1003

Tables (4)

Untitled (PART)

  • Key (partssn) — char(14) — Primary key — NOT NULL
  • Field (partExplanation) — text
  • Key (producerSsn2) — char(14) — Foreign key → Untitled.Key — NOT NULL

Untitled (PRODUCER)

  • Key (producerSsn) — char(14) — Primary key — NOT NULL
  • Field (producerName) — char(20)
  • Field (address) — char(40)
  • Field (phoneNo) — char(11)

Untitled (PRODUCT)

  • Key (productSsn) — char(14) — Primary key — NOT NULL
  • Field (productPrice) — char(8)
  • Field (productExplanation) — text

Untitled (COMPOSITION)

  • Field (amount) — char(20)
  • Key (productSsn) — char(14) — Foreign key → Untitled.Key — NOT NULL
  • Key (partssn) — char(14) — Foreign key → Untitled.Key — NOT NULL