wxmall数据库结构说明；微信小程序商城

数据库表结构说明文档

数据库表结构说明文档

点步科技

Wxmall 官网：

hp://www.dbumama.com

目录

 

 

 

 

 

 

 

 

  

 !"

 !"

# !"

 !

% !

%& !

% !

% !

 !

$ !

 !

数据库表结构说明文档

 !

 !

& !

(  

(  

 

  

  

$ 

 

 

 

 

 

 

(  

(  "

 "

t_agent

描述：分销代理表，三级代理

序号 字段名称 字段描述 字段类型 长度 允许空 缺省值

数据库表结构说明文档

t_agent_aduit_log

描述：

序号 字段名称 字段描述 字段类型 长度 允许空 缺省值

t_agent_commission

描述：分销商佣金记录表，每次有当前分销商的分销订单的时候，根据佣金比率计算的所得佣金

存放在此表

序号 字段名称 字段描述 字段类型 长度 允许空 缺省值

累计获得的总佣金

删除标记

创建日期

最后修改日期

数据库表结构说明文档

t_agent_rank

等级权重，值越大权重越大

一级佣金占比

二级佣金占比

三级佣金占比

升到此等级奖励金额

条件）

累 计 获 取 佣 金 （ 自 动 升 级 条

最后修改日期

t_area

描述：地区

序号 字段名称 字段描述 字段类型 长度 允许空 缺省值

主键_id

全称

最后修改日期

删除标记

数据库表结构说明文档

序号 字段名称 字段描述 字段类型 长度 允许空 缺省值