1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72
| CREATE TABLE project(
name_pro VarChar2 (50)) ;
CREATE TABLE task(
name_tas VarChar2 (50),
name_pro VarChar2 (50)) ;
CREATE TABLE soustask(
name_sta VarChar2 (50),
name_tas VarChar2 (50),
name_pro VarChar2 (50)) ;
CREATE TABLE works(
user_wor VarChar2 (50),
name_pro VarChar2 (50),
name_tas VarChar2 (50),
name_sta VarChar2 (50),
date_wor date,
workst_wor VarChar2 (50),
outt_wor VarChar2 (50),
total_wor VarChar2 (50) ) ;
CREATE TABLE horaire(
BeginAM_hor date,
EndAM_hor date,
BeginPM_hor date,
EndPM_hor date ) ;
ALTER TABLE horaire
ADD CONSTRAINT pk_hor PRIMARY KEY (BeginAM_hor, EndAM_hor, BeginPM_hor, EndPM_hor);
ALTER TABLE project
ADD CONSTRAINT pk_pro PRIMARY KEY (name_pro);
ALTER TABLE task
ADD CONSTRAINT pk_tas PRIMARY KEY (name_tas,name_pro);
ALTER TABLE soustask
ADD CONSTRAINT pk_sta PRIMARY KEY (name_sta,name_tas,name_pro);
ALTER TABLE works
ADD CONSTRAINT pk_4 PRIMARY KEY (name_pro,name_tas,name_sta,date_wor);
ALTER TABLE task
ADD CONSTRAINT fk_tas_pro FOREIGN KEY (name_pro)
REFERENCES project(name_pro);
ALTER TABLE soustask
ADD CONSTRAINT fk_sta_tas FOREIGN KEY (name_tas,name_pro)
REFERENCES task(name_tas,name_pro),
ALTER TABLE works
ADD CONSTRAINT fk_wor_pro FOREIGN KEY (name_pro)
REFERENCES project(name_pro);
ALTER TABLE works
ADD CONSTRAINT fk_wor_tas FOREIGN KEY (name_tas,name_pro)
REFERENCES task(name_tas,name_pro);
ALTER TABLE works
ADD CONSTRAINT fk_wor_sta FOREIGN KEY (name_sta,name_tas,name_pro)
REFERENCES soustask(name_sta,name_tas,name_pro); |
Partager