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