For Auto Repair Database
All pages use the p478870b_RepairShop database. The primary keys do not auto-increment, except in the Log table.
The database is set up to handle multiple repairs per job and multiple parts per repair.
However, this feature has not been implemented in the "Add a Job" or "Add a Repair" pages.
Those pages only add one repair or part, respectively.
The estimate field is currently required for to add a job, which is not ideal, so I imagine the "estimate" to be a baseline cost to select.
This report displays Jobs with Customer Name, Car info, Repair info and Job info.
It is based on the RepairJob table and not all jobs are currently linked.