항해 2주

테이블 (4)

LECTURE (lecture)

  • id (lecture_id) — int — 기본 키 — NOT NULL
  • lecture_name — varchar — NOT NULL

Lecture Enroll (lecture_enroll)

  • id (lecture_enroll_id) — int — 기본 키 — NOT NULL
  • id (user_id) — int — 외래 키 → USER.id — NOT NULL
  • id (lecture_schedule_id) — int — 외래 키 → Lecture Schedule.id — NOT NULL
  • enroll_time (Field)

Lecture Schedule (lecture_schedule)

  • id (lecture_schedule_id) — int — 기본 키 — NOT NULL
  • id (lecture_id) — int — 외래 키 → LECTURE.id — NOT NULL
  • lecture_id (int) — int — NOT NULL
  • reg_date — DATE — NOT NULL
  • capacity (Field3) — int — NOT NULL
  • current_count (Field) — int

USER (user)

  • id (user_id) — int — 기본 키 — NOT NULL
  • user_name — varchar — NOT NULL