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)