CTRL+C pour copier, CTRL+V pour coller
2
login VARCHAR PRIMARY KEY
5
CREATE TABLE questionnaire (
6
name VARCHAR PRIMARY KEY
12
questionnaire VARCHAR REFERENCES questionnaire(name),
13
PRIMARY KEY (number, questionnaire)
20
value INTEGER CHECK (value=0 OR value=-2 OR value=-1 OR value=1 OR value=2),
22
PRIMARY KEY (question,questionnaire,login),
23
FOREIGN KEY (login) REFERENCES user(login),
24
FOREIGN KEY (question,questionnaire) REFERENCES question(number,questionnaire)
CREATE TABLE user (
login VARCHAR PRIMARY KEY
);
CREATE TABLE questionnaire (
name VARCHAR PRIMARY KEY
);
CREATE TABLE question (
number INTEGER,
label VARCHAR,
questionnaire VARCHAR REFERENCES questionnaire(name),
PRIMARY KEY (number, questionnaire)
);
CREATE TABLE answer (
question INTEGER,
questionnaire VARCHAR,
login VARCHAR,
value INTEGER CHECK (value=0 OR value=-2 OR value=-1 OR value=1 OR value=2),
comment VARCHAR,
PRIMARY KEY (question,questionnaire,login),
FOREIGN KEY (login) REFERENCES user(login),
FOREIGN KEY (question,questionnaire) REFERENCES question(number,questionnaire)
);