과제

테이블 (5)

Part (part)

  • Part ID(PK) (part ID(PK)) — INT (Primary Key) — 기본 키 — NOT NULL
  • Description (description) — VARCHAR(255)

Product (product)

  • Product ID (product ID) — INT (Primary Key) — 기본 키 — NOT NULL
  • Number (number) — VARCHAR(50)
  • Description (description) — VARCHAR(255)
  • Price (price) — DECIMAL(10,2)

Productpart (productPart)

  • ProductPart ID (productpart ID) — INT (Primary Key) — 기본 키 — NOT NULL
  • Product ID (product ID) — INT (Primary Key) — 외래 키 → Product.Product ID — NOT NULL
  • Part ID(PK) (part ID(PK)) — INT (Primary Key) — 외래 키 → Part.Part ID(PK) — NOT NULL
  • Quantity (quantity) — INT (Primary Key)

Supplier (supplier)

  • Supplier ID (supplier ID) — INT (Primary Key) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(100)
  • Address (address) — VARCHAR(255)
  • Phone (phone) — VARCHAR(15)

SupplierPart (supplierpart)

  • SupplierPartID (supplierpartID) — INT (Primary Key) — 기본 키 — NOT NULL
  • Supplier ID (supplier ID) — INT (Primary Key) — 외래 키 → Supplier.Supplier ID — NOT NULL
  • Part ID(PK) (part ID(PK)) — INT (Primary Key) — 외래 키 → Part.Part ID(PK) — NOT NULL