|
id
|
bigint(20)
|
|
|
|
|
order_id
|
bigint(20)
|
|
|
|
|
stop_index
|
int(11)
|
|
|
|
|
stop_type
|
enum
|
-- |
|
|
|
address_name
|
varchar(150)
|
|
|
|
|
address
|
varchar(255)
|
|
|
|
|
address_note
|
varchar(255)
|
|
|
|
|
lat
|
decimal(10,8)
|
|
|
|
|
lng
|
decimal(11,8)
|
|
|
|
|
contact_name
|
varchar(100)
|
|
|
|
|
contact_phone
|
varchar(20)
|
|
|
|
|
cod_amount
|
decimal(15,2)
|
|
|
0.00
|
|
status
|
enum
|
-- |
|
pending
|
|
fail_reason
|
varchar(255)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
stop_order
|
int(11)
|
|
|
0
|