var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
ER Diagram, any suggestion will be appreciate.
I am a newbie to the database, I have drawn a E-R diagram, but I ain't sure if it makes any sense to you guys.
Time to "Reorder"
Yes, you certainly need some help here. I apologize for not giving you a conceptual model myself, I'm tired.
Customer, Orders and Items.
Customers know about, request, or purchase, etc. 'Items' through an order. So customers don't generally have a direct relationship to the 'Items'.
An item can be on zero, one or many orders.
An order can be for one or many items.
SO ... you see there's a many to many between order and items.
Here's a model link for you. Replace the 'Aircraft Parts' entity with your 'Items' entity.
It appears you don't need the Customer Quotation and Quotation Items entity.