1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| CREATE TABLE CL_client(
CL_ident INT AUTO_INCREMENT,
CL_nom VARCHAR(50) NOT NULL,
CL_prenom VARCHAR(50) NOT NULL,
PRIMARY KEY(CL_ident)
);
CREATE TABLE GT_gite(
GT_ident INT AUTO_INCREMENT,
GT_code CHAR(6) NOT NULL,
GT_nom VARCHAR(100) NOT NULL,
PRIMARY KEY(GT_ident),
UNIQUE(GT_code)
);
CREATE TABLE RS_reserver(
GT_ident INT,
CA_date DATE,
RS_dtfin DATE NOT NULL,
CL_ident INT NOT NULL,
PRIMARY KEY(GT_ident, CA_date),
FOREIGN KEY(GT_ident) REFERENCES GT_gite(GT_ident),
FOREIGN KEY(CL_ident) REFERENCES CL_client(CL_ident)
); |
Partager