感知自然项目管理

数据管理

数据管理列表

1. 创建数据管理表dataset

CREATE TABLE public.dataset (
  id varchar(255) NULL,
  creator varchar(32) NULL,
  modifier varchar(32) NULL,
  created_time int8 NULL,
  modified_time int8 NULL,
  deleted bool DEFAULT false NULL,
  tenant_key int4 NULL,
  dataset_name varchar(255) NULL,
  dataset_origin varchar(255) NULL,
  dataset_type varchar(32) NOT NULL,
  annotation_status int2 NULL,
  dataset_order int4 NULL,
  CONSTRAINT dataset_pk PRIMARY KEY (id)
);
COMMENT ON TABLE public.dataset IS '数据管理';

-- Column comments

COMMENT ON COLUMN public.dataset.id IS '表逐渐';
COMMENT ON COLUMN public.dataset.creator IS '创建人';
COMMENT ON COLUMN public.dataset.modifier IS '修改人';
COMMENT ON COLUMN public.dataset.created_time IS '创建时间';
COMMENT ON COLUMN public.dataset.modified_time IS '修改时间';
COMMENT ON COLUMN public.dataset.dataset_name IS '数据名称';
COMMENT ON COLUMN public.dataset.dataset_origin IS '数据来源';
COMMENT ON COLUMN public.dataset.dataset_type IS '数据类型: 1-图片 2-音频 3-视频 4-其他';
COMMENT ON COLUMN public.dataset.annotation_status IS '标注状态: 0-未标注 2-标注中 1-已标注';
COMMENT ON COLUMN public.dataset.dataset_order IS '数据order, 排序用';

2. 创建数据文件表dataset_media

CREATE TABLE public.dataset_media (
  id varchar(255) NOT NULL,
  creator varchar(32) NULL,
  modifier varchar(32) NULL,
  created_time int8 NULL,
  modified_time int8 NULL,
  deleted bool DEFAULT false NULL,
  tenant_key int4 NULL,
  media_type varchar(32) NOT NULL,
  media_url varchar(255) NULL,
  annotation_status int2 NULL,
  media_duration float8 NULL,
  media_thumbnail varchar(255) NULL,
  check_status int2 NULL,
  audit_status int2 NULL,
  dataset_id varchar(255) NULL
);
COMMENT ON TABLE public.dataset_media IS '数据文件表';

-- Column comments

COMMENT ON COLUMN public.dataset_media.id IS '表逐渐';
COMMENT ON COLUMN public.dataset_media.creator IS '创建人';
COMMENT ON COLUMN public.dataset_media.modifier IS '修改人';
COMMENT ON COLUMN public.dataset_media.created_time IS '创建时间';
COMMENT ON COLUMN public.dataset_media.modified_time IS '修改时间';
COMMENT ON COLUMN public.dataset_media.media_type IS '媒体类型: 1-图片 2-音频 3-视频 4-其他';
COMMENT ON COLUMN public.dataset_media.media_url IS '媒体地址';
COMMENT ON COLUMN public.dataset_media.annotation_status IS '标注状态: 0-未标注 2-标注中 1-已标注';
COMMENT ON COLUMN public.dataset_media.media_duration IS '音/视频时长';
COMMENT ON COLUMN public.dataset_media.media_thumbnail IS '图片/视频封面缩略图';
COMMENT ON COLUMN public.dataset_media.check_status IS '0-不合格 1-合格';
COMMENT ON COLUMN public.dataset_media.audit_status IS '审核状态: 0-未审核 1-已审核';
COMMENT ON COLUMN public.dataset_media.dataset_id IS '数据集id';