ERD 1번

테이블 (4)

PART

  • Key (partID) — 기본 키 — NOT NULL
  • Field (partModelNumber)
  • Field (partName)
  • Field2 (description)
  • producerID — 외래 키 → Untitled3.producerID — NOT NULL

PRODUCT

  • productModelID — 기본 키 — NOT NULL
  • product_Name (productName)
  • description
  • Field3 (price)

PRODUCT_PART

  • Key (partID) — 외래 키 → PART.Key — NOT NULL
  • productModelID — 외래 키 → PRODUCT.productModelID — NOT NULL
  • qty

Untitled3 (PRODUCER)

  • producerID — 기본 키 — NOT NULL
  • producerName (productName)
  • Field (phone)
  • Field2 (address)
  • Field3 (email)