1004

Tables (4)

Copy Of Untitled (생산과정)

  • Field (usage per piece) — int
  • Key (partQuantity) — int — NOT NULL
  • Key (partID) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (productID) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (PRODUCT)

  • Key (productID) — int — Primary key — NOT NULL
  • Field (prodName) — char(15)
  • Field (porPrice) — char(10)
  • Field (proDescription) — text

Untitled (SUPPLIER)

  • Key (ssn) — char(15) — Primary key — NOT NULL
  • Field (supName) — char(20)
  • Field (supAdd) — text
  • Field (supPhone) — int
  • Field

Untitled (PART)

  • Key (partID) — int — Primary key — NOT NULL
  • Field (partinfo) — text
  • Field (partPrice) — int
  • Key (ssn) — char(15) — Foreign key → Untitled.Key — NOT NULL