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
| CREATE TABLE CL_client(
CL_ident INT IDENTITY,
CL_nom VARCHAR(50) NOT NULL,
PRIMARY KEY(CL_ident)
);
CREATE TABLE AS_associer(
CL_ident_succursale INT,
CL_ident_principal INT NOT NULL,
PRIMARY KEY(CL_ident_succursale),
FOREIGN KEY(CL_ident_succursale) REFERENCES CL_client(CL_ident),
FOREIGN KEY(CL_ident_principal) REFERENCES CL_client(CL_ident)
);
insert into CL_client(CL_nom)
values ('principal P1')
, ('succursale P1-S1')
, ('simple P1-S1-01')
, ('simple P1-S1-02')
, ('succursale P1-S2')
, ('simple P1-S2-01')
, ('principal P2')
, ('succursale P2-S2')
, ('simple P2-S2-01')
, ('simple P2-s2-02')
, ('simple P2-S2-03')
;
select * from CL_client
;
insert into AS_associer (CL_ident_succursale, CL_ident_principal)
values (2, 1)
, (3, 2)
, (4, 2)
, (5, 1)
, (6, 5)
, (8, 7)
, (9, 8)
, (10, 8)
, (11, 8)
;
select * from AS_associer
; |
Partager