ERD 연습문제 7

테이블 (6)

Untitled (project)

  • Key (pno) — char(10) — 기본 키 — NOT NULL
  • Field (pname) — char(10)
  • Key (pmno) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (pDescription) — text

Untitled (pmanager)

  • Key (pmno) — char(10) — 기본 키 — NOT NULL
  • Field (pmName) — char(4)
  • Field (pmCell) — int(10)
  • Field (pmAddress) — char(20)

Untitled (subcontractor)

  • Key (sno) — char(10) — 기본 키 — NOT NULL
  • Field (sname) — char(10)
  • Field (sfriendly) — int(2)
  • Key (spCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (sAbility) — int(2)

Untitled (project_subcontractor)

  • Key (pno) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (sno) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (specialty)

  • Key (spCode) — char(10) — 기본 키 — NOT NULL
  • Field (spName) — char(20)
  • Field (spDescription) — text

Untitled (loan)

  • Key (lcode) — char(10) — 기본 키 — NOT NULL
  • Field (lamount) — int(3)
  • Field (lprice) — int
  • Key (pno) — char(10) — 외래 키 → Untitled.Key — NOT NULL