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
| insert into sys_menu values('11616', '工作流' , '0', '6', 'workflow', '', '', '1', '0', 'M', '0', '0', '', 'tree-table', 103, 1, sysdate, 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, sysdate, NULL, NULL, '');
| insert into sys_menu values('11618', '我的任务', '0', '7', 'task', '', '', '1', '0', 'M', '0', '0', '', 'tree-table', 103, 1, sysdate, NULL, NULL, '');
| insert into sys_menu values('11619', '我的待办', '11618', '2', 'taskWaiting', 'workflow/task/taskWaiting', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, sysdate, NULL, NULL, '');
| insert into sys_menu values('11632', '我的已办', '11618', '3', 'taskFinish', 'workflow/task/taskFinish', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, sysdate, NULL, NULL, '');
| insert into sys_menu values('11633', '我的抄送', '11618', '4', 'taskCopyList', 'workflow/task/taskCopyList', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, sysdate, NULL, NULL, '');
| insert into sys_menu values('11620', '流程定义', '11616', '3', 'processDefinition', 'workflow/processDefinition/index', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, sysdate, NULL, NULL, '');
| insert into sys_menu values('11621', '流程实例', '11630', '1', 'processInstance', 'workflow/processInstance/index', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, sysdate, 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, sysdate, NULL, NULL, '');
| insert into sys_menu values('11629', '我发起的', '11618', '1', 'myDocument', 'workflow/task/myDocument', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, sysdate, NULL, NULL, '');
| insert into sys_menu values('11630', '流程监控', '11616', '4', 'monitor', '', '', '1', '0', 'M', '0', '0', '', 'tree-table', 103, 1, sysdate, NULL, NULL, '');
| insert into sys_menu values('11631', '待办任务', '11630', '2', 'allTaskWaiting', 'workflow/task/allTaskWaiting', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, sysdate, NULL, NULL, '');
|
|
| -- 流程分类管理相关按钮
| insert into sys_menu values ('11623', '流程分类查询', '11622', '1', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:query', '#', 103, 1, sysdate, null, null, '');
| insert into sys_menu values ('11624', '流程分类新增', '11622', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:add', '#', 103, 1, sysdate, null, null, '');
| insert into sys_menu values ('11625', '流程分类修改', '11622', '3', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:edit', '#', 103, 1, sysdate, null, null, '');
| insert into sys_menu values ('11626', '流程分类删除', '11622', '4', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:remove','#', 103, 1, sysdate, null, null, '');
| insert into sys_menu values ('11627', '流程分类导出', '11622', '5', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:export','#', 103, 1, sysdate, null, null, '');
|
| -- 请假单信息
| create table TEST_LEAVE
| (
| ID NUMBER(20) not null
| constraint PK_TEST_LEAVE
| primary key,
| LEAVE_TYPE VARCHAR2(255),
| START_DATE DATE,
| END_DATE DATE,
| LEAVE_DAYS NUMBER(10),
| REMARK VARCHAR2(255),
| CREATE_DEPT NUMBER(20),
| CREATE_BY NUMBER(20),
| CREATE_TIME DATE,
| UPDATE_BY NUMBER(20),
| UPDATE_TIME DATE,
| TENANT_ID VARCHAR2(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.LEAVE_DAYS 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 '租户编号'
|
| -- 流程分类信息表
| create table WF_CATEGORY
| (
| ID NUMBER(20) not null
| constraint PK_WF_CATEGORY
| primary key,
| CATEGORY_NAME VARCHAR2(255),
| CATEGORY_CODE VARCHAR2(255)
| constraint UNI_CATEGORY_CODE
| unique,
| PARENT_ID NUMBER(20),
| SORT_NUM NUMBER(10),
| TENANT_ID VARCHAR2(20),
| CREATE_DEPT NUMBER(20),
| CREATE_BY NUMBER(20),
| CREATE_TIME DATE,
| UPDATE_BY NUMBER(20),
| UPDATE_TIME DATE
| );
|
| 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 '租户编号'
| 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 '更新时间'
| INSERT INTO wf_category values (1, 'OA', 'OA', 0, 0, '000000', 103, 1, sysdate, 1, sysdate);
|
| create table WF_TASK_BACK_NODE
| (
| ID NUMBER(20) not null
| constraint PK_WF_TASK_BACK_NODE
| primary key,
| NODE_ID VARCHAR2(255) not null,
| NODE_NAME VARCHAR2(255) not null,
| ORDER_NO NUMBER(20) not null,
| INSTANCE_ID VARCHAR2(255) not null,
| TASK_TYPE VARCHAR2(255) not null,
| ASSIGNEE VARCHAR2(2000) not null,
| TENANT_ID VARCHAR2(20),
| CREATE_DEPT NUMBER(20),
| CREATE_BY NUMBER(20),
| CREATE_TIME DATE,
| UPDATE_BY NUMBER(20),
| UPDATE_TIME DATE
| );
| 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.SORT_NUM 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 '租户编号'
| 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 '更新时间'
|
| create table WF_FORM_DEFINITION
| (
| ID NUMBER(20) NOT NULL
| CONSTRAINT PK_WF_FORM_DEFINITION
| PRIMARY KEY,
| PATH VARCHAR2(200) NOT NULL,
| DEFINITION_ID VARCHAR2(255) NOT NULL,
| PROCESS_KEY VARCHAR2(255) NOT NULL,
| TENANT_ID VARCHAR2(20),
| CREATE_DEPT NUMBER(20),
| CREATE_BY NUMBER(20),
| CREATE_TIME DATE,
| UPDATE_BY NUMBER(20),
| UPDATE_TIME DATE,
| constraint uni_definition_id
| unique (definition_id)
| );
| comment on table WF_FORM_DEFINITION is '表单配置'
| comment on column WF_FORM_DEFINITION.ID is '主键'
| comment on column WF_FORM_DEFINITION.DEFINITION_ID is '流程定义ID'
| comment on column WF_FORM_DEFINITION.PROCESS_KEY is '流程KEY'
| comment on column WF_FORM_DEFINITION.TENANT_ID is '租户编号'
| comment on column WF_FORM_DEFINITION.CREATE_DEPT is '创建部门'
| comment on column WF_FORM_DEFINITION.CREATE_BY is '创建者'
| comment on column WF_FORM_DEFINITION.CREATE_TIME is '创建时间'
| comment on column WF_FORM_DEFINITION.UPDATE_BY is '更新者'
| comment on column WF_FORM_DEFINITION.UPDATE_TIME is '更新时间'
|
| 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, sysdate, 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, sysdate, 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, sysdate, 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, sysdate, 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, sysdate, 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, sysdate, NULL, NULL, '');
|
|
