热门搜索: 物流跟踪 自定义URL oauth2.0 银联
当前位置: 我的shopex插件站 > 教程 > shopex >
详细内容

Ecstore B2B2C 数据库词典

时间:2015-12-01 10:12 来源:MyShopEx插件站 作者:本站原创 点击:

数据库表数量: 130个

  • APP:base
    • base_app_content(app资源信息表, 记录app的service信息)
    • base_apps(系统应用表)
    • base_crontab(定时任务表)
    • base_kvstore(kvstore存储表)
    • base_network(网络互联表)
    • base_rpcpoll(ec-rpc连接池表)
    • base_setting(setting存储表)
    • base_syscache_resources(kvstore存储表)
  • APP:desktop
    • desktop_account(用户权限账户表)
    • desktop_filter(后台搜索过滤器表)
    • desktop_hasrole(后台权限, 角色和用户关联表)
    • desktop_menus(后台菜单表)
    • desktop_roles(管理员角色表)
    • desktop_tag(finder tag(标签)表)
    • desktop_tag_rel(tag和对象关联表)
    • desktop_users(商店后台管理员表)
  • APP:ectools
    • ectools_analysis(ectools app统计表)
    • ectools_analysis_logs(ectools统计日志)
    • ectools_payments(支付记录)
    • ectools_refunds(退款单表)
    • ectools_trade_paybill(订单支付单据记录)
  • APP:image
    • image_images(图片表)
  • APP:importexport
    • importexport_task(导出、导入任务表)
  • APP:search
    • search_associate()
    • search_delta()
  • APP:serveradm
    • serveradm_xhprof(xphrof)
  • APP:site
    • site_explorers(site地图表)
    • site_link(前台链接表)
    • site_menus(导航菜单表)
    • site_seo(前台SEO配置表)
    • site_themes(模板表)
    • site_themes_file(模板文件表)
    • site_themes_tmpl(页面模板表)
    • site_widgets(挂件表)
    • site_widgets_instance(挂件实例表)
  • APP:sysaftersales
    • sysaftersales_aftersales(售后申请)
    • sysaftersales_refunds(退款申请表)
  • APP:syscategory
    • syscategory_brand(品牌表)
    • syscategory_cat(类别属性值有限表)
    • syscategory_cat_rel_brand(分类和品牌关联表)
    • syscategory_cat_rel_prop(商品属性表)
    • syscategory_prop_values(属性值表)
    • syscategory_props(属性表)
  • APP:sysclearing
    • sysclearing_settlement(商家账号信息)
    • sysclearing_settlement_detail(结算明细表)
  • APP:syscontent
    • syscontent_article(文章主表)
    • syscontent_article_nodes(文章节点表)
  • APP:sysdecorate
    • sysdecorate_widgets_instance(挂件实例表)
  • APP:sysitem
    • sysitem_item(商品表)
    • sysitem_item_count(商品次数表)
    • sysitem_item_desc(商品详情表)
    • sysitem_item_nature_props(商品自然属性信息表)
    • sysitem_item_promotion(商品关联的促销表(新))
    • sysitem_item_status(商品上下架状态表)
    • sysitem_item_store(商品总库存表)
    • sysitem_sku(货品表)
    • sysitem_sku_store(商品库存表)
    • sysitem_spec_index(商品规格索引表)
  • APP:syslogistics
    • syslogistics_coupon(优惠券表)
    • syslogistics_delivery(发货单表)
    • syslogistics_delivery_detail(发货/退货单明细表)
    • syslogistics_dlycorp(物流公司表)
    • syslogistics_dlytmpl(快递模板配置表)
    • syslogistics_ziti(自提点表)
  • APP:sysopen
    • sysopen_keys(店铺请求开放api的key和secret)
    • sysopen_shopconf(店铺请求开放api的key和secret)
  • APP:syspromotion
    • syspromotion_activity(活动规则表)
    • syspromotion_activity_item(活动商品表)
    • syspromotion_activity_register(活动报名表)
    • syspromotion_coupon(优惠券表)
    • syspromotion_coupon_item(商品与促销规则关联表)
    • syspromotion_freepostage(免邮表)
    • syspromotion_freepostage_item(商品与促销规则关联表)
    • syspromotion_fulldiscount(满折促销规则表)
    • syspromotion_fulldiscount_item(商品与促销规则关联表)
    • syspromotion_fullminus(满减促销规则表)
    • syspromotion_fullminus_item(商品与促销规则关联表)
    • syspromotion_promotions(各种促销关联表)
    • syspromotion_xydiscount(X件Y折促销规则表)
    • syspromotion_xydiscount_item(商品与促销规则关联表)
  • APP:sysrate
    • sysrate_appeal(评论申诉表)
    • sysrate_consultation(商品咨询表)
    • sysrate_dsr(店铺动态评分统计表)
    • sysrate_feedback(意见反馈表)
    • sysrate_score(店铺评分表)
    • sysrate_traderate(商品评分表)
  • APP:sysshop
    • sysshop_account(商家会员表)
    • sysshop_enterapply(入驻申请表)
    • sysshop_roles(角色表)
    • sysshop_seller(商家账号信息)
    • sysshop_shop(店铺表)
    • sysshop_shop_cat(店铺分类表)
    • sysshop_shop_info(企业信息表)
    • sysshop_shop_notice(商家通知表)
    • sysshop_shop_rel_brand()
    • sysshop_shop_rel_lv1cat(店铺关联类目表)
    • sysshop_shop_rel_seller()
    • sysshop_shop_type(店铺类型表)
  • APP:sysstat
    • sysstat_item_statics(商品统计表)
    • sysstat_statmember(会员统计表)
    • sysstat_trade_statics(交易统计表)
  • APP:system
    • system_adminlog(平台人员操作日志表)
    • system_matrixset()
    • system_messenger_systmpl(邮件短信模板)
    • system_prism_initstep()
    • system_queue_mysql(队列-mysql实现表)
    • system_seller_log(店铺人员操作日志表)
  • APP:systrade
    • systrade_activity_detail(订单使用的活动信息表)
    • systrade_cart(购物车)
    • systrade_cart_coupon(购物车使用优惠券表)
    • systrade_log(订单日志表)
    • systrade_order(订单子表)
    • systrade_order_complaints(订单投诉表)
    • systrade_promotion_detail(订单使用的促销信息表)
    • systrade_trade(订单主表)
    • systrade_tradeabnormal(取消异常订单表)
  • APP:sysuser
    • sysuser_account(商城会员用户表)
    • sysuser_shop_fav(收藏店铺表)
    • sysuser_trustinfo()
    • sysuser_user(商店会员表)
    • sysuser_user_addrs(会员地址表)
    • sysuser_user_coupon(用户优惠券表)
    • sysuser_user_experience(会员经验值详细记录表)
    • sysuser_user_fav(收藏/缺货登记)
    • sysuser_user_grade(会员等级表)
    • sysuser_user_item_notify(缺货表)
    • sysuser_user_point(会员积分值详细记录表)
    • sysuser_user_pointlog(会员积分值明细表)
    • sysuser_user_points(会员积分表)
    • sysuser_user_trade_count()

app:base tables

base_app_content

app资源信息表, 记录app的service信息

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
content_id序号INT UNSIGNED AUTO_INCREMENTYes
Yes
content_typeservice类型(service_category和service)VARCHAR(80)Yes
No
app_id应用的app_idVARCHAR(32)Yes
No
content_nameservice category name - service idVARCHAR(80)No
No
content_titleoptnameVARCHAR(100)No
No
content_pathclass name只有type为service才有VARCHAR(255)No
No
ordernum
SMALLINTNo50No
input_time
INT UNSIGNEDNo
No
disabled是否有效TINYINT(1)No0No
  • 索引
Key nameColumn namesUniqueComment
primarycontent_idYes
ind_content_typecontent_typeNo

base_apps

系统应用表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
app_id
VARCHAR(32)Yes
No
app_name
VARCHAR(50)No
No
debug_mode
TINYINT(1)No0No
app_config
LONGTEXTNo
No
statusinstalled:已安装, 未启动;resolved:已配置;starting:正在启动;active:运行中;stopping:正在关闭;uninstalled:尚未安装;installing:正在安装;broken:已损坏;paused:已暂停;VARCHAR(11)NouninstalledNo
webpath远程地址VARCHAR(20)No
No
description
VARCHAR(255)No
No
local_ver
VARCHAR(20)No
No
remote_ver
VARCHAR(20)No
No
author_name作者名VARCHAR(100)No
No
author_url作者urlVARCHAR(100)No
No
author_email作者邮件VARCHAR(100)No
No
dbver目前安装版本VARCHAR(32)No
No
remote_config远程配置信息LONGTEXTNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryapp_idYes

base_crontab

定时任务表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
id
VARCHAR(100)Yes
No
description
VARCHAR(255)Yes
No
enabled
TINYINT(1)Yes1No
schedule
VARCHAR(255)Yes
No
last
INT UNSIGNEDYes
No
app_id
VARCHAR(32)Yes
No
class
VARCHAR(100)Yes
No
typecustom:客户自定义;system:系统内置;VARCHAR(6)No
No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes

base_kvstore

kvstore存储表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
id序号INT UNSIGNED AUTO_INCREMENTYes
Yes
prefixkvstore类型VARCHAR(255)Yes
No
keykvstore存储的键值VARCHAR(255)Yes
No
valuekvstore存储值LONGTEXTNo
No
dateline存储修改时间INT UNSIGNEDNo
No
ttl过期时间,0代表不过期INT UNSIGNEDNo0No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes
ind_prefixprefixNo
ind_keykeyNo

base_network

网络互联表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
node_id序号INT UNSIGNED AUTO_INCREMENTYes
Yes
node_name
VARCHAR(255)Yes
No
node_url
VARCHAR(100)Yes
No
node_api
VARCHAR(100)Yes
No
link_statusactive:正常;group:维护;wait:等待对方确认...;VARCHAR(6)YeswaitNo
node_detail
VARCHAR(255)No
No
token
VARCHAR(32)No
No
  • 索引
Key nameColumn namesUniqueComment
primarynode_idYes

base_rpcpoll

ec-rpc连接池表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
id
VARCHAR(32)No
No
process_id
VARCHAR(32)No
No
typerequest:发出请求;response:接收的请求;VARCHAR(8)No
No
calltime
INT UNSIGNEDNo
No
network
INT UNSIGNEDNo
No
method
VARCHAR(100)No
No
params请求和响应的参数(序列化)LONGTEXTNo
No
callback
VARCHAR(200)No
No
callback_params
LONGTEXTNo
No
result
LONGTEXTNo
No
fail_times
VARCHAR(10)Yes1No
statussucc:成功;failed:失败;VARCHAR(6)YesfailedNo
  • 索引
Key nameColumn namesUniqueComment
ind_rpc_task_idid, type, process_idYes
ind_rpc_response_idprocess_idNo

base_setting

setting存储表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
appapp名VARCHAR(50)Yes
No
keysetting键值VARCHAR(255)Yes
No
valuesetting存储值LONGTEXTNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryapp, keyYes

base_syscache_resources

kvstore存储表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
id序号INT UNSIGNED AUTO_INCREMENTYes
Yes
typekvstore类型VARCHAR(255)Yes
No
keykvstore存储的键值VARCHAR(255)Yes
No
valuekvstore存储值LONGTEXTNo
No
dateline存储修改时间INT UNSIGNEDNo
No
ttl过期时间,0代表不过期INT UNSIGNEDNo0No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes
ind_prefixtypeNo
ind_keykeyNo

app:desktop tables

desktop_account

用户权限账户表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
account_id账户序号IDINT UNSIGNED AUTO_INCREMENTYes
Yes
account_type账户类型(会员和管理员等)VARCHAR(30)No
No
login_name登录用户名VARCHAR(100)Yes
No
login_password登录密码VARCHAR(60)Yes
No
disabled
TINYINT(1)No0No
createtime创建时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryaccount_idYes
ind_accountlogin_name, disabledYes

desktop_filter

后台搜索过滤器表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
filter_idfinder过滤器IDINT UNSIGNED AUTO_INCREMENTYes
Yes
filter_name过滤条件名称VARCHAR(20)No
No
user_id过滤器所属后台用户IDINT UNSIGNEDYes
No
model过滤器对应的model(表名)VARCHAR(100)Yes
No
filter_query过滤器对应的过滤条件LONGTEXTNo
No
ctl过滤器对应的controller(控制器)VARCHAR(100)Yes
No
app过滤器对应的app(应用)VARCHAR(50)Yes
No
act过滤器对应的act(方法)VARCHAR(50)Yes
No
create_time过滤器创建时间INT UNSIGNEDYes0No
  • 索引
Key nameColumn namesUniqueComment
primaryfilter_idYes

desktop_hasrole

后台权限, 角色和用户关联表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
user_id后台用户IDINT UNSIGNEDYes
No
role_id角色IDINT UNSIGNEDYes
No
  • 索引
Key nameColumn namesUniqueComment
primaryuser_id, role_idYes

desktop_menus

后台菜单表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
menu_id后台菜单IDINT UNSIGNED AUTO_INCREMENTYes
Yes
menu_type菜单类型VARCHAR(80)Yes
No
app_id所属app(应用)IDVARCHAR(32)Yes
No
workground顶级菜单VARCHAR(200)No
No
menu_group菜单组VARCHAR(200)No
No
menu_title菜单标题VARCHAR(100)No
No
menu_path菜单对应执行的url路径VARCHAR(255)No
No
disabled
TINYINT(1)No0No
display是否显示TINYINT(1)No0No
permission权限,有效显示范围VARCHAR(80)No
No
addon额外信息LONGTEXTNo
No
target跳转VARCHAR(10)No
No
menu_order排序INT UNSIGNEDNo0No
parent父节点VARCHAR(255)No0No
  • 索引
Key nameColumn namesUniqueComment
primarymenu_idYes
ind_menu_typemenu_typeNo
ind_menu_pathmenu_pathNo
ind_menu_ordermenu_orderNo

desktop_roles

