2

Tables (7)

Car (Untitled4)

  • Car (car_serial) — Primary key — NOT NULL
  • Car (car_serial2) — Foreign key → Invoice.Car — NOT NULL
  • Salesperson (id) — Foreign key → Invoice.Salesperson — NOT NULL
  • Customer (id2) — Foreign key → Invoice.Customer — NOT NULL
  • Car (person_name)

Customer (Untitled2)

  • Customer (id) — Primary key — NOT NULL
  • Field (name)

Invoice (Untitled3)

  • Car (car_serial) — Primary key — NOT NULL
  • Salesperson (id) — Foreign key → Salesperson.Salesperson — NOT NULL
  • Customer (id2) — Foreign key → Customer.Customer — NOT NULL

Mechanics (Untitled6)

  • Mechanics (id) — Primary key — NOT NULL
  • Mechanics (name)

Salesperson (Untitled)

  • Salesperson (id) — Primary key — NOT NULL
  • Field (name)

Service (Untitled5)

  • service (id) — Primary key — NOT NULL
  • Car (car_serial) — Foreign key → Car.Car — NOT NULL
  • Salesperson (id2) — Foreign key → Car.Salesperson — NOT NULL
  • Customer (id22) — Foreign key → Car.Customer — NOT NULL
  • Mechanics (id3) — Foreign key → Mechanics.Mechanics — NOT NULL

repair (Untitled7)

  • service (id) — Foreign key → Service.service — NOT NULL
  • Mechanics (id3) — Foreign key → Service.Mechanics — NOT NULL