sql/flow-node.sql · javaalpha/dcy-fast

Fetch the repository succeeded.

Scan WeChat QR to Pay

Cancel

Complete

richgiteeai

Watch

Unwatch Watching Releases Only Ignoring

1 Star 0 Fork 150

javaalpha/dcy-fast

forked from 青年/dcy-fast

Code Issues 0 Pull Requests 0 Wiki Insights Pipelines

Service

Tencent Cloud Serverless

Create your Gitee Account

Explore and code with more than 14 million developers,Free private repositories !:)

Already have an account? Sign in

文件

master

Branches (1)

Manage

master

Clone or Download

Clone/Download

HTTPS SSH SVN SVN+SSH Download ZIP

Prompt

To download the code, please copy the following command and execute it in the terminal

To ensure that your submitted code identity is correctly recognized by Gitee, please execute the following command.

git config --global user.name userName 
git config --global user.email userEmail

When using the SSH protocol for the first time to clone or push code, follow the prompts below to complete the SSH configuration.

1 Generate RSA keys.

2 Obtain the content of the RSA public key and configure it in SSH Public Keys

To use SVN on Gitee, please visit the usage guide

When using the HTTPS protocol, the command line will prompt for account and password verification as follows. For security reasons, Gitee recommends configure and use personal access tokens instead of login passwords for cloning, pushing, and other operations.

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # Private Token

Branches 1

Tags 0

dcy-fast

sql

flow-node.sql

flow-node.sql 2.03 KB

drop table if exists act_flow_node;

drop table if exists act_flow_node_dept;

drop table if exists act_flow_node_role;

drop table if exists act_flow_node_user;

/*==============================================================*/
/* Table: act_flow_node */
/*==============================================================*/
create table act_flow_node
(
 id varchar(36) not null comment '主键id',
 proc_def_id varchar(255) comment '流程定义id',
 flow_id varchar(255) comment '流程节点id',
 flow_name varchar(255) comment '流程节点名称',
 flow_type varchar(11) comment '流程审批类型(1:用户;2:角色;3:部门)',
 primary key (id)
);

/*==============================================================*/
/* Table: act_task_node_depa */
/*==============================================================*/
create table act_flow_node_dept
(
 flow_node_id varchar(36) comment '节点类型id',
 dept_id varchar(36) comment '部门id'
);

alter table act_flow_node_dept comment '任务节点关联部门表';

/*==============================================================*/
/* Table: act_task_node_role */
/*==============================================================*/
create table act_flow_node_role
(
 flow_node_id varchar(36) comment '节点类型id',
 role_id varchar(36) comment '角色id'
);

alter table act_flow_node_role comment '任务节点关联角色表';

/*==============================================================*/
/* Table: act_task_node_user */
/*==============================================================*/
create table act_flow_node_user
(
 flow_node_id varchar(36) comment '节点类型id',
 user_id varchar(36) comment '用户id'
);

alter table act_flow_node_user comment '任务节点关联用户表';

Copy Edit Raw Blame History

青年 authored 2021年06月10日 15:43 +08:00 . feat: 添加获取任务列表

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58

drop table if exists act_flow_node;

drop table if exists act_flow_node_dept;

drop table if exists act_flow_node_role;


drop table if exists act_flow_node_user;

/*==============================================================*/
/* Table: act_flow_node */
/*==============================================================*/
create table act_flow_node
(
 id varchar(36) not null comment '主键id',
 proc_def_id varchar(255) comment '流程定义id',
 flow_id varchar(255) comment '流程节点id',
 flow_name varchar(255) comment '流程节点名称',
 flow_type varchar(11) comment '流程审批类型(1:用户;2:角色;3:部门)',
 primary key (id)
);



/*==============================================================*/
/* Table: act_task_node_depa */
/*==============================================================*/
create table act_flow_node_dept
(
 flow_node_id varchar(36) comment '节点类型id',
 dept_id varchar(36) comment '部门id'
);

alter table act_flow_node_dept comment '任务节点关联部门表';

/*==============================================================*/
/* Table: act_task_node_role */
/*==============================================================*/
create table act_flow_node_role
(
 flow_node_id varchar(36) comment '节点类型id',
 role_id varchar(36) comment '角色id'
);

alter table act_flow_node_role comment '任务节点关联角色表';



/*==============================================================*/
/* Table: act_task_node_user */
/*==============================================================*/
create table act_flow_node_user
(
 flow_node_id varchar(36) comment '节点类型id',
 user_id varchar(36) comment '用户id'
);

alter table act_flow_node_user comment '任务节点关联用户表';