管理员角色表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
role_id管理员角色IDINT UNSIGNED AUTO_INCREMENTYes
Yes
role_name
VARCHAR(100)Yes
No
workground
LONGTEXTNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryrole_idYes

desktop_tag

finder tag(标签)表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
tag_idtag IDINT UNSIGNED AUTO_INCREMENTYes
Yes
tag_name
VARCHAR(20)Yes
No
tag_modenormal:普通标签;filter:自动标签;VARCHAR(6)YesnormalNo
app_idapp(应用)IDVARCHAR(32)Yes
No
tag_type
VARCHAR(20)Yes
No
tag_abbr
VARCHAR(150)Yes
No
tag_bgcolor
VARCHAR(7)Yes
No
tag_fgcolor
VARCHAR(7)Yes
No
tag_filter
VARCHAR(255)Yes
No
rel_count关联的个数INT UNSIGNEDYes0No
params
LONGTEXTNo
No
  • 索引
Key nameColumn namesUniqueComment
primarytag_idYes
ind_typetag_typeNo
ind_nametag_nameNo

desktop_tag_rel

tag和对象关联表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
tag_idtag IDINT UNSIGNEDYes0No
rel_id对象IDVARCHAR(32)Yes0No
app_idapp(应用)IDVARCHAR(32)Yes
No
tag_type标签对应的model(表)VARCHAR(20)Yes
No
last_modify
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primarytag_id, rel_idYes

desktop_users

商店后台管理员表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
user_id后台用户IDINT UNSIGNEDYes
No
status
TINYINT(1)Yes0No
name
VARCHAR(30)No
No
lastlogin
INT UNSIGNEDYes0No
config配置信息LONGTEXTNo
No
favorite爱好LONGTEXTNo
No
super
TINYINT(1)Yes0No
lastip上次登录ipVARCHAR(20)No
No
logincount
INT UNSIGNEDYes0No
disabled
TINYINT(1)Yes0No
op_no操作员noVARCHAR(50)No
No
memo
LONGTEXTNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryuser_idYes
ind_disableddisabledNo

app:ectools tables

ectools_analysis

ectools app统计表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
idectools统计IDINT UNSIGNED AUTO_INCREMENTYes
Yes
service对应的serviceVARCHAR(80)Yes
No
intervalhour:hour;day:day;comment:执行监控间隔时间;VARCHAR(7)Yes
No
modify最后修改时间INT UNSIGNEDYes0No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes

ectools_analysis_logs

ectools统计日志

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
idectools统计日志IDINT UNSIGNED AUTO_INCREMENTYes
Yes
analysis_idectools统计IDINT UNSIGNEDYes
No
type
INT UNSIGNEDYes0No
target
INT UNSIGNEDYes0No
flag
INT UNSIGNEDYes0No
value
DOUBLE PRECISIONYes0No
time
INT UNSIGNEDYes
No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes
ind_analysis_idanalysis_idNo
ind_typetypeNo
ind_targettargetNo
ind_timetimeNo

ectools_payments

支付记录

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
payment_id支付单号VARCHAR(20)Yes
No
money需要支付的金额NUMERIC(20, 3)Yes0No
cur_money支付货币金额NUMERIC(20, 3)Yes0No
status支付状态|succ:支付成功;failed:支付失败;cancel:未支付;error:处理异常;invalid:非法参数;progress:已付款至担保方;timeout:超时;ready:准备中;paying:支付中;VARCHAR(8)YesreadyNo
user_id会员INT UNSIGNEDNo
No
user_name会员用户名VARCHAR(100)No
No
pay_type支付类型|online:在线支付;offline:货到付款;VARCHAR(7)YesonlineNo
pay_app_id支付方式名称VARCHAR(100)No
No
pay_name支付方式名VARCHAR(100)No
No
payed_time支付完成时间INT UNSIGNEDNo
No
op_id操作员INT UNSIGNEDNo
No
op_name操作员VARCHAR(100)No
No
account收款账号VARCHAR(50)No
No
bank收款银行VARCHAR(50)No
No
pay_account支付账户VARCHAR(50)No
No
currency货币VARCHAR(10)No
No
paycost支付网关费用NUMERIC(20, 3)No
No
pay_ver支付版本号VARCHAR(50)No
No
ip支付IPVARCHAR(20)No
No
created_time支付单创建时间INT UNSIGNEDNo
No
modified_time最后更新时间INT UNSIGNEDNo
No
memo支付注释LONGTEXTNo
No
return_url支付返回地址VARCHAR(100)No
No
disabled支付单状态TINYINT(1)No0No
trade_no支付单交易编号VARCHAR(30)No
No
thirdparty_account第三方支付账户VARCHAR(50)No
No
tids订单id集, 已废弃LONGTEXTNo
No
trade_own_money订单自有的金额,已废弃LONGTEXTNo
No
  • 索引
Key nameColumn namesUniqueComment
primarypayment_idYes
ind_disableddisabledNo

ectools_refunds

退款单表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
refund_id
VARCHAR(20)Yes
No
money
NUMERIC(20, 3)Yes0No
cur_money
NUMERIC(20, 3)Yes0No
refund_bank
VARCHAR(50)No
No
refund_account
VARCHAR(50)No
No
refund_people
VARCHAR(100)No
No
receive_bank
VARCHAR(50)No
No
receive_account
VARCHAR(50)No
No
beneficiary
VARCHAR(50)No
No
currency
VARCHAR(10)NoCNYNo
paycost
NUMERIC(20, 3)No
No
pay_typeonline:在线支付;offline:货到付款;VARCHAR(7)YesofflineNo
statussucc:支付成功;failed:支付失败;cancel:未支付;error:处理异常;invalid:非法参数;progress:处理中;timeout:超时;ready:准备中;VARCHAR(8)YesreadyNo
pay_ver
VARCHAR(50)No
No
op_id
INT UNSIGNEDNo
No
aftersales_bn
VARCHAR(32)No
No
pay_app_id
VARCHAR(100)Yes0No
created_time
INT UNSIGNEDNo
No
finish_time
INT UNSIGNEDNo
No
confirm_time
INT UNSIGNEDNo
No
memo备注LONGTEXTNo
No
oid交易子订单号VARCHAR(30)No
No
tid交易主订单号VARCHAR(30)No
No
  • 索引
Key nameColumn namesUniqueComment
primaryrefund_idYes

ectools_trade_paybill

订单支付单据记录

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
paybill_id子支付单编号INT UNSIGNED AUTO_INCREMENTYes
Yes
payment_id主支付单编号VARCHAR(20)Yes
No
tid被支付订单编号VARCHAR(20)Yes
No
status该订单支付的状态|succ:支付成功;failed:支付失败;cancel:未支付;error:处理异常;invalid:非法参数;progress:已付款至担保方;timeout:超时;ready:准备中;paying:支付中;VARCHAR(8)YesreadyNo
payment该订单支付的金额VARCHAR(20)Yes
No
user_id会员idVARCHAR(100)No
No
created_time支付单创建时间INT UNSIGNEDNo
No
payed_time支付完成时间INT UNSIGNEDNo
No
modified_time最后更新时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primarypaybill_idYes

app:image tables

image_images

图片表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
idIDINT UNSIGNED AUTO_INCREMENTYes
Yes
storage
VARCHAR(50)YesfilesystemNo
image_name
VARCHAR(200)No
No
target_id关联IDBIGINT UNSIGNEDYes0No
target_type用户类型VARCHAR(20)Yes
No
img_type图片类型,根据图片类型生成不同大小的图片VARCHAR(255)Yes
No
url
VARCHAR(255)Yes
No
ident唯一标识VARCHAR(200)No
No
width
INT UNSIGNEDNo
No
height
INT UNSIGNEDNo
No
size文件大小INT UNSIGNEDNo
No
last_modified
INT UNSIGNEDYes0No
disableddisabledTINYINT(1)Yes0No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes
ind_targettarget_id, target_typeNo
ind_urlurlYes
ind_uniqueurl, target_id, target_typeYes

app:importexport tables

importexport_task

导出、导入任务表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
task_id
INT UNSIGNED AUTO_INCREMENTYes
Yes
name
VARCHAR(255)Yes
No
message
VARCHAR(255)No
No
filetype
VARCHAR(20)No
No
create_date
INT UNSIGNEDNo
No
complete_date
INT UNSIGNEDNo
No
typeexport:导出;import:导入;VARCHAR(6)No
No
status0:等待执行;1:正在导出;2:导出成功;3:导出失败;4:正在导入;5:导入成功;6:导入失败;7:中断;8:部分导入;VARCHAR(1)No0No
is_display0:隐藏;1:显示;VARCHAR(1)No0No
key
VARCHAR(255)No
No
  • 索引
Key nameColumn namesUniqueComment
primarytask_idYes

app:search tables

search_associate


  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
id
INT UNSIGNED AUTO_INCREMENTYes
Yes
words
VARCHAR(50)Yes
No
type_id
INT UNSIGNEDNo
No
from_type
VARCHAR(50)No
No
last_modify
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes
ind_last_modifylast_modifyNo

search_delta


  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
id
INT UNSIGNEDYes
No
index_name
VARCHAR(50)Yes
No
last_modify
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryid, index_nameYes
ind_last_modifylast_modifyNo

app:serveradm tables

serveradm_xhprof

xphrof

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
run_idrun_idVARCHAR(100)Yes
No
sourcesourceVARCHAR(50)No
No
appappVARCHAR(30)No
No
ctlcontrollerVARCHAR(100)No
No
actactionVARCHAR(50)No
No
request_urirequest_uriVARCHAR(255)No
No
params
LONGTEXTNo
No
addtime
INT UNSIGNEDNo
No
wt
VARCHAR(80)No
No
mu
INT UNSIGNEDNo
No
pmu
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryrun_idYes

app:site tables

site_explorers

site地图表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
idsite地图表IDINT UNSIGNED AUTO_INCREMENTYes
Yes
app应用(app)名VARCHAR(50)Yes
No
title
VARCHAR(100)Yes
No
path路径VARCHAR(100)Yes
No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes

site_link

前台链接表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
link_id链接IDINT UNSIGNED AUTO_INCREMENTYes
Yes
link_name
VARCHAR(128)Yes
No
href
VARCHAR(255)Yes
No
image_url
VARCHAR(255)No
No
orderlist
INT UNSIGNEDYes0No
hidden
TINYINT(1)Yes0No
  • 索引
Key nameColumn namesUniqueComment
primarylink_idYes

site_menus

导航菜单表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
id导航菜单表INT UNSIGNED AUTO_INCREMENTYes
Yes
title
VARCHAR(100)Yes
No
app
VARCHAR(50)No
No
ctl
VARCHAR(50)No
No
act
VARCHAR(50)No
No
custom_url
VARCHAR(200)No
No
display_order
SMALLINTYes0No
target_blank
TINYINT(1)Yes0No
hidden
TINYINT(1)Yes0No
params
LONGTEXTNo
No
config
LONGTEXTNo
No
update_modified更新时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes

site_seo

前台SEO配置表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
idIDINT UNSIGNED AUTO_INCREMENTYes
Yes
app应用(app)VARCHAR(50)Yes
No
route路由别名,唯一标示VARCHAR(50)Yes
No
title
VARCHAR(50)Yes
No
config
LONGTEXTNo
No
param
LONGTEXTNo
No
update_modified更新时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes

site_themes

模板表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
theme主题唯一英文名称VARCHAR(50)Yes
No
name主题名称VARCHAR(50)No
No
platform模板终端|pc:电脑端;wap:无线端;VARCHAR(3)YespcNo
stime开始使用时间INT UNSIGNEDNo
No
author
VARCHAR(50)No
No
site
VARCHAR(100)No
No
version
VARCHAR(50)No
No
info详细说明VARCHAR(255)No
No
config配置信息LONGTEXTNo
No
is_used是否启用TINYINT(1)No0No
  • 索引
Key nameColumn namesUniqueComment
primarythemeYes

site_themes_file

模板文件表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
id模板文件IDINT UNSIGNED AUTO_INCREMENTYes
Yes
platform模板终端|pc:电脑端;wap:无线端;VARCHAR(3)YespcNo
filename文件名VARCHAR(255)No
No
filetype文件扩展名VARCHAR(30)No
No
fileuri文件路径标识,包括模板名. [theme name]:[filename]VARCHAR(255)No
No
version版本号INT UNSIGNEDNo
No
theme模板名标识VARCHAR(50)No
No
memo备注VARCHAR(100)No
No
content文件内容LONGTEXTNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes

site_themes_tmpl

页面模板表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
id页面模板IDINT UNSIGNED AUTO_INCREMENTYes
Yes
platform模板终端|pc:电脑端;wap:无线端;VARCHAR(3)YespcNo
tmpl_type对应前台页面标示符VARCHAR(20)Yes
No
tmpl_name名称VARCHAR(30)Yes
No
tmpl_path页面路径VARCHAR(100)Yes
No
theme对应模板VARCHAR(20)Yes
No
rel_file_id关联模板文件表:site_themes_fileINT UNSIGNEDYes
No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes

site_widgets

挂件表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
id挂件IDINT UNSIGNED AUTO_INCREMENTYes
Yes
app如果是系统挂件, 此字段为应用名. 如果是模板挂件此字段为空VARCHAR(30)Yes
No
theme如果是模板级挂件, 此字段为模板名. 如果是系统挂件此字段为空VARCHAR(30)Yes
No
name挂件名VARCHAR(30)Yes
No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes
ind_uniqapp, theme, nameNo

site_widgets_instance

挂件实例表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
widgets_id挂件实例IDINT UNSIGNED AUTO_INCREMENTYes
Yes
core_file挂件挂在模版的页面VARCHAR(50)Yes
No
core_slot模版中提供给挂件位置序号SMALLINT UNSIGNEDYes0No
core_id位置的IDVARCHAR(20)No
No
widgets_type所属挂件的名称VARCHAR(30)Yes
No
app所属的应用VARCHAR(30)No
No
theme模版的名称VARCHAR(30)No
No
widgets_order挂件顺序SMALLINT UNSIGNEDYes5No
title挂件自定义标题VARCHAR(100)No
No
domid挂件idVARCHAR(100)No
No
classnamecss class nameVARCHAR(100)No
No
tpl模版的名称VARCHAR(100)No
No
params配置参数LONGTEXTNo
No
modified修改时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primarywidgets_idYes
ind_wgbasecore_file, core_id, widgets_orderNo
ind_wginfocore_file, core_slot, widgets_orderNo

