{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["目录索引","设备基本信息表","商品设备关联表","商品类目表","商品表","订单表","订单详情表"],"not_rendered":{"charts":0,"images":0,"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":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,0,25,0],[26,0,28,0],[29,0,31,0],[32,0,34,0],[35,0,37,0],[38,0,40,0],[41,0,43,0],[44,0,46,0],[47,0,49,0],[50,0,52,0],[53,0,55,0],[56,0,58,0],[59,0,61,0],[62,0,64,0],[65,0,67,0],[68,0,70,0],[71,0,73,0],[1,4,25,4],[26,4,50,4],[51,4,75,4],[76,4,100,4]]}
["表属性","数据库表名","数据库表说明","是否建分区表","所属数据库","备注说明"]
[null,"VM_EQUIPMENT_INF","设备基本信息表"]
[null,"VM_PRO_EQU_REL","商品设备关联表"]
[null,"VM_CATEGORY_INF","商品类目表"]
[null,"VM_PRODUCT_INF","商品表"]
[null,"VM_ORDER_INF","订单表"]
[null,"VM_ORDER_DETAILS","订单详情表"]

{"sheet":"设备基本信息表","index":1,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,6],[1,7,1,11],[2,6,2,10],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,11,3,11]]}
["返回首页"]
["中文表名","设备基本信息表",null,null,"英文表名",null,null,"VM_EQUIPMENT_INF"]
["序号","字段名","字段描述","数据类型","必填项","默认值","索引",{"$nulls":4},"备注说明"]
[{"$nulls":6},"唯一","普通","普通","普通","普通"]
[1,"VEQ_ID","ID","varchar(20)      ","M",null,"①"]
[2,"VEQ_CHANNEL","渠道（V01:自助售货机）","varchar(3)      ","M",{"$nulls":6},"渠道（V01:自助售货机）"]
[3,"VEQ_NAME","设备名称","varcha(100)      ","M"]
[4,"VEQ_IOT_SERVICE_PROVIDER","物联服务商","varchar(20)   ","O"]
[5,"VEQ_IOT_CARD_NUMBER","物联卡号","varchar(20)   ","O"]
[6,"VEQ_VERSION_TYPE","版本类型(00:直接购买,01:幸运购,02:游戏购,03:10倍,04:7件商品,05参与分配(超级彩蛋))","varchar(2)   ","O","00",{"$nulls":5},"版本类型(00:直接购买,01:幸运购,02:游戏购,03:10倍,04:7件商品,05参与分配(超级彩蛋))"]
[7,"VEQ_ADDRESS","机器地址","varcha(300)   ","O"]
[8,"VEQ_EQU_TYPE","机器类型（EQU_TYEP：00：支付盒子售货机，01：支付盒子存货机 02：便携式售货机）","varchar(2)   ","O",{"$nulls":6},"机器类型（EQU_TYEP：00：支付盒子售货机，01：支付盒子存货机 02：便携式售货机）"]
[9,"VEQ_EQU_IMG","机器图片","varcha(512)   ","O"]
[10,"VEQ_WC_ACCOUNT","微信公众号","varchar(32)   ","O"]
[11,"VEQ_ZFB_ACCOUNT","支付宝账号","varchar(32)   ","O"]
[12,"VEQ_CHARGE","手续费","varchar(10)   ","O"]
[13,"VEQ_CREDIT_CHANNEL","收款通道","varcha(512)   ","O"]
[14,"VEQ_PAYEE_NO","收款机构号/商户号","varchar(32)   ","O"]
[15,"VEQ_PAYMENT","支付金额","varchar(10)   ","O"]
[16,"VEQ_PAYMENT_TYPE","支付金额类型(00随机 01固定)","varchar(2)   ","O"]
[17,"VEQ_BACKGROUND_ONE","游戏背景图1","varcha(512)   ","O"]
[18,"VEQ_BACKGROUND_TWO","游戏背景图2","varcha(512)   ","O"]
[19,"VEQ_EXCHANGE_RATE","汇率","varchar(10)   ","O"]
[20,"VEQ_SUPPORT_BALANCE","是否支持余额(00支持01不支持)","varchar(2)   ","O","01",{"$nulls":5},"是否支持余额(00支持01不支持)"]
[21,"VEQ_REMARKS","备注","varcha(300)   ","O"]
[null,"VEQ_CREATE_USER","创建人","varchar(20)   "]
[22,"VEQ_CREATE_TIME","创建时间","varchar(14)   ","O"]
[23,"VEQ_MODIFY_USER","最后修改人","varchar(20)   ","O"]
[24,"VEQ_MODIFY_TIME","最后修改时间","varchar(14)   ","O"]
[25,"VEQ_IMEI_ADDR","设备IMEI","varchar(50)   ","O"]
[26,"VEQ_HEART_RATES","设备心跳次数","varchar(50)   "]
[27,"VEQ_STATE","运行状态","varchar(2)   ",null,"01",{"$nulls":5},"运行状态:00正常01离线02检修03销毁"]
[28,"VEQ_MACHINE_NO","设备编号","varchar(32)   "]
[29,"VEQ_PROGRAM_EDITION","程序版本","varchar(50)   "]
[30,"VEQ_TEMPERATURE","机箱温度","varchar(20)   "]
[31,"VEQ_SIGNAL","信号强度","varchar(20)   "]
[32,"VEQ_BRANCHID","所属商户","varchar(32)   ",{"$nulls":7},"所属商户（机构号）"]

