KiosPager

Tables (6)

Member (4)

  • member_id (Key) — BIG_INT — Primary key — NOT NULL
  • email (Field) — VARCHAR
  • refresh_token (Field2) — VARCHAR
  • user_name (Field3) — VARCHAR
  • auth_provider​ (Field4) — ENUM

Order (2)

  • order_id (Key) — BIG_INT — Primary key — NOT NULL
  • pay_id — BIG_INT — Foreign key → Payment.pay_id — NOT NULL
  • member_id — BIG_INT — Foreign key → Member.member_id — NOT NULL
  • store_id — BIG_INT
  • buzzer_id (Field) — VARCHAR
  • create_at (Field2) — DATETIME
  • order_status (Field3) — TINYINT(1)
  • order_type (enum) — ENUM

OrderItem (3)

  • order_item_id — BIG_INT — Primary key — NOT NULL
  • order_id (Key) — BIG_INT — Foreign key → Order.order_id — NOT NULL
  • munu_name (Field3) — VARCHAR
  • category (Field) — VARCHAR
  • price (Field2) — BIGINT
  • take_out (Field4) — VARCHAR
  • option_json (Field5) — TEXT
  • quantity (Field6) — INT

Payment (1)

  • pay_id (Key) — BIG_INT — Primary key — NOT NULL
  • imp_uid (Field) — VARCHAR
  • merchant_uid (Field2) — VARCHAR
  • total_price (Field3) — INT

Photo (6)

  • photo_id (Key) — BIG_INT — Primary key — NOT NULL
  • setting_item_id — BIG_INT — Foreign key → SettingItem.setting_item_id — NOT NULL
  • photo_name (Field) — VARCHAR

SettingItem (5)

  • setting_item_id — BIG_INT — Primary key — NOT NULL
  • member_id (Key) — BIG_INT — Foreign key → Member.member_id — NOT NULL
  • category (Field2) — VARCHAR
  • menu_name (Field3) — VARCHAR
  • price (Field4) — INT
  • option_json (Field5) — TEXT
  • store_id (Field6) — BIG_INT
  • photo_name (Field7) — VARCHAR
  • deleted (Field) — TINYINT(1)