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)