{"sheet":"商品设备关联表","index":2,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,6],[1,7,1,11],[2,6,2,10],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,11,3,11]]}
["返回首页"]
["中文表名","商品设备关联表",null,null,"英文表名",null,null,"VM_PRO_EQU_REL"]
["序号","字段名","字段描述","数据类型","必填项","默认值","索引",{"$nulls":4},"备注说明"]
[{"$nulls":6},"唯一","普通","普通","普通","普通"]
[1,"VCI_ID","ID","varchar(20)      ","M",null,"①"]
[2,"VCI_CHANNEL","渠道（V01:自助售货机）","varchar(3)      ","M","V01",{"$nulls":5},"渠道（V01:自助售货机）"]
[3,"VCI_PRODUCT_ID","商品Id","varchar(20)   ","O"]
[4,"VCI_EQUIPMENT_ID","设备Id","varchar(20)   ","O"]
[5,"VCI_AISLE","货道指令","varchar(5)   ","O"]
[6,"VCI_CARGO_WAY_ROW","货道行","varchar(5)   ","O"]
[7,"VCI_CARGO_WAY_LINE","货道列","varchar(5)   ","O"]
[8,"VCI_CARGO_WAY_NUMS","货道容量","varchar(5)   ","O"]
[9,"VCI_PRODUCT_NUMS","商品余量","varchar(5)   ","O"]
[10,"VCI_USER_Id","商户Id","varchar(20)   ","O"]
[11,"VCI_SALL_PRICE","售货价","varchar(10)   ","O"]
[12,"VCI_GAME_PRICE","游戏价","varchar(10)   ","O"]
[13,"VCI_COST_PRICE","成本价","varchar(10)   ","O"]
[14,"VCI_IS_PROMOTION","是否促销","char(1)   ","O",{"$nulls":6},"是否促销:0是1否"]
[15,"VCI_PROMOTION_PRICE","促销价","varchar(10)   ","O"]
[16,"VCI_GAME_TYPE","游戏类型","varchar(2)   ","O",{"$nulls":6},"游戏类型（GAME_TYEP：00：不参与，10：游戏购 20：幸运购）"]
[17,"VCI_IS_FRAGILE","是否易碎","char(1)   ","O",{"$nulls":6},"是否易碎:0是1否"]
[18,"VCI_REMARKS","备注","varcha(200)   ","O"]
[19,"VCI_CREATE_USER","创建人","varchar(20)   ","O"]
[20,"VCI_CREATE_TIME","创建时间","varchar(14)   ","O"]
[21,"VCI_MODIFY_USER","最后修改人","varchar(20)   ","O"]
[22,"VCI_MODIFY_TIME","最后修改时间","varchar(14)   ","O"]
[23,"VCI_EXEIT_STATE","状态","char(2)   ","O",{"$nulls":6},"状态:00正常01货道删除02删除"]

