BBIT-Kai
44 lines
1.7 KiB
SQL
44 lines
1.7 KiB
SQL
/*
|
|
Navicat Premium Dump SQL
|
|
|
|
Source Server : 智能控制平台
|
|
Source Server Type : PostgreSQL
|
|
Source Server Version : 150013 (150013)
|
|
Source Host : 10.10.10.9:5432
|
|
Source Catalog : ktor2
|
|
Source Schema : public
|
|
|
|
Target Server Type : PostgreSQL
|
|
Target Server Version : 150013 (150013)
|
|
File Encoding : 65001
|
|
|
|
Date: 18/09/2025 16:10:44
|
|
*/
|
|
|
|
|
|
-- ----------------------------
|
|
-- Table structure for video_analytics_details
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."video_analytics_details";
|
|
CREATE TABLE "public"."video_analytics_details" (
|
|
"id" uuid NOT NULL DEFAULT gen_random_uuid(),
|
|
"v_id" uuid,
|
|
"time_stamp" int4 NOT NULL,
|
|
"total_people" int4,
|
|
"total_people_masked" int4,
|
|
"action" varchar(50) COLLATE "pg_catalog"."default"
|
|
)
|
|
;
|
|
COMMENT ON COLUMN "public"."video_analytics_details"."id" IS '主键';
|
|
COMMENT ON COLUMN "public"."video_analytics_details"."v_id" IS '所属视频分析任务ID';
|
|
COMMENT ON COLUMN "public"."video_analytics_details"."time_stamp" IS '时间戳';
|
|
COMMENT ON COLUMN "public"."video_analytics_details"."total_people" IS '当前时间出现的总人数';
|
|
COMMENT ON COLUMN "public"."video_analytics_details"."total_people_masked" IS '当前时间佩戴口罩的人数';
|
|
COMMENT ON COLUMN "public"."video_analytics_details"."action" IS '动作';
|
|
COMMENT ON TABLE "public"."video_analytics_details" IS '视频分析-动作识别任务-分析详情';
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table video_analytics_details
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."video_analytics_details" ADD CONSTRAINT "video_analytics_details_pkey" PRIMARY KEY ("id");
|