| 123456789101112131415161718192021 |
- create table flow_user
- (
- id bigint not null comment '主键id'
- primary key,
- type char not null comment '人员类型（1待办任务的审批人权限 2待办任务的转办人权限 3待办任务的委托人权限）',
- processed_by varchar(80) null comment '权限人',
- associated bigint not null comment '任务表id',
- create_time datetime null comment '创建时间',
- create_by varchar(80) null comment '创建人',
- update_time datetime null comment '更新时间',
- del_flag char default '0' null comment '删除标志',
- tenant_id varchar(40) null comment '租户id'
- )
- comment '流程用户表';
- create index user_associated
- on flow_user (associated);
- create index user_processed_type
- on flow_user (processed_by, type);
|
