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
|
use tempdb ;
create table client
(
codeclient integer not null
, compte integer not null
, CONSTRAINT client_PK PRIMARY KEY (codeclient)
) ;
create table facture
(
codeclient integer not null
, NumeroFacture integer not null
, CONSTRAINT facture_PK PRIMARY KEY (NumeroFacture)
, CONSTRAINT facture_client_FK FOREIGN KEY (codeclient)
REFERENCES client(codeclient)
) ;
insert into client (codeclient, compte) values (1, 12345) ;
insert into client (codeclient, compte) values (2, 23456) ;
insert into client (codeclient, compte) values (3, 34567) ;
insert into facture (codeclient, NumeroFacture) values (1, 10001) ;
insert into facture (codeclient, NumeroFacture) values (1, 10002) ;
insert into facture (codeclient, NumeroFacture) values (1, 10003) ;
insert into facture (codeclient, NumeroFacture) values (2, 20001) ;
insert into facture (codeclient, NumeroFacture) values (2, 20002) ;
insert into facture (codeclient, NumeroFacture) values (2, 20003) ;
insert into facture (codeclient, NumeroFacture) values (2, 20004) ; |
Partager