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
active template char 1 1
affiliate_gender affiliate_affiliate char 1
affiliate_newsletter affiliate_affiliate char 1 1
affiliate_notified affiliate_payment_status_history int 1  √  0
affiliate_status affiliate_banners int 1 1
articles_status articles bit 1 0
categories_status faq_categories bit 1 0
categories_status pages_categories bit 1 0
coupon_active coupons char 1 Y
coupon_type coupons char 1 F
customer_notified orders_status_history int 1  √  0
customers_gender customers char 1
customers_newsletter customers char 1  √  null
customers_validation customers char 1 0
data_status data_files int 1 0
decimal_places currencies char 1  √  null
decimal_point currencies char 1  √  null
email_subjects_category email_subjects int 1  √  null
entry_gender address_book char 1
global_product_notifications customers_info int 1  √  0
link_categories_status link_categories bit 1 0
links_rating links bit 1 0
locked affiliate_newsletters int 1  √  0
locked newsletters int 1  √  0
news_status affiliate_news bit 1 0
nml_status navmenu_links bit 1 0
price_prefix orders_products_attributes char 1
price_prefix products_attributes char 1
products_extra_fields_status products_extra_fields bit 1 0
products_status products bit 1 0
purchased_without_account customers bit 1 0
purchased_without_account orders bit 1 0
release_flag coupon_gv_queue char 1 N
reviews_rating article_reviews int 1  √  null
reviews_rating reviews int 1  √  null
status affiliate_newsletters int 1  √  null
status banners int 1 1
status featured int 1  √  1
status newsletters int 1  √  null
status specials int 1 1
thousands_point currencies char 1  √  null
visible configuration_group int 1  √  1
code languages char 2
countries_iso_code_2 countries char 2
customers_basket_quantity customers_basket int 2 0
customers_group_ra customers enum 2 0
customers_group_show_tax customers_groups enum 2 1
customers_group_tax_exempt customers_groups enum 2 0
data_lang_char data_files char 2  √  en
download_count orders_products_download int 2 0
download_maxdays orders_products_download int 2 0
options_length products_options smallint 2 32
products_attributes_maxcount products_attributes_download int 2  √  0
products_attributes_maxdays products_attributes_download int 2  √  0
products_quantity customers_wishlist int 2 0
products_quantity orders_products int 2 0
visible faq enum 2 1
visible information enum 2 1
notify_version paypal decimal 2,1 0.0
approved article_reviews tinyint unsigned 3  √  0
cart_in_header template char 3 no
categories_id faq_categories tinyint unsigned 3  √ 
faq_categories_description.categories_id faq_categories_description_ibfk_1
faq_to_categories.categories_id faq_to_categories_ibfk_2
pages_categories.categories_id Implied Constraint
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 tinyint unsigned 3  √ 
pages_categories_description.categories_id pages_categories_description_ibfk_1
pages_to_categories.categories_id pages_to_categories_ibfk_2
faq_categories.categories_id Implied Constraint
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_sort_order faq_categories int 3  √  null
categories_sort_order pages_categories int 3  √  null
cc_issue orders char 3  √  null
code currencies char 3
countries_iso_code_3 countries char 3
currency orders char 3  √  null
currency orders_session_info char 3
customer_greeting template char 3 yes
data_cur data_files char 3  √  USD
event_id events_calendar int 3  √ 
faq_id faq tinyint unsigned 3  √ 
faq_to_categories.faq_id faq_to_categories_ibfk_1
faq_id faq_to_categories tinyint unsigned 3 0
faq.faq_id faq_to_categories_ibfk_1
information_id information tinyint unsigned 3  √ 
is_anonymous_proxy algozone_fraud_queries char 3  √ 
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  √ 
languages_in_header template char 3  √  no
link_categories_sort_order link_categories int 3  √  null
location infobox_configuration int 3 0
mc_currency paypal char 3
nmc_sort_order navmenu_categories int 3  √  null
nml_sort_order navmenu_links int 3  √  null
pages_id pages tinyint unsigned 3  √ 
pages_description.pages_id pages_description_ibfk_1
pages_to_categories.pages_id pages_to_categories_ibfk_1
pages_id pages_description tinyint unsigned 3 0
pages.pages_id pages_description_ibfk_1
pages_id pages_to_categories tinyint unsigned 3 0
pages.pages_id pages_to_categories_ibfk_1
pages_sort_order pages tinyint 3 0
pages_status pages tinyint 3 1
pay_method_sort orders_pay_methods int 3 0
payment_currency orders_session_info char 3
products_extra_fields_order products_extra_fields int 3 0
settle_currency paypal char 3  √  null
ship_method_sort orders_ship_methods int 3 0
show_header_link_buttons template char 3 no
sort_order categories int 3  √  null
sort_order languages int 3  √  null
sort_order topics int 3  √  null
template_cellpadding_left template char 3 0
template_cellpadding_main template char 3 0
template_cellpadding_right template char 3 0
template_cellpadding_sub template char 3 0
template_id infobox_configuration int 3 0
template.template_id infobox_configuration_ibfk_1
v_order faq tinyint unsigned 3 0
v_order information tinyint unsigned 3 0
affiliate_agb affiliate_affiliate tinyint 4 0
affiliate_banners_clicks affiliate_banners_history tinyint 4 0
auction_multi_item paypal tinyint 4 0
box_width_left template varchar 4 125
box_width_right template varchar 4 125
cc_start orders varchar 4  √  null
num_cart_items paypal tinyint unsigned 4 1
payment_time_zone paypal varchar 4
products_options_sort_order products_options int 4 0
products_quantity products int 4 0
sale_deduction_type salemaker_sales tinyint 4 0
sale_specials_condition salemaker_sales tinyint 4 0
sale_status salemaker_sales tinyint 4 0
status specials_retail_prices tinyint 4  √  null
affiliate_commission_percent affiliate_affiliate decimal 4,2 0.00
affiliate_percent affiliate_sales decimal 4,2 0.00
exchange_rate paypal decimal 4,2  √  null
admin_files_is_boxes admin_files tinyint 5 0
admin_groups_id admin_files set 5 1
affiliate_address_format_id affiliate_payment int 5 0
affiliate_billing_status affiliate_sales int 5 0
affiliate_new_value affiliate_payment_status_history int 5 0
affiliate_old_value affiliate_payment_status_history int 5  √  null
affiliate_payment_status affiliate_payment int 5 0
affiliate_payment_status.affiliate_payment_status_id affiliate_payment_ibfk_2
articles_viewed articles_description int 5  √  0
banners_clicked banners_history int 5 0
banners_shown banners_history int 5 0
billing_address_format_id orders int 5 0
bin_country_code algozone_fraud_queries varchar 5  √ 
blacklist_id card_blacklist int 5  √ 
customer_id coupon_gv_customer int 5 0
customers.customers_id coupon_gv_customer_ibfk_1
customer_id coupon_gv_queue int 5 0
customers.customers_id coupon_gv_queue_ibfk_1
customers_address_format_id orders int 5 0
customers_group_id customers smallint 5 0
customers_group_id customers_groups smallint unsigned 5 0
products_groups.customers_group_id Implied Constraint
specials.customers_group_id Implied Constraint
customers_group_id products_groups smallint unsigned 5 0
customers_groups.customers_group_id Implied Constraint
customers_group_id specials smallint unsigned 5 0
customers_groups.customers_group_id Implied Constraint
customers_info_number_of_logons customers_info int 5  √  null
data_convert_cur data_files varchar 5  √  false
data_cur_use data_files varchar 5 true
data_lang_use data_files varchar 5 true
delivery_address_format_id orders int 5 0
for_auction paypal varchar 5 false
fraud_level algozone_fraud_queries varchar 5  √ 
infobox_display infobox_configuration varchar 5
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_high_risk_country algozone_fraud_queries varchar 5  √ 
options_type products_options int 5 0
order_id coupon_gv_queue int 5 0
orders.orders_id coupon_gv_queue_ibfk_2
orders_status orders int 5 0
orders_status.orders_status_id orders_ibfk_1
orders_status_id orders_status_history int 5 0
products_viewed products_description int 5  √  0
proxy_level algozone_fraud_queries varchar 5  √ 
reviews_read article_reviews int 5 0
reviews_read reviews int 5 0
site_width template varchar 5 100%
sort_order configuration int 5  √  null
sort_order configuration_group int 5  √  null
spam_level algozone_fraud_queries varchar 5  √ 
tax_priority tax_rates int 5  √  1
unique_id coupon_gv_queue int 5  √ 
url_clicked authors_info int 5 0
url_clicked manufacturers_info int 5 0
uses_per_coupon coupons int 5 1
uses_per_user coupons int 5 0
products_weight products decimal 5,2 0.00
code visual_verify_code varchar 6
customers_group_id specials_retail_prices smallint 6  √  null
main_table_border template varchar 6 no
order_id algozone_fraud_queries varchar 6
products_options_sort_order products_attributes int 6 0
show_heading_title_original template varchar 6 yes
affiliate_expires_impressions affiliate_banners int 7  √  0
expires_impressions banners int 7  √  0
payment_type paypal varchar 7
mc_fee paypal decimal 7,2 0.00
mc_gross paypal decimal 7,2 0.00
payment_amount orders_session_info decimal 7,2 0.00
payment_fee paypal decimal 7,2  √  null
payment_gross paypal decimal 7,2  √  null
settle_amount paypal decimal 7,2  √  null
tax paypal decimal 7,2  √  null
products_tax orders_products decimal 7,4 0.0000
tax_rate tax_rates decimal 7,4 0.0000
customers_basket_date_added customers_basket varchar 8  √  null
month counter_history char 8  √  null
startdate counter char 8  √  null
final_price customers_wishlist decimal 8,2 0.00
products_price customers_wishlist decimal 8,2 0.00
amount coupon_gv_customer decimal 8,4 0.0000
amount coupon_gv_queue decimal 8,4 0.0000
coupon_amount coupons decimal 8,4 0.0000
coupon_minimum_order coupons decimal 8,4 0.0000
ID articles_xsell int 10  √ 
products_xsell.ID Implied Constraint
ID products_xsell int 10  √ 
articles_xsell.ID Implied Constraint
address_zip paypal varchar 10  √  null
affiliate_banners_group affiliate_banners varchar 10
affiliate_banners_history_date affiliate_banners_history date 10 0000-00-00
affiliate_postcode affiliate_affiliate varchar 10
affiliate_postcode affiliate_payment varchar 10
articles_id articles_xsell int 10 1
articles.articles_id articles_xsell_ibfk_1
banners_group banners varchar 10
billing_postcode orders varchar 10
box_heading_font_color infobox_configuration varchar 10 #000000
customers_postcode orders varchar 10
data_files_service data_files varchar 10  √  froogle
data_files_type1 data_files varchar 10 product
date faq date 10 0000-00-00
delivery_postcode orders varchar 10
distance_k algozone_fraud_queries varchar 10  √ 
distance_m algozone_fraud_queries varchar 10  √ 
entry_postcode address_book varchar 10
orders_total_id orders_total int unsigned 10  √ 
payer_status paypal varchar 10
products_id products_xsell int 10 1
products.products_id products_xsell_ibfk_1
sale_date_added salemaker_sales date 10 0000-00-00
sale_date_end salemaker_sales date 10 0000-00-00
sale_date_last_modified salemaker_sales date 10 0000-00-00
sale_date_start salemaker_sales date 10 0000-00-00
sale_date_status_change salemaker_sales date 10 0000-00-00
side_box_left_width template int 10  √  1
side_box_right_width template int 10  √  1
sort_order articles_xsell int unsigned 10 1
sort_order products_xsell int unsigned 10 1
start_date events_calendar date 10 0000-00-00
txn_type paypal varchar 10
xsell_id articles_xsell int 10 1
products.products_id articles_xsell_ibfk_2
xsell_id products_xsell int 10 1
products.products_id products_xsell_ibfk_2
address_book_id address_book int 11  √ 
address_format_id address_format int 11  √ 
countries.address_format_id countries_ibfk_1
address_format_id countries int 11 0
address_format.address_format_id countries_ibfk_1
address_status paypal varchar 11  √  null
admin_files_id admin_files int 11  √ 
admin_files_to_boxes admin_files int 11 0
admin_groups_id admin int 11  √  null
admin_groups.admin_groups_id admin_ibfk_1
admin_groups_id admin_groups int 11  √ 
admin.admin_groups_id admin_ibfk_1
admin_id admin int 11  √ 
admin_lognum admin int 11 0
affiliate_banner_id affiliate_clickthroughs int 11 0
affiliate_banners_affiliate_id affiliate_banners_history int 11 0
affiliate_banners_history_id affiliate_banners_history int 11  √ 
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_products_id affiliate_banners_history int 11 0
affiliate_banners_shown affiliate_banners_history int 11 0
affiliate_category_id affiliate_banners int 11  √  null
categories.categories_id affiliate_banners_ibfk_2
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_country_id affiliate_affiliate int 11 0
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_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_language_id affiliate_payment_status int 11 1