{"sheet":"商品类目表","index":3,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,6],[1,7,1,11],[2,6,2,10],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,11,3,11]]}
["返回首页"]
["中文表名","商品类目表",null,null,"英文表名",null,null,"VM_CATEGORY_INF"]
["序号","字段名","字段描述","数据类型","必填项","默认值","索引",{"$nulls":4},"备注说明"]
[{"$nulls":6},"唯一","普通","普通","普通","普通"]
[1,"VCI_ID","ID","varchar(10)      ","M",null,"①"]
[2,"VCI_CHANNEL","渠道（V01:自助售货机）","varchar(3)      ","M","V01",{"$nulls":5},"渠道（V01:自助售货机）"]
[3,"VCI_NAME","类目名称","varchar(50)   ","O"]
[4,"VCI_ALIAS","类目别名","varchar(30)   ","O"]
[5,"VCI_INITIAL","类目名称首字母","char(1)   ","O"]
[6,"VCI_CODE","类目编号","varchar(10)   ","O"]
[7,"VCI_PARENT_CODE","上级类目","varchar(10)   ","O"]
[8,"VCI_LEVEL","类目级别","char(1)   ","O"]
[9,"VCI_SORT","类目排序","varchar(4)   ","O","9999"]
[10,"VCI_CATEGORY_IMG","类目图片","varcha(100)   ","O"]
[11,"VCI_CATEGORY_URL","类目关联路径","varcha(100)   ","O"]
[12,"VCI_STATE","状态(0正常1失效)","varchar(1)   ","O","0",{"$nulls":5},"状态(0正常1失效)"]
[13,"VCI_REMARKS","备注","varcha(255)   ","O"]
[14,"VCI_CREATE_USER","创建人","varchar(20)   ","O"]
[15,"VCI_CREATE_TIME","创建时间","varchar(14)   ","O"]
[16,"VCI_MODIFY_USER","最后修改人","varchar(20)   ","O"]
[17,"VCI_MODIFY_TIME","最后修改时间","varchar(14)   ","O"]

{"sheet":"商品表","index":4,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,6],[1,7,1,11],[2,6,2,10],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,11,3,11]]}
["返回首页"]
["中文表名","银行卡BIN信息表",null,null,"英文表名",null,null,"T_P_BIN_INFO"]
["序号","字段名","字段描述","数据类型","必填项","默认值","索引",{"$nulls":4},"备注说明"]
[{"$nulls":6},"唯一","普通","普通","普通","普通"]
[1,"PRT_ID","商品ID","varchar(20)      ","M",null,"①"]
[2,"PRT_CHANNEL","渠道（V01:自助售货机）","varchar(3)      ","M",{"$nulls":6},"渠道（V01:自助售货机）"]
[3,"PRT_NAME","商品名称","varchar(100)      ","M"]
[4,"PRT_CATEGORY_ID","商品类别id","varchar(20)      ","M"]
[5,"PRT_MASTER_MAP","商品主图","varchar(100)      ","M"]
[6,"PRT_FMPIC","商品封面图","varchar(100)   ","O"]
[7,"PRT_PICLIST","商品图片列表，以逗号分割","varchar(300)   ","O"]
[8,"PRT_DESCRIBE","商品描述","varchar(100)   ","O"]
[9,"PRT_PRO_VEDIO","商品视频","varchar(100)   ","O"]
[10,"PRT_USER_ID","商品所属商户（机构）","varchar(20)   ","O",{"$nulls":6},"商品所属商户ID()"]
[11,"PRT_SORT","排序越大越靠后","varchar(4)   ","O",9999]
[12,"PRT_STATE","状态","char(1)   ","O",0,{"$nulls":5},"状态(0正常1停售2删除)"]
[13,"PRT_CREATE_USER","创建人","varchar(20)   ","O"]
[14,"PRT_CREATE_TIME","创建时间","varchar(14)   ","O"]
[15,"PRT_MODIFY_USER","最后修改人","varchar(20)   ","O"]
[16,"PRT_MODIFY_TIME","最后修改时间","varchar(14)   ","O"]

