* id company_id branch_id academic_year_id plan_type class_id section_id subject_id teacher_id assigned_date due_date plan_title topic_focus total_students submitted_students pending_students submission_percentage estimated_workload_minutes deadline_risk_score risk_level plan_status instruction_note resource_note ai_generated ai_workload_note ai_recommendation remarks status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id activity_title activity_type activity_date start_time end_time class_ids section_ids subject_ids teacher_ids objective expected_outcome approval_status ai_suggestion_note status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id class_id section_id subject_id teacher_id source_module source_record_id gap_title gap_category gap_description detected_date target_completion_date severity_level priority_score impact_area current_value expected_value gap_value suggested_action auto_action_type suggested_owner_role suggested_owner_id ai_confidence_score ai_reasoning_note ai_recommendation action_status action_taken_note action_taken_at approval_status status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id class_id section_id subject_id teacher_id syllabus_planner_id assignment_title assignment_type assigned_date due_date instructions expected_outcome submission_required ai_generated ai_assignment_note status delete_status created_by updated_by created_at updated_at

* id company_id branch_id module_name record_id action_type old_data new_data remarks created_by created_at

* id company_id branch_id board_name board_code description display_order is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id event_title event_type start_date end_date applicable_to description is_holiday is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id term_id event_title event_type start_date end_date is_working_day applies_to class_id section_id description is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id syllabus_planner_id daily_lesson_id class_id section_id subject_id teacher_id tracking_date before_completion_percentage after_completion_percentage periods_used remaining_periods completion_note evidence_file verified_by verified_at verification_status verification_note ai_progress_note ai_delay_prediction delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id board_id division_id stream_id class_name class_code display_order is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id year_planner_id monthly_planner_id weekly_planner_id class_id section_id planner_title target_description total_subjects total_chapters completed_chapters pending_chapters syllabus_completion_percentage risk_level risk_reason ai_summary ai_recommendation approval_status status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id class_id section_id subject_id teacher_id plan_month total_subjects total_chapters completed_chapters pending_chapters delayed_chapters planned_periods completed_periods pending_periods revision_required_periods remedial_required_periods extra_class_required_periods syllabus_completion_percentage class_readiness_score risk_level planner_status class_scope coordinator_remarks ai_generated ai_class_summary ai_gap_note ai_recommendation approval_status status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id class_id section_id subject_id teacher_id year_planner_id monthly_planner_id weekly_planner_id syllabus_planner_id lesson_date period_no lesson_title lesson_objective teaching_method teaching_aid planned_content actual_content homework_given assignment_given execution_status completion_percentage teacher_execution_note student_response_note ai_generated ai_lesson_summary ai_followup_suggestion approval_status status delete_status created_by updated_by created_at updated_at

* id company_id branch_id division_name division_code description display_order is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id exam_type exam_name exam_date class_id section_id subject_id available_working_days holiday_count affected_working_days syllabus_completion_percentage pending_chapters revision_days_needed revision_window_days exam_readiness_percentage risk_score readiness_status risk_level alignment_status holiday_impact_note revision_window_note ai_generated ai_readiness_note ai_recommendation remarks status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id exam_id class_id section_id subject_id exam_date syllabus_required_percentage current_syllabus_percentage pending_percentage days_remaining working_days_remaining periods_remaining revision_required revision_days_required risk_level risk_summary ai_generated ai_exam_readiness_score ai_action_plan status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id class_id section_id subject_id teacher_id exam_name exam_type preparation_title preparation_start_date preparation_end_date exam_date syllabus_covered_percentage revision_completed_percentage question_bank_completed_percentage mock_test_completed_count important_chapters weak_chapters revision_strategy practice_plan target_average_score current_average_score expected_average_score readiness_score risk_level planner_status ai_generated ai_exam_summary ai_gap_note ai_recommendation ai_priority_score teacher_remarks hod_remarks approval_status status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id class_id section_id subject_id teacher_id syllabus_planner_id suggested_date suggested_start_time suggested_end_time suggestion_reason available_slot_source ai_generated ai_reason ai_priority_score approval_status approved_by approved_at approval_remarks notification_status notification_message status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id calendar_id class_id section_id subject_id teacher_id impacted_date lost_periods affected_chapters impact_level impact_summary recovery_required suggested_recovery_periods suggested_recovery_dates ai_generated ai_adjustment_plan status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id year_planner_id plan_year plan_month month_name month_start_date month_end_date total_days working_days holiday_days exam_days revision_days activity_days monthly_focus target_summary ai_generated ai_summary ai_risk_note ai_recommendation completion_percentage approval_status approved_by approved_at approval_remarks status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id alert_type alert_title alert_message reference_table reference_id class_id section_id subject_id teacher_id severity ai_generated ai_recommendation action_status action_taken_by action_taken_at action_note notify_principal notify_hod notify_teacher notify_parent notify_student notification_status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id run_type reference_table reference_id class_id section_id subject_id teacher_id input_payload ai_prompt ai_response ai_score ai_confidence result_status error_message generated_by generated_at delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id planner_module planner_record_id planner_title requested_by requested_role requested_at approval_level approver_id approver_role approval_status approval_remarks submitted_at approved_at rejected_at locked_at escalation_status escalation_note escalation_due_date ai_generated ai_risk_level ai_approval_note ai_recommendation status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id calendar_date day_name day_type title description is_working_day working_weight affected_classes affected_sections ai_impact_level ai_impact_note status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id report_type report_title filter_payload report_payload generated_by generated_at export_status export_file delete_status created_by updated_by created_at updated_at

