|
id
|
bigint(20) unsigned
|
|
|
|
|
ts
|
int(10) unsigned
|
|
|
|
|
click_id
|
bigint(20) unsigned
|
|
|
|
|
visitor_uid
|
char(32)
|
|
|
|
|
days_to_buy
|
smallint(5) unsigned
|
|
|
|
|
subid
|
varchar(200)
|
|
|
|
|
zone
|
varchar(100)
|
|
|
|
|
campaign
|
varchar(100)
|
|
|
|
|
geo
|
varchar(8)
|
|
|
|
|
network
|
varchar(50)
|
|
|
|
|
product
|
varchar(255)
|
|
|
|
|
type
|
varchar(20)
|
|
|
CPA
|
|
payout
|
decimal(12,2)
|
|
|
0.00
|
|
payout_currency
|
varchar(8)
|
|
|
IDR
|
|
payout_idr
|
decimal(12,2)
|
|
|
0.00
|
|
order_amount
|
decimal(12,2)
|
|
|
0.00
|
|
commission_rate
|
decimal(5,2)
|
|
|
0.00
|
|
status
|
enum
|
-- |
|
pending
|
|
source
|
varchar(20)
|
|
|
manual
|
|
external_id
|
varchar(100)
|
|
|
|
|
notes
|
varchar(255)
|
|
|
|
|
raw
|
text
|
|
|
|
|
created_at
|
int(10) unsigned
|
|
|
|