Adds a job in the Automobile Body Repair Shop Project
Select a Mechanic:
Estimate ID:
Date:
(Expected) Date Completed:
The sql for the insert
INSERT INTO Job VALUES ('', '', '', '', '', '')
| 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 |
Page to add the repair itself
Back to the Repair Shop main menu