* id company_id branch_id promotion_rule_id from_academic_year_id to_academic_year_id total_students promoted_students held_students transfer_students status processed_by processed_at remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id from_academic_year_id to_academic_year_id from_class_id to_class_id from_section_id to_section_id promotion_type rule_status remarks is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id class_id section_id subject_id teacher_id remedial_title remedial_reason student_group_type student_ids planned_date start_time end_time topics expected_outcome ai_generated ai_reason ai_student_risk_summary execution_status teacher_feedback status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id class_id section_id subject_id teacher_id exam_id revision_title revision_type revision_start_date revision_end_date planned_periods completed_periods chapters_covered weak_topics ai_generated ai_revision_strategy ai_expected_improvement completion_status status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id class_id section_id subject_id teacher_id syllabus_planner_id daily_lesson_id plan_type plan_title target_group target_student_count planned_date start_time end_time planned_periods topic_area learning_gap planned_activity assessment_method completion_status completion_percentage pre_assessment_score post_assessment_score improvement_percentage ai_generated ai_gap_analysis ai_recommendation ai_priority_score ai_risk_level teacher_remarks hod_remarks approval_status status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id class_id section_name section_code capacity room_no display_order is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id stream_name stream_code description display_order is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id class_id section_id subject_id teacher_id year_planner_id monthly_planner_id weekly_planner_id chapter_no chapter_title unit_name chapter_weightage estimated_periods planned_periods completed_periods remaining_periods planned_start_date planned_end_date actual_start_date actual_end_date completion_status completion_percentage is_exam_important difficulty_level ai_priority_score ai_delay_risk ai_prediction_note ai_recommendation teacher_remarks hod_remarks principal_remarks approval_status status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id teacher_id planner_date planner_type total_assigned_classes total_assigned_subjects total_planned_periods total_completed_periods total_pending_periods workload_level workload_score ai_workload_summary ai_balancing_suggestion teacher_notes hod_notes status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id teacher_id class_id section_id subject_id plan_month assigned_periods completed_periods pending_periods extra_class_periods substitution_periods assigned_lessons completed_lessons pending_lessons workload_score load_status risk_level assigned_scope teacher_remarks ai_generated ai_workload_note ai_recommendation approval_status status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id term_name term_code term_type start_date end_date sequence_no display_order is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id year_planner_id monthly_planner_id week_no week_title week_start_date week_end_date working_days holiday_days available_periods planned_periods completed_periods weekly_focus weekly_targets ai_generated ai_summary ai_gap_note ai_recommendation completion_percentage approval_status approved_by approved_at approval_remarks status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_name year_code start_date end_date is_current status remarks is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id planner_code planner_title plan_start_date plan_end_date total_working_days total_instruction_days total_revision_days total_exam_days total_activity_days total_holidays planning_strategy ai_generated ai_prompt ai_summary ai_confidence approval_status approved_by approved_at approval_remarks status delete_status created_by updated_by created_at updated_at

* id company_id branch_id application_no application_date enquiry_id admission_type student_name gender dob blood_group nationality religion category caste sub_caste mother_tongue academic_year_id academic_year_name class_id class_name section_id section_name father_name father_mobile father_email father_occupation father_income mother_name mother_mobile mother_email mother_occupation mother_income guardian_name guardian_relation guardian_mobile guardian_email primary_mobile alternate_mobile whatsapp_no primary_email current_address permanent_address city state pincode previous_school previous_class previous_board previous_percentage transfer_certificate_no sibling_available sibling_details transport_required hostel_required application_fee registration_fee fee_concession_requested fee_concession_remarks selection_status approval_status approved_by approved_at admission_no student_id admitted_at remarks delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id enquiry_id application_id channel recipient_name recipient_contact template_name subject message_body send_status provider_response sent_at delete_status created_by updated_by created_at updated_at

* id reference_type enquiry_id application_id reference_no student_name class_id class_name document_type document_name file_name file_extension file_size_kb file_path verification_status verification_remarks verified_by verified_at company_id branch_id delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id enquiry_no enquiry_date source campaign_name student_name gender dob age academic_year_id academic_year_name class_id class_name section_id section_name parent_name father_name mother_name guardian_name mobile_no alternate_mobile_no whatsapp_no email address city state pincode previous_school previous_class priority status assigned_to next_followup_date remarks converted_application_id converted_student_id delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id reference_type enquiry_id application_id reference_no student_name class_id class_name contact_person contact_no followup_date followup_time followup_type followup_status next_followup_date next_followup_time assigned_to remarks next_action company_id branch_id delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id interview_no application_id application_no enquiry_id enquiry_no student_name class_id class_name interview_type scheduled_date scheduled_time venue conducted_by conducted_by_name marks_obtained max_marks grade result_status remarks recommendation company_id branch_id delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id receipt_no payment_date enquiry_id enquiry_no application_id application_no student_name class_id class_name payer_name payer_mobile payment_type amount discount_amount net_amount payment_mode payment_status transaction_no bank_name cheque_no cheque_date remarks company_id branch_id delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id academic_year_id academic_year_name class_id class_name section_id section_name total_seats reserved_seats admitted_count waiting_count available_seats is_active remarks company_id branch_id delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id setting_key setting_label setting_value setting_type setting_group is_active company_id branch_id delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id enquiry_id application_id entity_type old_status new_status remarks created_by created_at

* id company_id branch_id key_name key_type api_key_hash api_key_prefix allowed_modules allowed_ips rate_limit_per_minute expires_at last_used_at last_used_ip is_active revoked_at revoked_by delete_status created_by updated_by created_at updated_at

