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)