Online Test Database Schema

I want to create Online Test Platform in php. i am attaching Database schema for your reference . I would like to put Single Choice , Multiple Choice and Matrix type question. Please suggest is required any changes in below schema . question_details

Fields
Field Type qid int(2) PRI

question varchar(500)

qoption1 varchar(500)

qoption2 varchar(500)

qoption3 varchar(500)

qoption4 varchar(500)

qlevel varchar(50)

qright varchar(50)

qright_marks varchar(50)

qwrong_marks varchar(50)

qtype int(11)

Indexes
Table Non Key unique name

question_details 0 PRIMARY question_details 1
qtype Foreign Key Relationships FK Id Reference Table Source Column qtype question_type qtype

question_type

Fields
Field Type id int(11) PRI

qid int(2)

question_type varchar(50)

Indexes
Table Non Key unique name

question_type 0 PRIMARY

subject_details

Fields
Field Type Collation id int(11) (NULL)

Testid int(8) (NULL)

subjects varchar(50)

qfrom int(5) (NULL)

qto int(5) (NULL)

Indexes
Table Non Key unique name

subject_details 0 PRIMARY subject_details 1 Testid

Foreign Key Relationships
FK Id Reference Table Testid test_details

test_details

Fields Field Type testid int(3)

test_code varchar(50)

test_name varchar(100)

test_stream int(5)

test_duration int(3)

total_question int(3)

test_max_marks int(3)

test_start_date timestamp

test_end_date timestamp

Indexes

Table Non unique

test_details 0 test_details 1 Foreign Key Relationships FK Id Reference Table testStream test_stream

test_question_details

Fields Field Type Collation id int(2)

testid int(3)

qid int(2)

Indexes
Table Non Key unique name

test_question_details 0 PRIMARY test_question_details 1 testsid test_question_details 1 qeustionid

Foreign Key Relationships
FK Id Reference Table Source Column Target Column qeustionid question_details qid qid

testsid test_details testid testid

test_stream

Fields Field Type
id int(11)

streamid int(2)

stream_name varchar(50)

Indexes
Table Non Key unique name
test_stream 0 PRIMARY