|
jobOrder :
{
jobId - primary key
jobName
productid - foreign key refering product id in product table
}
Parts {
partId - primary key, forieng key refering productid in the product table
jobId - primary key, foreign key refering jobid in job order table
qty
}
Products {
productId - primary key
productName
}
__________________
Looking out the window, that's an act of war. Staring at my shoes, that's an act of war. Committing an act of war? Oh you better believe that's an act of war
|