report-java/db/flowlong/flowlong-mysql.sql

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- 添加数据库初始化脚本+兼容5.6/5.7版本MYSQL
-- ----------------------------
DROP DATABASE IF  EXISTS  `flowlong`;
CREATE DATABASE IF NOT EXISTS `flowlong` charset utf8mb4 collate utf8mb4_unicode_ci;
USE `flowlong`;

-- ----------------------------
-- Table structure for flw_his_task_actor
-- ----------------------------
DROP TABLE IF EXISTS `flw_his_task_actor`;
CREATE TABLE `flw_his_task_actor`  (
    `id` bigint NOT NULL COMMENT '主键 ID',
    `tenant_id` varchar(50) COMMENT '租户ID',
    `instance_id` bigint NOT NULL COMMENT '流程实例ID',
    `task_id` bigint NOT NULL COMMENT '任务ID',
    `actor_id` varchar(100) NOT NULL COMMENT '参与者ID',
    `actor_name` varchar(100) NOT NULL COMMENT '参与者名称',
    `actor_type` int NOT NULL COMMENT '参与者类型 0，用户 1，角色 2，部门',
    `weight` int COMMENT '票签权重',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `idx_his_task_actor_task_id`(`task_id` ASC) USING BTREE,
    CONSTRAINT `fk_his_task_actor_task_id` FOREIGN KEY (`task_id`) REFERENCES `flw_his_task` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4  COMMENT = '历史任务参与者表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for flw_his_task
-- ----------------------------
DROP TABLE IF EXISTS `flw_his_task`;
CREATE TABLE `flw_his_task`  (
    `id` bigint NOT NULL COMMENT '主键ID',
    `tenant_id` varchar(50) COMMENT '租户ID',
    `create_id` varchar(50) NOT NULL COMMENT '创建人ID',
    `create_by` varchar(50) NOT NULL COMMENT '创建人名称',
    `create_time` timestamp NOT NULL COMMENT '创建时间',
    `instance_id` bigint NOT NULL COMMENT '流程实例ID',
    `parent_task_id` bigint COMMENT '父任务ID',
    `call_process_id` bigint COMMENT '调用外部流程定义ID',
    `call_instance_id` bigint COMMENT '调用外部流程实例ID',
    `task_name` varchar(100)   NOT NULL COMMENT '任务名称',
    `display_name` varchar(200)   NOT NULL COMMENT '任务显示名称',
    `task_type` tinyint(1) NOT NULL COMMENT '任务类型',
    `perform_type` tinyint(1) COMMENT '参与类型',
    `action_url` varchar(200) COMMENT '任务处理的url',
    `variable` text COMMENT '变量json',
    `assignor_id` varchar(100) COMMENT '委托人ID',
    `assignor` varchar(100) COMMENT '委托人',
    `expire_time` timestamp NULL DEFAULT NULL COMMENT '任务期望完成时间',
    `remind_time` timestamp NULL DEFAULT NULL COMMENT '提醒时间',
    `remind_repeat` tinyint(1) NOT NULL DEFAULT 0 COMMENT '提醒次数',
    `viewed` tinyint(1) NOT NULL DEFAULT 0 COMMENT '已阅 0，否 1，是',
    `finish_time` timestamp NULL DEFAULT NULL COMMENT '任务完成时间',
    `task_state` tinyint(1) NOT NULL DEFAULT 1 COMMENT '任务状态 0，活动 1，结束 2，拒绝 3，超时 4，终止  5，跳转',
    `duration` bigint COMMENT '处理耗时',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `idx_his_task_instance_id`(`instance_id` ASC) USING BTREE,
    INDEX `idx_his_task_parent_task_id`(`parent_task_id` ASC) USING BTREE,
    CONSTRAINT `fk_his_task_instance_id` FOREIGN KEY (`instance_id`) REFERENCES `flw_his_instance` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4  COMMENT = '历史任务表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for flw_task_actor
-- ----------------------------
DROP TABLE IF EXISTS `flw_task_actor`;
CREATE TABLE `flw_task_actor`  (
    `id` bigint NOT NULL COMMENT '主键 ID',
    `tenant_id` varchar(50) COMMENT '租户ID',
    `instance_id` bigint NOT NULL COMMENT '流程实例ID',
    `task_id` bigint NOT NULL COMMENT '任务ID',
    `actor_id` varchar(100) NOT NULL COMMENT '参与者ID',
    `actor_name` varchar(100) NOT NULL COMMENT '参与者名称',
    `actor_type` int NOT NULL COMMENT '参与者类型 0，用户 1，角色 2，部门',
    `weight` int COMMENT '票签权重',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `idx_task_actor_task_id`(`task_id` ASC) USING BTREE,
    CONSTRAINT `fk_task_actor_task_id` FOREIGN KEY (`task_id`) REFERENCES `flw_task` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4  COMMENT = '任务参与者表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for flw_task
-- ----------------------------
DROP TABLE IF EXISTS `flw_task`;
CREATE TABLE `flw_task`  (
    `id` bigint NOT NULL COMMENT '主键ID',
    `tenant_id` varchar(50) COMMENT '租户ID',
    `create_id` varchar(50) NOT NULL COMMENT '创建人ID',
    `create_by` varchar(50) NOT NULL COMMENT '创建人名称',
    `create_time` timestamp NOT NULL COMMENT '创建时间',
    `instance_id` bigint NOT NULL COMMENT '流程实例ID',
    `parent_task_id` bigint COMMENT '父任务ID',
    `task_name` varchar(100) NOT NULL COMMENT '任务名称',
    `display_name` varchar(200) NOT NULL COMMENT '任务显示名称',
    `task_type` tinyint(1) NOT NULL COMMENT '任务类型',
    `perform_type` tinyint(1) NULL COMMENT '参与类型',
    `action_url` varchar(200) COMMENT '任务处理的url',
    `variable` text COMMENT '变量json',
    `assignor_id` varchar(100) COMMENT '委托人ID',
    `assignor` varchar(100) COMMENT '委托人',
    `expire_time` timestamp NULL DEFAULT NULL COMMENT '任务期望完成时间',
    `remind_time` timestamp NULL DEFAULT NULL COMMENT '提醒时间',
    `remind_repeat` tinyint(1) NOT NULL DEFAULT 0 COMMENT '提醒次数',
    `viewed` tinyint(1) NOT NULL DEFAULT 0 COMMENT '已阅 0，否 1，是',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `idx_task_instance_id`(`instance_id` ASC) USING BTREE,
    CONSTRAINT `fk_task_instance_id` FOREIGN KEY (`instance_id`) REFERENCES `flw_instance` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4  COMMENT = '任务表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for flw_his_instance
-- ----------------------------
DROP TABLE IF EXISTS `flw_his_instance`;
CREATE TABLE `flw_his_instance`  (
    `id` bigint NOT NULL COMMENT '主键ID',
    `tenant_id` varchar(50) COMMENT '租户ID',
    `create_id` varchar(50) NOT NULL COMMENT '创建人ID',
    `create_by` varchar(50) NOT NULL COMMENT '创建人名称',
    `create_time` timestamp NOT NULL COMMENT '创建时间',
    `process_id` bigint NOT NULL COMMENT '流程定义ID',
    `parent_instance_id` bigint COMMENT '父流程实例ID',
    `priority` tinyint(1) COMMENT '优先级',
    `instance_no` varchar(50) COMMENT '流程实例编号',
    `business_key` varchar(100) COMMENT '业务KEY',
    `variable` text COMMENT '变量json',
    `current_node` varchar(100) NOT NULL COMMENT '当前所在节点',
    `expire_time` timestamp NULL DEFAULT NULL COMMENT '期望完成时间',
    `last_update_by` varchar(50) COMMENT '上次更新人',
    `last_update_time` timestamp NULL DEFAULT NULL COMMENT '上次更新时间',
    `instance_state` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态 0，审批中 1，审批通过 2，审批拒绝 3，撤销审批 4，超时结束 5，强制终止',
    `end_time` timestamp NULL DEFAULT NULL COMMENT '结束时间',
    `duration` bigint COMMENT '处理耗时',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `idx_his_instance_process_id`(`process_id` ASC) USING BTREE,
    CONSTRAINT `fk_his_instance_process_id` FOREIGN KEY (`process_id`) REFERENCES `flw_process` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4  COMMENT = '历史流程实例表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for flw_instance
-- ----------------------------
DROP TABLE IF EXISTS `flw_instance`;
CREATE TABLE `flw_instance`  (
    `id` bigint NOT NULL COMMENT '主键ID',
    `tenant_id` varchar(50) COMMENT '租户ID',
    `create_id` varchar(50) NOT NULL COMMENT '创建人ID',
    `create_by` varchar(50) NOT NULL COMMENT '创建人名称',
    `create_time` timestamp NOT NULL COMMENT '创建时间',
    `process_id` bigint NOT NULL COMMENT '流程定义ID',
    `parent_instance_id` bigint COMMENT '父流程实例ID',
    `priority` tinyint(1) COMMENT '优先级',
    `instance_no` varchar(50) COMMENT '流程实例编号',
    `business_key` varchar(100) COMMENT '业务KEY',
    `variable` text COMMENT '变量json',
    `current_node` varchar(100) NOT NULL COMMENT '当前所在节点',
    `expire_time` timestamp NULL DEFAULT NULL COMMENT '期望完成时间',
    `last_update_by` varchar(50) COMMENT '上次更新人',
    `last_update_time` timestamp NULL DEFAULT NULL COMMENT '上次更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `idx_instance_process_id`(`process_id` ASC) USING BTREE,
    CONSTRAINT `fk_instance_process_id` FOREIGN KEY (`process_id`) REFERENCES `flw_process` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4  COMMENT = '流程实例表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for flw_instance
-- ----------------------------
DROP TABLE IF EXISTS `flw_ext_instance`;
CREATE TABLE `flw_ext_instance`  (
    `id` bigint NOT NULL COMMENT '主键ID',
    `tenant_id` varchar(50) COMMENT '租户ID',
    `process_id` bigint NOT NULL COMMENT '流程定义ID',
    `model_content` text COMMENT '流程模型定义JSON内容',
    PRIMARY KEY (`id`) USING BTREE,
    CONSTRAINT `fk_ext_instance_id` FOREIGN KEY (`id`) REFERENCES `flw_his_instance` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4  COMMENT = '扩展流程实例表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for flw_process
-- ----------------------------
DROP TABLE IF EXISTS `flw_process`;
CREATE TABLE `flw_process`  (
    `id` bigint NOT NULL COMMENT '主键ID',
    `tenant_id` varchar(50) COMMENT '租户ID',
    `create_id` varchar(50) NOT NULL COMMENT '创建人ID',
    `create_by` varchar(50) NOT NULL COMMENT '创建人名称',
    `create_time` timestamp NOT NULL COMMENT '创建时间',
    `process_key` varchar(100) NOT NULL COMMENT '流程定义 key 唯一标识',
    `process_name` varchar(100) NOT NULL COMMENT '流程定义名称',
    `process_icon` varchar(255) DEFAULT NULL COMMENT '流程图标地址',
    `process_type` varchar(100) COMMENT '流程类型',
    `process_version` int NOT NULL DEFAULT 1 COMMENT '流程版本，默认 1',
    `instance_url` varchar(200) COMMENT '实例地址',
    `remark` varchar(255) COMMENT '备注说明',
    `use_scope` tinyint(1) NOT NULL DEFAULT 0 COMMENT '使用范围 0，全员 1，指定人员（业务关联） 2，均不可提交',
    `process_state` tinyint(1) NOT NULL DEFAULT 1 COMMENT '流程状态 0，不可用 1，可用',
    `model_content` text COMMENT '流程模型定义JSON内容',
    `sort` tinyint(1) DEFAULT 0 COMMENT '排序',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `idx_process_name`(`process_name` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4  COMMENT = '流程定义表' ROW_FORMAT = Dynamic;