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