예5

테이블 (5)

Untitled (Client)

  • Key (Ccode) — int — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (Address) — text
  • Field — char(14)
  • Field2 (pType) — char(20)
  • Field2 (pDate) — char(10)
  • Field2 (pAmount) — char(20)

Untitled (Provider)

  • Key (pCode) — int — 기본 키 — NOT NULL
  • Field (product) — char(10)

Untitled (Department)

  • Key (dCode) — int — 기본 키 — NOT NULL
  • Field (dName) — char(50)

Untitled (Employee)

  • Key (ID) — int — 기본 키 — NOT NULL
  • Key (dCode) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — char(20

Untitled (Purchase)

  • Key (Ccode) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (sCode) — char(10) — 외래 키 — NOT NULL
  • Key (Ccode2) — int — 외래 키 → Untitled.Key — NOT NULL