app:sysaftersales tables

sysaftersales_aftersales

售后申请

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
aftersales_bn
BIGINT UNSIGNEDYes
No
user_id
INT UNSIGNEDYes
No
shop_id店铺IDINT UNSIGNEDNo
No
aftersales_typeONLY_REFUND:仅退款;REFUND_GOODS:退货退款;EXCHANGING_GOODS:换货;VARCHAR(16)YesONLY_REFUNDNo
progress0:等待商家处理;1:商家接受申请,等待消费者回寄;2:消费者回寄,等待商家收货确认;3:商家已驳回;4:商家已处理;5:商家确认收货,同意退款,提交到平台,等待平台处理;6:平台驳回退款申请;7:平台已处理退款申请;VARCHAR(1)Yes0No
status0:待处理;1:处理中;2:已处理;3:已驳回;VARCHAR(1)Yes0No
tid
BIGINT UNSIGNEDYes
No
oid
BIGINTYes
No
title
VARCHAR(60)Yes
No
num
INT UNSIGNEDNo
No
reason
VARCHAR(255)No
No
description申请描述VARCHAR(255)No
No
evidence_pic图片凭证信息VARCHAR(5120)No
No
shop_explanation商家处理申请说明VARCHAR(255)No
No
admin_explanation平台处理申请说明VARCHAR(255)No
No
sendback_data消费者提交退货物流信息LONGTEXTNo
No
sendconfirm_data商家重新发货物流信息LONGTEXTNo
No
created_time
INT UNSIGNEDNo
No
modified_time
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryaftersales_bnYes
ind_user_iduser_idNo
ind_shop_idshop_idNo
ind_aftersales_typeaftersales_typeNo
ind_progressprogressNo
ind_statusstatusNo
ind_tidtidNo

sysaftersales_refunds

退款申请表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
refunds_id退款申请IDINT UNSIGNED AUTO_INCREMENTYes
Yes
aftersales_bn
BIGINT UNSIGNEDYes
No
refunds_type0:售后申请退款;1:商家取消异常订单退款;VARCHAR(1)Yes0No
status0:待处理;1:已处理;2:已驳回;VARCHAR(1)Yes0No
refunds_reason
VARCHAR(255)No
No
total_price
NUMERIC(20, 3)No0No
created_time
INT UNSIGNEDNo
No
modified_time
INT UNSIGNEDNo
No
user_id会员idINT UNSIGNEDNo
No
shop_id店铺idINT UNSIGNEDNo
No
tid该退款单的主订单号LONGTEXTNo
No
oid该退款单的订单号LONGTEXTNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryrefunds_idYes
ind_user_iduser_idNo
ind_shop_idshop_idNo
ind_refunds_typerefunds_typeNo
ind_statusstatusNo

app:syscategory tables

syscategory_brand

品牌表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
brand_id品牌idINT UNSIGNED AUTO_INCREMENTYes
Yes
brand_name品牌名称VARCHAR(50)Yes
No
brand_alias品牌别名VARCHAR(50)No
No
brand_url品牌网址(保留字段)VARCHAR(255)No
No
order_sort排序INT UNSIGNEDNo0No
brand_desc品牌介绍(保留字段)LONGTEXTNo
No
brand_logo品牌图片标识VARCHAR(255)No
No
modified_time
INT UNSIGNEDNo
No
disabled失效TINYINT(1)No0No
  • 索引
Key nameColumn namesUniqueComment
primarybrand_idYes
ind_disableddisabledNo
ind_ordernumorder_sortNo

syscategory_cat

类别属性值有限表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
cat_id分类IDINT UNSIGNED AUTO_INCREMENTYes
Yes
parent_id分类父级IDINT UNSIGNEDNo
No
cat_name
VARCHAR(100)Yes
No
cat_logo一级分类logoVARCHAR(255)No
No
cat_path分类路径(从根至本结点的路径,逗号分隔,首部有逗号)VARCHAR(100)No,No
level1:一级分类;2:二级分类;3:三级分类;VARCHAR(1)No1No
is_leaf是否叶子结点(true:是;false:否)TINYINT(1)Yes0No
disabled是否屏蔽(true:是;false:否)TINYINT(1)Yes0No
addon附加项LONGTEXTNo
No
child_count子类别数量INT UNSIGNEDYes0No
params参数表结构(序列化) array(参数组名=>array(参数名1=>别名1别名2,参数名2=>别名1别名2))LONGTEXTNo | | No
guarantee_money
NUMERIC(20, 3)No0No
platform_fee
NUMERIC(20, 3)No0No
cat_service_rates
NUMERIC(20, 3)No0No
order_sort
INT UNSIGNEDNo0No
modified_time
INT UNSIGNEDNo
No
cat_template类目对应的模板VARCHAR(50)No
No
  • 索引
Key nameColumn namesUniqueComment
primarycat_idYes
ind_cat_pathcat_pathNo
ind_cat_namecat_nameNo
ind_modified_timemodified_timeNo

syscategory_cat_rel_brand

分类和品牌关联表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
cat_id商品分类IDINT UNSIGNEDYes0No
brand_id品牌IDINT UNSIGNEDYes0No
order_sort排序INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primarycat_id, brand_idYes

syscategory_cat_rel_prop

商品属性表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
prop_id属性IDINT UNSIGNEDYes0No
cat_id分类IDINT UNSIGNEDYes0No
order_sort
INT UNSIGNEDYes0No
  • 索引
Key nameColumn namesUniqueComment
primaryprop_id, cat_idYes

syscategory_prop_values

属性值表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
prop_value_id属性值IDINT UNSIGNED AUTO_INCREMENTYes
Yes
prop_id属性IDINT UNSIGNEDYes0No
prop_value属性值VARCHAR(100)Yes
No
prop_image属性图片VARCHAR(255)No
No
order_sort排序INT UNSIGNEDYes0No
  • 索引
Key nameColumn namesUniqueComment
primaryprop_value_idYes

syscategory_props

属性表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
prop_id属性idINT UNSIGNED AUTO_INCREMENTYes
Yes
prop_name
VARCHAR(50)Yes
No
type
VARCHAR(20)No
No
search
VARCHAR(20)YesselectNo
show是否显示VARCHAR(10)Yes
No
is_def是否系统默认属性TINYINT(1)Yes0No
show_typetext:文字;image:图片;VARCHAR(5)YestextNo
prop_typespec:销售属性;nature:自然属性;VARCHAR(6)YesspecNo
prop_memo
VARCHAR(50)Yes
No
order_sort
INT UNSIGNEDYes1No
modified_time
INT UNSIGNEDNo
No
disabled
TINYINT(1)Yes0No
  • 索引
Key nameColumn namesUniqueComment
primaryprop_idYes

app:sysclearing tables

sysclearing_settlement

商家账号信息

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
settlement_no
BIGINT UNSIGNEDYes
No
shop_id
INT UNSIGNEDNo
No
tradecount
INT UNSIGNEDYes0No
item_fee_amount
NUMERIC(20, 3)Yes0No
post_fee_amount
NUMERIC(20, 3)Yes0No
refund_fee_amount
NUMERIC(20, 3)No0No
commission_fee_amount
NUMERIC(20, 3)No0No
settlement_fee_amount
NUMERIC(20, 3)No0No
settlement_status1:未结算;2:已结算;VARCHAR(1)No1No
account_start_time
INT UNSIGNEDNo
No
account_end_time
INT UNSIGNEDNo
No
settlement_time
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primarysettlement_noYes

sysclearing_settlement_detail

结算明细表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
idsettlement_detail_idINT UNSIGNED AUTO_INCREMENTYes
Yes
oid子订单编号BIGINT UNSIGNEDYes
No
tid订单编号BIGINT UNSIGNEDYes
No
shop_id所属商家INT UNSIGNEDYes
No
settlement_time
INT UNSIGNEDNo
No
pay_time
INT UNSIGNEDNo
No
item_id商品idINT UNSIGNEDYes
No
sku_id货品idINT UNSIGNEDYes
No
bn明细商品的编码VARCHAR(45)No
No
title商品标题VARCHAR(60)Yes
No
spec_nature_infosku描述LONGTEXTNo
No
price商品价格NUMERIC(20, 3)No
No
num购买数量INT UNSIGNEDNo
No
sku_properties_nameSKU的值VARCHAR(500)No
No
divide_order_fee分摊之后的实付金额NUMERIC(20, 3)No
No
part_mjz_discount优惠分摊NUMERIC(20, 3)No
No
payment实付金额NUMERIC(20, 3)No
No
post_fee
NUMERIC(20, 3)Yes
No
refund_fee
NUMERIC(20, 3)No
No
cat_service_rate
NUMERIC(20, 3)No0No
commission_fee
NUMERIC(20, 3)No
No
settlement_fee
NUMERIC(20, 3)No
No
settlement_type1:普通结算;2:运费结算;3:退款结算;VARCHAR(1)No1No
discount_fee子订单级订单优惠金额NUMERIC(20, 3)No
No
adjust_fee手工调整金额NUMERIC(20, 3)No
No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes

app:syscontent tables

syscontent_article

文章主表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
article_id文章IDINT UNSIGNED AUTO_INCREMENTYes
Yes
title
VARCHAR(255)Yes
No
article_logo文章默认logoVARCHAR(255)No
No
platformpc:电脑端;wap:移动端;VARCHAR(3)Yes
No
node_id
INT UNSIGNEDYes
No
pubtime发布时间(无需精确到秒)INT UNSIGNEDNo
No
modified更新时间(精确到秒)INT UNSIGNEDNo
No
ifpub发布TINYINT(1)No0No
content文章内容LONGTEXTNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryarticle_idYes

syscontent_article_nodes

文章节点表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
node_id节点idINT UNSIGNED AUTO_INCREMENTYes
Yes
parent_id父节点INT UNSIGNEDYes0No
node_depth节点深度SMALLINTYes0No
node_name节点名称VARCHAR(255)Yes
No
node_path节点路径VARCHAR(255)No
No
has_children是否存在子节点TINYINT(1)Yes0No
ifpub发布TINYINT(1)Yes0No
order_sort排序INT UNSIGNEDYes0No
modified修改时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primarynode_idYes

app:sysdecorate tables

sysdecorate_widgets_instance

挂件实例表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
widgets_id挂件实例IDINT UNSIGNED AUTO_INCREMENTYes
Yes
shop_id
INT UNSIGNEDYes
No
widgets_type所属挂件的名称VARCHAR(30)Yes
No
theme模版的名称VARCHAR(30)No
No
title挂件自定义标题VARCHAR(100)No
No
params配置参数LONGTEXTNo
No
modified_time修改时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primarywidgets_idYes
ind_wgbaseshop_id, widgets_typeNo

app:sysitem tables

sysitem_item

商品表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
item_iditem_idINT UNSIGNED AUTO_INCREMENTYes
Yes
shop_id店铺idINT UNSIGNEDYes
No
cat_id商品类目IDINT UNSIGNEDYes
No
brand_id品牌INT UNSIGNEDYes
No
shop_cat_id商家自定义分类idVARCHAR(255)Yes
No
title商品标题VARCHAR(90)Yes
No
sub_title商品子标题VARCHAR(200)No
No
bnbnVARCHAR(45)Yes
No
price商品价格NUMERIC(20, 3)Yes
No
cost_price商品成本价格NUMERIC(20, 3)No
No
mkt_price商品市场价格NUMERIC(20, 3)No
No
weight商品重量NUMERIC(20, 3)Yes0No
image_default_id商品默认图VARCHAR(255)No
No
list_image商品图片LONGTEXTNo
No
store商品数量INT UNSIGNEDYes0No
freez预扣库存INT UNSIGNEDNo
No
order_sort排序INT UNSIGNEDNo0No
modified_time商品最后更新时间INT UNSIGNEDYes
No
has_discount是否支持会员打折TINYINT(1)No0No
is_virtual是否是虚拟商品TINYINT(1)No0No
is_timing是否定时上下架TINYINT(1)No0No
violation是否违规TINYINT(1)No0No
is_selfshop是否自营TINYINT(1)No0No
nospec
TINYINT(1)Yes0No
spec_desc销售属性序列化LONGTEXTNo
No
props_name商品属性LONGTEXTNo
No
params商品参数序列化LONGTEXTNo
No
sub_stock是否支持下单减库存TINYINT(1)No1No
outer_id商家外部编码VARCHAR(32)No
No
is_offline是否是线下商品TINYINT(1)No0No
barcode商品级别的条形码VARCHAR(128)No
No
disableddisabledTINYINT(1)Yes0No
use_platform使用平台|0:全部;1:pc端;2:wap端;VARCHAR(1)No0No
  • 索引
Key nameColumn namesUniqueComment
primaryitem_idYes
ind_titletitleNo
ind_bnbnNo

sysitem_item_count

商品次数表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
item_id商品idINT UNSIGNEDYes
No
sold_quantity商品销量INT UNSIGNEDNo0No
rate_count评论次数INT UNSIGNEDYes0No
rate_good_count好评次数INT UNSIGNEDYes0No
rate_neutral_count中评次数INT UNSIGNEDYes0No
rate_bad_count差评次数INT UNSIGNEDYes0No
view_count浏览次数INT UNSIGNEDYes0No
buy_count购买次数INT UNSIGNEDYes0No
  • 索引
Key nameColumn namesUniqueComment
primaryitem_idYes

sysitem_item_desc

商品详情表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
item_id商品idINT UNSIGNEDYes
No
pc_desc宝贝详情LONGTEXTNo
No
wap_descWap宝贝详情LONGTEXTNo
No
wireless_desc无线端宝贝详情LONGTEXTNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryitem_idYes

