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)
); |
