| id |
int(10)
|
|
|
|
| company_id |
int(10)
|
|
|
|
| branch_id |
int(10)
|
|
|
|
| academic_year_id |
int(10)
|
|
|
|
| exam_type |
enum('unit_test', 'monthly_test', 'mid_term', 'annual', 'board_exam', 'internal', 'practical')
|
utf8mb4_unicode_ci
|
|
|
| exam_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| exam_date |
date
|
|
|
|
| class_id |
int(10)
|
|
|
|
| section_id |
int(10)
|
|
|
|
| subject_id |
int(10)
|
|
|
|
| available_working_days |
int(10)
|
|
|
|
| holiday_count |
int(10)
|
|
|
|
| affected_working_days |
int(10)
|
|
|
|
| syllabus_completion_percentage |
decimal(8,2)
|
|
|
|
| pending_chapters |
int(10)
|
|
|
|
| revision_days_needed |
int(10)
|
|
|
|
| revision_window_days |
int(10)
|
|
|
|
| exam_readiness_percentage |
decimal(8,2)
|
|
|
|
| risk_score |
decimal(8,2)
|
|
|
|
| readiness_status |
enum('not_ready', 'partially_ready', 'ready', 'excellent')
|
utf8mb4_unicode_ci
|
|
|
| risk_level |
enum('low', 'medium', 'high', 'critical')
|
utf8mb4_unicode_ci
|
|
|
| alignment_status |
enum('draft', 'aligned', 'needs_revision', 'approved', 'locked')
|
utf8mb4_unicode_ci
|
|
|
| holiday_impact_note |
text
|
utf8mb4_unicode_ci
|
|
|
| revision_window_note |
text
|
utf8mb4_unicode_ci
|
|
|
| ai_generated |
tinyint(1)
|
|
|
|
| ai_readiness_note |
text
|
utf8mb4_unicode_ci
|
|
|
| ai_recommendation |
text
|
utf8mb4_unicode_ci
|
|
|
| remarks |
text
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('active', 'inactive')
|
utf8mb4_unicode_ci
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_by |
int(10)
|
|
|
|
| updated_by |
int(10)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|