{"sheet":"订单表","index":5,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,6],[1,7,1,12],[2,6,2,11],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,12,3,12]]}
["返回首页"]
["中文表名","订单表",null,null,"英文表名",null,null,"vm_order_inf"]
["序号","字段名","字段描述","数据类型","必填项","默认值","索引",{"$nulls":5},"备注说明"]
[{"$nulls":6},"唯一","唯一","普通","普通","普通","普通"]
[1,"VOI_ID","ID","varchar(20) NOT NULL","M",null,"①"]
[2,"VOI_CHANNEL","渠道","varchar(3) NOT NULL","M","V01",{"$nulls":6},"渠道（V01:自助售货机）"]
[3,"VOI_USER_ID","用户Id","varchar(20) NULL","O"]
[4,"VOI_EQUIPMENT_ID","商品设备关联表","varchar(30) NOT NULL","M",{"$nulls":7},"商品设备关联表VM_EQUIPMENT_INF.VEQ_ID"]
[5,"VOI_ORDER_AMT","订单总金额","varchar(20) NULL","O"]
[6,"VOI_STATE","支付状态 ","varchar(2) NULL","O",{"$nulls":7},"支付状态 80:已重新支付 90:已取消 91:未支付 92:支付中 00 ：已支付"]
[7,"VOI_RECORD_ID","结算批次号","varchar(20) NULL","O",null,null,"②",{"$nulls":4},"（VM_SET_RECORD.PSR_BATCHNO）,空代表未结算 废弃"]
[8,"VOI_PAY_ORDERNO","支付平台订单号","varchar(50) NULL","O",null,null,"③",{"$nulls":4},"支付平台订单号（微信、支付宝订单号）"]
[9,"VOI_REMARKS","备注","varchar(100) NULL","O",null,null,"④"]
[10,"VOI_PAY_TYPE","支付金额类别","varchar(2) NULL","O",null,null,"⑤",{"$nulls":4},"支付金额类别:1:1倍支付 3:3倍支付 5:5倍支付"]
[11,"VOI_NUMBER","购买次数","varchar(2) NULL","O"]
[12,"VOI_PRO_TYPE","商品交易类别","varchar(2) NULL","O",{"$nulls":7},"商品交易类别:00正常商品，01抽奖商品，02：充值"]
[13,"VOI_IS_DRAW","是否中奖","varchar(2) NULL","O",{"$nulls":7},"是否中奖:00未中奖01中奖"]
[14,"VOI_IS_USED","是否使用","varchar(2) NULL","O",{"$nulls":7},"是否使用:00已使用01未使用"]
[15,"VOI_PRO_STATE","00直接取货01放入卡包02失效","varchar(2) NULL","O",{"$nulls":7},"00直接取货01放入卡包02失效"]
[16,"VOI_DRAW_PRICE","中奖金额","varchar(20) NULL","O"]
[17,"VOI_CREATE_USER","创建人","varchar(20) NULL","O"]
[18,"VOI_CREATE_TIME","创建时间","varchar(14) NULL","O"]
[19,"VOI_MODIFY_USER","最后修改人","varchar(20) NULL","O"]
[20,"VOI_MODIFY_TIME","最后修改时间","varchar(14) NULL","O"]

{"sheet":"订单详情表","index":6,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,6],[1,7,1,12],[2,6,2,11],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,12,3,12]]}
["返回首页"]
["中文表名","非金融交易流水表",null,null,"英文表名",null,null,"T_P_NON_FINANCE_TXN"]
["序号","字段名","字段描述","数据类型","必填项","默认值","索引",{"$nulls":5},"备注说明"]
[{"$nulls":6},"唯一","唯一","普通","普通","普通","普通"]
[1,"VOD_DETAILS_ID","ID","varchar(20) NOT NULL","M",null,"①"]
[2,"VOD_CHANNEL","渠道（V01:自助售货机）","varchar(3) NOT NULL","M"]
[3,"VOD_ORDER_ID","所属订单表vm_order_inf.VOI_ID","varchar(20) NULL","O"]
[4,"VOD_PRO_EQU_REL_ID","商品设备关联表vm_pro_equ_rel.VCI_ID","varchar(20) NOT NULL","M"]
[5,"VOD_CARGO_WAY","商品所在售货机货道(00:第一行第一列)","varchar(20) NOT NULL","M"]
[6,"VOD_PRODUCT_ID","商品编号","varchar(20) NOT NULL","M"]
[7,"VOD_PRO_TYPE","商品交易类别:00正常商品01抽奖商品","varchar(2) NULL","O",0]
[8,"VOD_PRO_NAME","商品名称","varchar(100) NULL","O"]
[9,"VOD_PRO_PRICE","商品单价格","varchar(20) NULL","O"]
[10,"VOD_PRO_NUMS","商品数量","varchar(20) NULL","O"]
[11,"VOD_AMOUNT","商品总价","varchar(20) NULL","O"]
[12,"VOD_RECORD_ID","结算批次号（VM_SET_RECORD.PSR_BATCHNO）,空代表未结算","varchar(20) NULL","O"]
[13,"VOD_REMARKS","备注","varchar(200) NULL","O"]
[14,"VOD_CREATE_USER","创建人","varchar(20) NULL","O"]
[15,"VOD_CREATE_TIME","创建时间","varchar(14) NULL","O"]
[16,"VOD_MODIFY_USER","最后修改人","varchar(20) NULL","O"]
[17,"VOD_MODIFY_TIME","最后修改时间","varchar(14) NULL","O"]