I am trying to create an e-commerce database, but I do not understand the relationship between orders, products and customers. There are many examples of databases, but they are too complex. Is there a simpler explanation or example of possible tables and relationships.
Thank.
This is the simplest form if customers can have more than one order and orders for several products:
The table ORDERcontains information on the date and status of the order.
ORDER
The table ORDER ITEMcontains information on the quantity of the ordered product.
ORDER ITEM
, -, : " " " ". ( ?) , .
, , . , , , .
"" . - + mysql ( ubuntu LAMP). , .
: order_main order_payment
"" . . .
MySql php-, cron . - , HTML . , flatfile . - , Quickbooks, -.
- , LAMP . 7 ( , , Magento).
, - MySql, . , , 2 , Magento , . Magento -, Quickbooks ( ), QB . , QB .