功能说明
<ul>
<li>传阅表,储存流程实例传阅信息</li>
</ul>
<pre><code class="language-sql">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');
</code></pre>
<table>
<thead>
<tr>
<th style="text-align: left;">字段</th>
<th style="text-align: left;">类型</th>
<th style="text-align: left;">空</th>
<th>默认</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">uuid</td>
<td style="text-align: left;">varchar(100)</td>
<td style="text-align: left;">是</td>
<td></td>
<td>唯一键</td>
</tr>
<tr>
<td style="text-align: left;">p_uuid</td>
<td style="text-align: left;">varchar(100)</td>
<td style="text-align: left;">是</td>
<td></td>
<td>流程实例id</td>
</tr>
<tr>
<td style="text-align: left;">user_id</td>
<td style="text-align: left;">varchar(100)</td>
<td style="text-align: left;">是</td>
<td></td>
<td>用户id</td>
</tr>
<tr>
<td style="text-align: left;">is_read</td>
<td style="text-align: left;">bool</td>
<td style="text-align: left;">是</td>
<td></td>
<td>是否已阅</td>
</tr>
<tr>
<td style="text-align: left;">create_time</td>
<td style="text-align: left;">varchar(50)</td>
<td style="text-align: left;">否</td>
<td></td>
<td>创建时间</td>
</tr>
<tr>
<td style="text-align: left;">read_time</td>
<td style="text-align: left;">varchar(50)</td>
<td style="text-align: left;">否</td>
<td></td>
<td>已阅时间</td>
</tr>
</tbody>
</table>
<ul>
<li>备注:无</li>
</ul>