Ecshop Data Dictionary

Collected online, organized a bit

--table's structure ' ecs_account_log ' CREATE table IF not EXISTS ' ecs_account_log ' (' log_id ' mediumint (8) unsigned not NULL auto_incr Ement COMMENT ' ID number ', ' user_id ' mediumint (8) unsigned not NULL COMMENT ' the ID number of the user who is saved in session after logging in, corresponding to the user_id in the Users table ', ' user _money ' Decimal (10,2) NOT null COMMENT ' the balance of the user's record ', ' Frozen_money ' decimal (10,2) NOT null COMMENT ' frozen funds ', ' rank_points ' Mediumint (9) NOT null COMMENT ' grade integral, separate from the consumer integral ', ' pay_points ' mediumint (9) Not null COMMENT ' consumption integral, separate from the grade integral ', ' change_time ' Int (a) unsigned NOT null COMMENT ' time of occurrence of this pen operation ', ' change_desc ' varchar (255) NOT null COMMENT ' remark of the operation, generally, recharge or present. It is also the admin write any in the memo ', ' Change_type ' tinyint (3) unsigned not NULL COMMENT ' operation type, 0 for recharge, 1 for the present, 2 for the administrator to adjust, 99 for other types ', PRIMARY KEY (' log_id '), KEY ' user_id ' (' user_id ')) engine=myisam default Charset=utf8 row_format=dynamic ' user Account record form,
Including funds and points such as ' auto_increment=42; ----------------------------------------------------------Table's structure ' ecs_ad ' CREATE table IF not EXISTS ' ecs_ad ' (' ad_id ' Mallint (5) unsigned NOT null auto_increment COMMENT ' ID number ', ' position_id ' smallint (5) unsigned not NULL DEFAULT ' 0 ' COMMENT ' 0, outbound ad; From 1 it represents the wide Advertising position in the same table ad_position the value of the field position_id ', ' media_type ' tinyint (3) unsigned not NULL DEFAULT ' 0 ' COMMENT ' ad type, 0, picture; 1,
FLASH;2, code, 3, text ', ' ad_name ' varchar NOT NULL COMMENT ' ad name ', ' ad_link ' varchar (255) NOT NULL COMMENT ' ad link address ', ' Ad_code ' text not null COMMENT ' ad link performance, text ads are text or pictures and Flash is their address, code ads is the code content ', ' start_time ' int (one) not null DEFAULT ' 0 ' C Omment ' ad start time ', ' end_time ' int (one) not null DEFAULT ' 0 ' COMMENT ' ad end Time ', ' link_man ' varchar (a) NOT null COMMENT ' ad contact ' , ' link_email ' varchar NOT NULL COMMENT ' mailbox of Advertiser contact ', ' link_phone ' varchar ' NOT null COMMENT ' ad contact's phone ', ' Click_count ' Mediumint (8) unsigned NOT NULL default ' 0 ' COMMENT ' The number of ad clicks ', ' Enabled ' tinyint (3) unsigned NOT null default ' 1 ' COMMENT ' Whether the advertisement is closed, 1, open, 0, closed, the advertisement will no longer be valid until reopened ', PRIMARY key (' ad_id '), key ' position_id ' (' position_id '), key ' enabled ' (' Enabled ')) Engine=myisam DEFAULT CHARSEt=utf8 row_format=dynamic comment= ' advertising list configuration table, including the station inside the station outside the picture, text, Flash, code ads ' auto_increment=6; ----------------------------------------------------------Table's structure ' ecs_admin_action ' CREATE table IF not EXISTS ' Ecs_ Admin_action ' (' action_id ' tinyint (3) unsigned not NULL auto_increment COMMENT ' ID number ', ' parent_id ' tinyint (3) unsigned N OT null DEFAULT ' 0 ' COMMENT ' the ID item's parent ID, corresponding to the action_id field ' of this table ', ' action_code ' varchar ' not NULL COMMENT ' is the English string representing the permission, corresponding to the Chinese language file , if the field has a string, it means that permission ', PRIMARY key (' action_id '), key ' parent_id ' (' parent_id ') Engine=myisam DEFAULT Charset=utf8 ROW
_format=dynamic comment= ' admin rights list tree ' auto_increment=104; ----------------------------------------------------------Table's structure ' ecs_admin_log ' CREATE table IF not EXISTS ' Ecs_admin_  Log ' (' log_id ' int () unsigned not NULL auto_increment COMMENT ' ID number ', ' log_time ' int (a) unsigned NOT null DEFAULT ' 0 ' COMMENT ' Write log Time ', ' user_id ' tinyint (3) unsigned not NULL DEFAULT ' 0 ' COMMENT ' the operator ID recorded in the log, ecs_admin_user with user_id ', ' Log_ Info ' VarchAR (255) NOT NULL COMMENT ' manage operation content ', ' ip_address ' varchar NOT NULL COMMENT ' administrator login IP ', PRIMARY key (' log_id '), key ' log_t IME ' (' log_time '), KEY ' user_id ' (' user_id ') engine=myisam DEFAULT charset=utf8 row_format=dynamic ' admin action Log table ' A
uto_increment=158; ----------------------------------------------------------Table's structure ' ecs_admin_message ' CREATE table IF not EXISTS ' Ecs_ Admin_message ' (' message_id ' smallint (5) unsigned not NULL auto_increment COMMENT ' ID number ', ' sender_id ' tinyint (3) Unsigne D NOT null default ' 0 ' COMMENT ' sends the administrator ID for this message, with Ecs_admin_user user_id ', ' receiver_id ' tinyint (3) unsigned NOT NULL default ' 0 ' COMMENT ' receives the message's administrator ID, user_id with Ecs_admin_user, if it is sent to multiple administrators, the same message sends a ', ' sent_time ' int (one) unsigned not NULL for each administrator ID DEFAULT ' 0 ' COMMENT ' message send Time ', ' read_time ' int (one) unsigned not NULL DEFAULT ' 0 ' COMMENT ' message reading time ', ' readed ' tinyint (1) unsi gned NOT NULL default ' 0 ' COMMENT ' message whether read, 1, read, 0, unread ', ' deleted ' tinyint (1) unsigned NOT null default ' 0 ' COMMENT ' message has been Whether it has been deleted, 1, deleted0, not deleted ', ' title ' varchar NOT null COMMENT ' theme ', ' message ' text is not null COMMENT ' contents of message ', PRIMARY KEY (' message_id ' ), key ' sender_id ' (' sender_id ', ' receiver_id '), key ' receiver_id ' (' receiver_id ')) Engine=myisam DEFAULT Charset=utf8 RO
W_format=dynamic comment= ' Administrator message record form ' auto_increment=7; ----------------------------------------------------------Table's structure ' ecs_admin_user ' CREATE table IF not EXISTS ' ecs_admin _user ' (' user_id ' smallint (5) unsigned not NULL auto_increment ' auto ID number, admin code ', ' COMMENT ' user_name ' () NOT NULL CO Mment ' admin login name ', ' email ' varchar NOT NULL COMMENT ' admin mailbox ', ' password ' varchar ' NOT null COMMENT ' admin login Secret cryptographic string ', ' add_t IME ' int (one) not null default ' 0 ' COMMENT ' admin add time ', ' last_login ' int (one) not null default ' 0 ' COMMENT ' admin last logon time ', ' Las T_IP ' varchar NOT NULL COMMENT ' administrator last login ip ', ' action_list ' text not null COMMENT ' admin admin rights List ', ' nav_list ' text not NUL L COMMENT ' admin navigation bar configuration item ', ' lang_type ' varchar not NULL, ' agency_id ' smallint (5) unsigned notNULL COMMENT ' ID of the office responsible for this administrator, agency_id field with Ecs_agency. If the administrator is not responsible for the office, then here is 0 ', ' todolist ' Longtext COMMENT ' notepad recorded data ', PRIMARY key (' user_id '), key ' user_name ' (' user_name '), key ' a
gency_id ' (' agency_id ')) Engine=myisam DEFAULT Charset=utf8 row_format=dynamic comment= ' Administrator data permission list ' auto_increment=4; ----------------------------------------------------------Table's structure ' ecs_adsense ' CREATE table IF not EXISTS ' Ecs_adsense '  (' From_ad ' smallint (5) NOT null DEFAULT ' 0 ' COMMENT ' ad code,-1 is an outbound advertisement, if it is an advertisement in the station is Ecs_ad ad_id ', ' referer ' varchar (255) NOT NULL COMMENT ' source ', ' clicks ' int () unsigned not NULL DEFAULT ' 0 ' COMMENT ' ctr ', KEY ' from_ad ' (' From_ad ') Engine=myisam D
Efault Charset=utf8 row_format=dynamic comment= ' ad click Statistics '; ----------------------------------------------------------Table's structure ' ecs_ad_position ' CREATE table IF not EXISTS ' Ecs_ad_ Position ' (' position_id ' tinyint (3) unsigned not NULL auto_increment COMMENT ' ad bit id ', ' position_name ' varchar () not N ull COMMENT ' ad bit name ', ' Ad_width ' smallint (5unsigned NOT NULL default ' 0 ' COMMENT ' ad bit width ', ' ad_height ' smallint (5) unsigned NOT null default ' 0 ' COMMENT ' ad bit height ', ' p Osition_desc ' varchar (255) NOT NULL COMMENT ' ad bit description ', ' position_style ' text not null COMMENT ' ad bit template code ', PRIMARY KEY (' posit
ion_id ') Engine=myisam DEFAULT charset=utf8 row_format=dynamic comment= ' Ad location configuration table ' auto_increment=2; ----------------------------------------------------------Table's structure ' ecs_affiliate_log ' CREATE table IF not EXISTS ' Ecs_ 
Affiliate_log ' (' log_id ' mediumint (8) NOT NULL auto_increment, ' order_id ' mediumint (8) isn't null, ' time ' int (a) NOT NULL, ' user_id ' Mediumint (8) Not NULL, ' user_name ' varchar (a) DEFAULT null, ' Money ' decimal (10,2) NOT null default ' 0.00 ', ' PO  int ' int. NOT NULL default ' 0 ', ' separate_type ' tinyint (1) NOT null default ' 0 ', PRIMARY KEY (' log_id ') Engine=myisam
DEFAULT Charset=utf8 row_format=dynamic comment= ' divided into related tables, not yet researched through ' auto_increment=1; Structure of the----------------------------------------------------------table ' ecs_agency ' CREATE TAble IF not EXISTS ' ecs_agency ' (' agency_id ' smallint (5) unsigned not NULL auto_increment ' office id ', ' COMMENT ' varchar (255) NOT null COMMENT ' office name ', ' agency_desc ' text not NULL COMMENT ' office description ', PRIMARY key (' agency_id '), key ' agency
_name ' (' Agency_name ')) Engine=myisam DEFAULT Charset=utf8 comment= ' office information ' auto_increment=5; ----------------------------------------------------------Table's structure ' ecs_area_region ' CREATE table IF not EXISTS ' Ecs_area _region ' (' shipping_area_id ' smallint (5) unsigned not NULL DEFAULT ' 0 ' COMMENT ' distribution area ID number, equivalent to Ecs_shipping_area shipping_ area_id value ', ' region_id ' smallint (5) unsigned not NULL DEFAULT ' 0 ' COMMENT ' area list, equivalent to Ecs_region region_id ', PRIMARY KEY (' sh ipping_area_id ', ' region_id ') Engine=myisam DEFAULT Charset=utf8 row_format=fixed comment= ' record table Ecs_shipping_
The Shipping_area_name in area includes the city of Ecs_region; ----------------------------------------------------------Table's structure ' ecs_article ' CREATE table IF not EXISTS ' ecs_article ' (' article_id ' mediuminT (8) unsigned not NULL auto_increment COMMENT ' ID number ', ' cat_id ' smallint (5) NOT null DEFAULT ' 0 ' COMMENT ' the classification of the article, with the Ecs_arti Cle_cat's cat_id, if not, will automatically become a reserved type and cannot be deleted ', ' title ' varchar () NOT null COMMENT ' article title ', ' content ' longtext not null COMMENT ' article Content ', ' author ' varchar NOT null COMMENT ' article author ', ' author_email ' varchar ' NOT null COMMENT ' email of article author ', ' Keywords ' va Rchar (255) NOT null COMMENT ' keywords ', ' article_type ' tinyint (1) unsigned NOT null DEFAULT ' 2 ' COMMENT ' article type, 0, common; 1, top; 2 and greater 2, for retaining articles, retain articles cannot be deleted ', ' Is_open ' tinyint (1) unsigned not NULL DEFAULT ' 1 ' COMMENT ' is displayed. 1, show; 0, do not show ', ' add_time ' int (a) unsigned not