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
articles_status articles bit 1 0
categories_status faq_categories bit 1 0
categories_status pages_categories bit 1 0
link_categories_status link_categories bit 1 0
links_rating links bit 1 0
news_status affiliate_news bit 1 0
nml_status navmenu_links bit 1 0
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
active template char 1 1
affiliate_gender affiliate_affiliate char 1
affiliate_newsletter affiliate_affiliate char 1 1
coupon_active coupons char 1 Y
coupon_type coupons char 1 F
customers_gender customers char 1
customers_newsletter customers char 1  √  null
customers_validation customers char 1 0
decimal_places currencies char 1  √  null
decimal_point currencies char 1  √  null
entry_gender address_book char 1
price_prefix orders_products_attributes char 1
price_prefix products_attributes char 1
release_flag coupon_gv_queue char 1 N
thousands_point currencies char 1  √  null
code languages char 2
countries_iso_code_2 countries char 2
data_lang_char data_files char 2  √  en
cart_in_header template char 3 no
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
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
mc_currency paypal char 3
payment_currency orders_session_info char 3
settle_currency paypal char 3  √  null
show_header_link_buttons template char 3 no
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
month counter_history char 8  √  null
startdate counter char 8  √  null
affiliate_banners_history_date affiliate_banners_history date 10 0000-00-00
date faq date 10 0000-00-00
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
start_date events_calendar date 10 0000-00-00
admin_created admin datetime 19  √  null
admin_logdate admin datetime 19  √  null
admin_modified admin datetime 19 0000-00-00 00:00:00
affiliate_clientdate affiliate_clickthroughs datetime 19 0000-00-00 00:00:00
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_expires_date affiliate_banners datetime 19  √  null
affiliate_last_modified affiliate_payment datetime 19 0000-00-00 00:00:00
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_last_modified affiliate_payment datetime 19 0000-00-00 00:00:00
articles_date_added articles datetime 19 0000-00-00 00:00:00
articles_date_available articles datetime 19  √  null
articles_last_modified articles datetime 19  √  null
auction_closing_date paypal datetime 19 0000-00-00 00:00:00
banners_history_date banners_history datetime 19 0000-00-00 00:00:00
categories_date_added faq_categories datetime 19  √  null
categories_date_added pages_categories datetime 19  √  null
categories_last_modified faq_categories datetime 19  √  null
categories_last_modified pages_categories datetime 19  √  null
coupon_expire_date coupons datetime 19 0000-00-00 00:00:00
coupon_start_date coupons datetime 19 0000-00-00 00:00:00
customers_dob customers datetime 19 0000-00-00 00:00:00
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
date_added affiliate_news datetime 19 0000-00-00 00:00:00
date_added affiliate_newsletters datetime 19 0000-00-00 00:00:00
date_added article_reviews datetime 19  √  null
date_added authors datetime 19  √  null
date_added banners datetime 19 0000-00-00 00:00:00
date_added card_blacklist datetime 19  √  null
date_added categories datetime 19  √  null
date_added configuration datetime 19 0000-00-00 00:00:00
date_added email_subjects datetime 19  √  null
date_added events_calendar datetime 19 0000-00-00 00:00:00
date_added geo_zones datetime 19 0000-00-00 00:00:00
date_added infobox_configuration datetime 19 0000-00-00 00:00:00
date_added manufacturers datetime 19  √  null
date_added newsletters datetime 19 0000-00-00 00:00:00
date_added orders_pay_methods datetime 19 0000-00-00 00:00:00
date_added orders_ship_methods datetime 19 0000-00-00 00:00:00
date_added orders_status_history datetime 19 0000-00-00 00:00:00
date_added paypal datetime 19  √  null
date_added paypal_payment_status_history datetime 19 0000-00-00 00:00:00
date_added products_notifications datetime 19 0000-00-00 00:00:00
date_added reviews datetime 19  √  null
date_added tax_class datetime 19 0000-00-00 00:00:00
date_added tax_rates datetime 19 0000-00-00 00:00:00
date_added template datetime 19  √  null
date_added topics datetime 19  √  null
date_added zones_to_geo_zones datetime 19 0000-00-00 00:00:00
date_created coupon_gv_queue datetime 19 0000-00-00 00:00:00
date_created coupons datetime 19 0000-00-00 00:00:00
date_last_click authors_info datetime 19  √  null
date_last_click manufacturers_info datetime 19  √  null
date_modified coupons datetime 19 0000-00-00 00:00:00
date_purchased orders datetime 19  √  null
date_scheduled banners datetime 19  √  null
date_sent affiliate_newsletters datetime 19  √  null
date_sent coupon_email_track datetime 19 0000-00-00 00:00:00
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
expires_date banners datetime 19  √  null
expires_date featured datetime 19  √  null
expires_date specials datetime 19  √  null
featured_date_added featured datetime 19  √  null
featured_last_modified featured datetime 19  √  null
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_categories_date_added link_categories datetime 19  √  null
link_categories_last_modified link_categories datetime 19  √  null
links_date_added links datetime 19 0000-00-00 00:00:00
links_last_modified links datetime 19  √  null
nmc_date_added navmenu_categories datetime 19  √  null
nml_date_added navmenu_links datetime 19 0000-00-00 00:00:00
options_date_added products_options datetime 19  √  null
options_last_modified products_options datetime 19  √  null
orders_date_finished orders datetime 19  √  null
payment_date paypal datetime 19  √  null
products_date_added products datetime 19 0000-00-00 00:00:00
products_date_available products datetime 19  √  null
products_last_modified products datetime 19  √  null
redeem_date coupon_redeem_track datetime 19 0000-00-00 00:00:00
specials_date_added specials datetime 19  √  null
specials_last_modified specials datetime 19  √  null
notify_version paypal decimal 2,1 0.0
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
products_weight products decimal 5,2 0.00
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
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
currency_value orders decimal 14,6  √  null
affiliate_payment affiliate_payment decimal 15,2 0.00
affiliate_payment affiliate_sales decimal 15,2 0.00
affiliate_payment_tax affiliate_payment decimal 15,2 0.00
affiliate_payment_total affiliate_payment decimal 15,2 0.00
affiliate_value affiliate_sales decimal 15,2 0.00
customers_group_price products_groups decimal 15,4 0.0000
customers_group_price1 products_groups decimal 15,4 0.0000
customers_group_price10 products_groups decimal 15,4 0.0000
customers_group_price11 products_groups decimal 15,4 0.0000
customers_group_price2 products_groups decimal 15,4 0.0000
customers_group_price3 products_groups decimal 15,4 0.0000
customers_group_price4 products_groups decimal 15,4 0.0000
customers_group_price5 products_groups decimal 15,4 0.0000
customers_group_price6 products_groups decimal 15,4 0.0000
customers_group_price7 products_groups decimal 15,4 0.0000
customers_group_price8 products_groups decimal 15,4 0.0000
customers_group_price9 products_groups decimal 15,4 0.0000
final_price customers_basket decimal 15,4 0.0000
final_price orders_products decimal 15,4 0.0000
options_values_price orders_products_attributes decimal 15,4 0.0000
options_values_price products_attributes decimal 15,4 0.0000
options_values_price products_options_values decimal 15,4 0.0000
products_price orders_products decimal 15,4 0.0000
products_price products decimal 15,4 0.0000
products_price1 products decimal 15,4 0.0000
products_price10 products decimal 15,4 0.0000
products_price11 products decimal 15,4 0.0000
products_price2 products decimal 15,4 0.0000
products_price3 products decimal 15,4 0.0000
products_price4 products decimal 15,4 0.0000
products_price5 products decimal 15,4 0.0000
products_price6 products decimal 15,4 0.0000
products_price7 products decimal 15,4 0.0000
products_price8 products decimal 15,4 0.0000
products_price9 products decimal 15,4 0.0000
sale_deduction_value salemaker_sales decimal 15,4 0.0000
sale_pricerange_from salemaker_sales decimal 15,4 0.0000
sale_pricerange_to salemaker_sales decimal 15,4 0.0000
specials_new_products_price specials decimal 15,4 0.0000
specials_new_products_price specials_retail_prices decimal 15,4 0.0000
value orders_total decimal 15,4 0.0000
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
visible faq enum 2 1
visible information enum 2 1
currency_value orders_session_info float 13,8  √  null
payment_currency_val orders_session_info float 13,8  √  null
value currencies float 13,8  √  null
affiliate_notified affiliate_payment_status_history int 1  √  0
affiliate_status affiliate_banners int 1 1
customer_notified orders_status_history int 1  √  0
data_status data_files int 1 0
email_subjects_category email_subjects int 1  √  null
global_product_notifications customers_info int 1  √  0
locked affiliate_newsletters int 1  √  0
locked newsletters int 1  √  0
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
visible configuration_group int 1  √  1
customers_basket_quantity customers_basket int 2 0
download_count orders_products_download int 2 0
download_maxdays orders_products_download int 2 0
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
categories_sort_order faq_categories int 3  √  null
categories_sort_order pages_categories int 3  √  null
event_id events_calendar int 3  √ 
link_categories_sort_order link_categories int 3  √  null
location infobox_configuration int 3 0
nmc_sort_order navmenu_categories int 3  √  null
nml_sort_order navmenu_links int 3  √  null
pay_method_sort orders_pay_methods int 3 0
products_extra_fields_order products_extra_fields int 3 0
ship_method_sort orders_ship_methods int 3 0
sort_order categories int 3  √  null
sort_order languages int 3  √  null
sort_order topics int 3  √  null
template_id infobox_configuration int 3 0
template.template_id infobox_configuration_ibfk_1
products_options_sort_order products_options int 4 0
products_quantity products int 4 0
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
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_info_number_of_logons customers_info int 5  √  null
delivery_address_format_id orders int 5 0
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
reviews_read article_reviews int 5 0
reviews_read reviews int 5 0
sort_order configuration int 5  √  null
sort_order configuration_group int 5  √  null
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