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)