방과후 관리 프로그램 erd
테이블 (6)
afterschool
- program_id — INT
- teacher_id — INT — NOT NULL
- title — VARCHAR(100)
- description — TEXT
- schedule — VARCHAR(50)
- room — VARCHAR(20)
- capacity — INT
attendance
- attendance_id — INT
- student_id — INT — NOT NULL
- program_id — INT — NOT NULL
- date — DATE
- status — VARCHAR(20)
enrollment
- enrollment_id — INT
- student_id — INT — NOT NULL
- program_id — INT — NOT NULL
- apply_date — DATE
- status — VARCHAR(20)
student
- student_id — INT
- user_id — INT — NOT NULL
- grade — INT
- class — VARCHAR(20)
- parent_name — VARCHAR(50)
- parent_phone — VARCHAR(20)
teacher
- teacher_id — INT
- user_id — INT — NOT NULL
- dept — VARCHAR(50)
- phone — VARCHAR(20)
- email — VARCHAR(50)
- hire_date — DATE
user
- user_id — INT
- login_id — VARCHAR(50) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20)
- created_at — DATETIME