University
Tables (4)
courses (과목)
- 과목ID (course_id) — int4 — Primary key — NOT NULL
- 교수ID (professor_id) — int4 — Foreign key → professors.교수ID — NOT NULL
- 학점 (credits) — int — NOT NULL
enrollments (수강)
- 과목ID (course_id) — int4 — Foreign key → courses.과목ID — NOT NULL
- 교수ID (professor_id) — int4 — Foreign key → courses.교수ID — NOT NULL
- 학생 ID (student_id2) — int — Foreign key → students.학생 ID — NOT NULL
professors (교수)
- 교수ID (professor_id) — int4 — Primary key — NOT NULL
- 이름 (name) — varchar(255)
students (학생)
- 학생 ID (student_id) — int — Primary key — NOT NULL
- 이름 (name) — varchar(255) — NOT NULL
- 전공 (major) — varchar(255)
- Field