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)