openx contains 643 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
ox_affiliates_extra	account_contact	varchar	255	√		null
ox_accounts	account_id	mediumint	7		√		ox_account_preference_assoc.account_id Defined in XML ox_account_user_assoc.account_id Defined in XML ox_account_user_permission_assoc.account_id Defined in XML ox_affiliates.account_id Defined in XML ox_audit.account_id Defined in XML ox_audit.advertiser_account_id Defined in XML ox_audit.website_account_id Defined in XML ox_clients.account_id Defined in XML ox_ext_market_assoc_data.account_id Defined in XML ox_users.default_account_id Defined in XML
ox_agency	account_id	mediumint	7	√		null		ox_ext_market_assoc_data.account_id Implied Constraint
ox_accounts	account_name	varchar	255	√		null
ox_accounts	account_type	varchar	16
ox_preferences	account_type	varchar	16
ox_banners	acl_plugins	text	65535	√		null
ox_channel	acl_plugins	text	65535	√		null
ox_banners	acls_updated	datetime	0			0000-00-00 00:00:00
ox_channel	acls_updated	datetime	0			0000-00-00 00:00:00
ox_data_bkt_a	action	int	10	√		null
ox_database_action	action	int	10
ox_upgrade_action	action	int	10
ox_userlog	action	mediumint	7			0
ox_data_bkt_a	action_date_time	datetime	0
ox_audit	actionid	mediumint	7
ox_campaigns	activate	date	0	√		0000-00-00
ox_agency	active	smallint	5	√		0
ox_channel	active	smallint	5	√		null
ox_users	active	bit	0			1
ox_data_summary_channel_daily	actual_impressions	int unsigned	10			0
ox_data_summary_zone_impression_history	actual_impressions	int unsigned	10	√		null
ox_ad_category_assoc	ad_category_assoc_id	int unsigned	10		√
ox_banners	ad_direct_rejection_reason_id	tinyint	3			0
ox_banners	ad_direct_status	tinyint	3			0
ox_data_intermediate_ad_connection	ad_id	int unsigned	10
ox_zones	ad_selection	text	65535
ox_ad_zone_assoc	ad_zone_assoc_id	mediumint	7		√
ox_affiliates_extra	address	text	65535	√		null
ox_banners	adserver	varchar	50
ox_log_maintenance_statistics	adserver_run_type	int	10	√		null
ox_clients	advertiser_limitation	bit	0			0
ox_affiliates	affiliateid	mediumint	7		√		ox_affiliates_extra.affiliateid Defined in XML ox_ext_market_website_pref.affiliateid Defined in XML ox_variable_publisher.publisher_id Defined in XML ox_zones.affiliateid Defined in XML
ox_channel	affiliateid	mediumint	7			0		ox_affiliates_extra.affiliateid Implied Constraint
ox_agency	agencyid	mediumint	7		√		ox_affiliates.agencyid Defined in XML ox_channel.agencyid Implied Constraint ox_clients.agencyid Defined in XML
ox_channel	agencyid	mediumint	7			0		ox_agency.agencyid Implied Constraint
ox_banners	alt	varchar	255
ox_banners	alt_contenttype	enum	4			gif
ox_banners	alt_filename	varchar	255
ox_banners	alt_imageurl	varchar	255
ox_clients	an_adnetwork_id	int	10	√		null
ox_banners	an_banner_id	int	10	√		null
ox_campaigns	an_campaign_id	int	10	√		null
ox_campaigns	an_status	int	10			0
ox_affiliates	an_website_id	int	10	√		null
ox_campaigns	anonymous	enum	2			f
ox_banners	append	text	65535
ox_zones	append	text	65535
ox_trackers	appendcode	text	65535
ox_banners	appendtype	tinyint	3			0
ox_zones	appendtype	tinyint	3			0
ox_clients	as_advertiser_id	int	10	√		null
ox_banners	as_banner_id	int	10	√		null
ox_campaigns	as_campaign_id	int	10	√		null
ox_campaigns	as_reject_reason	int	10			0
ox_affiliates	as_website_id	int	10	√		null
ox_zones	as_zone_id	int	10	√		null
ox_audit	auditid	mediumint	7		√
ox_tracker_append	autotrack	enum	2			f
ox_banners	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
ox_banners	bannertext	text	65535
ox_banners	bannertype	tinyint	3			0
ox_banners	block	int	10			0
ox_campaigns	block	int	10			0
ox_zones	block	int	10			0
ox_trackers	blockwindow	mediumint	7			0
ox_data_raw_ad_click	browser	varchar	32	√		null
ox_data_raw_ad_impression	browser	varchar	32	√		null
ox_data_raw_ad_request	browser	varchar	32	√		null
ox_data_raw_tracker_impression	browser	varchar	32	√		null
ox_campaigns_trackers	campaign_trackerid	mediumint	7		√
ox_banners	campaignid	mediumint	7			0		ox_campaigns.campaignid Implied Constraint
ox_campaigns	campaignid	mediumint	7		√		ox_banners.campaignid Implied Constraint ox_campaigns_trackers.campaignid Defined in XML ox_ext_market_campaign_pref.campaignid Defined in XML ox_placement_zone_assoc.placement_id Defined in XML ox_targetstats.campaignid Defined in XML
ox_campaigns	campaignname	varchar	255
ox_banners	capping	int	10			0
ox_campaigns	capping	int	10			0
ox_zones	capping	int	10			0
ox_affiliates_extra	category	varchar	255	√		null
ox_zones	category	text	65535
ox_category	category_id	int unsigned	10		√		ox_ad_category_assoc.category_id Defined in XML
ox_zones	chain	text	65535
ox_data_raw_ad_click	channel	varchar	255	√		null
ox_data_raw_ad_impression	channel	varchar	255	√		null
ox_data_raw_ad_request	channel	varchar	255	√		null
ox_data_raw_tracker_impression	channel	varchar	255	√		null
ox_data_raw_ad_click	channel_ids	varchar	64	√		null
ox_data_raw_ad_impression	channel_ids	varchar	64	√		null
ox_data_raw_ad_request	channel_ids	varchar	64	√		null
ox_data_raw_tracker_impression	channel_ids	varchar	64	√		null
ox_channel	channelid	mediumint	7		√		ox_acls_channel.channelid Defined in XML ox_data_summary_channel_daily.channel_id Defined in XML
ox_affiliates_extra	city	varchar	255	√		null
ox_campaigns	clicks	int	10	√		-1
ox_data_intermediate_ad	clicks	int unsigned	10			0
ox_data_summary_ad_hourly	clicks	int unsigned	10			0
ox_campaigns	clickwindow	mediumint	7			0
ox_trackers	clickwindow	mediumint	7			0
ox_campaigns	clientid	mediumint	7			0		ox_clients.clientid Implied Constraint
ox_clients	clientid	mediumint	7		√		ox_campaigns.clientid Implied Constraint ox_trackers.clientid Implied Constraint
ox_trackers	clientid	mediumint	7			0		ox_clients.clientid Implied Constraint
ox_clients	clientname	varchar	255
ox_affiliates	comments	text	65535	√		null
ox_banners	comments	text	65535	√		null
ox_campaigns	comments	text	65535	√		null
ox_channel	comments	text	65535	√		null
ox_clients	comments	text	65535	√		null
ox_data_intermediate_ad_connection	comments	text	65535	√		null
ox_users	comments	text	65535	√		null
ox_zones	comments	text	65535	√		null
ox_campaigns	companion	smallint	5	√		0
ox_banners	companion_banner	text	65535	√		null
ox_banners	companion_banner_height	smallint	5	√		null
ox_banners	companion_banner_width	smallint	5	√		null
ox_acls	comparison	char	2			==
ox_acls_channel	comparison	char	2			==
ox_banners	compatibility_class	smallint	5	√		1
ox_zones	compatibility_class	smallint	5	√		null
ox_banners	compiledlimitation	text	65535
ox_channel	compiledlimitation	text	65535
ox_upgrade_action	confbackup	varchar	128	√		null
ox_data_intermediate_ad_connection	connection_action	int unsigned	10	√		null
ox_data_intermediate_ad_connection	connection_browser	varchar	32	√		null
ox_data_intermediate_ad_connection	connection_channel	varchar	255	√		null
ox_data_intermediate_ad_connection	connection_channel_ids	varchar	64	√		null
ox_data_intermediate_ad_connection	connection_country	char	2	√		null
ox_data_intermediate_ad_connection	connection_date_time	datetime	0	√		null
ox_data_intermediate_ad_connection	connection_domain	varchar	255	√		null
ox_data_intermediate_ad_connection	connection_host_name	varchar	255	√		null
ox_data_intermediate_ad_connection	connection_https	int unsigned	10	√		null
ox_data_intermediate_ad_connection	connection_ip_address	varchar	16	√		null
ox_data_intermediate_ad_connection	connection_language	varchar	13	√		null
ox_data_intermediate_ad_connection	connection_os	varchar	32	√		null
ox_data_intermediate_ad_connection	connection_page	varchar	255	√		null
ox_data_intermediate_ad_connection	connection_query	varchar	255	√		null
ox_data_intermediate_ad_connection	connection_referer	varchar	255	√		null
ox_data_intermediate_ad_connection	connection_search_term	varchar	255	√		null
ox_data_intermediate_ad_connection	connection_status	int unsigned	10			4
ox_data_intermediate_ad_connection	connection_user_agent	varchar	255	√		null
ox_data_intermediate_ad_connection	connection_window	int unsigned	10	√		null
ox_affiliates	contact	varchar	255	√		null
ox_agency	contact	varchar	255	√		null
ox_clients	contact	varchar	255	√		null
ox_users	contact_name	varchar	255
ox_images	contents	longblob	2147483647
ox_banners	contenttype	enum	4			gif
ox_audit	context	varchar	255
ox_audit	contextid	mediumint	7	√		null
ox_campaigns	conversions	int	10	√		-1
ox_data_intermediate_ad	conversions	int unsigned	10			0
ox_data_summary_ad_hourly	conversions	int unsigned	10			0
ox_zones	cost	decimal	10,4	√		null
ox_zones	cost_type	smallint	5	√		null
ox_zones	cost_variable_id	varchar	255	√		null
ox_data_bkt_c	count	int	10			0
ox_data_bkt_m	count	int	10			0
ox_data_bkt_r	count	int	10			0
ox_affiliates_extra	country	varchar	255	√		null
ox_data_raw_ad_click	country	char	2	√		null
ox_data_raw_ad_impression	country	char	2	√		null
ox_data_raw_tracker_impression	country	char	2	√		null
ox_data_summary_ad_zone_assoc	created	datetime	0
ox_data_summary_ad_zone_assoc	created_by	int unsigned	10
ox_data_intermediate_ad	creative_id	int unsigned	10
ox_data_intermediate_ad_connection	creative_id	int unsigned	10
ox_data_raw_ad_click	creative_id	int unsigned	10
ox_data_raw_ad_impression	creative_id	int unsigned	10
ox_data_raw_ad_request	creative_id	int unsigned	10
ox_data_summary_ad_hourly	creative_id	int unsigned	10
ox_affiliates_extra	currency	varchar	64	√		null
ox_acls	data	text	65535
ox_acls_channel	data	text	65535
ox_data_intermediate_ad_connection	data_intermediate_ad_connection_id	bigint	19		√		ox_data_intermediate_ad_variable_value.data_intermediate_ad_connection_id Defined in XML
ox_data_intermediate_ad	data_intermediate_ad_id	bigint	19		√
ox_data_intermediate_ad_variable_value	data_intermediate_ad_variable_value_id	bigint	19		√
ox_data_summary_ad_hourly	data_summary_ad_hourly_id	bigint	19		√
ox_data_summary_ad_zone_assoc	data_summary_ad_zone_assoc_id	bigint	19		√
ox_data_summary_channel_daily	data_summary_channel_daily_id	bigint	19		√
ox_data_summary_zone_impression_history	data_summary_zone_impression_history_id	bigint	19		√
ox_database_action	database_action_id	int unsigned	10		√
ox_variables	datatype	enum	8			numeric
ox_users	date_created	datetime	0	√		null
ox_users	date_last_login	datetime	0	√		null
ox_data_bkt_a	date_time	datetime	0
ox_data_bkt_a_var	date_time	datetime	0
ox_data_intermediate_ad	date_time	datetime	0
ox_data_raw_ad_click	date_time	datetime	0
ox_data_raw_ad_impression	date_time	datetime	0
ox_data_raw_ad_request	date_time	datetime	0
ox_data_raw_tracker_impression	date_time	datetime	0
ox_data_raw_tracker_variable_value	date_time	datetime	0	√		null
ox_data_summary_ad_hourly	date_time	datetime	0
ox_ext_market_web_stats	date_time	datetime	0	√		null
ox_data_summary_channel_daily	day	date	0
ox_targetstats	day	date	0			0000-00-00
ox_zones	delivery	smallint	5			0
ox_banners	description	varchar	255
ox_channel	description	varchar	255	√		null
ox_trackers	description	varchar	255
ox_upgrade_action	description	varchar	255	√		null
ox_variables	description	varchar	250	√		null
ox_zones	description	varchar	255
ox_audit	details	text	65535
ox_userlog	details	mediumtext	16777215	√		null
ox_data_raw_ad_click	domain	varchar	255	√		null
ox_data_raw_ad_impression	domain	varchar	255	√		null
ox_data_raw_ad_request	domain	varchar	255	√		null
ox_data_raw_tracker_impression	domain	varchar	255	√		null
ox_banners	duration	int	10	√		null
ox_log_maintenance_forecasting	duration	int	10
ox_log_maintenance_priority	duration	int	10
ox_log_maintenance_statistics	duration	int	10
ox_affiliates	email	varchar	64
ox_agency	email	varchar	64
ox_clients	email	varchar	64
ox_users	email_address	varchar	64
ox_users	email_updated	datetime	0	√		null
ox_log_maintenance_forecasting	end_run	datetime	0
ox_log_maintenance_priority	end_run	datetime	0
ox_log_maintenance_statistics	end_run	datetime	0
ox_data_summary_zone_impression_history	est	smallint	5	√		null
ox_acls	executionorder	int unsigned	10			0
ox_acls_channel	executionorder	int unsigned	10			0
ox_campaigns	expire	date	0	√		0000-00-00
ox_data_summary_ad_zone_assoc	expired	datetime	0	√		null
ox_data_summary_ad_zone_assoc	expired_by	int unsigned	10	√		null
ox_banners	ext_bannertype	varchar	255	√		null
ox_affiliates_extra	fax	varchar	64	√		null
ox_banners	field1	varchar	60	√		null
ox_banners	filename	varchar	255
ox_images	filename	varchar	128
ox_ext_market_campaign_pref	floor_price	decimal	10,4	√		null
ox_zones	forceappend	enum	2	√		f
ox_data_summary_channel_daily	forecast_impressions	int unsigned	10			0
ox_data_summary_zone_impression_history	forecast_impressions	int unsigned	10	√		null
ox_data_raw_ad_click	geo_area_code	varchar	50	√		null
ox_data_raw_ad_impression	geo_area_code	varchar	50	√		null
ox_data_raw_tracker_impression	geo_area_code	varchar	50	√		null
ox_data_raw_ad_click	geo_city	varchar	50	√		null
ox_data_raw_ad_impression	geo_city	varchar	50	√		null
ox_data_raw_tracker_impression	geo_city	varchar	50	√		null
ox_data_raw_ad_click	geo_continent	varchar	13	√		null
ox_data_raw_ad_impression	geo_continent	varchar	13	√		null
ox_data_raw_tracker_impression	geo_continent	varchar	13	√		null
ox_data_raw_ad_click	geo_dma_code	varchar	50	√		null
ox_data_raw_ad_impression	geo_dma_code	varchar	50	√		null
ox_data_raw_tracker_impression	geo_dma_code	varchar	50	√		null
ox_data_raw_ad_click	geo_latitude	decimal	8,4	√		null
ox_data_raw_ad_impression	geo_latitude	decimal	8,4	√		null
ox_data_raw_tracker_impression	geo_latitude	decimal	8,4	√		null
ox_data_raw_ad_click	geo_longitude	decimal	8,4	√		null
ox_data_raw_ad_impression	geo_longitude	decimal	8,4	√		null
ox_data_raw_tracker_impression	geo_longitude	decimal	8,4	√		null
ox_data_raw_ad_click	geo_netspeed	varchar	20	√		null
ox_data_raw_ad_impression	geo_netspeed	varchar	20	√		null
ox_data_raw_tracker_impression	geo_netspeed	varchar	20	√		null
ox_data_raw_ad_click	geo_organisation	varchar	50	√		null
ox_data_raw_ad_impression	geo_organisation	varchar	50	√		null
ox_data_raw_tracker_impression	geo_organisation	varchar	50	√		null
ox_data_raw_ad_click	geo_postal_code	varchar	10	√		null
ox_data_raw_ad_impression	geo_postal_code	varchar	10	√		null
ox_data_raw_tracker_impression	geo_postal_code	varchar	10	√		null
ox_data_raw_ad_click	geo_region	varchar	50	√		null
ox_data_raw_ad_impression	geo_region	varchar	50	√		null
ox_data_raw_tracker_impression	geo_region	varchar	50	√		null
ox_banners	height	smallint	5			0
ox_ext_market_web_stats	height	smallint	5	√		null
ox_zones	height	smallint	5			0
ox_affiliates_extra	help_file	varchar	255	√		null
ox_variables	hidden	enum	2			f
ox_data_raw_ad_click	host_name	varchar	255	√		null
ox_data_raw_ad_impression	host_name	varchar	255	√		null
ox_data_raw_ad_request	host_name	varchar	255	√		null
ox_data_raw_tracker_impression	host_name	varchar	255	√		null
ox_campaigns	hosted_clicks	int	10			0
ox_campaigns	hosted_views	int	10			0
ox_banners	htmlcache	text	65535
ox_banners	htmltemplate	text	65535
ox_data_raw_ad_click	https	bit	0	√		null
ox_data_raw_ad_impression	https	bit	0	√		null
ox_data_raw_ad_request	https	bit	0	√		null
ox_data_raw_tracker_impression	https	int unsigned	10	√		null
ox_banners	imageurl	varchar	255
ox_data_intermediate_ad	impressions	int unsigned	10			0
ox_data_summary_ad_hourly	impressions	int unsigned	10			0
ox_ext_market_web_stats	impressions	int	10
ox_database_action	info1	varchar	255	√		null
ox_database_action	info2	varchar	255	√		null
ox_data_intermediate_ad_connection	inside_window	bit	0			0
ox_data_intermediate_ad	interval_end	datetime	0
ox_data_summary_ad_zone_assoc	interval_end	datetime	0
ox_data_summary_zone_impression_history	interval_end	datetime	0
ox_data_bkt_c	interval_start	datetime	0
ox_data_bkt_m	interval_start	datetime	0
ox_data_bkt_r	interval_start	datetime	0
ox_data_intermediate_ad	interval_start	datetime	0
ox_data_summary_ad_zone_assoc	interval_start	datetime	0
ox_data_summary_zone_impression_history	interval_start	datetime	0
ox_zones	inventory_forecast_type	smallint	5			0
ox_data_bkt_a	ip_address	varchar	16
ox_data_raw_ad_click	ip_address	varchar	16	√		null
ox_data_raw_ad_impression	ip_address	varchar	16	√		null
ox_data_raw_ad_request	ip_address	varchar	16	√		null
ox_data_raw_tracker_impression	ip_address	varchar	16	√		null
ox_account_user_permission_assoc	is_allowed	bit	0			1
ox_ext_market_campaign_pref	is_enabled	smallint	5	√		0
ox_zones	is_in_ad_direct	bit	0			0
ox_variables	is_unique	int	10			0
ox_ext_market_website_pref	is_url_synchronized	enum	2	√		t
ox_banners	keyword	varchar	255
ox_data_raw_ad_click	language	varchar	32	√		null
ox_data_raw_ad_impression	language	varchar	32	√		null
ox_data_raw_ad_request	language	varchar	32	√		null
ox_data_raw_tracker_impression	language	varchar	32	√		null
ox_users	language	varchar	5	√		null
ox_session	lastused	datetime	0	√		null
ox_clients	lb_reporting	bit	0			0
ox_ad_zone_assoc	link_type	smallint	5			1
ox_trackers	linkcampaigns	enum	2			f
ox_account_user_assoc	linked	datetime	0
ox_log_maintenance_forecasting	log_maintenance_forecasting_id	int	10		√
ox_log_maintenance_priority	log_maintenance_priority_id	int	10		√
ox_log_maintenance_statistics	log_maintenance_statistics_id	int	10		√
ox_upgrade_action	logfile	varchar	128	√		null
ox_acls	logical	varchar	3			and
ox_acls_channel	logical	varchar	3			and
ox_agency	logout_url	varchar	255	√		null
ox_accounts	m2m_password	varchar	32	√		null
ox_accounts	m2m_ticket	varchar	32	√		null
ox_ext_market_setting	market_setting_id	mediumint	7
ox_ext_market_setting	market_setting_type_id	mediumint	7
ox_data_raw_ad_click	max_https	bit	0	√		null
ox_data_raw_ad_impression	max_https	bit	0	√		null
ox_data_raw_ad_request	max_https	bit	0	√		null
ox_data_raw_tracker_impression	max_https	int unsigned	10	√		null
ox_affiliates	mnemonic	varchar	5
ox_affiliates_extra	mode_of_payment	varchar	64	√		null
ox_targetstats	modified	tinyint	3			0
ox_affiliates	name	varchar	255					ox_ext_market_general_pref.name Implied Constraint
ox_agency	name	varchar	255					ox_ext_market_general_pref.name Implied Constraint
ox_application_variable	name	varchar	255
ox_category	name	varchar	255	√		null
ox_channel	name	varchar	255	√		null		ox_ext_market_general_pref.name Implied Constraint
ox_ext_market_general_pref	name	varchar	255				ox_affiliates.name Implied Constraint ox_agency.name Implied Constraint ox_channel.name Implied Constraint
ox_variables	name	varchar	250
ox_affiliates	oac_category_id	int	10	√		null
ox_zones	oac_category_id	int	10	√		null
ox_affiliates	oac_country_code	char	2
ox_affiliates	oac_language_id	int	10	√		null
ox_userlog	object	mediumint	7	√		null
ox_data_intermediate_ad	operation_interval	int unsigned	10
ox_data_summary_ad_zone_assoc	operation_interval	int unsigned	10
ox_data_summary_zone_impression_history	operation_interval	int unsigned	10
ox_log_maintenance_forecasting	operation_interval	int	10
ox_log_maintenance_priority	operation_interval	int	10
ox_data_intermediate_ad	operation_interval_id	int unsigned	10
ox_data_summary_ad_zone_assoc	operation_interval_id	int unsigned	10
ox_data_summary_zone_impression_history	operation_interval_id	int unsigned	10
ox_data_raw_ad_click	os	varchar	32	√		null
ox_data_raw_ad_impression	os	varchar	32	√		null
ox_data_raw_ad_request	os	varchar	32	√		null
ox_data_raw_tracker_impression	os	varchar	32	√		null
ox_banners	outgoing_filename	varchar	255	√		null
ox_ext_market_setting	owner_id	mediumint	7
ox_ext_market_setting	owner_type_id	mediumint	7
ox_ext_market_web_stats	p_website_id	char	36
ox_data_raw_ad_click	page	varchar	255	√		null
ox_data_raw_ad_impression	page	varchar	255	√		null
ox_data_raw_ad_request	page	varchar	255	√		null
ox_data_raw_tracker_impression	page	varchar	255	√		null
ox_affiliates_extra	page_rank	int	10	√		null
ox_banners	parameters	text	65535	√		null
ox_audit	parentid	mediumint	7	√		null
ox_users	password	varchar	64	√		null
ox_data_summary_ad_zone_assoc	past_zone_traffic_fraction	double	22	√		null
ox_tracker_append	paused	enum	2			f
ox_affiliates_extra	payee_name	varchar	255	√		null
ox_account_user_permission_assoc	permission_id	mediumint	7
ox_affiliates_extra	phone	varchar	64	√		null
ox_placement_zone_assoc	placement_zone_assoc_id	mediumint	7		√
ox_banners	pluginversion	mediumint	7			0
ox_affiliates_extra	postcode	varchar	64	√		null
ox_preferences	preference_id	mediumint	7		√		ox_account_preference_assoc.preference_id Defined in XML
ox_preferences	preference_name	varchar	64
ox_zones	prepend	text	65535
ox_zones	pricing	varchar	50			CPM
ox_ad_zone_assoc	priority	double	22	√		0
ox_campaigns	priority	int	10			0
ox_data_summary_ad_zone_assoc	priority	double	22
ox_ad_zone_assoc	priority_factor	double	22	√		0
ox_data_summary_ad_zone_assoc	priority_factor	double	22	√		null
ox_data_summary_ad_zone_assoc	priority_factor_limited	smallint	5			0
ox_variables	purpose	enum	13	√		null
ox_data_raw_ad_click	query	varchar	255	√		null
ox_data_raw_ad_impression	query	varchar	255	√		null
ox_data_raw_ad_request	query	varchar	255	√		null
ox_data_raw_tracker_impression	query	varchar	255	√		null
ox_tracker_append	rank	int	10			0
ox_zones	rate	decimal	19,2	√		null
ox_password_recovery	recovery_id	varchar	64
ox_data_raw_ad_click	referer	varchar	255	√		null
ox_data_raw_ad_impression	referer	varchar	255	√		null
ox_data_raw_ad_request	referer	varchar	255	√		null
ox_data_raw_tracker_impression	referer	varchar	255	√		null
ox_variables	reject_if_empty	smallint unsigned	5			0
ox_clients	report	enum	2			t
ox_clients	reportdeactivate	enum	2			t
ox_clients	reportinterval	mediumint	7			7
ox_clients	reportlastdate	date	0			0000-00-00
ox_data_summary_ad_zone_assoc	requested_impressions	int unsigned	10
ox_data_intermediate_ad	requests	int unsigned	10			0
ox_data_summary_ad_hourly	requests	int unsigned	10			0
ox_data_summary_ad_zone_assoc	required_impressions	int unsigned	10
ox_campaigns	revenue	decimal	10,4	√		null
ox_ext_market_web_stats	revenue	decimal	17,5	√		null
ox_campaigns	revenue_type	smallint	5	√		null
ox_log_maintenance_priority	run_type	tinyint unsigned	3
ox_database_action	schema_name	varchar	64	√		null
ox_log_maintenance_statistics	search_run_type	int	10	√		null
ox_data_raw_ad_click	search_term	varchar	255	√		null
ox_data_raw_ad_impression	search_term	varchar	255	√		null
ox_data_raw_ad_request	search_term	varchar	255	√		null
ox_data_raw_tracker_impression	search_term	varchar	255	√		null
ox_banners	seq	tinyint	3			0
ox_data_bkt_a	server_conv_id	bigint	19		√
ox_data_bkt_a_var	server_conv_id	bigint	19		√
ox_data_bkt_a	server_ip	varchar	16
ox_data_bkt_a_var	server_ip	varchar	16
ox_data_intermediate_ad_connection	server_raw_ip	varchar	16
ox_data_raw_tracker_impression	server_raw_ip	varchar	16
ox_data_raw_tracker_variable_value	server_raw_ip	varchar	16
ox_data_intermediate_ad_connection	server_raw_tracker_impression_id	bigint	19
ox_data_raw_tracker_impression	server_raw_tracker_impression_id	bigint	19		√		ox_data_raw_tracker_variable_value.server_raw_tracker_impression_id Defined in XML
ox_banners	session_capping	int	10			0
ox_campaigns	session_capping	int	10			0
ox_zones	session_capping	int	10			0
ox_session	sessiondata	text	65535
ox_session	sessionid	varchar	32
ox_users	sso_user_id	int	10	√		null
ox_log_maintenance_forecasting	start_run	datetime	0
ox_log_maintenance_priority	start_run	datetime	0
ox_log_maintenance_statistics	start_run	datetime	0
ox_banners	status	int	10			0
ox_campaigns	status	int	10			0
ox_campaigns_trackers	status	smallint unsigned	5			4
ox_data_bkt_a	status	int	10	√		null
ox_ext_market_assoc_data	status	tinyint	3			0
ox_trackers	status	smallint unsigned	5			4
ox_banners	statustext	varchar	255
ox_banners	storagetype	enum	7			sql
ox_images	t_stamp	datetime	0	√		null
ox_database_action	table_backup_schema	text	65535	√		null
ox_database_action	tablename	varchar	64	√		null
ox_database_action	tablename_backup	varchar	64	√		null
ox_tracker_append	tagcode	text	65535
ox_banners	target	varchar	16
ox_targetstats	target	int	10			0
ox_campaigns	target_click	int	10			0
ox_campaigns	target_conversion	int	10			0
ox_campaigns	target_impression	int	10			0
ox_affiliates_extra	tax_id	varchar	64	√		null
ox_zones	technology_cost	decimal	10,4	√		null
ox_zones	technology_cost_type	smallint	5	√		null
ox_userlog	timestamp	int	10			0
ox_database_action	timing	int	10
ox_ad_zone_assoc	to_be_delivered	bit	0			1
ox_data_summary_ad_zone_assoc	to_be_delivered	bit	0			1
ox_data_intermediate_ad	total_basket_value	decimal	10,4			0.0000
ox_data_summary_ad_hourly	total_basket_value	decimal	10,4	√		null
ox_data_summary_ad_hourly	total_cost	decimal	10,4	√		null
ox_data_intermediate_ad	total_num_items	int	10			0
ox_data_summary_ad_hourly	total_num_items	int	10	√		null
ox_data_summary_ad_hourly	total_revenue	decimal	10,4	√		null
ox_data_summary_ad_hourly	total_techcost	decimal	10,4	√		null
ox_tracker_append	tracker_append_id	int	10		√
ox_data_intermediate_ad_connection	tracker_browser	varchar	32	√		null
ox_data_intermediate_ad_connection	tracker_channel	varchar	255	√		null
ox_data_intermediate_ad_connection	tracker_channel_ids	varchar	64	√		null
ox_data_intermediate_ad_connection	tracker_country	char	2	√		null
ox_data_intermediate_ad_connection	tracker_date_time	datetime	0
ox_data_intermediate_ad_connection	tracker_domain	varchar	255	√		null
ox_data_intermediate_ad_connection	tracker_host_name	varchar	255	√		null
ox_data_intermediate_ad_connection	tracker_https	int unsigned	10	√		null
ox_data_raw_tracker_impression	tracker_id	int unsigned	10
ox_data_intermediate_ad_connection	tracker_ip_address	varchar	16	√		null
ox_data_intermediate_ad_connection	tracker_language	varchar	13	√		null
ox_data_intermediate_ad_connection	tracker_os	varchar	32	√		null
ox_data_intermediate_ad_connection	tracker_page	varchar	255	√		null
ox_data_intermediate_ad_connection	tracker_query	varchar	255	√		null
ox_data_intermediate_ad_connection	tracker_referer	varchar	255	√		null
ox_log_maintenance_statistics	tracker_run_type	int	10	√		null
ox_data_intermediate_ad_connection	tracker_search_term	varchar	255	√		null
ox_data_intermediate_ad_connection	tracker_user_agent	varchar	255	√		null
ox_trackers	trackerid	mediumint	7		√		ox_campaigns_trackers.trackerid Defined in XML ox_data_bkt_a.tracker_id Defined in XML ox_data_intermediate_ad_connection.tracker_id Defined in XML ox_tracker_append.tracker_id Defined in XML ox_variables.trackerid Defined in XML
ox_trackers	trackername	varchar	255
ox_banners	transparent	bit	0			0
ox_acls	type	varchar	255
ox_acls_channel	type	varchar	255
ox_trackers	type	smallint unsigned	5			1
ox_affiliates_extra	unique_users	int	10	√		null
ox_affiliates_extra	unique_views	int	10	√		null
ox_variables	unique_window	int	10			0
ox_affiliates	updated	datetime	0
ox_agency	updated	datetime	0
ox_audit	updated	datetime	0	√		null
ox_banners	updated	datetime	0
ox_campaigns	updated	datetime	0
ox_channel	updated	datetime	0
ox_clients	updated	datetime	0
ox_data_intermediate_ad	updated	datetime	0
ox_data_intermediate_ad_connection	updated	datetime	0
ox_data_summary_ad_hourly	updated	datetime	0
ox_database_action	updated	datetime	0	√		null
ox_password_recovery	updated	datetime	0
ox_trackers	updated	datetime	0
ox_upgrade_action	updated	datetime	0	√		null
ox_variables	updated	datetime	0
ox_zones	updated	datetime	0
ox_log_maintenance_forecasting	updated_to	datetime	0	√		null
ox_log_maintenance_priority	updated_to	datetime	0	√		null
ox_log_maintenance_statistics	updated_to	datetime	0	√		null
ox_database_action	upgrade_action_id	int unsigned	10	√		0	ox_upgrade_action.upgrade_action_id Defined in XML
ox_upgrade_action	upgrade_name	varchar	128	√		null
ox_banners	url	text	65535
ox_data_raw_ad_click	user_agent	varchar	255	√		null
ox_data_raw_ad_impression	user_agent	varchar	255	√		null
ox_data_raw_ad_request	user_agent	varchar	255	√		null
ox_data_raw_tracker_impression	user_agent	varchar	255	√		null
ox_users	user_id	mediumint	7		√		ox_account_user_assoc.user_id Defined in XML ox_account_user_permission_assoc.user_id Defined in XML ox_password_recovery.user_id Defined in XML ox_userlog.userid Defined in XML
ox_password_recovery	user_type	varchar	64
ox_audit	userid	mediumint	7			0
ox_userlog	userlogid	mediumint	7		√
ox_audit	username	varchar	64	√		null
ox_users	username	varchar	64	√		null
ox_audit	usertype	tinyint	3			0
ox_userlog	usertype	tinyint	3			0
ox_account_preference_assoc	value	text	65535
ox_application_variable	value	text	65535
ox_data_bkt_a_var	value	text	65535	√		null
ox_data_intermediate_ad_variable_value	value	varchar	50	√		null
ox_data_raw_tracker_variable_value	value	varchar	50	√		null
ox_ext_market_general_pref	value	text	65535
ox_variables	variablecode	varchar	255
ox_variables	variableid	mediumint unsigned	8		√		ox_data_bkt_a_var.tracker_variable_id Defined in XML ox_data_intermediate_ad_variable_value.tracker_variable_id Defined in XML ox_data_raw_tracker_variable_value.tracker_variable_id Defined in XML ox_variable_publisher.variable_id Defined in XML
ox_trackers	variablemethod	enum	8			default
ox_banners	vast_delivery	smallint	5	√		null
ox_database_action	version	int	10
ox_upgrade_action	version_from	varchar	64	√		null
ox_upgrade_action	version_to	varchar	64
ox_data_intermediate_ad_connection	viewer_id	varchar	32	√		null
ox_data_raw_ad_click	viewer_id	varchar	32	√		null
ox_data_raw_ad_impression	viewer_id	varchar	32	√		null
ox_data_raw_ad_request	viewer_id	varchar	32	√		null
ox_data_raw_tracker_impression	viewer_id	varchar	32
ox_data_intermediate_ad_connection	viewer_session_id	varchar	32	√		null
ox_data_raw_ad_click	viewer_session_id	varchar	32	√		null
ox_data_raw_ad_impression	viewer_session_id	varchar	32	√		null
ox_data_raw_ad_request	viewer_session_id	varchar	32	√		null
ox_data_raw_tracker_impression	viewer_session_id	varchar	32	√		null
ox_campaigns	views	int	10	√		-1
ox_targetstats	views	int	10			0
ox_campaigns	viewwindow	mediumint	7			0
ox_trackers	viewwindow	mediumint	7			0
ox_variable_publisher	visible	bit	0
ox_affiliates	website	varchar	255	√		null
ox_ext_market_website_pref	website_id	char	36
ox_banners	weight	tinyint	3			1
ox_campaigns	weight	tinyint	3			1
ox_zones	what	text	65535
ox_banners	width	smallint	5			0
ox_ext_market_web_stats	width	smallint	5	√		null
ox_zones	width	smallint	5			0
ox_data_bkt_a	window	int	10	√		null
ox_data_intermediate_ad_connection	zone_id	int unsigned	10
ox_zones	zoneid	mediumint	7		√		ox_ad_zone_assoc.zone_id Defined in XML ox_data_bkt_a.zone_id Defined in XML ox_data_bkt_c.zone_id Defined in XML ox_data_bkt_m.zone_id Defined in XML ox_data_bkt_r.zone_id Defined in XML ox_data_intermediate_ad.zone_id Defined in XML ox_data_raw_ad_click.zone_id Defined in XML ox_data_raw_ad_impression.zone_id Defined in XML ox_data_raw_ad_request.zone_id Defined in XML ox_data_summary_ad_hourly.zone_id Defined in XML ox_data_summary_ad_zone_assoc.zone_id Defined in XML ox_data_summary_channel_daily.zone_id Defined in XML ox_data_summary_zone_impression_history.zone_id Defined in XML ox_placement_zone_assoc.zone_id Defined in XML
ox_zones	zonename	varchar	245
ox_zones	zonetype	smallint	5			0
ox_account_preference_assoc	account_id	mediumint	7					ox_accounts.account_id Defined in XML
ox_account_user_assoc	account_id	mediumint	7					ox_accounts.account_id Defined in XML
ox_account_user_permission_assoc	account_id	mediumint	7					ox_accounts.account_id Defined in XML
ox_affiliates	account_id	mediumint	7	√		null	ox_ext_market_assoc_data.publisher_account_id Defined in XML	ox_accounts.account_id Defined in XML
ox_audit	account_id	mediumint	7					ox_accounts.account_id Defined in XML
ox_clients	account_id	mediumint	7	√		null		ox_accounts.account_id Defined in XML
ox_ext_market_assoc_data	account_id	mediumint	7				ox_agency.account_id Implied Constraint	ox_accounts.account_id Defined in XML
ox_audit	advertiser_account_id	mediumint	7	√		null		ox_accounts.account_id Defined in XML
ox_users	default_account_id	mediumint	7	√		null		ox_accounts.account_id Defined in XML
ox_audit	website_account_id	mediumint	7	√		null		ox_accounts.account_id Defined in XML
ox_affiliates_extra	affiliateid	mediumint	7				ox_channel.affiliateid Implied Constraint	ox_affiliates.affiliateid Defined in XML
ox_ext_market_website_pref	affiliateid	mediumint	7			0		ox_affiliates.affiliateid Defined in XML
ox_zones	affiliateid	mediumint	7	√		null		ox_affiliates.affiliateid Defined in XML
ox_ext_market_assoc_data	publisher_account_id	varchar	36					ox_affiliates.account_id Defined in XML
ox_variable_publisher	publisher_id	int	10					ox_affiliates.affiliateid Defined in XML
ox_affiliates	agencyid	mediumint	7			0		ox_agency.agencyid Defined in XML
ox_clients	agencyid	mediumint	7			0		ox_agency.agencyid Defined in XML
ox_ad_category_assoc	ad_id	int unsigned	10					ox_banners.bannerid Defined in XML
ox_ad_zone_assoc	ad_id	mediumint	7	√		null		ox_banners.bannerid Defined in XML
ox_data_intermediate_ad	ad_id	int unsigned	10					ox_banners.bannerid Defined in XML
ox_data_raw_ad_click	ad_id	int unsigned	10					ox_banners.bannerid Defined in XML
ox_data_raw_ad_impression	ad_id	int unsigned	10					ox_banners.bannerid Defined in XML
ox_data_raw_ad_request	ad_id	int unsigned	10					ox_banners.bannerid Defined in XML
ox_data_summary_ad_hourly	ad_id	int unsigned	10					ox_banners.bannerid Defined in XML
ox_data_summary_ad_zone_assoc	ad_id	int unsigned	10					ox_banners.bannerid Defined in XML
ox_acls	bannerid	mediumint	7			0		ox_banners.bannerid Defined in XML
ox_data_bkt_a	creative_id	mediumint	7					ox_banners.bannerid Defined in XML
ox_data_bkt_c	creative_id	mediumint	7					ox_banners.bannerid Defined in XML
ox_data_bkt_m	creative_id	mediumint	7					ox_banners.bannerid Defined in XML
ox_data_bkt_r	creative_id	mediumint	7					ox_banners.bannerid Defined in XML
ox_campaigns_trackers	campaignid	mediumint	7			0		ox_campaigns.campaignid Defined in XML
ox_ext_market_campaign_pref	campaignid	mediumint	7			0		ox_campaigns.campaignid Defined in XML
ox_targetstats	campaignid	mediumint	7			0		ox_campaigns.campaignid Defined in XML
ox_placement_zone_assoc	placement_id	mediumint	7	√		null		ox_campaigns.campaignid Defined in XML
ox_ad_category_assoc	category_id	int unsigned	10					ox_category.category_id Defined in XML
ox_data_summary_channel_daily	channel_id	int unsigned	10					ox_channel.channelid Defined in XML
ox_acls_channel	channelid	mediumint	7			0		ox_channel.channelid Defined in XML
ox_data_intermediate_ad_variable_value	data_intermediate_ad_connection_id	bigint	19					ox_data_intermediate_ad_connection.data_intermediate_ad_connection_id Defined in XML
ox_data_raw_tracker_variable_value	server_raw_tracker_impression_id	bigint	19					ox_data_raw_tracker_impression.server_raw_tracker_impression_id Defined in XML
ox_upgrade_action	upgrade_action_id	int unsigned	10		√			ox_database_action.upgrade_action_id Defined in XML
ox_account_preference_assoc	preference_id	mediumint	7					ox_preferences.preference_id Defined in XML
ox_data_bkt_a	tracker_id	mediumint	7					ox_trackers.trackerid Defined in XML
ox_data_intermediate_ad_connection	tracker_id	int unsigned	10					ox_trackers.trackerid Defined in XML
ox_tracker_append	tracker_id	mediumint	7			0		ox_trackers.trackerid Defined in XML
ox_campaigns_trackers	trackerid	mediumint	7			0		ox_trackers.trackerid Defined in XML
ox_variables	trackerid	mediumint	7			0		ox_trackers.trackerid Defined in XML
ox_account_user_assoc	user_id	mediumint	7					ox_users.user_id Defined in XML
ox_account_user_permission_assoc	user_id	mediumint	7					ox_users.user_id Defined in XML
ox_password_recovery	user_id	int	10					ox_users.user_id Defined in XML
ox_userlog	userid	mediumint	7			0		ox_users.user_id Defined in XML
ox_data_bkt_a_var	tracker_variable_id	mediumint	7					ox_variables.variableid Defined in XML
ox_data_intermediate_ad_variable_value	tracker_variable_id	int	10					ox_variables.variableid Defined in XML
ox_data_raw_tracker_variable_value	tracker_variable_id	int	10					ox_variables.variableid Defined in XML
ox_variable_publisher	variable_id	int	10					ox_variables.variableid Defined in XML
ox_ad_zone_assoc	zone_id	mediumint	7	√		null		ox_zones.zoneid Defined in XML
ox_data_bkt_a	zone_id	mediumint	7					ox_zones.zoneid Defined in XML
ox_data_bkt_c	zone_id	mediumint	7					ox_zones.zoneid Defined in XML
ox_data_bkt_m	zone_id	mediumint	7					ox_zones.zoneid Defined in XML
ox_data_bkt_r	zone_id	mediumint	7					ox_zones.zoneid Defined in XML
ox_data_intermediate_ad	zone_id	int unsigned	10					ox_zones.zoneid Defined in XML
ox_data_raw_ad_click	zone_id	int unsigned	10					ox_zones.zoneid Defined in XML
ox_data_raw_ad_impression	zone_id	int unsigned	10					ox_zones.zoneid Defined in XML
ox_data_raw_ad_request	zone_id	int unsigned	10					ox_zones.zoneid Defined in XML
ox_data_summary_ad_hourly	zone_id	int unsigned	10					ox_zones.zoneid Defined in XML
ox_data_summary_ad_zone_assoc	zone_id	int unsigned	10					ox_zones.zoneid Defined in XML
ox_data_summary_channel_daily	zone_id	int unsigned	10					ox_zones.zoneid Defined in XML
ox_data_summary_zone_impression_history	zone_id	int unsigned	10					ox_zones.zoneid Defined in XML
ox_placement_zone_assoc	zone_id	mediumint	7	√		null		ox_zones.zoneid Defined in XML