학부실습

테이블 (7)

Untitled (Lab)

  • Key (ID) — Char [2] — 기본 키 — NOT NULL
  • Field (name) — Char [30]
  • Field — Char[5]
  • Key (pid) — char[2] — 외래 키 → Untitled.Key — NOT NULL

Untitled (student)

  • Key (id) — char[2] — 기본 키 — NOT NULL
  • Field (name) — char[33]
  • Field (iphak) — datetime[2]
  • Field (email) — char[33]
  • Key (labid) — Char [2] — 외래 키 → Untitled.Key — NOT NULL
  • Field (phone) — Char[11]

Untitled (prof)

  • Key (id) — char[2] — 기본 키 — NOT NULL
  • Field (name) — char[30]

Untitled (course)

  • Key (ID) — char[2] — 기본 키 — NOT NULL
  • Field (name) — char[30]
  • Field (credit) — int

Untitled (sugang)

  • Key (sid) — char[2] — 외래 키 → Untitled.Key — NOT NULL
  • Key (cid) — char[2] — 외래 키 → Untitled.Key — NOT NULL
  • Key (pid) — char[2] — 외래 키 → Untitled.Key — NOT NULL
  • Field (score) — char[2]
  • Field (openyear) — datetime2

Untitled2 (project)

  • Key (ID) — char[2] — 기본 키 — NOT NULL
  • Field (name) — char[30]
  • Field (from) — datetime2
  • Field (to) — datetime2
  • Field (price) — int

Untitled2 (project_Suhang)

  • Key (sid) — char[2] — 외래 키 → Untitled.Key — NOT NULL
  • Key (pid) — char[2] — 외래 키 → Untitled2.Key — NOT NULL
  • Key (projid) — char[2] — 외래 키 → Untitled.Key — NOT NULL
  • Field (s_참여율) — decimal
  • Field (p.참여율) — decimal
  • Field (From) — datatime2
  • Field (To) — Datatiem2