20230306_2주차_과제

테이블 (5)

Untitled (PRODUCT)

  • Key (prodNo) — int — 기본 키 — NOT NULL
  • Field (prodName) — char(100)
  • Field (prodExplain) — char(200)
  • Field (prodPrice) — int
  • Field (priceUnit) — char(3)

Untitled (PART)

  • Key (partNo) — int — 기본 키 — NOT NULL
  • Field (partName) — char(100)
  • Field (partExplain) — char(200)

Untitled (COMPONENT)

  • Key (prodNo) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (partNo) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (quantity) — int
  • Field (unit) — char(3)

Untitled (PRODUCER)

  • Key (producerNo) — int — 기본 키 — NOT NULL
  • Field (producerName) — char(50)
  • Field (producerAddress) — char(100)
  • Field (producerPhone) — char(13)

Untitled (PART PRODUCER PRICE)

  • Key (partNo) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (producerNo) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (partPrice) — int
  • Field (priceUnit) — char(3)