Displays all of the tables in the Automobile Body Repair Shop Project
| Customer ID |
First Name |
Last Name |
Address |
Phone Number |
| 101 | Joe | Johnson | 42 Wullaby Way | 8675309 |
| 102 | Bob | Robertson | 86 East Point | 3333333 |
| 103 | Mary | Sue | 124 Conch St | 5111111 |
| 104 | Olaf | Olafsson | 344 South Fairview | 4512257 |
| 105 | Christopher | Christophson | 555 Sandwich Dr | 8888888 |
| 106 | Patrick | Smith | 100 Rainbow Rd | 7418529 |
| 1212 | Dave | Tucker | 123 Maple St. | 111223333 |
| Car ID |
Customer ID |
Make |
Model |
Year |
| 111 | 101 | Nissan | Rogue | 2010 |
| 112 | 102 | Nissan | Ultima | 2010 |
| 113 | 103 | Toyota | Camry | 2010 |
| 114 | 104 | Toyota | Rav4 | 2010 |
| 115 | 105 | Chevy | Cruze | 2010 |
| 116 | 106 | Chevy | Malibu | 2010 |
| 117 | 107 | Jeep | Renegade | 2015 |
| 1212 | 1212 | Ford | F150 | 2015 |
| Estimate ID |
Mechanic ID |
Car ID |
Estimated Cost |
Date |
| 131 | 141 | 111 | 125.50 | 2016-05-01 |
| 132 | 142 | 112 | 175.50 | 2016-04-01 |
| 133 | 143 | 113 | 55.50 | 2016-11-01 |
| 134 | 144 | 114 | 195.50 | 2016-07-01 |
| 135 | 145 | 115 | 65.50 | 2016-09-01 |
| 136 | 146 | 116 | 105.50 | 2016-06-01 |
| 137 | 147 | 117 | 225.50 | 2016-02-01 |
| Job ID |
Car ID |
Mechanic ID |
Estimate ID |
Date |
Date Completed |
| 121 | 111 | 141 | 131 | 2016-05-02 | 2016-05-16 |
| 122 | 112 | 142 | 132 | 2016-04-02 | 2016-04-16 |
| 123 | 113 | 143 | 133 | 2016-11-02 | 2016-11-16 |
| 124 | 114 | 144 | 134 | 2016-07-08 | 2016-07-22 |
| 125 | 115 | 145 | 135 | 2016-09-01 | 2016-09-15 |
| 126 | 116 | 146 | 136 | 2016-06-02 | 2016-06-16 |
| 127 | 117 | 147 | 137 | 2016-02-05 | 2016-02-19 |
| 128 | 118 | 141 | 138 | 2019-04-09 | 2019-04-30 |
| Log ID |
Record Changed |
Action |
Change Date |
| 2 | 128 | Insert | 2023-04-19 |
| 5 | 128 | Deleted | 2023-04-19 |
| 24 | 128 | Insert | 2023-04-19 |
| 25 | 128 | Deleted | 2023-04-19 |
| 27 | 128 | Insert | 2023-04-19 |
| 28 | 128 | Deleted | 2023-04-19 |
| 29 | 128 | Insert | 2023-04-19 |
| 30 | 128 | Deleted | 2023-04-19 |
| 31 | 128 | Insert | 2023-04-19 |
| 32 | 128 | Deleted | 2023-04-19 |
| 33 | 128 | Insert | 2023-04-19 |
| Mechanic ID |
Name |
Rate |
Number of Jobs Assigned |
| 141 | Harry | 24.00 | 1 |
| 142 | Moe | 70.00 | 1 |
| 143 | Curly | 18.00 | 1 |
| 144 | Howard | 33.00 | 1 |
| 145 | Ben | 42.00 | 1 |
| 146 | Gary | 8.00 | 1 |
| 147 | Larry | 11.00 | 1 |
| 148 | Jerry | 15.00 | 0 |
| 149 | Tim | 39.00 | 0 |
| Part ID |
Repair ID |
| 171 | 161 |
| 172 | 162 |
| 173 | 163 |
| 174 | 164 |
| 175 | 165 |
| 176 | 166 |
| 177 | 167 |
| 178 | 168 |
| Repair ID |
Description |
Time Required |
Cost |
| 161 | Breaks | 5 days | 230.00 |
| 162 | Oil Change | 3 days | 170.00 |
| 163 | Struts | 8 days | 185.00 |
| 164 | Doors | 4 days | 265.00 |
| 165 | Engine | 9 days | 145.00 |
| 166 | Body Work | 6 days | 195.00 |
| 167 | Mirrors | 7-10 days | 155.00 |
| Repair ID |
Job ID |
| 151 | 121 |
| 152 | 122 |
| 153 | 123 |
| 154 | 124 |
| 155 | 125 |
| 156 | 126 |
| 157 | 127 |
Back to the Repair Shop main menu