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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
| insert into sys_menu values('11616', '工作流' , '0', '6', 'workflow', '', '', '1', '0', 'M', '0', '0', '', 'tree-table', 103, 1, now(), NULL, NULL, '');
| insert into sys_menu values('11617', '模型管理', '11616', '2', 'model', 'workflow/model/index', '', '1', '1', 'C', '0', '0', 'workflow:model:list', 'tree-table', 103, 1, now(), NULL, NULL, '');
| insert into sys_menu values('11618', '我的任务', '0', '7', 'task', '', '', '1', '0', 'M', '0', '0', '', 'tree-table', 103, 1, now(), NULL, NULL, '');
| insert into sys_menu values('11619', '我的待办', '11618', '2', 'taskWaiting', 'workflow/task/taskWaiting', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, now(), NULL, NULL, '');
| insert into sys_menu values('11632', '我的已办', '11618', '3', 'taskFinish', 'workflow/task/taskFinish', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, now(), NULL, NULL, '');
| insert into sys_menu values('11633', '我的抄送', '11618', '4', 'taskCopyList', 'workflow/task/taskCopyList', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, now(), NULL, NULL, '');
| insert into sys_menu values('11620', '流程定义', '11616', '3', 'processDefinition', 'workflow/processDefinition/index', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, now(), NULL, NULL, '');
| insert into sys_menu values('11621', '流程实例', '11630', '1', 'processInstance', 'workflow/processInstance/index', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, now(), NULL, NULL, '');
| insert into sys_menu values('11622', '流程分类', '11616', '1', 'category', 'workflow/category/index', '', '1', '0', 'C', '0', '0', 'workflow:category:list', 'tree-table', 103, 1, now(), NULL, NULL, '');
| insert into sys_menu values('11629', '我发起的', '11618', '1', 'myDocument', 'workflow/task/myDocument', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, now(), NULL, NULL, '');
| insert into sys_menu values('11630', '流程监控', '11616', '4', 'monitor', '', '', '1', '0', 'M', '0', '0', '', 'tree-table', 103, 1, now(), NULL, NULL, '');
| insert into sys_menu values('11631', '待办任务', '11630', '2', 'allTaskWaiting', 'workflow/task/allTaskWaiting', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, now(), NULL, NULL, '');
|
|
| -- 流程分类管理相关按钮
| insert into sys_menu values ('11623', '流程分类查询', '11622', '1', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:query', '#', 103, 1, now(), null, null, '');
| insert into sys_menu values ('11624', '流程分类新增', '11622', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:add', '#', 103, 1, now(), null, null, '');
| insert into sys_menu values ('11625', '流程分类修改', '11622', '3', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:edit', '#', 103, 1, now(), null, null, '');
| insert into sys_menu values ('11626', '流程分类删除', '11622', '4', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:remove','#', 103, 1, now(), null, null, '');
| insert into sys_menu values ('11627', '流程分类导出', '11622', '5', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:export','#', 103, 1, now(), null, null, '');
| -- 请假单信息
| DROP TABLE if EXISTS test_leave;
| create table test_leave
| (
| id bigint not null
| constraint test_leave_pk
| primary key,
| leave_type varchar(255),
| start_date timestamp,
| end_date timestamp,
| leave_days bigint,
| remark varchar(255),
| create_dept bigint,
| create_by bigint,
| create_time timestamp,
| update_by bigint,
| update_time timestamp,
| tenant_id varchar(20)
| );
|
| comment on table test_leave is '请假申请表';
|
| comment on column test_leave.id is '主键';
|
| comment on column test_leave.leave_type is '请假类型';
|
| comment on column test_leave.start_date is '开始时间';
|
| comment on column test_leave.end_date is '结束时间';
|
| comment on column test_leave.remark is '请假原因';
|
| comment on column test_leave.create_dept is '创建部门';
|
| comment on column test_leave.create_by is '创建者';
|
| comment on column test_leave.create_time is '创建时间';
|
| comment on column test_leave.update_by is '更新者';
|
| comment on column test_leave.update_time is '更新时间';
|
| comment on column test_leave.tenant_id is '租户编码';
|
| alter table test_leave
| owner to postgres;
|
| -- 流程分类信息表
| DROP TABLE if EXISTS wf_category;
| create table wf_category
| (
| id bigint not null
| constraint wf_category_pk
| primary key,
| category_name varchar(255),
| category_code varchar(255),
| parent_id bigint,
| sort_num bigint,
| tenant_id varchar(20),
| create_dept bigint,
| create_by bigint,
| create_time timestamp,
| update_by bigint,
| update_time timestamp
| );
|
| comment on table wf_category is '流程分类';
|
| comment on column wf_category.id is '主键';
|
| comment on column wf_category.category_name is '分类名称';
|
| comment on column wf_category.category_code is '分类编码';
|
| comment on column wf_category.parent_id is '父级id';
|
| comment on column wf_category.sort_num is '排序';
|
| comment on column wf_category.tenant_id is '租户id';
|
| comment on column wf_category.create_dept is '创建部门';
|
| comment on column wf_category.create_by is '创建者';
|
| comment on column wf_category.create_time is '创建时间';
|
| comment on column wf_category.update_by is '修改者';
|
| comment on column wf_category.update_time is '修改时间';
|
| alter table wf_category
| owner to postgres;
|
| create unique index uni_category_code
| on wf_category (category_code);
|
| INSERT INTO wf_category values (1, 'OA', 'OA', 0, 0, '000000', 103, 1, now(), 1, now());
|
| create table wf_task_back_node
| (
| id bigint not null
| constraint pk_wf_task_back_node
| primary key,
| node_id varchar(255) not null,
| node_name varchar(255) not null,
| order_no bigint not null,
| instance_id varchar(255) not null,
| task_type varchar(255) not null,
| assignee varchar(2000) not null,
| tenant_id varchar(20),
| create_dept bigint,
| create_by bigint,
| create_time timestamp,
| update_by bigint,
| update_time timestamp
| );
|
| comment on table wf_task_back_node is '节点审批记录';
|
| comment on column wf_task_back_node.id is '主键';
|
| comment on column wf_task_back_node.node_id is '节点id';
|
| comment on column wf_task_back_node.node_name is '节点名称';
|
| comment on column wf_task_back_node.order_no is '排序';
|
| comment on column wf_task_back_node.instance_id is '流程实例id';
|
| comment on column wf_task_back_node.task_type is '节点类型';
|
| comment on column wf_task_back_node.assignee is '审批人';
|
| comment on column wf_task_back_node.tenant_id is '租户id';
|
| comment on column wf_task_back_node.create_dept is '创建部门';
|
| comment on column wf_task_back_node.create_by is '创建者';
|
| comment on column wf_task_back_node.create_time is '创建时间';
|
| comment on column wf_task_back_node.update_by is '修改者';
|
| comment on column wf_task_back_node.update_time is '修改时间';
|
| alter table wf_task_back_node
| owner to postgres;
|
| create table wf_definition_config
| (
| id bigint(20) not null
| constraint pk_wf_definition_config
| primary key,
| form_id bigint(20) not null,
| definition_id varchar(255) not null,
| process_key varchar(255) not null,
| tenant_id varchar(20),
| create_dept bigint,
| create_by bigint,
| create_time timestamp,
| update_by bigint,
| update_time timestamp
| );
|
| comment on table wf_definition_config is '流程定义配置';
|
| comment on column wf_definition_config.id is '主键';
|
| comment on column wf_definition_config.form_id is '表单ID';
|
| comment on column wf_definition_config.definition_id is '流程定义ID';
|
| comment on column wf_definition_config.process_key is '流程KEY';
|
| comment on column wf_definition_config.tenant_id is '租户id';
|
| comment on column wf_definition_config.create_dept is '创建部门';
|
| comment on column wf_definition_config.create_by is '创建者';
|
| comment on column wf_definition_config.create_time is '创建时间';
|
| comment on column wf_definition_config.update_by is '修改者';
|
| comment on column wf_definition_config.update_time is '修改时间';
|
| alter table wf_definition_config
| owner to postgres;
| create unique index uni_definition_id
| on wf_definition_config (definition_id);
|
| INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11638, '请假申请', 5, 1, 'leave', 'workflow/leave/index', 1, 0, 'C', '0', '0', 'demo:leave:list', '#', 103, 1, now(), NULL, NULL, '请假申请菜单');
| INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11639, '请假申请查询', 11638, 1, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:query', '#', 103, 1, now(), NULL, NULL, '');
| INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11640, '请假申请新增', 11638, 2, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:add', '#', 103, 1, now(), NULL, NULL, '');
| INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11641, '请假申请修改', 11638, 3, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:edit', '#', 103, 1, now(), NULL, NULL, '');
| INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11642, '请假申请删除', 11638, 4, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:remove', '#', 103, 1, now(), NULL, NULL, '');
| INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11643, '请假申请导出', 11638, 5, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:export', '#', 103, 1, now(), NULL, NULL, '');
|
|
