ERD
Tables (7)
Untitled (ORDERS)
- Key (ORDER_ID) — varchar — Primary key — NOT NULL
- Field (orderdate) — date
- Field (status) — varchar
- Key (memver_id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Key (delivery_id) — varchar — Foreign key → Untitled.Key — NOT NULL
Untitled (member)
- Key (memver_id) — varchar — Primary key — NOT NULL
- Field (name) — varchar
- Field (city) — varchar
- Field (street) — varchar
- Field (ziocode) — varchar
Untitled (delivery)
- Key (delivery_id) — varchar — Primary key — NOT NULL
- Field (street) — varchar
- Field (zipcode) — varchar
- Field (status) — varchar
- Key (ORDER ID) — varchar — NOT NULL
Untitled (order_item)
- Key (order_item_id) — varchar — Primary key — NOT NULL
- Field (orderprice) — number
- Field (count) — number
- Key (ORDER_ID) — varchar — Foreign key → Untitled.Key — NOT NULL
- Key (item_id2) — varchar — Foreign key → Untitled.Key — NOT NULL
Untitled (category)
- Key (gategory_id) — varchar — Primary key — NOT NULL
- Field (name) — varchar
Untitled (item)
- Key (item_id) — varchar — Primary key — NOT NULL
- Field (name) — varchar
- Field (price) — number
- Field (stockquantity) — number
Untitled (category_item)
- Key (item_id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Key (gategory_id) — varchar — Foreign key → Untitled.Key — NOT NULL