Lecture

Tables (4)

Lecture (lecture)

  • l_id (Key) — INTEGER(100) — Primary key — NOT NULL
  • title (Field) — CHARFIELD(50)
  • code (Field2) — CHARFIELD(20)
  • p_id (Key2) — INTEGER(100) — Foreign key → Professor.p_id — NOT NULL

LectureStudent (lecture_student)

  • ls_id (Key) — INTEGER(100) — Primary key — NOT NULL
  • enrolled_at (Field) — DATETIMEFIELD
  • l_id (Key2) — INTEGER(100) — Foreign key → Lecture.l_id — NOT NULL
  • s_id (Key3) — INTEGER(100) — Foreign key → Student.s_id — NOT NULL

Professor (professor)

  • p_id (id) — INTEGER(100) — Primary key — NOT NULL
  • name (교수명) — CHARFIELD(20)
  • email (Field2) — CHARFIELD(20)

Student (student)

  • s_id (Key) — INTEGER(100) — Primary key — NOT NULL
  • name (Field) — CHARFIELD(20)
  • student_id (Field2) — CHARFIELD(20)