Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v edbroad_ai_sumanth academic_activity_assignment_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* plan_type : enum('activity','assignment','project','homework','practical','assessment')
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* teacher_id : int(10) unsigned
* assigned_date : date
* due_date : date
* plan_title : varchar(255)
* topic_focus : varchar(255)
* total_students : int(10) unsigned
* submitted_students : int(10) unsigned
* pending_students : int(10) unsigned
* submission_percentage : decimal(8,2)
* estimated_workload_minutes : int(10) unsigned
* deadline_risk_score : decimal(8,2)
* risk_level : enum('low','medium','high','critical')
* plan_status : enum('draft','assigned','in_progress','submitted','reviewed','closed','overdue')
* instruction_note : text
* resource_note : text
* ai_generated : tinyint(1)
* ai_workload_note : text
* ai_recommendation : text
* remarks : text
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_activity_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* activity_title : varchar(220)
* activity_type : enum('academic_activity','club_activity','project_work','seminar','competition','field_visit','lab_activity','celebration','other')
* activity_date : date
* start_time : time
* end_time : time
* class_ids : text
* section_ids : text
* subject_ids : text
* teacher_ids : text
* objective : text
* expected_outcome : text
* approval_status : enum('draft','submitted','approved','rejected','completed','cancelled')
* ai_suggestion_note : text
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_ai_gap_detection_suggestions
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* teacher_id : int(10) unsigned
* source_module : enum('year_planner','monthly_planner','weekly_planner','daily_lesson_planner','syllabus_planner','teacher_wise_planner','class_wise_planner','revision_remedial_planner','exam_preparation_planner','manual_review')
* source_record_id : int(10) unsigned
* gap_title : varchar(220)
* gap_category : enum('syllabus_delay','low_completion','teacher_workload','class_readiness','exam_readiness','learning_gap','approval_delay','attendance_impact','manual_gap')
* gap_description : text
* detected_date : date
* target_completion_date : date
* severity_level : enum('low','medium','high','critical')
* priority_score : decimal(6,2)
* impact_area : enum('student','teacher','class','subject','exam','management')
* current_value : decimal(8,2)
* expected_value : decimal(8,2)
* gap_value : decimal(8,2)
* suggested_action : text
* auto_action_type : enum('create_revision_plan','create_remedial_plan','create_extra_class','notify_teacher','notify_hod','escalate_approval','monitor_only')
* suggested_owner_role : varchar(80)
* suggested_owner_id : int(10) unsigned
* ai_confidence_score : decimal(6,2)
* ai_reasoning_note : text
* ai_recommendation : text
* action_status : enum('open','accepted','in_progress','completed','ignored','escalated')
* action_taken_note : text
* action_taken_at : datetime
* approval_status : enum('draft','submitted','approved','rejected','locked')
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_assignment_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* teacher_id : int(10) unsigned
* syllabus_planner_id : int(10) unsigned
* assignment_title : varchar(220)
* assignment_type : enum('homework','classwork','project','worksheet','revision_test','practice_set')
* assigned_date : date
* due_date : date
* instructions : text
* expected_outcome : text
* submission_required : tinyint(1)
* ai_generated : tinyint(1)
* ai_assignment_note : text
* status : enum('planned','assigned','completed','cancelled')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_audit_logs
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* module_name : varchar(100)
* record_id : int(10) unsigned
* action_type : varchar(100)
* old_data : longtext
* new_data : longtext
* remarks : text
* created_by : int(10) unsigned
* created_at : datetime
v edbroad_ai_sumanth academic_boards
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* board_name : varchar(150)
* board_code : varchar(50)
* description : text
* display_order : int(11)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_calendar
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* event_title : varchar(180)
* event_type : varchar(60)
* start_date : date
* end_date : date
* applicable_to : varchar(60)
* description : text
* is_holiday : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_calendar_events
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* term_id : int(10) unsigned
* event_title : varchar(200)
* event_type : enum('holiday','exam','activity','meeting','vacation','working_day','result','other')
* start_date : date
* end_date : date
* is_working_day : tinyint(1)
* applies_to : enum('all','class','section')
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* description : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_chapter_completion_tracking
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* syllabus_planner_id : int(10) unsigned
* daily_lesson_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* teacher_id : int(10) unsigned
* tracking_date : date
* before_completion_percentage : decimal(5,2)
* after_completion_percentage : decimal(5,2)
* periods_used : int(10) unsigned
* remaining_periods : int(10) unsigned
* completion_note : text
* evidence_file : varchar(255)
* verified_by : int(10) unsigned
* verified_at : datetime
* verification_status : enum('pending','verified','rejected')
* verification_note : text
* ai_progress_note : text
* ai_delay_prediction : text
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_classes
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* board_id : int(10) unsigned
* division_id : int(10) unsigned
* stream_id : int(10) unsigned
* class_name : varchar(150)
* class_code : varchar(50)
* display_order : int(11)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_class_section_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* year_planner_id : int(10) unsigned
* monthly_planner_id : int(10) unsigned
* weekly_planner_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* planner_title : varchar(180)
* target_description : text
* total_subjects : int(10) unsigned
* total_chapters : int(10) unsigned
* completed_chapters : int(10) unsigned
* pending_chapters : int(10) unsigned
* syllabus_completion_percentage : decimal(5,2)
* risk_level : enum('none','low','medium','high','critical')
* risk_reason : text
* ai_summary : text
* ai_recommendation : text
* approval_status : enum('draft','submitted','approved','rejected','locked')
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_class_wise_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* teacher_id : int(10) unsigned
* plan_month : varchar(7)
* total_subjects : int(10) unsigned
* total_chapters : int(10) unsigned
* completed_chapters : int(10) unsigned
* pending_chapters : int(10) unsigned
* delayed_chapters : int(10) unsigned
* planned_periods : int(10) unsigned
* completed_periods : int(10) unsigned
* pending_periods : int(10) unsigned
* revision_required_periods : int(10) unsigned
* remedial_required_periods : int(10) unsigned
* extra_class_required_periods : int(10) unsigned
* syllabus_completion_percentage : decimal(5,2)
* class_readiness_score : decimal(6,2)
* risk_level : enum('low','medium','high','critical')
* planner_status : enum('on_track','attention_needed','behind_schedule','critical_delay')
* class_scope : text
* coordinator_remarks : text
* ai_generated : tinyint(1)
* ai_class_summary : text
* ai_gap_note : text
* ai_recommendation : text
* approval_status : enum('draft','submitted','approved','rejected','locked')
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_daily_lesson_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* teacher_id : int(10) unsigned
* year_planner_id : int(10) unsigned
* monthly_planner_id : int(10) unsigned
* weekly_planner_id : int(10) unsigned
* syllabus_planner_id : int(10) unsigned
* lesson_date : date
* period_no : int(10) unsigned
* lesson_title : varchar(220)
* lesson_objective : text
* teaching_method : varchar(160)
* teaching_aid : text
* planned_content : text
* actual_content : text
* homework_given : text
* assignment_given : text
* execution_status : enum('planned','completed','partially_completed','not_taken','substituted','postponed','cancelled')
* completion_percentage : decimal(5,2)
* teacher_execution_note : text
* student_response_note : text
* ai_generated : tinyint(1)
* ai_lesson_summary : text
* ai_followup_suggestion : text
* approval_status : enum('draft','submitted','approved','rejected','locked')
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_divisions
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* division_name : varchar(150)
* division_code : varchar(50)
* description : text
* display_order : int(11)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_exam_calendar_alignment
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* exam_type : enum('unit_test','monthly_test','mid_term','annual','board_exam','internal','practical')
* exam_name : varchar(255)
* exam_date : date
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* available_working_days : int(10) unsigned
* holiday_count : int(10) unsigned
* affected_working_days : int(10) unsigned
* syllabus_completion_percentage : decimal(8,2)
* pending_chapters : int(10) unsigned
* revision_days_needed : int(10) unsigned
* revision_window_days : int(10) unsigned
* exam_readiness_percentage : decimal(8,2)
* risk_score : decimal(8,2)
* readiness_status : enum('not_ready','partially_ready','ready','excellent')
* risk_level : enum('low','medium','high','critical')
* alignment_status : enum('draft','aligned','needs_revision','approved','locked')
* holiday_impact_note : text
* revision_window_note : text
* ai_generated : tinyint(1)
* ai_readiness_note : text
* ai_recommendation : text
* remarks : text
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_exam_planner_alignment
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* exam_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* exam_date : date
* syllabus_required_percentage : decimal(5,2)
* current_syllabus_percentage : decimal(5,2)
* pending_percentage : decimal(5,2)
* days_remaining : int(11)
* working_days_remaining : int(11)
* periods_remaining : int(11)
* revision_required : tinyint(1)
* revision_days_required : int(10) unsigned
* risk_level : enum('none','low','medium','high','critical')
* risk_summary : text
* ai_generated : tinyint(1)
* ai_exam_readiness_score : decimal(6,2)
* ai_action_plan : text
* status : enum('open','on_track','at_risk','critical','closed')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_exam_preparation_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* teacher_id : int(10) unsigned
* exam_name : varchar(180)
* exam_type : enum('unit_test','monthly_test','mid_term','pre_final','final_exam','board_exam','practice_exam')
* preparation_title : varchar(220)
* preparation_start_date : date
* preparation_end_date : date
* exam_date : date
* syllabus_covered_percentage : decimal(5,2)
* revision_completed_percentage : decimal(5,2)
* question_bank_completed_percentage : decimal(5,2)
* mock_test_completed_count : int(10) unsigned
* important_chapters : text
* weak_chapters : text
* revision_strategy : text
* practice_plan : text
* target_average_score : decimal(5,2)
* current_average_score : decimal(5,2)
* expected_average_score : decimal(5,2)
* readiness_score : decimal(6,2)
* risk_level : enum('low','medium','high','critical')
* planner_status : enum('not_started','in_progress','ready','attention_needed','critical')
* ai_generated : tinyint(1)
* ai_exam_summary : text
* ai_gap_note : text
* ai_recommendation : text
* ai_priority_score : decimal(6,2)
* teacher_remarks : text
* hod_remarks : text
* approval_status : enum('draft','submitted','approved','rejected','locked')
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_extra_class_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* teacher_id : int(10) unsigned
* syllabus_planner_id : int(10) unsigned
* suggested_date : date
* suggested_start_time : time
* suggested_end_time : time
* suggestion_reason : enum('pending_syllabus','holiday_impact','exam_near','revision_needed','low_performance','teacher_request','principal_request','ai_recommended')
* available_slot_source : enum('manual','timetable_gap','free_period','after_school','sunday','special_day')
* ai_generated : tinyint(1)
* ai_reason : text
* ai_priority_score : decimal(6,2)
* approval_status : enum('suggested','approved','rejected','scheduled','completed','cancelled')
* approved_by : int(10) unsigned
* approved_at : datetime
* approval_remarks : text
* notification_status : enum('not_sent','drafted','sent','failed')
* notification_message : text
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_holiday_impact_analysis
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* calendar_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* teacher_id : int(10) unsigned
* impacted_date : date
* lost_periods : int(10) unsigned
* affected_chapters : text
* impact_level : enum('low','medium','high','critical')
* impact_summary : text
* recovery_required : tinyint(1)
* suggested_recovery_periods : int(10) unsigned
* suggested_recovery_dates : text
* ai_generated : tinyint(1)
* ai_adjustment_plan : text
* status : enum('open','adjusted','ignored','closed')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_monthly_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* year_planner_id : int(10) unsigned
* plan_year : int(10) unsigned
* plan_month : tinyint(3) unsigned
* month_name : varchar(30)
* month_start_date : date
* month_end_date : date
* total_days : int(10) unsigned
* working_days : int(10) unsigned
* holiday_days : int(10) unsigned
* exam_days : int(10) unsigned
* revision_days : int(10) unsigned
* activity_days : int(10) unsigned
* monthly_focus : varchar(180)
* target_summary : text
* ai_generated : tinyint(1)
* ai_summary : text
* ai_risk_note : text
* ai_recommendation : text
* completion_percentage : decimal(5,2)
* approval_status : enum('draft','submitted','approved','rejected','locked')
* approved_by : int(10) unsigned
* approved_at : datetime
* approval_remarks : text
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_planner_ai_alerts
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* alert_type : enum('pending_syllabus','exam_risk','holiday_impact','teacher_overload','low_completion','revision_pending','remedial_required','extra_class_required','planner_not_updated','approval_pending','academic_risk')
* alert_title : varchar(220)
* alert_message : text
* reference_table : varchar(120)
* reference_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* teacher_id : int(10) unsigned
* severity : enum('info','low','medium','high','critical')
* ai_generated : tinyint(1)
* ai_recommendation : text
* action_status : enum('open','in_review','action_taken','ignored','closed')
* action_taken_by : int(10) unsigned
* action_taken_at : datetime
* action_note : text
* notify_principal : tinyint(1)
* notify_hod : tinyint(1)
* notify_teacher : tinyint(1)
* notify_parent : tinyint(1)
* notify_student : tinyint(1)
* notification_status : enum('not_sent','drafted','sent','failed')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_planner_ai_runs
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* run_type : enum('year_plan','monthly_plan','weekly_plan','lesson_plan','syllabus_prediction','pending_alert','extra_period','revision_timetable','remedial_class','teacher_workload','holiday_adjustment','sunday_special_day','academic_risk')
* reference_table : varchar(120)
* reference_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* teacher_id : int(10) unsigned
* input_payload : longtext
* ai_prompt : longtext
* ai_response : longtext
* ai_score : decimal(6,2)
* ai_confidence : decimal(5,2)
* result_status : enum('generated','accepted','modified','rejected','failed')
* error_message : text
* generated_by : int(10) unsigned
* generated_at : datetime
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_planner_approval_workflow
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* planner_module : enum('year_planner','monthly_planner','weekly_planner','daily_lesson_planner','syllabus_planner','teacher_wise_planner','class_wise_planner','revision_remedial_planner','exam_preparation_planner')
* planner_record_id : int(10) unsigned
* planner_title : varchar(220)
* requested_by : int(10) unsigned
* requested_role : varchar(80)
* requested_at : datetime
* approval_level : enum('teacher','coordinator','hod','principal','admin')
* approver_id : int(10) unsigned
* approver_role : varchar(80)
* approval_status : enum('draft','submitted','approved','rejected','revision_required','locked')
* approval_remarks : text
* submitted_at : datetime
* approved_at : datetime
* rejected_at : datetime
* locked_at : datetime
* escalation_status : enum('none','pending','escalated','resolved')
* escalation_note : text
* escalation_due_date : date
* ai_generated : tinyint(1)
* ai_risk_level : enum('low','medium','high','critical')
* ai_approval_note : text
* ai_recommendation : text
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_planner_calendar
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* calendar_date : date
* day_name : varchar(20)
* day_type : enum('working_day','holiday','sunday','special_day','exam_day','event_day','activity_day','half_day','revision_day','remedial_day')
* title : varchar(180)
* description : text
* is_working_day : tinyint(1)
* working_weight : decimal(5,2)
* affected_classes : text
* affected_sections : text
* ai_impact_level : enum('none','low','medium','high','critical')
* ai_impact_note : text
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_planner_report_snapshots
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* report_type : enum('dashboard','year_plan','monthly_plan','weekly_plan','class_plan','teacher_plan','subject_plan','syllabus_pending','revision_plan','remedial_plan','ai_alerts','principal_review')
* report_title : varchar(220)
* filter_payload : longtext
* report_payload : longtext
* generated_by : int(10) unsigned
* generated_at : datetime
* export_status : enum('ready','printed','pdf_generated','excel_generated','failed')
* export_file : varchar(255)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_promotion_history
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* promotion_rule_id : int(10) unsigned
* from_academic_year_id : int(10) unsigned
* to_academic_year_id : int(10) unsigned
* total_students : int(10) unsigned
* promoted_students : int(10) unsigned
* held_students : int(10) unsigned
* transfer_students : int(10) unsigned
* status : enum('draft','processed','cancelled')
* processed_by : int(10) unsigned
* processed_at : datetime
* remarks : text
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_promotion_rules
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* from_academic_year_id : int(10) unsigned
* to_academic_year_id : int(10) unsigned
* from_class_id : int(10) unsigned
* to_class_id : int(10) unsigned
* from_section_id : int(10) unsigned
* to_section_id : int(10) unsigned
* promotion_type : enum('auto','manual','conditional')
* rule_status : enum('draft','ready','completed','cancelled')
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_remedial_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* teacher_id : int(10) unsigned
* remedial_title : varchar(220)
* remedial_reason : enum('low_marks','attendance_issue','concept_gap','slow_learner','exam_preparation','chapter_pending','teacher_recommended','ai_recommended')
* student_group_type : enum('selected_students','full_class','section_group','custom_group')
* student_ids : text
* planned_date : date
* start_time : time
* end_time : time
* topics : text
* expected_outcome : text
* ai_generated : tinyint(1)
* ai_reason : text
* ai_student_risk_summary : text
* execution_status : enum('planned','completed','cancelled','postponed')
* teacher_feedback : text
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_revision_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* teacher_id : int(10) unsigned
* exam_id : int(10) unsigned
* revision_title : varchar(220)
* revision_type : enum('chapter_revision','unit_revision','full_syllabus','exam_revision','quick_revision')
* revision_start_date : date
* revision_end_date : date
* planned_periods : int(10) unsigned
* completed_periods : int(10) unsigned
* chapters_covered : text
* weak_topics : text
* ai_generated : tinyint(1)
* ai_revision_strategy : text
* ai_expected_improvement : text
* completion_status : enum('planned','in_progress','completed','delayed','cancelled')
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_revision_remedial_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* teacher_id : int(10) unsigned
* syllabus_planner_id : int(10) unsigned
* daily_lesson_id : int(10) unsigned
* plan_type : enum('revision','remedial','extra_class','bridge_course','practice_test','doubt_clearing')
* plan_title : varchar(220)
* target_group : enum('whole_class','slow_learners','absentees','high_achievers','selected_students')
* target_student_count : int(10) unsigned
* planned_date : date
* start_time : time
* end_time : time
* planned_periods : int(10) unsigned
* topic_area : varchar(220)
* learning_gap : text
* planned_activity : text
* assessment_method : varchar(180)
* completion_status : enum('planned','in_progress','completed','postponed','cancelled')
* completion_percentage : decimal(5,2)
* pre_assessment_score : decimal(5,2)
* post_assessment_score : decimal(5,2)
* improvement_percentage : decimal(5,2)
* ai_generated : tinyint(1)
* ai_gap_analysis : text
* ai_recommendation : text
* ai_priority_score : decimal(6,2)
* ai_risk_level : enum('low','medium','high','critical')
* teacher_remarks : text
* hod_remarks : text
* approval_status : enum('draft','submitted','approved','rejected','locked')
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_sections
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* class_id : int(10) unsigned
* section_name : varchar(100)
* section_code : varchar(50)
* capacity : int(10) unsigned
* room_no : varchar(50)
* display_order : int(11)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_streams
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* stream_name : varchar(150)
* stream_code : varchar(50)
* description : text
* display_order : int(11)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_subject_syllabus_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* teacher_id : int(10) unsigned
* year_planner_id : int(10) unsigned
* monthly_planner_id : int(10) unsigned
* weekly_planner_id : int(10) unsigned
* chapter_no : varchar(40)
* chapter_title : varchar(220)
* unit_name : varchar(180)
* chapter_weightage : decimal(6,2)
* estimated_periods : int(10) unsigned
* planned_periods : int(10) unsigned
* completed_periods : int(10) unsigned
* remaining_periods : int(10) unsigned
* planned_start_date : date
* planned_end_date : date
* actual_start_date : date
* actual_end_date : date
* completion_status : enum('not_started','planned','in_progress','completed','delayed','skipped','revision_pending')
* completion_percentage : decimal(5,2)
* is_exam_important : tinyint(1)
* difficulty_level : enum('easy','medium','hard','very_hard')
* ai_priority_score : decimal(6,2)
* ai_delay_risk : enum('none','low','medium','high','critical')
* ai_prediction_note : text
* ai_recommendation : text
* teacher_remarks : text
* hod_remarks : text
* principal_remarks : text
* approval_status : enum('draft','submitted','approved','rejected','locked')
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_teacher_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* teacher_id : int(10) unsigned
* planner_date : date
* planner_type : enum('yearly','monthly','weekly','daily')
* total_assigned_classes : int(10) unsigned
* total_assigned_subjects : int(10) unsigned
* total_planned_periods : int(10) unsigned
* total_completed_periods : int(10) unsigned
* total_pending_periods : int(10) unsigned
* workload_level : enum('low','normal','high','overloaded')
* workload_score : decimal(6,2)
* ai_workload_summary : text
* ai_balancing_suggestion : text
* teacher_notes : text
* hod_notes : text
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_teacher_wise_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* teacher_id : int(10) unsigned
* class_id : int(10) unsigned
* section_id : int(10) unsigned
* subject_id : int(10) unsigned
* plan_month : varchar(7)
* assigned_periods : int(10) unsigned
* completed_periods : int(10) unsigned
* pending_periods : int(10) unsigned
* extra_class_periods : int(10) unsigned
* substitution_periods : int(10) unsigned
* assigned_lessons : int(10) unsigned
* completed_lessons : int(10) unsigned
* pending_lessons : int(10) unsigned
* workload_score : decimal(8,2)
* load_status : enum('under_loaded','balanced','near_capacity','over_loaded')
* risk_level : enum('low','medium','high','critical')
* assigned_scope : text
* teacher_remarks : text
* ai_generated : tinyint(1)
* ai_workload_note : text
* ai_recommendation : text
* approval_status : enum('draft','submitted','approved','rejected','locked')
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_terms
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* term_name : varchar(100)
* term_code : varchar(50)
* term_type : enum('term','semester','quarter','custom')
* start_date : date
* end_date : date
* sequence_no : int(11)
* display_order : int(11)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_weekly_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* year_planner_id : int(10) unsigned
* monthly_planner_id : int(10) unsigned
* week_no : int(10) unsigned
* week_title : varchar(160)
* week_start_date : date
* week_end_date : date
* working_days : int(10) unsigned
* holiday_days : int(10) unsigned
* available_periods : int(10) unsigned
* planned_periods : int(10) unsigned
* completed_periods : int(10) unsigned
* weekly_focus : varchar(180)
* weekly_targets : text
* ai_generated : tinyint(1)
* ai_summary : text
* ai_gap_note : text
* ai_recommendation : text
* completion_percentage : decimal(5,2)
* approval_status : enum('draft','submitted','approved','rejected','locked')
* approved_by : int(10) unsigned
* approved_at : datetime
* approval_remarks : text
* status : enum('active','inactive')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_years
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_name : varchar(50)
* year_code : varchar(30)
* start_date : date
* end_date : date
* is_current : tinyint(1)
* status : enum('active','inactive')
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth academic_year_planner
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* academic_year_id : int(10) unsigned
* planner_code : varchar(60)
* planner_title : varchar(180)
* plan_start_date : date
* plan_end_date : date
* total_working_days : int(10) unsigned
* total_instruction_days : int(10) unsigned
* total_revision_days : int(10) unsigned
* total_exam_days : int(10) unsigned
* total_activity_days : int(10) unsigned
* total_holidays : int(10) unsigned
* planning_strategy : enum('balanced','exam_focused','syllabus_completion','revision_focused','remedial_focused','custom')
* ai_generated : tinyint(1)
* ai_prompt : text
* ai_summary : text
* ai_confidence : decimal(5,2)
* approval_status : enum('draft','submitted','hod_review','principal_review','approved','rejected','locked')
* approved_by : int(10) unsigned
* approved_at : datetime
* approval_remarks : text
* status : enum('active','inactive','archived')
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth admission_applications
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* application_no : varchar(50)
* application_date : date
* enquiry_id : int(10) unsigned
* admission_type : enum('New','Re Admission','Transfer','Sibling','Staff Child')
* student_name : varchar(150)
* gender : varchar(20)
* dob : date
* blood_group : varchar(20)
* nationality : varchar(80)
* religion : varchar(80)
* category : varchar(80)
* caste : varchar(100)
* sub_caste : varchar(100)
* mother_tongue : varchar(80)
* academic_year_id : int(10) unsigned
* academic_year_name : varchar(50)
* class_id : int(10) unsigned
* class_name : varchar(100)
* section_id : int(10) unsigned
* section_name : varchar(100)
* father_name : varchar(150)
* father_mobile : varchar(30)
* father_email : varchar(150)
* father_occupation : varchar(150)
* father_income : decimal(12,2)
* mother_name : varchar(150)
* mother_mobile : varchar(30)
* mother_email : varchar(150)
* mother_occupation : varchar(150)
* mother_income : decimal(12,2)
* guardian_name : varchar(150)
* guardian_relation : varchar(80)
* guardian_mobile : varchar(30)
* guardian_email : varchar(150)
* primary_mobile : varchar(30)
* alternate_mobile : varchar(30)
* whatsapp_no : varchar(30)
* primary_email : varchar(150)
* current_address : text
* permanent_address : text
* city : varchar(100)
* state : varchar(100)
* pincode : varchar(20)
* previous_school : varchar(180)
* previous_class : varchar(80)
* previous_board : varchar(100)
* previous_percentage : varchar(30)
* transfer_certificate_no : varchar(100)
* sibling_available : tinyint(1)
* sibling_details : text
* transport_required : tinyint(1)
* hostel_required : tinyint(1)
* application_fee : decimal(12,2)
* registration_fee : decimal(12,2)
* fee_concession_requested : tinyint(1)
* fee_concession_remarks : text
* selection_status : enum('Draft','Submitted','Under Review','Interview Scheduled','Selected','Waiting List','Rejected','Cancelled','Admitted')
* approval_status : enum('Pending','Approved','Rejected')
* approved_by : int(10) unsigned
* approved_at : datetime
* admission_no : varchar(80)
* student_id : int(10) unsigned
* admitted_at : datetime
* remarks : text
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth admission_communication_logs
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* enquiry_id : int(10) unsigned
* application_id : int(10) unsigned
* channel : enum('WhatsApp','SMS','Email','Call','Other')
* recipient_name : varchar(150)
* recipient_contact : varchar(150)
* template_name : varchar(150)
* subject : varchar(220)
* message_body : text
* send_status : enum('Pending','Sent','Failed','Delivered','Read')
* provider_response : text
* sent_at : datetime
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth admission_documents
* id : int(11)
* reference_type : varchar(30)
* enquiry_id : int(11)
* application_id : int(11)
* reference_no : varchar(50)
* student_name : varchar(150)
* class_id : int(11)
* class_name : varchar(100)
* document_type : varchar(100)
* document_name : varchar(150)
* file_name : varchar(255)
* file_extension : varchar(20)
* file_size_kb : int(11)
* file_path : varchar(500)
* verification_status : varchar(30)
* verification_remarks : text
* verified_by : int(11)
* verified_at : datetime
* company_id : int(11)
* branch_id : int(11)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* deleted_by : int(11)
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth admission_enquiries
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* enquiry_no : varchar(50)
* enquiry_date : date
* source : varchar(80)
* campaign_name : varchar(120)
* student_name : varchar(150)
* gender : varchar(20)
* dob : date
* age : varchar(30)
* academic_year_id : int(10) unsigned
* academic_year_name : varchar(50)
* class_id : int(10) unsigned
* class_name : varchar(100)
* section_id : int(10) unsigned
* section_name : varchar(100)
* parent_name : varchar(150)
* father_name : varchar(150)
* mother_name : varchar(150)
* guardian_name : varchar(150)
* mobile_no : varchar(30)
* alternate_mobile_no : varchar(30)
* whatsapp_no : varchar(30)
* email : varchar(150)
* address : text
* city : varchar(100)
* state : varchar(100)
* pincode : varchar(20)
* previous_school : varchar(180)
* previous_class : varchar(80)
* priority : enum('Low','Medium','High','Hot')
* status : enum('New','Contacted','Follow Up','Visited','Application Given','Application Submitted','Selected','Rejected','Cancelled','Converted')
* assigned_to : int(10) unsigned
* next_followup_date : date
* remarks : text
* converted_application_id : int(10) unsigned
* converted_student_id : int(10) unsigned
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth admission_followups
* id : int(11)
* reference_type : varchar(30)
* enquiry_id : int(11)
* application_id : int(11)
* reference_no : varchar(50)
* student_name : varchar(150)
* class_id : int(11)
* class_name : varchar(100)
* contact_person : varchar(150)
* contact_no : varchar(20)
* followup_date : date
* followup_time : time
* followup_type : varchar(30)
* followup_status : varchar(50)
* next_followup_date : date
* next_followup_time : time
* assigned_to : int(11)
* remarks : text
* next_action : text
* company_id : int(11)
* branch_id : int(11)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* deleted_by : int(11)
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth admission_interviews
* id : int(11)
* interview_no : varchar(50)
* application_id : int(11)
* application_no : varchar(50)
* enquiry_id : int(11)
* enquiry_no : varchar(50)
* student_name : varchar(150)
* class_id : int(11)
* class_name : varchar(100)
* interview_type : varchar(50)
* scheduled_date : date
* scheduled_time : time
* venue : varchar(150)
* conducted_by : int(11)
* conducted_by_name : varchar(150)
* marks_obtained : decimal(10,2)
* max_marks : decimal(10,2)
* grade : varchar(30)
* result_status : varchar(50)
* remarks : text
* recommendation : text
* company_id : int(11)
* branch_id : int(11)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* deleted_by : int(11)
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth admission_payments
* id : int(11)
* receipt_no : varchar(50)
* payment_date : date
* enquiry_id : int(11)
* enquiry_no : varchar(50)
* application_id : int(11)
* application_no : varchar(50)
* student_name : varchar(150)
* class_id : int(11)
* class_name : varchar(100)
* payer_name : varchar(150)
* payer_mobile : varchar(20)
* payment_type : varchar(50)
* amount : decimal(12,2)
* discount_amount : decimal(12,2)
* net_amount : decimal(12,2)
* payment_mode : varchar(50)
* payment_status : varchar(50)
* transaction_no : varchar(150)
* bank_name : varchar(150)
* cheque_no : varchar(100)
* cheque_date : date
* remarks : text
* company_id : int(11)
* branch_id : int(11)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* deleted_by : int(11)
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth admission_seat_plan
* id : int(11)
* academic_year_id : int(11)
* academic_year_name : varchar(50)
* class_id : int(11)
* class_name : varchar(100)
* section_id : int(11)
* section_name : varchar(50)
* total_seats : int(11)
* reserved_seats : int(11)
* admitted_count : int(11)
* waiting_count : int(11)
* available_seats : int(11)
* is_active : tinyint(1)
* remarks : text
* company_id : int(11)
* branch_id : int(11)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* deleted_by : int(11)
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth admission_settings
* id : int(11)
* setting_key : varchar(100)
* setting_label : varchar(150)
* setting_value : text
* setting_type : varchar(50)
* setting_group : varchar(80)
* is_active : tinyint(1)
* company_id : int(11)
* branch_id : int(11)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* deleted_by : int(11)
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth admission_status_logs
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* enquiry_id : int(10) unsigned
* application_id : int(10) unsigned
* entity_type : enum('Enquiry','Application')
* old_status : varchar(80)
* new_status : varchar(80)
* remarks : text
* created_by : int(10) unsigned
* created_at : datetime
v edbroad_ai_sumanth api_keys
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* key_name : varchar(150)
* key_type : enum('mobile_app','external_api','payment_webhook','sms_webhook','whatsapp_webhook','gps_webhook','ai_provider','internal')
* api_key_hash : varchar(255)
* api_key_prefix : varchar(30)
* allowed_modules : text
* allowed_ips : text
* rate_limit_per_minute : int(11)
* expires_at : datetime
* last_used_at : datetime
* last_used_ip : varchar(60)
* is_active : tinyint(4)
* revoked_at : datetime
* revoked_by : int(11)
* delete_status : tinyint(4)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth api_key_logs
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* api_key_id : int(11)
* request_path : varchar(255)
* request_method : varchar(20)
* request_ip : varchar(60)
* user_agent : text
* status : enum('success','failed')
* message : varchar(255)
* created_at : datetime
v edbroad_ai_sumanth branches
* id : int(11)
* company_id : int(11)
* institution_code : varchar(6)
* branch_code : varchar(20)
* branch_name : varchar(150)
* short_name : varchar(50)
* address : text
* city : varchar(100)
* state : varchar(100)
* pincode : varchar(20)
* phone : varchar(30)
* email : varchar(150)
* contact_person : varchar(150)
* display_order : int(11)
* is_main_branch : tinyint(4)
* is_active : tinyint(4)
* status : enum('active','inactive')
* delete_status : tinyint(4)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth erp_dashboard_activity_log
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* user_id : int(11)
* role_code : varchar(50)
* activity_type : varchar(80)
* activity_title : varchar(180)
* activity_message : text
* module_code : varchar(80)
* reference_id : int(11)
* activity_url : varchar(255)
* activity_time : datetime
* delete_status : tinyint(4)
* created_at : datetime
v edbroad_ai_sumanth erp_dashboard_ai_insights
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* role_code : varchar(50)
* insight_type : enum('info','risk','suggestion','prediction','automation')
* insight_title : varchar(180)
* insight_message : text
* module_code : varchar(80)
* score_value : decimal(10,2)
* action_label : varchar(120)
* action_url : varchar(255)
* is_active : tinyint(4)
* delete_status : tinyint(4)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth erp_dashboard_alerts
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* role_code : varchar(50)
* user_id : int(11)
* alert_type : enum('info','success','warning','danger')
* alert_title : varchar(180)
* alert_message : text
* module_code : varchar(80)
* reference_id : int(11)
* action_url : varchar(255)
* is_read : tinyint(4)
* priority : enum('low','normal','high','urgent')
* alert_date : date
* delete_status : tinyint(4)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth erp_dashboard_user_preferences
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* user_id : int(11)
* role_code : varchar(50)
* dashboard_code : varchar(80)
* widget_key : varchar(100)
* widget_title : varchar(180)
* is_visible : tinyint(4)
* display_order : int(11)
* widget_size : enum('small','medium','large','wide')
* settings_json : longtext
* delete_status : tinyint(4)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth erp_role_dashboards
* id : int(11)
* dashboard_code : varchar(80)
* dashboard_title : varchar(150)
* role_code : varchar(50)
* user_type : varchar(50)
* dashboard_url : varchar(255)
* dashboard_icon : varchar(30)
* is_active : tinyint(4)
* display_order : int(11)
* delete_status : tinyint(4)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hostel_alerts
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* hostel_id : int(11)
* student_id : int(11)
* alert_type : enum('Attendance','Overdue Return','Visitor','Complaint','Fee Due','Medical','Security','General')
* reference_id : int(11)
* alert_title : varchar(200)
* alert_message : text
* alert_priority : enum('Low','Medium','High','Critical')
* alert_status : enum('New','Seen','Actioned','Closed')
* notify_parent : tinyint(1)
* notify_warden : tinyint(1)
* notify_admin : tinyint(1)
* action_by : int(11)
* action_note : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hostel_attendance
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* hostel_id : int(11)
* student_id : int(11)
* allocation_id : int(11)
* attendance_date : date
* morning_status : enum('Present','Absent','Late','Outing','Leave')
* night_status : enum('Present','Absent','Late','Outing','Leave')
* remarks : text
* marked_by : int(11)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hostel_beds
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* hostel_id : int(11)
* block_id : int(11)
* room_id : int(11)
* bed_no : varchar(50)
* bed_status : enum('Available','Occupied','Reserved','Maintenance')
* student_id : int(11)
* allocation_id : int(11)
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hostel_blocks
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* hostel_id : int(11)
* block_name : varchar(150)
* block_code : varchar(50)
* floor_count : int(11)
* room_count : int(11)
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hostel_complaints
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* hostel_id : int(11)
* block_id : int(11)
* room_id : int(11)
* student_id : int(11)
* complaint_no : varchar(80)
* complaint_type : enum('Room','Electrical','Water','Food','Cleanliness','Security','Medical','Other')
* priority : enum('Low','Medium','High','Critical')
* complaint_title : varchar(200)
* complaint_description : text
* complaint_status : enum('Open','Assigned','In Progress','Resolved','Closed','Rejected')
* assigned_to : int(11)
* resolved_at : datetime
* resolution_note : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hostel_fee_mapping
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* student_id : int(11)
* allocation_id : int(11)
* hostel_id : int(11)
* room_id : int(11)
* bed_id : int(11)
* rent_amount : decimal(10,2)
* mess_amount : decimal(10,2)
* caution_deposit : decimal(10,2)
* other_charges : decimal(10,2)
* discount_amount : decimal(10,2)
* total_amount : decimal(10,2)
* billing_cycle : enum('Monthly','Quarterly','Half Yearly','Yearly')
* fee_status : enum('Active','Hold','Closed')
* remarks : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hostel_master
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* hostel_name : varchar(150)
* hostel_code : varchar(50)
* hostel_type : enum('Boys','Girls','Staff','Mixed')
* warden_name : varchar(150)
* warden_mobile : varchar(30)
* address : text
* total_blocks : int(11)
* total_rooms : int(11)
* total_beds : int(11)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hostel_mess_menu
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* hostel_id : int(11)
* menu_date : date
* day_name : varchar(30)
* breakfast_menu : text
* lunch_menu : text
* snacks_menu : text
* dinner_menu : text
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hostel_mess_plans
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* hostel_id : int(11)
* plan_name : varchar(150)
* plan_type : enum('Monthly','Weekly','Daily','Special')
* monthly_amount : decimal(10,2)
* breakfast_enabled : tinyint(1)
* lunch_enabled : tinyint(1)
* snacks_enabled : tinyint(1)
* dinner_enabled : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hostel_outing_pass
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* hostel_id : int(11)
* student_id : int(11)
* allocation_id : int(11)
* request_type : enum('Outing','Home Leave','Medical','Emergency','Other')
* request_date : date
* from_datetime : datetime
* to_datetime : datetime
* reason : text
* warden_status : enum('Pending','Approved','Rejected')
* final_status : enum('Pending','Approved','Rejected','Returned','Overdue')
* approved_by : int(11)
* out_time : datetime
* return_time : datetime
* remarks : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hostel_rooms
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* hostel_id : int(11)
* block_id : int(11)
* floor_no : varchar(30)
* room_no : varchar(50)
* room_type : enum('Single','Double','Triple','Dormitory','Staff')
* capacity : int(11)
* current_occupied : int(11)
* monthly_rent : decimal(10,2)
* room_status : enum('Available','Full','Maintenance','Inactive')
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hostel_room_transfers
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* allocation_id : int(11)
* student_id : int(11)
* from_hostel_id : int(11)
* from_block_id : int(11)
* from_room_id : int(11)
* from_bed_id : int(11)
* to_hostel_id : int(11)
* to_block_id : int(11)
* to_room_id : int(11)
* to_bed_id : int(11)
* transfer_date : date
* reason : text
* approved_by : int(11)
* transfer_status : enum('Pending','Approved','Rejected','Completed')
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hostel_student_allocations
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* student_id : int(11)
* admission_no : varchar(80)
* student_name : varchar(150)
* class_id : int(11)
* section_id : int(11)
* hostel_id : int(11)
* block_id : int(11)
* room_id : int(11)
* bed_id : int(11)
* allocation_date : date
* expected_checkout_date : date
* actual_checkout_date : date
* allocation_status : enum('Active','Transferred','Vacated','Cancelled')
* guardian_name : varchar(150)
* guardian_mobile : varchar(30)
* emergency_contact : varchar(30)
* medical_notes : text
* remarks : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hostel_visitor_logs
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* hostel_id : int(11)
* student_id : int(11)
* allocation_id : int(11)
* visitor_name : varchar(150)
* relation : varchar(80)
* mobile_no : varchar(30)
* id_proof_type : varchar(80)
* id_proof_no : varchar(100)
* purpose : text
* visit_date : date
* in_time : time
* out_time : time
* approval_status : enum('Pending','Approved','Rejected','Completed')
* approved_by : int(11)
* remarks : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hr_activity_logs
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* activity_module : varchar(100)
* activity_action : varchar(100)
* activity_text : text
* activity_user : varchar(150)
* activity_status : varchar(50)
* reference_table : varchar(120)
* reference_id : int(10) unsigned
* ip_address : varchar(80)
* user_agent : text
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_analytics_ai_insights
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* insight_date : date
* insight_type : varchar(80)
* insight_title : varchar(220)
* insight_description : text
* related_module : varchar(120)
* related_entity_type : varchar(120)
* related_entity_id : int(10) unsigned
* severity : varchar(60)
* ai_score : decimal(8,2)
* recommended_action : text
* action_status : varchar(60)
* resolved_by : int(10) unsigned
* resolved_at : datetime
* resolution_notes : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_analytics_alerts
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* alert_date : date
* alert_title : varchar(220)
* alert_message : text
* alert_category : varchar(100)
* alert_priority : varchar(60)
* alert_status : varchar(60)
* related_module : varchar(120)
* related_entity_type : varchar(120)
* related_entity_id : int(10) unsigned
* assigned_to : int(10) unsigned
* assigned_to_name : varchar(180)
* due_date : date
* closed_by : int(10) unsigned
* closed_at : datetime
* closure_notes : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_analytics_snapshots
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* snapshot_date : date
* total_employees : int(10) unsigned
* active_employees : int(10) unsigned
* inactive_employees : int(10) unsigned
* present_today : int(10) unsigned
* absent_today : int(10) unsigned
* late_today : int(10) unsigned
* on_leave_today : int(10) unsigned
* open_leave_requests : int(10) unsigned
* pending_attendance_regularizations : int(10) unsigned
* payroll_pending_count : int(10) unsigned
* payroll_processed_count : int(10) unsigned
* open_recruitment_count : int(10) unsigned
* onboarding_pending_count : int(10) unsigned
* exit_pending_count : int(10) unsigned
* open_helpdesk_requests : int(10) unsigned
* escalated_helpdesk_requests : int(10) unsigned
* training_pending_count : int(10) unsigned
* performance_review_pending_count : int(10) unsigned
* average_performance_score : decimal(8,2)
* attrition_risk_score : decimal(8,2)
* compliance_score : decimal(8,2)
* hr_health_score : decimal(8,2)
* snapshot_notes : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_attendance
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* employee_id : int(10) unsigned
* attendance_date : date
* shift_id : int(10) unsigned
* shift_name : varchar(120)
* check_in_time : datetime
* check_out_time : datetime
* total_minutes : int(10) unsigned
* attendance_status : varchar(40)
* day_type : varchar(40)
* late_minutes : int(10) unsigned
* early_out_minutes : int(10) unsigned
* overtime_minutes : int(10) unsigned
* source_type : varchar(60)
* approval_status : varchar(40)
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_attendance_regularization
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* employee_id : int(10) unsigned
* attendance_date : date
* requested_check_in : datetime
* requested_check_out : datetime
* requested_status : varchar(40)
* reason : text
* approval_status : varchar(40)
* approved_by : int(10) unsigned
* approved_at : datetime
* rejected_by : int(10) unsigned
* rejected_at : datetime
* rejection_reason : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_attendance_shifts
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* shift_name : varchar(120)
* shift_code : varchar(50)
* start_time : time
* end_time : time
* grace_minutes : int(10) unsigned
* half_day_minutes : int(10) unsigned
* full_day_minutes : int(10) unsigned
* is_default : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_documents
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* category_id : int(10) unsigned
* document_title : varchar(180)
* document_code : varchar(80)
* document_type : varchar(80)
* related_employee_id : int(10) unsigned
* related_module : varchar(100)
* file_path : varchar(255)
* file_name : varchar(180)
* file_type : varchar(80)
* file_size : varchar(50)
* document_status : varchar(40)
* remarks : text
* is_confidential : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_document_categories
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* category_name : varchar(150)
* category_code : varchar(80)
* description : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_employees
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* employee_code : varchar(50)
* biometric_code : varchar(50)
* old_employee_code : varchar(50)
* salutation : varchar(20)
* first_name : varchar(100)
* middle_name : varchar(100)
* last_name : varchar(100)
* display_name : varchar(180)
* gender : varchar(20)
* date_of_birth : date
* blood_group : varchar(20)
* marital_status : varchar(30)
* nationality : varchar(80)
* religion : varchar(80)
* caste_category : varchar(80)
* mobile_no : varchar(30)
* alternate_mobile_no : varchar(30)
* email : varchar(150)
* personal_email : varchar(150)
* current_address : text
* current_city : varchar(100)
* current_state : varchar(100)
* current_pincode : varchar(20)
* permanent_address : text
* permanent_city : varchar(100)
* permanent_state : varchar(100)
* permanent_pincode : varchar(20)
* joining_date : date
* confirmation_date : date
* probation_end_date : date
* resignation_date : date
* relieving_date : date
* employee_type : varchar(50)
* employment_category : varchar(80)
* staff_category : varchar(80)
* department_name : varchar(120)
* designation_name : varchar(120)
* reporting_manager_id : int(10) unsigned
* work_location : varchar(150)
* shift_name : varchar(100)
* employee_status : varchar(40)
* attendance_applicable : tinyint(1)
* payroll_applicable : tinyint(1)
* portal_access : tinyint(1)
* aadhaar_no : varchar(30)
* pan_no : varchar(30)
* passport_no : varchar(50)
* driving_license_no : varchar(50)
* emergency_contact_name : varchar(150)
* emergency_contact_relation : varchar(80)
* emergency_contact_mobile : varchar(30)
* photo_path : varchar(255)
* signature_path : varchar(255)
* notes : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_employee_bank_details
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* employee_id : int(10) unsigned
* bank_name : varchar(150)
* branch_name : varchar(150)
* account_holder_name : varchar(180)
* account_no : varchar(80)
* ifsc_code : varchar(30)
* account_type : varchar(50)
* pf_no : varchar(80)
* uan_no : varchar(80)
* esi_no : varchar(80)
* professional_tax_no : varchar(80)
* tds_applicable : tinyint(1)
* payment_mode : varchar(50)
* is_primary : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_employee_code_sequence
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* prefix : varchar(20)
* current_no : int(10) unsigned
* padding_length : int(10) unsigned
* financial_year : varchar(20)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hr_employee_documents
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* employee_id : int(10) unsigned
* document_type : varchar(120)
* document_title : varchar(180)
* document_no : varchar(100)
* issue_date : date
* expiry_date : date
* file_path : varchar(255)
* file_name : varchar(180)
* file_type : varchar(80)
* file_size : varchar(50)
* verification_status : varchar(40)
* verified_by : int(10) unsigned
* verified_at : datetime
* remarks : text
* is_mandatory : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_employee_exit_clearance_items
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* exit_id : int(10) unsigned
* clearance_master_id : int(10) unsigned
* clearance_title : varchar(180)
* clearance_category : varchar(100)
* responsible_department : varchar(120)
* mandatory : tinyint(1)
* item_status : varchar(60)
* cleared_by : int(10) unsigned
* cleared_at : datetime
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_employee_exit_clearance_master
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* clearance_title : varchar(180)
* clearance_code : varchar(80)
* clearance_category : varchar(100)
* responsible_department : varchar(120)
* mandatory : tinyint(1)
* display_order : int(10) unsigned
* description : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_employee_exit_requests
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* employee_id : int(10) unsigned
* resignation_date : date
* requested_last_working_date : date
* approved_last_working_date : date
* exit_type : varchar(80)
* exit_reason : varchar(180)
* resignation_notes : text
* notice_period_days : int(10) unsigned
* notice_served_days : int(10) unsigned
* notice_shortfall_days : int(10) unsigned
* exit_status : varchar(60)
* clearance_status : varchar(60)
* settlement_status : varchar(60)
* exit_interview_done : tinyint(1)
* exit_interview_notes : text
* relieving_letter_ready : tinyint(1)
* experience_letter_ready : tinyint(1)
* ai_risk_score : decimal(6,2)
* ai_notes : text
* approved_by : int(10) unsigned
* approved_at : datetime
* rejected_by : int(10) unsigned
* rejected_at : datetime
* rejection_reason : text
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_employee_exit_settlement
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* exit_id : int(10) unsigned
* employee_id : int(10) unsigned
* unpaid_salary : decimal(12,2)
* leave_encashment : decimal(12,2)
* gratuity_amount : decimal(12,2)
* bonus_amount : decimal(12,2)
* other_earnings : decimal(12,2)
* loan_recovery : decimal(12,2)
* notice_recovery : decimal(12,2)
* asset_recovery : decimal(12,2)
* other_deductions : decimal(12,2)
* gross_payable : decimal(12,2)
* total_deductions : decimal(12,2)
* net_payable : decimal(12,2)
* settlement_status : varchar(60)
* payment_mode : varchar(60)
* payment_reference : varchar(150)
* payment_date : date
* approved_by : int(10) unsigned
* approved_at : datetime
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_employee_experience
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* employee_id : int(10) unsigned
* organization_name : varchar(200)
* designation_name : varchar(150)
* department_name : varchar(150)
* from_date : date
* to_date : date
* total_experience : varchar(80)
* last_salary : decimal(12,2)
* reason_for_leaving : text
* experience_letter_path : varchar(255)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_employee_family
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* employee_id : int(10) unsigned
* member_name : varchar(150)
* relation : varchar(80)
* gender : varchar(20)
* date_of_birth : date
* mobile_no : varchar(30)
* occupation : varchar(120)
* is_nominee : tinyint(1)
* nominee_percentage : decimal(8,2)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_employee_kpi_assignments
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* cycle_id : int(10) unsigned
* employee_id : int(10) unsigned
* kpi_id : int(10) unsigned
* kpi_title : varchar(180)
* kpi_category : varchar(120)
* target_value : varchar(180)
* weightage : decimal(8,2)
* max_score : decimal(8,2)
* assignment_status : varchar(60)
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_employee_qualifications
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* employee_id : int(10) unsigned
* qualification_name : varchar(150)
* course_name : varchar(150)
* institution_name : varchar(200)
* university_name : varchar(200)
* year_of_passing : varchar(20)
* percentage_or_grade : varchar(50)
* certificate_path : varchar(255)
* is_highest : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_employee_salary
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* employee_id : int(10) unsigned
* structure_id : int(10) unsigned
* effective_from : date
* effective_to : date
* basic_salary : decimal(12,2)
* gross_salary : decimal(12,2)
* total_earnings : decimal(12,2)
* total_deductions : decimal(12,2)
* net_salary : decimal(12,2)
* payment_mode : varchar(40)
* bank_name : varchar(150)
* bank_account_no : varchar(80)
* ifsc_code : varchar(40)
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_employee_status_history
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* employee_id : int(10) unsigned
* old_status : varchar(50)
* new_status : varchar(50)
* effective_date : date
* reason : text
* remarks : text
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_helpdesk_categories
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* category_name : varchar(180)
* category_code : varchar(80)
* responsible_department : varchar(120)
* default_priority : varchar(60)
* default_sla_hours : int(10) unsigned
* description : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_helpdesk_requests
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* request_no : varchar(80)
* employee_id : int(10) unsigned
* category_id : int(10) unsigned
* category_name : varchar(180)
* request_title : varchar(220)
* request_description : text
* priority : varchar(60)
* request_status : varchar(60)
* assigned_department : varchar(120)
* assigned_to : int(10) unsigned
* assigned_to_name : varchar(180)
* requested_date : date
* due_date : date
* sla_hours : int(10) unsigned
* first_response_at : datetime
* resolved_at : datetime
* closed_at : datetime
* resolution_notes : text
* internal_notes : text
* escalation_level : int(10) unsigned
* escalated_at : datetime
* escalated_by : int(10) unsigned
* escalation_reason : text
* employee_rating : decimal(6,2)
* employee_feedback : text
* ai_priority_score : decimal(6,2)
* ai_notes : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_helpdesk_request_notes
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* request_id : int(10) unsigned
* note_type : varchar(60)
* note_text : text
* visible_to_employee : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_leave_balances
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* employee_id : int(10) unsigned
* leave_type_id : int(10) unsigned
* leave_year : varchar(20)
* opening_balance : decimal(8,2)
* credited_leave : decimal(8,2)
* used_leave : decimal(8,2)
* pending_leave : decimal(8,2)
* available_balance : decimal(8,2)
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_leave_requests
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* employee_id : int(10) unsigned
* leave_type_id : int(10) unsigned
* leave_from : date
* leave_to : date
* total_days : decimal(8,2)
* half_day : tinyint(1)
* half_day_session : varchar(30)
* reason : text
* attachment_path : varchar(255)
* leave_status : varchar(40)
* approved_by : int(10) unsigned
* approved_at : datetime
* rejected_by : int(10) unsigned
* rejected_at : datetime
* rejection_reason : text
* cancel_requested : tinyint(1)
* cancel_reason : text
* cancelled_by : int(10) unsigned
* cancelled_at : datetime
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_leave_types
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* leave_type_name : varchar(120)
* leave_type_code : varchar(50)
* leave_color : varchar(30)
* annual_quota : decimal(8,2)
* carry_forward_allowed : tinyint(1)
* max_carry_forward : decimal(8,2)
* paid_leave : tinyint(1)
* approval_required : tinyint(1)
* half_day_allowed : tinyint(1)
* description : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_letter_requests
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* employee_id : int(10) unsigned
* template_id : int(10) unsigned
* letter_type : varchar(100)
* letter_no : varchar(80)
* letter_subject : varchar(255)
* letter_body : longtext
* request_status : varchar(40)
* approval_status : varchar(40)
* approved_by : int(10) unsigned
* approved_at : datetime
* rejected_by : int(10) unsigned
* rejected_at : datetime
* rejection_reason : text
* generated_file_path : varchar(255)
* issued_date : date
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_letter_sequence
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* prefix : varchar(30)
* current_no : int(10) unsigned
* padding_length : int(10) unsigned
* financial_year : varchar(20)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth hr_letter_templates
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* template_name : varchar(180)
* template_code : varchar(80)
* letter_type : varchar(100)
* subject : varchar(255)
* template_body : longtext
* available_placeholders : text
* approval_required : tinyint(1)
* is_default : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_onboarding_candidates
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* employee_id : int(10) unsigned
* applicant_id : int(10) unsigned
* candidate_name : varchar(180)
* candidate_code : varchar(80)
* mobile_no : varchar(30)
* email : varchar(150)
* department_name : varchar(120)
* designation_name : varchar(120)
* joining_date : date
* reporting_manager : varchar(180)
* employment_type : varchar(80)
* onboarding_status : varchar(60)
* verification_status : varchar(60)
* offer_letter_issued : tinyint(1)
* appointment_letter_issued : tinyint(1)
* id_card_issued : tinyint(1)
* system_access_created : tinyint(1)
* completion_percent : decimal(6,2)
* ai_risk_score : decimal(6,2)
* ai_notes : text
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_onboarding_checklist_items
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* onboarding_id : int(10) unsigned
* checklist_master_id : int(10) unsigned
* checklist_title : varchar(180)
* checklist_category : varchar(100)
* responsible_department : varchar(120)
* mandatory : tinyint(1)
* due_date : date
* item_status : varchar(60)
* completed_by : int(10) unsigned
* completed_at : datetime
* evidence_path : varchar(255)
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_onboarding_checklist_master
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* checklist_title : varchar(180)
* checklist_code : varchar(80)
* checklist_category : varchar(100)
* responsible_department : varchar(120)
* mandatory : tinyint(1)
* default_due_days : int(10) unsigned
* display_order : int(10) unsigned
* description : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_onboarding_documents
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* onboarding_id : int(10) unsigned
* document_name : varchar(180)
* document_type : varchar(100)
* document_status : varchar(60)
* required_document : tinyint(1)
* received_date : date
* verified_by : int(10) unsigned
* verified_at : datetime
* file_path : varchar(255)
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_payroll_loans_advances
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* employee_id : int(10) unsigned
* loan_type : varchar(80)
* loan_date : date
* principal_amount : decimal(12,2)
* installment_amount : decimal(12,2)
* total_installments : int(10) unsigned
* paid_installments : int(10) unsigned
* balance_amount : decimal(12,2)
* loan_status : varchar(40)
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_payroll_monthly
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* payroll_month : varchar(7)
* payroll_title : varchar(150)
* total_employees : int(10) unsigned
* processed_employees : int(10) unsigned
* total_earnings : decimal(14,2)
* total_deductions : decimal(14,2)
* net_payable : decimal(14,2)
* payroll_status : varchar(40)
* approval_status : varchar(40)
* processed_by : int(10) unsigned
* processed_at : datetime
* approved_by : int(10) unsigned
* approved_at : datetime
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_payroll_monthly_items
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* payroll_id : int(10) unsigned
* employee_id : int(10) unsigned
* payroll_month : varchar(7)
* working_days : decimal(8,2)
* present_days : decimal(8,2)
* leave_days : decimal(8,2)
* lop_days : decimal(8,2)
* basic_salary : decimal(12,2)
* gross_salary : decimal(12,2)
* total_earnings : decimal(12,2)
* total_deductions : decimal(12,2)
* loan_deduction : decimal(12,2)
* net_salary : decimal(12,2)
* payslip_status : varchar(40)
* payment_status : varchar(40)
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_performance_cycles
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* cycle_name : varchar(180)
* cycle_code : varchar(80)
* cycle_type : varchar(80)
* start_date : date
* end_date : date
* review_due_date : date
* cycle_status : varchar(60)
* description : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_performance_improvement_plans
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* review_id : int(10) unsigned
* employee_id : int(10) unsigned
* pip_title : varchar(180)
* pip_reason : varchar(180)
* start_date : date
* end_date : date
* target_improvement : text
* action_plan : text
* pip_status : varchar(60)
* followup_notes : text
* closed_by : int(10) unsigned
* closed_at : datetime
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_performance_kpi_master
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* kpi_title : varchar(180)
* kpi_code : varchar(80)
* kpi_category : varchar(120)
* department_name : varchar(120)
* designation_name : varchar(120)
* max_score : decimal(8,2)
* default_weightage : decimal(8,2)
* measurement_type : varchar(80)
* description : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_performance_reviews
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* cycle_id : int(10) unsigned
* employee_id : int(10) unsigned
* reviewer_id : int(10) unsigned
* reviewer_name : varchar(180)
* self_score : decimal(8,2)
* manager_score : decimal(8,2)
* final_score : decimal(8,2)
* final_rating : varchar(60)
* performance_band : varchar(80)
* review_status : varchar(60)
* approval_status : varchar(60)
* self_comments : text
* manager_comments : text
* hr_comments : text
* increment_percent : decimal(8,2)
* approved_by : int(10) unsigned
* approved_at : datetime
* ai_score : decimal(8,2)
* ai_notes : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_performance_review_items
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* review_id : int(10) unsigned
* assignment_id : int(10) unsigned
* kpi_id : int(10) unsigned
* kpi_title : varchar(180)
* kpi_category : varchar(120)
* weightage : decimal(8,2)
* max_score : decimal(8,2)
* self_score : decimal(8,2)
* manager_score : decimal(8,2)
* final_score : decimal(8,2)
* comments : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_recruitment_applicants
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* job_id : int(10) unsigned
* applicant_name : varchar(180)
* applicant_code : varchar(80)
* mobile_no : varchar(30)
* email : varchar(150)
* gender : varchar(30)
* qualification : varchar(180)
* experience_years : decimal(6,2)
* current_company : varchar(180)
* current_ctc : decimal(12,2)
* expected_ctc : decimal(12,2)
* notice_period : varchar(80)
* source_type : varchar(80)
* referred_by : varchar(180)
* resume_path : varchar(255)
* cover_note : text
* applicant_stage : varchar(60)
* applicant_status : varchar(60)
* ai_score : decimal(6,2)
* ai_notes : text
* applied_date : date
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_recruitment_feedback
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* interview_id : int(10) unsigned
* applicant_id : int(10) unsigned
* job_id : int(10) unsigned
* technical_score : decimal(6,2)
* communication_score : decimal(6,2)
* attitude_score : decimal(6,2)
* overall_score : decimal(6,2)
* recommendation : varchar(60)
* feedback_notes : text
* feedback_by : int(10) unsigned
* feedback_at : datetime
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_recruitment_interviews
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* applicant_id : int(10) unsigned
* job_id : int(10) unsigned
* interview_round : varchar(80)
* interview_type : varchar(80)
* interview_date : date
* interview_time : time
* interviewer_name : varchar(180)
* interviewer_user_id : int(10) unsigned
* location : varchar(180)
* interview_status : varchar(60)
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_recruitment_jobs
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* job_title : varchar(180)
* job_code : varchar(80)
* department_name : varchar(120)
* designation_name : varchar(120)
* vacancy_count : int(10) unsigned
* employment_type : varchar(60)
* work_location : varchar(180)
* min_experience : decimal(6,2)
* max_experience : decimal(6,2)
* salary_range : varchar(120)
* job_description : text
* required_skills : text
* opening_date : date
* closing_date : date
* job_status : varchar(40)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_salary_heads
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* head_name : varchar(150)
* head_code : varchar(60)
* head_type : varchar(40)
* calculation_type : varchar(40)
* calculation_value : decimal(12,2)
* taxable : tinyint(1)
* pf_applicable : tinyint(1)
* esi_applicable : tinyint(1)
* display_order : int(10) unsigned
* description : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth hr_salary_structures
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* structure_name : varchar(150)
* structure_code : varchar(60)
* description : text
* gross_salary : decimal(12,2)
* total_earnings : decimal(12,2)
* total_deductions : decimal(12,2)
* net_salary : decimal(12,2)
* is_default : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth institutions
* id : int(11)
* institution_code : varchar(6)
* institution_name : varchar(150)
* short_name : varchar(50)
* status : enum('active','inactive')
* subscription_status : enum('active','inactive','expired')
* contact_person : varchar(150)
* phone : varchar(30)
* email : varchar(150)
* address : text
* city : varchar(100)
* state : varchar(100)
* pincode : varchar(20)
* logo_path : varchar(255)
* academic_year_id : int(11)
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(4)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth institution_type_presets
* id : int(11)
* institution_type : varchar(50)
* preset_name : varchar(120)
* institution_level : varchar(80)
* affiliation_type : varchar(120)
* affiliation_name : varchar(180)
* academic_structure_type : varchar(80)
* label_class : varchar(80)
* label_section : varchar(80)
* label_subject : varchar(80)
* label_teacher : varchar(80)
* label_student : varchar(80)
* label_parent : varchar(80)
* label_academic_year : varchar(80)
* label_term : varchar(80)
* enabled_modules : text
* ai_profile : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth institution_units
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* unit_name : varchar(180)
* unit_code : varchar(50)
* institution_type : varchar(50)
* institution_level : varchar(80)
* affiliation_type : varchar(120)
* affiliation_name : varchar(180)
* academic_structure_type : varchar(80)
* label_class : varchar(80)
* label_section : varchar(80)
* label_subject : varchar(80)
* label_teacher : varchar(80)
* label_student : varchar(80)
* label_parent : varchar(80)
* label_academic_year : varchar(80)
* label_term : varchar(80)
* enabled_modules : text
* ai_profile : text
* is_primary_unit : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth lib_books
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* book_code : varchar(50)
* isbn_no : varchar(80)
* title : varchar(255)
* subtitle : varchar(255)
* author_name : varchar(255)
* co_author_name : varchar(255)
* publisher_name : varchar(255)
* edition : varchar(100)
* publication_year : varchar(20)
* language : varchar(80)
* category : varchar(120)
* subject : varchar(120)
* class_level : varchar(80)
* rack_no : varchar(50)
* shelf_no : varchar(50)
* keywords : text
* description : text
* cover_image : varchar(255)
* total_copies : int(11)
* available_copies : int(11)
* issued_copies : int(11)
* lost_copies : int(11)
* damaged_copies : int(11)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth lib_book_copies
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* book_id : int(11)
* accession_no : varchar(80)
* barcode_no : varchar(80)
* rfid_no : varchar(80)
* purchase_date : date
* purchase_price : decimal(12,2)
* vendor_name : varchar(150)
* bill_no : varchar(100)
* copy_status : enum('available','issued','reserved','lost','damaged','withdrawn')
* condition_status : enum('new','good','average','poor','damaged')
* rack_no : varchar(50)
* shelf_no : varchar(50)
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth lib_fine_payments
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* transaction_id : int(11)
* member_id : int(11)
* payment_date : date
* fine_amount : decimal(12,2)
* paid_amount : decimal(12,2)
* waived_amount : decimal(12,2)
* balance_amount : decimal(12,2)
* payment_mode : enum('cash','upi','card','bank','adjustment','waiver')
* receipt_no : varchar(80)
* reference_no : varchar(120)
* remarks : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth lib_issue_transactions
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* transaction_no : varchar(80)
* member_id : int(11)
* book_id : int(11)
* copy_id : int(11)
* issue_date : date
* due_date : date
* return_date : date
* issue_status : enum('issued','returned','renewed','overdue','lost','damaged')
* renew_count : int(11)
* last_renew_date : date
* fine_amount : decimal(12,2)
* fine_paid : decimal(12,2)
* fine_balance : decimal(12,2)
* fine_status : enum('none','pending','partial','paid','waived')
* issued_by : int(11)
* returned_by : int(11)
* remarks : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth lib_members
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* member_type : enum('student','staff','teacher','external')
* member_ref_id : int(11)
* member_code : varchar(80)
* library_card_no : varchar(80)
* member_name : varchar(150)
* class_name : varchar(80)
* section_name : varchar(80)
* department_name : varchar(120)
* mobile_no : varchar(30)
* email : varchar(150)
* max_books_allowed : int(11)
* max_days_allowed : int(11)
* fine_per_day : decimal(10,2)
* membership_status : enum('active','blocked','expired')
* blocked_reason : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth lib_notifications
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* member_id : int(11)
* transaction_id : int(11)
* notification_type : enum('due_reminder','overdue_alert','fine_alert','reservation_ready','lost_book','general')
* title : varchar(180)
* message : text
* channel : enum('app','sms','whatsapp','email','manual')
* send_status : enum('pending','sent','failed','cancelled')
* scheduled_at : datetime
* sent_at : datetime
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth lib_reservations
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* reservation_no : varchar(80)
* member_id : int(11)
* book_id : int(11)
* copy_id : int(11)
* request_date : date
* expiry_date : date
* reservation_status : enum('pending','approved','ready_for_pickup','issued','cancelled','expired')
* priority_no : int(11)
* approved_by : int(11)
* approved_at : datetime
* remarks : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth lib_settings
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* default_student_book_limit : int(11)
* default_staff_book_limit : int(11)
* default_issue_days : int(11)
* default_renew_limit : int(11)
* default_fine_per_day : decimal(10,2)
* allow_reservation : tinyint(1)
* allow_renewal : tinyint(1)
* auto_overdue_marking : tinyint(1)
* auto_fine_calculation : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth lib_stock_verification
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* verification_no : varchar(80)
* verification_date : date
* verified_by : int(11)
* total_books_checked : int(11)
* available_count : int(11)
* missing_count : int(11)
* damaged_count : int(11)
* extra_found_count : int(11)
* verification_status : enum('draft','in_progress','completed','closed')
* remarks : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth lib_stock_verification_items
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* verification_id : int(11)
* book_id : int(11)
* copy_id : int(11)
* accession_no : varchar(80)
* barcode_no : varchar(80)
* system_status : varchar(50)
* physical_status : enum('found','missing','damaged','extra')
* remarks : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth login_logs
* id : bigint(20)
* company_id : int(11)
* branch_id : int(11)
* user_id : int(11)
* institution_code : varchar(6)
* username : varchar(100)
* ip_address : varchar(60)
* user_agent : varchar(255)
* status : enum('success','failed')
* remarks : varchar(255)
* created_at : datetime
v edbroad_ai_sumanth password_reset_tokens
* id : bigint(20) unsigned
* user_id : int(11)
* token_hash : char(64)
* requested_ip : varchar(60)
* expires_at : datetime
* used_at : datetime
* created_at : datetime
v edbroad_ai_sumanth permission_actions
* id : int(11)
* action_code : varchar(80)
* action_name : varchar(120)
* display_order : int(11)
* is_active : tinyint(4)
* delete_status : tinyint(4)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth permission_modules
* id : int(11)
* module_code : varchar(100)
* module_name : varchar(150)
* module_icon : varchar(100)
* module_order : int(11)
* module_group : varchar(100)
* display_order : int(11)
* is_active : tinyint(4)
* delete_status : tinyint(4)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth role_menu_access
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* role_id : int(11)
* menu_code : varchar(100)
* can_view : tinyint(4)
* delete_status : tinyint(4)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth role_permissions
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* role_id : int(11)
* module_code : varchar(100)
* action_code : varchar(80)
* is_allowed : tinyint(4)
* delete_status : tinyint(4)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth students
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* student_code : varchar(50)
* admission_no : varchar(50)
* admission_date : date
* first_name : varchar(100)
* middle_name : varchar(100)
* last_name : varchar(100)
* full_name : varchar(255)
* gender : varchar(20)
* dob : date
* blood_group : varchar(10)
* mobile_no : varchar(20)
* email : varchar(150)
* photo : varchar(255)
* aadhaar_no : varchar(30)
* religion : varchar(80)
* category : varchar(80)
* caste : varchar(100)
* nationality : varchar(80)
* mother_tongue : varchar(80)
* student_status : enum('Draft','Verification','Active','Inactive','TC Requested','TC Issued','Alumni')
* parent_app_status : enum('Pending','Invite Sent','Activated','Disabled')
* mobile_app_enabled : tinyint(1)
* ai_attendance_risk : varchar(30)
* ai_academic_risk : varchar(30)
* ai_fee_risk : varchar(30)
* ai_dropout_risk : varchar(30)
* ai_discipline_risk : varchar(50)
* ai_overall_risk_score : decimal(5,2)
* ai_recommendation : text
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth student_academic_mapping
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* student_id : int(11)
* academic_year_id : int(11)
* academic_year_name : varchar(50)
* board_id : int(11)
* board_name : varchar(100)
* division_id : int(11)
* division_name : varchar(100)
* class_id : int(11)
* class_name : varchar(100)
* section_id : int(11)
* section_name : varchar(100)
* roll_no : varchar(50)
* house_name : varchar(100)
* admission_type : enum('New Admission','Transfer Admission','Promoted','Re-admission')
* previous_academic_year_id : int(11)
* previous_academic_year_name : varchar(50)
* previous_class : varchar(100)
* previous_section : varchar(100)
* mapping_status : enum('Mapped','Unmapped','Promoted','Transferred')
* is_current : tinyint(1)
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth student_admission_details
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* student_id : int(11)
* admission_source : varchar(100)
* enquiry_no : varchar(50)
* application_no : varchar(50)
* admission_type : enum('New Admission','Transfer Admission','Promoted','Re-admission')
* previous_school : varchar(255)
* previous_class : varchar(50)
* previous_percentage : varchar(30)
* previous_tc_no : varchar(100)
* counsellor_name : varchar(150)
* admission_approved_by : varchar(150)
* admission_approved_date : date
* verification_status : enum('Pending','Verified','Rejected')
* verification_remarks : text
* public_remarks : text
* internal_notes : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth student_ai_insights
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* student_id : int(11)
* academic_year_id : int(11)
* attendance_score : decimal(5,2)
* academic_score : decimal(5,2)
* fee_risk_score : decimal(5,2)
* behaviour_score : decimal(5,2)
* health_risk_score : decimal(5,2)
* overall_risk_score : decimal(5,2)
* attendance_risk : enum('Normal','Watch','Medium','High')
* academic_risk : enum('Normal','Watch','Medium','High')
* fee_risk : enum('Normal','Watch','Medium','High')
* behaviour_risk : enum('Normal','Watch','Medium','High')
* dropout_risk : enum('Normal','Watch','Medium','High')
* ai_summary : text
* ai_recommendation : text
* next_action : text
* action_owner : varchar(150)
* action_due_date : date
* action_status : enum('Pending','In Progress','Completed','Ignored')
* generated_date : date
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth student_attendance_daily
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* unit_id : int(11)
* academic_year_id : int(11)
* term_id : int(11)
* attendance_date : date
* student_id : int(11)
* admission_id : int(11)
* admission_no : varchar(80)
* student_code : varchar(80)
* student_name : varchar(180)
* board_id : int(11)
* division_id : int(11)
* class_id : int(11)
* section_id : int(11)
* class_name : varchar(150)
* section_name : varchar(150)
* roll_no : varchar(80)
* session_id : int(11)
* attendance_scope : enum('daily','session','period','subject','lab','event')
* attendance_mode : enum('class_teacher','subject_teacher','quick_entry','biometric','mobile_app','import','api','admin')
* timetable_period_id : int(11)
* subject_id : int(11)
* teacher_id : int(11)
* attendance_status : enum('present','absent','late','half_day','leave','permission','holiday','not_marked')
* morning_status : enum('present','absent','late','leave','permission','not_marked')
* afternoon_status : enum('present','absent','late','leave','permission','not_marked')
* in_time : time
* out_time : time
* late_minutes : int(11)
* reason_id : int(11)
* reason_title : varchar(180)
* remarks : text
* parent_notified : tinyint(1)
* notification_status : enum('pending','sent','failed','skipped')
* notification_sent_at : datetime
* source_type : enum('manual','import','biometric','mobile_app','api')
* device_reference : varchar(150)
* import_batch_no : varchar(120)
* is_locked : tinyint(1)
* locked_by : int(11)
* locked_at : datetime
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* deleted_by : int(11)
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth student_attendance_device_logs
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* unit_id : int(11)
* device_id : varchar(120)
* device_name : varchar(180)
* student_id : int(11)
* student_code : varchar(80)
* admission_no : varchar(80)
* punch_datetime : datetime
* punch_type : enum('in','out','unknown')
* raw_payload : text
* sync_status : enum('pending','mapped','failed','ignored')
* attendance_id : int(11)
* error_message : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* created_at : datetime
v edbroad_ai_sumanth student_attendance_import_logs
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* unit_id : int(11)
* import_type : enum('excel','csv','biometric','mobile_app','api')
* import_batch_no : varchar(120)
* file_name : varchar(255)
* file_path : varchar(255)
* total_rows : int(11)
* success_rows : int(11)
* failed_rows : int(11)
* skipped_rows : int(11)
* import_status : enum('pending','processing','completed','failed','cancelled')
* error_summary : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* created_at : datetime
* completed_at : datetime
v edbroad_ai_sumanth student_attendance_monthly_summary
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* unit_id : int(11)
* academic_year_id : int(11)
* term_id : int(11)
* student_id : int(11)
* admission_id : int(11)
* admission_no : varchar(80)
* student_code : varchar(80)
* student_name : varchar(180)
* board_id : int(11)
* division_id : int(11)
* class_id : int(11)
* section_id : int(11)
* class_name : varchar(150)
* section_name : varchar(150)
* roll_no : varchar(80)
* subject_id : int(11)
* summary_month : tinyint(4)
* summary_year : smallint(6)
* total_working_days : decimal(8,2)
* present_days : decimal(8,2)
* absent_days : decimal(8,2)
* late_days : decimal(8,2)
* half_days : decimal(8,2)
* leave_days : decimal(8,2)
* permission_days : decimal(8,2)
* attendance_percentage : decimal(6,2)
* required_percentage : decimal(6,2)
* shortage_percentage : decimal(6,2)
* shortage_days : decimal(8,2)
* risk_level : enum('low','medium','high','critical')
* ai_remark : varchar(255)
* is_locked : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth student_attendance_notification_log
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* unit_id : int(11)
* attendance_id : int(11)
* student_id : int(11)
* admission_id : int(11)
* notification_type : enum('absent','late','half_day','leave','permission','shortage','summary','custom')
* channel : enum('whatsapp','sms','email','mobile_app')
* recipient_type : enum('father','mother','guardian','student','other')
* recipient_name : varchar(180)
* recipient_mobile : varchar(40)
* recipient_email : varchar(180)
* message_title : varchar(180)
* message_text : text
* send_status : enum('pending','sent','failed','skipped')
* provider_name : varchar(120)
* provider_reference : varchar(180)
* response_text : text
* sent_at : datetime
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* created_at : datetime
v edbroad_ai_sumanth student_attendance_reasons
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* unit_id : int(11)
* reason_type : enum('absent','late','leave','half_day','permission','present','other')
* reason_title : varchar(150)
* reason_code : varchar(80)
* is_parent_visible : tinyint(1)
* requires_document : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* deleted_by : int(11)
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth student_attendance_sessions
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* unit_id : int(11)
* academic_year_id : int(11)
* term_id : int(11)
* session_name : varchar(150)
* session_code : varchar(80)
* session_type : enum('full_day','morning','afternoon','period','subject','lab','event')
* start_time : time
* end_time : time
* late_after_time : time
* display_order : int(11)
* is_default : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* deleted_by : int(11)
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v edbroad_ai_sumanth student_attendance_settings
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* unit_id : int(11)
* setting_key : varchar(120)
* setting_value : text
* setting_group : varchar(120)
* input_type : enum('text','number','time','select','textarea','toggle','json')
* display_label : varchar(180)
* display_order : int(11)
* is_editable : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth student_counselling_records
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* student_id : int(11)
* discipline_record_id : int(11)
* session_date : date
* session_type : enum('Counselling','Parent Meeting','Teacher Review','Principal Review')
* conducted_by : varchar(150)
* counselling_notes : text
* improvement_plan : text
* next_followup_date : date
* followup_status : enum('Pending','Completed','Closed')
* parent_present : enum('Yes','No')
* parent_remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth student_discipline_records
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* student_id : int(11)
* incident_date : date
* incident_type : enum('Behaviour','Late Coming','Uniform','Misconduct','Bullying','Other')
* severity : enum('Low','Medium','High','Critical')
* reported_by : varchar(150)
* incident_description : text
* action_taken : varchar(150)
* parent_status : enum('Not Informed','Informed','Meeting Scheduled','Meeting Done')
* record_status : enum('Open','Action Taken','Counselling','Closed')
* followup_date : date
* counsellor_name : varchar(150)
* ai_risk_flag : enum('Normal','Watch','Medium','High Risk')
* teacher_remarks : text
* admin_remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth student_documents
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* student_id : int(11)
* document_type : varchar(150)
* document_name : varchar(150)
* file_name : varchar(255)
* file_path : varchar(255)
* file_type : varchar(50)
* file_size : varchar(50)
* document_status : enum('Pending','Partial','Verified','Missing','Rejected')
* verification_status : enum('Waiting','Office Verified','Rejected')
* expiry_date : date
* uploaded_by_type : enum('Admin','Office','Parent App','Student App')
* uploaded_by : int(11)
* verified_by : int(11)
* verified_date : date
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth student_health_incidents
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* student_id : int(11)
* incident_date : date
* incident_type : varchar(100)
* description : text
* action_taken : text
* parent_notified : enum('Yes','No')
* notified_to : varchar(150)
* notified_mobile : varchar(20)
* handled_by : varchar(150)
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth student_health_records
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* student_id : int(11)
* blood_group : varchar(10)
* height : varchar(50)
* weight : varchar(50)
* vision : varchar(100)
* allergies : text
* chronic_condition : text
* medication : text
* doctor_name : varchar(150)
* doctor_mobile : varchar(20)
* preferred_hospital : varchar(255)
* emergency_name : varchar(150)
* emergency_mobile : varchar(20)
* emergency_relation : varchar(80)
* vaccination_status : enum('Updated','Pending','Not Available')
* last_checkup_date : date
* special_care_required : enum('No','Yes')
* special_care_notes : text
* visible_to_teacher : enum('Yes','No')
* alert_level : enum('Normal','Attention','Critical')
* record_status : enum('Complete','Incomplete','Review Required')
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth student_import_logs
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* import_file_name : varchar(255)
* import_file_path : varchar(255)
* total_rows : int(11)
* success_rows : int(11)
* failed_rows : int(11)
* import_status : enum('Pending','Processing','Completed','Failed')
* error_file_name : varchar(255)
* error_file_path : varchar(255)
* imported_by : int(11)
* imported_at : datetime
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth student_parent_guardians
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* student_id : int(11)
* father_name : varchar(150)
* father_mobile : varchar(20)
* father_email : varchar(150)
* father_occupation : varchar(150)
* father_income : varchar(50)
* father_aadhaar : varchar(30)
* mother_name : varchar(150)
* mother_mobile : varchar(20)
* mother_email : varchar(150)
* mother_occupation : varchar(150)
* mother_income : varchar(50)
* mother_aadhaar : varchar(30)
* guardian_name : varchar(150)
* guardian_relation : varchar(80)
* guardian_mobile : varchar(20)
* guardian_email : varchar(150)
* primary_contact : enum('Father','Mother','Guardian')
* login_mobile : varchar(20)
* parent_app_status : enum('Pending','Invite Sent','Activated','Disabled')
* parent_app_enabled : tinyint(1)
* communication_preference : enum('App','WhatsApp','SMS','Email','Call')
* notification_language : varchar(50)
* attendance_alerts : tinyint(1)
* fee_reminders : tinyint(1)
* result_notifications : tinyint(1)
* homework_alerts : tinyint(1)
* emergency_name : varchar(150)
* emergency_mobile : varchar(20)
* emergency_relation : varchar(80)
* address : text
* city : varchar(100)
* state : varchar(100)
* pincode : varchar(20)
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth student_status_history
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* student_id : int(11)
* old_status : varchar(80)
* new_status : varchar(80)
* status_change_date : date
* reason : text
* changed_by : int(11)
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth student_tc_requests
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* student_id : int(11)
* admission_no : varchar(50)
* tc_no : varchar(80)
* request_date : date
* leaving_date : date
* leaving_reason : enum('Parent Transfer','School Change','Completed Course','Relocation','Other')
* reason_details : text
* fee_clearance : enum('Pending','Clear','Hold')
* library_clearance : enum('Pending','Clear','Hold')
* transport_clearance : enum('Pending','Clear','Hold')
* document_clearance : enum('Pending','Clear','Hold')
* fee_due_amount : decimal(12,2)
* library_due_amount : decimal(12,2)
* transport_due_amount : decimal(12,2)
* clearance_status : enum('Pending','Clear','Hold')
* approval_status : enum('Draft','Pending','Approved','Rejected','Issued')
* approved_by : varchar(150)
* approved_date : date
* issued_date : date
* print_status : enum('Not Printed','Printed')
* student_final_status : enum('Active','TC Requested','TC Issued','Alumni','Inactive')
* qr_code : varchar(150)
* qr_verify_url : varchar(255)
* office_remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth system_menus
* id : int(11)
* menu_code : varchar(100)
* parent_code : varchar(100)
* menu_title : varchar(150)
* menu_url : varchar(255)
* menu_icon : varchar(30)
* module_code : varchar(100)
* display_order : int(11)
* is_active : tinyint(4)
* delete_status : tinyint(4)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_activity_logs
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* log_type : enum('MASTER_SETUP','TEACHER_SELF_ENTRY','AI_GENERATION','MANUAL_ADJUST','LOCK','UNLOCK','APPROVAL','PUBLISH','UNPUBLISH','VERSION','ROOM_BOOKING','DAILY_CHANGE','LEAVE','SUBSTITUTION','IMPORT','REPORT','OTHER')
* reference_table : varchar(100)
* reference_id : int(11)
* action_name : varchar(150)
* description : text
* old_data_json : longtext
* new_data_json : longtext
* ip_address : varchar(100)
* user_agent : text
* delete_status : tinyint(1)
* created_by : int(11)
* created_at : datetime
v edbroad_ai_sumanth timetable_ai_suggestions
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* suggestion_context : enum('GENERATION','CONFLICT_FIX','MANUAL_ADJUST','SUBSTITUTION','WORKLOAD_BALANCE','ROOM_OPTIMIZATION')
* reference_id : int(11)
* suggestion_title : varchar(255)
* suggestion_body : text
* suggested_teacher_id : int(11)
* suggested_subject_id : int(11)
* suggested_room_id : int(11)
* suggested_period_id : int(11)
* suggested_day_name : varchar(20)
* score_percentage : decimal(5,2)
* reason_json : longtext
* status : enum('PENDING','ACCEPTED','REJECTED','EXPIRED')
* action_by : int(11)
* action_at : datetime
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_block_rules
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* class_id : int(11)
* section_id : int(11)
* subject_id : int(11)
* block_name : varchar(150)
* block_type : enum('DOUBLE_PERIOD','TRIPLE_PERIOD','LAB_BLOCK','PROJECT_BLOCK','CUSTOM')
* period_count : int(11)
* preferred_day : varchar(20)
* preferred_start_period_id : int(11)
* is_mandatory : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_conflict_logs
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* generation_batch_id : int(11)
* version_id : int(11)
* timetable_entry_id : int(11)
* conflict_type : enum('TEACHER_DOUBLE_BOOKING','ROOM_DOUBLE_BOOKING','CLASS_DOUBLE_BOOKING','SUBJECT_QUOTA_MISMATCH','CONTINUOUS_SUBJECT_NOT_ALLOWED','TEACHER_PREFERENCE_VIOLATION','ROOM_TYPE_MISMATCH','LOCKED_SLOT_CONFLICT','PUBLISHED_SLOT_CONFLICT','OTHER')
* severity : enum('LOW','MEDIUM','HIGH','CRITICAL')
* conflict_message : text
* suggested_action : text
* status : enum('OPEN','IGNORED','RESOLVED')
* resolved_by : int(11)
* resolved_at : datetime
* resolution_remarks : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_constraints
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* constraint_name : varchar(200)
* constraint_code : varchar(100)
* constraint_type : enum('TEACHER','CLASS','SECTION','SUBJECT','ROOM','PERIOD','DAY','WORKLOAD','DISTRIBUTION','CUSTOM')
* rule_level : enum('HARD','SOFT')
* priority_level : enum('LOW','NORMAL','HIGH','MANDATORY')
* target_teacher_id : int(11)
* target_class_id : int(11)
* target_section_id : int(11)
* target_subject_id : int(11)
* target_room_id : int(11)
* target_period_id : int(11)
* target_day_name : varchar(20)
* operator_type : enum('ALLOW','AVOID','BLOCK','LIMIT','PREFER','REQUIRE','BALANCE')
* rule_value : varchar(255)
* rule_json : longtext
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_daily_changes
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* change_date : date
* day_name : varchar(20)
* change_type : enum('FOLLOW_OTHER_DAY','SPECIAL_PERIOD','ROOM_CHANGE','TEACHER_CHANGE','SUBJECT_CHANGE','CLASS_CANCELLED','EXAM_MODE','EVENT_MODE')
* original_timetable_entry_id : int(11)
* class_id : int(11)
* section_id : int(11)
* period_id : int(11)
* new_day_name : varchar(20)
* new_subject_id : int(11)
* new_teacher_id : int(11)
* new_room_id : int(11)
* reason : text
* status : enum('DRAFT','APPROVED','PUBLISHED','CANCELLED')
* approved_by : int(11)
* approved_at : datetime
* published_by : int(11)
* published_at : datetime
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_entries
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* generation_batch_id : int(11)
* version_id : int(11)
* schedule_mode : enum('WEEKLY','DATE_SPECIFIC')
* timetable_date : date
* day_name : varchar(20)
* period_id : int(11)
* period_order : int(11)
* class_id : int(11)
* section_id : int(11)
* subject_id : int(11)
* teacher_id : int(11)
* room_id : int(11)
* slot_type : enum('REGULAR','BLOCK','LAB','BREAK','FREE','SUBSTITUTION','SPECIAL','EXAM','EVENT')
* entry_status : enum('DRAFT','REVIEWED','APPROVED','PUBLISHED')
* source_type : enum('AI_GENERATED','MANUAL','TEACHER_SELF_ENTRY','IMPORT','SUBSTITUTION','DAILY_CHANGE')
* status : enum('DRAFT','ACTIVE','LOCKED','CANCELLED','REPLACED')
* is_published : tinyint(1)
* published_at : datetime
* is_locked : tinyint(1)
* locked_by : int(11)
* locked_at : datetime
* is_ai_generated : tinyint(1)
* ai_score : decimal(5,2)
* ai_reason : text
* parent_entry_id : int(11)
* remarks : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_feasibility_checks
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* check_batch_code : varchar(100)
* class_id : int(11)
* section_id : int(11)
* check_type : enum('SLOT_CAPACITY','TEACHER_LOAD','ROOM_AVAILABILITY','SUBJECT_QUOTA','MAPPING_MISSING','CONSTRAINT_OVERLOAD','DUPLICATE_RULE','PERIOD_MISSING','OTHER')
* severity : enum('INFO','WARNING','ERROR','BLOCKER')
* message : text
* suggested_fix : text
* status : enum('OPEN','FIXED','IGNORED')
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_generation_batches
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* batch_code : varchar(100)
* batch_name : varchar(150)
* generation_mode : enum('CLASS_SECTION','FULL_SCHOOL','TEACHER_BALANCED','ROOM_OPTIMIZED','MANUAL_DRAFT')
* class_id : int(11)
* section_id : int(11)
* status : enum('DRAFT','GENERATING','GENERATED','FAILED','LOCKED','ARCHIVED')
* approval_status : enum('NOT_REQUIRED','PENDING','APPROVED','REJECTED')
* approved_by : int(11)
* approved_at : datetime
* approval_remarks : text
* is_active_version : tinyint(1)
* published_version_id : int(11)
* ai_engine_version : varchar(50)
* rules_snapshot_json : longtext
* generation_summary_json : longtext
* total_slots : int(11)
* filled_slots : int(11)
* conflict_count : int(11)
* score_percentage : decimal(5,2)
* generated_by : int(11)
* generated_at : datetime
* locked_by : int(11)
* locked_at : datetime
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_import_logs
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* import_type : enum('PERIODS','ROOMS','QUOTAS','TEACHER_MAPPING','TIMETABLE_ENTRIES','FULL_IMPORT')
* file_name : varchar(255)
* file_path : varchar(500)
* total_rows : int(11)
* success_rows : int(11)
* failed_rows : int(11)
* status : enum('UPLOADED','PROCESSING','COMPLETED','FAILED')
* error_json : longtext
* summary_json : longtext
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_notifications
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* notification_type : enum('PUBLISH','SUBSTITUTION','DAILY_REMINDER','CHANGE_ALERT','VISIBILITY')
* audience_type : enum('TEACHER','STUDENT','PARENT','CLASS_TEACHER','ADMIN')
* channel : enum('APP','WHATSAPP','EMAIL','SMS')
* class_id : int(11)
* section_id : int(11)
* title : varchar(180)
* message : text
* recipient_count : int(11)
* success_count : int(11)
* failed_count : int(11)
* status : enum('DRAFT','READY','SENT','FAILED','CANCELLED')
* send_mode : enum('NOW','SAVE_ONLY')
* sent_at : datetime
* failed_reason : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_period_master
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* period_name : varchar(100)
* period_code : varchar(50)
* period_order : int(11)
* start_time : time
* end_time : time
* duration_minutes : int(11)
* is_break : tinyint(1)
* break_name : varchar(100)
* applicable_days : varchar(100)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_publish_logs
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* version_id : int(11)
* generation_batch_id : int(11)
* publish_scope : enum('FULL_SCHOOL','CLASS','SECTION','TEACHER','ROOM')
* class_id : int(11)
* section_id : int(11)
* teacher_id : int(11)
* room_id : int(11)
* publish_status : enum('PUBLISHED','UNPUBLISHED','SCHEDULED')
* publish_to_teacher : tinyint(1)
* publish_to_student : tinyint(1)
* publish_to_parent : tinyint(1)
* publish_to_mobile_app : tinyint(1)
* scheduled_at : datetime
* published_by : int(11)
* published_at : datetime
* remarks : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_room_bookings
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* booking_date : date
* day_name : varchar(20)
* from_period_id : int(11)
* to_period_id : int(11)
* room_id : int(11)
* booking_title : varchar(200)
* booking_type : enum('CLASS','LAB','MEETING','EVENT','EXAM','ACTIVITY','OTHER')
* class_id : int(11)
* section_id : int(11)
* teacher_id : int(11)
* description : text
* status : enum('PENDING','APPROVED','REJECTED','CANCELLED')
* approved_by : int(11)
* approved_at : datetime
* approval_remarks : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_room_master
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* room_name : varchar(150)
* room_code : varchar(50)
* room_type : enum('CLASSROOM','LAB','LIBRARY','HALL','SPORTS','AUDITORIUM','STAFF_ROOM','OTHER')
* capacity : int(11)
* floor_name : varchar(100)
* building_name : varchar(150)
* is_shared : tinyint(1)
* requires_approval : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_subject_quota
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* class_id : int(11)
* section_id : int(11)
* subject_id : int(11)
* weekly_periods : int(11)
* min_periods_per_week : int(11)
* max_periods_per_week : int(11)
* max_periods_per_day : int(11)
* allow_continuous : tinyint(1)
* requires_room_type : enum('NONE','LAB','LIBRARY','HALL','SPORTS','AUDITORIUM','OTHER')
* priority_level : enum('LOW','NORMAL','HIGH','MANDATORY')
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_substitutions
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* substitution_date : date
* day_name : enum('mon','tue','wed','thu','fri','sat','sun')
* original_entry_id : int(11)
* generation_batch_id : int(11)
* version_id : int(11)
* class_id : int(11)
* section_id : int(11)
* period_id : int(11)
* subject_id : int(11)
* room_id : int(11)
* absent_teacher_id : int(11)
* substitute_teacher_id : int(11)
* reason_type : enum('ABSENT','LEAVE','MEETING','TRAINING','EMERGENCY','OTHER')
* reason_note : text
* status : enum('DRAFT','ASSIGNED','NOTIFIED','COMPLETED','CANCELLED')
* notification_sent : tinyint(1)
* notification_sent_at : datetime
* completed_at : datetime
* cancelled_at : datetime
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_substitution_logs
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* leave_id : int(11)
* original_timetable_entry_id : int(11)
* substitution_date : date
* day_name : varchar(20)
* period_id : int(11)
* class_id : int(11)
* section_id : int(11)
* subject_id : int(11)
* room_id : int(11)
* absent_teacher_id : int(11)
* substitute_teacher_id : int(11)
* suggestion_type : enum('SAME_SUBJECT','SAME_CLASS','FREE_TEACHER','LOWEST_LOAD','MANUAL')
* status : enum('SUGGESTED','APPROVED','REJECTED','PUBLISHED','COMPLETED','CANCELLED')
* ai_score : decimal(5,2)
* ai_reason : text
* remarks : text
* approved_by : int(11)
* approved_at : datetime
* published_by : int(11)
* published_at : datetime
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_teacher_leave
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* teacher_id : int(11)
* leave_date : date
* leave_type : enum('FULL_DAY','HALF_DAY','PERIOD_WISE')
* from_period_id : int(11)
* to_period_id : int(11)
* reason : text
* status : enum('PENDING','APPROVED','REJECTED','CANCELLED')
* approved_by : int(11)
* approved_at : datetime
* approval_remarks : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_teacher_mapping
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* teacher_id : int(11)
* subject_id : int(11)
* class_id : int(11)
* section_id : int(11)
* mapping_type : enum('PRIMARY','SECONDARY','SUBSTITUTE','TEMPORARY')
* max_periods_per_day : int(11)
* max_periods_per_week : int(11)
* effective_from : date
* effective_to : date
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_teacher_preferences
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* teacher_id : int(11)
* preference_type : enum('DAY_OFF','PREFERRED_DAY','AVOID_DAY','PREFERRED_PERIOD','AVOID_PERIOD','MAX_DAILY_LOAD','MAX_WEEKLY_LOAD','CUSTOM')
* day_name : varchar(20)
* period_id : int(11)
* preference_value : varchar(255)
* priority_level : enum('LOW','NORMAL','HIGH','MANDATORY')
* remarks : text
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_teacher_self_entries
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* teacher_id : int(11)
* entry_date : date
* day_name : varchar(20)
* period_id : int(11)
* class_id : int(11)
* section_id : int(11)
* subject_id : int(11)
* room_id : int(11)
* entry_type : enum('PREFERRED','AVAILABLE','NOT_AVAILABLE','PLANNED_CLASS','REQUESTED_SLOT')
* status : enum('PENDING','APPROVED','REJECTED','USED_IN_AI')
* remarks : text
* approved_by : int(11)
* approved_at : datetime
* approval_remarks : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_versions
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* generation_batch_id : int(11)
* version_name : varchar(150)
* version_code : varchar(100)
* class_id : int(11)
* section_id : int(11)
* effective_from : date
* effective_to : date
* status : enum('DRAFT','UNDER_REVIEW','APPROVED','PUBLISHED','ARCHIVED')
* is_published : tinyint(1)
* total_slots : int(11)
* conflict_count : int(11)
* approved_by : int(11)
* approved_at : datetime
* published_by : int(11)
* published_at : datetime
* remarks : text
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth timetable_visibility_settings
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* teacher_visible : tinyint(1)
* student_visible : tinyint(1)
* parent_visible : tinyint(1)
* substitution_overlay_visible : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth transport_ai_insights
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* insight_date : date
* insight_type : enum('Delay Pattern','Route Optimization','Fuel Usage','Maintenance Risk','Student Safety','Driver Performance','Vehicle Utilization','Parent Complaint Pattern','Other')
* route_id : int(11)
* vehicle_id : int(11)
* driver_id : int(11)
* insight_title : varchar(200)
* insight_summary : text
* recommendation : text
* risk_level : enum('Low','Medium','High','Critical')
* action_status : enum('New','Reviewed','Action Taken','Ignored')
* reviewed_by : int(11)
* reviewed_at : datetime
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth transport_alerts
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* alert_date : date
* alert_type : enum('Delay','Breakdown','Emergency','Route Deviation','Overspeed','Student Missing Pickup','Student Missing Drop','GPS Offline','Maintenance Due','Document Expiry','Other')
* priority : enum('Low','Medium','High','Critical')
* route_id : int(11)
* vehicle_id : int(11)
* driver_id : int(11)
* student_id : int(11)
* trip_session_id : int(11)
* latitude : decimal(10,7)
* longitude : decimal(10,7)
* alert_title : varchar(200)
* alert_message : text
* alert_status : enum('Open','In Progress','Resolved','Closed')
* resolved_by : int(11)
* resolved_at : datetime
* resolution_note : text
* resolution_notes : text
* parent_notified : tinyint(1)
* admin_notified : tinyint(1)
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth transport_drivers
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* driver_code : varchar(50)
* driver_name : varchar(150)
* driver_type : enum('Driver','Helper','Supervisor')
* mobile_no : varchar(20)
* alternate_mobile_no : varchar(20)
* email : varchar(150)
* address : text
* license_no : varchar(100)
* license_type : varchar(100)
* license_expiry_date : date
* aadhaar_no : varchar(50)
* police_verification_status : enum('Pending','Verified','Rejected')
* medical_fitness_status : enum('Pending','Fit','Unfit')
* app_login_enabled : tinyint(1)
* app_username : varchar(100)
* app_password_hash : varchar(255)
* last_login_at : datetime
* driver_status : enum('Active','Inactive','On Leave','Terminated')
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth transport_fuel_logs
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* vehicle_id : int(11)
* fuel_date : date
* fuel_type : enum('Diesel','Petrol','CNG','Electric','Other')
* litres : decimal(10,2)
* rate_per_litre : decimal(10,2)
* total_amount : decimal(10,2)
* odometer_reading : int(11)
* fuel_station_name : varchar(200)
* bill_no : varchar(100)
* entered_by_driver_id : int(11)
* approved_by : int(11)
* approval_status : enum('Pending','Approved','Rejected')
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth transport_live_locations
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* trip_session_id : int(11)
* route_id : int(11)
* vehicle_id : int(11)
* driver_id : int(11)
* latitude : decimal(12,8)
* longitude : decimal(12,8)
* speed_kmph : decimal(10,2)
* heading : varchar(50)
* battery_level : int(11)
* gps_accuracy : decimal(10,2)
* nearest_stop_id : int(11)
* next_stop_id : int(11)
* eta_to_next_stop_min : int(11)
* location_source : enum('Driver App','GPS Device','Manual')
* recorded_at : datetime
* created_by : int(11)
* delete_status : tinyint(1)
v edbroad_ai_sumanth transport_parent_notifications
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* student_id : int(11)
* parent_mobile_no : varchar(20)
* trip_session_id : int(11)
* route_id : int(11)
* vehicle_id : int(11)
* notification_type : enum('Bus Started','Bus Near Stop','Student Picked','Student Dropped','Bus Delayed','Route Changed','Emergency','Trip Completed','Other')
* notification_title : varchar(200)
* notification_message : text
* channel : enum('WhatsApp','SMS','App Push','Email','All')
* send_status : enum('Pending','Sent','Failed')
* sent_at : datetime
* failed_reason : text
* created_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
v edbroad_ai_sumanth transport_routes
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* route_code : varchar(50)
* route_name : varchar(150)
* route_direction : enum('Morning','Evening','Both')
* start_point : varchar(200)
* end_point : varchar(200)
* total_distance_km : decimal(10,2)
* estimated_duration_min : int(11)
* vehicle_id : int(11)
* driver_id : int(11)
* helper_id : int(11)
* morning_start_time : time
* morning_end_time : time
* evening_start_time : time
* evening_end_time : time
* route_status : enum('Active','Inactive','Temporary Closed')
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth transport_route_stops
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* route_id : int(11)
* stop_code : varchar(50)
* stop_name : varchar(200)
* stop_address : text
* stop_sequence : int(11)
* morning_pickup_time : time
* evening_drop_time : time
* latitude : decimal(12,8)
* longitude : decimal(12,8)
* distance_from_previous_km : decimal(10,2)
* distance_from_school_km : decimal(10,2)
* waiting_minutes : int(11)
* stop_status : enum('Active','Inactive')
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth transport_route_timeline_logs
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* trip_session_id : int(11)
* trip_date : date
* route_id : int(11)
* vehicle_id : int(11)
* driver_id : int(11)
* stop_id : int(11)
* timeline_type : enum('Trip Started','Reached Stop','Left Stop','Student Picked','Student Dropped','Delay','Breakdown','Route Changed','Trip Completed','Manual Note')
* timeline_title : varchar(200)
* timeline_message : text
* latitude : decimal(12,8)
* longitude : decimal(12,8)
* event_time : datetime
* visible_to_parent : tinyint(1)
* visible_to_admin : tinyint(1)
* created_by : int(11)
* delete_status : tinyint(1)
v edbroad_ai_sumanth transport_student_allocation
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* academic_year_id : int(11)
* student_id : int(11)
* admission_no : varchar(100)
* student_name : varchar(150)
* class_id : int(11)
* section_id : int(11)
* route_id : int(11)
* vehicle_id : int(11)
* pickup_stop_id : int(11)
* drop_stop_id : int(11)
* transport_type : enum('Pickup Only','Drop Only','Both')
* fee_category : varchar(100)
* monthly_fee : decimal(10,2)
* start_date : date
* end_date : date
* parent_mobile_no : varchar(20)
* emergency_contact_no : varchar(20)
* allocation_status : enum('Active','Inactive','Stopped')
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth transport_student_trip_status
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* trip_session_id : int(11)
* trip_date : date
* trip_type : enum('Morning Pickup','Evening Drop')
* student_id : int(11)
* admission_no : varchar(100)
* student_name : varchar(150)
* route_id : int(11)
* vehicle_id : int(11)
* stop_id : int(11)
* status : enum('Pending','Picked','Dropped','Absent','Not Available','Skipped')
* status_time : datetime
* latitude : decimal(12,8)
* longitude : decimal(12,8)
* confirmed_by : enum('Driver','Helper','Parent','Admin','System')
* parent_notified : tinyint(1)
* notification_sent_at : datetime
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth transport_trip_sessions
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* trip_date : date
* trip_type : enum('Morning Pickup','Evening Drop','Special Trip')
* route_id : int(11)
* vehicle_id : int(11)
* driver_id : int(11)
* helper_id : int(11)
* start_time : datetime
* end_time : datetime
* start_latitude : decimal(12,8)
* start_longitude : decimal(12,8)
* end_latitude : decimal(12,8)
* end_longitude : decimal(12,8)
* current_stop_id : int(11)
* next_stop_id : int(11)
* trip_status : enum('Scheduled','Started','Running','Paused','Completed','Cancelled')
* delay_minutes : int(11)
* delay_reason : varchar(255)
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth transport_vehicles
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* vehicle_code : varchar(50)
* vehicle_name : varchar(150)
* vehicle_type : varchar(50)
* registration_no : varchar(50)
* chassis_no : varchar(100)
* engine_no : varchar(100)
* seating_capacity : int(11)
* gps_device_id : varchar(100)
* gps_imei_no : varchar(100)
* insurance_expiry_date : date
* fitness_expiry_date : date
* pollution_expiry_date : date
* permit_expiry_date : date
* tax_expiry_date : date
* vehicle_status : enum('Active','Inactive','Maintenance','Sold')
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth transport_vehicle_maintenance
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* vehicle_id : int(11)
* maintenance_date : date
* maintenance_type : enum('Regular Service','Repair','Tyre','Battery','Oil Change','Fitness','Other')
* odometer_reading : int(11)
* service_center_name : varchar(200)
* invoice_no : varchar(100)
* amount : decimal(10,2)
* next_service_date : date
* next_service_km : int(11)
* maintenance_status : enum('Scheduled','In Progress','Completed','Cancelled')
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth users
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* role_id : int(11)
* employee_id : int(11)
* user_type : enum('admin','staff','teacher','accountant','librarian','security','parent','student','other')
* full_name : varchar(150)
* username : varchar(80)
* email : varchar(150)
* mobile : varchar(30)
* profile_photo : varchar(255)
* password_hash : varchar(255)
* status : enum('active','inactive')
* force_password_change : tinyint(4)
* last_login_at : datetime
* last_login_ip : varchar(60)
* login_attempts : int(11)
* locked_until : datetime
* is_super_admin : tinyint(4)
* updated_by : int(11)
* delete_status : tinyint(4)
* created_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth user_branch_access
* id : int(11)
* company_id : int(11)
* user_id : int(11)
* branch_id : int(11)
* is_default : tinyint(4)
* is_active : tinyint(4)
* delete_status : tinyint(4)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v edbroad_ai_sumanth user_roles
* id : int(11)
* company_id : int(11)
* branch_id : int(11)
* role_name : varchar(120)
* role_code : varchar(60)
* role_description : text
* is_system_role : tinyint(4)
* is_active : tinyint(4)
* delete_status : tinyint(4)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship