lundi 26 janvier 2015

Manage orders based off product attributes and quantity


I'm developing a database for an online store in which the Products have multiple attributes and attribute types.



ATRIBUTES TYPES
atrtype_id
name (like size, color...)

ATRIBUTES
atribute_id
atrtype_id (This will get the name)
product_id
value (like blue, black, L, M, XXL)

PRODUCTS
product_id
name
price
weight
...

PARCELS (or ORDER ITEMS)
parcel_id
order_id
product_id

ORDERS
order_id
user_id
order_value
delivery_method
order_date
status

PARCEL ATRIBUTES
parcelatribute_id
parcel_id
atribute_id


First of all, I don't know if this last table is correct, I got blanked...


So, I wanted to save on the order which product the costumer picked and which color and/or size he chose and the quantity of each product (how many blue products he bought etc).


I would love to know if there's any alternative to registering the quantity of products when the same does not have attributes.





Aucun commentaire:

Enregistrer un commentaire