|
id
|
bigint(20) unsigned
|
|
|
|
|
payment_id
|
bigint(20) unsigned
|
|
|
|
|
order_id
|
bigint(20) unsigned
|
|
|
|
|
order_no
|
varchar(64)
|
|
|
|
|
channel_id
|
varchar(32)
|
|
|
|
|
line_user_id
|
varchar(64)
|
|
|
|
|
member_id
|
bigint(20) unsigned
|
|
|
|
|
referrer_member_id
|
bigint(20) unsigned
|
|
|
|
|
payment_amount
|
decimal(14,2)
|
|
|
|
|
commission_rate
|
decimal(7,4)
|
|
|
|
|
commission_amount
|
decimal(14,2)
|
|
|
|
|
payment_reference
|
varchar(191)
|
|
|
|
|
commission_ledger_id
|
bigint(20) unsigned
|
|
|
|
|
status
|
enum
|
-- |
|
paid
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
reversed_at
|
datetime
|
|
|
|