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