| id |
int(11)
|
|
|
|
| table_id |
int(11)
|
|
|
|
| user_id |
int(11)
|
|
|
|
| client_id |
int(11)
|
|
|
Browse foreign values
|
| total |
decimal(10,2)
|
|
|
|
| status |
enum('pending', 'preparing', 'ready', 'paid', 'cancelled')
|
utf8mb4_general_ci
|
|
|
| payment_method |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| payment_detail |
text
|
utf8mb4_general_ci
|
|
|
| amount_paid |
decimal(10,2)
|
|
|
|
| change_amount |
decimal(10,2)
|
|
|
|
| order_type |
enum('local', 'takeout', 'delivery')
|
utf8mb4_general_ci
|
|
|
| delivery_fee |
decimal(10,2)
|
|
|
|
| client_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| client_phone |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| client_address |
text
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| cash_session_id |
int(11)
|
|
|
|
| external_id |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| is_hotel |
tinyint(1)
|
|
|
|
| deduct_delivery |
tinyint(1)
|
|
|
|
| tip_amount |
decimal(10,2)
|
|
|
|
| tip_percentage |
int(11)
|
|
|
|