test

Tables (5)

member (Untitled)

  • member_id (Key) — Primary key — NOT NULL

order (Untitled3)

  • order_id (Key2) — Primary key — NOT NULL
  • member_id (Key3) — Foreign key → member.member_id — NOT NULL

order_product (Untitled4)

  • order_product_id (Key) — Primary key — NOT NULL
  • order_id (Key2) — Foreign key → order.order_id — NOT NULL
  • product_id (Key3) — Foreign key → product.product_id — NOT NULL
  • price_at_order (Field)

payment (Untitled5)

  • payment_id (Key) — Primary key — NOT NULL
  • order_id (Key2) — Foreign key → order.order_id — NOT NULL

product (Untitled2)

  • product_id (Key) — Primary key — NOT NULL
  • name (Field)
  • price (Field2)