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
|
Create Table Contact (
ContactId Int Not null,
ContactNom Varchar(48) Not null,
Constraint Contact_PK Primary Key (ContactId)
) ;
Create Table Societe (
SocieteId Int Not null,
SocieteNom Varchar(48) Not null,
Constraint Societe_PK Primary Key (SocieteId)
) ;
Create Table Siege (
SocieteId Int Not null,
SiegeId Int Not null,
SiegeNom Char(14) Not null,
Constraint Siege_PK Primary Key (SocieteId, SiegeId),
Constraint Siege_Societe_1 Foreign Key (SocieteId)
References Societe (SocieteId)
On Update cascade On Delete Cascade
) ;
Create Table AdresseSociete (
SocieteId Int Not null,
AdresseId Varchar(48) Not null,
Adresse1 Varchar(48) Not null,
Adresse2 Varchar(48) Not null,
Adresse3 Varchar(48) Not null,
Adresse4 Varchar(48) Not null,
Constraint AdresseSociete_PK Primary Key (SocieteId, AdresseId),
Constraint AdresseSociete_Societe_1 Foreign Key (SocieteId)
References Societe (SocieteId)
On Update cascade On Delete Cascade
) ;
Create Table Service (
SocieteId Int Not null,
SiegeId Int Not null,
ServiceId Int Not null,
ServiceNom Varchar(48) Not null,
Constraint Service_PK Primary Key (SocieteId, ServiceId),
Constraint Service_Siege_1 Foreign Key (SocieteId, SiegeId)
References Siege (SocieteId, SiegeId)
On Update cascade On Delete Cascade
) ;
Create Table AdresseSiege (
SocieteId Int Not null,
SiegeId Int Not null,
AdresseId Varchar(48) Not null,
Adresse1 Varchar(48) Not null,
Adresse2 Varchar(48) Not null,
Adresse3 Varchar(48) Not null,
Adresse4 Varchar(48) Not null,
Constraint AdresseSiege_PK Primary Key (SocieteId, AdresseId),
Constraint AdresseSiege_Siege_1 Foreign Key (SocieteId, SiegeId)
References Siege (SocieteId, SiegeId)
On Update cascade On Delete Cascade
) ;
Create Table ContactService (
ContactId Int Not null,
SocieteId Int Not null,
ServiceId Int Not null,
Constraint ContactService_PK Primary Key (ContactId, SocieteId, ServiceId),
Constraint ContactService_Contact_1 Foreign Key (ContactId)
References Contact (ContactId)
On Update cascade On Delete Cascade,
Constraint ContactService_Service_2 Foreign Key (SocieteId, ServiceId)
References Service (SocieteId, ServiceId)
On Update cascade
) ; |
Partager