You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 

20 lines
884 B

/******
项企数据库维护升级脚本
2022-11-16 14:40:00
表清单:
stats_process_nodes (流程节点数统计表)
******/
-- ###<创建流程节点数统计表><彭玲><202211161440>
create table if not exists pepca.public.stats_process_nodes (
process_version_id integer not null constraint stats_process_nodes_pk primary key,
process_id integer not null,
process_name varchar(255) not null,
process_nodes_total integer not null
);
comment on table pepca.public.stats_process_nodes is '流程节点数统计表';
comment on column pepca.public.stats_process_nodes.process_version_id is '流程版本id';
comment on column pepca.public.stats_process_nodes.process_id is '流程id';
comment on column pepca.public.stats_process_nodes.process_name is '流程名称';
comment on column pepca.public.stats_process_nodes.process_nodes_total is '流程节点数';