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