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