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
| Create Table Donnee (
DonneeId Int Not null,
DonneeLibelle Varchar(48) Not null,
Constraint Donnee_PK Primary Key (DonneeId)
);
Create Table DonneeDonnee (
DonneeId Int Not null,
Parent_DonneeId Int Not null,
Constraint DonneeDonnee_PK Primary Key (DonneeId),
Constraint DonneeDonnee_Donnee_1 Foreign Key (DonneeId)
References Donnee (DonneeId)
On Delete Cascade,
Constraint DonneeDonnee_Donnee_2 Foreign Key (Parent_DonneeId)
References Donnee (DonneeId)
)
;
Create Table Experience (
ExperienceId Int Not null,
ExperienceLibelle Varchar(48) Not null,
Constraint Experience_PK Primary Key (ExperienceId)
)
;
Create Table Operateur (
OperateurId Int Not null,
OperateurLibelle Varchar(48) Not null,
Constraint Operateur_PK Primary Key (OperateurId)
)
;
Create Table DonneeExp (
DonneeId Int Not null,
ExperienceId Int Not null,
Constraint DonneeExp_PK Primary Key (DonneeId),
Constraint DonneeExp_Experience_1 Foreign Key (ExperienceId)
References Experience (ExperienceId),
Constraint DonneeEXP_Donnee Foreign Key (DonneeId)
References Donnee (DonneeId)
On Delete Cascade
)
;
Create Table DonneeOper (
DonneeId Int Not null,
OperateurId Int Not null,
Constraint DonneeOper_PK Primary Key (DonneeId),
Constraint DonneeOper_Operateur_1 Foreign Key (OperateurId)
References Operateur (OperateurId),
Constraint DonneeOper_Donnee_2 Foreign Key (DonneeId)
References Donnee (DonneeId)
On Delete Cascade
); |
Partager