* id company_id branch_id api_key_id request_path request_method request_ip user_agent status message created_at

* id company_id institution_code branch_code branch_name short_name address city state pincode phone email contact_person display_order is_main_branch is_active status delete_status created_by updated_by created_at updated_at

* id company_id branch_id user_id role_code activity_type activity_title activity_message module_code reference_id activity_url activity_time delete_status created_at

* id company_id branch_id role_code insight_type insight_title insight_message module_code score_value action_label action_url is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id role_code user_id alert_type alert_title alert_message module_code reference_id action_url is_read priority alert_date delete_status created_by updated_by created_at updated_at

* id company_id branch_id user_id role_code dashboard_code widget_key widget_title is_visible display_order widget_size settings_json delete_status created_by updated_by created_at updated_at

* id dashboard_code dashboard_title role_code user_type dashboard_url dashboard_icon is_active display_order delete_status created_by updated_by created_at updated_at

* id company_id branch_id hostel_id student_id alert_type reference_id alert_title alert_message alert_priority alert_status notify_parent notify_warden notify_admin action_by action_note delete_status created_by updated_by created_at updated_at

* id company_id branch_id hostel_id student_id allocation_id attendance_date morning_status night_status remarks marked_by delete_status created_by updated_by created_at updated_at

* id company_id branch_id hostel_id block_id room_id bed_no bed_status student_id allocation_id remarks is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id hostel_id block_name block_code floor_count room_count remarks is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id hostel_id block_id room_id student_id complaint_no complaint_type priority complaint_title complaint_description complaint_status assigned_to resolved_at resolution_note delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id student_id allocation_id hostel_id room_id bed_id rent_amount mess_amount caution_deposit other_charges discount_amount total_amount billing_cycle fee_status remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id hostel_name hostel_code hostel_type warden_name warden_mobile address total_blocks total_rooms total_beds is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id hostel_id menu_date day_name breakfast_menu lunch_menu snacks_menu dinner_menu remarks is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id hostel_id plan_name plan_type monthly_amount breakfast_enabled lunch_enabled snacks_enabled dinner_enabled is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id hostel_id student_id allocation_id request_type request_date from_datetime to_datetime reason parent_consent_status warden_status final_status approved_by out_time return_time remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id hostel_id block_id floor_no room_no room_type capacity current_occupied monthly_rent room_status remarks is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id allocation_id student_id from_hostel_id from_block_id from_room_id from_bed_id to_hostel_id to_block_id to_room_id to_bed_id transfer_date reason approved_by transfer_status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id student_id admission_no student_name class_id section_id hostel_id block_id room_id bed_id allocation_date expected_checkout_date actual_checkout_date allocation_status guardian_name guardian_mobile emergency_contact medical_notes remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id hostel_id student_id allocation_id visitor_name relation mobile_no id_proof_type id_proof_no purpose visit_date in_time out_time approval_status approved_by remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id activity_module activity_action activity_text activity_user activity_status reference_table reference_id ip_address user_agent delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id insight_date insight_type insight_title insight_description related_module related_entity_type related_entity_id severity ai_score recommended_action action_status resolved_by resolved_at resolution_notes is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id alert_date alert_title alert_message alert_category alert_priority alert_status related_module related_entity_type related_entity_id assigned_to assigned_to_name due_date closed_by closed_at closure_notes is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id snapshot_date total_employees active_employees inactive_employees present_today absent_today late_today on_leave_today open_leave_requests pending_attendance_regularizations payroll_pending_count payroll_processed_count open_recruitment_count onboarding_pending_count exit_pending_count open_helpdesk_requests escalated_helpdesk_requests training_pending_count performance_review_pending_count average_performance_score attrition_risk_score compliance_score hr_health_score snapshot_notes is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id employee_id attendance_date shift_id shift_name check_in_time check_out_time total_minutes attendance_status day_type late_minutes early_out_minutes overtime_minutes source_type approval_status remarks is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id employee_id attendance_date requested_check_in requested_check_out requested_status reason approval_status approved_by approved_at rejected_by rejected_at rejection_reason is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id shift_name shift_code start_time end_time grace_minutes half_day_minutes full_day_minutes is_default is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id category_id document_title document_code document_type related_employee_id related_module file_path file_name file_type file_size document_status remarks is_confidential is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id category_name category_code description is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id employee_code biometric_code old_employee_code salutation first_name middle_name last_name display_name gender date_of_birth blood_group marital_status nationality religion caste_category mobile_no alternate_mobile_no email personal_email current_address current_city current_state current_pincode permanent_address permanent_city permanent_state permanent_pincode joining_date confirmation_date probation_end_date resignation_date relieving_date employee_type employment_category staff_category department_name designation_name reporting_manager_id work_location shift_name employee_status attendance_applicable payroll_applicable portal_access aadhaar_no pan_no passport_no driving_license_no emergency_contact_name emergency_contact_relation emergency_contact_mobile photo_path signature_path notes is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id employee_id bank_name branch_name account_holder_name account_no ifsc_code account_type pf_no uan_no esi_no professional_tax_no tds_applicable payment_mode is_primary is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id prefix current_no padding_length financial_year is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id employee_id document_type document_title document_no issue_date expiry_date file_path file_name file_type file_size verification_status verified_by verified_at remarks is_mandatory is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id exit_id clearance_master_id clearance_title clearance_category responsible_department mandatory item_status cleared_by cleared_at remarks is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id clearance_title clearance_code clearance_category responsible_department mandatory display_order description is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id employee_id resignation_date requested_last_working_date approved_last_working_date exit_type exit_reason resignation_notes notice_period_days notice_served_days notice_shortfall_days exit_status clearance_status settlement_status exit_interview_done exit_interview_notes relieving_letter_ready experience_letter_ready ai_risk_score ai_notes approved_by approved_at rejected_by rejected_at rejection_reason remarks is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id exit_id employee_id unpaid_salary leave_encashment gratuity_amount bonus_amount other_earnings loan_recovery notice_recovery asset_recovery other_deductions gross_payable total_deductions net_payable settlement_status payment_mode payment_reference payment_date approved_by approved_at remarks is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id employee_id organization_name designation_name department_name from_date to_date total_experience last_salary reason_for_leaving experience_letter_path is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id employee_id member_name relation gender date_of_birth mobile_no occupation is_nominee nominee_percentage is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id cycle_id employee_id kpi_id kpi_title kpi_category target_value weightage max_score assignment_status remarks is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id employee_id qualification_name course_name institution_name university_name year_of_passing percentage_or_grade certificate_path is_highest is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id employee_id structure_id effective_from effective_to basic_salary gross_salary total_earnings total_deductions net_salary payment_mode bank_name bank_account_no ifsc_code remarks is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id employee_id old_status new_status effective_date reason remarks delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id category_name category_code responsible_department default_priority default_sla_hours description is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id request_no employee_id category_id category_name request_title request_description priority request_status assigned_department assigned_to assigned_to_name requested_date due_date sla_hours first_response_at resolved_at closed_at resolution_notes internal_notes escalation_level escalated_at escalated_by escalation_reason employee_rating employee_feedback ai_priority_score ai_notes is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id request_id note_type note_text visible_to_employee is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id employee_id leave_type_id leave_year opening_balance credited_leave used_leave pending_leave available_balance remarks is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id employee_id leave_type_id leave_from leave_to total_days half_day half_day_session reason attachment_path leave_status approved_by approved_at rejected_by rejected_at rejection_reason cancel_requested cancel_reason cancelled_by cancelled_at remarks is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id leave_type_name leave_type_code leave_color annual_quota carry_forward_allowed max_carry_forward paid_leave approval_required half_day_allowed description is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id employee_id template_id letter_type letter_no letter_subject letter_body request_status approval_status approved_by approved_at rejected_by rejected_at rejection_reason generated_file_path issued_date remarks is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id prefix current_no padding_length financial_year is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id template_name template_code letter_type subject template_body available_placeholders approval_required is_default is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id employee_id applicant_id candidate_name candidate_code mobile_no email department_name designation_name joining_date reporting_manager employment_type onboarding_status verification_status offer_letter_issued appointment_letter_issued id_card_issued system_access_created completion_percent ai_risk_score ai_notes remarks is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id onboarding_id checklist_master_id checklist_title checklist_category responsible_department mandatory due_date item_status completed_by completed_at evidence_path remarks is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id checklist_title checklist_code checklist_category responsible_department mandatory default_due_days display_order description is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id onboarding_id document_name document_type document_status required_document received_date verified_by verified_at file_path remarks is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id employee_id loan_type loan_date principal_amount installment_amount total_installments paid_installments balance_amount loan_status remarks is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id payroll_month payroll_title total_employees processed_employees total_earnings total_deductions net_payable payroll_status approval_status processed_by processed_at approved_by approved_at remarks is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id payroll_id employee_id payroll_month working_days present_days leave_days lop_days basic_salary gross_salary total_earnings total_deductions loan_deduction net_salary payslip_status payment_status remarks is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id cycle_name cycle_code cycle_type start_date end_date review_due_date cycle_status description is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id review_id employee_id pip_title pip_reason start_date end_date target_improvement action_plan pip_status followup_notes closed_by closed_at is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id kpi_title kpi_code kpi_category department_name designation_name max_score default_weightage measurement_type description is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id cycle_id employee_id reviewer_id reviewer_name self_score manager_score final_score final_rating performance_band review_status approval_status self_comments manager_comments hr_comments promotion_recommended increment_recommended increment_percent approved_by approved_at ai_score ai_notes is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id review_id assignment_id kpi_id kpi_title kpi_category weightage max_score self_score manager_score final_score comments is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id job_id applicant_name applicant_code mobile_no email gender qualification experience_years current_company current_ctc expected_ctc notice_period source_type referred_by resume_path cover_note applicant_stage applicant_status ai_score ai_notes applied_date is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id interview_id applicant_id job_id technical_score communication_score attitude_score overall_score recommendation feedback_notes feedback_by feedback_at is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id applicant_id job_id interview_round interview_type interview_date interview_time interviewer_name interviewer_user_id meeting_link location interview_status remarks is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id job_title job_code department_name designation_name vacancy_count employment_type work_location min_experience max_experience salary_range job_description required_skills opening_date closing_date job_status is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id head_name head_code head_type calculation_type calculation_value taxable pf_applicable esi_applicable display_order description is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id structure_name structure_code description gross_salary total_earnings total_deductions net_salary is_default is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id institution_code institution_name short_name status subscription_status contact_person phone email address city state pincode logo_path academic_year_id created_by updated_by delete_status created_at updated_at

