功能说明

• 传阅表，储存流程实例传阅信息

CREATE TABLE "public"."process_circulate" (
  "uuid" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "p_uuid" varchar(100) COLLATE "pg_catalog"."default",
  "user_id" varchar(100) COLLATE "pg_catalog"."default",
  "is_read" bool,
  "create_time" varchar(50) COLLATE "pg_catalog"."default",
  "read_time" varchar(50) COLLATE "pg_catalog"."default"
) ;
ALTER TABLE "public"."process_circulate" ADD CONSTRAINT "process_circulate_pkey" PRIMARY KEY ("uuid");

-- 网关
INSERT INTO "public"."BasicGatewayRoute"("uuid", "name", "sourcepath", "module", "targeturl", "targetpath", "logtype", "logcontent", "param", "responsebody", "remark", "createTime", "state", "updateTime", "verify", "type", "moduleId") VALUES ('0a344cc6-ca38-4e2b-bf23-8a1a87c18f12', '传阅-已阅列表', '/ops/workflow/query/rest/processInst/instCirculationRead', 'workflow', '192.168.2.107:8096', '/workflow/query/rest/processInst/instCirculationRead', '操作', '', '{}', '{}', '', '', 0, '', 't', 'normal', 'uuidworkflow');
INSERT INTO "public"."BasicGatewayRoute"("uuid", "name", "sourcepath", "module", "targeturl", "targetpath", "logtype", "logcontent", "param", "responsebody", "remark", "createTime", "state", "updateTime", "verify", "type", "moduleId") VALUES ('0a344cc6-ca38-4e2b-bf23-8a1a87c18f13', '传阅-已阅列表-高级搜索', '/ops/workflow/query/rest/processInst/advancedSearch/instCirculationRead', NULL, NULL, '/workflow/query/rest/processInst/advancedSearch/instCirculationRead', '操作', '', '', '', '', '2021-08-24 16:19:08', 0, '2021-08-24 16:19:08', 't', 'normal', 'uuidworkflow');

INSERT INTO "public"."BasicGatewayRoute"("uuid", "name", "sourcepath", "module", "targeturl", "targetpath", "logtype", "logcontent", "param", "responsebody", "remark", "createTime", "state", "updateTime", "verify", "type", "moduleId") VALUES ('0a344cc6-ca38-4e2b-bf23-8a1a87c18f14', '传阅-全部列表', '/ops/workflow/query/rest/processInst/instCirculationAll', 'workflow', '192.168.2.107:8096', '/workflow/query/rest/processInst/instCirculationAll', '操作', '', '{}', '{}', '', '', 0, '', 't', 'normal', 'uuidworkflow');
INSERT INTO "public"."BasicGatewayRoute"("uuid", "name", "sourcepath", "module", "targeturl", "targetpath", "logtype", "logcontent", "param", "responsebody", "remark", "createTime", "state", "updateTime", "verify", "type", "moduleId") VALUES ('0a344cc6-ca38-4e2b-bf23-8a1a87c18f15', '传阅-全部列表-高级搜索', '/ops/workflow/query/rest/processInst/advancedSearch/instCirculationAll', NULL, NULL, '/workflow/query/rest/processInst/advancedSearch/instCirculationAll', '操作', '', '', '', '', '2021-08-24 16:19:08', 0, '2021-08-24 16:19:08', 't', 'normal', 'uuidworkflow');

INSERT INTO "public"."BasicGatewayRoute"("uuid", "name", "sourcepath", "module", "targeturl", "targetpath", "logtype", "logcontent", "param", "responsebody", "remark", "createTime", "state", "updateTime", "verify", "type", "moduleId") VALUES ('0a344cc6-ca38-4e2b-bf23-8a1a87c18f16', '修改待阅为已阅', '/ops/workflow/task/rest/processInst/instCirculationRead', 'workflow', '192.168.2.107:8096', '/workflow/task/rest/processInst/instCirculationRead', '操作', '', '{}', '{}', '', '', 0, '', 't', 'normal', 'uuidworkflow');
INSERT INTO "public"."BasicGatewayRoute"("uuid", "name", "sourcepath", "module", "targeturl", "targetpath", "logtype", "logcontent", "param", "responsebody", "remark", "createTime", "state", "updateTime", "verify", "type", "moduleId") VALUES ('0a344cc6-ca38-4e2b-bf23-8a1a87c18f17', '流程列表分阅按钮', '/ops/workflow/task/rest/processInst/taskSharing', NULL, NULL, '/workflow/task/rest/processInst/taskSharing', '操作', '', '', '', '', '2021-08-24 16:19:08', 0, '2021-08-24 16:19:08', 't', 'normal', 'uuidworkflow');

字段	类型	空	默认	注释
uuid	varchar(100)	是		唯一键
p_uuid	varchar(100)	是		流程实例id
user_id	varchar(100)	是		用户id
is_read	bool	是		是否已阅
create_time	varchar(50)	否		创建时间
read_time	varchar(50)	否		已阅时间

• 备注：无