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