학부실습

테이블 (7)

Untitled (Student)

  • Key (id) — char(2) — 기본 키 — NOT NULL
  • Field (_name) — char(2)
  • Field (lphak) — datetime2
  • Field (phone) — char(11)
  • Field (email) — char(30)
  • Field (labid) — char(2)

Untitled (Sugang)

  • Field (cid) — char(2)
  • Field (sid) — char(2)
  • Field (pid) — char(2)
  • Field (score) — char(2)
  • Field (openyear) — datetime2

Untitled (Course)

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

Untitled (Prof)

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

Untitled (Proh_Suhang)

  • Key (id2) — char(2) — 외래 키 → Untitled.Key — NOT NULL
  • Field (pid) — char(2)
  • Field2 (projid) — char(2)
  • Field (sid) — char(2)

Untitled (prohect)

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

Untitled2 (Lab)

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