Table openx.ox_banners 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
bannerid mediumint 7  √ 
ox_acls.bannerid Defined in XML
ox_ad_category_assoc.ad_id Defined in XML
ox_ad_zone_assoc.ad_id Defined in XML
ox_data_bkt_a.creative_id Defined in XML
ox_data_bkt_c.creative_id Defined in XML
ox_data_bkt_m.creative_id Defined in XML
ox_data_bkt_r.creative_id Defined in XML
ox_data_intermediate_ad.ad_id Defined in XML
ox_data_raw_ad_click.ad_id Defined in XML
ox_data_raw_ad_impression.ad_id Defined in XML
ox_data_raw_ad_request.ad_id Defined in XML
ox_data_summary_ad_hourly.ad_id Defined in XML
ox_data_summary_ad_zone_assoc.ad_id Defined in XML
campaignid mediumint 7 0
ox_campaigns.campaignid Implied Constraint
contenttype enum 4 gif
pluginversion mediumint 7 0
storagetype enum 7 sql
filename varchar 255
imageurl varchar 255
htmltemplate text 65535
htmlcache text 65535
width smallint 5 0
height smallint 5 0
weight tinyint 3 1
seq tinyint 3 0
target varchar 16
url text 65535
alt varchar 255
statustext varchar 255
bannertext text 65535
description varchar 255
adserver varchar 50
block int 10 0
capping int 10 0
session_capping int 10 0
compiledlimitation text 65535
acl_plugins text 65535  √  null
append text 65535
appendtype tinyint 3 0
bannertype tinyint 3 0
alt_filename varchar 255
alt_imageurl varchar 255
alt_contenttype enum 4 gif
comments text 65535  √  null
updated datetime 0
acls_updated datetime 0 0000-00-00 00:00:00
keyword varchar 255
transparent bit 0 0
parameters text 65535  √  null
an_banner_id int 10  √  null
as_banner_id int 10  √  null
status int 10 0
ad_direct_status tinyint 3 0
ad_direct_rejection_reason_id tinyint 3 0
ext_bannertype varchar 255  √  null
field1 varchar 60  √  null
companion_banner text 65535  √  null
duration int 10  √  null
outgoing_filename varchar 255  √  null
vast_delivery smallint 5  √  null
compatibility_class smallint 5  √  1
companion_banner_height smallint 5  √  null
companion_banner_width smallint 5  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
bannerid Primary key Asc PRIMARY
campaignid Performance Asc ox_banners_campaignid

Close relationships  within of separation: