lecture

Tables (6)

enroll (Enrollment Detail1)

  • enrollment index (enrollId) — int — Primary key — NOT NULL
  • lecture detail index (lectureOptionId) — int — Foreign key → lecture_option.lecture detail index — NOT NULL
  • lecture index (lectureId) — int — Foreign key → lecture_option.lecture index — NOT NULL
  • user id (userId) — int
  • enrollment date (created_at) — datetime

enroll_history (Enrollment History Log)

  • enrollment history index (historyId) — int — Primary key — NOT NULL
  • enrollment index (enrollId) — int
  • lecture index (lectureId) — int
  • lecture detail index (lectureOptionId) — int
  • user id (userId) — int
  • enrollment type (type) — enum
  • history created date (created_at) — int

enrolls (Enrollment Detail)

  • enrollment index (enrollId) — int — Primary key — NOT NULL
  • user id (userId) — int
  • enrollment date (created_at) — datetime
  • lecture index (lectureId1) — int — Foreign key → lectures.lecture index — NOT NULL

lecture (Lecture1)

  • lecture index (lectureId) — int — Primary key — NOT NULL
  • lecture created date (created_at) — datetime

lecture_option (Lecture Detail)

  • lecture detail index (lectureOptionId) — int — Primary key — NOT NULL
  • lecture index (lectureId) — int — Foreign key → lecture.lecture index — NOT NULL
  • lecture name (name) — varchar
  • current capacity (curCapacity) — int
  • maximum capacity (maxCapacity) — int
  • lecture start date (open_at) — datetime
  • lecture edited date (updated_at) — datetime
  • lecture created date (created_at) — datetime

lectures (Lecture)

  • lecture index (lectureId) — int — Primary key — NOT NULL
  • lecture name (name) — varchar
  • current capacity (curCapacity) — int
  • maximum capacity (maxCapacity) — int
  • lecture start date (open_at) — datetime
  • lecture edited date (updated_at) — datetime
  • lecture created date (created_at) — datetime