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)