| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| viewer_id |
varchar |
32 |
√ |
|
null |
|
|
| viewer_session_id |
varchar |
32 |
√ |
|
null |
|
|
| date_time |
datetime |
0 |
|
|
|
|
|
| ad_id |
int unsigned |
10 |
|
|
|
|
|
| creative_id |
int unsigned |
10 |
|
|
|
|
|
| zone_id |
int unsigned |
10 |
|
|
|
|
|
| channel |
varchar |
255 |
√ |
|
null |
|
|
| channel_ids |
varchar |
64 |
√ |
|
null |
|
|
| language |
varchar |
32 |
√ |
|
null |
|
|
| ip_address |
varchar |
16 |
√ |
|
null |
|
|
| host_name |
varchar |
255 |
√ |
|
null |
|
|
| country |
char |
2 |
√ |
|
null |
|
|
| https |
bit |
0 |
√ |
|
null |
|
|
| domain |
varchar |
255 |
√ |
|
null |
|
|
| page |
varchar |
255 |
√ |
|
null |
|
|
| query |
varchar |
255 |
√ |
|
null |
|
|
| referer |
varchar |
255 |
√ |
|
null |
|
|
| search_term |
varchar |
255 |
√ |
|
null |
|
|
| user_agent |
varchar |
255 |
√ |
|
null |
|
|
| os |
varchar |
32 |
√ |
|
null |
|
|
| browser |
varchar |
32 |
√ |
|
null |
|
|
| max_https |
bit |
0 |
√ |
|
null |
|
|
| geo_region |
varchar |
50 |
√ |
|
null |
|
|
| geo_city |
varchar |
50 |
√ |
|
null |
|
|
| geo_postal_code |
varchar |
10 |
√ |
|
null |
|
|
| geo_latitude |
decimal |
8,4 |
√ |
|
null |
|
|
| geo_longitude |
decimal |
8,4 |
√ |
|
null |
|
|
| geo_dma_code |
varchar |
50 |
√ |
|
null |
|
|
| geo_area_code |
varchar |
50 |
√ |
|
null |
|
|
| geo_organisation |
varchar |
50 |
√ |
|
null |
|
|
| geo_netspeed |
varchar |
20 |
√ |
|
null |
|
|
| geo_continent |
varchar |
13 |
√ |
|
null |
|
|
Table contained 0 rows at Sat Feb 28 16:58 EST 2009
|
