Table openx.ox_data_summary_ad_hourly 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_summary_ad_hourly_id bigint 19  √ 
date_time datetime 0
ad_id int unsigned 10
ox_banners.bannerid Defined in XML
creative_id int unsigned 10
zone_id int unsigned 10
ox_zones.zoneid Defined in XML
requests int unsigned 10 0
impressions int unsigned 10 0
clicks int unsigned 10 0
conversions int unsigned 10 0
total_basket_value decimal 10,4  √  null
total_num_items int 10  √  null
total_revenue decimal 10,4  √  null
total_cost decimal 10,4  √  null
total_techcost decimal 10,4  √  null
updated datetime 0

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

Indexes:
Column(s) Type Sort Constraint Name
data_summary_ad_hourly_id Primary key Asc PRIMARY
ad_id + date_time Performance Asc/Asc ox_data_summary_ad_hourly_ad_id_date_time
date_time Performance Asc ox_data_summary_ad_hourly_date_time
zone_id + date_time Performance Asc/Asc ox_data_summary_ad_hourly_zone_id_date_time

Close relationships  within of separation: