Kiosk

Tables (4)

Member (Untitled)

  • member_id (PK) — Primary key — NOT NULL
  • phone (Field)
  • grade (Field2)

order (Untitled3)

  • order_id (Key) — Primary key — NOT NULL
  • member_id (PK) — Foreign key → Member.member_id — NOT NULL
  • created_at (Field)

product (Untitled2)

  • product_id (Key) — Primary key — NOT NULL
  • product_name (Field)
  • price (Field2)
  • size (Field3)
  • type (Field4)
  • kcal (Field5)

product_order (Untitled4)

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