3

Tables (3)

Untitled (Manufacturer)

  • Key (serial number) — integer(20) — Primary key — NOT NULL
  • Key (serial number2) — integer(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — char(10)
  • Field (address) — char(30)
  • Field (phone number) — char(11)

Untitled (Component)

  • Key (serial number) — integer(20) — Primary key — NOT NULL
  • Field (explanation) — char(30)
  • Key (serial number2) — integer(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (serial number22) — integer(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (Serial number)

  • Key (explanation) — integer(30) — Primary key — NOT NULL
  • Field (price) — char(10)
  • Key (serial number) — integer(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (serial number2) — integer(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (serial number22) — integer(20) — Foreign key → Untitled.Key — NOT NULL