Student
Tables (5)
lecture (Untitled5)
- lecture_no (Key) — int — Primary key — NOT NULL
- subject_no (Key2) — char(4) — Foreign key → subject.subject_no — NOT NULL
- professor_no (Key22) — char(4) — Foreign key → subject.professor_no — NOT NULL
major (Untitled)
- 학과명 (major_name) — varchar
- 학과번호 (major_no) — char — NOT NULL
professor (Untitled2)
- professor_no (Key) — char(4) — Primary key — NOT NULL
- professor_name (Field) — varchar(30)
- major_no (Field2) — char(4)
student (Untitled4)
- student_no (char) — Primary key — NOT NULL
- lecture_no (Key) — int — Foreign key → lecture.lecture_no — NOT NULL
- subject_no (Key2) — char(4) — Foreign key → lecture.subject_no — NOT NULL
- professor_no (Key22) — char(4) — Foreign key → lecture.professor_no — NOT NULL
subject (Untitled3)
- subject_no (Key) — char(4) — Primary key — NOT NULL
- professor_no (Key2) — char(4) — Foreign key → professor.professor_no — NOT NULL
- professor_no (Field) — char(4)
- subject_name (Field2) — varchar(50)