* id institution_type preset_name institution_level affiliation_type affiliation_name academic_structure_type label_class label_section label_subject label_teacher label_student label_parent label_academic_year label_term enabled_modules ai_profile is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id unit_name unit_code institution_type institution_level affiliation_type affiliation_name academic_structure_type label_class label_section label_subject label_teacher label_student label_parent label_academic_year label_term enabled_modules ai_profile is_primary_unit is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id book_code isbn_no title subtitle author_name co_author_name publisher_name edition publication_year language category subject class_level rack_no shelf_no keywords description cover_image total_copies available_copies issued_copies lost_copies damaged_copies is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id book_id accession_no barcode_no rfid_no purchase_date purchase_price vendor_name bill_no copy_status condition_status rack_no shelf_no remarks is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id transaction_id member_id payment_date fine_amount paid_amount waived_amount balance_amount payment_mode receipt_no reference_no remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id transaction_no member_id book_id copy_id issue_date due_date return_date issue_status renew_count last_renew_date fine_amount fine_paid fine_balance fine_status issued_by returned_by remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id member_type member_ref_id member_code library_card_no member_name class_name section_name department_name mobile_no email max_books_allowed max_days_allowed fine_per_day membership_status blocked_reason is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id member_id transaction_id notification_type title message channel send_status scheduled_at sent_at delete_status created_by updated_by created_at updated_at

