CREATE TABLE USERS (
id SERIAL,
first_name varchar(100),
last_name varchar(100),
email varchar(100),
college varchar(200),
branch varchar(100),
city varchar(100),
password varchar(100),
password_confirmation varchar(100),
phone_number varchar(100),
batch varchar(100),
role varchar(50),
created_at timestamptz,
year_of_passing varchar(4),
PRIMARY KEY(id));

CREATE TABLE sessions(
id int,
start_time timestamptz,
end_time timestamptz,
user_id int,
CONSTRAINT session_id_key FOREIGN KEY (user_id)
REFERENCES users (id),
auth_token varchar(320),
UNIQUE (auth_token));

CREATE TABLE SECTIONS (
id int,
name varchar(100),
PRIMARY KEY(id));

CREATE TABLE QUESTIONS (
id int,
title text,
option_1 varchar(1000),
option_2 varchar(1000),
option_3 varchar(1000),
option_4 varchar(1000),
answer varchar(1000),
section_id int,
CONSTRAINT section_id_key FOREIGN KEY(section_id)
REFERENCES sections(id),
PRIMARY KEY(id));

CREATE TABLE RESULTS (
id SERIAL,
user_id int,
CONSTRAINT session_section_key FOREIGN KEY(user_id)
REFERENCES users(id),
first_name varchar(100),
last_name varchar(100),
email varchar(100),
phone_number varchar(100),
city varchar(100),
batch varchar(100),
section_1 int DEFAULT 0,
section_2 int DEFAULT 0,
section_3 int DEFAULT 0,
total_score int DEFAULT 0,
start_time timestamptz,
end_time timestamptz,
test_finished boolean DEFAULT 'no'
);

{"firstname":"steve","lastname":"jobs","email":"[email protected]","password":"password","password_confirmation":"password","Branch":"Information Science","Year_of_passing":"2014","Phone_number":"9916854300","Auth_token":"039d51057a2c6125ba53fe6d90daee31837fbc76145dad6186f036cf1d2"}

{
	"Success": "true",
	"Message": "User created Successfully!",
	"User": {
		"Id": 1,
		"Firstname": "steve",
		"Lastname": "jobs",
		"Email": "[email protected]",
		"Password": "password",
		"Password_confirmation": "password",
		"Branch": "Information Science",
		"Year_of_passing": "2014",
		"Phone_number": "9916854300",
		"Auth_token": "039d51057a2c6125ba53fe6d90daee31837fbc76145dad6186f036cf1d2"
	},
	"Session": {
		"SessionId": 1,
		"StartTime": "2016-03-04T00:59:49.784724111+05:30"
	}
}

{"SectionId":1, "UserId":12, "Questions":[{"QuestionId":1,"Answer":"a"},{"QuestionId":2,"Answer":"a"},{"QuestionId":3,"Answer":"a"},{"QuestionId":4,"Answer":"a"},{"QuestionId":5,"Answer":"a"},{"QuestionId":6,"Answer":"a"},{"QuestionId":7,"Answer":"a"},{"QuestionId":8,"Answer":"a"},{"QuestionId":9,"Answer":"a"},{"QuestionId":10,"Answer":"a"},{"QuestionId":11,"Answer":"a"},{"QuestionId":12,"Answer":"a"}]}

{
	"Section": 1,
	"TotalQuestions": 20,
	"Score": 0
}