COMMENT ON TABLE T_ZHZQ_DETAIL IS '灾害灾情-速报';
COMMENT ON COLUMN T_ZHZQ_DETAIL.ID IS '灾害编号';
COMMENT ON COLUMN T_ZHZQ_DETAIL.ZHZQ_ID IS '灾害ID';
COMMENT ON COLUMN T_ZHZQ_DETAIL.REPORT_TIME IS '灾情速报时间';
COMMENT ON COLUMN T_ZHZQ_DETAIL.CONTENT IS '内容';
COMMENT ON COLUMN T_ZHZQ_DETAIL.PIC IS '图片或视频';
COMMENT ON COLUMN T_ZHZQ_DETAIL.TENANT_ID IS '租户号';
COMMENT ON COLUMN T_ZHZQ_DETAIL.REVISION IS '乐观锁';
COMMENT ON COLUMN T_ZHZQ_DETAIL.CREATED_BY IS '创建人';
COMMENT ON COLUMN T_ZHZQ_DETAIL.CREATED_TIME IS '创建时间';
COMMENT ON COLUMN T_ZHZQ_DETAIL.UPDATED_BY IS '更新人';
COMMENT ON COLUMN T_ZHZQ_DETAIL.UPDATED_TIME IS '更新时间';
{
"msg": "",
"code": 200,
"data": {
"list": [
{
"ZHZQ_CODE": "tempStorm-241209",
"CREATED_BY": null,
"REVISION": null,
"SOURCE_ID": "a36bf08ca89d4aaab7d6a31f82f607b1",
"CREATED_TIME": null,
"UPDATED_TIME": null,
"LON": "119.3984",
"PIC": "[{\"name\":\"wave3.jpg\",\"id\":\"8737f2958e464c678404153d8673dd98\",\"url\":\"ocean-disaster/Task/2024/12/1215/wave3.jpg\"}]",
"UPDATED_BY": null,
"TENANT_ID": null,
"ID": "1922560018675175426",
"CONTENT": "灾情上报信息如下",
"REPORT_TIME": "2024-12-12 15:44:53",
"ZHZQ_ID": "1922560017270083585",
"LAT": "26.7455"
},
{
"ZHZQ_CODE": "tempStorm-241209",
"CREATED_BY": null,
"REVISION": null,
"SOURCE_ID": "5e230509b3f24c37ae3a5b0f94350ec9",
"CREATED_TIME": null,
"UPDATED_TIME": null,
"LON": "119.2873",
"PIC": "[{\"name\":\"096c21156940ee20670f0312d463b741.jpeg\",\"id\":\"2ae7f990d2b04809ab59b1a9f6ee8e48\",\"url\":\"ocean-disaster/Task/2024/12/0918/096c21156940ee20670f0312d463b741.jpeg\"}]",
"UPDATED_BY": null,
"TENANT_ID": null,
"ID": "1922560019665031170",
"CONTENT": "xxh上报点位5:该地区无受灾情况",
"REPORT_TIME": "2024-12-09 18:29:35",
"ZHZQ_ID": "1922560017270083585",
"LAT": "26.7329"
},
{
"ZHZQ_CODE": "tempStorm-241209",
"CREATED_BY": null,
"REVISION": null,
"SOURCE_ID": "557fff7f672648bc9740562253ed548b",
"CREATED_TIME": null,
"UPDATED_TIME": null,
"LON": "119.4991",
"PIC": "[{\"name\":\"ef0f3f59bcaccb6c4780a209fd3af166.jpeg\",\"id\":\"0ba395c5564f4254b432d26b2b92bd9a\",\"url\":\"ocean-disaster/Task/2024/12/0918/ef0f3f59bcaccb6c4780a209fd3af166.jpeg\"}]",
"UPDATED_BY": null,
"TENANT_ID": null,
"ID": "1922560020659081217",
"CONTENT": "xxh上报点位4,该地区受灾情况如下...",
"REPORT_TIME": "2024-12-09 18:16:10",
"ZHZQ_ID": "1922560017270083585",
"LAT": "26.7564"
},
{
"ZHZQ_CODE": "tempStorm-241209",
"CREATED_BY": null,
"REVISION": null,
"SOURCE_ID": "5cba570e57504eb681f998b5546443cf",
"CREATED_TIME": null,
"UPDATED_TIME": null,
"LON": "119.6729",
"PIC": "[{\"name\":\"c1db3b5a14bde8a90522f59e29381452.jpeg\",\"id\":\"708c5005d3bd4160b5529c41ada5aad7\",\"url\":\"ocean-disaster/Task/2024/12/0918/c1db3b5a14bde8a90522f59e29381452.jpeg\"}]",
"UPDATED_BY": null,
"TENANT_ID": null,
"ID": "1922560021644742658",
"CONTENT": "xxh上报点位3:该地区受灾情况如下...",
"REPORT_TIME": "2024-12-09 18:00:33",
"ZHZQ_ID": "1922560017270083585",
"LAT": "26.7883"
},
{
"ZHZQ_CODE": "tempStorm-241209",
"CREATED_BY": null,
"REVISION": null,
"SOURCE_ID": "38b455d454be4f2297af08772e401cd8",
"CREATED_TIME": null,
"UPDATED_TIME": null,
"LON": "119.7066",
"PIC": "[{\"name\":\"45bc84bce1bbce25d6be70980186bab1.jpeg\",\"id\":\"804eb07efc324a13a2b312afd6c2b747\",\"url\":\"ocean-disaster/Task/2024/12/0917/45bc84bce1bbce25d6be70980186bab1.jpeg\"}]",
"UPDATED_BY": null,
"TENANT_ID": null,
"ID": "1922560022638792705",
"CONTENT": "xxh上报点位2,该地区受灾情况如下:受二级风暴潮影响,该地区出现67.34厘米的风暴增水...",
"REPORT_TIME": "2024-12-09 16:50:44",
"ZHZQ_ID": "1922560017270083585",
"LAT": "26.7660"
},
{
"ZHZQ_CODE": "tempStorm-241209",
"CREATED_BY": null,
"REVISION": null,
"SOURCE_ID": "7f8f087a22a94b5db5d4d5bccb1eea27",
"CREATED_TIME": null,
"UPDATED_TIME": null,
"LON": "119.7682",
"PIC": "[{\"name\":\"78b52c4f3d9fe99bfcfba522f7dc3e38.jpeg\",\"id\":\"d109a78a6ee24edc81c67390c36df627\",\"url\":\"ocean-disaster/Task/2024/12/0916/78b52c4f3d9fe99bfcfba522f7dc3e38.jpeg\"}]",
"UPDATED_BY": null,
"TENANT_ID": null,
"ID": "1922560023620259841",
"CONTENT": "xxh上报点位1:沧县无受灾情况",
"REPORT_TIME": "2024-12-09 16:44:18",
"ZHZQ_ID": "1922560017270083585",
"LAT": "26.7064"
},
{
"ZHZQ_CODE": "tempStorm-241209",
"CREATED_BY": null,
"REVISION": null,
"SOURCE_ID": "43b6e7f8146e4513959d88561ad7c380",
"CREATED_TIME": null,
"UPDATED_TIME": null,
"LON": "118.3460",
"PIC": "[{\"name\":\"2ac43f49608d15b91b36f9f777c049da.gif\",\"id\":\"e12fbab8704b4e59987a54364db7869c\",\"url\":\"ocean-disaster/Task/2024/12/0916/2ac43f49608d15b91b36f9f777c049da.gif\"}]",
"UPDATED_BY": null,
"TENANT_ID": null,
"ID": "1922560024622698498",
"CONTENT": "gjx上报点位5,该地区受灾情况如下:",
"REPORT_TIME": "2024-12-09 16:31:53",
"ZHZQ_ID": "1922560017270083585",
"LAT": "24.3892"
},
{
"ZHZQ_CODE": "tempStorm-241209",
"CREATED_BY": null,
"REVISION": null,
"SOURCE_ID": "c3a25b535da248c7bf19356cf906f45d",
"CREATED_TIME": null,
"UPDATED_TIME": null,
"LON": "118.9186",
"PIC": "[{\"name\":\"096c21156940ee20670f0312d463b741.jpeg\",\"id\":\"ac6e03a022d8482f9eee211e973d42ce\",\"url\":\"ocean-disaster/Task/2024/12/0916/096c21156940ee20670f0312d463b741.jpeg\"}]",
"UPDATED_BY": null,
"TENANT_ID": null,
"ID": "1922560025599971329",
"CONTENT": "gjx上报点位4,该地区受灾情况如下:唐山市受三级风暴潮影响,出现178.23厘米的风暴增水...",
"REPORT_TIME": "2024-12-09 16:12:32",
"ZHZQ_ID": "1922560017270083585",
"LAT": "24.5659"
},
{
"ZHZQ_CODE": "tempStorm-241209",
"CREATED_BY": null,
"REVISION": null,
"SOURCE_ID": "cc82810e6eef4732b7629592e78fd765",
"CREATED_TIME": null,
"UPDATED_TIME": null,
"LON": "117.9635",
"PIC": "[{\"name\":\"ef0f3f59bcaccb6c4780a209fd3af166.jpeg\",\"id\":\"36c4657dc6544305b4b37a647bd08fc4\",\"url\":\"ocean-disaster/Task/2024/12/0916/ef0f3f59bcaccb6c4780a209fd3af166.jpeg\"}]",
"UPDATED_BY": null,
"TENANT_ID": null,
"ID": "1922560026589827074",
"CONTENT": "gjx上报点位3:该地区受灾情况如下,警报等级三级,出现80.23厘米的风暴增水...",
"REPORT_TIME": "2024-12-09 15:53:02",
"ZHZQ_ID": "1922560017270083585",
"LAT": "24.6136"
},
{
"ZHZQ_CODE": "tempStorm-241209",
"CREATED_BY": null,
"REVISION": null,
"SOURCE_ID": "66d1af0b2d0a4e208621357b1a53c177",
"CREATED_TIME": null,
"UPDATED_TIME": null,
"LON": "118.4179",
"PIC": "[{\"name\":\"78b52c4f3d9fe99bfcfba522f7dc3e38.jpeg\",\"id\":\"930425e4c93d45fe81e86d49b605af85\",\"url\":\"ocean-disaster/Task/2024/12/0915/78b52c4f3d9fe99bfcfba522f7dc3e38.jpeg\"}]",
"UPDATED_BY": null,
"TENANT_ID": null,
"ID": "1922560027567099906",
"CONTENT": "gjx上报点位2:该地区无受灾情况",
"REPORT_TIME": "2024-12-09 15:39:46",
"ZHZQ_ID": "1922560017270083585",
"LAT": "24.6076"
},
{
"ZHZQ_CODE": "tempStorm-241209",
"CREATED_BY": null,
"REVISION": null,
"SOURCE_ID": "d67ee4c4e4b44e9aacb81715e0b1189a",
"CREATED_TIME": null,
"UPDATED_TIME": null,
"LON": "117.3098",
"PIC": "[{\"name\":\"78b52c4f3d9fe99bfcfba522f7dc3e38.jpeg\",\"id\":\"646332d4e83e453ba770a4f4cbcdb8a8\",\"url\":\"ocean-disaster/Task/2024/12/0915/78b52c4f3d9fe99bfcfba522f7dc3e38.jpeg\"}]",
"UPDATED_BY": null,
"TENANT_ID": null,
"ID": "1922560028556955650",
"CONTENT": "gjx上报点位1:该地区无受灾情况",
"REPORT_TIME": "2024-12-09 15:32:38",
"ZHZQ_ID": "1922560017270083585",
"LAT": "24.8184"
},
{
"ZHZQ_CODE": "tempStorm-241209",
"CREATED_BY": null,
"REVISION": null,
"SOURCE_ID": "ba907379f99d4a06b9ea83977252223b",
"CREATED_TIME": null,
"UPDATED_TIME": null,
"LON": "118.3350",
"PIC": "[{\"contentType\":\"image/jpeg\",\"id\":\"f3b334eaefa24efe9e316e57e84e59ab\",\"length\":13706,\"name\":\"wave3.jpg\",\"url\":\"http://8.142.144.85:9000/ocean-disaster/Task/2024/12/0915/wave3.jpg\",\"extname\":\"jpg\"}]",
"UPDATED_BY": null,
"TENANT_ID": null,
"ID": "1922560029555200001",
"CONTENT": "tzw上报点位4:该地受灾情况如下",
"REPORT_TIME": "2024-12-09 15:10:45",
"ZHZQ_ID": "1922560017270083585",
"LAT": "24.3197"
},
{
"ZHZQ_CODE": "tempStorm-241209",
"CREATED_BY": null,
"REVISION": null,
"SOURCE_ID": "c97b114234524cc0bd4356ed91a81de3",
"CREATED_TIME": null,
"UPDATED_TIME": null,
"LON": "118.4492",
"PIC": "[{\"name\":\"45bc84bce1bbce25d6be70980186bab1.jpeg\",\"id\":\"ee9871519d314da9b0518ff33525805d\",\"url\":\"ocean-disaster/Task/2024/12/0915/45bc84bce1bbce25d6be70980186bab1.jpeg\"}]",
"UPDATED_BY": null,
"TENANT_ID": null,
"ID": "1922560030540861441",
"CONTENT": "tzw上报点位3,受灾情况如下",
"REPORT_TIME": "2024-12-09 15:03:45",
"ZHZQ_ID": "1922560017270083585",
"LAT": "24.5638"
},
{
"ZHZQ_CODE": "tempStorm-241209",
"CREATED_BY": null,
"REVISION": null,
"SOURCE_ID": "3c9058575dab4ff1875719bf82aa9c30",
"CREATED_TIME": null,
"UPDATED_TIME": null,
"LON": "117.1784",
"PIC": "[{\"name\":\"ef0f3f59bcaccb6c4780a209fd3af166.jpeg\",\"id\":\"616b19a66c6b40e5a7bd686c72819026\",\"url\":\"ocean-disaster/Task/2024/12/0912/ef0f3f59bcaccb6c4780a209fd3af166.jpeg\"}]",
"UPDATED_BY": null,
"TENANT_ID": null,
"ID": "1922560031534911489",
"CONTENT": "tzw上报点位2:灾情描述如下",
"REPORT_TIME": "2024-12-09 12:28:48",
"ZHZQ_ID": "1922560017270083585",
"LAT": "24.3455"
},
{
"ZHZQ_CODE": "tempStorm-241209",
"CREATED_BY": null,
"REVISION": null,
"SOURCE_ID": "1bca7e5f1f534526ab343cb3f522131a",
"CREATED_TIME": null,
"UPDATED_TIME": null,
"LON": "117.1269",
"PIC": "[{\"name\":\"c1db3b5a14bde8a90522f59e29381452.jpeg\",\"id\":\"728b3354c0fd41458afce673960fbc20\",\"url\":\"ocean-disaster/Task/2024/12/0912/c1db3b5a14bde8a90522f59e29381452.jpeg\"}]",
"UPDATED_BY": null,
"TENANT_ID": null,
"ID": "1922560032524767233",
"CONTENT": "tzw上报点位1:受灾情况如下",
"REPORT_TIME": "2024-12-09 12:23:09",
"ZHZQ_ID": "1922560017270083585",
"LAT": "24.2749"
}
]
},
"tm": "2025-06-05 10:45:31"
}