{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["用户中心","商品模块","订单中心","资源中心"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":158,"n_cols":4,"rows_kept":158,"cut":false,"hidden":false,"merged":[]}
["账户表"]
["字段名","字段","数据类型","备注"]
["自增Id","id","int(11)"]
["账号类型（企业账号/个人账号）","accountType","varchar(10)"]
["账号主体（企业标识/人员标识）","bodyId","int(11)"]
["是否开通1开通0未开通","isOpend","tinyint(1)"]
["创建时间","timestamp","datetime"]
["有效状态(0-禁用，1-启用)","state","tinyint(1)"]
["APPID","appId","varchar(50)"]
[]
["账户信息表"]
["字段名","字段","数据类型","备注"]
["自增Id","id","int(11)"]
["人员标识","employeeId","int(11)"]
["账号","userName","varchar(20)"]
["手机号","phone","varchar(11)"]
["密码","password","varchar(100)"]
["微信openId","openId","tinyint(1)"]
["是否有效","state","varchar(50)"]
["邮箱","mailbox","varchar(255)"]
[]
["认证记录表"]
["字段名","字段","数据类型","备注"]
["自增Id","id","int(11)"]
["认证主体ID(company_id或者employee_id)","authBodyId","int(11)"]
["认证主体类型(0-公司,1-人员)","authBodyType","tinyint(1)"]
["认证方式(0-支付宝,1-微信,2-公安,3-银行卡)","authWay","tinyint(1)"]
["认证结果（1-通过，0-不通过）","authResult","tinyint(1)"]
["认证时间","authTime","datetime"]
["备注","memo","varchar(255)"]
[]
["字段名","字段","数据类型","备注"]
["自增Id","id","int(11)"]
["人员标识","userId","varchar(50)"]
["企业标识","companyId","int(11)"]
["组织标识","departmentId","int(11)"]
["人员类型（管理员/组织管理员/普通员工）","employeeType","varchar(10)"]
["授权人标识","authPerson","int(11)"]
["是否有效1有效0无效","state","tinyint(1)"]
["是否冻结1冻结0未冻结","frozen","tinyint(1)"]
["截止时间","endTime","datatime"]
["资源类型","resourceType","varchar(255)"]
["数量","number","int(11)"]
["企业用户标识","accountId","varchar(50)"]
[]
["用户表"]
["字段名","字段","数据类型","备注"]
["自增Id","id","int(11)"]
["姓名","name","varchar(20)"]
["性别1男0女","sex","tinyint(1)"]
["手机号","phone","varchar(11)"]
["年龄","age","int(11)"]
["公司状态(0-禁用，1-启用)","state","tinyint(1)"]
["认证状态(0-未认证,1-已认证)","authState","tinyint(1)"]
["创建时间","createAt","datetime"]
["修改时间","updateAt","datetime"]
["删除时间","deleteAt","datetime"]
[]
["企业-用户帐户表"]
["字段名","字段","数据类型","备注"]
["自增ID","id","int(11)"]
["人员标识","employeeId","int(11)"]
["组织标识","departmentId","int(11)"]
["企业标识","companyId","int(11)"]
["创建时间","timestamp","datetime"]
["是否审核1是0否","isAuth","tinyint(1)"]
["是否有效1有效0无效","state","tinyint(1)"]
["人员类型（管理员/组织管理员/普通员工）","employeeType","varchar(10)"]
[]
["企业表"]
["字段名","字段","数据类型","备注"]
["自增Id","id","int(11)"]
["公司名称","name","varchar(20)"]
["公司简称","shortName","varchar(20)"]
["地址","address","varchar(255)"]
["联系人","contactPerson","varchar(20)"]
["联系人手机号","contactPhone","varchar(11)"]
["公司状态(0-禁用，1-启用)","state","tinyint(1)"]
["认证状态(0-未认证,1-已认证)","authState","tinyint(1)"]
["创建时间","createAt","datetime"]
["修改时间","updateAt","datetime"]
["删除时间","deleteAt","datetime"]
["行业","industry","varchar(10)"]
["企业类型","comPanyType","varchar(10)"]
["统一社会信用代码","creditCode","varchar(20)"]
["法人姓名","legalPerson","varchar(20)"]
[]
["部门表"]
["字段名","字段","数据类型","备注"]
["自增Id","id","int(11)"]
["部门名称","name","varchar(20)"]
["部门简称","shortName","varchar(20)"]
["部门联系人","contactPerson","varchar(20)"]
["部门联系人手机号","contactPhone","varchar(11)"]
["状态(0-禁用，1-启用)","state","tinyint(1)"]
["企业信息ID","companyId","int(11)"]
["上级部门ID","parentId","int(11)"]
["创建时间","createAt","datetime"]
["修改时间","updateAt","datetime"]
["删除时间","deleteAt","datetime"]
[]
["部门-人员关联表"]
["字段名","字段","数据类型","备注"]
["自增ID","id","int(11)"]
["人员标识","employeeId","int(11)"]
["组织标识","departmentId","int(11)"]
["企业标识","companyId","int(11)"]
["创建时间","timestamp","datetime"]
["是否有效1有效0无效","state","tinyint(1)"]
["是否审核1是0否","isAuth","tinyint(1)"]
["人员类型（管理员/组织管理员/普通员工）","employeeType","varchar(10)"]
[]
["认证表"]
["字段名","字段","数据类型","备注"]
["自增ID","id","int(11)"]
["人员标识","employeeId","int(11)"]
["企业标识","companyId","int(11)"]
["组织标识","departmentId","int(11)"]
["人员类型（管理员/组织管理员/普通员工）","employeeType","varchar(10)"]
["授权人标识","authPerson","int(11)"]
["是否有效1有效0无效","state","tinyint(1)"]
["是否冻结1冻结0未冻结","frozen","tinyint(1)"]
[]
["权益表(moduleService)"]
["字段名","字段","数据类型","备注"]
["自增ID","id","int(11)"]
["用户标识","userId","varchar(50)"]
["功能代码","moduleCode","varchar(100)"]
["商品代码","productCode","varchar(100)"]
["截止时间","endTime","datetime"]
["是否有效0无效1有效","state","tinyint(2)"]
["开始时间","startTime","datetime"]
[]
["账号与资源对应关系表(account_resources)"]
["字段名","字段","数据类型","备注"]
["自增Id","id","int(11)"]
["企业标识","companyId","int(11)"]
["组织标识","departmentId","int(11)"]
["资源名称","name","varchar(50)"]
["数量","number","int(11)"]
["资源代码","resourceType","varchar(100)"]
["规格","spec","varchar(10)"]
["APPID","appId","varchar(50)"]
["账户标识","accountId","varchar(50)"]
["截止时间","endTime","varchar(20)"]
["0无效1有效","state","tinyint(2)"]
[]
["资源包授权表(resources_authorization)"]
["字段名","字段","数据类型","备注"]
["自增Id","id","int(11)"]
["人员标识","userId","varchar(255)"]
["公司标识","companyId","int(11)"]
["部门标识","departmentId","int(11)"]
["资源标识","resourceId","int(11)"]
["定额","quota","int(11)"]
["比例","ratio","int(11)"]
["是否有效1有效0无效","state","tinyint(1)"]
["账户标识","accountId","varchar(255)"]

{"sheet":"商品模块","index":1,"n_rows":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["商品表","base_product",{"$nulls":5},"原有产品表"]
["字段名","字段","数据类型","备注"]
["id","id","int(10)"]
["商品名称","productName","varchar(255)","SKU,7天全国全行业超级订阅、月付1个省、季付1个省"]
["商品编号","productCode","varchar(255)"]
["pc端落地页","pcPage","varchar(255)"]
["wx端落地页","wxPage","varchar(255)"]
["app端落地页","appPage","varchar(255)"]
["产品描述","describe","varchar(255)"]
["产品图文","richText","varchar(65536)"]
["产品logo","logo","varchar(255)"]
["标签","tag","varchar(40)","如课程，同一个老师可以打上标签/类别"]
["商品版本号","productVersion",null,"商品版本号"]
["更新时间","updateTime"]
["更新管理员","updateBy"]
[null,null,null,"注：商品大致分三类\n课程、文库类似电商商品，购买完永久使用，商品管理还沿用以前逻辑，购买走新架构\n积分、数据导出、接口调用是按数量计费/扣减商品\n超级订阅、商机管理等是组合功能，按周期、额度等计费"]
[]
["商品规格表","base_productSpecs"]
["字段名","字段","数据类型","备注"]
["id","id","int(10)"]
["规格名称","specsName","varchar(255)"]
["规格代码","specsCode","varchar(255)"]
["商品代码","productCode","varchar(255)"]
["商品原价","originPrice","int(11)","原价，仅用来显示"]
["商品实际价","price","int(11)","使用这个价格"]
["剑鱼币兑换价格","coinExchange","int(11)","兑换价格 0 不支持兑换  "]
["默认有效时长","validDate","varchar(40)","7d,1m,3m,1y,-1=永久,-2=自定义周期(接口传递时间和价格、不用于前台销售)"]
["是否支持授权/份数","isLiscence","tinyint","0不支持 1支持计价相乘( 商机管理人数、超级订阅省份数、积分、数据导出)  2使用价格规则"]
["多份购买时价格规则","priceMode","varchar","F份数  P总价//f份数 z总价折扣  p单价  a总价 , \"\" 忽略   \"F,>,15,a,599\""]
["续期策略","renewMode","tinyint","0 不支持  1支持,计费走通用逻辑、时间延长  2计费走定制模式"]
["最大续期时间","maxRenewDate","varchar","\"36m\"  最多续期36个月"]
["周期内升级份数策略","upgradeMode","tinyint","0 不支持  1支持,计费走通用逻辑、时间延长  2计费走定制模式"]
["最大份数","maxLiscence","int","省最大34，导出最多2万条等"]
["规格版本号","specsVersion","varchar(20)"]
["备注","memo","varchar(4096)"]
["更新时间","updateTime"]
["更新管理员","updateBy"]
[]
["功能表：仅逻辑判断等使用","base_module"]
["字段名","字段","数据类型","备注"]
["id","id","int(10)"]
["功能名称","moduleName","varchar(255)","功能名称"]
["功能代码","moduleCode","varchar(255)","功能代码"]
["备注","memo","varchar(5000)"]
[]
["商品功能规格表：具体的功能","base_moduleSpecs"]
["字段名","字段","数据类型","备注"]
["id","id","int(10)","生成权益时，记录此id"]
["权益名称","rightName","varchar(255)"]
["功能代码","moduleCode","varchar(255)","和功能表关联用于标识是企业画像、预测等不同模块"]
["功能使用规则","rightRule","tinyint","1 只检查权益  2 只检查资源  3二者都检查   给用户生成对应表时使用"]
["资源限额","quota","int(10)","购买的数据条数、省份数，大会员每日导出限额等"]
["购买时资源限额计算规则","quotaCreateRule","tinyint","0无  1相乘  2自定义(后续考虑插件)"]
["资源限额上限","maxQuota","int(10)","生成时限额最大上限"]
["限额使用规则","quotaRule","tinyint","0 无规则/由功能控制  1直接扣减"]
["最后修改时间","updateTime","datetime"]
["修改人","updateby","varchar(32)"]
["备注","memo","varchar(4096)","备注"]
[]
["商品规格权益关联表","base_productModuleSpecs"]
["字段名","字段","数据类型","备注"]
["id","id","int(10)"]
["产品规格id","specsId","int(10)"]
["功能规格id","rightId","int(10)"]
[]
[]
["商品快照表 - 同上"]
["商品规格快照表 - 同上"]
["商品权益快照表 - 同上"]
["商品规格权益关联快照表+版本号"]

{"sheet":"订单中心","index":2,"n_rows":150,"n_cols":4,"rows_kept":150,"cut":false,"hidden":false,"merged":[]}
["订单表"]
["订单商品表"]
["合同表 "]
["回款记录表 "]
["销售记录表"]
["支付信息表"]
["退款记录表 "]
["发票申请表"]
["发票表 "]
[]
["订单表（order）"]
["字段名","字段","数据类型"]
["自增id","id","int(11)"]
["订单编号","order_code","varchar(255)"]
["实付金额（订单实际金额=实收金额），精确到分","order_money","int(11)"]
["原价（优惠前总价），精确到分","original_price","int(11)"]
["创建时间","create_time","datetime"]
["修改时间","update_time","datetime"]
["预订单生成时间","prepay_time","datetime"]
["预支付交易会话标识","prepay_id","varchar(255)"]
["商户订单号","out_trade_no","varchar(255)"]
["二维码地址","code_url","varchar(2500)"]
["支付状态 （0:未支付 1:已支付  2：部分支付 3:已取消 ）","order_status","int(10)"]
["用户手机号","user_phone","varchar(255)"]
["用户id","user_id","varchar(255)"]
["用户邮箱","user_mail","varchar(255)"]
["公司标识（跟用户中心企业/组织标识关联）","company_name","varchar(255)"]
["删除状态（0：未删除; 1:已删除）","del_status","int(1)"]
["删除时间","del_time","datetime"]
["退款状态（1-全额退款   2-部分退款  0-未退）","refund_status","int(1)"]
["付费类型（0-试用、1-续费、2-升级、3-赠送、4-购买）","payment_type","int(11)"]
["订单来源标识：0-线下销售服务开通、1-线上用户订单补录、2-线上用户自助购买","source_order_id","int(11)"]
["分销口令","dis_word","varchar(255)"]
["","remind_status","tinyint(4)"]
[]
["订单商品明细表（order_commodity）"]
["字段名","字段","数据类型"]
["自增id","id","int(11)"]
["订单编号","order_code","varchar(255)"]
["商品代码","product_code","varchar(255)"]
["商品规格代码","product_specs_code","text"]
["数量","quantity","int(11)"]
["单价","unitPrice","int(11)"]
["合计","total","int(11)"]
[]
["支付（回款）信息表（pay_ment）"]
["字段名","字段","数据类型"]
["自增id","id","int(11)"]
["订单编号","order_code","varchar(255)"]
["支付时间","pay_time","datetime"]
["支付方式","pay_way","varchar(255)"]
["支付金额，精确到分","pay_money","int(11)"]
["支付单号","pay_code","varchar(255)"]
["支付凭证地址","pay_voucher_url","varchar(255)"]
["付款账号","pay_account","varchar(255)"]
["付款名称","pay_name","varchar(255)"]
["收款账号","collect_account","varchar(255)"]
["收款名称","collect_name","varchar(255)"]
["操作人","operate_person","varchar(255)"]
["操作时间","operate_time","datetime"]
["备注","remarks","varchar(255)"]
[]
[]
[]
["订单业务表（展示订单列表和一次性付费功能用）（order_business）"]
["字段名","字段","数据类型"]
["自增id","id","int(11)"]
["订单编号","order_code","varchar(255)"]
["服务状态，1已提供服务及已经下载，0未服务","service_status","int(10)"]
["服务时间","service_time","datetime"]
["筛选条件","filter","mediumtext"]
["筛选条件，所有的关键词","filter_keys","mediumtext"]
["筛选条件，发布时间","filter_publishtime","varchar(255)"]
["匹配到的数据总数","data_count","int(11)"]
["过滤条件在mongodb中的id","filter_id","varchar(255)"]
["下载链接","download_url","varchar(255)"]
["商品代码","product_code","varchar(255)"]
["商品规格代码","specsCode"," varchar(255)"]
[]
["合同表（contract_new）"]
["字段名","字段","数据类型"]
["自增id","id","int(11)"]
["订单编号","order_code","varchar(255)"]
["客户名称","customer_name","varchar(255)"]
["协议编号","contract_code","varchar(255)"]
["协议签订时间","contract_time","datetime"]
["协议状态 1-已签协议 0-未签协议","contract_status","int(1)"]
["合同金额 单位：分","contract_money","int(11)"]
["合同文件地址","contract_file_url","varchar(255)"]
["合同生效时间","effect_time","datetime"]
["合同到期时间","expire_time","datetime"]
["乙方公司名称","company_name","varchar(255)"]
["甲方对接人","party_a_docking","varchar(255)"]
["乙方对接人","party_b_docking","varchar(255)"]
["备注信息","remarks","varchar(255)"]
["录入人","enter_person","varchar(255)"]
["录入时间","enter_time","datetime"]
[]
[]
["退款记录表（refund_record_new）"]
["字段名","字段","数据类型"]
["自增id","id","int(11)"]
["订单编号","order_code","varchar(255)"]
["退款时间","refund_time","datetime"]
["退款金额，单位：分","refund_money","int(11)"]
["退款原因","refund_reason","varchar(255)"]
["操作人","operate_person","varchar(255)"]
["退款渠道","refund_channel","varchar(255)","增加"]
[]
["发票表（invoice_new）"]
["字段名","字段","数据类型"]
["自增id","id","int(11)"]
["订单号","order_code","varchar(255)"]
["支付标识","pay_code","varchar(255)"]
["发票代码","invoice_code","varchar(255)"]
["发票号码","invoice_number","varchar(255)"]
["纳税人识别号","taxpayer_identnum","varchar(255)"]
["公司名称","company_name","varchar(255)"]
["手机号","phone","varchar(255)"]
["邮箱","mail","varchar(255)"]
["发票类型","invoice_type","varchar(255)"]
["发票内容","invoice_content","varchar(255)"]
["发票地址","url","varchar(255)"]
["开票状态；-1：失败，0：开票中，1：成功 2:退票中 3:已冲红（退票成功）,4:退票失败，5:已换票","invoice_status","int(11)"]
["红票信息","red","text"]
["流水号","invoice_serialnum","varchar(255)"]
["创建时间","create_time","int(10)"]
["开票时间","billing_time","int(10)"]
["用户id","user_id","varchar(255)"]
["操作人","operator","varchar(255)"]
["操作时间","operable_time","datetime"]
[]
["开票日志（invoice_log）"]
["字段名","字段","数据类型"]
["自增id","id","int(11)"]
["订单号","order_code","varchar(255)"]
["支付标识","pay_code","varchar(255)"]
[]
[]
[]
[]
[]
["销售记录表（sales_record）"]
["字段名","字段","数据类型"]
["自增id","id","int(11)"]
["订单编号","order_code","varchar(255)"]
["销售人员","salesperson","varchar(255)"]
["销售时间","sale_time","datetime"]
["操作人","operator","varchar(255)"]
["操作时间","operable_time","datetime"]

{"sheet":"资源中心","index":3,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["企业-用户资源表"]
["字段名","字段","数据类型","备注"]
[null,"id","int(11)"]
["企业标识","companyId","int(11)"]
["组织标识","departmentId","int(11)"]
["资源名称","name","varchar(50)"]
["数量","number","int(11)"]
["资源代码","resourceType","varchar(100)"]
["规格","spec","varchar(10)"]
["APPID","appId","varchar(50)"]
["账户标识","accountId","varchar(50)"]
["截止时间","endTime","varchar(20)"]
[]
["资源充值/消耗明细表"]
["字段名","字段","数据类型","备注"]
[null,"id","int(11)"]
["人员标识","userId","varchar(255)"]
["账户标识","accountId","varchar(50)"]
["企业标识","companyId","int(11)"]
["组织标识","departmentId","int(11)"]
["资源名称","name","varchar(50)"]
["资源类型","resourceType","varchar(100)"]
["导出数量/购买数量","number","int(11)"]
["扣除数量","deductionNumb","int(10)"]
["使用规则","ruleId","text"]
["导出时间/购买时间","createTime","timestamp"]
["流水类型0使用1新增","userType","tinyint(2)"]
["备注","remarks","text"]