Automobile
| ID |
Customer ID |
Make |
Model |
Year |
| 1 | 1 | Ford | Fiesta | 2001 |
| 4 | 7 | Ford | F123 | 2015 |
Customer
| ID |
Last Name |
First Name |
Address |
Phone |
| 1 | White | Walter | 124 Sesame St. | 5738374017 |
| 2 | King | Larry | 1522 West 26th St. | 8142551122 |
| 7 | Tucker | Dave | 123 Maple st | 123333333 |
Mechanic
| ID |
Name |
Rate |
Jobs Assigned |
| 1 | Dave | 120 | 6 |
Estimates
| ID |
Mechanic Assigned |
Car ID |
Estimated Cost |
Estimated Completion |
| 1 | 1 | 1 | 8553.11 | 2023-03-04 |
| 2 | 1 | 1 | 100.00 | 2023-05-16 |
| 25 | 1 | 4 | 5555.00 | 2023-05-24 |
Jobs
| ID |
Car ID |
Mechanic Assigned |
Estimate ID |
Date Started |
Date Completed |
| 1 | 1 | 1 | 1 | 2023-03-04 | 2023-03-05 |
| 2 | 1 | 1 | 1 | 2023-04-04 | 2023-04-12 |
| 3 | 1 | 1 | 1 | 2023-05-05 | 2023-05-11 |
| 12 | 1 | 1 | 25 | 2023-05-03 | 2023-05-02 |
Home