연습문제

테이블 (5)

Untitled (PART)

  • Key (PartID) — 기본 키 — NOT NULL
  • Field2 (name)
  • Field2 (modelNumber)
  • Field (description) — text
  • Field (price) — integer(10)
  • Key (supplierID) — char(12) — 외래 키 → product.Key — NOT NULL
  • Key (cateNum) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field

Untitled (PRODUCT_PART)

  • Key (ProductNo) — char(16) — 외래 키 → parts.Key — NOT NULL
  • Key (PartID) — 외래 키 → Untitled.Key — NOT NULL
  • Field (quantity)

Untitled (CATEGORY)

  • Key (cateNum) — 기본 키 — NOT NULL
  • Field (name)
  • Field (description)

parts (PRODUCT)

  • Key (modelNumber) — char(16) — 기본 키 — NOT NULL
  • Field (name)
  • Field (description) — text
  • Field (price) — char(11)

product (SUPPLIER)

  • Key (supplierID) — char(12) — 기본 키 — NOT NULL
  • Field2 (name) — char(20)
  • Field2 (address) — char(100)
  • Field2 (phone)