﻿TABLE: attendance
  - id (int(11))
  - student_id (int(11))
  - date (date)
  - check_in (datetime)
  - check_out (datetime)
TABLE: attendance_log
  - id (int(11))
  - student_id (int(11))
  - scan_time (datetime)
  - direction (enum('IN','OUT'))
TABLE: audit_logs
  - id (int(11))
  - action_type (varchar(50))
  - record_id (int(11))
  - changed_by (varchar(100))
  - change_details (text)
  - change_time (datetime)
TABLE: courses
  - id (int(11))
  - course_name (varchar(255))
  - description (text)
  - thumbnail (varchar(255))
  - created_at (datetime)
TABLE: enrollments
  - id (int(11))
  - student_id (int(11))
  - course_id (int(11))
  - enrolled_at (datetime)
  - status (enum('active','completed','dropped'))
TABLE: event_participation
  - id (int(11))
  - student_id (int(11))
  - event_id (int(11))
  - marked_at (datetime)
TABLE: exam_type_master
  - id (int(11))
  - exam_name (varchar(100))
TABLE: grade_master
  - id (int(11))
  - name (varchar(100))
  - description (text)
  - status (tinyint(1))
  - created_at (timestamp)
TABLE: modules
  - id (int(11))
  - course_id (int(11))
  - title (varchar(255))
  - content_type (enum('text','video','pdf'))
  - content (text)
  - order_index (int(11))
TABLE: special_events
  - id (int(11))
  - event_name (varchar(255))
  - event_date (date)
TABLE: special_participation
  - id (int(11))
  - student_id (int(11))
  - event_id (int(11))
  - participation_date (date)
TABLE: student_exam_results
  - id (int(11))
  - student_id (int(11))
  - exam_type_id (int(11))
  - subject_id (int(11))
  - marks (decimal(5,2))
  - grade (char(1))
  - pass_fail (tinyint(1))
  - entered_at (timestamp)
TABLE: students
  - id (int(11))
  - admission_no (varchar(20))
  - password (varchar(255))
  - category (varchar(100))
  - registered_category (varchar(50))
  - name (varchar(255))
  - photo (varchar(255))
  - gender (varchar(10))
  - address (text)
  - dob (date)
  - mobile (varchar(15))
  - guardian_name (varchar(255))
  - school_name (varchar(255))
  - school_grade (varchar(50))
  - previous_daham_school (varchar(255))
  - prev_daham_school (varchar(255))
  - grade_attended (varchar(50))
  - joined_date (date)
  - regfee (decimal(10,2))
  - facilityfee (decimal(10,2))
  - batchfee (decimal(10,2))
  - recbookfee (decimal(10,2))
  - otherfree (decimal(10,2))
  - discount (decimal(5,2))
  - totpay (decimal(10,2))
  - discount_category (varchar(100))
  - remarks (text)
  - status_active (tinyint(1))
  - status_resign (tinyint(1))
  - status_suspended (tinyint(1))
  - status_dismissal (tinyint(1))
  - add_date (datetime)
  - grade (int(11))
  - name_si (varchar(255))
TABLE: subject_master
  - id (int(11))
  - subject_name (varchar(100))
TABLE: tbl_attendance
  - id (int(11))
  - student_id (int(11))
  - scan_time (datetime)
TABLE: users
  - id (int(11))
  - name (varchar(100))
  - email (varchar(100))
  - password (varchar(255))
  - role (enum('admin','teacher','student','parent'))
  - created_at (timestamp)
