| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| campaignid |
mediumint |
7 |
|
√ |
|
|
|
| campaignname |
varchar |
255 |
|
|
|
|
|
| clientid |
mediumint |
7 |
|
|
0 |
|
|
| views |
int |
10 |
√ |
|
-1 |
|
|
| clicks |
int |
10 |
√ |
|
-1 |
|
|
| conversions |
int |
10 |
√ |
|
-1 |
|
|
| expire |
date |
0 |
√ |
|
0000-00-00 |
|
|
| activate |
date |
0 |
√ |
|
0000-00-00 |
|
|
| priority |
int |
10 |
|
|
0 |
|
|
| weight |
tinyint |
3 |
|
|
1 |
|
|
| target_impression |
int |
10 |
|
|
0 |
|
|
| target_click |
int |
10 |
|
|
0 |
|
|
| target_conversion |
int |
10 |
|
|
0 |
|
|
| anonymous |
enum |
2 |
|
|
f |
|
|
| companion |
smallint |
5 |
√ |
|
0 |
|
|
| comments |
text |
65535 |
√ |
|
null |
|
|
| revenue |
decimal |
10,4 |
√ |
|
null |
|
|
| revenue_type |
smallint |
5 |
√ |
|
null |
|
|
| updated |
datetime |
0 |
|
|
|
|
|
| block |
int |
10 |
|
|
0 |
|
|
| capping |
int |
10 |
|
|
0 |
|
|
| session_capping |
int |
10 |
|
|
0 |
|
|
| an_campaign_id |
int |
10 |
√ |
|
null |
|
|
| as_campaign_id |
int |
10 |
√ |
|
null |
|
|
| status |
int |
10 |
|
|
0 |
|
|
| an_status |
int |
10 |
|
|
0 |
|
|
| as_reject_reason |
int |
10 |
|
|
0 |
|
|
| hosted_views |
int |
10 |
|
|
0 |
|
|
| hosted_clicks |
int |
10 |
|
|
0 |
|
|
| viewwindow |
mediumint |
7 |
|
|
0 |
|
|
| clickwindow |
mediumint |
7 |
|
|
0 |
|
|
Table contained 4 rows at Sat Feb 28 16:58 EST 2009
|
