방과후 관리 프로그램 erd111

테이블 (6)

afterschool

  • program_id — int
  • title — varchar(100) — NOT NULL
  • description — text
  • schedule — varchar(50) — NOT NULL
  • room — varchar(50)
  • capacity — int — NOT NULL
  • teacher_id — int — NOT NULL

attendance

  • attendance_id — int
  • student_id — int — NOT NULL
  • program_id — int — NOT NULL
  • date — date — NOT NULL
  • status — enum('PRESENT','ABSENT','LATE') — NOT NULL

enrollment

  • enrollment_id — int
  • student_id — int — NOT NULL
  • program_id — int — NOT NULL
  • apply_date — date
  • status — enum('APPROVED','PENDING','CANCELLED')

student

  • student_id — int
  • user_id — int — NOT NULL
  • grade — int — NOT NULL
  • class — varchar(10) — NOT NULL
  • parent_name — varchar(50)
  • parent_phone — varchar(20)

teacher

  • teacher_id — int
  • user_id — int — NOT NULL
  • dept — varchar(50) — NOT NULL
  • phone — varchar(20)
  • email — varchar(100)
  • hire_date — date

user

  • user_id — int
  • login_id — varchar(50) — NOT NULL
  • name — varchar(50) — NOT NULL
  • password — varchar(255) — NOT NULL
  • role — enum('STUDENT','TEACHER','ADMIN') — NOT NULL
  • status — enum('PENDING','APPROVED','REJECTED')
  • created_at — timestamp