{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["citylifeline_db"],"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":"citylifeline_db","index":0,"n_rows":2515,"n_cols":5,"rows_kept":2515,"cut":false,"hidden":false,"merged":[[0,0,0,4],[19,0,19,4],[29,0,29,4],[44,0,44,4],[63,0,63,4],[93,0,93,4],[105,0,105,4],[122,0,122,4],[130,0,130,4],[164,0,164,4],[186,0,186,4],[212,0,212,4],[239,0,239,4],[255,0,255,4],[276,0,276,4],[297,0,297,4],[309,0,309,4],[333,0,333,4],[346,0,346,4],[364,0,364,4],[382,0,382,4],[396,0,396,4],[411,0,411,4],[436,0,436,4],[459,0,459,4],[475,0,475,4],[502,0,502,4],[518,0,518,4],[531,0,531,4],[553,0,553,4],[559,0,559,4],[577,0,577,4],[604,0,604,4],[619,0,619,4],[633,0,633,4],[664,0,664,4],[676,0,676,4],[703,0,703,4],[721,0,721,4],[748,0,748,4],[775,0,775,4],[804,0,804,4],[824,0,824,4],[848,0,848,4],[875,0,875,4],[913,0,913,4],[934,0,934,4],[953,0,953,4],[965,0,965,4],[978,0,978,4],[993,0,993,4],[1025,0,1025,4],[1046,0,1046,4],[1057,0,1057,4],[1074,0,1074,4],[1087,0,1087,4],[1103,0,1103,4],[1126,0,1126,4],[1145,0,1145,4],[1161,0,1161,4],[1183,0,1183,4],[1196,0,1196,4],[1215,0,1215,4],[1233,0,1233,4],[1270,0,1270,4],[1292,0,1292,4],[1319,0,1319,4],[1338,0,1338,4],[1368,0,1368,4],[1389,0,1389,4],[1401,0,1401,4],[1420,0,1420,4],[1437,0,1437,4],[1476,0,1476,4],[1521,0,1521,4],[1531,0,1531,4],[1552,0,1552,4],[1562,0,1562,4],[1583,0,1583,4],[1615,0,1615,4],[1631,0,1631,4],[1652,0,1652,4],[1668,0,1668,4],[1694,0,1694,4],[1718,0,1718,4],[1730,0,1730,4],[1748,0,1748,4],[1766,0,1766,4],[1808,0,1808,4],[1824,0,1824,4],[1838,0,1838,4],[1855,0,1855,4],[1882,0,1882,4],[1899,0,1899,4],[1908,0,1908,4],[1922,0,1922,4],[1935,0,1935,4],[1963,0,1963,4],[1970,0,1970,4],[1981,0,1981,4],[1993,0,1993,4],[2004,0,2004,4],[2018,0,2018,4],[2030,0,2030,4],[2039,0,2039,4],[2048,0,2048,4],[2054,0,2054,4],[2079,0,2079,4],[2117,0,2117,4],[2125,0,2125,4],[2166,0,2166,4],[2176,0,2176,4],[2208,0,2208,4],[2235,0,2235,4],[2267,0,2267,4],[2287,0,2287,4],[2318,0,2318,4],[2330,0,2330,4],[2360,0,2360,4],[2379,0,2379,4],[2400,0,2400,4],[2418,0,2418,4],[2438,0,2438,4],[2458,0,2458,4],[2479,0,2479,4],[2498,0,2498,4]]}
["1.archives_event(档案管理-事件档案库-事件档案)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","","主键"]
["scene","varchar(50)","是","","所属专项  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["name","varchar(500)","是","","事件名称"]
["type","varchar(50)","是","","事件类型  下拉框"]
["level","varchar(50)","是","","事件等级 一级、二级、三级、四级"]
["keyword","text","是","","关键字"]
["annex","varchar(500)","是","","档案文件"]
["create_time","timestamp(6)","是","","数据创建日期/存档时间"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
["is_often","varchar(2)","是","","是否高发是,不是"]
["area","varchar(16)","是","","行政区划"]
["dispose_progress","varchar(16)","是","","处置进度(处置状态) 0未处置、1处置中、2已完成"]
["emergency_description","varchar(1000)","是","","事件说明"]
[]
["2.archives_organization(档案管理-联动通讯录-组织)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["name","varchar(500)","是","","组织名称"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
[]
["3.archives_personnel(档案管理-联动通讯录-组织)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["org_id","varchar(50)","是","","组织id"]
["name","varchar(500)","是","","姓名"]
["department","varchar(500)","是","","部门"]
["post","varchar(500)","是","","岗位"]
["phone","varchar(500)","是","","联系方式"]
["order_num","varchar(50)","是","","排序"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
[]
["4.archives_pitfall(档案管理-事件档案库-隐患档案)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(128)","否","","主键"]
["scene","varchar(50)","是","","所属专项  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["name","varchar(500)","是","","隐患名称"]
["type","varchar(50)","是","","隐患类型  下拉框"]
["level","varchar(50)","是","","隐患等级 一级、二级、三级、四级"]
["keyword","text","是","","关键字"]
["annex","varchar(500)","是","","档案文件"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
["is_often","varchar(2)","是","","是否高发是,不是"]
["area","varchar(16)","是","","行政区划梁溪区320213 滨湖区320211..."]
["dispose_progress","varchar(16)","是","","处置进度(处置状态) 0未处置、1处置中、2已完成"]
["hidden_trouble_description","varchar(1000)","是","","隐患描述"]
[]
["5.archives_risk(档案管理-事件档案库-风险档案)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["scene","varchar(50)","是","","所属专项  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["name","varchar(500)","是","","风险名称"]
["type","varchar(50)","是","","风险类型  下拉框"]
["level","varchar(50)","是","","风险等级 一级、二级、三级、四级"]
["keyword","text","是","","关键字"]
["annex","varchar(500)","是","","档案文件"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
["area","varchar(16)","是","","行政区划"]
["is_often","varchar(2)","是","","是否高发是,不是"]
["dispose_progress","varchar(16)","是","","处置进度(处置状态) 0未处置、1处置中、2已完成"]
["kjxx","geometry","是","","空间信息"]
["zrdw","varchar(500)","是","","责任单位"]
["pgdw","varchar(500)","是","","评估单位"]
["pgsj","timestamp(6)","是","","评估时间"]
["dlwz","varchar(2000)","是","","地理位置"]
["fxms","varchar(1000)","是","","风险描述"]
["bsm","varchar(64)","是","","标识码"]
["childtype","varchar(255)","是","","专项子类名称"]
["code","varchar(255)","是","","所属专项名称"]
["table","varchar(255)","是","","来源表名称"]
["tbsj","timestamp(6)","是","","同步时间"]
["pgfz","numeric(6,2)","是","","评估分值"]
[]
["6.business_tag_info(无注释)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["tag_id","varchar(500)","是","",""]
["business_id","varchar(64)","是","",""]
["business_type","varchar(64)","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["7.change_duty_management(调班管理表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","","id"]
["staff_name","varchar(32)","是","","调班对象人员姓名"]
["staff_number","varchar(64)","是","","调班对象人员编号"]
["staff_tel","varchar(16)","是","","调班对象人员手机号"]
["apply_staff_name","varchar(32)","是","","申请调班人员姓名"]
["apply_staff_number","varchar(64)","是","","申请调班人员编号"]
["apply_staff_tel","varchar(16)","是","","申请调班人员手机号"]
["duty_date","timestamp(6)","是","","调班日期"]
["duty_type","varchar(16)","是","","调班班次 0早班 1中班 2晚班"]
["deleted","int4","是","0",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["8.demo_class(无注释)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","",""]
["name","varchar(100)","是","NULL::character varying",""]
["grade","varchar(10)","是","NULL::character varying",""]
["created_at","time(6)","是","",""]
["created_by","varchar(50)","是","NULL::character varying",""]
[]
["9.dl_csdl(城市道路属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","是","","标识码"]
["xzqhdm","varchar(16)","是","","行政区划代码"]
["dlmc","varchar(64)","是","","道路名称"]
["dlqd","varchar(100)","是","","道路起点"]
["dlzd","varchar(100)","是","","道路终点"]
["dlzx","int4","是","","道路走向"]
["dldj","int4","是","","道路等级"]
["glfl","int4","是","","管理分类"]
["yhdj","int4","是","","养护等级"]
["dlcd","numeric(12,2)","是","","道路长度"]
["dlkd","numeric(8,2)","是","","道路宽度"]
["dlmj","numeric(12,2)","是","","道路面积"]
["jsdw","varchar(100)","是","","建设单位"]
["sjdw","varchar(100)","是","","设计单位"]
["sgdw","varchar(100)","是","","施工单位"]
["jldw","varchar(100)","是","","监理单位"]
["gldw","varchar(100)","是","","管理单位"]
["yhdw","varchar(100)","是","","养护单位"]
["jgrq","date","是","","竣工日期"]
["bz","varchar(255)","是","","备注"]
["tbsj","date","是","","同步时间"]
["del_flag","int4","是","",""]
["kjxx","varchar(4000)","是","","空间信息"]
["yskzjbz","varchar(32)","是","","原始库主键标志"]
["dlmcbz","int4","是","","道路名称备注"]
["flbm","varchar(4)","是","","分类编码"]
["rxdsl","int4","是","","人行道数量"]
["rxdlc","numeric(12,2)","是","","人行道里程"]
["zxcdsl","int4","是","","自行车道数量"]
["zxcdlc","numeric(12,2)","是","","自行车道里程"]
["sjtbzt","varchar(16)","是","","数据同步状态"]
[]
["10.dl_jc_dltxfx(道路塌陷风险(根据省标作废))"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(32)","否","",""]
["xzqhdm","varchar(6)","是","",""]
["dlmc","varchar(32)","是","",""]
["dlqd","varchar(100)","是","",""]
["dlzd","varchar(100)","是","",""]
["dldj","int4","是","",""]
["fxdj","int4","是","",""]
["bz","varchar(255)","是","",""]
["tbsj","date","是","",""]
["del_flag","int4","是","",""]
["gcmc","varchar(50)","是","",""]
["jcdw","varchar(50)","是","",""]
["pgdybh","varchar(32)","是","",""]
["pgdylc","float8","是","",""]
["pgfz","int4","是","",""]
["kjxx","varchar(4000)","是","",""]
["yskzjbz","varchar(32)","是","",""]
["pgsj","date","是","",""]
["fj","varchar(255)","是","",""]
[]
["11.dl_jg_dltxfx(道路塌陷风险属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","是","","标识码"]
["xzqhdm","varchar(16)","是","","行政区划代码"]
["dlmc","varchar(64)","是","","道路名称"]
["dlqd","varchar(100)","是","","道路起点"]
["dlzd","varchar(100)","是","","道路终点"]
["dldj","int4","是","","道路等级"]
["fxdj","int4","是","","风险等级"]
["bz","varchar(255)","是","","备注"]
["tbsj","date","是","","同步时间"]
["del_flag","int4","是","",""]
["mc","varchar(100)","是","","名称"]
["jcdw","varchar(100)","是","","检测单位"]
["pgdybh","varchar(64)","是","","评估单元编号"]
["pgdycd","int4","是","","评估单元长度"]
["pgfz","numeric(6,2)","是","","评估分值"]
["kjxx","varchar(4000)","是","","空间信息"]
["yskzjbz","varchar(32)","是","","原始库主键标志"]
["pgsj","date","是","","评估时间"]
["fj","varchar(100)","是","","附件"]
["fxms","varchar(255)","是","","风险描述"]
["gkcs","varchar(100)","是","","管控措施"]
["gkzt","int4","是","","管控状态"]
["sjtbzt","varchar(16)","是","","数据同步状态"]
[]
["12.dl_js_csdl(城市道路属性结构表(根据省标作废))"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(32)","否","","标识码"]
["xzqhdm","varchar(6)","是","","行政区划代码"]
["dlmc","varchar(100)","是","","道路名称"]
["dlqd","varchar(100)","是","","道路起点"]
["dlzd","varchar(100)","是","","道路终点"]
["dlzx","int4","是","","道路走向"]
["dldj","int4","否","","道路等级"]
["glfl","int4","否","","管理分类"]
["yhdj","int4","否","","养护等级"]
["dlcd","numeric(12,2)","否","","道路长度"]
["dlkd","numeric(8,2)","否","","道路宽度"]
["dlmj","numeric(12,2)","否","","道路面积"]
["jsdw","varchar(100)","是","","建设单位"]
["sjdw","varchar(100)","是","","设计单位"]
["sgdw","varchar(100)","是","","施工单位"]
["jldw","varchar(100)","是","","监理单位"]
["gldw","varchar(100)","否","","管理单位"]
["yhdw","varchar(100)","是","","养护单位"]
["jgny","date","是","","竣工年月"]
["bz","varchar(255)","是","","备注"]
["tbsj","timestamp(6)","是","","同步时间"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["kjxx","varchar(4000)","是","","空间信息"]
["del_flag","int4","是","",""]
[]
["13.duty_management(排班管理表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","","id"]
["staff_name","varchar(32)","是","","人员姓名"]
["staff_number","varchar(64)","是","","人员编号"]
["staff_tel","varchar(16)","是","","人员手机号"]
["duty_date","timestamp(6)","是","","排班时间"]
["duty_type","varchar(16)","是","","值班班次 0早班 1中班 2晚班"]
["day_record","varchar(2000)","是","","日报"]
["deleted","int4","是","0",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["management_type_id","varchar(64)","是","","排班类型管理日志表id"]
[]
["14.duty_management_type(排班类型管理日志)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(60)","否","","id"]
["start_time","timestamp(6)","是","","生效日期"]
["end_time","timestamp(6)","是","","失效日期"]
["type","varchar(2)","是","","排班类型0长白班,1长夜班,2两班制,3三班制"]
["start_first","time(6)","是","","第一班"]
["end_first","time(6)","是","","第一班"]
["first_time","numeric(4,1)","是","","所用工时"]
["start_second","time(6)","是","","第2班"]
["end_second","time(6)","是","","第2班"]
["second_time","numeric(4,1)","是","","所用工时"]
["start_third","time(6)","是","","第3班"]
["end_third","time(6)","是","","第3班"]
["third_time","numeric(4,1)","是","","所用工时"]
["deleted","int2","是","","1不删除,0删除"]
["create_time","timestamp(6)","是","","创建时间"]
["creater_id","varchar(64)","是","","创建人id"]
["update_time","timestamp(6)","是","","修改时间"]
["updater_id","varchar(64)","是","","修改人id"]
[]
["15.gs_jc_jcsb(监测设备属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","否","","标识码"]
["dwbsm","varchar(64)","是","","点位标识码"]
["sblx","varchar(50)","否","","设备类型"]
["sbmc","varchar(32)","否","","设备名称"]
["sbxh","varchar(50)","是","","设备型号"]
["jczb","varchar(32)","否","","监测指标"]
["cjpl","varchar(32)","否","","采集频率"]
["scpl","varchar(32)","否","","上传频率"]
["sbzt","int4","是","","设备状态"]
["csmc","varchar(50)","是","","厂商名称"]
["xdgd","numeric(10,3)","是","","相对高度"]
["azrq","date","是","","安装时间"]
["azwhdw","varchar(100)","是","","安装维护单位"]
["gdfs","varchar(32)","是","","供电方式"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","否","","数据同步状态"]
["tbsj","timestamp(6)","否","","同步时间"]
[]
["16.gs_jc_jcxyz(监测项阈值属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","否","","标识码"]
["sbbsm","varchar(64)","是","","设备标识码"]
["sblx","varchar(32)","是","","设备类型"]
["jczb","varchar(32)","是","","监测指标"]
["bjyz","varchar(255)","是","","报警阈值"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","是","","数据同步状态"]
["tbsj","timestamp(6)","是","","同步时间"]
[]
["17.gs_jg_gwfxhczxx(供水管网风险&处置信息属性结构表(省))"]
["列名","数据类型","是否为空","默认值","备注"]
["pgdywz","varchar(200)","是","",""]
["pgdw","varchar(200)","是","",""]
["bz","varchar(200)","是","",""]
["gkcs","varchar(200)","是","",""]
["pgdywybs","varchar(200)","是","",""]
["gkzt","numeric(23,0)","是","",""]
["fxdj","numeric(23,0)","是","",""]
["xzqhdm","varchar(16)","是","",""]
["pgsj","date","是","",""]
["xxdz","varchar(200)","是","",""]
["knxdj","numeric(23,0)","是","",""]
["pgdygdcd","numeric(23,0)","是","",""]
["qsdw","varchar(200)","是","",""]
["bsm","varchar(64)","是","",""]
["sjcgpcbh","varchar(200)","是","",""]
["fxms","varchar(200)","是","",""]
["hgdj","numeric(23,0)","是","",""]
["pgdymc","varchar(200)","是","",""]
["kjxx","text","是","",""]
["fxbh","varchar(200)","是","",""]
["glgdbh","varchar(2000)","是","",""]
[]
["18.gs_jg_ljgwgzlsqk(老旧管网改造落实情况结构表(省))"]
["列名","数据类型","是否为空","默认值","备注"]
["szljgwygzgls","float4","是","","市政老旧管网已改造公里数"]
["nf","varchar(50)","是","","年份"]
["xzqhdm","varchar(16)","是","","行政区划代码"]
["ljgwygzgls","float4","是","","老旧管网已改造长度"]
["ljgwgzzgls","float4","是","","老旧管网改造中长度"]
["bz","varchar(50)","是","","备注"]
["dnjhgzljgwgls","float4","是","","当年计划改造老旧管网总长"]
["tjsj","date","是","","提交时间"]
["ljgwwgzgls","float4","是","","老旧管网未改造长度"]
["bsm","varchar(64)","是","","标识码"]
[]
["19.gs_js_gsbz(增压站或二供泵房(市))"]
["列名","数据类型","是否为空","默认值","备注"]
["jyhs","varchar(60)","是","","加压户数"]
["gsqy","varchar(60)","是","",""]
["scbsm","varchar(60)","是","",""]
["mc","varchar(60)","是","",""]
["sysj","date","是","",""]
["lxsm","varchar(60)","是","",""]
["bsm","varchar(60)","是","","标识码"]
["dz","varchar(300)","是","",""]
["xzqhdm","varchar(60)","是","","行政区划代码"]
["jgrq","date","是","",""]
["xqwz","varchar(200)","是","","小区位置"]
["bfzt","varchar(60)","是","",""]
["lx","varchar(60)","是","",""]
["jsdw","varchar(60)","是","",""]
["kjsj","varchar(60)","是","",""]
[]
["20.gs_js_jcd(监测点属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(32)","否","","标识码"]
["xzqhdm","varchar(6)","否","","行政区划代码"]
["dwmc","varchar(64)","否","","点位名称"]
["ssmc","varchar(64)","是","","设施名称"]
["ssbm","varchar(17)","否","","设施编码"]
["jcwz","varchar(200)","是","","监测位置"]
["gc","numeric(10,3)","是","","高程"]
["gcjz","varchar(32)","是","","高程基准"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","是","","数据同步状态"]
["tbsj","timestamp(6)","是","","同步时间"]
["kjxx","geometry","是","","空间信息"]
["xzb","varchar(50)","是","","x坐标"]
["yzb","varchar(50)","是","","y坐标"]
[]
["21.holiday_management(休假管理表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","","id"]
["staff_name","varchar(32)","是","","人员姓名"]
["staff_number","varchar(64)","是","","人员编号"]
["staff_tel","varchar(16)","是","","人员手机号"]
["duty_date_start","timestamp(6)","是","","开始时间"]
["duty_date_end","timestamp(6)","是","","结束时间"]
["deleted","int4","是","0",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["22.industry_supervision_data(行业监督-行业资料库)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["name","varchar(255)","是","","资料名称"]
["type","varchar(500)","是","","资料类别"]
["years","timestamp(6)","是","","资料年代"]
["keyword","text","是","","关键字"]
["scene","varchar(50)","是","","所属专项  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["annex","varchar(500)","是","","资料"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
[]
["23.industry_supervision_drill(行业监督-行业知识管理-应急演练管理)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["name","varchar(500)","是","","演练名称"]
["type","varchar(50)","是","","演练类别"]
["department","varchar(100)","是","","所属部门"]
["revision_time","timestamp(6)","是","","演练修订时间"]
["commander","varchar(100)","是","","演练总指挥"]
["drill_time","timestamp(6)","是","","演练时间"]
["location","varchar(2000)","是","","演练地点"]
["unit","varchar(200)","是","","参与单位（部门）"]
["participant_num","varchar(50)","是","","参加演练人数"]
["content","text","是","","演练总结"]
["scene","varchar(50)","是","","专项场景  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["label","varchar(500)","是","","标签"]
["annex","varchar(500)","是","","演练内容"]
["release_time","timestamp(6)","是","","发布时间"]
["state","varchar(50)","是","","发布状态 未发布:0  已发布:1"]
["order_num","int8","是","","排序"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1",""]
[]
["24.industry_supervision_evaluate(行业监督-行业评价)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["name","varchar(500)","是","","企业名称"]
["national_rank","int8","是","","全国排名"]
["jiangsu_rank","int8","是","","江苏省排名"]
["wuxi_rank","int8","是","","无锡市排名"]
["rank_time","timestamp(6)","是","","排名统计时间"]
["scene","varchar(50)","是","","专项场景  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["label","varchar(500)","是","","标签"]
["annex","varchar(500)","是","","附件"]
["release_time","timestamp(6)","是","","发布时间"]
["state","varchar(50)","是","","发布状态 未发布:0  已发布:1"]
["order_num","int8","是","","排序"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
["annexwuxi_rank","text","是","","无锡附件"]
["annexjiangsu_rank","text","是","","江苏附件"]
["annexnational_rank","text","是","","全国附件"]
[]
["25.industry_supervision_knowledge(行业监督-行业知识管理-事件处置知识)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["name","varchar(500)","是","","事件名称"]
["scene","varchar(50)","是","","专项场景  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["label","varchar(500)","是","","标签"]
["annex","varchar(500)","是","","处置措施"]
["release_time","timestamp(6)","是","","发布时间"]
["state","varchar(50)","是","","发布状态 未发布:0  已发布:1"]
["order_num","int8","是","","排序"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1",""]
[]
["26.industry_supervision_patrol(行业监督管理-巡查养护-巡查养护记录)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","","主键"]
["scene","varchar(50)","是","","所属专项  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["type","varchar(500)","是","","巡查养护类型 "]
["object","varchar(500)","是","","巡查对象 "]
["unit","varchar(500)","是","","检查单元 "]
["project","varchar(500)","是","","检查项目 "]
["function","varchar(500)","是","","检查方法 "]
["content","varchar(2000)","是","","检查内容 "]
["result","varchar(500)","是","","检查结果 "]
["pitfall","varchar(500)","是","","存在隐患 "]
["check_time","timestamp(6)","是","","检查时间 "]
["checker","varchar(500)","是","","检查人员 "]
["owner","varchar(500)","是","","设施权属单位 "]
["manager","varchar(500)","是","","主管单位 "]
["annex","varchar(2000)","是","","附件 "]
["remark","varchar(2000)","是","","备注 "]
["order_num","int8","是","","排序"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
["plan_id","varchar(50)","是","","巡查养护计划ID"]
["area","varchar(50)","是","","行政区划"]
[]
["27.industry_supervision_patrol_plan(行业监督管理-巡查养护-巡查养护计划)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["scene","varchar(50)","是","","所属专项  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["type","varchar(500)","是","","巡查养护类型 "]
["frequency_type","varchar(50)","是","","频次类型 "]
["planned_frequency","int8","是","","计划频次 "]
["planned_count","int8","是","","计划巡查总数 "]
["order_num","int8","是","","排序"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
["area","varchar(50)","是","","行政区划"]
[]
["28.industry_supervision_patrol_plan_dtl(行业监督管理-巡查养护-巡查养护计划明细表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["plan_id","varchar(50)","是","","巡查养护计划主键"]
["frequency_type","varchar(50)","是","","频次类型 "]
["plan_time","timestamp(6)","是","","计划时间 "]
["plan_count","int8","是","","巡查养护对象数量 "]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
[]
["29.industry_supervision_plan(行业监督-规划建设)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["type","varchar(50)","是","","项目类型"]
["unit","varchar(500)","是","","项目承建单位"]
["name","varchar(500)","是","","项目名称"]
["content","text","是","","项目内容简介"]
["level","varchar(50)","是","","层级 国家级、江苏省、无锡市"]
["completion_time","timestamp(6)","是","","预计完成时间"]
["scene","varchar(50)","是","","所属专项  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["label","varchar(500)","是","","标签"]
["annex","varchar(500)","是","","项目内容简介"]
["release_time","timestamp(6)","是","","发布时间"]
["state","varchar(50)","是","","发布状态 未发布:0  已发布:1"]
["order_num","int8","是","","排序"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
["cb","int4","是","0",""]
[]
["30.industry_supervision_plan_lifeline(行业监督-规划建设(平台设置部分))"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["project_progress","int4","是","","项目进度0-100的值"]
["project_progress_description","varchar(1024)","是","","项目进度描述"]
[]
["31.industry_supervision_report(行业监督-行业通报)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["title","varchar(500)","是","","通报标题"]
["image","varchar(500)","是","","通报首页大图"]
["content","text","是","","通报内容"]
["level","varchar(500)","是","","层级 0国家级、1江苏省、2无锡市"]
["scene","varchar(50)","是","","所属专项 0 燃气爆炸、1城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["annex","varchar(255)","是","","附件"]
["release_time","timestamp(6)","是","","发布时间"]
["state","varchar(50)","是","","发布状态 未发布:0  已发布:1"]
["order_num","int8","是","","排序"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
[]
["32.industry_supervision_scheme(行业监督-行业知识管理-应急预案管理)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["bsm","varchar(50)","是","","标识码"]
["name","varchar(500)","是","","应急预案名称"]
["number","varchar(500)","是","","应急预案编码"]
["scene","varchar(50)","是","","专项场景  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["annex","varchar(500)","是","",""]
["location","varchar(500)","是","","空间信息"]
["geometry_data","geometry","是","","地图选点"]
["release_time","timestamp(6)","是","","预案启动时间"]
["state","varchar(50)","是","","预案状态 未启动:0  已启动:1"]
["order_num","int8","是","","排序"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1",""]
["yabzdw","varchar(500)","是","","预案编制单位"]
["type","varchar(500)","是","","预案类型"]
["keyword","varchar(255)","是","","关键字"]
["syfw","text","是","","适用范围"]
["yazlc","varchar(500)","是","","预案主流程"]
["yanr","text","是","","预案内容"]
["area","varchar(255)","是","","区县"]
["warning_rank","varchar(16)","是","","预警级别 1一级、2二级、3三级、4四级(通用_JCYJ_YJJB_DM)"]
[]
["33.industry_supervision_scheme_node(应急预案节点)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["supervision_scheme_id","varchar(64)","是","","应急预案id"]
["dept_name","varchar(500)","是","","部门名称"]
["dept_id","varchar(500)","是","","部门id"]
["ya_node_name","varchar(64)","是","","预案节点"]
["bz","varchar(500)","是","","备注"]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["disposal_time","int4","是","","处置时间(分钟)"]
[]
["34.industry_supervision_scheme_resource(应急预案资源保障)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["supervision_scheme_id","varchar(64)","是","","应急预案id"]
["resource_type","varchar(64)","是","","资源类型"]
["resource_id","varchar(500)","是","","资源id"]
["resource_name","varchar(500)","是","","资源名称"]
["bz","varchar(500)","是","","备注"]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["35.industry_supervision_supervise(行业监督-事项督办)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["content","text","是","","督办事项"]
["level","varchar(50)","是","","督办层级 省级督办、市级督办"]
["unit","varchar(500)","是","","签发单位"]
["process_status","varchar(50)","是","","事项状态"]
["plan_time","timestamp(6)","是","","要求完成时限"]
["start_time","timestamp(6)","是","","任务下达时间"]
["end_time","timestamp(6)","是","","任务完成时间"]
["scene","varchar(50)","是","","业务专项  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["label","varchar(500)","是","","标签"]
["annex","varchar(500)","是","","附件"]
["release_time","timestamp(6)","是","","发布时间"]
["state","varchar(50)","是","","发布状态 未发布:0  已发布:1"]
["order_num","int8","是","","排序"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
["supervise_rank","varchar(50)","是","","等级（重大、较大、一般）"]
["supervise_area","varchar(50)","是","","所属区域"]
["type","varchar(50)","是","","督办类型"]
["area","varchar(50)","是","","行政区划"]
["duty_unit","varchar(500)","是","","责任单位"]
["result","varchar(50)","是","","督办结果"]
["rel_id","varchar(50)","是","","关联id"]
["sms_phone","varchar(1000)","是","",""]
["sms_content","varchar(1000)","是","",""]
[]
["36.industry_supervision_supervise_process(无注释)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键ID"]
["supervise_id","varchar(50)","是","","督办ID"]
["result","varchar(50)","是","","督办结果"]
["remark","varchar(2000)","是","","备注"]
["created_at","timestamp(6)","是","","数据创建日期"]
["created_by","varchar(100)","是","","数据创建人员"]
["updated_at","timestamp(6)","是","","数据更新日志"]
["updated_by","varchar(100)","是","","数据更新人员"]
["del_flag","int4","是","","逻辑删除状态 无效：0 有效：1"]
[]
["37.jcss_gscz(供水厂站)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["jcss_id","varchar(64)","是","","基础设施id"]
["czlx","varchar(64)","是","","厂站类型 0原水厂、1自来水厂、2增压站、3二次供水泵房"]
["symc","varchar(64)","是","","水源名称"]
["sylx","varchar(64)","是","","水源类型 0地表水、1地下水"]
["qsgm","numeric(10,2)","是","","取水规模"]
["yjsymc","varchar(64)","是","","应急水源名称"]
["yjsylx","varchar(64)","是","","应急水源类型 0地表水、1地下水"]
["yjqsgm","numeric(10,2)","是","","应急取水规模"]
["yjqsts","numeric(10,2)","是","","应急取水天数"]
["gsgm","numeric(10,2)","是","","供水规模"]
["gsrk","numeric(10,2)","是","","供水人口"]
["gsqy","varchar(250)","是","","供水区域"]
["clgy","varchar(64)","是","","处理工艺"]
["tcrq","timestamp(6)","是","","投产日期"]
["zyzlx","varchar(500)","是","","增压站类型"]
["jgrq","timestamp(6)","是","","竣工日期"]
["remark","varchar(500)","是","","备注"]
["defined","int4","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["38.jcss_jlss(截流设施)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["jcss_id","varchar(64)","是","","基础设施id"]
["sspsxt","varchar(64)","是","","所属排水系统"]
["jlsslx","varchar(64)","是","","截流设施类型 1-闸，2-泵，3-堰，4-阀，5-其他"]
["jlssljgqbm","varchar(64)","是","","截流设施连接管渠编码"]
["jlnbssbm","varchar(64)","是","","截流内部设施编码"]
["jll","numeric(6,2)","是","","截流量"]
["jlqx","int4","是","","截流曲线"]
["bz","varchar(500)","是","","备注"]
["defined","int4","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["39.jcss_pscz(排水场站)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["jcss_id","varchar(64)","是","","基础设施id"]
["czlx","varchar(64)","是","","厂站类型 0污水处理厂、1雨水泵站、2污水泵站"]
["jgrq","timestamp(6)","是","","竣工日期"]
["wscljb","varchar(64)","是","","污水处理级别 0一级、1二级、2三级"]
["nhdl","numeric(10,2)","是","","年耗电量"]
["wsclsjgm","numeric(10,2)","是","","污水处理设计规模"]
["wsyxfhl","numeric(10,2)","是","","污水运行负荷率"]
["ysclsjgm","numeric(10,2)","是","","雨水处理设计规模"]
["wnclsjgm","numeric(10,2)","是","","污泥处理设计规模"]
["wnyxfhl","numeric(10,2)","是","","污泥运行负荷率"]
["wnczfs","varchar(64)","是","","污泥处置方式 0填埋、1焚烧、2土地利用、3建材利用、4堆肥、5其它"]
["wnczdw","varchar(100)","是","","污泥处置单位"]
["bzsbts","int4","是","","泵站水泵台数"]
["bzzgl","numeric(10,2)","是","","泵站总功率"]
["bzzll","numeric(10,2)","是","","泵站总流量"]
["bzzp","varchar(500)","是","","泵站照片"]
["remark","varchar(500)","是","","备注"]
["defined","int4","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["40.jcss_psgd(排水管点)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["jcss_id","varchar(64)","是","","基础设施id"]
["dmgc","numeric(10,3)","是","","地面高程"]
["fsw","varchar(64)","是","","附属物"]
["szdl","varchar(64)","是","","所在道路"]
["jsdm","varchar(64)","是","","井室代码"]
["xzj","numeric(10,3)","是","","旋转角"]
["js","numeric(10,2)","是","","井深"]
["jgxz","varchar(64)","是","","井盖形状 0圆形、1矩形"]
["jgcz","varchar(64)","是","","井盖材质"]
["jgzj","numeric(10,2)","是","","井盖直径"]
["jgc","numeric(10,2)","是","","井盖长"]
["jgk","numeric(10,2)","是","","井盖宽"]
["jxjcz","varchar(64)","是","","检修井材质 0水泥、1砖"]
["jbs","numeric(10,2)","是","","井脖深"]
["jszj","numeric(10,2)","是","","井室直径"]
["qsdw","varchar(100)","是","","权属单位"]
["remark","varchar(500)","是","","备注"]
["defined","int4","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["41.jcss_psgx(排水管线)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["jcss_id","varchar(64)","是","","基础设施id"]
["qddh","varchar(64)","是","","起点点号"]
["zddh","varchar(64)","是","","终点点号"]
["qdgc","numeric(10,2)","是","","起点高程"]
["zdgc","numeric(10,2)","是","","终点高程"]
["qdms","numeric(10,2)","是","","起点埋深"]
["zdms","numeric(10,2)","是","","终点埋深"]
["mslx","varchar(64)","是","","埋设类型 0直埋、1矩形管沟、2拱形管沟、3管块、4管埋、5架空、6井内连线、7顶管"]
["cz","varchar(64)","是","","材质"]
["gj","varchar(32)","是","","管径"]
["yl","varchar(32)","是","","压力"]
["szdl","varchar(64)","是","","所在道路"]
["qsdw","varchar(100)","是","","权属单位"]
["lb","varchar(64)","是","","类別 0雨水、1污水、2合流"]
["gdjb","varchar(64)","是","","管道级别 0主干管、1次干管、2支管"]
["lx","varchar(64)","是","","流向 0起点到终点、1终点到起点"]
["sfyl","varchar(64)","是","","是否有压 0是、1否"]
["gdyc","varchar(64)","是","","管道异常"]
["remark","varchar(500)","是","","备注"]
["defined","int4","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["42.jcss_pspk(排水排口)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["jcss_id","varchar(64)","是","","基础设施id"]
["lb","varchar(64)","是","","类别 0雨水、1污水、2合流"]
["dbgc","numeric(10,2)","是","","地表高程"]
["dbugc","numeric(10,2)","是","","顶部高程"]
["pkcc","varchar(64)","是","","排口尺寸"]
["sfypm","varchar(64)","是","","是否有拍门 0是、2否"]
["clxs","varchar(64)","是","","出流形式 0自由出流、1常水位淹没、2潮汐影响"]
["hdcsw","numeric(10,2)","是","","河道常水位"]
["pkzp","varchar(500)","是","","排口照片"]
["remark","varchar(500)","是","","备注"]
["defined","int4","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["43.jcss_rqcz(燃气场站)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["jcss_id","varchar(64)","是","","基础设施id"]
["czlx","varchar(16)","是","","场站类型 0-气化站、1-门站、2-储配站、3-加气站、4-调压站、5-瓶装供应站、6-LNG站"]
["cqnl","varchar(50)","是","","储气能力 单位：万立方米"]
["sjcql","varchar(50)","是","","实际储气量 单位：万立方米"]
["gznl","varchar(50)","是","","灌装能力 单位：万立方米"]
["ngql","numeric(10,2)","是","","年供气量 单位：万立方米"]
["xsgynl","numeric(10,2)","是","","小时供应能力 单位：万立方米；场站类型为门站、调压站、气化站、加气站时填写"]
["zps","numeric(10,2)","是","","(作废)重瓶数"]
["yl","numeric(10,2)","是","","(作废)压力 单位：Mpa 当场站类型为气化站、门站、储配站、加气站、调压站时填写，取场站整体运行数据"]
["ll","numeric(10,2)","是","","(作废)流量 单位：m³/h 当场站类型为门站、调压站时填写，取场站整体运行数据"]
["yw","numeric(10,2)","是","","(作废)液位 单位：mm 当场站类型为储配站、LNG站时填写，取场站整体运行数据"]
["wd","numeric(10,2)","是","","(作废)温度 单位：℃ 当场站类型为气化站、门站、储配站、加气站、调压站时填写，取场站整体运行数据"]
["jgrq","timestamp(6)","是","","竣工日期"]
["remark","varchar(500)","是","","备注"]
["defined","int4","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["44.jcss_rqgd(燃气管点)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["jcss_id","varchar(64)","是","","基础设施id"]
["dmgc","numeric(10,3)","是","","地面高程"]
["fsw","varchar(64)","是","","附属物"]
["szdl","varchar(64)","是","","所在道路"]
["jsdm","varchar(64)","是","","井室代码"]
["xzj","numeric(10,3)","是","","旋转角"]
["js","numeric(10,2)","是","","井深"]
["jgxz","varchar(64)","是","","井盖形状 0圆形、1矩形"]
["jgcz","varchar(64)","是","","井盖材质"]
["jgzj","numeric(10,2)","是","","井盖直径"]
["jgc","numeric(10,2)","是","","井盖长"]
["jgk","numeric(10,2)","是","","井盖宽"]
["jxjcz","varchar(64)","是","","检修井材质 0水泥、1砖"]
["jbs","numeric(10,2)","是","","井脖深"]
["jszj","numeric(10,2)","是","","井室直径"]
["qsdw","varchar(100)","是","","权属单位"]
["remark","varchar(500)","是","","备注"]
["defined","int4","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["45.jcss_rqgx(燃气管线)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["jcss_id","varchar(64)","是","","基础设施id"]
["qddh","varchar(64)","是","","起点点号"]
["zddh","varchar(64)","是","","终点点号"]
["qdgc","numeric(10,2)","是","","起点高程"]
["zdgc","numeric(10,2)","是","","终点高程"]
["qdms","numeric(10,2)","是","","起点埋深"]
["zdms","numeric(10,2)","是","","终点埋深"]
["mslx","varchar(64)","是","","埋设类型 0直埋、1矩形管沟、2拱形管沟、3管块、4管埋、5架空、6井内连线、7顶管"]
["cz","varchar(64)","是","","材质"]
["gj","varchar(32)","是","","管径"]
["yl","varchar(32)","是","","压力"]
["szdl","varchar(64)","是","","所在道路"]
["qsdw","varchar(100)","是","","权属单位"]
["gdjb","varchar(64)","是","","管道级别 0高压A、1高压B、2次高压A、3次高压 、4中压A、5中压B、6低压"]
["dqjz","varchar(64)","是","","当前介质"]
["bhcz","varchar(16)","是","","保护材质"]
["sjyl","varchar(32)","是","","设计压力"]
["fxdj","varchar(64)","是","","风险等级"]
["yxyl","varchar(32)","是","","运行压力"]
["tqrq","timestamp(6)","是","","通气日期"]
["jsdw","varchar(100)","是","","建设单位"]
["sccj","varchar(100)","是","","生产厂家"]
["ffxs","varchar(64)","是","","防腐形式"]
["fsqk","varchar(64)","是","","腐蚀情况"]
["jkfs","varchar(64)","是","","接口方式"]
["lmxz","varchar(64)","是","","路面性质 0水泥、1柏油、2土路、3弹石、4绿化地、5人行道板、6农田"]
["zjgzsj","timestamp(6)","是","","最近改造时间"]
["remark","varchar(500)","是","","备注"]
["defined","int4","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["46.jcss_txss(调蓄设施)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["jcss_id","varchar(64)","是","","基础设施id"]
["txssbm","varchar(64)","是","","调蓄设施编码"]
["lb","varchar(64)","是","","类别"]
["qsdw","varchar(64)","是","","权属单位"]
["sspsxt","varchar(64)","是","","所属排水系统"]
["zgsw","numeric(10,2)","是","","最高水位"]
["zdsw","numeric(10,2)","是","","最低水位"]
["txssrj","numeric(10,2)","是","","调蓄设施容积"]
["txsslx","varchar(64)","是","","调蓄设施类型"]
["txsscz","varchar(64)","是","","调蓄设施材质"]
["remark","varchar(500)","是","","备注"]
["defined","int4","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["47.jg_yhjl(养护记录)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","","主键"]
["scene","varchar(5)","是","","专项场景"]
["bsm","varchar(32)","是","","标识码"]
["xzqhdm","varchar(16)","是","","行政区划"]
["yhdx","varchar(255)","是","","养护对象"]
["yhrq","date","是","","养护日期"]
["yhnr","varchar(255)","是","","养护内容"]
["zyry","varchar(32)","是","","作业人员"]
["fj","text","是","","附件"]
["bz","varchar(255)","是","","备注"]
["tbsj","date","是","","同步时间"]
["del_flag","int4","是","","逻辑删除状态 无效：0 有效：1"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
[]
["48.jg_yhjl_fj(养护记录)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(32)","否","","主键"]
["rel_id","varchar(32)","是","","养护计划id"]
["name","varchar(255)","是","","附件名称"]
["url","varchar(255)","是","","附件地址"]
["del_flag","int4","是","",""]
["create_time","timestamp(6)","是","",""]
["create_user","varchar(50)","是","",""]
["update_time","timestamp(6)","是","",""]
["update_user","varchar(50)","是","",""]
[]
["49.jg_yqgl(热点舆情)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(32)","否","","主键"]
["source","varchar(32)","是","","舆情来源"]
["title","varchar(255)","是","","标题"]
["yqxq","text","是","","舆情详情"]
["fj","text","是","","附件"]
["del_flag","int4","是","","逻辑删除状态 无效：0 有效：1"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
[]
["50.jg_zdgz(重点工作)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(32)","否","","主键"]
["type","varchar(32)","是","","重点工作类型"]
["level","varchar(32)","是","","任务级别"]
["name","varchar(255)","是","","任务名称"]
["rwjd","varchar(6)","是","","任务进度"]
["rwxq","text","是","","任务详情"]
["fj","text","是","","附件"]
["del_flag","int4","是","","逻辑删除状态 无效：0 有效：1"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
[]
["51.linkage_coordinate(联动协调表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["event_number","varchar(100)","是","","事件编号"]
["scene","varchar(16)","是","","事件场景"]
["event_name","varchar(64)","是","","事件名称"]
["event_rank","varchar(16)","是","","事件等级 0一级、1二级、2三级、3四级"]
["occur_time","timestamp(6)","是","","事件发生时间"]
["occur_site","varchar(100)","是","","事件发生地点"]
["area","varchar(16)","是","","行政区划"]
["issue_time","timestamp(6)","是","","联动下发时间"]
["manage_dept","varchar(300)","是","","事件主管部门"]
["manage_dept_id","varchar(300)","是","","事件主管部门id"]
["coordinate_dept","varchar(300)","是","","联动协调部门"]
["coordinate_dept_id","varchar(300)","是","","联动协调部门id"]
["disposal_progress","varchar(16)","是","","联动协调进度"]
["disposal_time","timestamp(6)","是","","事件处理时间"]
["disposal_complete_time","timestamp(6)","是","","联动完成时间"]
["geom_data","geometry","是","","空间信息"]
["defined","int4","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["remark","varchar(500)","是","","备注"]
["event_id","varchar(64)","是","","事件id"]
["coordinate_source","varchar(64)","是","",""]
["sms_phone","varchar(1000)","是","",""]
["sms_content","varchar(1000)","是","",""]
["attachments","varchar(1000)","是","",""]
[]
["52.linkage_coordinate_send(联动协调下发表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["scene","varchar(16)","是","","所属专项"]
["coordinate_id","varchar(64)","是","","联动协调id"]
["event_number","varchar(64)","是","","事件编号"]
["event_sub_number","varchar(64)","是","","关联子事件编号"]
["handler","varchar(64)","是","","处理人"]
["complete_attachments","varchar(600)","是","","处理后的图片"]
["disposal_dept","varchar(255)","是","","处理部门"]
["feedback","varchar(500)","是","","处理结果说明"]
["process_time","timestamp(6)","是","","处理时间"]
["state","varchar(16)","是","","当前处理状态"]
["yjyabh","varchar(255)","是","","关联应急预案编号"]
["bz","varchar(500)","是","","备注"]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["53.local_dict(行政区划代码表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(16)","否","","id"]
["city","varchar(255)","是",""," 城市名称"]
["district","varchar(255)","是","","区名称"]
["street","varchar(255)","是","","街道名称"]
["code","varchar(255)","是","","行政区划代码"]
["type","varchar(1)","是","","种类1市,2区,3街道,4社区"]
["community","varchar(255)","是","","社区名称"]
["order","int4","是","","排序"]
[]
["54.local_dict_jcss(业务字典-基础设施)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["scene","varchar(64)","是","",""]
["big_category","varchar(64)","是","",""]
["small_category","varchar(64)","是","",""]
["code","varchar(64)","是","",""]
["type","varchar(64)","是","",""]
["description","varchar(64)","是","",""]
["sort","int4","是","",""]
["bz","varchar(500)","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["55.manager_organization(主管运营组织)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(100)","否","","主键"]
["item_scene","varchar(50)","是","","专项场景（字典）"]
["organization_type","varchar(50)","是","","单位类型（字典）"]
["organization_name","varchar(255)","是","","单位名称"]
["organization_duty","varchar(255)","是","","单位职责"]
["create_user","varchar(100)","是","","创建人"]
["create_time","timestamp(6)","是","","创建时间"]
["update_user","varchar(100)","是","","更新人"]
["update_time","timestamp(6)","是","","更新时间"]
["del_tag","int4","是","1","删除标识（0已删、1未删）"]
[]
["56.message_read(无注释)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","","id"]
["source_id","varchar(128)","是","","原表id"]
["user_id","varchar(64)","是","","推送用户id"]
["source_type","varchar(4)","是","","原表映射关系('1':warning_info[预警管理表],2:industry_supervision_report行业公告查看,3:work_order_admin工单管理,4用户对应急专家zy_js_yjzj,5应急专家对用户chat_topic)"]
["deleted","int4","是","","1不删除0已经删除"]
["create_time","timestamp","是","","创建时间"]
["update_time","timestamp","是","","修改时间"]
["creater_id","varchar(64)","是","","创建人id"]
["updater_id","varchar(64)","是","","修改人id"]
["is_read","int4","是","","是否已读1已读,0未读"]
["remark","varchar(255)","是","","备注"]
["source_id2","varchar(255)","是","","原表id2"]
["name","varchar(1000)","是","","名称"]
[]
["57.operation_maintain_assets(运行维护-设备资产管理)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["scene","varchar(50)","是","","所属专项  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["name","varchar(500)","是","","设备名称"]
["bsm","varchar(500)","是","","标识码"]
["model","varchar(500)","是","","规格型号"]
["purchase_time","timestamp(6)","是","","购置日期"]
["producer","varchar(500)","是","","生产商"]
["enable_time","timestamp(6)","是","","启用日期"]
["location","varchar(2000)","是","","设备位置"]
["assets_state","varchar(50)","是","","设备状态 未使用、正常、试运行、故障、维修、报废"]
["scrap_time","timestamp(6)","是","","报废日期"]
["label","varchar(500)","是","","标签"]
["annex","varchar(500)","是","","附件"]
["order_num","int8","是","",""]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
["geometry_data","geometry","是","",""]
[]
["58.operation_maintain_performance(运行维护-设备绩效管理)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["assets_id","varchar(50)","是","","设备 id ，需要关联设备资产表"]
["assets_state","varchar(50)","是","","设备状态 未使用、正常、试运行、故障、维修、报废"]
["failure_rate","varchar(50)","是","","设备故障率"]
["online_rate","varchar(50)","是","","设备在线率"]
["data_quality","varchar(50)","是","","设备数据质量  下拉框"]
["maintain_num","varchar(50)","是","","保养次数（次）"]
["failure_num","varchar(50)","是","","故障次数（次）"]
["repair_duration","varchar(50)","是","","平均故障维修时间（小时）"]
["score","varchar(50)","是","","设备评分"]
["score_time","timestamp(6)","是","","评分日期"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
[]
["59.operation_maintain_platform(运行维护-平台手册)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["name","varchar(200)","是","","手册名称"]
["scene","varchar(50)","是","","所属专项  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["modify_time","timestamp(6)","是","","修改时间"]
["type","varchar(50)","是","","文件类型"]
["size","varchar(50)","是","","文件大小"]
["down_num","varchar(50)","是","","下周次数"]
["annex","varchar(500)","是","","附件地址"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
[]
["60.ps_jc_jcsb(监测设备属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(32)","否","","标识码"]
["dwbsm","varchar(32)","否","","点位标识码"]
["sblx","varchar(32)","否","","设备类型"]
["sbmc","varchar(50)","否","","设备名称"]
["sbxh","varchar(32)","是","","设备型号"]
["jczb","varchar(32)","否","","监测指标"]
["cjpl","varchar(32)","否","","采集频率"]
["scpl","varchar(32)","否","","上传频率"]
["sbzt","int4","否","","设备状态"]
["csmc","varchar(50)","是","","厂商名称"]
["xdgd","numeric(10,3)","是","","相对高度"]
["azsj","date","是","","安装时间"]
["azwhdw","varchar(100)","是","","安装维护单位"]
["gdfs","varchar(32)","是","","供电方式"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","否","","数据同步状态"]
["tbsj","timestamp(6)","否","","同步时间"]
["lb","int4","否","1","类别：1(雨水)/2(污水)/3(合流)"]
[]
["61.ps_jc_jcxyz(监测项阈值属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","否","","标识码"]
["sbbsm","varchar(64)","是","","设备标识码"]
["sblx","varchar(32)","是","","设备类型"]
["jczb","varchar(32)","是","","监测指标"]
["bjyz","numeric(13,3)","是","","报警阈值"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","是","","数据同步状态"]
["tbsj","timestamp(6)","是","","同步时间"]
["lb","int4","是","1","类别：1(雨水)/2(污水)/3(合流)"]
[]
["62.ps_jg_ysfxgk(雨水风险管控)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","是","",""]
["xzqhdm","varchar(16)","是","",""]
["nf","varchar(64)","是","",""]
["fxmc","varchar(64)","是","",""]
["fxdj","varchar(64)","是","",""]
["fxly","varchar(255)","是","",""]
["fxnr","varchar(255)","是","",""]
["wz","varchar(100)","是","",""]
["mj","numeric(12,2)","是","",""]
["gkcs","varchar(255)","是","",""]
["sfgk","varchar(1)","是","",""]
["gkzt","varchar(64)","是","",""]
["yskzjbz","varchar(64)","是","",""]
["sjtbzt","varchar(16)","是","",""]
["tbsj","timestamp(6)","是","",""]
["kjxx","geometry","是","",""]
[]
["63.ps_js_jcd(监测点属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(32)","否","","标识码"]
["xzqhdm","varchar(6)","否","","行政区划代码"]
["dwmc","varchar(64)","否","","点位名称"]
["ssmc","varchar(64)","是","","设施名称"]
["ssbm","varchar(17)","否","","设施编码"]
["jcwz","varchar(200)","是","","监测位置"]
["gc","numeric(10,3)","是","","高程"]
["gcjz","varchar(32)","是","","高程基准"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","是","","数据同步状态"]
["tbsj","timestamp(6)","是","","同步时间"]
["lb","int4","否","1","类别：1(雨水)/2(污水)/3(合流)"]
["jcfx","int4","是","","监测方向"]
["kjxx","geometry","是","","空间信息"]
[]
["64.ps_js_psh(重点排水户属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(255)","否","","标识码"]
["xzqhdm","varchar(255)","是","","行政区划代码"]
["sspsxt","varchar(255)","是","","所属排水系统"]
["pshmc","varchar(255)","否","","排水户名称"]
["pshdz","varchar(255)","否","","排水户地址"]
["jrjcjbm","varchar(255)","是","","接入检查井编码"]
["zzjgdm","varchar(255)","是","","组织机构代码"]
["lxdh","varchar(255)","否","","联系电话"]
["zgdw","varchar(255)","是","","主管单位"]
["pshlx","varchar(255)","是","","排水户类型"]
["sfwzdpsh","varchar(255)","否","","是否为重点排水户"]
["zyscgy","varchar(255)","是","","主要生产工艺"]
["psxkzbh","varchar(255)","是","","排水许可证编号"]
["yhzl","varchar(255)","是","","用户总量"]
["zbsl","varchar(255)","是","","自备水量"]
["zpsl","varchar(255)","是","","总排水量"]
["scwsl","varchar(255)","是","","生产污水量"]
["shwsl","varchar(255)","是","","生活污水量"]
["dylwrwmc","varchar(255)","是","","第一类污染物名称"]
["delwrwmc","varchar(255)","是","","第二类污染物名称"]
["wsclfs","varchar(255)","是","","污水处理方式"]
["wsclgm","varchar(255)","是","","污水处理规模"]
["sjhqrq","varchar(255)","是","","数据获取日期"]
["tbdw","varchar(255)","是","","填报单位"]
["tbrq","varchar(255)","是","","填报日期"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(255)","是","","原始库主键标志"]
["sjtbzt","varchar(255)","是","","数据同步状态"]
["tbsj","varchar(255)","是","","同步时间"]
["kjxx","text","是","","空间信息"]
["mrdb","varchar(255)","是","",""]
["xkzffrq","varchar(255)","是","",""]
["jszlwjs","varchar(255)","是","",""]
["jly","varchar(255)","是","",""]
[]
["65.ps_js_xxtd(行泄通道属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","否","","标识码"]
["xzqhdm","varchar(16)","是","","行政区划代码"]
["xxtdbm","varchar(64)","是","","行泄通道编码"]
["dbysxxtdlx","int4","否","","地表雨水行泄通道类型"]
["lmdjymclx","int4","是","","路面等级与面层类型"]
["dbysxxtdcl","numeric(11,4)","否","","地表雨水行泄通道糙率"]
["sjly","varchar(255)","是","","数据来源"]
["sjhqrq","date","是","","数据获取日期"]
["tbdw","varchar(255)","是","","填报单位"]
["tbrq","date","是","","填报日期"]
["dlmc","varchar(255)","否","","道路名称"]
["dz","varchar(255)","否","","地址"]
["cd","numeric(12,3)","否","","长度"]
["mj","numeric(14,2)","否","","面积"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(255)","是","","原始库主键标志"]
["sjtbzt","varchar(255)","是","","数据同步状态"]
["tbsj","timestamp(6)","是","","同步时间"]
["kjxx","text","是","","空间信息"]
[]
["66.ps_js_yld(ps_js_yld-->NL_JG_YLD排水易涝点属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","是","",""]
["xzqhdm","varchar(16)","是","",""]
["mc","varchar(50)","是","",""]
["dz","varchar(255)","是","",""]
["fxdj","varchar(32)","是","",""]
["dcjyl","varchar(32)","是","",""]
["dcjylcxsj","varchar(32)","是","",""]
["dczdnlss","varchar(32)","是","",""]
["dczdysmj","varchar(32)","是","",""]
["dcnlcxsj","varchar(32)","是","",""]
["nlzyyy","text","是","",""]
["dcrq","timestamp(6)","是","",""]
["qyqkms","text","是","",""]
["tbdw","varchar(100)","是","",""]
["tbrq","timestamp(6)","是","",""]
["bz","varchar(255)","是","",""]
["kjxx","varchar(255)","是","",""]
["yskzjbz","varchar(255)","是","",""]
["sjtbzt","varchar(255)","是","",""]
["tbsj","varchar(255)","是","",""]
["ydcs","varchar(255)","是","",""]
["cx","varchar(255)","是","",""]
["zzzt","int4","是","",""]
["zzsj","timestamp(6)","是","",""]
[]
["67.ps_js_zyhd(主要河道)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","是","","标识码"]
["xzqhdm","varchar(16)","是","","行政区划代码"]
["hdbm","varchar(64)","是","","河道编码"]
["hlmc","varchar(20)","是","","河流名称"]
["hdcd","numeric(11,3)","是","","河段长度"]
["qdzhbm","varchar(17)","是","","起点桩号编码"]
["zdzhbm","varchar(17)","是","","终点桩号编码"]
["qdhdbg","numeric(10,3)","是","","起点河底标高"]
["zdhdbg","numeric(10,3)","是","","终点河底标高"]
["csw","numeric(8,2)","是","","常水位"]
["jjsw","numeric(8,2)","是","","警戒水位"]
["bz","varchar(255)","是","","备注"]
["kjxx","geometry","是","","空间信息"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","是","","数据同步状态"]
["tbsj","timestamp(6)","是","","同步时间"]
[]
["68.public_report_hidden_trouble_lifeline(公众上报的隐患)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["scene","varchar(16)","是","","专项场景"]
["area","varchar(16)","是","","行政区划"]
["hidden_trouble_name","varchar(500)","是","","隐患名称"]
["report_type","varchar(16)","是","","上报类型"]
["hidden_trouble_description","varchar(2000)","是","","隐患描述"]
["hidden_trouble_address","varchar(500)","是","","隐患地址"]
["hidden_trouble_grade","varchar(16)","是","","隐患等级 0-I级、1-II级、2-III级、3-IV级(备用)"]
["find_time","timestamp(6)","是","","发现时间"]
["report_unit","varchar(200)","是","","上报单位(备用)"]
["report_people","varchar(32)","是","","上报人员"]
["report_people_tel","varchar(32)","是","","人员联系电话"]
["scene_photo","text","是","","现场照片"]
["dispose_progress","varchar(16)","是","","处置进度 0未处置、1处置中、2已完成"]
["dispose_unit","varchar(200)","是","","处置单位"]
["dispose_people","varchar(32)","是","","处置负责人"]
["dispose_people_tel","varchar(32)","是","","负责人联系电话"]
["dispose_finish_time","timestamp(6)","是","","处置完成时间"]
["remark","varchar(500)","是","","备注 "]
["dispose_photo","text","是","","处置照片"]
["defined","int4","是","","自定义(1时为公众上报数据,null为平台修改数据)"]
["deleted","int4","是","","是否删除"]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["geom_data","geometry","是","","空间信息(备用)"]
[]
["69.ql_jc_jcsb(监测设备属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(32)","否","","标识码"]
["dwbsm","varchar(32)","否","","点位标识码"]
["sblx","varchar(32)","否","","设备类型"]
["sbmc","varchar(50)","否","","设备名称"]
["sbxh","varchar(32)","是","","设备型号"]
["jczb","varchar(32)","否","","监测指标"]
["cjpl","varchar(32)","否","","采集频率"]
["scpl","varchar(32)","否","","上传频率"]
["sbzt","int4","否","","设备状态"]
["csmc","varchar(50)","是","","厂商名称"]
["xdgd","numeric(10,3)","是","","相对高度"]
["azsj","date","是","","安装时间"]
["azwhdw","varchar(100)","是","","安装维护单位"]
["gdfs","varchar(32)","是","","供电方式"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","否","","原始库主键标志"]
["sjtbzt","varchar(16)","否","","数据同步状态"]
["tbsj","timestamp(6)","否","","同步时间"]
[]
["70.ql_jc_jcxyz(桥梁监测项阈值属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","否","","标识码"]
["sbbsm","varchar(64)","是","","设备标识码"]
["sblx","varchar(32)","是","","设备类型"]
["jczb","varchar(32)","是","","监测指标"]
["bjyz","numeric(13,3)","是","","报警阈值"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","是","","数据同步状态"]
["tbsj","timestamp(6)","是","","同步时间"]
[]
["71.ql_jg_fxpg(风险评估)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","是","","标识码"]
["xzqhdm","varchar(16)","是","","行政区划代码"]
["qlmc","varchar(255)","是","","桥梁名称"]
["qlbh","varchar(64)","是","","桥梁编号"]
["pgsj","timestamp(6)","是","","评估时间"]
["fxmc","varchar(255)","是","","风险名称"]
["fxdj","int4","是","","风险等级"]
["fxms","varchar(100)","是","","风险描述"]
["gkzt","varchar(64)","是","","管控状态"]
["bz","varchar(255)","是","","备注"]
["tbsj","timestamp(6)","是","","同步时间"]
["tbzt","int4","是","",""]
["kjxx","varchar(4000)","是","","空间信息"]
["yskzjbz","varchar(32)","是","","原始库主键标志"]
["gkcs","varchar(100)","是","","管控措施"]
["sjtbzt","varchar(16)","是","","数据同步状态"]
[]
["72.ql_js_jcd(桥梁监测点属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(32)","否","","标识码"]
["xzqhdm","varchar(6)","否","","行政区划代码"]
["dwmc","varchar(64)","否","","点位名称"]
["ssmc","varchar(64)","是","","设施名称"]
["ssbm","varchar(17)","否","","设施编码"]
["jcwz","varchar(200)","是","","监测位置"]
["gc","numeric(10,3)","是","","高程"]
["gcjz","varchar(32)","是","","高程基准"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","否","","原始库主键标志"]
["sjtbzt","varchar(16)","否","","数据同步状态"]
["tbsj","timestamp(6)","否","","同步时间"]
["kjxx","geometry","是","","空间信息"]
["zb_xy","varchar(255)","是","","xy坐标"]
[]
["73.ql_js_ql(桥梁属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(32)","否","","标识码"]
["xzqhdm","varchar(6)","是","","行政区划代码"]
["qlmc","varchar(32)","是","","桥梁名称"]
["jgny","varchar(32)","是","","竣工年月"]
["szdlmc","varchar(32)","是","","所在道路名称"]
["dldj","int4","是","","道路等级"]
["kjfl","int4","是","","跨径分类"]
["jglx","int4","是","","结构类型"]
["kjzh","varchar(4000)","是","","跨径组合"]
["qlzc","numeric(12,2)","是","","桥梁总长"]
["qlzk","numeric(8,2)","是","","桥梁总宽"]
["kydw","int4","是","","跨越地物"]
["thdj","int4","是","","通航等级"]
["sfdzd","int4","是","","是否独柱墩"]
["qmmj","numeric(12,2)","是","","桥面面积"]
["kzld","int4","是","","抗震烈度"]
["yhlb","int4","是","","养护类别"]
["yhdj","int4","是","","养护等级"]
["qlwhzk","varchar(8)","是","","桥梁完好状况"]
["qljgzk","varchar(8)","是","","桥梁结构状况"]
["jcrq","date","是","","检测日期"]
["jcbg","varchar(255)","是","","检测报告"]
["jsdw","varchar(100)","是","","建设单位"]
["sjdw","varchar(100)","是","","设计单位"]
["sgdw","varchar(100)","是","","施工单位"]
["jldw","varchar(100)","是","","监理单位"]
["gldw","varchar(100)","是","","管理单位"]
["yhdw","varchar(100)","是","","养护单位"]
["sfjggz","int4","是","","是否加固改造"]
["sfyjjcxt","int4","是","","是否已建监测系统"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["tbsj","timestamp(6)","是","","同步时间"]
["kjxx","varchar(4000)","是","","空间信息"]
["del_flag","int4","是","",""]
["sbsm","varchar(32)","是","",""]
[]
["74.ql_ql(桥梁)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","否","",""]
["xzqhdm","varchar(16)","是","",""]
["qlmc","varchar(255)","是","",""]
["jgny","varchar(32)","是","",""]
["szdlmc","varchar(255)","是","",""]
["dldj","int4","是","",""]
["kjfl","int4","是","",""]
["jglx","int4","是","",""]
["kjzh","varchar","否","",""]
["qlzc","numeric(10,2)","是","",""]
["qlzk","numeric(6,2)","是","",""]
["kydw","int4","是","",""]
["thdj","int4","是","",""]
["sfdzd","bool","是","",""]
["qmmj","numeric(10,2)","是","",""]
["kzld","int4","是","",""]
["yhlb","int4","是","",""]
["yhdj","int4","是","",""]
["qlwhzk","int4","是","",""]
["qljgzk","int4","是","",""]
["jcrq","date","否","",""]
["jsdw","varchar(100)","是","",""]
["sjdw","varchar(100)","是","",""]
["sgdw","varchar(100)","是","",""]
["jldw","varchar(100)","是","",""]
["gldw","varchar(100)","是","",""]
["yhdw","varchar(100)","是","",""]
["sfjggz","bool","是","",""]
["sfyjjcxt","bool","是","",""]
["bz","varchar(255)","是","",""]
["tbsj","timestamp(6)","是","CURRENT_TIMESTAMP",""]
["del_flag","int4","是","0",""]
["kjxx","varchar(4000)","是","",""]
["yskzjbz","varchar(32)","是","",""]
["sbsm","varchar(32)","是","",""]
["jcbg","varchar","是","",""]
["stql","varchar(8)","是","",""]
["sfgfxcgql","bool","否","",""]
["jkjclx","int4","是","",""]
["flbm","varchar(4)","否","",""]
["jgrq","date","是","",""]
["sjtbzt","varchar(16)","是","",""]
[]
["75.risk_ledger(防护目标)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(100)","是","",""]
["mark_code","varchar(255)","是","","标识码"]
["type","varchar(255)","是","","所属类别"]
["target_name","varchar(255)","是","","防护目标名称"]
["region","varchar(255)","是","","行政区"]
["region_code","varchar(255)","是","","行政区划代码"]
["geom_data","geometry","是","","空间信息"]
[]
["76.rq_jc_jcsb(监测设备属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(32)","否","","标识码"]
["dwbsm","varchar(32)","否","","点位标识码"]
["sblx","varchar(32)","否","","设备类型"]
["sbmc","varchar(50)","否","","设备名称"]
["sbxh","varchar(32)","是","","设备型号"]
["jczb","varchar(32)","否","","监测指标"]
["cjpl","varchar(32)","否","","采集频率"]
["scpl","varchar(32)","否","","上传频率"]
["sbzt","int4","否","","设备状态"]
["csmc","varchar(50)","是","","厂商名称"]
["xdgd","numeric(10,3)","是","","相对高度"]
["azsj","date","是","","安装时间"]
["azwhdw","varchar(100)","是","","安装维护单位"]
["gdfs","varchar(32)","是","","供电方式"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","否","","数据同步状态"]
["tbsj","timestamp(6)","否","","同步时间"]
[]
["77.rq_jc_jcxyz(监测项阈值(前置库是rq_jc_jzxyz))"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(32)","是","","标识码"]
["sbbsm","varchar(64)","是","","设备标识码"]
["bjyz","numeric(10,3)","是","","报警阈值"]
["sblx","varchar(32)","是","","设备类型"]
["jczb","varchar(32)","是","","监测指标"]
["bz","varchar(255)","是","","备注"]
["tbsj","timestamp(6)","是","","同步时间"]
[]
["78.rq_jg_aqzxjcjl(安全专项检查记录)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar","是","","标识码"]
["xzqhdm","varchar","是","","行政区划代码"]
["jcdx","varchar","是","","检查对象"]
["lx","varchar","是","","类型"]
["jcdy","varchar","是","","检查单元"]
["jcxm","varchar","是","","检查项目"]
["jcff","varchar","是","","检查方法"]
["jcnr","varchar","是","","检查内容"]
["jcjg","varchar","是","","检查结果"]
["czyh","varchar","是","","存在隐患"]
["jcrq","varchar","是","","检查日期"]
["jcry","varchar","是","","检查人员"]
["jcdw","varchar","是","","检查单位"]
["ssqsdw","varchar","是","","设施权属单位"]
["zgdw","varchar","是","","主管单位"]
["fj","varchar","是","","附件"]
["bz","varchar","是","","备注"]
["tbsj","timestamp(6)","是","","同步时间"]
[]
["79.rq_jg_fxpg(风险评估信息表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","否","","标识码"]
["xzqhdm","varchar(16)","是","","行政区划代码"]
["ssqy","varchar(255)","是","","所属区域"]
["zrdw","varchar(255)","是","","责任单位"]
["pgdy","varchar(100)","是","","评估单元"]
["glgdbh","varchar(255)","是","","关联管段编号"]
["pgdygdcd","numeric(20,0)","是","","评估单元管道长度"]
["fxms","varchar(255)","是","","风险描述"]
["fxdj","int4","是","","风险等级"]
["gkzt","int4","是","","管控状态"]
["gxsj","timestamp(6)","是","","更新时间"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","是","","数据同步状态"]
["tbsj","timestamp(6)","是","","同步时间"]
["gxid","varchar(255)","是","","管线id"]
["fxlx","int4","是","","风险类型"]
["pgsj","timestamp(6)","是","","评估时间"]
["pgdw","varchar(50)","是","","评估单位"]
["dz","varchar(255)","是","","地址"]
["pcbh","varchar(255)","是","","批次编号"]
["pgdymc","varchar(255)","是","","评估单元名称"]
["pgdywz","varchar(255)","是","","评估单元位置"]
["pgdywybs","varchar(255)","是","","评估单元唯一标识"]
["knxdj","int4","是","","可能性等级"]
["hgdj","int4","是","","后果等级"]
["gkcs","varchar(255)","是","","管控措施"]
["kjxx","varchar","是","","空间信息"]
["zbxx","varchar(255)","是","",""]
[]
["80.rq_jg_lhjcjl(安全专项检查记录)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar","是","","标识码"]
["xzqhdm","varchar","是","","行政区划代码"]
["qtbm","varchar","是","","牵头部门"]
["cjbm","varchar","是","","参检部门"]
["jcrq","varchar","是","","检查日期"]
["jcxm","varchar","是","","检查项目"]
["jcnr","varchar","是","","检查内容"]
["jcjg","varchar","是","","检查结果"]
["zrdw","varchar","是","","责任单位"]
["jcry","varchar","是","","检查人员"]
["xczp","varchar","是","","现场照片"]
["bz","varchar","是","","备注"]
["tbsj","timestamp(6)","是","","同步时间"]
[]
["81.rq_jg_zgjl(整改记录属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","否","","标识码"]
["xzqhdm","varchar(16)","否","","行政区划代码"]
["zgjhmc","varchar(255)","是","","整改计划名称"]
["zgnr","varchar(255)","是","","整改内容"]
["zgwz","varchar(255)","是","","整改位置"]
["zgtp","varchar","是","","整改图片"]
["glsbss","varchar(255)","是","","关联设备设施"]
["zgrq","date","否","","整改日期"]
["zgjd","varchar(255)","是","","整改进度"]
["zgjg","varchar(255)","否","","整改结果"]
["zgfzr","varchar(255)","是","","整改负责人"]
["ssqsdw","varchar(100)","否","","设施权属单位"]
["hyzgdw","varchar(100)","是","","行业主管单位"]
["fj","varchar","是","","附件"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","否","","原始库主键标志"]
["sjtbzt","varchar(16)","否","","数据同步状态"]
["tbsj","timestamp(6)","否","","同步时间"]
[]
["82.rq_js_jcd(监测点属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(32)","否","","标识码"]
["xzqhdm","varchar(6)","否","","行政区划代码"]
["dwmc","varchar(64)","否","","点位名称"]
["ssmc","varchar(64)","是","","设施名称"]
["ssbm","varchar(17)","是","","设施编码"]
["jcwz","varchar(200)","是","","监测位置"]
["gc","numeric(10,3)","是","","高程"]
["gcjz","varchar(32)","是","","高程基准"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","是","","数据同步状态"]
["tbsj","timestamp(6)","否","","同步时间"]
["kjxx","geometry","是","","空间信息"]
[]
["83.rq_js_rqyh(燃气用户属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(32)","否","","标识码"]
["xzqhdm","varchar(6)","是","","行政区划代码"]
["yhlx","int4","是","","用户类型"]
["fjmyhlx","int4","是","","非居民用户类型"]
["yhxx","varchar(100)","是","","用户信息"]
["xxdz","varchar(255)","是","","详细地址"]
["szjdhsq","varchar(50)","是","","所在街道和社区"]
["qyrq","date","是","","启用日期"]
["yqfw","varchar(255)","是","","用气范围"]
["qyzl","int4","否","","气源种类"]
["yhqpzl","int4","是","","液化气瓶种类"]
["yhqcps","int4","是","","液化气存瓶数"]
["yqgm","numeric(12,2)","是","","用气规模"]
["gqdw","varchar(100)","是","","供气单位"]
["sbssqk","varchar(255)","是","","设备设施情况"]
["sfzdyqcs","bool","是","","是否重点用气场所"]
["bjq","int4","是","","报警器"]
["sfyqdzz","bool","是","","是否有切断装置"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","是","","数据同步状态"]
["tbsj","timestamp(6)","是","","同步时间"]
["kjxx","geometry","是","","空间信息"]
[]
["84.sg_jc_jcsb(监测设备属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(32)","否","","标识码"]
["dwbsm","varchar(32)","是","","点位标识码"]
["sblx","varchar(32)","否","","设备类型"]
["sbmc","varchar(50)","否","","设备名称"]
["sbxh","varchar(32)","是","","设备型号"]
["jczb","varchar(32)","否","","监测指标"]
["cjpl","varchar(32)","否","","采集频率"]
["scpl","varchar(32)","否","","上传频率"]
["sbzt","int4","否","","设备状态"]
["csmc","varchar(50)","是","","厂商名称"]
["xdgd","numeric(10,3)","是","","相对高度"]
["azsj","date","是","","安装时间"]
["azwhdw","varchar(100)","是","","安装维护单位"]
["gdfs","varchar(32)","是","","供电方式"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","否","","数据同步状态"]
["tbsj","timestamp(6)","否","","同步时间"]
["jcssid","varchar(32)","是","","监测设施编号"]
["xmbh","varchar(32)","是","","项目编号"]
["jcssqsqy","varchar(100)","是","","监测设施权属企业"]
[]
["85.sg_jc_jcxyz(监测项阈值属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","否","","标识码"]
["sbbsm","varchar(64)","是","","设备标识码"]
["sblx","varchar(32)","是","","设备类型"]
["jczb","varchar(32)","是","","监测指标"]
["bjyz","numeric(13,3)","是","","报警阈值"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","是","","数据同步状态"]
["tbsj","timestamp(6)","是","","同步时间"]
[]
["86.sg_jg_dsfsglhcj(第三方施工联合惩戒属性结构表(2024年6月21日根据省标作废))"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(32)","否","","标识码"]
["xzqhdm","varchar(6)","否","","行政区划代码"]
["xmbm","varchar(32)","是","","项目编码"]
["sjbm","varchar(32)","是","","事件编码"]
["sjms","varchar(255)","否","","事件描述"]
["cjsj","varchar(100)","否","","惩戒时间"]
["bcjdw","varchar(100)","否","","被惩戒单位"]
["cjjg","varchar(255)","否","","惩戒结果"]
["fj","bytea","是","","附件"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","否","","数据同步状态"]
["tbsj","timestamp(6)","否","","同步时间"]
["fbdw","varchar(100)","否","","发布单位"]
["fbsj","date","否","","发布时间"]
[]
["87.sg_jg_lhcj(第三方施工联合惩戒属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","否","","标识码"]
["xzqhdm","varchar(16)","是","","行政区划代码"]
["xmbm","varchar(64)","是","","项目编码"]
["sjbm","varchar(64)","是","","事件编码"]
["sjms","varchar(255)","是","","事件描述"]
["cjrq","date","是","","惩戒日期"]
["bcjdw","varchar(100)","是","","被惩戒单位"]
["cjjg","varchar(255)","是","","惩戒结果"]
["fbdw","varchar(100)","是","","发布单位"]
["fbsj","date","是","","发布时间"]
["fj","varchar(100)","是","","附件"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","是","","数据同步状态"]
["tbsj","timestamp(6)","是","","同步时间"]
[]
["88.sg_jg_xmxx(第三方施工项目信息属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(64)","否","","标识码"]
["xzqhdm","varchar(16)","是","","行政区划代码"]
["xmbm","varchar(64)","是","","项目编码"]
["sgzt","int4","是","","施工状态"]
["sgxkxx","varchar(255)","是","","施工许可信息"]
["dlwjspzt","int4","是","","道路挖掘审批状态"]
["xmmc","varchar(255)","是","","项目名称"]
["dkm","varchar(255)","是","","地块名"]
["xmlx","int4","是","","项目类型"]
["xmly","int4","是","","项目来源"]
["sggy","int4","是","","施工工艺"]
["tzfs","int4","是","","通知方式"]
["btzdw","varchar(32)","是","","被通知单位"]
["tzsj","date","是","","通知时间"]
["czzt","int4","是","","处置状态"]
["czwcsj","date","是","","处置完成时间"]
["czms","varchar(255)","是","","处置描述"]
["szjd","varchar(255)","是","","所在街道"]
["sgxmdz","varchar(255)","是","","施工项目地址"]
["jhksrq","date","是","","计划开始日期"]
["jhjsrq","date","是","","计划结束日期"]
["sjksrq","date","是","","实际开始日期"]
["sjjsrq","date","是","","实际结束日期"]
["sgsd","numeric(8,2)","是","","施工深度"]
["jsdw","varchar(255)","是","","建设单位"]
["jsdwfzr","varchar(32)","是","","建设单位负责人"]
["jsdwfzrlxdh","varchar(16)","是","","建设单位负责人联系电话"]
["sgdw","varchar(255)","是","","施工单位"]
["sgdwfzr","varchar(32)","是","","施工单位负责人"]
["sgdwfzrlxdh","varchar(16)","是","","施工单位负责人联系电话"]
["jldw","varchar(255)","是","","监理单位"]
["jldwfzr","varchar(32)","是","","监理单位负责人"]
["jldwfzrlxdh","varchar(16)","是","","监理单位负责人联系电话"]
["bz","varchar(255)","是","","备注"]
["hxfw","varchar(5120)","是","","红线范围"]
["kjxx","varchar(5120)","是","","空间信息"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","是","","数据同步状态"]
["tbsj","timestamp(6)","是","","同步时间"]
[]
["89.sg_js_jcd(监测点属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["bsm","varchar(32)","否","","标识码"]
["xzqhdm","varchar(6)","否","","行政区划代码"]
["dwmc","varchar(64)","否","","点位名称"]
["ssmc","varchar(64)","是","","设施名称"]
["ssbm","varchar(17)","否","","设施编码"]
["jcwz","varchar(200)","是","","监测位置"]
["gc","numeric(10,3)","是","","高程"]
["gcjz","varchar(32)","是","","高程基准"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","否","","原始库主键标志"]
["sjtbzt","varchar(16)","否","","数据同步状态"]
["tbsj","timestamp(6)","否","","同步时间"]
["kjxx","geometry","是","","空间信息"]
[]
["90.sms_record(无注释)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(32)","否","","短信记录id"]
["context","varchar(1000)","是","","短信发送内容"]
["send_from","varchar(255)","是","","发送者手机号"]
["send_to","varchar(3000)","是","","接收者手机号"]
["status","int4","是","","短信发送状态 0失败 1成功"]
["res","varchar(2000)","是","","响应"]
["params","varchar(2000)","是","","发送短信参数"]
["client_id","varchar(100)","是","","客户端Id"]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
[]
["91.social_public_case(社会公众服务-案例分析)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["name","varchar(500)","是","","案例名称"]
["content","text","是","","案例内容"]
["images","varchar(500)","是","","案例图片"]
["scene","varchar(50)","是","","所属专项  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["annex","varchar(255)","是","","附件"]
["release_time","timestamp(6)","是","","发布时间"]
["state","varchar(50)","是","","发布状态 未发布:0  已发布:1"]
["order_num","int8","是","","排序"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
[]
["92.social_public_feedback(社会公众服务-群众反馈)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["source","varchar(50)","是","","反馈来源  待定"]
["content","text","是","","反馈内容"]
["location","varchar(500)","是","","详细地点"]
["feedback_time","timestamp(6)","是","","反馈时间"]
["name","varchar(50)","是","","反馈人"]
["phone","varchar(50)","是","","电话"]
["scene","varchar(50)","是","","所属专项  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["label","varchar(500)","是","","标签"]
["annex","varchar","是","","附件"]
["release_time","timestamp(6)","是","","发布时间"]
["state","varchar(50)","是","","发布状态 未发布:0  已发布:1"]
["order_num","int8","是","","排序"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
["area","varchar(64)","是","","行政区划"]
["disposal_state","varchar(64)","是","","处置状态"]
["disposal_result","varchar(1000)","是","","处置结果"]
["disposal_user_name","varchar(64)","是","","处置人"]
["disposal_time","timestamp(6)","是","","处置时间"]
["disposal_annex","varchar(1000)","是","","处置附件"]
[]
["93.social_public_notice(社会公众服务-通知公告)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["scene","varchar(50)","是","","专项 场景 燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷；"]
["title","varchar(500)","是","","通知公告标题"]
["source","varchar(50)","是","","公告 来源 灵锡APP、12345、12319、综合监管"]
["notice_time","timestamp(6)","是","","公告日期"]
["content","text","是","","公告内容"]
["state","varchar(50)","是","","发布状态 未发布:0  已发布:1"]
["annex","varchar(255)","是","","附件"]
["order_num","int8","是","","排序"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
[]
["94.social_public_notice_read(通知公告已读未读)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","","id"]
["source_id","varchar(128)","是","","原表id(social_public_notice)"]
["user_id","varchar(64)","是","","用户id"]
["create_time","timestamp(6)","是","","创建时间"]
["is_read","int4","是","","是否已读1已读,0未读"]
["remark","varchar(255)","是","","备注(没有用到)"]
[]
["95.social_public_train_plan(社会公众服务-安全培训-培训计划)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["scene","varchar(50)","是","","所属专项  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["type","varchar(500)","是","","培训类型(1:人员岗前培训2:企业安全培训)"]
["frequency_type","varchar(50)","是","","频次类型:日,周,半月,月,季度,半年,年"]
["order_num","int8","是","","排序"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
["planned_count","int8","是","","计划培训总次数，取该计划已设置的各频次下的计划次数合计"]
[]
["96.social_public_train_plan_dtl(培训计划 社会公众服务-安全培训-培训计划明细表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["plan_id","varchar(50)","是","","培训计划主键"]
["frequency_type","varchar(50)","是","","频次类型 "]
["plan_time","timestamp(6)","是","","计划时间 "]
["plan_count","int8","是","","培训次数 "]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
[]
["97.social_public_training(社会公众服务-安全培训-安全培训记录)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(50)","否","","主键"]
["plan_id","varchar(50)","是","","培训计划ID"]
["theme","varchar(500)","是","","培训主题 "]
["start_time","timestamp(6)","是","","培训开始时间"]
["end_time","timestamp(6)","是","","培训结束时间"]
["duration","int8","是","","培训时长（课时）"]
["location","varchar(500)","是","","培训地点"]
["institution","varchar(500)","是","","培训机构"]
["planned_num","int8","是","","计划人数（人）"]
["actua_num","int8","是","","实到人数（人）"]
["content","text","是","","培训内容"]
["training_state","varchar(50)","是","","培训状态\t下拉框\t未开始、进行中、已结束"]
["type","varchar(500)","是","","培训类型"]
["scene","varchar(50)","是","","所属专项  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 "]
["annex","varchar(255)","是","","附件"]
["release_time","timestamp(6)","是","","发布时间"]
["state","varchar(50)","是","","发布状态 未发布:0  已发布:1"]
["order_num","int8","是","","排序"]
["create_time","timestamp(6)","是","","数据创建日期"]
["create_user","varchar(50)","是","","数据创建人员"]
["update_time","timestamp(6)","是","","数据更新日期"]
["update_user","varchar(50)","是","","数据更新人员"]
["del_flag","int4","是","1","逻辑删除状态 无效：0 有效：1"]
["purpose","varchar","是","","培训目的"]
["area","varchar(50)","是","","行政区划"]
[]
["98.sync_table_time(数据同步时间表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(100)","否","","主键"]
["table_name","varchar(100)","是","","同步的前置库表名"]
["last_sync_time","timestamp(6)","是","","最后同步时间"]
["sync_notes","varchar(255)","是","","备注"]
[]
["99.tag_category_info(标签类别表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["category_name","varchar(64)","是","",""]
["remark","varchar(500)","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["100.tag_info(标签表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["category_id","varchar(64)","是","",""]
["tag_name","varchar(64)","是","",""]
["tag_explain","varchar(500)","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["101.third_party_layer_info(大屏下钻图层设置-主)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(200)","否","",""]
["inlet_name","varchar(255)","是","","大屏图层入口名称"]
["inlet_pric","varchar(255)","是","","入口说明"]
["counter_sys","varchar(255)","是","","对应系统"]
["update_date","date","是","","更新时间"]
["update_by","varchar(255)","是","","更新人"]
["create_date","date","是","","创建时间"]
["create_by","varchar(255)","是","","创建人"]
[]
["102.third_party_layer_route(大屏下钻图层设置-子)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(200)","否","",""]
["info_id","varchar(200)","是","","父级id"]
["counter_sys","varchar(255)","是","","对应系统"]
["layer_route_name","varchar(255)","是","","系统一张图图层名称"]
["route_url","varchar(255)","是","","路径"]
["route_pric","varchar(255)","是","","路径说明"]
["state","varchar(255)","是","","状态(0=开，1=关)"]
["update_date","date","是","","更新时间"]
["update_by","varchar(255)","是","","更新人"]
["create_date","date","是","","创建时间"]
["create_by","varchar(255)","是","","创建人"]
[]
["103.third_party_stage_route(门户系统入口图层设置)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(200)","否","",""]
["route_name","varchar(255)","是","","系统名称"]
["route_url","varchar(255)","是","","路径"]
["route_pric","varchar(255)","是","","路径说明"]
["state","varchar(10)","是","","状态(0=开，1=关)"]
["update_date","date","是","","更新时间"]
["update_by","varchar(200)","是","","更新人"]
["create_date","date","是","","创建时间"]
["create_by","varchar(200)","是","","创建人"]
[]
["104.us_gaz(无注释)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","int4","否","nextval('us_gaz_id_seq'::regclass)",""]
["seq","int4","是","",""]
["word","text","是","",""]
["stdword","text","是","",""]
["token","int4","是","",""]
["is_custom","bool","否","true",""]
[]
["105.us_lex(无注释)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","int4","否","nextval('us_lex_id_seq'::regclass)",""]
["seq","int4","是","",""]
["word","text","是","",""]
["stdword","text","是","",""]
["token","int4","是","",""]
["is_custom","bool","否","true",""]
[]
["106.us_rules(无注释)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","int4","否","nextval('us_rules_id_seq'::regclass)",""]
["rule","text","是","",""]
["is_custom","bool","否","true",""]
[]
["107.video_channel(视频通道表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["scene","varchar(16)","是","","专项场景"]
["equipment_name","varchar(64)","是","","设备名称"]
["area","varchar(16)","是","","行政区划"]
["channel_no","varchar(64)","是","","通道号"]
["install_address","varchar(100)","是","","安装地址"]
["monitoring_object","varchar(100)","是","","监控对象"]
["equipment_number","varchar(64)","是","","设备型号"]
["spatial_position","varchar(300)","是","","空间位置"]
["manufacturer_name","varchar(64)","是","","生产厂家"]
["property_unit","varchar(100)","是","","产权单位"]
["video_address","text","是","","视频地址"]
["isimportance","varchar(16)","是","","是否重点监控 0否、1是"]
["remark","varchar(500)","是","","描述"]
["defined","int4","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["geom_data","geometry","是","","空间信息"]
["video_store","varchar(255)","是","","视频厂商"]
[]
["108.warning_info(预警管理表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["scene","varchar(16)","是","","预警场景"]
["warning_name","varchar(64)","是","","预警名称"]
["warning_source","varchar(16)","是","","预警来源 0人员报警、1监测设备"]
["equipment_name","varchar(100)","是","","预警设备名称"]
["equipment_number","varchar(100)","是","","预警设备编号"]
["warning_type","varchar(100)","是","","预警类型"]
["warning_site","varchar(100)","是","","预警地址"]
["area","varchar(16)","是","","行政区划"]
["warning_rank","varchar(16)","是","","预警级别 1一级、2二级、3三级、4四级(通用_JCYJ_YJJB_DM)"]
["generated_time","timestamp(6)","是","","预警生成时间"]
["report_time","timestamp(6)","是","","预警上报时间"]
["warning_describe","varchar(600)","是","","预警简述"]
["report","varchar(500)","是","","预警报告"]
["analyses","varchar(500)","是","","研判分析"]
["disposal_state","varchar(16)","是","","处置状态 0未处置、1处置中、2误报、3处置完成(字典是disposal_state_yj)"]
["disposal_user_name","varchar(64)","是","","处置人"]
["disposal_user_id","varchar(64)","是","","处置人id"]
["disposal_time","timestamp(6)","是","","处置时间"]
["disposal_suggest","varchar(500)","是","","处置建议"]
["disposal_complete_time","timestamp(6)","是","","处置完成时间"]
["disposal_report","varchar(500)","是","","处置报告"]
["remark","varchar(500)","是","","备注"]
["geom_data","geometry","是","","空间信息"]
["defined","int4","是","",""]
["deleted","int4","是","","1不删除0已经删除"]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["analyses_report","varchar(500)","是","","分析报告"]
["warning_state","int4","是","","预警状态1-发布，2-处置，3-解除，"]
["streaming_url","varchar(512)","是","","流媒体数据存放地址"]
["table_name","varchar(255)","是","","数据来源表名称"]
["threshold_value","varchar(100)","是","","预警阈值"]
[]
["109.warning_info_lifeline(预警管理表(平台设置预警类型,预警级别,关联预案))"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["warning_type_lifeline","varchar(100)","是","","预警类型"]
["warning_rank_lifeline","varchar(16)","是","","预警级别 1一级、2二级、3三级、4四级(通用_JCYJ_YJJB_DM)"]
["associated_plan_lifeline","text","是","","关联预案"]
["remark","varchar(255)","是","","备注"]
[]
["110.work_order_admin(工单管理表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","","id"]
["work_order_code","varchar(64)","是","","工单编号"]
["scene","varchar(16)","是","","专项场景"]
["work_order_content","varchar(255)","是","","工单内容"]
["place","varchar(200)","是","","位置"]
["area","varchar(16)","是","","行政区划"]
["dispatch_time","timestamp(6)","是","","下发时间"]
["process_limited","timestamp(6)","是","","处理时限"]
["feedback","varchar(500)","是","","处理结果说明"]
["handler","varchar(64)","是","","处理人员"]
["handler_id","varchar(64)","是","","处理人员编号"]
["state","varchar(16)","是","","工单状态 0待处理 1处理中 2已完成"]
["geom_data","geometry","是","","空间信息"]
["defined","int4","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["process_time","timestamp(6)","是","","处理时间"]
["work_order_type","varchar(32)","是","","工单类型 0事件工单、1预警工单、2风险工单、3隐患工单、4设备工单"]
["foreign_id","varchar(64)","是","","关联id"]
["attachments","text","是","","附件"]
["complete_time","timestamp(6)","是","","完成时间"]
["send_scene","varchar(64)","是","","需下发专项"]
["complete_attachments","text","是","","工单处理附件"]
["disposal_dept","varchar(255)","是","","处理单位(部门)"]
["disposal_dept_id","varchar(64)","是","","处理单位(部门)id"]
["yjyabh","varchar(255)","是","","关联应急预案编号"]
["order_source","varchar(64)","是","",""]
["order_urgent","varchar(64)","是","",""]
["sms_phone","varchar(1000)","是","",""]
["sms_content","varchar(1000)","是","",""]
["is_handle_urge","varchar(2)","是","","是否催办(0是，1否)"]
["handle_urge_user","varchar(100)","是","","催办人"]
["handle_urge_time","timestamp(0)","是","","催办时间"]
["check_result","varchar(255)","是","","复查结果"]
["check_describe","varchar(2000)","是","","复查描述"]
[]
["111.work_order_info(待办)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(200)","否","",""]
["work_name","varchar(255)","是","","名称"]
["src","varchar(255)","是","","来源"]
["content","varchar(300)","是","","内容"]
["create_date","date","是","","发送时间"]
["create_by","varchar(255)","是","","发送人"]
["handle_by","varchar(255)","是","","处理人"]
[]
["112.zhjg_analysis_emergency(突发事件表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["scene","varchar(16)","是","","专项场景"]
["area","varchar(16)","是","","行政区划"]
["emergency_name","varchar(100)","是","","事件名称"]
["emergency_description","varchar(1000)","是","","事件说明"]
["emergency_address","varchar(500)","是","","事件发生地点"]
["relevance_facility","varchar(500)","是","","关联基础设施 0燃气爆炸、1供水爆管、2排水、3道路塌陷、4桥梁倒塌"]
["find_time","timestamp(6)","是","","事件发生时间(由于前置数据库没有值,所以没有数据)"]
["response_grade","varchar(16)","是","","响应级别 1一级、2二级、3三级、4四级"]
["scene_photo","varchar(500)","是","","现场照片"]
["repair_content","varchar(1000)","是","","抢修内容"]
["dispose_progress","varchar(16)","是","","处置进度 0未处置、1处置中、2处置完成"]
["dispose_time","timestamp(6)","是","","处理日期"]
["dispose_result","varchar(1000)","是","","处理结果"]
["dispose_people","varchar(32)","是","","处理人员"]
["dispose_unit","varchar(200)","是","","处理单位"]
["attachments","varchar(500)","是","","附件"]
["remark","varchar(500)","是","","备注"]
["defined","int4","是","","是否自定义"]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["emergency_type","varchar(128)","是","","事件类型(作废,发现使用了relevance_facility这个字段)"]
["is_often","varchar(2)","是","","是否高发是,不是"]
["project_code","varchar(64)","是","","项目编号"]
["geom_data","geometry","是","","空间信息"]
["emergency_code","varchar(100)","是","","事件编号"]
[]
["113.zhjg_analysis_facility(基础设施表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(100)","否","",""]
["bsm","varchar(64)","是","","标识码"]
["scene","varchar(16)","是","","专项场景"]
["facility_type","varchar(16)","是","","设施类型 0燃气管线、1燃气管点、2燃气场站、3供水厂站、4排水厂站、5排水管线、6排水管点、7排水排口、8调蓄设施"]
["facility_name","varchar(100)","是","","设施名称"]
["facility_status","varchar(16)","是","","设施状态 0待投用 1投用中 2检修中 3关停 4废弃"]
["facility_quantity","numeric(10,2)","是","","设施数量"]
["measuring_unit","varchar(16)","是","","计量单位 0-km，1-个，2-座，3-万瓶，"]
["construction_age","timestamp(6)","是","","建设年代"]
["construction_unit","varchar(200)","是","","建设单位"]
["facility_use_year","numeric(8,1)","是","","设施使用年限"]
["position","varchar(500)","是","","位置"]
["area","varchar(16)","是","","行政区划"]
["data_source","varchar(16)","是","","数据来源 0探测 1竣测 2图解 3整合 4权属单位提供"]
["defined","int4","是","","是否自定义 0自定义 1非自定义"]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["geom_data","geometry","是","","空间信息"]
["big_category","varchar(64)","是","","大类"]
["small_category","varchar(64)","是","","小类"]
["owner","varchar(255)","是","",""]
[]
["114.zhjg_analysis_hidden_trouble(隐患报警表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["scene","varchar(16)","是","","专项场景"]
["area","varchar(16)","是","","行政区划"]
["hidden_trouble_number","varchar(64)","是","","隐患编号"]
["hidden_trouble_type","varchar(16)","是","","隐患类型"]
["hidden_trouble_description","varchar(500)","是","","隐患描述"]
["hidden_trouble_address","varchar(500)","是","","隐患地址"]
["hidden_trouble_grade","varchar(16)","是","","隐患等级 0-I级、1-II级、2-III级、3-IV级"]
["find_time","timestamp(6)","是","","发现时间"]
["report_unit","varchar(200)","是","","上报单位"]
["report_people","varchar(32)","是","","上报人员"]
["report_people_tel","varchar(32)","是","","人员联系电话"]
["scene_photo","varchar(500)","是","","现场照片"]
["dispose_progress","varchar(16)","是","","处置进度 0未处置、1处置中、2已完成"]
["dispose_unit","varchar(200)","是","","处置单位"]
["dispose_people","varchar(32)","是","","处置负责人"]
["dispose_people_tel","varchar(32)","是","","负责人联系电话"]
["dispose_finish_time","timestamp(6)","是","","处置完成时间"]
["remark","varchar(500)","是","","备注 "]
["dispose_photo","varchar(500)","是","","处置照片"]
["defined","int4","是","","是否自定义"]
["deleted","int4","是","","是否删除"]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["is_often","varchar(2)","是","","是否高发是,不是"]
["project_code","varchar(32)","是","","项目编号(目前只有第三方场景中用到)"]
["geom_data","geometry","是","","空间信息"]
[]
["115.zhjg_analysis_monitor_point(综合统计分析-监测点)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","","主键"]
["bsm","varchar(64)","是","","标识码"]
["area","varchar(16)","是","","行政区划代码"]
["name","varchar(200)","是","","点位名称"]
["jcwz","varchar(200)","是","","监测位置"]
["gc","numeric(10,3)","是","","高程"]
["gcjz","varchar(32)","是","","高程基准"]
["remark","varchar(500)","是","","备注"]
["kjxx","geometry","是","","空间信息"]
["deleted","int4","是","","逻辑删除状态 无效：0 有效：1"]
["created_at","timestamp(6)","是","","创建人"]
["created_by","varchar(100)","是","","创建时间"]
["updated_at","timestamp(6)","是","","更新人"]
["updated_by","varchar(100)","是","","更新时间"]
["scene","varchar(16)","是","","专项场景"]
["ssmc","varchar(64)","是","","设施名称"]
["ssbm","varchar(32)","是","","设施编码"]
[]
["116.zhjg_analysis_monitoring_equipment(监测设备表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["bsm","varchar(64)","是","","标识码"]
["scene","varchar(16)","是","","专项场景"]
["equipment_type","varchar(16)","是","","设备类型"]
["equipment_number","varchar(64)","是","","设备编号"]
["equipment_name","varchar(200)","是","","设备名称"]
["equipment_model","varchar(64)","是","","设备型号"]
["monitoring_index","varchar(64)","是","","监测指标"]
["collection_frequency","varchar(64)","是","","采集频率"]
["upload_frequency","varchar(64)","是","","上传频率"]
["equipment_status","varchar(16)","是","","设备状态 1-未使用，2-正常，3-试运行，4-故障，5-维修，6-报废(字典:通用_JCSB_SBZT_DM)"]
["manufacturer_name","varchar(64)","是","","厂商名称"]
["relative_altitude","numeric(8,2)","是","","相对高度（米）"]
["instal_time","timestamp(6)","是","","安装时间"]
["power_supply_mode","varchar(64)","是","","供电方式"]
["instal_mainten_unit","varchar(64)","是","","安装维护单位"]
["position","varchar(500)","是","","位置"]
["area","varchar(16)","是","","行政区划"]
["remark","varchar(500)","是","","备注"]
["geom_data","geometry","是","","空间信息"]
["defined","int4","是","","是否自定义 0自定义 1非自定义"]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["alarm_threshold","varchar(128)","是","","报警阈值srcid值(后加数据)"]
["ewm","varchar(500)","是","","二维码"]
[]
["117.zhjg_analysis_point_rel(综合统计分析-监测点-关系表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","","主键"]
["point_bsm","varchar(64)","是","","监测点位标识码"]
["rel_type","int2","是","","关系类型 0:基础设施 1:监测设备"]
["rel_bsm","varchar(64)","是","","关系标识码"]
["deleted","int4","是","","逻辑删除状态 无效：0 有效：1"]
["created_at","timestamp(6)","是","","创建人"]
["created_by","varchar(100)","是","","创建时间"]
["updated_at","timestamp(6)","是","","更新人"]
["updated_by","varchar(100)","是","","更新时间"]
[]
["118.zhjg_rcwhwx(综合监管日常维护维修属性结构表)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["bsm","varchar(64)","否","","标识码"]
["scene","varchar(64)","否","","专项场景"]
["xzqhdm","varchar(6)","否","","行政区划代码"]
["whwxnr","varchar(255)","否","","维护维修内容"]
["sbsslx","varchar(500)","是","","设备设施类型"]
["sbssid","varchar(500)","是","",""]
["sbssname","varchar(500)","是","",""]
["sbss","varchar(500)","否","","设备设施"]
["cljg","varchar(255)","是","","处理结果"]
["clrq","timestamp(6)","是","","处理日期"]
["clry","varchar(32)","是","","处理人员"]
["lxdh","varchar(16)","是","","联系电话"]
["yhdw","varchar(255)","是","","养护单位"]
["ssqsdw","varchar(100)","是","","设施权属单位"]
["jcff","varchar(255)","否","","检测方法"]
["jcjl","varchar(255)","否","","检测结论"]
["fj","varchar(1000)","是","","附件"]
["bz","varchar(255)","是","","备注"]
["yskzjbz","varchar(64)","是","","原始库主键标志"]
["sjtbzt","varchar(16)","是","","数据同步状态"]
["tbsj","timestamp(6)","是","","同步时间"]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["119.zhjg_repair_bill(维修单)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["scene","varchar(16)","是","","专项场景"]
["type","varchar(32)","是","","类型（facility-设施 equipment-设备）"]
["foreign_id","varchar(64)","是","","foreignId"]
["facility_name","varchar(100)","是","","设施名称"]
["equipment_number","varchar(64)","是","","设备编号"]
["equipment_name","varchar(200)","是","","设备名称"]
["repair_time","timestamp(6)","是","","维修时间"]
["repair_content","varchar(1000)","是","","维修内容"]
["remark","varchar(500)","是","","备注"]
["defined","int4","是","","是否自定义"]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["120.zy_js_bncs(避难场所)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["bsm","varchar(70)","是","","标识码"]
["csmc","varchar(255)","是","","场所名称"]
["szdz","varchar(255)","是","","所在地址"]
["area","varchar(16)","是","","行政区划"]
["cslb","varchar(255)","是","","场所类别"]
["scene","varchar(32)","是","","归属专项"]
["kymj","varchar(255)","是","","可用面积(万m²)"]
["rnrs","varchar(255)","是","","容纳人数(万人)"]
["fzr","varchar(255)","是","","负责人"]
["lxdh","varchar(255)","是","","联系电话"]
["geom_data","geometry","是","","空间信息"]
["defined","int4","是","","是否自定义 0自定义 1非自定义"]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
[]
["121.zy_js_ck(应急仓库)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","","id"]
["bsm","varchar(70)","是","","标识码"]
["ckmc","varchar(200)","是","","仓库名称"]
["ckdz","varchar(200)","是","","仓库地址"]
["area","varchar(16)","是","","行政区划"]
["scene","varchar(32)","是","","归属专项"]
["lxr","varchar(50)","是","","联系人"]
["lxdh","varchar(600)","是","","联系电话"]
["defined","int4","是","","是否自定义 0自定义 1非自定义"]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["geom_data","geometry","是","","空间信息"]
[]
["122.zy_js_jydw(救援队伍)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["bsm","varchar(70)","是","","标识码"]
["dwmc","varchar(200)","是","","队伍名称"]
["zyfzr","varchar(50)","是","","主要负责人"]
["lxrdh","varchar(50)","是","","联系人电话"]
["zbdh","varchar(50)","是","","值班电话"]
["dyrs","int4","是","","队员人数"]
["schy","varchar(100)","是","","擅长行业"]
["xxdz","varchar(200)","是","","详细地址"]
["area","varchar(16)","是","","行政区划"]
["defined","int4","是","","是否自定义 0自定义 1非自定义"]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["geom_data","geometry","是","","空间信息"]
[]
["123.zy_js_yjwz(应急物资)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["bsm","varchar(70)","是","","标识码"]
["ssck","varchar(64)","是","","所属仓库"]
["area","varchar(16)","是","","行政区划"]
["wzmc","varchar(255)","是","","物资名称"]
["wzlx","varchar(20)","是","","物资类型"]
["wzly","varchar(20)","是","","物资来源"]
["scene","varchar(32)","是","","归属专项"]
["kcsl","float8","是","","库存数量"]
["jldw","varchar(20)","是","","计量单位"]
["defined","int4","是","","是否自定义 0自定义 1非自定义"]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["geom_data","geometry","是","","空间信息"]
[]
["124.zy_js_yjzj(应急专家)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["bsm","varchar(70)","是","","标识码"]
["zjxm","varchar(50)","是","","专家姓名"]
["js","varchar(100)","是","","角色"]
["czd","varchar(255)","是","","常驻地"]
["lxdh","varchar(50)","是","","联系电话"]
["gzdw","varchar(100)","是","","工作单位"]
["sczy","varchar(100)","是","","擅长专业"]
["zjcc","varchar(100)","是","","专家职称"]
["defined","int4","是","",""]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["geom_data","geometry","是","","空间信息"]
["area","varchar(16)","是","","行政区划"]
["jtdh","varchar(50)","是","","家庭电话"]
[]
["125.zy_js_ylwsjg(医疗卫生机构)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["bsm","varchar(70)","是","","标识码"]
["jgmc","varchar(200)","是","","机构名称"]
["szdz","varchar(200)","是","","所在地址"]
["area","varchar(16)","是","","行政区划"]
["jgjb","varchar(200)","是","","机构级别"]
["kycw","int4","是","","可用床位"]
["fzr","varchar(50)","是","","负责人"]
["lxdh","varchar(50)","是","","联系电话"]
["defined","int4","是","","是否自定义 0自定义 1非自定义"]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["geom_data","geometry","是","","空间信息"]
[]
["126.zy_js_zdwxy(重大危险源)"]
["列名","数据类型","是否为空","默认值","备注"]
["id","varchar(64)","否","",""]
["bsm","varchar(70)","是","","标识码"]
["wxymc","varchar(200)","是","","危险源名称"]
["wxjb","varchar(200)","是","","危险级别"]
["zdwxyfl","varchar(200)","是","","重大危险源分类"]
["dz","varchar(200)","是","","地址"]
["area","varchar(16)","是","","行政区划"]
["qymc","varchar(200)","是","","企业名称"]
["defined","int4","是","","是否自定义 0自定义 1非自定义"]
["deleted","int4","是","",""]
["created_at","timestamp(6)","是","",""]
["created_by","varchar(100)","是","",""]
["updated_at","timestamp(6)","是","",""]
["updated_by","varchar(100)","是","",""]
["geom_data","geometry","是","","空间信息"]