studentERD

Tables (3)

course (Untitled3)

  • 과목번호 (course_id) — number — Primary key — NOT NULL
  • 과목명 (title) — varchar(20) — NOT NULL
  • 과목내용 (content) — varchar(25)

register (Untitled2)

  • 학번 (studnet_id) — number — Foreign key → student.학번 — NOT NULL
  • 과목번호 (course_id2) — number — Foreign key → course.과목번호 — NOT NULL
  • 학점 (grade) — varchar(4) — NOT NULL

student (Untitled)

  • 학번 (studnet_id) — number — Primary key — NOT NULL
  • 이름 (name) — varchar(20) — NOT NULL
  • 전화번호 (phone) — number