sysitem_item_nature_props

商品自然属性信息表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
item_id商品IDINT UNSIGNEDYes0No
prop_id自然属性IDINT UNSIGNEDYes0No
prop_value_id自然属性值IDINT UNSIGNEDYes0No
pv_typeselect:下拉框select;text:输入值text;VARCHAR(6)YesselectNo
pv_number
INT UNSIGNEDNo
No
pv_str
VARCHAR(255)No
No
modified_time
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryitem_id, prop_idYes

sysitem_item_promotion

商品关联的促销表(新)

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
item_id商品IDINT UNSIGNEDYes
No
promotion_id促销idINT UNSIGNEDYes
No
  • 索引
Key nameColumn namesUniqueComment
primaryitem_id, promotion_idYes

sysitem_item_status

商品上下架状态表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
item_id商品 IDINT UNSIGNEDYes
No
shop_id店铺idINT UNSIGNEDYes
No
approve_status商品状态|onsale:出售中;instock:库中;VARCHAR(7)YesinstockNo
list_time上架时间INT UNSIGNEDNo
No
delist_time下架时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryitem_idYes

sysitem_item_store

商品总库存表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
item_id商品 IDINT UNSIGNEDYes
No
store总商品数量INT UNSIGNEDYes0No
freezsku预占库存总和INT UNSIGNEDNo0No
  • 索引
Key nameColumn namesUniqueComment
primaryitem_idYes

sysitem_sku

货品表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
sku_idsku_idINT UNSIGNED AUTO_INCREMENTYes
Yes
item_id商品idINT UNSIGNEDYes
No
title商品标题VARCHAR(90)Yes
No
bn商品编号VARCHAR(30)Yes
No
price商品价格NUMERIC(20, 3)Yes
No
cost_price成本价NUMERIC(20, 3)No0No
mkt_price市场价NUMERIC(20, 3)No0No
barcode条形码VARCHAR(32)No
No
weight商品重量NUMERIC(20, 3)Yes0No
created_time创建时间INT UNSIGNEDNo
No
modified_time最后更新时间INT UNSIGNEDNo
No
propertiessku销售属性LONGTEXTNo
No
spec_info物品描述LONGTEXTNo
No
spec_desc
LONGTEXTNo
No
statussku状态|normal:正常;delete:删除;VARCHAR(6)NonormalNo
outer_id商家设置的外部idVARCHAR(32)No
No
  • 索引
Key nameColumn namesUniqueComment
primarysku_idYes
ind_item_iditem_idNo
ind_titletitleNo
ind_bnbnNo
ind_barcodebarcodeNo

sysitem_sku_store

商品库存表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
item_id商品 IDINT UNSIGNEDYes
No
sku_idsku IDINT UNSIGNEDYes
No
store商品数量INT UNSIGNEDYes0No
freezsku预占库存INT UNSIGNEDNo0No
  • 索引
Key nameColumn namesUniqueComment
primaryitem_id, sku_idYes

sysitem_spec_index

商品规格索引表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
prop_value_id销售属性值IDINT UNSIGNEDYes0No
sku_idsku IDINT UNSIGNEDYes0No
cat_id商品三级分类IDINT UNSIGNEDYes0No
prop_id销售属性IDINT UNSIGNEDYes0No
item_id商品IDINT UNSIGNEDYes0No
modified_time
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryprop_value_id, sku_idYes

app:syslogistics tables

syslogistics_coupon

优惠券表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
cpns_id优惠券方案idINT UNSIGNED AUTO_INCREMENTYes
Yes
cpns_name优惠券名称VARCHAR(255)No
No
  • 索引
Key nameColumn namesUniqueComment
primarycpns_idYes

syslogistics_delivery

发货单表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
delivery_id配送流水号BIGINT UNSIGNED AUTO_INCREMENTYes
Yes
tid订单号VARCHAR(100)No
No
user_id订货会员IDINT UNSIGNEDNo
No
seller_id商家账号INT UNSIGNEDNo
No
shop_id商家IDINT UNSIGNEDNo
No
post_fee配送费用NUMERIC(20, 3)Yes0No
is_protect是否保价TINYINT(1)Yes0No
dlytmpl_id配送方式(货到付款、EMS...)INT UNSIGNEDNo
No
logi_id物流公司IDVARCHAR(50)No
No
logi_name物流公司名称VARCHAR(100)No
No
corp_code物流公司代码VARCHAR(200)No
No
logi_no物流单号VARCHAR(50)No
No
receiver_name收货人姓名VARCHAR(50)No
No
receiver_state收货人所在省VARCHAR(20)No
No
receiver_city收货人所在市VARCHAR(20)No
No
receiver_district收货人所在地区VARCHAR(20)No
No
receiver_address收货人详细地址VARCHAR(200)No
No
receiver_zip收货人邮编VARCHAR(20)No
No
receiver_mobile收货人手机号VARCHAR(20)No
No
receiver_phone收货人电话VARCHAR(20)No
No
t_begin单据生成时间INT UNSIGNEDNo
No
t_send单据结束时间INT UNSIGNEDNo
No
t_confirm单据确认时间INT UNSIGNEDNo
No
op_name操作者VARCHAR(50)No
No
status状态|succ:成功到达;failed:发货失败;cancel:已取消;lost:货物丢失;progress:运送中;timeout:超时;ready:准备发货;VARCHAR(8)YesreadyNo
memo备注LONGTEXTNo
No
disabled无效TINYINT(1)No0No
  • 索引
Key nameColumn namesUniqueComment
primarydelivery_idYes
ind_disableddisabledNo
ind_logi_nologi_noNo

syslogistics_delivery_detail

发货/退货单明细表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
detail_id序号INT UNSIGNED AUTO_INCREMENTYes
Yes
delivery_id发货单号BIGINT UNSIGNEDYes0No
oid发货明细子订单号BIGINT UNSIGNEDNo0No
item_type商品类型|item:商品;gift:赠品;pkg:捆绑商品;adjunct:配件商品;VARCHAR(7)YesitemNo
sku_idSKU IDBIGINT UNSIGNEDYes0No
sku_bnsku编号VARCHAR(30)No
No
sku_titlesku名称VARCHAR(200)No
No
number发货数量DOUBLE PRECISIONYes0No
  • 索引
Key nameColumn namesUniqueComment
primarydetail_idYes
ind_delivery_iddelivery_idNo
ind_oidoidNo

syslogistics_dlycorp

物流公司表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
corp_id物流公司IDSMALLINT AUTO_INCREMENTYes
Yes
corp_code物流公司代码VARCHAR(200)Yes
No
full_name物流公司全名VARCHAR(200)No
No
corp_name物流公司简称VARCHAR(200)Yes
No
website物流公司网址VARCHAR(100)No
No
request_url查询接口网址VARCHAR(100)No
No
order_sort排序INT UNSIGNEDYes0No
custom
TINYINT(1)No0No
  • 索引
Key nameColumn namesUniqueComment
primarycorp_idYes
ind_corp_codecorp_codeNo

syslogistics_dlytmpl

快递模板配置表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
template_id
INT UNSIGNED AUTO_INCREMENTYes
Yes
shop_id
INT UNSIGNEDYes
No
name
VARCHAR(50)No
No
valuation运费计算参数来源|0:按件数;1:按重量;2:按体积;VARCHAR(1)No1No
corp_id物流公司IDVARCHAR(255)No
No
order_sort
INT UNSIGNEDNo0No
protect
TINYINT(1)Yes0No
protect_rate保价费率NUMERIC(6, 3)No
No
minprice保价费最低值NUMERIC(10, 2)Yes0.00No
status是否开启|off:关闭;on:启用;VARCHAR(3)NoonNo
fee_conf运费模板中运费信息对象,包含默认运费和指定地区运费LONGTEXTNo
No
create_time创建时间INT UNSIGNEDNo
No
modifie_time最后修改时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primarytemplate_idYes
ind_shop_temp_idshop_id, template_idNo
ind_shop_idshop_idNo

syslogistics_ziti

自提点表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
id自增IDINT UNSIGNED AUTO_INCREMENTYes
Yes
name自提点名称VARCHAR(255)No
No
area_state_id自提地区ID(省)VARCHAR(255)Yes
No
area_city_id自提地区ID(城市)VARCHAR(255)Yes
No
area_district_id自提地区ID(区,县)VARCHAR(255)Yes
No
area地区IDVARCHAR(255)Yes
No
addr地址VARCHAR(255)No
No
tel电话或者手机号码VARCHAR(50)No
No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes
ind_area_state_idarea_state_idNo
ind_area_city_idarea_city_idNo
ind_area_district_idarea_district_idNo

app:sysopen tables

sysopen_keys

店铺请求开放api的key和secret

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
shop_id对应的商户idVARCHAR(255)Yes
No
key访问api时用的keyVARCHAR(255)No
No
secret访问api时用的secretVARCHAR(255)No
No
contact_type商户状态|notallowopen:禁止接入;applyforopen:申请接入;openstandard:标准接入;VARCHAR(12)Yes
No
mark备注VARCHAR(255)No
No
  • 索引
Key nameColumn namesUniqueComment
primaryshop_idYes

sysopen_shopconf

店铺请求开放api的key和secret

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
shop_id对应的商户idVARCHAR(255)Yes
No
develop_mode开发者模式配置|DEVELOP:开发者模式;PRODUCT:运营商模式;VARCHAR(7)Yes
No
  • 索引
Key nameColumn namesUniqueComment
primaryshop_idYes

app:syspromotion tables

syspromotion_activity

活动规则表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
activity_id活动idINT UNSIGNED AUTO_INCREMENTYes
Yes
activity_name活动名称VARCHAR(100)Yes
No
activity_tag活动标签VARCHAR(255)Yes
No
activity_desc活动描述LONGTEXTNo
No
apply_begin_time申请活动开始时间INT UNSIGNEDYes0No
apply_end_time申请活动结束时间INT UNSIGNEDYes0No
release_time发布时间INT UNSIGNEDYes0No
start_time活动生效开始时间INT UNSIGNEDYes0No
end_time活动生效结束时间INT UNSIGNEDYes0No
buy_limit用户限购数量INT UNSIGNEDYes0No
enroll_limit店铺报名限制数量INT UNSIGNEDYes0No
limit_cat报名类目限制LONGTEXTYes0No
shoptype店铺类型限制VARCHAR(255)No
No
discount_min最小折扣INT UNSIGNEDYes
No
discount_max最大折扣INT UNSIGNEDYes
No
mainpush是否主推活动TINYINT(1)No0No
slide_images轮播广告图VARCHAR(500)No
No
enabled是否启用TINYINT(1)No0No
created_time创建时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryactivity_idYes
ind_created_timecreated_timeNo

syspromotion_activity_item

活动商品表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
id
INT UNSIGNED AUTO_INCREMENTYes
Yes
activity_id活动idINT UNSIGNEDNo
No
shop_id商家店铺idINT UNSIGNEDYes
No
item_id商品idINT UNSIGNEDNo
No
cat_id商品关联的三级类目idINT UNSIGNEDNo
No
title商品名称VARCHAR(90)Yes
No
item_default_image商品原默认图VARCHAR(255)No
No
price商品原价NUMERIC(20, 3)Yes
No
activity_price促销价格NUMERIC(20, 3)No
No
sales_count本活动销量INT UNSIGNEDNo0No
verify_status审核状态|pending:待审核;refuse:审核被拒绝;agree:审核通过;VARCHAR(7)YespendingNo
start_time活动生效开始时间INT UNSIGNEDYes0No
end_time活动生效结束时间INT UNSIGNEDYes0No
activity_tag活动标签VARCHAR(255)Yes
No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes
ind_activitywithitemactivity_id, item_idYes
ind_shop_idshop_idNo
ind_activity_tagactivity_tagNo
ind_verify_statusverify_statusNo
ind_cat_idcat_idNo

syspromotion_activity_register

活动报名表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
ididINT UNSIGNED AUTO_INCREMENTYes
Yes
shop_id店铺idINT UNSIGNEDYes
No
activity_id活动idINT UNSIGNEDYes
No
verify_status审核状态|pending:待审核;refuse:审核被拒绝;agree:审核通过;VARCHAR(7)YespendingNo
valid_status有效状态TINYINT(1)Yes1No
refuse_reason拒绝原因VARCHAR(255)No
No
modified_time报名更新时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes
ind_activitywithshopactivity_id, shop_idYes
ind_verify_statusverify_statusNo
ind_modified_timemodified_timeNo

syspromotion_coupon

优惠券表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
coupon_id优惠券方案idINT UNSIGNED AUTO_INCREMENTYes
Yes
shop_id所属商家的店铺idINT UNSIGNEDYes
No
coupon_name优惠券名称VARCHAR(255)Yes
No
coupon_desc优惠券描述VARCHAR(255)Yes
No
used_platform使用平台|0:商家全场可用;1:只能用于pc;2:只能用于wap;VARCHAR(1)Yes0No
valid_grade
VARCHAR(255)Yes
No
limit_money满足条件金额NUMERIC(20, 3)No0No
deduct_money优惠金额NUMERIC(20, 3)No0No
max_gen_quantity最大优惠券号码数量INT UNSIGNEDNo0No
send_couponcode_quantity已生成的优惠券号码数量INT UNSIGNEDNo0No
userlimit_quantity用户总计可领取优惠券数量INT UNSIGNEDNo0No
use_bound使用范围|0:商家全场可用;1:指定商品可用;VARCHAR(1)No1No
coupon_prefix优惠券前缀VARCHAR(50)Yes
No
coupon_key优惠券生成的keyVARCHAR(20)Yes
No
cansend_start_time发优惠券开始时间INT UNSIGNEDNo
No
cansend_end_time发优惠券结束时间INT UNSIGNEDNo
No
canuse_start_time优惠券生效时间INT UNSIGNEDNo
No
canuse_end_time优惠券失效时间INT UNSIGNEDNo
No
created_time建券时间INT UNSIGNEDNo
No
promotion_tag促销标签VARCHAR(15)Yes
No
coupon_status促销状态|pending:待审核;agree:审核通过;refuse:审核拒绝;cancel:已取消;VARCHAR(7)YesagreeNo
  • 索引