* id company_id branch_id reservation_no member_id book_id copy_id request_date expiry_date reservation_status priority_no approved_by approved_at remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id default_student_book_limit default_staff_book_limit default_issue_days default_renew_limit default_fine_per_day allow_reservation allow_renewal auto_overdue_marking auto_fine_calculation is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id verification_no verification_date verified_by total_books_checked available_count missing_count damaged_count extra_found_count verification_status remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id verification_id book_id copy_id accession_no barcode_no system_status physical_status remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id user_id institution_code username ip_address user_agent status remarks created_at

* id user_id token_hash requested_ip expires_at used_at created_at

* id action_code action_name display_order is_active delete_status created_at updated_at

* id module_code module_name module_icon module_order module_group display_order is_active delete_status created_at updated_at

* id company_id branch_id role_id menu_code can_view delete_status created_by updated_by created_at updated_at

* id company_id branch_id role_id module_code action_code is_allowed delete_status created_by updated_by created_at updated_at

* id company_id branch_id student_code admission_no admission_date first_name middle_name last_name full_name gender dob blood_group mobile_no email photo aadhaar_no religion category caste nationality mother_tongue student_status parent_app_status mobile_app_enabled ai_attendance_risk ai_academic_risk ai_fee_risk ai_dropout_risk ai_discipline_risk ai_overall_risk_score ai_recommendation remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id student_id academic_year_id academic_year_name board_id board_name division_id division_name class_id class_name section_id section_name roll_no house_name admission_type previous_academic_year_id previous_academic_year_name previous_class previous_section mapping_status is_current remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id student_id admission_source enquiry_no application_no admission_type previous_school previous_class previous_percentage previous_tc_no counsellor_name admission_approved_by admission_approved_date verification_status verification_remarks public_remarks internal_notes created_by updated_by delete_status created_at updated_at

* id company_id branch_id student_id academic_year_id attendance_score academic_score fee_risk_score behaviour_score health_risk_score overall_risk_score attendance_risk academic_risk fee_risk behaviour_risk dropout_risk ai_summary ai_recommendation next_action action_owner action_due_date action_status generated_date created_by updated_by delete_status created_at updated_at

* id company_id branch_id unit_id academic_year_id term_id attendance_date student_id admission_id admission_no student_code student_name board_id division_id class_id section_id class_name section_name roll_no session_id attendance_scope attendance_mode timetable_period_id subject_id teacher_id attendance_status morning_status afternoon_status in_time out_time late_minutes reason_id reason_title remarks parent_notified notification_status notification_sent_at source_type device_reference import_batch_no is_locked locked_by locked_at is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id unit_id device_id device_name student_id student_code admission_no punch_datetime punch_type raw_payload sync_status attendance_id error_message is_active delete_status created_by created_at

* id company_id branch_id unit_id import_type import_batch_no file_name file_path total_rows success_rows failed_rows skipped_rows import_status error_summary is_active delete_status created_by created_at completed_at

* id company_id branch_id unit_id academic_year_id term_id student_id admission_id admission_no student_code student_name board_id division_id class_id section_id class_name section_name roll_no subject_id summary_month summary_year total_working_days present_days absent_days late_days half_days leave_days permission_days attendance_percentage required_percentage shortage_percentage shortage_days risk_level ai_remark is_locked is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id unit_id attendance_id student_id admission_id notification_type channel recipient_type recipient_name recipient_mobile recipient_email message_title message_text send_status provider_name provider_reference response_text sent_at is_active delete_status created_by created_at

* id company_id branch_id unit_id reason_type reason_title reason_code is_parent_visible requires_document is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id unit_id academic_year_id term_id session_name session_code session_type start_time end_time late_after_time display_order is_default is_active delete_status created_by updated_by deleted_by created_at updated_at deleted_at

* id company_id branch_id unit_id setting_key setting_value setting_group input_type display_label display_order is_editable is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id student_id discipline_record_id session_date session_type conducted_by counselling_notes improvement_plan next_followup_date followup_status parent_present parent_remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id student_id incident_date incident_type severity reported_by incident_description action_taken parent_status record_status followup_date counsellor_name ai_risk_flag teacher_remarks admin_remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id student_id document_type document_name file_name file_path file_type file_size document_status verification_status expiry_date uploaded_by_type uploaded_by verified_by verified_date remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id student_id incident_date incident_type description action_taken parent_notified notified_to notified_mobile handled_by remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id student_id blood_group height weight vision allergies chronic_condition medication doctor_name doctor_mobile preferred_hospital emergency_name emergency_mobile emergency_relation vaccination_status last_checkup_date special_care_required special_care_notes visible_to_teacher alert_level record_status remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id import_file_name import_file_path total_rows success_rows failed_rows import_status error_file_name error_file_path imported_by imported_at remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id student_id father_name father_mobile father_email father_occupation father_income father_aadhaar mother_name mother_mobile mother_email mother_occupation mother_income mother_aadhaar guardian_name guardian_relation guardian_mobile guardian_email primary_contact login_mobile parent_app_status parent_app_enabled communication_preference notification_language attendance_alerts fee_reminders result_notifications homework_alerts emergency_name emergency_mobile emergency_relation address city state pincode sibling_link remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id student_id old_status new_status status_change_date reason changed_by remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id student_id admission_no tc_no request_date leaving_date leaving_reason reason_details fee_clearance library_clearance transport_clearance document_clearance fee_due_amount library_due_amount transport_due_amount clearance_status approval_status approved_by approved_date issued_date print_status student_final_status qr_code qr_verify_url office_remarks created_by updated_by delete_status created_at updated_at

