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