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
|
Create Table Salarie (
SalarieId Int Not null,
Nom Varchar(48) Not null,
Constraint Salarie_PK Primary Key (SalarieId)
)
;
Create Table Prestation (
SalarieId Int Not null,
PrestationId Smallint Not null,
Montant Int Not null,
Constraint Prestation_PK Primary Key (SalarieId, PrestationId),
Constraint Prestation_Salarie_1 Foreign Key (SalarieId)
References Salarie (SalarieId)
)
;
Create Table Enfant (
SalarieId Int Not null,
EnfantId Smallint Not null,
Nom Varchar(48) Not null,
DateNaissance Char(10) Not null,
Constraint Enfant_PK Primary Key (SalarieId, EnfantId),
Constraint Enfant_Salarie_1 Foreign Key (SalarieId)
References Salarie (SalarieId)
On Update cascade
)
;
Create Table PrestationEnfant (
SalarieId Int Not null,
PrestationId Smallint Not null,
EnfantId Smallint Not null,
Constraint PrestationEnfant_PK Primary Key (SalarieId, EnfantId),
Constraint PrestationEnfant_Enfant_1 Foreign Key (SalarieId, EnfantId)
References Enfant (SalarieId, EnfantId),
Constraint PrestationEnfant_Prestation_2 Foreign Key (SalarieId, PrestationId)
References Prestation (SalarieId, PrestationId)
On Delete Cascade
)
; |
Partager