Go to most recent revision | Blame | Last modification | View Log | RSS feed
--
-- Selected TOC Entries:
--
\connect - andreas
--
-- TOC Entry ID 1 (OID 0)
--
-- Name: pm Type: DATABASE Owner: andreas
--
CREATE DATABASE "pm" WITH TEMPLATE = template0 ENCODING = 0;
\connect pm andreas
\connect - wwwrun
--
-- TOC Entry ID 2 (OID 157123)
--
-- Name: key_role Type: TABLE Owner: wwwrun
--
CREATE TABLE "key_role" (
"kr_num" integer NOT NULL,
"kr_role" character varying(50),
Constraint "key_role_pkey" Primary Key ("kr_num")
);
--
-- TOC Entry ID 3 (OID 157123)
--
-- Name: key_role Type: ACL Owner:
--
REVOKE ALL on "key_role" from PUBLIC;
GRANT ALL on "key_role" to "andreas";
GRANT ALL on "key_role" to "wwwrun";
--
-- TOC Entry ID 4 (OID 157126)
--
-- Name: key_land Type: TABLE Owner: wwwrun
--
CREATE TABLE "key_land" (
"kl_num" integer NOT NULL,
"kl_land" character varying(50),
Constraint "key_land_pkey" Primary Key ("kl_num")
);
--
-- TOC Entry ID 5 (OID 157126)
--
-- Name: key_land Type: ACL Owner:
--
REVOKE ALL on "key_land" from PUBLIC;
GRANT ALL on "key_land" to "andreas";
GRANT ALL on "key_land" to "wwwrun";
--
-- TOC Entry ID 6 (OID 157129)
--
-- Name: key_abt Type: TABLE Owner: wwwrun
--
CREATE TABLE "key_abt" (
"ka_num" integer NOT NULL,
"ka_abt" character varying(50),
Constraint "key_abt_pkey" Primary Key ("ka_num")
);
--
-- TOC Entry ID 7 (OID 157129)
--
-- Name: key_abt Type: ACL Owner:
--
REVOKE ALL on "key_abt" from PUBLIC;
GRANT ALL on "key_abt" to "andreas";
GRANT ALL on "key_abt" to "wwwrun";
--
-- TOC Entry ID 8 (OID 157132)
--
-- Name: key_sgf Type: TABLE Owner: wwwrun
--
CREATE TABLE "key_sgf" (
"ks_num" integer NOT NULL,
"ks_sgf" character varying(20),
Constraint "key_sgf_pkey" Primary Key ("ks_num")
);
--
-- TOC Entry ID 9 (OID 157132)
--
-- Name: key_sgf Type: ACL Owner:
--
REVOKE ALL on "key_sgf" from PUBLIC;
GRANT ALL on "key_sgf" to "andreas";
GRANT ALL on "key_sgf" to "wwwrun";
--
-- TOC Entry ID 10 (OID 157135)
--
-- Name: key_tmgroup Type: TABLE Owner: wwwrun
--
CREATE TABLE "key_tmgroup" (
"kt_num" integer NOT NULL,
"kt_tm" character varying(50),
Constraint "key_tmgroup_pkey" Primary Key ("kt_num")
);
--
-- TOC Entry ID 11 (OID 157135)
--
-- Name: key_tmgroup Type: ACL Owner:
--
REVOKE ALL on "key_tmgroup" from PUBLIC;
GRANT ALL on "key_tmgroup" to "andreas";
GRANT ALL on "key_tmgroup" to "wwwrun";
--
-- TOC Entry ID 12 (OID 157138)
--
-- Name: counter Type: TABLE Owner: wwwrun
--
CREATE TABLE "counter" (
"co_mitarbeiter" integer,
"co_plan" integer,
"co_task" integer,
"co_wdone" integer,
"co_allocation" integer
);
--
-- TOC Entry ID 13 (OID 157138)
--
-- Name: counter Type: ACL Owner:
--
REVOKE ALL on "counter" from PUBLIC;
GRANT ALL on "counter" to "andreas";
GRANT ALL on "counter" to "wwwrun";
--
-- TOC Entry ID 14 (OID 157140)
--
-- Name: mitarbeiter Type: TABLE Owner: wwwrun
--
CREATE TABLE "mitarbeiter" (
"mi_num" integer NOT NULL,
"mi_vname" character varying(50) NOT NULL,
"mi_nname" character varying(50) NOT NULL,
"mi_land" integer,
"mi_abt" integer,
"mi_tel" character varying(50),
"mi_mail" character varying(80),
"mi_userid" character varying(16),
"mi_passwd" character varying(50),
"mi_rstufe" smallint,
"mi_hacker" smallint,
Constraint "mitarbeiter_pkey" Primary Key ("mi_num")
);
--
-- TOC Entry ID 15 (OID 157140)
--
-- Name: mitarbeiter Type: ACL Owner:
--
REVOKE ALL on "mitarbeiter" from PUBLIC;
GRANT ALL on "mitarbeiter" to "andreas";
GRANT ALL on "mitarbeiter" to "wwwrun";
--
-- TOC Entry ID 16 (OID 157157)
--
-- Name: project Type: TABLE Owner: wwwrun
--
CREATE TABLE "project" (
"pr_num" integer NOT NULL,
"pr_name" character varying(100) NOT NULL,
"pr_pl" integer NOT NULL,
"pr_plav" integer,
"pr_sgf" integer,
"pr_tmgroup" integer,
"pr_status" integer,
Constraint "project_pkey" Primary Key ("pr_num")
);
--
-- TOC Entry ID 17 (OID 157157)
--
-- Name: project Type: ACL Owner:
--
REVOKE ALL on "project" from PUBLIC;
GRANT ALL on "project" to "andreas";
GRANT ALL on "project" to "wwwrun";
--
-- TOC Entry ID 18 (OID 157179)
--
-- Name: plan Type: TABLE Owner: wwwrun
--
CREATE TABLE "plan" (
"pl_num" integer NOT NULL,
"pl_lfd" integer NOT NULL,
"pl_prnum" integer,
"pl_status" smallint,
Constraint "plan_pkey" Primary Key ("pl_num")
);
--
-- TOC Entry ID 19 (OID 157179)
--
-- Name: plan Type: ACL Owner:
--
REVOKE ALL on "plan" from PUBLIC;
GRANT ALL on "plan" to "andreas";
GRANT ALL on "plan" to "wwwrun";
--
-- TOC Entry ID 20 (OID 157188)
--
-- Name: task Type: TABLE Owner: wwwrun
--
CREATE TABLE "task" (
"ta_num" integer NOT NULL,
"ta_plnum" integer NOT NULL,
"ta_id" smallint NOT NULL,
"ta_depend" smallint,
"ta_deptype" smallint,
"ta_name" character varying(50) NOT NULL,
"ta_color" integer,
"ta_shape" character varying(40),
"ta_meeting" smallint,
"ta_start" integer,
"ta_duration" smallint,
"ta_complete" smallint,
"ta_fixed_start" smallint,
"ta_priority" smallint,
"ta_level" smallint,
"ta_notiz" character varying(4096),
"ta_phase" integer,
Constraint "task_pkey" Primary Key ("ta_num")
);
--
-- TOC Entry ID 21 (OID 157188)
--
-- Name: task Type: ACL Owner:
--
REVOKE ALL on "task" from PUBLIC;
GRANT ALL on "task" to "andreas";
GRANT ALL on "task" to "wwwrun";
--
-- TOC Entry ID 22 (OID 157201)
--
-- Name: allocation Type: TABLE Owner: wwwrun
--
CREATE TABLE "allocation" (
"al_num" integer NOT NULL,
"al_task" integer,
"al_ressource" integer,
"al_hours" double precision,
"al_role" integer,
"al_phase" smallint,
"al_pstart" integer,
"al_pduration" smallint,
Constraint "allocation_pkey" Primary Key ("al_num")
);
--
-- TOC Entry ID 23 (OID 157201)
--
-- Name: allocation Type: ACL Owner:
--
REVOKE ALL on "allocation" from PUBLIC;
GRANT ALL on "allocation" to "andreas";
GRANT ALL on "allocation" to "wwwrun";
--
-- TOC Entry ID 24 (OID 157223)
--
-- Name: wdone Type: TABLE Owner: wwwrun
--
CREATE TABLE "wdone" (
"wd_num" integer NOT NULL,
"wd_prnum" integer,
"wd_minum" integer,
"wd_datum" integer,
"wd_hours" double precision,
"wd_task" integer,
"wd_rk" smallint,
"wd_phase" smallint,
"wd_edit" boolean,
"wd_periode" integer,
Constraint "wdone_pkey" Primary Key ("wd_num")
);
--
-- TOC Entry ID 25 (OID 157223)
--
-- Name: wdone Type: ACL Owner:
--
REVOKE ALL on "wdone" from PUBLIC;
GRANT ALL on "wdone" to "andreas";
GRANT ALL on "wdone" to "wwwrun";
\connect - andreas
--
-- TOC Entry ID 26 (OID 157245)
--
-- Name: pga_graphs Type: TABLE Owner: andreas
--
CREATE TABLE "pga_graphs" (
"graphname" character varying(64) NOT NULL,
"graphsource" text,
"graphcode" text,
Constraint "pga_graphs_pkey" Primary Key ("graphname")
);
--
-- TOC Entry ID 27 (OID 157245)
--
-- Name: pga_graphs Type: ACL Owner:
--
REVOKE ALL on "pga_graphs" from PUBLIC;
GRANT ALL on "pga_graphs" to "andreas";
GRANT ALL on "pga_graphs" to "wwwrun";
--
-- TOC Entry ID 28 (OID 157251)
--
-- Name: pga_layout Type: TABLE Owner: andreas
--
CREATE TABLE "pga_layout" (
"tablename" character varying(64) NOT NULL,
"nrcols" smallint,
"colnames" text,
"colwidth" text,
Constraint "pga_layout_pkey" Primary Key ("tablename")
);
--
-- TOC Entry ID 29 (OID 157251)
--
-- Name: pga_layout Type: ACL Owner:
--
REVOKE ALL on "pga_layout" from PUBLIC;
GRANT ALL on "pga_layout" to "andreas";
GRANT ALL on "pga_layout" to "wwwrun";
--
-- TOC Entry ID 30 (OID 157257)
--
-- Name: pga_images Type: TABLE Owner: andreas
--
CREATE TABLE "pga_images" (
"imagename" character varying(64) NOT NULL,
"imagesource" text,
Constraint "pga_images_pkey" Primary Key ("imagename")
);
--
-- TOC Entry ID 31 (OID 157257)
--
-- Name: pga_images Type: ACL Owner:
--
REVOKE ALL on "pga_images" from PUBLIC;
GRANT ALL on "pga_images" to "andreas";
GRANT ALL on "pga_images" to "wwwrun";
--
-- TOC Entry ID 32 (OID 157263)
--
-- Name: pga_queries Type: TABLE Owner: andreas
--
CREATE TABLE "pga_queries" (
"queryname" character varying(64) NOT NULL,
"querytype" character(1),
"querycommand" text,
"querytables" text,
"querylinks" text,
"queryresults" text,
"querycomments" text,
Constraint "pga_queries_pkey" Primary Key ("queryname")
);
--
-- TOC Entry ID 33 (OID 157263)
--
-- Name: pga_queries Type: ACL Owner:
--
REVOKE ALL on "pga_queries" from PUBLIC;
GRANT ALL on "pga_queries" to "andreas";
GRANT ALL on "pga_queries" to "wwwrun";
--
-- TOC Entry ID 34 (OID 157269)
--
-- Name: pga_reports Type: TABLE Owner: andreas
--
CREATE TABLE "pga_reports" (
"reportname" character varying(64) NOT NULL,
"reportsource" text,
"reportbody" text,
"reportprocs" text,
"reportoptions" text,
Constraint "pga_reports_pkey" Primary Key ("reportname")
);
--
-- TOC Entry ID 35 (OID 157269)
--
-- Name: pga_reports Type: ACL Owner:
--
REVOKE ALL on "pga_reports" from PUBLIC;
GRANT ALL on "pga_reports" to "andreas";
GRANT ALL on "pga_reports" to "wwwrun";
--
-- TOC Entry ID 36 (OID 157275)
--
-- Name: pga_forms Type: TABLE Owner: andreas
--
CREATE TABLE "pga_forms" (
"formname" character varying(64) NOT NULL,
"formsource" text,
Constraint "pga_forms_pkey" Primary Key ("formname")
);
--
-- TOC Entry ID 37 (OID 157275)
--
-- Name: pga_forms Type: ACL Owner:
--
REVOKE ALL on "pga_forms" from PUBLIC;
GRANT ALL on "pga_forms" to "andreas";
GRANT ALL on "pga_forms" to "wwwrun";
--
-- TOC Entry ID 38 (OID 157281)
--
-- Name: pga_diagrams Type: TABLE Owner: andreas
--
CREATE TABLE "pga_diagrams" (
"diagramname" character varying(64) NOT NULL,
"diagramtables" text,
"diagramlinks" text,
Constraint "pga_diagrams_pkey" Primary Key ("diagramname")
);
--
-- TOC Entry ID 39 (OID 157281)
--
-- Name: pga_diagrams Type: ACL Owner:
--
REVOKE ALL on "pga_diagrams" from PUBLIC;
GRANT ALL on "pga_diagrams" to "andreas";
GRANT ALL on "pga_diagrams" to "wwwrun";
--
-- TOC Entry ID 40 (OID 157287)
--
-- Name: pga_scripts Type: TABLE Owner: andreas
--
CREATE TABLE "pga_scripts" (
"scriptname" character varying(64) NOT NULL,
"scriptsource" text,
Constraint "pga_scripts_pkey" Primary Key ("scriptname")
);
--
-- TOC Entry ID 41 (OID 157287)
--
-- Name: pga_scripts Type: ACL Owner:
--
REVOKE ALL on "pga_scripts" from PUBLIC;
GRANT ALL on "pga_scripts" to "andreas";
GRANT ALL on "pga_scripts" to "wwwrun";
\connect - wwwrun
--
-- TOC Entry ID 42 (OID 157338)
--
-- Name: key_status Type: TABLE Owner: wwwrun
--
CREATE TABLE "key_status" (
"ks_num" integer NOT NULL,
"ks_status" character varying(10) NOT NULL,
Constraint "key_status_pkey" Primary Key ("ks_num")
);
--
-- TOC Entry ID 43 (OID 157338)
--
-- Name: key_status Type: ACL Owner:
--
REVOKE ALL on "key_status" from PUBLIC;
GRANT ALL on "key_status" to "andreas";
GRANT ALL on "key_status" to "wwwrun";
--
-- TOC Entry ID 44 (OID 157341)
--
-- Name: ptemp Type: TABLE Owner: wwwrun
--
CREATE TABLE "ptemp" (
"pt_num" integer NOT NULL,
"pt_tnum" smallint NOT NULL,
"pt_lfd" smallint NOT NULL,
"pt_level" smallint,
"pt_name" character varying(50),
"pt_color" integer,
"pt_meeting" boolean,
"pt_phase" integer,
Constraint "ptemp_pkey" Primary Key ("pt_num")
);
--
-- TOC Entry ID 45 (OID 157341)
--
-- Name: ptemp Type: ACL Owner:
--
REVOKE ALL on "ptemp" from PUBLIC;
GRANT ALL on "ptemp" to "andreas";
GRANT ALL on "ptemp" to "wwwrun";
--
-- TOC Entry ID 46 (OID 165403)
--
-- Name: key_phase Type: TABLE Owner: wwwrun
--
CREATE TABLE "key_phase" (
"kp_num" integer NOT NULL,
"kp_phase" character varying(60) NOT NULL,
Constraint "key_phase_pkey" Primary Key ("kp_num")
);
--
-- TOC Entry ID 47 (OID 173690)
--
-- Name: allocmi Type: VIEW Owner: wwwrun
--
CREATE VIEW "allocmi" as SELECT allocation.al_num AS am_num, allocation.al_task AS am_task, allocation.al_ressource AS am_ressource, allocation.al_hours AS am_hours, allocation.al_phase AS am_phase, key_role.kr_role AS am_role, key_role.kr_num AS am_krnum, mitarbeiter.mi_vname AS am_vname, mitarbeiter.mi_nname AS am_nname, allocation.al_pstart AS am_pstart, allocation.al_pduration AS am_pduration FROM allocation, mitarbeiter, key_role WHERE ((mitarbeiter.mi_num = allocation.al_ressource) AND (key_role.kr_num = allocation.al_role));
--
-- TOC Entry ID 48 (OID 190526)
--
-- Name: tempidx Type: TABLE Owner: wwwrun
--
CREATE TABLE "tempidx" (
"te_num" integer NOT NULL,
"te_name" character varying(60) NOT NULL,
"te_zweck" character varying(2048),
Constraint "tempidx_pkey" Primary Key ("te_num")
);
--
-- Data for TOC Entry ID 57 (OID 157123)
--
-- Name: key_role Type: TABLE DATA Owner: wwwrun
--
COPY "key_role" FROM stdin;
1 Projektleiter
3 Mitarbeiter
4 Programmierer
5 Themenmanager
6 Ressourcenmanager
7 Geschäftsführung
2 PLA-V
\.
--
-- Data for TOC Entry ID 58 (OID 157126)
--
-- Name: key_land Type: TABLE DATA Owner: wwwrun
--
COPY "key_land" FROM stdin;
2 RLB
3 RZB
4 RI
5 Extern
6 RI-Fachlich
1 RO+<big>e</big>
\.
--
-- Data for TOC Entry ID 59 (OID 157129)
--
-- Name: key_abt Type: TABLE DATA Owner: wwwrun
--
COPY "key_abt" FROM stdin;
2 Meldewesen
1 Finanzierung
3 Vertrieb
4 Programmierung
\.
--
-- Data for TOC Entry ID 60 (OID 157132)
--
-- Name: key_sgf Type: TABLE DATA Owner: wwwrun
--
COPY "key_sgf" FROM stdin;
1 PK
2 PK+
3 FK
4 FB
\.
--
-- Data for TOC Entry ID 61 (OID 157135)
--
-- Name: key_tmgroup Type: TABLE DATA Owner: wwwrun
--
COPY "key_tmgroup" FROM stdin;
1 Finanzierung
3 Vertrieb
2 BW Controlling
4 Büroorganisation
5 Veranlagung
6 Zahlungsverkehr
7 Kernbanken
\.
--
-- Data for TOC Entry ID 62 (OID 157138)
--
-- Name: counter Type: TABLE DATA Owner: wwwrun
--
COPY "counter" FROM stdin;
35 29 336 171 843
\.
--
-- Data for TOC Entry ID 63 (OID 157140)
--
-- Name: mitarbeiter Type: TABLE DATA Owner: wwwrun
--
COPY "mitarbeiter" FROM stdin;
1 Andreas Theofilu 1 1 5387 andreas.theofilu@roe.raiffeisen.at wrothe 6fab60e33f7e264df872a70fc89572d5 1 0
9 Linda Windisch 1 1 5916 linda.windisch@roe.raiffeisen.at wrowil be2332e4f2e07062832164eb5bc7a78f 2 0
13 Günther Glassl 1 1 5917 wrogla be2332e4f2e07062832164eb5bc7a78f 2 0
14 Markus Strobl 1 1 5302 wrostr be2332e4f2e07062832164eb5bc7a78f 4 0
8 Josef Stern 6 2 wrnstj ea110dfdeb4b966c81f7d786df7b1192 5 0
15 Robert Kollmann 1 1 5382 robert.kollmann@roe.raiffeisen.at wrokol 2 0
6 Christian Gerl 1 1 5346 christian.gerl@roe.raiffeisen.at wrogch 2 0
5 Klaus Schilhan 1 1 5375 klaus.schilhan@roe.raiffeisen.at wrosck 2 0
16 N N 1 2 nn 5 0
2 Herbert Papai 1 2 5382 herbert.papai@roe.raiffeisen.at wropah be2332e4f2e07062832164eb5bc7a78f 2 0
10 Franz Heneis 2 1 franz be2332e4f2e07062832164eb5bc7a78f 3 0
4 Manfred Krankenedl 2 2 manfred be2332e4f2e07062832164eb5bc7a78f 3 0
11 Wolfgang Wieshofer 3 2 wolfgang be2332e4f2e07062832164eb5bc7a78f 3 0
12 Heinz Gromes 2 2 heinz be2332e4f2e07062832164eb5bc7a78f 3 0
17 Alexander Dorfmann 5 2 wroa20 be2332e4f2e07062832164eb5bc7a78f 2 0
18 Gerald Vukovich 1 1 wrovuk be2332e4f2e07062832164eb5bc7a78f 3 0
19 Josef Spiess 3 1 josef 5 0
22 Christine Hagen 2 1 nn2 5 0
24 Herbert Strallhofer 2 1 nn4 5 0
25 Sabine Benigni 3 1 nn5 5 0
26 Johannes Schuster 3 1 nn6 5 0
28 ? Sailer 2 1 nn8 5 0
29 Martin Zöch 2 1 nn9 5 0
30 Fachlich RACON 6 1 nn10 5 0
31 Entwicklung RACON 4 1 nn11 5 0
23 Heinz Donat 2 1 nn3 5 0
21 Gert Fenkart 2 1 nn1 5 0
20 Gerhard Grünwald 2 1 unknown 5 0
27 Daniela Marvan 2 1 nn7 5 0
3 Thomas Kainz 1 1 thomas.kainz@roe.raiffeisen.at wrokth be2332e4f2e07062832164eb5bc7a78f 3 0
32 Viktor Kotal 1 3 viktor.kotal@roe.raiffeisen.at wrokot be2332e4f2e07062832164eb5bc7a78f 6 0
7 Christian Urich 5 1 5316 christian.urich@roe.raiffeisen.at wroa10 be2332e4f2e07062832164eb5bc7a78f 2 0
33 Franz Zdichynec 3 2 nn20 5 0
34 Manfred Holzer 2 2 nn21 5 0
35 Tanja Stöcker 1 1 5317 tanja.stoecker@roe.raiffeisen.at wrosto be2332e4f2e07062832164eb5bc7a78f 2 0
\.
--
-- Data for TOC Entry ID 64 (OID 157157)
--
-- Name: project Type: TABLE DATA Owner: wwwrun
--
COPY "project" FROM stdin;
11230 Sicherheitenbewertung 7 5 1 1 3
10388 Kreditrisikomanagement 6 5 3 2 3
13130 Meldewesen Neu 2 5 3 2 5
13510 Beteiligungen & Anteilsrechte 1 5 3 2 3
90757 TM BW Controlling 5 5 4 2 6
13200 Zahlungsbilanz Neu 17 5 3 2 1
999999 Testprojekt 1 5 4 2 1
13860 Teil B1 Restlaufzeiten und Risikostatistik 17 5 4 2 2
12661 GKE Globalrahmen 17 5 3 2 3
13980 Kompensandokonten 17 5 3 2 6
13870 Auslistung Kontrolldatei GI 0536 17 5 4 2 6
13880 Elektronische Rückmeldung GKE 17 5 4 2 1
13890 Großveranlagungen § 27 BWG 17 5 4 2 6
13900 Automatische Bewertungsbuchungen 17 5 4 2 6
13910 Testumgebung Meldewesen und Bilanz 17 5 4 2 6
13920 Stammdaten - NEU 17 5 4 2 6
11750 Design der Kreditprozesse 35 5 4 1 3
14060 GA-Statistikblatt RK0049 1 5 4 2 2
\.
--
-- Data for TOC Entry ID 65 (OID 157179)
--
-- Name: plan Type: TABLE DATA Owner: wwwrun
--
COPY "plan" FROM stdin;
6 1 12661 1
10 1 10388 1
2 1 13510 2
13 1 90757 2
11 1 13200 5
12 2 13200 2
15 1 999999 1
17 1 11230 1
14 1 13860 2
29 2 11750 1
26 1 14060 2
\.
--
-- Data for TOC Entry ID 66 (OID 157188)
--
-- Name: task Type: TABLE DATA Owner: wwwrun
--
COPY "task" FROM stdin;
9 2 2 0 2 Grunddaten fixieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083362400 40 100 0 1 2 1 1
88 2 3 0 2 Grunddaten fixieren Mai 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083362400 30 100 0 1 3 1
89 2 4 0 2 Grunddaten fixieren Juni 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 15 100 0 1 3 1
10 2 5 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 13 100 0 1 2 1
12 2 6 0 2 Angebot freigegeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1087250400 1 0 0 1 2 1
24 2 7 0 2 Organisationsentwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088632800 1 0 0 1 1 2
25 2 8 0 2 Prozesse Modellieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088632800 30 0 0 1 2 2
26 2 9 0 2 Sollkonzept freigegeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1091138400 1 0 0 1 2 2
27 2 10 0 2 Organisatorische Maßnahmen definieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088632800 30 0 0 1 2 2
28 2 11 0 2 Organisationskonzept freigegeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1091138400 1 0 0 1 2 2
29 2 12 0 2 Systementwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 1 0 0 1 1 3
30 2 13 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 90 0 0 1 2 3
31 2 14 0 2 Erstellen Interimslösung Excel 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1091311200 30 100 0 2 2 Durch Hr. Krankenedl erstellt.\r\nEr bekommt dafür 6 PT extra (Projektänderung!)\r\nÄnderung durch PLA am 20.08.2004 beschlossen. 3
32 2 15 0 2 IT-Lösung beauftragen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1087336800 14 0 0 1 2 3
33 2 16 0 2 IT-Lösung beauftragt 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1088546400 1 0 0 1 2 3
90 2 17 0 2 IT-Lösung abnehmen (Excel) 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088546400 1 100 0 1 2 3
91 2 18 0 2 IT-Lösung Abnehmen Juli (Excel) 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088632800 5 100 0 1 2 3
92 2 19 0 2 IT-Lösung Abnehmen August (Excel) 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1091311200 10 100 0 1 2 3
100 12 4 0 2 Rahmenangebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1087336800 1 0 0 1 1 1
101 12 5 0 2 Definition Inhalte Rahmenangebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1087336800 93 0 0 1 2 1
102 12 6 0 2 Angebot freigegeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1097877600 1 0 0 1 2 1
103 12 7 0 2 Systementwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1091224800 1 0 0 1 1 3
104 12 8 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1091224800 92 0 0 1 2 3
105 12 9 0 2 Fachkonzept RI/RACON übergeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1099000800 1 0 0 1 2 3
106 12 10 0 2 Softwarerealisierung gesamt 8421631 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1099263600 211 0 0 1 2 3
107 12 11 0 2 Testumgebung fertiggestellt 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1112306400 1 0 0 1 2 3
108 12 12 0 2 Abnahmetest MONSTAT 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1112306400 84 0 0 1 2 3
109 12 13 0 2 Abnahmetest MONSTAT freigegeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1119823200 1 0 0 1 2 3
110 12 14 0 2 Abnahmetest 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 183 0 0 1 2 3
111 12 15 0 2 Abnahmetest freigegeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1135983600 1 0 0 1 2 3
112 12 16 0 2 Testdaten an ÖNB / nach Freigabe Teilthema 32960 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1120168800 153 0 0 1 2 3
113 12 17 0 2 Projektende 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1135983600 1 0 0 1 2 3
127 13 1 0 2 Themenmanagement 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 1 0 0 1 1 0
97 12 1 0 2 Themenaufbereitung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 1 0 0 1 1 0
99 12 3 0 2 Analyse beendet 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1087250400 1 0 0 1 2 0
98 12 2 0 2 Analyse 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 48 0 0 1 2 0
132 15 1 0 2 Angebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 1 0 0 1 1 1
133 15 2 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 19 0 0 1 2 1
134 15 3 2 2 Angebot erstellt 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1095717600 1 0 0 1 2 1
135 15 4 0 2 Organisatorissche Massnahmen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1095631200 1 0 0 1 1 2
136 15 5 0 2 Organisationskonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1095631200 72 0 0 1 2 2
137 15 6 5 2 Organisationskonzept fertig 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1101855600 1 0 0 1 2 2
138 15 7 0 2 Systementwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1096840800 1 0 0 1 1 3
139 15 8 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1096840800 71 0 0 1 2 3
140 15 9 0 2 Fachkonzept fertig 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1102978800 1 0 0 1 2 3
141 15 10 0 2 Rollout 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1099263600 1 0 0 1 1 4
142 15 11 0 2 Rolloutplan erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1099263600 70 0 0 1 2 4
143 15 12 0 2 Rolloutkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1102892400 28 0 0 1 2 4
144 15 13 0 2 Rolloutkonzept fertig 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1105398000 1 0 0 1 2 4
145 15 14 0 2 Phasenübergreifende Projektaktivitäten 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 1 0 0 1 1 6
146 15 15 0 2 Berichterstattung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 181 0 0 1 2 6
148 6 1 0 2 Angebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1085695200 1 0 0 1 1 1
149 6 2 0 2 Grunddaten fixieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1085695200 4 0 0 1 2 1
150 6 3 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 1 0 0 1 2 1
151 6 4 0 2 Angebot freigegeben 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1086213600 1 0 0 1 2 1
152 6 5 0 2 Systementwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086559200 1 0 0 1 1 3
153 6 6 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086559200 2 0 0 1 2 3
154 6 7 0 2 Entwicklung beauftragt 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1086904800 1 0 0 1 2 3
155 6 8 0 2 IT-Lösung abnehmen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1091397600 18 0 0 1 2 3
156 6 9 0 2 Software abgenommen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1092952800 1 0 0 1 2 3
157 6 10 0 2 Zentrale Rolloutplanung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1087768800 67 0 0 1 1 4
158 6 11 0 2 Rolloutkonzepte erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1087768800 4 0 0 1 2 4
159 6 12 0 2 Einsatzrelevante Dokumente erstellt 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1088114400 1 0 0 1 2 4
160 6 13 0 2 Feldeinsatz freigegeben 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1093557600 1 0 0 1 2 4
161 6 14 0 2 Dezentraler Rollout 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1095372000 1 0 0 1 1 5
162 6 15 0 2 Rollout abgeschlossen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1095372000 1 0 0 1 2 5
163 6 16 0 2 Phasenübergreifende Projektaktivitäten 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1085695200 125 0 0 1 1 6
164 6 17 0 2 Laufende Tätigkeiten des Projektleiters 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1085695200 112 0 0 1 2 6
165 6 18 0 2 Berichterstattung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1085695200 112 0 0 1 2 6
166 6 19 0 2 Software Entwicklung / Lizenz 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 60 0 0 1 2 6
167 6 20 0 2 RACON-Entwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 60 0 0 1 3 6
168 6 21 0 2 Projekt abgeschlossen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1096495200 1 0 0 1 2 6
61 11 9 0 2 Rahmenangebot 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1087164000 1 0 0 1 2 0
59 11 8 0 2 Grenzüb. Finanztr 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 60 0 0 1 3 0
58 11 7 0 2 Grenzüb. Liegensch.- u. Vermögensübertr. 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 60 0 0 1 3 0
57 11 6 0 2 Sonstige Investitionen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 18 0 0 1 3 0
56 11 5 0 2 Direktinvestitionen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 18 0 0 1 3 0
55 11 4 0 2 Portfolioinvestitionen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 18 0 0 1 3 0
54 11 3 0 2 Analyse Teilthemen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 60 0 0 1 2 0
60 11 2 0 2 Themenaufbereitung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 476 0 0 1 1 0
64 11 12 0 2 Angebot fertig 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1090792800 1 0 0 1 2 1
63 11 11 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088978400 19 0 0 1 2 1
62 11 10 0 2 Angebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088978400 21 0 0 1 1 1
67 11 15 0 2 Qualitätssicherung Sollprozess 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1096236000 12 0 0 1 2 2
66 11 14 0 2 Organisatorische Massnahmen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 26 0 0 1 2 2
68 11 13 0 2 Orgkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094767200 35 0 0 1 1 2
69 11 16 0 2 Orgkonzept freigeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1097445600 1 0 0 1 2 2
70 11 17 0 2 Fachkonzepte erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083535200 281 0 0 1 1 3
71 11 18 0 2 Portfolioinvestitionen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1096840800 127 0 0 1 2 3
74 11 19 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1096840800 78 0 0 1 2 Wertpapiere und Depotmeldungen\r\nRepo- und Wertpapierleihegeschäfte\r\nStammdaten interner Wertpapierkennummern\r\nFinanzderivate\r\nRepos 3
75 11 20 0 2 Fachkonzept freigeben 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1105311600 1 0 0 1 3 3
76 11 21 0 2 Testplan erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1105916400 22 0 0 1 3 3
78 11 23 0 2 Testkonzept fertig 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1107730800 1 0 0 1 4 3
77 11 22 0 2 Testkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1105916400 19 0 0 1 4 3
79 11 24 0 2 Direktinvestitionen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 57 0 0 1 2 3
80 11 25 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1125957600 26 0 0 1 3 Unterjährige und Jährliche Meldungen 3
81 11 26 0 2 Fachkonzept freigeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1096840800 1 0 0 1 3 3
82 11 27 0 2 Testplan erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097445600 22 0 0 1 3 3
83 11 28 0 2 Testkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097445600 19 0 0 1 4 3
84 11 29 0 2 Testkonzept fertig 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1099263600 1 0 0 1 4 3
147 15 17 0 2 Sitzungsmanagement 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 181 0 0 1 2 6
169 15 19 0 2 RACON Softwareentwicklung 16744448 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1099263600 74 0 0 1 3 6
171 15 18 0 2 Softwareentwicklung 16744448 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1099263600 1 0 0 1 2 6
172 15 20 0 2 Software fertig 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1105916400 1 0 0 1 3 6
115 10 2 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088632800 183 100 0 1 2 1
114 10 1 0 2 Angebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088632800 183 100 0 1 1 1
173 10 4 0 2 Organisationsentwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1075590000 303 0 0 1 1 2
174 10 5 0 2 Organisationskonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1075590000 303 0 0 1 2 0
176 10 19 0 2 Sitzungsmanagement 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1072911600 454 0 0 1 2 6
175 10 18 0 2 Phasenübergreifende Projektaktivitäten 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1072911600 454 0 0 1 1 6
124 10 15 0 2 Rolloutkonzept 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1080770400 363 0 0 1 2 4
131 10 14 0 2 Zentrale Rolloutplanung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 30 0 0 1 1 4
123 10 13 0 2 Testkonzept erstellt 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1096581600 1 0 0 1 3 3
122 10 12 0 2 Testkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 26 0 0 1 3 3
121 10 11 0 2 Fachliche Geschäftsfälle 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 26 0 0 1 3 3
126 10 17 0 2 Rolloutkonzept erstellt 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1112047200 1 0 0 1 2 4
118 10 7 0 2 Fachkonzeption 0 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1072911600 424 0 0 1 2 3
117 10 6 0 2 Systementwicklung 0 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1072911600 424 0 0 1 1 3
128 13 2 0 2 Themenaufbereitung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 1582 0 0 1 2 0
181 17 2 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1072911600 30 0 0 1 2 1
180 17 1 0 2 Angebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1072911600 30 0 0 1 1 1
182 17 3 0 2 Organisationsentwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1075590000 40 0 0 1 1 2
183 17 4 0 2 Organisationskonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1075590000 40 0 0 1 2 2
185 17 6 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1078095600 120 0 0 1 2 3
186 17 7 0 2 Testkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 150 0 0 1 2 3
184 17 5 0 2 Systementwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1078095600 242 0 0 1 1 3
49 2 39 0 2 Sitzungsmanagement 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083362400 364 0 0 1 2 6
48 2 38 0 2 Berichterstattung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083362400 364 0 0 1 2 6
47 2 37 0 2 Laufende Aktivitäten des Projektleiters 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083362400 364 0 0 1 2 6
46 2 36 0 2 Themenmanagement 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083362400 364 0 0 1 2 6
45 2 35 0 2 Projekt gestartet 65280 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1083362400 1 0 0 1 2 6
44 2 34 0 2 Phasenübergreifende Projektaktivitäten 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083362400 1 0 0 1 1 6
43 2 33 0 2 Rollout abgeschlossen 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1110495600 1 0 0 1 2 5
42 2 32 0 2 Rollout durchführen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1096581600 162 0 0 1 2 5
41 2 31 0 2 Dezentralen Rollout planen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1092607200 184 0 0 1 2 5
40 2 30 0 2 Dezentraler Rollout 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1092607200 1 0 0 1 1 5
39 2 29 0 2 Einsatzrelevante Dokumente erstellt 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1108508400 1 0 0 1 2 4
38 2 25 0 2 Rolloutkonzepte erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1092607200 184 0 0 1 2 4
36 2 24 0 2 Zentrale Rolloutplanung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1092607200 1 0 0 1 1 4
35 2 23 0 2 IT-Lösung abgenommen 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1108335600 1 0 0 1 2 3
34 2 21 0 2 IT-Lösung abnehmen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1105916400 25 0 0 1 2 3
1 2 1 0 2 Angebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083362400 1 0 0 1 1 1
187 2 20 0 2 IT-Lösung programmieren 4227200 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088632800 226 0 0 1 2 3
94 2 26 0 2 Rolloutkonzept 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1091311200 195 0 0 1 3 4
129 14 1 0 2 Angebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 35 100 0 1 1 1
188 14 3 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 35 0 0 1 2 1
189 14 4 0 2 Angebot freigegeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1097445600 1 0 0 1 2 1
190 14 5 0 2 Systementwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097445600 20 0 0 1 1 3
191 14 6 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097445600 19 0 0 1 2 3
192 14 7 0 2 IT-Lösung beauftragen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1098309600 10 0 0 1 2 3
197 14 13 0 2 Berichterstattung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 55 0 0 1 2 6
196 14 12 0 2 Laufende Aktivitäten des Projektleiters 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 55 0 0 1 2 6
194 14 10 0 2 Phasenübergreifende Projektaktivitäten 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 55 0 0 1 1 6
193 14 9 0 2 Entwicklung beauftragt 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1099173600 1 0 0 1 2 3
198 14 8 0 2 IT-Lösung abnehmen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1098050400 11 0 0 1 2 3
199 14 14 0 2 Sitzungsmanagement 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 55 0 0 1 2 6
130 14 2 0 2 Grunddaten fixieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 24 0 0 1 2 1
177 10 10 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1072911600 424 0 0 1 3 Theofilu: Monat 9 (September):\r\nErstellen des Schulungskonzepts einschließlich der Folien und einiger Beispielreports.\r\n\r\nSicherstellen das in Vlbg. die Systeme für den Test vorbereitet sind und am Testtag auch einsatzbereit.\r\n\r\nRückmeldung von Gerl abwarten.\r\n\r\nTestkonzept nach Anmerkungen von Hagen überarbeiten.\r\n 3
297 26 1 0 2 Angebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097704800 23 0 0 1 1 1
299 26 3 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1099263600 4 0 0 1 2 1
300 26 4 0 2 Angebot freigegeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1099868400 1 0 0 1 2 1
301 26 5 0 2 Systementwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1099868400 32 0 0 1 1 3
302 26 6 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1101078000 11 0 0 1 2 3
303 26 7 0 2 IT-Lösung beauftragen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1102287600 4 0 0 1 2 3
304 26 8 0 2 Entwicklung beauftragt 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1102633200 1 0 0 1 2 3
305 26 10 0 2 IT-Lösung abnehmen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1108940400 4 0 0 1 2 3
306 26 9 7 2 Entwicklung durchführen 4227200 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1102892400 74 0 0 1 2 3
307 26 11 10 2 Software abgenommen 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1109545200 1 0 0 1 2 3
308 26 12 0 2 Phasenübergreifende Projektaktivitäten 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097704800 197 0 0 1 1 6
309 26 13 0 2 Laufende Aktivitäten des Projektleiters 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097704800 197 0 0 1 2 6
310 26 14 0 2 Berichterstattung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097704800 197 0 0 1 2 6
311 26 15 0 2 Sitzungsmanagement 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097704800 197 0 0 1 2 6
298 26 2 0 2 Grunddaten fixieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097704800 1 100 0 1 2 1
312 26 16 0 2 Projekt abgeschlossen 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1114725600 1 0 0 1 2 6
318 29 1 0 2 Projektinitialisierung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097791200 1 0 0 1 1 0
330 29 5 0 2 Grunddaten fixieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097791200 1 0 0 1 1 1
335 29 19 0 2 Organisationskonzept freigegeben 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1098655200 1 0 0 1 1 2
323 29 18 0 2 Organisatorische Maßnahmen definieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1101769200 1 0 0 1 1 2
334 29 17 0 2 Sollkonzept freigegeben 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1098396000 1 0 0 1 1 2
322 29 16 0 2 Prozesse modellieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1100473200 1 0 0 1 1 2
333 29 15 0 2 Projekt Kick-Off durchführen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1098223200 1 0 0 1 1 1
321 29 14 0 2 Projektvertrag abschließen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1099173600 1 0 0 1 1 1
332 29 13 0 2 Angebot freigeben 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1097964000 1 0 0 1 1 1
320 29 9 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1098655200 1 0 0 1 1 1
\.
--
-- Data for TOC Entry ID 67 (OID 157201)
--
-- Name: allocation Type: TABLE DATA Owner: wwwrun
--
COPY "allocation" FROM stdin;
116 55 2 5 1 0 1080770400 30
117 55 2 5 1 0 1083362400 30
119 56 1 5 3 0 1080770400 30
120 56 1 10 3 0 1083362400 30
122 25 2 1 1 2 1088632800 30
123 25 1 3 3 2 1088632800 30
124 10 2 1 1 1 1086040800 30
125 89 12 2 3 1 1086040800 30
126 89 10 2 3 1 1086040800 30
127 89 4 2 3 1 1086040800 30
128 89 2 2 1 1 1086040800 30
129 89 8 2 3 1 1086040800 30
130 89 1 7 3 1 1086040800 30
131 89 11 2 3 1 1086040800 30
132 88 10 1 3 1 1083362400 30
133 88 4 1 3 1 1083362400 30
134 88 2 1 1 1 1083362400 30
135 88 8 1 3 1 1083362400 30
136 88 11 1 3 1 1083362400 30
137 27 12 0.5 3 2 1088632800 30
138 27 10 0.5 3 2 1088632800 30
139 27 4 0.5 3 2 1088632800 30
140 27 2 1 1 2 1088632800 30
141 27 1 3 3 2 1088632800 30
142 27 11 0.5 3 2 1088632800 30
143 30 12 0.5 3 3 1086040800 30
144 30 10 0.5 3 3 1086040800 30
145 30 4 0.5 3 3 1086040800 30
148 31 4 6 3 3 1091311200 30
151 90 8 1 3 3 1088546400 30
152 91 8 2 3 3 1088632800 30
153 92 12 1.5 3 3 1091311200 30
154 92 2 0.5 1 3 1091311200 30
155 92 1 0.5 3 3 1091311200 30
162 94 12 2 3 4 1091311200 30
179 58 5 0.5 2 0 1080770400 30
180 58 5 0.5 2 0 1083362400 30
181 58 5 0.5 2 0 1086040800 30
183 133 1 5 1 1 1093989600 30
187 136 1 3 1 2 1095631200 30
188 136 1 3 1 2 1096581600 30
189 136 1 4 1 2 1099263600 30
191 139 10 2 3 3 1096840800 30
192 139 10 2 3 3 1099263600 30
193 139 10 4 3 3 1101855600 30
194 139 4 2 3 3 1096840800 30
195 139 4 2 3 3 1099263600 30
196 139 4 4 3 3 1101855600 30
197 139 3 4 3 3 1096840800 30
198 139 3 4 3 3 1099263600 30
199 139 3 4 3 3 1101855600 30
200 139 8 1 3 3 1096840800 30
201 139 8 1 3 3 1099263600 30
202 139 8 1 3 3 1101855600 30
203 139 1 1 1 3 1096840800 30
204 139 1 1 1 3 1099263600 30
205 139 1 1 1 3 1101855600 30
206 139 11 1.5 3 3 1096840800 30
207 139 11 1.5 3 3 1099263600 30
208 139 11 2 3 3 1101855600 30
209 63 1 20 3 1 1088632800 30
214 122 1 1 3 3 1093989600 30
215 121 1 6 3 3 1093989600 30
218 136 5 0.5 2 2 1093989600 30
219 136 5 0.5 2 2 1096581600 30
220 136 5 0.5 2 2 1099263600 30
222 142 1 1 1 4 1104534000 30
228 143 3 2 3 4 1101855600 30
229 143 3 4 3 4 1104534000 30
231 146 1 0.5 1 6 1093989600 30
232 146 1 0.5 1 6 1096581600 30
233 146 1 0.5 1 6 1099263600 30
234 146 1 0.5 1 6 1101855600 30
235 146 1 0.5 1 6 1104534000 30
236 146 1 0.5 1 6 1107212400 30
238 147 1 0.5 1 6 1093989600 30
239 147 1 0.5 1 6 1096581600 30
240 147 1 0.5 1 6 1099263600 30
241 147 1 0.5 1 6 1101855600 30
242 147 1 0.5 1 6 1104534000 30
243 147 1 0.5 1 6 1107212400 30
245 147 5 0.5 2 6 1093989600 30
246 147 5 0.5 2 6 1096581600 30
247 147 5 0.5 2 6 1099263600 30
248 147 5 0.5 2 6 1101855600 30
249 147 5 0.5 2 6 1104534000 30
250 147 5 0.5 2 6 1107212400 30
252 169 16 15 4 6 1099263600 30
253 169 16 15 4 6 1101855600 30
254 169 16 15 4 6 1104534000 30
262 142 8 2 3 4 1101855600 30
263 142 8 1 3 4 1104534000 30
265 142 4 2 3 4 1099263600 30
266 142 4 4 3 4 1101855600 30
276 174 6 4 1 0 1078095600 30
277 174 6 1.5 1 0 1080770400 30
278 174 6 5.75 1 0 1083362400 30
279 174 6 6 1 0 1086040800 30
280 174 6 10.75 1 0 1088632800 30
281 174 6 3.5 1 0 1091311200 30
282 174 6 6 1 0 1096581600 30
283 174 6 7 1 0 1099263600 30
286 174 18 2 3 0 1075590000 30
287 174 18 2 3 0 1080770400 30
288 174 18 0.5 3 0 1083362400 30
289 174 18 1.75 3 0 1086040800 30
291 174 16 26 3 0 1099263600 30
293 174 19 1.5 3 0 1083362400 30
294 174 19 2 3 0 1091311200 30
295 174 19 2 3 0 1099263600 30
297 174 7 8 3 0 1075590000 30
298 174 7 8 3 0 1083362400 30
299 174 7 2.5 3 0 1088632800 30
300 174 7 2.5 3 0 1091311200 30
301 174 7 3 3 0 1093989600 30
303 174 5 1 2 0 1075590000 30
304 174 5 1 2 0 1083362400 30
305 174 5 1 2 0 1086040800 30
306 174 5 1 2 0 1088632800 30
307 174 5 3 2 0 1091311200 30
308 174 5 3 2 0 1093989600 30
310 174 20 0.5 3 0 1086040800 30
311 174 20 2 3 0 1093989600 30
312 174 20 2 3 0 1099263600 30
314 174 21 2 3 0 1093989600 30
315 174 21 2 3 0 1099263600 30
317 174 22 1 3 0 1088632800 30
319 174 23 2 3 0 1093989600 30
320 174 23 2 3 0 1099263600 30
322 174 24 2 3 0 1093989600 30
323 174 24 2 3 0 1099263600 30
325 174 25 1 3 0 1075590000 30
326 174 25 1.5 3 0 1083362400 30
327 174 25 3 3 0 1093989600 30
328 174 25 2 3 0 1099263600 30
331 177 6 10.5 1 3 1072911600 30
332 177 6 9 1 3 1075590000 30
333 177 6 12.375 1 3 1078095600 30
334 177 6 4.5 1 3 1080770400 30
335 177 6 2.75 1 3 1083362400 30
336 177 6 6.625 1 3 1086040800 30
337 177 6 2.375 1 3 1088632800 30
338 177 6 7.875 1 3 1091311200 30
339 177 6 2 1 3 1093989600 30
340 177 6 6 1 3 1096581600 30
341 177 6 3 1 3 1099263600 30
342 177 6 1 1 3 1104534000 30
343 177 6 2 1 3 1107212400 30
357 177 16 26 4 3 1099263600 30
363 177 19 6 3 3 1072911600 30
364 177 19 5 3 3 1078095600 30
365 177 19 2 3 3 1080770400 30
367 177 7 10 3 3 1072911600 30
368 177 7 8 3 3 1078095600 30
369 177 7 8 3 3 1080770400 30
370 177 7 2 3 3 1086040800 30
371 177 7 1 3 3 1088632800 30
372 177 7 4 3 3 1091311200 30
373 177 7 5 3 3 1093989600 30
374 177 7 5 3 3 1096581600 30
375 177 7 3 3 3 1099263600 30
377 177 5 1 2 3 1078095600 30
378 177 5 2 2 3 1080770400 30
379 177 5 0.5 2 3 1091311200 30
380 177 5 2 2 3 1093989600 30
381 177 5 2 2 3 1096581600 30
382 177 5 2 2 3 1099263600 30
384 177 20 2 3 3 1078095600 30
385 177 20 1 3 3 1080770400 30
387 177 21 1 3 3 1072911600 30
388 177 21 3 3 3 1078095600 30
389 177 21 1 3 3 1080770400 30
390 177 21 1 3 3 1091311200 30
392 177 22 1 3 3 1078095600 30
394 177 23 1 3 3 1072911600 30
395 177 23 3 3 3 1078095600 30
396 177 23 1 3 3 1080770400 30
397 177 23 1 3 3 1091311200 30
399 177 27 1.5 3 3 1078095600 30
401 177 28 9 3 3 1078095600 30
403 177 24 1 3 3 1072911600 30
404 177 24 3 3 3 1078095600 30
405 177 24 1 3 3 1080770400 30
406 177 24 1 3 3 1093989600 30
407 177 24 1 3 3 1096581600 30
408 177 24 1 3 3 1099263600 30
410 177 29 1 3 3 1078095600 30
411 177 29 1 3 3 1080770400 30
413 177 25 1 3 3 1072911600 30
414 177 25 3 3 3 1078095600 30
415 177 25 1 3 3 1080770400 30
416 177 25 3 3 3 1091311200 30
417 177 25 6 3 3 1093989600 30
418 177 25 1 3 3 1096581600 30
419 177 25 1 3 3 1099263600 30
421 177 30 3 3 3 1093989600 30
422 177 30 3 3 3 1096581600 30
423 177 30 3 3 3 1099263600 30
425 177 31 38 4 3 1072911600 30
426 177 31 38 4 3 1075590000 30
427 177 31 38 4 3 1078095600 30
428 177 31 38 4 3 1080770400 30
429 177 31 38 4 3 1083362400 30
430 177 31 38 4 3 1086040800 30
431 177 31 38 4 3 1088632800 30
432 177 31 38 4 3 1091311200 30
433 177 31 38 4 3 1093989600 30
434 177 31 38 4 3 1096581600 30
435 177 31 40 4 3 1099263600 30
437 177 13 0.375 3 3 1072911600 30
439 124 6 2 3 4 1091311200 30
440 124 6 4 3 4 1093989600 30
441 124 6 6 3 4 1096581600 30
442 124 6 2 3 4 1099263600 30
443 124 6 5 3 4 1101855600 30
444 124 6 8 3 4 1104534000 30
445 124 6 6 3 4 1107212400 30
446 124 6 2 3 4 1109631600 30
450 124 16 24.5 3 4 1099263600 30
452 124 7 2 3 4 1096581600 30
454 176 6 1 1 6 1075590000 30
455 176 6 1 1 6 1078095600 30
456 176 6 1 1 6 1080770400 30
457 176 6 1 1 6 1083362400 30
458 176 6 3 1 6 1086040800 30
459 176 6 2.5 1 6 1088632800 30
460 176 6 3 1 6 1091311200 30
461 176 6 3 1 6 1093989600 30
462 176 6 2 1 6 1096581600 30
463 176 6 3 1 6 1099263600 30
464 176 6 2 1 6 1101855600 30
465 176 6 2 1 6 1104534000 30
466 176 6 2 1 6 1107212400 30
467 176 6 3 1 6 1109631600 30
483 176 5 2 2 6 1072911600 30
484 176 5 1 2 6 1075590000 30
485 176 5 1 2 6 1078095600 30
486 176 5 1 2 6 1083362400 30
487 176 5 1 2 6 1086040800 30
488 176 5 1 2 6 1088632800 30
489 176 5 1 2 6 1091311200 30
490 176 5 1 2 6 1093989600 30
491 176 5 1 2 6 1096581600 30
492 176 5 1 2 6 1099263600 30
493 176 5 1 2 6 1101855600 30
494 176 5 1 2 6 1104534000 30
495 176 5 1 2 6 1107212400 30
496 176 5 1 2 6 1109631600 30
498 176 7 2 3 6 1075590000 30
499 176 7 2 3 6 1078095600 30
500 176 7 2 3 6 1080770400 30
501 176 7 2 3 6 1083362400 30
502 176 7 1 3 6 1086040800 30
503 176 7 0.5 3 6 1088632800 30
504 176 7 1 3 6 1093989600 30
505 176 7 1 3 6 1096581600 30
506 176 7 1 3 6 1099263600 30
507 176 7 1 3 6 1101855600 30
508 176 7 1 3 6 1104534000 30
509 176 7 1 3 6 1107212400 30
510 176 7 1 3 6 1109631600 30
512 136 3 1 3 2 1093989600 30
513 136 3 2 3 2 1096581600 30
514 136 3 3 3 2 1099263600 30
216 133 3 10 3 1 1093989600 30
259 142 11 1 3 4 1099263600 30
516 142 11 2 3 4 1101855600 30
260 142 11 2 3 4 1104534000 30
256 142 10 1 3 4 1099263600 30
517 142 10 2 3 4 1101855600 30
257 142 10 3 3 4 1104534000 30
224 142 3 4 3 4 1099263600 30
225 142 3 2 3 4 1101855600 30
226 142 3 5 3 4 1104534000 30
518 143 1 8 1 4 1101855600 30
519 143 1 8 1 4 1104534000 30
520 128 1 5 1 0 1093989600 30
521 128 1 5 1 0 1096581600 30
522 32 2 1 1 3 1086040800 30
523 47 2 0.5 1 6 1083362400 30
524 47 2 0.5 1 6 1086040800 30
525 47 1 0.5 1 6 1091311200 30
526 48 2 0.5 1 6 1083362400 30
527 48 2 0.5 1 6 1086040800 30
528 48 2 0.5 1 6 1088632800 30
536 49 2 0.5 1 6 1086040800 30
537 49 2 0.5 1 6 1088632800 30
538 49 2 0.5 1 6 1091311200 30
560 34 10 1.5 3 3 1107212400 30
561 34 4 1.5 3 3 1107212400 30
562 34 1 0.5 1 3 1104534000 30
563 34 1 0.5 1 3 1107212400 30
568 94 10 2 3 4 1091311200 30
569 94 10 1 3 4 1104534000 30
570 94 10 3 3 4 1107212400 30
571 150 1 1 3 1 1086040800 30
572 153 1 1 3 3 1086040800 30
573 155 2 0.5 1 3 1091311200 30
574 155 1 0.5 3 3 1091311200 30
575 158 1 1 3 4 1086040800 30
576 164 2 0.5 1 6 1093989600 30
577 165 2 0.5 1 6 1083362400 30
578 165 2 0.5 1 6 1088632800 30
579 165 2 0.5 1 6 1093989600 30
580 165 1 0.5 3 6 1091311200 30
581 165 1 0.5 3 6 1093989600 30
582 98 3 3 3 0 1080770400 30
583 98 3 4 3 0 1083362400 30
584 98 2 2 1 0 1080770400 30
585 98 2 3 1 0 1083362400 30
586 98 1 5 3 0 1080770400 30
587 98 1 7 3 0 1083362400 30
590 104 1 0.5 3 3 1093989600 30
552 49 5 0.5 2 6 1086040800 30
553 49 5 0.5 2 6 1088632800 30
554 49 5 0.5 2 6 1091311200 30
557 49 5 1 2 6 1104534000 30
558 49 5 1 2 6 1107212400 30
559 49 5 0.5 2 6 1109631600 30
529 48 1 0.5 1 6 1088632800 30
530 48 1 1 1 6 1091311200 30
533 48 1 1 1 6 1104534000 30
534 48 1 1 1 6 1107212400 30
535 48 1 0.5 1 6 1109631600 30
591 181 3 5 3 1 1072911600 30
592 181 7 1 1 1 1072911600 30
593 183 3 5 3 2 1075590000 30
594 183 3 5 3 2 1078095600 30
595 183 7 1 1 2 1075590000 30
596 183 7 1 1 2 1078095600 30
597 185 3 2 3 3 1078095600 30
598 185 3 8 3 3 1080770400 30
599 185 3 10 3 3 1083362400 30
600 185 3 10 3 3 1086040800 30
601 185 7 1 1 3 1078095600 30
602 185 7 1 1 3 1080770400 30
603 185 7 1 1 3 1083362400 30
604 185 7 1 1 3 1086040800 30
605 186 3 5 3 3 1093989600 30
606 186 3 5 3 3 1096581600 30
615 187 31 15.25 4 3 1088632800 30
616 187 31 15.25 4 3 1091311200 30
617 187 31 15.25 4 3 1093989600 30
618 187 31 15.25 4 3 1096581600 30
619 187 31 15.25 4 3 1099263600 30
620 187 31 15.25 4 3 1101855600 30
621 187 31 15.25 4 3 1104534000 30
622 187 31 15.25 4 3 1107212400 30
149 30 1 2 3 3 1088632800 30
147 30 11 0.5 3 3 1086040800 30
156 34 8 2 3 3 1105916400 30
564 34 11 1 3 3 1107212400 30
623 94 4 2 3 4 1091311200 30
624 94 4 1 3 4 1104534000 30
625 94 4 3 3 4 1107212400 30
626 94 8 0.5 3 4 1091311200 30
627 94 8 1 3 4 1104534000 30
628 94 8 1 3 4 1107212400 30
629 94 1 1.5 1 4 1091311200 30
630 94 1 1 1 4 1104534000 30
631 94 1 2 1 4 1107212400 30
632 94 11 1 3 4 1091311200 30
633 94 11 1 3 4 1104534000 30
634 94 11 2 3 4 1107212400 30
635 130 10 0.5 3 1 1093989600 30
636 130 4 0.5 3 1 1093989600 30
637 130 11 0.5 3 1 1093989600 30
638 130 8 0.5 3 1 1093989600 30
639 188 17 3 1 1 1093989600 30
640 130 33 0.5 3 1 1093989600 30
641 191 17 3 1 3 1096581600 30
642 191 1 2 3 3 1096581600 30
645 130 34 0.5 3 1 1093989600 30
646 191 34 0.5 3 3 1096581600 30
644 191 4 1 3 3 1096581600 30
647 191 11 1 3 3 1096581600 30
648 191 8 2 3 3 1096581600 30
643 191 10 0.5 3 3 1096581600 30
649 192 17 1 1 3 1096581600 30
650 192 8 1 3 3 1096581600 30
651 198 1 2 3 3 1096581600 30
652 198 17 3 1 3 1096581600 30
653 198 10 0.5 3 3 1098050400 30
654 198 34 0.5 3 3 1098050400 30
655 198 4 1 3 3 1098050400 30
656 198 11 1 3 3 1098050400 30
657 198 8 3 3 3 1098050400 30
660 196 17 3 1 6 1093989600 30
661 196 17 3 1 6 1096581600 30
662 197 17 2 1 6 1093989600 30
663 197 17 2 1 6 1096581600 30
664 199 17 1.5 1 6 1093989600 30
665 199 17 1.5 1 6 1096581600 30
666 130 1 1 3 1 1094421600 30
667 130 17 1 1 1 1093989600 30
669 124 1 5 3 4 1096581600 30
670 124 1 8 3 4 1099263600 30
345 177 1 10 3 3 1072911600 30
346 177 1 13.5 3 3 1075590000 30
347 177 1 11.5 3 3 1078095600 30
348 177 1 8.25 3 3 1080770400 30
349 177 1 2 3 3 1083362400 30
350 177 1 2 3 3 1086040800 30
351 177 1 0.5 3 3 1088632800 30
352 177 1 2 3 3 1091311200 30
353 177 1 8 3 3 1096581600 30
354 177 1 3 3 3 1104534000 30
355 177 1 4 3 3 1107212400 30
807 298 1 1 1 1 1096581600 30
808 299 1 2 1 1 1099263600 30
824 311 1 0.5 1 6 1096581600 30
825 311 1 0.5 1 6 1112306400 30
827 303 1 1 1 3 1101855600 30
831 305 1 2 1 3 1107212400 30
826 302 1 2 1 3 1101855600 30
809 309 1 0.5 1 6 1096581600 30
834 309 1 0.5 1 6 1104534000 30
835 309 1 0.5 1 6 1109631600 30
813 309 1 0.5 1 6 1112306400 30
837 310 5 0.5 2 6 1099263600 30
842 310 5 0.5 2 6 1112306400 30
820 310 1 0.5 1 6 1099263600 30
823 310 1 0.5 1 6 1112306400 30
\.
--
-- Data for TOC Entry ID 68 (OID 157223)
--
-- Name: wdone Type: TABLE DATA Owner: wwwrun
--
COPY "wdone" FROM stdin;
1 13510 1 1086559200 8 89 0 1 t \N
2 13510 1 1086645600 8 89 0 1 t \N
3 13510 1 1086732000 8 89 0 1 t \N
8 13510 1 1086818400 8 89 0 1 t \N
9 13510 1 1086904800 8 89 0 1 t \N
10 13510 1 1087164000 8 89 0 1 t \N
11 13510 1 1087250400 8 89 0 1 t \N
12 13510 1 1088978400 8 27 0 2 t \N
13 13510 1 1089064800 8 27 0 2 t \N
14 13510 1 1089756000 8 30 0 3 t \N
16 13510 1 1093903200 4 48 0 6 t \N
17 13510 2 1084140000 8 88 0 1 t \N
18 13510 2 1086559200 8 89 0 1 t \N
19 13510 2 1086645600 8 89 0 1 t \N
21 13510 2 1088978400 8 27 0 2 t \N
22 13510 2 1090360800 3 27 0 2 t \N
23 13510 2 1090360800 5 30 0 3 t \N
25 13510 2 1088460000 8 48 0 6 t \N
26 13510 2 1088546400 4 47 0 6 t \N
27 13510 2 1092693600 4 31 0 3 t \N
28 13510 2 1093903200 4 47 0 6 t \N
29 90757 1 1094680800 8 128 0 0 t \N
30 13510 1 1091138400 4 48 0 6 t \N
31 13510 10 1084744800 8 88 0 1 t \N
32 13510 10 1086559200 8 89 0 1 t \N
33 13510 10 1086645600 8 89 0 1 t \N
34 13510 10 1089669600 4 27 0 2 t \N
35 13510 10 1090274400 4 30 0 3 t \N
36 13510 10 1092780000 8 94 0 4 t \N
37 13510 10 1092866400 8 94 0 4 t \N
38 13510 4 1084140000 8 88 0 1 t \N
41 13510 4 1089583200 4 27 0 2 t \N
42 13510 4 1089669600 4 30 0 3 t \N
43 13510 4 1092607200 8 31 0 3 t \N
44 13510 4 1092693600 8 31 0 3 t \N
45 13510 4 1092780000 8 31 0 3 t \N
46 13510 4 1092866400 8 31 0 3 t \N
47 13510 4 1092952800 8 31 0 3 t \N
48 13510 4 1093212000 8 31 0 3 t \N
49 13510 4 1093212000 8 94 0 4 t \N
50 13510 4 1093298400 8 94 0 4 t \N
51 13510 11 1084140000 8 88 0 1 t \N
52 13510 11 1086559200 8 89 0 1 t \N
53 13510 11 1086645600 8 89 0 1 t \N
54 13510 11 1089583200 4 27 0 2 t \N
55 13510 11 1089669600 4 30 0 3 t \N
56 13510 11 1092002400 8 94 0 4 t \N
57 13510 12 1086559200 8 89 0 1 t \N
58 13510 12 1086645600 8 89 0 1 t \N
59 13510 12 1089583200 4 27 0 2 t \N
60 13510 12 1089669600 4 30 0 3 t \N
61 13510 12 1092002400 8 30 0 3 t \N
62 13510 12 1092088800 4 30 0 3 t \N
63 13510 12 1092175200 8 94 0 4 t \N
64 13510 12 1092693600 8 94 0 4 t \N
65 13200 1 1079910000 2 98 0 0 t \N
66 13200 1 1080169200 8 98 0 0 t \N
67 13200 1 1080770400 2 98 0 0 t \N
68 13200 1 1080856800 4 98 0 0 t \N
69 13200 1 1081116000 4 98 0 0 t \N
70 13200 1 1081375200 8 98 0 0 t \N
71 13200 1 1081893600 1 98 0 0 t \N
72 13200 1 1083708000 4 98 0 0 t \N
73 13200 1 1083794400 2 98 0 0 t \N
74 13200 1 1084140000 8 98 0 0 t \N
75 13200 1 1084226400 2 98 0 0 t \N
76 13200 1 1084312800 6 98 0 0 t \N
77 13200 1 1084399200 6 98 0 0 t \N
78 13200 1 1084485600 4 98 0 0 t \N
79 13200 1 1084744800 6 98 0 0 t \N
80 13200 1 1084831200 8 98 0 0 t \N
81 13200 1 1084917600 8 98 0 0 t \N
82 13200 1 1085608800 8 98 0 0 t \N
83 13200 1 1085695200 2 98 0 0 t \N
85 10388 1 1095026400 8 121 0 3 t \N
6 10388 1 1094594400 8 121 0 3 t \N
5 10388 1 1094508000 8 121 0 3 t \N
86 10388 1 1095112800 8 121 0 3 t \N
87 13200 1 1095285600 4 104 0 3 t \N
88 13200 2 1219183200 8 112 0 3 t \N
90 12661 1 1086645600 8 150 0 1 t \N
92 12661 1 1087941600 8 158 0 4 t \N
93 12661 1 1088460000 8 153 0 3 t \N
95 12661 1 1086732000 8 165 0 6 t \N
99 12661 1 1088546400 4 165 0 6 t \N
100 12661 2 1086732000 8 165 0 6 t \N
101 12661 2 1088546400 4 165 0 6 t \N
103 12661 1 1093903200 4 165 0 6 t \N
104 12661 2 1093903200 4 165 0 6 t \N
105 10388 1 1095890400 8 121 0 3 t \N
89 10388 1 1095631200 8 121 0 3 t \N
106 90757 1 1096322400 8 128 0 0 t \N
107 90757 1 1095976800 4 128 0 0 t \N
108 10388 1 1096408800 4 122 0 3 t \N
109 13510 2 1086732000 8 10 0 1 t \N
110 13510 2 1091138400 4 48 0 6 t \N
111 13510 2 1091138400 4 49 0 6 t \N
112 90757 1 1096495200 8 128 0 0 t \N
113 90757 1 1096408800 8 128 0 0 t \N
39 13510 4 1086559200 8 89 1 1 t \N
40 13510 4 1086645600 8 89 1 1 t \N
115 11230 3 1095026400 8 186 0 3 t \N
116 11230 3 1095112800 8 186 0 3 t \N
117 11230 3 1095285600 8 186 0 3 t \N
120 13510 5 1091138400 4 49 0 6 t \N
121 13510 5 1093903200 4 49 0 6 t \N
119 13510 5 1088546400 4 49 0 6 t \N
124 13510 8 1086645600 8 89 0 1 t \N
123 13510 8 1086559200 8 89 0 1 t \N
126 13510 8 1088978400 8 91 0 3 t \N
127 13510 8 1089064800 8 91 0 3 t \N
125 13510 8 1086732000 8 90 0 3 t \N
128 13510 8 1092002400 4 94 0 4 t \N
149 90757 1 1096840800 8 128 0 0 t \N
151 13860 17 1094680800 8 130 0 1 t \N
152 13860 17 1094508000 2 196 0 6 t \N
153 13860 17 1094767200 8 196 0 6 t \N
154 13860 17 1095112800 4 188 0 1 t \N
155 13860 17 1095199200 4 188 0 1 t \N
156 13860 17 1095372000 4 188 0 1 t \N
157 13860 17 1095804000 3 196 0 6 t \N
158 13860 17 1095976800 4 188 0 1 t \N
159 13860 17 1095976800 4 196 0 6 t \N
160 13860 17 1096149600 3 196 0 6 t \N
161 13860 17 1096495200 4 188 0 1 t \N
84 13860 1 1094767200 4 130 0 1 t \N
162 90757 1 1096927200 8 128 0 0 t \N
163 10388 1 1097100000 8 177 0 3 t \N
165 999999 1 1096927200 8 139 0 3 t \N
164 999999 1 1093989600 8 133 0 1 t \N
166 999999 1 1094076000 8 133 0 1 t \N
167 999999 1 1097013600 4 139 0 3 t \N
168 10388 1 1097445600 8 177 0 3 t \N
169 10388 1 1097532000 8 177 0 3 t \N
171 14060 1 1097704800 8 298 0 1 t \N
\.
\connect - andreas
--
-- Data for TOC Entry ID 69 (OID 157245)
--
-- Name: pga_graphs Type: TABLE DATA Owner: andreas
--
COPY "pga_graphs" FROM stdin;
\.
--
-- Data for TOC Entry ID 70 (OID 157251)
--
-- Name: pga_layout Type: TABLE DATA Owner: andreas
--
COPY "pga_layout" FROM stdin;
key_land 2 kl_num kl_land 150 150
key_tmgroup 2 kt_num kt_tm 150 150
key_sgf 2 ks_num ks_sgf 150 150
key_abt 2 ka_num ka_abt 150 150
key_role 2 kr_num kr_role 150 150
project 7 pr_num pr_name pr_pl pr_plav pr_sgf {pr_tmgroup} {pr_status} 150 150 150 150 150 150 150
key_status 2 ks_num ks_status 150 150
plan 4 pl_num pl_lfd pl_prnum pl_status 150 150 150 150
counter 5 co_mitarbeiter co_plan co_task co_wdone {co_allocation} 150 150 150 150 150
mitarbeiter 11 mi_num mi_vname mi_nname mi_land mi_abt mi_tel mi_mail mi_userid mi_passwd {mi_rstufe} {mi_hacker} 150 150 150 150 150 150 150 150 150 150 150
allocmi 9 am_num am_task am_ressource am_hours am_phase am_role am_krnum am_vname am_nname 150 150 150 150 150 150 150 150 150
task 17 ta_num ta_plnum ta_id ta_depend ta_deptype ta_name ta_color ta_shape ta_meeting ta_start ta_duration ta_complete ta_fixed_start ta_priority ta_level ta_notiz {ta_phase} 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150
allocation 8 al_num al_task al_ressource al_hours al_role al_phase al_pstart al_pduration 150 150 150 150 150 150 150 150
wdone 10 wd_num wd_prnum wd_minum wd_datum wd_hours wd_task wd_rk {wd_phase} {wd_edit} {wd_periode} 150 150 150 150 150 150 150 150 150 150
10 wd_num wd_prnum wd_minum wd_datum wd_hours wd_task wd_rk wd_phase wd_edit wd_periode 150 150 150 150 150 150 150 150 150 150
tempidx 3 te_num te_name te_zweck 150 150 150
\.
--
-- Data for TOC Entry ID 71 (OID 157257)
--
-- Name: pga_images Type: TABLE DATA Owner: andreas
--
COPY "pga_images" FROM stdin;
\.
--
-- Data for TOC Entry ID 72 (OID 157263)
--
-- Name: pga_queries Type: TABLE DATA Owner: andreas
--
COPY "pga_queries" FROM stdin;
\.
--
-- Data for TOC Entry ID 73 (OID 157269)
--
-- Name: pga_reports Type: TABLE DATA Owner: andreas
--
COPY "pga_reports" FROM stdin;
\.
--
-- Data for TOC Entry ID 74 (OID 157275)
--
-- Name: pga_forms Type: TABLE DATA Owner: andreas
--
COPY "pga_forms" FROM stdin;
\.
--
-- Data for TOC Entry ID 75 (OID 157281)
--
-- Name: pga_diagrams Type: TABLE DATA Owner: andreas
--
COPY "pga_diagrams" FROM stdin;
\.
--
-- Data for TOC Entry ID 76 (OID 157287)
--
-- Name: pga_scripts Type: TABLE DATA Owner: andreas
--
COPY "pga_scripts" FROM stdin;
\.
\connect - wwwrun
--
-- Data for TOC Entry ID 77 (OID 157338)
--
-- Name: key_status Type: TABLE DATA Owner: wwwrun
--
COPY "key_status" FROM stdin;
2 INI
1 PLG
3 AKT
4 ABG
5 ABS
6 TMA
\.
--
-- Data for TOC Entry ID 78 (OID 157341)
--
-- Name: ptemp Type: TABLE DATA Owner: wwwrun
--
COPY "ptemp" FROM stdin;
\.
--
-- Data for TOC Entry ID 79 (OID 165403)
--
-- Name: key_phase Type: TABLE DATA Owner: wwwrun
--
COPY "key_phase" FROM stdin;
1 Angebot
2 Organisationsentwicklung
3 Systementwicklung
4 Zentrale Rolloutplanung
5 Dezentraler Rollout
6 Phasenübergreifende Projektaktivitäten
0 Analyse / Themenmanagement
\.
--
-- Data for TOC Entry ID 80 (OID 190526)
--
-- Name: tempidx Type: TABLE DATA Owner: wwwrun
--
COPY "tempidx" FROM stdin;
\.
--
-- TOC Entry ID 49 (OID 157155)
--
-- Name: "idx_mi_name" Type: INDEX Owner: wwwrun
--
CREATE UNIQUE INDEX idx_mi_name ON mitarbeiter USING btree (mi_nname, mi_vname);
--
-- TOC Entry ID 50 (OID 157156)
--
-- Name: "idx_mi_userid" Type: INDEX Owner: wwwrun
--
CREATE UNIQUE INDEX idx_mi_userid ON mitarbeiter USING btree (mi_userid);
--
-- TOC Entry ID 51 (OID 157178)
--
-- Name: "idx_project_name" Type: INDEX Owner: wwwrun
--
CREATE UNIQUE INDEX idx_project_name ON project USING btree (pr_name);
--
-- TOC Entry ID 52 (OID 157200)
--
-- Name: "idx_task_plnum" Type: INDEX Owner: wwwrun
--
CREATE INDEX idx_task_plnum ON task USING btree (ta_plnum);
--
-- TOC Entry ID 53 (OID 157222)
--
-- Name: "idx_alloc_task" Type: INDEX Owner: wwwrun
--
CREATE INDEX idx_alloc_task ON allocation USING btree (al_task);
--
-- TOC Entry ID 54 (OID 157344)
--
-- Name: "idx_ptemp_num" Type: INDEX Owner: wwwrun
--
CREATE UNIQUE INDEX idx_ptemp_num ON ptemp USING btree (pt_tnum, pt_lfd);
--
-- TOC Entry ID 55 (OID 165156)
--
-- Name: "idx_task_numid" Type: INDEX Owner: wwwrun
--
CREATE UNIQUE INDEX idx_task_numid ON task USING btree (ta_plnum, ta_id);
--
-- TOC Entry ID 56 (OID 190533)
--
-- Name: "idx_tempidx_name" Type: INDEX Owner: wwwrun
--
CREATE UNIQUE INDEX idx_tempidx_name ON tempidx USING btree (te_name);
--
-- TOC Entry ID 89 (OID 157144)
--
-- Name: "RI_ConstraintTrigger_157143" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "mitarbeiter" FROM "key_land" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'mitarbeiter', 'key_land', 'UNSPECIFIED', 'mi_land', 'kl_num');
--
-- TOC Entry ID 83 (OID 157146)
--
-- Name: "RI_ConstraintTrigger_157145" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "key_land" FROM "mitarbeiter" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'mitarbeiter', 'key_land', 'UNSPECIFIED', 'mi_land', 'kl_num');
--
-- TOC Entry ID 84 (OID 157148)
--
-- Name: "RI_ConstraintTrigger_157147" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "key_land" FROM "mitarbeiter" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'mitarbeiter', 'key_land', 'UNSPECIFIED', 'mi_land', 'kl_num');
--
-- TOC Entry ID 90 (OID 157150)
--
-- Name: "RI_ConstraintTrigger_157149" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "mitarbeiter" FROM "key_abt" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'mitarbeiter', 'key_abt', 'UNSPECIFIED', 'mi_abt', 'ka_num');
--
-- TOC Entry ID 85 (OID 157152)
--
-- Name: "RI_ConstraintTrigger_157151" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "key_abt" FROM "mitarbeiter" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'mitarbeiter', 'key_abt', 'UNSPECIFIED', 'mi_abt', 'ka_num');
--
-- TOC Entry ID 86 (OID 157154)
--
-- Name: "RI_ConstraintTrigger_157153" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "key_abt" FROM "mitarbeiter" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'mitarbeiter', 'key_abt', 'UNSPECIFIED', 'mi_abt', 'ka_num');
--
-- TOC Entry ID 99 (OID 157161)
--
-- Name: "RI_ConstraintTrigger_157160" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "project" FROM "mitarbeiter" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'project', 'mitarbeiter', 'UNSPECIFIED', 'pr_pl', 'mi_num');
--
-- TOC Entry ID 91 (OID 157163)
--
-- Name: "RI_ConstraintTrigger_157162" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "mitarbeiter" FROM "project" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'project', 'mitarbeiter', 'UNSPECIFIED', 'pr_pl', 'mi_num');
--
-- TOC Entry ID 92 (OID 157165)
--
-- Name: "RI_ConstraintTrigger_157164" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "mitarbeiter" FROM "project" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'project', 'mitarbeiter', 'UNSPECIFIED', 'pr_pl', 'mi_num');
--
-- TOC Entry ID 100 (OID 157167)
--
-- Name: "RI_ConstraintTrigger_157166" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "project" FROM "mitarbeiter" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'project', 'mitarbeiter', 'UNSPECIFIED', 'pr_plav', 'mi_num');
--
-- TOC Entry ID 93 (OID 157169)
--
-- Name: "RI_ConstraintTrigger_157168" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "mitarbeiter" FROM "project" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'project', 'mitarbeiter', 'UNSPECIFIED', 'pr_plav', 'mi_num');
--
-- TOC Entry ID 94 (OID 157171)
--
-- Name: "RI_ConstraintTrigger_157170" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "mitarbeiter" FROM "project" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'project', 'mitarbeiter', 'UNSPECIFIED', 'pr_plav', 'mi_num');
--
-- TOC Entry ID 101 (OID 157173)
--
-- Name: "RI_ConstraintTrigger_157172" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "project" FROM "key_sgf" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'project', 'key_sgf', 'UNSPECIFIED', 'pr_sgf', 'ks_num');
--
-- TOC Entry ID 87 (OID 157175)
--
-- Name: "RI_ConstraintTrigger_157174" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "key_sgf" FROM "project" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'project', 'key_sgf', 'UNSPECIFIED', 'pr_sgf', 'ks_num');
--
-- TOC Entry ID 88 (OID 157177)
--
-- Name: "RI_ConstraintTrigger_157176" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "key_sgf" FROM "project" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'project', 'key_sgf', 'UNSPECIFIED', 'pr_sgf', 'ks_num');
--
-- TOC Entry ID 106 (OID 157183)
--
-- Name: "RI_ConstraintTrigger_157182" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "plan" FROM "project" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'plan', 'project', 'UNSPECIFIED', 'pl_prnum', 'pr_num');
--
-- TOC Entry ID 102 (OID 157185)
--
-- Name: "RI_ConstraintTrigger_157184" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "project" FROM "plan" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'plan', 'project', 'UNSPECIFIED', 'pl_prnum', 'pr_num');
--
-- TOC Entry ID 103 (OID 157187)
--
-- Name: "RI_ConstraintTrigger_157186" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "project" FROM "plan" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'plan', 'project', 'UNSPECIFIED', 'pl_prnum', 'pr_num');
--
-- TOC Entry ID 109 (OID 157195)
--
-- Name: "RI_ConstraintTrigger_157194" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "task" FROM "plan" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'task', 'plan', 'UNSPECIFIED', 'ta_plnum', 'pl_num');
--
-- TOC Entry ID 107 (OID 157197)
--
-- Name: "RI_ConstraintTrigger_157196" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "plan" FROM "task" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'task', 'plan', 'UNSPECIFIED', 'ta_plnum', 'pl_num');
--
-- TOC Entry ID 108 (OID 157199)
--
-- Name: "RI_ConstraintTrigger_157198" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "plan" FROM "task" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'task', 'plan', 'UNSPECIFIED', 'ta_plnum', 'pl_num');
--
-- TOC Entry ID 114 (OID 157205)
--
-- Name: "RI_ConstraintTrigger_157204" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "allocation" FROM "task" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'allocation', 'task', 'UNSPECIFIED', 'al_task', 'ta_num');
--
-- TOC Entry ID 110 (OID 157207)
--
-- Name: "RI_ConstraintTrigger_157206" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "task" FROM "allocation" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'allocation', 'task', 'UNSPECIFIED', 'al_task', 'ta_num');
--
-- TOC Entry ID 111 (OID 157209)
--
-- Name: "RI_ConstraintTrigger_157208" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "task" FROM "allocation" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'allocation', 'task', 'UNSPECIFIED', 'al_task', 'ta_num');
--
-- TOC Entry ID 115 (OID 157211)
--
-- Name: "RI_ConstraintTrigger_157210" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "allocation" FROM "mitarbeiter" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'allocation', 'mitarbeiter', 'UNSPECIFIED', 'al_ressource', 'mi_num');
--
-- TOC Entry ID 95 (OID 157213)
--
-- Name: "RI_ConstraintTrigger_157212" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "mitarbeiter" FROM "allocation" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'allocation', 'mitarbeiter', 'UNSPECIFIED', 'al_ressource', 'mi_num');
--
-- TOC Entry ID 96 (OID 157215)
--
-- Name: "RI_ConstraintTrigger_157214" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "mitarbeiter" FROM "allocation" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'allocation', 'mitarbeiter', 'UNSPECIFIED', 'al_ressource', 'mi_num');
--
-- TOC Entry ID 116 (OID 157217)
--
-- Name: "RI_ConstraintTrigger_157216" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "allocation" FROM "key_role" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'allocation', 'key_role', 'UNSPECIFIED', 'al_role', 'kr_num');
--
-- TOC Entry ID 81 (OID 157219)
--
-- Name: "RI_ConstraintTrigger_157218" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "key_role" FROM "allocation" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'allocation', 'key_role', 'UNSPECIFIED', 'al_role', 'kr_num');
--
-- TOC Entry ID 82 (OID 157221)
--
-- Name: "RI_ConstraintTrigger_157220" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "key_role" FROM "allocation" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'allocation', 'key_role', 'UNSPECIFIED', 'al_role', 'kr_num');
--
-- TOC Entry ID 117 (OID 157227)
--
-- Name: "RI_ConstraintTrigger_157226" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "wdone" FROM "project" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'wdone', 'project', 'UNSPECIFIED', 'wd_prnum', 'pr_num');
--
-- TOC Entry ID 104 (OID 157229)
--
-- Name: "RI_ConstraintTrigger_157228" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "project" FROM "wdone" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'wdone', 'project', 'UNSPECIFIED', 'wd_prnum', 'pr_num');
--
-- TOC Entry ID 105 (OID 157231)
--
-- Name: "RI_ConstraintTrigger_157230" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "project" FROM "wdone" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'wdone', 'project', 'UNSPECIFIED', 'wd_prnum', 'pr_num');
--
-- TOC Entry ID 118 (OID 157233)
--
-- Name: "RI_ConstraintTrigger_157232" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "wdone" FROM "mitarbeiter" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'wdone', 'mitarbeiter', 'UNSPECIFIED', 'wd_minum', 'mi_num');
--
-- TOC Entry ID 97 (OID 157235)
--
-- Name: "RI_ConstraintTrigger_157234" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "mitarbeiter" FROM "wdone" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'wdone', 'mitarbeiter', 'UNSPECIFIED', 'wd_minum', 'mi_num');
--
-- TOC Entry ID 98 (OID 157237)
--
-- Name: "RI_ConstraintTrigger_157236" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "mitarbeiter" FROM "wdone" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'wdone', 'mitarbeiter', 'UNSPECIFIED', 'wd_minum', 'mi_num');
--
-- TOC Entry ID 119 (OID 157239)
--
-- Name: "RI_ConstraintTrigger_157238" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "wdone" FROM "task" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'wdone', 'task', 'UNSPECIFIED', 'wd_task', 'ta_num');
--
-- TOC Entry ID 112 (OID 157241)
--
-- Name: "RI_ConstraintTrigger_157240" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "task" FROM "wdone" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'wdone', 'task', 'UNSPECIFIED', 'wd_task', 'ta_num');
--
-- TOC Entry ID 113 (OID 157243)
--
-- Name: "RI_ConstraintTrigger_157242" Type: TRIGGER Owner: wwwrun
--
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "task" FROM "wdone" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'wdone', 'task', 'UNSPECIFIED', 'wd_task', 'ta_num');