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