개인 ERD 작성문제

테이블 (5)

part (Untitled)

  • part_id (Key) — int — 기본 키 — NOT NULL
  • name (Field) — char
  • description (Field2) — char
  • price (Field3) — int

product

  • product_id (Key) — int — 기본 키 — NOT NULL
  • name (Field) — char
  • description (Field2) — char
  • price (Field3) — int

product_part (Untitled3)

  • product_id (Key) — int — 외래 키 → product.product_id — NOT NULL
  • part_id (Key2) — int — 외래 키 → part.part_id — NOT NULL
  • quantity_used (Field) — int

supplier (Untitled2)

  • supplier_id (Key) — int — 기본 키 — NOT NULL
  • name (Field) — char
  • address (Field2) — char
  • phone_number (Field3) — char

supplier_part (Untitled4)

  • part_id (Key) — int — 외래 키 → part.part_id — NOT NULL
  • supplier_id (Key2) — int — 외래 키 → supplier.supplier_id — NOT NULL