| id |
char |
36 |
|
|
|
|
|
| name |
varchar |
50 |
√ |
|
null |
|
|
| date_entered |
datetime |
19 |
√ |
|
null |
|
|
| date_modified |
datetime |
19 |
√ |
|
null |
|
|
| modified_user_id |
char |
36 |
√ |
|
null |
|
| users.id
|
Defined in XML R |
|
| created_by |
char |
36 |
√ |
|
null |
|
| users.id
|
Defined in XML R |
|
| deleted |
bit |
1 |
√ |
|
0 |
|
|
| assigned_user_id |
char |
36 |
√ |
|
null |
|
| users.id
|
Defined in XML R |
|
| team_id |
char |
36 |
√ |
|
null |
|
| teams.id
|
Defined in XML R |
|
| team_set_id |
char |
36 |
√ |
|
null |
|
|
| tracker_key |
int |
11 |
|
√ |
|
|
|
| tracker_count |
int |
11 |
√ |
|
0 |
|
|
| refer_url |
varchar |
255 |
√ |
|
http:// |
|
|
| tracker_text |
varchar |
255 |
√ |
|
null |
|
|
| start_date |
date |
10 |
√ |
|
null |
|
|
| end_date |
date |
10 |
√ |
|
null |
|
|
| status |
varchar |
100 |
√ |
|
null |
|
|
| impressions |
int |
11 |
√ |
|
0 |
|
|
| currency_id |
char |
36 |
√ |
|
null |
|
|
| budget |
double |
22 |
√ |
|
null |
|
|
| expected_cost |
double |
22 |
√ |
|
null |
|
|
| actual_cost |
double |
22 |
√ |
|
null |
|
|
| expected_revenue |
double |
22 |
√ |
|
null |
|
|
| campaign_type |
varchar |
100 |
√ |
|
null |
|
|
| objective |
text |
65535 |
√ |
|
null |
|
|
| content |
text |
65535 |
√ |
|
null |
|
|
| frequency |
varchar |
100 |
√ |
|
null |
|
|
