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