|
id
|
varchar(50)
|
|
|
|
|
created_by
|
varchar(36)
|
|
|
|
|
seller_id
|
varchar(36)
|
|
|
|
|
rider_id
|
varchar(36)
|
|
|
|
|
amount
|
decimal(10,2)
|
|
|
|
|
currency
|
varchar(10)
|
|
|
KES
|
|
status
|
varchar(50)
|
|
|
|
|
pickup
|
longtext
|
|
|
|
|
dropoff
|
longtext
|
|
|
|
|
escrow_status
|
varchar(50)
|
|
|
|
|
escrow_held
|
tinyint(1)
|
|
|
1
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
otp_hash
|
varchar(255)
|
|
|
|
|
otp_expires_at
|
timestamp
|
|
|
|
|
otp_attempts
|
tinyint(4)
|
|
|
0
|