Key nameColumn namesUniqueComment
primarycoupon_idYes
ind_shop_idshop_idNo
ind_created_timecreated_timeNo
ind_coupon_statuscoupon_statusNo

syspromotion_coupon_item

商品与促销规则关联表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
coupon_id优惠券IDINT UNSIGNEDYes
No
item_id商品IDINT UNSIGNEDYes
No
leaf_cat_id商品关联的平台叶子节点分类IDINT UNSIGNEDYes
No
title商品名称VARCHAR(60)Yes
No
image_default_id商品图片VARCHAR(255)No
No
price商品价格NUMERIC(20, 3)Yes
No
promotion_tag
VARCHAR(10)Yes0No
canuse_start_time起始可使用时间INT UNSIGNEDNo0No
canuse_end_time截止可使用时间INT UNSIGNEDNo0No
status促销状态TINYINT(1)Yes0No
  • 索引
Key nameColumn namesUniqueComment
primarycoupon_id, item_idYes

syspromotion_freepostage

免邮表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
freepostage_id免邮方案idINT UNSIGNED AUTO_INCREMENTYes
Yes
shop_id所属商家的店铺idINT UNSIGNEDYes
No
freepostage_name免邮名称VARCHAR(255)Yes
No
freepostage_desc免邮描述VARCHAR(255)Yes
No
used_platform使用平台|0:商家全场可用;1:只能用于pc;2:只能用于wap;VARCHAR(1)Yes0No
valid_grade
VARCHAR(255)Yes
No
gentype生成类型|0:独立添加;1:绑定促销;VARCHAR(1)No0No
condition_type免邮条件标准|money:按金额;quantity:按数量;VARCHAR(8)NomoneyNo
limit_money满足条件金额NUMERIC(20, 3)No0No
limit_quantity满足条件数量INT UNSIGNEDNo
No
use_bound使用范围|0:商家全场可用;1:指定商品可用;VARCHAR(1)No0No
start_time免邮生效时间INT UNSIGNEDNo
No
end_time免邮失效时间INT UNSIGNEDNo
No
created_time创建时间INT UNSIGNEDNo
No
promotion_tag促销标签VARCHAR(15)Yes
No
freepostage_status促销状态|pending:待审核;agree:审核通过;refuse:审核拒绝;cancel:已取消;VARCHAR(7)YesagreeNo
  • 索引
Key nameColumn namesUniqueComment
primaryfreepostage_idYes
ind_freepostage_statusfreepostage_statusNo
ind_shop_idshop_idNo

syspromotion_freepostage_item

商品与促销规则关联表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
freepostage_id满减IDINT UNSIGNEDYes
No
item_id商品IDINT UNSIGNEDYes
No
shop_id所属商家的店铺idINT UNSIGNEDYes
No
leaf_cat_id商品关联的平台叶子节点分类IDINT UNSIGNEDYes
No
title商品名称VARCHAR(60)Yes
No
image_default_id商品图片VARCHAR(255)No
No
price商品价格NUMERIC(20, 3)Yes
No
promotion_tag
VARCHAR(10)Yes0No
start_time起始时间INT UNSIGNEDNo0No
end_time截止时间INT UNSIGNEDNo0No
status是否生效中TINYINT(1)Yes0No
  • 索引
Key nameColumn namesUniqueComment
primaryfreepostage_id, item_idYes
ind_promotion_tagpromotion_tagNo
ind_leaf_cat_idleaf_cat_idNo

syspromotion_fulldiscount

满折促销规则表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
fulldiscount_id满折规则idINT UNSIGNED AUTO_INCREMENTYes
Yes
shop_id所属商家的店铺idINT UNSIGNEDYes
No
fulldiscount_name满折规则名称VARCHAR(255)Yes
No
fulldiscount_desc规则描述LONGTEXTNo
No
used_platform使用平台|0:商家全场可用;1:只能用于pc;2:只能用于wap;VARCHAR(1)Yes0No
use_bound使用范围|0:商家全场可用;1:指定商品可用;VARCHAR(1)No1No
valid_grade
VARCHAR(255)No
No
condition_value
VARCHAR(255)No
No
join_limit
INT UNSIGNEDYes1No
free_postage
TINYINT(1)No0No
created_time创建时间INT UNSIGNEDNo
No
start_time起始时间INT UNSIGNEDNo0No
end_time截止时间INT UNSIGNEDNo0No
promotion_tag促销标签VARCHAR(15)Yes
No
fulldiscount_status促销状态|pending:待审核;agree:审核通过;refuse:审核拒绝;cancel:已取消;VARCHAR(7)YesagreeNo
  • 索引
Key nameColumn namesUniqueComment
primaryfulldiscount_idYes
ind_shop_idshop_idNo
ind_created_timecreated_timeNo
ind_fulldiscount_statusfulldiscount_statusNo

syspromotion_fulldiscount_item

商品与促销规则关联表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
fulldiscount_id满折IDINT UNSIGNEDYes
No
item_id商品IDINT UNSIGNEDYes
No
shop_id所属商家的店铺idINT UNSIGNEDYes
No
leaf_cat_id商品关联的平台叶子节点分类IDINT UNSIGNEDYes
No
title商品名称VARCHAR(60)Yes
No
image_default_id商品图片VARCHAR(250)No
No
price商品价格NUMERIC(20, 3)Yes
No
promotion_tag
VARCHAR(10)Yes0No
start_time起始时间INT UNSIGNEDNo0No
end_time截止时间INT UNSIGNEDNo0No
status是否生效中TINYINT(1)Yes0No
  • 索引
Key nameColumn namesUniqueComment
primaryfulldiscount_id, item_idYes
ind_shop_idshop_idNo
ind_leaf_cat_idleaf_cat_idNo

syspromotion_fullminus

满减促销规则表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
fullminus_id满减规则idINT UNSIGNED AUTO_INCREMENTYes
Yes
shop_id所属商家的店铺idINT UNSIGNEDYes
No
fullminus_name满减规则名称VARCHAR(255)Yes
No
fullminus_desc规则描述LONGTEXTNo
No
used_platform使用平台|0:商家全场可用;1:只能用于pc;2:只能用于wap;VARCHAR(1)Yes0No
use_bound使用范围|0:商家全场可用;1:指定商品可用;VARCHAR(1)No1No
valid_grade
VARCHAR(255)No
No
condition_value
VARCHAR(255)No
No
join_limit
INT UNSIGNEDYes1No
canjoin_repeat
TINYINT(1)Yes0No
free_postage
TINYINT(1)No0No
created_time创建时间INT UNSIGNEDNo
No
start_time起始时间INT UNSIGNEDNo0No
end_time截止时间INT UNSIGNEDNo0No
promotion_tag促销标签VARCHAR(15)Yes
No
fullminus_status促销状态|pending:待审核;agree:审核通过;refuse:审核拒绝;cancel:已取消;VARCHAR(7)YesagreeNo
  • 索引
Key nameColumn namesUniqueComment
primaryfullminus_idYes
ind_shop_idshop_idNo
ind_created_timecreated_timeNo
ind_fullminus_statusfullminus_statusNo

syspromotion_fullminus_item

商品与促销规则关联表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
fullminus_id满减IDINT UNSIGNEDYes
No
item_id商品IDINT UNSIGNEDYes
No
shop_id所属商家的店铺idINT UNSIGNEDYes
No
leaf_cat_id商品关联的平台叶子节点分类IDINT UNSIGNEDYes
No
title商品名称VARCHAR(60)Yes
No
image_default_id商品图片VARCHAR(255)No
No
price商品价格NUMERIC(20, 3)Yes
No
promotion_tag
VARCHAR(10)Yes0No
start_time起始时间INT UNSIGNEDNo0No
end_time截止时间INT UNSIGNEDNo0No
status是否生效中TINYINT(1)Yes0No
  • 索引
Key nameColumn namesUniqueComment
primaryfullminus_id, item_idYes
ind_shop_idshop_idNo
ind_leaf_cat_idleaf_cat_idNo

syspromotion_promotions

各种促销关联表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
promotion_id促销idINT UNSIGNED AUTO_INCREMENTYes
Yes
rel_promotion_id关联的促销类型idINT UNSIGNEDYes
No
promotion_type促销类型VARCHAR(50)Yes
No
shop_id所属商家的店铺idINT UNSIGNEDYes
No
promotion_name促销名称VARCHAR(255)Yes
No
promotion_tag促销标签VARCHAR(255)Yes
No
promotion_desc促销描述VARCHAR(255)No
No
used_platform使用平台|0:商家全场可用;1:只能用于pc;2:只能用于wap;VARCHAR(1)Yes0No
start_time开始时间INT UNSIGNEDNo
No
end_time结束时间INT UNSIGNEDYes
No
created_time创建时间INT UNSIGNEDYes
No
check_status促销状态|pending:待审核;agree:审核通过;refuse:审核拒绝;cancel:已取消;VARCHAR(7)Yes
No
  • 索引
Key nameColumn namesUniqueComment
primarypromotion_idYes

syspromotion_xydiscount

X件Y折促销规则表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
xydiscount_idX件Y折规则idINT UNSIGNED AUTO_INCREMENTYes
Yes
shop_id所属商家的店铺idINT UNSIGNEDYes
No
xydiscount_nameX件Y折规则名称VARCHAR(255)Yes
No
xydiscount_desc规则描述LONGTEXTNo
No
used_platform使用平台|0:商家全场可用;1:只能用于pc;2:只能用于wap;VARCHAR(1)Yes0No
use_bound使用范围|0:商家全场可用;1:指定商品可用;VARCHAR(1)No1No
valid_grade
VARCHAR(255)No
No
join_limit
INT UNSIGNEDYes1No
limit_number满足条件件数INT UNSIGNEDNo
No
discount折扣INT UNSIGNEDNo0No
condition_value
VARCHAR(255)No
No
created_time创建时间INT UNSIGNEDNo
No
start_time起始时间INT UNSIGNEDNo0No
end_time截止时间INT UNSIGNEDNo0No
promotion_tag促销标签VARCHAR(15)Yes
No
xydiscount_status促销状态|pending:待审核;agree:审核通过;refuse:审核拒绝;cancel:已取消;VARCHAR(7)YesagreeNo
  • 索引
Key nameColumn namesUniqueComment
primaryxydiscount_idYes
ind_shop_idshop_idNo
ind_created_timecreated_timeNo
ind_xydiscount_statusxydiscount_statusNo

syspromotion_xydiscount_item

商品与促销规则关联表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
xydiscount_idX件Y折IDINT UNSIGNEDYes
No
item_id商品IDINT UNSIGNEDYes
No
shop_id所属商家的店铺idINT UNSIGNEDYes
No
leaf_cat_id商品关联的平台叶子节点分类IDINT UNSIGNEDYes
No
title商品名称VARCHAR(60)Yes
No
image_default_id商品图片VARCHAR(255)No
No
price商品价格NUMERIC(20, 3)Yes
No
promotion_tag
VARCHAR(10)Yes0No
start_time起始时间INT UNSIGNEDNo0No
end_time截止时间INT UNSIGNEDNo0No
status是否生效中TINYINT(1)Yes0No
  • 索引
Key nameColumn namesUniqueComment
primaryxydiscount_id, item_idYes
ind_shop_idshop_idNo
ind_leaf_cat_idleaf_cat_idNo

app:sysrate tables

sysrate_appeal

评论申诉表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
appeal_id申诉IDBIGINT UNSIGNED AUTO_INCREMENTYes
Yes
rate_id评价IDBIGINT UNSIGNEDYes
No
statusWAIT:等待批准;REJECT:申诉驳回;SUCCESS:申诉成功;CLOSE:申诉关闭;VARCHAR(7)NoWAITNo
appeal_typeAPPLY_DELETE:申请删除评论;APPLY_UPDATE:申请修改评论;VARCHAR(12)NoAPPLY_UPDATENo
appeal_again再次申诉TINYINT(1)No0No
content
LONGTEXTNo
No
evidence_pic申诉图片凭证LONGTEXTNo
No
reject_reason
LONGTEXTNo
No
appeal_log申诉日志LONGTEXTNo
No
appeal_time
INT UNSIGNEDNo
No
modified_time
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryappeal_idYes
ind_rate_idrate_idNo
ind_statusstatusNo
ind_appeal_timeappeal_timeNo

sysrate_consultation

商品咨询表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
consultation_id咨询自增编号BIGINT AUTO_INCREMENTYes
Yes
be_reply_id被回复的咨询idBIGINTNo0No
item_title被咨询的商品标题VARCHAR(1023)Yes
No
shop_name所属店铺VARCHAR(70)Yes
No
author操作人VARCHAR(60)No
No
consultation_type咨询类型|item:商品咨询;store_delivery:库存/配送咨询;payment: 支付方式咨询;invoice:发票保修咨询;VARCHAR(14)NoitemNo
contack联系方式VARCHAR(200)No
No
content商品咨询的内容VARCHAR(1023)No
No
is_reply商品咨询是否被回复TINYINT(1)No0No
created_time创建时间INT UNSIGNEDNo
No
ip消费者发起咨询时的ipVARCHAR(255)No
No
is_display是否显示至商祥页|true:显示;false:不显示;VARCHAR(5)NofalseNo
shop_id店铺IDINT UNSIGNEDYes
No
item_id被咨询的商品idBIGINTYes
No
author_id操作人idBIGINTNo
No
is_anonymity是否匿名TINYINT(1)No0No
modified_time
INT UNSIGNEDNo
No
image_default_id商品默认图VARCHAR(255)No
No
  • 索引
Key nameColumn namesUniqueComment
primaryconsultation_idYes
ind_item_iditem_idNo
ind_shop_idshop_idNo
ind_created_timecreated_timeNo

sysrate_dsr

