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
|
CREATE TABLE Utilisateur(
Id INT IDENTITY(1,1) NOT NULL,
Nom VARCHAR(50) NOT NULL,
Prenom VARCHAR(50) NOT NULL,
Email VARCHAR(50) NOT NULL,
Password VARCHAR(50) NOT NULL,
CONSTRAINT PK_Utilisateur Primary Key(Id),
CONSTRAINT UN_Utilisateur Unique(Email)
);
CREATE TABLE Sondage(
Id INT IDENTITY(1,1) NOT NULL,
Nom VARCHAR(50) NOT NULL,
Date_ouverture DATETIME NOT NULL,
Date_fermeture DATETIME NOT NULL,
Nb_participants INT NOT NULL DEFAULT 0,
Utilisateur_Id INT NOT NULL,
CONSTRAINT PK_Sondage PRIMARY KEY(Id),
CONSTRAINT FK_Sondage FOREIGN KEY(Utilisateur_Id) REFERENCES Utilisateur(Id),
CONSTRAINT UN_Sondage UNIQUE(Nom)
);
CREATE TABLE Question(
Id INT IDENTITY(1,1) NOT NULL,
Phrase VARCHAR(250) NOT NULL,
Sondage_Id INT NOT NULL,
CONSTRAINT PK_Question PRIMARY KEY(Id),
CONSTRAINT FK_Question FOREIGN KEY(Sondage_Id) REFERENCES Sondage(Id)
);
CREATE TABLE Reponse(
Id INT IDENTITY(1,1) NOT NULL,
Phrase VARCHAR(250) NOT NULL,
Question_Id INT NOT NULL,
Nb_Vote INT NOT NULL DEFAULT 0,
CONSTRAINT PK_Reponse PRIMARY KEY(Id),
CONSTRAINT FK_Reponse FOREIGN KEY(Question_Id) REFERENCES Question(Id)
); |
Partager