fyp
Tables (5)
attendance
- id — int(11) — Primary key — NOT NULL
- student_id — int(11) — NOT NULL
- enrolled_at — datetime — NOT NULL
- class_id — int(11) — NOT NULL
- status — enum('Present','Late','Absent') — NOT NULL
classes
- class_id — int(11) — Primary key — NOT NULL
- class_name — varchar(255) — NOT NULL
- class_start_time — datetime — NOT NULL
- lecturer_name — varchar(255) — NOT NULL
- subject_name — varchar(255) — NOT NULL
proof_of_absence
- id — int(11) — Primary key — NOT NULL
- student_id — varchar(50) — NOT NULL
- proof_file — varchar(255) — NOT NULL
- absent_reason — text
students
- id — int(11) — Primary key — NOT NULL
- student_id — varchar(50) — NOT NULL
- student_name — varchar(100) — NOT NULL
- class_id — varchar(50) — NOT NULL
- address — varchar(255)
- phone — varchar(20)
users
- user_id — int(11) — Primary key — NOT NULL
- username — varchar(50) — NOT NULL
- password — varchar(255) — NOT NULL
- role — enum('student','lecturer') — NOT NULL