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
| CREATE TABLE MA_materiel(
MA_ident INT IDENTITY,
MA_reference CHAR(8) NOT NULL,
MA_description VARCHAR(50) NOT NULL,
PRIMARY KEY(MA_ident),
UNIQUE(MA_reference)
);
CREATE TABLE BO_boitier(
MA_ident INT,
PRIMARY KEY(MA_ident),
FOREIGN KEY(MA_ident) REFERENCES MA_materiel(MA_ident)
);
CREATE TABLE CA_carte(
MA_ident INT,
CA_RAM SMALLINT NOT NULL,
PRIMARY KEY(MA_ident),
FOREIGN KEY(MA_ident) REFERENCES MA_materiel(MA_ident)
);
CREATE TABLE AL_alim(
MA_ident INT,
AL_puissance DECIMAL(5,2) NOT NULL,
AL_tension_entree DECIMAL(5,2) NOT NULL,
AL_tension_sortie DECIMAL(5,2) NOT NULL,
PRIMARY KEY(MA_ident),
FOREIGN KEY(MA_ident) REFERENCES MA_materiel(MA_ident)
);
CREATE TABLE EQ_equiper(
MA_ident_composé INT,
MA_ident_composant INT,
EQ_quantite SMALLINT NOT NULL,
PRIMARY KEY(MA_ident_composé, MA_ident_composant),
FOREIGN KEY(MA_ident_composé) REFERENCES MA_materiel(MA_ident),
FOREIGN KEY(MA_ident_composant) REFERENCES MA_materiel(MA_ident)
); |
Partager