|
id
|
int(11)
|
|
|
|
|
user_id
|
int(11)
|
|
|
|
|
target_type
|
varchar(10)
|
|
|
post
|
|
target_id
|
int(11)
|
|
|
|
|
title
|
varchar(120)
|
|
|
|
|
budget
|
decimal(10,2)
|
|
|
0.00
|
|
price_per_1000
|
decimal(10,2)
|
|
|
0.00
|
|
impressions_target
|
int(11)
|
|
|
0
|
|
impressions_delivered
|
int(11)
|
|
|
0
|
|
clicks_count
|
int(11)
|
|
|
0
|
|
duration_days
|
smallint(6)
|
|
|
7
|
|
target_countries
|
varchar(100)
|
|
|
|
|
target_devices
|
varchar(30)
|
|
|
|
|
payment_method
|
varchar(20)
|
|
|
|
|
payment_sender
|
varchar(40)
|
|
|
|
|
payment_ref
|
varchar(80)
|
|
|
|
|
payment_screenshot
|
varchar(500)
|
|
|
|
|
status
|
varchar(16)
|
|
|
draft
|
|
admin_reason
|
varchar(500)
|
|
|
|
|
reviewed_by
|
int(11)
|
|
|
|
|
reviewed_at
|
datetime
|
|
|
|
|
submit_count
|
smallint(6)
|
|
|
0
|
|
starts_at
|
datetime
|
|
|
|
|
ends_at
|
datetime
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|
|
ad_kind
|
varchar(10)
|
|
|
feed
|
|
description
|
varchar(300)
|
|
|
|
|
link_url
|
varchar(500)
|
|
|
|
|
creative_path
|
varchar(500)
|
|
|
|
|
whatsapp
|
varchar(20)
|
|
|
|
|
chat_enabled
|
tinyint(1)
|
|
|
1
|
|
cta_text
|
varchar(30)
|
|
|
|
|
scan_note
|
varchar(255)
|
|
|
|