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
address_format address_format varchar 128
address_summary address_format varchar 48
admin_email_address admin varchar 96
admin_files_name admin_files varchar 64
admin_firstname admin varchar 32
admin_password admin varchar 40
affiliate_banners_group affiliate_banners varchar 10
affiliate_banners_image affiliate_banners varchar 64
affiliate_banners_title affiliate_banners varchar 64
affiliate_browser affiliate_sales varchar 100
affiliate_browser orders_session_info varchar 100  √ 
affiliate_city affiliate_affiliate varchar 32
affiliate_city affiliate_payment varchar 32
affiliate_company affiliate_affiliate varchar 60
affiliate_company affiliate_payment varchar 60
affiliate_company_taxid affiliate_affiliate varchar 64
affiliate_email_address affiliate_affiliate varchar 96
affiliate_fax affiliate_affiliate varchar 32
affiliate_firstname affiliate_affiliate varchar 32
affiliate_firstname affiliate_payment varchar 32
affiliate_gender affiliate_affiliate char 1
affiliate_homepage affiliate_affiliate varchar 96
affiliate_ipaddress affiliate_sales varchar 20
affiliate_ipaddress orders_session_info varchar 20  √ 
affiliate_lastname affiliate_affiliate varchar 32
affiliate_lastname affiliate_payment varchar 32
affiliate_news_contents affiliate_news_contents text 65535
affiliate_news_headlines affiliate_news_contents varchar 255
affiliate_password affiliate_affiliate varchar 40
affiliate_payment_bank_account_name affiliate_affiliate varchar 64
affiliate_payment_bank_account_number affiliate_affiliate varchar 64
affiliate_payment_bank_branch_number affiliate_affiliate varchar 64
affiliate_payment_bank_name affiliate_affiliate varchar 64
affiliate_payment_bank_swift_code affiliate_affiliate varchar 64
affiliate_payment_check affiliate_affiliate varchar 100
affiliate_payment_paypal affiliate_affiliate varchar 64
affiliate_payment_status_name affiliate_payment_status varchar 32
affiliate_postcode affiliate_affiliate varchar 10
affiliate_postcode affiliate_payment varchar 10
affiliate_state affiliate_affiliate varchar 32
affiliate_street_address affiliate_affiliate varchar 64
affiliate_street_address affiliate_payment varchar 64
affiliate_suburb affiliate_affiliate varchar 64
affiliate_suburb affiliate_payment varchar 64
affiliate_telephone affiliate_affiliate varchar 32
answer faq text 65535
articles_name articles_description varchar 64
auction_buyer_id paypal varchar 64
authors_name authors varchar 32
authors_url authors_info varchar 255
bank_name algozone_fraud_queries varchar 20  √ 
bank_phone algozone_fraud_queries varchar 15  √ 
banners_group banners varchar 10
banners_image banners varchar 64
banners_title banners varchar 64
banners_url banners varchar 255
billing_city orders varchar 32
billing_country orders varchar 32
billing_name orders varchar 64
billing_postcode orders varchar 10
billing_street_address orders varchar 64
bin_country_code algozone_fraud_queries varchar 5  √ 
blacklist_card_number card_blacklist varchar 20
box_heading infobox_configuration varchar 64
box_heading infobox_heading varchar 64
business paypal varchar 96
categories_head_desc_tag categories_description longtext 2147483647
categories_head_keywords_tag categories_description longtext 2147483647
categories_name categories_description varchar 32
categories_name faq_categories_description varchar 32
categories_name pages_categories_description varchar 32
cc_bank_phone orders varchar 32
class orders_total varchar 32
code currencies char 3
code languages char 2
code visual_verify_code varchar 6
configuration_description configuration varchar 255
configuration_group_description configuration_group varchar 255
configuration_group_title configuration_group varchar 64
configuration_key configuration varchar 64
configuration_title configuration varchar 64
configuration_value configuration varchar 255
content affiliate_newsletters text 65535
content newsletters text 65535
content_type orders_session_info varchar 32
countries_iso_code_2 countries char 2
countries_iso_code_3 countries char 3
countries_name countries varchar 64
country_code algozone_fraud_queries varchar 21  √ 
coupon_code coupons varchar 32
coupon_name coupons_description varchar 32
currency orders_session_info char 3
customers_city orders varchar 32
customers_country orders varchar 32
customers_email_address customers varchar 96
customers_email_address orders varchar 96
customers_email_registered customers varchar 32
customers_firstname customers varchar 32
customers_gender customers char 1
customers_group_name customers_groups varchar 32
customers_lastname customers varchar 32
customers_name article_reviews varchar 64
customers_name orders varchar 64
customers_name reviews varchar 64
customers_password customers varchar 40
customers_payment_allowed customers varchar 255
customers_postcode orders varchar 10
customers_shipment_allowed customers varchar 255
customers_street_address orders varchar 64
customers_telephone customers varchar 32
customers_telephone orders varchar 32
customers_validation_code customers varchar 48
delivery_city orders varchar 32
delivery_country orders varchar 32
delivery_name orders varchar 64
delivery_postcode orders varchar 10
delivery_street_address orders varchar 64
description information text 65535
distance_k algozone_fraud_queries varchar 10  √ 
distance_m algozone_fraud_queries varchar 10  √ 
edit_customer_greeting_personal template text 65535
edit_customer_greeting_personal_relogon template text 65535
edit_greeting_guest template text 65535
email_subjects_name email_subjects varchar 64
entry_city address_book varchar 32
entry_firstname address_book varchar 32
entry_gender address_book char 1
entry_lastname address_book varchar 32
entry_postcode address_book varchar 10
entry_street_address address_book varchar 64
err_message algozone_fraud_queries varchar 150  √ 
first_name paypal varchar 32
firstname orders_session_info varchar 32
fraud_level algozone_fraud_queries varchar 5  √ 
full_name whos_online varchar 64
geo_zone_description geo_zones varchar 255
geo_zone_name geo_zones varchar 32
group_payment_allowed customers_groups varchar 255
group_shipment_allowed customers_groups varchar 255
http_referer whos_online varchar 255
info_title information varchar 255
infobox_display infobox_configuration varchar 5
infobox_file_name infobox_configuration varchar 64
ip_address algozone_fraud_queries varchar 30
ip_address whos_online varchar 15
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  √ 
ipaddr coupon_gv_queue varchar 32
ipaddy orders varchar 15
ipisp orders varchar 15
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  √ 
language faq varchar 32
language orders_session_info varchar 32
last_name paypal varchar 32
last_page_url whos_online varchar 64
lastname orders_session_info varchar 32
link_categories_name link_categories_description varchar 32
links_status_name links_status varchar 32
links_title links_description varchar 64
manufacturers_name manufacturers varchar 32
manufacturers_url manufacturers_info varchar 255
mc_currency paypal char 3
module affiliate_newsletters varchar 255
module newsletters varchar 255
module_five template varchar 64
module_four template varchar 64
module_one template varchar 64
module_six template varchar 64
module_three template varchar 64
module_two template varchar 64
name languages varchar 32
nmc_name navmenu_categories_description varchar 32
nml_name navmenu_links_description varchar 64
nml_url navmenu_links varchar 255
order_id algozone_fraud_queries varchar 6
orders_products_filename orders_products_download varchar 255
orders_status_name orders_status varchar 32
oscsid visual_verify_code varchar 32
pages_author pages varchar 255
pages_title pages_description varchar 255
pay_method orders_pay_methods varchar 255
payer_email paypal varchar 96
payer_id paypal varchar 32
payer_status paypal varchar 10
payment orders_session_info varchar 32
payment_currency orders_session_info char 3
payment_method orders varchar 32
payment_status paypal varchar 17
payment_status paypal_payment_status_history varchar 17
payment_time_zone paypal varchar 4
payment_title orders_session_info varchar 32
payment_type paypal varchar 7
price_prefix orders_products_attributes char 1
price_prefix products_attributes char 1
products_attributes_filename products_attributes_download varchar 255
products_extra_fields_name products_extra_fields varchar 64
products_head_desc_tag products_description longtext 2147483647
products_head_keywords_tag products_description longtext 2147483647
products_id customers_basket tinytext 255
products_id customers_basket_attributes tinytext 255
products_name customers_wishlist varchar 64
products_name orders_products varchar 64
products_name products_description varchar 64
products_options orders_products_attributes varchar 32
products_options_name products_options_text varchar 32
products_options_value_text customers_basket_attributes text 65535
products_options_values orders_products_attributes varchar 32
products_options_values_name products_options_values varchar 64
proxy_level algozone_fraud_queries varchar 5  √ 
question faq text 65535
receiver_email paypal varchar 96
receiver_id paypal varchar 32
redeem_ip coupon_redeem_track varchar 32
reviews_text article_reviews_description text 65535
reviews_text reviews_description text 65535
sale_name salemaker_sales varchar 30
session_id whos_online varchar 128
sesskey sessions varchar 32
ship_method orders_ship_methods varchar 255
spam_level algozone_fraud_queries varchar 5  √ 
tax_class_description tax_class varchar 255
tax_class_title tax_class varchar 32
tax_description tax_rates varchar 255
text orders_total varchar 255
time_entry whos_online varchar 14
time_last_click whos_online varchar 14
title affiliate_newsletters varchar 255
title currencies varchar 32
title newsletters varchar 255
title orders_total varchar 255
topics_name topics_description varchar 32
txn_id paypal varchar 17
txn_signature orders_session_info varchar 32
txn_type paypal varchar 10
user_agent whos_online varchar 255
value sessions text 65535
verify_sign paypal varchar 128
zone_code zones varchar 32
zone_name zones varchar 32
box_heading_font_color infobox_configuration varchar 10 #000000
address_format_id countries int 11 0
address_format.address_format_id countries_ibfk_1
admin_files_is_boxes admin_files tinyint 5 0
admin_files_to_boxes admin_files int 11 0
admin_lognum admin int 11 0
affiliate_address_format_id affiliate_payment int 5 0
affiliate_agb affiliate_affiliate tinyint 4 0
affiliate_banner_id affiliate_clickthroughs int 11 0
affiliate_banners_affiliate_id affiliate_banners_history int 11 0
affiliate_banners_clicks affiliate_banners_history tinyint 4 0
affiliate_banners_id affiliate_banners_history int 11 0
affiliate_banners.affiliate_banners_id Implied Constraint
affiliate_banners_products_id affiliate_banners_history int 11 0
affiliate_banners_shown affiliate_banners_history int 11 0
affiliate_billing_status affiliate_sales int 5 0
affiliate_clickthroughs_id affiliate_sales int 11 0
affiliate_clickthroughs_id orders_session_info int 11  √  0
affiliate_country affiliate_payment varchar 32 0
affiliate_country_id affiliate_affiliate int 11 0
affiliate_expires_impressions affiliate_banners int 7  √  0
affiliate_id affiliate_clickthroughs int 11 0
affiliate_affiliate.affiliate_id affiliate_clickthroughs_ibfk_1
affiliate_id affiliate_payment int 11 0
affiliate_affiliate.affiliate_id affiliate_payment_ibfk_1
affiliate_id affiliate_sales int 11 0
affiliate_affiliate.affiliate_id affiliate_sales_ibfk_1
affiliate_id orders_session_info int 11  √  0
affiliate_affiliate.affiliate_id Implied Constraint
affiliate_lft affiliate_affiliate int 11 0
affiliate_new_value affiliate_payment_status_history int 5 0
affiliate_news_id affiliate_news_contents int 11 0
affiliate_news.news_id affiliate_news_contents_ibfk_1
affiliate_news_languages_id affiliate_news_contents int 11 0
languages.languages_id affiliate_news_contents_ibfk_2
affiliate_notified affiliate_payment_status_history int 1  √  0
affiliate_number_of_logons affiliate_affiliate int 11 0
affiliate_orders_id affiliate_sales int 11 0
orders.orders_id affiliate_sales_ibfk_2
affiliate_payment_id affiliate_payment_status_history int 11 0
affiliate_payment.affiliate_payment_id affiliate_payment_status_history_ibfk_1
affiliate_payment_id affiliate_sales int 11 0
affiliate_payment.affiliate_payment_id Implied Constraint
affiliate_payment_status affiliate_payment int 5 0
affiliate_payment_status.affiliate_payment_status_id affiliate_payment_ibfk_2
affiliate_payment_status_id affiliate_payment_status int 11 0
affiliate_payment.affiliate_payment_status affiliate_payment_ibfk_2
affiliate_products_id affiliate_clickthroughs int 11  √  0
products.products_id affiliate_clickthroughs_ibfk_2
affiliate_rgt affiliate_affiliate int 11 0
affiliate_root affiliate_affiliate int 11 0
affiliate_salesman affiliate_sales int 11 0
affiliate_state affiliate_payment varchar 32 0
affiliate_zone_id affiliate_affiliate int 11 0
approved article_reviews tinyint unsigned 3  √  0
articles_id article_reviews int 11 0
articles.articles_id article_reviews_ibfk_1
articles_id articles_to_topics int 11 0
articles.articles_id articles_to_topics_ibfk_1
articles_status articles bit 1 0
articles_viewed articles_description int 5  √  0
auction_multi_item paypal tinyint 4 0
authors_id authors_info int 11 0
authors.authors_id authors_info_ibfk_1
banners_clicked banners_history int 5 0
banners_id banners_history int 11 0
banners.banners_id Implied Constraint
banners_shown banners_history int 5 0
billing_address_format_id orders int 5 0
cat_id data_cat int 11 0
categories_id categories_description int 11 0
categories