Donggukelectronics

Tables (4)

Untitled (employee)

  • Key (e_number) — Primary key — NOT NULL
  • Field (name)
  • Field2 (position)
  • Field (salary)
  • Field (location)

Untitled (part)

  • Key (p_name) — Primary key — NOT NULL
  • Field (stock)
  • Field (price)

Untitled2 (customer)

  • Key (c_name) — Primary key — NOT NULL
  • Key (model) — Primary key — NOT NULL
  • Field (location)
  • Field (date)
  • Field (fee)

Untitled3 (service)

  • Key (number) — Primary key — NOT NULL
  • Key (e_number) — Foreign key → Untitled.Key — NOT NULL
  • Key (c_name) — Foreign key → Untitled2.Key — NOT NULL
  • Key (model) — Foreign key → Untitled2.Key — NOT NULL
  • Key (p_name) — Foreign key → Untitled.Key — NOT NULL
  • Field (date)
  • Field (fee)
  • Field (note)