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_book_id address_book int 11  √ 
customers_id address_book int 11 0
customers.customers_id address_book_ibfk_1
entry_city address_book varchar 32
entry_company address_book varchar 32  √  null
entry_company_tax_id address_book varchar 32  √  null
entry_country_id address_book int 11 0
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_state address_book varchar 32  √  null
entry_street_address address_book varchar 64
entry_suburb address_book varchar 32  √  null
entry_zone_id address_book int 11 0
address_format address_format varchar 128
address_format_id address_format int 11  √ 
countries.address_format_id countries_ibfk_1
address_summary address_format varchar 48
admin_created admin datetime 19  √  null
admin_email_address admin varchar 96
admin_firstname admin varchar 32
admin_groups_id admin int 11  √  null
admin_groups.admin_groups_id admin_ibfk_1
admin_id admin int 11  √ 
admin_lastname admin varchar 32  √  null
admin_logdate admin datetime 19  √  null
admin_lognum admin int 11 0
admin_modified admin datetime 19 0000-00-00 00:00:00
admin_password admin varchar 40
admin_files_id admin_files int 11  √ 
admin_files_is_boxes admin_files tinyint 5 0
admin_files_name admin_files varchar 64
admin_files_to_boxes admin_files int 11 0
admin_groups_id admin_files set 5 1
admin_groups_id admin_groups int 11  √ 
admin.admin_groups_id admin_ibfk_1
admin_groups_name admin_groups varchar 64  √  null
affiliate_agb affiliate_affiliate tinyint 4 0
affiliate_city affiliate_affiliate varchar 32
affiliate_commission_percent affiliate_affiliate decimal 4,2 0.00
affiliate_company affiliate_affiliate varchar 60
affiliate_company_taxid affiliate_affiliate varchar 64
affiliate_country_id affiliate_affiliate int 11 0
affiliate_date_account_created affiliate_affiliate datetime 19 0000-00-00 00:00:00
affiliate_date_account_last_modified affiliate_affiliate datetime 19 0000-00-00 00:00:00
affiliate_date_of_last_logon affiliate_affiliate datetime 19 0000-00-00 00:00:00
affiliate_dob affiliate_affiliate datetime 19 0000-00-00 00:00:00
affiliate_email_address affiliate_affiliate varchar 96
affiliate_fax affiliate_affiliate varchar 32
affiliate_firstname affiliate_affiliate varchar 32
affiliate_gender affiliate_affiliate char 1
affiliate_homepage affiliate_affiliate varchar 96
affiliate_id affiliate_affiliate int 11  √ 
affiliate_clickthroughs.affiliate_id affiliate_clickthroughs_ibfk_1
affiliate_payment.affiliate_id affiliate_payment_ibfk_1
affiliate_sales.affiliate_id affiliate_sales_ibfk_1
orders_session_info.affiliate_id Implied Constraint
affiliate_lastname affiliate_affiliate varchar 32
affiliate_lft affiliate_affiliate int 11 0
affiliate_newsletter affiliate_affiliate char 1 1
affiliate_number_of_logons affiliate_affiliate int 11 0
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_postcode affiliate_affiliate varchar 10
affiliate_rgt affiliate_affiliate int 11 0
affiliate_root affiliate_affiliate int 11 0
affiliate_state affiliate_affiliate varchar 32
affiliate_street_address affiliate_affiliate varchar 64
affiliate_suburb affiliate_affiliate varchar 64
affiliate_telephone affiliate_affiliate varchar 32
affiliate_zone_id affiliate_affiliate int 11 0
affiliate_banners_group affiliate_banners varchar 10
affiliate_banners_html_text affiliate_banners text 65535  √  null
affiliate_banners_id affiliate_banners int 11  √ 
affiliate_banners_history.affiliate_banners_id Implied Constraint
affiliate_banners_image affiliate_banners varchar 64
affiliate_banners_title affiliate_banners varchar 64
affiliate_category_id affiliate_banners int 11  √  null
categories.categories_id affiliate_banners_ibfk_2
affiliate_date_added affiliate_banners datetime 19 0000-00-00 00:00:00
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_products_id affiliate_banners int 11  √  null
products.products_id affiliate_banners_ibfk_1
affiliate_status affiliate_banners int 1 1
affiliate_banners_affiliate_id affiliate_banners_history int 11 0
affiliate_banners_clicks affiliate_banners_history tinyint 4 0
affiliate_banners_history_date affiliate_banners_history date 10 0000-00-00
affiliate_banners_history_id affiliate_banners_history int 11  √ 
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_banner_id affiliate_clickthroughs int 11 0
affiliate_clickthrough_id affiliate_clickthroughs int 11  √ 
affiliate_clientbrowser affiliate_clickthroughs varchar 200  √  Could Not Find This Data
affiliate_clientdate affiliate_clickthroughs datetime 19 0000-00-00 00:00:00
affiliate_clientip affiliate_clickthroughs varchar 50  √  Could Not Find This Data
affiliate_clientreferer affiliate_clickthroughs varchar 200  √  None Detected (Perhaps a direct link)
affiliate_id affiliate_clickthroughs int 11 0
affiliate_affiliate.affiliate_id affiliate_clickthroughs_ibfk_1
affiliate_products_id affiliate_clickthroughs int 11  √  0
products.products_id affiliate_clickthroughs_ibfk_2
date_added affiliate_news datetime 19 0000-00-00 00:00:00
news_id affiliate_news int 11  √ 
affiliate_news_contents.affiliate_news_id affiliate_news_contents_ibfk_1
news_status affiliate_news bit 1 0
affiliate_news_contents affiliate_news_contents text 65535
affiliate_news_contents_id affiliate_news_contents int 11  √ 
affiliate_news_headlines affiliate_news_contents varchar 255
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_newsletters_id affiliate_newsletters int 11  √ 
content affiliate_newsletters text 65535
date_added affiliate_newsletters datetime 19 0000-00-00 00:00:00
date_sent affiliate_newsletters datetime 19  √  null
locked affiliate_newsletters int 1  √  0
module affiliate_newsletters varchar 255
status affiliate_newsletters int 1  √  null
title affiliate_newsletters varchar 255
affiliate_address_format_id affiliate_payment int 5 0
affiliate_city affiliate_payment varchar 32
affiliate_company affiliate_payment varchar 60
affiliate_country affiliate_payment varchar 32 0
affiliate_firstname affiliate_payment varchar 32
affiliate_id affiliate_payment int 11 0
affiliate_affiliate.affiliate_id affiliate_payment_ibfk_1
affiliate_last_modified affiliate_payment datetime 19 0000-00-00 00:00:00
affiliate_lastname affiliate_payment varchar 32
affiliate_payment affiliate_payment decimal 15,2 0.00
affiliate_payment_date affiliate_payment datetime 19 0000-00-00 00:00:00
affiliate_payment_id affiliate_payment int 11  √ 
affiliate_payment_status_history.affiliate_payment_id affiliate_payment_status_history_ibfk_1
affiliate_sales.affiliate_payment_id Implied Constraint
affiliate_payment_last_modified affiliate_payment datetime 19 0000-00-00 00:00:00
affiliate_payment_status affiliate_payment int 5 0
affiliate_payment_status.affiliate_payment_status_id affiliate_payment_ibfk_2
affiliate_payment_tax affiliate_payment decimal 15,2 0.00
affiliate_payment_total affiliate_payment decimal 15,2 0.00
affiliate_postcode affiliate_payment varchar 10
affiliate_state affiliate_payment varchar 32 0
affiliate_street_address affiliate_payment varchar 64
affiliate_suburb affiliate_payment varchar 64
affiliate_language_id affiliate_payment_status int 11 1
languages.languages_id affiliate_payment_status_ibfk_1
affiliate_payment_status_id affiliate_payment_status int 11 0
affiliate_payment.affiliate_payment_status affiliate_payment_ibfk_2
affiliate_payment_status_name affiliate_payment_status varchar 32
affiliate_date_added affiliate_payment_status_history datetime 19 0000-00-00 00:00:00
affiliate_new_value affiliate_payment_status_history int 5 0
affiliate_notified affiliate_payment_status_history int 1  √  0
affiliate_old_value affiliate_payment_status_history int 5  √  null
affiliate_payment_id affiliate_payment_status_history int 11 0
affiliate_payment.affiliate_payment_id affiliate_payment_status_history_ibfk_1
affiliate_status_history_id affiliate_payment_status_history int 11  √ 
affiliate_billing_status affiliate_sales int 5 0
affiliate_browser affiliate_sales varchar 100
affiliate_clickthroughs_id affiliate_sales int 11 0
affiliate_date affiliate_sales datetime 19 0000-00-00 00:00:00
affiliate_id affiliate_sales int 11 0
affiliate_affiliate.affiliate_id affiliate_sales_ibfk_1
affiliate_ipaddress affiliate_sales varchar 20
affiliate_orders_id affiliate_sales int 11 0
orders.orders_id affiliate_sales_ibfk_2
affiliate_payment affiliate_sales decimal 15,2 0.00
affiliate_payment_date affiliate_sales datetime 19 0000-00-00 00:00:00
affiliate_payment_id affiliate_sales int 11 0
affiliate_payment.affiliate_payment_id Implied Constraint
affiliate_percent affiliate_sales decimal 4,2 0.00
affiliate_salesman affiliate_sales int 11 0
affiliate_value affiliate_sales decimal 15,2 0.00
bank_name algozone_fraud_queries varchar 20  √ 
bank_phone algozone_fraud_queries varchar 15  √ 
bin_country_code algozone_fraud_queries varchar 5  √ 
country_code algozone_fraud_queries varchar 21  √ 
distance_k algozone_fraud_queries varchar 10  √ 
distance_m algozone_fraud_queries varchar 10  √ 
err_message algozone_fraud_queries varchar 150  √ 
fraud_level algozone_fraud_queries varchar 5  √ 
ip_address algozone_fraud_queries varchar 30
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  √ 
last_date_queried algozone_fraud_queries datetime 19  √  0000-00-00 00:00:00
order_id algozone_fraud_queries varchar 6
proxy_level algozone_fraud_queries varchar 5  √ 
spam_level algozone_fraud_queries varchar 5  √ 
approved article_reviews tinyint unsigned 3  √  0
articles_id article_reviews int 11 0
articles.articles_id article_reviews_ibfk_1
customers_id article_reviews int 11  √  null
customers.customers_id Implied Constraint
customers_name article_reviews varchar 64
date_added article_reviews datetime 19  √  null
last_modified article_reviews datetime 19  √  null
reviews_id article_reviews int 11  √ 
article_reviews_description.reviews_id article_reviews_description_ibfk_1
reviews.reviews_id Implied Constraint
reviews_rating article_reviews int 1  √  null
reviews_read article_reviews int 5 0
languages_id article_reviews_description int 11 0
languages.languages_id article_reviews_description_ibfk_2
reviews_id article_reviews_description int 11 0
article_reviews.reviews_id article_reviews_description_ibfk_1
reviews_text article_reviews_description text 65535
articles_date_added articles datetime 19 0000-00-00 00:00:00
articles_date_available articles datetime 19  √  null
articles_id articles int 11  √ 
article_reviews.articles_id article_reviews_ibfk_1
articles_description.articles_id articles_description_ibfk_1
articles_to_topics.articles_id articles_to_topics_ibfk_1
articles_xsell.articles_id articles_xsell_ibfk_1
articles_last_modified articles datetime 19  √  null
articles_status articles bit 1 0
authors_id articles int 11  √  null
authors.authors_id articles_ibfk_1
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_id articles_description int 11  √ 
articles.articles_id articles_description_ibfk_1
articles_name articles_description varchar 64
articles_url articles_description varchar 255  √  null
articles_viewed articles_description int 5  √  0
language_id articles_description int 11 1
languages.languages_id articles_description_ibfk_2
articles_id articles_to_topics int 11 0
articles.articles_id articles_to_topics_ibfk_1
topics_id articles_to_topics int 11 0
topics.topics_id articles_to_topics_ibfk_2
ID articles_xsell int 10  √ 
products_xsell.ID Implied Constraint
articles_id articles_xsell int 10 1
articles.articles_id articles_xsell_ibfk_1
sort_order articles_xsell int unsigned 10 1
xsell_id articles_xsell int 10 1
products.products_id articles_xsell_ibfk_2
authors_id authors int 11  √ 
articles.authors_id articles_ibfk_1
authors_info.authors_id authors_info_ibfk_1
authors_image authors varchar 64  √  null
authors_name authors varchar 32
date_added authors datetime 19  √  null
last_modified authors datetime 19  √  null
authors_description authors_info text 65535  √  null
authors_id authors_info int 11 0
authors.authors_id authors_info_ibfk_1
authors_url authors_info varchar 255
date_last_click authors_info datetime 19  √  null
languages_id authors_info int 11 0
languages.languages_id authors_info_ibfk_2
url_clicked authors_info int 5 0
banners_group banners varchar 10
banners_html_text banners text 65535  √  null
banners_id banners int 11  √ 
banners_history.banners_id Implied Constraint
banners_image banners varchar 64
banners_title banners varchar 64
banners_url banners varchar 255
date_added banners datetime 19 0000-00-00 00:00:00
date_scheduled banners datetime 19  √  null
date_status_change banners datetime 19  √  null
expires_date banners datetime 19  √  null
expires_impressions banners int 7  √  0
status banners int 1 1
banners_clicked banners_history int 5 0
banners_history_date banners_history datetime 19 0000-00-00 00:00:00
banners_history_id banners_history int 11  √ 
banners_id banners_history int 11 0
banners.banners_id Implied Constraint
banners_shown banners_history int 5 0
blacklist_card_number card_blacklist varchar 20
blacklist_id card_blacklist int 5  √ 
date_added card_blacklist datetime 19  √  null
last_modified card_blacklist datetime 19  √  null
categories_id categories int 11  √ 
affiliate_banners.affiliate_category_id affiliate_banners_ibfk_2
categories_description.categories_id categories_description_ibfk_1
products_to_categories.categories_id products_to_categories_ibfk_2
categories_image categories varchar 64  √  null
date_added categories datetime 19  √  null
last_modified categories datetime 19  √  null
parent_id categories int 11 0
sort_order categories int 3  √  null
categories_description categories_description text 65535  √  null
categories_head_desc_tag categories_description longtext 2147483647 <