功能说明

  • 传阅表,储存流程实例传阅信息
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) 已阅时间
  • 备注:无