|
id
|
bigint(20) unsigned
|
|
|
|
|
order_no
|
varchar(40)
|
|
|
|
|
line_user_id
|
varchar(100)
|
|
|
|
|
sports_customer_id
|
bigint(20) unsigned
|
|
|
|
|
member_id
|
bigint(20) unsigned
|
|
|
|
|
referrer_member_id
|
bigint(20) unsigned
|
|
|
|
|
draft_id
|
bigint(20) unsigned
|
|
|
|
|
stake
|
decimal(14,2)
|
|
|
|
|
combined_odds
|
decimal(18,6)
|
|
|
|
|
potential_payout
|
decimal(14,2)
|
|
|
|
|
settled_payout
|
decimal(14,2)
|
|
|
|
|
status
|
enum
|
-- |
|
pending_payment
|
|
payment_status
|
enum
|
-- |
|
unpaid
|
|
payment_expires_at
|
datetime
|
|
|
|
|
paid_at
|
datetime
|
|
|
|
|
payment_reference
|
varchar(120)
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
settled_at
|
datetime
|
|
|
|