lecture
Tables (4)
Lecture (Untitled2)
- id (lecture_ID) — INTEGER — Primary key — NOT NULL
- 강의명 (title) — TEXT
- 강의코드 (code) — TEXT
- id (professor_id) — INTEGER — Foreign key → Professor.id — NOT NULL
LectureStudent (Untitled4)
- id (LectureStudent_ID) — INTEGER — Primary key — NOT NULL
- 수강신청시간 (enrolled_at) — INTEGER
- id (lecture_id) — INTEGER — Foreign key → Lecture.id — NOT NULL
- id (user_id2) — INTEGER — Foreign key → Student.id — NOT NULL
Professor (Untitled)
- id (professor_id) — INTEGER — Primary key — NOT NULL
- 이름 (name) — TEXT
- 이메일 (email) — TEXT
Student (Untitled3)
- id (user_ID) — INTEGER — Primary key — NOT NULL
- 이름 (name) — TEXT
- 아이디 (student_id) — TEXT
- id (user_id) — INTEGER — Foreign key → Lecture.id — NOT NULL