灾害风险板块-滨海旅游区_指定站点信息_关联视频监控

COMMENT ON COLUMN "JSC"."bhlyyp_travel_video"."bhlyyp_travel_id" IS '所属滨海旅游区';
COMMENT ON COLUMN "JSC"."bhlyyp_travel_video"."video_name" IS '名称';
COMMENT ON COLUMN "JSC"."bhlyyp_travel_video"."video_url" IS '接口地址';
COMMENT ON COLUMN "JSC"."bhlyyp_travel_video"."create_by" IS '创建人';
COMMENT ON COLUMN "JSC"."bhlyyp_travel_video"."create_time" IS '创建日期';
COMMENT ON COLUMN "JSC"."bhlyyp_travel_video"."update_by" IS '更新人';
COMMENT ON COLUMN "JSC"."bhlyyp_travel_video"."update_time" IS '更新日期';
COMMENT ON COLUMN "JSC"."bhlyyp_travel_video"."sys_org_code" IS '所属部门';
COMMENT ON COLUMN "JSC"."bhlyyp_travel_video"."lon" IS '经度（°）';
COMMENT ON COLUMN "JSC"."bhlyyp_travel_video"."lat" IS '纬度（°）';
COMMENT ON COLUMN "JSC"."bhlyyp_travel_video"."connect_status" IS '通讯情况';
COMMENT ON COLUMN "JSC"."bhlyyp_travel_video"."connect_status_time" IS '通信情况检测时间';
使用 video_url就是Channelid.  调用视频播放接口, 获取视频地址. 进行播放.

{
    "msg": "",
    "code": 200,
    "data": {
        "list": [
            {
                "video_name": "九龙江口XM004_1",
                "connect_status": "1",
                "create_time": "2025-02-05 13:51:26",
                "sys_org_code": "A02",
                "bhlyyp_travel_id": "1903111751659028522",
                "lon": 118.0247,
                "create_by": "yuansu",
                "update_time": "2025-04-23 21:29:48",
                "video_url": "11633949492971776",
                "connect_status_time": "2025-04-08 00:00:00",
                "id": "1887016160973705218",
                "update_by": "yuansu",
                "lat": 24.2571
            },
            {
                "video_name": "同安湾XM001",
                "connect_status": "1",
                "create_time": "2025-02-05 13:51:37",
                "sys_org_code": "A02",
                "bhlyyp_travel_id": "1903111751659028522",
                "lon": 118.1084,
                "create_by": "yuansu",
                "update_time": "2025-04-23 21:29:59",
                "video_url": "11652051251104001",
                "connect_status_time": "2025-04-08 00:00:00",
                "id": "1887016204556718082",
                "update_by": "yuansu",
                "lat": 24.3488
            }
        ]
    },
    "tm": "2025-05-13 23:52:23"
}