Yo. I’m developing a shopping cart system for a company and I was thinking if you people could take a glance at it, tell me what you think, what could be improved, ekcetera (I’m looking at you, bwh2, ha!).
Anyway, the ERD is attached. I didn’t bother with a lot of attributes and partiality in the diagram, this diagram is more about establishing semantic and good relationships between the entities, I’ll add the attributes later.
As you can see, one item has many tags. An item belongs in several orders and one order has several items in it, the item2order table also has a quantity attribute, which tells you how many of something someone has put on the order. An item belongs in a category, each category belongs to a parent category. One account makes several orders and has several shipping addresses, it’s noted in the order which account made the order and which shipping address that should be sent to.
You think I should add anything else? I was thinking maybe adding a step and order2step table, so the owner of the store could add several steps (like order handled, item packaged, item shipped out, transaction closed etc.) and then an order would have one or more of these steps. Do you think that’s overcomplicating things?
