SchemaSpy Analysis of schema_generation - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Jun 18 16:54 CDT 2007
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
schema_generation contains 1003 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
OSC_link events_calendar varchar 255  √  null
account_name orders varchar 32  √  null
account_number orders varchar 20  √  null
address_city paypal varchar 32  √  null
address_country paypal varchar 64  √  null
address_name paypal varchar 32  √  null
address_state paypal varchar 32  √  null
address_status paypal varchar 11  √  null
address_street paypal varchar 64  √  null
address_zip paypal varchar 10  √  null
admin_created admin datetime 19  √  null
admin_groups_id admin int 11  √  null
admin_groups.admin_groups_id admin_ibfk_1
admin_groups_name admin_groups varchar 64  √  null
admin_lastname admin varchar 32  √  null
admin_logdate admin datetime 19  √  null
affiliate_banners_html_text affiliate_banners text 65535  √  null
affiliate_browser orders_session_info varchar 100  √ 
affiliate_category_id affiliate_banners int 11  √  null
categories.categories_id affiliate_banners_ibfk_2
affiliate_clickthroughs_id orders_session_info int 11  √  0
affiliate_clientbrowser affiliate_clickthroughs varchar 200  √  Could Not Find This Data
affiliate_clientip affiliate_clickthroughs varchar 50  √  Could Not Find This Data
affiliate_clientreferer affiliate_clickthroughs varchar 200  √  None Detected (Perhaps a direct link)
affiliate_date orders_session_info datetime 19  √  null
affiliate_date_scheduled affiliate_banners datetime 19  √  null
affiliate_date_status_change affiliate_banners datetime 19  √  null
affiliate_expires_date affiliate_banners datetime 19  √  null
affiliate_expires_impressions affiliate_banners int 7  √  0
affiliate_id orders_session_info int 11  √  0
affiliate_affiliate.affiliate_id Implied Constraint
affiliate_ipaddress orders_session_info varchar 20  √ 
affiliate_notified affiliate_payment_status_history int 1  √  0
affiliate_old_value affiliate_payment_status_history int 5  √  null
affiliate_products_id affiliate_banners int 11  √  null
products.products_id affiliate_banners_ibfk_1
affiliate_products_id affiliate_clickthroughs int 11  √  0
products.products_id affiliate_clickthroughs_ibfk_2
approved article_reviews tinyint unsigned 3  √  0
articles_date_available articles datetime 19  √  null
articles_description articles_description text 65535  √  null
articles_head_desc_tag articles_description text 65535  √  null
articles_head_keywords_tag articles_description text 65535  √  null
articles_head_title_tag articles_description varchar 80  √  null
articles_last_modified articles datetime 19  √  null
articles_url articles_description varchar 255  √  null
articles_viewed articles_description int 5  √  0
authors_description authors_info text 65535  √  null
authors_id articles int 11  √  null
authors.authors_id articles_ibfk_1
authors_image authors varchar 64  √  null
bank_name algozone_fraud_queries varchar 20  √ 
bank_phone algozone_fraud_queries varchar 15  √ 
banners_html_text banners text 65535  √  null
billing_company orders varchar 32  √  null
billing_state orders varchar 32  √  null
billing_suburb orders varchar 32  √  null
bin_country_code algozone_fraud_queries varchar 5  √ 
cat_tree data_cat varchar 254  √  null
categories_date_added faq_categories datetime 19  √  null
categories_date_added pages_categories datetime 19  √  null
categories_description categories_description text 65535  √  null
categories_description faq_categories_description text 65535  √  null
categories_description pages_categories_description text 65535  √  null
categories_head_title_tag categories_description varchar 80  √  null
categories_heading_title categories_description varchar 64  √  null
categories_htc_desc_tag categories_description longtext 2147483647  √  null
categories_htc_description categories_description longtext 2147483647  √  null
categories_htc_keywords_tag categories_description longtext 2147483647  √  null
categories_htc_title_tag categories_description varchar 80  √  null
categories_image categories varchar 64  √  null
categories_image faq_categories varchar 64  √  null
categories_image pages_categories varchar 64  √  null
categories_last_modified faq_categories datetime 19  √  null
categories_last_modified pages_categories datetime 19  √  null
categories_sort_order faq_categories int 3  √  null
categories_sort_order pages_categories int 3  √  null
cc_ccv orders varchar 90  √  null
cc_expires orders varchar 90  √  null
cc_issue orders char 3  √  null
cc_number orders varchar 90  √  null
cc_owner orders varchar 64  √  null
cc_start orders varchar 4  √  null
cc_type orders varchar 20  √  null
comments orders_status_history text 65535  √  null
counter counter int 12  √  null
counter counter_history int 12  √  null
country_code algozone_fraud_queries varchar 21  √ 
coupon_description coupons_description text 65535  √  null
currency orders char 3  √  null
currency_value orders decimal 14,6  √  null
currency_value orders_session_info float 13,8  √  null
customer_id whos_online int 11  √  null
customer_notified orders_status_history int 1  √  0
customers_basket_date_added customers_basket varchar 8  √  null
customers_company orders varchar 32  √  null
customers_fax customers varchar 32  √  null
customers_group_id specials_retail_prices smallint 6  √  null
customers_id article_reviews int 11  √  null
customers.customers_id Implied Constraint
customers_id reviews int 11  √  null
customers.customers_id Implied Constraint
customers_info_date_account_created customers_info datetime 19  √  null
customers_info_date_account_last_modified customers_info datetime 19  √  null
customers_info_date_of_last_logon customers_info datetime 19  √  null
customers_info_number_of_logons customers_info int 5  √  null
customers_newsletter customers char 1  √  null
customers_selected_template customers varchar 20  √  null
customers_state orders varchar 32  √  null
customers_suburb orders varchar 32  √  null
data_convert_cur data_files varchar 5  √  false
data_cur data_files char 3  √  USD
data_files_service data_files varchar 10  √  froogle
data_ftp_directory data_files varchar 64  √  null
data_ftp_server data_files varchar 32  √  hedwig.google.com
data_ftp_user_name data_files varchar 32  √  null
data_ftp_user_pass data_files varchar 32  √  null
data_image_url data_files varchar 64  √  null
data_lang_char data_files char 2  √  en
data_product_url data_files varchar 64  √  null
data_tax_class_id data_files int 11  √  null
tax_class.tax_class_id data_files_ibfk_1
date_added article_reviews datetime 19  √  null
date_added authors datetime 19  √  null
date_added card_blacklist datetime 19  √  null
date_added categories datetime 19  √  null
date_added email_subjects datetime 19  √  null
date_added manufacturers datetime 19  √  null
date_added paypal datetime 19  √  null
date_added reviews datetime 19  √  null
date_added template datetime 19  √  null
date_added topics datetime 19  √  null
date_last_click authors_info datetime 19  √  null
date_last_click manufacturers_info datetime 19  √  null
date_purchased orders datetime 19  √  null
date_scheduled banners datetime 19  √  null
date_sent affiliate_newsletters datetime 19  √  null
date_sent newsletters datetime 19  √  null
date_status_change banners datetime 19  √  null
date_status_change featured datetime 19  √  null
date_status_change specials datetime 19  √  null
decimal_places currencies char 1  √  null
decimal_point currencies char 1  √  null
delivery_company orders varchar 32  √  null
delivery_state orders varchar 32  √  null
delivery_suburb orders varchar 32  √  null
description events_calendar text 65535  √  null
directory languages varchar 32  √  null
distance_k algozone_fraud_queries varchar 10  √ 
distance_m algozone_fraud_queries varchar 10  √ 
dt visual_verify_code timestamp 19  √  CURRENT_TIMESTAMP
email_subjects_category email_subjects int 1  √  null
emailed_to coupon_email_track varchar 32  √  null
end_date events_calendar varchar 20  √  null
entry_company address_book varchar 32  √  null
entry_company_tax_id address_book varchar 32  √  null
entry_state address_book varchar 32  √  null
entry_suburb address_book varchar 32  √  null
err_message algozone_fraud_queries varchar 150  √ 
event_image events_calendar varchar 64  √  null
exchange_rate paypal decimal 4,2  √  null
expires_date banners datetime 19  √  null
expires_date featured datetime 19  √  null
expires_date specials datetime 19  √  null
expires_impressions banners int 7  √  0
featured_date_added featured datetime 19  √  null
featured_last_modified featured datetime 19  √  null
fraud_level algozone_fraud_queries varchar 5  √ 
geo_zone_id zones_to_geo_zones int 11  √  null
geo_zones.geo_zone_id zones_to_geo_zones_ibfk_3
global_product_notifications customers_info int 1  √  0
image languages varchar 64  √  null
invoice paypal varchar 64  √  null
ip_city algozone_fraud_queries varchar 21  √ 
ip_isp algozone_fraud_queries varchar 30  √ 
ip_latitude algozone_fraud_queries varchar 21  √ 
ip_longitude algozone_fraud_queries varchar 21  √ 
ip_org algozone_fraud_queries varchar 30  √ 
ip_region algozone_fraud_queries varchar 21  √ 
is_anonymous_proxy algozone_fraud_queries char 3  √ 
is_bank_name_match algozone_fraud_queries varchar 5  √ 
is_bank_phone_match algozone_fraud_queries varchar 5  √ 
is_bin_match algozone_fraud_queries varchar 5  √ 
is_country_match algozone_fraud_queries char 3  √ 
is_customer_phone_inloc algozone_fraud_queries char 3  √ 
is_free_email algozone_fraud_queries char 3  √ 
is_high_risk_country algozone_fraud_queries varchar 5  √ 
languages_in_header template char 3  √  no
last_date_queried algozone_fraud_queries datetime 19  √  0000-00-00 00:00:00
last_modified article_reviews datetime 19  √  null
last_modified authors datetime 19  √  null
last_modified card_blacklist datetime 19  √  null
last_modified categories datetime 19  √  null
last_modified configuration datetime 19  √  null
last_modified email_subjects datetime 19  √  null
last_modified geo_zones datetime 19  √  null
last_modified infobox_configuration datetime 19  √  null
last_modified manufacturers datetime 19  √  null
last_modified orders datetime 19  √  null
last_modified paypal datetime 19  √  null
last_modified reviews datetime 19  √  null
last_modified tax_class datetime 19  √  null
last_modified tax_rates datetime 19  √  null
last_modified template datetime 19  √  null
last_modified topics datetime 19  √  null
last_modified zones_to_geo_zones datetime 19  √  null
last_updated currencies datetime 19  √  null
link events_calendar varchar 255  √  null
link_categories_date_added link_categories datetime 19  √  null
link_categories_description link_categories_description text 65535  √  null
link_categories_image link_categories varchar 64  √  null
link_categories_last_modified link_categories datetime 19  √  null
link_categories_sort_order link_categories int 3  √  null
links_contact_email links varchar 96  √  null
links_contact_name links varchar 64  √  null
links_description links_description text 65535  √  null
links_image_url links varchar 255  √  null
links_last_modified links datetime 19  √  null
links_reciprocal_url links varchar 255  √  null
links_url links varchar 255  √  null
locked affiliate_newsletters int 1  √  0
locked newsletters int 1  √  0
manufacturers_id products int 11  √  null
manufacturers.manufacturers_id products_ibfk_1
manufacturers_image manufacturers varchar 64  √  null
memo paypal text 65535  √  null
month counter_history char 8  √  null
nmc_date_added navmenu_categories datetime 19  √  null
nmc_sort_order navmenu_categories int 3  √  null
nml_sort_order navmenu_links int 3  √  null
options_date_added products_options datetime 19  √  null
options_last_modified products_options datetime 19  √  null
orders_date_finished orders datetime 19  √  null
pages_blurb pages_description text 65535  √  null
pages_body pages_description text 65535  √  null
pages_date_added pages timestamp 19  √  CURRENT_TIMESTAMP
pages_date_modified pages timestamp 19  √  0000-00-00 00:00:00
pages_image pages varchar 64  √  null
pages_meta_description pages_description varchar 255  √  null
pages_meta_keywords pages_description varchar 255  √  null
pages_meta_title pages_description varchar 80  √  null
parent_txn_id paypal varchar 17  √  null
payer_business_name paypal varchar 64  √  null
payment_currency_val orders_session_info float 13,8  √  null
payment_date paypal datetime 19  √  null
payment_fee paypal decimal 7,2  √  null
payment_gross paypal decimal 7,2  √  null
payment_info orders text 65535  √  null
pending_reason paypal varchar 14  √  null
pending_reason paypal_payment_status_history varchar 14  √  null
po_number orders varchar 12  √  null
products_attributes_maxcount products_attributes_download int 2  √  0
products_attributes_maxdays products_attributes_download int 2  √  0
products_date_available products datetime 19  √  null
products_description products_description text 65535  √  null
products_extra_fields_value products_to_products_extra_fields varchar 64  √  null
products_head_title_tag products_description varchar 80  √  null
products_image products varchar 64  √  null
products_image_lrg products varchar 64  √  null
products_image_med products varchar 64  √  null
products_image_sm_1 products varchar 64  √  null
products_image_sm_2 products varchar 64  √  null
products_image_sm_3 products varchar 64  √  null
products_image_sm_4 products varchar 64  √  null
products_image_sm_5 products varchar 64  √  null
products_image_sm_6 products varchar 64  √  null
products_image_xl_1 products varchar 64  √  null
products_image_xl_2 products varchar 64  √  null
products_image_xl_3 products varchar 64  √  null
products_image_xl_4 products varchar 64  √  null
products_image_xl_5 products varchar 64  √  null
products_image_xl_6 products varchar 64  √  null
products_last_modified products datetime 19  √  null
products_model customers_wishlist varchar 13  √  null
products_model orders_products varchar 12  √  null
products_model products varchar 25  √  null
products_options_instruct products_options_text varchar 64  √  null
products_tax_class_id products int 11  √  null
tax_class.tax_class_id products_ibfk_2
products_url products_description varchar 255  √  null
products_viewed products_description int 5  √  0
proxy_level algozone_fraud_queries varchar 5  √ 
reason_code paypal varchar 15  √  null
reason_code paypal_payment_status_history varchar 15  √  null
restrict_to_categories coupons varchar 255  √  null
restrict_to_customers coupons text 65535  √  null
restrict_to_products coupons varchar 255  √  null
reviews_rating article_reviews int 1  √  null
reviews_rating reviews int 1  √  null
sale_categories_all salemaker_sales varchar 255  √  null
sale_categories_selected salemaker_sales varchar 255  √  null
sent_firstname coupon_email_track varchar 32  √  null
sent_lastname coupon_email_track varchar 32  √  null
set_function configuration varchar 255  √  null
settle_amount paypal decimal 7,2  √  null
settle_currency paypal char 3  √  null
side_box_left_width template int 10  √  1
side_box_right_width template int 10  √  1
sort_order categories int 3  √  null
sort_order configuration int 5  √  null
sort_order configuration_group int 5  √  nul