250507 연습문제(1)

테이블 (4)

Part (PART)

  • partId — int(10) — 기본 키 — NOT NULL
  • partName — char(10)
  • partDescription — char(30)
  • partLocation — char(20)
  • supplierId (producerId) — int(6) — 외래 키 → Supplier.supplierId — NOT NULL

Product (PRODUCT)

  • productId — int(10) — 기본 키 — NOT NULL
  • productName — char(10)
  • productDescription — char(30)
  • productPrice — int(10)

Supplier (PODUCER)

  • supplierId (producerId) — int(6) — 기본 키 — NOT NULL
  • supplierName (producerName) — char(10)
  • supplierAddress (producerAddress) — char(30)
  • supplierPhone (producerPhone) — int(11)
  • Field (producerEmail) — email

Untitled (PRODUCT_PART)

  • partId — int(10) — 외래 키 → Part.partId — NOT NULL
  • productId — int(10) — 외래 키 → Product.productId — NOT NULL
  • Field (quantity) — int(10)