* id menu_code parent_code menu_title menu_url menu_icon module_code display_order is_active delete_status created_at updated_at

* id company_id branch_id academic_year_id log_type reference_table reference_id action_name description old_data_json new_data_json ip_address user_agent delete_status created_by created_at

* id company_id branch_id academic_year_id suggestion_context reference_id suggestion_title suggestion_body suggested_teacher_id suggested_subject_id suggested_room_id suggested_period_id suggested_day_name score_percentage reason_json status action_by action_at delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id class_id section_id subject_id block_name block_type period_count preferred_day preferred_start_period_id is_mandatory is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id generation_batch_id version_id timetable_entry_id conflict_type severity conflict_message suggested_action status resolved_by resolved_at resolution_remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id constraint_name constraint_code constraint_type rule_level priority_level target_teacher_id target_class_id target_section_id target_subject_id target_room_id target_period_id target_day_name operator_type rule_value rule_json is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id change_date day_name change_type original_timetable_entry_id class_id section_id period_id new_day_name new_subject_id new_teacher_id new_room_id reason status approved_by approved_at published_by published_at delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id generation_batch_id version_id schedule_mode timetable_date day_name period_id period_order class_id section_id subject_id teacher_id room_id slot_type entry_status source_type status is_published published_at is_locked locked_by locked_at is_ai_generated ai_score ai_reason parent_entry_id remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id check_batch_code class_id section_id check_type severity message suggested_fix status delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id batch_code batch_name generation_mode class_id section_id status approval_status approved_by approved_at approval_remarks is_active_version published_version_id ai_engine_version rules_snapshot_json generation_summary_json total_slots filled_slots conflict_count score_percentage generated_by generated_at locked_by locked_at delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id import_type file_name file_path total_rows success_rows failed_rows status error_json summary_json delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id notification_type audience_type channel class_id section_id title message recipient_count success_count failed_count status send_mode sent_at failed_reason delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id period_name period_code period_order start_time end_time duration_minutes is_break break_name applicable_days is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id version_id generation_batch_id publish_scope class_id section_id teacher_id room_id publish_status publish_to_teacher publish_to_student publish_to_parent publish_to_mobile_app scheduled_at published_by published_at remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id booking_date day_name from_period_id to_period_id room_id booking_title booking_type class_id section_id teacher_id description status approved_by approved_at approval_remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id room_name room_code room_type capacity floor_name building_name is_shared requires_approval is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id class_id section_id subject_id weekly_periods min_periods_per_week max_periods_per_week max_periods_per_day allow_continuous requires_room_type priority_level is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id substitution_date day_name original_entry_id generation_batch_id version_id class_id section_id period_id subject_id room_id absent_teacher_id substitute_teacher_id reason_type reason_note status notification_sent notification_sent_at completed_at cancelled_at delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id leave_id original_timetable_entry_id substitution_date day_name period_id class_id section_id subject_id room_id absent_teacher_id substitute_teacher_id suggestion_type status ai_score ai_reason remarks approved_by approved_at published_by published_at delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id teacher_id leave_date leave_type from_period_id to_period_id reason status approved_by approved_at approval_remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id teacher_id subject_id class_id section_id mapping_type max_periods_per_day max_periods_per_week effective_from effective_to is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id teacher_id preference_type day_name period_id preference_value priority_level remarks is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id teacher_id entry_date day_name period_id class_id section_id subject_id room_id entry_type status remarks approved_by approved_at approval_remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id generation_batch_id version_name version_code class_id section_id effective_from effective_to status is_published total_slots conflict_count approved_by approved_at published_by published_at remarks delete_status created_by updated_by created_at updated_at

* id company_id branch_id academic_year_id teacher_visible student_visible parent_visible substitution_overlay_visible delete_status created_by updated_by created_at updated_at

* id company_id branch_id insight_date insight_type route_id vehicle_id driver_id insight_title insight_summary recommendation risk_level action_status reviewed_by reviewed_at created_by updated_by delete_status created_at updated_at

* id company_id branch_id alert_date alert_type priority route_id vehicle_id driver_id student_id trip_session_id latitude longitude alert_title alert_message alert_status resolved_by resolved_at resolution_note resolution_notes parent_notified admin_notified created_by updated_by delete_status created_at updated_at

* id company_id branch_id driver_code driver_name driver_type mobile_no alternate_mobile_no email address license_no license_type license_expiry_date aadhaar_no police_verification_status medical_fitness_status app_login_enabled app_username app_password_hash last_login_at driver_status remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id vehicle_id fuel_date fuel_type litres rate_per_litre total_amount odometer_reading fuel_station_name bill_no entered_by_driver_id approved_by approval_status remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id trip_session_id route_id vehicle_id driver_id latitude longitude speed_kmph heading battery_level gps_accuracy nearest_stop_id next_stop_id eta_to_next_stop_min location_source recorded_at created_by delete_status

