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
| CREATE TABLE GA_garantie(
GA_ident INT IDENTITY,
GA_code CHAR(6) NOT NULL,
GA_libelle VARCHAR(128) NOT NULL,
PRIMARY KEY(GA_ident),
UNIQUE(GA_code)
);
CREATE TABLE OP_option(
GA_ident INT,
OP_seq SMALLINT,
OP_libelle VARCHAR(50) NOT NULL,
PRIMARY KEY(GA_ident, OP_seq),
FOREIGN KEY(GA_ident) REFERENCES GA_garantie(GA_ident)
);
CREATE TABLE DE_devis(
DE_ident INT IDENTITY,
DE_numero CHAR(8) NOT NULL,
DE_date DATE NOT NULL,
GA_ident INT NOT NULL,
PRIMARY KEY(DE_ident),
UNIQUE(DE_numero),
FOREIGN KEY(GA_ident) REFERENCES GA_garantie(GA_ident)
);
CREATE TABLE SE_selectionner(
DE_ident INT,
GA_ident INT,
OP_seq SMALLINT,
PRIMARY KEY(DE_ident, GA_ident, OP_seq),
FOREIGN KEY(DE_ident) REFERENCES DE_devis(DE_ident),
FOREIGN KEY(GA_ident, OP_seq) REFERENCES OP_option(GA_ident, OP_seq)
); |
Partager