{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["0"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"0","index":0,"n_rows":200,"n_cols":6,"rows_kept":200,"cut":false,"hidden":false,"merged":[[1,0,32,0],[33,0,46,0],[47,0,57,0],[58,0,71,0],[72,0,84,0],[85,0,90,0],[91,0,106,0],[107,0,135,0],[136,0,159,0],[160,0,179,0],[180,0,186,0],[187,0,199,0],[1,1,32,1],[33,1,46,1],[47,1,57,1],[58,1,71,1],[72,1,84,1],[85,1,90,1],[91,1,106,1],[107,1,135,1],[136,1,159,1],[160,1,179,1],[180,1,186,1],[187,1,199,1]]}
["表名称","表备注","列名","备注","示例1","示例2"]
["frame_user","用户表","id","id","1","1021425397054570496"]
[null,null,"group_id","集团ID","",""]
[null,null,"staff_code","员工编号","测试工号1","测试工号2"]
[null,null,"department","部门ID","b60290d0-38c5-11ed-95ef-002b676e86f6","b60290d0-38c5-11ed-95ef-002b676e86f6"]
[null,null,"department_code","部门编码","",""]
[null,null,"username","用户账号","admin","15852717080"]
[null,null,"password","用户密码","8a73ce1fe3f948f7d8944951d30e5afa","a0a475cf454cf9a06979034098167b9e"]
[null,null,"truename","用户姓名","管理","测试用账号"]
[null,null,"gender","性别，1-男，2-女","1","1"]
[null,null,"phone","联系电话","15995298888","15995298888"]
[null,null,"email","联系邮箱","",""]
[null,null,"position","职位","",""]
[null,null,"leader","上级领导ID","",""]
[null,null,"posts","岗位，逗号分隔","1022113195545853952","1022113195545853952"]
[null,null,"data_role","权限关键字，暂用于数据权限","1022079976255520768","1031882682306396160"]
[null,null,"data_role_key","","appletHome","noPermission"]
[null,null,"mobile_role","移动端权限","1030075672581636096",""]
[null,null,"mobile_role_key","","",""]
[null,null,"sequence_no","顺序号","1.0",""]
[null,null,"secret_key","密钥关键字","",""]
[null,null,"image_data","图片数据","",""]
[null,null,"comment","备注","管理员",""]
[null,null,"reset_at","密码最新重置时间","","2022-11-24T13:32:15"]
[null,null,"login_at","最后登录时间","2022-12-08T10:40:39","2022-11-03T14:50:18"]
[null,null,"login_ip","最后登录IP","",""]
[null,null,"is_init","0-未初始化，1-已初始化","1","1"]
[null,null,"is_lock","0-未锁定，1-已锁定","0","1"]
[null,null,"status","状态：0-禁用， 1-启用","1","1"]
[null,null,"flag","标识，用于不同系统定义不同内容\r\n本系统中：\r\n0或空-非销售，1-销售人员","1",""]
[null,null,"del_flag","删除标志（0代表存在 2代表删除）","0","2"]
[null,null,"createdat","","","2022-09-19T14:19:52"]
[null,null,"updatedat","","2022-12-08T10:40:39","2022-11-30T14:51:18"]
["pecw_address_record","地址变更记录","recordid","主键","2LnoIAMBO3zRtj1vvnB","2mW97AhpCnCdchWfgTX"]
[null,null,"userid","申请人id","1022916181364834304","1022824132565270528"]
[null,null,"extendid","用户扩展表id","CT172160","HYX207003"]
[null,null,"submitdate","提交日期","2022-11-11T15:15:57","2022-10-20T13:15:14"]
[null,null,"oldaddress","原地址","新吴区净慧东道","新吴区江溪街道万裕苑一区31号501室"]
[null,null,"newaddress","新地址","滨湖区新吴区净慧东道","新吴区新洲人家"]
[null,null,"state","审批状态（0待提交1已提交2已审核3已退回）","1","2"]
[null,null,"operation_reason","操作/退回原因","",""]
[null,null,"operatetime","审核时间","","2022-10-20T13:16:34"]
[null,null,"audituser","审批人id","","1022915525082087424"]
[null,null,"createuser","创建人","1022916181364834304","1022824132565270528"]
[null,null,"createtime","创建时间","2022-11-11T15:15:57","2022-10-20T13:15:14"]
[null,null,"updateuser","更新人","1022916181364834304","1022824132565270528"]
[null,null,"updatetime","更新时间","2022-11-11T15:15:57","2022-10-20T13:16:34"]
["pecw_announcement","通知公告表","announceid","主键","Ea1mQ8ujisW5Ma36RRX","eidSbspRW6JcI7fO8af"]
[null,null,"title","标题","测试通知公告2","zttest2"]
[null,null,"picurl","主题图地址","1022154313188769792","1032586404216963072"]
[null,null,"content","内容","水水水水水水水水水水水水水水水水水水12","1212"]
[null,null,"state","状态（0待发布、1已发布、2已撤回）","2","0"]
[null,null,"publishuser","发布人","1",""]
[null,null,"publishtime","发布时间","2022-10-19T15:39:10",""]
[null,null,"createuser","创建人","1","1"]
[null,null,"createtime","创建时间","2022-09-21T14:36:41","2022-10-20T09:29:48"]
[null,null,"updateuser","修改人","1",""]
[null,null,"updatetime","修改时间","2022-10-19T15:56:53","2022-10-20T09:29:48"]
["pecw_announcement_detail","通知公告表-查收人明细表","detailid","主键","00FpgnbavFj1LYqrsXA","00SHEuUHsu7eDh7rq3c"]
[null,null,"announceid","通知公告表id","UZcgEpUZUXOcBKEIBAc","SqogaU3xgaRzDn9hd92"]
[null,null,"userid","用户id","1024618410195025920","1022916710799245312"]
[null,null,"extendid","用户扩展id（预留）","k57MnTE3ntgoeP5FVCf","8SvxPUSD1Xp3mz2MVcX"]
[null,null,"confirmtime","确认时间","",""]
[null,null,"state","确认状态（0未确认1已确认）","0","0"]
[null,null,"ucode","工号","WMP032110","ZZ221004"]
[null,null,"uname","姓名","郑爱伟","张禹"]
[null,null,"udept","部门","镍氢电池工场/镍氢制造总括部/镍氢制造部/组立科/工程改善系","锂离子电池工场/CELL总括部/CELL制造三部/仕上科/圆筒自动系"]
[null,null,"uphone","联系电话","13771136599","15567255799"]
[null,null,"createuser","创建人","1","1"]
[null,null,"createtime","创建时间","2022-10-10T13:25:29","2022-10-19T11:47:23"]
[null,null,"updateuser","修改人","",""]
[null,null,"updatetime","修改时间","",""]
["pecw_audit_record","审批记录表","id","主键","0wE4Vr6Qeo8UvDuR2WI","0WKQ9VpQkKYA20CTQdW"]
[null,null,"formid","表单id","gBnMTXtRXl1kAiu0yhw","Ev2sVnoe9mWRelilX6i"]
[null,null,"audituser","审批人id","1022915670079176704","1022824124608675840"]
[null,null,"audittime","审批时间","2022-10-25T10:30:30","2022-11-18T16:55:54"]
[null,null,"auditcontent","审批意见","",""]
[null,null,"auditresult","审批结果","yes",""]
[null,null,"audittype","审批类型","end","start"]
[null,null,"processtype","流程类型","apply_leave","apply_free"]
[null,null,"processpost","流程岗位","curr_user",""]
[null,null,"processid","流程id","",""]
[null,null,"taskid","流程任务id","40031",""]
[null,null,"createuser","创建人","","1022824124608675840"]
[null,null,"createtime","创建时间","2022-10-25T10:30:30","2022-11-18T16:55:54"]
["pecw_code_rule","编码规则","ruleid","主键","3917e608-3324-11ed-868f-002b676e86f6","825492d9-33cc-11ed-868f-002b676e86f6"]
[null,null,"prefix","前缀","GL","LX"]
[null,null,"nowdate","当前日期yyyyMMdd","20221124","20221202"]
[null,null,"tablename","表名","pecw_isolation_record","pecw_in_out_record"]
[null,null,"countsize","流水号位数","4","4"]
[null,null,"countnum","流水号","3","1"]
["pecw_epidemic_info","人员涉疫信息表","infoid","主键","000FAdG07HoQ1vL0zkV","000JkfTU0TQyMFgN6IE"]
[null,null,"extendcode","工号","WM212003","WM128027"]
[null,null,"userid","用户id(新增)暂时不录)","",""]
[null,null,"ilevel","苏康码信息状态（1绿码、2黄码、3红码）","1","1"]
[null,null,"controlled","是否在管控区域(true、false)","false","false"]
[null,null,"vaccine","是否接种疫苗（0已接种、1未接种）","0","0"]
[null,null,"nuclein","核酸信息状态（0已采样未检测、1阴性、-1无核算记录、2阳性）","1","1"]
[null,null,"iname","扫码/刷卡人姓名","罗丽梅","卞政"]
[null,null,"icode","扫码/刷卡人证件号","",""]
[null,null,"irange","核酸核验周期(24/48/72)","24","72"]
[null,null,"createtime","创建时间","2022-10-17T19:11:16","2022-10-14T19:10:43"]
[null,null,"updatetime","更新时间","2022-10-17T19:11:16","2022-10-14T19:10:43"]
[null,null,"getdatatime","统一开始获取数据时间(新增)","2022-10-17T19:00","2022-10-14T19:00"]
[null,null,"travelcode","行程码信息(0正常,1异常)(新增)(暂时不录)","",""]
[null,null,"url_travel_picture","行程码信息图片地址(新增)(暂时不录)","",""]
[null,null,"message","异常情况备注(如未获取数据的msg)","",""]
["pecw_in_out_record","离锡返锡记录","recordid","主键","28dqiPNF2V19Ga5Eg4Z","3IA4J3RsGLixAlez7gq"]
[null,null,"recordcode","申请单号","LX202210210006","LX202211110001"]
[null,null,"recorddate","申请日期(有问题暂时不用,改用createtime字段)","2022-10-21T00:00","2022-11-11T00:00"]
[null,null,"recordusertype","申请人类型（本人、他人）","他人","本人"]
[null,null,"recorduser","申请人id","1022916182677651456","1022916181364834304"]
[null,null,"state","申请状态（0待提交1待审核2已审核3已退回4结束流程）","2","2"]
[null,null,"backstate","返锡申报提交状态（0未提交1已提交）","0","0"]
[null,null,"outreason","出省原因","探亲","探亲"]
[null,null,"outdate","出发时间","2022-10-21T00:00","2022-11-23T00:00"]
[null,null,"outway","交通方式","自驾","火车/高铁"]
[null,null,"outprovince","目的地-省","西藏自治区","天津市"]
[null,null,"outcity","目的地-市","拉萨市","市辖区"]
[null,null,"outarea","目的地-区","市辖区","河西区"]
[null,null,"outaddress","目的地详细地址","","河西"]
[null,null,"outrisk","是否属于风险区（0是1否）","1","0"]
[null,null,"intime","返锡时间","2022-10-21T00:00","2022-11-25T00:00"]
[null,null,"inway","交通方式","自驾","飞机"]
[null,null,"inprovince","回归地-省","江苏省","内蒙古自治区"]
[null,null,"incity","回归地-市","无锡市","呼和浩特市"]
[null,null,"inarea","回归地-区","市辖区","回民区"]
[null,null,"inaddress","回归地详细地址","",""]
[null,null,"recordnotes","备注","",""]
[null,null,"inrequirement","返锡当天与社区确认防疫要求","",""]
[null,null,"travelcode","行程码","1033018336939606016","1040563625489596416"]
[null,null,"createuser","创建人","1024619485111255040","1022916181364834304"]
[null,null,"createtime","创建时间","2022-10-21T14:08:54","2022-11-11T09:48:26"]
[null,null,"updateuser","更新人","",""]
[null,null,"updatetime","更新时间","2022-10-21T14:31:27","2022-11-11T09:52:22"]
[null,null,"processid","流程相关","40139","187508"]
["pecw_isolation_record","隔离记录","recordid","主键","0YxywiKohbYHM9REB7w","1cuL3MMr9mktfDzLe4y"]
[null,null,"recordcode","申请单号","GL202211110001","GL202211170001"]
[null,null,"recorddate","申请日期","2022-11-11T00:00","2022-11-17T00:00"]
[null,null,"recordusertype","申请人类型（本人、他人）","本人","本人"]
[null,null,"recorduser","申请人id","1022916181364834304","1022915525082087424"]
[null,null,"recordaddress","居住地址","新吴区净慧东道","新吴区天鹅座"]
[null,null,"recordreason","原因","入境人员","入境人员"]
[null,null,"recordstarttime","隔离开始时间","2026-01-01T00:00","2022-11-15T00:00"]
[null,null,"recordrequirement","防控要求","3天3检","3天3检"]
[null,null,"recordtype","隔离类型","居家隔离","居家隔离"]
[null,null,"isolationtype","集中隔离类型","",""]
[null,null,"isolationname","集中隔离名称","",""]
[null,null,"isolationaddress","集中隔离地址","",""]
[null,null,"submitstate","隔离申请提交状态（0待提交1已提交）","1","1"]
[null,null,"state","解封审核状态（0待解封、1待审核、2已审核、3已退回）","1","1"]
[null,null,"expectendtime","预计隔离结束时间","2026-01-03T00:00","2022-11-21T00:00"]
[null,null,"recordendtime","隔离结束时间","2026-01-01T00:00","2022-11-17T00:00"]
[null,null,"recordnotes","备注","",""]
[null,null,"recordsupport","解除隔离证明","1040578699386159104","1042842493126705152"]
[null,null,"createuser","创建人","1022916181364834304","1022915525082087424"]
[null,null,"createtime","创建时间","2022-11-11T10:19:48","2022-11-17T00:00"]
[null,null,"updateuser","更新人","","1022915525082087424"]
[null,null,"updatetime","更新时间","2022-11-11T10:48:31","2022-11-23T17:09:18"]
[null,null,"processid","流程相关","195008","300008"]
["pecw_user_extend","人员信息扩展表","extendid","主键","00v9FpImCU0d9XHjH1a","01S7vJjoe0mot0kcgFe"]
[null,null,"userid","用户id","1022916156584886272","1022915047942258688"]
[null,null,"extenddept","部门","锂离子电池工场/CELL总括部/CELL制造一部/角形科/组立二系","锂离子电池工场/CELL总括部/CELL制造一部/角形科/组立二系"]
[null,null,"extendcode","工号","WMZ122308","WMY071055"]
[null,null,"extendname","姓名","穆娟娟","邓尚举"]
[null,null,"extendphone","联系电话","13806191346","18351576602"]
[null,null,"extendaddress","现居住地址","梁溪区黄巷街道沈巷小区231号802","惠山区堰桥街道西漳横街34号"]
[null,null,"numbervaccineshots","疫苗接种次数","",""]
[null,null,"firsttimevaccineshots","第一针接种时间","",""]
[null,null,"firstnamevaccineshots","第一针疫苗品牌名称","",""]
[null,null,"secondtimevaccineshots","第二针接种时间","",""]
[null,null,"secondnamevaccineshots","第二针疫苗品牌名称","",""]
[null,null,"thirdtimevaccineshots","第三针接种时间","",""]
[null,null,"thirdnamevaccineshots","第三针疫苗品牌名称","",""]
[null,null,"createuser","创建人","-1","-1"]
[null,null,"createtime","创建时间","2022-09-23T17:03:37","2022-09-23T16:59:12"]
[null,null,"updateuser","更新人","-1","-1"]
[null,null,"updatetime","更新时间","2022-12-05T13:19:30","2022-12-05T13:16:28"]
[null,null,"isdel","删除标志（0未删除1已删除）","0","0"]
[null,null,"openid","微信小程序的openid","",""]
["pecw_wgy_dept","网格员管辖部门信息","wgyid","主键","123","8OaoPyQM3xsO60wAaYR"]
[null,null,"userid","用户id","1022824101678415872","1024618545310334976"]
[null,null,"ids","管辖部门ids","b60290d0-38c5-11ed-95ef-002b676e86f6","1021819803368685568,3d923d37-38c4-11ed-95ef-002b676e86f6,69afbfee-38c4-11ed-95ef-002b676e86f6,82650f67-38c4-11ed-95ef-002b676e86f6,826704d7-38c4-11ed-95ef-002b676e86f6,69b1a6ba-38c4-11ed-95ef-002b676e86f6,ae0086f8-38c4-11ed-95ef-002b676e86f6,69b43fa0-38c4-11ed-95ef-002b676e86f6,ae02e453-38c4-11ed-95ef-002b676e86f6,69b6e94a-38c4-11ed-95ef-002b676e86f6,ae047af1-38c4-11ed-95ef-002b676e86f6,3d94741a-38c4-11ed-95ef-002b676e86f6,d0a2f1d8-38c4-11ed-95ef-002b676e86f6,f5073ab6-38c4-11ed-95ef-002b676e86f6,f5098757-38c4-11ed-95ef-002b676e86f6,d0a48e9c-38c4-11ed-95ef-002b676e86f6,f50b9282-38c4-11ed-95ef-002b676e86f6,f50d690c-38c4-11ed-95ef-002b676e86f6"]
[null,null,"createuser","创建时间","1",""]
[null,null,"createtime","创建时间","2022-09-23T15:53:32","2022-10-21T16:08:47"]
[null,null,"updateuser","修改者","1",""]
[null,null,"updatetime","修改时间","2022-09-23T15:53:36",""]
["sys_dept","部门信息表","id","id","0","010382aa-38c2-11ed-95ef-002b676e86f6"]
[null,null,"parent_id","","","e3b3f041-38c1-11ed-95ef-002b676e86f6"]
[null,null,"group_id","所属集团分公司","",""]
[null,null,"dept_name","部门名称","组织架构","计量计测系"]
[null,null,"dept_code","部门编码","TOP","jiliangjicexi"]
[null,null,"dept_url","部门logo","",""]
[null,null,"dept_order","顺序号","0","0"]
[null,null,"dept_level","部门层级","0","6"]
[null,null,"dept_attr","部门属性，字典项，多一类相关类型","",""]
[null,null,"changed_by","部门负责人","",""]
[null,null,"created_at","","2021-04-08T11:26:03","2022-09-20T16:55:40"]
[null,null,"updated_at","","",""]
[null,null,"sys_id","","BIZ_OA","BIZ_OA"]