| id |
bigint(20)
|
|
|
|
| order_code |
varchar(32)
|
utf8mb4_unicode_ci
|
|
|
| user_id |
bigint(20)
|
|
|
|
| driver_id |
bigint(20)
|
|
|
|
| service_type_id |
int(11)
|
|
|
|
| status |
enum('finding_driver', 'pending', 'picking_up', 'picked_up', 'delivering', 'completed', 'returned', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| total_fee |
decimal(15,2)
|
|
|
|
| cargo_value |
decimal(15,2)
|
|
|
|
| total_cod_amount |
decimal(15,2)
|
|
|
|
| cash_to_collect |
decimal(15,2)
|
|
|
|
| payer |
enum('sender', 'receiver')
|
utf8mb4_unicode_ci
|
|
|
| payment_method |
enum('cash', 'wallet', 'credit_card')
|
utf8mb4_unicode_ci
|
|
|
| voucher_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| note_for_driver |
text
|
utf8mb4_unicode_ci
|
|
|
| package_size |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| weight |
int(11)
|
|
|
|
| category |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| assigned_driver_phone |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| assignment_type |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| is_round_trip |
tinyint(1)
|
|
|
|
| round_trip_fee |
decimal(15,2)
|
|
|
|
| distance_km |
decimal(10,2)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| cancellation_reason |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| updated_at |
timestamp
|
|
|
|
| max_delivery_minutes |
int(11)
|
|
|
|
| picked_up_at |
datetime
|
|
|
|
| delivered_at |
datetime
|
|
|
|
| is_late |
tinyint(1)
|
|
|
|
| is_auto_batch_enabled |
tinyint(1)
|
|
|
|
| platform_fee |
decimal(10,2)
|
|
|
|
| batch_group_id |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| batch_sequence_index |
tinyint(4)
|
|
|
|
