Back to Main Page
Add a Job
Job ID:
Customer ID:
------------
Phil More
pop me
Stephen Knuth
me you
Dave Tucker
Car ID:
------------
A1 Audi 1980
please help 2020
No One 1616
Clubman MINI 1978
Armada Nissan 1991
BRZ Subaru 1980
Mechanic ID:
------------
Nick
Kyle
John
Paul
Estimate ID:
Date:
Date Completed:
Repair ID:
------------
Breaks
Oil Change
Help
Struts
What the hell is that?
The sql for the insert
INSERT INTO Job VALUES ('', '', '', '', '', '')
INSERT INTO RepairJob VALUES('')
Job ID
Car ID
Mechanic ID
Estimate ID
Date
Date Completed
1
1
1
1
1985-05-15
1985-05-22
22
5057
1
4545
2023-05-16
2023-05-23
108
116
8
911
1987-11-15
1987-11-22
10203
3062
1
5
2023-05-12
2023-05-27
23542
5057
3
11379
1999-12-12
1999-12-17