店铺动态评分统计表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
shop_id店铺IDBIGINT UNSIGNEDYes
No
cat_id关联类目idINT UNSIGNEDYes
No
tally_dsr
LONGTEXTNo5No
attitude_dsr
LONGTEXTNo5No
delivery_speed_dsr
LONGTEXTNo5No
modified_time
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryshop_idYes
ind_modified_timemodified_timeNo
ind_cat_idcat_idNo

sysrate_feedback

意见反馈表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
idIDBIGINT UNSIGNED AUTO_INCREMENTYes
Yes
seller_id用户IDBIGINT UNSIGNEDYes0No
shop_id店铺IDBIGINTYes0No
statusactive:未处理;closed:已关闭;VARCHAR(6)YesactiveNo
name
VARCHAR(32)Yes
No
email
VARCHAR(100)No0No
tel
VARCHAR(100)No
No
question
VARCHAR(255)No
No
memo
VARCHAR(255)No
No
modified_time
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes
ind_modified_timemodified_timeNo
ind_seller_idseller_idNo
ind_shop_idshop_idNo

sysrate_score

店铺评分表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
tid订单IDBIGINT UNSIGNEDYes
No
cat_id关联类目idINT UNSIGNEDYes
No
user_id用户IDBIGINT UNSIGNEDYes
No
shop_id店铺IDBIGINT UNSIGNEDYes
No
tally_score
SMALLINTNo
No
attitude_score
SMALLINTNo
No
delivery_speed_score
SMALLINTNo
No
logistics_service_score
SMALLINTNo
No
created_time
INT UNSIGNEDNo
No
modified_time
INT UNSIGNEDNo
No
disabled是否有效TINYINT(1)Yes0No
  • 索引
Key nameColumn namesUniqueComment
primarytidYes
ind_user_iduser_idNo
ind_created_timecreated_timeNo
ind_shop_idshop_idNo

sysrate_traderate

商品评分表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
rate_id评价IDBIGINT UNSIGNED AUTO_INCREMENTYes
Yes
tid订单号VARCHAR(100)No
No
oid子订单号VARCHAR(100)No
No
user_id
INT UNSIGNEDYes
No
shop_id店铺IDINT UNSIGNEDNo
No
item_id评论的商品IDINT UNSIGNEDYes
No
item_title
VARCHAR(60)Yes
No
item_price商品价格NUMERIC(20, 3)No0No
item_pic商品图片绝对路径VARCHAR(1024)No
No
spec_nature_infosku描述LONGTEXTNo
No
resultgood:好评;neutral:中评;bad:差评;VARCHAR(7)NogoodNo
content
LONGTEXTNo
No
rate_pic晒单图片LONGTEXTNo
No
is_reply
TINYINT(1)No0No
reply_content
LONGTEXTNo
No
reply_time
INT UNSIGNEDNo
No
anony是否匿名TINYINT(1)Yes0No
roleseller:卖家;buyer:买家;VARCHAR(6)YesbuyerNo
is_lock该评价是否被锁定TINYINT(1)No1No
is_appeal是否可以申诉TINYINT(1)No1No
appeal_statusNO_APPEAL:未申诉;WAIT:等待批准;REJECT:申诉驳回;SUCCESS:申诉成功;CLOSE:申诉关闭;VARCHAR(9)NoNO_APPEALNo
appeal_again再次申诉TINYINT(1)No0No
appeal_time
INT UNSIGNEDNo
No
created_time
INT UNSIGNEDNo
No
modified_time
INT UNSIGNEDNo
No
disabled是否有效TINYINT(1)Yes0No
  • 索引
Key nameColumn namesUniqueComment
primaryrate_idYes
ind_tidtidNo
ind_user_iduser_idNo
ind_shop_idshop_idNo
ind_item_iditem_idNo

app:sysshop tables

sysshop_account

商家会员表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
seller_id商家账户序号IDINT UNSIGNED AUTO_INCREMENTYes
Yes
login_account登录名VARCHAR(100)Yes
No
login_password登录密码VARCHAR(60)Yes
No
disabled
TINYINT(1)No0No
createtime创建时间INT UNSIGNEDNo
No
modified_time
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryseller_idYes
ind_login_accountlogin_accountNo
ind_createtimecreatetimeNo

sysshop_enterapply

入驻申请表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
enterapply_id入驻申请id 自增INT UNSIGNED AUTO_INCREMENTYes
Yes
status申请状态|active:未审核;locked:审核中;successful:审核通过;failing:审核驳回;finish:开店完成;VARCHAR(10)Yes
No
seller_id提交申请的账号INT UNSIGNEDYes
No
shop_name店铺名称VARCHAR(20)Yes
No
shop_type店铺类型|flag:品牌旗舰店;brand:品牌专卖店;cat:类目专营店;VARCHAR(5)Yes
No
shop店铺相关信息LONGTEXTNo
No
shop_info企业相关信息LONGTEXTNo
No
new_brand商家新增品牌VARCHAR(20)No
No
shopuser_name店主姓名VARCHAR(20)Yes
No
company_name公司名称VARCHAR(50)Yes
No
add_time修改时间INT UNSIGNEDNo
No
refuse_time拒绝时间INT UNSIGNEDNo
No
agree_time同意时间INT UNSIGNEDNo
No
enterlog操作日志LONGTEXTNo
No
reason审核不通过原因VARCHAR(500)No
No
  • 索引
Key nameColumn namesUniqueComment
primaryenterapply_idYes
ind_seller_idseller_idNo
ind_statusstatusNo

sysshop_roles

角色表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
role_id角色IDINT UNSIGNED AUTO_INCREMENTYes
Yes
shop_id店铺IDINT UNSIGNEDYes
No
role_name
VARCHAR(100)Yes
No
workground
LONGTEXTNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryrole_idYes

sysshop_seller

商家账号信息

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
seller_id
INT UNSIGNEDYes
No
shop_id店铺idINT UNSIGNEDNo
No
seller_type0:店主;1:店员;VARCHAR(1)Yes0No
role_id角色IDINT UNSIGNEDYes0No
name
VARCHAR(50)Yes
No
mobile
VARCHAR(20)Yes
No
email
VARCHAR(100)Yes
No
modified_time
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryseller_idYes
ind_mobilemobileNo
ind_emailemailNo
ind_shop_idshop_idNo

sysshop_shop

店铺表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
shop_id店铺编号id 自增INT UNSIGNED AUTO_INCREMENTYes
Yes
shop_name店铺名称VARCHAR(50)Yes
No
shop_descript店铺描述LONGTEXTNo
No
shop_type店铺类型|flag:品牌旗舰店;brand:品牌专卖店;cat:类目专营店;self:运营商自营店铺;VARCHAR(5)Yes
No
seller_id提交申请时的用户INT UNSIGNEDYes
No
status提交状态|active:活动店铺;dead:过期店铺;VARCHAR(6)NoactiveNo
open_time开店时间INT UNSIGNEDYes
No
close_time关店时间INT UNSIGNEDNo
No
close_reason店铺关闭原因VARCHAR(500)No
No
shop_logo提交logoVARCHAR(255)No
No
shopuser_name店主姓名VARCHAR(20)Yes
No
qq即时通讯qq账号配置VARCHAR(255)No
No
wangwang即时通讯wangwang账号配置VARCHAR(255)No
No
email邮箱VARCHAR(200)Yes
No
mobile手机号VARCHAR(50)Yes
No
shopuser_identity店主身份证号CHAR(18)Yes
No
shopuser_identity_img店主身份证电子版VARCHAR(255)No
No
shop_area店铺所在地区VARCHAR(255)Yes
No
shop_addr店铺所在地址LONGTEXTYes
No
bulletin店铺公告VARCHAR(50)No
No
  • 索引
Key nameColumn namesUniqueComment
primaryshop_idYes
ind_seller_idseller_idNo
ind_shop_typeshop_typeNo
ind_shop_nameshop_nameNo

sysshop_shop_cat

店铺分类表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
cat_id分类idINT UNSIGNED AUTO_INCREMENTYes
Yes
shop_id
INT UNSIGNEDYes
No
parent_id父类IDINT UNSIGNEDYes0No
cat_path
VARCHAR(100)No,No
level1:一级分类;2:二级分类;VARCHAR(1)No1No
is_leaf
TINYINT(1)Yes0No
cat_name
VARCHAR(100)Yes
No
order_sort
INT UNSIGNEDNo0No
modified_time
INT UNSIGNEDNo
No
disabled
TINYINT(1)Yes0No
  • 索引
Key nameColumn namesUniqueComment
primarycat_idYes
ind_parent_idparent_idNo
ind_cat_shop_idshop_id, cat_idNo
ind_cat_namecat_nameNo

sysshop_shop_info

企业信息表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
info_id企业信息id 自增INT UNSIGNED AUTO_INCREMENTYes
Yes
seller_id提交申请的账号INT UNSIGNEDYes
No
shop_id商家店铺idINT UNSIGNEDYes
No
company_name公司名称VARCHAR(50)Yes
No
license_num营业执照注册号VARCHAR(50)Yes
No
license_img营业执照副本-电子版VARCHAR(255)No
No
representative法定代表人姓名VARCHAR(20)Yes
No
corporate_identity法人身份证号CHAR(18)Yes
No
corporate_identity_img法人身份证号电子版VARCHAR(255)No
No
license_area营业执照所在地VARCHAR(255)Yes
No
license_addr营业执照详细地址LONGTEXTYes
No
establish_date成立日期INT UNSIGNEDYes
No
license_indate营业执照有效期INT UNSIGNEDYes
No
enroll_capital注册资本VARCHAR(20)Yes
No
scope经营范围VARCHAR(200)Yes
No
shop_url公司官网VARCHAR(50)No
No
company_area公司所在地VARCHAR(255)Yes
No
company_addr公司地址LONGTEXTYes
No
company_phone公司电话VARCHAR(20)Yes
No
company_contacts公司联系人VARCHAR(20)Yes
No
company_cmobile公司联系人手机号VARCHAR(50)Yes
No
tissue_code组织机构代码VARCHAR(50)Yes
No
tissue_code_img组织机构代码副本-电子版VARCHAR(255)No
No
tax_code税务登记号VARCHAR(20)Yes
No
tax_code_img税务登记号副本-电子版VARCHAR(255)No
No
bank_user_name银行开户公司名VARCHAR(50)Yes
No
bank_name开户银行VARCHAR(50)Yes
No
cnaps_code支行联行号VARCHAR(50)Yes
No
bankid银行账号VARCHAR(50)Yes
No
bank_area开户银行所在地VARCHAR(50)Yes
No
  • 索引
Key nameColumn namesUniqueComment
primaryinfo_idYes
ind_seller_idseller_idNo
ind_shop_idshop_idNo

sysshop_shop_notice

商家通知表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
notice_id商家通知IDINT UNSIGNED AUTO_INCREMENTYes
Yes
notice_title商家通知标题VARCHAR(255)Yes
No
notice_content商家通知内容LONGTEXTYes
No
notice_type商家通知类型VARCHAR(255)Yes
No
shop_id店铺idINT UNSIGNEDYes
No
admin_id
INT UNSIGNEDNo
No
createtime商家通知创建时间INT UNSIGNEDNo
No
modified_time商家通知最后修改时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primarynotice_idYes

sysshop_shop_rel_brand


  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
shop_id关联店铺idINT UNSIGNEDYes
No
brand_id关联品牌idINT UNSIGNEDYes
No
brand_warranty品牌授权书VARCHAR(255)No
No
  • 索引
Key nameColumn namesUniqueComment
primaryshop_id, brand_idYes

sysshop_shop_rel_lv1cat

店铺关联类目表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
rel_id店铺类目关联INT UNSIGNED AUTO_INCREMENTYes
Yes
cat_id关联类目idINT UNSIGNEDYes
No
shop_id关联店铺idINT UNSIGNEDYes
No
fee_confg
LONGTEXTNo0No
  • 索引
Key nameColumn namesUniqueComment
primaryrel_idYes
ind_uniquecat_id, shop_idYes

sysshop_shop_rel_seller


  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
shop_id关联店铺INT UNSIGNEDYes
No
seller_id关联商家会员idINT UNSIGNEDYes
No
roles商家会员角色|admin:超级管理员;member:普通管理员;VARCHAR(6)YesadminNo
authority商家会员权限|all:所有权限;other:其他权限;VARCHAR(5)YesallNo
shop_name商家所属店铺名称VARCHAR(100)No
No
  • 索引
Key nameColumn namesUniqueComment
primaryshop_id, seller_idYes

sysshop_shop_type

店铺类型表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
shoptype_id自增idSMALLINT AUTO_INCREMENTYes
Yes
shop_type店铺类型id|flag:品牌旗舰店;brand:品牌专卖店;cat:类目专营店;self:运营商自营店铺;VARCHAR(5)Yes
No
name店铺类型名称VARCHAR(20)Yes
No
status状态TINYINT(1)Yes
No
is_exclusive是否排他TINYINT(1)Yes0No
brief类型描述VARCHAR(500)Yes
No
suffix店铺名称后缀VARCHAR(20)Yes
No
max_item店铺默认商品上限INT UNSIGNEDYes
No
is_display
TINYINT(1)No1No
  • 索引
Key nameColumn namesUniqueComment
primaryshoptype_idYes
ind_shop_typeshop_typeNo

app:sysstat tables

sysstat_item_statics

商品统计表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
item_stat_id商家商品数据统计id 自赠BIGINT UNSIGNED AUTO_INCREMENTYes
Yes
shop_id所属商家INT UNSIGNEDYes
No
item_id商品idINT UNSIGNEDYes
No
title商品标题VARCHAR(60)Yes
No
pic_path商品图片绝对路径VARCHAR(255)No
No
amountnum销售数量INT UNSIGNEDNo
No
amountprice销售总价NUMERIC(20, 3)No
No
createtime创建时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryitem_stat_idYes
ind_createtimecreatetimeNo
ind_item_iditem_idNo
ind_shop_idshop_idNo

sysstat_statmember

