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