| id |
bigint(20)
|
|
|
|
| question_id |
bigint(20)
|
|
|
|
| version_no |
int(10)
|
|
|
|
| subject_id |
bigint(20)
|
|
|
|
| chapter_id |
bigint(20)
|
|
|
|
| topic_id |
bigint(20)
|
|
|
|
| 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)
|
|
|
|
| question_text |
longtext
|
utf8mb4_unicode_ci
|
|
|
| question_html |
longtext
|
utf8mb4_unicode_ci
|
|
|
| question_image_path |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| positive_marks |
decimal(8,2)
|
|
|
|
| negative_marks |
decimal(8,2)
|
|
|
|
| explanation_text |
longtext
|
utf8mb4_unicode_ci
|
|
|
| explanation_html |
longtext
|
utf8mb4_unicode_ci
|
|
|
| explanation_image_path |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| explanation_video_url |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| answer_mode |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| numeric_answer_min |
decimal(20,8)
|
|
|
|
| numeric_answer_max |
decimal(20,8)
|
|
|
|
| version_status |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| change_note |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| authored_by |
bigint(20)
|
|
|
|
| approved_by |
bigint(20)
|
|
|
|
| approved_at |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| delete_status |
tinyint(1)
|
|
|
|