shop_stand_intall Db dictionary

The dictionary’s comments come from the database table and its field comments (` comment ‘)

account_ban_ip IP forbidden table - in cache

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
ban_ip varchar(25) NO IP
ban_reason varchar(50) NO reason
ban_unlock_time int(12) unsigned 0 NO Unlocking time
ban_lock_time int(12) unsigned 0 NO Lock time
ban_autorelease int(1) 1 NO Automatic opening (enum): 1-automatic unlocking; 0-manual unlocking
ban_status tinyint(1) 1 NO Locking status (enum): 1-locked; 2-unlocked
ban_type tinyint(1) unsigned 1 NO Locking type (enum): 1-access forbidden; 2-registration forbidden

account_base_app Application configuration table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
app_id int(10) unsigned NO Application number
app_name varchar(40) NO Application Name: program calls key app_ name . url
app_label varchar(255) NO Apply labels
app_type smallint(5) unsigned 0 NO Application type
app_seq int(11) 0 NO Application No
app_key varchar(255) NO Application key
app_ip varchar(255) NO IP list (DOT)
app_url_site varchar(255) NO Service website
app_url_api varchar(255) NO API website
app_url_admin varchar(255) NO Background web address: API settings are synchronized directly from the user center
app_url_login varchar(255) NO Login URL
app_url_logout varchar(255) NO Log out
app_url_reg varchar(255) NO Registered website
app_url_recharge varchar(255) NO Exchange website
app_url_order varchar(255) NO URL address to check if the order exists
app_logo varchar(255) NO Please paste in the web photo address
app_hosts varchar(255) NO Domain name list (DOT)
app_return_fields varchar(255) NO Return field (DOT)
app_enable tinyint(1) unsigned 0 NO Enable (enum): 0-disable; 1-enable

account_base_config System parameter setting table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
config_key varchar(50) NO Set key
config_value varchar(10000) NO value
config_type varchar(20) NO Classification
config_enable tinyint(1) unsigned 1 NO Status value, 1 possible, 0 not available
config_comment varchar(1024) NO Explanatory notes
config_datatype enum(‘string’,’json’,’number’,’dot’) string NO data type
config_name varchar(50) NO Set name
config_formater varchar(255) NO Output format - two outputs of key \ value
config_category enum(‘系统参数’,’基础参数’,’扩展参数’) 基础参数 NO Set type - used to view data, no use value

account_base_config_dev System parameter setting table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
config_key varchar(50) NO Set key
config_value varchar(10000) NO value
config_type varchar(20) NO Classification
config_enable tinyint(1) unsigned 1 NO Status value, 1 possible, 0 not available
config_comment varchar(1024) NO Explanatory notes
config_datatype enum(‘string’,’json’,’number’,’dot’) string NO data type
config_name varchar(50) NO Set name
config_formater varchar(255) NO Output format - two outputs of key \ value
config_category enum(‘系统参数’,’基础参数’,’扩展参数’) 基础参数 NO Set type - used to view data, no use value

account_base_protocol Basic communication protocol table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
cmd_id mediumint(8) unsigned NO Agreement No
ctl varchar(50) NO Controller class name
met varchar(50) NO Controller method
mdu varchar(50) NO -
db enum(‘master’,’slave’) master NO Connection database type
typ enum(‘e’,’json’,’msgpcak’,’amf’) json NO Default type of output data
rights_id smallint(4) 0 NO Authority number
log tinyint(1) 0 NO Log or not
struct varchar(100) NO Generate structure, independent use
comment varchar(255) NO notes
0 varchar(255) int16_t:cmd_id NO First field
1 varchar(255) NO -
2 varchar(255) NO -
3 varchar(255) NO -
4 varchar(255) NO -
5 varchar(255) NO -
6 varchar(255) NO -
7 varchar(255) NO -
8 varchar(255) NO -
9 varchar(255) NO -
10 varchar(255) NO -
11 varchar(255) NO -
12 varchar(255) NO -
13 varchar(255) NO -
14 varchar(255) NO -
15 varchar(255) NO -
16 varchar(255) NO -
17 varchar(255) NO -
18 varchar(255) NO -
19 varchar(255) NO -
20 varchar(255) NO -
21 varchar(255) NO -
22 varchar(255) NO -
23 varchar(255) NO -
24 varchar(255) NO -
25 varchar(255) NO -
26 varchar(255) NO -
27 varchar(255) NO -
28 varchar(255) NO -
29 varchar(255) NO -
30 varchar(255) NO -
31 varchar(255) NO -
32 varchar(255) NO -

account_base_role_level Role level table platform

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
role_level_id int(11) NO Grade number
role_level_name varchar(50) NO Rank Name
role_level_exp int(10) 0 NO Upgrade experience
role_level_fans_user int(10) 0 NO Develop fans
role_level_fans_store int(10) 0 NO Promoting Shops
role_level_spend int(10) 0 NO Cumulative consumption
role_level_product_id int(11) 0 NO Upgrade product SPU number
role_level_logo varchar(255) NO LOGO
role_level_validity tinyint(1) unsigned 0 NO Validity period: 1-member validity period of 1 year; 0-permanent validity, after 1 year, 4000 growth value will be deducted, and the level will be recalculated according to the remaining growth value
role_level_exp_reduction int(10) unsigned 0 NO Annual fee
role_level_annual_fee int(10) unsigned 0 NO Annual fee
role_level_rate decimal(6,2) 0.00 NO Discount rate percentage
role_level_fx_rate decimal(6,2) 100.00 NO Divided commission ratio
role_level_privilege varchar(2048) NO Equity - participate in rights function - independent table implementation
role_level_time timestamp CURRENT_TIMESTAMP NO Modification time
role_level_is_buildin tinyint(1) 0 NO Bool: 0-no; 1-yes

account_base_user_level User level table - platform

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_level_id int(11) NO Grade number
user_level_name varchar(50) NO Rank Name
user_level_exp int(10) 0 NO Upgrade experience
user_level_fans_user int(10) 0 NO Develop fans
user_level_fans_store int(10) 0 NO Promoting Shops
user_level_fans_vip int(10) 0 NO Promote VIP
user_level_fans_team int(10) 0 NO Team VIP
user_level_spend int(10) 0 NO Cumulative consumption
user_level_product_id varchar(30) NO Upgrade product SPU number (DOT)
user_level_logo varchar(255) NO LOGO
user_level_validity tinyint(1) unsigned 0 NO Validity period: 1-member validity period of 1 year; 0-permanent validity, after 1 year, 4000 growth value will be deducted, and the level will be recalculated according to the remaining growth value
user_level_exp_reduction int(10) unsigned 0 NO Annual fee
user_level_annual_fee int(10) unsigned 0 NO Annual fee
user_level_rate decimal(6,2) 0.00 NO Discount rate percentage
user_level_fx_rate decimal(6,2) 100.00 NO Divided commission ratio
user_level_privilege varchar(2048) NO Equity - participate in rights function - independent table implementation
user_level_time timestamp CURRENT_TIMESTAMP NO Modification time
user_level_is_buildin tinyint(1) 0 NO Bool: 0-no; 1-yes

account_number_seq ID management table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
prefix varchar(20) NO prefix
number mediumint(8) unsigned 0 NO Growth value

account_user_analytics User role information table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_id int(10) unsigned 0 NO User number
user_spend decimal(10,2) unsigned 0.00 NO Total consumption
user_refund decimal(10,2) unsigned 0.00 NO Total refund
user_order_buy_num int(10) unsigned 0 NO Effective order quantity
user_order_return_num int(10) NO Chargeback quantity
user_product_buy_num int(10) NO Purchase Quantity
user_product_return_num int(10) NO Quantity of returns:

account_user_base User basic information table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_id int(10) unsigned NO User number
user_account varchar(50) NO User Center
user_password char(32) NO Password
user_nickname varchar(50) NO User nickname
user_state tinyint(1) unsigned 1 NO Status (enum): 0-locked; 1-not activated; 2-activated;
user_key varchar(100) NO Cookie encryption key: password change login change involves multiple ends, affecting user center
user_salt varchar(100) salt- NO Add some salt
user_token varchar(100) NO for site connect check: user_ Key password login change, user_ Token connect changes after request verification
rights_group_id varchar(100) NO Permission Group (DOT)
user_is_admin tinyint(1) 0 NO Whether to enable (bool): 0-no; 1-yes
store_ids varchar(200) NO Store account (DOT)
chain_ids varchar(200) NO Store account number (DOT)

account_user_bind_account User account binding table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_account varchar(50) NO User account
user_id int(10) unsigned NO User number
bind_time timestamp CURRENT_TIMESTAMP NO Binding time

account_user_bind_connect User binding table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
bind_id varchar(100) NO Binding tag: mobie / email / openid binding type + open number
bind_type tinyint(4) unsigned NO Binding type (emun): 1-mobile; 2-email; 11 sinaweibo; 12 QQ; 13 Weixin
user_id int(10) unsigned 0 NO User number
bind_time timestamp CURRENT_TIMESTAMP NO Binding time
bind_nickname varchar(50) NO User name
bind_icon varchar(255) NO User Icon
bind_gender tinyint(1) 1 NO Gender (emun): 1-male; 2-female;
bind_vip tinyint(1) unsigned 0 NO VIP
bind_level tinyint(1) unsigned 0 NO level
bind_client_id varchar(80) NO client
bind_country varchar(20) NO country
bind_province varchar(20) NO Provincial ID
bind_city varchar(20) NO City
bind_county varchar(20) NO County Area
bind_openid varchar(100) NO Access open number
bind_unionid varchar(100) NO for wechat
bind_access_token varchar(255) NO access_ token
bind_expires_in int(8) 0 NO Valid until
bind_refresh_token varchar(255) NO Refresh token
bind_token_ttl int(10) unsigned 0 NO Effective deadline
bind_active tinyint(3) 0 NO Whether to activate (bool): 0-not activated; 1-activated

account_user_bind_email User mail binding table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_email varchar(50) 0 NO User email
user_id int(10) unsigned NO User Center
bind_time timestamp CURRENT_TIMESTAMP NO -

account_user_bind_mobile User mobile binding table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_mobile varchar(20) 0 NO User’s mobile number + 86 1212
user_id int(10) unsigned NO User Center
bind_time timestamp CURRENT_TIMESTAMP NO -

account_user_chain Store customer relationship table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_id int(10) unsigned 0 NO Membership Number
chain_id int(10) unsigned 0 NO Owned stores
store_id int(10) unsigned 0 NO Shop Number

account_user_history User password history information table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_id int(10) unsigned NO User number
user_history_password varchar(255) NO History password
user_history_ip varchar(255) NO Historical IP
user_history_time timestamp CURRENT_TIMESTAMP NO Modification time

account_user_info User details table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_id int(10) unsigned NO User number
user_type_id smallint(4) unsigned 0 NO User category
user_exp_total bigint(16) unsigned 0 NO Total platform experience
user_level_validity_time int(11) 0 NO Valid until
user_level_card varchar(20) NO Membership card No
user_level_id smallint(4) unsigned 1001 NO User Level
user_group int(11) 0 NO User groups
user_avatar varchar(255) NO Head portrait
user_gender tinyint(1) unsigned 1 NO Gender (enum): 1-male; 2-female;
user_birthday date 0000-01-01 NO Date of birth
user_mobile varchar(20) NO Mobile number
user_tel varchar(30) NO Telephone
user_email varchar(50) NO User email
user_qq varchar(20) NO QQ
user_ww varchar(255) NO Ali Wangwang
user_province_id int(10) unsigned 0 NO Provincial ID
user_city_id int(10) unsigned 0 NO City
user_county_id int(10) unsigned 0 NO county
user_address varchar(255) NO Detailed address
user_sign varchar(255) NO autograph
user_realname varchar(20) NO Real name
user_idcard varchar(30) NO ID
user_idcard_images varchar(1024) NO ID card picture (DOT)
user_certification tinyint(1) unsigned 0 NO Real name authentication (bool): 0-not verified; 1-authenticated; 2-data submitted for review
user_is_new tinyint(1) 1 NO New user (bool): 0-no; 1-yes;
user_notename varchar(50) NO Platform remark name
user_withdraw_state tinyint(1) 0 NO Withdrawal agreement (bool): 0 - not signed; 1 - agreed;

account_user_level_log User level record

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_level_log_id int(11) NO Log number
user_id int(10) NO User number
user_level_id smallint(4) 0 NO Order status: 2010 to be paid; 2020 to be distributed; 2030 to be shipped; 2040 to be shipped; 2050 to be signed in; 2060 to be completed; 2070 to be cancelled;
user_level_pre_id smallint(4) unsigned 0 NO Order status: 2010 to be paid; 2020 to be distributed; 2030 to be shipped; 2040 to be shipped; 2050 to be signed in; 2060 to be completed; 2070 to be cancelled;
ull_time timestamp CURRENT_TIMESTAMP NO Time order_ state_ modify_ time
ull_note varchar(50) NO Operation notes
ull_is_sync tinyint(1) NO Synchronization (bool): 0-no; 1-yes
admin_id int(10) 0 NO Successful operation

account_user_login User login information table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_id int(10) unsigned NO User number
user_reg_datetime timestamp CURRENT_TIMESTAMP NO Registration time
user_active_time timestamp 1970-01-02 00:00:00 NO Activation time
user_reg_ip varchar(15) NO Register IP
user_lastlogin_time timestamp 1970-01-02 00:00:00 NO Last login time
user_lastlogin_ip varchar(15) NO Last login IP
user_count_login int(11) unsigned 0 NO Number of logins
user_reg_date date NO Registration date
user_reg_time int(11) 0 NO Registration time

account_user_login_history User login information table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_login_history_id int(11) NO Log number
user_id int(10) unsigned NO User number
user_login_ip varchar(20) NO Login IP
user_login_time timestamp CURRENT_TIMESTAMP NO login time

account_user_role User role information table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_id int(10) unsigned 0 NO User number
role_level_id int(10) 1001 NO Role level number
user_is_sp tinyint(10) unsigned 0 NO Bool: 0-no; 1-yes;
user_is_da tinyint(10) unsigned 0 NO Bool: 0-no; 1-yes;
user_is_ca tinyint(10) unsigned 0 NO Bool: 0-no; 1-yes;
user_is_new tinyint(1) 1 NO New user (bool): 0-no; 1-yes;

account_user_sns User SNS information table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_id int(10) unsigned NO User number
user_blog int(10) unsigned 0 NO Number of microblogs
user_friend int(10) unsigned 0 NO Number of friends
user_fans int(10) unsigned 0 NO Number of fans
user_growth int(10) unsigned 0 NO Growth Value
user_sign varchar(500) NO User signature
user_report tinyint(1) 1 NO Whether to report (bool): 0-no; 1-yes
user_buy tinyint(1) 1 NO Whether to buy goods (bool): 0-no; 1-yes
user_comment tinyint(1) unsigned 1 NO Whether to allow speech (bool): 0-no; 1-yes
user_fans_store int(10) 0 NO Number of promotion stores
user_story int(10) 0 NO the number of the post
user_story_comment int(10) 0 NO Number of comments
user_favorites_store int(10) 0 NO Bookmark
user_favorites_item int(10) 0 NO Collections
user_favorites_brand int(10) 0 NO Collection brand
user_story_collection int(10) 0 NO Favorite posts
user_story_like int(10) 0 NO Post likes
user_story_forward int(10) 0 NO Post forwarding

account_wechat_access_token Wechat access_ Token central control server table - currently directly in cache zero_ Api_ Wechat

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
wechat_app_id varchar(255) NO App number
wechat_access_token varchar(1024) NO access_ Token - unified access. If it fails, it needs to provide a re access interface
wechat_expires_in int(10) unsigned 0 NO expires_ In
wechat_ttl int(10) unsigned 0 NO Valid timestamps time + expires_ In

admin_base_config System parameter setting table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
config_key varchar(50) NO Set key
config_value varchar(10000) NO value
config_type varchar(20) NO Classification
config_enable tinyint(1) unsigned 1 NO Status value, 1 possible, 0 not available
config_comment varchar(255) NO Explanatory notes
config_datatype enum(‘string’,’json’,’number’,’dot’) string NO data type
config_name varchar(50) NO Set name
config_formater varchar(255) NO Output format - two outputs of key \ value
config_category enum(‘系统参数’,’基础参数’,’扩展参数’) 基础参数 NO Set type - used to view data, no use value

admin_base_menu Menu table - 10 increments

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
menu_id int(10) NO Menu number
menu_parent_id int(10) 0 NO Menu number
menu_rel varchar(20) pageTab NO -
menu_name_en_GB varchar(50) NO English menu
menu_name varchar(20) NO Menu Name
menu_label varchar(50) NO Menu text
menu_order tinyint(4) unsigned 50 NO sort
menu_enable tinyint(1) unsigned 1 NO Whether to enable (bool)
menu_class varchar(255) NO class name
menu_icon varchar(30) NO Icon class
menu_bubble varchar(255) NO bubble
menu_url_mdu varchar(255) NO Module name
menu_url_ctl varchar(50) NO Controller name
menu_url_met varchar(20) NO Controller method
menu_url_parem varchar(250) NO URL parameters
menu_url varchar(100) NO Type 1 Page2 URL
menu_time timestamp 0000-00-00 00:00:00 NO Last updated
menu_type tinyint(1) unsigned 1 NO Menu type (list): 1-general; 2-order system; 3-mall system
menu_note varchar(5000) NO -
menu_func varchar(255) NO Function on: follow config_ Key
menu_role tinyint(3) unsigned 1 NO Role type (list): 1-platform; 2-commodity inspection management end; 3-store

admin_base_menu_untech Menu table - 10 increments

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
menu_id int(10) NO Menu Id
menu_parent_id int(10) 0 NO Menu Id
menu_rel varchar(20) pageTab NO -
menu_name_en_GB varchar(50) NO English menu
menu_name_ar_SA varchar(50) NO arab
menu_name_es_MX varchar(50) NO Spain
menu_name_th_TH varchar(50) NO Thai
menu_name varchar(20) NO Menu Name
menu_label varchar(50) NO Menu text
menu_order tinyint(4) unsigned 50 NO sort
menu_enable tinyint(1) unsigned 1 NO Whether to enable (bool)
menu_class varchar(255) NO class name
menu_icon varchar(30) NO Icon class
menu_bubble varchar(255) NO bubble
menu_url_mdu varchar(255) NO Module name
menu_url_ctl varchar(50) NO Controller name
menu_url_met varchar(20) NO Controller method
menu_url_parem varchar(250) NO URL parameters
menu_url varchar(100) NO Type 1 Page2 URL
menu_time timestamp 0000-00-00 00:00:00 NO Last updated
menu_type tinyint(1) unsigned 1 NO Menu type (list): 1-general; 2-order system; 3-mall system
menu_note varchar(5000) NO -
menu_func varchar(255) NO Function on: follow config_ Key
menu_role tinyint(3) unsigned 1 NO Role type (list): 1-platform; 2-commodity inspection management end; 3-store

admin_base_protocol Basic communication protocol table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
cmd_id mediumint(8) unsigned NO Agreement No
ctl varchar(50) NO Controller class name
met varchar(50) NO Controller method
mdu varchar(50) NO -
db enum(‘master’,’slave’) master NO Connection database type
typ enum(‘e’,’json’,’msgpcak’,’amf’) json NO Default type of output data
rights_id smallint(4) 0 NO Authority number
log tinyint(1) 0 NO Log or not
struct varchar(100) NO Generate structure, independent use
comment varchar(255) NO notes
0 varchar(255) int16_t:cmd_id NO First field
1 varchar(255) NO -
2 varchar(255) NO -
3 varchar(255) NO -
4 varchar(255) NO -
5 varchar(255) NO -
6 varchar(255) NO -
7 varchar(255) NO -
8 varchar(255) NO -
9 varchar(255) NO -
10 varchar(255) NO -
11 varchar(255) NO -
12 varchar(255) NO -
13 varchar(255) NO -
14 varchar(255) NO -
15 varchar(255) NO -
16 varchar(255) NO -
17 varchar(255) NO -
18 varchar(255) NO -
19 varchar(255) NO -
20 varchar(255) NO -
21 varchar(255) NO -
22 varchar(255) NO -
23 varchar(255) NO -
24 varchar(255) NO -
25 varchar(255) NO -
26 varchar(255) NO -
27 varchar(255) NO -
28 varchar(255) NO -
29 varchar(255) NO -
30 varchar(255) NO -
31 varchar(255) NO -
32 varchar(255) NO -

admin_log_action User behavior log table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
log_id bigint(20) unsigned NO Log number
user_id mediumint(10) 0 NO Player ID
user_account varchar(100) NO Role account
user_name varchar(20) NO Role name
action_id mediumint(8) 0 NO Behavior ID: Protocol_ id -> rights_ ID
action_type_id mediumint(9) NO Operation type No.: right_ parent_ ID
log_param varchar(1024) NO Requested parameters
log_ip varchar(20) NO Log IP
log_date date NO Log date
log_time timestamp CURRENT_TIMESTAMP NO Record time

admin_rights_base Authority table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
rights_id smallint(4) unsigned NO Authority number
rights_name varchar(20) NO Name of permission
rights_parent_id smallint(4) unsigned NO Permission parent number
rights_remark varchar(255) NO Remarks
rights_order smallint(4) 50 NO sort

admin_rights_data_type Data permission type table - read data by yourself

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
rights_data_type_id mediumint(6) unsigned NO Authority data type number
rights_data_type_name varchar(50) NO Permission data type name
rights_data_type_primary_key text NO Data primary key

admin_rights_group Permission group table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
rights_group_id smallint(4) unsigned NO Authority Group No
rights_group_name varchar(50) NO Permission group name
rights_group_rights_ids varchar(2048) NO Permission list (DOT)
rights_group_rights_data varchar(2048) NO Data permission (DOT): group data permission, which is only used to represent data with a certain small result set.
rights_group_add_time timestamp CURRENT_TIMESTAMP NO Creation time

admin_seller_menu Menu table - 10 increments

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
menu_id int(10) NO Menu number
menu_parent_id int(10) 0 NO Menu number
menu_rel varchar(20) pageTab NO -
menu_name varchar(20) NO Menu Name
menu_label varchar(50) NO Menu text
menu_order tinyint(4) unsigned 50 NO sort
menu_enable tinyint(1) unsigned 1 NO Whether to enable (bool)
menu_class varchar(255) NO class name
menu_icon varchar(20) NO Icon class
menu_bubble varchar(255) NO bubble
menu_url_mdu varchar(255) NO Module name
menu_url_ctl varchar(50) NO Controller name
menu_url_met varchar(20) NO Controller method
menu_url_parem varchar(250) NO URL parameters
menu_url varchar(100) NO Type 1 Page2 URL
menu_time timestamp 0000-00-00 00:00:00 NO Last updated
menu_type tinyint(1) unsigned 1 NO Menu type (list): 1-general; 2-order system; 3-mall system
menu_note varchar(1024) NO -
menu_func varchar(255) NO Function on: follow config_ Key

admin_user_rights_data User data permission table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_rights_data_id mediumint(8) unsigned 0 NO -
user_id mediumint(8) unsigned NO User number
user_rights_data_value mediumint(8) NO Primary key value
rights_data_type_id mediumint(8) unsigned 0 NO Authority type No

analytics_access_history Access log table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
access_id bigint(20) NO number
user_id int(10) unsigned 0 NO User number
access_client_id char(32) NO Unique customer number
access_os varchar(200) 0.00 NO operating system
access_browser_name varchar(200) 0.00 NO Browser name
access_browser_version varchar(200) 0 NO Browser version
access_spider varchar(200) NO Search Engines
access_country varchar(255) NO country
access_province varchar(200) NO Province
access_city varchar(200) NO city
access_county varchar(255) NO Beijing
access_lang varchar(255) NO language
access_ip varchar(255) NO Access IP
access_url varchar(255) NO Access address
access_time int(11) NO Access time
access_year mediumint(4) NO year
access_month tinyint(2) NO monthly
access_day tinyint(2) NO day
access_hour tinyint(2) NO overtime
access_date date NO specific date
access_datetime datetime NO time
access_refer_domain varchar(255) NO source
access_refer_url varchar(255) NO source
access_mobile tinyint(1) 0 NO Mobile phone or not
access_pad tinyint(1) 0 NO Flat or not
access_pc tinyint(1) 0 NO PC or not
access_device tinyint(1) 3 NO Terminal (enum): 1-phone; 2-pad; 3-Pc
access_type smallint(4) 2310 NO Terminal source (enum): 2310 other; 2311 PC; 2312-h5; 2313 app; 2314 applet
access_from smallint(4) 2320 NO Terminal sources (ENUM): 2320- others; 2321- WeChat; 2322- Baidu; 2323- Alipay; 2324- headlines

analytics_user_reg_source User source terminal table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_reg_id int(11) NO Registration number
user_reg_date date NO Date No
user_reg_num varchar(10) 0.00 NO operating system
user_reg_mobile int(10) 0 NO Mobile phone or not
user_reg_pad int(10) 0 NO Flat or not
user_reg_pc int(10) 0 NO PC or not
user_reg_h5 int(10) 0 NO -
user_reg_app int(10) 0 NO -
user_reg_mp int(10) 0 NO -
user_reg_wechat int(10) 0 NO -
user_reg_baidu int(10) 0 NO -
user_reg_alipay int(10) 0 NO -
user_reg_toutiao int(10) 0 NO -

cms_article_analytics News likes data

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
article_id mediumint(8) NO -
article_clicked mediumint(8) unsigned 0 NO click
article_praise mediumint(8) unsigned 0 NO give the thumbs-up
article_comment_count mediumint(9) unsigned 0 NO Number of article comments

cms_article_attachment Attachment information sheet

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
attachment_id mediumint(8) unsigned NO Article number
user_id mediumint(8) unsigned 0 NO Article author number
attachment_time int(10) NO Article date
attachment_content longtext NO Content of the article
attachment_title text NO Article title
attachment_remark text NO Summary of the article
attachment_password varchar(20) NO Article browsing password
attachment_name varchar(200) NO Post Slug
attachment_link varchar(200) NO URL and link address of the article
attachment_url varchar(255) NO Attachment path
attachment_mime_type varchar(100) NO Uploaded attachment type
attachment_file varchar(100) NO enclosure
attachment_metadata text NO -
attachment_alt varchar(255) NO Article first added

cms_article_base Content of the article

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
article_id int(5) NO number
article_title varchar(50) NO Title
article_name varchar(255) NO Article alias slug
article_excerpt varchar(255) NO Summary of the article
article_content mediumtext NO Article content (HTML)
article_url varchar(100) NO Call web address: the default is the web address constructed by this page
category_id smallint(4) unsigned NO Classification
article_template varchar(50) NO Template
article_seo_title varchar(200) NO SEO Title
article_seo_keywords varchar(200) NO SEO keywords
article_seo_description varchar(200) NO Description of SEO
article_reply_flag tinyint(1) unsigned 1 NO Whether to enable question answering message (bool): 0-no; 1-yes
article_lang varchar(5) cn NO language
article_type tinyint(1) unsigned 1 NO Article type (enum): 1-article; 2-announcement
article_sort tinyint(2) unsigned 0 NO sort
article_status tinyint(1) unsigned 0 NO Status (bool): 0-closed; 1-enabled
article_add_time timestamp CURRENT_TIMESTAMP NO Add world
article_image varchar(255) NO Articles and pictures
user_id int(10) unsigned 0 NO Author of the article
article_tags varchar(255) NO Article tag (DOT): article tag
article_is_popular tinyint(1) 0 NO Hot or not

cms_article_base_user Article user association table - not used, efficiency problem optimized by redis

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
article_id mediumint(8) unsigned NO Article number
user_id mediumint(8) unsigned 0 NO Article author number
article_time int(10) NO Article date
article_status varchar(20) publish NO Article status [‘draft ‘,’publish’,’pending ‘,’Future’,’private ‘]
article_type varchar(20) post NO [ ‘post’ / ‘page’ / ‘link’ / ‘nav_ menu_ Item ‘/ custom post type] article type: article, page, link, menu, other custom types post is the published article, revision is the revised version, and page is the page

cms_article_category Article Categories

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
category_id smallint(4) NO Classification Number
category_name varchar(50) NO Category name
category_parent_id int(6) 0 NO -
category_image_url varchar(100) NO -
category_keywords varchar(100) NO Category keywords
category_desc varchar(255) NO Classification Description
category_count smallint(4) NO Number of categorized content
category_template varchar(255) NO Classification Template
category_alias varchar(50) NO -
category_order tinyint(255) unsigned 50 NO Sort by category
category_buildin tinyint(1) 0 NO Enum: 0 - not built in; 1 - built in;

cms_article_category_relationship Article relation table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
category_relationship_id mediumint(8) unsigned NO -
article_id mediumint(8) NO -
category_id smallint(4) 0 NO -
category_relationship_order mediumint(8) 0 NO -
article_status varchar(255) publish YES Article status [‘draft ‘,’publish’,’pending ‘,’Future’,’private ‘], redundant fields, for efficient retrieval
article_publish_time int(10) YES Article publishing time / redundant field - > can be changed through the background program without adding

cms_article_comment Article comment table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
comment_id bigint(20) unsigned NO Comment number
article_id bigint(20) unsigned 0 NO Article number
comment_user_ip varchar(100) NO Reviewer’s IP address
comment_time timestamp CURRENT_TIMESTAMP NO Date and time of comment
comment_content text NO Comment content
comment_karma int(11) 0 NO Comment’s karma value
comment_approved varchar(20) 1 NO Comment permission (0, 1, or ‘spam’)
comment_agent varchar(255) NO Comment agent (browser, operating system, etc.)
comment_type varchar(20) NO Meaningful comment type (pingback/trackback), which is empty in general comment type
comment_parent_id bigint(20) unsigned 0 NO -
user_id mediumint(8) unsigned 0 NO User number of reviewer after login (0 if not logged in)
comment_helpful_num int(11) unsigned 0 NO Number of helpers
comment_is_show tinyint(1) 0 NO Display (bool): 1-display; 0-not display

cms_article_comment_helpful Useful voting table for commodity evaluation

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
comment_id bigint(20) unsigned NO Comment number
user_id int(10) unsigned 0 NO Click on user number
article_id int(11) NO Article number
comment_helpful_time timestamp CURRENT_TIMESTAMP NO Evaluation time

cms_article_comment_reply Q & a response form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
comment_reply_id int(11) unsigned NO Comment reply No
comment_id int(11) 0 NO Comment number
comment_reply_parent_id int(11) 0 NO Reply parent number
article_id int(11) unsigned NO Article No
user_id int(10) unsigned 0 NO Comment reply No
user_name varchar(50) NO Comment reply name
user_id_to int(10) NO Comment reply user number
comment_reply_content varchar(255) NO Comment on the content of the reply
comment_reply_time timestamp CURRENT_TIMESTAMP NO Comment reply time
comment_reply_show_flag tinyint(1) 1 NO Does the Q & a show
comment_reply_islook tinyint(1) unsigned 0 NO Bool: 1-read; 2-unread
comment_reply_helpful_num int(11) unsigned 0 NO Number of helpers

cms_article_comment_reply_helpful Useful voting table for commodity evaluation

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
comment_reply_id bigint(20) unsigned NO Comment number
user_id int(10) unsigned 0 NO Click on user number
article_id int(11) NO Article number
comment_helpful_time timestamp CURRENT_TIMESTAMP NO Evaluation time

cms_article_group Site initialization content grouping table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
article_group_id int(10) unsigned NO number
article_group_title varchar(60) NO Title
article_group_lang varchar(5) cn NO language
article_group_sort smallint(4) unsigned 0 NO sort
article_group_logo varchar(100) NO LOGO
article_group_parent_id int(10) unsigned 0 NO Superior classification No

cms_article_id_number Article serial number table - not used temporarily. For optimization and efficiency, use redis, etc

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
article_id mediumint(8) unsigned NO Article number
article_time int(10) NO Article date
article_order mediumint(8) 0 NO The page number of the article, generally 0 if not used

cms_article_praise News likes data

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
article_id mediumint(8) NO -
article_clicked mediumint(8) YES click
article_praise mediumint(8) 0 YES give the thumbs-up
article_comment_count mediumint(9) YES Number of article comments

cms_article_read null

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
read_id mediumint(8) NO Reading number
article_id mediumint(8) NO Article number
read_ip varchar(20) NO Reader IP
read_time date NO Reading time

cms_article_recommend Recommendation form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
recommend_id mediumint(8) unsigned NO Recommendation number
article_id mediumint(8) NO Article number
recommend_type enum(‘slider’,’hot’) slider NO Recommended type
recommend_image_url varchar(100) NO Recommended picture address

cms_article_reply Q & a response form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
article_reply_id int(11) unsigned NO Comment reply No
article_reply_parent_id int(11) 0 NO Reply parent number
article_id int(11) unsigned NO Article No
user_id int(10) unsigned 0 NO Comment reply No
user_name varchar(50) NO Comment reply name
user_id_to int(10) NO Comment reply user number
user_name_to varchar(50) NO Comment reply user name
article_reply_content varchar(255) NO Comment on the content of the reply
article_reply_time timestamp CURRENT_TIMESTAMP NO Comment reply time
article_reply_show_flag tinyint(1) 1 NO Does the Q & a show
article_reply_islook tinyint(1) unsigned 0 NO Bool: 1-read; 2-unread

cms_article_tag Article label table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
tag_id int(10) unsigned NO Classification Number
tag_name varchar(50) NO Category name
tag_count smallint(4) unsigned 0 NO Number of categorized content
user_id int(11) unsigned 0 NO User number

cms_article_tag_relationship Article label relation table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
tag_relationship_id mediumint(8) unsigned NO -
article_id mediumint(8) NO -
tag_id smallint(4) 0 NO -
tag_relationship_order smallint(4) 0 NO -

invoicing_bill_type_id Purchase return type table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
bill_type_id mediumint(8) unsigned NO number
bill_type_name varchar(20) NO Purchase return type name
bill_type_desc varchar(100) NO Purchase return type remarks

invoicing_customer_base Merchant customer table - a user can belong to multiple merchant customers

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
customer_id mediumint(8) unsigned NO Customer Number
customer_number varchar(32) NO Customer Number
customer_name varchar(20) NO Customer Name
customer_type_id smallint(4) unsigned 0 NO Customer Category
customer_level_id smallint(4) unsigned 1 NO Customer Level
customer_tax_rate decimal(5,2) 0.00 NO tax rate
customer_remark varchar(200) NO Remarks
customer_bank varchar(30) NO Opening Bank
customer_card varchar(30) NO Bank account
customer_account_name varchar(50) NO Account name
customer_taxnum varchar(30) NO Taxpayer identification number
customer_invoice varchar(50) NO Invoice payable
seller_id int(10) unsigned 1 NO Business representative: employee
store_id int(10) unsigned 0 NO Shop Number
chain_id int(10) unsigned 0 NO store number
user_id int(10) unsigned 0 NO User Association

invoicing_customer_contacter Customer contact list

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
customer_contacter_id mediumint(8) unsigned NO Contact number
customer_id mediumint(8) unsigned NO Supplier Number
customer_contacter_name varchar(10) NO Contacts
customer_contacter_im varchar(30) NO Contact Im, MSN/QQ
customer_contacter_mobile bigint(11) NO Cell Phone
customer_contacter_telephone varchar(30) NO Contact seating machine
customer_contacter_district_ids varchar(20) NO Contact Area (DOT)
customer_contacter_address varchar(50) NO Contact address
customer_contacter_first tinyint(1) 1 NO Primary contact (bool): 0-non primary; 1-primary
customer_contacter_code mediumint(9) 0 NO Contacter_code

invoicing_customer_level Customer level table - pricing by customer level by default

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
customer_level_id smallint(4) unsigned NO Customer grade number
customer_level_name varchar(60) NO Customer level name (length = > 2,50)
customer_level_desc varchar(200) NO Customer Level Description
customer_level_discountrate decimal(6,2) 100.00 NO Discount percentage
customer_level_is_buildin tinyint(1) unsigned 0 NO Bool: 0-no; 1-yes
store_id int(10) unsigned 0 NO The shop under which it belongs

invoicing_stock_bill Goods receipt / issue doc table - all goods changes

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
stock_bill_id varchar(50) NO Purchase (return) Order No
stock_bill_number varchar(32) NO Purchase (return) No
stock_bill_checked tinyint(4) 0 NO Approve or not: 1-approved; 0-not approved
stock_bill_date date NO Please choose the date of the document!
stock_bill_modify_time timestamp 0000-00-00 00:00:00 NO Update time
stock_bill_time timestamp 0000-00-00 00:00:00 NO Creation time
bill_type_id smallint(4) unsigned 0 NO Business category purchase_ type_ id, sale_ type_ ID (enum): 2750 warehouse in; 2700 warehouse out; 2855 purchase order; 2850 sales order
stock_transport_type_id smallint(4) unsigned 0 NO Inventory type (enum)
store_id int(10) 0 NO The shop under which it belongs
warehouse_id int(10) unsigned 0 NO Warehouse
order_id varchar(50) NO Source doc No.: one order and one receipt / issue record can be split
stock_bill_remark varchar(255) NO Remarks
employee_id int(10) unsigned 0 NO Agent
admin_id int(10) unsigned 0 NO Maker
stock_bill_other_money decimal(20,6) 0.000000 NO Other amount
stock_bill_amount decimal(20,6) unsigned 0.000000 NO Order amount:
stock_bill_enable tinyint(1) unsigned 1 NO Whether it is valid (bool): 1-valid; 0-invalid
stock_bill_src_id varchar(50) NO Association number

invoicing_stock_bill_item Item table of receipt / issue document

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
stock_bill_item_id bigint(20) NO number
order_item_id bigint(20) unsigned 0 NO Order item table No
stock_bill_id varchar(50) NO Order Id
product_id int(10) unsigned 0 NO Product number
product_name varchar(255) NO Name of commodity
item_id bigint(20) unsigned NO Item code
item_name varchar(100) NO Name of commodity
bill_item_quantity decimal(20,6) 1.000000 NO The number of integral goods is insufficient!
bill_item_unit_price decimal(10,2) 0.00 NO Order evaluation
bill_item_subtotal decimal(10,2) 0.00 NO Subtotal
unit_id smallint(4) 0 NO Unit No
warehouse_item_quantity decimal(20,6) 0.000000 NO Inventory
store_id int(10) NO -
warehouse_id int(10) 0 NO Warehouse
stock_transport_type_id smallint(4) 0 NO Inventory type (enum)
bill_item_remark varchar(255) NO Remarks
bill_type_id smallint(4) unsigned 0 NO Business category (enum): 2750 inbound; 2700 outbound

invoicing_stock_po Purchase order form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
po_id varchar(50) NO Purchase (return) Order No
po_number varchar(32) NO Purchase (return) No
po_checked tinyint(4) 0 NO Whether to audit - 1: checked: audited 0: non checked: not audited
po_date date NO Please choose the date of the document!
po_modify_time timestamp 0000-00-00 00:00:00 NO Update time
po_time timestamp 0000-00-00 00:00:00 NO Creation time
store_id int(10) 0 NO The shop under which it belongs
supplier_id int(10) 0 NO supplier
po_remark varchar(255) NO Remarks
employee_id int(10) unsigned 0 NO buyer
admin_id int(10) unsigned 0 NO Maker
po_other_money decimal(20,6) 0.000000 NO Other amounts
po_amount decimal(20,6) unsigned 0.000000 NO Amount payable
po_items varchar(1024) NO Purchase item information

invoicing_stock_po_item Purchase order item list

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
stock_bill_item_id bigint(20) NO number
stock_bill_id varchar(50) NO Order Id
product_id int(10) unsigned 0 NO Product number
product_name varchar(255) NO Name of commodity
item_id bigint(20) unsigned NO Item code
item_name varchar(100) NO Name of commodity
bill_item_quantity decimal(20,6) 1.000000 NO The number of integral goods is insufficient!
bill_item_unit_price decimal(10,2) 0.00 NO Order evaluation
bill_item_subtotal decimal(10,2) 0.00 NO Subtotal
unit_id smallint(4) 0 NO Unit No
warehouse_item_quantity decimal(20,6) 0.000000 NO Inventory
store_id int(10) NO -
warehouse_id int(10) NO -
customer_id int(10) unsigned 0 NO Customer
supplier_id int(10) unsigned 0 NO supplier
stock_transport_type_id smallint(4) 0 NO Inventory type (enum): 4001 - purchase warehousing;
bill_type_id smallint(4) unsigned 0 NO Business category (enum): 2750 inbound; 2700 outbound
bill_item_remark varchar(255) NO Remarks

invoicing_stock_transport_type Inventory type table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
stock_transport_type_id mediumint(8) unsigned NO Stock type number
stock_transport_type_name varchar(20) NO Inventory type
stock_transport_type_text varchar(20) NO Inventory type

invoicing_supplier_base Supplier information sheet

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
supplier_id mediumint(8) unsigned NO Supplier Number
supplier_number varchar(32) NO Supplier Number
supplier_name varchar(20) NO Name of supplier
supplier_type_id smallint(4) unsigned 0 NO Supplier Category
supplier_tax_rate float(5,2) 0.17 NO VAT Tax Rate
supplier_remark varchar(200) NO Remarks
supplier_level_id mediumint(8) unsigned 0 NO -
supplier_bank varchar(30) NO Opening Bank
supplier_card varchar(30) NO Bank account
supplier_account_name varchar(50) NO Account name
supplier_taxnum varchar(30) NO Taxpayer identification number
supplier_invoice varchar(50) NO Invoice payable
store_id int(10) unsigned 0 NO Shop Number

invoicing_supplier_contacter Supplier contact list

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
supplier_contacter_id mediumint(8) unsigned NO Contact number
supplier_id mediumint(8) unsigned NO Supplier Number
supplier_contacter_name varchar(10) NO Contacts
supplier_contacter_im varchar(30) NO Contact Im, MSN/QQ
supplier_contacter_mobile bigint(11) NO Cell Phone
supplier_contacter_telephone varchar(30) NO Contact seating machine
supplier_contacter_district_ids varchar(20) NO Contact Area (DOT)
supplier_contacter_address varchar(50) NO Contact address
supplier_contacter_first tinyint(1) 1 NO Primary contact (bool): 0-non primary; 1-primary
supplier_contacter_code mediumint(9) 0 NO Contacter_code

invoicing_supplier_level Supplier level table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
supplier_level_id smallint(4) unsigned NO Supplier grade No
supplier_level_name varchar(60) NO Supplier level name
supplier_level_desc varchar(200) NO Supplier level description
store_id int(10) unsigned 0 NO The shop under which it belongs

invoicing_supplier_product Supplier list

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
supplier_product_id mediumint(8) unsigned NO Supplier item number
supplier_id mediumint(8) unsigned NO Supplier Number
product_id bigint(20) unsigned 0 NO Commodity ID

invoicing_supplier_type Supplier category table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
supplier_type_id smallint(4) unsigned NO Supplier category number
supplier_type_name varchar(20) NO Supplier category name
supplier_type_desc varchar(50) NO Supplier category note

invoicing_warehouse_base Warehouse table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
warehouse_id mediumint(8) unsigned NO Warehouse Number
warehouse_number varchar(60) NO Warehouse Number
warehouse_name varchar(120) NO Warehouse Name
warehouse_address varchar(255) NO Warehouse Address
warehouse_type_id mediumint(8) unsigned 0 NO Warehouse type No
warehouse_enable tinyint(1) unsigned 1 NO Enable warehouse (bool): 0-disable; 1-enable
warehouse_is_default tinyint(1) 1 NO Warehouse default (bool): 0 - non default; 1 - default warehouse
warehouse_contact varchar(20) NO Warehouse Contacts
warehouse_phone smallint(5) unsigned 0 NO Platform Contact
warehouse_delivery_type tinyint(1) unsigned 1 NO Shipment attribute (enum): 1-shipment warehouse; 0-stock warehouse
warehouse_delivery_ids varchar(255) NO Goods preparation warehouse number (DOT) if it is the goods preparation warehouse number bound to the delivery warehouse
store_id int(10) unsigned 0 NO The shop under which it belongs

invoicing_warehouse_item SKU storage details

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
warehouse_item_id bigint(20) NO Warehouse commodity ID
product_id mediumint(8) unsigned 0 NO Commodity ID (redundancy)
unit_id mediumint(8) unsigned 0 NO Commodity unit ID (redundancy)
item_id mediumint(8) unsigned 0 NO Goods_info_id
category_id int(11) unsigned 0 NO -
warehouse_id mediumint(8) unsigned 0 NO Warehouse Number
warehouse_item_cost decimal(20,6) 0.000000 NO cost
warehouse_item_quantity decimal(20,6) 0.000000 NO Number
warehouse_item_lock_quantity decimal(20,6) 0.000000 NO Locked inventory: actual inventory - locked inventory = available for sale inventory
warehouse_item_quantity_min mediumint(8) unsigned 0 NO -
warehouse_item_quantity_max mediumint(8) unsigned 0 NO -
store_id int(10) unsigned 0 NO -

invoicing_warehouse_type Warehouse type table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
warehouse_type_id mediumint(8) unsigned NO number
warehouse_type_name varchar(20) NO Warehouse Name
warehouse_type_desc varchar(100) NO Warehouse notes

invoicing_warehouse_warning Warehouse alarm table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
warehouse_warning_id int(10) NO primary key
warehouse_id int(10) unsigned 0 YES If the warehouse is empty, warehouse splitting will not be enabled
product_id int(10) unsigned 0 NO Commodity ID
item_id int(10) unsigned 0 NO Merchandise SKU_ If the ID is empty, the product has no auxiliary property
warehouse_warning_min int(10) unsigned 0 NO Minimum stock alarm
warehouse_warning_max int(10) unsigned 0 NO Maximum inventory alarm

live_user_room null

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
room_id int(11) NO Room number
room_name varchar(255) NO Room name
room_slogan varchar(255) NO Card number
room_pwd varchar(255) NO Room code
room_is_microphone tinyint(1) 0 NO Bool: 0-none; 1-permission
room_pattern tinyint(1) 1 NO Live mode (enum): 1-video mode; 2-pure tone mode
room_logo varchar(255) NO Room logo
room_poster varchar(255) https://static.shopsuite.cn/xcxfile/appicon/live/video-img4.jpg NO Room cover
user_id int(10) unsigned 0 NO User number
room_state tinyint(1) 0 NO Live status (bool): 0-offline; 1-live
room_stime int(10) 0 NO Live time
room_etime int(10) 0 NO Ending time
room_video varchar(255) https://txmov2.a.yximgs.com/bs2/newWatermark/MTYzNTczOTUwMjk_zh_4.mp4 NO Room video
item_id bigint(20) 0 NO Related products

pay_base_bank Settlement bank record

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
bank_id smallint(4) unsigned NO Bank Number
bank_name varchar(120) NO Bank Name
bank_remark varchar(255) NO Remarks
bank_order tinyint(4) 0 NO sort
bank_enable tinyint(1) 0 NO Whether to enable (bool): 1-enable; 0-disable
settlement_account_type_id smallint(4) 1004 NO Account category (ENUM): 1001-; WeChat; 1002- Alipay; 1003- cash; 1004- bank

pay_base_config System parameter setting table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
config_key varchar(50) NO Set key
config_value varchar(10000) NO value
config_type varchar(20) NO Classification
config_enable tinyint(1) unsigned 1 NO Status value, 1 possible, 0 not available
config_comment varchar(1024) NO Explanatory notes
config_datatype enum(‘string’,’json’,’number’,’dot’) string NO data type
config_name varchar(50) NO Set name
config_formater varchar(255) NO Output format - two outputs of key \ value
config_category enum(‘系统参数’,’基础参数’,’扩展参数’) 基础参数 NO Set type - used to view data, no use value

pay_base_recharge_level Fixed recharge table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
recharge_level_id int(11) NO number
recharge_level_name varchar(50) NO Name of quota
recharge_level_img varchar(255) NO Articles and pictures
recharge_level_value int(10) 0 NO Recharge quota
recharge_level_gift decimal(14,2) 0.00 NO Extra gift
recharge_level_validity int(10) unsigned 0 NO Validity: calculated by day
recharge_level_rate decimal(6,2) 0.00 NO Daily principal interest percentage
recharge_level_time timestamp CURRENT_TIMESTAMP NO Modification time
recharge_level_repeat tinyint(1) NO Repeat purchase (bool): 0-purchase once; 1-unlimited
recharge_level_description varchar(255) NO describe
recharge_level_duration decimal(6,2) 0.00 NO Effective time unit is year

pay_base_settlement_account Fund settlement account table user_ Bank replacement

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
settlement_account_id mediumint(8) unsigned NO Settlement account No
settlement_account_name varchar(120) NO Name of settlement account
settlement_account_number mediumint(8) NO Settlement account No
settlement_account_type_id smallint(4) unsigned NO Account category (ENUM): 1001-; WeChat; 1002- Alipay; 1003- cash; 1004- bank; 1005- pre deposit.
settlement_account_begin_date int(11) NO Balance date
settlement_account_amount_money float(10,3) NO Account balance
settlement_account_remark varchar(255) NO Remarks
settlement_account_order tinyint(4) NO -
settlement_account_enable tinyint(1) 1 NO Whether to enable (bool): 1-enable; 0-disable
user_id int(10) unsigned 0 NO Subordinate users

pay_base_settlement_account_type Fund settlement account category table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
settlement_account_type_id smallint(4) unsigned NO Fund settlement account type
settlement_account_type_name varchar(120) NO Fund settlement account category name
settlement_account_type_remark varchar(255) NO Remarks

pay_card_history Card use record

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
card_history_id int(10) unsigned NO Card use record
card_code varchar(50) NO Card number
card_type_id smallint(6) unsigned NO Card number
user_id int(10) unsigned NO User number
card_history_value decimal(20,6) 0.000000 NO Change limit
user_recharge_card decimal(20,6) 0.000000 NO Current limit
card_history_time timestamp CURRENT_TIMESTAMP NO Card generation time
store_id int(10) unsigned 0 NO The shop under which it belongs
card_history_remark varchar(255) NO Remarks

pay_card_info Card information table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
card_code varchar(50) NO Card activation code
card_password varchar(20) NO Card code
card_type_id smallint(6) unsigned NO Card number
card_fetch_time timestamp 0000-00-00 00:00:00 NO Award time
card_media_id smallint(6) unsigned 0 NO Media number
server_id int(10) unsigned 0 NO Service number of the card collector
user_id int(10) unsigned NO User number
user_account varchar(100) NO Account no. of card receiver
card_time timestamp CURRENT_TIMESTAMP NO Card generation time
store_id int(10) unsigned 0 NO The shop under which it belongs

pay_card_media Card channel table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
card_media_id mediumint(9) unsigned NO Card media number
card_media_name varchar(50) NO Media title of the card

pay_card_type Card basic information table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
card_type_id smallint(6) unsigned NO Card type number
app_id int(10) unsigned 9999 NO AppId:9999 currency
card_type_name varchar(100) NO Type name to be modified
card_type_prize varchar(1024) NO Type prize
card_type_desc varchar(255) NO Type description
card_type_starttime timestamp 0000-00-00 00:00:00 NO Effective start time
card_type_endtime timestamp 0000-00-00 00:00:00 NO Effective end time
card_type_image varchar(255) NO Card logo
store_id int(10) unsigned 0 NO The shop under which it belongs

pay_consume_deposit Recharge table - payment daily statement - payment callback use - confirm payment

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
deposit_id bigint(20) unsigned NO Payment serial number
order_id varchar(255) NO Unique order number (DOT) of merchant website: combined payment is multiple order numbers, and no joint payment transaction number has been created
deposit_trade_no varchar(255) NO Transaction No.: Alipay etc
payment_channel_id smallint(4) 0 NO Payment channel
app_id int(10) unsigned 0 NO Order source
server_id int(10) unsigned 0 NO Server ID: determine callback URL
deposit_app_id_channel int(10) unsigned 0 NO Payment channel app_id
deposit_subject varchar(255) NO Name of commodity
deposit_payment_type smallint(4) 0 NO Payment method (enum): 1301 - cash on delivery; 1302 - online payment; 1303 - white payment; 1304 - cash payment; 1305 - offline payment;
deposit_trade_status varchar(100) NO Transaction status
deposit_seller_id varchar(30) NO Seller number: Alipay etc
deposit_seller_email varchar(100) NO Payment account no. of the seller
deposit_buyer_id varchar(30) NO Buyer payment user number
deposit_buyer_email varchar(100) NO Buyer Alipay account
currency_id int(11) 86 NO Currency number
currency_symbol_left varchar(12) NO Left sign
deposit_total_fee decimal(10,2) 0.00 NO Transaction amount
deposit_quantity int(10) unsigned 1 NO Purchase Quantity
deposit_price decimal(10,2) 0.00 NO item pricing
deposit_body varchar(400) NO Commodity Description
deposit_gmt_create datetime 0000-00-00 00:00:00 NO Transaction creation time
deposit_gmt_payment datetime 0000-00-00 00:00:00 NO Transaction payment time
deposit_gmt_close datetime 0000-00-00 00:00:00 NO -
deposit_is_total_fee_adjust tinyint(1) 0 NO Adjust the total price
deposit_use_coupon tinyint(1) 0 NO Whether to use red bag buyer
deposit_discount decimal(6,3) 0.000 NO Discount?
deposit_notify_time datetime 0000-00-00 00:00:00 NO Notice time
deposit_notify_type varchar(100) NO Notification type
deposit_notify_id varchar(200) NO Notice verification number
deposit_sign_type varchar(100) NO Signature method
deposit_sign varchar(1000) NO autograph
deposit_extra_param varchar(200) NO Additional parameters
deposit_service varchar(100) NO payment
deposit_state tinyint(1) unsigned 0 NO Payment status: 0-default; 1-receive correct data processing logic; 9-abnormal order
deposit_async tinyint(1) unsigned 0 NO Synchronize or not: 0-synchronous; 1-asynchronous callback use
deposit_review tinyint(1) unsigned 0 NO Collection confirmation (bool): 0-unconfirmed; 1-confirmed
deposit_enable tinyint(3) unsigned 1 NO Void (bool): 1-normal; 2-void
store_id int(10) unsigned 0 NO Store: direct transaction works
user_id int(10) unsigned 0 NO Subordinate users
chain_id int(10) unsigned 0 NO Store: direct transaction works

pay_consume_record Transaction details - account revenue and expenditure details - fund flow statement - account amount change flow

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
consume_record_id bigint(20) NO Payment serial number
order_id varchar(255) NO Merchant order number
user_id int(10) unsigned 0 NO Number
user_nickname varchar(50) NO Username
currency_id int(11) 86 NO Currency number
currency_symbol_left varchar(12) NO Left sign
record_total decimal(10,2) 0.00 NO Denomination
record_money decimal(10,2) 0.00 NO Amount: record_ Total - Commission
record_commission_fee decimal(10,2) 0.00 NO Commission: platform Commission for sales collection
record_distribution_commission_fee decimal(10,2) 0.00 NO Distribution Commission: for sales collection
record_date date 0000-00-00 NO Year month day
record_year smallint(4) 0 NO year
record_month tinyint(2) 0 NO monthly
record_day tinyint(2) 0 NO day
record_title varchar(100) NO Title
record_desc varchar(255) NO describe
record_time timestamp CURRENT_TIMESTAMP NO Payment time
trade_type_id smallint(4) unsigned 0 NO ž‹ transaction type (enum): 1201 - shopping; 1202 - transfer; 1203 - recharge; 1204 - withdrawal; 1205 - sales; 1206 - Commission; 1207 - return payment; 1208 - return collection; 1209 - transfer collection
payment_type_id smallint(4) unsigned 0 NO Payment method (enum): 1301 - cash on delivery; 1302 - online payment; 1303 - white payment; 1304 - cash payment; 1305 - offline payment;
payment_channel_id smallint(4) unsigned 0 NO Payment channel
store_id int(10) unsigned 0 NO The shop under which it belongs
chain_id int(10) unsigned 0 NO Owned stores
payment_met_id smallint(5) unsigned 1 NO Consumption type (enum): 1-balance payment; 2-recharge card payment; 3-point payment; 4-credit payment; 5-red packet payment
record_enable tinyint(1) unsigned 1 NO Status (bool): 1-collected; 0-voided

pay_consume_trade Transaction order table - emphasize unique order - recharge order will be created first

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
consume_trade_id int(11) unsigned NO Transaction order No
trade_title varchar(100) NO Title
order_id varchar(255) NO Merchant order number
buyer_id int(10) unsigned 0 NO Buyer ID
store_id int(10) unsigned 0 NO Shop Number
subsite_id int(8) unsigned 0 NO Sub station: 0-main station
seller_id int(10) unsigned 0 NO Vendor number
chain_id int(11) unsigned NO store number
trade_is_paid smallint(4) unsigned 0 NO Payment status
order_state_id smallint(4) unsigned 1 NO The order status is incorrect!
trade_type_id smallint(1) unsigned NO Transaction type (enum): 1201 - shopping; 1202 - transfer; 1203 - recharge; 1204 - withdrawal; 1205 - sales; 1206 - Commission;
payment_channel_id smallint(4) unsigned 0 NO Payment channel
app_id int(10) unsigned 0 NO app_ ID
server_id int(10) unsigned 0 NO Server number
trade_mode_id smallint(4) unsigned 1 NO Enum: 1-secured transaction; 2-direct transaction
recharge_level_id int(11) 0 NO Recharge No
currency_id int(11) 86 NO Currency number
currency_symbol_left varchar(12) NO Left sign
order_payment_amount decimal(10,2) 0.00 NO Total payment: Trade_ payment_ amount + trade_ payment_ money + trade_ payment_ recharge_ card + trade_ payment_ points
order_commission_fee decimal(10,2) 0.00 NO Platform transaction commission
trade_payment_amount decimal(10,2) 0.00 NO Paid amount: online payment amount, which is the default payment amount of the order.
trade_payment_money decimal(10,2) 0.00 NO Balance payment
trade_payment_recharge_card decimal(10,2) 0.00 NO Recharge card balance payment
trade_payment_points decimal(10,2) 0.00 NO Point payment
trade_payment_sp decimal(10,2) 0.00 NO Zhongbao payment
trade_payment_credit decimal(10,2) unsigned 0.00 NO Credit payment
trade_payment_redpack decimal(10,2) 0.00 NO Red packet payment
trade_discount decimal(10,2) 0.00 NO Discount offer
trade_amount decimal(10,2) 0.00 NO Total virtual: Trade_ order_ amount + trade_ discount
trade_date date 0000-00-00 NO Year month day
trade_year smallint(4) unsigned 0 NO year
trade_month tinyint(2) unsigned 0 NO monthly
trade_day tinyint(2) unsigned 0 NO day
trade_desc varchar(255) NO describe
trade_remark varchar(255) NO Remarks
trade_create_time timestamp CURRENT_TIMESTAMP NO Creation time
trade_pay_time timestamp 0000-00-00 00:00:00 NO Payment time
trade_finish_time timestamp 0000-00-00 00:00:00 NO Ending time
trade_delete tinyint(1) unsigned 0 NO Delete or not

pay_consume_trade_combine Consolidated payment table, one or more orders - all payment entries - temporarily not used: Joint payment, transfer in multiple order numbers, consolidated price calculation, transfer in payment channels better?

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
ctc_id varchar(35) NO Transaction order No
order_ids varchar(1024) NO Merchant order number (DOT)
ctc_time timestamp CURRENT_TIMESTAMP NO Creation time

pay_consume_withdraw Withdrawal application form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
withdraw_id int(10) NO number
user_id int(10) unsigned 0 NO User number
store_id int(10) unsigned 0 NO The shop under which it belongs
order_id text NO Order (DOT)
withdraw_amount decimal(10,2) unsigned 0.00 NO Deduction margin
withdraw_state tinyint(2) unsigned 0 NO Withdrawal status (enum): 0-in application; 1-withdrawal passed; 2-rejection; 3-payment completed
withdraw_desc varchar(255) NO describe
withdraw_bank varchar(50) NO Bank
withdraw_account_no varchar(32) NO Bank account
withdraw_account_name varchar(50) NO Account name
withdraw_fee decimal(10,2) unsigned 0.00 NO Service charge for withdrawal
withdraw_time timestamp CURRENT_TIMESTAMP NO Creation time
withdraw_bankflow varchar(50) NO Bank account No
withdraw_user_id int(10) unsigned 0 NO Operation administrator
withdraw_opertime timestamp 0000-00-00 00:00:00 NO Operating time
withdraw_mobile varchar(255) NO Contact your cell phone
withdraw_trans_state varchar(255) YES -

pay_payment_channel Payment channel table - can be replaced with config - collection account

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
payment_channel_id smallint(4) unsigned NO number
payment_channel_code varchar(20) NO Code name
payment_channel_name varchar(100) NO title of account
payment_channel_img varchar(255) NO Icon
payment_channel_config varchar(2048) [] NO Payment Interface Configuration Information (JSON)
payment_channel_status tinyint(1) unsigned 0 NO Interface status
payment_channel_allow enum(‘both’,’wap’,’pc’) both NO Type (list): both full terminal use; WAP mobile terminal; PC PC terminal
payment_channel_wechat tinyint(4) unsigned 1 NO Whether list can be used in wechat: 1-enabled; 0-disabled
payment_channel_enable tinyint(4) unsigned 1 NO Enable (enum): 1-enable; 0-disable
payment_type_id smallint(4) unsigned 1 NO Payment method (list): 1302 online payment [white card for intra station payment balance recharging]; 1305 offline payment
payment_channel_order tinyint(1) unsigned 50 NO Sort: smaller number, higher sort
payment_channel_buildin tinyint(1) unsigned 0 NO Enum: 1-built in system; 0-offline account
store_id int(10) unsigned 0 NO Store: 0-for platform use
chain_id int(10) unsigned 0 NO Owned stores

pay_payment_type Form of payment

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
payment_type_id smallint(4) unsigned NO number
payment_type_code varchar(20) NO Code name
payment_type_name varchar(100) NO Payment name
payment_type_order tinyint(4) unsigned 50 NO sort
payment_type_remark varchar(255) NO Remarks
payment_type_enable tinyint(1) unsigned 0 NO Whether to enable (bool): 0-disable; 1-enable

pay_plantform_resource Platform Commission summary

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
plantform_resource_id int(10) unsigned NO User number
plantform_commission_fee decimal(16,6) 0.000000 NO User funds: prepayment recharge, selling goods, transfer, etc
plantform_recharge_card decimal(16,6) 0.000000 NO Top up card balance: you can only shop at all times
plantform_points decimal(16,6) 0.000000 NO Integral Exchange
plantform_credit decimal(16,6) 0.000000 NO Available credits
plantform_credit_used decimal(16,6) 0.000000 NO Use credit
plantform_credit_total decimal(16,6) 0.000000 NO Credit limit
plantform_redpack decimal(16,6) 0.000000 NO Red envelope quota
plantform_redpack_frozen decimal(16,6) 0.000000 NO Red packet frozen quota
plantform_sp decimal(16,6) 0.000000 NO Platform integral 1
plantform_bp decimal(16,6) 0.000000 NO Platform integral 2
plantform_margin decimal(16,6) 0.000000 NO Margin account
plantform_transfer_commission decimal(16,6) 0.000000 NO Amount of commission distribution for platform doc transfer

pay_service_fee Service charge

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
id int(6) NO -
name varchar(100) NO -
fee_rates float(12,2) 0.00 YES -
fee_min int(2) 0 YES -
fee_max int(2) 0 YES -

pay_trade_type Transaction type table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
trade_type_id smallint(4) NO Status number
trade_type_name varchar(50) NO The order status is incorrect!
trade_type_text varchar(20) NO Shop Name
trade_type_remark varchar(200) NO Remarks

pay_user_bank_card Statement of settlement account

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_bank_id int(11) unsigned NO Card number
user_id int(11) NO User number
bank_id int(11) 0 NO Bank Number
bank_name varchar(20) NO Bank Name
settlement_account_type_id smallint(4) 1004 NO Account category (ENUM): 1001-; WeChat; 1002- Alipay; 1003- cash; 1004- bank
user_bank_card_name varchar(50) NO Card No. account name
user_bank_card_code varchar(50) NO Bank card No
user_bank_card_address varchar(30) NO Name of opening branch
user_bank_card_time timestamp CURRENT_TIMESTAMP NO Add time of bank card
user_bank_card_mobile varchar(20) NO Bank reserved mobile number
province_id varchar(50) 0 NO Account opening province No
city_id varchar(50) 0 NO Account City No
type_id int(11) 0 NO Card type number
user_bank_default tinyint(1) NO Default cash withdrawal card currently selected by the user
user_bank_enable tinyint(4) 1 NO Bool: 1-enabled; 0-disabled
user_bank_begin_date int(11) NO Balance date
user_bank_amount_money decimal(16,6) NO Account balance

pay_user_pay User basic information table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_id int(10) unsigned NO User number
user_pay_passwd varchar(32) NO Payment confirmation password
user_pay_salt varchar(100) NO salt

pay_user_resource User resource table - fund account table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_id int(10) unsigned NO User number
currency_id int(11) 86 NO Currency number
currency_symbol_left varchar(12) NO Left sign
user_money decimal(16,6) 0.000000 NO User funds: prepayment recharge, selling goods, transfer, etc
user_money_frozen decimal(16,6) 0.000000 NO Frozen money: balance to be settled
user_recharge_card decimal(16,6) 0.000000 NO Top up card balance: you can only shop at all times
user_recharge_card_frozen decimal(16,6) 0.000000 NO Freeze recharge card: to be settled
user_points decimal(16,6) 0.000000 NO Integral Exchange
user_points_frozen decimal(16,6) 0.000000 NO Freezing Integral:
user_credit decimal(16,6) 0.000000 NO Available credits
user_credit_frozen decimal(16,6) 0.000000 NO Frozen quota
user_credit_used decimal(16,6) 0.000000 NO Use credit
user_credit_total decimal(16,6) 0.000000 NO Credit limit
user_margin decimal(16,6) 0.000000 NO Bond
user_redpack decimal(16,6) 0.000000 NO Red envelope quota
user_redpack_frozen decimal(16,6) 0.000000 NO Red packet frozen quota
user_sp_frozen decimal(16,6) 0.000000 NO Treasure to be released
user_sp_base decimal(16,6) 0.000000 NO Zhongbao Basic Households
user_sp_buy decimal(16,6) 0.000000 NO Consumer treasure
user_sp_profit decimal(16,6) 0.000000 NO Benefit Zhongbao
user_bp decimal(16,6) 0.000000 NO Exchange Golden Treasure
user_discount_num mediumint(6) unsigned 0 NO Times of preferential purchase

seller_base_menu Menu table of business center at management end

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
menu_id int(10) unsigned NO Menu number
menu_parent_id int(10) 0 NO Menu number
menu_rel varchar(20) pageTab NO -
menu_name varchar(20) NO Menu Name
menu_label varchar(50) NO Menu text
menu_order tinyint(4) unsigned 50 NO sort
menu_enable tinyint(1) unsigned 1 NO Whether to enable (bool)
menu_class varchar(255) NO class name
menu_icon varchar(20) NO Icon class
menu_bubble varchar(255) NO bubble
menu_url_mdu varchar(255) NO Module name
menu_url_ctl varchar(50) NO Controller name
menu_url_met varchar(20) NO Controller method
menu_url_parem varchar(250) NO URL parameters
menu_url varchar(100) NO Type 1 Page2 URL
menu_time timestamp 0000-00-00 00:00:00 NO Last updated

shop_activity_cutprice Bargaining history

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
ac_id int(10) unsigned NO Bargaining No
activity_id int(10) unsigned 0 NO Bargain item number
user_id int(10) unsigned 0 NO User number
ac_sale_price decimal(10,2) unsigned 0.00 NO Price after bargain
ac_datetime datetime NO Creation time
order_id varchar(20) NO Order number:
ac_mix_limit_price decimal(10,2) NO Bargaining floor price

shop_activity_cutprice_history Bargaining history

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
ach_id int(10) unsigned NO Bargaining history number
activity_id int(10) unsigned 0 NO Activity Number
user_id int(10) unsigned 0 NO Bargain users
ach_price decimal(10,2) unsigned 0.00 NO Cut down the price
item_id int(10) unsigned 0 NO Commodity ID
ach_datetime datetime 0000-00-00 00:00:00 NO Bargaining time
ac_id int(10) unsigned 0 NO Bargaining No

shop_activity_flashsale_history Stopwatch

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
afh_id int(11) unsigned NO Seckill number
activity_id int(11) unsigned 0 NO Activity Number
user_id int(11) unsigned 0 NO Seckill user number
item_id int(11) unsigned 0 NO Seckill commodity number
afh_enable tinyint(4) unsigned 1 NO Is the seckill record valid
afh_time timestamp 0000-00-00 00:00:00 NO Second kill time

shop_activity_groupbooking Formed Collage

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
gb_id int(11) unsigned NO Group number
user_id int(11) unsigned 0 NO Create group user number
activity_id int(11) NO Group activity No
gb_datetime timestamp CURRENT_TIMESTAMP NO Opening time
gb_endtime timestamp 0000-00-00 00:00:00 NO United time
gb_enable tinyint(1) unsigned 2 NO Enum: 1-success; 2-in progress; 0-failure
gb_amount_quantity int(11) NO Total number of participants
gb_quantity int(11) NO Effective number of clusters

shop_activity_groupbooking_history Group record

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
gbh_id int(11) unsigned NO Group record No
user_id int(11) unsigned 0 NO User number
activity_id int(11) NO Group purchase activity No
gbh_time timestamp CURRENT_TIMESTAMP NO Time of group purchase
order_id varchar(20) NO Group order
gb_id int(11) NO Number of participants
gbh_flag tinyint(4) unsigned 0 NO Pay or not (bool): 0-unpaid; 1-paid
gb_enable tinyint(1) 2 NO Enum: 1-success; 2-in progress; 0-failure

shop_activity_groupbuy_store Group buying formed

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
gbs_id int(11) unsigned NO Group purchase No
user_id int(11) unsigned 0 NO Create group user number
activity_id int(11) NO Group purchase activity No
gbs_datetime datetime NO Opening time
gbs_endtime datetime NO United time
gbs_enable tinyint(1) unsigned 2 NO Group purchase status (enum): 1-success; 2-in progress; 0-failure
gbs_amount_quantity int(11) NO Total number of participants in group purchase
gbs_quantity int(11) NO Effective number of clusters

shop_activity_groupbuy_store_history Group record

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
gbsh_id int(11) unsigned NO Group purchase record No
user_id int(11) unsigned 0 NO User number
activity_id int(11) NO Group purchase activity No
gbsh_time timestamp CURRENT_TIMESTAMP NO Time of group purchase
order_id varchar(20) NO Group purchase order No
gbs_id int(11) 0 NO Number of participants
gbsh_flag tinyint(4) unsigned 0 NO Pay or not (bool): 0-unpaid; 1-paid; 2-refunded
gbsh_enable tinyint(1) 2 NO Group purchase status (enum): 1-success; 2-in progress; 0-failure

shop_activity_lottery Big turntable / golden egg smashing prize list (temporarily useless)

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
al_id int(11) unsigned NO Prize Number
award_type tinyint(4) unsigned 0 NO Prize type (DOT):
activity_id int(11) unsigned 0 NO Activity Number
voucher_activity_id int(11) unsigned 0 NO When the activity prize is a coupon, the coupon activity number
awards_probability decimal(8,4) unsigned 0.0000 NO Winning percentage%
award_level tinyint(11) unsigned 0 NO Award level (emun):
award_title varchar(50) NO Name of prize
award_quantity tinyint(4) unsigned 0 NO Number of prizes
award_enabled tinyint(4) unsigned 1 NO Is the prize available

shop_activity_lottery_history Record of smashing golden eggs / big circle lottery

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
alh_id int(10) unsigned NO User winning number
user_id int(10) unsigned 0 NO User number
activity_id int(10) unsigned 0 NO Activity Number
alh_item_id int(10) unsigned 0 NO Lottery item No
alh_date date NO Date of expiration
alh_datetime datetime NO time
alh_is_send tinyint(4) unsigned 0 NO Has the prize been sent
user_name varchar(50) NO Name of recipient
user_phone varchar(50) NO Recipient’s phone number
user_address varchar(50) NO Receiving address
alh_award_flag tinyint(1) 0 NO Bool: 0-not won; 1-won

shop_activity_marketing_history Record of participants in market activities

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
amh_id int(10) unsigned NO User winning number
user_id int(10) unsigned 0 NO User number
activity_id int(10) unsigned 0 NO Activity Number
user_name varchar(50) NO -
user_phone varchar(50) NO -
user_company varchar(50) NO -
user_position varchar(50) NO -
amh_datetime datetime NO -

shop_activity_pf_groupbuy_store_history Group record

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
pfgbsh_id int(11) unsigned NO Wholesale group purchase record No
user_id int(11) unsigned 0 NO User number
item_id int(11) NO Commodity ID
activity_id int(11) NO Group purchase activity No
pfgbsh_time timestamp CURRENT_TIMESTAMP NO Time to participate in wholesale group buying
order_id varchar(20) NO Wholesale group purchase order No
pfgbsh_flag tinyint(4) unsigned 0 NO Pay or not (bool): 0-unpaid; 1-paid; 2-refunded
pfgbsh_item_num int(11) unsigned NO The number of integral goods is insufficient!
pfgbsh_enable tinyint(1) 2 NO Group purchase status (enum): 1-success; 2-in progress; 0-failure

shop_activity_zerobuy_user Zero purchase user sharing form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
zbu_id int(10) NO Zero purchase user No
zb_id int(10) NO Zero purchase activity No
product_id int(10) NO Zero purchase product No
item_name varchar(255) NO Name of zero purchase product
item_id int(10) NO Zero purchase SKU
zbu_share_num int(10) 0 NO Share times
zbu_share_time timestamp 0000-00-00 00:00:00 NO Sharing time
zbu_user_id int(10) NO Sharer No
zbu_user_nickname varchar(255) NO Sharer nickname
zbu_state int(10) 0 NO Sharing status (enum): 0-in progress; 1-completed
zb_starttime timestamp 0000-00-00 00:00:00 NO start time
zb_endtime timestamp 0000-00-00 00:00:00 NO Ending time

shop_award null

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
award_id int(11) unsigned NO Prize Number
award_type tinyint(4) unsigned 0 NO Prize type (DOT):
activity_id int(11) unsigned 0 NO Activity Number
voucher_activity_id int(11) unsigned 0 NO When the activity prize is a coupon, the coupon activity number
awards_probability decimal(8,4) unsigned 0.0000 NO Winning percentage%
award_level tinyint(11) unsigned 0 NO Award level (emun):
award_title varchar(50) NO Name of prize
award_quantity tinyint(4) unsigned 0 NO Number of prizes
award_enabled tinyint(4) unsigned 1 NO Is the prize available

shop_base_activity_type Activity type table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
activity_type_id smallint(4) unsigned NO Gift bag No
activity_type_name varchar(50) NO Activity Name
activity_type_title varchar(50) NO Activity title
activity_type_icon varchar(50) NO Icon
activity_type_category tinyint(4) 0 NO activity type
cd_num_id tinyint(4) 0 NO -
channel_id smallint(6) 0 NO Channel ID, refer to the channel table of GM
cmd_id smallint(4) 0 NO Agreement No
activity_type_tpl tinyint(4) 0 NO Activity template type
activity_type_order smallint(6) 0 NO Active sort field
activity_type_introduce varchar(100) NO Activity introduction
activity_type_prize varchar(5000) NO Activity reward JSON format
activity_type_enable tinyint(1) unsigned 0 NO Whether to enable (bool): 0-not enabled; 1-enabled

shop_base_area Regional table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
area_id mediumint(8) NO Area Number
area_name varchar(50) NO Region name - North China, northeast, East China, South China, central China, southwest, northwest, Hong Kong, Macao and Taiwan, overseas
area_parent_id mediumint(8) unsigned 0 NO Father number
area_sort smallint(6) unsigned 0 NO sort

shop_base_ask_category Classification of consulting questions

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
ask_category_id smallint(6) unsigned NO Issue classification number
ask_category_name varchar(50) NO Category name
ask_category_enable tinyint(1) unsigned 1 NO Enable (enum): 0-disable; 1-enable

shop_base_config System parameter setting table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
config_key varchar(50) NO Set key
config_value varchar(10000) NO value
config_type varchar(20) NO Classification
config_enable tinyint(1) unsigned 1 NO Status value (enum): 1-available; 0-unavailable
config_comment varchar(255) NO Explanatory notes
config_datatype enum(‘string’,’json’,’number’,’dot’) string NO Data type (list): string string; JSON; number number; dot dot
config_name varchar(50) NO Set name
config_formater varchar(255) NO Output format - two outputs of key \ value
config_category enum(‘系统参数’,’基础参数’,’扩展参数’) 基础参数 NO Set type - used to view data, no use value

shop_base_contract_type Consumer protection service form - store joining

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
contract_type_id smallint(4) NO Consumer protection number
contract_type_name varchar(50) NO Consumer Protection Name
contract_type_desc varchar(50) NO Brief description of consumer protection
contract_type_text varchar(1024) NO Description of Consumer Security
contract_type_deposit decimal(8,2) unsigned 0.00 NO Bond
contract_type_icon varchar(255) NO Project Icon
contract_type_url varchar(255) NO Description article link address
contract_type_order tinyint(3) unsigned 255 NO sort
contract_type_enable tinyint(1) unsigned 1 NO Whether to open (bool): 0-close; 1-open

shop_base_crontab Schedule of tasks

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
crontab_id int(6) unsigned NO Task No
crontab_name varchar(50) NO Shop Name
crontab_file varchar(50) NO Script
crontab_last_exe_time int(10) 0 NO Last execution time
crontab_next_exe_time int(10) 0 NO Next execution time
crontab_minute varchar(200) * NO 36-36; 37-37; 38-38; 39-39; 40-40; 41-41; 42-42; 43-43; 44-44; 45-45; 46-46; 47-47; 48-48; 49-49; 50-50; 51-51; 52-52; 53-53; 54-54; 55-55; 56-56; 57-57; 58-58; 59-59; 60-60
crontab_hour varchar(200) * NO Hours (list): * - any; 1-1; 2-2; 3-3; 4-4; 5-5; 6-6; 7-7; 8-8; 9-9; 10-10; 11-11; 12-12; 13-13; 14-14; 15-15; 16-16; 17-17; 18-18; 19-19; 20-20; 21-21; 22-22; 23-23; 24-24
crontab_day varchar(200) * NO Daily (list): * - any; 1-1; 2-2; 3-3; 4-4; 5-5; 6-6; 7-7; 8-8; 9-9; 10-10; 11-11; 12-12; 13-13; 14-14; 15-15; 16-16; 17-17; 18-18; 19-19; 20-20; 21-21; 22-22; 23-23; 24-24; 25-25; 26-26; 27-27; 28; 29-29; 30-30
crontab_month varchar(200) * NO Monthly (list): * - any; January January to January; February to February; march to March; April to April; May to May; June to June; July to July; August to August; September to September; October to October; November to November; December to December
crontab_week varchar(200) * NO Weekly (list): * - weekly; 1-monday; 2-tuesday; 3-wednesday; 4-thursday; 5-friday; 6-saturday; 7-sunday
crontab_enable tinyint(1) unsigned 1 NO Enable (enum): 0-disable; 1-enable
crontab_buildin tinyint(1) unsigned 0 NO Enum: 0-no; 1-yes
crontab_remark varchar(255) NO Remarks

shop_base_currency Currency setting table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
currency_id int(10) unsigned NO No.: telephone area code of all countries in the world
currency_title varchar(32) NO Name of currency
currency_symbol_left varchar(12) NO Left sign
currency_symbol_right varchar(12) NO Right symbol
currency_decimal_place tinyint(1) unsigned NO Decimal places
currency_exchange_rate decimal(15,8) unsigned NO exchange rate
currency_status tinyint(1) unsigned 1 NO Enable (enum): 0-disable; 1-enable
currency_time timestamp CURRENT_TIMESTAMP NO Modification time
currency_is_default tinyint(1) 0 NO Default (enum): 0-no; 1-default

shop_base_delivery_time Delivery time setting table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
delivery_time_id tinyint(4) unsigned NO Set number
delivery_time_name varchar(50) NO Set name
delivery_time_text varchar(255) NO Explanatory notes
delivery_time_enable tinyint(4) 1 NO Is it enabled?

shop_base_delivery_type Distribution method setting table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
delivery_type_id tinyint(4) unsigned NO Set number
delivery_type_name varchar(50) NO Set name
delivery_type_text varchar(255) NO Explanatory notes

shop_base_district Regional table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
district_id int(10) NO Area Number
district_name varchar(255) NO Region name
district_parent_id int(10) unsigned 0 NO Father number
district_sort smallint(6) 0 NO sort
district_area varchar(50) NO Region name - North China, northeast, East China, South China, central China, southwest, northwest, Hong Kong, Macao and Taiwan, overseas
district_is_leaf tinyint(1) 1 NO No subclass
district_level tinyint(1) 1 NO Grade
area_id mediumint(8) unsigned 0 NO Area number

shop_base_express Express delivery form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
express_id int(10) NO Express Company No
express_name varchar(30) NO Delivery company
express_pinyin varchar(30) NO Delivery company
express_pinyin_100 varchar(30) NO Express company 100
express_site varchar(255) NO Official website
express_is_fav tinyint(1) 0 NO Common or not
express_order tinyint(1) unsigned 0 NO Sorting: smaller, higher
express_enable tinyint(1) unsigned 0 NO Status (bool): 0-disabled; 1-enabled

shop_base_festival Platform Festival table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
festival_id int(10) unsigned NO Festival activity number
festival_name varchar(255) NO Activity Name
festival_category_ids varchar(255) NO Commodity classification (DOT)
festival_time int(11) NO Festival Date
festival_start_time int(11) NO start time
festival_end_time int(11) NO Ending time
festival_rate decimal(10,2) NO Floating Ratio: Percentage

shop_base_layout Page layout table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
layout_id int(10) unsigned NO Page Number
layout_name varchar(64) NO page name

shop_base_layout_module null

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
layout_module_id int(11) NO -
layout_id int(11) NO -
code varchar(64) NO -
position varchar(14) NO -
sort_order int(3) NO -

shop_base_layout_route Shop page layout routing table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
layout_route_id int(11) NO -
layout_id int(10) unsigned NO Layout number
store_id int(10) unsigned NO Shop Number
layout_route_format varchar(255) NO Routing format

shop_base_market_category Market classification table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
market_category_id mediumint(8) unsigned NO Classification Number
category_parent_id mediumint(8) unsigned 0 NO Parent number of market classification
category_name varchar(50) NO Category name
category_image varchar(255) NO Classification picture: different customer groups
category_order tinyint(1) unsigned 50 NO sort
category_level tinyint(1) unsigned 0 NO Vehicle classification
category_is_leaf tinyint(1) 1 NO Leaf node or not
category_is_enable tinyint(1) 1 NO Whether to enable (bool): 0-do not display; 1-display
market_latitude varchar(20) NO latitude
market_longitude varchar(20) NO longitude

shop_base_menu Menu table - 10 increments

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
menu_id int(10) NO Menu number
menu_parent_id int(10) 0 NO Menu number
menu_rel varchar(20) pageTab NO Open tab or not
menu_name varchar(20) NO Menu Name
menu_label varchar(50) NO Menu text
menu_icon varchar(20) NO Icon class
menu_url_ctl varchar(20) NO Controller name
menu_url_met varchar(20) NO Controller method
menu_url_parem varchar(50) NO URL parameters
menu_url varchar(255) NO Type 1 Page2 URL
menu_order tinyint(4) unsigned 50 NO sort
menu_time timestamp 0000-00-00 00:00:00 NO Last updated

shop_base_meta_item Extended field options table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
meta_item_id int(10) unsigned NO Option value
meta_key int(10) unsigned NO Option number
meta_item_name varchar(20) NO Option value name
meta_item_image varchar(255) NO Option value picture
meta_item_order tinyint(3) unsigned 50 NO -
meta_category_name varchar(20) NO List: user user; product product;

shop_base_meta_key Extended field key name table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
meta_key int(10) unsigned NO Option value
meta_name varchar(20) NO -
meta_order int(3) NO -
option_id int(11) unsigned 0 NO Option number
meta_required tinyint(1) unsigned 0 NO Required or not (bool): 0-not required; 1-required
meta_placeholder varchar(100) NO placeholder
meta_datatype varchar(20) NO Data type: email:-email;mobile :mobile;json-json;dot-dot

shop_base_option Options table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
option_id int(10) unsigned NO Option number
option_type varchar(32) NO Option name
option_sort tinyint(3) unsigned 50 NO Options sorting

shop_base_product_assist Product auxiliary property sheet

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
assist_id mediumint(8) unsigned NO Secondary attribute number
assist_name varchar(20) NO Secondary property name
type_id mediumint(8) unsigned 0 NO Type No
assist_item varchar(2048) NO Secondary attribute value (DOT)
assist_is_search tinyint(1) unsigned 0 NO Whether to be searched (bool): 0-no search; 1-search
assist_format enum(‘select’,’checkbox’,’radio’,’text’) checkbox NO Display type (list): select select; checkbox checkbox; radio radio; text text;
assist_order tinyint(3) unsigned 50 NO sort

shop_base_product_assist_item Commodity auxiliary attribute value table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
assist_item_id mediumint(8) unsigned NO Secondary attribute number
assist_item_name varchar(100) NO Secondary property value name
assist_id mediumint(8) unsigned NO Attribute No
assist_item_order tinyint(3) unsigned 50 NO Secondary attribute value sorting

shop_base_product_brand Brand list - 540

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
brand_id mediumint(8) unsigned NO Brand Number
brand_name varchar(60) NO Brand name
brand_name_pinyin varchar(255) NO Brand Pinyin
brand_initial varchar(2) NO Initials
brand_desc varchar(255) NO Brand Description
category_id mediumint(8) unsigned 0 NO Classification: first level classification
brand_show_type tinyint(1) 1 NO Enum: 1-picture; 2-text / display on the “all brands” page. If it is set to “picture”, the brand image logo of the brand will be displayed. If it is set to “text”, the brand name of the brand will be displayed
brand_image varchar(255) NO Brand LOGO
brand_recommend tinyint(1) 0 NO Recommended or not (enum): 1-yes; 0-no
brand_enable tinyint(1) 1 NO Enable (enum): 1-enable; 0-disable
store_id int(10) unsigned 0 NO Shop Number
brand_apply tinyint(1) 1 NO Brand application (enum): 0-in application; 1-through the / application function is used by members, and the system background defaults to 1

shop_base_product_category Commodity classification table - classification emphasizes difference and type emphasizes commonness

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
category_id mediumint(8) unsigned NO Commodity classification No
category_parent_id mediumint(8) unsigned 0 NO Item classification parent number
category_name varchar(50) NO Category name
category_image varchar(255) NO Classification picture: different customer groups
type_id mediumint(8) unsigned 1001 NO Commodity type No
category_virtual_enable tinyint(1) unsigned 0 NO Allow virtual products (enum): 1-yes; 0-no
category_show_type enum(‘COLOR’,’SPU’) COLOR NO Enum: color-color; spu-spu
category_commission_rate decimal(6,2) unsigned 0.00 NO Percentage of commission
category_order tinyint(1) unsigned 50 NO sort
category_level tinyint(1) unsigned 0 NO Commodity classification level - redundancy
category_is_leaf tinyint(1) 1 NO Leaf node redundancy or not
category_is_enable tinyint(1) 1 NO Whether to enable (bool): 0-do not display; 1-display
page_id bigint(20) NO Mobile page number
page_id_pc bigint(20) NO PC page number

shop_base_product_category_mobile Mobile home page classification

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
category_id mediumint(8) unsigned NO Commodity category number - used by first level classification
category_name varchar(50) NO Category name
category_alias varchar(50) NO Classified aliases
category_image varchar(255) NO Classified pictures
page_id bigint(20) unsigned 1 NO Page Number
category_order tinyint(3) unsigned 50 NO sort

shop_base_product_category_nav Product category navigation table - first page classification

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
category_id mediumint(8) unsigned NO Commodity category number - used by first level classification
category_name varchar(50) NO Category name
category_alias varchar(50) NO Classified aliases
category_image varchar(255) NO Classified pictures
category_ids_recommend text NO Recommended classification (JSON)
item_ids_recommend text NO Recommended products (DOT)
brand_ids_recommend varchar(2048) NO Recommended brand (DOT)
category_nav_adv varchar(2048) [] NO Advertising data (JSON)
temp_type tinyint(3) unsigned 1 NO Template classification (enum): 1-classification template 1; 2-product template
category_order tinyint(3) unsigned 50 NO sort

shop_base_product_category_recommend_item Recommended products under product classification - recommended products will be displayed on the product list page when searching by product classification, and the display position is above the main product list.

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
category_id mediumint(8) unsigned NO Commodity category number - used in the last level of classification
items_ids_recommend text NO Recommended classification (DOT)

shop_base_product_category_tag Product category tag table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
category_id mediumint(8) unsigned NO Last level number of commodity classification
category_ids varchar(255) NO Commodity classification (DOT)
category_tags varchar(255) NO Classification mark (DOT)

shop_base_product_extension Product extension property sheet

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
extension_id mediumint(8) unsigned NO Extended attribute number
extension_name varchar(20) NO Extended attribute name
type_id mediumint(8) unsigned 0 NO Type
extension_item_ids varchar(2048) NO Secondary attribute value (DOT)
extension_is_search tinyint(1) unsigned 0 NO Whether to be searched (bool): 0-text does not search; 1-search
extension_format enum(‘select’,’checkbox’,’radio’,’text’) checkbox NO Display type (list): select select; checkbox checkbox; radio radio; text text;
extension_order tinyint(3) unsigned 50 NO sort

shop_base_product_extension_item Product extension attribute value table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
extension_item_id mediumint(8) unsigned NO Secondary attribute number
extension_item_name varchar(100) NO Secondary property value name
extension_id mediumint(8) unsigned NO Attribute No
extension_item_order tinyint(3) unsigned 50 NO Secondary attribute value sorting

shop_base_product_kind Commodity category table - physical goods (logistics delivery) virtual goods (no logistics required) cannot be modified after publishing

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
kind_id smallint(4) unsigned NO Item No
kind_name varchar(20) NO Commodity category name
kind_remark varchar(50) NO Commodity type remarks

shop_base_product_spec Product specifications

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
spec_id mediumint(8) unsigned NO Specification category No
spec_name varchar(20) NO Service Category Name
spec_remark varchar(50) NO Specification category note
spec_format enum(‘text’,’image’) text NO Display type (enum): text text; image picture
spec_order smallint(6) unsigned 50 NO sort
spec_category_id mediumint(8) unsigned 0 NO Specification classification No.: it is not a commodity type number. Select a classification and it can be associated to any level of classification. (you can use the primary category_ ID, only works in the background shortcut location) - no need to create a new classification table management.
spec_buildin tinyint(3) unsigned 0 NO Enum: 1-yes; 0-no

shop_base_product_state Product status table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_state_id smallint(4) unsigned NO Commodity status: 1001 normal; 1002 in off shelf warehouse; 1003 to be reviewed; 1000 illegal prohibition
product_state_name varchar(50) NO Product status status
product_state_text_1 varchar(255) NO Product status
product_state_text_2 varchar(255) NO Product status
product_state_remark varchar(255) NO Remarks

shop_base_product_tag Product label table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_tag_id mediumint(8) unsigned NO Commodity label No
product_tag_name varchar(255) NO Commodity label name

shop_base_product_type Commodity type table - emphasize commonness, category cat is emphasize difference

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
type_id mediumint(8) unsigned NO number
type_name varchar(20) NO Type name to be modified
type_remark varchar(50) NO Remarks
type_is_assist tinyint(4) unsigned 0 NO Enable auxiliary properties (enum): 1-yes; 0-no
type_is_param tinyint(4) unsigned 0 NO Enable parameter (enum): 1-yes; 0-no
type_is_brand tinyint(4) unsigned 0 NO Enable brand (enum): 1-yes; 0-no
type_is_entity tinyint(4) unsigned 0 NO Enable enum: 1-yes; 0-no
type_category_id mediumint(8) unsigned 0 NO Classification number - can be associated to any level of classification. (you can use the primary category_ ID, only works in the background shortcut location) - to cancel the shortcut location function, better implement it through UI interaction
type_is_draft tinyint(1) unsigned 1 NO Draft (enum): 1-draft; 0-publish
type_spec_ids varchar(255) NO Specification ID (DOT)
type_brand_ids varchar(255) NO Brand Number
type_assist_ids varchar(255) NO Auxiliary properties (DOT)
type_buildin tinyint(1) unsigned 0 NO Enum: 1-built in; 0-not built in

shop_base_product_type_brand_rel Product type and brand relationship table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
type_brand_id int(10) unsigned NO Primary key, many to many must have
type_id mediumint(8) unsigned 0 NO Type Number
brand_id mediumint(8) unsigned 0 NO Brand Number

shop_base_product_type_spec_rel Corresponding table of commodity type and specification

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
type_spec_id int(10) unsigned NO -
type_id mediumint(8) unsigned NO Type Number
spec_id mediumint(8) unsigned NO Specification No

shop_base_product_unit Commodity UOM table - provides the function of modifying and adding categories - 530

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
unit_id mediumint(8) unsigned NO Commodity unit of measurement No
parent_unit_id mediumint(8) unsigned 0 NO Item UOM parent number
unit_name varchar(20) NO Name of Commodity Measurement Unit
unit_remark varchar(50) NO Comments on Commodity Measurement Units
unit_rate varchar(20) 0 NO Conversion relationship
unit_guid varchar(11) NO Gu No
unit_is_base tinyint(1) unsigned 0 NO Basic Unit
unit_type_id mediumint(8) unsigned NO Commodity unit of measurement classification No
unit_is_buildin tinyint(1) unsigned 0 NO Enum: 0-not built-in; 1-built-in weight and length unit, built-in

shop_base_product_unit_type Commodity unit of measurement category table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
unit_type_id mediumint(8) unsigned NO Commodity unit of measurement classification No
parent_unit_type_id mediumint(8) unsigned 0 NO Commodity UOM classification parent No
unit_type_name varchar(255) NO Commodity unit of measurement classification name
unit_type_remark varchar(50) NO Notes on the classification of commodity units of measurement
unit_type_is_buildin tinyint(1) unsigned 0 NO Enum: 0-not built-in; 1-built-in weight and length unit, built-in

shop_base_product_verify Product audit information form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_verify_id smallint(4) unsigned NO Audit status No
product_verify_name varchar(50) NO Audit status status
product_verify_text_1 varchar(255) NO Audit status:
product_verify_text_2 varchar(255) NO Audit status:
product_verify_remark varchar(255) NO Remarks

shop_base_protocol Basic communication protocol table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
cmd_id mediumint(8) unsigned NO Agreement No
ctl varchar(50) NO Controller class name
met varchar(50) NO Controller method
mdu varchar(50) NO -
db enum(‘master’,’slave’) master NO Connection database type
typ enum(‘e’,’json’,’msgpcak’,’amf’) json NO Default type of output data
rights_id smallint(4) 0 NO Authority number
log tinyint(1) 0 NO Log or not
struct varchar(100) NO Generate structure, independent use
comment varchar(255) NO notes
0 varchar(255) int16_t:cmd_id NO First field
1 varchar(255) NO -
2 varchar(255) NO -
3 varchar(255) NO -
4 varchar(255) NO -
5 varchar(255) NO -
6 varchar(255) NO -
7 varchar(255) NO -
8 varchar(255) NO -
9 varchar(255) NO -
10 varchar(255) NO -
11 varchar(255) NO -
12 varchar(255) NO -
13 varchar(255) NO -
14 varchar(255) NO -
15 varchar(255) NO -
16 varchar(255) NO -
17 varchar(255) NO -
18 varchar(255) NO -
19 varchar(255) NO -
20 varchar(255) NO -
21 varchar(255) NO -
22 varchar(255) NO -
23 varchar(255) NO -
24 varchar(255) NO -
25 varchar(255) NO -
26 varchar(255) NO -
27 varchar(255) NO -
28 varchar(255) NO -
29 varchar(255) NO -
30 varchar(255) NO -
31 varchar(255) NO -
32 varchar(255) NO -

shop_base_readme Instruction sheet

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
readme_key varchar(50) NO Set key (JSON)
readme_comment varchar(255) NO Annotation (JSON)
dfadf mediumint(9) YES -
dfff timestamp CURRENT_TIMESTAMP NO Creation time

shop_base_site_nav Page navigation table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
nav_id int(11) NO Navigation number
nav_type tinyint(1) 0 NO Category (enum): 0-custom navigation; 1-product classification; 2-article navigation; 3-activity navigation
nav_item_id int(10) unsigned 0 NO Category content No
nav_title varchar(100) NO Navigation title
nav_url varchar(255) NO Navigation Links (HTML)
nav_position tinyint(1) 0 NO Navigation position (enum): 0-head; 1-middle; 2-bottom
nav_target_blank tinyint(1) 0 NO Open as a new window (bool): 1-yes; 0-no
nav_image varchar(255) NO Navigation pictures
nav_dropdown_menu varchar(20000) NO Navigation drop-down content (HTML)
nav_order tinyint(3) unsigned 50 NO sort
nav_enable tinyint(1) unsigned 1 NO Whether to enable (bool): 1-yes; 0-no
nav_buildin tinyint(4) unsigned 0 NO Enum: 1-yes; 0-no

shop_base_state_code Status code table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
state_code_id smallint(4) unsigned NO Commodity status: 1001 normal; 1002 in off shelf warehouse; 1003 to be reviewed; 1000 illegal prohibition
state_code_name varchar(50) NO Product status status
state_code_text_1 varchar(255) NO Product status
state_code_text_2 varchar(255) NO Product status
state_code_text_3 varchar(255) NO -
state_code_code varchar(255) NO CODE
state_code_remark varchar(255) NO Remarks
state_category varchar(255) NO Classification

shop_base_state_code_lang Status code table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
lang_id int(10) unsigned NO number
state_code_id smallint(4) NO Commodity status: 1001 normal; 1002 in off shelf warehouse; 1003 to be reviewed; 1000 illegal prohibition
state_code_text_1 varchar(255) NO Product status
state_code_text_2 varchar(255) NO Product status
state_code_text_3 varchar(255) NO -
lang varchar(255) NO Language

shop_base_store_category Store classification platform settings

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_category_id int(10) unsigned NO Shop classification number
store_category_name varchar(50) NO Shop classification
store_category_deposit decimal(10,2) 0.00 NO Amount of deposit (yuan)
store_category_order tinyint(1) unsigned 255 NO Display Order
category_ids varchar(50) NO Commodity classification (DOT)

shop_base_store_grade Shop level table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_grade_id smallint(4) unsigned NO Shop level number
store_grade_name varchar(50) NO -
store_grade_fee decimal(6,2) 0.00 NO Charge standard - charge standard, single: yuan / year, must be a number, will be displayed in the front desk when members open or upgrade the store
store_grade_desc varchar(255) NO Application Note
store_grade_product_limit mediumint(8) 0 NO Number of publishable products 0: Unlimited
store_grade_album_limit mediumint(8) unsigned 0 NO Number of uploadable pictures
store_grade_template varchar(50) NO Shop Optional Template
store_grade_function_id varchar(50) NO Additional functions available - function_ editor_ multimedia
store_grade_sort mediumint(8) 0 NO Level - a higher value indicates a higher level

shop_base_store_template Shop template table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_template_name varchar(100) NO Store template name – find the corresponding file according to the template name
store_style_name varchar(255) NO Style name
store_template_img varchar(255) NO Image corresponding to template

shop_base_user_tag User label table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
tag_id int(10) NO User tag number
tag_order int(10) NO Label sorting
tag_name varchar(50) NO Label Name
tag_image varchar(255) NO Label picture
tag_recommend tinyint(1) 0 NO Recommended or not: 0-not recommended; 1-recommended
tag_content varchar(1024) NO Label description
tag_time timestamp CURRENT_TIMESTAMP NO Creation time

shop_base_user_type User classification table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_type_id smallint(4) unsigned NO Customer category number
user_type_name varchar(20) NO Customer category name
user_type_remark varchar(50) NO Customer category notes

shop_chain_base Store list

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
chain_id int(10) unsigned NO store number
store_id int(10) unsigned 0 NO The shop under which it belongs
chain_name varchar(20) NO Name of store
chain_mobile varchar(20) NO Phone number
chain_telephone varchar(30) NO Contact number:
chain_contacter varchar(20) NO Contacts
chain_lng varchar(20) 0 NO longitude
chain_lat varchar(20) 0 NO latitude
chain_district_info varchar(255) NO address
chain_district_id varchar(255) NO Area Number
chain_address varchar(255) NO Please enter the store’s detailed address.
chain_opening_hours varchar(255) NO Business Hours
chain_close_hours varchar(255) NO Closing time
chain_traffic_line varchar(255) NO Traffic routes
chain_img varchar(255) NO Shop Pictures
chain_time timestamp CURRENT_TIMESTAMP NO Add time

shop_chain_company Organization company information form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
company_id int(10) unsigned NO Company No
user_id int(10) unsigned 0 NO Subordinate users
chain_id int(10) unsigned NO store number
company_name varchar(50) NO Full name of enterprise
company_area varchar(50) NO Location of company
company_address varchar(100) NO Address: Please enter the detailed address of the company
company_zipcode varchar(255) NO Zip code: Please enter the company zip code
company_phone varchar(255) NO Phone: Please enter the company phone number
company_website varchar(255) NO Company website: Please enter the company website
company_description varchar(255) NO Company profile: Please enter company profile
contacts_name varchar(255) NO Contacts
contacts_position varchar(255) NO position
contacts_phone varchar(255) NO Contact telephone
contacts_email varchar(255) NO Contact email
company_registered_capital int(10) unsigned 0 NO Registered funds
company_employee_count int(10) unsigned 0 NO Total number of employees
company_taxnum varchar(20) NO Unified social credit code
company_invoice varchar(50) NO Invoice payable
legal_person varchar(50) NO Name of legal representative
legal_person_number varchar(50) NO Corporate Identity Card Number
legal_person_electronic varchar(255) NO Electronic version of corporate identity card
business_license_location varchar(255) NO Business license
establish_date date NO date of establishment
business_licence_start date NO The Starting Time of Statutory Business Scope
business_licence_end date NO Ending time of statutory scope of business
business_sphere varchar(255) NO Scope of business
business_license_electronic varchar(255) NO Business license
organization_code varchar(20) NO Organizational code
organization_code_start date NO Start time of validity of organization code certificate
organization_code_end date NO End of validity period of organization code certificate
organization_code_electronic varchar(255) NO Organizational Code Certificate Electronic Edition
general_taxpayer varchar(255) NO General taxpayer certificate
bank_account_name varchar(50) NO Bank Account Name
bank_account_number varchar(30) NO Company bank account
bank_name varchar(50) NO Name of branch of deposit bank
bank_code varchar(20) NO Bank Branch Interbank Number of Account Opening Bank
bank_address varchar(255) NO Location of branch of deposit-opening bank
bank_licence_electronic varchar(255) NO Electronic version of deposit bank license
tax_registration_certificate varchar(20) NO Tax Registration Certificate Number
tax_registration_certificate_electronic varchar(255) NO Electronic version of tax registration certificate number
payment_voucher varchar(255) NO Payment vouchers
payment_voucher_explain varchar(255) NO Payment vouchers
store_class_ids text NO Business Category
store_class_names text NO Collection of Store Management Category Names
store_class_commission text NO The percentage of commission in shop management category
contacts_fee float(10,2) NO Fee standard
contacts_deposit float(10,2) NO Bond
business_id varchar(20) 0 NO Business license
payment_type tinyint(1) unsigned 0 NO Payment methods: 1- WeChat; 2- Alipay; 3- bank transfer.

shop_chain_config Store parameter setting table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
chain_id int(10) unsigned NO store number
cc_state tinyint(1) unsigned 0 NO Order receiving setting (bool): 0-open order receiving; 1-stop order receiving
cc_day_max int(10) unsigned 0 NO Daily maximum order quantity

shop_chain_item Store list - can have store price

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
chain_item_id int(10) NO -
chain_id int(10) 0 NO store number
store_id int(10) 0 NO Shop number
item_id int(10) 0 NO Commodity ID
product_id int(10) 0 NO Commodity common_id
chain_item_quantity decimal(10,2) 0.00 NO Commodity inventory
chain_item_unit_price decimal(10,2) 9.00 NO -

shop_chain_user Store user table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
chain_user_id int(10) unsigned NO User number
user_id int(10) unsigned NO Membership Number
chain_id int(10) unsigned 0 NO Owned stores
store_id int(10) unsigned NO Shop Number

shop_distribution_base_config This table is abandoned – system parameter setting table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
config_key varchar(50) NO Set key
config_value varchar(10000) NO value
config_type varchar(20) NO Classification
config_enable tinyint(1) unsigned 1 NO Status value, 1 possible, 0 not available
config_comment varchar(255) NO Explanatory notes
config_datatype enum(‘string’,’json’,’number’,’dot’) string NO data type
config_name varchar(50) NO Set name
config_formater varchar(255) NO Output format - two outputs of key \ value
config_category enum(‘系统参数’,’基础参数’,’扩展参数’) 基础参数 NO Set type - used to view data, no use value

shop_distribution_order_base This table is obsolete - order details

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_id varchar(50) NO Order number:
store_distributor_id int(10) unsigned 0 NO distributor
order_distribution_seller_type tinyint(1) unsigned 1 NO So order distribution type 1: direct sales (E) 2: distribution, consignment and forwarding sales (P, SP)
order_distribution_buyer_type tinyint(1) unsigned 1 NO Po order type 1: purchase (e purchase, SP: consignment purchase) 2: distribution purchase, place order on behalf of customer (beginning with P)
order_source_id varchar(50) 0 NO Source order No. (P beginning): P beginning order corresponding to sp beginning order
directseller_flag tinyint(1) unsigned 0 NO Salesman promotion
directseller_id_0 int(10) unsigned 0 NO Sales promotion - order
directseller_id_1 int(10) 0 NO Push officials to higher levels
directseller_id_2 int(10) NO -
directseller_discount decimal(10,2) unsigned 0.00 NO Level discount amount
buyer_flag tinyint(1) 0 NO -
buyer_id_0 int(10) 0 NO Promoter
buyer_id_1 int(10) 0 NO -
buyer_id_2 int(10) 0 NO -
order_time int(11) NO -
order_state_id smallint(4) unsigned 2011 NO Order status (list): 2011 pending order review; 2013 pending financial review; 2020 pending distribution / issue review; 2030 pending delivery; 2040 confirmed delivery / receipt; 2060 completed / signed in; 2070 cancelled / voided;
buyer_user_id int(10) 0 NO Buyer ID

shop_distribution_order_item Discard this table - order distribution goods relation table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_item_id int(10) NO number
order_id varchar(50) NO Order Id
item_id int(10) NO Commodity ID
product_id int(10) 0 NO Product_ ID
distributor_commission_0 decimal(16,6) unsigned 0.000000 NO Distributor’s income - price difference of our sales
distributor_commission_1 decimal(16,6) unsigned 0.000000 NO Primary distributor revenue
distributor_commission_2 decimal(16,6) unsigned 0.000000 NO Income of secondary distributors
directseller_commission_0 decimal(16,6) unsigned 0.000000 NO Promotion commission paid
directseller_commission_1 decimal(16,6) unsigned 0.000000 NO Promotion commission paid
directseller_commission_2 decimal(16,6) unsigned 0.000000 NO Promotion commission paid
buyer_commission_0 decimal(16,6) unsigned 0.000000 NO Promotion commission paid
buyer_commission_1 decimal(16,6) unsigned 0.000000 NO Promotion commission paid
buyer_commission_2 decimal(16,6) unsigned 0.000000 NO Promotion commission paid
directseller_id_0 int(10) unsigned 0 NO Promotion salesman
directseller_id_1 int(10) unsigned 0 NO Promotion superior
directseller_id_2 int(10) unsigned 0 NO Promotion superior
directseller_item_discount decimal(10,2) unsigned 0.00 NO Level discount amount
buyer_id_0 int(10) unsigned 0 NO Push officials
buyer_id_1 int(10) unsigned 0 NO -
buyer_id_2 int(10) unsigned 0 NO -
order_item_time int(10) unsigned 0 NO time

shop_distribution_plantform_user This record cannot be changed,

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_id int(10) unsigned NO User number
user_parent_id int(10) 0 NO Superior user number - registration decision, cannot be changed, promotion fairness consideration
user_partner_id int(10) unsigned 0 NO City partner
user_time int(11) unsigned 0 NO Registration time
user_team_count int(10) 0 NO Team size
user_level_id mediumint(10) 1001 NO User Level
user_province_team_id int(10) 0 NO Provincial company
user_city_team_id int(10) 0 NO City company
user_county_team_id int(10) 0 NO District company
role_level_id mediumint(10) 1001 NO Role level

shop_distribution_plantform_user_generated_commission Summary of commission generated by platform promotion fans

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
ugc_id varchar(255) NO Contribution Commission No.: user_ id + ‘-‘ + level
user_id mediumint(8) unsigned NO Promote fans
user_parent_id mediumint(11) unsigned 0 NO Superior promoter No
ugc_level tinyint(4) unsigned 1 NO Promotion level: 1 parent, 2 grandfather, the record remains the same. If the relationship changes, add other records
ugc_amount decimal(16,6) unsigned 0.000000 NO Generate Commission
ugc_num int(11) unsigned 0 NO Order Quantity
user_time int(11) unsigned 0 NO Registration time

shop_distribution_product This table is abandoned - public content table of goods - future separable table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_id bigint(20) unsigned NO Commodity ID
product_lock_flag tinyint(1) 0 NO The shop must have a distribution flag (bool): 1-can’t be deleted; 0-can be deleted
product_agent_id int(10) unsigned 0 NO All subordinates of the shop belong to the agent. Changeable
product_distributor_flag tinyint(1) unsigned 0 NO Bool: 0-own goods; 1-distributed goods
product_is_allow_update tinyint(1) unsigned 1 NO Whether the content can be modified (bool): 0-no; 1-yes
product_is_allow_price tinyint(1) unsigned 1 NO Whether the price can be modified (bool): 0-no; 1-yes
product_is_behalf_delivery tinyint(1) 1 NO Bool: 0-no; 1-yes
store_parent_id int(10) unsigned 0 NO Commodity source - Supplier shop number
product_parent_id int(10) 0 NO Distribution of original products

shop_distribution_product_item Commodity list

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
item_id int(10) unsigned NO Commodity ID
item_recommended_price decimal(10,0) 0 NO Suggested retail price
item_recommended_min_price decimal(10,2) 0.00 NO Suggested minimum retail price
item_recommended_max_price decimal(10,2) 0.00 NO Suggested maximum retail price
item_parent_id int(10) unsigned 0 NO Commodity source No

shop_distribution_store_agent Shop agent list.

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_agent_id int(10) unsigned 0 NO -
store_id int(10) unsigned 0 NO Shop No
agent_id int(10) unsigned 0 NO Distributor id = shop_ ID
agent_parent_id int(10) unsigned 0 NO Superior No

shop_distribution_store_agent_generated_commission Commission summary of agent contribution - the record is generated only when the agent develops the sub agent. -Emphasize agent’s Commission contribution to superior. Emphasis on commission created by agents

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
agc_id varchar(255) NO Commission contributed by users to different stores: user_ id + shop_ id + level
directseller_id mediumint(8) unsigned NO Salesman user number
directseller_name varchar(30) NO -
directseller_parent_id mediumint(11) NO Parent user number
directseller_parent_name varchar(30) NO -
agc_level tinyint(4) 1 NO User level - distribution level: 1 parent, 2 grandparent, the record remains the same. If the relationship changes more, other records will be added
agc_amount decimal(16,6) unsigned 0.000000 NO Sales commission

shop_distribution_store_agent_level Agent level table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
agent_level_id tinyint(3) unsigned NO Agent grade No
agent_leve_name varchar(50) NO Rank Name
agent_leve_discount_rate decimal(6,2) 0.00 NO Grade discount
agent_leve_freeshipping varchar(255) 0 NO Package setting - after opening, the agent of this level will sell or purchase all goods free of freight
agent_leve_order mediumint(8) unsigned 0 NO sort
store_id int(10) unsigned 0 NO Shop Number

shop_distribution_store_base This table is obsolete - store basic information table - distribution store source relationship record (superior). This record can be changed under special circumstances.

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_id int(10) unsigned NO Shop Number
store_parent_id int(10) unsigned 0 NO Superior store number - store creation decision, distributor - cannot be changed! Commission equity considerations
store_type tinyint(1) unsigned 1 NO Shop type: 1-seller’s shop; 2: supplier’s shop

shop_distribution_store_commission Income statement - agency / distribution / promotion

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_id int(10) unsigned NO Shop Number
commission_amount decimal(15,6) 0.000000 NO Total Commission
commission_distributor_amount_0 decimal(15,6) 0.000000 NO Our distribution Commission
commission_distributor_amount_1 decimal(15,6) 0.000000 NO Primary distribution Commission
commission_distributor_amount_2 decimal(15,6) 0.000000 NO Secondary distribution Commission
commission_agent_amount_0 decimal(15,6) unsigned 0.000000 NO Commission of primary agent
commission_agent_amount_1 decimal(15,6) unsigned 0.000000 NO Commission of secondary agent
commission_agent_amount_2 decimal(15,6) unsigned 0.000000 NO Commission of third level agent

shop_distribution_store_directseller List of shop promotion salesmen.

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_directseller_id int(10) unsigned NO -
store_id int(10) unsigned 0 NO Shop No
directseller_id int(10) unsigned 0 NO Promotion salesman id = user_ ID
directseller_parent_id int(10) unsigned 0 NO Superior ID - because the stores are different, the superior may be different. If the user actively becomes a salesperson of a store, the superior ID is 0
directseller_enable tinyint(1) unsigned 1 NO Approved or not: 0-to be approved 1-approved
directseller_create_time datetime NO Creation time

shop_distribution_store_directseller_config Store salesperson parameter setting table meta

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_id int(10) unsigned NO Shop Number
allow_seller_buy tinyint(1) unsigned 0 NO Salesman’s purchase authority - when the purchase authority is enabled, the orders purchased by the salesman himself will be included in the performance
auto_settle tinyint(1) unsigned 1 NO Settlement method 0 - Manual settlement 1 - automatic settlement
cps_rate int(10) unsigned 0 NO Primary commission ratio
second_is_enable tinyint(1) unsigned 1 NO Secondary sales 0 close 1 open
second_cps_rate int(10) unsigned 0 NO Secondary commission ratio
directseller_customer_exptime int(10) unsigned 0 NO Customer relationship period: after a certain period of time, the customers brought by the salesperson (the time when the customers who become the store start to calculate) will no longer enjoy the sub Commission. The commission can be generated only when the consumer consumes the first time in the store and within a certain period of time.
directseller_exptime_type tinyint(1) unsigned 1 NO 1. Permanent, establish customer relationship, the purchase of customers in the store will be divided into commission. 2. In the short term, you can only get commission according to the link purchase, and after a certain period of time, the link fails. No customer relationship needed
directseller_rel_exptime int(10) unsigned 0 NO Customer relationship protection period - the brought customer relationship will not be stolen within a certain period of time. Other sales can take effect through the purchase link, but the relationship will be changed within the protection period
is_verify tinyint(1) unsigned 0 NO Salesperson approval 0 does not need approval 1 needs approval
settle_time_type int(10) unsigned 0 NO Settlement time
third_cps_rate int(10) unsigned 0 NO Ratio of three-tier Commission distribution
expenditure int(10) unsigned 0 NO Consumption

shop_distribution_store_directseller_customer Shop promotion salesman customer list.

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_directseller_customer_id int(10) unsigned 0 NO -
directseller_id int(10) unsigned 0 NO Promotion salesman id = user_ ID
store_id int(10) unsigned 0 NO Shop No
customer_id int(10) unsigned 0 NO Customer number = user_ ID - this can be changed, when the customer purchases according to the other seller’s link, the relationship will be changed

shop_distribution_store_directseller_generated_commission Summary of commission generated by shop promotion salesperson contribution - salesperson promotion salesperson generates record. -Emphasize the relationship between salesman and superior and commission contribution to superior. Emphasize commissions created by salespeople

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
dgc_id varchar(255) NO Commission contributed by users to different stores: user_ id + shop_ id + level
directseller_id mediumint(8) unsigned NO Salesman user number
directseller_parent_id mediumint(11) unsigned NO Parent user number
dgc_level tinyint(4) unsigned 1 NO User level - distribution level: 1 parent, 2 grandparent, the record remains the same. If the relationship changes more, other records will be added
dgc_amount decimal(16,6) unsigned 0.000000 NO Sales commission

shop_distribution_store_directseller_level Salesman level table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
directseller_level_id tinyint(3) unsigned NO Distributor level number
directseller_leve_name varchar(50) NO Rank Name
directseller_leve_discount_rate decimal(6,2) 0.00 NO Grade discount
directseller_leve_freeshipping varchar(255) 0 NO Package setting - after opening, all goods of this level will be free of freight
directseller_leve_order mediumint(8) unsigned 0 NO sort
store_id int(10) unsigned 0 NO Shop Number

shop_distribution_store_directseller_product Sales promotion product list.

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_directseller_product_code varchar(255) NO Unique number of user promotion products
directseller_id int(10) unsigned 0 NO Promotion salesman id = user_ ID
store_id int(10) unsigned 0 NO Shop No
product_id int(10) unsigned 0 NO Product number
directseller_images_image varchar(1024) NO Merchandise Pictures
directseller_time datetime NO Add time
item_price decimal(10,2) 0.00 NO Order evaluation
item_id bigint(20) 0 NO SKU number

shop_distribution_store_distributor Store distributor list. -Different suppliers can have the same distributor

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_distributor_id int(10) unsigned NO -
store_id int(10) unsigned 0 NO Shop No
distributor_id int(10) unsigned 0 NO Distributor id = shop_ ID
distributor_level_id int(10) unsigned 0 NO Distributor level number
distributor_parent_id int(11) unsigned 0 NO Parent ID - the source when joining this distribution store - develops its own distributor usage for different suppliers. If there is a supplier market, this field can be discarded
distributor_enable tinyint(1) 1 NO Approved or not: 0-to be approved; 1-passed; - 1 failed
distributor_cat_ids varchar(1024) NO Authorization classification of distribution goods: ‘,’ split. Suppliers authorize the classification of distributable goods of distributors. Goods not classified cannot be distributed.
store_distributor_time datetime NO Application time
store_distributor_reason varchar(255) NO Audit reason

shop_distribution_store_distributor_generated_commission Distributor contribution generates Commission Summary - only when distributor develops sub distributors can records be generated. -Emphasize the Commission contribution of distributors to their superiors. Emphasize the commission created by distributors FGC = distributor_ generated_ commission

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
fgc_id varchar(255) NO Commission contributed by users to different stores: user_ id + shop_ id + level
distributor_id mediumint(8) unsigned 0 NO Distributor id = shop_ ID
distributor_parent_id mediumint(11) unsigned NO Parent user number
fgc_level tinyint(4) unsigned 1 NO Distribution level: 1 parent, 2 grandfather, the record remains the same. If the relationship changes, add other records
fgc_amount decimal(16,6) unsigned 0.000000 NO Distribution sales corresponding level commission

shop_distribution_store_distributor_level Distributor level table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
distributor_level_id int(10) unsigned NO Distributor level number
distributor_leve_name varchar(50) NO Rank Name
distributor_leve_discount_rate decimal(6,2) 0.00 NO Grade discount
distributor_leve_freeshipping varchar(255) 0 NO Package setting - after opening, all goods of this level will be free of freight
distributor_leve_order mediumint(8) unsigned 0 NO sort
store_id int(10) unsigned 0 NO Shop Number

shop_distribution_store_distributor_product_cat Authorized classification of distributable goods

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
cat_id int(9) NO -
cat_name varchar(50) NO Classification name
cat_parent_id int(11) 0 NO Superclass
cat_pic varchar(255) NO Classified pictures
type_id int(10) 0 NO Type Number
cat_commission float 0 NO Ratio of three-tier Commission distribution
cat_is_wholesale tinyint(1) 0 NO -
cat_is_virtual tinyint(1) 0 NO Allow virtual or not
cat_templates varchar(100) 0 NO -
cat_displayorder smallint(3) 255 NO sort
cat_level tinyint(1) NO Classification level
cat_show_type tinyint(4) 1 NO 1: SPU 2: color

shop_distribution_store_team Supplier team table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
team_id int(10) unsigned NO Note name (in=>88,23): 0- no rebate; 1- percentage rebate; 2- difference
team_name varchar(255) NO Team name
team_type tinyint(1) unsigned 1 NO Team type: Delegation
team_image varchar(255) NO Team portrait
distributor_level_id tinyint(3) unsigned 0 NO League member level
team_chat_flag tinyint(1) unsigned 1 NO Group chat
team_verify_flag tinyint(1) unsigned 0 NO Group audit
team_leader_id int(10) 0 NO Set up a team leader
team_performance_flag tinyint(1) 0 NO Team performance: allow ordinary members to view performance
team_split_type tinyint(1) unsigned 0 NO Rebate mode: 0-no rebate; 1-percentage rebate; 2: grade difference rebate difference
team_invisible tinyint(1) 0 NO Secret team: after opening, users cannot search for the team in the platform
team_permit varchar(255) 0 NO Head of delegation (DOT): the supplier can authorize the head of delegation to adjust the delegation level. After authorization, the head of delegation can modify the delegation level in the app
store_id int(10) unsigned 0 NO Supplier
team_amount decimal(15,6) unsigned 0.000000 NO Accumulated turnover
team_quantity int(10) unsigned 0 NO Cumulative volume

shop_distribution_store_team_member Supplier team member table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
team_member_id int(10) unsigned NO Team member number
team_id int(10) unsigned 0 NO Team number
store_id int(10) unsigned 0 NO Shop Number

shop_distribution_store_type This table is obsolete – store type

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_type_id int(10) unsigned NO Shop Number
store_type_name varchar(255) NO Type name to be modified

shop_distribution_user Platform promoter

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_id int(10) unsigned NO User number
user_fans_num int(10) unsigned 0 NO Number of fans: redundancy
user_is_sp tinyint(1) 0 NO Bool: 0-no; 1-yes;
user_is_da int(11) 0 NO Zone agent (bool): 0-no; 1-yes is zone ID;
user_is_ca int(11) 0 NO City agent (bool): 0-no; 1-yes is city ID;
user_is_pa int(11) 0 NO Bool: 0 - no; 1 - yes is the province ID;
user_is_pt tinyint(1) unsigned 0 NO Bool: 0-no; 1-yes;
user_active tinyint(1) unsigned 1 NO Valid or not (bool): 0 - not valid; 1 - valid
user_time int(11) unsigned 0 NO Registration time
role_level_id int(11) 0 NO Grade number

shop_distribution_user_commission Promoter and income statement - user earned summary

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_id int(10) unsigned NO Shop Number
commission_amount decimal(15,6) 0.000000 NO Total Commission: total historical amount
commission_directseller_amount_0 decimal(15,6) 0.000000 NO Salesman’s Commission
commission_directseller_amount_1 decimal(15,6) NO Secondary salesman
commission_directseller_amount_2 decimal(15,6) NO Level 3 salesman
commission_buy_amount_0 decimal(15,6) 0.000000 NO Promotion Commission
commission_buy_amount_1 decimal(15,6) 0.000000 NO Consumption Commission
commission_buy_amount_2 decimal(15,6) 0.000000 NO Consumption Commission
commission_click_amount_0 decimal(15,6) 0.000000 NO Our traffic Commission
commission_click_amount_1 decimal(15,6) 0.000000 NO First level flow Commission
commission_click_amount_2 decimal(15,6) 0.000000 NO Secondary flow Commission
commission_reg_amount_0 decimal(15,6) 0.000000 NO Our Registration Commission
commission_reg_amount_1 decimal(15,6) 0.000000 NO First level Registration Commission
commission_reg_amount_2 decimal(15,6) 0.000000 NO Secondary Registration Commission
commission_settled decimal(15,6) unsigned 0.000000 NO Commission settled
commission_directseller_settled decimal(15,0) 0 NO Salesman has settled
commission_buy_settled decimal(15,6) 0.000000 NO Promoter has settled
commission_buy_da decimal(15,6) 0.000000 NO District agency income
commission_buy_ca decimal(15,6) 0.000000 NO City agency income
commission_directseller_da decimal(15,6) 0.000000 NO District agency income
commission_directseller_ca decimal(15,6) 0.000000 NO City agency income
commission_buy_trade_0 decimal(15,6) 0.000000 NO Total transactions
commission_buy_trade_1 decimal(15,6) 0.000000 NO Total transactions
commission_buy_trade_2 decimal(15,6) 0.000000 NO Total transactions
commission_buy_da_trade decimal(15,6) 0.000000 NO Total transactions
commission_buy_ca_trade decimal(15,6) 0.000000 NO Total transactions
commission_directseller_trade_0 decimal(15,6) 0.000000 NO Total transactions
commission_directseller_trade_1 decimal(15,6) 0.000000 NO Total transactions
commission_directseller_trade_2 decimal(15,6) 0.000000 NO Total transactions
commission_directseller_da_trade decimal(15,6) 0.000000 NO Total transactions
commission_directseller_ca_trade decimal(15,6) 0.000000 NO Total transactions
commission_partner_buy_trade decimal(15,6) unsigned 0.000000 NO Total partner transactions
commission_partner_directseller_trade decimal(15,6) unsigned 0.000000 NO Total partner transactions
commission_partner_deposit_trade decimal(15,6) unsigned 0.000000 NO Total recharge of partners
commission_distributor_amount decimal(15,6) 0.000000 NO Distributor revenue
commission_salesperson_amount decimal(15,6) 0.000000 NO Sales revenue
commission_refund_amount decimal(15,6) 0.000000 NO Refund total Commission

shop_distribution_user_order Promotion order income statement

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
uo_id int(11) unsigned NO Order revenue number
user_id int(10) unsigned 0 NO User No.: superior ID, get commission promoter
order_id varchar(50) NO Order Id
uo_buy_commission decimal(15,6) 0.000000 NO Promoter Commission
uo_directseller_commission decimal(15,6) 0.000000 NO Salesman’s Commission
buyer_user_id int(10) 0 NO Buyer ID
store_id int(11) 0 NO Shop Number
uo_level smallint(4) 0 NO Grade
uo_time int(11) unsigned 0 NO time
uo_active tinyint(1) unsigned 0 NO Valid or not (bool): 0 - not valid; 1 - valid
uo_remark varchar(255) NO Remarks
uo_is_paid tinyint(1) 0 NO Valid or not (bool): 0-unpaid; 1-paid
uo_paytime int(11) 0 NO Payment time
uo_receivetime int(11) 0 NO Receiving time

shop_distribution_user_order_item Income statement of promotion order goods

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
uoi_id int(11) unsigned NO Order revenue number
user_id int(10) unsigned 0 NO User number
order_id varchar(50) NO Order Id
product_id int(10) unsigned NO Commodity ID
item_id int(10) unsigned NO Commodity SKU
uoi_buy_commission decimal(15,6) 0.000000 NO Promoter Commission
uoi_directseller_commission decimal(15,6) 0.000000 NO Salesman’s Commission
uoi_distributor_commission decimal(15,0) 0 NO Distributor’s income - price difference of our sales
buyer_user_id int(10) unsigned NO Buyer ID
uoi_level smallint(4) 0 NO Grade
uoi_time int(11) unsigned 0 NO time
uoi_active tinyint(1) unsigned 0 NO Valid or not (bool): 0 - not valid; 1 - valid
store_id int(11) 0 NO Shop Number
uoi_is_paid tinyint(1) 0 NO Valid or not (bool): 0-unpaid; 1-paid
uoi_receivetime int(11) 0 NO Receiving time

shop_distribution_user_withdraw Commission transfer to balance application form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
duw_id int(10) NO number
user_id int(10) unsigned 0 NO Member payment No
duw_amount decimal(10,2) unsigned 0.00 NO Deduction margin
duw_state tinyint(2) unsigned 0 NO Success or not (bool): 0-in application; 1-withdrawal passed
duw_user_id int(10) unsigned 0 NO Operation administrator
duw_time timestamp CURRENT_TIMESTAMP NO Creation time

shop_log_action User behavior log table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
log_id bigint(20) unsigned NO Log number
user_id mediumint(10) 0 NO Player ID
user_account varchar(100) NO Role account
user_name varchar(20) NO Role name
action_id mediumint(8) 0 NO Behavior ID: Protocol_ id -> rights_ ID
action_type_id mediumint(9) NO Operation type No.: right_ parent_ ID
log_param varchar(1024) NO Requested parameters
log_ip varchar(20) NO Log IP
log_date date NO Log date
log_time timestamp CURRENT_TIMESTAMP NO Record time

shop_message_template Message template table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
message_id varchar(100) NO Message template number
message_code varchar(100) NO Message template key
message_name varchar(100) NO Message template name
message_email_title varchar(100) NO Mail Title
message_email_content varchar(1024) NO Mail content
message_content varchar(255) NO Content of Station Letter
message_sms varchar(255) NO Short Message Content
message_type tinyint(1) 1 NO Message type (enum): 1-User; 2-merchant; 3-platform;
message_enable tinyint(1) unsigned 0 NO In station notification (bool): 0-disabled; 1-enabled
message_sms_enable tinyint(1) unsigned 0 NO Short message notification (bool): 0-disabled; 1-enabled
message_email_enable tinyint(1) unsigned 0 NO Mail notification (bool): 0-disabled; 1-enabled
message_wechat_enable tinyint(1) unsigned 0 NO Wechat notification (bool): 0-disabled; 1-enabled
message_sms_force tinyint(1) unsigned 0 NO Mobile message (bool): 0-not mandatory; 1-mandatory
message_email_force tinyint(1) unsigned 0 NO Mail (bool): 0-not enforced; 1-enforced
message_force tinyint(1) unsigned 0 NO Bool: 0-not mandatory; 1-mandatory
message_category tinyint(1) unsigned 0 NO Common tips: 1 - order transaction notice; 2 - balance card voucher reminder; 3 - after sales service message
message_order tinyint(2) 50 NO sort
message_tpl_id varchar(50) NO Huawei template No
message_tpl_sender varchar(255) NO Huawei signature management channel number

shop_number_seq ID management table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
prefix varchar(20) NO prefix
number int(10) unsigned 1001 NO Growth value

shop_order_base Order details - Retrieve rows regardless of table, cache

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_id varchar(50) NO Order Id
order_number varchar(50) NO Order No. for internal use in mall
order_time timestamp CURRENT_TIMESTAMP NO Order time
order_payment_amount decimal(10,2) 0.00 NO Amount payable / amount payable: order_ goods_ amount - order_ discount_ amount + order_ shipping_ fee - order_ voucher_ price - order_ points_ fee - order_ adjust_ Fee
currency_id int(11) 86 NO Currency number
currency_symbol_left varchar(12) NO Left sign
store_id int(10) unsigned 0 NO Seller shop number
store_name varchar(50) NO Seller’s shop name
buyer_user_id int(10) unsigned 0 NO Buyer ID
buyer_user_name varchar(50) NO Name of buyer
order_state_id smallint(4) 2010 NO Order status (list): 2011 pending order review; 2013 pending financial review; 2020 pending distribution / issue review; 2030 pending delivery; 2040 confirmed delivery / receipt; 2060 completed / signed in; 2070 cancelled / voided;

shop_order_cancel_reason Order cancellation reason table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
cancel_reason_id mediumint(4) unsigned NO Order cancellation reason No
cancel_reason_name varchar(50) NO Order cancellation reason

shop_order_cb Cross border order information form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_id varchar(50) NO Order Id
order_cb_flag tinyint(1) 2 NO Cross border order (bool): 0-no; 1-yes
order_cb_sync tinyint(1) 2 NO Whether to declare (bool): 0-no; 1-yes
order_cb_pay_req tinyint(1) 2 NO Push payment request information (bool): 0-no; 1-yes
order_cb_pay_res tinyint(1) 2 NO Original information when pushing payment (bool): 0-no; 1-yes
order_cb_transfer tinyint(1) 2 NO Push logistics information (bool): 0-no; 1-yes
order_cb_ts tinyint(1) 2 NO Push logistics information change (bool): 0-no; 1-yes
order_cb_list tinyint(1) 2 NO Push logistics list (bool): 0-no; 1-yes
order_cb_pay_res_data varchar(1024) NO Payment result parameters
order_cb_pay_req_data varchar(1024) NO Payment request parameters

shop_order_chain_code Virtual exchange code store self collection exchange code table pickupcode

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_id varchar(50) NO Order Id
chain_id int(11) 0 NO store number
item_id int(10) unsigned 0 NO Order item number
chain_code varchar(50) NO Virtual code: pickupcode
chain_code_status int(10) unsigned 0 NO Virtual code status (enum): 0-not used; 1-used; 2-frozen
chain_code_usetime timestamp 0000-00-00 00:00:00 NO Usage time of virtual exchange code
virtual_service_date date 0000-00-00 NO -
virtual_service_time timestamp 0000-00-00 00:00:00 NO -
user_id int(11) unsigned 0 NO User number
store_id int(10) unsigned 0 NO Shop Number
product_validity_end int(11) 0 NO Expiration time

shop_order_comment Order shop evaluation form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_id varchar(50) NO Order Id
store_id int(10) unsigned 0 NO Seller Store Number - Redundancy
store_name varchar(50) NO Shop Name
user_id int(10) unsigned 0 NO Buyer ID
user_name varchar(50) NO Name of buyer
comment_points decimal(10,2) 0.00 NO Obtain Integral-Redundancy, Independent Table Records
comment_scores tinyint(4) unsigned 3 NO Evaluation of Star 1-5 Integral
comment_content varchar(255) NO Evaluation content
comment_image varchar(1000) NO Comments uploaded pictures: / split multiple pictures
comment_helpful int(10) 0 NO To be helpful to
comment_nohelpful int(10) 0 NO No help
comment_time timestamp CURRENT_TIMESTAMP NO Evaluation time
comment_is_anonymous tinyint(1) unsigned 0 NO Anonymous evaluation
comment_enable tinyint(1) unsigned 1 NO Status of evaluation information (bool): 1-normal display; 0-forbidden display
comment_store_desc_credit tinyint(1) unsigned 5 NO Description matching score-order_buyer_evaluation_status, no need to comment again after the evaluation status changes, follow the order
comment_store_service_credit tinyint(1) unsigned 5 NO Service Attitude Score - order_buyer_evaluation_status
comment_store_delivery_credit tinyint(1) unsigned 5 NO Delivery Speed score - order_buyer_evaluation_status

shop_order_data Order details

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_id varchar(50) NO Order Id
order_desc varchar(200) NO Order description
order_delay_time int(11) 0 NO Delay time, default to 0 - receipt confirmation
delivery_type_id tinyint(4) unsigned 0 NO express type
delivery_time_id tinyint(4) 1 NO Delivery time: requirements, unlimited, Monday to Friday, weekend, etc
delivery_time date NO Delivery time
delivery_time_rang tinyint(2) 0 NO Irregular delivery
delivery_time_h tinyint(2) NO When scheduled delivery
delivery_time_i tinyint(2) YES Regular distribution points
delivery_istimer tinyint(1) 0 NO Scheduled delivery or not (0: irregular 1: Regular)
invoice_type_id tinyint(1) 0 NO Invoice type (enum): 0-none; 1-normal; 2-electronic; 3-value added
invoice_company_code varchar(100) NO Taxpayer identification number
order_invoice_title varchar(100) NO Invoice information
order_message varchar(255) NO Buyer’s order message
order_item_amount decimal(10,2) 0.00 NO Total price of goods / amount of goods, excluding freight
order_discount_amount decimal(10,2) 0.00 NO Discount price / total discount amount
order_adjust_fee decimal(10,2) 0.00 NO Manual adjustment fee shop discount
order_points_fee decimal(10,2) 0.00 NO Points deduction expense
order_shipping_fee_amount decimal(10,2) 0.00 NO Freight price / freight amount
order_shipping_fee decimal(10,2) 0.00 NO Actual freight amount - modifiable by seller
voucher_id int(10) 0 NO Coupon ID / coupon / cashback: release option
voucher_number varchar(32) NO Voucher code
voucher_price decimal(10,2) 0.00 NO Face value of voucher
redpacket_id int(10) 0 NO Red envelope ID platform voucher
redpacket_number varchar(32) NO Red packet code
redpacket_price decimal(10,2) 0.00 NO Red envelope denomination
order_redpacket_price decimal(10,2) 0.00 NO Red packet offset order amount
order_resource_ext1 decimal(10,2) 0.00 NO Second, resources such as points need to be paid
order_resource_ext2 decimal(10,2) 0.00 YES The Release of Treasures
order_resource_ext3 decimal(10,2) 0.00 YES Exchange Golden Treasure
trade_payment_money decimal(10,0) 0 NO Balance payment
trade_payment_recharge_card decimal(10,2) 0.00 NO Charge Card Payment
trade_payment_credit decimal(10,2) 0.00 NO Credit payment
order_refund_status tinyint(1) unsigned 0 NO Refund status: 0 - no refund; 1 - partial refund; 2 - full refund
order_refund_amount decimal(10,2) 0.00 NO Refund amount - redundant not used
order_return_status tinyint(1) unsigned 0 NO Return status (enum): 0 - no return; 1 - partial return; 2 - all return
order_return_num int(10) unsigned 0 NO Quantity of returns:
order_return_ids varchar(200) NO Return order No. s (DOT): redundant
order_commission_fee decimal(10,2) 0.00 NO Platform transaction commission
order_commission_fee_refund decimal(10,2) 0.00 NO Transaction commission - refund
order_points_add int(11) 0 NO Bonus points for orders
order_promotion_info varchar(255) NO Promotional information
order_cancel_identity tinyint(1) 0 NO Order canceller identity (enum): 1-buyer; 2-seller; 3-system
order_cancel_reason varchar(255) NO Order cancellation reason
order_cancel_time timestamp 0000-00-00 00:00:00 NO Order cancellation time
order_bp_add int(10) 0 NO Complimentary resource 2
order_rebate decimal(10,2) 0.00 NO Order rebate
buyer_mobile int(11) YES -
order_heka varchar(255) YES -

shop_order_delivery_address Receiving address table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_id varchar(50) NO Order Id
da_name varchar(10) NO Contacts
da_mobile varchar(20) NO Phone number
da_telephone varchar(30) NO Contact number:
da_contacter varchar(20) NO Contacts (not enabled)
da_im varchar(255) NO Contact Im: QQ
da_province_id int(10) 0 NO Province No
da_province varchar(50) NO Province
da_city_id int(10) 0 NO City No
da_city varchar(50) NO city
da_county_id int(10) unsigned 0 NO county
da_county varchar(50) NO County Area
da_address varchar(255) NO Detailed address
da_postalcode varchar(30) NO Postal Code
da_tag_name varchar(50) 0 NO Address tag: home, company, etc
da_time timestamp CURRENT_TIMESTAMP NO Add time
da_longitude varchar(20) NO longitude
da_latitude varchar(20) NO Latitudinal reading

shop_order_exchange Exchange order form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_return_id bigint(20) unsigned NO number
order_id varchar(50) NO Order Id
refund_id varchar(100) NO Refund No
member_id int(10) unsigned NO Buyer ID
seller_id int(10) unsigned NO Vendor number
product_id int(10) NO Commodity ID
item_id int(10) 0 NO Commodity ID
refund_price float(10,2) NO Amount of refund:
reason varchar(255) NO reason
status tinyint(1) 1 NO Unknown state
order_return_item_status tinyint(1) 0 NO Cargo status
type tinyint(1) 0 NO unknown type
create_time int(10) unsigned NO Creation time
close_reason varchar(255) NO Cause of closure
refuse_reason varchar(255) NO Reason for rejection

shop_order_info Order information form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_id varchar(50) NO Order Id
order_title varchar(50) NO Order Title
store_id mediumint(8) 0 NO Seller shop number
subsite_id int(8) unsigned 0 NO Sub station: 0-main station
buyer_user_id int(10) 0 NO Buyer ID
kind_id smallint(4) unsigned 0 NO Order type (enum): 1201 - physical; 1202 - virtual; 1203 - electronic card voucher; 1204 - take out order
order_lock_status tinyint(3) unsigned 0 NO Lock status (bool): 0-normal; 1-locked, refund and return
order_is_settlemented tinyint(1) unsigned 0 NO Order settled (bool): 0 - unsettled; 1 - settled
order_settlement_time timestamp 0000-00-00 00:00:00 NO Order settlement time
order_buyer_evaluation_status tinyint(1) 0 NO Enum: 0 - not evaluated; 1 - evaluated; 2 - expired not evaluated
order_seller_evaluation_status tinyint(1) 0 NO Seller evaluation status (enum): 0-not evaluated; 1-evaluated; 2-expired not evaluated
order_year smallint(4) unsigned 0 NO Order year - index query
order_month tinyint(2) unsigned 0 NO Order month index query
order_day tinyint(2) unsigned 0 NO Order date index query
order_time int(11) unsigned 0 NO Order time: retrieve usage
order_deal_time int(11) unsigned 0 NO Processing time of current state
order_buyer_hidden tinyint(1) 0 NO Buyer delete (bool): 1-yes; 0-no
order_shop_hidden tinyint(1) 0 NO Shop delete (bool): 1-yes; 0-no
payment_type_id int(4) unsigned 2 NO Payment method (enum): 1301 - cash on delivery; 1302 - online payment; 1303 - white payment; 1304 - cash payment; 1305 - offline payment;
payment_time timestamp 0000-00-00 00:00:00 NO Payment time
order_state_id smallint(4) unsigned 10 NO Order status (list): 2011 pending order review; 2013 pending financial review; 2020 pending distribution / issue review; 2030 pending delivery; 2040 confirmed delivery / receipt; 2060 completed / signed in; 2070 cancelled / voided;
order_is_review tinyint(1) unsigned 0 NO Order approval (bool): 0 - not approved; 1 - approved;
order_finance_review tinyint(1) unsigned 0 NO Financial status (bool): 0 - not approved; 1 - approved
order_is_paid smallint(4) unsigned 3010 NO Payment status (enum): 3010 unpaid; 3011 pending payment; 3012 partial payment; 3013 paid
order_is_out smallint(4) unsigned 3020 NO Outbound status (enum): 3020 - not outbound; 3021 - partial outbound solves this problem by splitting documents; 3022 - outbound
order_is_shipped smallint(6) 3030 NO Shipment status (enum): 3030 - not shipped; 3031 - shipped; 3032 - partial shipped
order_is_received smallint(4) unsigned 0 NO Receiving status (bool): 0-not received; 1-received
chain_id int(10) unsigned 0 NO store number
delivery_type_id tinyint(4) 0 NO express type
order_is_offline tinyint(1) unsigned 0 NO Offline order (bool): 0-online; 1-offline
cart_type_id tinyint(1) unsigned 1 NO Purchase type (enum): 1-purchase; 2-point exchange; 3-complimentary; 4-event promotion
order_express_print tinyint(1) unsigned 0 NO Whether to print (bool): 0-not printed; 1-printed
activity_id varchar(50) 0 NO Activity number (DOT)
activity_type_id varchar(50) 0 NO Activity type (DOT)
salesperson_id int(10) 0 NO Salesman No.: user No
order_is_sync tinyint(1) 0 NO ERP synchronization (bool): 0-not synchronized; 1-synchronized
store_is_selfsupport tinyint(1) 1 NO Whether it is self operated (enum): 1 - self operated; 0 - non self operated
store_type tinyint(1) 1 NO Shop type (enum): 1-seller’s shop; 2-supplier’s shop
order_erp_id varchar(100) NO ERP order number
distributor_user_id int(10) 0 NO Distributor No.: user No
order_is_cb tinyint(1) 0 NO Cross border order (bool): 0-no; 1-yes
order_is_cb_sync tinyint(1) 0 NO Whether to declare (bool): 0-no; 1-yes
src_order_id varchar(50) NO Source order

shop_order_invoice Order invoice management form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_invoice_id int(11) NO Invoice No
order_id varchar(50) NO Order Id
user_id int(11) unsigned 0 NO Subordinate users
store_id int(11) NO Shop Number
invoice_title varchar(50) NO Invoice payable
invoice_content varchar(50) NO Invoice contents:
invoice_amount decimal(16,6) unsigned 0.000000 NO Invoiced amount
invoice_company_code varchar(100) NO Taxpayer identification number
invoice_type enum(‘company’,’person’) person NO Invoice type (enum): person individual; company company company
invoice_kind tinyint(1) unsigned 2 NO Invoice type (enum): 1-paper invoice; 2-electronic invoice
invoice_status tinyint(1) unsigned 0 NO Billing status (bool): 0 - not invoiced; 1 - invoiced;
invoice_datetime datetime 0000-00-00 00:00:00 NO -

shop_order_item Order item list

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_item_id bigint(20) NO number
order_id varchar(50) NO Order Id
buyer_id int(10) unsigned 0 NO Buyer user_id redundancy
store_id int(10) 0 NO Shop Number
product_id bigint(20) unsigned NO Product number
item_id bigint(20) unsigned NO Item code
item_name varchar(100) NO Name of commodity
category_id mediumint(8) 0 NO Category number corresponding to commodity
spec_id int(10) 0 NO Specification No
spec_info varchar(255) NO Specification description
item_unit_price decimal(10,2) unsigned 0.00 NO Unit price of commodity price
item_unit_points decimal(10,2) 0.00 NO Unit price of resource 1
item_unit_sp decimal(10,2) NO Unit price of resource 2
order_item_unit_price decimal(10,2) 0.00 NO Unit Price of Actual Transaction Price of Commodity
item_platform_price decimal(10,2) 0.00 NO Platform price
item_cost_price decimal(10,2) 0.00 NO cost
order_item_quantity smallint(5) unsigned 1 NO The number of integral goods is insufficient!
order_item_image varchar(255) NO Merchandise Pictures
order_item_return_num smallint(5) unsigned 0 NO Quantity of returns:
order_item_return_subtotal decimal(10,2) 0.00 NO Total refund
order_item_amount decimal(10,2) 0.00 NO Actual total amount of goods: goods_ pay_ unit_ price * goods_ quantity
order_item_discount_amount decimal(10,2) 0.00 NO Negative Preferential Amount
order_item_adjust_fee decimal(10,2) 0.00 NO Manual adjustment of negative amount
order_item_points_fee decimal(10,2) 0.00 NO Integral Cost
order_item_payment_amount decimal(10,2) unsigned 0.00 NO Paid in amount: goods_ payment_ amount = goods_ amount + goods_ discount_ amount + goods_ adjust_ fee + goods_ point_ Fee
order_item_evaluation_status tinyint(1) unsigned 0 NO Evaluation status (enum): 0-not evaluated; 1-evaluated; 2-failure evaluation
activity_type_id int(11) unsigned 0 NO Activity type (enum): 0-default; 1101-premium purchase = matching treasure; 1102-full store gift - small gift; 1103 - limited time discount; 1104 - discount package; 1105 - store voucher coupon; 1106 - group; 1107 - full discount; 1108 - step price; 1109 - point exchange
activity_id int(11) 0 NO Promotion ID: and activity_ type_ Use with ID, group purchase ID / limited time discount ID / special package ID / point exchange No
order_item_commission_rate decimal(6,2) unsigned 0.00 NO Percentage of commission
order_item_commission_fee decimal(10,2) unsigned 0.00 NO Distribution Commission
policy_discountrate decimal(6,2) unsigned 100.00 NO Price policy discount rate
item_voucher decimal(10,2) 0.00 NO Allocate coupon quota
order_item_note varchar(100) NO Remarks
order_item_file varchar(255) NO Order attachment
order_item_confirm_file varchar(255) NO Merchant accessories
order_item_confirm_status tinyint(1) 0 NO Buyer confirmation status (bool): 0-confirmed; 1-confirmed
design_file_images varchar(500) 0 NO Five figures
order_item_saler_id int(11) 0 NO Item distributor No
item_src_id bigint(20) 0 NO Distribution item number
order_item_supplier_sync tinyint(1) 0 NO Split order synchronization status
src_order_id varchar(50) NO Source order

shop_order_item_supplier Order item list

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_item_supplier_id bigint(20) NO Order item No
order_id varchar(50) NO Order Id
item_id bigint(20) unsigned 0 NO SKU number
item_src_id bigint(20) 0 NO Supplier SKU number
order_item_supplier_sync tinyint(1) 0 NO Synchronization status

shop_order_logistics Order delivery logistics information table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_logistics_id bigint(20) NO Order logistics number
order_id varchar(50) NO Order Id
stock_bill_id varchar(50) NO Receipt / issue doc id = stock_ bill_ ID
order_tracking_number varchar(50) NO Order logistics No. airway bill number
logistics_explain varchar(50) NO Seller notes delivery note
logistics_time timestamp CURRENT_TIMESTAMP NO Delivery time delivery time
logistics_id mediumint(8) NO Corresponding Express Company
logistics_name varchar(30) NO Logistics Name
logistics_number varchar(50) NO Logistics Company Number
logistics_phone varchar(20) NO Delivery contact number
logistics_mobile varchar(20) NO Delivery contact mobile
logistics_contacter varchar(100) NO Delivery contact
logistics_tax varchar(20) NO Delivery fax
logistics_address varchar(100) NO Delivery contact address
logistics_zip varchar(20) NO -
logistics_enable tinyint(1) unsigned 1 NO Whether it is valid (bool): 1-valid; 0-invalid

shop_order_meta Order extension table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
meta_id varchar(50) NO Meta id:data_ id-meta_ Key
data_id varchar(50) 0 NO order_ ID
meta_key varchar(255) NO key
meta_value varchar(4096) NO value
meta_datatype enum(‘string’,’json’,’number’,’dot’) string NO data type

shop_order_payment Payment information table - one order can record multiple payments.

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_payment_id bigint(20) unsigned NO Payment order No
order_id varchar(50) NO Order Id
payment_need_amount decimal(20,2) 0.00 NO Payment required = order_ payment_ Amount) - balance payment order_ point_ fee-gift_ card_ price-payment_ offline
order_point_sub decimal(10,2) 0.00 NO Use points
order_point_fee decimal(10,2) 0.00 NO Integral Cost
gift_card_id int(8) 0 NO Gift card ID: enter the number to use
gift_card_number varchar(32) NO Gift card code
gift_card_price decimal(10,2) 0.00 NO Gift card denomination
payment_cash decimal(10,2) 0.00 YES Cash of account balance
order_point_add int(10) unsigned 0 NO Bonus points for orders
payment_type_id tinyint(4) 2 NO Payment method No
payment_id tinyint(4) 0 NO Payment channel
payment_name varchar(100) NO Name of payment channel
payment_ip varchar(20) NO Payment IP address
payment_start_time timestamp CURRENT_TIMESTAMP NO Payment start time
payment_end_time timestamp 0000-00-00 00:00:00 NO Payment completion time
payment_status tinyint(1) 1 NO Payment status
trade_id varchar(30) NO Payment transaction No. - payment center update
payment_offline decimal(10,2) unsigned 0.00 NO Offline payment amount

shop_order_process_state Order processing status table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_process_state_id smallint(4) unsigned NO Order process No
order_process_state_name varchar(50) NO Order process name: icon according to drawing
order_process_state_text_1 varchar(50) NO Order process remarks
order_process_state_note varchar(255) NO notes
order_process_state_buildin tinyint(1) unsigned 1 NO Enum: 0-no; 1-yes
order_process_type enum(‘Order’,’Return’) Order NO Process

shop_order_repair Order repair form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_repair_id bigint(20) unsigned NO number
order_id varchar(50) NO Order Id
refund_id varchar(100) NO Refund No
member_id int(10) unsigned NO Buyer ID
seller_id int(10) unsigned NO Vendor number
product_id int(10) NO Commodity ID
item_id int(10) 0 NO Commodity ID
refund_price float(10,2) NO Amount of refund:
reason varchar(255) NO reason
status tinyint(1) 1 NO Unknown state
order_repair_item_status tinyint(1) 0 NO Cargo status
type tinyint(1) 0 NO unknown type
create_time int(10) unsigned NO Creation time
close_reason varchar(255) NO Cause of closure
refuse_reason varchar(255) NO Reason for rejection

shop_order_return Refund return form - delivery return, the seller can also decide not to return a refund, the buyer does not support refund. The seller can offer a refund.

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
return_id varchar(50) NO Return number
service_type_id tinyint(3) unsigned 2 NO Service type (enum): 1-Exchange; 2-RETURN; 3-repair
order_id varchar(50) NO Order Id
return_refund_amount decimal(10,2) 0.00 NO Refund amount = goods_payment_amount / goods_quantity, because it involves discounts, etc. or for order_payment_amount in the order
store_id int(10) NO Shop Number
buyer_user_id int(10) unsigned NO Buyer ID
return_add_time timestamp CURRENT_TIMESTAMP NO Add time
return_year smallint(4) unsigned 0 NO Order year - index query
return_month tinyint(2) unsigned 0 NO Order month index query
return_day tinyint(2) unsigned 0 NO Order date index query
return_reason_id int(10) NO Refund reason No
return_buyer_message varchar(300) NO Buyer Return Notes
return_addr_contacter varchar(30) NO Addressee
return_tel varchar(20) NO Contact number:
return_addr varchar(150) NO Receiving address
return_post_code int(6) 0 NO Zip code
express_id tinyint(4) 0 NO Logistics Company Number
return_tracking_number varchar(30) NO Logistics Document Number
plantform_return_state_id smallint(4) 3180 NO Application status platform (enum): 3180 - in process; 3181 - after the seller’s consent or receipt is processed by the administrator; 3182 - completed
return_state_id smallint(4) 3105 NO Seller processing status (enum): 3100 - [customer] submits return; 3105 - review of return; 3110 - confirmation of receipt; 3115 - confirmation of refund; 3120 - confirmation of customer] collection; 3125 - complete
return_is_paid tinyint(1) unsigned 0 NO Refund complete
return_flag tinyint(4) 1 NO Return type (enum): 0-no return; 1-return required
return_type tinyint(4) 1 NO Application type (enum): 1-refund application; 2-RETURN application; 3-virtual refund
return_order_lock tinyint(4) 1 NO Order lock type (bool): 1-no lock; 2-lock required
return_item_state_id smallint(4) unsigned 2030 NO Logistics status (list): 2030 - to be delivered; 2040 - confirmation of delivered / to be received; 2060 - completed / signed in; 2070 - cancelled / voided;
return_store_time timestamp 0000-00-00 00:00:00 NO Business Processing Time
return_store_message varchar(300) NO Commerce Notes:
return_commision_fee decimal(10,2) 0.00 NO Return of commission
return_finish_time timestamp 0000-00-00 00:00:00 NO Refund Completion Time
return_platform_message varchar(255) NO Platform message
return_is_settlemented varchar(255) 0 NO Order settled (bool): 0 - unsettled; 1 - settled
return_settlement_time int(11) unsigned 0 NO Order settlement time
return_channel_code varchar(255) money NO Refund channel (ENUM): money- balance; alipay- Alipay; wx_ Native wechat
return_channel_flag tinyint(4) 0 NO Channel refund (enum): 0-to be returned; 1-returned; 2-abnormal
return_channel_time timestamp 0000-00-00 00:00:00 NO Channel refund time
return_channel_trans_id varchar(255) NO Channel refund No
deposit_trade_no varchar(255) NO Transaction No
payment_channel_id smallint(4) 0 NO Payment channel
trade_payment_amount decimal(10,2) 0.00 NO Paid in amount: online payment amount

shop_order_return_item Order return details

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_return_item_id int(10) NO -
order_id varchar(50) NO Order Id
return_id varchar(50) NO Return number
order_item_id int(10) 0 NO Order item_ ID
return_item_num smallint(5) unsigned 0 NO Quantity of returned goods
return_item_store_remark varchar(255) NO Commerce Notes:
return_reason_id smallint(4) NO Reasons for refund
return_item_note varchar(255) NO Reason for return application
return_item_subtotal decimal(10,2) 0.00 NO Total refund
return_item_commision_fee decimal(10,2) 0.00 NO Total refund Commission
return_item_image varchar(1024) NO Refund certificate (DOT)
return_state_id smallint(4) 3105 NO Seller processing status (enum): 3100 - [customer] submits return; 3105 - review of return; 3110 - confirmation of receipt; 3115 - confirmation of refund; 3120 - confirmation of customer] collection; 3125 - complete

shop_order_return_reason Return reason table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
return_reason_id int(10) NO -
return_reason_name varchar(255) NO Content of complaint reason
return_reason_sort int(3) 225 NO Order of complaint reasons

shop_order_service_type Order after sales service type table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
service_type_id tinyint(4) NO Service type number
service_type_name varchar(50) NO Service type name
service_type_text varchar(50) NO Service type description
service_type_prefix varchar(5) NO prefix
service_type_remark varchar(255) NO Order type remarks

shop_order_settlement Order statement

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
os_id varchar(50) NO Statement No. (store No. on MM DD YY)
os_start_time int(11) unsigned 0 NO Start date
os_end_time int(11) unsigned 0 NO End date
os_order_amount decimal(10,2) 0.00 NO Order amount:
os_shipping_amount decimal(10,2) 0.00 NO Free of freight
os_order_return_amount decimal(10,2) 0.00 NO Chargeback amount
os_commission_amount decimal(10,2) 0.00 NO Commission amount
os_commission_return_amount decimal(10,2) 0.00 NO Return of commission
os_store_expense_amount decimal(10,2) 0.00 NO Shop promotion expenses
os_amount decimal(10,2) 0.00 NO Amount to be settled
os_datetime timestamp 0000-00-00 00:00:00 NO Generate settlement document date
os_date date 0000-00-00 NO Month of statement year
os_state tinyint(4) 1 NO Status (enum): 1-default issued; 2-confirmed by store; 3-approved by platform; 4-settlement completed
os_pay_date timestamp 0000-00-00 00:00:00 NO Date of payment
os_pay_content varchar(200) NO Payment notes
store_id int(10) unsigned NO Shop Number
store_name varchar(50) NO Shop name
kind_id smallint(4) unsigned 1 NO Settlement order type (enum): 1-physical order; 2-virtual order

shop_order_shipping_address Shipper address table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_logistics_id bigint(20) 0 NO Logistics No
order_id varchar(50) NO Order Id
seller_id int(8) unsigned NO Shipper No
sa_name varchar(10) NO Contacts
sa_mobile varchar(20) NO Phone number
sa_telephone varchar(30) NO Contact number:
sa_contacter varchar(20) NO Contacts (not enabled)
sa_im varchar(20) NO Contact Im: QQ
sa_province_id int(10) 0 NO Province No
sa_province varchar(10) NO Province
sa_city_id int(10) 0 NO City No
sa_city varchar(10) NO city
sa_county_id int(10) unsigned 0 NO county
sa_county varchar(10) NO County Area
sa_address varchar(100) NO Detailed address
sa_postalcode varchar(30) NO Postal Code
sa_time timestamp CURRENT_TIMESTAMP NO Delivery time

shop_order_state Order status table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_state_id smallint(4) NO Status number
order_state_name varchar(50) NO The order status is incorrect!
order_state_text_1 varchar(255) NO -
order_state_text_2 varchar(255) NO -
order_state_text_3 varchar(255) NO -
order_state_remark varchar(255) NO Remarks

shop_order_state_log Order status record - order - payment - distribution - issue - transaction succeeded

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_state_log_id int(11) NO Status number
order_id varchar(50) NO Order Id
order_state_id smallint(4) 0 NO Order status: 2010 to be paid; 2020 to be distributed; 2030 to be shipped; 2040 to be shipped; 2050 to be signed in; 2060 to be completed; 2070 to be cancelled;
order_state_pre_id smallint(4) unsigned 0 NO Order status: 2010 to be paid; 2020 to be distributed; 2030 to be shipped; 2040 to be shipped; 2050 to be signed in; 2060 to be completed; 2070 to be cancelled;
order_state_type varchar(50) NO Operation category
order_state_time timestamp CURRENT_TIMESTAMP NO Time order_ state_ modify_ time
user_id int(10) NO Successful operation
user_nickname varchar(50) NO The order status is incorrect!
order_state_note varchar(50) NO Operation notes
order_state_is_sync tinyint(1) NO Synchronization (bool): 0-no; 1-yes

shop_order_trace Order tracking form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
order_trace_id bigint(20) NO -
order_id varchar(15) NO Order Id
order_trace_user_id smallint(5) NO Order operator ID: user_ id member_ ID
order_trace_name varchar(30) NO Operator
order_trace_text longtext NO Operation information
order_trace_time timestamp CURRENT_TIMESTAMP NO Operating time
order_trace_type varchar(255) NO Operation type

shop_page_app Shop style table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
app_id int(10) unsigned NO Application number
app_name varchar(1024) NO apply name
app_code text NO Application code
tpl_id int(10) unsigned 0 NO Template No
tpl_image varchar(255) NO -
store_id mediumint(8) unsigned 0 NO The shop under which it belongs
user_id mediumint(8) unsigned 0 NO Subordinate users
subsite_id int(8) unsigned 0 NO Sub station: 0-main station
app_buildin tinyint(1) unsigned 0 NO Built in (bool): 0-no; 1-yes
app_type tinyint(1) unsigned 1 NO Type (enum): 1-wap; 2-PC; 3-app
app_tpl text NO Apply template
app_member_center text NO Personal Center

shop_page_base Page table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
page_id bigint(20) unsigned NO Page Number
page_name varchar(20) NO page name
store_id mediumint(8) unsigned 0 NO The shop under which it belongs
user_id mediumint(8) unsigned 0 NO Subordinate users
subsite_id mediumint(4) unsigned 0 NO Sub station: 0-main station
page_buildin tinyint(1) unsigned 0 NO Built in (bool): 0-no; 1-yes
page_type tinyint(1) unsigned 1 NO Type (enum): 1-wap; 2-PC; 3-app
page_tpl text NO Page layout template
app_id int(10) 0 NO App
page_code text NO Page Code
page_nav text NO -
page_config varchar(255) NO -
page_share_title varchar(255) NO -
page_share_image varchar(255) NO -
page_qrcode varchar(255) NO -
page_index tinyint(1) unsigned 0 NO Front page (bool): 0 - non front page; 1 - front page
page_gb tinyint(1) unsigned 0 NO Group home page (bool): 0-non home page; 1-home page
page_activity tinyint(1) unsigned 0 NO Bool: 0 - non home page; 1 - home page
page_point tinyint(1) unsigned 0 NO Bool: 0 - non home page; 1 - home page
page_gbs tinyint(1) unsigned 0 NO Group purchase homepage (bool): 0-non homepage; 1-homepage
page_package tinyint(1) unsigned 0 NO Combination package (bool): 0-non homepage; 1-homepage
page_pfgb tinyint(1) unsigned 0 NO Wholesale group purchase homepage (bool): 0-non homepage; 1-homepage
page_sns tinyint(1) unsigned 0 NO Community (bool): 0-non homepage; 1-homepage
page_zerobuy tinyint(1) 0 NO Bool: 0-no; 1-yes
page_higharea tinyint(1) 0 NO Bool: 0-no; 1-yes
page_taday tinyint(1) 0 NO Bool today: 0-no; 1-yes
page_everyday tinyint(1) 0 NO Bool: 0-no; 1-yes
page_secondkill tinyint(1) 0 NO Bool: 0-no; 1-yes
page_secondday tinyint(1) 0 NO Bool: 0-no; 1-yes
page_rura tinyint(1) 0 NO Set local specialties (bool): 0-no; 1-yes
page_likeyou tinyint(1) 0 NO User page banner (bool): 0-no; 1-yes
page_exchange tinyint(1) 0 NO Bool: 0-no; 1-yes
page_new tinyint(1) 0 NO New product launch (bool): 0-no; 1-yes
page_newperson tinyint(1) 0 NO Bool: 0-no; 1-yes
page_upgrade tinyint(1) 0 NO Upgrade VIP (bool): 0-no; 1-yes

shop_page_module Page module table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
pm_id int(10) unsigned NO -
pm_name varchar(20) NO Module name
page_id bigint(20) NO -
user_id mediumint(8) NO Subordinate users
pm_color varchar(20) NO colour
pm_type varchar(10) NO Page
module_id varchar(10) NO Template
pm_utime datetime NO Update time
pm_order smallint(3) unsigned 1 NO sort
pm_enable tinyint(1) unsigned 1 NO Whether to display
pm_html varchar(10000) NO Module HTML code
pm_json varchar(10000) [] NO Module JSON code (JSON)
subsite_id mediumint(4) 0 NO Sub station ID: 0 - Main Station
pm_position varchar(255) NO column_ left:content_ Top

shop_plantform_activity Platform activity table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
pa_id int(10) NO Activity Number
pa_name varchar(255) NO Activity Name
pa_title varchar(255) NO Activity title
pa_remark varchar(255) NO Activity tagging
pa_type_id int(10) NO Activity type (enum): 5001 - today’s best; 5002 - good store every day; 5003 - every second; 5004 - every second
pa_starttime timestamp CURRENT_TIMESTAMP NO start time
pa_endtime timestamp 0000-00-00 00:00:00 NO Ending time
pa_state tinyint(1) 0 NO Active state (enum): 0-not turned on; 1-normal; 2-ended; 3-administrator closed
pa_order varchar(255) 50 NO sort
pa_type tinyint(1) 1 NO Activity type (enum): 1-product; 2-store

shop_plantform_activity_item Participate in active product table - user filtering calculation

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
pai_id int(10) unsigned NO Active Goods
pa_id int(10) unsigned 0 NO Activity Number
pa_type_id int(10) unsigned 0 NO Activity type number
store_id int(10) unsigned 0 NO Shop Number
store_name varchar(255) NO Shop Name
product_id bigint(20) unsigned 0 NO SPU
product_name varchar(255) NO Product name
item_id bigint(20) unsigned 0 NO Commodity ID
category_id mediumint(8) unsigned 0 NO Classification of commodities
pa_starttime timestamp CURRENT_TIMESTAMP NO start time
pa_endtime timestamp 0000-00-00 00:00:00 NO Ending time
pa_state tinyint(3) unsigned 1 NO Active state (enum): 0-not turned on; 1-normal; 2-ended; 3-administrator closed
pai_enable tinyint(3) unsigned 0 NO Recommendation flag (enum): 0-to be approved; 1-passed; 2-failed
pai_time timestamp 0000-00-00 00:00:00 NO Reporting time
pai_item_order tinyint(3) NO Display sorting
pai_unit_price decimal(10,2) NO Activity price

shop_plantform_activity_zerobuy Zero yuan shopping area

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
zb_id int(10) NO Zero purchase No
product_id int(10) NO Zero purchase SPU
item_name varchar(255) NO
item_id int(10) NO Zero purchase item No
zb_share int(10) NO Number of participants
zb_time timestamp 0000-00-00 00:00:00 NO Add time
zb_state tinyint(1) 0 NO Active product status (enum): 0-not open; 1-normal; 2-closed; 3-administrator closed
user_id int(10) NO Add person number
zb_starttime timestamp 0000-00-00 00:00:00 NO start time
zb_endtime timestamp 0000-00-00 00:00:00 NO Ending time
zb_unit_price decimal(10,2) NO Activity price
store_id int(10) NO Merchant number

shop_plantform_ban_ip IP forbidden table - in cache

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
ban_id int(10) unsigned NO number
ban_ip varchar(25) NO IP
ban_reason varchar(50) NO reason
ban_unlock_time int(12) unsigned 0 NO Unlocking time
ban_lock_time int(12) unsigned 0 NO Unlocking time
ban_autorelease int(1) 1 NO Automatic opening (enum): 1-automatic unlocking; 0-manual unlocking
ban_status tinyint(1) 1 NO Locking status (enum): 1-locked; 2-unlocked
ban_type tinyint(1) unsigned 1 NO Locking type (enum): 1-access forbidden; 2-registration forbidden

shop_plantform_feedback Platform feedback form - Report

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
feedback_id int(10) NO -
feedback_category_id smallint(6) unsigned 1001 NO -
user_id int(10) unsigned 0 NO User number
user_name varchar(50) NO -
feedback_question varchar(255) NO Feedback questions - describe your problems here
feedback_question_url varchar(255) NO Page link (optional)
feedback_question_answer varchar(255) NO -
feedback_question_time timestamp CURRENT_TIMESTAMP NO time
feedback_question_answer_time timestamp 0000-00-00 00:00:00 NO time
feedback_question_status tinyint(1) unsigned 1 NO Report status (1Not processed / 2processed)
feedback_question_result tinyint(1) unsigned 0 NO Report handling results (1 invalid report / 2 malicious report / 3 effective report)
product_id bigint(20) unsigned 0 NO Report product No
admin_id int(11) NO -

shop_plantform_feedback_category Platform feedback topic classification table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
feedback_category_id smallint(6) unsigned NO Feedback classification number
feedback_category_name varchar(50) NO Category name
feedback_type_id tinyint(1) unsigned 1 NO Feedback type
feedback_category_enable tinyint(1) unsigned 1 NO Is it enabled?

shop_plantform_feedback_type Platform feedback type table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
feedback_type_id smallint(6) unsigned NO Feedback type No
feedback_type_name varchar(50) NO Type name to be modified
feedback_type_enable tinyint(1) unsigned 1 NO Is it enabled?

shop_plantform_high_return High recurrent area

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
ha_id int(10) NO High value return area No
user_id int(10) NO User number
product_id int(10) NO Product number
item_name varchar(255) NO Product name
item_id int(10) NO Commodity ID
ha_time timestamp 0000-00-00 00:00:00 NO Creation time
ha_state tinyint(1) 0 NO Active product status (enum): 0-not open; 1-normal; 2-closed; 3-administrator closed
ha_unit_price decimal(10,2) NO -
ha_starttime timestamp 0000-00-00 00:00:00 NO start time
ha_endtime timestamp 0000-00-00 00:00:00 NO Ending time
store_id int(10) NO Merchant number

shop_plantform_high_return_user High value return area user sharing form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
hau_id int(10) NO High value return area user sharing No
ha_id int(10) NO High value return area No
item_id int(10) NO Product number
product_id int(10) NO Product number
user_id int(10) NO User number
user_name varchar(255) NO User name
hau_time timestamp 0000-00-00 00:00:00 NO Sharing time
hau_share_num int(10) 0 NO Share times

shop_plantform_media User attachment table - pictures, videos

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
media_id bigint(20) unsigned NO Product picture number
media_number char(32) NO Attachment MD5
gallery_id bigint(20) NO -
store_id int(10) unsigned 0 NO Shop Number
media_url varchar(255) NO The URL of the attachment defaults to the original image
media_source varchar(255) NO Source - website capture
media_order mediumint(4) unsigned 50 NO Sort - smaller, higher
media_domain varchar(255) NO domain name
media_path varchar(255) NO Attachment path local storage
media_type enum(‘video’,’other’,’image’) image NO image/video/
media_image_h int(10) unsigned 0 NO Higher than
media_image_w int(10) unsigned 0 NO export
media_size int(10) unsigned 0 NO Original file size
media_mime_type varchar(100) NO Uploaded attachment type
media_metadata varchar(255) NO metadata
media_alt varchar(255) NO Attachment alt
media_name varchar(50) NO Attachment title
media_desc varchar(255) NO Attachment description
media_password varchar(20) NO Attachment browse password
media_time timestamp CURRENT_TIMESTAMP NO Attachment date

shop_plantform_media_gallery User album table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
gallery_id bigint(20) unsigned NO Product picture number
gallery_name varchar(100) NO Album Name
gallery_desc varchar(255) NO Album Description
gallery_num mediumint(8) unsigned 0 NO Content quantity
gallery_is_default tinyint(4) unsigned 0 NO Default Album: 1-yes; 0-no
gallery_order smallint(4) unsigned 50 NO sort
gallery_type enum(‘video’,’other’,’image’) image NO Annex
gallery_cover varchar(255) NO cover
store_id int(10) unsigned 0 NO The shop under which it belongs

shop_plantform_notice Platform announcement form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
notice_id int(10) NO Announcement No
notice_titile varchar(50) NO Announcement title
notice_content varchar(1024) NO Announcement content (HTML)
notice_time timestamp CURRENT_TIMESTAMP NO Push time
notice_enable tinyint(1) unsigned 0 NO Whether to enable (bool): 1-enable; 0-disable

shop_plantform_subsite List of urban sub stations

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
subsite_id int(8) NO number
subsite_parent_id int(11) 0 NO Father number
subsite_name varchar(60) NO Substation name
subsite_domain varchar(20) NO Substation domain prefix
subsite_city_ids text NO Regional city ID (JSON)
subsite_item_city_ids varchar(5000) NO Region ID (DOT)
subsite_item_city_name varchar(10000) NO Regional city name (JSON)
subsite_logo varchar(255) NO LOGO
subsite_copyright text NO copyright
subsite_template varchar(50) NO Template
subsite_enable tinyint(1) unsigned 1 NO Whether to open (bool)
subsite_title varchar(100) NO SEO Title
subsite_keywords varchar(100) NO SEO keywords
subsite_description varchar(100) NO Description of SEO
subsite_des varchar(100) NO describe
subsite_hot tinyint(1) 0 NO BOOL: 0- no; 1- yes

shop_plantform_subsite_user Administrator list of Urban Substation

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
subsite_user_id int(11) unsigned NO Substation administrator
subsite_id int(8) unsigned NO Substation No
user_id int(11) unsigned 0 NO Administrator

shop_points_cart Point gift exchange shopping cart - do not use this form for direct purchase

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
points_cart_id int(10) unsigned NO Auto increment No
user_id int(10) unsigned 0 NO Membership Number
points_item_id int(10) unsigned 0 NO Bonus gift No
points_item_name varchar(10) NO Name of point gift
points_item_points int(10) unsigned 0 NO Redeem points for gifts
points_item_quantity int(10) unsigned 0 NO Choose the number of bonus gifts
points_item_image varchar(255) NO Bonus gift picture

shop_points_item Bonus gift table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
points_item_id int(10) NO Index number of points and gifts
points_item_number varchar(50) NO Credit Gift Item No
points_item_name varchar(100) NO Name of point gift
points_item_price decimal(10,2) 0.00 NO Original price of bonus gifts
points_item_points int(10) 0 NO Points for gift exchange
points_item_image varchar(255) NO Bonus gift default cover image
points_item_tag varchar(100) NO Point gift label (DOT)
points_item_storage int(10) 0 NO Bonus gift inventory
points_item_enable tinyint(1) unsigned 0 NO Integral gift on shelf (bool): 0-for off shelf; 1-for on shelf
points_item_recommend tinyint(1) 0 NO Whether to recommend bonus gifts (bool): 1-yes; 0-no
points_item_add_time timestamp CURRENT_TIMESTAMP NO Time to add bonus gifts
points_item_keywords varchar(100) NO Points gift keywords
points_item_description varchar(200) NO Point gift description
points_item_content text NO Details of points and gifts
points_item_salenum int(10) 0 NO Number of points sold
points_item_view int(10) 0 NO Number of points product views
points_item_user_level int(10) 0 NO Change purchase is limited to the member level. The default value is 0. All levels can be changed
points_item_islimit tinyint(1) 0 NO Limit the number of exchanges per member (bool): 0 - unlimited; 1 - Limited
points_item_limitnum int(10) NO Limited exchange quantity per member
points_item_islimittime tinyint(1) 0 NO Limit exchange time (bool): 0-unlimited; 1-restricted
points_item_starttime timestamp 0000-00-00 00:00:00 NO Exchange start time
points_item_endtime timestamp 0000-00-00 00:00:00 NO Exchange end time
points_item_order int(10) 50 NO Gift sorting

shop_points_order Points exchange order form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
points_order_id varchar(10) NO Exchange Order No
points_user_id int(10) NO Exchange member No
points_addtime timestamp CURRENT_TIMESTAMP NO Exchange order generation time
points_payment_time timestamp 0000-00-00 00:00:00 NO Time of payment
points_shipping_time timestamp 0000-00-00 00:00:00 NO Delivery time
points_order_tracking_number varchar(50) NO Logistics Document Number
express_id varchar(50) NO Logistics Company Number
points_order_endtime datetime NO Order completion time
points_order_points int(10) 0 NO Redeem total points
points_order_amount decimal(10,2) NO Total exchange order amount
points_order_shipping_type tinyint(1) 0 NO Enum: 0 - platform; 1 - buyer
points_order_shipping_fee decimal(10,2) 0.00 NO Freight amount
points_order_message varchar(300) NO Order message
points_order_state int(4) 1 NO Order status (enum): 1 - (placed, waiting for delivery); 2 - (shipped, waiting for receipt); 3 - (confirmed receipt) 4 (cancelled)

shop_points_order_delivery_address Receiving address table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
points_order_id varchar(50) NO Order Id
da_name varchar(10) NO Contacts
da_mobile varchar(20) NO Phone number
da_telephone varchar(30) NO Contact number:
da_contacter varchar(20) NO Contacts (not enabled)
da_im varchar(255) NO Contact Im: QQ
da_province_id int(10) 0 NO Province No
da_province varchar(50) NO Province
da_city_id int(10) 0 NO City No
da_city varchar(50) NO city
da_county_id int(10) unsigned 0 NO county
da_county varchar(50) NO County Area
da_address varchar(255) NO Detailed address
da_postalcode varchar(30) NO Postal Code
da_tag_name varchar(50) 0 NO Address tag: home, company, etc
da_time timestamp CURRENT_TIMESTAMP NO Add time

shop_points_order_item Exchange order item list

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
poi_id int(10) NO Order gift table index
points_order_id varchar(50) NO Order Id
points_item_id int(10) 0 NO Gift number
poi_name varchar(100) NO Gift name
poi_points int(10) 0 NO Gift exchange points
poi_num int(10) 0 NO Number of gifts
poi_image varchar(255) NO Gift picture

shop_product_analytics Product statistics

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_id bigint(20) unsigned NO Product number
product_click int(10) unsigned 0 NO Product click quantity
product_sale_num int(10) unsigned 0 NO Sales quantity: product_ sales_ volumes
product_favorite_num int(10) unsigned 0 NO Number of collections
product_evaluation_star int(10) unsigned 0 NO Total star rating
product_evaluation_num int(10) unsigned 0 NO Evaluation number
product_evaluation_level_0 tinyint(1) unsigned 0 NO -
product_evaluation_level_1 tinyint(1) unsigned 0 NO Bad
product_evaluation_level_2 tinyint(1) unsigned 0 NO Normal
product_evaluation_level_3 tinyint(1) unsigned 0 NO Good
product_evaluation_level_4 tinyint(1) unsigned 0 NO -
product_evaluation_level_5 tinyint(1) unsigned 0 NO -
product_ask_num int(10) unsigned 0 NO Number of questions and answers

shop_product_ask_base Commodity Consultation

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
ask_id int(10) unsigned NO Consultation ID
ask_type_id int(10) NO Consultation category No
product_id int(10) unsigned NO Commodity ID
store_id int(10) NO Shop Number
user_id int(10) NO User number
user_nickname varchar(50) NO User name
ask_question varchar(255) NO Consultation content
ask_time timestamp CURRENT_TIMESTAMP NO Question time
ask_answer varchar(255) NO Answer
ask_answer_time timestamp 0000-00-00 00:00:00 NO Answer time
ask_answer_user_id int(11) NO Reply to users
ask_answer_user_nickname varchar(50) NO Reply to nickname
ask_status tinyint(1) unsigned 0 NO Reply or not (bool): 0-not replied; 1-replied
ask_enable tinyint(1) unsigned 0 NO Is it realistic (bool): 0-not open; 1-open
ask_helpful int(10) unsigned 0 NO Number of points

shop_product_ask_helpful Useful voting table for commodity consultation

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
ask_id bigint(20) unsigned NO Question number
user_id int(10) unsigned 0 NO Click on user number
ask_helpful_time timestamp CURRENT_TIMESTAMP NO Evaluation time

shop_product_assist_index Product and property correspondence table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_assist_index_id varchar(50) NO product_ id-assist_ ID
product_id bigint(20) unsigned NO Commodity public table No
assist_id mediumint(8) unsigned 0 NO Property number
assist_item_id varchar(100) 0 NO Property value (DOT)

shop_product_base Commodity base table - SPU table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_id bigint(20) unsigned NO Product number
product_name varchar(50) NO Product name (in = > 2100)
product_tips varchar(50) NO Commodity selling point: commodity advertising words
store_id int(10) unsigned 0 NO Shop Number
store_name varchar(50) NO Shop Name
product_market_price decimal(10,2) 0.00 NO market value
product_unit_price decimal(10,2) 0.00 NO item pricing
product_cost_price decimal(10,2) 0.00 NO cost
product_image varchar(255) NO Commodity map
product_video varchar(255) NO Product video
transport_type_id mediumint(8) unsigned 0 NO Select Sales Area: complete sales area and freight setting
product_seo_url varchar(50) NO If jump page is enabled
layout_route_id int(10) unsigned 0 NO Thematic layout number
product_verify_id smallint(4) 10 NO Enum: 3001 - approved; 3002 - under review; 3000 - failed
product_state_id smallint(4) unsigned 1002 NO Commodity status (list): 1001 - normal; 1002 - in off shelf warehouse; 1000 - illegal prohibition
product_sale_time timestamp 0000-00-00 00:00:00 NO Listing time: preset the listing time, and the status can be dynamically corrected
unit_id smallint(4) 0 NO unit of measure
product_country varchar(20) NO Country of origin
product_currency varchar(20) NO Recharge
product_add_time int(10) unsigned 0 NO Add time
product_unit_points int(10) 0 NO Point unit price
product_unit_sp int(10) 0 NO Unit price of resource 2
product_order tinyint(2) unsigned 50 NO sort
product_src_id bigint(20) 0 NO Product source No

shop_product_comment Commodity evaluation form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
comment_id bigint(20) unsigned NO -
order_id varchar(50) NO Order Id
product_id bigint(20) unsigned 0 NO Product number
item_id bigint(20) unsigned 0 NO Commodity ID
item_name varchar(20) NO Commodity specifications
store_id int(10) unsigned 0 NO Seller Store Number - Redundancy
store_name varchar(50) NO Shop Name
user_id int(10) unsigned 0 NO Buyer ID
user_name varchar(50) NO Buyer Name: user_ nickname
comment_points decimal(10,2) 0.00 NO Obtain Integral-Redundancy, Independent Table Records
comment_scores tinyint(4) unsigned 3 NO Evaluation of Star 1-5 Integral
comment_content varchar(255) NO Evaluation content
comment_image varchar(2048) NO Comment on uploaded images (DOT)
comment_helpful int(10) 0 NO To be helpful to
comment_nohelpful int(10) 0 NO No help
comment_time timestamp CURRENT_TIMESTAMP NO Evaluation time
comment_is_anonymous tinyint(1) unsigned 0 NO Anonymous evaluation
comment_enable tinyint(1) unsigned 1 NO Status of evaluation information (bool): 1-normal display; 0-forbidden display
comment_store_desc_credit tinyint(1) unsigned 5 NO Description matching score-order_buyer_evaluation_status, no need to comment again after the evaluation status changes, follow the order
comment_store_service_credit tinyint(1) unsigned 5 NO Service Attitude Score - order_buyer_evaluation_status
comment_store_delivery_credit tinyint(1) unsigned 5 NO Delivery Speed score - order_buyer_evaluation_status

shop_product_comment_helpful Useful voting table for commodity evaluation

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
comment_id bigint(20) unsigned NO Comment number
user_id int(10) unsigned 0 NO Click on user number
comment_helpful_time timestamp CURRENT_TIMESTAMP NO Evaluation time

shop_product_comment_reply Commodity evaluation Reply Form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
comment_reply_id bigint(20) unsigned NO Comment reply No
comment_id bigint(20) unsigned NO Comment number
user_id int(10) unsigned 0 NO Comment number
user_name varchar(50) NO Buyer reviewer name
user_id_to int(10) NO Reply to users
user_name_to varchar(50) NO Reply user name
comment_reply_content varchar(255) NO Comment on the content of the reply
comment_reply_time timestamp CURRENT_TIMESTAMP NO Comment reply time
comment_reply_enable tinyint(1) 1 NO Allow display
comment_reply_isadmin tinyint(1) 0 NO Administrator evaluation

shop_product_data Product data sheet

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_id bigint(20) unsigned NO Product number
product_region_district_ids varchar(1024) NO Product location (DOT): the sub station of the product is divided according to the street of the provincial urban area
product_region varchar(100) NO Commodity location - Region - province and city
product_is_lock tinyint(1) unsigned 0 NO Whether to lock (enum): 0-not locked; 1-locked, no modification is allowed for the commodities participating in group purchase
product_verify_remark varchar(255) NO Audit reason
product_state_remark varchar(255) NO Reasons for violation
product_edit_time timestamp 0000-00-00 00:00:00 NO Edit time

shop_product_detail Product details

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_id bigint(20) unsigned NO Product number - designated as SPU number
product_detail varchar(15000) NO Commodity Description
product_param varchar(3000) NO Specification parameters
product_service varchar(3000) NO After-sale service
product_meta_title varchar(50) NO Meta tag title
product_meta_description varchar(100) NO Meta tag description
product_meta_keyword varchar(100) NO Meta tag keyword
product_tags varchar(255) NO Product label (DOT)

shop_product_image Product picture table according to color specification

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_image_id bigint(20) unsigned NO Product picture number
product_id bigint(20) unsigned 0 NO Product number: product_ id-color_ ID
store_id int(10) unsigned NO Shop Number
color_id int(10) unsigned 0 NO System default color specification ID / spec_ item_ ID, if not, a record is 0
color_name varchar(10) NO Specification value
item_image_default varchar(255) NO Commodity map
item_image_other varchar(800) NO Sub drawing (DOT)
item_image_diy varchar(255) NO DIY background
item_video varchar(255) NO Video address
item_image_ext_1 varchar(255) NO Extended picture
item_image_ext_2 varchar(255) NO Extended picture

shop_product_index Product index table - do not read data read only primary key

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_id bigint(20) unsigned NO Product No.: designated as SPU No
product_name varchar(50) NO Product Name: the store platform first searches in the usage table and then searches by ID to search and use
product_name_index varchar(255) NO Name index key (DOT)
store_id int(10) unsigned 0 NO Shop Number
store_is_open tinyint(1) unsigned 1 NO Store status: 0-closed; 1-whether the goods are available in operation, it is necessary to judge whether the redundant list of store status of the goods is retrieved and used
store_type tinyint(1) 1 NO Shop type (enum): 1-seller’s shop; 2-supplier’s shop
store_category_ids varchar(50) 0 NO Store classification number (DOT)
category_id mediumint(8) unsigned 0 NO Classification of commodities
category_ids varchar(50) NO Commodity classification number (DOT)
type_id mediumint(8) unsigned 0 NO Type number: redundant search
product_quantity int(10) unsigned 0 NO Commodity inventory: redundant calculation
product_warn_quantity int(10) unsigned 0 NO Alert quantity
brand_id mediumint(8) unsigned 0 NO Brand Number
product_service_type_ids varchar(50) NO After sales service (DOT)
product_state_id smallint(4) unsigned 1 NO Commodity status: 1001 normal; 1002 in off shelf warehouse; 1003 to be reviewed; 1000 illegal prohibition
product_verify_id smallint(4) unsigned 10 NO Enum: 3001 - approved; 3002 - under review; 3000 - failed
product_is_invoices tinyint(3) unsigned 0 NO Whether to issue VAT invoice: 1-yes; 0-no
product_is_return tinyint(1) unsigned 1 NO Return and exchange allowed: 1-yes; 0-no
product_is_recommend tinyint(1) unsigned 0 NO Product recommendation: 1-yes; 0-no
product_stock_status tinyint(1) unsigned 1 NO Out of stock status: 1-available; 2-pre-sale goods; 3-out of stock; 4-2 to 3 days
kind_id smallint(4) unsigned 0 NO Commodity category: 1201 - physical; 1202 - Virtual
activity_type_ids varchar(50) NO Participation activities (DOT)
contract_type_ids varchar(50) NO Consumer protection (DOT): mapping from store to product
product_assist_data varchar(255) NO Auxiliary attribute value column (DOT): Assist_ item_ Each ID is not used. Setfilter (TagID, array (2,3,4)); means any one of the tag values 2,3,4 is qualified for filtering. Here is the or relationship. Setfilter (‘tagid ‘, array (2)); setfilter (‘tagid’, array (3)); form and relationship / MSYQL where find_ IN_ SET(‘1’, product_ assist_ data)
product_add_time int(10) unsigned 0 NO Add time
product_unit_price decimal(10,2) unsigned 0.00 NO item pricing
product_unit_points decimal(10,2) 0.00 NO Commodity points
product_unit_sp decimal(10,2) 0.00 NO Commodity resources
product_sale_num int(10) unsigned 0 NO sales volume
product_favorite_num int(10) unsigned 0 NO Collection quantity popularity
product_sale_district_ids varchar(1024) NO Sales area (DOT): District_ Id0 is an unrestricted query carry in condition
product_region_district_ids varchar(1024) NO Area (DOT): the sub stations of commodities are divided according to the streets of the provincial urban area
product_freight decimal(6,2) unsigned 0.00 NO Freight: 0 for package, retrieved for use
product_evaluation_num mediumint(8) unsigned 0 NO Evaluation times
product_tags varchar(255) NO Product label (DOT)
store_is_selfsupport tinyint(1) unsigned 0 NO Whether it is self-supporting (bool): 1-self-supporting; 0-non-self-supporting
product_fx_enable tinyint(1) unsigned 0 NO Allow distribution (bool): 1-enable distribution; 0-disable distribution
product_sale_time int(11) unsigned NO Listing time: preset the listing time, and the status can be dynamically corrected
product_number varchar(50) NO SPU merchant code: Article No
product_order tinyint(2) unsigned 50 NO Sorting: smaller, higher
product_src_id bigint(20) 0 NO Product source No
market_category_id varchar(1024) NO Business district (DOT)
store_latitude varchar(20) NO latitude
store_longitude varchar(20) NO longitude
product_is_video tinyint(1) unsigned 0 NO Whether video (bool): 1-with video; 0-without video
subsite_id int(8) unsigned 0 NO Sub station: 0-main station

shop_product_info Commodity information table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_id bigint(20) unsigned NO Product number
product_number varchar(50) NO SPU merchant code: Article No
product_barcode varchar(30) NO Product bar code
product_model varchar(255) NO Product model
product_assist varchar(2048) NO Properties (JSON) - auxiliary properties and val
product_spec varchar(2048) NO Specification (JSON) - Specification, specification value, goods_ The ID specification does not need to select all to add the corresponding data [{‘ID’: spec_ id, ‘name’ : spec_ name, ‘item’:[{‘id’ : spec_ item_ id, ‘name’ : spec_ item_ name}, {‘id’ : spec_ item_ id, ‘name’ : spec_ item_ name}]},{‘id’ : spec_ id, ‘name’ : spec_ name, ‘item’:[{‘id’ : spec_ item_ id, ‘name’ : spec_ item_ name}, {‘id’ : spec_ item_ id, ‘name’ : spec_ item_ name}]}]
product_uniqid varchar(10240) [] NO Product SKU (JSON): {‘uniq_ id’:[item_ id, price, url]}
unit_length_id mediumint(8) unsigned 1 NO Length unit
unit_weight_id mediumint(8) unsigned 1 NO weight
product_weight decimal(10,2) unsigned 0.00 NO Enable commodity weight field
product_cubage varchar(50) 0.00 NO Dimension length x width x height (DOT): product volume
product_subtract tinyint(1) unsigned 1 NO Deduct inventory
unit_type_id mediumint(8) unsigned 0 NO unit of measure
tax_class_id int(10) unsigned 0 NO Commodity tax type: commodity tax rate can be set according to commodity classification
product_buy_limit int(10) unsigned 0 NO Limited purchase per person
product_user_level_discount tinyint(1) unsigned 1 NO Membership level discount
product_shop_card_discount tinyint(1) unsigned 1 NO Discount of membership card issued by participating stores

shop_product_item Product list - SKU table product name (product name + color specification name) = shop_ product_ item

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
item_id bigint(20) unsigned NO Item No. - SKU No
item_name varchar(255) NO Subtitle (DOT): SKU name
product_id bigint(20) unsigned NO Product number
color_id mediumint(8) 0 NO Color SKU, specification value
item_is_default tinyint(1) unsigned 0 NO Is it the default displayed product - list page display, must be item_ enable
item_number varchar(50) NO SKU merchant code: SKU merchant code is not required. If it is not filled in, the system will automatically generate a SKU merchant code.
item_barcode varchar(20) NO bar code
item_cost_price decimal(10,2) 0.00 NO cost
item_platform_price decimal(10,2) 0.00 NO Platform price
item_unit_price decimal(10,2) 0.00 NO commodity price
item_market_price decimal(10,2) 0.00 NO market value
item_unit_points decimal(10,2) unsigned 0.00 NO Point price
item_unit_sp decimal(10,2) 0.00 NO The Release of Treasures
item_quantity int(10) unsigned 0 NO Product stock
item_quantity_frozen int(10) unsigned 0 NO Goods frozen inventory
item_warn_quantity int(10) unsigned 0 NO Inventory alert value
item_spec varchar(2048) [] NO Product specification serialization (JSON): {spec_ id:spec_ item_ id, spec_ id:spec_ item_ id, spec_ id:spec_ item_ Id}
item_enable smallint(4) unsigned 1002 NO List: 1001 - normal; 1002 - in off shelf warehouse; 1000 - illegal prohibition
item_is_change tinyint(1) unsigned 0 NO Changed (bool): 0-unchanged; 1-changed distribution and use
item_weight decimal(20,6) unsigned 0.000000 NO Enable commodity weight field
item_fx_commission decimal(10,2) 0.00 NO Distribution Commission of micro stores
item_rebate decimal(10,2) 0.00 NO Rebate amount
item_title varchar(50) NO Course video name
item_freetime int(10) NO Course video duration (unit / minute)
item_src_id bigint(20) 0 NO Supplier SKU number
category_id mediumint(8) 0 NO Classification of commodities
store_id int(10) 0 NO The shop under which it belongs

shop_product_item_meta SKU extension table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
meta_id varchar(50) NO Meta id:data_ id-meta_ Key
data_id int(10) unsigned 0 NO item_ ID
meta_key varchar(255) NO key
meta_value varchar(4096) NO value
meta_datatype enum(‘string’,’json’,’number’,’dot’) string NO data type

shop_product_item_seq ITEM_ ID / SKU unique number table.

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_item_seq_id varchar(32) NO No.: md5product_ item_ seq_ Val
product_item_seq_val varchar(255) NO Number value
item_id bigint(20) unsigned NO Item No. - SKU No
product_id bigint(20) unsigned NO Product number

shop_product_meta Product data extension form - buyers are required to leave a message here

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
meta_id varchar(50) NO Meta id:data_ id-meta_ Key
data_id int(10) unsigned 0 NO product_ ID
meta_key varchar(255) NO key
meta_value varchar(4096) NO value
meta_datatype enum(‘string’,’json’,’number’,’dot’) string NO data type

shop_product_option Item extension field table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_id bigint(20) unsigned NO Product number
product_service_text varchar(50) NO After sales service - if the after-sales service is not filled in, the customized

shop_product_option_value null

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_option_value_id int(11) NO -
product_option_id int(11) NO -
product_id int(11) NO -
option_id int(11) NO -
option_value_id int(11) NO -
quantity int(3) NO -
subtract tinyint(1) NO -
price decimal(15,4) NO -
price_prefix varchar(1) NO -
points int(8) NO -
points_prefix varchar(1) NO -
weight decimal(15,8) NO -
weight_prefix varchar(1) NO -

shop_product_pre_sale Information sheet of pre-sale goods

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_id bigint(20) unsigned NO Product number
product_pre_sale_end timestamp 0000-00-00 00:00:00 NO Presale end time - stored in active product information
product_pss_start date 0000-00-00 NO Estimated delivery time
product_pss_end date 0000-00-00 NO Estimated delivery time

shop_product_pricing_policy Price strategy table - pricing by customer

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
policy_id int(10) unsigned NO -
item_id int(10) unsigned 0 NO Product
store_id int(10) unsigned 0 NO The shop under which it belongs
customer_id int(10) unsigned 0 NO Customer
policy_price decimal(20,6) 0.000000 NO Strategic price
policy_discountrate decimal(8,6) 0.000000 NO True discount rate: Policy_ price/item_ unit_ price
policy_quantity_min int(10) unsigned 0 NO Starting quantity
policy_quantity_max int(10) unsigned 0 NO Order limit

shop_product_pricing_policy_level Price strategy table - pricing by customer level

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
policy_level_id int(10) unsigned NO Policy number
item_id int(10) unsigned 0 NO Commodity SKU
store_id int(10) unsigned 0 NO The shop under which it belongs
customer_level_id smallint(4) 0 NO Customer grade No.: determine default discount rate
policy_level_price decimal(20,6) 0.000000 NO Strategic price
policy_level_discountrate decimal(10,6) 0.000000 NO True discount rate: by policy_ level_ Price decision
policy_level_quantity_min int(10) 0 NO Starting quantity
policy_level_quantity_max int(10) 0 NO Order limit

shop_product_pricing_policy_wholesale Price strategy table - step price

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
policy_wholesale_id int(10) unsigned NO Policy number
item_id int(10) unsigned 0 NO Commodity SKU
store_id int(10) unsigned 0 NO The shop under which it belongs
item_quantity int(10) 0 NO Maximum quantity
policy_wholesale_price decimal(10,2) 0.00 NO Step price
policy_wholesale_group_price decimal(10,2) NO Group Purchase Price
policy_wholesale_discountrate decimal(10,6) 0.000000 NO Discount rate: Policy_ wholesale_ Price decision
policy_wholesale_enable tinyint(1) unsigned 0 NO Whether to enable (bool): 0-disable; 1-enable

shop_product_spec_item Product specification value table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
spec_item_id int(10) unsigned NO Commodity specification value No
store_id int(10) unsigned NO Shop Number
category_id int(11) unsigned 0 NO The commodity classification number determines the specification by type, but the specification values under the classification are different
spec_id mediumint(8) unsigned NO Specification classification No
spec_item_name varchar(20) NO Specification Value Name
spec_item_order smallint(6) 50 NO sort
spec_item_enable tinyint(1) unsigned 1 NO Whether to enable (bool): 0-do not display; 1-display

shop_product_valid_period Virtual goods information table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_id bigint(20) unsigned NO Product number
product_valid_period smallint(4) 1001 NO Validity period: 1001 - long term validity; 1002 - user defined validity period; 1003 - long term unit since purchase
product_validity_start date 0000-00-00 NO start time
product_validity_end date 0000-00-00 NO Expiration time
product_validity_duration decimal(6,4) 0.0000 NO Effective time unit is year
product_valid_type smallint(4) unsigned 1001 NO Service type (enum): 1001 arrival service; 1002 on site service
product_service_date_flag tinyint(1) unsigned 0 NO Fill in appointment date (enum): 0-no; 1-yes
product_service_contactor_flag tinyint(1) unsigned 0 NO Fill in contact person (enum): 0-no; 1-yes
product_valid_refund_flag tinyint(1) unsigned 0 NO Support for overdue refund (enum): 0-no; 1-yes
product_service_date date 0000-00-00 NO Appointment service date
product_service_time int(11) 0 NO Appointment service time

shop_rights_base Authority table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
rights_id smallint(4) unsigned NO Authority number
rights_name varchar(20) NO Name of permission
rights_parent_id smallint(4) unsigned 0 NO Permission parent number
rights_remark varchar(255) NO Remarks
rights_order smallint(4) 50 NO sort

shop_rights_data Data permission table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
rights_group_id smallint(4) unsigned NO Authority Group No
rights_group_name varchar(50) NO Permission group name
rights_group_rights_ids text NO Permission list
rights_group_add_time timestamp CURRENT_TIMESTAMP NO Creation time

shop_rights_data_type Data permission type table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
rights_data_type_id smallint(4) unsigned NO Authority data type number
rights_data_type_name varchar(50) NO Permission data type name
rights_data_type_primary_key text NO Data primary key

shop_rights_group Permission group table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
rights_group_id smallint(4) unsigned NO Authority Group No
rights_group_name varchar(50) NO Permission group name
rights_group_rights_ids text NO Permission list
rights_group_add_time timestamp CURRENT_TIMESTAMP NO Creation time

shop_store_activity_base Activity table - implemented through plug-ins

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
activity_id int(10) unsigned NO Activity Number
store_id int(10) unsigned 0 NO Shop Number
user_id int(10) unsigned 0 NO User number
activity_name varchar(50) NO Activity Name
activity_title varchar(50) NO Activity title
activity_remark varchar(255) NO Activity description
activity_combo_id int(10) unsigned 0 NO Package No
activity_type_id int(10) unsigned 0 NO activity type
activity_starttime timestamp 0000-00-00 00:00:00 NO Activity start time
activity_endtime timestamp 0000-00-00 00:00:00 NO End time of activity
activity_state tinyint(1) unsigned 1 NO Activity status (enum): 0-not opened; 1-normal; 2-closed; 3-administrator closed; 4-merchant closed
activity_rule varchar(10240) NO Activity rule (JSON): do not retrieve {rule_ id:{}, rule_ ID: {}}, unified resolution rule {“requirement”: {“buy”: {“item”: [1,2,3], “subtotal”: “conditions satisfied by calculation modification”}}, “rule”: [{“total”: 100, “Max_ num”:1,”item”:{“1”:1,”1200”:3}},{“total”:200,”max_ num”:1,”item”:{“1”:1,”1200”:3}}]}
activity_type tinyint(4) unsigned 0 NO Participation type (enum): 1-free participation; 2-point participation; 3-purchase participation
activity_order tinyint(4) unsigned 50 NO sort
activity_is_finish tinyint(1) unsigned 0 NO Whether the activity is completed (enum): 0 - not completed; 1 - completed; 2 - disbanded (currently used for group purchase)
item_id int(10) NO Item number

shop_store_activity_combo Activity package

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
activity_combo_id int(10) unsigned NO Activity package No
activity_combo_starttime datetime NO start time
activity_combo_endtime datetime NO Ending time
activity_type_id int(10) unsigned 0 NO activity type
store_id int(10) unsigned 0 NO Shop Number
user_id int(10) unsigned 0 NO User number

shop_store_activity_item Participate in active product table - user filtering calculation

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
activity_item_id int(10) unsigned NO Commodity table No
store_id int(10) unsigned 0 NO Shop Number
activity_type_id int(10) unsigned 0 NO Activity type number
activity_id int(10) unsigned 0 NO Activity Number
product_id int(10) unsigned 0 NO -
item_id int(10) unsigned 0 NO Commodity ID
category_id mediumint(8) unsigned 0 NO Classification of commodities
activity_item_starttime timestamp CURRENT_TIMESTAMP NO start time
activity_item_endtime timestamp 0000-00-00 00:00:00 NO Ending time
activity_item_price decimal(10,2) 0.00 NO Limited time discount price
activity_item_min_quantity int(10) unsigned 0 NO Lower Purchase Limit
activity_item_state tinyint(3) unsigned 1 NO Active state (enum): 0-not turned on; 1-normal; 2-ended; 3-administrator closed
activity_item_recommend tinyint(3) unsigned 0 NO Recommended flag: 0-not recommended; 1-recommended
activity_level_limits tinyint(3) 0 NO Grade limit
activity_points_num int(10) 0 NO Necessary Integral Number
activity_points_product_num int(10) unsigned 0 NO Remaining quantity of credit products
activity_points_product_sale_num int(10) 0 NO Number of points sold

shop_store_analytics Shop statistics

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_id int(10) unsigned NO Shop Number
store_click_num int(11) 0 NO Store visits
store_favorite_num int(10) unsigned 0 NO Number of collections
store_product_new_num int(10) unsigned 0 NO Latest products
store_product_num int(10) unsigned 0 NO Product quantity
store_sales_num int(10) 0 NO Store sales
store_evaluation_num int(10) 0 NO Evaluation times
store_evaluation_rate decimal(10,2) 0.00 NO Good reviews: store_ servicecredit/store_ evaluation_ Num / 5, service evaluation with comprehensive options
store_desccredit decimal(10,2) 0.00 NO The description is consistent
store_servicecredit decimal(10,2) 0.00 NO Service evaluation
store_deliverycredit decimal(10,2) 0.00 NO Logistics evaluation
store_trade_amount decimal(10,2) unsigned 0.00 NO Total turnover of store transaction: confirmed receipt

shop_store_base Shop basic information table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_id int(10) unsigned NO Shop Number
user_id int(10) unsigned NO User No.: administrator shop main account
store_name varchar(50) NO Shop Name
store_grade_id int(5) unsigned 0 NO Store level
store_logo varchar(255) NO Shop logo
store_slogan varchar(255) NO Shop slogan
store_domain varchar(255) NO Sub domain
store_area varchar(50) NO Area
store_district_id varchar(255) NO Area (DOT)
store_address varchar(50) NO Detailed address of the store
store_latitude varchar(20) NO latitude
store_longitude varchar(20) NO longitude
store_is_selfsupport tinyint(1) unsigned 0 NO Whether it is self operated (enum): 1 - self operated; 0 - non self operated
store_type tinyint(4) unsigned 1 NO Shop type (enum): 1-seller’s shop; 2-supplier’s shop
store_is_open tinyint(1) unsigned 0 NO Store status (enum): 0-closed; 1-in operation, whether the product is available, need to judge the store status of the product
shop_parent_id int(11) 0 NO Superior store No.: store creation decision, distributor - cannot be changed! Commission equity considerations
store_category_id int(10) unsigned 0 NO Shop classification number
store_state_id smallint(4) unsigned 3220 NO Store information status (enum): 3210 data to be improved; 3220 data to be reviewed; 3230 data to be reviewed failed; 3240 data to be reviewed and paid
store_time timestamp CURRENT_TIMESTAMP NO Join time
store_end_time int(11) NO Deadline of validity
product_category_ids varchar(255) NO Store operational classification (DOT)
store_o2o_tags varchar(30) NO Free service (DOT)
store_o2o_flag tinyint(1) 0 NO O2o (bool): 0-no; 1-yes
store_o2o_merchant_id varchar(60) NO Merchant offline payment No
store_circle varchar(50) NO Business district (DOT)
subsite_id int(8) unsigned 0 NO Sub station: 0-main station

shop_store_book With your hand

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_book_id int(10) unsigned NO number
store_id int(10) unsigned NO Merchant number
book_amount decimal(10,2) NO Pre-tax expenses
book_remark varchar(255) NO Remarks
book_time int(11) NO time

shop_store_business_category Store management category binding

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_business_category_id int(10) unsigned NO Shop operation classification No
store_id int(10) unsigned 0 NO Shop Number
category_id int(10) unsigned 0 NO Business category ID: the last level of commodity classification
store_business_category_commission_rate decimal(4,2) 0.00 NO Commission Rate
store_business_category_enable tinyint(1) 1 NO Is it enabled?

shop_store_company Shop company information form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
company_id int(10) unsigned NO Company No
user_id int(10) unsigned 0 NO Subordinate users
store_id int(10) unsigned NO Shop Number
company_name varchar(50) NO Full name of enterprise
company_area varchar(50) NO Location of company
company_address varchar(100) NO Address: Please enter the detailed address of the company
company_zipcode varchar(255) NO Zip code: Please enter the company zip code
company_phone varchar(255) NO Phone: Please enter the company phone number
company_website varchar(255) NO Company website: Please enter the company website
company_description varchar(255) NO Company profile: Please enter company profile
contacts_name varchar(255) NO Contacts
contacts_position varchar(255) NO position
contacts_phone varchar(255) NO Contact telephone
contacts_email varchar(255) NO Contact email
company_registered_capital int(10) unsigned 0 NO Registered funds
company_employee_count int(10) unsigned 0 NO Total number of employees
company_taxnum varchar(20) NO Taxpayer identification number
company_invoice varchar(50) NO Invoice payable
legal_person varchar(50) NO Name of legal representative
legal_person_number varchar(50) NO Corporate Identity Card Number
legal_person_electronic varchar(255) NO Electronic version of corporate identity card
business_license_location varchar(255) NO Business license
establish_date date NO date of establishment
business_licence_start date NO The Starting Time of Statutory Business Scope
business_licence_end date NO Ending time of statutory scope of business
business_sphere varchar(255) NO Scope of business
business_license_electronic varchar(255) NO Business license
company_other_files varchar(1024) NO Other documents (DOT)
organization_code varchar(20) NO Organizational code
organization_code_start date NO Start time of validity of organization code certificate
organization_code_end date NO End of validity period of organization code certificate
organization_code_electronic varchar(255) NO Organizational Code Certificate Electronic Edition
general_taxpayer varchar(255) NO General taxpayer certificate
bank_account_name varchar(50) NO Bank Account Name
bank_account_number varchar(30) NO Company bank account
bank_name varchar(50) NO Name of branch of deposit bank
bank_code varchar(20) NO Bank Branch Interbank Number of Account Opening Bank
bank_address varchar(255) NO Location of branch of deposit-opening bank
bank_licence_electronic varchar(255) NO Electronic version of deposit bank license
tax_registration_certificate varchar(20) NO Tax Registration Certificate Number
tax_registration_certificate_electronic varchar(255) NO Electronic version of tax registration certificate number
payment_voucher varchar(255) NO Payment vouchers
payment_voucher_explain varchar(255) NO Payment vouchers
store_class_ids text NO Business Category
store_class_names text NO Collection of Store Management Category Names
store_class_commission text NO The percentage of commission in shop management category
contacts_fee float(10,2) NO Fee standard
contacts_deposit float(10,2) NO Bond
business_id varchar(20) 0 NO Business license
payment_type tinyint(1) unsigned 0 NO Payment methods: 1- WeChat; 2- Alipay; 3- bank transfer.
alipay_account varchar(255) NO Alipay account
alipay_realname varchar(255) NO Real name

shop_store_config Shop parameter setting table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_id int(10) unsigned NO Shop Number
sc_allow_seller_buy tinyint(1) unsigned 0 NO Salesman’s purchase authority (bool): 0-closed; 1-open. When the purchase authority is open, the orders purchased by the salesman himself will be included in the performance
sc_expenditure int(10) unsigned 0 NO Distribution application consumption
sc_cps_rate float(10,2) unsigned 0.00 NO Primary commission ratio
sc_second_is_enable tinyint(1) unsigned 1 NO Secondary sales (bool): 0-closed; 1-open
sc_second_cps_rate float(10,2) unsigned 0.00 NO Secondary commission ratio
sc_third_cps_rate float(10,2) unsigned 0.00 NO Ratio of three-tier Commission distribution
sc_directseller_customer_exptime int(10) unsigned 0 NO Customer relationship period: after a certain period of time, the customers brought by the salesperson (the time when the customers who become the store start to calculate) will no longer enjoy the sub Commission. The commission can be generated only when
sc_directseller_exptime_type tinyint(1) unsigned 1 NO Term of validity (enum): 1-permanent, establish customer relationship, and the purchase of customers in the store will be divided into commission; 2-Short term, only get commission according to the link purchase, and after a certain period, the link will fail. No customer relationship needed
sc_directseller_rel_exptime int(10) unsigned 0 NO Customer relationship protection period - the brought customer relationship will not be stolen within a certain period of time. Other sales can take effect through the purchase link, but the relationship will be changed within the protection period
sc_is_verify tinyint(1) unsigned 0 NO Salesman review (bool): 0-no need to review; 1-need to review
sc_auto_settle tinyint(1) unsigned 1 NO Settlement method (bool): 0-manual settlement; 1-automatic settlement
sc_settle_time_type int(10) unsigned 0 NO Settlement time
sc_is_use_min_quantity tinyint(1) unsigned 0 NO Enabling commodity minimum order
sc_is_use_max_quantity tinyint(1) 0 NO Enabling Limited Purchase of Commodities
sc_is_use_product_brand tinyint(1) unsigned 0 NO Enabling Commodity Brands
sc_is_use_product_weight tinyint(1) unsigned 0 NO Enable commodity weight field
sc_is_use_product_defined tinyint(1) unsigned 0 NO Enable Commodity Custom Fields
sc_product_tags varchar(255) [] NO Commodity Label Management (JSON)
sc_is_necessary_delivery_date date 0000-00-00 NO Delivery date must be filled in
sc_is_use_order_min_money tinyint(1) unsigned 0 NO Enable the minimum order amount limit (bool): 0-close; 1-enable
sc_order_min_money decimal(10,2) unsigned 0.00 NO Enable the minimum order amount limit
sc_deduct_inventory_mode tinyint(1) 1 NO Enum: 1 - ordering goods according to the general warehouse, not to restrict the warehouse to supply the designated customers; 2 - ordering goods according to the corresponding warehouse of the customer, not to restrict the warehouse to supply the designated customers
sc_inventory_agent_show_type tinyint(1) unsigned 2 NO Customer order system (enum): 0 - do not display inventory, customer order does not have inventory function; 1 - display whether there is a customer in the inventory and display whether there is a commodity inventory when placing an order, but do not display the specific quantity, and display no inventory information without filling in the inventory information; 2 - display the inventory quantity when placing an order, the customer order system can display the commodity inventory quantity when placing an order, and display no inventory information without filling in the inventory information
sc_is_enabled_inventory_check tinyint(1) 1 NO Enum: 1-order deduction lock; 2-payment deduction lock, quantity less than or equal to zero, no order
sc_fund_account_settings varchar(255) [] NO Customer fund account (JSON): [{“baseid”: 1, “name”: “prepayment account”, “code”: “0001”, “can”_ Pay “:” 1 “,” canrecharge “:” 1 “,” enablestatus “:” 1 “,” autoauditflag “:” 1 “}, {“ baseid “: 2,” name “:” rebate account “,” code “:” 0002 “,” can_ Pay “:” 1 “,” canrecharge “:” 0 “,” enablestatus “:” 1 “,” autoauditflag “:” 1 “}, {“ baseid “: 3,” name “:” margin account “,” code “:” 0003 “,” can_ pay”:”0”,”canRecharge”:”1”,”enableStatus”:”1”,”autoAuditFlag”:”0”}]
sc_order_process varchar(255) NO Order process settings (DOT)
sc_order_return_process varchar(255) NO Return process settings (DOT)
sc_is_enabled_share tinyint(1) unsigned 1 NO Enable customer product sharing (bool): 1-enable; 0-disable
sc_is_enabled_invoicing tinyint(1) unsigned 0 NO Enable purchase / sales inventory management (bool): 1-enable; 0-disable
sc_settle_circle tinyint(3) unsigned 30 NO Settlement cycle: 30 is the whole month
sc_settle_last_time int(11) unsigned 0 NO Last settlement time
sc_settle_next_time int(11) 0 NO Next settlement time
sc_points_consume_rate decimal(4,2) 0.00 NO Consumption bonus ratio
sc_start_distance decimal(4,2) NO Running distance
sc_start_amount decimal(4,2) NO Running - starting amount
sc_extra_amount decimal(4,2) NO Running - amount per kilometer beyond the starting distance
sc_festival_name varchar(255) NO Festival offer - event name
sc_festival_start varchar(255) NO Holiday offer - start time
sc_festival_end varchar(255) NO Holiday offer - end time
sc_festival_amount_upper decimal(10,2) NO Holiday offer - maximum amount
sc_festival_amount_down decimal(10,2) NO Holiday offers - Holiday floor
sc_festival_float_proportion decimal(4,2) NO Festival offer - Daily floating rate
sc_festival_float_type tinyint(1) 1 NO Holiday offers - floating
sc_is_free_freight tinyint(1) 0 NO Shop free shipping (bool): 0-closed; 1-open

shop_store_contract Association table of consumer protection service stores

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
contract_id int(10) NO Association number
contract_type_id int(10) unsigned NO Service number
contract_type_name varchar(50) NO Service Category Name
store_id int(10) unsigned 0 NO Shop Number
store_name varchar(50) NO Shop Name
contract_state tinyint(1) unsigned 0 NO Application status (enum): 1-apply to join; 2-apply to exit; 9-pass
contract_use_state tinyint(1) 2 NO Join status (bool): 1-joined; 2-exited
contract_deposit decimal(8,2) 0.00 NO Guarantee balance

shop_store_contract_log Payment log form of consumer security service deposit

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
contract_log_id int(10) NO Log number
contract_id int(10) NO Service number
contract_type_id int(10) NO Service number
contract_type_name varchar(50) NO Service name
store_id int(10) unsigned 0 NO Shop Number
store_name varchar(50) NO Shop Name
contract_log_operator varchar(50) NO Successful operation
contract_log_date timestamp CURRENT_TIMESTAMP NO Log generation time
contract_log_desc varchar(255) NO Log content
contract_deposit decimal(10,2) NO Amount of deposit paid, plus or minus
contract_log_type tinyint(1) unsigned 4 NO Type (enum): 1-margin operation; 2-join operation; 3-exit operation; 4-other operation
contract_log_state tinyint(1) unsigned 1 NO Status (enum): 1-to be reviewed (join / exit); 2-deposit to be reviewed (join); 3-to be reviewed (join / exit); 4-to be reviewed (join / exit); 5-deposit paid
contract_cash_pic varchar(255) NO Deposit picture

shop_store_custom_service Shop customer service form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
custom_service_id int(10) NO Customer service No
store_id int(10) NO Shop Number
custom_service_name varchar(20) NO Customer Service Name
custom_service_qq varchar(20) NO Customer service QQ
custom_service_ww varchar(20) NO Customer Service Wangwang
custom_service_tool tinyint(1) 0 NO Customer service tools: 1: QQ; 2: WW
custom_service_enable tinyint(1) unsigned 0 NO Enable (enum): 0-no; 1-yes;
custom_service_number varchar(30) NO Customer service account
custom_service_type tinyint(1) unsigned 0 NO Customer service type: 0-pre-sales customer service; 1-after-sales customer service;

shop_store_domain Secondary domain name table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_id int(10) unsigned NO -
store_sub_domain varchar(100) NO Sub domain
store_edit_domain int(10) 0 NO Number of edits
store_self_domain varchar(100) NO Custom domain name

shop_store_employee Seller user table - company employee - enable user center through user ID

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
employee_id int(10) unsigned NO Vendor number
store_id int(10) unsigned NO Shop Number
user_id int(10) unsigned NO Membership Number
rights_group_id varchar(100) NO Vendor group number
employee_is_admin tinyint(3) unsigned 0 NO Administrator (bool): 0-ordinary employee; 1-administrator
employee_login_time timestamp CURRENT_TIMESTAMP NO Last login time

shop_store_employee_department Department table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
department_id int(8) unsigned NO Department Number
department_parent_id int(8) 0 NO Superior departments
department_name varchar(50) NO Permission group name
department_add_time timestamp CURRENT_TIMESTAMP NO Creation time
store_id int(11) NO Shop Number
department_enable tinyint(1) unsigned 0 NO Whether to enable (bool): 0-disable; 1-enable
department_buildin tinyint(1) 0 NO System built in (bool): 0-not built in; 1-built in

shop_store_employee_log Seller log form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
employee_log_id bigint(20) unsigned NO -
employee_log_content varchar(50) NO Log content
employee_log_time timestamp CURRENT_TIMESTAMP NO Log time
user_id int(10) unsigned NO Vendor number
user_name varchar(50) NO Seller account number
store_id int(10) unsigned NO Shop Number
employee_log_ip varchar(50) NO Seller IP
employee_log_url varchar(50) NO Log URL
employee_log_status tinyint(1) unsigned 1 NO Log status (0 - failure 1 - success)

shop_store_employee_rights User permission information table - obsolete, use store_ employee

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
employee_id int(8) unsigned NO User number
employee_group_id text NO User rights group
employee_rights_ids text NO User rights

shop_store_employee_rights_base Authority table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
rights_id smallint(4) unsigned NO Authority number
rights_name varchar(20) NO Name of permission
rights_parent_id smallint(4) unsigned NO Permission parent number
rights_remark varchar(255) NO Remarks
rights_order smallint(4) 50 NO sort

shop_store_employee_rights_group Permission group table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
rights_group_id smallint(4) unsigned NO Authority Group No
rights_group_name varchar(50) NO Permission group name
rights_group_rights_ids varchar(2048) NO Permission list (DOT)
rights_group_rights_data varchar(2048) NO Data permission (DOT): group data permission, which is only used to represent data with a certain small result set.
rights_group_add_time timestamp CURRENT_TIMESTAMP NO Creation time
store_id int(11) NO Shop Number

shop_store_entity Physical store store relationship?

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
entity_id int(10) NO Physical store No
store_id int(10) 0 NO Shop Number
entity_name char(60) 0 NO Name of physical store
store_lng varchar(20) 0 NO longitude
store_lat varchar(20) 0 NO latitude
entity_district_info varchar(255) NO area
entity_address varchar(255) NO Please enter the store’s detailed address.
entity_tel varchar(30) NO Physical store contact number
entity_transit varchar(1024) NO Public transport information

shop_store_expense Shop expense table - first expense, unified settlement

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
expense_id int(10) unsigned NO Expense No
user_id int(10) unsigned 0 NO Subordinate users
store_id int(10) unsigned 0 NO The shop under which it belongs
expense_value decimal(10,2) 0.00 NO Pre-tax expenses
expense_name varchar(255) NO describe
expense_status tinyint(1) unsigned 0 NO Status (bool): 0-unsettled; 1-settled
expense_time int(10) unsigned 0 NO Creation time

shop_store_express_logistics Logistics = shop_ store_ express

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
logistics_id int(10) NO Logistics No
store_id int(10) 0 NO Store
chain_id int(10) 0 NO store_ express_ logistics_ cond
logistics_name varchar(30) NO Logistics Name
logistics_pinyin varchar(30) NO View Logistics
logistics_number int(11) NO Logistics Company Number
logistics_state tinyint(1) 0 NO Single state of electronic surface
express_id mediumint(8) 0 NO Corresponding Express Company
express_name varchar(30) NO Delivery company
waybill_tpl_id int(11) 0 NO -
logistics_is_default tinyint(1) 0 NO Default (bool): 1-default; 0-non default
logistics_tpl_item varchar(2048) NO -
logistics_tpl_top varchar(255) 0 NO The offset on the waybill template in millimeter mm.
logistics_tpl_left varchar(255) 0 NO Left offset of Waybill template in millimeter mm
logistics_phone varchar(20) NO Contact number:
logistics_mobile varchar(20) NO Contact your cell phone
logistics_contacter varchar(100) NO Contacts
logistics_tax varchar(20) NO Fax
logistics_address varchar(100) NO Contact address
logistics_fee text NO Logistics freight
fee_type tinyint(1) 0 NO Freight type (enum) 0-unified; 1-regional
logistics_is_enable tinyint(1) 1 NO Whether to enable (bool): 1-enable; 0-disable

shop_store_express_logistics_contactor Binding user list of logistics outlets

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
selc_id int(10) unsigned NO Contact number
logistics_id int(10) unsigned 0 NO Logistics point No
selc_name varchar(10) NO Contacts
selc_im varchar(30) NO Contact Im, MSN/QQ
selc_mobile bigint(11) NO Cell Phone
selc_telephone varchar(30) NO Contact seating machine
selc_district_ids varchar(20) NO Contact Area (DOT)
selc_address varchar(50) NO Contact address
selc_first tinyint(1) 1 NO Primary contact (bool): 0-non primary; 1-primary
selc_code mediumint(9) 0 NO Contacter_code

shop_store_extend Extended table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_id int(10) NO -

shop_store_festival Shop Festival table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_festival_id int(10) unsigned NO Festival activity number
festival_id int(10) unsigned 0 NO Platform activity Festival No
store_id int(10) unsigned 0 NO Merchant number
festival_rate decimal(10,2) NO Floating Ratio: Percentage

shop_store_info Store table - users can have multiple stores - need to separate tables

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_id int(10) unsigned NO Shop Number
store_register_region varchar(255) NO Location of registration
store_deliver_region varchar(1024) NO Distribution Area (DOT)
store_settlement_cycle mediumint(4) 30 NO Settlement cycle: day as unit - if you want to set the settlement cycle to one month, you can enter 30
store_banner varchar(255) NO Shop Banner
store_slide varchar(1024) NO Shop Slide and Slide Link (JSON)
store_address varchar(255) NO Detailed address
store_workingtime varchar(1024) NO Working hours
store_tel varchar(12) NO Seller Telephone
store_qq varchar(20) NO QQ
store_ww varchar(20) NO Wangwang
store_is_renovation tinyint(1) 0 NO Open decoration: 0-no; 1-yes
store_stamp varchar(255) NO Shop Seal
store_free_shipping int(10) 0 NO Freight margin
store_template varchar(20) shop1 NO Store Binding Template
store_print_desc varchar(255) NO Print the instructions at the bottom of the order page
store_state_id smallint(4) unsigned 3210 NO Store information status (enum): 3210 data to be improved; 3220 data to be reviewed; 3230 data to be reviewed failed; 3240 data to be reviewed and paid
store_payment_state tinyint(3) unsigned 0 NO Payment status (enum): 0-unpaid; 1-paid to be reviewed; 2-approved
store_start_time timestamp 0000-00-00 00:00:00 NO Start time of this time
store_end_time timestamp 0000-00-00 00:00:00 NO Deadline of validity
store_close_reason varchar(255) NO Cause of closure
store_points int(10) unsigned 0 NO Integral Exchange
store_notice varchar(255) NO Buying instructions
store_opening_hours varchar(255) NO Business Hours
store_close_hours varchar(255) NO Closing time
store_points_consume_rate decimal(4,2) 0.00 NO Consumption bonus ratio
store_circle varchar(50) NO Business district (DOT)

shop_store_media User attachment table - pictures, videos

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
media_id bigint(20) unsigned NO Product picture number
media_number char(32) NO Attachment MD5
gallery_id bigint(20) NO -
store_id int(10) unsigned 0 NO Shop Number
media_url varchar(255) NO The URL of the attachment defaults to the original image
media_source varchar(255) NO Source - website capture
media_order mediumint(4) unsigned 50 NO Sort - smaller, higher
media_domain varchar(255) NO domain name
media_path varchar(255) NO Attachment path local storage
media_type enum(‘video’,’other’,’image’) image NO image/video/
media_image_h int(10) unsigned 0 NO Higher than
media_image_w int(10) unsigned 0 NO export
media_size int(10) unsigned 0 NO Original file size
media_mime_type varchar(100) NO Uploaded attachment type
media_metadata varchar(255) NO metadata
media_alt varchar(255) NO Attachment alt
media_name varchar(50) NO Attachment title
media_desc varchar(255) NO Attachment description
media_password varchar(20) NO Attachment browse password
media_time timestamp CURRENT_TIMESTAMP NO Attachment date

shop_store_media_gallery User album table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
gallery_id bigint(20) unsigned NO Product picture number
gallery_name varchar(100) NO Album Name
gallery_desc varchar(255) NO Album Description
gallery_num mediumint(8) unsigned 0 NO Content quantity
gallery_is_default tinyint(4) unsigned 0 NO Default Album: 1-yes; 0-no
gallery_order smallint(4) unsigned 50 NO sort
gallery_type enum(‘video’,’other’,’image’) image NO Annex
gallery_cover varchar(255) NO cover
store_id int(10) unsigned 0 NO The shop under which it belongs

shop_store_message_setting Store message setting table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
sms_id int(10) unsigned NO number
store_id int(10) unsigned NO User number
message_template_ids varchar(1024) NO Open template (DOT)
sms_time timestamp CURRENT_TIMESTAMP NO Set time

shop_store_meta Store extension table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
meta_id varchar(50) NO Meta id = user_ id-meta_ Key
data_id int(10) unsigned 0 NO data_ id = store_ ID
meta_key varchar(255) NO key
meta_value varchar(1024) NO value
meta_datatype enum(‘string’,’json’,’number’) string NO data type

shop_store_nav Shop page navigation table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_nav_id int(11) NO Index number
store_nav_type tinyint(1) 0 NO Category, 0 custom navigation, 1 product classification, 2 article navigation, 3 activity navigation, default is 0
store_nav_title varchar(100) NO Navigation title
store_nav_url varchar(255) NO Navigation Links
store_nav_position tinyint(1) 0 NO Navigation position, 0 head, 1 middle, 2 bottom, default 0
store_nav_target_blank tinyint(1) 0 NO Open as a new window, 0 = no, 1 = yes, default = 0
store_nav_order tinyint(3) unsigned 255 NO sort
store_nav_content text NO Navigation content
store_nav_time timestamp CURRENT_TIMESTAMP NO -

shop_store_points_item Bonus gift table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
points_item_id int(10) NO Index number of points and gifts
points_item_number varchar(50) NO Credit Gift Item No
points_item_name varchar(100) NO Name of point gift
points_item_price decimal(10,2) 0.00 NO Original price of bonus gifts
points_item_points int(10) 0 NO Points for gift exchange
points_item_image varchar(255) NO Bonus gift default cover image
points_item_tag varchar(100) NO Point gift label (DOT)
points_item_storage int(10) 0 NO Bonus gift inventory
points_item_enable tinyint(1) unsigned 0 NO Integral gift on shelf (bool): 0-for off shelf; 1-for on shelf
points_item_recommend tinyint(1) 0 NO Whether to recommend bonus gifts (bool): 1-yes; 0-no
points_item_add_time timestamp CURRENT_TIMESTAMP NO Time to add bonus gifts
points_item_keywords varchar(100) NO Points gift keywords
points_item_description varchar(200) NO Point gift description
points_item_content text NO Details of points and gifts
points_item_salenum int(10) 0 NO Number of points sold
points_item_view int(10) 0 NO Number of points product views
points_item_user_level int(10) 0 NO Change purchase is limited to the member level. The default value is 0. All levels can be changed
points_item_islimit tinyint(1) 0 NO Limit the number of exchanges per member (bool): 0 - unlimited; 1 - Limited
points_item_limitnum int(10) NO Limited exchange quantity per member
points_item_islimittime tinyint(1) 0 NO Limit exchange time (bool): 0-unlimited; 1-restricted
points_item_starttime int(11) 0 NO Exchange start time
points_item_endtime int(11) 0 NO Exchange end time
points_item_order int(10) 50 NO Gift sorting

shop_store_product_category Classification of shop goods

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_product_cat_id int(10) unsigned NO Classification Number
store_product_cat_name varchar(50) NO Category name
store_product_cat_image varchar(255) NO Classified pictures
store_id int(10) unsigned NO The shop under which it belongs
parent_id int(10) 0 NO Father number
store_product_cat_enable tinyint(1) unsigned 1 NO Whether to enable (bool): 0-disable; 1-enable
store_product_cat_order tinyint(1) unsigned 50 NO sort
store_product_cat_level tinyint(1) unsigned 1 NO Classification level
store_product_cat_is_leaf tinyint(1) unsigned 0 NO Leaf node or not

shop_store_product_format Related plate table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_format_id int(10) unsigned NO Layout number
product_format_name varchar(50) NO Layout name
store_id int(10) unsigned NO -
product_format_header_content varchar(5000) NO Layout content (HTML)
product_format_footer_content varchar(5000) NO Layout content (HTML)

shop_store_product_tag List of commodity labels of merchants

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_product_tag_id int(10) NO Tag No
product_tag_id int(10) unsigned 0 NO product_ tag_ ID
store_id int(10) 0 NO Shop Number
product_tag_time datetime NO Select label time
store_product_tag_buildin tinyint(1) unsigned 0 NO Bool: 0-no; 1-yes

shop_store_renewal_apply Renewal application form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_renewal_apply_id int(10) unsigned NO number
user_id int(10) unsigned NO Membership Number
store_id int(10) unsigned NO Shop Number
store_name varchar(50) NO Shop Name
store_grade_id int(10) unsigned NO Shop level number
store_grade_name varchar(50) NO Shop level name
store_grade_fee decimal(10,2) NO Store level fee
store_renewal_apply_renewtime int(10) unsigned NO Renewal duration
store_renewal_apply_expense decimal(10,2) NO Total renewal fee
store_renewal_apply_time timestamp CURRENT_TIMESTAMP NO Application time
store_renewal_apply_starttime timestamp 0000-00-00 00:00:00 NO Validity period start time
store_renewal_apply_endtime timestamp 0000-00-00 00:00:00 NO Expiry date
store_renewal_apply_status tinyint(1) 0 NO Unknown state
admin_id int(10) unsigned 0 NO Administrator No
admin_name varchar(50) NO Administrator name
store_renewal_apply_desc varchar(100) NO Remarks

shop_store_saler Shop salesman

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
saler_id int(10) unsigned NO Vendor number
store_id int(10) unsigned NO Shop Number
user_id int(10) unsigned NO Membership Number

shop_store_setting Shop setting table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
store_setting_id int(10) unsigned NO Shop Number
store_id tinyint(3) unsigned 0 NO Store level
store_is_brand tinyint(1) unsigned 1 NO Enable product brand (bool): 1-enable; 0-disable enable product brand, the product will increase the brand option, and the product brand will be used as the product filter criteria.
store_is_weight tinyint(1) unsigned 0 NO Enable product weight: 0-off; 1-enable
shop_parent_id int(11) 0 NO Superior store No.: store creation decision, distributor - cannot be changed! Commission equity considerations
store_category_id int(10) unsigned 0 NO Shop classification number
store_time timestamp CURRENT_TIMESTAMP NO Join time

shop_store_shipping_address Shipping address table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
ss_id int(10) unsigned NO Address number
ss_name varchar(10) NO Contacts
ss_mobile bigint(11) NO Phone number
ss_telephone varchar(30) NO Contact number:
ss_contacter varchar(20) NO Contacts (not enabled)
ss_postalcode varchar(30) NO Contact Im: QQ
ss_province_id int(10) 0 NO Province No
ss_province varchar(10) NO Province
ss_city_id int(10) 0 NO City No
ss_city varchar(10) NO city
ss_county_id int(10) unsigned 0 NO county
ss_county varchar(10) NO County Area
ss_address varchar(50) NO Detailed Address - No need to duplicate areas
ss_time timestamp CURRENT_TIMESTAMP NO Add time
ss_is_default tinyint(1) unsigned 0 NO Default address (enum): 0-no; 1-yes
store_id int(10) 0 NO The shop under which it belongs

shop_store_themes Shop style table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
app_id int(10) unsigned NO Application number
app_name varchar(1024) NO apply name
app_code text NO Application code
tpl_id int(10) unsigned 0 NO Template No
store_id mediumint(8) unsigned 0 NO The shop under which it belongs
user_id mediumint(8) unsigned 0 NO Subordinate users
subsite_id mediumint(4) unsigned 0 NO Sub station: 0-main station
app_buildin tinyint(1) unsigned 0 NO Built in (bool): 0-no; 1-yes
app_type tinyint(1) unsigned 1 NO Type (enum): 1-wap; 2-PC; 3-app
app_tpl text NO Apply template

shop_store_transport_amount Store purchase quota freight template

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
sta_id int(10) unsigned NO number
sta_free_amount decimal(6,2) 0.00 NO Freight margin
sta_decrease smallint(3) 1 NO Reduction of quota
sta_add_price decimal(6,2) 0.00 NO Increase freight
sta_city_ids varchar(6000) NO Regional city ID (DOT): it can be sold in different regions and all over the country * instead of ID price needs to calculate logistics cost according to weight, etc
sta_city_row text NO Regional city ID (JSON)
sta_city_name varchar(6000) [] NO Regional city name (JSON)
store_id int(10) NO The shop under which it belongs

shop_store_transport_item User defined logistics template content table - only process area and freight.

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
transport_item_id int(10) unsigned NO number
transport_type_id mediumint(8) unsigned NO Custom logistics template number
logistics_type varchar(50) NO EMS, pingpost, express - obsolete
transport_item_default_num smallint(3) unsigned 0 NO Default number
transport_item_default_price decimal(6,2) 0.00 NO Default freight
transport_item_add_num smallint(3) 1 NO Increase in quantity
transport_item_add_price decimal(6,2) 0.00 NO Increase freight
transport_item_city_ids varchar(6000) NO Regional city ID (DOT): it can be sold in different regions and all over the country * instead of ID price needs to calculate logistics cost according to weight, etc
transport_city_ids text NO Regional city ID (JSON)
transport_item_city_name varchar(6000) [] NO Regional city name (JSON)

shop_store_transport_offpay_area To pay area.

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
offpay_area_id int(10) unsigned NO number
store_id int(10) unsigned 0 NO Shop Number
offpay_area_city_ids varchar(5000) NO Regional city ID (DOT)

shop_store_transport_type Custom logistics freight and sales area type table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
transport_type_id mediumint(8) unsigned NO Logistics and sales area No
transport_type_name varchar(20) NO Template name
store_id int(10) unsigned 0 NO The shop under which it belongs
chain_id int(10) unsigned 0 NO Store number
transport_type_pricing_method smallint(1) unsigned 1 NO Charging rules (enum): 1-by pieces; 2-by weight; 3-by volume
transport_type_time timestamp CURRENT_TIMESTAMP NO Last edit time
transport_type_freight_free decimal(10,2) unsigned 0.00 NO Freight margin
transport_type_buildin tinyint(1) unsigned 0 NO System built in (bool): 0-not built in; 1-built in
transport_type_free tinyint(1) unsigned 0 NO All free freight (bool): 0-not all free; 1-all free (unlimited area and free freight)

shop_store_waybill_tpl Delivery form layout

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
waybill_tpl_id int(10) unsigned NO -
waybill_tpl_name varchar(20) NO Template name
store_id int(10) unsigned NO The shop under which it belongs
express_id mediumint(8) NO Logistics Company Number
waybill_tpl_width int(11) 0 NO Waybill width in mm
waybill_tpl_height int(11) 0 NO Waybill height in mm
waybill_tpl_top int(255) 0 NO Offset on waybill template, unit: mm
waybill_tpl_left int(255) 0 NO Left offset of Waybill template, unit: mm
waybill_tpl_image varchar(200) NO Template image - please upload the scanned image of the waybill. The size of the image must be consistent with the actual size of the express bill
waybill_tpl_enable tinyint(1) 1 NO Is it enabled?
waybill_tpl_buildin tinyint(1) 1 NO System built-in can not be deleted!

shop_user_base User basic information table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_id int(10) unsigned NO User number
user_number varchar(50) NO User number
user_account varchar(50) NO User account
user_passwd char(32) NO Password: use user center - discard here
user_nickname varchar(30) NO Username
user_key char(32) NO User key
user_delete tinyint(4) 0 NO Whether it is banned (bool): 0-not banned; 1-banned
user_login_times mediumint(8) unsigned 1 NO Number of logins
user_login_time timestamp 0000-00-00 00:00:00 NO Last login time

shop_user_cart Shopping cart table - package is handled as one item

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
cart_id int(10) unsigned NO number
user_id int(10) unsigned 0 NO Buyer ID
store_id int(10) unsigned 0 NO Shop Number
product_id bigint(20) 0 NO Product number
item_id bigint(20) unsigned 0 NO Commodity ID
cart_quantity smallint(5) unsigned 1 NO Quantity of goods purchased
cart_type tinyint(1) unsigned 1 NO Purchase type (enum): 1-purchase; 2-point exchange; 3-complimentary; 4-event promotion
activity_id int(10) unsigned 0 NO Activity ID - tips for adding shopping
activity_item_id bigint(20) unsigned 0 NO Add activity item number of shopping cart
cart_select tinyint(1) 1 NO Selected status (bool): 0-not selected; 1-selected
cart_ttl int(10) 0 NO Valid time stamp
cart_time int(10) unsigned 0 NO Add timestamp
cart_file varchar(255) NO piece

shop_user_delivery_address User address table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
ud_id int(10) unsigned NO Order Id
user_id int(10) unsigned 0 NO User number
ud_name varchar(10) NO Contacts
ud_mobile varchar(20) NO Phone number
ud_telephone varchar(30) NO Contact number:
ud_contacter varchar(20) NO Contacts (not enabled)
ud_im varchar(255) NO Contact Im, MSN/QQ
ud_province_id int(10) 0 NO Province No
ud_province varchar(10) NO Province
ud_city_id int(10) 0 NO City No
ud_city varchar(10) NO city
ud_county_id int(10) unsigned 0 NO county
ud_county varchar(10) NO County Area
ud_address varchar(50) NO Detailed address
ud_postalcode varchar(30) NO Postal Code
ud_tag_name varchar(50) 0 NO Address tag: home, company, etc
ud_longitude varchar(20) NO longitude
ud_latitude varchar(20) NO Latitudinal reading
ud_time timestamp CURRENT_TIMESTAMP NO Add time
ud_is_default tinyint(1) 0 NO Default or not

shop_user_exp_history Member experience log

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
exp_log_id int(10) NO -
exp_kind_id smallint(4) unsigned 1 NO Type (enum): 1-get; 2-consume
exp_type_id smallint(4) unsigned 0 NO Bonus type (enum): 1-member registration; 2-member login; 3-product review; 4-purchase product; 5-administrator operation; 7-bonus exchange product; 8-bonus exchange voucher
user_id int(10) NO Membership Number
exp_log_value int(10) unsigned 0 NO Available experience
user_exp int(10) unsigned 0 NO Current experience
exp_log_time timestamp CURRENT_TIMESTAMP NO Creation time
exp_log_desc varchar(100) NO describe
store_id int(10) unsigned 0 NO The shop under which it belongs
exp_log_date timestamp 0000-00-00 00:00:00 NO Date of experience

shop_user_favorites_brand Collection brand

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
favorites_brand_id int(10) unsigned NO -
user_id int(10) unsigned NO User number
brand_id int(10) unsigned NO Brand Number
favorites_time timestamp CURRENT_TIMESTAMP NO Collection time

shop_user_favorites_item Favorite items - according to SKU

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
favorites_item_id int(10) unsigned NO -
user_id int(10) unsigned NO User number
item_id int(10) unsigned NO Commodity ID
favorites_time timestamp CURRENT_TIMESTAMP NO -

shop_user_favorites_store Collection shop

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
favorites_store_id int(10) unsigned NO -
user_id int(10) unsigned NO User number
store_id int(10) unsigned NO Shop Number
favorites_time timestamp CURRENT_TIMESTAMP NO Collection time

shop_user_invoice User invoice management table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_invoice_id int(11) NO Invoice No
user_id int(11) unsigned 0 NO Subordinate users
invoice_title varchar(50) NO Invoice payable
invoice_content varchar(50) NO Invoice contents:
invoice_type enum(‘company’,’person’) person NO Invoice type (enum): person individual; company company company
invoice_kind tinyint(1) unsigned 1 NO Invoice form (enum): 1-paper invoice; 2-electronic invoice
invoice_company_code varchar(100) NO Taxpayer identification number
invoice_status tinyint(1) 0 NO Invoicing status: 0 - not invoiced; 1 - invoiced;
invoice_datetime datetime NO Add time

shop_user_message SMS

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
message_id int(11) NO SMS index number
message_parent_id int(11) NO Reply to the message “Id”
user_id int(10) unsigned NO Short Message Receiver
user_from_id int(10) unsigned NO SMS sender
user_from_nickname varchar(50) NO User name of sender
message_content varchar(255) NO Short message content
message_time timestamp CURRENT_TIMESTAMP NO Sending time of SMS
message_is_read tinyint(1) 0 NO Whether to read (bool): 0-unread; 1-read
message_is_delete tinyint(1) 0 NO Short message status (bool): 0-normal status; 1-deletion status
message_type tinyint(1) 2 NO Message type: 1-system message; 2-user message; 3-private message
message_cat tinyint(1) NO Message classification: 1-message; 2-user message; 3-order message
message_data_id varchar(50) NO Message data
message_kind varchar(10) text NO Message type (enum): text message; img picture message; video video message; file: file; location: Location

shop_user_message_setting Message settings table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
ums_id int(10) unsigned NO number
user_id int(10) unsigned NO User number
message_template_ids varchar(1024) NO Open template (DOT)
ums_time timestamp CURRENT_TIMESTAMP NO Set time

shop_user_meta User data extension table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
meta_id varchar(50) NO Meta id = user_ id-meta_ Key
data_id int(10) unsigned 0 NO Data user_ ID
meta_key varchar(255) NO key
meta_value varchar(1024) NO value
meta_datatype enum(‘string’,’json’,’number’) string NO data type

shop_user_points_api_history Member points log

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
id varchar(100) NO Payment note No
offline_order_id varchar(100) NO Order number generated by the caller
out_order_no varchar(100) NO Order number produced by WeChat or Alipay
order_status varchar(100) NO Order status, details refer to: order status details
money decimal(8,2) 0.00 NO Payment amount
seller_id varchar(255) NO Payment merchant No
buyer_id varchar(255) NO consumer number
payment_channel varchar(255) NO Payment channel, details refer to: detailed explanation of payment channel
subject varchar(255) NO Order introduction
processed tinyint(1) unsigned 0 NO Processing status (bool): 1-processed; 0-not processed
points_log_id int(10) NO Corresponding logging
payment_way varchar(255) NO Payment method, details refer to: detailed explanation of payment method
time timestamp CURRENT_TIMESTAMP NO time
total_amount varchar(255) NO Total orders
discount_amount varchar(255) NO Preferential amount
pay_time int(11) NO Payment time

shop_user_points_history Member points log

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
points_log_id int(10) NO -
points_kind_id smallint(4) unsigned 1 NO Type (enum): 1-get points; 2-consume points;
points_type_id smallint(4) unsigned 0 NO Bonus type (enum): 1-member registration; 2-member login; 3-product review; 4-purchase product; 5-administrator operation; 7-bonus exchange product; 8-bonus exchange voucher
user_id int(10) NO Membership Number
points_log_points decimal(16,6) 0.000000 NO Available points
user_points decimal(16,6) 0.000000 NO Current points
points_log_time timestamp CURRENT_TIMESTAMP NO Creation time
points_log_desc varchar(100) NO describe
store_id int(10) unsigned 0 NO The shop under which it belongs
points_log_date date 0000-00-00 NO Point date
user_id_other int(10) 0 NO Interactive members
points_log_state tinyint(1) unsigned 1 NO Collection status (bool): 0 - not collected; 1 - received

shop_user_privacy User information privacy settings table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_id int(10) unsigned NO User number
user_privacy_email tinyint(1) 0 NO Mailbox setting 0 public 1 visible to friends 2 confidential
user_privacy_realname tinyint(1) 0 NO Real name setting 0 public 1 friends visible 2 confidential
user_privacy_sex tinyint(1) NO Gender setting 0 public 1 visible to friends 2 confidential
user_privacy_birthday tinyint(1) 0 NO Birthday setting 0 public 1 friends visible 2 confidential
user_privacy_area tinyint(1) 0 NO Local setting 0 public 1 friends visible 2 confidential
user_privacy_qq tinyint(1) 0 NO QQ setting 0 public 1 friends visible 2 confidential
user_privacy_ww tinyint(1) 0 NO Alibaba Wangwang set 0 public 1 visible to friends 2 confidential
user_privacy_mobile tinyint(1) 0 NO Mobile settings 0 public 1 visible to friends 2 confidential

shop_user_product_browse Product browsing history - SPU - should not be stored directly in the database

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_browse_id bigint(20) unsigned NO -
item_id int(10) NO Commodity ID
user_id int(10) NO Membership Number
browse_date date 0000-00-00 NO Browse date
browse_time timestamp CURRENT_TIMESTAMP NO Browse time
category_id mediumint(8) unsigned 0 NO Classification of commodities
category_id_1 mediumint(8) unsigned 0 NO Primary classification of commodities
category_id_2 mediumint(8) unsigned 0 NO Secondary classification of commodities
category_id_3 mediumint(8) unsigned 0 NO Three level classification of commodities

shop_user_product_buy User’s purchase quantity history

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
product_buy_id bigint(20) unsigned NO number
product_id bigint(20) unsigned 0 NO Commodity ID
item_id bigint(20) unsigned 0 NO SKU
user_id int(10) unsigned 0 NO Membership Number
product_buy_num int(10) 0 NO Purchase Quantity
product_buy_time timestamp CURRENT_TIMESTAMP NO Browse time

shop_user_product_meta User product data extension table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
meta_id varchar(50) NO Meta id:data_ id-meta_ Key
data_id int(10) unsigned 0 NO product_ ID
meta_key varchar(255) NO key
meta_value varchar(20000) NO value
meta_datatype enum(‘string’,’json’,’number’,’dot’) string NO data type

shop_user_product_stock User goods inventory table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
ps_id bigint(20) unsigned NO number
product_id bigint(20) unsigned 0 NO Commodity ID
item_id bigint(20) unsigned 0 NO SKU number
user_id int(10) unsigned 0 NO Membership Number
ps_num int(10) 0 NO Purchase Quantity
ps_time timestamp CURRENT_TIMESTAMP NO Browse time

shop_user_product_stock_history User goods inventory record

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
upsh_id int(10) NO number
upsh_kind_id smallint(4) unsigned 1 NO Type (enum): 1-acquisition; 2-consumption;
upsh_type_id smallint(4) unsigned 0 NO Type (enum): 1-purchase acquisition; 2-gift acquisition; 3-gift consumption; 4-consumption consumption; 5-administrator operation;
user_id int(10) NO Membership Number
product_id bigint(20) unsigned NO SPU
item_id bigint(20) unsigned NO SKU
upsh_num decimal(16,6) 0.000000 NO Number of operations
ps_num decimal(16,6) 0.000000 NO Original quantity
upsh_time timestamp CURRENT_TIMESTAMP NO Creation time
upsh_desc varchar(100) NO describe
store_id int(10) unsigned 0 NO The shop under which it belongs
upsh_date date 0000-00-00 NO Point date
user_id_other int(10) 0 NO Interactive members
upsh_state tinyint(1) unsigned 1 NO Collection status (bool): 0 - not collected; 1 - received

shop_user_saas Record the unique store of SaaS users

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_id int(10) unsigned NO User number
store_ids varchar(10) NO User accessible store (DOT)

shop_user_search_history User search history table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
search_id varchar(32) NO md5. userid.keyword
search_keyword varchar(80) NO Search keywords
search_char_index varchar(80) NO Pinyin index
search_nums int(11) unsigned 0 NO Number of searches
user_id mediumint(8) unsigned 0 NO Search users
search_time timestamp CURRENT_TIMESTAMP NO -

shop_user_sign User sign in form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
sign_id int(10) NO Sign in No
user_id int(10) NO User number
sign_time timestamp 0000-00-00 00:00:00 NO Check in time
sign_day int(10) NO Check in days

shop_user_tag User interest tab

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_tag_id int(10) NO Interest tag number
tag_id int(10) NO Tag No
user_id int(10) NO User number
user_tag_time timestamp CURRENT_TIMESTAMP NO Select label time

shop_user_voucher User voucher form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_voucher_id int(11) NO Voucher No
activity_id int(10) unsigned NO Voucher template No
voucher_state_id smallint(4) unsigned 1501 NO Voucher status (enum): 1501 unused; 1502 used; 1503 expired; 1504 recovered
user_voucher_time timestamp CURRENT_TIMESTAMP NO Voucher issue date
user_id int(11) unsigned 0 NO Subordinate users
order_id varchar(50) NO Order Id
user_voucher_activetime timestamp 0000-00-00 00:00:00 NO Usage time
voucher_price decimal(10,2) NO Coupon deductible price
voucher_subtotal decimal(10,2) NO Order amount using coupons
voucher_end_date timestamp 0000-00-00 00:00:00 NO Date of expiration
store_id int(11) 0 NO Shop No
item_id int(10) NO Item number
voucher_type mediumint(2) 0 NO Coupon type (enum): 0-regular coupon; 1-free coupon

shop_user_wechat WeChat official account binding table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
wechat_openid varchar(255) NO Growth Value
wechat_unionid varchar(255) NO -
wechat_app_id varchar(255) NO App number
user_id int(10) unsigned NO -

shop_wechat_access_token Wechat access_ Token central control server table - currently directly in cache zero_ Api_ Wechat

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
wechat_app_id varchar(255) NO App number
wechat_access_token varchar(1024) NO access_ Token - unified access. If it fails, it needs to provide a re access interface
wechat_expires_in int(10) unsigned 0 NO expires_ In
wechat_ttl int(10) unsigned 0 NO Valid timestamps time + expires_ In

shop_wechat_keyword Wechat magic keyword table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
wk_id mediumint(8) unsigned NO Trigger key number
wk_parent_id mediumint(8) unsigned 0 NO Key p number
wk_name varchar(20) NO Trigger keywords
wk_type_id smallint(4) unsigned 1 NO Trigger type (list): 1-plain text; 2-graphic text;
wk_url varchar(255) NO link
wk_desc varchar(255) NO Keyword description
wk_title varchar(50) NO Title [Graphic and Textual Validity]
wk_image varchar(255) NO Cover [picture and text valid]
wk_enable tinyint(1) unsigned 1 NO Whether to enable (bool): 0-disable; 1-enable
wk_is_buildin tinyint(1) unsigned 0 NO Bool: 0-no; 1-yes
wk_remark varchar(255) NO Remarks
store_id int(8) unsigned 0 NO Mall No
wk_sort tinyint(4) 50 NO sort

shop_wechat_menu Wechat menu

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
wm_id mediumint(8) unsigned NO Menu number
wm_parent_id mediumint(8) unsigned 0 NO Superior menu
wm_name varchar(20) NO Menu Name
wm_type_id smallint(4) unsigned 1 NO Action type (enum): 1-link; 2-simulation keyword; 3-scan code; 4-scan code [waiting for information]; 5-system photo sending; 6-photo taking or photo album sending; 7-wechat photo album sending; 8-geographic location
wm_target varchar(255) NO Action operation
wm_enable tinyint(1) unsigned 1 NO Whether to enable (bool): 0-disable; 1-enable
store_id int(8) 0 NO Mall No
wm_sort tinyint(3) unsigned 50 NO sort
wm_is_buildin tinyint(1) unsigned 0 NO Bool: 0-no; 1-yes

shop_wechat_tplmsg Message template table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
tplmsg_id mediumint(8) unsigned NO Template number
tplmsg_title varchar(100) NO Template title
tplmsg_type_id smallint(4) unsigned 1 NO Template type (list): 1-order reminder; 2-payment reminder; 3-delivery reminder
tplmsg_name varchar(100) NO Wechat message template title
tplmsg_number varchar(255) NO Template library No
tplmsg_tpl_id varchar(255) NO Template library No
tplmsg_enable tinyint(1) unsigned 1 NO Whether to enable (bool): 0-disable; 1-enable
tplmsg_is_buildin tinyint(1) unsigned 0 NO Bool: 0-no; 1-yes
tplmsg_remark varchar(255) NO Remarks
tplmsg_sort tinyint(4) 50 NO sort
store_id int(8) unsigned 0 NO Mall No
message_id varchar(100) NO Message template ID: Associate message template

sns_base_filter_keyword Sensitive word filtering - enable API

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
filter_id int(10) unsigned NO Sensitive word number
filter_find varchar(50) NO Find Sensitive Words
filter_replace varchar(50) NO replace content
filter_type tinyint(1) 1 NO Filtering type (enum): 1-prohibited; 2-replace
filter_time timestamp CURRENT_TIMESTAMP NO Add time
filter_buildin tinyint(1) unsigned 0 NO Whether the system is built-in (enum): 0-not built-in; 1-built-in
user_id int(10) unsigned 0 NO User number
filter_enable tinyint(1) unsigned 1 NO Enable (enum): 0 - not enabled; 1 - enabled

sns_story_base Dynamic information table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
story_id int(10) unsigned NO number
user_id int(11) unsigned NO Membership Number
story_index varchar(255) NO Search index: retrieval using
story_title varchar(100) NO Title
story_content text NO Navigation drop-down content (HTML)
story_file varchar(1024) NO Picture (DOT)
story_video varchar(255) NO Video address
story_type tinyint(1) unsigned 1 NO Type (enum): 1-text; 2-picture; 3-music; 4-video; 5-commodity
story_src_id int(10) unsigned 0 NO Transfer source
story_time int(11) unsigned NO Add time
story_status tinyint(1) unsigned 0 NO Status (enum): 0-draft; 1-publish
story_enable tinyint(1) unsigned 1 NO Delete (bool): 0-delete; 1-valid
story_privacy tinyint(1) unsigned 0 NO Privacy visibility (enum): 0-visible to all; 1-visible to friends; 2-visible only to yourself
story_comment_count int(11) unsigned 0 NO Comment ID
story_forward_count int(11) unsigned 0 NO Forwarding number
story_like_count int(11) unsigned 0 NO Praise points
story_collection_count int(11) unsigned 0 NO Number of post collections
story_forward tinyint(1) unsigned 1 NO Can be forwarded (bool): 0-can’t be forwarded; 1-can be forwarded
story_is_top tinyint(1) unsigned 0 NO Bool: 0-normal; 1-top
story_brower_count tinyint(11) 0 NO Access number
item_id varchar(100) NO Return commodity number:%s
story_category_id smallint(4) 0 NO Classification Number
story_tags varchar(255) NO Tags (DOT)
story_source smallint(4) 1001 NO Data source (enum): 1001 - post; 1002 - Product Review; 1003 - Product Q & A
product_id bigint(20) 0 NO Commodity ID

sns_story_category Block

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
story_category_id smallint(4) NO Block number
story_category_name varchar(50) NO Name of Forum
story_category_parent_id int(6) 0 NO Parent class
story_category_logo varchar(255) NO Page icon
story_category_bg varchar(255) NO Background of layout
story_category_keywords varchar(100) NO Key words
story_category_desc varchar(255) NO Page description
story_category_count smallint(4) NO Number of categorized content
story_category_template varchar(255) NO Template template
story_category_alias varchar(50) NO Block alias
story_category_order tinyint(255) unsigned 50 NO Page sorting
story_category_buildin tinyint(1) 0 NO Enum: 0 - not built in; 1 - built in;

sns_story_collection Collection table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
collection_id int(11) NO number
story_id int(11) NO Dynamic information number
user_id int(11) NO Membership Number
collection_time int(11) NO Collection time

sns_story_comment Comment form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
comment_id int(11) NO Comment number
user_id int(11) NO Membership Number
story_id int(11) NO Original post number
comment_content varchar(255) NO Comment content
comment_state tinyint(1) 0 NO Status (bool): 0-normal; 1-shielded
to_user_id int(11) NO Reply user number
comment_like_count int(10) 0 NO Number of points
comment_time timestamp CURRENT_TIMESTAMP NO Add time
comment_is_show tinyint(1) 0 NO Show or not: 0-hidden; 1-show

sns_story_comment_helpful Evaluate useful voting forms

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
comment_helpful_id bigint(20) NO number
comment_id int(20) unsigned NO Comment number
user_id int(10) unsigned 0 NO Click on user number
story_id int(11) NO Article number
comment_helpful_time int(11) NO Evaluation time

sns_story_comment_reply Q & a response form

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
comment_reply_id int(11) unsigned NO Comment reply No
comment_id int(11) 0 NO Comment number
comment_reply_parent_id int(11) 0 NO Reply parent number
story_id int(11) unsigned NO Article No
user_id int(10) unsigned 0 NO Comment reply No
user_nickname varchar(50) NO Comment reply name
user_id_to int(10) NO Comment reply user number
comment_reply_content varchar(255) NO Comment on the content of the reply
comment_reply_time int(11) NO Comment reply time
comment_reply_show_flag tinyint(1) 1 NO Does the Q & a show
comment_reply_islook tinyint(1) unsigned 0 NO Bool: 1-read; 2-unread
comment_reply_helpful_num int(11) unsigned 0 NO Number of helpers

sns_story_comment_reply_helpful Evaluate useful voting forms

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
comment_reply_helpful_id bigint(20) NO number
comment_reply_id bigint(11) unsigned NO Comment number
user_id bigint(10) unsigned 0 NO Click on user number
story_id int(11) NO Article number
comment_reply_helpful_time int(11) NO Evaluation time

sns_story_forward Relay table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
forward_id int(11) NO number
user_id int(11) NO Forwarded post No
story_new_id int(11) NO New post number after forwarding
story_id int(11) NO Original post number
forward_time int(11) NO Add time

sns_story_like Likes list

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
like_id int(11) NO number
story_id int(11) NO Dynamic information number
user_id int(11) NO Membership Number
like_time int(11) NO Collection time

sns_story_timeline User message timeline table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
timeline_id bigint(20) NO number
user_id int(11) unsigned NO User number
story_id int(10) unsigned 0 NO Story or product comment
timeline_time int(11) 0 NO Activity time
timeline_type tinyint(1) unsigned 1 NO Type: 1-Story; 2-product review

sns_user_block User blacklist

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_black_id int(11) unsigned NO Blacklist No
user_id int(10) unsigned NO User number
black_id int(11) unsigned 0 NO Blackout user number
user_black_time timestamp CURRENT_TIMESTAMP NO Blackout time

sns_user_friend User friend relationship table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_friend_id int(11) unsigned NO -
user_id int(10) unsigned NO User number
friend_id int(11) unsigned 0 NO Friend number
friend_note varchar(50) NO Note name
user_friend_addtime timestamp CURRENT_TIMESTAMP NO Add time
friend_state tinyint(1) 1 NO Attention status (enum): 1-one-way attention; 2-two-way attention
friend_invite tinyint(1) unsigned 0 NO Invitation status (enum): 0-new invitation; 2-invitation after processing

sns_user_group Friends Management Group

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
group_id int(10) NO Friend group number
group_name varchar(30) NO Group name
group_type tinyint(1) 0 NO Group type (enum): 0 - upper limit of 100 people in temporary group; 1 - upper limit of 300 people in general group; 2 - upper limit of 500 people in VIP group
user_id int(10) unsigned NO Administrator
group_num int(10) unsigned 0 NO Number

sns_user_group_rel Friend group relationship

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
group_rel_id int(10) NO Friend group number
group_id int(10) 0 NO Group name
user_id int(10) unsigned 0 NO User ID error

sns_user_message SMS Chat

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
message_id int(11) unsigned NO SMS index number
message_parent_id int(11) unsigned 0 NO Reply to the message “Id”
user_id int(10) unsigned 1 NO Message user: sender or receiver, if message_ If kind = 1, the message sent by the user will be changed.
user_nickname varchar(50) NO Name of receiver
user_other_id int(10) unsigned 0 NO Short cancellation related users: sender or receiver
user_other_nickname varchar(50) NO Short cancellation related users: sender or receiver
message_title varchar(50) NO Message title
message_content varchar(1024) NO Short message content
message_time int(11) unsigned 0 NO Sending time of SMS
message_is_read tinyint(1) unsigned 0 NO Whether to read (bool): 0-unread; 1-read
message_is_delete tinyint(1) unsigned 0 NO Short message status (bool): 0-normal status; 1-deletion status
message_type tinyint(1) 2 NO Message type (enum): 1-system message; 2-user message; 3-private message
message_kind tinyint(1) unsigned 1 NO Message type (enum): 1-send message; 2-receive message
message_cat varchar(10) text NO Message type (enum): text message; img picture message; video video message; file: file; location: Location
message_data_type tinyint(1) 1 NO Message classification: 1-announcement message; 2-order message
message_data_id varchar(50) NO Message data
message_length varchar(10) 0 NO Message length
message_w int(10) 0 NO image width
message_h int(10) 0 NO Picture height
item_id int(10) 0 NO Commodity ID

sns_user_message_analytics SMS Chat statistics

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
user_message_analytics_id int(11) unsigned NO SMS index number
user_id int(10) unsigned 1 NO Message user: sender or receiver, if message_ If kind = 1, the message sent by the user will be changed.
user_other_id int(10) unsigned 0 NO Short cancellation related users: sender or receiver
message_content varchar(255) NO Short message content
message_time timestamp CURRENT_TIMESTAMP NO Sending time of SMS
message_new_num tinyint(1) unsigned 0 NO Number of new messages

sns_user_zone group

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
zone_id int(10) NO Friend group number
zone_name varchar(30) NO group name
zone_type tinyint(1) 0 NO Group type (enum): 0 - upper limit of 100 people in temporary group; 1 - upper limit of 300 people in general group; 2 - upper limit of 500 people in VIP group
zone_permission tinyint(4) 0 NO Application joining mode (enum): 0-default direct joining; 1-authentication required; 2-private group
zone_declared varchar(50) NO Group announcement
user_id int(10) unsigned 0 NO Administrator
zone_bind_id varchar(32) NO Third party group number
zone_user_num int(10) unsigned 2 NO Number of people

sns_user_zone_message Group messages - chat

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
zone_message_id int(11) unsigned NO SMS index number
user_id int(10) unsigned 1 NO Send user
zone_id int(10) unsigned 0 NO Group number
zone_message_content varchar(255) NO Short message content
zone_message_time timestamp CURRENT_TIMESTAMP NO Sending time of SMS
zone_message_is_delete tinyint(1) unsigned 0 NO Short message status (bool): 0-normal status; 1-deletion status
zone_message_type tinyint(1) 2 NO Message type (enum): 1-system message; 2-user message; 3-private message

sns_user_zone_rel Group user relationship table

Column Name Column Type Column Default Is Nullable Auto Increment Column Comment
zone_rel_id int(11) unsigned NO Relationship number
zone_id int(10) NO Group number
user_id int(10) unsigned NO User ID error
zone_rel_permission tinyint(3) unsigned 0 NO Application mode (enum): 0-join; 1-to be verified;
文档更新时间: 2020-06-02 09:43   作者:随商信息技术(上海)有限公司