{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["菜单","管理员","角色","角色权限","操作日志","操作日志详细信息","用户表","门店表","门店粉丝表","红包广告分类","红包广告","红包充值方案","观看、收藏、领取记录","关系","用户收支明细","店主收支明细","分享","提现","充值方案","基础设置"],"not_rendered":{"charts":0,"images":20,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"菜单","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2],[0,3,1,4]]}
["表名","菜单"]
["tableName","Sys_Menu"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["menuSn","菜单Sn","varchar(100)"]
["menuUrl","链接地址","varchar(250)"]
["menuName","链接名称","varchar(100)"]
["sort","排序","int"]
["parentSn","父菜单Sn","varchar(100)"]
["buttonIds","按钮","varchar(100)"]
["isShow","是否在菜单显示","int"]

{"sheet":"管理员","index":1,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,1,4],[1,1,1,2]]}
["表名","管理员"]
["tableName","Sys_Admin"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["adminName","管理员名称","varchar(200)"]
["password","密码","varchar(200)"]
["roleId","权限Id","int"]

{"sheet":"角色","index":2,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2],[0,3,1,4]]}
["表名","角色"]
["tableName","Sys_Role"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["roleName","角色名称","varchar(50)"]
["description","描述","varchar(MAX)"]

{"sheet":"角色权限","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2],[0,3,1,4]]}
["表名","角色权限"]
["tableName","Sys_Permission"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["roleId","角色Id","int"]
["menuSn","菜单Sn","varchar(100)"]
["menuName","菜单名称","varchar(100)"]
["menuUrl","菜单地址","varchar(100)"]
["sort","排序","int"]
["parentSn","父sn","varchar(100)"]
["buttonIds","功能按钮","varchar(100)","集合"]

{"sheet":"操作日志","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2],[0,3,1,4]]}
["表名","操作日志"]
["tableName","Sys_OperLog"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["operatorId","操作人Id","int"]
["page","操作页面","varchar(Max)"]
["tableName","表名","varchar(200)"]
["pageName","操作业务名称","varchar(200)"]
["operatorDateTime","操作时间","varchar(20)"]
["type","操作类型","int","枚举"]

{"sheet":"操作日志详细信息","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2],[0,3,1,4]]}
["表名","操作日志详细信息"]
["tableName","Sys_OperLogDtl"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["operLogId","日志Id","int"]
["clmName","字段名","varchar(50)"]
["clmContent","字段描述","varchar(200)"]
["oldValue","旧值","varchar(Max)"]
["newValue","新值","varchar(Max)"]

{"sheet":"用户表","index":6,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,1,4],[1,1,1,2]]}
["表名","用户表"]
["tableName","User_Users"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["tcNO","摊财编号","varchar(20)"]
["openId","微信openId","varchar(MAX)"]
["headPic","头像","varchar(MAX)"]
["nickName","昵称","varchar(MAX)"]
["sex","性别","int"]
["phone","手机号码","varchar(20)"]
["name","姓名","varchar(50)"]
["country","国家","varchar(200)"]
["prov","省","varchar(200)"]
["city","市","varchar(200)"]
["email","邮件","varchar(100)"]
["balance","余额","decimal(18,3)"]
["sharePic","分享海报","varchar(MAX)"]
["state","状态","int","10：正常 20：拉黑"]
["insDateTime","注册时间","varchar(20)"]

{"sheet":"门店表","index":7,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,1,4],[1,1,1,2]]}
["表名","门店表"]
["tableName","Shop_Shop"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["userId","用户Id","int"]
["shopNO","门店摊财编号","varchar(20)"]
["shopName","店铺名称","varchar(MAX)"]
["shopLogo","店铺logo","varchar(MAX)"]
["shopDetail","店铺详细介绍","varchar(MAX)"]
["viewCount","曝光量","int"]
["fansCount","粉丝量","int"]
["collocationCount","收藏量","int"]
["seeCount","浏览量","int"]
["balance","余额","decimal(18,3)"]
["state","状态","int","10：审核中 20：驳回 30：正常 40：禁用 50：拉黑"]
["insDateTime","注册时间","varchar(20)"]

{"sheet":"门店粉丝表","index":8,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,1,4],[1,1,1,2]]}
["表名","门店粉丝表"]
["tableName","Shop_Fans"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["shopId","门店Id","int"]
["userId","用户Id","int"]
["isDelete","是否删除","int","1：是 2：否"]
["insDateTime","注册时间","varchar(20)"]

{"sheet":"红包广告分类","index":9,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,1,4],[1,1,1,2]]}
["表名","红包广告分类"]
["tableName","AD_Type"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["typeName","分类名称","varchar(MAX)"]
["sort","排序","int"]
["isView","是否显示","int","1：是 2：否"]
["isDelete","是否删除","int","1：是 2：否"]
["insDateTime","插入时间","varchar(20)"]

{"sheet":"红包广告","index":10,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,1,4],[1,1,1,2]]}
["表名","红包广告"]
["tableName","Shop_AD"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["userId","用户Id","int"]
["shopId","门店Id","int"]
["adTypeId","分类Id","int"]
["adTitle","广告标题","varchar(MAX)"]
["detail1","红包介绍1","varchar(MAX)"]
["pics","图片","varchar(MAX)"]
["video","视频","varchar(MAX)"]
["detail2","红包介绍2","varchar(MAX)"]
["viewCount","曝光量","int"]
["receiveCount","领取红包量","int"]
["collocationCount","收藏量","int"]
["seeCount","浏览量","int"]
["state","状态","int","10：待审核 20：上架 30：下架 40：驳回"]
["insDateTime","插入时间","varchar(20)"]

{"sheet":"红包充值方案","index":11,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,1,4],[1,1,1,2]]}
["表名","红包充值方案"]
["tableName","AD_RechargePlan"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["shopId","门店Id","int"]
["adId","用户Id","int"]
["rpId","充值方案Id","int"]
["amount","金额","decimal(18,2)"]
["seconds","秒数","int"]
["number","次数","int"]
["consumeAmount","消耗金额","decimal(18,2)"]
["consumeSeconds","消耗秒数","int"]
["state","状态","int","10：使用中 20：已使用"]
["insDateTime","插入时间","varchar(20)"]

{"sheet":"观看、收藏、领取记录","index":12,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,1,4],[1,1,1,2]]}
["表名","观看、收藏、领取记录"]
["tableName","AD_Records"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["userId","用户Id","int"]
["shopId","门店Id","int"]
["adId","广告Id","int"]
["typeId","类型","int","10：足迹 20：收藏 30：领取"]
["amount","金额","decimal(18,2)"]
["isDelete","是否删除","int","1：是 2：否"]
["insDateTime","插入时间","varchar(20)"]

{"sheet":"关系","index":13,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,1,4],[1,1,1,2]]}
["表名","关系"]
["tableName","User_Rela"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["userId","用户Id","int"]
["openId","openId","varchar(MAX)"]
["lUserId","下级用户Id","int"]
["lOpenId","下级openId","varchar(MAX)"]
["insDateTime","插入时间","varchar(20)"]

{"sheet":"用户收支明细","index":14,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,1,4],[1,1,1,2]]}
["表名","用户收支明细"]
["tableName","User_InOutDetail"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["userId","用户Id","int"]
["amount","金额","decimal(18,2)"]
["tranType","交易类型","int","10：观看 20：分享 30：推广 40：提现 50：提现驳回"]
["description","描述","varchar(MAX)"]
["insDateTime","插入时间","varchar(20)"]

{"sheet":"店主收支明细","index":15,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,1,4],[1,1,1,2]]}
["表名","店主收支明细"]
["tableName","Shop_InOutDetail"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["shopId","门店Id","int"]
["amount","金额","decimal(18,2)"]
["tranType","交易类型","int","10：充值 20：广告充值 30：广告支出 40：未消费返还 50：反向充值"]
["insDateTime","插入时间","varchar(20)"]

{"sheet":"分享","index":16,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,1,4],[1,1,1,2]]}
["表名","分享"]
["tableName","User_Share"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["userId","用户Id","int"]
["openId","用户openId","varchar(MAX)"]
["lUserId","被分享用户Id","int"]
["lOpenId","被分享用户openId","varchar(MAX)"]
["shareType","分享类型","int","10：店铺 20：广告"]
["adId","广告Id","int"]
["shopId","店铺Id","int"]
["insDateTime","插入时间","varchar(20)"]

{"sheet":"提现","index":17,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,1,4],[1,1,1,2]]}
["表名","提现"]
["tableName","User_With"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["userId","用户Id","int"]
["openId","用户openId","varchar(MAX)"]
["amount","金额","decimal(18,2)"]
["state","状态","int","10：审核中 20：通过 30：驳回"]
["reason","驳回理由","varchar(MAX)"]
["insDateTime","插入时间","varchar(20)"]
["passDateTime","通过时间","varchar(20)"]

{"sheet":"充值方案","index":18,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,1,4],[1,1,1,2]]}
["表名","充值方案"]
["tableName","Sys_RechargePlan"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["rpName","充值方案名称","varchar(MAX)"]
["amount","金额","decimal(18,2)"]
["seconds","秒数","int"]
["num","次数","int"]
["isView","是否显示","int","1：是 2：否"]
["sort","排序","int"]
["isDelete","是否删除","int","1：是 2：否"]
["insDateTime","插入时间","varchar(20)"]

{"sheet":"基础设置","index":19,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,1,4],[1,1,1,2]]}
["表名","基础设置"]
["tableName","Sys_BaseSet"]
["字段名","对应的中文名","数据类型","备注","引用"]
["id","ID","int"]
["maxPacketCount","每日红包上限","int"]
["seePercent","观看分佣百分比","int"]
["sharePercent","分享分佣百分比","int"]
["recommendPercent","推荐分佣百分比","int"]
["minWithAmount","最低提现金额","int"]
["withFeePrecrnt","提现手续费百分比","int"]
["recommendFrozenDays","推广佣金冻结天数","int"]
["defaultShopLogo","门店默认头像","varchar(MAX)"]