CREATE TABLE groupid
(
groupid int(4) NOT NULL auto_increment,
description varchar varchar(100) NOT NULL
PRIMARY KEY ( groupid)
);
CREATE TABLE user
(
userid int(4) NOT NULL auto_increment,
firstname varchar(100) NOT NULL,
lastname varchar(100) NOT NULL,
emailid varchar(100) NOT NULL UNIQUE,
password varchar(50) NOT NULL,
groupid int(8) not null,
PRIMARY KEY ( userid)
);
CREATE TABLE Event
(
Eventid int(4) NOT NULL AUTO_INCREMENT,
Description varchar (255) NOT NULL,
Publish varchar(20) NOT NULL,
Questionid int(4) NOT NULL,
Targetgroup varchar(70) NOT NULL,
Anonymous varchar(15) NOT NULL,
PRIMARY KEY ( Eventid )
);
CREATE TABLE Questionid
(
Questionid int(4) NOT NULL AUTO_INCREMENT,
Description varchar(70) NOT NULL,
Type varchar(70) NOT NULL,
PRIMARY KEY (Questionid)
);
CREATE TABLE QuestionBank
(
Qserialno int(3) NOT NULL AUTO_INCREMENT,
Questionid int(4) NOT NULL ,
Questionname varchar(255) NOT NULL,
OptionA varchar(50),
OptionB varchar(50),
OptionC varchar(50),
OptionD varchar(50),
Other varchar(50),
Answer varchar(1),
PRIMARY KEY (Qserialno, Questionid )
);
CREATE TABLE Final
(
Userid int(4) ,
Eventid int(4) NOT NULL,
Questionid int(4) NOT NULL,
Qserialno int(3) NOT NULL,
Answer varchar(8) NOT NULL
);