Table openx.ox_data_raw_tracker_impression Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
server_raw_tracker_impression_id bigint 19  √ 
ox_data_raw_tracker_variable_value.server_raw_tracker_impression_id Defined in XML
server_raw_ip varchar 16
viewer_id varchar 32
viewer_session_id varchar 32  √  null
date_time datetime 0
tracker_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 int unsigned 10  √  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 int unsigned 10  √  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

Indexes:
Column(s) Type Sort Constraint Name
server_raw_tracker_impression_id + server_raw_ip Primary key Asc/Asc PRIMARY
date_time Performance Asc ox_data_raw_tracker_impression_date_time
viewer_id Performance Asc ox_data_raw_tracker_impression_viewer_id

Close relationships  within of separation: