Ecshop273数据库表结构说明.docx

Ecshop 数据库表结构说明- 商城广告表 ecs_adDROP TABLE IF EXISTS ecs_ad;CREATE TABLE ecs_ad ( ad_id smallint(5) unsigned NOT NULL auto_increment, position_id smallint unsigned NOT NULL default 0, media_type tinyint(3) unsigned NOT NULL default 0, ad_name varchar(60) NOT NULL default , ad_link varchar(255) NOT NULL default , ad_code text NOT NULL, start_time int(11) NOT NULL default 0, end_time int(11) NOT NULL default 0, link_man varchar(60) NOT NULL default , link_email varchar(60) NOT NULL default , link_phone varchar(60) NOT NULL default , click_count mediumint(8) unsigned NOT NULL default 0, enabled tinyint(3) unsigned NOT NULL default 1, PRIMARY KEY (ad_id), KEY position_id (position_id), KEY enabled (enabled) TYPE=MyISAM;- 广告位置表 ecs_ad_positionDROP TABLE IF EXISTS ecs_ad_position;CREATE TABLE ecs_ad_position ( position_id tinyint(3) unsigned NOT NULL auto_increment, position_name varchar(60) NOT NULL default , ad_width smallint(5) unsigned NOT NULL default 0, ad_height smallint(5) unsigned NOT NULL default 0, position_desc varchar(255) NOT NULL default , position_style text NOT NULL, PRIMARY KEY (position_id) TYPE=MyISAM;- 管理员权限分配表 ecs_admin_actionDROP TABLE IF EXISTS ecs_admin_action;CREATE TABLE ecs_admin_action ( action_id tinyint(3) unsigned NOT NULL auto_increment, parent_id tinyint(3) unsigned NOT NULL default 0, action_code varchar(20) NOT NULL default , relevance varchar(20) NOT NULL default , PRIMARY KEY (action_id), KEY parent_id (parent_id) TYPE=MyISAM;- 管理员日志表 ecs_admin_logDROP TABLE IF EXISTS ecs_admin_log;CREATE TABLE ecs_admin_log ( log_id int(10) unsigned NOT NULL auto_increment, log_time int(10) unsigned NOT NULL default 0, user_id tinyint(3) unsigned NOT NULL default 0, log_info varchar(255) NOT NULL default , ip_address varchar(15) NOT NULL default , PRIMARY KEY (log_id), KEY log_time (log_time), KEY user_id (user_id) TYPE=MyISAM;- 管理员留言表 ecs_admin_messageDROP TABLE IF EXISTS ecs_admin_message;CREATE TABLE ecs_admin_message ( message_id smallint(5) unsigned NOT NULL auto_increment, sender_id tinyint(3) unsigned NOT NULL default 0, receiver_id tinyint(3) unsigned NOT NULL default 0, sent_time int(11) unsigned NOT NULL default 0, read_time int(11) unsigned NOT NULL default 0, readed tinyint(1) unsigned NOT NULL default 0, deleted tinyint(1) unsigned NOT NULL default 0, title varchar(150) NOT NULL default , message text NOT NULL, PRIMARY KEY (message_id), KEY sender_id (sender_id,receiver_id), KEY receiver_id (receiver_id) TYPE=MyISAM;- 管理员用户表 ecs_admin_userDROP TABLE IF EXISTS ecs_admin_user;CREATE TABLE ecs_admin_user ( user_id smallint(5) unsigned NOT NULL auto_increment, user_name varchar(60) NOT NULL default , email varchar(60) NOT NULL default , password varchar(32) NOT NULL default , ec_salt VARCHAR( 10 ) NULL, add_time int(11) NOT NULL default 0, last_login int(11) NOT NULL default 0, last_ip varchar(15) NOT NULL default , action_list text NOT NULL, nav_list text NOT NULL, lang_type varchar(50) NOT NULL default , agency_id smallint(5) unsigned NOT NULL, suppliers_id smallint(5) unsigned default 0, todolist LONGTEXT NULL, role_id smallint(5) default NULL, PRIMARY KEY (user_id), KEY user_name (user_name), KEY agency_id (agency_id) TYPE=MyISAM;- 广告相关统计表 ecs_adsenseDROP TABLE IF EXISTS ecs_adsense;CREATE TABLE ecs_adsense ( from_ad smallint(5) NOT NULL default 0, referer varchar(255) NOT NULL default , clicks int(10) unsigned NOT NULL default 0, KEY from_ad (from_ad) TYPE=MyISAM;- 配送区域表 ecs_area_regionDROP TABLE IF EXISTS ecs_area_region;CREATE TABLE ecs_area_region ( shipping_area_id smallint(5) unsigned NOT NULL default 0, region_id smallint(5) unsigned NOT NULL default 0, PRIMARY KEY (shipping_area_id,region_id) TYPE=MyISAM;- 商城文章表 ecs_articleDROP TABLE IF EXISTS ecs_article;CREATE TABLE ecs_article ( article_id mediumint(8) unsigned NOT NULL auto_increment, cat_id smallint(5) NOT NULL default 0, title varchar(150) NOT NULL default , content longtext NOT NULL, author varchar(30) NOT NULL default , author_email varchar(60) NOT NULL default , keywords varchar(255) NOT NULL default , article_type tinyint(1) unsigned NOT NULL default 2, is_open tinyint(1) unsigned NOT NULL default 1, add_time int(10) unsigned NOT NULL default 0, file_url varchar(255) NOT NULL default , open_type tinyint(1) unsigned NOT NULL default 0, link varchar(255) NOT NULL default , description varchar(255) default NULL, PRIMARY KEY (article_id), KEY cat_id (cat_id) TYPE=MyISAM;- 文章分类表 ecs_article_catDROP TABLE IF EXISTS ecs_article_cat;CREATE TABLE ecs_article_cat ( cat_id smallint(5) NOT NULL auto_increment, cat_name varchar(255) NOT NULL default , cat_type tinyint(1) unsigned NOT NULL default 1, keywords varchar(255) NOT NULL default , cat_desc varchar(255) NOT NULL default , sort_order tinyint(3) unsigned NOT NULL default 50, show_in_nav tinyint(1) unsigned NOT NULL default 0, parent_id smallint(5) unsigned NOT NULL default 0, PRIMARY KEY (cat_id), KEY cat_type (cat_type), KEY sort_order (sort_order), KEY parent_id (parent_id) TYPE=MyISAM;- 商品属性表 ecs_attributeDROP TABLE IF EXISTS ecs_attribute;CREATE TABLE ecs_attribute ( attr_id smallint(5) unsigned NOT NULL auto_increment, cat_id smallint(5) unsigned NOT NULL default 0, attr_name varchar(60) NOT NULL default , attr_input_type tinyint(1) unsigned NOT NULL default 1, attr_type tinyint(1) unsigned NOT NULL default 1, attr_values text NOT NULL, attr_index tinyint(1) unsigned NOT NULL default 0, sort_order tinyint(3) unsigned NOT NULL default 0, is_linked tinyint(1) unsigned NOT NULL default 0, attr_group tinyint( 1 ) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (attr_id), KEY cat_id (cat_id) TYPE=MyISAM;- 红包相关表 ecs_bonus_typeDROP TABLE IF EXISTS ecs_bonus_type;CREATE TABLE ecs_bonus_type ( type_id smallint unsigned NOT NULL auto_increment, type_name varchar(60) NOT NULL default , type_money decimal(10,2) NOT NULL default 0.00, send_type tinyint(3) unsigned NOT NULL default 0, min_amount decimal(10,2) unsigned NOT NULL default 0.00, max_amount decimal(10,2) unsigned NOT NULL default 0.00, send_start_date int(11) NOT NULL default 0, send_end_date int(11) NOT NULL default 0, use_start_date int(11) NOT NULL default 0, use_end_date int(11) NOT NULL default 0, min_goods_amount decimal(10,2) unsigned NOT NULL default 0.00, PRIMARY KEY (type_id) TYPE=MyISAM;- 缺货登记表 ecs_booking_goodsDROP TABLE IF EXISTS ecs_booking_goods;CREATE TABLE ecs_booking_goods ( rec_id mediumint(8) unsigned NOT NULL auto_increment, user_id mediumint(8) unsigned NOT NULL default 0, email varchar(60) NOT NULL default , link_man varchar(60) NOT NULL default , tel varchar(60) NOT NULL default , goods_id mediumint(8) unsigned NOT NULL default 0, goods_desc varchar(255) NOT NULL default , goods_number smallint(5) unsigned NOT NULL default 0, booking_time int(10) unsigned NOT NULL default 0, is_dispose tinyint(1) unsigned NOT NULL default 0, dispose_user varchar(30) NOT NULL default , dispose_time int(10) unsigned NOT NULL default 0, dispose_note varchar(255) NOT NULL default , PRIMARY KEY (rec_id), KEY user_id (user_id) TYPE=MyISAM;- 商品品牌表 ecs_brandDROP TABLE IF EXISTS ecs_brand;CREATE TABLE ecs_brand ( brand_id smallint(5) unsigned NOT NULL auto_increment, brand_name varchar(60) NOT NULL default , brand_logo varchar(80) NOT NULL default , brand_desc text NOT NULL, site_url varchar(255) NOT NULL default , sort_order tinyint(3) unsigned NOT NULL default 50, is_show tinyint( 1 ) unsigned NOT NULL default 1, PRIMARY KEY (brand_id), KEY is_show (is_show) TYPE=MyISAM;- 贺卡表 ecs_cardDROP TABLE IF EXISTS ecs_card;CREATE TABLE ecs_card ( card_id tinyint(3) unsigned NOT NULL auto_increment, card_name varchar(120) NOT NULL default , card_img varchar(255) NOT NULL default , card_fee decimal(6,2) unsigned NOT NULL default 0.00, free_money decimal(6,2) unsigned NOT NULL default 0.00, card_desc varchar(255) NOT NULL default , PRIMARY KEY (card_id) TYPE=MyISAM;- 购物车表 ecs_cartDROP TABLE IF EXISTS ecs_cart;CREATE TABLE ecs_cart ( rec_id mediumint(8) unsigned NOT NULL auto_increment, user_id mediumint(8) unsigned NOT NULL default 0, session_id char(32) binary NOT NULL default , goods_id mediumint(8) unsigned NOT NULL default 0, goods_sn varchar(60) NOT NULL default , product_id mediumint(8) unsigned NOT NULL default 0, goods_name varchar(120) NOT NULL default , market_price decimal(10,2) unsigned NOT NULL default 0.00, goods_price decimal(10,2) NOT NULL default 0.00, goods_number smallint(5) unsigned NOT NULL default 0, goods_attr text NOT NULL, is_real tinyint(1) unsigned NOT NULL default 0, extension_code varchar(30) NOT NULL default , parent_id mediumint(8) unsigned NOT NULL default 0, rec_type tinyint(1) unsigned NOT NULL default 0, is_gift smallint unsigned NOT NULL default 0, is_shipping tinyint(1) unsigned NOT NULL default 0, can_handsel tinyint(3) unsigned NOT NULL default 0, goods_attr_id varchar(255) NOT NULL default , PRIMARY KEY (rec_id), KEY session_id (session_id) TYPE=MyISAM;- 商品分类表 ecs_categoryDROP TABLE IF EXISTS ecs_category;CREATE TABLE ecs_category ( cat_id smallint(5) unsigned NOT NULL auto_increment, cat_name varchar(90) NOT NULL default , keywords varchar(255) NOT NULL default , cat_desc varchar(255) NOT NULL default , parent_id smallint(5) unsigned NOT NULL default 0, sort_order tinyint(1) unsigned NOT NULL default 50, template_file varchar(50) NOT NULL default , measure_unit varchar(15) NOT NULL default , show_in_nav tinyint(1) NOT NULL default 0, style varchar( 150 ) NOT NULL, is_show tinyint(1) unsigned NOT NULL default 1, grade tinyint(4) NOT NULL default 0, filter_attr varchar(255) NOT NULL default 0, PRIMARY KEY (cat_id), KEY parent_id (parent_id) TYPE=MyISAM;- 商品收藏表 ecs_collect_goodsDROP TABLE IF EXISTS ecs_collect_goods;CREATE TABLE ecs_collect_goods ( rec_id mediumint(8) unsigned NOT NULL auto_increment, user_id mediumint(8) unsigned NOT NULL default 0, goods_id mediumint(8) unsigned NOT NULL default 0, add_time int(11) unsigned NOT NULL default 0, is_attention TINYINT( 1 ) NOT NULL DEFAULT 0, PRIMARY KEY (rec_id), KEY user_id (user_id), KEY goods_id (goods_id), KEY is_attention (is_attention) TYPE=MyISAM;- 商品评价表 ecs_commentDROP TABLE IF EXISTS ecs_comment;CREATE TABLE ecs_comment ( comment_id int(10) unsigned NOT NULL auto_increment, comment_type tinyint(3) unsigned NOT NULL default 0, id_value mediumint(8) unsigned NOT NULL default 0, email varchar(60) NOT NULL default , user_name varchar(60) NOT NULL default , content text NOT NULL, comment_rank tinyint(1) unsigned NOT NULL default 0, add_time int(10) unsigned NOT NULL default 0, ip_address varchar(15) NOT NULL default , status tinyint(3) unsigned NOT NULL default 0, parent_id int(10) unsigned NOT NULL default 0, user_id int(10) unsigned NOT NULL default 0, PRIMARY KEY (comment_id), KEY parent_id (parent_id), KEY id_value (id_value) TYPE=MyISAM;- - 表的结构 ecs_crons-DROP TABLE IF EXISTS ecs_crons;CREATE TABLE ecs_crons ( cron_id tinyint(3) unsigned NOT NULL auto_increment, cron_code varchar(20) NOT NULL, cron_name varchar(120) NOT NULL, cron_desc text, cron_order tinyint(3) unsigned NOT NULL default 0, cron_config text NOT NULL, thistime int(10) NOT NULL default 0, nextime int(10) NOT NULL, day tinyint(2) NOT NULL, week varchar(1) NOT NULL, hour varchar(2) NOT NULL, minute varchar(255) NOT NULL, enable tinyint(1) NOT NULL default 1, run_once tinyint(1) NOT NULL default 0, allow_ip varchar(100) NOT NULL default , alow_files varchar(255) NOT NULL, PRIMARY KEY (cron_id), KEY nextime (nextime), KEY enable (enable), KEY cron_code (cron_code) TYPE=MyISAM;- - 表的结构 ecs_error_log-DROP TABLE IF EXISTS ecs_error_log;CREATE TABLE ecs_error_log ( id int(10) NOT NULL auto_increment, info varchar(255) NOT NULL, file varchar(100) NOT NULL, time int(10) NOT NULL, PRIMARY KEY (id), KEY time (time) TYPE=MyISAM;- 用户留言表 ecs_feedbackDROP TABLE IF EXISTS ecs_feedback;CREATE TABLE ecs_feedback ( msg_id mediumint(8) unsigned NOT NULL auto_increment, parent_id mediumint(8) unsigned NOT NULL default 0, user_id mediumint(8) unsigned NOT NULL default 0, user_name varchar(60) NOT NULL default , user_email varchar(60) NOT NULL default , msg_title varchar(200) NOT NULL default , msg_type tinyint(1) unsigned NOT NULL default 0, msg_status tinyint( 1 ) unsigned NOT NULL DEFAULT 0, msg_content text NOT NULL, msg_time int(10) unsigned NOT NULL default 0, message_img varchar(255) NOT NULL default 0, order_id int(11) unsigned NOT NULL default 0, msg_area TINYINT(1) unsigned NOT NULL default 0, PRIMARY KEY (msg_id), KEY user_id (user_id) TYPE=MyISAM;- 友情链接表 ecs_friend_linkDROP TABLE IF EXISTS ecs_friend_link;CREATE TABLE ecs_friend_link ( link_id smallint(5) unsigned NOT NULL auto_increment, link_name varchar(255) NOT NULL default , link_url varchar(255) NOT NULL default , link_logo varchar(255) NOT NULL default , show_order tinyint(3) unsigned NOT NULL default 50, PRIMARY KEY (link_id), KEY show_order (show_order) TYPE=MyISAM;- 商品信息表 ecs_goodsDROP TABLE IF EXISTS ecs_goods;CREATE TABLE ecs_goods ( goods_id mediumint(8) unsigned NOT NULL auto_increment, cat_id smallint(5) unsigned NOT NULL default 0, goods_sn varchar(60) NOT NULL default , goods_name varchar(120) NOT NULL default , goods_name_style varchar(60) NOT NULL default +, click_count int(10) unsigned NOT NULL default 0, brand_id smallint(5) unsigned NOT NULL default 0, provider_name varchar(100) NOT NULL default , goods_number smallint(5) unsigned NOT NULL default 0, goods_weight decimal(10,3) unsigned NOT NULL default 0.000, market_price decimal(10,2) unsigned NOT NULL default 0.00, shop_price decimal(10,2) unsigned NOT NULL default 0.00, promote_price decimal(10,2) unsigned NOT NULL default 0.00, promote_start_date int(11) unsigned NOT NULL default 0, promote_end_date int(11) unsigned NOT NULL default 0, warn_number tinyint(3) unsigned NOT NULL default 1, keywords varchar(255) NOT NULL default , goods_brief varchar(255) NOT NULL default , goods_desc text NOT NULL, goods_thumb varchar(255) NOT NULL default , goods_img varchar(255) NOT NULL default , original_img varchar(255) NOT NULL default , is_real tinyint(3) unsigned NOT NULL default 1, extension_code varchar(30) NOT NULL default , is_on_sale tinyint(1) unsigned NOT NULL default 1, is_alone_sale tinyint(1) unsigned NOT NULL default 1, is_shipping tinyint(1) unsigned NOT NULL default 0, integral int unsigned NOT NULL default 0, add_time int(10) unsigned NOT NULL default 0, sort_order smallint(4) unsigned NOT NULL default 100, is_delete tinyint(1) unsigned NOT NULL default 0, is_best tinyint(1) unsigned NOT NULL default 0, is_new tinyint(1) unsigned NOT NULL default 0, is_hot tinyint(1) unsigned NOT NULL default 0, is_promote tinyint(1) unsigned NOT NULL default 0, bonus_type_id tinyint(3) unsigned NOT NULL default 0, last_update int(10) unsigned NOT NULL default 0, goods_type smallint(5) unsigned NOT NULL default 0, seller_note varchar(255) NOT NULL default , give_integral int NOT NULL default -1, rank_integral int NOT NULL default -1, suppliers_id smallint(5) unsigned default NULL, is_check tinyint(1) unsigned default NULL, PRIMARY KEY (goods_id), KEY goods_sn (goods_sn), KEY cat_id (cat_id), KEY last_update (last_update), KEY brand_id (brand_id), KEY goods_weight (goods_weight), KEY promote_end_date (promote_end_date), KEY promote_start_date (promote