afterSchool
Tables (6)
afterschool_classes (Untitled2)
- class_id (수업 ID) — INT — Primary key — NOT NULL
- teacher_id (교사ID) — INT — Foreign key → teacher.teacher_id — NOT NULL — PK
- title (수업명) — VARCHAR(100)
- description (설명) — TEXT
- day_of_week (요일) — ENUM(Mon,Tue,Wed,Thu,Fri,Sat)
- start_time (시작 시간) — TIME
- end_time (종료 시간) — TIME
- capacity (정원) — INT
- created_at (생성일) — DATETIME
class_attendance (Untitled5)
- attendance_id (출석 ID) — INT — Primary key — NOT NULL
- enrollment_id (신청 ID) — INT — Foreign key → class_enrollments.enrollment_id — NOT NULL
- class_date (수업 날짜) — DATE
- status (출석 상태) — ENUM(present,absent,late)
- recorded_at (기록일) — DATETIME
class_enrollments (Untitled3)
- enrollment_id (신청 ID) — INT — Primary key — NOT NULL
- student_id (학생ID) — INT — Foreign key → student.student_id — NOT NULL — PK
- class_id (수업 ID) — INT — Foreign key → afterschool_classes.class_id — NOT NULL
- status (상태) — ENUM(enrolled,cancelled)
- attendance_rate (출석률) — DECIMAL(5,2)
- applied_at (신청일) — DATETIME
- Field
class_notices (Untitled4)
- notice_id (공지 ID) — INT — Primary key — NOT NULL
- teacher_id (교사ID) — INT — Foreign key → teacher.teacher_id — NOT NULL — PK
- class_id (수업 ID) — INT — Foreign key → afterschool_classes.class_id — NOT NULL
- title (제목) — VARCHAR(100)
- content (내용) — TEXT
- created_at (생성일) — DATETIME
student (Untitled)
- student_id (학생ID) — INT — Primary key — NOT NULL — PK
- email (이메일) — VARCHAR(100)
- password_hash (비밀번호 해시) — VARCHAR(255)
- name (이름) — VARCHAR(50)
- created_at (생성일) — DATETIME
- updated_at (수정일) — DATETIME
teacher (CopyOfUntitled)
- teacher_id (교사ID) — INT — Primary key — NOT NULL — PK
- email (이메일) — VARCHAR(100)
- password_hash (비밀번호 해시) — VARCHAR(255)
- name (이름) — VARCHAR(50)
- created_at (생성일) — DATETIME
- updated_at (수정일) — DATETIME