表结构设计
<p>新增7张表</p>
<table>
<thead>
<tr>
<th>name</th>
<th>code</th>
</tr>
</thead>
<tbody>
<tr>
<td>字典类型表</td>
<td>proc_dict_type</td>
</tr>
<tr>
<td>流程字典表</td>
<td>proc_dict_info</td>
</tr>
<tr>
<td>业务信息表</td>
<td>proc_biz_info</td>
</tr>
<tr>
<td>字段信息表</td>
<td>proc_col_info</td>
</tr>
<tr>
<td>流程信息表</td>
<td>proc_flow_info</td>
</tr>
</tbody>
</table>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=d061e252d87a6e2c8501e21398d4b576&file=file.png" alt="" /></p>
<ul>
<li>proc_dict_type</li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>id</td>
</tr>
<tr>
<td>biz_id</td>
<td>int</td>
<td>是</td>
<td></td>
<td>业务id</td>
</tr>
<tr>
<td>type_code</td>
<td>varchar(100)</td>
<td>否</td>
<td></td>
<td>类型编码</td>
</tr>
<tr>
<td>type_name</td>
<td>varchar(100)</td>
<td>否</td>
<td></td>
<td>类型名称</td>
</tr>
<tr>
<td>is_common</td>
<td>tinyint</td>
<td>否</td>
<td></td>
<td>是否公共</td>
</tr>
</tbody>
</table>
<pre><code class="language-sql">create table proc_dict_type
(
id int not null auto_increment comment 'id',
biz_id int comment '业务id',
type_code varchar(100) not null comment '类型编码',
type_name varchar(100) not null comment '类型名称',
is_common tinyint not null comment '是否公共',
primary key (id)
);
alter table proc_dict_type comment '流程字典类型';</code></pre>
<ul>
<li>proc_dict_info</li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>id</td>
</tr>
<tr>
<td>type_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>字典类型</td>
</tr>
<tr>
<td>dict_code</td>
<td>varchar(100)</td>
<td>否</td>
<td></td>
<td>字典编码</td>
</tr>
<tr>
<td>dict_value</td>
<td>varchar(100)</td>
<td>否</td>
<td></td>
<td>字典值</td>
</tr>
</tbody>
</table>
<pre><code class="language-sql">create table proc_dict_info
(
id int not null auto_increment comment 'id',
type_id int not null comment '字典类型',
dict_code varchar(100) not null comment '字典编码',
dict_value varchar(100) not null comment '字典值',
primary key (id)
);
alter table proc_dict_info comment '流程字典表';</code></pre>
<ul>
<li>proc_biz_info</li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>id</td>
</tr>
<tr>
<td>biz_name</td>
<td>varchar(200)</td>
<td>否</td>
<td></td>
<td>业务名称</td>
</tr>
<tr>
<td>flow_title</td>
<td>varchar(500)</td>
<td>是</td>
<td></td>
<td>流程标题</td>
</tr>
<tr>
<td>if_shared</td>
<td>tinyint</td>
<td>否</td>
<td></td>
<td>是否共享 0 是;1 否</td>
</tr>
<tr>
<td>creater</td>
<td>varchar(50)</td>
<td>否</td>
<td></td>
<td>创建人</td>
</tr>
<tr>
<td>create_time</td>
<td>date</td>
<td>否</td>
<td>CURRENT_TIMESTAMP</td>
<td>创建时间</td>
</tr>
</tbody>
</table>
<pre><code class="language-sql">create table proc_biz_info
(
id int not null auto_increment comment 'id',
biz_name varchar(200) not null comment '业务名称',
flow_title varchar(500) comment '流程标题',
if_shared tinyint not null comment '是否共享 0|是;1|否',
creater varchar(50) not null comment '创建人',
create_time date not null default CURRENT_TIMESTAMP comment '创建时间',
primary key (id)
);
alter table proc_biz_info comment '业务信息';</code></pre>
<ul>
<li>proc_col_info</li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>id</td>
</tr>
<tr>
<td>biz_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>业务id</td>
</tr>
<tr>
<td>col_name</td>
<td>varchar(500)</td>
<td>否</td>
<td></td>
<td>字段名称</td>
</tr>
<tr>
<td>col_code</td>
<td>varchar(500)</td>
<td>否</td>
<td></td>
<td>字段编码</td>
</tr>
<tr>
<td>type</td>
<td>varchar(100)</td>
<td>否</td>
<td></td>
<td>组件类型</td>
</tr>
<tr>
<td>col_dict_info</td>
<td>int</td>
<td>是</td>
<td></td>
<td>字典类型</td>
</tr>
<tr>
<td>length</td>
<td>varchar(200)</td>
<td>是</td>
<td></td>
<td>字段长度</td>
</tr>
<tr>
<td>if_required</td>
<td>varchar(10)</td>
<td>否</td>
<td></td>
<td>是否必填</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>是</td>
<td></td>
<td>显示顺序</td>
</tr>
<tr>
<td>remark</td>
<td>varchar(1000)</td>
<td>是</td>
<td></td>
<td>字段描述</td>
</tr>
<tr>
<td>def_val</td>
<td>varchar(500)</td>
<td>是</td>
<td></td>
<td>展示默认值</td>
</tr>
<tr>
<td>creater</td>
<td>varchar(100)</td>
<td>否</td>
<td></td>
<td>创建人</td>
</tr>
<tr>
<td>create_time</td>
<td>date</td>
<td>否</td>
<td>CURRENT_TIMESTAMP</td>
<td>创建时间</td>
</tr>
</tbody>
</table>
<pre><code class="language-sql">create table proc_col_info
(
id int not null auto_increment comment 'id',
biz_id int not null comment '业务id',
col_name varchar(500) not null comment '字段名称',
col_code varchar(500) not null comment '字段编码',
type varchar(100) not null comment '组件类型',
col_dict_info int comment '字典类型',
length varchar(200) not null comment '字段长度',
if_required varchar(10) not null comment '是否必填',
sort int comment '显示顺序',
remark varchar(1000) comment '字段描述',
def_val varchar(500) comment '展示默认值',
creater varchar(100) not null comment '创建人',
create_time date not null default CURRENT_TIMESTAMP comment '创建时间',
primary key (id)
);
alter table proc_col_info comment '字段信息';
</code></pre>
<ul>
<li>proc_flow_info</li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>id</td>
</tr>
<tr>
<td>flow_id</td>
<td>varchar(100)</td>
<td>否</td>
<td></td>
<td>流程id</td>
</tr>
<tr>
<td>biz_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>业务</td>
</tr>
<tr>
<td>flow_info</td>
<td>text</td>
<td>否</td>
<td></td>
<td>流程内容</td>
</tr>
<tr>
<td>creater</td>
<td>varchar(100)</td>
<td>否</td>
<td></td>
<td>创建人</td>
</tr>
<tr>
<td>create_time</td>
<td>date</td>
<td>否</td>
<td>CURRENT_TIMESTAMP</td>
<td>创建时间</td>
</tr>
</tbody>
</table>
<pre><code class="language-sql">create table proc_flow_info
(
id int not null auto_increment comment 'id',
flow_id varchar(100) not null comment '流程id',
biz_id int not null comment '业务',
flow_info text not null comment '流程内容',
creater varchar(100) not null comment '创建人',
create_time date not null default CURRENT_TIMESTAMP comment '创建时间',
primary key (id)
);
alter table proc_flow_info comment '流程信息';</code></pre>
<ul>
<li>proc_manager_info</li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>id</td>
</tr>
<tr>
<td>emp_name</td>
<td>varchar(100)</td>
<td>否</td>
<td></td>
<td>姓名</td>
</tr>
<tr>
<td>userid</td>
<td>varchar(10)</td>
<td>否</td>
<td></td>
<td>userid</td>
</tr>
</tbody>
</table>
<pre><code class="language-sql">create table proc_manager_info
(
id int not null auto_increment comment '',
emp_name varchar(100) not null comment '姓名',
userid varchar(10) not null comment 'userid',
primary key (id)
);
alter table proc_manager_info comment '管理员信息表';</code></pre>
<h6>备注:</h6>
<p>城市组件+单选
常用组件表 单独存 城市、性别等 可将自定义组件绑定常用,绑定后常用表中组件只能管理员修改
组件类型对应值字段(默认值)
目前只能移动端做配置字段,pc端desk做不了</p>