방과후 관리 프로그램 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