lecture
Tables (3)
Instructor (강사)
- instructor_id (Key) — int — Primary key — NOT NULL
- lecture_id (Key2) — Foreign key → lecture.lecture_id — NOT NULL
- instructor_name (Field)
- Field2
lecture (강의)
- lecture_id (Key) — Primary key — NOT NULL
- instructor_id (Field3)
- lecture_time (Field2)
- lecture_name (Field)
- classroom (Field4)
- max_capacity (Field5)
student (학생)
- student_id (Key) — Primary key — NOT NULL
- student_name (Field)