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 42 43
| CREATE TABLE UT_utilisateur(
UT_ident COUNTER,
UT_nom VARCHAR(50) NOT NULL,
UT_prenom VARCHAR(50) NOT NULL,
PRIMARY KEY(UT_ident)
);
CREATE TABLE VD_video(
VD_ident COUNTER,
VD_titre VARCHAR(255) NOT NULL,
VD_annee CHAR(4) NOT NULL,
PRIMARY KEY(VD_ident)
);
CREATE TABLE EX_exemplaire(
UT_ident INT,
VD_ident INT,
EX_ident COUNTER,
EX_code_barre CHAR(13) NOT NULL UNIQUE,
PRIMARY KEY(UT_ident, VD_ident, EX_ident),
FOREIGN KEY(UT_ident) REFERENCES UT_utilisateur(UT_ident),
FOREIGN KEY(VD_ident) REFERENCES VD_video(VD_ident)
);
CREATE TABLE QS_question(
VD_ident INT,
QS_ident COUNTER,
QS_libelle VARCHAR(255) NOT NULL,
PRIMARY KEY(VD_ident, QS_ident),
FOREIGN KEY(VD_ident) REFERENCES VD_video(VD_ident)
);
CREATE TABLE RR_reponse(
UT_ident INT,
VD_ident INT,
QS_ident INT,
RR_ident COUNTER,
RR_libelle VARCHAR(255),
PRIMARY KEY(UT_ident, VD_ident, QS_ident, RR_ident),
FOREIGN KEY(UT_ident) REFERENCES UT_utilisateur(UT_ident),
FOREIGN KEY(VD_ident, QS_ident) REFERENCES QS_question(VD_ident, QS_ident)
FOREIGN KEY(UT_ident, VD_ident) REFERENCES EX_exemplaire(UT_ident, VD_ident)
); |
Partager