mirror of
http://git.pig4cloud.com/pig/pigx.git
synced 2026-11-08 04:39:00 +08:00
244 lines
15 KiB
SQL
244 lines
15 KiB
SQL
USE pigxx_flow;
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
CREATE TABLE `bpm_oa_leave` (
|
|
`id` BIGINT NOT NULL COMMENT '主键',
|
|
`process_instance_id` VARCHAR(64) DEFAULT NULL COMMENT '流程实例编号',
|
|
`username` VARCHAR(255) NOT NULL COMMENT '申请人',
|
|
`leave_type` SMALLINT NOT NULL COMMENT '请假类型',
|
|
`leave_reason` VARCHAR(255) DEFAULT NULL COMMENT '请假原因',
|
|
`start_time` DATETIME(6) NOT NULL COMMENT '开始时间',
|
|
`end_time` DATETIME(6) NOT NULL COMMENT '结束时间',
|
|
`leave_day` SMALLINT NOT NULL COMMENT '请假天数',
|
|
`leave_status` SMALLINT DEFAULT NULL COMMENT '请假结果',
|
|
`create_by` VARCHAR(64) DEFAULT '' COMMENT '创建者',
|
|
`create_time` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
|
|
`update_by` VARCHAR(64) DEFAULT '' COMMENT '更新者',
|
|
`update_time` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
|
|
`del_flag` CHAR(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
|
|
`tenant_id` BIGINT NOT NULL DEFAULT 0 COMMENT '租户编号',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='请假申请表';
|
|
|
|
-- ----------------------------
|
|
-- Table structure for process
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `process`;
|
|
CREATE TABLE `process` (
|
|
`id` bigint NOT NULL COMMENT '用户id',
|
|
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志',
|
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
|
`flow_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '表单ID',
|
|
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '表单名称',
|
|
`logo` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '图标配置',
|
|
`settings` json DEFAULT NULL COMMENT '设置项',
|
|
`group_id` bigint NOT NULL COMMENT '分组ID',
|
|
`form_config` json NOT NULL COMMENT '表单设置信息',
|
|
`form_items` json NOT NULL COMMENT '表单设置内容',
|
|
`process` json NOT NULL COMMENT '流程设置内容',
|
|
`remark` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
|
|
`sort` int NOT NULL,
|
|
`is_hidden` char(1) NOT NULL COMMENT '0 正常 1=隐藏',
|
|
`is_stop` char(1) NOT NULL COMMENT '0 正常 1=停用 ',
|
|
`admin_id` bigint DEFAULT NULL COMMENT '流程管理员',
|
|
`unique_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '唯一性id',
|
|
`admin_list` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '管理员',
|
|
`range_show` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '范围描述显示',
|
|
`print_template` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '打印模板',
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '所属租户id',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE KEY `idx_form_id` (`flow_id`) USING BTREE,
|
|
KEY `process_idx_id` (`id`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=182 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='流程定义数据';
|
|
|
|
|
|
-- ----------------------------
|
|
-- Table structure for process_copy
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `process_copy`;
|
|
CREATE TABLE `process_copy` (
|
|
`id` bigint NOT NULL COMMENT '用户id',
|
|
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志',
|
|
`create_time` datetime COMMENT '创建时间',
|
|
`update_time` datetime COMMENT '更新时间',
|
|
`start_time` datetime NOT NULL COMMENT ' 流程发起时间',
|
|
`node_time` datetime NOT NULL COMMENT '当前节点时间',
|
|
`start_user_id` bigint NOT NULL COMMENT '发起人',
|
|
`flow_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程id',
|
|
`process_instance_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '实例id',
|
|
`node_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '节点id',
|
|
`group_id` bigint NOT NULL COMMENT '分组id',
|
|
`group_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分组名称',
|
|
`process_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程名称',
|
|
`node_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '节点 名称',
|
|
`form_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '表单数据',
|
|
`user_id` bigint NOT NULL COMMENT '抄送人id',
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '所属租户id',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
KEY `copy_idx_id` (`id`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='流程抄送数据';
|
|
|
|
|
|
-- ----------------------------
|
|
-- Table structure for process_group
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `process_group`;
|
|
CREATE TABLE `process_group` (
|
|
`id` bigint NOT NULL COMMENT '用户id',
|
|
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志',
|
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
|
`group_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分组名',
|
|
`sort` int NOT NULL DEFAULT '0' COMMENT '排序',
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '所属租户id',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
KEY `group_idx_id` (`id`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='流程分组';
|
|
|
|
|
|
|
|
-- ----------------------------
|
|
-- Table structure for process_instance_record
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `process_instance_record`;
|
|
CREATE TABLE `process_instance_record` (
|
|
`id` bigint NOT NULL COMMENT '用户id',
|
|
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程名字',
|
|
`logo` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '头像',
|
|
`user_id` bigint NOT NULL COMMENT '用户id',
|
|
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志',
|
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|
`update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
`flow_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '流程id',
|
|
`process_instance_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '流程实例id',
|
|
`form_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '表单数据',
|
|
`group_id` bigint DEFAULT NULL COMMENT '组id',
|
|
`group_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组名称',
|
|
`status` int DEFAULT '1' COMMENT '状态',
|
|
`finish_reason` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '结束原因',
|
|
`end_time` datetime DEFAULT NULL COMMENT '结束时间',
|
|
`parent_process_instance_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '上级流程实例id',
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '所属租户id',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
KEY `record_idx_id` (`id`) USING BTREE,
|
|
KEY `record_idx_dep_id` (`user_id`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=366 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='流程记录';
|
|
|
|
|
|
-- ----------------------------
|
|
-- Table structure for process_node_data
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `process_node_data`;
|
|
CREATE TABLE `process_node_data` (
|
|
`id` bigint NOT NULL COMMENT '用户id',
|
|
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志',
|
|
`create_time` datetime COMMENT '创建时间',
|
|
`update_time` datetime COMMENT '更新时间',
|
|
`flow_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程id',
|
|
`data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '表单数据',
|
|
`node_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '所属租户id',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
KEY `data_idx_id` (`id`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1195 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='流程节点数据';
|
|
|
|
|
|
-- ----------------------------
|
|
-- Table structure for process_node_record
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `process_node_record`;
|
|
CREATE TABLE `process_node_record` (
|
|
`id` bigint NOT NULL COMMENT '用户id',
|
|
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志',
|
|
`create_time` datetime COMMENT '创建时间',
|
|
`update_time` datetime COMMENT '更新时间',
|
|
`flow_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程id',
|
|
`process_instance_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程实例id',
|
|
`data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '表单数据',
|
|
`node_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
|
|
`node_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '节点类型',
|
|
`node_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '节点名字',
|
|
`status` int NOT NULL COMMENT '节点状态',
|
|
`start_time` datetime NOT NULL COMMENT '开始时间',
|
|
`end_time` datetime DEFAULT NULL COMMENT '结束时间',
|
|
`execution_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行id',
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '所属租户id',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
KEY `node_idx_id` (`id`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1435 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='流程节点记录';
|
|
|
|
|
|
-- ----------------------------
|
|
-- Table structure for process_node_record_assign_user
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `process_node_record_assign_user`;
|
|
CREATE TABLE `process_node_record_assign_user` (
|
|
`id` bigint NOT NULL COMMENT '用户id',
|
|
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志',
|
|
`create_time` datetime COMMENT '创建时间',
|
|
`update_time` datetime COMMENT '更新时间',
|
|
`flow_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程id',
|
|
`process_instance_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程实例id',
|
|
`data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '表单数据',
|
|
`node_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
|
|
`user_id` bigint NOT NULL COMMENT ' 用户id',
|
|
`status` int NOT NULL COMMENT '节点状态',
|
|
`start_time` datetime NOT NULL COMMENT '开始时间',
|
|
`end_time` datetime DEFAULT NULL COMMENT '结束时间',
|
|
`execution_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行id',
|
|
`task_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT ' 任务id',
|
|
`approve_desc` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '审批意见',
|
|
`node_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT ' 节点名称',
|
|
`task_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务类型',
|
|
`local_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '表单本地数据',
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '所属租户id',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
KEY `user_idx_id` (`id`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=597 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='流程节点记录-执行人';
|
|
|
|
|
|
-- ----------------------------
|
|
-- Table structure for process_starter
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `process_starter`;
|
|
CREATE TABLE `process_starter` (
|
|
`id` bigint NOT NULL COMMENT '用户id',
|
|
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志',
|
|
`create_time` datetime COMMENT '创建时间',
|
|
`update_time` datetime COMMENT '更新时间',
|
|
`type_id` bigint NOT NULL COMMENT '用户id或者部门id',
|
|
`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ' 类型 user dept',
|
|
`process_id` bigint NOT NULL COMMENT '流程id',
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '所属租户id',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
KEY `starter_idx_id` (`id`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=217 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='流程发起人';
|
|
|
|
-- ----------------------------
|
|
-- Table structure for bmp_oa_leave
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `bmp_oa_leave`;
|
|
CREATE TABLE `bmp_oa_leave` (
|
|
`id` bigint NOT NULL COMMENT '请假表单主键',
|
|
`username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '申请人',
|
|
`leave_type` int NOT NULL COMMENT '请假类型',
|
|
`leave_reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '请假原因',
|
|
`start_time` datetime NOT NULL COMMENT '开始时间',
|
|
`end_time` datetime NOT NULL COMMENT '结束时间',
|
|
`leave_day` int NOT NULL COMMENT '请假天数',
|
|
`leave_status` int DEFAULT NULL COMMENT '请假结果',
|
|
`process_instance_id` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '流程实例的编号',
|
|
`create_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
`create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
|
|
`update_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
`update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
|
|
`del_flag` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '是否删除',
|
|
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='请假表单';
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|