20241024 대학원2

테이블 (5)

Course

  • id — int — 기본 키 — NOT NULL
  • _name — nchar(30)
  • credit — int
  • dept_id — int — NOT NULL

Department

  • id — int — 기본 키 — NOT NULL
  • name — char(30)
  • phone — char(14)
  • address — char(50)

Student

  • id — int — 기본 키 — NOT NULL
  • name — nchar(30)
  • birth — domain2
  • dept_id — int — NOT NULL

lab

  • name — nchar(30)

sugang

  • c_id — int — 외래 키 → Course.id — NOT NULL
  • s_id — int — 외래 키 → Student.id — NOT NULL
  • gpa — char(2)
  • open_year — VARCHAR(255)
  • open_semester — VARCHAR(255)