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
|
Create table Client
(CliId Char(4) Not Null,
Nom VarChar(48) Not Null,
Primary Key (CLiId)
) ;
Create table Facture
(CliId Char(4) Not Null,
FactId Char(4) Not Null,
FactDate Char(10) Not Null,
Primary Key (CLiId, FactId),
Foreign Key (CliId) References Client
) ;
Create Table Suivi
(SuiviId Char(4) Not Null,
CliId Char(4) Not Null,
FactId Char(4),
Primary Key (SuiviId),
Foreign Key (CliId, FactId) References Facture
) ;
Insert Into Client Values ('cli1', 'Client Un') ;
Insert Into Client Values ('cli2', 'Client Deux') ;
Insert Into Facture Values ('cli1', 'Fac1', '2008-03-02') ;
Insert Into Suivi Values ('Sv01', 'cli1', 'Fac1') ;
Insert Into Suivi Values ('Sv02', 'cli7', null) ;
Select * From Suivi |
Partager