警戒潮位板块-警戒潮位标志物(右上)

COMMENT ON TABLE "JSC"."T_WARNING_IDENTIFIER_ENTITY" IS '岸段警戒潮位标志物信息表';

COMMENT ON COLUMN "JSC"."T_WARNING_IDENTIFIER_ENTITY"."ID" IS '主键ID';

COMMENT ON COLUMN "JSC"."T_WARNING_IDENTIFIER_ENTITY"."COASTID" IS '岸段id';

COMMENT ON COLUMN "JSC"."T_WARNING_IDENTIFIER_ENTITY"."COASTNAME" IS '岸段名称';

COMMENT ON COLUMN "JSC"."T_WARNING_IDENTIFIER_ENTITY"."WARNID" IS '岸段警戒潮位评价ID，即标志物呈现的哪次评价的信息';

COMMENT ON COLUMN "JSC"."T_WARNING_IDENTIFIER_ENTITY"."NAME" IS '警戒潮位标志物名称';

COMMENT ON COLUMN "JSC"."T_WARNING_IDENTIFIER_ENTITY"."IDENTIFIER_IMAGE" IS '警戒潮位标志物图片，base64码';

COMMENT ON COLUMN "JSC"."T_WARNING_IDENTIFIER_ENTITY"."IDENTIFIER_TIME" IS '警戒潮位标志物建成时间';

COMMENT ON COLUMN "JSC"."T_WARNING_IDENTIFIER_ENTITY"."IDENTIFIER_TYPE" IS '警戒潮位标志物类型，如直涂式警示柱/牌、直观式警示柱和亮化式警示柱等类型';

COMMENT ON COLUMN "JSC"."T_WARNING_IDENTIFIER_ENTITY"."IDENTIFIER_ADVISE" IS '警戒潮位标志物警示应急措施信息';

COMMENT ON COLUMN "JSC"."T_WARNING_IDENTIFIER_ENTITY"."LONGITUDE" IS '标志物经度';

COMMENT ON COLUMN "JSC"."T_WARNING_IDENTIFIER_ENTITY"."LATITUDE" IS '标志物纬度';

COMMENT ON COLUMN "JSC"."T_WARNING_IDENTIFIER_ENTITY"."REMARK" IS '备注';

COMMENT ON COLUMN "JSC"."T_WARNING_IDENTIFIER_ENTITY"."CJR" IS '创建人';

COMMENT ON COLUMN "JSC"."T_WARNING_IDENTIFIER_ENTITY"."CJSJ" IS '创建时间';

COMMENT ON COLUMN "JSC"."T_WARNING_IDENTIFIER_ENTITY"."ZHGXR" IS '最后更新人';

COMMENT ON COLUMN "JSC"."T_WARNING_IDENTIFIER_ENTITY"."ZHGXSJ" IS '最后更新时间';
{
    "msg": "",
    "code": 200,
    "data": {
        "list": [
            {
                "COASTNAME": "湄洲岛岸段",
                "IDENTIFIER_TYPE": "自建",
                "CJSJ": null,
                "IDENTIFIER_ADVISE": "核定",
                "ZHGXR": null,
                "IDENTIFIER_IMAGE": "https://cdn.pixabay.com/photo/2021/11/07/21/09/buoy-6777906_640.jpg",
                "LONGITUDE": 119.647951,
                "CJR": "张峰",
                "NAME": "湄洲岛岸段标志物",
                "WARNID": "1",
                "IDENTIFIER_TIME": "2023-03-12",
                "COASTID": null,
                "ZHGXSJ": null,
                "ID": "1",
                "LATITUDE": 25.214163,
                "REMARK": null
            },
            {
                "COASTNAME": "荔城岸段",
                "IDENTIFIER_TYPE": "自建",
                "CJSJ": null,
                "IDENTIFIER_ADVISE": "核定",
                "ZHGXR": null,
                "IDENTIFIER_IMAGE": "https://cdn.pixabay.com/photo/2012/12/24/08/38/buoy-72044_1280.jpg",
                "LONGITUDE": 118.818379,
                "CJR": "王林",
                "NAME": "荔城岸段标志物",
                "WARNID": "1",
                "IDENTIFIER_TIME": "2018-04-22",
                "COASTID": null,
                "ZHGXSJ": null,
                "ID": "2",
                "LATITUDE": 24.947484,
                "REMARK": null
            }
        ]
    },
    "tm": "2025-04-08 13:05:59"
}