1

Tables (7)

Course (course)

  • Key (id) — char(2) — Primary key — NOT NULL
  • Field (_name) — char(30)
  • Field (credit) — int

Prof

  • Key (id) — char(2) — Primary key — NOT NULL
  • Key (labid) — char(2) — Foreign key → Untitled.Key — NOT NULL
  • Field (_name) — char(30)
  • Field (phone) — char(11)

Student

  • Key (id) — char(2) — Primary key — NOT NULL
  • Field (_name) — char(30)
  • Field (iphac) — datetime2
  • Field (phone) — char(11)
  • Field (email) — char(30)
  • Key (labid) — char(2) — Foreign key → Untitled.Key — NOT NULL

Sugang

  • Key (sid) — char(2) — Foreign key → Student.Key — NOT NULL
  • Key (cid) — char(2) — Foreign key → Course.Key — NOT NULL
  • Key (pid) — char(2) — Foreign key → Prof.Key — NOT NULL
  • Field (score) — char(2)
  • Field (openyear) — datetime2
  • Key (id2) — char(2) — Foreign key → Prof.Key — NOT NULL

Untitled (Lab)

  • Key (id) — char(2) — Primary key — NOT NULL
  • Field (_name) — char(30)
  • Field (room) — char(5)

Untitled (Project)

  • Key (id) — char(2) — Primary key — NOT NULL
  • Field (_name) — char(100)
  • Field (from) — datetime2
  • Field (to) — datetime2
  • Field (money) — int

Untitled (Proj_Suhang)

  • Key (pid) — char(2) — Foreign key → Prof.Key — NOT NULL
  • Key (pjid) — char(2) — Foreign key → Untitled.Key — NOT NULL
  • Key (sid) — char(2) — Foreign key → Student.Key — NOT NULL
  • s참여율 (s_참여율) — decinal
  • p참여율 (p_참여율) — decimal