과제

테이블 (4)

Untitled (Supplier)

  • Key (SuppilerID) — char — 기본 키 — NOT NULL
  • Field (name) — char
  • Field (address) — char
  • Field (phonenumber) — char

Untitled (Part)

  • Key (PartID) — char — 기본 키 — NOT NULL
  • Field (partModelNumber) — char
  • Field (describe) — char
  • Key (SuppilerID) — char — 외래 키 → Untitled.Key — NOT NULL

Untitled (Product_Part)

  • Key (ProductID) — char — 외래 키 → Untitled2.Key — NOT NULL
  • Key (PartID) — char — 외래 키 → Untitled.Key — NOT NULL
  • Field (Quantity) — int

Untitled2 (Product)

  • Key (ProductID) — char — 기본 키 — NOT NULL
  • Field (productName) — char
  • Field (descreibe) — text
  • Field (price) — int