ERD Exercise1-2111150송찬혁

테이블 (5)

CATEGORY (Untitled3)

  • cateName (Key) — char(30) — 기본 키 — NOT NULL
  • name (Field) — char(100)
  • description (Field2) — text

PART (Untitled2)

  • partID (Key) — integer — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • modelNumber (Field2) — char(30)
  • description (Field3) — text
  • price (Field4) — integer
  • Field5
  • suplierID (Key2) — integer(10) — 외래 키 → SUPPLIER.suplierID — NOT NULL
  • cateName (Key3) — char(30) — 외래 키 → CATEGORY.cateName — NOT NULL

PRODUCT (Untitled5)

  • modelNumber (Key) — char(30) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • description (Field2) — text
  • price (Field3) — integer

PRODUCT_PART (Untitled4)

  • partID (Key) — integer — 외래 키 → PART.partID — NOT NULL
  • modelNumber (Key2) — char(30) — 외래 키 → PRODUCT.modelNumber — NOT NULL
  • quantity (Field) — integer(10)

SUPPLIER (Untitled)

  • suplierID (Key) — integer(10) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • phone (Field2) — char(30)
  • email (Field3) — char(40)
  • address (Field4) — char(50)
  • description (Field5) — text
  • grade (Field6) — integer(1)