Table openx.ox_data_summary_zone_impression_history 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_zone_impression_history_id bigint 19  √ 
operation_interval int unsigned 10
operation_interval_id int unsigned 10
interval_start datetime 0
interval_end datetime 0
zone_id int unsigned 10
ox_zones.zoneid Defined in XML
forecast_impressions int unsigned 10  √  null
actual_impressions int unsigned 10  √  null
est smallint 5  √  null

Table contained 2,534 rows at Sat Feb 28 16:58 EST 2009

Indexes:
Column(s) Type Sort Constraint Name
data_summary_zone_impression_history_id Primary key Asc PRIMARY
operation_interval_id Performance Asc ox_data_summary_zone_impression_history_operation_interval_id
zone_id Performance Asc ox_data_summary_zone_impression_history_zone_id

Close relationships  within of separation: