test

Tables (6)

t_cart

  • Key (cart_id) — Primary key — NOT NULL
  • Key (member_id) — Foreign key → t_member.Key — NOT NULL

t_cartitem (Untitled)

  • Key (cart_item_id) — Primary key — NOT NULL
  • Field (count)
  • Key (cart_id) — Foreign key → t_cart.Key — NOT NULL
  • Key (item_id) — Foreign key → t_item.Key — NOT NULL

t_item (Untitled2)

  • Key (item_id) — Primary key — NOT NULL
  • Field (item_name)
  • Field (price)
  • Field (stock_number)
  • Field (item_detail)
  • Field (item_sell_status)

t_member

  • Key (member_id) — Primary key — NOT NULL
  • Field (name)
  • Field (email)
  • Field (password)
  • ad (address)
  • Field (role)

t_order

  • Key (order_id) — Primary key — NOT NULL
  • Field (order_date)
  • Field (order_status)
  • Key (member_id) — Foreign key → t_member.Key — NOT NULL

t_orderitem

  • Key (order_item_id) — Primary key — NOT NULL
  • Field (order_price)
  • Field (count)
  • Key (order_id) — Foreign key → t_order.Key — NOT NULL
  • Key (item_id) — Foreign key → t_item.Key — NOT NULL