| id |
bigint(20)
|
|
|
|
| company_id |
bigint(20)
|
|
|
|
| branch_id |
bigint(20)
|
|
|
|
| unit_id |
bigint(20)
|
|
|
|
| subject_id |
bigint(20)
|
|
|
|
| chapter_id |
bigint(20)
|
|
|
|
| topic_id |
bigint(20)
|
|
|
|
| question_code |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| question_type |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| difficulty_level |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| language_code |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| question_source |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| source_name |
varchar(180)
|
utf8mb4_unicode_ci
|
|
|
| source_year |
smallint(5)
|
|
|
|
| current_version_no |
int(10)
|
|
|
|
| current_version_id |
bigint(20)
|
|
|
|
| workflow_status |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| approved_by |
bigint(20)
|
|
|
|
| approved_at |
datetime
|
|
|
|
| is_active |
tinyint(1)
|
|
|
|
| created_by |
bigint(20)
|
|
|
|
| updated_by |
bigint(20)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| delete_status |
tinyint(1)
|
|
|
|