| id |
bigint(20)
|
|
|
|
| public_id |
varchar(32)
|
ascii_bin
|
|
|
| token |
varchar(64)
|
ascii_bin
|
|
|
| external_order_id |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| status |
varchar(16)
|
utf8mb4_general_ci
|
|
|
| currency_id |
int(11)
|
|
|
|
| locale |
varchar(8)
|
utf8mb4_general_ci
|
|
|
| allow_quantity_decrease |
tinyint(1)
|
|
|
|
| allowed_payment_methods |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| allowed_delivery_types |
varchar(32)
|
utf8mb4_general_ci
|
|
|
| customer |
longtext
|
utf8mb4_bin
|
|
|
| delivery |
longtext
|
utf8mb4_bin
|
|
|
| payment_method |
varchar(16)
|
utf8mb4_general_ci
|
|
|
| subtotal |
decimal(15,2)
|
|
|
|
| discount |
decimal(15,2)
|
|
|
|
| delivery_amount |
decimal(15,2)
|
|
|
|
| tax |
decimal(15,2)
|
|
|
|
| total |
decimal(15,2)
|
|
|
|
| success_url |
varchar(2048)
|
utf8mb4_general_ci
|
|
|
| cancel_url |
varchar(2048)
|
utf8mb4_general_ci
|
|
|
| metadata |
longtext
|
utf8mb4_bin
|
|
|
| mz_id |
bigint(20)
|
|
|
|
| idempotency_key |
varchar(64)
|
utf8mb4_bin
|
|
|
| request_hash |
char(64)
|
ascii_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| expires_at |
datetime
|
|
|
|
| placed_at |
datetime
|
|
|
|
| completed_at |
datetime
|
|
|
|
| idempotency_response |
longtext
|
utf8mb4_general_ci
|
|
|
| place_idempotency_key |
varchar(64)
|
utf8mb4_bin
|
|
|
| place_request_hash |
char(64)
|
ascii_general_ci
|
|
|
| place_response |
text
|
utf8mb4_general_ci
|
|
|
| receipt_done_at |
datetime
|
|
|
|
| digital_done_at |
datetime
|
|
|
|
| reissued_payment_id |
varchar(64)
|
ascii_bin
|
|
|
| spz_id |
bigint(20)
|
|
|
|
| payment_link_id |
bigint(20)
|
|
|
|
| cart_id |
bigint(20)
|
|
|
|
| channel |
varchar(16)
|
utf8mb4_general_ci
|
|
|
| reminder_sent_at |
datetime
|
|
|
|
| order_cancelled_at |
datetime
|
|
|
|
| allow_promotion_codes |
tinyint(1)
|
|
|
|
| promo_code_id |
bigint(20)
|
|
|
|
| promo_code |
varchar(32)
|
ascii_bin
|
|
|
| promo_type |
varchar(8)
|
utf8mb4_general_ci
|
|
|
| promo_value |
decimal(15,2)
|
|
|
|
| promo_min_subtotal |
decimal(15,2)
|
|
|
|