pratice
Tables (4)
Item (Untitled4)
- Key (item_id) — Primary key — NOT NULL
- Field (name)
- Field2 (price)
- Field3 (stockQuantity)
Member (Untitled)
- Key (member_id) — Primary key — NOT NULL
- Field (name)
- Field (address)
- Field2 (orders)
Order (Untitled2)
- Key (order_id) — Primary key — NOT NULL
- Key (member) — Foreign key → Member.Key — NOT NULL
- Field (order)
- Field (delivery_id)
- Field (orderDate)
- Field (status)
OrderItem (Untitled3)
- Key (order_item_id) — Primary key — NOT NULL
- Key (order_id) — Foreign key → Order.Key — NOT NULL
- Field (orderPrice)
- Field2 (count)