lecture
Tables (4)
Lecture (강의)
- id (lecture_id) — INTEGER — Primary key — NOT NULL
- 강의명 (title) — VARCHAR(50) — NOT NULL
- 코드 (code) — INTEGER — NOT NULL
- id (professor_id) — INTEGER — Foreign key → Professor.id — NOT NULL
LectureStudent (강의학생)
- id (LectureStudent_id) — INTEGER — Primary key — NOT NULL
- 시간 (enrolled_at) — DATETIME — NOT NULL
- id (lecture_id) — INTEGER — Foreign key → Lecture.id — NOT NULL
- id (student_id) — INTEGER — Foreign key → Student.id — NOT NULL
Professor (교수)
- id (professor_id) — INTEGER — Primary key — NOT NULL
- 이름 (name) — VARCHAR(20) — NOT NULL
- 이메일 (email) — TEXT — NOT NULL
Student (학생)
- id (student_id) — INTEGER — Primary key — NOT NULL
- 이름 (name) — VARCHAR(20) — NOT NULL
- 학번 (studentid) — INTEGER — NOT NULL