* id company_id branch_id student_id parent_mobile_no trip_session_id route_id vehicle_id notification_type notification_title notification_message channel send_status sent_at failed_reason created_by delete_status created_at

* id company_id branch_id route_code route_name route_direction start_point end_point total_distance_km estimated_duration_min vehicle_id driver_id helper_id morning_start_time morning_end_time evening_start_time evening_end_time route_status remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id route_id stop_code stop_name stop_address stop_sequence morning_pickup_time evening_drop_time latitude longitude distance_from_previous_km distance_from_school_km waiting_minutes stop_status created_by updated_by delete_status created_at updated_at

* id company_id branch_id trip_session_id trip_date route_id vehicle_id driver_id stop_id timeline_type timeline_title timeline_message latitude longitude event_time visible_to_parent visible_to_admin created_by delete_status

* id company_id branch_id academic_year_id student_id admission_no student_name class_id section_id route_id vehicle_id pickup_stop_id drop_stop_id transport_type fee_category monthly_fee start_date end_date parent_mobile_no emergency_contact_no allocation_status remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id trip_session_id trip_date trip_type student_id admission_no student_name route_id vehicle_id stop_id status status_time latitude longitude confirmed_by parent_notified notification_sent_at remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id trip_date trip_type route_id vehicle_id driver_id helper_id start_time end_time start_latitude start_longitude end_latitude end_longitude current_stop_id next_stop_id trip_status delay_minutes delay_reason created_by updated_by delete_status created_at updated_at

* id company_id branch_id vehicle_code vehicle_name vehicle_type registration_no chassis_no engine_no seating_capacity gps_device_id gps_imei_no insurance_expiry_date fitness_expiry_date pollution_expiry_date permit_expiry_date tax_expiry_date vehicle_status remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id vehicle_id maintenance_date maintenance_type odometer_reading service_center_name invoice_no amount next_service_date next_service_km maintenance_status remarks created_by updated_by delete_status created_at updated_at

* id company_id branch_id role_id employee_id user_type full_name username email mobile profile_photo password_hash status force_password_change last_login_at last_login_ip login_attempts locked_until is_super_admin updated_by delete_status created_by created_at updated_at

* id company_id user_id branch_id is_default is_active delete_status created_by updated_by created_at updated_at

* id company_id branch_id role_name role_code role_description is_system_role is_active delete_status created_by updated_by created_at updated_at

