| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| zoneid |
mediumint |
7 |
|
√ |
|
|
|
| affiliateid |
mediumint |
7 |
√ |
|
null |
|
|
| zonename |
varchar |
245 |
|
|
|
|
|
| description |
varchar |
255 |
|
|
|
|
|
| delivery |
smallint |
5 |
|
|
0 |
|
|
| zonetype |
smallint |
5 |
|
|
0 |
|
|
| category |
text |
65535 |
|
|
|
|
|
| width |
smallint |
5 |
|
|
0 |
|
|
| height |
smallint |
5 |
|
|
0 |
|
|
| ad_selection |
text |
65535 |
|
|
|
|
|
| chain |
text |
65535 |
|
|
|
|
|
| prepend |
text |
65535 |
|
|
|
|
|
| append |
text |
65535 |
|
|
|
|
|
| appendtype |
tinyint |
3 |
|
|
0 |
|
|
| forceappend |
enum |
2 |
√ |
|
f |
|
|
| inventory_forecast_type |
smallint |
5 |
|
|
0 |
|
|
| comments |
text |
65535 |
√ |
|
null |
|
|
| cost |
decimal |
10,4 |
√ |
|
null |
|
|
| cost_type |
smallint |
5 |
√ |
|
null |
|
|
| cost_variable_id |
varchar |
255 |
√ |
|
null |
|
|
| technology_cost |
decimal |
10,4 |
√ |
|
null |
|
|
| technology_cost_type |
smallint |
5 |
√ |
|
null |
|
|
| updated |
datetime |
0 |
|
|
|
|
|
| block |
int |
10 |
|
|
0 |
|
|
| capping |
int |
10 |
|
|
0 |
|
|
| session_capping |
int |
10 |
|
|
0 |
|
|
| what |
text |
65535 |
|
|
|
|
|
| as_zone_id |
int |
10 |
√ |
|
null |
|
|
| is_in_ad_direct |
bit |
0 |
|
|
0 |
|
|
| rate |
decimal |
19,2 |
√ |
|
null |
|
|
| pricing |
varchar |
50 |
|
|
CPM |
|
|
| oac_category_id |
int |
10 |
√ |
|
null |
|
|
| compatibility_class |
smallint |
5 |
√ |
|
null |
|
|
Table contained 7 rows at Sat Feb 28 16:58 EST 2009
|
