感知自然项目管理
蒲公英 2025-07-07 感知自然项目管理
# 数据管理
# 数据管理列表
- 创建数据管理表
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, 排序用';
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
- 创建数据文件表
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';
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34