select table academic_activity_assignment_planner academic_activity_planner academic_ai_gap_detection_suggestions academic_assignment_planner academic_audit_logs academic_boards academic_calendar academic_calendar_events academic_chapter_completion_tracking academic_classes academic_class_section_planner academic_class_wise_planner academic_daily_lesson_planner academic_divisions academic_exam_calendar_alignment academic_exam_planner_alignment academic_exam_preparation_planner academic_extra_class_planner academic_holiday_impact_analysis academic_monthly_planner academic_planner_ai_alerts academic_planner_ai_runs academic_planner_approval_workflow academic_planner_calendar academic_planner_report_snapshots academic_promotion_history academic_promotion_rules academic_remedial_planner academic_revision_planner academic_revision_remedial_planner academic_sections academic_streams academic_subject_syllabus_planner academic_teacher_planner academic_teacher_wise_planner academic_terms academic_weekly_planner academic_years academic_year_planner admission_applications admission_communication_logs admission_documents admission_enquiries admission_followups admission_interviews admission_payments admission_seat_plan admission_settings admission_status_logs api_keys api_key_logs branches erp_dashboard_activity_log erp_dashboard_ai_insights erp_dashboard_alerts erp_dashboard_user_preferences erp_role_dashboards hostel_alerts hostel_attendance hostel_beds hostel_blocks hostel_complaints hostel_fee_mapping hostel_master hostel_mess_menu hostel_mess_plans hostel_outing_pass hostel_rooms hostel_room_transfers hostel_student_allocations hostel_visitor_logs hr_activity_logs hr_analytics_ai_insights hr_analytics_alerts hr_analytics_snapshots hr_attendance hr_attendance_regularization hr_attendance_shifts hr_documents hr_document_categories hr_employees hr_employee_bank_details hr_employee_code_sequence hr_employee_documents hr_employee_exit_clearance_items hr_employee_exit_clearance_master hr_employee_exit_requests hr_employee_exit_settlement hr_employee_experience hr_employee_family hr_employee_kpi_assignments hr_employee_qualifications hr_employee_salary hr_employee_status_history hr_helpdesk_categories hr_helpdesk_requests hr_helpdesk_request_notes hr_leave_balances hr_leave_requests hr_leave_types hr_letter_requests hr_letter_sequence hr_letter_templates hr_onboarding_candidates hr_onboarding_checklist_items hr_onboarding_checklist_master hr_onboarding_documents hr_payroll_loans_advances hr_payroll_monthly hr_payroll_monthly_items hr_performance_cycles hr_performance_improvement_plans hr_performance_kpi_master hr_performance_reviews hr_performance_review_items hr_recruitment_applicants hr_recruitment_feedback hr_recruitment_interviews hr_recruitment_jobs hr_salary_heads hr_salary_structures institutions institution_type_presets institution_units lib_books lib_book_copies lib_fine_payments lib_issue_transactions lib_members lib_notifications lib_reservations lib_settings lib_stock_verification lib_stock_verification_items login_logs password_reset_tokens permission_actions permission_modules role_menu_access role_permissions students student_academic_mapping student_admission_details student_ai_insights student_attendance_daily student_attendance_device_logs student_attendance_import_logs student_attendance_monthly_summary student_attendance_notification_log student_attendance_reasons student_attendance_sessions student_attendance_settings student_counselling_records student_discipline_records student_documents student_health_incidents student_health_records student_import_logs student_parent_guardians student_status_history student_tc_requests system_menus timetable_activity_logs timetable_ai_suggestions timetable_block_rules timetable_conflict_logs timetable_constraints timetable_daily_changes timetable_entries timetable_feasibility_checks timetable_generation_batches timetable_import_logs timetable_notifications timetable_period_master timetable_publish_logs timetable_room_bookings timetable_room_master timetable_subject_quota timetable_substitutions timetable_substitution_logs timetable_teacher_leave timetable_teacher_mapping timetable_teacher_preferences timetable_teacher_self_entries timetable_versions timetable_visibility_settings transport_ai_insights transport_alerts transport_drivers transport_fuel_logs transport_live_locations transport_parent_notifications transport_routes transport_route_stops transport_route_timeline_logs transport_student_allocation transport_student_trip_status transport_trip_sessions transport_vehicles transport_vehicle_maintenance users user_branch_access user_roles . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table academic_activity_assignment_planner academic_activity_planner academic_ai_gap_detection_suggestions academic_assignment_planner academic_audit_logs academic_boards academic_calendar academic_calendar_events academic_chapter_completion_tracking academic_classes academic_class_section_planner academic_class_wise_planner academic_daily_lesson_planner academic_divisions academic_exam_calendar_alignment academic_exam_planner_alignment academic_exam_preparation_planner academic_extra_class_planner academic_holiday_impact_analysis academic_monthly_planner academic_planner_ai_alerts academic_planner_ai_runs academic_planner_approval_workflow academic_planner_calendar academic_planner_report_snapshots academic_promotion_history academic_promotion_rules academic_remedial_planner academic_revision_planner academic_revision_remedial_planner academic_sections academic_streams academic_subject_syllabus_planner academic_teacher_planner academic_teacher_wise_planner academic_terms academic_weekly_planner academic_years academic_year_planner admission_applications admission_communication_logs admission_documents admission_enquiries admission_followups admission_interviews admission_payments admission_seat_plan admission_settings admission_status_logs api_keys api_key_logs branches erp_dashboard_activity_log erp_dashboard_ai_insights erp_dashboard_alerts erp_dashboard_user_preferences erp_role_dashboards hostel_alerts hostel_attendance hostel_beds hostel_blocks hostel_complaints hostel_fee_mapping hostel_master hostel_mess_menu hostel_mess_plans hostel_outing_pass hostel_rooms hostel_room_transfers hostel_student_allocations hostel_visitor_logs hr_activity_logs hr_analytics_ai_insights hr_analytics_alerts hr_analytics_snapshots hr_attendance hr_attendance_regularization hr_attendance_shifts hr_documents hr_document_categories hr_employees hr_employee_bank_details hr_employee_code_sequence hr_employee_documents hr_employee_exit_clearance_items hr_employee_exit_clearance_master hr_employee_exit_requests hr_employee_exit_settlement hr_employee_experience hr_employee_family hr_employee_kpi_assignments hr_employee_qualifications hr_employee_salary hr_employee_status_history hr_helpdesk_categories hr_helpdesk_requests hr_helpdesk_request_notes hr_leave_balances hr_leave_requests hr_leave_types hr_letter_requests hr_letter_sequence hr_letter_templates hr_onboarding_candidates hr_onboarding_checklist_items hr_onboarding_checklist_master hr_onboarding_documents hr_payroll_loans_advances hr_payroll_monthly hr_payroll_monthly_items hr_performance_cycles hr_performance_improvement_plans hr_performance_kpi_master hr_performance_reviews hr_performance_review_items hr_recruitment_applicants hr_recruitment_feedback hr_recruitment_interviews hr_recruitment_jobs hr_salary_heads hr_salary_structures institutions institution_type_presets institution_units lib_books lib_book_copies lib_fine_payments lib_issue_transactions lib_members lib_notifications lib_reservations lib_settings lib_stock_verification lib_stock_verification_items login_logs password_reset_tokens permission_actions permission_modules role_menu_access role_permissions students student_academic_mapping student_admission_details student_ai_insights student_attendance_daily student_attendance_device_logs student_attendance_import_logs student_attendance_monthly_summary student_attendance_notification_log student_attendance_reasons student_attendance_sessions student_attendance_settings student_counselling_records student_discipline_records student_documents student_health_incidents student_health_records student_import_logs student_parent_guardians student_status_history student_tc_requests system_menus timetable_activity_logs timetable_ai_suggestions timetable_block_rules timetable_conflict_logs timetable_constraints timetable_daily_changes timetable_entries timetable_feasibility_checks timetable_generation_batches timetable_import_logs timetable_notifications timetable_period_master timetable_publish_logs timetable_room_bookings timetable_room_master timetable_subject_quota timetable_substitutions timetable_substitution_logs timetable_teacher_leave timetable_teacher_mapping timetable_teacher_preferences timetable_teacher_self_entries timetable_versions timetable_visibility_settings transport_ai_insights transport_alerts transport_drivers transport_fuel_logs transport_live_locations transport_parent_notifications transport_routes transport_route_stops transport_route_timeline_logs transport_student_allocation transport_student_trip_status transport_trip_sessions transport_vehicles transport_vehicle_maintenance users user_branch_access user_roles .	select column