Table openx.ox_data_intermediate_ad_connection 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
data_intermediate_ad_connection_id bigint 19  √ 
ox_data_intermediate_ad_variable_value.data_intermediate_ad_connection_id Defined in XML
server_raw_ip varchar 16
server_raw_tracker_impression_id bigint 19
viewer_id varchar 32  √  null
viewer_session_id varchar 32  √  null
tracker_date_time datetime 0
connection_date_time datetime 0  √  null
tracker_id int unsigned 10
ox_trackers.trackerid Defined in XML
ad_id int unsigned 10
creative_id int unsigned 10
zone_id int unsigned 10
tracker_channel varchar 255  √  null
connection_channel varchar 255  √  null
tracker_channel_ids varchar 64  √  null
connection_channel_ids varchar 64  √  null
tracker_language varchar 13  √  null
connection_language varchar 13  √  null
tracker_ip_address varchar 16  √  null
connection_ip_address varchar 16  √  null
tracker_host_name varchar 255  √  null
connection_host_name varchar 255  √  null
tracker_country char 2  √  null
connection_country char 2  √  null
tracker_https int unsigned 10  √  null
connection_https int unsigned 10  √  null
tracker_domain varchar 255  √  null
connection_domain varchar 255  √  null
tracker_page varchar 255  √  null
connection_page varchar 255  √  null
tracker_query varchar 255  √  null
connection_query varchar 255  √  null
tracker_referer varchar 255  √  null
connection_referer varchar 255  √  null
tracker_search_term varchar 255  √  null
connection_search_term varchar 255  √  null
tracker_user_agent varchar 255  √  null
connection_user_agent varchar 255  √  null
tracker_os varchar 32  √  null
connection_os varchar 32  √  null
tracker_browser varchar 32  √  null
connection_browser varchar 32  √  null
connection_action int unsigned 10  √  null
connection_window int unsigned 10  √  null
connection_status int unsigned 10 4
inside_window bit 0 0
comments text 65535  √  null
updated datetime 0

Table contained 0 rows at Sat Feb 28 16:58 EST 2009

Indexes:
Column(s) Type Sort Constraint Name
data_intermediate_ad_connection_id Primary key Asc PRIMARY
ad_id Performance Asc ox_data_intermediate_ad_connection_ad_id
tracker_date_time Performance Asc ox_data_intermediate_ad_connection_tracker_date_time
tracker_id Performance Asc ox_data_intermediate_ad_connection_tracker_id
viewer_id Performance Asc ox_data_intermediate_ad_connection_viewer_id
zone_id Performance Asc ox_data_intermediate_ad_connection_zone_id

Close relationships  within of separation: