Magento 数据库设计图

rayzhang

贡献于2012-05-31

字数:0 关键词: 电子商务/商城

EAV ENTITY STORECUSTOMER GROUP WISH LIST REVIEW RATING CATALOG INDEX CATALOG QUERY PRODUCT OPTION PRODUCT BUNDLE PRODUCT SUPER ATTRIBUTE CATEGORY PRODUCT PRODUCT ENTITY PRODUCT LINKCATEGORY ENTITY CORE CONFIGURATION WEBSITE / STORE ADMIN TAG SYSTEM LAYOUT SYSTEM API DIRECTORY EVENT REPORTER SYSTEM LOGS DATA FLOW EAV ENTITY TYPE EAV ATTRIBUTE CATALOG RULE PRODUCT GALLERYPRODUCT ALERT CUSTOMER NEWSLETTER SALES TRANSACTION POLL SALES ORDER EAV ENTITYCUSTOMER ENTITY CUSTOMER ADDRESS ENTITY PRODUCT INVENTORY PRODUCT CUSTOMER EAV SALES SYSTEM MAGENTO - Database Diagram [v1.1.6] TAX PAYMENT OPTIONS GIFT / GIFT CERTIFICATE SHIPPING CHECKOUT AGREEMENT SALES QUOTE Tables Created & Dropped [1.0.x to 1.1.1] NEW TABLES * CREATE TABLE adminnotification_inbox * CREATE TABLE api_assert * CREATE TABLE api_role * CREATE TABLE api_rule * CREATE TABLE api_user * CREATE TABLE catalog_category_product_index * CREATE TABLE catalog_product_bundle_selection * CREATE TABLE catalog_product_enabled_index * CREATE TABLE catalog_product_option * CREATE TABLE catalog_product_option_price * CREATE TABLE catalog_product_option_title * CREATE TABLE catalog_product_option_type_price * CREATE TABLE catalog_product_option_type_title * CREATE TABLE catalog_product_option_type_value * CREATE TABLE checkout_agreement * CREATE TABLE checkout_agreement_store * CREATE TABLE core_flag * CREATE TABLE sales_flat_order_item * CREATE TABLE sales_flat_quote * CREATE TABLE sales_flat_quote_address * CREATE TABLE sales_flat_quote_address_item * CREATE TABLE sales_flat_quote_item * CREATE TABLE sales_flat_quote_item_option * CREATE TABLE sales_flat_quote_payment * CREATE TABLE sales_flat_quote_shipping_rate * CREATE TABLE sales_order_tax * CREATE TABLE tax_calculation * CREATE TABLE tax_calculation_rate * CREATE TABLE tax_calculation_rate_title * CREATE TABLE tax_calculation_rule DELETED TABLES * DROP TABLE catalog_product_bundle_option_link * DROP TABLE sales_counter * DROP TABLE sales_discount_coupon * DROP TABLE sales_giftcert * DROP TABLE sales_quote * DROP TABLE sales_quote_address * DROP TABLE sales_quote_address_decimal * DROP TABLE sales_quote_address_int * DROP TABLE sales_quote_address_text * DROP TABLE sales_quote_address_varchar * DROP TABLE sales_quote_decimal * DROP TABLE sales_quote_entity * DROP TABLE sales_quote_entity_datetime * DROP TABLE sales_quote_entity_decimal * DROP TABLE sales_quote_entity_int * DROP TABLE sales_quote_entity_text * DROP TABLE sales_quote_entity_varchar * DROP TABLE sales_quote_int * DROP TABLE sales_quote_item * DROP TABLE sales_quote_item_decimal * DROP TABLE sales_quote_item_int * DROP TABLE sales_quote_item_text * DROP TABLE sales_quote_item_varchar * DROP TABLE sales_quote_rule * DROP TABLE sales_quote_text * DROP TABLE sales_quote_varchar * DROP TABLE tax_rate * DROP TABLE tax_rate_data * DROP TABLE tax_rate_type * DROP TABLE tax_rule SALES RULE SALES ORDER ENTITY EAV_ATTRIBUTE Area: Sales Cross-Reference Tables Entity Detail Tables [by DataType] "Important Looking" Tables Other Tables Entity Tables Reference Tables [Dynamic] Area: System Area: Product Area: Customer Area: EAV CORE_WEBSITE CORE_STORE EAV_ENTITY_TYPE CUSTOMER_GROUP CATALOG_PRODUCT_ENTITY CATALOG_CATEGORY_ENTITY CUSTOMER_ENTITY LEGEND Reference Tables [Static] eav_entity_store entity_store_id entity_type_id store_id increment_prefix increment_last_id int(10) smallint(5) smallint(5) varchar(20) varchar(50) identity not null not null not null not null customer_group customer_group_id customer_group_code tax_class_id smallint(3) varchar(32) int(10) identity not null not null rating rating_id entity_id rating_code position smallint(6) smallint(6) varchar(64) tinyint(3) identity not null not null not null rating_option_vote_aggregated primary_id rating_id entity_pk_value vote_count vote_value_sum percent percent_approved store_id int(11) smallint(6) bigint(20) int(10) int(10) tinyint(3) tinyint(3) smallint(5) identity not null not null not null not null not null null not null rating_title rating_id store_id value smallint(6) smallint(5) varchar(255) not null not null not null rating_option option_id rating_id code value position int(10) smallint(6) varchar(32) tinyint(3) tinyint(3) identity not null not null not null not null rating_option_vote vote_id option_id remote_ip remote_ip_long customer_id entity_pk_value rating_id review_id percent value bigint(20) int(10) varchar(16) int(11) int(11) bigint(20) smallint(6) bigint(20) tinyint(3) tinyint(3) identity not null not null not null null not null not null null not null not null rating_entity entity_id entity_code smallint(6) varchar(64) identity not null rating_store rating_id store_id smallint(6) smallint(5) not null not null catalog_product_entity_gallery value_id entity_type_id attribute_id store_id entity_id position value int(11) smallint(5) smallint(5) smallint(5) int(10) int(11) varchar(255) identity not null not null not null not null not null not null catalog_product_entity_media_gallery value_id attribute_id entity_id value int(11) smallint(5) int(10) varchar(255) identity not null not null null catalog_product_entity_media_gallery_value value_id store_id label position disabled int(11) smallint(5) varchar(255) int(11) tinyint(1) not null not null null null not null salesrule rule_id name description from_date to_date coupon_code uses_per_coupon uses_per_customer customer_group_ids is_active conditions_serialized actions_serialized stop_rules_processing is_advanced product_ids sort_order simple_action discount_amount discount_qty discount_step simple_free_shipping times_used is_rss website_ids int(10) varchar(255) text date date varchar(255) int(11) int(11) varchar(255) tinyint(1) text text tinyint(1) tinyint(3) text int(10) varchar(32) decimal(12,4) decimal(12,4) int(10) tinyint(1) int(11) tinyint(4) text identity not null not null null null null not null not null not null not null not null not null not null not null null not null not null not null null not null not null not null not null null salesrule_customer rule_customer_id rule_id customer_id times_used int(10) int(10) int(10) smallint(11) identity not null not null not null eav_attribute_set attribute_set_id entity_type_id attribute_set_name sort_order smallint(5) smallint(5) varchar(255) smallint(6) identity not null not null not null core_config_data config_id scope scope_id path value int(10) enum('default','websites','stores','config') int(11) varchar(255) text identity not null not null not null not null core_email_template template_id template_code template_text template_type template_subject template_sender_name template_sender_email added_at modified_at int(7) varchar(150) text int(3) varchar(200) varchar(200) varchar(200) datetime datetime identity null null null null null null null null core_layout_link layout_link_id store_id package theme layout_update_id int(10) smallint(5) varchar(64) varchar(64) int(10) identity not null not null not null not null core_layout_update layout_update_id handle xml int(10) varchar(255) text identity null null core_resource code version varchar(50) varchar(50) not null not null admin_role role_id parent_id tree_level sort_order role_type user_id role_name int(10) int(10) tinyint(3) tinyint(3) char(1) int(11) varchar(50) identity not null not null not null not null not null not null admin_assert assert_id assert_type assert_data int(10) varchar(20) text identity not null null admin_user user_id firstname lastname email username password created modified logdate lognum reload_acl_flag is_active extra mediumint(9) varchar(32) varchar(32) varchar(128) varchar(40) varchar(40) datetime datetime datetime smallint(5) tinyint(1) tinyint(1) text identity not null not null not null not null not null not null null null not null not null not null null admin_rule rule_id role_id resource_id privileges assert_id role_type permission int(10) int(10) varchar(255) varchar(20) int(10) char(1) varchar(10) identity not null not null not null not null null null cron_schedule schedule_id job_code status messages created_at scheduled_at executed_at finished_at int(10) varchar(255) enum('pending','running','success','missed','error') text datetime datetime datetime datetime identity not null not null null not null not null not null not null core_url_rewrite url_rewrite_id store_id category_id product_id id_path request_path target_path is_system options description int(10) smallint(5) int(10) int(10) varchar(255) varchar(255) varchar(255) tinyint(1) varchar(255) varchar(255) identity not null null null not null not null not null null not null null design_change design_change_id store_id design date_from date_to int(11) smallint(5) varchar(255) date date identity not null not null null null catalogindex_eav store_id entity_id attribute_id value smallint(5) int(10) smallint(5) int(11) not null not null not null not null catalogindex_price store_id entity_id attribute_id customer_group_id qty value tax_class_id smallint(5) int(10) smallint(5) smallint(3) decimal(12,4) decimal(12,4) smallint(6) not null not null not null not null not null not null not null catalogrule rule_id name description from_date to_date customer_group_ids is_active conditions_serialized actions_serialized stop_rules_processing sort_order simple_action discount_amount website_ids int(10) varchar(255) text date date varchar(255) tinyint(1) text text tinyint(1) int(10) varchar(32) decimal(12,4) text identity not null not null null null not null not null not null not null not null not null not null not null null catalogrule_product_price rule_product_price_id rule_date customer_group_id product_id rule_price website_id latest_start_date earliest_end_date int(10) date smallint(5) int(10) decimal(12,4) smallint(5) date date identity not null not null not null not null not null null null catalogrule_product rule_product_id rule_id from_time to_time customer_group_id product_id action_operator action_amount action_stop sort_order website_id int(10) int(10) int(10) int(10) smallint(5) int(10) enum('to_fixed','to_percent','by_fixed','by_percent') decimal(12,4) tinyint(1) int(10) smallint(5) identity not null not null not null not null not null not null not null not null not null not null product_alert_stock alert_stock_id customer_id product_id website_id add_date send_date send_count status int(10) int(10) int(10) smallint(5) datetime datetime smallint(5) tinyint(3) identity not null not null not null not null null not null not null product_alert_price alert_price_id customer_id product_id price website_id add_date last_send_date send_count status int(10) int(10) int(10) decimal(12,4) smallint(5) datetime datetime smallint(5) tinyint(3) identity not null not null not null not null not null null not null not null eav_attribute_group attribute_group_id attribute_set_id attribute_group_name sort_order default_id smallint(5) smallint(5) varchar(255) smallint(6) smallint(5) identity not null not null not null null eav_attribute_option option_id attribute_id sort_order int(10) smallint(5) smallint(5) identity not null not null eav_attribute_option_value value_id option_id store_id value int(10) int(10) smallint(5) varchar(255) identity not null not null not null eav_entity_attribute entity_attribute_id entity_type_id attribute_set_id attribute_group_id attribute_id sort_order int(10) smallint(5) smallint(5) smallint(5) smallint(5) smallint(6) identity not null not null not null not null not null newsletter_queue_store_link queue_id store_id int(7) smallint(5) not null not null newsletter_template template_id template_code template_text template_text_preprocessed template_type template_subject template_sender_name template_sender_email template_actual added_at modified_at int(7) varchar(150) text text int(3) varchar(200) varchar(200) varchar(200) tinyint(1) datetime datetime identity null null null null null null null null null null newsletter_problem problem_id subscriber_id queue_id problem_error_code problem_error_text int(7) int(7) int(7) int(3) varchar(200) identity null not null null null newsletter_queue queue_id template_id queue_status queue_start_at queue_finish_at int(7) int(7) int(3) datetime datetime identity not null not null null null newsletter_queue_link queue_link_id queue_id subscriber_id letter_sent_at int(9) int(7) int(7) datetime identity not null not null null newsletter_subscriber subscriber_id store_id change_status_at customer_id subscriber_email subscriber_status subscriber_confirm_code int(7) smallint(5) datetime int(11) varchar(150) int(3) varchar(32) identity null null not null not null not null null poll_store poll_id store_id int(10) smallint(5) not null not null poll_vote vote_id poll_id poll_answer_id ip_address customer_id vote_time int(10) int(10) int(10) bigint(20) int(11) timestamp identity not null not null null null not null poll poll_id poll_title votes_count store_id date_posted date_closed active closed answers_display int(10) varchar(255) int(10) smallint(5) datetime datetime smallint(6) tinyint(1) smallint(6) identity not null not null null not null null not null not null null poll_answer answer_id poll_id answer_title votes_count answer_order int(10) int(10) varchar(255) int(10) smallint(6) identity not null not null not null not null wishlist wishlist_id customer_id shared sharing_code int(10) int(10) tinyint(1) varchar(32) identity not null null not null wishlist_item wishlist_item_id wishlist_id product_id store_id added_at description int(10) int(10) int(10) smallint(5) datetime text identity not null not null not null null null core_translate key_id string store_id translate locale int(10) varchar(255) smallint(5) varchar(255) varchar(20) identity not null not null not null not null core_session session_id website_id session_expires session_data varchar(255) smallint(5) int(10) mediumblob not null null not null not null sitemap sitemap_id sitemap_type sitemap_filename sitemap_path sitemap_time store_id int(11) varchar(32) varchar(32) tinytext timestamp smallint(5) identity null null null null not null core_store_group group_id website_id name root_category_id default_store_id smallint(5) smallint(5) varchar(32) int(10) smallint(5) identity not null not null not null not null cms_block block_id title identifier content creation_time update_time is_active smallint(6) varchar(255) varchar(255) text datetime datetime tinyint(1) identity not null not null null null null not null cms_block_store block_id store_id smallint(6) smallint(5) not null not null cms_page page_id title root_template meta_keywords meta_description identifier content creation_time update_time is_active sort_order layout_update_xml custom_theme custom_theme_from custom_theme_to smallint(6) varchar(255) varchar(255) text text varchar(100) text datetime datetime tinyint(1) tinyint(4) text varchar(100) date date identity not null not null not null not null not null null null null not null not null null null null null cms_page_store page_id store_id smallint(6) smallint(5) not null not null log_summary_type type_id type_code period period_type smallint(5) varchar(64) smallint(5) enum('minute','hour','day','week','month') identity not null not null not null log_customer log_id visitor_id customer_id login_at logout_at store_id int(10) bigint(20) int(11) datetime datetime smallint(5) identity null not null not null null not nulllog_summary summary_id store_id type_id visitor_count customer_count add_date bigint(20) smallint(5) smallint(5) int(11) int(11) datetime identity not null null not null not null not null log_url url_id visitor_id visit_time bigint(20) bigint(20) datetime not null null not null log_url_info url_id url referer bigint(20) varchar(255) varchar(255) identity not null null log_visitor visitor_id session_id first_visit_at last_visit_at last_url_id store_id bigint(20) char(64) datetime datetime bigint(20) smallint(5) identity not null null not null not null not null log_visitor_info visitor_id http_referer http_user_agent http_accept_charset http_accept_language server_addr remote_addr bigint(20) varchar(255) varchar(255) varchar(255) varchar(255) bigint(20) bigint(20) not null null null null null null null sales_order_datetime value_id entity_type_id attribute_id entity_id value int(11) smallint(5) smallint(5) int(10) datetime identity not null not null not null not null sales_order_decimal value_id entity_type_id attribute_id entity_id value int(11) smallint(5) smallint(5) int(10) decimal(12,4) identity not null not null not null not null sales_order_int value_id entity_type_id attribute_id entity_id value int(11) smallint(5) smallint(5) int(10) int(11) identity not null not null not null not null sales_order_text value_id entity_type_id attribute_id entity_id value int(11) smallint(5) smallint(5) int(10) text identity not null not null not null not null sales_order_varchar value_id entity_type_id attribute_id entity_id value int(11) smallint(5) smallint(5) int(10) varchar(255) identity not null not null not null not null eav_entity entity_id entity_type_id attribute_set_id increment_id parent_id store_id created_at updated_at is_active int(10) smallint(8) smallint(5) varchar(50) int(11) smallint(5) datetime datetime tinyint(1) identity not null not null not null not null not null not null not null not null eav_entity_datetime value_id entity_type_id attribute_id store_id entity_id value int(11) smallint(5) smallint(5) smallint(5) int(10) datetime identity not null not null not null not null not null eav_entity_decimal value_id entity_type_id attribute_id store_id entity_id value int(11) smallint(5) smallint(5) smallint(5) int(10) decimal(12,4) identity not null not null not null not null not null eav_entity_int value_id entity_type_id attribute_id store_id entity_id value int(11) smallint(5) smallint(5) smallint(5) int(10) int(11) identity not null not null not null not null not null eav_entity_text value_id entity_type_id attribute_id store_id entity_id value int(11) smallint(5) smallint(5) smallint(5) int(10) text identity not null not null not null not null not null eav_entity_varchar value_id entity_type_id attribute_id store_id entity_id value int(11) smallint(5) smallint(5) smallint(5) int(10) varchar(255) identity not null not null not null not null not null customer_address_entity entity_id entity_type_id attribute_set_id increment_id parent_id created_at updated_at is_active int(10) smallint(8) smallint(5) varchar(50) int(10) datetime datetime tinyint(1) identity not null not null not null null not null not null not null customer_address_entity_datetime value_id entity_type_id attribute_id entity_id value int(11) smallint(8) smallint(5) int(10) datetime identity not null not null not null not null customer_address_entity_decimal value_id entity_type_id attribute_id entity_id value int(11) smallint(8) smallint(5) int(10) decimal(12,4) identity not null not null not null not null customer_address_entity_int value_id entity_type_id attribute_id entity_id value int(11) smallint(8) smallint(5) int(10) int(11) identity not null not null not null not null customer_address_entity_text value_id entity_type_id attribute_id entity_id value int(11) smallint(8) smallint(5) int(10) text identity not null not null not null not null customer_address_entity_varchar value_id entity_type_id attribute_id entity_id value int(11) smallint(8) smallint(5) int(10) varchar(255) identity not null not null not null not null customer_entity_datetime value_id entity_type_id attribute_id entity_id value int(11) smallint(8) smallint(5) int(10) datetime identity not null not null not null not null customer_entity_decimal value_id entity_type_id attribute_id entity_id value int(11) smallint(8) smallint(5) int(10) decimal(12,4) identity not null not null not null not null customer_entity_int value_id entity_type_id attribute_id entity_id value int(11) smallint(8) smallint(5) int(10) int(11) identity not null not null not null not null customer_entity_text value_id entity_type_id attribute_id entity_id value int(11) smallint(8) smallint(5) int(10) text identity not null not null not null not null customer_entity_varchar value_id entity_type_id attribute_id entity_id value int(11) smallint(8) smallint(5) int(10) varchar(255) identity not null not null not null not null catalog_category_entity_datetime value_id entity_type_id attribute_id store_id entity_id value int(11) smallint(5) smallint(5) smallint(5) int(10) datetime identity not null not null not null not null not null catalog_category_entity_int value_id entity_type_id attribute_id store_id entity_id value int(11) smallint(5) smallint(5) smallint(5) int(10) int(11) identity not null not null not null not null not null catalog_category_entity_text value_id entity_type_id attribute_id store_id entity_id value int(11) smallint(5) smallint(5) smallint(5) int(10) text identity not null not null not null not null not null catalog_category_entity_decimal value_id entity_type_id attribute_id store_id entity_id value int(11) smallint(5) smallint(5) smallint(5) int(10) decimal(12,4) identity not null not null not null not null not null catalog_category_entity_varchar value_id entity_type_id attribute_id store_id entity_id value int(11) smallint(5) smallint(5) smallint(5) int(10) varchar(255) identity not null not null not null not null not null catalog_product_entity_datetime value_id entity_type_id attribute_id store_id entity_id value int(11) smallint(5) smallint(5) smallint(5) int(10) datetime identity not null not null not null not null not null catalog_product_entity_decimal value_id entity_type_id attribute_id store_id entity_id value int(11) smallint(5) smallint(5) smallint(5) int(10) decimal(12,4) identity not null not null not null not null not null catalog_product_entity_int value_id entity_type_id attribute_id store_id entity_id value int(11) mediumint(8) smallint(5) smallint(5) int(10) int(11) identity not null not null not null not null not null catalog_product_entity_text value_id entity_type_id attribute_id store_id entity_id value int(11) mediumint(8) smallint(5) smallint(5) int(10) text identity not null not null not null not null not null catalog_product_entity_varchar value_id entity_type_id attribute_id store_id entity_id value int(11) mediumint(8) smallint(5) smallint(5) int(10) varchar(255) identity not null not null not null not null not null catalog_product_link_attribute product_link_attribute_id link_type_id product_link_attribute_code data_type smallint(6) tinyint(3) varchar(32) varchar(32) identity not null not null not null catalog_product_link_attribute_decimal value_id product_link_attribute_id link_id value int(11) smallint(6) int(11) decimal(12,4) identity null null not null catalog_product_link_attribute_int value_id product_link_attribute_id link_id value int(11) smallint(6) int(11) int(11) identity null null not null catalog_product_link_attribute_varchar value_id product_link_attribute_id link_id value int(11) smallint(6) int(11) varchar(255) identity not null null not null catalogindex_minimal_price index_id store_id entity_id customer_group_id qty value tax_class_id int(10) smallint(5) int(10) smallint(3) decimal(12,4) decimal(12,4) smallint(6) identity not null not null not null not null not null not null review_store review_id store_id bigint(20) smallint(5) not null not null review_entity entity_id entity_code smallint(5) varchar(32) identity not null review_entity_summary primary_id entity_pk_value entity_type reviews_count rating_summary store_id bigint(20) bigint(20) tinyint(4) smallint(6) tinyint(4) smallint(5) identity not null not null not null not null not null review_status status_id status_code tinyint(3) varchar(32) identity not null review_detail detail_id review_id store_id title detail nickname customer_id bigint(20) bigint(20) smallint(5) varchar(255) text varchar(128) int(10) identity not null null not null not null not null null review review_id created_at entity_id entity_pk_value status_id bigint(20) datetime smallint(5) int(10) tinyint(3) identity not null not null not null not null catalog_product_super_link link_id product_id parent_id int(10) int(10) int(10) identity not null not nullcatalog_product_link_type link_type_id code tinyint(3) varchar(32) identity not null catalog_product_link link_id product_id linked_product_id link_type_id int(11) int(10) int(10) tinyint(3) identity not null not null not null cataloginventory_stock stock_id stock_name smallint(4) varchar(255) identity not null cataloginventory_stock_item item_id product_id stock_id qty min_qty use_config_min_qty is_qty_decimal backorders use_config_backorders min_sale_qty use_config_min_sale_qty max_sale_qty use_config_max_sale_qty is_in_stock low_stock_date notify_stock_qty use_config_notify_stock_qty manage_stock use_config_manage_stock int(10) int(10) smallint(4) decimal(12,4) decimal(12,4) tinyint(1) tinyint(1) tinyint(3) tinyint(1) decimal(12,4) tinyint(1) decimal(12,4) tinyint(1) tinyint(1) datetime decimal(12,4) tinyint(1) tinyint(1) tinyint(1) identity not null not null not null not null not null not null not null not null not null not null not null not null not null null null not null not null not null eav_entity_type entity_type_id entity_type_code entity_model attribute_model entity_table value_table_prefix entity_id_field is_data_sharing data_sharing_key default_attribute_set_id increment_model increment_per_store increment_pad_length increment_pad_char smallint(5) varchar(50) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) tinyint(4) varchar(100) smallint(5) varchar(255) tinyint(1) tinyint(8) char(1) identity not null not null not null not null not null not null not null null not null not null not null not null not null core_store store_id code website_id group_id name sort_order is_active smallint(5) varchar(32) smallint(5) smallint(5) varchar(32) smallint(5) tinyint(1) identity not null null not null not null not null not null core_website website_id code name sort_order default_group_id is_default smallint(5) varchar(32) varchar(64) smallint(5) smallint(5) tinyint(1) identity not null not null not null not null null customer_entity entity_id entity_type_id attribute_set_id website_id email group_id increment_id store_id created_at updated_at is_active int(10) smallint(8) smallint(5) smallint(5) varchar(255) smallint(3) varchar(50) smallint(5) datetime datetime tinyint(1) identity not null not null null not null not null not null null not null not null not null catalog_product_entity entity_id entity_type_id attribute_set_id type_id sku category_ids created_at updated_at has_options int(10) smallint(8) smallint(5) varchar(32) varchar(64) text datetime datetime smallint(1) identity not null not null not null null null not null not null not null catalog_category_entity entity_id entity_type_id attribute_set_id parent_id created_at updated_at path position level children_count int(10) smallint(8) smallint(5) int(10) datetime datetime varchar(255) int(11) int(11) int(11) identity not null not null not null not null not null not null not null not null not null eav_attribute attribute_id entity_type_id attribute_code attribute_model backend_model backend_type backend_table frontend_model frontend_input frontend_label frontend_class source_model is_global is_visible is_required is_user_defined default_value is_searchable is_filterable is_comparable is_visible_on_front is_unique is_configurable apply_to position note is_visible_in_advanced_search is_used_for_price_rules smallint(5) smallint(5) varchar(255) varchar(255) varchar(255) enum('static','datetime','decimal','int','text','varchar') varchar(255) varchar(255) varchar(50) varchar(255) varchar(255) varchar(255) tinyint(1) tinyint(1) tinyint(1) tinyint(1) text tinyint(1) tinyint(1) tinyint(1) tinyint(1) tinyint(1) tinyint(1) varchar(255) int(11) varchar(255) tinyint(1) tinyint(1) identity not null not null null null not null null null null null null null not null not null not null not null null not null not null not null not null not null not null not null not null not null not null not null sales_order_entity entity_id entity_type_id attribute_set_id increment_id parent_id store_id created_at updated_at is_active int(10) smallint(8) smallint(5) varchar(50) int(10) smallint(5) datetime datetime tinyint(1) identity not null not null not null not null null not null not null not null sales_order_entity_datetime value_id entity_type_id attribute_id entity_id value int(11) smallint(5) smallint(5) int(10) datetime identity not null not null not null not null sales_order_entity_decimal value_id entity_type_id attribute_id entity_id value int(11) smallint(5) smallint(5) int(10) decimal(12,4) identity not null not null not null not null sales_order_entity_int value_id entity_type_id attribute_id entity_id value int(11) smallint(5) smallint(5) int(10) int(11) identity not null not null not null not null sales_order_entity_text value_id entity_type_id attribute_id entity_id value int(11) smallint(5) smallint(5) int(10) text identity not null not null not null not null sales_order_entity_varchar value_id entity_type_id attribute_id entity_id value int(11) smallint(5) smallint(5) int(10) varchar(255) identity not null not null not null not null sales_flat_quote_shipping_rate rate_id address_id created_at updated_at carrier carrier_title code method method_description price parent_id error_message method_title int(10) int(10) datetime datetime varchar(255) varchar(255) varchar(255) varchar(255) text decimal(12,4) varchar(255) varchar(255) varchar(255) identity not null not null not null null null null null null not null null null null sales_flat_quote_payment payment_id quote_id created_at updated_at method cc_type cc_number_enc cc_last4 cc_cid_enc cc_owner cc_exp_month cc_exp_year cc_ss_owner cc_ss_start_month cc_ss_start_year cybersource_token paypal_correlation_id paypal_payer_id paypal_payer_status po_number parent_id additional_data cc_ss_issue int(10) int(10) datetime datetime varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) tinyint(2) smallint(4) varchar(255) tinyint(2) smallint(4) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) identity not null not null not null null null null null null null null null null null null null null null null null null null null catalog_product_option_type_value option_type_id option_id sku sort_order int(10) int(10) varchar(64) int(10) identity not null not null not null catalog_product_option_type_title option_type_title_id option_type_id store_id title int(10) int(10) smallint(5) varchar(50) identity not null not null not null catalog_product_option_type_price option_type_price_id option_type_id store_id price price_type int(10) int(10) smallint(5) decimal(12,4) enum('fixed','percent') identity not null not null not null not null catalog_product_option_title option_title_id option_id store_id title int(10) int(10) smallint(5) varchar(50) identity not null not null not null catalog_product_option_price option_price_id option_id store_id price price_type int(10) int(10) smallint(5) decimal(12,4) enum('fixed','percent') identity not null not null not null not null catalog_product_option option_id product_id type is_require sku max_characters file_extension sort_order int(10) int(10) varchar(50) tinyint(1) varchar(64) int(10) varchar(50) int(10) identity not null not null not null not null null null not null adminnotification_inbox notification_id severity date_added title description url is_read is_remove int(10) tinyint(3) datetime varchar(255) text varchar(255) tinyint(1) tinyint(1) identity not null not null not null null not null not null not null log_quote quote_id visitor_id created_at deleted_at int(10) bigint(20) datetime datetime not null null not null null sendfriend_log log_id ip time int(11) int(11) int(11) identity not null not null api_user user_id firstname lastname email username api_key created modified logdate lognum sessid reload_acl_flag is_active mediumint(9) varchar(32) varchar(32) varchar(128) varchar(40) varchar(40) datetime datetime datetime smallint(5) varchar(40) tinyint(1) tinyint(1) identity not null not null not null not null not null not null null null not null not null not null not null api_rule rule_id role_id resource_id privileges assert_id role_type permission int(10) int(10) varchar(255) varchar(20) int(10) char(1) varchar(10) identity not null not null not null not null null null api_role role_id parent_id tree_level sort_order role_type user_id role_name int(10) int(10) tinyint(3) tinyint(3) char(1) int(11) varchar(50) identity not null not null not null not null not null not null api_assert assert_id assert_type assert_data int(10) varchar(20) text identity not null null dataflow_import_data import_id session_id serial_number value status int(11) int(11) int(11) text int(1) identity null not null null not null dataflow_session session_id user_id created_date file type direction comment int(11) int(11) datetime varchar(255) varchar(32) varchar(32) varchar(255) identity not null null null null null null dataflow_profile profile_id name created_at updated_at actions_xml gui_data direction entity_type store_id data_transfer int(10) varchar(255) datetime datetime text text enum('import','export') varchar(64) smallint(5) enum('file','interactive') identity not null not null not null null null null not null not null null dataflow_profile_history history_id profile_id action_code user_id performed_at int(10) int(10) varchar(64) int(10) datetime identity not null null not null null dataflow_batch batch_id profile_id store_id adapter params created_at int(10) int(10) smallint(5) varchar(128) text datetime identity not null not null null null null report_event event_id logged_at event_type_id object_id subject_id subtype store_id bigint(20) datetime smallint(6) int(10) int(10) tinyint(3) smallint(5) identity not null not null not null not null not null not null report_event_types event_type_id event_name customer_login smallint(6) varchar(64) tinyint(3) identity not null not null directory_country_region_name locale region_id name varchar(8) mediumint(8) varchar(64) not null not null not null directory_country_region region_id country_id code default_name mediumint(8) varchar(4) varchar(32) varchar(255) identity not null not null null directory_country country_id iso2_code iso3_code varchar(2) varchar(2) varchar(3) not null not null not null directory_currency_rate currency_from currency_to rate char(3) char(3) decimal(24,12) not null not null not null directory_country_format country_format_id country_id type format int(10) varchar(2) varchar(30) text identity not null not null not null gift_message gift_message_id customer_id sender recipient message int(7) int(7) varchar(255) varchar(255) text identity not null not null not null not null shipping_tablerate pk website_id dest_country_id dest_region_id dest_zip condition_name condition_value price cost int(10) int(11) varchar(4) int(10) varchar(10) varchar(20) decimal(12,4) decimal(12,4) decimal(12,4) identity not null not null not null not null not null not null not null not null tax_class class_id class_name class_type smallint(6) varchar(255) enum('customer','product') identity not null not null paygate_authorizenet_debug debug_id request_body response_body request_serialized result_serialized request_dump result_dump int(10) text text text text text text identity null null null null null null paypaluk_api_debug debug_id debug_at request_body response_body int(10) timestamp text text identity not null null null googlecheckout_api_debug debug_id dir url request_body response_body int(10) enum('in','out') varchar(255) text text identity null null null null tax_calculation_rule tax_calculation_rule_id code priority position int(11) varchar(255) mediumint(9) mediumint(9) identity not null not null not null tax_calculation_rate_title tax_calculation_rate_title_id tax_calculation_rate_id store_id value int(11) int(11) smallint(5) varchar(255) identity not null not null not null tax_calculation_rate tax_calculation_rate_id tax_country_id tax_region_id tax_postcode code rate int(11) char(2) mediumint(9) varchar(12) varchar(255) decimal(12,4) identity not null not null not null not null not null tax_calculation tax_calculation_rate_id tax_calculation_rule_id customer_tax_class_id product_tax_class_id int(11) int(11) smallint(6) smallint(6) not null not null not null not null checkout_agreement_store agreement_id store_id int(10) smallint(5) not null not null checkout_agreement agreement_id name content content_height checkbox_text is_active int(10) varchar(255) text varchar(25) text tinyint(4) identity not null not null null not null not null sales_order_tax tax_id order_id code title percent amount priority position base_amount process base_real_amount int(10) int(10) varchar(255) varchar(255) decimal(12,4) decimal(12,4) int(11) int(11) decimal(12,4) smallint(6) decimal(12,4) identity not null not null not null not null not null not null not null not null not null not null sales_flat_quote_address address_id quote_id created_at updated_at customer_id save_in_address_book customer_address_id address_type email prefix firstname middlename lastname suffix company street city region region_id postcode country_id telephone fax same_as_billing free_shipping collect_shipping_rates shipping_method shipping_description weight subtotal base_subtotal subtotal_with_discount base_subtotal_with_discount tax_amount base_tax_amount shipping_amount base_shipping_amount shipping_tax_amount base_shipping_tax_amount discount_amount base_discount_amount grand_total base_grand_total customer_notes entity_id parent_id custbalance_amount base_custbalance_amount applied_taxes gift_message_id int(10) int(10) datetime datetime int(10) tinyint(1) int(10) varchar(255) varchar(255) varchar(40) varchar(255) varchar(40) varchar(255) varchar(40) varchar(255) varchar(255) varchar(255) varchar(255) int(10) varchar(255) varchar(255) varchar(255) varchar(255) tinyint(1) tinyint(1) tinyint(1) varchar(255) varchar(255) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) text varchar(255) varchar(255) varchar(255) varchar(255) text varchar(255) identity not null not null not null null null null null null null null null null null null null null null null null null null null not null not null not null not null not null not null not null not null not null not null not null not null not null not null null null not null not null not null not null null null null null null null null sales_flat_quote entity_id store_id created_at updated_at converted_at is_active is_virtual is_multi_shipping items_count items_qty orig_order_id store_to_base_rate store_to_quote_rate base_currency_code store_currency_code quote_currency_code grand_total base_grand_total checkout_method customer_id customer_tax_class_id customer_group_id customer_email customer_prefix customer_firstname customer_middlename customer_lastname customer_suffix customer_dob customer_note customer_note_notify customer_is_guest remote_ip applied_rule_ids reserved_order_id password_hash coupon_code quote_status_id billing_address_id custbalance_amount is_multi_payment customer_taxvat subtotal base_subtotal subtotal_with_discount base_subtotal_with_discount is_changed gift_message_id int(10) smallint(5) datetime datetime datetime tinyint(1) tinyint(1) tinyint(1) int(10) decimal(12,4) int(10) decimal(12,4) decimal(12,4) varchar(255) varchar(255) varchar(255) decimal(12,4) decimal(12,4) varchar(255) int(10) int(10) int(10) varchar(255) varchar(40) varchar(255) varchar(40) varchar(255) varchar(40) datetime varchar(255) tinyint(1) tinyint(1) varchar(32) varchar(255) varchar(64) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) identity not null not null not null not null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null paypal_api_debug debug_id debug_at request_body response_body int(10) timestamp text text identity not null null null catalog_compare_item catalog_compare_item_id visitor_id customer_id product_id int(11) int(11) int(11) int(11) identity not null null not null catalogsearch_query query_id query_text num_results popularity redirect synonim_for store_id display_in_terms updated_at int(10) varchar(255) int(10) int(10) varchar(255) varchar(255) smallint(5) tinyint(1) datetime identity not null not null not null not null not null not null not null not null tag tag_id name status int(11) varchar(255) smallint(6) identity not null not null tag_relation tag_relation_id tag_id customer_id product_id store_id active created_at int(11) int(11) int(10) int(11) smallint(6) tinyint(1) datetime identity not null not null not null not null not null null tag_summary tag_id store_id customers products uses historical_uses popularity int(11) smallint(5) int(11) int(11) int(11) int(11) int(11) not null not null not null not null not null not null not null dataflow_batch_export batch_export_id batch_id batch_data status bigint(20) int(10) longtext tinyint(3) identity not null null not null dataflow_batch_import batch_import_id batch_id batch_data status bigint(20) int(10) longtext tinyint(3) identity not null null not null catalog_category_product category_id product_id position int(10) int(10) int(10) not null not null not null catalog_category_product_index category_id product_id position is_parent int(10) int(10) int(10) tinyint(1) not null not null not null not null catalog_product_entity_tier_price value_id entity_id all_groups customer_group_id qty value website_id int(11) int(10) tinyint(1) smallint(5) decimal(12,4) decimal(12,4) smallint(5) identity not null not null not null not null not null not null catalog_product_website product_id website_id int(10) smallint(5) identity not null catalog_product_enabled_index product_id store_id visibility int(10) smallint(5) smallint(5) not null not null not null catalog_product_bundle_option option_id parent_id required position type int(10) int(10) tinyint(1) int(10) varchar(255) identity not null not null not null not null catalog_product_bundle_option_value value_id option_id store_id title int(10) int(10) smallint(5) varchar(255) identity not null not null not null catalog_product_bundle_selection selection_id option_id parent_product_id product_id position is_default selection_price_type selection_price_value selection_qty selection_can_change_qty int(10) int(10) int(10) int(10) int(10) tinyint(1) tinyint(1) decimal(12,4) decimal(12,4) tinyint(1) identity not null not null not null not null not null not null not null not null not null catalog_product_super_attribute product_super_attribute_id product_id attribute_id position int(10) int(10) smallint(5) smallint(5) identity not null not null not null catalog_product_super_attribute_label value_id product_super_attribute_id store_id value int(10) int(10) smallint(5) varchar(255) identity not null not null not null catalog_product_super_attribute_pricing value_id product_super_attribute_id value_index is_percent pricing_value int(10) int(10) varchar(255) tinyint(1) decimal(10,4) identity not null not null null null sales_order entity_id entity_type_id attribute_set_id increment_id parent_id store_id created_at updated_at is_active customer_id tax_amount shipping_amount discount_amount subtotal grand_total total_paid total_refunded total_qty_ordered total_canceled total_invoiced total_online_refunded total_offline_refunded base_tax_amount base_shipping_amount base_discount_amount base_subtotal base_grand_total base_total_paid base_total_refunded base_total_qty_ordered base_total_canceled base_total_invoiced base_total_online_refunded base_total_offline_refunded subtotal_refunded subtotal_canceled tax_refunded tax_canceled shipping_refunded shipping_canceled base_subtotal_refunded base_subtotal_canceled base_tax_refunded base_tax_canceled base_shipping_refunded base_shipping_canceled subtotal_invoiced tax_invoiced shipping_invoiced base_subtotal_invoiced base_tax_invoiced base_shipping_invoiced shipping_tax_amount base_shipping_tax_amount int(10) smallint(5) smallint(5) varchar(50) int(10) smallint(5) datetime datetime tinyint(1) int(11) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) identity not null not null not null not null null not null not null not null null not null not null not null not null not null not null not null not null not null not null not null not null not null not null not null not null not null not null not null not null not null not null not null not null null null null null null null null null null null null null null null null null null null null null sales_flat_order_item item_id order_id parent_item_id quote_item_id created_at updated_at product_id product_type product_options weight is_virtual sku name description applied_rule_ids additional_data free_shipping is_qty_decimal no_discount qty_backordered qty_canceled qty_invoiced qty_ordered qty_refunded qty_shipped cost price base_price original_price base_original_price tax_percent tax_amount base_tax_amount tax_invoiced base_tax_invoiced discount_percent discount_amount base_discount_amount discount_invoiced base_discount_invoiced amount_refunded base_amount_refunded row_total base_row_total row_invoiced base_row_invoiced row_weight gift_message_id gift_message_available base_tax_before_discount tax_before_discount int(10) int(10) int(10) int(10) datetime datetime int(10) varchar(255) text decimal(12,4) tinyint(1) varchar(255) varchar(255) text text text tinyint(1) tinyint(1) tinyint(1) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) int(10) int(10) varchar(255) varchar(255) identity not null null null not null not null null null null null null not null null null null null not null null null null null null null null null null not null not null null null null null null null null null null null null null null null not null not null not null not null null null null null null sales_flat_quote_item_option option_id item_id product_id code value int(10) int(10) int(10) varchar(255) text identity not null not null not null not null sales_flat_quote_item item_id quote_id created_at updated_at product_id parent_item_id is_virtual sku name description applied_rule_ids additional_data free_shipping is_qty_decimal no_discount weight qty price base_price custom_price discount_percent discount_amount base_discount_amount tax_percent tax_amount base_tax_amount row_total base_row_total row_total_with_discount row_weight parent_id product_type base_tax_before_discount tax_before_discount original_custom_price gift_message_id int(10) int(10) datetime datetime int(10) int(10) tinyint(1) varchar(255) varchar(255) text text text tinyint(1) tinyint(1) tinyint(1) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) identity not null not null not null null null null not null null null null null not null null null null not null not null not null null null null null null null null not null not null null null null null null null null null sales_flat_quote_address_item address_item_id parent_item_id quote_address_id quote_item_id created_at updated_at applied_rule_ids additional_data weight qty discount_amount tax_amount row_total base_row_total row_total_with_discount base_discount_amount base_tax_amount row_weight parent_id product_id super_product_id parent_product_id sku image name description free_shipping is_qty_decimal price discount_percent no_discount tax_percent base_price gift_message_id int(10) int(10) int(10) int(10) datetime datetime text text decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) decimal(12,4) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) identity null not null not null not null not null null null null not null null null not null not null null null null null null null null null null null null null null null null null null null null null core_flag flag_id flag_code state flag_data last_update smallint(5) varchar(255) smallint(5) text datetime identity not null not null null not null New Tables [v1.0 to v1.1.x]

下载文档,方便阅读与编辑

文档的实际排版效果,会与网站的显示效果略有不同!!

需要 10 金币 [ 分享文档获得金币 ] 0 人已下载

下载文档

相关文档