LectureEntollment

Tables (5)

Lecture

  • id — int — Primary key — NOT NULL — rkddml ㅑㅇ
  • title (title) — VARCHAR
  • instructor — VARCHAR

LectureItem (LectureSchedule)

  • id — int — Primary key — NOT NULL
  • lecture_id — int — Foreign key → Lecture.id — NOT NULL — rkddml ㅑㅇ
  • date (capacity) — int
  • capacity (schedule_date) — Date

LectureRegistration

  • Key (id) — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id
  • lecture_schedule_id — int — Foreign key → LectureItem.id — NOT NULL
  • RegistrationDate (regist_date_time) — date

User

  • id — int — Primary key
  • Field (name) — VARCHAR

instructor (Instructor)

  • Field (name) — VARCHAR
  • Field2 (subject) — VARCHAR