학사실습

테이블 (7)

Untitled (Student)

  • Key (ID) — char(2) — 기본 키 — NOT NULL
  • Field (_Name) — char(30)
  • Field (iphak) — Determine2
  • Field (Phone) — char(11)
  • Field (Email) — char(30)
  • Key (l.id) — char(2) — 외래 키 → Untitled.Key — NOT NULL

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)
  • Key (l.id) — char(2) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Sugang)

  • Key (s.ID) — char(2) — 외래 키 → Untitled.Key — NOT NULL
  • Key (c.ID) — char(2) — 외래 키 → Untitled.Key — NOT NULL
  • Key (p.ID) — char(2) — 외래 키 → Untitled.Key — NOT NULL
  • Field (score) — char(2)
  • Field (openyear) — determine2

Untitled (Lab)

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

Untitled (Project)

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

Untitled (proj_suheng)

  • Key (p.ID) — char(2) — 외래 키 → Untitled.Key — NOT NULL
  • Key (Pr.ID) — char(2) — 외래 키 → Untitled.Key — NOT NULL
  • Key (s.ID) — char(2) — 외래 키 → Untitled.Key — NOT NULL
  • Field (s.chamyoyul) — decimal
  • Field (p.chamyoyul) — decimal