/******
项企数据库维护升级脚本
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 '流程节点数';