course_registeration

Tables (4)

lesson (수업)

  • id (신청id) — BIGINT — Primary key — NOT NULL
  • student_id (학생id) — BIGINT — Foreign key → student.id — NOT NULL
  • tutor_id (튜터id) — BIGINT — Foreign key → tutor.id — NOT NULL
  • timeslot_id (타임슬롯 id) — BIGINT — Foreign key → timeslot.id — NOT NULL
  • class_path (수업 길이) — ENUM(30분, 60분)
  • created_at (생성날짜) — TIMESTAMP
  • updated_at (수정날짜) — TIMESTAMP

student (학생)

  • id (학생id) — BIGINT — Primary key — NOT NULL
  • name (학생 이름) — VARCHAR(100)
  • created_at (생성날짜) — TIMESTAMP
  • updated_at (수정날짜) — TIMESTAMP

timeslot (시간대)

  • id (타임슬롯 id) — BIGINT — Primary key — NOT NULL
  • tutor_id (튜터id) — BIGINT — Foreign key → tutor.id — NOT NULL
  • start_time (시작시간) — TIMESTAMP
  • end_time (종료시간) — TIMESTAMP
  • is_available (수업 가능여부) — BOOLEAN(TRUE/FALSE)
  • created_at (생성날짜) — TIMESTAMP
  • updated_at (수정날짜) — TIMESTAMP

tutor (튜터)

  • id (튜터id) — BIGINT — Primary key — NOT NULL
  • name (튜터 이름) — VARCHAR(100)
  • created_at (생성날짜) — TIMESTAMP
  • updated_at (수정날짜) — TIMESTAMP