Table openx.ox_data_summary_ad_zone_assoc 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_zone_assoc_id bigint 19  √ 
operation_interval int unsigned 10
operation_interval_id int unsigned 10
interval_start datetime 0
interval_end datetime 0
ad_id int unsigned 10
ox_banners.bannerid Defined in XML
zone_id int unsigned 10
ox_zones.zoneid Defined in XML
required_impressions int unsigned 10
requested_impressions int unsigned 10
priority double 22
priority_factor double 22  √  null
priority_factor_limited smallint 5 0
past_zone_traffic_fraction double 22  √  null
created datetime 0
created_by int unsigned 10
expired datetime 0  √  null
expired_by int unsigned 10  √  null
to_be_delivered bit 0 1

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

Indexes:
Column(s) Type Sort Constraint Name
data_summary_ad_zone_assoc_id Primary key Asc PRIMARY
ad_id Performance Asc ox_data_summary_ad_zone_assoc_ad_id
expired Performance Asc ox_data_summary_ad_zone_assoc_expired
interval_end Performance Asc ox_data_summary_ad_zone_assoc_interval_end
interval_start Performance Asc ox_data_summary_ad_zone_assoc_interval_start
zone_id Performance Asc ox_data_summary_ad_zone_assoc_zone_id

Close relationships  within of separation: