/SQL/Database schema for mcqs type exam in sql

Database schema for mcqs type exam in sql

CREATE  TABLE users (
  id int(10) auto_increment primary key,
  username VARCHAR(45) NOT NULL ,
  password VARCHAR(45) NOT NULL ,
  enabled TINYINT NOT NULL DEFAULT 1
);

CREATE TABLE questions (
    id int(10) auto_increment primary key,
    question varchar(800) NOT NULL,
    right_option int(10) NOT NULL references options(id)
);

CREATE TABLE options (
    id int(10) auto_increment primary key,
    question_id int(10) NOT NULL references questions(id),
    `option` varchar(150) NOT NULL
);

CREATE TABLE exam_details (
    id int(10) auto_increment primary key,
    username varchar(45) NOT NULL references users(username),
    date_of_exam date not null,
    exam_result varchar(10) NOT NULL, -- PASS/FAIL
    exam_score int(10) NOT NULL,      -- e.g. 40 
    no_of_questions int(10) NOT NULL  -- total no. of questions in the test
);     

CREATE TABLE user_answers (
    id int(10) auto_increment primary key,
    userId int(10) NOT NULL references users(id),
    question_id int(10) NOT NULL references questions(id),
    answer int(10) NOT NULL references options(id)
);

Source: stackoverflow.com

Similar codes

0 vote106 views2 answers
Alter table add multiple columns mysql
SQL
0 vote106 views1 answer
Sql tabelle erstellen
SQL
0 vote100 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
2 votes108 views2 answers
Mysql bidirectional composite primary key
SQL
1 vote100 views1 answer
How much every mysql database record takes from diskspace
SQL
1 vote105 views2 answers
End mysql command
SQL
1 vote112 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
7 votes104 views1 answer
Set sequence value oracle
SQL
0 vote104 views1 answer
Mariadb current date plus 1 day
SQL
0 vote100 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL