detail

Tables (5)

major (전공)

  • major_id (pk) — Primary key — NOT NULL
  • name (이름) — NOT NULL

professor (교수)

  • professor_id (pk) — Primary key — NOT NULL
  • name (이름) — NOT NULL
  • major_id (fk) — Foreign key → major.major_id

students (학생)

  • student_id (학번) — Primary key — NOT NULL
  • name (이름) — NOT NULL
  • major_id (fk) — Foreign key → major.major_id — NOT NULL

students_subjects (학생_과목)

  • students_subjects_id (pk) — Primary key — NOT NULL
  • student_id (학번) — Foreign key → students.student_id — NOT NULL
  • subject_code (과목 코드) — Foreign key → subjects.subject_code — NOT NULL

subjects (과목)

  • subject_code (과목 코드) — Primary key — NOT NULL
  • name (과목명)
  • credit (학점)
  • professor_id (pk) — Foreign key → professor.professor_id — NOT NULL