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 CLI (
IDCLIENTS INTEGER NOT NULL
);
ALTER TABLE CLI ADD CONSTRAINT PK_CLI PRIMARY KEY (IDCLIENTS);
CREATE TABLE VISITES (
JOUR INTEGER NOT NULL,
HEUREDEB INTEGER NOT NULL,
HEUREFIN INTEGER NOT NULL
);
ALTER TABLE VISITES ADD CONSTRAINT PK_VISITES PRIMARY KEY (JOUR, HEUREDEB, HEUREFIN);
CREATE TABLE VISCL (
IDCLIENTS INTEGER NOT NULL,
JOUR INTEGER NOT NULL,
HEUREDEB INTEGER NOT NULL,
HEUREFIN INTEGER NOT NULL
);
ALTER TABLE VISCL
ADD CONSTRAINT PK_VISCL PRIMARY KEY (IDCLIENTS, JOUR, HEUREDEB, HEUREFIN);
ALTER TABLE VISCL
ADD CONSTRAINT FK_CLI FOREIGN KEY (IDCLIENTS) REFERENCES CLI (IDCLIENTS);
ALTER TABLE VISCL
ADD CONSTRAINT FK_VISITES FOREIGN KEY (JOUR, HEUREDEB, HEUREFIN) REFERENCES VISITES (JOUR, HEUREDEB, HEUREFIN); |
Partager