|
id
|
bigint(20)
|
|
|
|
|
order_code
|
varchar(32)
|
|
|
|
|
user_id
|
bigint(20)
|
|
|
|
|
driver_id
|
bigint(20)
|
|
|
|
|
service_type_id
|
int(11)
|
|
|
|
|
status
|
enum
|
-- |
|
finding_driver
|
|
total_fee
|
decimal(15,2)
|
|
|
|
|
cargo_value
|
decimal(15,2)
|
|
|
0.00
|
|
total_cod_amount
|
decimal(15,2)
|
|
|
0.00
|
|
cash_to_collect
|
decimal(15,2)
|
|
|
0.00
|
|
payer
|
enum
|
-- |
|
sender
|
|
payment_method
|
enum
|
-- |
|
cash
|
|
voucher_code
|
varchar(50)
|
|
|
|
|
note_for_driver
|
text
|
|
|
|
|
package_size
|
varchar(20)
|
|
|
S
|
|
weight
|
int(11)
|
|
|
1
|
|
category
|
varchar(100)
|
|
|
Thời trang
|
|
assigned_driver_phone
|
varchar(20)
|
|
|
|
|
assignment_type
|
varchar(20)
|
|
|
manual
|
|
is_round_trip
|
tinyint(1)
|
|
|
0
|
|
round_trip_fee
|
decimal(15,2)
|
|
|
0.00
|
|
distance_km
|
decimal(10,2)
|
|
|
0.00
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
cancellation_reason
|
varchar(255)
|
|
|
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|
|
max_delivery_minutes
|
int(11)
|
|
|
60
|
|
picked_up_at
|
datetime
|
|
|
|
|
delivered_at
|
datetime
|
|
|
|
|
is_late
|
tinyint(1)
|
|
|
0
|
|
is_auto_batch_enabled
|
tinyint(1)
|
|
|
0
|
|
platform_fee
|
decimal(10,2)
|
|
|
0.00
|
|
batch_group_id
|
varchar(64)
|
|
|
|
|
batch_sequence_index
|
tinyint(4)
|
|
|
1
|
