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