Database Schema Question
Posted: Thu Apr 01, 2010 3:10 pm
Hi Chaps,
I'm starting to build a small online clothing shop for my friend.
I've sorted out the basic database schema:
All items will cost the same, regardless of size.
tbl_cust - [custid] (customer details)
tbl_cat - [catid] (denim, floral, leather)
tbl_sub_cat - ([subcatid] (skirt, dress, top)
tbl_size - [sizeid, subcatid] (S, M, L)
tbl_product - [prodid, catid, subcatid, sizeid] (skirt product, dress product, top product)
tbl_shop - [shopid, prodid] (quantity, price]
tbl_sales - [saleid, prodid, custid] (size, quantity, price, sale_date)
tbl_sale_item - [saleitemid, saleid . . . . .
and that's when I get a bit confused . . . I need help sorting our the orders, quantities, customer etc. . . .
Any help would be most awesome!
I'm starting to build a small online clothing shop for my friend.
I've sorted out the basic database schema:
All items will cost the same, regardless of size.
tbl_cust - [custid] (customer details)
tbl_cat - [catid] (denim, floral, leather)
tbl_sub_cat - ([subcatid] (skirt, dress, top)
tbl_size - [sizeid, subcatid] (S, M, L)
tbl_product - [prodid, catid, subcatid, sizeid] (skirt product, dress product, top product)
tbl_shop - [shopid, prodid] (quantity, price]
tbl_sales - [saleid, prodid, custid] (size, quantity, price, sale_date)
tbl_sale_item - [saleitemid, saleid . . . . .
and that's when I get a bit confused . . . I need help sorting our the orders, quantities, customer etc. . . .
Any help would be most awesome!