会员统计表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
statm_id会员数据统计id 自赠BIGINT UNSIGNED AUTO_INCREMENTYes
Yes
newuser新增会员数INT UNSIGNEDNo0No
accountuser会员数总数INT UNSIGNEDNo0No
shopnum新增店铺数INT UNSIGNEDNo0No
shopaccount店铺数INT UNSIGNEDNo0No
sellernum新增商家数INT UNSIGNEDNo0No
selleraccount商家数INT UNSIGNEDNo0No
createtime创建时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primarystatm_idYes
ind_createtimecreatetimeNo

sysstat_trade_statics

交易统计表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
stat_id商家数据统计id 自赠BIGINT UNSIGNED AUTO_INCREMENTYes
Yes
shop_id店铺idINT UNSIGNEDNo
No
new_trade新增订单数INT UNSIGNEDNo0No
new_fee新增订单额NUMERIC(20, 3)No0No
ready_trade待付款订单数INT UNSIGNEDNo0No
ready_fee待付款订单额NUMERIC(20, 3)No0No
alreadytrade已付款订单数VARCHAR(50)No0No
alreadyfee以付款订单额NUMERIC(20, 3)No0No
ready_send_trade待发货订单数量INT UNSIGNEDNo0No
ready_send_fee待发货订单额NUMERIC(20, 3)No0No
already_send_trade待收货订单数量INT UNSIGNEDNo0No
already_send_fee待收货订单额NUMERIC(20, 3)No0No
cancle_trade已取消的订单数量INT UNSIGNEDNo0No
cancle_fee已取消的订单额NUMERIC(20, 3)No0No
complete_trade已完成的订单数量INT UNSIGNEDNo0No
complete_fee已完成订单额NUMERIC(20, 3)No0No
createtime创建时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primarystat_idYes
ind_createtimecreatetimeNo
ind_shop_idshop_idNo

app:system tables

system_adminlog

平台人员操作日志表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
log_id
INT UNSIGNED AUTO_INCREMENTYes
Yes
admin_userid管理员idINT UNSIGNEDYes
No
admin_username管理员用户名VARCHAR(50)Yes
No
created_time操作时间INT UNSIGNEDYes
No
memo操作内容LONGTEXTNo
No
status操作结果TINYINT(1)No0No
router操作路由VARCHAR(200)No
No
ipIPVARCHAR(20)No
No
  • 索引
Key nameColumn namesUniqueComment
primarylog_idYes
ind_createdtimecreated_timeNo
ind_adminusernameadmin_usernameNo

system_matrixset


  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
matrixset_id
INT UNSIGNED AUTO_INCREMENTYes
Yes
node_id
VARCHAR(20)No
No
statusactive:active;dead:dead;VARCHAR(6)No
No
api_url
VARCHAR(100)No
No
iframe_url
VARCHAR(100)No
No
token
VARCHAR(100)No
No
node_type
VARCHAR(20)No
No
shopname
VARCHAR(20)No
No
  • 索引
Key nameColumn namesUniqueComment
primarymatrixset_idYes

system_messenger_systmpl

邮件短信模板

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
tmpl_name模版名称VARCHAR(100)Yes
No
content模板内容LONGTEXTNo0No
modified_time
INT UNSIGNEDNo
No
active是否激活TINYINT(1)No1No
  • 索引
Key nameColumn namesUniqueComment
primarytmpl_nameYes

system_prism_initstep


  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
step_id执行任务的步骤INT UNSIGNED AUTO_INCREMENTYes
Yes
state当前任务是否已经执行过|ready:准备执行中;complete:执行完毕;VARCHAR(8)NoreadyNo
handlar执行任务的类和方法VARCHAR(50)No
No
params请求参数LONGTEXTNo
No
result返回参数LONGTEXTNo
No
create_time进入队列的时间INT UNSIGNEDNo0No
start_time任务开始执行时间INT UNSIGNEDNo0No
complete_time任务执行结束时间INT UNSIGNEDNo0No
  • 索引
Key nameColumn namesUniqueComment
primarystep_idYes

system_queue_mysql

队列-mysql实现表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
idIDBIGINT UNSIGNED AUTO_INCREMENTYes
Yes
queue_name队列标识VARCHAR(100)Yes
No
worker执行任务类VARCHAR(100)Yes
No
params任务参数LONGTEXTYes
No
create_time进入队列的时间INT UNSIGNEDNo0No
last_cosume_time任务开始执行时间INT UNSIGNEDNo0No
owner_thread_idmysql进程IDINTNo-1No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes
ind_getqueue_name, owner_thread_idNo

system_seller_log

店铺人员操作日志表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
log_id
INT UNSIGNED AUTO_INCREMENTYes
Yes
seller_userid店员idINT UNSIGNEDYes
No
seller_username店员用户名VARCHAR(50)Yes
No
shop_id店铺idINT UNSIGNEDYes
No
created_time操作时间INT UNSIGNEDYes
No
memo操作内容LONGTEXTNo
No
router操作路由VARCHAR(50)No
No
ipIPVARCHAR(15)No
No
  • 索引
Key nameColumn namesUniqueComment
primarylog_idYes
ind_createdtimecreated_timeNo
ind_adminusernameseller_usernameNo

app:systrade tables

systrade_activity_detail

订单使用的活动信息表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
tid主订单idBIGINT UNSIGNEDYes
No
oid子订单idBIGINT UNSIGNEDYes
No
user_id会员idINT UNSIGNEDYes
No
activity_id活动规则idINT UNSIGNEDYes
No
item_id商品的IDINT UNSIGNEDNo
No
sku_idsku的IDINT UNSIGNEDNo
No
activity_tag活动标签VARCHAR(30)No
No
activity_name活动名称VARCHAR(255)No
No
activity_desc活动描述LONGTEXTNo
No

systrade_cart

购物车

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
cart_id
INT UNSIGNED AUTO_INCREMENTYes
Yes
user_id会员idINTYes-1No
user_ident会员ident,会员信息和session生成的唯一值VARCHAR(50)Yes
No
shop_id店铺IDINT UNSIGNEDYes
No
obj_type购物车对象类型VARCHAR(20)Yes
No
item_id商品idINT UNSIGNEDYes
No
sku_idsku的idINT UNSIGNEDYes
No
title商品标题VARCHAR(60)Yes
No
image_default_id商品默认图VARCHAR(255)No
No
quantity数量DOUBLE PRECISIONYes
No
is_checked是否购物车选中TINYINT(1)Yes0No
selected_promotion购物车选中的促销IDVARCHAR(30)Yes
No
created_time加入购物车时间INT UNSIGNEDNo
No
modified_time最后修改时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primarycart_id, user_idYes
ind_sku_idsku_id, user_identNo
ind_shop_idshop_idNo
ind_user_iduser_idNo

systrade_cart_coupon

购物车使用优惠券表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
id
INT UNSIGNED AUTO_INCREMENTYes
Yes
user_id会员idINTYes
No
shop_id店铺IDINT UNSIGNEDYes
No
coupon_id优惠券idINT UNSIGNEDYes
No
coupon_code优惠券号码VARCHAR(15)Yes
No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes
ind_shopusers_idshop_id, user_idYes

systrade_log

订单日志表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
log_id订单日志IDINT UNSIGNED AUTO_INCREMENTYes
Yes
rel_id单据对象ID,如订单号,退款单号等BIGINT UNSIGNEDYes0No
op_id操作员IDINT UNSIGNEDNo
No
op_name
VARCHAR(100)No
No
op_role操作角色|buyer:购买者;seller:卖家;shopadmin:平台操作员;system:系统;VARCHAR(9)YessystemNo
behavior日志记录操作的行为|create:创建;update:修改;payed:支付;delivery:发货;confirm:收货;cancel:取消;refund:退款;reship:退货;exchange:换货;mark:修改备注;finish:完成;VARCHAR(8)YesupdateNo
log_text操作内容LONGTEXTNo
No
log_time记录时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primarylog_idYes
ind_rel_idrel_idNo

systrade_order

订单子表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
oid子订单编号BIGINT UNSIGNEDYes
No
tid订单编号BIGINT UNSIGNEDYes
No
shop_id所属商家INT UNSIGNEDYes
No
user_id买家idINT UNSIGNEDYes
No
item_id商品idINT UNSIGNEDYes
No
sku_id货品idINT UNSIGNEDYes
No
bn明细商品的编码VARCHAR(45)No
No
title商品标题VARCHAR(90)Yes
No
spec_nature_infosku描述LONGTEXTNo
No
price商品价格NUMERIC(20, 3)No0No
num购买数量INT UNSIGNEDNo
No
sendnum明细商品发货数量DOUBLE PRECISIONYes0No
sku_properties_nameSKU的值VARCHAR(500)No
No
refund_id最近退款IDVARCHAR(20)No
No
is_oversold是否超卖TINYINT(1)No0No
pay_time付款时间INT UNSIGNEDNo
No
end_time结束时间INT UNSIGNEDNo
No
consign_time发货时间INT UNSIGNEDNo
No
shipping_type运送方式VARCHAR(20)No
No
bind_oid捆绑的子订单号VARCHAR(20)No
No
logistics_company子订单发货的快递公司VARCHAR(30)No
No
invoice_no子订单所在包裹的运单号VARCHAR(20)No
No
divide_order_fee分摊之后的实付金额NUMERIC(20, 3)No0No
part_mjz_discount优惠分摊NUMERIC(20, 3)No0No
total_fee应付金额NUMERIC(20, 3)No0No
payment实付金额NUMERIC(20, 3)No0No
discount_fee子订单级订单优惠金额NUMERIC(20, 3)No0No
adjust_fee手工调整金额NUMERIC(20, 3)No0No
modified_time最后更新时间INT UNSIGNEDNo
No
status子订单状态|WAIT_BUYER_PAY:等待买家付款;WAIT_SELLER_SEND_GOODS:等待卖家发货,即:买家已付 款;WAIT_BUYER_CONFIRM_GOODS:等待买家确认收货,即:卖家已发货;TRADE_BUYER_SIGNED:买家已签收,货到付 款专用;TRADE_FINISHED:交易成功;TRADE_CLOSED_AFTER_PAY:付款以后,用户退款成功,交易自动关 闭;TRADE_CLOSED_BEFORE_PAY:付款以前,卖家或买家主动关闭交易;VARCHAR(24)YesWAIT_BUYER_PAYNo
aftersales_status售后状态|WAIT_SELLER_AGREE:买家已经申请退款,等待卖家同意;WAIT_BUYER_RETURN_GOODS:卖家已 经同意退款,等待买家退货;WAIT_SELLER_CONFIRM_GOODS:买家已经退货,等待卖家确认收货;SUCCESS:退款成 功;CLOSED:退款关闭;REFUNDING:退款中;SELLER_REFUSE_BUYER:卖家拒绝退 款;SELLER_SEND_GOODS:卖家已发货;VARCHAR(25)No
No
complaints_status订单投诉状态|NOT_COMPLAINTS:买家未进行投诉;WAIT_SYS_AGREE:买家投诉,等待平台处理;FINISHED:处理完成;BUYER_CLOSED:买家撤销投诉;CLOSED:平台关闭投诉,不需要处理直接关闭;VARCHAR(14)NoNOT_COMPLAINTSNo
refund_fee退款金额NUMERIC(20, 3)No0No
buyer_rate买家是否已评价TINYINT(1)No0No
anony是否匿名TINYINT(1)No0No
seller_rate卖家是否已评价TINYINT(1)No0No
cat_service_rate
NUMERIC(20, 3)No0No
order_from订单来源VARCHAR(45)No
No
pic_path商品图片绝对路径VARCHAR(255)No
No
timeout_action_time订单超时到期时间INT UNSIGNEDNo
No
outer_iid商家外部编码VARCHAR(50)No
No
outer_sku_id商家外部sku码VARCHAR(50)No
No
sub_stock是否支持下单减库存TINYINT(1)Yes1No
  • 索引
Key nameColumn namesUniqueComment
primaryoidYes

systrade_order_complaints

订单投诉表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
complaints_id订单投诉IDBIGINT UNSIGNED AUTO_INCREMENTYes
Yes
shop_id被投诉店铺IDBIGINTYes0No
user_id发起投诉用户IDBIGINT UNSIGNEDYes0No
tid投诉订单号BIGINTYes
No
oid投诉子订单号BIGINTYes
No
statusWAIT_SYS_AGREE:等待处理;FINISHED:已完成;BUYER_CLOSED:买家撤销投诉;CLOSED:平台关闭投诉;VARCHAR(14)YesWAIT_SYS_AGREENo
tel
VARCHAR(100)Yes0No
image_url
VARCHAR(1500)No
No
complaints_type
VARCHAR(255)No
No
content
LONGTEXTNo
No
memo
VARCHAR(255)No
No
buyer_close_reasons
VARCHAR(255)No
No
created_time
INT UNSIGNEDNo
No
modified_time
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primarycomplaints_idYes
ind_oidoidYes
ind_tidtidNo
ind_statusstatusNo

systrade_promotion_detail

订单使用的促销信息表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
tid主订单idBIGINT UNSIGNEDYes
No
oid子订单idBIGINT UNSIGNEDYes
No
user_id会员idINT UNSIGNEDYes
No
promotion_id促销规则idINT UNSIGNEDYes
No
item_id商品的IDINT UNSIGNEDNo
No
sku_idsku的IDINT UNSIGNEDNo
No
promotion_type优惠规则类型VARCHAR(30)Yes
No
promotion_tag促销标签VARCHAR(30)No
No
promotion_name促销名称VARCHAR(255)No
No
promotion_desc促销描述LONGTEXTNo
No
  • 索引
Key nameColumn namesUniqueComment
ind_tidtidNo
ind_oidoidNo

systrade_trade

