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
ID articles_xsell int 10  √ 
products_xsell.ID Implied Constraint
ID products_xsell int 10  √ 
articles_xsell.ID Implied Constraint
OSC_link events_calendar varchar 255  √  null
account_name orders varchar 32  √  null
account_number orders varchar 20  √  null
active template char 1 1
address_book_id address_book int 11  √ 
address_city paypal varchar 32  √  null
address_country paypal varchar 64  √  null
address_format address_format varchar 128
address_format_id countries int 11 0
address_format.address_format_id countries_ibfk_1
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_summary address_format varchar 48
address_zip paypal varchar 10  √  null
admin_created admin datetime 19  √  null
admin_email_address admin varchar 96
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_firstname admin varchar 32
admin_groups_id admin int 11  √  null
admin_groups.admin_groups_id admin_ibfk_1
admin_groups_id admin_files set 5 1
admin_groups_name admin_groups varchar 64  √  null
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
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_group affiliate_banners varchar 10
affiliate_banners_history_date affiliate_banners_history date 10 0000-00-00
affiliate_banners_history_id affiliate_banners_history int 11  √ 
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_id affiliate_banners_history int 11 0
affiliate_banners.affiliate_banners_id Implied Constraint
affiliate_banners_image affiliate_banners varchar 64
affiliate_banners_products_id affiliate_banners_history int 11 0
affiliate_banners_shown affiliate_banners_history int 11 0
affiliate_banners_title affiliate_banners varchar 64
affiliate_billing_status affiliate_sales int 5 0
affiliate_browser affiliate_sales varchar 100
affiliate_browser orders_session_info varchar 100  √ 
affiliate_category_id affiliate_banners int 11  √  null
categories.categories_id affiliate_banners_ibfk_2
affiliate_city affiliate_affiliate varchar 32
affiliate_city affiliate_payment varchar 32
affiliate_clickthrough_id affiliate_clickthroughs int 11  √ 
affiliate_clickthroughs_id affiliate_sales int 11 0
affiliate_clickthroughs_id orders_session_info int 11  √  0
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_commission_percent affiliate_affiliate decimal 4,2 0.00
affiliate_company affiliate_affiliate varchar 60
affiliate_company affiliate_payment varchar 60
affiliate_company_taxid affiliate_affiliate varchar 64
affiliate_country affiliate_payment varchar 32 0
affiliate_country_id affiliate_affiliate int 11 0
affiliate_date affiliate_sales datetime 19 0000-00-00 00:00:00
affiliate_date orders_session_info datetime 19  √  null
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_added affiliate_banners datetime 19 0000-00-00 00:00:00
affiliate_date_added affiliate_payment_status_history datetime 19 0000-00-00 00:00:00
affiliate_date_of_last_logon affiliate_affiliate 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_dob affiliate_affiliate datetime 19 0000-00-00 00:00:00
affiliate_email_address affiliate_affiliate varchar 96
affiliate_expires_date affiliate_banners datetime 19  √  null
affiliate_expires_impressions affiliate_banners int 7  √  0
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_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_ipaddress affiliate_sales varchar 20
affiliate_ipaddress orders_session_info varchar 20  √ 
affiliate_language_id affiliate_payment_status int 11 1
languages.languages_id affiliate_payment_status_ibfk_1
affiliate_last_modified affiliate_payment datetime 19 0000-00-00 00:00:00
affiliate_lastname affiliate_affiliate varchar 32
affiliate_lastname affiliate_payment varchar 32
affiliate_lft affiliate_affiliate int 11 0
affiliate_new_value affiliate_payment_status_history int 5 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_newsletter affiliate_affiliate char 1 1
affiliate_newsletters_id affiliate_newsletters int 11  √ 
affiliate_notified affiliate_payment_status_history int 1  √  0
affiliate_number_of_logons affiliate_affiliate int 11 0
affiliate_old_value affiliate_payment_status_history int 5  √  null
affiliate_orders_id affiliate_sales int 11 0
orders.orders_id affiliate_sales_ibfk_2
affiliate_password affiliate_affiliate varchar 40
affiliate_payment affiliate_payment decimal 15,2 0.00
affiliate_payment affiliate_sales decimal 15,2 0.00
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_date affiliate_payment datetime 19 0000-00-00 00:00:00
affiliate_payment_date affiliate_sales datetime 19 0000-00-00 00:00:00
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_last_modified affiliate_payment datetime 19 0000-00-00 00:00:00
affiliate_payment_paypal affiliate_affiliate varchar 64
affiliate_payment_status affiliate_payment int 5 0
affiliate_payment_status.affiliate_payment_status_id affiliate_payment_ibfk_2
affiliate_payment_status_name affiliate_payment_status varchar 32
affiliate_payment_tax affiliate_payment decimal 15,2 0.00
affiliate_payment_total affiliate_payment decimal 15,2 0.00
affiliate_percent affiliate_sales decimal 4,2 0.00
affiliate_postcode affiliate_affiliate varchar 10
affiliate_postcode affiliate_payment varchar 10
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
affiliate_rgt affiliate_affiliate int 11 0
affiliate_root affiliate_affiliate int 11 0
affiliate_salesman affiliate_sales int 11 0
affiliate_state affiliate_affiliate varchar 32
affiliate_state affiliate_payment varchar 32 0
affiliate_status affiliate_banners int 1 1
affiliate_status_history_id affiliate_payment_status_history int 11  √ 
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
affiliate_value affiliate_sales decimal 15,2 0.00
affiliate_zone_id affiliate_affiliate int 11 0
amount coupon_gv_customer decimal 8,4 0.0000
amount coupon_gv_queue decimal 8,4 0.0000
answer faq text 65535
approved article_reviews tinyint unsigned 3  √  0
articles_date_added articles datetime 19 0000-00-00 00:00:00
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_id article_reviews int 11 0
articles.articles_id article_reviews_ibfk_1
articles_id articles_description int 11  √ 
articles.articles_id articles_description_ibfk_1
articles_id articles_to_topics int 11 0
articles.articles_id articles_to_topics_ibfk_1
articles_id articles_xsell int 10 1
articles.articles_id articles_xsell_ibfk_1
articles_last_modified articles datetime 19  √  null
articles_name articles_description varchar 64
articles_status articles bit 1 0
articles_url articles_description varchar 255  √  null
articles_viewed articles_description int 5  √  0
association_id zones_to_geo_zones int 11  √ 
auction_buyer_id paypal varchar 64
auction_closing_date paypal datetime 19 0000-00-00 00:00:00
auction_multi_item paypal tinyint 4 0
authors_description authors_info text 65535  √  null
authors_id articles int 11  √  null
authors.authors_id articles_ibfk_1
authors_id authors_info int 11 0
authors.authors_id authors_info_ibfk_1
authors_image authors varchar 64  √  null
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_clicked banners_history int 5 0
banners_group banners varchar 10
banners_history_date banners_history datetime 19 0000-00-00 00:00:00
banners_history_id banners_history int 11  √ 
banners_html_text banners text 65535  √  null
banners_id banners int 11  √ 
banners_history.banners_id Implied Constraint
banners_id banners_history int 11 0
banners.banners_id Implied Constraint
banners_image banners varchar 64
banners_shown banners_history int 5 0
banners_title banners varchar 64
banners_url banners varchar 255
billing_address_format_id orders int 5 0
billing_city orders varchar 32
billing_company orders varchar 32  √  null
billing_country orders varchar 32
billing_name orders varchar 64
billing_postcode orders varchar 10
billing_state orders varchar 32  √  null
billing_street_address orders varchar 64
billing_suburb orders varchar 32  √  null
billto orders_session_info int 11 1
bin_country_code algozone_fraud_queries varchar 5  √ 
blacklist_card_number card_blacklist varchar 20
blacklist_id card_blacklist int 5  √ 
box_heading infobox_configuration varchar 64
box_heading infobox_heading varchar 64
box_heading_font_color infobox_configuration varchar 10 #000000
box_template infobox_configuration varchar 64 infobox
box_width_left template varchar 4 125
box_width_right template varchar 4 125
business paypal varchar 96
cart_in_header template char 3 no
cat_id data_cat int 11 0
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_desc_tag categories_description longtext 2147483647
categories_head_keywords_tag categories_description longtext 2147483647
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_id categories_description int 11 0
categories.categories_id categories_description_ibfk_1
categories_id faq_categories_description tinyint unsigned 3 0
faq_categories.categories_id faq_categories_description_ibfk_1
categories_id faq_to_categories tinyint unsigned 3 0
faq_categories.categories_id faq_to_categories_ibfk_2
categories_id pages_categories_description tinyint unsigned 3 0
pages_categories.categories_id pages_categories_description_ibfk_1
categories_id pages_to_categories tinyint unsigned 3 0
pages_categories.categories_id pages_to_categories_ibfk_2
categories_id products_to_categories int 11 0
categories.categories_id products_to_categories_ibfk_2
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_name categories_description varchar 32
categories_name faq_categories_description varchar 32
categories_name pages_categories_description varchar 32
categories_sort_order faq_categories int 3  √  null
categories_sort_order pages_categories int 3  √  null
categories_status faq_categories bit 1 0
categories_status pages_categories bit 1 0
cc_bank_phone orders varchar 32
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
class orders_total varchar 32
code currencies char 3
code languages char 2
code visual_verify_code varchar 6
comments orders_status_history text 65535  √  null
configuration_description configuration varchar 255
configuration_group_description configuration_group varchar 255
configuration_group_id configuration int 11 0
configuration_group.configuration_group_id configuration_ibfk_1
configuration_group_title configuration_group varchar 64
configuration_id configuration int 11  √ 
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
counter counter int 12  √  null
counter counter_history int 12  √  null
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_active coupons char 1 Y
coupon_amount coupons decimal 8,4 0.0000
coupon_code coupons