학부2024_학사erd

테이블 (5)

Course (Untitled)

  • Key (Id) — char(2) — 기본 키 — NOT NULL
  • Field (_name) — char(30)
  • Field (credit) — int

Prof (Untitled3)

  • Key (id) — char(2) — 기본 키 — NOT NULL
  • Field (_name) — char(30)

Sugang (Untitled2)

  • Key (cId) — char(2) — 외래 키 → Untitled.Key — NOT NULL
  • Key (sId) — char(2) — 외래 키 → Course.Key — NOT NULL

Untitled (Student)

  • Key (Id) — char(2) — 기본 키 — NOT NULL
  • Field (_name) — char(30)
  • Field (entrance) — datetime2
  • Field (phone) — char(11)
  • Field (email) — char(30)

Untitled4 (lab)

  • Key (Id) — 기본 키 — NOT NULL
  • Field (_name) — char(30)
  • Field (room) — char(5)