订单主表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
tid
BIGINT UNSIGNEDYes
No
shop_id订单所属的店铺idINT UNSIGNEDYes
No
user_id会员idINT UNSIGNEDYes
No
dlytmpl_id配送模板idINT UNSIGNEDYes
No
ziti_addr自提地址VARCHAR(255)No
No
status订单状态|WAIT_BUYER_PAY:已下单等待付款;WAIT_SELLER_SEND_GOODS:已付款等待发 货;WAIT_BUYER_CONFIRM_GOODS:已发货等待确认收货;TRADE_FINISHED:已完成;TRADE_CLOSED:已关闭 (退款关闭订单);TRADE_CLOSED_BY_SYSTEM:已关闭(卖家或买家主动关闭);VARCHAR(24)Yes
No
cancel_reason
LONGTEXTNo
No
pay_type支付类型|online:线上付款;offline:货到付款;VARCHAR(7)YesonlineNo
payment实付金额,订单最终总额NUMERIC(20, 3)No0No
total_fee各子订单中商品price * num的和,不包括任何优惠信息NUMERIC(20, 3)No0No
post_fee邮费NUMERIC(20, 3)No
No
payed_fee已支付金额NUMERIC(20, 3)No0No
seller_rate卖家是否评价TINYINT(1)No0No
receiver_name收货人姓名VARCHAR(50)No
No
created_time订单创建时间INT UNSIGNEDNo
No
pay_time付款时间INT UNSIGNEDNo
No
consign_time卖家发货时间INT UNSIGNEDNo
No
end_time结束时间INT UNSIGNEDNo
No
modified_time修改时间INT UNSIGNEDNo
No
timeout_action_time超时到期时间INT UNSIGNEDNo
No
send_time订单将在此时间前发出,主要用于预售订单INT UNSIGNEDNo
No
receiver_state收货人所在省份VARCHAR(20)No
No
receiver_city收货人所在城市VARCHAR(20)No
No
receiver_district收货人所在地区VARCHAR(20)No
No
receiver_address收货人详细地址VARCHAR(200)No
No
receiver_zip收货人邮编VARCHAR(20)No
No
receiver_mobile收货人手机号VARCHAR(20)No
No
receiver_phone收货人电话VARCHAR(20)No
No
title交易标题VARCHAR(50)No
No
discount_fee促销优惠金额NUMERIC(20, 3)No0No
consume_point_fee买家使用积分INT UNSIGNEDNo0No
buyer_message买家留言VARCHAR(255)No
No
need_invoice是否需要开票TINYINT(1)No0No
invoice_name发票抬头VARCHAR(100)No
No
invoice_type发票类型VARCHAR(20)No
No
invoice_main发票内容VARCHAR(20)No
No
adjust_fee卖家手工调整金额,子订单调整金额之和NUMERIC(20, 3)No0No
trade_from订单来源|pc:标准平台;wap:手机触屏;weixin:微信商城;VARCHAR(6)NopcNo
itemnum子订单商品购买数量总数INT UNSIGNEDNo0No
shop_flag卖家备注旗帜VARCHAR(20)No
No
shop_memo卖家备注LONGTEXTNo
No
buyer_area买家下单的地区VARCHAR(30)No
No
area_id区域id,代表订单下单的区位码INT UNSIGNEDNo
No
step_trade_status分阶段付款的订单状态|0:定金和尾款都付;1:定金已付尾款未付;2:定金未付尾款未付;VARCHAR(1)No
No
step_paid_fee分阶段付款的已付金额NUMERIC(20, 3)No
No
shipping_type创建交易时的物流方式|free:卖家包邮;post:平邮;express:快递;ems:EMS;virtual:虚拟发货;VARCHAR(7)No
No
obtain_point_fee买家获得积分,返点的积分BIGINTNo
No
trade_memo交易备注LONGTEXTNo
No
buyer_rate买家是否已评价TINYINT(1)No0No
is_part_consign是否是多次发货的订单TINYINT(1)No0No
real_point_fee买家实际使用积分INT UNSIGNEDNo
No
ipIP地址VARCHAR(15)No
No
anony下单选择的是否匿名,子订单将匿名修改该字段不修改,只表示下单的选择TINYINT(1)No0No
is_clearing是否生成结算单TINYINT(1)No0No
disabled是否有效TINYINT(1)Yes0No
ziti_memo自提备注VARCHAR(300)No
No
  • 索引
Key nameColumn namesUniqueComment
primarytidYes
ind_statusstatusNo
ind_user_iduser_idNo
ind_created_timecreated_timeNo

systrade_tradeabnormal

取消异常订单表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
ididBIGINT UNSIGNED AUTO_INCREMENTYes
Yes
tid
BIGINT UNSIGNEDYes
No
reason
VARCHAR(255)No
No
statusWAIT_PROCESSING:等待平台处理;FINISHED:平台已处理;CLOSED:平台已驳回;VARCHAR(15)YesWAIT_PROCESSINGNo
reject_reason
VARCHAR(100)No
No
created_time
INT UNSIGNEDNo
No
modified_time
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryidYes
ind_tidtidNo
ind_created_timecreated_timeNo
ind_statusstatusNo

app:sysuser tables

sysuser_account

商城会员用户表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
user_id用户IDINT UNSIGNED AUTO_INCREMENTYes
Yes
login_account用户名VARCHAR(100)No
No
email邮箱VARCHAR(100)No
No
mobile手机号VARCHAR(32)No
No
login_password登录密码VARCHAR(60)Yes
No
login_type登录类型,信任登录或者普通登录VARCHAR(60)YescommonNo
disabled
TINYINT(1)No0No
createtime创建时间INT UNSIGNEDNo
No
modified_time
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryuser_idYes
ind_login_accountlogin_accountNo

sysuser_shop_fav

收藏店铺表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
snotify_id
INT UNSIGNED AUTO_INCREMENTYes
Yes
shop_id商店IDINT UNSIGNEDYes
No
user_id
INT UNSIGNEDNo
No
shop_name店铺名称VARCHAR(50)Yes
No
shop_logo提交logoVARCHAR(500)No
No
create_time
INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primarysnotify_idYes
ind_shop_idshop_idNo
ind_user_iduser_idNo

sysuser_trustinfo


  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
trust_id信任idINT UNSIGNED AUTO_INCREMENTYes
Yes
user_id会员idINT UNSIGNEDNo
No
user_flag对应信任登陆方的唯一标识VARCHAR(255)Yes
No
  • 索引
Key nameColumn namesUniqueComment
primarytrust_idYes
ind_bind_uniquser_id, user_flagYes

sysuser_user

商店会员表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
user_id
INT UNSIGNEDYes
No
grade_id
INT UNSIGNEDYes1No
name
VARCHAR(50)No
No
username
VARCHAR(50)No
No
point
INT UNSIGNEDYes0No
refer_id
VARCHAR(50)No
No
refer_url
VARCHAR(200)No
No
birthday
INT UNSIGNEDNo
No
sex0:女;1:男;2:-;VARCHAR(1)Yes2No
wedlock婚姻状况TINYINT(1)Yes0No
education教育程度VARCHAR(30)No
No
vocation职业VARCHAR(50)No
No
reg_ip注册时IP地址VARCHAR(16)No
No
regtime注册时间INT UNSIGNEDNo
No
cur货币(偏爱货币)VARCHAR(20)No
No
lang偏好语言VARCHAR(20)No
No
disabled
TINYINT(1)No0No
experience
INT UNSIGNEDNo0No
sourcepc:标准平台;wap:手机触屏;weixin:微信商城;api:API注册;VARCHAR(6)NopcNo
area
VARCHAR(55)No
No
addr
VARCHAR(255)No
No
email_verify
TINYINT(1)No0No
  • 索引
Key nameColumn namesUniqueComment
primaryuser_idYes
ind_regtimeregtimeNo
ind_disableddisabledNo

sysuser_user_addrs

会员地址表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
addr_id会员地址IDINT UNSIGNED AUTO_INCREMENTYes
Yes
user_id会员IDINT UNSIGNEDYes0No
name会员名称VARCHAR(50)No
No
area地区VARCHAR(255)No
No
addr地址VARCHAR(100)No
No
zip邮编VARCHAR(20)No
No
tel电话VARCHAR(50)No
No
mobile手机VARCHAR(50)No
No
def_addr默认地址TINYINT(1)No0No
  • 索引
Key nameColumn namesUniqueComment
primaryaddr_idYes
ind_user_iduser_idNo

sysuser_user_coupon

用户优惠券表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
coupon_code优惠券号码VARCHAR(32)Yes
No
user_id会员IDINT UNSIGNEDYes
No
shop_id店铺IDINT UNSIGNEDYes0No
coupon_id会员优惠券IDINT UNSIGNEDYes0No
obtain_desc领取方式VARCHAR(255)Yes
No
obtain_time优惠券获得时间INT UNSIGNEDNo
No
tid使用该优惠券的订单号BIGINT UNSIGNEDNo
No
is_valid会员优惠券是否当前可用|0:已使用;1:有效;2:过期;VARCHAR(1)Yes1No
used_platform使用平台|0:商家全场可用;1:只能用于pc;2:只能用于wap;VARCHAR(1)Yes0No
  • 索引
Key nameColumn namesUniqueComment
primarycoupon_code, user_id, shop_idYes
ind_tidtidNo

sysuser_user_experience

会员经验值详细记录表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
experience_id
INT UNSIGNED AUTO_INCREMENTYes
Yes
user_id
INT UNSIGNEDNo
No
modified_time记录时间INT UNSIGNEDNo
No
behavior_type行为类型|obtain:获得;consume:消费;VARCHAR(7)NoobtainNo
behavior行为描述VARCHAR(100)No
No
experience成长值BIGINTNo
No
remark备注(记录订单号)VARCHAR(500)No
No
expiration_time经验值过期时间INT UNSIGNEDNo0No
  • 索引
Key nameColumn namesUniqueComment
primaryexperience_idYes
ind_user_iduser_idNo
ind_modified_timemodified_timeNo

sysuser_user_fav

收藏/缺货登记

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
gnotify_id
INT UNSIGNED AUTO_INCREMENTYes
Yes
item_id商品IDINT UNSIGNEDYes
No
user_id
INT UNSIGNEDNo
No
sku_id货品IDINT UNSIGNEDNo
No
cat_id商品类目IDINT UNSIGNEDYes
No
goods_name
VARCHAR(200)No
No
goods_price
NUMERIC(20, 3)No0No
image_default_id
VARCHAR(255)No
No
email邮箱VARCHAR(100)No
No
cellphone
VARCHAR(20)No
No
send_time
INT UNSIGNEDNo
No
create_time
INT UNSIGNEDNo
No
disabled
TINYINT(1)No0No
remark备注LONGTEXTNo0No
object_type收藏的类型,goodsVARCHAR(100)NogoodsNo
  • 索引
Key nameColumn namesUniqueComment
primarygnotify_idYes
ind_item_iditem_idNo
ind_user_iduser_idNo
ind_cat_idcat_idNo

sysuser_user_grade

会员等级表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
grade_id
INT UNSIGNED AUTO_INCREMENTYes
Yes
grade_name
VARCHAR(100)Yes
No
grade_logo会员等级LOGOVARCHAR(255)No
No
experience
INT UNSIGNEDYes0No
default_grade是否默认等级TINYINT(1)Yes0No
validity等级有效期INT UNSIGNEDYes0No
  • 索引
Key nameColumn namesUniqueComment
primarygrade_idYes
ind_experienceexperienceNo

sysuser_user_item_notify

缺货表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
gnotify_id缺货IDINT UNSIGNED AUTO_INCREMENTYes
Yes
shop_id店铺idINT UNSIGNEDYes
No
item_id商品idINT UNSIGNEDYes
No
sku_id货品idINT UNSIGNEDYes
No
email邮箱VARCHAR(32)No
No
createtime创建时间INT UNSIGNEDNo
No
send_time
INT UNSIGNEDNo
No
sendstatus状态|ready:准备发送;send:以发送;VARCHAR(5)NoreadyNo
  • 索引
Key nameColumn namesUniqueComment
primarygnotify_idYes

sysuser_user_point

会员积分值详细记录表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
point_id
INT UNSIGNED AUTO_INCREMENTYes
Yes
user_id
INT UNSIGNEDYes
No
modified_time记录时间INT UNSIGNEDNo
No
behavior_type行为类型|obtain:获得;consume:消费;VARCHAR(7)NoobtainNo
behavior行为描述VARCHAR(100)Yes
No
point积分值BIGINTNo0No
remark备注(记录订单号)VARCHAR(500)No
No
expiration_time积分过期时间INT UNSIGNEDNo0No
  • 索引
Key nameColumn namesUniqueComment
primarypoint_idYes
ind_user_iduser_idNo
ind_modified_timemodified_timeNo
ind_expiration_timeexpiration_timeNo

sysuser_user_pointlog

会员积分值明细表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
pointlog_id
INT UNSIGNED AUTO_INCREMENTYes
Yes
user_id
INT UNSIGNEDYes
No
modified_time记录时间INT UNSIGNEDNo
No
behavior_type行为类型|obtain:获得;consume:消费;VARCHAR(7)NoobtainNo
behavior行为描述VARCHAR(100)Yes
No
point积分值BIGINTNo0No
remark备注(记录订单号)VARCHAR(500)No
No
expiration_time积分过期时间INT UNSIGNEDNo0No
  • 索引
Key nameColumn namesUniqueComment
primarypointlog_idYes
ind_user_iduser_idNo
ind_modified_timemodified_timeNo
ind_expiration_timeexpiration_timeNo

sysuser_user_points

会员积分表

  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
user_id
INT UNSIGNEDYes
No
point_count会员总积分值BIGINTNo0No
expired_point将要过期积分BIGINTNo0No
modified_time记录时间INT UNSIGNEDNo
No
  • 索引
Key nameColumn namesUniqueComment
primaryuser_idYes
ind_modified_timemodified_timeNo

sysuser_user_trade_count


  • 表结构
ColumnNameCommentTypeNot nullDefaultAutoincrement
user_id会员idINT UNSIGNEDNo
No
unpay未支付订单数量INT UNSIGNEDNo
No
undelivery未发货订单数量INT UNSIGNEDNo
No
unreceived未确认收货订单数量INT UNSIGNEDNo
No
unrate未评论订单INT UNSIGNEDNo
No


(责任编辑:admin)
标签:EcStoreB2B2C数据库词典
上一篇:Ecstore2.0数据库词典 下一篇:ShopEx安装失败ShopexID登陆接口不通问题解决!