orderERD
Tables (7)
category (Untitled5)
- Key (category_id) — Primary key — NOT NULL
- Field (parent_id)
- Field (name)
category_item (Untitled6)
- Field (category_id)
- Field (item_id)
- Key (item_id2) — Foreign key → item.Key — NOT NULL
- Key (category_id2) — Foreign key → category.Key — NOT NULL
delivery (Untitled3)
- Field (city)
- Field2 (street)
- Field (zipcode)
- Field (status)
- Key (order_id) — Foreign key → orders.Key — NOT NULL
item (Untitled7)
- Key (item_id) — Primary key — NOT NULL
- Field (name)
- Field (price)
- Field (stockquantity)
member (Untitled)
- Key (member_id) — Primary key — NOT NULL
- Field (name)
- Field (city)
- Field (street)
- zipcode (Field)
order_item (Untitled4)
- Key (order_item_id) — Primary key — NOT NULL
- Field (order_id)
- Field (item_id)
- Field (orderprice)
- Field (count)
- Key (item_id2) — Foreign key → item.Key — NOT NULL
- Key (order_id2) — Foreign key → orders.Key — NOT NULL
orders (Untitled2)
- Key (order_id) — Primary key — NOT NULL
- Field (member_id)
- Field (delivery_id)
- Field (orderdate)
- Field (status)
- Key (member_id2) — Foreign key → member.Key — NOT NULL