|
id
|
char(36)
|
|
|
|
|
name
|
varchar(255)
|
|
|
|
|
date_entered
|
datetime
|
|
|
|
|
date_modified
|
datetime
|
|
|
|
|
modified_user_id
|
char(36)
|
|
|
|
|
created_by
|
char(36)
|
|
|
|
|
deleted
|
tinyint(1)
|
|
|
0
|
|
assigned_user_id
|
char(36)
|
|
|
|
|
tracker_key
|
int(11)
|
|
|
|
|
tracker_count
|
int(11)
|
|
|
0
|
|
refer_url
|
varchar(255)
|
|
|
http://
|
|
tracker_text
|
varchar(255)
|
|
|
|
|
start_date
|
date
|
|
|
|
|
end_date
|
date
|
|
|
|
|
status
|
varchar(100)
|
|
|
|
|
impressions
|
int(11)
|
|
|
0
|
|
currency_id
|
char(36)
|
|
|
|
|
budget
|
double
|
|
|
|
|
expected_cost
|
double
|
|
|
|
|
actual_cost
|
double
|
|
|
|
|
expected_revenue
|
double
|
|
|
|
|
campaign_type
|
varchar(100)
|
|
|
|
|
objective
|
text
|
|
|
|
|
content
|
text
|
|
|
|
|
frequency
|
varchar(100)
|
|
|
|
|
survey_id
|
char(36)
|
|
|
|