|
id
|
bigint(20) unsigned
|
|
|
|
|
company_id
|
bigint(20) unsigned
|
|
|
0
|
|
branch_id
|
bigint(20) unsigned
|
|
|
0
|
|
unit_id
|
bigint(20) unsigned
|
|
|
0
|
|
academic_year_id
|
bigint(20) unsigned
|
|
|
0
|
|
exam_profile_id
|
bigint(20) unsigned
|
|
|
|
|
test_code
|
varchar(80)
|
|
|
|
|
test_name
|
varchar(180)
|
|
|
|
|
test_type
|
varchar(40)
|
|
|
MOCK_TEST
|
|
description
|
text
|
|
|
|
|
instructions
|
longtext
|
|
|
|
|
start_datetime
|
datetime
|
|
|
|
|
end_datetime
|
datetime
|
|
|
|
|
duration_minutes
|
int(10) unsigned
|
|
|
180
|
|
total_questions
|
int(10) unsigned
|
|
|
0
|
|
total_marks
|
decimal(12,2)
|
|
|
0.00
|
|
max_attempts
|
int(10) unsigned
|
|
|
1
|
|
result_publish_mode
|
varchar(30)
|
|
|
IMMEDIATE
|
|
result_publish_at
|
datetime
|
|
|
|
|
randomize_questions
|
tinyint(1)
|
|
|
0
|
|
randomize_options
|
tinyint(1)
|
|
|
0
|
|
allow_resume
|
tinyint(1)
|
|
|
1
|
|
status
|
varchar(30)
|
|
|
DRAFT
|
|
published_by
|
bigint(20) unsigned
|
|
|
0
|
|
published_at
|
datetime
|
|
|
|
|
created_by
|
bigint(20) unsigned
|
|
|
0
|
|
updated_by
|
bigint(20) unsigned
|
|
|
0
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
current_timestamp()
|
|
delete_status
|
tinyint(1)
|
|
|
0
|