orders
Tables (5)
Untitled (orders)
- Key (order_id) — INT — Primary key — NOT NULL
- Field (user_id) — INT
- Field (order_dow) — INT
- Field (order_hour_of_day) — INT
- Field (monthkey) — INT
- Field (branch) — VARCHAR(10)
Untitled (orderitems)
- Key (orderitem_id) — INT — Primary key — NOT NULL
- Key (order_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (product_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (reordered) — INT
Untitled (products)
- Key (product_id) — INT — Primary key — NOT NULL
- Key (prd_sml_cat_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (product_name) — VARCHAR(100)
- Field (price) — INT
Untitled (prd_mdl_cat)
- Key (prd_mdl_cat_id) — INT — Primary key — NOT NULL
- Field (prd_mdl_cat) — VARCHAR(100)
Untitled (prd_sml_cat)
- Key (prd_sml_cat_id) — INT — Primary key — NOT NULL
- Key (prd_mdl_cat_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (prd_sml_cat) — VARCHAR(100)