SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for act_evt_log -- ---------------------------- DROP TABLE IF EXISTS `act_evt_log`; CREATE TABLE `act_evt_log` ( `LOG_NR_` bigint NOT NULL AUTO_INCREMENT, `TYPE_` varchar(64) NULL DEFAULT NULL, `PROC_DEF_ID_` varchar(64) NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) NULL DEFAULT NULL, `TASK_ID_` varchar(64) NULL DEFAULT NULL, `TIME_STAMP_` timestamp NOT NULL, `USER_ID_` varchar(255) NULL DEFAULT NULL, `DATA_` longblob NULL, `LOCK_OWNER_` varchar(255) NULL DEFAULT NULL, `LOCK_TIME_` timestamp NULL DEFAULT NULL, `IS_PROCESSED_` tinyint NULL DEFAULT 0, PRIMARY KEY (`LOG_NR_`) USING BTREE ); -- ---------------------------- -- Records of act_evt_log -- ---------------------------- -- ---------------------------- -- Table structure for act_ge_bytearray -- ---------------------------- DROP TABLE IF EXISTS `act_ge_bytearray`; CREATE TABLE `act_ge_bytearray` ( `ID_` varchar(64) NOT NULL, `REV_` int NULL DEFAULT NULL, `NAME_` varchar(255) NULL DEFAULT NULL, `DEPLOYMENT_ID_` varchar(64) NULL DEFAULT NULL, `BYTES_` longblob NULL, `GENERATED_` tinyint NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_FK_BYTEARR_DEPL`(`DEPLOYMENT_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ); -- ---------------------------- -- Records of act_ge_bytearray -- ---------------------------- -- ---------------------------- -- Table structure for act_ge_property -- ---------------------------- DROP TABLE IF EXISTS `act_ge_property`; CREATE TABLE `act_ge_property` ( `NAME_` varchar(64) NOT NULL, `VALUE_` varchar(300) NULL DEFAULT NULL, `REV_` int NULL DEFAULT NULL, PRIMARY KEY (`NAME_`) USING BTREE ); -- ---------------------------- -- Records of act_ge_property -- ---------------------------- INSERT INTO `act_ge_property` VALUES ('next.dbid', '1', 1); INSERT INTO `act_ge_property` VALUES ('schema.history', 'create(5.22.0.0)', 1); INSERT INTO `act_ge_property` VALUES ('schema.version', '5.22.0.0', 1); -- ---------------------------- -- Table structure for act_hi_actinst -- ---------------------------- DROP TABLE IF EXISTS `act_hi_actinst`; CREATE TABLE `act_hi_actinst` ( `ID_` varchar(64) NOT NULL, `PROC_DEF_ID_` varchar(64) NOT NULL, `PROC_INST_ID_` varchar(64) NOT NULL, `EXECUTION_ID_` varchar(64) NOT NULL, `ACT_ID_` varchar(255) NOT NULL, `TASK_ID_` varchar(64) NULL DEFAULT NULL, `CALL_PROC_INST_ID_` varchar(64) NULL DEFAULT NULL, `ACT_NAME_` varchar(255) NULL DEFAULT NULL, `ACT_TYPE_` varchar(255) NOT NULL, `ASSIGNEE_` varchar(255) NULL DEFAULT NULL, `START_TIME_` datetime NOT NULL, `END_TIME_` datetime NULL DEFAULT NULL, `DURATION_` bigint NULL DEFAULT NULL, `TENANT_ID_` varchar(255) NULL DEFAULT '', PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_HI_ACT_INST_START`(`START_TIME_` ASC) USING BTREE, INDEX `ACT_IDX_HI_ACT_INST_END`(`END_TIME_` ASC) USING BTREE, INDEX `ACT_IDX_HI_ACT_INST_PROCINST`(`PROC_INST_ID_` ASC, `ACT_ID_` ASC) USING BTREE, INDEX `ACT_IDX_HI_ACT_INST_EXEC`(`EXECUTION_ID_` ASC, `ACT_ID_` ASC) USING BTREE ); -- ---------------------------- -- Records of act_hi_actinst -- ---------------------------- -- ---------------------------- -- Table structure for act_hi_attachment -- ---------------------------- DROP TABLE IF EXISTS `act_hi_attachment`; CREATE TABLE `act_hi_attachment` ( `ID_` varchar(64) NOT NULL, `REV_` int NULL DEFAULT NULL, `USER_ID_` varchar(255) NULL DEFAULT NULL, `NAME_` varchar(255) NULL DEFAULT NULL, `DESCRIPTION_` varchar(4000) NULL DEFAULT NULL, `TYPE_` varchar(255) NULL DEFAULT NULL, `TASK_ID_` varchar(64) NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL, `URL_` varchar(4000) NULL DEFAULT NULL, `CONTENT_ID_` varchar(64) NULL DEFAULT NULL, `TIME_` datetime NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ); -- ---------------------------- -- Records of act_hi_attachment -- ---------------------------- -- ---------------------------- -- Table structure for act_hi_comment -- ---------------------------- DROP TABLE IF EXISTS `act_hi_comment`; CREATE TABLE `act_hi_comment` ( `ID_` varchar(64) NOT NULL, `TYPE_` varchar(255) NULL DEFAULT NULL, `TIME_` datetime NOT NULL, `USER_ID_` varchar(255) NULL DEFAULT NULL, `TASK_ID_` varchar(64) NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL, `ACTION_` varchar(255) NULL DEFAULT NULL, `MESSAGE_` varchar(4000) NULL DEFAULT NULL, `FULL_MSG_` longblob NULL, PRIMARY KEY (`ID_`) USING BTREE ); -- ---------------------------- -- Records of act_hi_comment -- ---------------------------- -- ---------------------------- -- Table structure for act_hi_detail -- ---------------------------- DROP TABLE IF EXISTS `act_hi_detail`; CREATE TABLE `act_hi_detail` ( `ID_` varchar(64) NOT NULL, `TYPE_` varchar(255) NOT NULL, `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) NULL DEFAULT NULL, `TASK_ID_` varchar(64) NULL DEFAULT NULL, `ACT_INST_ID_` varchar(64) NULL DEFAULT NULL, `NAME_` varchar(255) NOT NULL, `VAR_TYPE_` varchar(255) NULL DEFAULT NULL, `REV_` int NULL DEFAULT NULL, `TIME_` datetime NOT NULL, `BYTEARRAY_ID_` varchar(64) NULL DEFAULT NULL, `DOUBLE_` double NULL DEFAULT NULL, `LONG_` bigint NULL DEFAULT NULL, `TEXT_` varchar(4000) NULL DEFAULT NULL, `TEXT2_` varchar(4000) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_HI_DETAIL_PROC_INST`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `ACT_IDX_HI_DETAIL_ACT_INST`(`ACT_INST_ID_` ASC) USING BTREE, INDEX `ACT_IDX_HI_DETAIL_TIME`(`TIME_` ASC) USING BTREE, INDEX `ACT_IDX_HI_DETAIL_NAME`(`NAME_` ASC) USING BTREE, INDEX `ACT_IDX_HI_DETAIL_TASK_ID`(`TASK_ID_` ASC) USING BTREE ); -- ---------------------------- -- Records of act_hi_detail -- ---------------------------- -- ---------------------------- -- Table structure for act_hi_identitylink -- ---------------------------- DROP TABLE IF EXISTS `act_hi_identitylink`; CREATE TABLE `act_hi_identitylink` ( `ID_` varchar(64) NOT NULL, `GROUP_ID_` varchar(255) NULL DEFAULT NULL, `TYPE_` varchar(255) NULL DEFAULT NULL, `USER_ID_` varchar(255) NULL DEFAULT NULL, `TASK_ID_` varchar(64) NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_HI_IDENT_LNK_USER`(`USER_ID_` ASC) USING BTREE, INDEX `ACT_IDX_HI_IDENT_LNK_TASK`(`TASK_ID_` ASC) USING BTREE, INDEX `ACT_IDX_HI_IDENT_LNK_PROCINST`(`PROC_INST_ID_` ASC) USING BTREE ); -- ---------------------------- -- Records of act_hi_identitylink -- ---------------------------- -- ---------------------------- -- Table structure for act_hi_procinst -- ---------------------------- DROP TABLE IF EXISTS `act_hi_procinst`; CREATE TABLE `act_hi_procinst` ( `ID_` varchar(64) NOT NULL, `PROC_INST_ID_` varchar(64) NOT NULL, `BUSINESS_KEY_` varchar(255) NULL DEFAULT NULL, `PROC_DEF_ID_` varchar(64) NOT NULL, `START_TIME_` datetime NOT NULL, `END_TIME_` datetime NULL DEFAULT NULL, `DURATION_` bigint NULL DEFAULT NULL, `START_USER_ID_` varchar(255) NULL DEFAULT NULL, `START_ACT_ID_` varchar(255) NULL DEFAULT NULL, `END_ACT_ID_` varchar(255) NULL DEFAULT NULL, `SUPER_PROCESS_INSTANCE_ID_` varchar(64) NULL DEFAULT NULL, `DELETE_REASON_` varchar(4000) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) NULL DEFAULT '', `NAME_` varchar(255) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, UNIQUE INDEX `PROC_INST_ID_`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `ACT_IDX_HI_PRO_INST_END`(`END_TIME_` ASC) USING BTREE, INDEX `ACT_IDX_HI_PRO_I_BUSKEY`(`BUSINESS_KEY_` ASC) USING BTREE ); -- ---------------------------- -- Records of act_hi_procinst -- ---------------------------- -- ---------------------------- -- Table structure for act_hi_taskinst -- ---------------------------- DROP TABLE IF EXISTS `act_hi_taskinst`; CREATE TABLE `act_hi_taskinst` ( `ID_` varchar(64) NOT NULL, `PROC_DEF_ID_` varchar(64) NULL DEFAULT NULL, `TASK_DEF_KEY_` varchar(255) NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) NULL DEFAULT NULL, `NAME_` varchar(255) NULL DEFAULT NULL, `PARENT_TASK_ID_` varchar(64) NULL DEFAULT NULL, `DESCRIPTION_` varchar(4000) NULL DEFAULT NULL, `OWNER_` varchar(255) NULL DEFAULT NULL, `ASSIGNEE_` varchar(255) NULL DEFAULT NULL, `START_TIME_` datetime NOT NULL, `CLAIM_TIME_` datetime NULL DEFAULT NULL, `END_TIME_` datetime NULL DEFAULT NULL, `DURATION_` bigint NULL DEFAULT NULL, `DELETE_REASON_` varchar(4000) NULL DEFAULT NULL, `PRIORITY_` int NULL DEFAULT NULL, `DUE_DATE_` datetime NULL DEFAULT NULL, `FORM_KEY_` varchar(255) NULL DEFAULT NULL, `CATEGORY_` varchar(255) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) NULL DEFAULT '', PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_HI_TASK_INST_PROCINST`(`PROC_INST_ID_` ASC) USING BTREE ); -- ---------------------------- -- Records of act_hi_taskinst -- ---------------------------- -- ---------------------------- -- Table structure for act_hi_varinst -- ---------------------------- DROP TABLE IF EXISTS `act_hi_varinst`; CREATE TABLE `act_hi_varinst` ( `ID_` varchar(64) NOT NULL, `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) NULL DEFAULT NULL, `TASK_ID_` varchar(64) NULL DEFAULT NULL, `NAME_` varchar(255) NOT NULL, `VAR_TYPE_` varchar(100) NULL DEFAULT NULL, `REV_` int NULL DEFAULT NULL, `BYTEARRAY_ID_` varchar(64) NULL DEFAULT NULL, `DOUBLE_` double NULL DEFAULT NULL, `LONG_` bigint NULL DEFAULT NULL, `TEXT_` varchar(4000) NULL DEFAULT NULL, `TEXT2_` varchar(4000) NULL DEFAULT NULL, `CREATE_TIME_` datetime NULL DEFAULT NULL, `LAST_UPDATED_TIME_` datetime NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_HI_PROCVAR_PROC_INST`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `ACT_IDX_HI_PROCVAR_NAME_TYPE`(`NAME_` ASC, `VAR_TYPE_` ASC) USING BTREE, INDEX `ACT_IDX_HI_PROCVAR_TASK_ID`(`TASK_ID_` ASC) USING BTREE ); -- ---------------------------- -- Records of act_hi_varinst -- ---------------------------- -- ---------------------------- -- Table structure for act_procdef_info -- ---------------------------- DROP TABLE IF EXISTS `act_procdef_info`; CREATE TABLE `act_procdef_info` ( `ID_` varchar(64) NOT NULL, `PROC_DEF_ID_` varchar(64) NOT NULL, `REV_` int NULL DEFAULT NULL, `INFO_JSON_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, UNIQUE INDEX `ACT_UNIQ_INFO_PROCDEF`(`PROC_DEF_ID_` ASC) USING BTREE, INDEX `ACT_IDX_INFO_PROCDEF`(`PROC_DEF_ID_` ASC) USING BTREE, INDEX `ACT_FK_INFO_JSON_BA`(`INFO_JSON_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ); -- ---------------------------- -- Records of act_procdef_info -- ---------------------------- -- ---------------------------- -- Table structure for act_re_deployment -- ---------------------------- DROP TABLE IF EXISTS `act_re_deployment`; CREATE TABLE `act_re_deployment` ( `ID_` varchar(64) NOT NULL, `NAME_` varchar(255) NULL DEFAULT NULL, `CATEGORY_` varchar(255) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) NULL DEFAULT '', `DEPLOY_TIME_` timestamp NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ); -- ---------------------------- -- Records of act_re_deployment -- ---------------------------- INSERT INTO `act_re_deployment` VALUES ('1587652788286963712', '入职流程', NULL, '-1', '2022-11-02 11:48:17'); INSERT INTO `act_re_deployment` VALUES ('1587760028532654080', '入职登记', NULL, '-1', '2022-11-02 18:54:25'); INSERT INTO `act_re_deployment` VALUES ('1587760525868056576', '表单测试', NULL, '-1', '2022-11-02 18:56:23'); INSERT INTO `act_re_deployment` VALUES ('1588450132737671168', '请假申请', NULL, '-1', '2022-11-04 16:36:38'); INSERT INTO `act_re_deployment` VALUES ('1588450213113118720', '新员工培训', NULL, '-1', '2022-11-04 16:36:57'); -- ---------------------------- -- Table structure for act_re_model -- ---------------------------- DROP TABLE IF EXISTS `act_re_model`; CREATE TABLE `act_re_model` ( `ID_` varchar(64) NOT NULL, `REV_` int NULL DEFAULT NULL, `NAME_` varchar(255) NULL DEFAULT NULL, `KEY_` varchar(255) NULL DEFAULT NULL, `CATEGORY_` varchar(255) NULL DEFAULT NULL, `CREATE_TIME_` timestamp NULL DEFAULT NULL, `LAST_UPDATE_TIME_` timestamp NULL DEFAULT NULL, `VERSION_` int NULL DEFAULT NULL, `META_INFO_` varchar(4000) NULL DEFAULT NULL, `DEPLOYMENT_ID_` varchar(64) NULL DEFAULT NULL, `EDITOR_SOURCE_VALUE_ID_` varchar(64) NULL DEFAULT NULL, `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) NULL DEFAULT '', PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_FK_MODEL_SOURCE`(`EDITOR_SOURCE_VALUE_ID_` ASC) USING BTREE, INDEX `ACT_FK_MODEL_SOURCE_EXTRA`(`EDITOR_SOURCE_EXTRA_VALUE_ID_` ASC) USING BTREE, INDEX `ACT_FK_MODEL_DEPLOYMENT`(`DEPLOYMENT_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ); -- ---------------------------- -- Records of act_re_model -- ---------------------------- -- ---------------------------- -- Table structure for act_re_procdef -- ---------------------------- DROP TABLE IF EXISTS `act_re_procdef`; CREATE TABLE `act_re_procdef` ( `ID_` varchar(64) NOT NULL, `REV_` int NULL DEFAULT NULL, `CATEGORY_` varchar(255) NULL DEFAULT NULL, `NAME_` varchar(255) NULL DEFAULT NULL, `KEY_` varchar(255) NOT NULL, `VERSION_` int NOT NULL, `DEPLOYMENT_ID_` varchar(64) NULL DEFAULT NULL, `RESOURCE_NAME_` varchar(4000) NULL DEFAULT NULL, `DGRM_RESOURCE_NAME_` varchar(4000) NULL DEFAULT NULL, `DESCRIPTION_` varchar(4000) NULL DEFAULT NULL, `HAS_START_FORM_KEY_` tinyint NULL DEFAULT NULL, `HAS_GRAPHICAL_NOTATION_` tinyint NULL DEFAULT NULL, `SUSPENSION_STATE_` int NULL DEFAULT NULL, `TENANT_ID_` varchar(255) NULL DEFAULT '', PRIMARY KEY (`ID_`) USING BTREE, UNIQUE INDEX `ACT_UNIQ_PROCDEF`(`KEY_` ASC, `VERSION_` ASC, `TENANT_ID_` ASC) USING BTREE ); -- ---------------------------- -- Records of act_re_procdef -- ---------------------------- -- ---------------------------- -- Table structure for act_ru_event_subscr -- ---------------------------- DROP TABLE IF EXISTS `act_ru_event_subscr`; CREATE TABLE `act_ru_event_subscr` ( `ID_` varchar(64) NOT NULL, `REV_` int NULL DEFAULT NULL, `EVENT_TYPE_` varchar(255) NOT NULL, `EVENT_NAME_` varchar(255) NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL, `ACTIVITY_ID_` varchar(64) NULL DEFAULT NULL, `CONFIGURATION_` varchar(255) NULL DEFAULT NULL, `CREATED_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `PROC_DEF_ID_` varchar(64) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) NULL DEFAULT '', PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_EVENT_SUBSCR_CONFIG_`(`CONFIGURATION_` ASC) USING BTREE, INDEX `ACT_FK_EVENT_EXEC`(`EXECUTION_ID_` ASC) USING BTREE, INDEX `ACT_IDX_EVENT_PROCINSTID`(`PROC_INST_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ); -- ---------------------------- -- Records of act_ru_event_subscr -- ---------------------------- -- ---------------------------- -- Table structure for act_ru_execution -- ---------------------------- DROP TABLE IF EXISTS `act_ru_execution`; CREATE TABLE `act_ru_execution` ( `ID_` varchar(64) NOT NULL, `REV_` int NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL, `BUSINESS_KEY_` varchar(255) NULL DEFAULT NULL, `PARENT_ID_` varchar(64) NULL DEFAULT NULL, `PROC_DEF_ID_` varchar(64) NULL DEFAULT NULL, `SUPER_EXEC_` varchar(64) NULL DEFAULT NULL, `ACT_ID_` varchar(255) NULL DEFAULT NULL, `IS_ACTIVE_` tinyint NULL DEFAULT NULL, `IS_CONCURRENT_` tinyint NULL DEFAULT NULL, `IS_SCOPE_` tinyint NULL DEFAULT NULL, `IS_EVENT_SCOPE_` tinyint NULL DEFAULT NULL, `SUSPENSION_STATE_` int NULL DEFAULT NULL, `CACHED_ENT_STATE_` int NULL DEFAULT NULL, `TENANT_ID_` varchar(255) NULL DEFAULT '', `NAME_` varchar(255) NULL DEFAULT NULL, `LOCK_TIME_` timestamp NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_FK_EXE_PROCDEF`(`PROC_DEF_ID_` ASC) USING BTREE, INDEX `ACT_IDX_RUEXECUTION_PROCINSTID`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `ACR_IDX_RUEXECUTION_PARENTID`(`PARENT_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ); -- ---------------------------- -- Records of act_ru_execution -- ---------------------------- -- ---------------------------- -- Table structure for act_ru_identitylink -- ---------------------------- DROP TABLE IF EXISTS `act_ru_identitylink`; CREATE TABLE `act_ru_identitylink` ( `ID_` varchar(64) NOT NULL, `REV_` int NULL DEFAULT NULL, `GROUP_ID_` varchar(255) NULL DEFAULT NULL, `TYPE_` varchar(255) NULL DEFAULT NULL, `USER_ID_` varchar(255) NULL DEFAULT NULL, `TASK_ID_` varchar(64) NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL, `PROC_DEF_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_IDENT_LNK_TASK_ID`(`TASK_ID_` ASC) USING BTREE ); -- ---------------------------- -- Records of act_ru_identitylink -- ---------------------------- -- ---------------------------- -- Table structure for act_ru_job -- ---------------------------- DROP TABLE IF EXISTS `act_ru_job`; CREATE TABLE `act_ru_job` ( `ID_` varchar(64) NOT NULL, `REV_` int NULL DEFAULT NULL, `TYPE_` varchar(255) NOT NULL, `LOCK_EXP_TIME_` timestamp NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) NULL DEFAULT NULL, `EXCLUSIVE_` tinyint(1) NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) NULL DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) NULL DEFAULT NULL, `PROC_DEF_ID_` varchar(64) NULL DEFAULT NULL, `RETRIES_` int NULL DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) NULL DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) NULL DEFAULT NULL, `DUEDATE_` timestamp NULL DEFAULT NULL, `REPEAT_` varchar(255) NULL DEFAULT NULL, `HANDLER_TYPE_` varchar(255) NULL DEFAULT NULL, `HANDLER_CFG_` varchar(4000) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) NULL DEFAULT '', PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_FK_JOB_EXCEPTION`(`EXCEPTION_STACK_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ); -- ---------------------------- -- Records of act_ru_job -- ---------------------------- -- ---------------------------- -- Table structure for act_ru_task -- ---------------------------- DROP TABLE IF EXISTS `act_ru_task`; CREATE TABLE `act_ru_task` ( `ID_` varchar(64) NOT NULL, `REV_` int NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL, `PROC_DEF_ID_` varchar(64) NULL DEFAULT NULL, `NAME_` varchar(255) NULL DEFAULT NULL, `PARENT_TASK_ID_` varchar(64) NULL DEFAULT NULL, `DESCRIPTION_` varchar(4000) NULL DEFAULT NULL, `TASK_DEF_KEY_` varchar(255) NULL DEFAULT NULL, `OWNER_` varchar(255) NULL DEFAULT NULL, `ASSIGNEE_` varchar(255) NULL DEFAULT NULL, `DELEGATION_` varchar(64) NULL DEFAULT NULL, `PRIORITY_` int NULL DEFAULT NULL, `CREATE_TIME_` timestamp NULL DEFAULT NULL, `DUE_DATE_` datetime NULL DEFAULT NULL, `CATEGORY_` varchar(255) NULL DEFAULT NULL, `SUSPENSION_STATE_` int NULL DEFAULT NULL, `TENANT_ID_` varchar(255) NULL DEFAULT '', `FORM_KEY_` varchar(255) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_TASK_CREATE`(`CREATE_TIME_` ASC) USING BTREE, INDEX `ACT_IDX_TASK_PARENTID`(`PARENT_TASK_ID_` ASC) USING BTREE, INDEX `ACT_FK_TASK_EXE`(`EXECUTION_ID_` ASC) USING BTREE, INDEX `ACT_IDX_RUTASK_PROCINSTID`(`PROC_INST_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE RESTRICT ); -- ---------------------------- -- Records of act_ru_task -- ---------------------------- -- ---------------------------- -- Table structure for act_ru_variable -- ---------------------------- DROP TABLE IF EXISTS `act_ru_variable`; CREATE TABLE `act_ru_variable` ( `ID_` varchar(64) NOT NULL, `REV_` int NULL DEFAULT NULL, `TYPE_` varchar(255) NOT NULL, `NAME_` varchar(255) NOT NULL, `EXECUTION_ID_` varchar(64) NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL, `TASK_ID_` varchar(64) NULL DEFAULT NULL, `BYTEARRAY_ID_` varchar(64) NULL DEFAULT NULL, `DOUBLE_` double NULL DEFAULT NULL, `LONG_` bigint NULL DEFAULT NULL, `TEXT_` varchar(4000) NULL DEFAULT NULL, `TEXT2_` varchar(4000) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_VARIABLE_TASK_ID`(`TASK_ID_` ASC) USING BTREE, INDEX `ACT_FK_VAR_EXE`(`EXECUTION_ID_` ASC) USING BTREE, INDEX `ACT_FK_VAR_PROCINST`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `ACT_FK_VAR_BYTEARRAY`(`BYTEARRAY_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE RESTRICT ); -- ---------------------------- -- Records of act_ru_variable -- ---------------------------- -- ---------------------------- -- Table structure for bpm_agent_condition -- ---------------------------- DROP TABLE IF EXISTS `bpm_agent_condition`; CREATE TABLE `bpm_agent_condition` ( `ID_` varchar(64) NOT NULL, `SETTING_ID_` varchar(64) NULL DEFAULT NULL COMMENT '设定ID', `CONDITION_DESC_` varchar(128) NULL DEFAULT NULL COMMENT '条件描述', `CONDITION_` varchar(4000) NULL DEFAULT NULL COMMENT '条件', `AGENT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '代理人ID', `AGENT_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '代理人', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_AGENT_SETTINGID`(`SETTING_ID_` ASC) USING BTREE )COMMENT = '流程代理条件'; -- ---------------------------- -- Records of bpm_agent_condition -- ---------------------------- -- ---------------------------- -- Table structure for bpm_agent_def -- ---------------------------- DROP TABLE IF EXISTS `bpm_agent_def`; CREATE TABLE `bpm_agent_def` ( `ID_` varchar(64) NOT NULL, `SETTING_ID_` varchar(64) NOT NULL COMMENT '设定ID', `FLOW_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '流程定义KEY', `FLOW_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '流程定义名称', `NODE_ID_` varchar(512) NULL DEFAULT NULL COMMENT '节点定义ID(为空的情况,如果指定ID,那么代理只在这些ID的任务生效)', `NODE_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '节点名称', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_AGENTDEF_FLOWKEY`(`FLOW_KEY_` ASC) USING BTREE )COMMENT = '代理指定流程'; -- ---------------------------- -- Records of bpm_agent_def -- ---------------------------- -- ---------------------------- -- Table structure for bpm_agent_setting -- ---------------------------- DROP TABLE IF EXISTS `bpm_agent_setting`; CREATE TABLE `bpm_agent_setting` ( `ID_` varchar(64) NOT NULL, `SUBJECT_` varchar(150) NULL DEFAULT NULL, `AUTH_ID_` varchar(64) NOT NULL COMMENT '授权人ID', `AUTH_NAME_` varchar(64) NOT NULL COMMENT '授权人姓名', `START_DATE_` datetime NULL DEFAULT NULL, `END_DATE_` datetime NULL DEFAULT NULL, `IS_ENABLED_` char(1) NOT NULL COMMENT '是否有效', `AGENT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '代理人ID', `AGENT_` varchar(128) NULL DEFAULT NULL COMMENT '代理人', `FLOW_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '流程定义KEY', `TYPE_` smallint NULL DEFAULT NULL COMMENT '代理类型(1,全权代理,2,部分代理,3.条件代理)', `CREATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '创建人ID', `CREATE_TIME_` datetime NULL DEFAULT NULL, `CREATE_ORG_ID_` varchar(64) NULL DEFAULT NULL COMMENT '创建者所属组织ID', `UPDATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '更新人ID', `UPDATE_TIME_` datetime NULL DEFAULT NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '租户id', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_AGENTSETTING_AUTHID`(`AUTH_ID_` ASC) USING BTREE, INDEX `IDX_AGENTSETTING_TYPE`(`TYPE_` ASC) USING BTREE, INDEX `IDX_AGENTSETTING_ISENABLED`(`IS_ENABLED_` ASC) USING BTREE, INDEX `IDX_AGENTSETTING_FLOWKEY`(`FLOW_KEY_` ASC) USING BTREE )COMMENT = '流程代理设置'; -- ---------------------------- -- Records of bpm_agent_setting -- ---------------------------- -- ---------------------------- -- Table structure for bpm_approval_item -- ---------------------------- DROP TABLE IF EXISTS `bpm_approval_item`; CREATE TABLE `bpm_approval_item` ( `ID_` varchar(64) NOT NULL, `USER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '用户ID', `DEF_KEY_` varchar(128) NULL DEFAULT NULL COMMENT '流程定义KEY', `DEF_NAME_` char(10) NULL DEFAULT NULL COMMENT '流程定义名称', `TYPE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程分类ID', `TYPE_` smallint NULL DEFAULT NULL COMMENT '常用语类型\r\n默认为1=全局\r\n2=流程分类\r\n3=流程\r\n4=个人的常用语', `EXPRESSION_` varchar(4000) NULL DEFAULT NULL COMMENT '常用语 多个项用回车分开', `CREATE_TIME_` datetime NULL DEFAULT NULL, `CREATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '创建人ID', `CREATE_ORG_ID_` varchar(64) NULL DEFAULT NULL COMMENT '创建人所属组织ID', `UPDATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '更新人ID', `UPDATE_TIME_` datetime NULL DEFAULT NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_APPROVALITEM_USERID`(`USER_ID_` ASC) USING BTREE, INDEX `IDX_APPROVALITEM_TYPE`(`TYPE_` ASC) USING BTREE )COMMENT = '常用语管理'; -- ---------------------------- -- Records of bpm_approval_item -- ---------------------------- INSERT INTO `bpm_approval_item` VALUES ('6901702', '1', NULL, NULL, NULL, 4, '管理员同意', NULL, NULL, NULL, NULL, '2020-09-29 10:30:10', '-1'); INSERT INTO `bpm_approval_item` VALUES ('752469', '1', NULL, NULL, NULL, 1, '请后面的同事审批', NULL, NULL, NULL, NULL, '2020-09-29 10:30:11', '-1'); INSERT INTO `bpm_approval_item` VALUES ('752475', '1', NULL, NULL, NULL, 1, '我不同意', NULL, NULL, NULL, NULL, '2020-09-29 10:30:14', '-1'); INSERT INTO `bpm_approval_item` VALUES ('8982173', '1', NULL, NULL, NULL, 1, '确认通过', NULL, NULL, NULL, NULL, '2020-09-29 10:30:13', '-1'); -- ---------------------------- -- Table structure for bpm_approval_org -- ---------------------------- DROP TABLE IF EXISTS `bpm_approval_org`; CREATE TABLE `bpm_approval_org` ( `ID_` varchar(64) NOT NULL, `APPROVAL_ID_` varchar(64) NULL DEFAULT NULL COMMENT '常用语', `POST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '岗位', `ROLE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '角色', `DEPARTMENT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '部门', `CREATE_TIME_` datetime NULL DEFAULT NULL, `CREATE_BY_` varchar(255) NULL DEFAULT NULL, `UPDATE_TIME_` datetime NULL DEFAULT NULL, `UPDATE_BY_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '常用语组织'; -- ---------------------------- -- Records of bpm_approval_org -- ---------------------------- -- ---------------------------- -- Table structure for bpm_auto_start_conf -- ---------------------------- DROP TABLE IF EXISTS `bpm_auto_start_conf`; CREATE TABLE `bpm_auto_start_conf` ( `ID_` varchar(64) NOT NULL COMMENT 'ID', `DEF_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '流程定义key', `START_USER_` text NULL COMMENT '启动用户', `FORM_DATA_` text NULL COMMENT '表单数据', `TRIGGER_` varchar(512) NULL DEFAULT NULL COMMENT '触发器', `TENANT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '租户id', `trigger_name_` varchar(100) NULL DEFAULT NULL COMMENT '触发器key', PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '流程自动发起配置表'; -- ---------------------------- -- Records of bpm_auto_start_conf -- ---------------------------- -- ---------------------------- -- Table structure for bpm_bloom -- ---------------------------- DROP TABLE IF EXISTS `bpm_bloom`; CREATE TABLE `bpm_bloom` ( `ID_` varchar(64) NOT NULL COMMENT '主键', `BLOOM_BYTES_` longblob NULL COMMENT '布隆过滤器的数据', `CODE_` varchar(255) NULL DEFAULT NULL COMMENT '编码，做唯一记录识别', PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '布隆过滤器数据表'; -- ---------------------------- -- Records of bpm_bloom -- ---------------------------- -- ---------------------------- -- Table structure for bpm_bus_link -- ---------------------------- DROP TABLE IF EXISTS `bpm_bus_link`; CREATE TABLE `bpm_bus_link` ( `ID_` varchar(64) NOT NULL, `DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程定义ID', `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例ID', `BUSINESSKEY_` bigint NULL DEFAULT NULL COMMENT '业务键', `BUSINESSKEY_STR_` varchar(64) NULL DEFAULT NULL COMMENT '业务键字符型', `SYS_CODE_` varchar(64) NULL DEFAULT NULL COMMENT '业务系统编码', `FORM_IDENTIFY_` varchar(64) NOT NULL COMMENT '表单标识', `START_ID_` varchar(64) NULL DEFAULT NULL COMMENT '发起人', `STARTOR_` varchar(128) NULL DEFAULT NULL COMMENT '发起人', `CREATE_DATE_` datetime NULL DEFAULT NULL, `START_GROUP_ID_` varchar(64) NULL DEFAULT NULL COMMENT '发起组织ID', `START_GROUP_` varchar(128) NULL DEFAULT NULL COMMENT '发起组织', `IS_MAIN_` smallint NULL DEFAULT NULL COMMENT '主记录', `BO_DEF_CODE_` varchar(64) NULL DEFAULT NULL COMMENT 'bodefcode数据', `SAVE_MODE_` varchar(50) NULL DEFAULT NULL COMMENT '保存模式 (boObject,database)', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_BUSLINK_INSTID`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `IDX_BUSLINK_BUSINESSKEY`(`BUSINESSKEY_STR_` ASC) USING BTREE )COMMENT = '流程实例与业务数据关系表，每一条记录对应业务的物理表，属于物理表的额外属性'; -- ---------------------------- -- Records of bpm_bus_link -- ---------------------------- -- ---------------------------- -- Table structure for bpm_call_log -- ---------------------------- DROP TABLE IF EXISTS `bpm_call_log`; CREATE TABLE `bpm_call_log` ( `ID_` varchar(64) NOT NULL, `SUBJECT_` varchar(600) NULL DEFAULT NULL COMMENT ' 流程标题', `PROC_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT ' 流程定义ID', `PROC_DEF_KEY_` varchar(128) NULL DEFAULT NULL COMMENT '流程定义Key', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务ID', `SUP_INST_ID_` varchar(64) NULL DEFAULT '0' COMMENT '父流程实例ID', `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例ID', `TASK_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '任务定义Key', `TASK_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '任务名称', `USER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '调用人员ID', `EVENT_TYPE_` varchar(64) NULL DEFAULT NULL COMMENT '事件类型', `URL_` varchar(255) NULL DEFAULT NULL COMMENT '调用地址', `DESC_` varchar(255) NULL DEFAULT NULL COMMENT '接口描述', `INVOKE_MODE_` int NULL DEFAULT NULL COMMENT '接口调用模式:0:同步，1:异步', `IS_SUCCESS_` smallint NULL DEFAULT 0 COMMENT '是否调用成功', `RESPONSE_` longtext NULL COMMENT '调用结果', `CALL_TIME_` datetime NULL DEFAULT NULL, `PARAMS_` text NULL COMMENT '请求参数', `HEADER_` varchar(2000) NULL DEFAULT NULL, `RETRY_COUNT_` int NULL DEFAULT NULL COMMENT '重试次数', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, `elapsed_time_` decimal(10, 3) NULL DEFAULT NULL COMMENT '接口耗时（单位：秒）', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_CALLLOG_CALLTIME`(`CALL_TIME_` ASC) USING BTREE )COMMENT = 'restful接口调用日志'; -- ---------------------------- -- Records of bpm_call_log -- ---------------------------- -- ---------------------------- -- Table structure for bpm_check_opinion -- ---------------------------- DROP TABLE IF EXISTS `bpm_check_opinion`; CREATE TABLE `bpm_check_opinion` ( `ID_` varchar(64) NOT NULL, `PROC_DEF_ID_` varchar(64) NOT NULL COMMENT '流程定义ID', `SUP_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '父流程实例ID', `PROC_INST_ID_` varchar(64) NOT NULL COMMENT '流程实例ID', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务ID', `TASK_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '任务定义Key', `TASK_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '任务名称', `TOKEN_` varchar(64) NULL DEFAULT NULL COMMENT '任务令牌', `QUALFIEDS_` text NULL COMMENT '有审批资格用户ID串', `QUALFIED_NAMES_` text NULL COMMENT '有审批资格用户名称串', `AUDITOR_` varchar(64) NULL DEFAULT NULL COMMENT '执行人ID', `AUDITOR_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '执行人名', `ORG_ID_` varchar(64) NULL DEFAULT NULL COMMENT '组织ID', `ORG_PATH_` varchar(600) NULL DEFAULT NULL COMMENT '组织全路径', `OPINION_` varchar(4000) NULL DEFAULT NULL COMMENT '审批意见', `STATUS_` varchar(40) NOT NULL COMMENT '审批状态。start=发起流程；awaiting_check=待审批；agree=同意；against=反对；return=驳回；abandon=弃权；retrieve=追回', `FORM_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT '表单定义ID', `FORM_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '表单名', `CREATE_TIME_` datetime NULL DEFAULT NULL, `ASSIGN_TIME_` datetime NULL DEFAULT NULL, `COMPLETE_TIME_` datetime NULL DEFAULT NULL, `DUR_MS_` bigint NULL DEFAULT NULL, `FILES_` text NULL DEFAULT NULL COMMENT '附件', `INTERPOSE_` smallint NULL DEFAULT NULL COMMENT '是否干预', `IS_DELE_` int NOT NULL DEFAULT 0 COMMENT '是否已删，1已删除，0未删除', `IS_READ_` int NOT NULL DEFAULT 0 COMMENT '0：待阅，1：已阅', `AGENT_LEADER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '被代理的领导人id', `PROP1_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性1', `PROP2_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性2', `PROP3_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性3', `PROP4_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性4', `PROP5_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性5', `PROP6_` text NULL COMMENT '扩展属性6', `Z_FILES_` varchar(1000) NULL DEFAULT NULL COMMENT '正文附件', `FORM_DATA_` longtext NULL, `PARENT_TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '父任务id', `SIGN_TYPE_` varchar(64) NULL DEFAULT NULL COMMENT '任务类型', `SKIP_TYPE_` varchar(64) NULL DEFAULT NULL COMMENT '跳过类型 启动跳过 审批跳过 执行人为空跳过 相同执行人跳过', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, `QUALFIEDS_ACCOUNT_` text NULL COMMENT '有审批资格用户帐号串', `AUDITOR_ACCOUNT_` varchar(255) NULL DEFAULT NULL COMMENT '实际审判人', `VARS_` longtext NULL COMMENT '流程变量', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_OPINION_AUDITOR`(`AUDITOR_` ASC) USING BTREE, INDEX `IDX_OPINION_INSTID`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `IDX_OPINION_TASK`(`TASK_ID_` ASC) USING BTREE, INDEX `IDX_CHECKOPINION_SUPINSTID`(`SUP_INST_ID_` ASC) USING BTREE )COMMENT = '流程审批意见'; -- ---------------------------- -- Records of bpm_check_opinion -- ---------------------------- -- ---------------------------- -- Table structure for bpm_check_opinion_hi -- ---------------------------- DROP TABLE IF EXISTS `bpm_check_opinion_hi`; CREATE TABLE `bpm_check_opinion_hi` ( `ID_` varchar(64) NOT NULL, `PROC_DEF_ID_` varchar(64) NOT NULL COMMENT '流程定义ID', `SUP_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '父流程实例ID', `PROC_INST_ID_` varchar(64) NOT NULL, `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务ID', `TASK_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '任务定义Key', `TASK_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '任务名称', `TOKEN_` varchar(64) NULL DEFAULT NULL COMMENT '任务令牌', `QUALFIEDS_` text NULL COMMENT '有审批资格用户ID串', `QUALFIED_NAMES_` text NULL COMMENT '有审批资格用户名称串', `AUDITOR_` varchar(64) NULL DEFAULT NULL COMMENT '执行人ID', `AUDITOR_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '执行人名', `ORG_ID_` varchar(64) NULL DEFAULT NULL COMMENT '组织ID', `ORG_PATH_` varchar(600) NULL DEFAULT NULL COMMENT '组织全路径', `OPINION_` varchar(4000) NULL DEFAULT NULL COMMENT '审批意见', `STATUS_` varchar(40) NOT NULL COMMENT '审批状态。start=发起流程；create=任务创建；agree=同意；against=反对；return=驳回；abandon=弃权；retrieve=追回', `FORM_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT '表单定义ID', `FORM_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '表单名', `CREATE_TIME_` datetime NULL DEFAULT NULL, `ASSIGN_TIME_` datetime NULL DEFAULT NULL, `COMPLETE_TIME_` datetime NULL DEFAULT NULL, `DUR_MS_` bigint NULL DEFAULT NULL COMMENT '持续时间(ms)', `FILES_` varchar(4000) NULL DEFAULT NULL, `INTERPOSE_` smallint NULL DEFAULT NULL, `PROP1_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性1', `PROP2_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性2', `PROP3_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性3', `PROP4_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性4', `PROP5_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性5', `PROP6_` text NULL COMMENT '扩展属性6', `Z_FILES_` varchar(1000) NULL DEFAULT NULL COMMENT '正文附件', `FORM_DATA_` text NULL, `PARENT_TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '父任务id', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_OPINIONHI_PROCINSTID`(`PROC_INST_ID_` ASC) USING BTREE )COMMENT = '流程审批意见历史'; -- ---------------------------- -- Records of bpm_check_opinion_hi -- ---------------------------- -- ---------------------------- -- Table structure for bpm_check_record -- ---------------------------- DROP TABLE IF EXISTS `bpm_check_record`; CREATE TABLE `bpm_check_record` ( `ID_` varchar(64) NOT NULL COMMENT '主键', `TENANT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '租户ID', `CREATE_TIME_` datetime NULL DEFAULT NULL COMMENT '创建时间', `UPDATE_TIME_` datetime NULL DEFAULT NULL COMMENT '更新时间', `CREATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '创建人', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务id', `INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '实例id', `create_org_id_` varchar(64) NULL DEFAULT NULL, `update_by_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '任务阅读记录'; -- ---------------------------- -- Records of bpm_check_record -- ---------------------------- -- ---------------------------- -- Table structure for bpm_commu_receiver -- ---------------------------- DROP TABLE IF EXISTS `bpm_commu_receiver`; CREATE TABLE `bpm_commu_receiver` ( `ID_` varchar(64) NOT NULL, `COMMU_ID_` varchar(64) NULL DEFAULT NULL COMMENT '通知ID', `RECEIVER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '接收人ID', `RECEIVER` varchar(128) NULL DEFAULT NULL COMMENT '接收人', `STATUS_` varchar(20) NULL DEFAULT NULL COMMENT '状态', `OPINION_` varchar(512) NULL DEFAULT NULL COMMENT '反馈意见', `RECEIVE_TIME_` datetime NULL DEFAULT NULL, `FEEDBACK_TIME_` datetime NULL DEFAULT NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_COMMURECEIVER_COMMUID`(`COMMU_ID_` ASC) USING BTREE, INDEX `IDX_COMMURECEIVER_RECEIVERID`(`RECEIVER_ID_` ASC) USING BTREE )COMMENT = '任务通知接收人'; -- ---------------------------- -- Records of bpm_commu_receiver -- ---------------------------- -- ---------------------------- -- Table structure for bpm_cpto_receiver -- ---------------------------- DROP TABLE IF EXISTS `bpm_cpto_receiver`; CREATE TABLE `bpm_cpto_receiver` ( `ID_` varchar(64) NOT NULL, `CPTO_ID_` varchar(64) NULL DEFAULT NULL COMMENT '关联ID', `RECEIVER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '接收人ID', `RECEIVER_` varchar(64) NULL DEFAULT NULL COMMENT '接收人', `IS_READ_` smallint NULL DEFAULT NULL COMMENT '已读', `READ_TIME_` datetime NULL DEFAULT NULL, `CREATE_TIME_` datetime NULL DEFAULT NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_CPTORECEIVER_CPTOID`(`CPTO_ID_` ASC) USING BTREE, INDEX `IDX_CPTORECEIVER_RECEIVERID`(`RECEIVER_ID_` ASC) USING BTREE )COMMENT = '抄送接收人'; -- ---------------------------- -- Records of bpm_cpto_receiver -- ---------------------------- -- ---------------------------- -- Table structure for bpm_custom_signdata -- ---------------------------- DROP TABLE IF EXISTS `bpm_custom_signdata`; CREATE TABLE `bpm_custom_signdata` ( `ID_` varchar(64) NOT NULL, `TYPE_` varchar(64) NULL DEFAULT NULL COMMENT '任务类型（并签，顺签，并批）', `STATUS_` varchar(64) NULL DEFAULT NULL COMMENT '审批中，完成，二次并签，被撤回，撤回审批中，撤回无待办', `PARENT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '父id', `PATH_` varchar(3000) NULL DEFAULT NULL COMMENT '路径', `INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '实例id', `NODE_ID_` varchar(128) NULL DEFAULT NULL COMMENT '节点id', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务id', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_CUSTOM_SIGN_PARENTID`(`PARENT_ID_` ASC) USING BTREE, INDEX `IDX_CUSTOM_SIGN_TYPE`(`TYPE_` ASC) USING BTREE, INDEX `IDX_CUSTOM_SIGN_TASKID`(`TASK_ID_` ASC) USING BTREE, INDEX `IDX_CUSTOM_SIGN_INSTID`(`INST_ID_` ASC) USING BTREE )COMMENT = '并行签署'; -- ---------------------------- -- Records of bpm_custom_signdata -- ---------------------------- -- ---------------------------- -- Table structure for bpm_def_act -- ---------------------------- DROP TABLE IF EXISTS `bpm_def_act`; CREATE TABLE `bpm_def_act` ( `ID_` varchar(64) NOT NULL, `AUTHORIZE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程授权主表ID', `DEF_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '授权流程KEY', `DEF_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '授权流程名称', `RIGHT_CONTENT_` varchar(128) NULL DEFAULT NULL COMMENT '授权内容', `TYPE_` varchar(64) NULL DEFAULT NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_AUTHDEF_AUTHID`(`AUTHORIZE_ID_` ASC) USING BTREE )COMMENT = '流程授权流程定义'; -- ---------------------------- -- Records of bpm_def_act -- ---------------------------- -- ---------------------------- -- Table structure for bpm_def_auth_type -- ---------------------------- DROP TABLE IF EXISTS `bpm_def_auth_type`; CREATE TABLE `bpm_def_auth_type` ( `ID_` varchar(64) NOT NULL, `AUTHORIZE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程授权主表ID', `AUTHORIZE_TYPE_` varchar(20) NULL DEFAULT NULL COMMENT '流程授权类型定义（management）、启动（start）、实例（instance）和任务（task）', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_AUTHTYPE_AUTHID`(`AUTHORIZE_ID_` ASC) USING BTREE, INDEX `IDX_AUTHTYPE_AUTHTYPE`(`AUTHORIZE_TYPE_` ASC) USING BTREE )COMMENT = '流程授权类型'; -- ---------------------------- -- Records of bpm_def_auth_type -- ---------------------------- -- ---------------------------- -- Table structure for bpm_def_authorize -- ---------------------------- DROP TABLE IF EXISTS `bpm_def_authorize`; CREATE TABLE `bpm_def_authorize` ( `ID_` varchar(64) NOT NULL, `AUTHORIZE_DESC_` varchar(255) NULL DEFAULT NULL COMMENT '流程授权说明', `CREATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '创建人ID', `CREATOR_` varchar(64) NULL DEFAULT NULL COMMENT '创建人', `CREATE_TIME_` datetime NULL DEFAULT NULL, `MULTI_PLE` varchar(64) NULL DEFAULT NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '流程授权主表'; -- ---------------------------- -- Records of bpm_def_authorize -- ---------------------------- -- ---------------------------- -- Table structure for bpm_def_data -- ---------------------------- DROP TABLE IF EXISTS `bpm_def_data`; CREATE TABLE `bpm_def_data` ( `ID_` varchar(64) NOT NULL, `DEF_XML_` longtext NULL, `BPMN_XML_` longtext NULL COMMENT '流程定义XML', `DEF_JSON_` longtext NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '流程定义XML数据'; -- ---------------------------- -- Records of bpm_def_data -- ---------------------------- -- ---------------------------- -- Table structure for bpm_def_user -- ---------------------------- DROP TABLE IF EXISTS `bpm_def_user`; CREATE TABLE `bpm_def_user` ( `ID_` varchar(64) NOT NULL, `AUTHORIZE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程授权主表ID', `OWNER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '授权对象ID', `OWNER_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '授权对象名称', `RIGHT_TYPE_` varchar(20) NULL DEFAULT NULL COMMENT '授权对象类型(角色,用户,岗位等)', `OBJ_TYPE_` varchar(64) NULL DEFAULT NULL, `AUTH_ORG_` varchar(255) NULL DEFAULT NULL, `AUTH_ORG_NAME_` varchar(255) NULL DEFAULT NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_DEFUSER_AUTHID`(`AUTHORIZE_ID_` ASC) USING BTREE, INDEX `IDX_DEFUSER_RIGHTTYPE`(`RIGHT_TYPE_` ASC) USING BTREE, INDEX `IDX_DEFUSER_OBJTYPE`(`OBJ_TYPE_` ASC) USING BTREE )COMMENT = '流程授权中用户'; -- ---------------------------- -- Records of bpm_def_user -- ---------------------------- -- ---------------------------- -- Table structure for bpm_definition -- ---------------------------- DROP TABLE IF EXISTS `bpm_definition`; CREATE TABLE `bpm_definition` ( `DEF_ID_` varchar(64) NOT NULL COMMENT '流程定义ID', `NAME_` varchar(64) NOT NULL COMMENT '流程名称', `DEF_KEY_` varchar(64) NOT NULL COMMENT '流程定义KEY', `DESC_` varchar(1024) NULL DEFAULT NULL COMMENT '流程描述', `TYPE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '所属分类ID', `STATUS_` varchar(40) NOT NULL COMMENT '状态。草稿、发布、禁用', `TEST_STATUS_` varchar(40) NOT NULL COMMENT '测试状态', `BPMN_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT 'BPMN - 流程定义ID', `BPMN_DEPLOY_ID_` varchar(64) NULL DEFAULT NULL COMMENT 'BPMN - 流程发布ID', `VERSION_` int NULL DEFAULT NULL COMMENT '版本 - 当前版本号', `MAIN_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT '版本 - 主版本流程ID', `IS_MAIN_` char(1) NOT NULL COMMENT '版本 - 是否主版本', `REASON_` varchar(1024) NULL DEFAULT NULL COMMENT '版本 - 变更理由', `CREATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '创建人ID', `CREATE_TIME_` datetime NULL DEFAULT NULL, `CREATE_ORG_ID_` varchar(64) NULL DEFAULT NULL COMMENT '创建者所属组织ID', `UPDATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '更新人ID', `UPDATE_TIME_` datetime NULL DEFAULT NULL, `DESIGNER_` varchar(20) NULL DEFAULT NULL COMMENT '设计器类型', `SUPPORT_MOBILE_` int NULL DEFAULT 0 COMMENT '支持手机表单', `REV_` int NOT NULL DEFAULT 1 COMMENT '关联锁', `SHOW_URGENT_STATE_` int NULL DEFAULT NULL COMMENT '是否显示紧急状态', `IS_READ_REVOKE` varchar(64) NULL DEFAULT NULL COMMENT '传阅已阅是否允许撤回', `URGENT_MAIL_TEL` text NULL COMMENT '人工催办内容邮件模板', `URGENT_SMS_TEL` text NULL COMMENT '人工催办内容短信模板', `TYPE_NAME_` varchar(64) NULL DEFAULT NULL, `SHOW_MODIFY_RECORD_` int NULL DEFAULT NULL COMMENT '是否显示表单留痕', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, `MOBILE_START_URL_` varchar(200) NULL DEFAULT NULL COMMENT '手机端启动地址', `PC_START_URL_` varchar(200) NULL DEFAULT NULL COMMENT 'pc端启动地址', `TAGS_` varchar(400) NULL DEFAULT NULL COMMENT '流程标签', `DESIGN_PATTERN_` varchar(20) NULL DEFAULT NULL COMMENT '设计模式 normal simple', `FLOW_TYPE_` int NULL DEFAULT NULL COMMENT '流程类型', `DEPLOY_DESC_` varchar(500) NULL DEFAULT NULL COMMENT '发布说明', PRIMARY KEY (`DEF_ID_`) USING BTREE, INDEX `IDX_DEFINITION_DEFKEY`(`DEF_KEY_` ASC) USING BTREE, INDEX `IDX_DEFINITION_BPMNDEFID`(`BPMN_DEF_ID_` ASC) USING BTREE )COMMENT = '流程定义'; -- ---------------------------- -- Records of bpm_definition -- ---------------------------- -- ---------------------------- -- Table structure for bpm_deputy -- ---------------------------- DROP TABLE IF EXISTS `bpm_deputy`; CREATE TABLE `bpm_deputy` ( `ID_` varchar(64) NOT NULL, `USER_ID_` varchar(64) NOT NULL COMMENT '被代理人id', `USER_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '被代理人姓名', `AGENT_ID_` varchar(64) NOT NULL COMMENT '代理人id', `AGENT_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '代理人姓名', `IS_MAIL_` int NULL DEFAULT 1 COMMENT '是否接收邮件(1:接收，0：不接收)', `IS_USABLE_` int NULL DEFAULT 1 COMMENT '是否可用（1：启用，0：禁用）', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_DEPUTY_USERID`(`USER_ID_` ASC) USING BTREE, INDEX `IDX_DEPUTY_AGENTID`(`AGENT_ID_` ASC) USING BTREE )COMMENT = '流程代理表'; -- ---------------------------- -- Records of bpm_deputy -- ---------------------------- -- ---------------------------- -- Table structure for bpm_documentation_config -- ---------------------------- DROP TABLE IF EXISTS `bpm_documentation_config`; CREATE TABLE `bpm_documentation_config` ( `ID_` varchar(255) NOT NULL, `DATA_KEY_` varchar(255) NULL DEFAULT NULL COMMENT '数据源key', `AUTORUN_` varchar(10) NULL DEFAULT NULL COMMENT '是否自动执行', `AUTORUN_CONFIG_` varchar(255) NULL DEFAULT NULL COMMENT '自动执行配置', `DELETE_DATA_` varchar(10) NULL DEFAULT NULL COMMENT '是否删除数据', `LIMIT_` varchar(10) NULL DEFAULT NULL COMMENT '是否限制数据', `LIMIT_NUMBER_` varchar(255) NULL DEFAULT NULL COMMENT '限制数量', `UPDATE_BY_` varchar(255) NULL DEFAULT NULL COMMENT '修改人', `UPDATE_TIME_` datetime NULL DEFAULT NULL COMMENT '修改时间', `BEFORE_MONTH_` varchar(10) NULL DEFAULT NULL COMMENT '同步时间', `JOB_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '定时任务名称', `TENANT_ID_` varchar(255) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '数据归档配置表'; -- ---------------------------- -- Records of bpm_documentation_config -- ---------------------------- INSERT INTO `bpm_documentation_config` VALUES ('1', NULL, '1', '{\"type\":4,\"timeInterval\":\"MON,TUE,WED,SUN|11:49:20\"}', '2', '1', '500', '1', '2023-03-23 15:46:12', '0', '流程归档数据同步', '-1'); -- ---------------------------- -- Table structure for bpm_documentation_table -- ---------------------------- DROP TABLE IF EXISTS `bpm_documentation_table`; CREATE TABLE `bpm_documentation_table` ( `ID_` varchar(255) NOT NULL, `TABLE_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '表名', `DML_` text NULL COMMENT '表查询语句', `DDL_` text NULL COMMENT '表定义语句', `SYSTEM_` varchar(10) NULL DEFAULT NULL COMMENT '是否系统默认表', `START_` varchar(255) NULL DEFAULT NULL COMMENT '是否启动', `INFO_` varchar(255) NULL DEFAULT NULL COMMENT '说明', `ORDER_` varchar(255) NULL DEFAULT NULL COMMENT '同步顺序', `UPDATE_BY_` varchar(255) NULL DEFAULT NULL COMMENT '创建人', `PARENT_FIELD_` varchar(255) NULL DEFAULT NULL COMMENT '主表字段', `FIELD_` varchar(255) NULL DEFAULT NULL COMMENT '子表字段', `TIME_KEY_` varchar(255) NULL DEFAULT NULL COMMENT '同步表时间字段', `PARENT_ID_` varchar(255) NULL DEFAULT NULL COMMENT '父表id', `UPDATE_TIME_` datetime NULL DEFAULT NULL COMMENT '创建时间', `TENANT_ID_` varchar(255) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '同步数据目标表'; -- ---------------------------- -- Records of bpm_documentation_table -- ---------------------------- INSERT INTO `bpm_documentation_table` VALUES ('1644250277726375936', 'bpm_pro_inst', '', 'CREATE TABLE `bpm_pro_inst` (\n `ID_` varchar(64) NOT NULL,\n `SUBJECT_` varchar(256) NULL DEFAULT NULL,\n `PROC_DEF_ID_` varchar(64) NOT NULL COMMENT \'流程定义ID\',\n `BPMN_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'BPMN流程定义ID\',\n `PROC_DEF_KEY_` varchar(128) NULL DEFAULT NULL COMMENT \'流程定义Key\',\n `PROC_DEF_NAME_` varchar(128) NOT NULL COMMENT \'流程名称\',\n `BIZ_KEY_` varchar(64) NULL DEFAULT NULL COMMENT \'业务主键\',\n `SYS_CODE_` varchar(64) NULL DEFAULT NULL COMMENT \'业务系统编码\',\n `FORM_KEY_` varchar(64) NULL DEFAULT NULL COMMENT \'绑定的表单主键\',\n `STATUS_` varchar(40) NULL DEFAULT NULL COMMENT \'实例状态\',\n `END_TIME_` datetime(0) NULL DEFAULT NULL,\n `DURATION_` bigint(0) NULL DEFAULT NULL COMMENT \'持续时间(ms)\',\n `TYPE_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'所属分类ID\',\n `RESULT_TYPE_` varchar(40) NULL DEFAULT NULL COMMENT \'流程结束后的最终审批结果，agree=同意；refuse=拒绝\',\n `BPMN_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'BPMN流程实例ID\',\n `CREATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT \'创建人ID\',\n `CREATE_TIME_` datetime(0) NULL DEFAULT NULL,\n `CREATE_ORG_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'创建者所属组织ID\',\n `UPDATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT \'更新人ID\',\n `UPDATE_TIME_` datetime(0) NULL DEFAULT NULL,\n `IS_FORMMAL_` char(1) NOT NULL COMMENT \'是否正式数据\',\n `PARENT_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'父实例Id\',\n `IS_FORBIDDEN_` smallint(0) NULL DEFAULT NULL COMMENT \'禁止\',\n `DATA_MODE_` varchar(20) NULL DEFAULT NULL COMMENT \'业务数据存储模式。\\r\\npk:主键\\r\\nbo:业务对象\',\n `CREATOR_` varchar(64) NULL DEFAULT NULL COMMENT \'创建人\',\n `SUPPORT_MOBILE_` int(0) NULL DEFAULT 0 COMMENT \'支持手机端\',\n `SUPER_NODE_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'子流程节点的ID\',\n `IS_DELE_` int(0) NOT NULL DEFAULT 0 COMMENT \'是否已删，1已删除，0未删除\',\n `URGENT_STATE_` varchar(64) NULL DEFAULT NULL COMMENT \'紧急状态\',\n `TENANT_ID_` varchar(64) NULL DEFAULT NULL,\n `MOBILE_INST_URL_` varchar(200) NULL DEFAULT NULL COMMENT \'手机端实例地址\',\n `PC_INST_URL_` varchar(200) NULL DEFAULT NULL COMMENT \'pc端实例地址\',\n `CREATE_ORG_PATH_` text NULL,\n `CREATE_ACCOUNT_` varchar(64) NULL DEFAULT NULL COMMENT \'流程发起人账号\',\n PRIMARY KEY (`ID_`) USING BTREE,\n UNIQUE INDEX `IDX_PRO_INST_BPMNINSTID`(`BPMN_INST_ID_`) USING BTREE,\n INDEX `IDX_PRO_INST_PROCDEFKEY`(`PROC_DEF_KEY_`) USING BTREE,\n INDEX `IDX_PRO_INST_PROCDEFID`(`PROC_DEF_ID_`) USING BTREE\n) COMMENT = \'流程实例\';', '1', '1', NULL, '1', '1', NULL, NULL, 'UPDATE_TIME_', '0', '2023-04-14 10:04:31', '-1'); INSERT INTO `bpm_documentation_table` VALUES ('1644251197944090624', 'bpm_bus_link', NULL, 'CREATE TABLE `bpm_bus_link` (\n `ID_` varchar(64) NOT NULL,\n `DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'流程定义ID\',\n `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'流程实例ID\',\n `BUSINESSKEY_` bigint(0) NULL DEFAULT NULL COMMENT \'业务键\',\n `BUSINESSKEY_STR_` varchar(64) NULL DEFAULT NULL COMMENT \'业务键字符型\',\n `SYS_CODE_` varchar(64) NULL DEFAULT NULL COMMENT \'业务系统编码\',\n `FORM_IDENTIFY_` varchar(64) NOT NULL COMMENT \'表单标识\',\n `START_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'发起人\',\n `STARTOR_` varchar(128) NULL DEFAULT NULL COMMENT \'发起人\',\n `CREATE_DATE_` datetime(0) NULL DEFAULT NULL,\n `START_GROUP_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'发起组织ID\',\n `START_GROUP_` varchar(128) NULL DEFAULT NULL COMMENT \'发起组织\',\n `IS_MAIN_` smallint(0) NULL DEFAULT NULL COMMENT \'主记录\',\n `BO_DEF_CODE_` varchar(64) NULL DEFAULT NULL COMMENT \'bodefcode数据\',\n `SAVE_MODE_` varchar(50) NULL DEFAULT NULL COMMENT \'保存模式 (boObject,database)\',\n `TENANT_ID_` varchar(64) NULL DEFAULT NULL,\n PRIMARY KEY (`ID_`) USING BTREE,\n INDEX `IDX_BUSLINK_INSTID`(`PROC_INST_ID_`) USING BTREE,\n INDEX `IDX_BUSLINK_BUSINESSKEY`(`BUSINESSKEY_STR_`) USING BTREE\n) COMMENT = \'流程实例与业务数据关系表，每一条记录对应业务的物理表，属于物理表的额外属性\';\n', '1', '0', NULL, '1', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-04-07 16:10:09', '-1'); INSERT INTO `bpm_documentation_table` VALUES ('1644251940189097984', 'bpm_pro_status', NULL, 'CREATE TABLE `bpm_pro_status` (\n `ID_` varchar(64) NOT NULL,\n `PROC_INST_ID_` varchar(64) NOT NULL COMMENT \'流程实例ID\',\n `PROC_DEF_ID_` varchar(64) NOT NULL COMMENT \'ACT流程定义ID\',\n `NODE_ID_` varchar(255) NOT NULL COMMENT \'节点ID\',\n `NODE_NAME_` varchar(255) NULL DEFAULT NULL COMMENT \'节点名称\',\n `STATUS_` varchar(50) NOT NULL COMMENT \'状态\',\n `LAST_UPDATE_` datetime(0) NULL DEFAULT NULL,\n `LAST_USERID_` varchar(64) NULL DEFAULT NULL COMMENT \'最后更新人\',\n `TENANT_ID_` varchar(64) NULL DEFAULT NULL,\n `RECYCLE_NODE_` varchar(2) NULL DEFAULT NULL COMMENT \'驳回按流程图执行回收的节点 0默认值 1因为驳回按照流程图执行目标节点之后的节点为1，如果重新运行到该节点变为0\',\n PRIMARY KEY (`ID_`) USING BTREE,\n INDEX `IDX_PROSTATUS_INSTID`(`PROC_INST_ID_`) USING BTREE,\n INDEX `IDX_PROSTATUS_NODEID`(`NODE_ID_`) USING BTREE\n) COMMENT = \'流程节点审批状态\';', '1', '0', NULL, '2', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-04-07 16:13:06', '-1'); INSERT INTO `bpm_documentation_table` VALUES ('1644252316812431360', 'bpm_check_opinion', NULL, 'CREATE TABLE `bpm_check_opinion` (\n `ID_` varchar(64) NOT NULL,\n `PROC_DEF_ID_` varchar(64) NOT NULL COMMENT \'流程定义ID\',\n `SUP_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'父流程实例ID\',\n `PROC_INST_ID_` varchar(64) NOT NULL COMMENT \'流程实例ID\',\n `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'任务ID\',\n `TASK_KEY_` varchar(64) NULL DEFAULT NULL COMMENT \'任务定义Key\',\n `TASK_NAME_` varchar(255) NULL DEFAULT NULL COMMENT \'任务名称\',\n `TOKEN_` varchar(64) NULL DEFAULT NULL COMMENT \'任务令牌\',\n `QUALFIEDS_` text NULL COMMENT \'有审批资格用户ID串\',\n `QUALFIED_NAMES_` text NULL COMMENT \'有审批资格用户名称串\',\n `AUDITOR_` varchar(64) NULL DEFAULT NULL COMMENT \'执行人ID\',\n `AUDITOR_NAME_` varchar(64) NULL DEFAULT NULL COMMENT \'执行人名\',\n `ORG_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'组织ID\',\n `ORG_PATH_` varchar(600) NULL DEFAULT NULL COMMENT \'组织全路径\',\n `OPINION_` varchar(4000) NULL DEFAULT NULL COMMENT \'审批意见\',\n `STATUS_` varchar(40) NOT NULL COMMENT \'审批状态。start=发起流程；awaiting_check=待审批；agree=同意；against=反对；return=驳回；abandon=弃权；retrieve=追回\',\n `FORM_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'表单定义ID\',\n `FORM_NAME_` varchar(64) NULL DEFAULT NULL COMMENT \'表单名\',\n `CREATE_TIME_` datetime(0) NULL DEFAULT NULL,\n `ASSIGN_TIME_` datetime(0) NULL DEFAULT NULL,\n `COMPLETE_TIME_` datetime(0) NULL DEFAULT NULL,\n `DUR_MS_` bigint(0) NULL DEFAULT NULL,\n `FILES_` varchar(4000) NULL DEFAULT NULL COMMENT \'附件\',\n `INTERPOSE_` smallint(0) NULL DEFAULT NULL COMMENT \'是否干预\',\n `IS_DELE_` int(0) NOT NULL DEFAULT 0 COMMENT \'是否已删，1已删除，0未删除\',\n `IS_READ_` int(0) NOT NULL DEFAULT 0 COMMENT \'0：待阅，1：已阅\',\n `AGENT_LEADER_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'被代理的领导人id\',\n `PROP1_` varchar(200) NULL DEFAULT NULL COMMENT \'扩展属性1\',\n `PROP2_` varchar(200) NULL DEFAULT NULL COMMENT \'扩展属性2\',\n `PROP3_` varchar(200) NULL DEFAULT NULL COMMENT \'扩展属性3\',\n `PROP4_` varchar(200) NULL DEFAULT NULL COMMENT \'扩展属性4\',\n `PROP5_` varchar(200) NULL DEFAULT NULL COMMENT \'扩展属性5\',\n `PROP6_` text NULL COMMENT \'扩展属性6\',\n `Z_FILES_` varchar(1000) NULL DEFAULT NULL COMMENT \'正文附件\',\n `FORM_DATA_` longtext NULL,\n `PARENT_TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'父任务id\',\n `SIGN_TYPE_` varchar(64) NULL DEFAULT NULL COMMENT \'任务类型\',\n `SKIP_TYPE_` varchar(64) NULL DEFAULT NULL COMMENT \'跳过类型 启动跳过 审批跳过 执行人为空跳过 相同执行人跳过\',\n `TENANT_ID_` varchar(64) NULL DEFAULT NULL,\n `QUALFIEDS_ACCOUNT_` text NULL COMMENT \'有审批资格用户帐号串\',\n `AUDITOR_ACCOUNT_` varchar(255) NULL DEFAULT NULL COMMENT \'实际审判人\',\n `VARS_` longtext NULL COMMENT \'流程变量\',\n PRIMARY KEY (`ID_`) USING BTREE,\n INDEX `IDX_OPINION_AUDITOR`(`AUDITOR_`) USING BTREE,\n INDEX `IDX_OPINION_INSTID`(`PROC_INST_ID_`) USING BTREE,\n INDEX `IDX_OPINION_TASK`(`TASK_ID_`) USING BTREE,\n INDEX `IDX_CHECKOPINION_SUPINSTID`(`SUP_INST_ID_`) USING BTREE\n) COMMENT = \'流程审批意见\';\n', '1', '0', NULL, '3', '1', 'id_', 'proc_inst_id_', NULL, '1644250277726375936', '2023-04-07 16:15:43', '-1'); INSERT INTO `bpm_documentation_table` VALUES ('1644253067093725184', 'bpm_exe_stack', NULL, 'CREATE TABLE `bpm_exe_stack` (\n `ID_` varchar(64) NOT NULL,\n `PRCO_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'流程定义ID\',\n `NODE_ID_` varchar(64) NOT NULL COMMENT \'节点ID\',\n `NODE_NAME_` varchar(128) NULL DEFAULT NULL COMMENT \'节点名\',\n `START_TIME_` datetime(0) NULL DEFAULT NULL,\n `END_TIME` datetime(0) NULL DEFAULT NULL,\n `IS_MULITI_TASK_` smallint(0) NOT NULL COMMENT \'多实例任务\\r\\n1=是\\r\\n0=否\',\n `PARENT_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'父ID\',\n `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'流程实例ID\',\n `NODE_PATH_` varchar(1024) NULL DEFAULT NULL COMMENT \'节点路径\\r\\n格式如：\\r\\n0.1.2.\\r\\n其中2则为本行记录的主键值\',\n `DEPTH_` smallint(0) NULL DEFAULT NULL COMMENT \'节点层\',\n `TASK_TOKEN_` varchar(255) NULL DEFAULT NULL COMMENT \'是针对分发任务时，携带的令牌，方便查找其父任务堆栈\',\n `NODE_TYPE_` varchar(255) NULL DEFAULT NULL COMMENT \'节点类型\',\n `TARGET_NODE_` varchar(200) NULL DEFAULT NULL COMMENT \'驳回时返回节点\',\n `TARGET_TOKEN_` varchar(255) NULL DEFAULT NULL,\n `INTERPOSE_` smallint(0) NULL DEFAULT NULL COMMENT \'是否干预执行\',\n `TENANT_ID_` varchar(64) NULL DEFAULT NULL,\n PRIMARY KEY (`ID_`) USING BTREE,\n INDEX `IDX_EXESTACK_INSTID`(`PROC_INST_ID_`) USING BTREE\n) COMMENT = \'流程执行堆栈树\';', '1', '0', NULL, '4', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-04-14 10:04:54', '-1'); INSERT INTO `bpm_documentation_table` VALUES ('1644254426346016768', 'bpm_flow_mq_log', NULL, 'CREATE TABLE `bpm_flow_mq_log` (\n `ID_` varchar(64) NOT NULL COMMENT \'主键\',\n `TYPE_` varchar(40) NOT NULL COMMENT \'类型\',\n `TITLE_` varchar(300) NULL DEFAULT NULL COMMENT \'标题\',\n `CONTENT_` text NULL COMMENT \'内容\',\n `STATUS_` int(0) NOT NULL COMMENT \'状态\',\n `TRY_TIME_` int(0) NULL DEFAULT NULL COMMENT \'重试次数\',\n `EXCEPTION_` varchar(2000) NULL DEFAULT NULL COMMENT \'异常信息\',\n `LOG_TIME_` datetime(0) NULL DEFAULT NULL COMMENT \'日志记录时间\',\n `TARGET_` varchar(64) NULL DEFAULT NULL COMMENT \'日志目标类型\',\n `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'实例ID\',\n `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'任务ID\',\n `OWNER_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'任务所属人id\',\n `OWNER_NAME_` varchar(64) NULL DEFAULT NULL COMMENT \'任务所属人姓名\',\n `TENANT_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'租户id\',\n `YEARS_PARTITION_` int(0) NULL DEFAULT NULL COMMENT \'日志所属年份\',\n PRIMARY KEY (`ID_`) USING BTREE,\n INDEX `IDX_YEARS_PARTITION_`(`YEARS_PARTITION_`) USING BTREE,\n INDEX `IDX_PROC_INST_ID_`(`PROC_INST_ID_`) USING BTREE,\n INDEX `idx_bpm_flow_message_type`(`TYPE_`) USING BTREE\n) COMMENT = \'统一待办推送日志\';', '1', '0', NULL, '5', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-04-07 16:23:10', '-1'); INSERT INTO `bpm_documentation_table` VALUES ('1644254843394052096', 'bpm_read_record', NULL, 'CREATE TABLE `bpm_read_record` (\n `ID_` varchar(255) NOT NULL,\n `PROC_DEF_ID_` varchar(255) NULL DEFAULT NULL COMMENT \'流程定义ID\',\n `SUP_INST_ID_` varchar(255) NULL DEFAULT NULL COMMENT \'父流程实例ID\',\n `PROC_INST_ID_` varchar(255) NULL DEFAULT NULL COMMENT \'流程实例ID\',\n `TASK_ID_` varchar(255) NULL DEFAULT NULL COMMENT \'任务ID\',\n `TASK_KEY_` varchar(255) NULL DEFAULT NULL COMMENT \'任务定义Key\',\n `TASK_NAME_` varchar(255) NULL DEFAULT NULL COMMENT \'任务名称\',\n `READER_` varchar(255) NULL DEFAULT NULL COMMENT \'阅读人ID\',\n `READER_NAME_` varchar(255) NULL DEFAULT NULL COMMENT \'阅读人名\',\n `READ_TIME_` datetime(0) NULL DEFAULT NULL,\n `ORG_ID_` varchar(255) NULL DEFAULT NULL COMMENT \'组织id\',\n `ORG_PATH_` varchar(255) NULL DEFAULT NULL COMMENT \'组织名称\',\n `TENANT_ID_` varchar(64) NULL DEFAULT NULL,\n PRIMARY KEY (`ID_`) USING BTREE,\n INDEX `IDX_READRECORD_PROCINSTID`(`PROC_INST_ID_`) USING BTREE,\n INDEX `IDX_READRECORD_TASKID`(`TASK_ID_`) USING BTREE,\n INDEX `IDX_READRECORD_TASKKEY`(`TASK_KEY_`) USING BTREE\n) COMMENT = \'任务阅读记录表\';', '1', '0', NULL, '6', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-04-07 16:24:59', '-1'); INSERT INTO `bpm_documentation_table` VALUES ('1644272017298935808', 'bpm_exe_stack_executor', NULL, 'CREATE TABLE `bpm_exe_stack_executor` (\n `ID_` varchar(64) NOT NULL,\n `STACK_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'堆栈ID\',\n `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'任务ID\',\n `ASSIGNEE_ID_` varchar(64) NULL DEFAULT NULL COMMENT \'执行人\',\n `CREATE_TIME_` datetime(0) NULL DEFAULT NULL,\n `END_TIME_` datetime(0) NULL DEFAULT NULL,\n `STATUS_` smallint(0) NULL DEFAULT NULL COMMENT \'状态(0,初始,1,完成,2,取消)\',\n `TENANT_ID_` varchar(64) NULL DEFAULT NULL,\n `TARGET_NODE_` varchar(64) NULL DEFAULT NULL COMMENT \'目标节点\',\n PRIMARY KEY (`ID_`) USING BTREE,\n INDEX `IDX_STACKEXECUTOR_STACKID`(`STACK_ID_`) USING BTREE,\n INDEX `IDX_STACKEXECUTOR_TASKID`(`TASK_ID_`) USING BTREE\n) COMMENT = \'堆栈执行人\';', NULL, '0', NULL, '7', '1', 'id_', 'STACK_ID_', '', '1644253067093725184', '2023-04-14 10:05:07', '-1'); -- ---------------------------- -- Table structure for bpm_exe_stack -- ---------------------------- DROP TABLE IF EXISTS `bpm_exe_stack`; CREATE TABLE `bpm_exe_stack` ( `ID_` varchar(64) NOT NULL, `PRCO_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程定义ID', `NODE_ID_` varchar(64) NOT NULL COMMENT '节点ID', `NODE_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '节点名', `START_TIME_` datetime NULL DEFAULT NULL, `END_TIME` datetime NULL DEFAULT NULL, `IS_MULITI_TASK_` smallint NOT NULL COMMENT '多实例任务\r\n1=是\r\n0=否', `PARENT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '父ID', `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例ID', `NODE_PATH_` varchar(1024) NULL DEFAULT NULL COMMENT '节点路径\r\n格式如：\r\n0.1.2.\r\n其中2则为本行记录的主键值', `DEPTH_` smallint NULL DEFAULT NULL COMMENT '节点层', `TASK_TOKEN_` varchar(255) NULL DEFAULT NULL COMMENT '是针对分发任务时，携带的令牌，方便查找其父任务堆栈', `NODE_TYPE_` varchar(255) NULL DEFAULT NULL COMMENT '节点类型', `TARGET_NODE_` varchar(200) NULL DEFAULT NULL COMMENT '驳回时返回节点', `TARGET_TOKEN_` varchar(255) NULL DEFAULT NULL, `INTERPOSE_` smallint NULL DEFAULT NULL COMMENT '是否干预执行', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_EXESTACK_INSTID`(`PROC_INST_ID_` ASC) USING BTREE )COMMENT = '流程执行堆栈树'; -- ---------------------------- -- Records of bpm_exe_stack -- ---------------------------- -- ---------------------------- -- Table structure for bpm_exe_stack_executor -- ---------------------------- DROP TABLE IF EXISTS `bpm_exe_stack_executor`; CREATE TABLE `bpm_exe_stack_executor` ( `ID_` varchar(64) NOT NULL, `STACK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '堆栈ID', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务ID', `ASSIGNEE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '执行人', `CREATE_TIME_` datetime NULL DEFAULT NULL, `END_TIME_` datetime NULL DEFAULT NULL, `STATUS_` smallint NULL DEFAULT NULL COMMENT '状态(0,初始,1,完成,2,取消)', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, `TARGET_NODE_` varchar(64) NULL DEFAULT NULL COMMENT '目标节点', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_STACKEXECUTOR_STACKID`(`STACK_ID_` ASC) USING BTREE, INDEX `IDX_STACKEXECUTOR_TASKID`(`TASK_ID_` ASC) USING BTREE )COMMENT = '堆栈执行人'; -- ---------------------------- -- Records of bpm_exe_stack_executor -- ---------------------------- -- ---------------------------- -- Table structure for bpm_exe_stack_his -- ---------------------------- DROP TABLE IF EXISTS `bpm_exe_stack_his`; CREATE TABLE `bpm_exe_stack_his` ( `ID_` varchar(64) NOT NULL, `PRCO_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程定义ID', `NODE_ID_` varchar(64) NOT NULL COMMENT '节点ID', `NODE_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '节点名', `START_TIME_` datetime NULL DEFAULT NULL, `END_TIME` datetime NULL DEFAULT NULL, `IS_MULITI_TASK_` smallint NOT NULL COMMENT '多实例任务\r\n1=是\r\n0=否', `PARENT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '父ID', `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例ID', `NODE_PATH_` varchar(1024) NULL DEFAULT NULL COMMENT '节点路径\r\n格式如：\r\n0.1.2.\r\n其中2则为本行记录的主键值', `DEPTH_` smallint NULL DEFAULT NULL COMMENT '节点层', `TASK_TOKEN_` varchar(255) NULL DEFAULT NULL COMMENT '是针对分发任务时，携带的令牌，方便查找其父任务堆栈', `NODE_TYPE_` varchar(255) NULL DEFAULT NULL COMMENT '节点类型', `TARGET_NODE_` varchar(20) NULL DEFAULT NULL COMMENT '驳回时返回节点', `TARGET_TOKEN_` varchar(255) NULL DEFAULT NULL, `INTERPOSE_` smallint NULL DEFAULT NULL COMMENT '是否干预执行', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_EXESTACKHIS_INSTID`(`PROC_INST_ID_` ASC) USING BTREE )COMMENT = '流程执行堆栈树'; -- ---------------------------- -- Records of bpm_exe_stack_his -- ---------------------------- -- ---------------------------- -- Table structure for bpm_exe_stack_relation -- ---------------------------- DROP TABLE IF EXISTS `bpm_exe_stack_relation`; CREATE TABLE `bpm_exe_stack_relation` ( `RELATION_ID_` varchar(64) NOT NULL COMMENT '关系ID', `PROC_INST_ID_` varchar(64) NOT NULL COMMENT '流程实例ID', `FROM_STACK_ID_` varchar(64) NOT NULL COMMENT '来自堆栈ID', `TO_STACK_ID_` varchar(64) NOT NULL COMMENT '到达堆栈ID', `FROM_NODE_ID_` varchar(64) NOT NULL COMMENT '来自节点', `TO_NODE_ID_` varchar(64) NOT NULL COMMENT '到达节点', `RELATION_STATE_` smallint NOT NULL DEFAULT 1 COMMENT '关系状态：1正常，0回收作废', `FROM_NODE_TYPE_` varchar(64) NOT NULL COMMENT '来自的节点类型', `TO_NODE_TYPE_` varchar(64) NOT NULL COMMENT '到达的节点类型', `CREATED_TIME_` datetime NULL DEFAULT NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`RELATION_ID_`) USING BTREE, INDEX `IDX_STACKREL_FROMSTACK`(`FROM_STACK_ID_` ASC) USING BTREE, INDEX `IDX_STACKREL_INSTID`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `IDX_STACKREL_TOSTACK`(`TO_STACK_ID_` ASC) USING BTREE )COMMENT = '堆栈关系表'; -- ---------------------------- -- Records of bpm_exe_stack_relation -- ---------------------------- -- ---------------------------- -- Table structure for bpm_exe_stack_relation_his -- ---------------------------- DROP TABLE IF EXISTS `bpm_exe_stack_relation_his`; CREATE TABLE `bpm_exe_stack_relation_his` ( `RELATION_ID_` varchar(64) NOT NULL COMMENT '关系ID', `PROC_INST_ID_` varchar(64) NOT NULL COMMENT '流程实例ID', `FROM_STACK_ID_` varchar(64) NOT NULL COMMENT '来自堆栈ID', `TO_STACK_ID_` varchar(64) NOT NULL COMMENT '到达堆栈ID', `FROM_NODE_ID_` varchar(64) NOT NULL COMMENT '来自节点', `TO_NODE_ID_` varchar(64) NOT NULL COMMENT '到达节点', `RELATION_STATE_` smallint NOT NULL DEFAULT 1 COMMENT '关系状态：1正常，0回收作废', `FROM_NODE_TYPE_` varchar(64) NOT NULL COMMENT '来自的节点类型', `TO_NODE_TYPE_` varchar(64) NOT NULL COMMENT '到达的节点类型', `CREATED_TIME_` datetime NULL DEFAULT NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`RELATION_ID_`) USING BTREE, INDEX `IDX_STACKRELHIS_FROMSTACK`(`FROM_STACK_ID_` ASC) USING BTREE, INDEX `IDX_STACKRELHIS_INSTID`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `IDX_STACKRELHIS_TOSTACK`(`TO_STACK_ID_` ASC) USING BTREE )COMMENT = '堆栈关系历史表'; -- ---------------------------- -- Records of bpm_exe_stack_relation_his -- ---------------------------- -- ---------------------------- -- Table structure for bpm_extend_class -- ---------------------------- DROP TABLE IF EXISTS `bpm_extend_class`; CREATE TABLE `bpm_extend_class` ( `ID_` varchar(64) NOT NULL, `JAR_ID_` varchar(64) NULL DEFAULT NULL COMMENT '所属jar包id', `SIMPLE_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '类名首字母小写，即beanId', `PATH_` varchar(500) NULL DEFAULT NULL COMMENT '类名全路径', `DESC_` varchar(255) NULL DEFAULT NULL COMMENT '类描述', `MD5_` varchar(255) NULL DEFAULT NULL COMMENT 'MD5版本号', `TYPE_` varchar(1) NULL DEFAULT NULL COMMENT '脚本类型1：条件脚本，2：人员脚本', PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '已发布扩展脚本管理表'; -- ---------------------------- -- Records of bpm_extend_class -- ---------------------------- -- ---------------------------- -- Table structure for bpm_extend_jar -- ---------------------------- DROP TABLE IF EXISTS `bpm_extend_jar`; CREATE TABLE `bpm_extend_jar` ( `ID_` varchar(64) NOT NULL, `NAME_` varchar(255) NULL DEFAULT NULL COMMENT 'jar包名称', `DESC_` varchar(255) NULL DEFAULT NULL COMMENT 'jar包描述', `JAR_FILE_` varchar(2000) NULL DEFAULT NULL COMMENT 'jar包的附件路径', `JAR_BYTES_` longblob NULL COMMENT 'jar包的二进制数据', `CREATE_BY_` varchar(255) NULL DEFAULT NULL COMMENT '上传人id', `CREATE_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '上传人姓名', `UPDATE_BY_` varchar(255) NULL DEFAULT NULL COMMENT '发布人id', `UPDATE_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '发布人姓名', `CREATE_TIME_` datetime NULL DEFAULT NULL COMMENT '创建时间', `UPDATE_TIME_` datetime NULL DEFAULT NULL COMMENT '更新时间', `SIZE_` int NULL DEFAULT NULL COMMENT 'jar包大小(kb)', `STATUS_` int NULL DEFAULT NULL COMMENT 'jar包状态。1：未发布，2：已发布', `TYPE_` int NULL DEFAULT 0 COMMENT 'jar包类型。0：script脚本扩展，1：用户数据同步', PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '扩展jar包管理表'; -- ---------------------------- -- Records of bpm_extend_jar -- ---------------------------- -- ---------------------------- -- Table structure for bpm_flow_collect -- ---------------------------- DROP TABLE IF EXISTS `bpm_flow_collect`; CREATE TABLE `bpm_flow_collect` ( `ID_` varchar(64) NOT NULL COMMENT '主键', `DEF_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '流程定义key', `CREATOR_` varchar(64) NULL DEFAULT NULL COMMENT '创建人ID', `CREATE_TIME_` datetime NULL DEFAULT NULL COMMENT '创建时间', `TENANT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '租户ID', PRIMARY KEY (`ID_`) USING BTREE, UNIQUE INDEX `BPM_FLOW_COLLECT_ID__uindex`(`ID_` ASC) USING BTREE )COMMENT = '流程收藏记录'; -- ---------------------------- -- Records of bpm_flow_collect -- ---------------------------- -- ---------------------------- -- Table structure for bpm_flow_default_button -- ---------------------------- DROP TABLE IF EXISTS `bpm_flow_default_button`; CREATE TABLE `bpm_flow_default_button` ( `ID_` varchar(64) NOT NULL, `NAME_` varchar(64) NOT NULL COMMENT '按钮名称', `ALIAS_` varchar(64) NOT NULL COMMENT '按钮别名', `BEFORESCRIPT_` text NULL COMMENT '前置脚本', `AFTERSCRIPT_` text NULL COMMENT '后置脚本', `GROOVYSCRIPT_` text NULL COMMENT '后台java脚本', `COMPLETEEVENTGROOVYSCRIPT_` text NULL COMMENT '后台完成任务后执行的java脚本', `REJECTMODE_` varchar(64) NULL DEFAULT NULL COMMENT '驳回模式 reject 驳回指定节点 rejectPre 驳回上一步 backToStart 驳回发起人', `REJECTNODE_` varchar(64) NULL DEFAULT NULL COMMENT '指定驳回的节点', `ISLOCK_` int NULL DEFAULT NULL, `SUPPORTSCRIPT_` int NULL DEFAULT NULL COMMENT '是否支持脚本', `MSGCONFIG_` varchar(255) NULL DEFAULT NULL COMMENT '按钮消息配置', `TYPE_` varchar(64) NULL DEFAULT NULL COMMENT '按钮节点类型', `DISABLED_` int NULL DEFAULT NULL COMMENT '启用或者禁用', PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '流程各个节点的按钮初始化'; -- ---------------------------- -- Records of bpm_flow_default_button -- ---------------------------- INSERT INTO `bpm_flow_default_button` VALUES ('1', '启动', 'startFlow', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'start', 0); INSERT INTO `bpm_flow_default_button` VALUES ('10', '签收', 'lockUnlock', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 0, '', 'userTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('11', '保存', 'saveDraft', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'userTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('12', '挂起', 'hangUp', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 0, '', 'userTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('13', '取消挂起', 'cancelHangUp', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 0, '', 'userTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('14', '反对', 'oppose', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'userTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('15', '流转', 'startTrans', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 0, '', 'userTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('16', '加签', 'addSign', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 0, '', 'userTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('17', '终止', 'endProcess', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'userTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('18', '传阅', 'instanceTrans', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 0, '', 'userTask', 1); INSERT INTO `bpm_flow_default_button` VALUES ('19', '驳回发起人', 'backToStart', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'userTask', 1); INSERT INTO `bpm_flow_default_button` VALUES ('2', '保存', 'saveDraft', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 1, NULL, 'start', 0); INSERT INTO `bpm_flow_default_button` VALUES ('20', '同意', 'agree', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 1, NULL, 'signTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('21', '沟通反馈', 'commu', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'signTask', 1); INSERT INTO `bpm_flow_default_button` VALUES ('22', '驳回', 'reject', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 1, NULL, 'signTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('23', '征询', 'inqu', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 0, NULL, 'signTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('24', '转办', 'delegate', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 0, NULL, 'signTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('25', '保存', 'saveDraft', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 1, NULL, 'signTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('26', '反对', 'oppose', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 1, NULL, 'signTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('27', '驳回发起人', 'backToStart', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'signTask', 1); INSERT INTO `bpm_flow_default_button` VALUES ('28', '传阅', 'instanceTrans', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 0, '', 'signTask', 1); INSERT INTO `bpm_flow_default_button` VALUES ('29', '加签', 'addSign', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 0, NULL, 'signTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('3', '同意', 'agree', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'userTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('4', '同意（流转）', 'agreeTrans', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 1, NULL, 'userTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('5', '反对（流转）', 'opposeTrans', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 1, NULL, 'userTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('6', '沟通反馈', 'commu', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'userTask', 1); INSERT INTO `bpm_flow_default_button` VALUES ('7', '驳回', 'reject', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 1, NULL, 'userTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('8', '征询', 'inqu', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 0, NULL, 'userTask', 0); INSERT INTO `bpm_flow_default_button` VALUES ('9', '转办', 'delegate', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 0, NULL, 'userTask', 0); -- ---------------------------- -- Table structure for bpm_flow_mq_log -- ---------------------------- DROP TABLE IF EXISTS `bpm_flow_mq_log`; CREATE TABLE `bpm_flow_mq_log` ( `ID_` varchar(64) NOT NULL COMMENT '主键', `TYPE_` varchar(40) NOT NULL COMMENT '类型', `TITLE_` varchar(300) NULL DEFAULT NULL COMMENT '标题', `CONTENT_` text NULL COMMENT '内容', `STATUS_` int NOT NULL COMMENT '状态', `TRY_TIME_` int NULL DEFAULT NULL COMMENT '重试次数', `EXCEPTION_` varchar(2000) NULL DEFAULT NULL COMMENT '异常信息', `LOG_TIME_` datetime NULL DEFAULT NULL COMMENT '日志记录时间', `TARGET_` varchar(64) NULL DEFAULT NULL COMMENT '日志目标类型', `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '实例ID', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务ID', `OWNER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务所属人id', `OWNER_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '任务所属人姓名', `TENANT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '租户id', `YEARS_PARTITION_` int NULL DEFAULT NULL COMMENT '日志所属年份', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_YEARS_PARTITION_`(`YEARS_PARTITION_` ASC) USING BTREE, INDEX `IDX_PROC_INST_ID_`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `idx_bpm_flow_message_type`(`TYPE_` ASC) USING BTREE )COMMENT = '统一待办推送日志'; -- ---------------------------- -- Records of bpm_flow_mq_log -- ---------------------------- -- ---------------------------- -- Table structure for bpm_form_modify_record -- ---------------------------- DROP TABLE IF EXISTS `bpm_form_modify_record`; CREATE TABLE `bpm_form_modify_record` ( `ID_` varchar(64) NOT NULL, `USER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '修改人id', `USER_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '修改人姓名', `INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例id', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务id', `TASK_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '任务名称', `NODE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '节点id', `MODIFY_TIME_` datetime NULL DEFAULT NULL COMMENT '修改时间', `IP_` varchar(64) NULL DEFAULT NULL COMMENT '修改人ip', `DETAIL_` text NULL COMMENT '修改详情', `REASON_` text NULL COMMENT '修改原因', `BO_ALIAS_` varchar(64) NULL DEFAULT NULL COMMENT 'bo别名', `REF_ID_` varchar(64) NULL DEFAULT NULL COMMENT '外键（表单记录主键）', `DATA_` longtext NULL COMMENT '表单数据', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '表单修改记录表'; -- ---------------------------- -- Records of bpm_form_modify_record -- ---------------------------- -- ---------------------------- -- Table structure for bpm_free_process_def -- ---------------------------- DROP TABLE IF EXISTS `bpm_free_process_def`; CREATE TABLE `bpm_free_process_def` ( `id_` varchar(64) NOT NULL COMMENT '新流程定义ID', `source_def_id_` varchar(64) NULL DEFAULT NULL COMMENT '原流程定义ID', `proc_inst_id_` varchar(255) NULL DEFAULT NULL COMMENT '实例ID', `BPMN_XML_` longtext NULL COMMENT 'xml', `TENANT_ID_` varchar(255) NULL DEFAULT NULL COMMENT '租户ID', PRIMARY KEY (`id_`) USING BTREE )COMMENT = '自由流程定义备份表'; -- ---------------------------- -- Records of bpm_free_process_def -- ---------------------------- -- ---------------------------- -- Table structure for bpm_hr_script -- ---------------------------- DROP TABLE IF EXISTS `bpm_hr_script`; CREATE TABLE `bpm_hr_script` ( `ID_` varchar(64) NOT NULL, `ALIAS_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '脚本的别名', `ALIAS_DESC_` varchar(512) NULL DEFAULT NULL COMMENT '脚本的描叙', `CLASS_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '调用类的路径', `CLASS_INS_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '调用类的对象名', `METHOD_NAME_` varchar(40) NULL DEFAULT NULL COMMENT '调用的方法名', `METHOD_DESC_` varchar(255) NULL DEFAULT NULL COMMENT '调用的方法的描叙', `RETURN_TYPE_` varchar(40) NULL DEFAULT NULL COMMENT '方法返回类型', `ARGUMENT_` varchar(4000) NULL DEFAULT NULL COMMENT '方法相关设置', `ENABLE_` smallint NOT NULL COMMENT '是否有效，有效 1，无效 0', `TYPE_` smallint NULL DEFAULT NULL COMMENT '脚本类型，条件脚本 1，别名脚本 2，人员脚本 3', PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '系统脚本'; -- ---------------------------- -- Records of bpm_hr_script -- ---------------------------- -- ---------------------------- -- Table structure for bpm_inst_delete_log -- ---------------------------- DROP TABLE IF EXISTS `bpm_inst_delete_log`; CREATE TABLE `bpm_inst_delete_log` ( `ID_` varchar(64) NOT NULL, `FULLNAME_` varchar(255) NULL DEFAULT NULL COMMENT '操作人姓名', `ACCOUNT_` varchar(255) NULL DEFAULT NULL COMMENT '操作人账号', `DELETE_TIME_` datetime NULL DEFAULT NULL COMMENT '删除时间', `INST_SUBJECT_` varchar(128) NULL DEFAULT NULL COMMENT '删除流程实例对象', `CONTENT_` varchar(550) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '流程实例删除日志'; -- ---------------------------- -- Records of bpm_inst_delete_log -- ---------------------------- -- ---------------------------- -- Table structure for bpm_inst_form -- ---------------------------- DROP TABLE IF EXISTS `bpm_inst_form`; CREATE TABLE `bpm_inst_form` ( `ID_` varchar(64) NOT NULL, `DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程定义id', `INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例id', `FORM_VALUE_` varchar(255) NULL DEFAULT NULL COMMENT '表单 inner 记录id frame 记录formValue', `NODE_ID_` varchar(255) NULL DEFAULT NULL COMMENT '节点id', `FORM_TYPE_` varchar(64) NULL DEFAULT NULL COMMENT '表单类型 pc mobile', `FORM_CATEGORY_` varchar(64) NULL DEFAULT NULL COMMENT 'url表单 frame 在线表单 inner', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_INST_FORM_INSTID`(`INST_ID_` ASC) USING BTREE )COMMENT = '记录流程启动时，节点使用的表单'; -- ---------------------------- -- Records of bpm_inst_form -- ---------------------------- -- ---------------------------- -- Table structure for bpm_interpose_recored -- ---------------------------- DROP TABLE IF EXISTS `bpm_interpose_recored`; CREATE TABLE `bpm_interpose_recored` ( `ID_` varchar(64) NOT NULL, `PROC_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程定义ID', `PROC_INST_ID_` varchar(64) NOT NULL COMMENT '流程实例ID', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务ID', `TASK_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '任务名称', `AUDITOR_` varchar(64) NULL DEFAULT NULL COMMENT '执行人ID', `AUDITOR_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '执行人名', `OPINION_` varchar(2000) NULL DEFAULT NULL, `STATUS_` varchar(40) NOT NULL COMMENT '干预动作', `CREATE_TIME_` datetime NULL DEFAULT NULL, `COMPLETE_TIME_` datetime NULL DEFAULT NULL, `DUR_MS_` int NULL DEFAULT NULL COMMENT '持续时间(ms)', `FILES_` varchar(2000) NULL DEFAULT NULL, `IS_DONE_` varchar(4000) NULL DEFAULT NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_INTERPOSE_INSTID`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `IDX_INTERPOSE_TASK`(`TASK_ID_` ASC) USING BTREE )COMMENT = '流程干预记录表'; -- ---------------------------- -- Records of bpm_interpose_recored -- ---------------------------- -- ---------------------------- -- Table structure for bpm_meetingroom -- ---------------------------- DROP TABLE IF EXISTS `bpm_meetingroom`; CREATE TABLE `bpm_meetingroom` ( `ID_` varchar(64) NOT NULL, `NAME_` varchar(100) NULL DEFAULT NULL COMMENT '会议室名称', `NEED_PENDING_` smallint NULL DEFAULT NULL COMMENT '是否需要审批', `PENDING_USER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '审批人ID', `PENDING_USER_NAME_` varchar(100) NULL DEFAULT NULL COMMENT '审批人', `SUPPORT_SERVICE_` varchar(500) NULL DEFAULT NULL COMMENT '支持的服务', `LOCATION_` varchar(300) NULL DEFAULT NULL COMMENT '会议室地址', `CAPACITY_` int NULL DEFAULT NULL COMMENT '会议室容量', `MEMO_` varchar(600) NULL DEFAULT NULL COMMENT '会议室备注', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '会议室'; -- ---------------------------- -- Records of bpm_meetingroom -- ---------------------------- -- ---------------------------- -- Table structure for bpm_meetingroom_appointment -- ---------------------------- DROP TABLE IF EXISTS `bpm_meetingroom_appointment`; CREATE TABLE `bpm_meetingroom_appointment` ( `ID_` varchar(64) NOT NULL, `MEETINGROOM_ID_` varchar(64) NULL DEFAULT NULL, `MEETING_ID_` varchar(64) NULL DEFAULT NULL COMMENT '会议id', `MEETING_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '会议名称', `HOSTESS_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '主持人姓名', `APPOINTMENT_BEG_TIME_` datetime NULL DEFAULT NULL, `APPOINTMENT_END_TIME_` datetime NULL DEFAULT NULL, `APPOINTMENT_STATUS_` int NULL DEFAULT NULL COMMENT '预约状态', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_MR_MEETINGROOM`(`MEETINGROOM_ID_` ASC) USING BTREE, INDEX `IDX_MR_PROINSTANCE`(`MEETING_ID_` ASC) USING BTREE )COMMENT = '会议室预约'; -- ---------------------------- -- Records of bpm_meetingroom_appointment -- ---------------------------- -- ---------------------------- -- Table structure for bpm_message_type -- ---------------------------- DROP TABLE IF EXISTS `bpm_message_type`; CREATE TABLE `bpm_message_type` ( `ID_` varchar(64) NOT NULL, `CLASSIFICATION_CODE_` varchar(100) NULL DEFAULT NULL COMMENT '分类名称', `CREATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '创建人', `CREATE_TIME_` datetime NULL DEFAULT NULL, `CREATE_ORG_ID_` varchar(64) NULL DEFAULT NULL, `UPDATE_BY_` varchar(64) NULL DEFAULT NULL, `UPDATE_TIME_` datetime NULL DEFAULT NULL, `IS_PENDING_` smallint NULL DEFAULT NULL COMMENT '是否需要审批', `PENDING_USER_ID_` varchar(100) NULL DEFAULT NULL COMMENT '审批人id', `PENDING_USER_NAME_` varchar(200) NULL DEFAULT NULL COMMENT '审批人姓名', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '分类管理'; -- ---------------------------- -- Records of bpm_message_type -- ---------------------------- -- ---------------------------- -- Table structure for bpm_mobile_category -- ---------------------------- DROP TABLE IF EXISTS `bpm_mobile_category`; CREATE TABLE `bpm_mobile_category` ( `ID_` varchar(64) NOT NULL COMMENT '主键', `DEF_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '流程定义key', `TYPE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '分类ID', `TYPE_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '分类key', `DEF_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '流程定义名称', `CREATOR_` varchar(64) NULL DEFAULT NULL COMMENT '创建人', `CREATE_TIME_` datetime NULL DEFAULT NULL COMMENT '创建时间', `UPDATE_TIME_` datetime NULL DEFAULT NULL COMMENT '更新时间', `TENANT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '租户ID', PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '移动端流程分类表'; -- ---------------------------- -- Records of bpm_mobile_category -- ---------------------------- -- ---------------------------- -- Table structure for bpm_multi_script -- ---------------------------- DROP TABLE IF EXISTS `bpm_multi_script`; CREATE TABLE `bpm_multi_script` ( `ID_` varchar(64) NOT NULL, `ALIAS_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '脚本的别名', `ALIAS_DESC_` varchar(512) NULL DEFAULT NULL COMMENT '脚本的描叙', `CLASS_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '调用类的路径', `CLASS_INS_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '调用类的对象名', `METHOD_NAME_` varchar(40) NULL DEFAULT NULL COMMENT '调用的方法名', `METHOD_DESC_` varchar(1000) NULL DEFAULT NULL, `RETURN_TYPE_` varchar(40) NULL DEFAULT NULL COMMENT '方法返回类型', `ARGUMENT_` varchar(4000) NULL DEFAULT NULL COMMENT '方法相关设置', `ENABLE_` smallint NOT NULL COMMENT '是否有效，有效 1，无效 0', `TYPE_` smallint NULL DEFAULT NULL COMMENT '脚本类型，条件脚本 1，别名脚本 2，人员脚本 3', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_MULTISCRIPT_ALIASNAME`(`ALIAS_NAME_` ASC) USING BTREE )COMMENT = '系统脚本'; -- ---------------------------- -- Records of bpm_multi_script -- ---------------------------- INSERT INTO `bpm_multi_script` VALUES ('1', NULL, NULL, 'com.hotent.runtime.script.UserScript', 'userScript', 'getRoleByAlias', '根据角色别名获取角色列表', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"角色别名\",\"paraCt\":\"base:role-selector\",\"paraCtBindName\":\"code\",\"paraCtBindKey\":\"code\",\"multiSelect\":false}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('10', NULL, NULL, 'com.hotent.runtime.script.UserRelScript', 'userRelScript', 'getUpChargesByOrgId', '获取上级组织负责人(包含主负责人)或主负责人', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"组织ID\",\"paraCt\":\"base:org-selector\",\"paraCtBindName\":\"组织ID\",\"paraCtBindKey\":\"id\",\"multiSelect\":false,\"$$hashKey\":\"object:3067\"},{\"paraName\":\"arg1\",\"paraType\":\"java.lang.Boolean\",\"paraDesc\":\"是否主负责人(值为true或false)\",\"paraCt\":null,\"paraCtBindName\":\"\",\"paraCtBindKey\":null,\"multiSelect\":false,\"$$hashKey\":\"object:3068\"}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('11', NULL, NULL, 'com.hotent.runtime.script.UserRelScript', 'userRelScript', 'getChargesByPreNode', '获取上一节点执行人的部门负责人(主组织)', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.Boolean\",\"paraDesc\":\"是否主负责人(值为true或false)\",\"paraCt\":\"\"},{\"paraName\":\"arg1\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"传维度id或编码都可以 \"}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('12', NULL, NULL, 'com.hotent.runtime.script.UserRelScript', 'userRelScript', 'getByRelPreNode', '通过上一节点执行人获取汇报线上级 人员列表', 'java.util.Set', '[{\"paraName\":\"arg1\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"汇报线类型编码\",\"paraCt\":\"\",\"paraCtBindName\":\"ID_\",\"paraCtBindKey\":\"\",\"multiSelect\":false}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('13', NULL, NULL, 'com.hotent.runtime.script.UserRelScript', 'userRelScript', 'getByRelStartUser', '通过发起人获取汇报线上级 人员列表', 'java.util.Set', '[{\"paraName\":\"arg1\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"汇报线类型编码\",\"paraCt\":\"\",\"paraCtBindName\":\"ID_\",\"paraCtBindKey\":\"\",\"multiSelect\":false}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('1318030354614980608', NULL, NULL, 'com.hotent.runtime.script.UserScript', 'userScript', 'getUserFromSubData', '从子表数据中提取节点审批人(固定值生效)', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"业务对象别名\"},{\"paraName\":\"arg1\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"子表别名（sub_)\"},{\"paraName\":\"arg2\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"用户帐号字段\"}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('1338367741324824576', NULL, NULL, 'com.hotent.runtime.script.UserScript', 'userScript', 'getByCompanyRole', '找这个组织底下拥有这个角色的人员', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"组织别名\",\"paraCt\":\"base:org-selector\",\"paraCtBindKey\":\"code\"},{\"paraName\":\"arg1\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"角色别名\",\"paraCt\":\"base:role-selector\",\"paraCtBindKey\":\"code\"}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('1338375124944031744', NULL, NULL, 'com.hotent.runtime.script.UserScript', 'userScript', 'getLeaderStep', '获取逐级审批(获取主负责人)', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.Integer\",\"paraDesc\":\"级别\"},{\"paraName\":\"arg1\",\"paraType\":\"boolean\",\"paraDesc\":\"是否需要上级（true，false）\"}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('1338377219818524672', NULL, NULL, 'com.hotent.runtime.script.UserScript', 'userScript', 'getUserById', '根据ID获取审批人', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"ID\"}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('1338379764150439936', NULL, NULL, 'com.hotent.runtime.script.UserRelScript', 'userRelScript', 'getUserFromBusSql', 'sql查询用户ID(固定值SQL要用\" \"包裹)', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"查询SQL，返回结果只有一列\"}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('1338381406014935040', NULL, NULL, 'com.hotent.runtime.script.UserScript', 'userScript', 'getLeaderStepByOrgId', '根据组织ID获取逐级审批', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"组织ID\",\"paraCt\":\"base:org-selector\",\"paraCtBindKey\":\"id\"},{\"paraName\":\"arg1\",\"paraType\":\"java.lang.Integer\",\"paraDesc\":\"组织级别\"}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('16', NULL, NULL, 'com.hotent.runtime.script.OrgScript', 'orgScript', 'getChargesByPOrg', '获取上一节点用户的上级部门（主）的负责人(主组织生效)', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.Boolean\",\"paraDesc\":\"是否主负责人(值为true或false)\",\"paraCt\":\"null\",\"$$hashKey\":\"object:2340\",\"multiSelect\":false},{\"paraName\":\"arg1\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"维度编码（不传为默认维度）\",\"multiSelect\":false,\"paraCt\":\"base:dem-selector\",\"paraCtBindKey\":\"code\",\"paraCtBindName\":\"code\"}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('17', NULL, NULL, 'com.hotent.runtime.script.OrgScript', 'orgScript', 'getChargesByStartPOrg', '获取发起人的上级部门的（主）负责人', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.Boolean\",\"paraDesc\":\"是否主负责人(值为true或false)\",\"paraCt\":\"\",\"$$hashKey\":\"object:1955\",\"multiSelect\":false},{\"paraName\":\"arg1\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"维度编码（不传为默认维度）\",\"multiSelect\":false,\"paraCt\":\"base:dem-selector\",\"paraCtBindKey\":\"code\",\"paraCtBindName\":\"code\"}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('18', NULL, NULL, 'com.hotent.runtime.script.OrgScript', 'orgScript', 'getChargesByOrg', '获取上一点节用户所在部门的（主）负责人', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"boolean\",\"paraDesc\":\"是否主负责人(值为true或false)\",\"paraCt\":\"\",\"$$hashKey\":\"object:1387\",\"multiSelect\":false},{\"paraName\":\"arg1\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"维度编码（不传为默认维度）\",\"multiSelect\":false,\"paraCt\":\"base:dem-selector\",\"paraCtBindKey\":\"code\",\"paraCtBindName\":\"code\"}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('19', NULL, NULL, 'com.hotent.runtime.script.OrgScript', 'orgScript', 'getChargesByStartOrg', '获取发起人所在部门的（主）负责人', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.Boolean\",\"paraDesc\":\"是否主负责人(值为true或false)\",\"paraCt\":\"null\",\"$$hashKey\":\"object:1002\",\"multiSelect\":false},{\"paraName\":\"arg1\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"维度编码（不传为默认维度）\",\"multiSelect\":false,\"paraCt\":\"base:dem-selector\",\"paraCtBindKey\":\"code\",\"paraCtBindName\":\"code\"}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('2', NULL, NULL, 'com.hotent.runtime.script.UserScript', 'userScript', 'getOrgById', '根据组织id查询组织作为候选处理人（不抽取）', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"组织编码\",\"paraCt\":\"base:org-selector\",\"paraCtBindName\":\"id_\",\"paraCtBindKey\":\"id\",\"multiSelect\":false,\"$$hashKey\":\"object:645\"}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('20', NULL, NULL, 'com.hotent.runtime.script.OrgScript', 'orgScript', 'getByOrgRelDefCode', '通过职务编码和组织编码查询用户', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"组织编码\",\"paraCt\":\"base:org-selector\",\"paraCtBindName\":\"code\",\"paraCtBindKey\":\"code\",\"multiSelect\":false},{\"paraName\":\"arg1\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"职务编码\",\"paraCt\":\"base:job-selector\",\"paraCtBindName\":\"code\",\"paraCtBindKey\":\"code\",\"multiSelect\":false}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('22', NULL, NULL, 'com.hotent.runtime.script.OrgScript', 'orgScript', 'getMasterFromUnder', '通过下属管理获取上一节点用户的上级', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"维度id或编码\",\"multiSelect\":false,\"paraCt\":\"base:dem-selector\",\"paraCtBindKey\":\"id\",\"paraCtBindName\":\"id\"}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('3', NULL, NULL, 'com.hotent.runtime.script.BpmUserScript', 'bpmUserScript', 'getListUserByRelCode', '根据岗位编码获取人员列表', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"岗位编码\",\"paraCt\":\"base:pos-selector\",\"paraCtBindName\":\"code\",\"paraCtBindKey\":\"code\",\"multiSelect\":false}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('4', NULL, NULL, 'com.hotent.runtime.script.UserScript', 'userScript', 'getMainByOrgId', '获取该组织中为主组织的人员列表', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"组织ID\",\"paraCt\":\"base:org-selector\",\"paraCtBindName\":\"id_\",\"paraCtBindKey\":\"id\",\"multiSelect\":false,\"$$hashKey\":\"object:3514\"}]', 1, 2, '-1'); INSERT INTO `bpm_multi_script` VALUES ('9', NULL, NULL, 'com.hotent.runtime.script.UserRelScript', 'userRelScript', 'getChargesByOrgId', '获取组织负责人(包含主负责人)或主负责人', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"组织ID\",\"paraCt\":\"base:org-selector\",\"paraCtBindName\":\"ID_\",\"paraCtBindKey\":\"id\",\"multiSelect\":false},{\"paraName\":\"arg1\",\"paraType\":\"java.lang.Boolean\",\"paraDesc\":\"是否主负责人(值为true或false)\",\"paraCt\":null,\"paraCtBindName\":\"\",\"paraCtBindKey\":null,\"multiSelect\":false,\"$$hashKey\":\"object:2506\"}]', 1, 2, '-1'); -- ---------------------------- -- Table structure for bpm_node_setting -- ---------------------------- DROP TABLE IF EXISTS `bpm_node_setting`; CREATE TABLE `bpm_node_setting` ( `ID_` varchar(255) NOT NULL COMMENT '主键', `CREATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '创建人ID', `CREATE_TIME_` datetime NULL DEFAULT NULL COMMENT '创建时间', `CREATE_ORG_ID_` varchar(64) NULL DEFAULT NULL COMMENT '创建者所属组织ID', `UPDATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '更新人ID', `UPDATE_TIME_` datetime NULL DEFAULT NULL COMMENT '更新时间', `TENANT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '租户ID', `NODE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '节点id', `DEF_ID` varchar(64) NULL DEFAULT NULL COMMENT '流程定义id', `FORECAST_` int NULL DEFAULT NULL COMMENT '审批预测值(1为同意,2为反对,默认为1)', PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '流程定义节点设置表'; -- ---------------------------- -- Records of bpm_node_setting -- ---------------------------- -- ---------------------------- -- Table structure for bpm_often_flow -- ---------------------------- DROP TABLE IF EXISTS `bpm_often_flow`; CREATE TABLE `bpm_often_flow` ( `ID_` varchar(64) NOT NULL, `DEF_KEY_` varchar(64) NOT NULL COMMENT '流程定义KEY', `USER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '所属人id。-1为所有人都有权限', `USER_NAME_` varchar(128) NULL DEFAULT NULL, `ORDER_` smallint NULL DEFAULT NULL COMMENT '排序号', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_OFTENFLOW_DEFKEY`(`DEF_KEY_` ASC) USING BTREE, INDEX `IDX_OFTENFLOW_USERID`(`USER_ID_` ASC) USING BTREE )COMMENT = '通用流程'; -- ---------------------------- -- Records of bpm_often_flow -- ---------------------------- -- ---------------------------- -- Table structure for bpm_often_flow_user -- ---------------------------- DROP TABLE IF EXISTS `bpm_often_flow_user`; CREATE TABLE `bpm_often_flow_user` ( `ID_` varchar(64) NOT NULL COMMENT '主键', `OFTEN_FLOW_ID_` varchar(64) NULL DEFAULT NULL COMMENT '常用流程表主键ID', `OWNER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '授权对象ID', `OWNER_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '授权对象名称', `RIGHT_TYPE_` varchar(20) NULL DEFAULT NULL COMMENT '授权对象类型(角色,用户,岗位等)', `TENANT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '租户ID', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_OFTENFLOWUSER_OFTENFLOWID`(`OFTEN_FLOW_ID_` ASC) USING BTREE )COMMENT = '常用流程授权对象表'; -- ---------------------------- -- Records of bpm_often_flow_user -- ---------------------------- -- ---------------------------- -- Table structure for bpm_print_record -- ---------------------------- DROP TABLE IF EXISTS `bpm_print_record`; CREATE TABLE `bpm_print_record` ( `ID_` varchar(64) NOT NULL COMMENT '主键', `PROC_DEF_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '流程定义KEY', `PROC_DEF_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '流程定义名称', `PROC_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程定义ID', `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例ID', `NODE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程节点ID', `FORM_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '表单key', `TEMPLATE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '打印模板ID', `TEMPLATE_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '打印模板名称', `FILE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '打印文件id', `LAST_VERSION_` int NULL DEFAULT 0 COMMENT '是否最后的版本（1：是，0：否）', `CREATE_BY_` varchar(64) NULL DEFAULT NULL, `CREATE_ORG_ID_` varchar(64) NULL DEFAULT NULL, `CREATE_TIME_` datetime NULL DEFAULT NULL, `UPDATE_BY_` varchar(64) NULL DEFAULT NULL, `UPDATE_TIME_` datetime NULL DEFAULT NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '租户ID', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_PRINTRECORD_PROCINSTID`(`PROC_INST_ID_` ASC) USING BTREE )COMMENT = '流程打印文件管理表'; -- ---------------------------- -- Records of bpm_print_record -- ---------------------------- -- ---------------------------- -- Table structure for bpm_pro_bo -- ---------------------------- DROP TABLE IF EXISTS `bpm_pro_bo`; CREATE TABLE `bpm_pro_bo` ( `ID_` varchar(64) NOT NULL, `PROCESS_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程ID', `PROCESS_KEY_` varchar(128) NULL DEFAULT NULL COMMENT '流程KEY', `BO_CODE_` varchar(128) NULL DEFAULT NULL COMMENT '业务对象CODE', `BO_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '业务对象名称', `CREATOR_ID_` varchar(64) NULL DEFAULT NULL COMMENT '创建人', `CREATE_TIME_` datetime NULL DEFAULT NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_PROBO_PROCESSID`(`PROCESS_ID_` ASC) USING BTREE, INDEX `IDX_PROBO_BOCODE`(`BO_CODE_` ASC) USING BTREE )COMMENT = '流程业务对象设置表'; -- ---------------------------- -- Records of bpm_pro_bo -- ---------------------------- -- ---------------------------- -- Table structure for bpm_pro_cpto -- ---------------------------- DROP TABLE IF EXISTS `bpm_pro_cpto`; CREATE TABLE `bpm_pro_cpto` ( `ID_` varchar(64) NOT NULL, `INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例ID', `BPMN_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT 'ACT实例ID', `NODE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '节点ID', `CREATE_TIME_` datetime NULL DEFAULT NULL, `OPINION_` varchar(1500) NULL DEFAULT NULL COMMENT '意见', `SUBJECT_` varchar(128) NULL DEFAULT NULL COMMENT '流程实例标题', `TYPE_` varchar(20) NULL DEFAULT NULL COMMENT '抄送类型(copyto抄送,trans转发)', `STARTOR_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程发起人', `TYPE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程分类', `STARTOR_` varchar(64) NULL DEFAULT NULL COMMENT '创建人', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_PROCPTO_INSTID`(`INST_ID_` ASC) USING BTREE, INDEX `IDX_PROCPTO_START`(`STARTOR_ID_` ASC) USING BTREE )COMMENT = '流程实例抄送'; -- ---------------------------- -- Records of bpm_pro_cpto -- ---------------------------- -- ---------------------------- -- Table structure for bpm_pro_inst -- ---------------------------- DROP TABLE IF EXISTS `bpm_pro_inst`; CREATE TABLE `bpm_pro_inst` ( `ID_` varchar(64) NOT NULL, `SUBJECT_` varchar(256) NULL DEFAULT NULL, `PROC_DEF_ID_` varchar(64) NOT NULL COMMENT '流程定义ID', `BPMN_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT 'BPMN流程定义ID', `PROC_DEF_KEY_` varchar(128) NULL DEFAULT NULL COMMENT '流程定义Key', `PROC_DEF_NAME_` varchar(128) NOT NULL COMMENT '流程名称', `BIZ_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '业务主键', `SYS_CODE_` varchar(64) NULL DEFAULT NULL COMMENT '业务系统编码', `FORM_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '绑定的表单主键', `STATUS_` varchar(40) NULL DEFAULT NULL COMMENT '实例状态', `END_TIME_` datetime NULL DEFAULT NULL, `DURATION_` bigint NULL DEFAULT NULL COMMENT '持续时间(ms)', `TYPE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '所属分类ID', `RESULT_TYPE_` varchar(40) NULL DEFAULT NULL COMMENT '流程结束后的最终审批结果，agree=同意；refuse=拒绝', `BPMN_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT 'BPMN流程实例ID', `CREATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '创建人ID', `CREATE_TIME_` datetime NULL DEFAULT NULL, `CREATE_ORG_ID_` varchar(64) NULL DEFAULT NULL COMMENT '创建者所属组织ID', `UPDATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '更新人ID', `UPDATE_TIME_` datetime NULL DEFAULT NULL, `IS_FORMMAL_` char(1) NOT NULL COMMENT '是否正式数据', `PARENT_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '父实例Id', `IS_FORBIDDEN_` smallint NULL DEFAULT NULL COMMENT '禁止', `DATA_MODE_` varchar(20) NULL DEFAULT NULL COMMENT '业务数据存储模式。\r\npk:主键\r\nbo:业务对象', `CREATOR_` varchar(64) NULL DEFAULT NULL COMMENT '创建人', `SUPPORT_MOBILE_` int NULL DEFAULT 0 COMMENT '支持手机端', `SUPER_NODE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '子流程节点的ID', `IS_DELE_` int NOT NULL DEFAULT 0 COMMENT '是否已删，1已删除，0未删除', `URGENT_STATE_` varchar(64) NULL DEFAULT NULL COMMENT '紧急状态', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, `MOBILE_INST_URL_` varchar(200) NULL DEFAULT NULL COMMENT '手机端实例地址', `PC_INST_URL_` varchar(200) NULL DEFAULT NULL COMMENT 'pc端实例地址', `CREATE_ORG_PATH_` text NULL, `CREATE_ACCOUNT_` varchar(64) NULL DEFAULT NULL COMMENT '流程发起人账号', PRIMARY KEY (`ID_`) USING BTREE, UNIQUE INDEX `IDX_PRO_INST_BPMNINSTID`(`BPMN_INST_ID_` ASC) USING BTREE, INDEX `IDX_PRO_INST_PROCDEFKEY`(`PROC_DEF_KEY_` ASC) USING BTREE, INDEX `IDX_PRO_INST_PROCDEFID`(`PROC_DEF_ID_` ASC) USING BTREE )COMMENT = '流程实例'; -- ---------------------------- -- Records of bpm_pro_inst -- ---------------------------- -- ---------------------------- -- Table structure for bpm_pro_inst_hi -- ---------------------------- DROP TABLE IF EXISTS `bpm_pro_inst_hi`; CREATE TABLE `bpm_pro_inst_hi` ( `ID_` varchar(64) NOT NULL, `SUBJECT_` varchar(128) NOT NULL COMMENT '流程实例标题', `PROC_DEF_ID_` varchar(64) NOT NULL COMMENT '流程定义ID', `BPMN_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT 'BPMN流程定义ID', `PROC_DEF_KEY_` varchar(128) NULL DEFAULT NULL COMMENT '流程定义Key', `PROC_DEF_NAME_` varchar(128) NOT NULL COMMENT '流程名称', `BIZ_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '关联数据业务主键', `SYS_CODE_` varchar(64) NULL DEFAULT NULL COMMENT '业务系统编码', `FORM_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '绑定的表单主键', `STATUS_` varchar(40) NULL DEFAULT NULL COMMENT '实例状态', `END_TIME_` datetime NULL DEFAULT NULL, `DURATION_` bigint NULL DEFAULT NULL COMMENT '持续时间', `TYPE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '所属分类ID', `RESULT_TYPE_` varchar(40) NULL DEFAULT NULL COMMENT '流程结束后的最终审批结果，agree=同意；refuse=拒绝', `BPMN_INST_ID_` varchar(64) NOT NULL COMMENT 'BPMN流程实例ID', `CREATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '创建人ID', `CREATE_TIME_` datetime NULL DEFAULT NULL, `CREATE_ORG_ID_` varchar(64) NULL DEFAULT NULL COMMENT '创建者所属组织ID', `UPDATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '更新人ID', `UPDATE_TIME_` datetime NULL DEFAULT NULL, `IS_FORMMAL_` char(1) NOT NULL COMMENT '是否正式数据 0非正式,1正式', `PARENT_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '父实例Id', `IS_FORBIDDEN_` smallint NULL DEFAULT NULL, `DATA_MODE_` varchar(20) NULL DEFAULT NULL, `CREATOR_` varchar(64) NULL DEFAULT NULL COMMENT '创建人', `SUPPORT_MOBILE_` int NULL DEFAULT 0 COMMENT '支持手机端', `SUPER_NODE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '子流程节点ID', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, `MOBILE_INST_URL_` varchar(200) NULL DEFAULT NULL COMMENT '手机端实例地址', `PC_INST_URL_` varchar(200) NULL DEFAULT NULL COMMENT 'pc端实例地址', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_PROINSTHI_BIZKEY`(`BIZ_KEY_` ASC) USING BTREE, INDEX `IDX_PROINSTHI_BPMINSTID`(`BPMN_INST_ID_` ASC) USING BTREE, INDEX `IDX_PROINSTHI_PARENTID`(`PARENT_INST_ID_` ASC) USING BTREE )COMMENT = '流程实例历史'; -- ---------------------------- -- Records of bpm_pro_inst_hi -- ---------------------------- -- ---------------------------- -- Table structure for bpm_pro_inst_status -- ---------------------------- DROP TABLE IF EXISTS `bpm_pro_inst_status`; CREATE TABLE `bpm_pro_inst_status` ( `ID_` varchar(64) NOT NULL, `KEY_` varchar(255) NULL DEFAULT NULL COMMENT '流程实例状态', `VALUE_` varchar(255) NULL DEFAULT NULL COMMENT '流程实例状态对应的排序号', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_PROINSTSTATUS_KEY`(`KEY_` ASC) USING BTREE )COMMENT = '流程实例状态排序表'; -- ---------------------------- -- Records of bpm_pro_inst_status -- ---------------------------- INSERT INTO `bpm_pro_inst_status` VALUES ('1', 'draft', '1'); INSERT INTO `bpm_pro_inst_status` VALUES ('2', 'revoke', '2'); INSERT INTO `bpm_pro_inst_status` VALUES ('3', 'back', '3'); INSERT INTO `bpm_pro_inst_status` VALUES ('4', 'backToStart', '4'); INSERT INTO `bpm_pro_inst_status` VALUES ('5', 'running', '5'); INSERT INTO `bpm_pro_inst_status` VALUES ('6', 'manualend', '6'); INSERT INTO `bpm_pro_inst_status` VALUES ('7', 'end', '7'); -- ---------------------------- -- Table structure for bpm_pro_publicity_read -- ---------------------------- DROP TABLE IF EXISTS `bpm_pro_publicity_read`; CREATE TABLE `bpm_pro_publicity_read` ( `ID_` varchar(64) NOT NULL, `PROC_INST_ID_` varchar(64) NOT NULL COMMENT '实例id', `USER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '用户id', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `PROC_INST_ID_`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `IDX_USER_ID`(`USER_ID_` ASC) USING BTREE )COMMENT = '流程公示阅读记录'; -- ---------------------------- -- Records of bpm_pro_publicity_read -- ---------------------------- -- ---------------------------- -- Table structure for bpm_pro_status -- ---------------------------- DROP TABLE IF EXISTS `bpm_pro_status`; CREATE TABLE `bpm_pro_status` ( `ID_` varchar(64) NOT NULL, `PROC_INST_ID_` varchar(64) NOT NULL COMMENT '流程实例ID', `PROC_DEF_ID_` varchar(64) NOT NULL COMMENT 'ACT流程定义ID', `NODE_ID_` varchar(255) NOT NULL COMMENT '节点ID', `NODE_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '节点名称', `STATUS_` varchar(50) NOT NULL COMMENT '状态', `LAST_UPDATE_` datetime NULL DEFAULT NULL, `LAST_USERID_` varchar(64) NULL DEFAULT NULL COMMENT '最后更新人', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, `RECYCLE_NODE_` varchar(2) NULL DEFAULT NULL COMMENT '驳回按流程图执行回收的节点 0默认值 1因为驳回按照流程图执行目标节点之后的节点为1，如果重新运行到该节点变为0', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_PROSTATUS_INSTID`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `IDX_PROSTATUS_NODEID`(`NODE_ID_` ASC) USING BTREE )COMMENT = '流程节点审批状态'; -- ---------------------------- -- Records of bpm_pro_status -- ---------------------------- -- ---------------------------- -- Table structure for bpm_pro_status_hi -- ---------------------------- DROP TABLE IF EXISTS `bpm_pro_status_hi`; CREATE TABLE `bpm_pro_status_hi` ( `ID_` varchar(64) NOT NULL, `PROC_INST_ID_` varchar(64) NOT NULL COMMENT '流程实例ID', `PROC_DEF_ID_` varchar(64) NOT NULL COMMENT 'ACT流程定义ID', `NODE_ID_` varchar(255) NOT NULL COMMENT '节点ID', `NODE_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '节点名称', `STATUS_` varchar(50) NOT NULL COMMENT '状态', `LAST_UPDATE_` datetime NULL DEFAULT NULL, `LAST_USERID_` varchar(64) NULL DEFAULT NULL COMMENT '最后更新人', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_PROSTATUSHI_INSTID`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `IDX_PROSTATUSHI_NODEID`(`NODE_ID_` ASC) USING BTREE )COMMENT = '流程节点审批历史状态'; -- ---------------------------- -- Records of bpm_pro_status_hi -- ---------------------------- -- ---------------------------- -- Table structure for bpm_read_record -- ---------------------------- DROP TABLE IF EXISTS `bpm_read_record`; CREATE TABLE `bpm_read_record` ( `ID_` varchar(255) NOT NULL, `PROC_DEF_ID_` varchar(255) NULL DEFAULT NULL COMMENT '流程定义ID', `SUP_INST_ID_` varchar(255) NULL DEFAULT NULL COMMENT '父流程实例ID', `PROC_INST_ID_` varchar(255) NULL DEFAULT NULL COMMENT '流程实例ID', `TASK_ID_` varchar(255) NULL DEFAULT NULL COMMENT '任务ID', `TASK_KEY_` varchar(255) NULL DEFAULT NULL COMMENT '任务定义Key', `TASK_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '任务名称', `READER_` varchar(255) NULL DEFAULT NULL COMMENT '阅读人ID', `READER_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '阅读人名', `READ_TIME_` datetime NULL DEFAULT NULL, `ORG_ID_` varchar(255) NULL DEFAULT NULL COMMENT '组织id', `ORG_PATH_` varchar(255) NULL DEFAULT NULL COMMENT '组织名称', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_READRECORD_PROCINSTID`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `IDX_READRECORD_TASKID`(`TASK_ID_` ASC) USING BTREE, INDEX `IDX_READRECORD_TASKKEY`(`TASK_KEY_` ASC) USING BTREE )COMMENT = '任务阅读记录表'; -- ---------------------------- -- Records of bpm_read_record -- ---------------------------- -- ---------------------------- -- Table structure for bpm_reminder_history -- ---------------------------- DROP TABLE IF EXISTS `bpm_reminder_history`; CREATE TABLE `bpm_reminder_history` ( `ID_` varchar(64) NOT NULL, `INST_ID_` varchar(255) NULL DEFAULT NULL COMMENT '流程实例ID', `ISNT_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '流程实例标题', `NODE_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '节点名称', `NODE_ID_` varchar(255) NULL DEFAULT NULL COMMENT '节点ID', `EXECUTE_DATE_` datetime NULL DEFAULT NULL COMMENT '执行时间', `REMIND_TYPE_` varchar(255) NULL DEFAULT NULL COMMENT '执行类型', `USER_ID_` varchar(255) NULL DEFAULT NULL COMMENT '说明', `NOTE_` varchar(255) NULL DEFAULT NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL, `TASK_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_REMINDER_TASKID`(`TASK_ID_` ASC) USING BTREE )COMMENT = '催办历史'; -- ---------------------------- -- Records of bpm_reminder_history -- ---------------------------- -- ---------------------------- -- Table structure for bpm_report_act -- ---------------------------- DROP TABLE IF EXISTS `bpm_report_act`; CREATE TABLE `bpm_report_act` ( `ID_` varchar(64) NOT NULL, `REPORT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '报表主表ID', `BPM_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程定义ID', `REPORT_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '报表名称', `DIMENSION_ID_` varchar(255) NULL DEFAULT NULL COMMENT '组织维度id', `GRADE_` varchar(255) NULL DEFAULT NULL COMMENT '统计级别', `PARAMS_` varchar(255) NULL DEFAULT NULL COMMENT '统计参数', `RIGHT_CONTENT_` varchar(255) NULL DEFAULT NULL COMMENT '授权内容(报表类型显示)', `IS_DEFAULT_` varchar(64) NULL DEFAULT NULL COMMENT '默认显示视图(1：柱状图，2：饼图)', `X_AXIS_` varchar(255) NULL DEFAULT NULL COMMENT 'x轴数据', `Y_AXIS_` varchar(255) NULL DEFAULT NULL COMMENT 'y轴数据', `PORP_` text NULL COMMENT '统计参数', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_REPORTACT_REPORTID`(`REPORT_ID_` ASC) USING BTREE )COMMENT = '报表子表'; -- ---------------------------- -- Records of bpm_report_act -- ---------------------------- -- ---------------------------- -- Table structure for bpm_report_list -- ---------------------------- DROP TABLE IF EXISTS `bpm_report_list`; CREATE TABLE `bpm_report_list` ( `ID_` varchar(64) NOT NULL, `NAME_` varchar(255) NULL DEFAULT NULL COMMENT '报表主表名称', `ALIAS_` varchar(64) NULL DEFAULT NULL COMMENT '别名', `CREATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '创建人ID', `CREATE_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '创建人名称', `CREATE_ORG_ID_` varchar(64) NULL DEFAULT NULL COMMENT '创建者所属组织ID', `CREATE_ORG_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '组织名称', `TYPE_` varchar(64) NULL DEFAULT NULL COMMENT '是否发布(1:是，2否)', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '报表主表'; -- ---------------------------- -- Records of bpm_report_list -- ---------------------------- -- ---------------------------- -- Table structure for bpm_report_user -- ---------------------------- DROP TABLE IF EXISTS `bpm_report_user`; CREATE TABLE `bpm_report_user` ( `ID_` varchar(64) NOT NULL, `REPORT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '报表授权主表ID', `OWNER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '授权对象ID', `OWNER_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '授权对象名称', `RIGHT_TYPE_` varchar(20) NULL DEFAULT NULL COMMENT '授权对象类型(角色,用户,岗位等)', `AUTH_ORG_` varchar(255) NULL DEFAULT NULL COMMENT '主组织ID', `AUTH_ORG_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '主组织名称', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_REPORTUSER_REPORTID`(`REPORT_ID_` ASC) USING BTREE )COMMENT = '报表授权表'; -- ---------------------------- -- Records of bpm_report_user -- ---------------------------- -- ---------------------------- -- Table structure for bpm_save_opinion -- ---------------------------- DROP TABLE IF EXISTS `bpm_save_opinion`; CREATE TABLE `bpm_save_opinion` ( `ID_` varchar(255) NOT NULL COMMENT '主键ID', `PROC_INST_ID_` varchar(255) NOT NULL COMMENT '流程实例ID', `TASK_ID_` varchar(255) NOT NULL COMMENT '任务ID', `OPINION_` varchar(2000) NOT NULL COMMENT '暂存的审批意见', `CREATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '创建人', `CREATE_TIME_` datetime NULL DEFAULT NULL COMMENT '创建时间', `UPDATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '更新人', `UPDATE_TIME_` datetime NULL DEFAULT NULL COMMENT '更新时间', `TENANT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '租户ID', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_SAVEOPINION_PROCINSTID`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `IDX_SAVEOPINION_TASKID`(`TASK_ID_` ASC) USING BTREE )COMMENT = '审批意见暂存表'; -- ---------------------------- -- Records of bpm_save_opinion -- ---------------------------- -- ---------------------------- -- Table structure for bpm_script -- ---------------------------- DROP TABLE IF EXISTS `bpm_script`; CREATE TABLE `bpm_script` ( `ID_` varchar(64) NOT NULL, `NAME_` varchar(150) NULL DEFAULT NULL, `SCRIPT_` text NULL COMMENT '脚本', `CATEGORY_` varchar(128) NULL DEFAULT NULL COMMENT '脚本分类', `MEMO_` varchar(1000) NULL DEFAULT NULL, `CREATE_TIME_` datetime NULL DEFAULT NULL, `CREATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '创建人ID', `CREATE_ORG_ID_` varchar(64) NULL DEFAULT NULL COMMENT '创建人所属组织ID', `UPDATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '更新人ID', `UPDATE_TIME_` datetime NULL DEFAULT NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL, `DS_NAME_` varchar(50) NULL DEFAULT NULL COMMENT '数据源名称', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_SCRIPT_NAME`(`NAME_` ASC) USING BTREE )COMMENT = '常用脚本'; -- ---------------------------- -- Records of bpm_script -- ---------------------------- INSERT INTO `bpm_script` VALUES ('10', '获取cmd对象', 'return scriptImpl.getActionCmd();', '系统脚本', '', NULL, NULL, NULL, NULL, NULL, '-1', NULL); INSERT INTO `bpm_script` VALUES ('11', '获取当前用户的主组织名称', 'return scriptImpl.getIUserMainOrgName();', '系统脚本', '', NULL, NULL, NULL, NULL, NULL, '-1', NULL); INSERT INTO `bpm_script` VALUES ('12', '获取当前用户的主组织ID', 'return scriptImpl.getIUserMainOrgID();', '系统脚本', '', NULL, NULL, NULL, NULL, NULL, '-1', NULL); INSERT INTO `bpm_script` VALUES ('1269805454708576256', '获取当前年份', 'return scriptImpl.getCurrentYear();', '系统脚本', '获取当前年份，例如\"2020\"', NULL, '1', '', NULL, NULL, '-1', NULL); INSERT INTO `bpm_script` VALUES ('1269805555023745024', '获取当前月份', 'return scriptImpl.getCurrentMonth();', '系统脚本', '获取当前月份，例如\"06\"', NULL, '1', '', NULL, NULL, '-1', NULL); INSERT INTO `bpm_script` VALUES ('13', '获取当前用户的岗位名称', 'return scriptImpl.getIUserPostName();', '系统脚本', '返回：Set(String)', NULL, NULL, NULL, NULL, NULL, '-1', NULL); INSERT INTO `bpm_script` VALUES ('1310142489381965824', '获取当前登录用户的id', 'return scriptImpl.getCurrentUserId();', '系统脚本', '', NULL, '1', '', NULL, NULL, NULL, NULL); INSERT INTO `bpm_script` VALUES ('1310143493599006720', '获取当前登录用户账号', 'return scriptImpl.getCurrentAccount()', '系统脚本', '返回String', NULL, '1', '', NULL, NULL, NULL, NULL); INSERT INTO `bpm_script` VALUES ('1310143776035049472', '获取职务级别', 'return scriptImpl.getMainPostName(\"postLevel\");', '系统脚本', '', NULL, '1', '', NULL, NULL, NULL, NULL); INSERT INTO `bpm_script` VALUES ('1310147332251193344', '根据级别获取当前登录用户组织编码', 'return scriptImpl.getString(orgScript.getParentMainOrg(\"1\").getGroupCode());', '系统脚本', '集团1，公司2，部门3', NULL, '1', '', NULL, NULL, NULL, NULL); INSERT INTO `bpm_script` VALUES ('1310149027446263808', '获取当前用户的角色名称', 'return scriptImpl.getIUserRoleName();', '系统脚本', '返回字符串数组', NULL, '1', '', NULL, NULL, NULL, NULL); INSERT INTO `bpm_script` VALUES ('1310150341488152576', '获取组织参数值', 'return orgScript.getParamKey(\'\',\'\');', '系统脚本', '组织id，组织参数编码', NULL, '1', '', NULL, NULL, NULL, NULL); INSERT INTO `bpm_script` VALUES ('1310153058105298944', '根据id获取工号', 'return scriptImpl.getUser(\"1\").getAccount();', '系统脚本', '', NULL, '1', '', NULL, NULL, NULL, NULL); INSERT INTO `bpm_script` VALUES ('1310155448002940928', '判断组织参数', 'return orgScript.isOrgHasParamKey(\'\',\'\')', '系统脚本', '组织ID，参数别名', NULL, NULL, NULL, '1', NULL, NULL, NULL); INSERT INTO `bpm_script` VALUES ('1338310603730718720', '根据组织ID和参数判断组织是否有该参数', 'return orgScript.isOrgHasParamKey(\'\',\'\');', '系统脚本', '组织ID(String)，组织参数(String)', NULL, '1', '', '1', NULL, NULL, NULL); INSERT INTO `bpm_script` VALUES ('1338321870394626048', '根据级别获取当前用户组织ID', 'return orgScript.getParamMainOrgId(\'\');', '系统脚本', 'param:grade(String)', NULL, '1', '', '1', NULL, NULL, NULL); INSERT INTO `bpm_script` VALUES ('1338326076463648768', '获取当前用户主岗位名称', 'return scriptImpl.getCurrentMainPostName();', '系统脚本', '无参数', NULL, '1', '', '1', NULL, NULL, NULL); INSERT INTO `bpm_script` VALUES ('1338326248547553280', '获取当前用户主岗位ID', 'return scriptImpl.getCurrentMainPostId();', '系统脚本', '无参数', NULL, '1', '', '1', NULL, NULL, NULL); INSERT INTO `bpm_script` VALUES ('1338326415497629696', '获取当前用户主岗位编码', 'return scriptImpl.getCurrentMainPostId();', '系统脚本', '无参数', NULL, '1', '', '1', NULL, NULL, NULL); INSERT INTO `bpm_script` VALUES ('1338334576715632640', '执行sql', 'return scriptImpl.executeSql(\'\');', '系统脚本', '参数：sql(String)，参数中加入<#id#>，在流程中会替换成表单数据主键。返回值只有一行一列(String)', NULL, '1', '', '1', NULL, NULL, NULL); INSERT INTO `bpm_script` VALUES ('1338364268277534720', '判断当前用户是否拥有该角色', 'return scriptImpl.isCurrentInRole(\'\');', '系统脚本', '参数：角色别名', NULL, '1', '', NULL, NULL, NULL, NULL); INSERT INTO `bpm_script` VALUES ('14', '获取当前用户的岗位ID', 'return scriptImpl.getIUserPostID();', '系统脚本', '返回：Set(String)', NULL, NULL, NULL, NULL, NULL, '-1', NULL); INSERT INTO `bpm_script` VALUES ('15', '获取当前用户的角色名称', 'return scriptImpl.getIUserRoleName();', '系统脚本', '返回：Set(String)', NULL, NULL, NULL, NULL, NULL, '-1', NULL); INSERT INTO `bpm_script` VALUES ('16', '获取当前用户的角色ID', 'return scriptImpl.getIUserRoleID();', '系统脚本', '返回：Set(String)', NULL, NULL, NULL, NULL, NULL, '-1', NULL); INSERT INTO `bpm_script` VALUES ('7', '获取当前用户名称', 'return scriptImpl.getCurrentUserName();', '系统脚本', '', NULL, NULL, NULL, NULL, NULL, '-1', NULL); INSERT INTO `bpm_script` VALUES ('8', '获取当前日期', 'return scriptImpl.getCurrentDate();', '系统脚本', '获取当前日期，例如\"2002-11-06\"', NULL, NULL, NULL, NULL, NULL, '-1', NULL); INSERT INTO `bpm_script` VALUES ('9', '获取当前日期（指定格式）', 'return scriptImpl.getCurrentDateByStyle(String style);', '系统脚本', '获取当前日期，按指定格式输出', NULL, NULL, NULL, NULL, NULL, '-1', NULL); -- ---------------------------- -- Table structure for bpm_secretary_manage -- ---------------------------- DROP TABLE IF EXISTS `bpm_secretary_manage`; CREATE TABLE `bpm_secretary_manage` ( `ID_` varchar(64) NOT NULL, `LEADER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '领导id', `LEADER_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '领导姓名', `SECRETARY_ID_` varchar(255) NULL DEFAULT NULL COMMENT '秘书id', `SECRETARY_NAME_` varchar(1024) NULL DEFAULT NULL COMMENT '秘书姓名', `SHARE_TYPE_` varchar(2) NULL DEFAULT NULL COMMENT '共享类型，1流程分类。2，流程定义', `SHARE_KEY_` text NULL COMMENT '共享的key', `SHARE_NAME_` varchar(1024) NULL DEFAULT NULL COMMENT '共享对象的名称', `ENABLED_` varchar(2) NULL DEFAULT '1' COMMENT '是否有效', `SHARE_RIGHT_` varchar(10) NULL DEFAULT NULL COMMENT '共享权限类型', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_SEC_SECRETARYID`(`SECRETARY_ID_` ASC) USING BTREE )COMMENT = '秘书管理表'; -- ---------------------------- -- Records of bpm_secretary_manage -- ---------------------------- -- ---------------------------- -- Table structure for bpm_selector_def -- ---------------------------- DROP TABLE IF EXISTS `bpm_selector_def`; CREATE TABLE `bpm_selector_def` ( `ID_` varchar(64) NOT NULL, `NAME_` varchar(40) NULL DEFAULT NULL COMMENT '名称', `ALIAS_` varchar(64) NULL DEFAULT NULL COMMENT '别名', `GROUP_FIELD_` varchar(512) NULL DEFAULT NULL COMMENT '组合字段', `BUTTONS_` varchar(512) NULL DEFAULT NULL COMMENT '按钮定义', `IS_CUSTOM_` smallint NULL DEFAULT NULL COMMENT '系统预定义', `FLAG_` smallint NULL DEFAULT 0 COMMENT '标记是否系统默认', `METHOD_` varchar(64) NULL DEFAULT NULL COMMENT '选择器对应的js方法名称', `CONF_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '已选数据参数的传递key', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_SELECTORDEF_ALIAS`(`ALIAS_` ASC) USING BTREE )COMMENT = '控件组合定义'; -- ---------------------------- -- Records of bpm_selector_def -- ---------------------------- -- ---------------------------- -- Table structure for bpm_service_log -- ---------------------------- DROP TABLE IF EXISTS `bpm_service_log`; CREATE TABLE `bpm_service_log` ( `ID_` varchar(64) NOT NULL, `SUBJECT_` varchar(600) NULL DEFAULT NULL COMMENT ' 流程标题', `PROC_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT ' 流程定义ID', `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例ID', `NODE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '节点ID', `STATUS_` int NULL DEFAULT NULL COMMENT '处理结果：1.处理成功 0.处理失败', `CREATE_TIME_` datetime NULL DEFAULT NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `PROC_INST_ID_`(`PROC_INST_ID_` ASC) USING BTREE )COMMENT = '服务节点执行日志'; -- ---------------------------- -- Records of bpm_service_log -- ---------------------------- -- ---------------------------- -- Table structure for bpm_show_record -- ---------------------------- DROP TABLE IF EXISTS `bpm_show_record`; CREATE TABLE `bpm_show_record` ( `id_` varchar(32) NOT NULL COMMENT '主键id', `account_` varchar(32) NOT NULL COMMENT '查阅人账号', `full_name_` varchar(32) NOT NULL COMMENT '查阅人名称', `show_time_` datetime NOT NULL COMMENT '查阅时间', `task_id_` varchar(32) NULL DEFAULT NULL COMMENT '流程实例id或者任务id', `action_` varchar(32) NULL DEFAULT NULL COMMENT '流程定义中的动作：发布新版本/保存', `show_type_` varchar(20) NULL DEFAULT NULL COMMENT '展示类型：实例/任务/流程定义', `reasons_` text NOT NULL COMMENT '查阅原因', `create_by_` varchar(32) NULL DEFAULT NULL COMMENT '创建人', `create_time_` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_org_id_` varchar(32) NULL DEFAULT NULL, `update_by_` varchar(32) NULL DEFAULT NULL COMMENT '更新人', `update_time_` datetime NULL DEFAULT NULL COMMENT '更新时间', `tenant_id_` varchar(32) NULL DEFAULT NULL COMMENT '租户id', PRIMARY KEY (`id_`) USING BTREE, INDEX `show_record_task_id__show_type__index`(`task_id_` ASC, `show_type_` ASC) USING BTREE )COMMENT = '流程实例和流程任务查阅记录'; -- ---------------------------- -- Records of bpm_show_record -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task -- ---------------------------- DROP TABLE IF EXISTS `bpm_task`; CREATE TABLE `bpm_task` ( `ID_` varchar(64) NOT NULL, `NAME_` varchar(100) NOT NULL COMMENT '任务名称', `SUBJECT_` varchar(256) NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) NOT NULL COMMENT '关联 - 流程实例ID', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '关联的任务ID', `EXEC_ID_` varchar(64) NULL DEFAULT NULL COMMENT '关联 - 节点执行ID', `NODE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '关联 - 任务节点ID', `PROC_DEF_ID_` varchar(64) NOT NULL COMMENT '关联 - 流程定义ID', `PROC_DEF_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '关联 - 流程业务主键', `PROC_DEF_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '关联 - 流程名称', `OWNER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务所属人ID', `OWNER_NAME_` varchar(128) NULL DEFAULT NULL, `ASSIGNEE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务执行人ID', `ASSIGNEE_NAME_` varchar(128) NULL DEFAULT NULL, `STATUS_` varchar(40) NOT NULL COMMENT '任务状态', `PRIORITY_` int NULL DEFAULT NULL COMMENT '任务优先级', `CREATE_TIME_` datetime NULL DEFAULT NULL, `DUE_TIME_` datetime NULL DEFAULT NULL, `SUSPEND_STATE_` smallint NULL DEFAULT 0 COMMENT '是否挂起(0正常,1挂起)', `PARENT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '父任务ID', `BPMN_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT 'bpmn实例ID', `BPMN_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT 'BPMN定义ID', `TYPE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '分类ID', `SUPPORT_MOBILE_` int NULL DEFAULT 0 COMMENT '支持手机', `IS_DELE_` int NOT NULL DEFAULT 0 COMMENT '是否已删，1已删除，0未删除', `IS_READ_` int NULL DEFAULT NULL, `IS_REVOKE_` int NULL DEFAULT NULL, `PROP1_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性1', `PROP2_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性2', `PROP3_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性3', `PROP4_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性4', `PROP5_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性5', `PROP6_` text NULL COMMENT '扩展属性6', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, `MOBILE_TASK_URL_` varchar(200) NULL DEFAULT NULL COMMENT '手机端任务地址', `PC_TASK_URL_` varchar(200) NULL DEFAULT NULL COMMENT 'pc端任务地址', `TARGET_NODE_` varchar(255) NULL DEFAULT NULL COMMENT '回到本节点', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_BPM_TASK_TASKID`(`TASK_ID_` ASC) USING BTREE, INDEX `IDX_BPM_TASK_PARENTID`(`PARENT_ID_` ASC) USING BTREE, INDEX `IDX_BPM_TASK_INSTID`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `IDX_BPM_TASK_STATUS`(`STATUS_` ASC) USING BTREE, INDEX `IDX_BPM_TASK_OWNERID`(`OWNER_ID_` ASC) USING BTREE, INDEX `IDX_BPM_TASK_ASSIGNEEID`(`ASSIGNEE_ID_` ASC) USING BTREE )COMMENT = '流程任务'; -- ---------------------------- -- Records of bpm_task -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task_candidate -- ---------------------------- DROP TABLE IF EXISTS `bpm_task_candidate`; CREATE TABLE `bpm_task_candidate` ( `ID_` varchar(64) NOT NULL, `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务ID', `TYPE_` varchar(20) NULL DEFAULT NULL COMMENT '候选人类型', `EXECUTOR_` varchar(64) NULL DEFAULT NULL COMMENT '执行人ID', `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_TASKCANDIDATE_TASKID`(`TASK_ID_` ASC) USING BTREE, INDEX `IDX_TASKCANDIDATE_PROCINSTID`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `IDX_TASKCANDIDATE_EXECUTOR`(`EXECUTOR_` ASC) USING BTREE, INDEX `IDX_TASKCANDIDATE_TYPE`(`TYPE_` ASC) USING BTREE )COMMENT = '任务候选人'; -- ---------------------------- -- Records of bpm_task_candidate -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task_commu -- ---------------------------- DROP TABLE IF EXISTS `bpm_task_commu`; CREATE TABLE `bpm_task_commu` ( `ID_` varchar(64) NOT NULL, `INSTANCE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例ID', `NODE_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '节点名称', `NODE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '节点ID', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务ID', `SENDER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '发送沟通人ID', `SENDER` varchar(128) NULL DEFAULT NULL COMMENT '发送沟通人', `CREATETIME_` datetime NULL DEFAULT NULL, `OPINION_` varchar(1500) NULL DEFAULT NULL COMMENT '意见', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_TASKCOMMU_TASKID`(`TASK_ID_` ASC) USING BTREE, INDEX `IDX_TASKCOMMU_INSTANCEID`(`INSTANCE_ID_` ASC) USING BTREE )COMMENT = '任务通知'; -- ---------------------------- -- Records of bpm_task_commu -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task_due_time -- ---------------------------- DROP TABLE IF EXISTS `bpm_task_due_time`; CREATE TABLE `bpm_task_due_time` ( `ID_` varchar(64) NOT NULL, `PARENT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '父id', `INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例id', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务id', `DATE_TYPE_` varchar(32) NULL DEFAULT NULL COMMENT '时间类型 工作日 worktime 日历日 caltime', `DUE_TIME_` int NULL DEFAULT NULL COMMENT '任务时间 (分钟)', `ADD_DUE_TIME_` int NULL DEFAULT NULL COMMENT '延迟时间', `START_TIME_` datetime NULL DEFAULT NULL, `EXPIRATION_DATE_` datetime NULL DEFAULT NULL, `REMAINING_TIME_` int NULL DEFAULT NULL COMMENT '任务剩余时间（分钟）', `CREATE_TIME_` datetime NULL DEFAULT NULL, `STATUS_` int NULL DEFAULT NULL COMMENT '状态 是否延期申请过 1申请过 0没延迟过', `USER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '审批人ID', `USER_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '审批人姓名', `REMARK_` varchar(512) NULL DEFAULT NULL COMMENT '说明', `FILE_ID_` varchar(512) NULL DEFAULT NULL COMMENT '附件', `IS_NEW_` int NULL DEFAULT NULL COMMENT '是否新的延迟 1 是 0 否 ', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_DUETIME_TASKID`(`TASK_ID_` ASC) USING BTREE )COMMENT = '任务期限记录表'; -- ---------------------------- -- Records of bpm_task_due_time -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task_follow -- ---------------------------- DROP TABLE IF EXISTS `bpm_task_follow`; CREATE TABLE `bpm_task_follow` ( `ID` varchar(255) NOT NULL COMMENT '主键', `TASK_ID` varchar(255) NULL DEFAULT NULL COMMENT '任务id', `CREATOR_ID_` varchar(255) NULL DEFAULT NULL COMMENT '创建者ID', `PRO_INST_` varchar(255) NULL DEFAULT NULL COMMENT '流程实例id', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID`) USING BTREE )COMMENT = '任务跟踪表'; -- ---------------------------- -- Records of bpm_task_follow -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task_notice -- ---------------------------- DROP TABLE IF EXISTS `bpm_task_notice`; CREATE TABLE `bpm_task_notice` ( `ID_` varchar(64) NOT NULL, `NAME_` varchar(64) NOT NULL COMMENT '任务名称', `SUBJECT_` varchar(128) NOT NULL COMMENT '待办事项标题', `PROC_INST_ID_` varchar(64) NOT NULL COMMENT '关联 - 流程实例ID', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '关联的任务ID', `EXEC_ID_` varchar(64) NULL DEFAULT NULL COMMENT '关联 - 节点执行ID', `NODE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '关联 - 任务节点ID', `PROC_DEF_ID_` varchar(64) NOT NULL COMMENT '关联 - 流程定义ID', `PROC_DEF_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '关联 - 流程业务主键', `PROC_DEF_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '关联 - 流程名称', `OWNER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务所属人ID', `OWNER_NAME_` varchar(128) NULL DEFAULT NULL, `ASSIGNEE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务执行人ID', `ASSIGNEE_NAME_` varchar(128) NULL DEFAULT NULL, `STATUS_` varchar(40) NOT NULL COMMENT '任务状态', `PRIORITY_` int NULL DEFAULT NULL COMMENT '任务优先级', `CREATE_TIME_` datetime NULL DEFAULT NULL, `DUE_TIME_` datetime NULL DEFAULT NULL, `SUSPEND_STATE_` smallint NULL DEFAULT 0 COMMENT '是否挂起(0正常,1挂起)', `PARENT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '父任务ID', `BPMN_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT 'bpmn实例ID', `BPMN_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT 'BPMN定义ID', `TYPE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '分类ID', `SUPPORT_MOBILE_` int NULL DEFAULT 0 COMMENT '支持手机', `IS_DELE_` int NOT NULL DEFAULT 0 COMMENT '是否已删，1已删除，0未删除', `IS_READ_` int NOT NULL DEFAULT 0 COMMENT '传阅的任务是否已阅 0:待阅，1：已阅', `IS_REVOKE_` int NOT NULL DEFAULT 0 COMMENT '传阅的任务是否撤回 0:否，1：是', `PROP1_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性1', `PROP2_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性2', `PROP3_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性3', `PROP4_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性4', `PROP5_` varchar(200) NULL DEFAULT NULL COMMENT '扩展属性5', `PROP6_` text NULL COMMENT '扩展属性6', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, `MOBILE_TASK_URL_` varchar(200) NULL DEFAULT NULL COMMENT '手机端任务地址', `PC_TASK_URL_` varchar(200) NULL DEFAULT NULL COMMENT 'pc端任务地址', `OPINION_ID_` varchar(64) NULL DEFAULT NULL COMMENT '传阅时审批意见id,不为空时根据此id查找审批意见里的数据', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_BPMTASK_INSTID`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `IDX_BPMTASK_PARENTID`(`PARENT_ID_` ASC) USING BTREE, INDEX `IDX_BPMTASK_TASKID`(`TASK_ID_` ASC) USING BTREE, INDEX `IDX_BPMTASK_USERID`(`ASSIGNEE_ID_` ASC) USING BTREE, INDEX `IDX_TASK_NOTICE_OWNER_ID`(`OWNER_ID_` ASC) USING BTREE )COMMENT = '知会任务表'; -- ---------------------------- -- Records of bpm_task_notice -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task_notice_done -- ---------------------------- DROP TABLE IF EXISTS `bpm_task_notice_done`; CREATE TABLE `bpm_task_notice_done` ( `ID_` varchar(64) NOT NULL, `PROC_DEF_ID_` varchar(64) NOT NULL COMMENT '流程定义ID', `SUP_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '父流程实例ID', `PROC_INST_ID_` varchar(64) NOT NULL COMMENT '流程实例ID', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务ID', `TASK_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '任务定义Key', `TASK_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '任务名称', `TOKEN_` varchar(64) NULL DEFAULT NULL COMMENT '任务令牌', `QUALFIEDS_` text NULL COMMENT '有审批资格用户ID串', `QUALFIED_NAMES_` text NULL COMMENT '有审批资格用户名称串', `AUDITOR_` varchar(64) NULL DEFAULT NULL COMMENT '执行人ID', `AUDITOR_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '执行人名', `ORG_ID_` varchar(64) NULL DEFAULT NULL COMMENT '组织ID', `ORG_PATH_` varchar(600) NULL DEFAULT NULL COMMENT '组织全路径', `OPINION_` varchar(4000) NULL DEFAULT NULL COMMENT '审批意见', `STATUS_` varchar(40) NOT NULL COMMENT '知会任务已办状态', `FORM_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT '表单定义ID', `FORM_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '表单名', `CREATE_TIME_` datetime NULL DEFAULT NULL, `ASSIGN_TIME_` datetime NULL DEFAULT NULL, `COMPLETE_TIME_` datetime NULL DEFAULT NULL, `DUR_MS_` int NULL DEFAULT NULL COMMENT '持续时间(ms)', `FILES_` varchar(4000) NULL DEFAULT NULL COMMENT '附件', `INTERPOSE_` smallint NULL DEFAULT NULL COMMENT '是否干预', `SUBJECT_` varchar(255) NULL DEFAULT NULL COMMENT '流程标题', `PROC_DEF_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '任务名称', `BPM_TASK_NOTICE_ID_` varchar(255) NULL DEFAULT NULL COMMENT '知会待办主键ID', `SUPPORT_MOBILE_` int NULL DEFAULT 0 COMMENT '是否支持手机0：不支持，1：支持', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_TND_INSTID`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `IDX_OPINION_SUPINSTID`(`SUP_INST_ID_` ASC) USING BTREE, INDEX `IDX_NOTICE_TASK`(`TASK_ID_` ASC) USING BTREE, INDEX `IDX_TASK_NDP_DEF_ID`(`PROC_DEF_ID_` ASC) USING BTREE )COMMENT = '知会任务已办'; -- ---------------------------- -- Records of bpm_task_notice_done -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task_read -- ---------------------------- DROP TABLE IF EXISTS `bpm_task_read`; CREATE TABLE `bpm_task_read` ( `READ_ID_` varchar(64) NOT NULL COMMENT '主键', `PROC_DEF_ID` varchar(64) NULL DEFAULT NULL COMMENT '流程定义ID', `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例ID', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务ID', `NODE_ID_` varchar(255) NULL DEFAULT NULL COMMENT '节点ID', `READ_TIME_` datetime NULL DEFAULT NULL, `USER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '用户ID', `USER_NAME_` varchar(32) NULL DEFAULT NULL COMMENT '用户名', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`READ_ID_`) USING BTREE )COMMENT = '流程任务查看'; -- ---------------------------- -- Records of bpm_task_read -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task_reminder -- ---------------------------- DROP TABLE IF EXISTS `bpm_task_reminder`; CREATE TABLE `bpm_task_reminder` ( `ID_` varchar(64) NOT NULL, `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '催办任务ID', `NAME_` varchar(64) NULL DEFAULT NULL COMMENT '催办名称', `REL_DATE_` datetime NULL DEFAULT NULL, `DUE_ACTION_` varchar(64) NULL DEFAULT NULL COMMENT '到期执行动作', `DUE_SCRIPT_` varchar(255) NULL DEFAULT NULL COMMENT '调用指定方法', `DUE_DATE_` datetime NULL DEFAULT NULL, `IS_SEND_MSG_` int NULL DEFAULT NULL COMMENT '期间是否发送催办', `MSG_SEND_DATE_` datetime NULL DEFAULT NULL, `MSG_INTERVAL_` int NULL DEFAULT NULL COMMENT '发送消息间隔', `MSG_COUNT_` int NULL DEFAULT NULL COMMENT '发送次数', `MSG_TYPE_` varchar(64) NULL DEFAULT NULL COMMENT '消息类型 inner,msg,email 等', `HTML_MSG_` varchar(255) NULL DEFAULT NULL COMMENT '富文本', `PLAIN_MSG_` varchar(255) NULL DEFAULT NULL COMMENT '纯文本消息', `WARNINGSET_` varchar(255) NULL DEFAULT NULL COMMENT '预警配置（预警名称，triggerDate，change2level）', `TRIGGER_DATE_` datetime NULL DEFAULT NULL, `SEND_PERSON_` varchar(64) NULL DEFAULT NULL, `SEND_USER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '发送个人ID', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, `DURATION_SCRIPT_` text NULL COMMENT '时长脚本', `DURATION_` int NULL DEFAULT NULL COMMENT '时长', `SEND_DURATION_` int NULL DEFAULT NULL COMMENT '消息时长', `DATE_TYPE_` varchar(20) NULL DEFAULT NULL COMMENT '类型 caltime日历日 worktime工作日', `TYPE_SCRIPT_` text NULL COMMENT '类型脚本', `REL_TIME_SCRIPT_` text NULL COMMENT '相对时间脚本', `TRANSFER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '转办人id', `TRANSFER_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '转办人名称', `DIRECT_LEADER_` int NULL DEFAULT NULL COMMENT '催办直接上级', `MAIN_ORG_LEADER_` int NULL DEFAULT NULL COMMENT '催办主组织负责人', `DIRECT_USER_IDS_` varchar(1000) NULL DEFAULT NULL COMMENT '指定用户id', `DIRECT_USER_NAMES_` varchar(1000) NULL DEFAULT NULL COMMENT '指定用户名称', `DIRECT_USER_` int NULL DEFAULT NULL COMMENT '催办指定用户', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_TASK_REMINDER_TASK_ID`(`TASK_ID_` ASC) USING BTREE )COMMENT = '任务催办'; -- ---------------------------- -- Records of bpm_task_reminder -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task_sign_line -- ---------------------------- DROP TABLE IF EXISTS `bpm_task_sign_line`; CREATE TABLE `bpm_task_sign_line` ( `ID_` varchar(64) NOT NULL, `INSTANCE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务ID', `PARENT_TASK_ID_` varchar(64) NULL DEFAULT NULL, `PATH_` varchar(512) NULL DEFAULT NULL COMMENT '路径', `STATUS_` varchar(64) NULL DEFAULT NULL, `EXECUTOR_` varchar(2048) NULL DEFAULT NULL COMMENT '执行人', `ACTION_` varchar(64) NULL DEFAULT NULL COMMENT '并行签署后的动作 submit提交 back返回 ', `NODE_ID_` varchar(128) NULL DEFAULT NULL COMMENT '节点id', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_TASK_SIGN_LINE_TASK_ID`(`TASK_ID_` ASC) USING BTREE, INDEX `IDX_TASK_SIGN_LINE_INSTANCE_ID`(`INSTANCE_ID_` ASC) USING BTREE )COMMENT = '并行签署'; -- ---------------------------- -- Records of bpm_task_sign_line -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task_sign_sequence -- ---------------------------- DROP TABLE IF EXISTS `bpm_task_sign_sequence`; CREATE TABLE `bpm_task_sign_sequence` ( `ID_` varchar(64) NOT NULL, `INSTANCE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例', `NODE_ID_` varchar(128) NULL DEFAULT NULL COMMENT '节点key', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务ID', `NEXT_TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '下一任务ID', `PARENT_ID_` varchar(64) NULL DEFAULT NULL, `STATUS_` varchar(64) NULL DEFAULT NULL, `PATH_` varchar(512) NULL DEFAULT NULL COMMENT '路径', `SEQ_` smallint NULL DEFAULT NULL COMMENT '顺序', `EXECUTOR_` varchar(2048) NULL DEFAULT NULL COMMENT '执行人', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_TASK_SIGN_SEQ_INST_ID`(`INSTANCE_ID_` ASC) USING BTREE, INDEX `IDX_TASK_SIGN_SEQUENCE_TASK_ID`(`TASK_ID_` ASC) USING BTREE )COMMENT = '顺序签署人员'; -- ---------------------------- -- Records of bpm_task_sign_sequence -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task_signdata -- ---------------------------- DROP TABLE IF EXISTS `bpm_task_signdata`; CREATE TABLE `bpm_task_signdata` ( `ID_` varchar(64) NOT NULL, `DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程定义ID', `INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例ID', `EXECUTE_ID_` varchar(40) NULL DEFAULT NULL COMMENT 'act运行实例Id', `ACT_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT 'ACT流程实例ID', `NODE_ID_` varchar(128) NULL DEFAULT NULL COMMENT '节点ID', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程任务ID', `QUALIFIED_ID_` varchar(255) NULL DEFAULT NULL COMMENT '有资格审批的成员ID', `QUALIFIED_NAME_` varchar(512) NULL DEFAULT NULL COMMENT '有资格审批的成员名称', `CREATE_TIME_` datetime NULL DEFAULT NULL, `VOTE_RESULT_` varchar(20) NULL DEFAULT NULL COMMENT '投票结果(no 未投票 通过 agree,abandon 弃权,oppose 反对)', `VOTE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '投票人', `VOTER_` varchar(40) NULL DEFAULT NULL COMMENT '投票人', `VOTE_TIME_` datetime NULL DEFAULT NULL, `INDEX_` int NULL DEFAULT NULL COMMENT '投票次序', `IS_ACTIVE_` int NULL DEFAULT NULL COMMENT '是否活动', `TYPE_` varchar(64) NULL DEFAULT NULL COMMENT '数据类型（NORMAL正常会签数据，ADDSIGN加签会签数据）', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, `IDENTITY_TYPE_` varchar(64) NULL DEFAULT NULL COMMENT '用户组类型', `FROM_` varchar(64) NULL DEFAULT NULL COMMENT '来源。assign由指定历史会签处理人产生的', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_TASK_SIGNDATA_EXECUTE_ID`(`EXECUTE_ID_` ASC) USING BTREE, INDEX `IDX_TASK_SIGNDATA_NODE_ID`(`NODE_ID_` ASC) USING BTREE, INDEX `IDX_TASK_SIGNDATA_INST_ID_`(`INST_ID_` ASC) USING BTREE )COMMENT = '会签数据'; -- ---------------------------- -- Records of bpm_task_signdata -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task_trans -- ---------------------------- DROP TABLE IF EXISTS `bpm_task_trans`; CREATE TABLE `bpm_task_trans` ( `ID_` varchar(64) NOT NULL, `INSTANCE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务ID\r\n流转任务ID', `ACTION_` varchar(20) NULL DEFAULT NULL COMMENT '完成后的操作', `CREATE_BY_` varchar(64) NULL DEFAULT NULL, `CREATOR_` varchar(128) NULL DEFAULT NULL COMMENT '创建人', `CREATE_TIME_` datetime NULL DEFAULT NULL, `CREATE_ORG_ID_` varchar(64) NULL DEFAULT NULL, `UPDATE_BY_` varchar(64) NULL DEFAULT NULL, `UPDATE_TIME_` datetime NULL DEFAULT NULL, `DECIDE_TYPE_` varchar(20) NULL DEFAULT NULL COMMENT '决策类型\r\nagree\r\noppose', `VOTE_TYPE_` varchar(20) NULL DEFAULT NULL COMMENT '投票类型\r\namount\r\npercent', `VOTE_AMOUNT_` smallint NULL DEFAULT NULL COMMENT '票数', `SIGN_TYPE_` varchar(20) NULL DEFAULT NULL COMMENT '会签类型\r\nparallel,seq', `INQU_TYPE_` varchar(20) NULL DEFAULT NULL COMMENT '征询类型 direct step', `TOTAL_AMOUNT_` smallint NULL DEFAULT NULL COMMENT '总票数', `AGREE_AMOUNT_` smallint NULL DEFAULT NULL COMMENT '通过票数', `OPPOSE_AMOUNT_` smallint NULL DEFAULT NULL COMMENT '反对票数', `SEQ_` smallint NULL DEFAULT NULL COMMENT '投票次序', `USER_JSON_` varchar(4000) NULL DEFAULT NULL COMMENT '用户数据', `ALLOW_FORM_EDIT_` smallint NULL DEFAULT NULL COMMENT '表单允许编辑', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_TASK_TRANS_TASK_ID`(`TASK_ID_` ASC) USING BTREE, INDEX `IDX_TASK_TRANS_INSTANCE_ID`(`INSTANCE_ID_` ASC) USING BTREE )COMMENT = '流程流转'; -- ---------------------------- -- Records of bpm_task_trans -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task_trans_record -- ---------------------------- DROP TABLE IF EXISTS `bpm_task_trans_record`; CREATE TABLE `bpm_task_trans_record` ( `ID_` varchar(64) NOT NULL, `PROC_INST_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程实例', `TASK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务ID\r\n流转任务ID', `ACTION_` varchar(20) NULL DEFAULT NULL COMMENT '完成后的操作', `CREATE_BY_` varchar(64) NULL DEFAULT NULL, `CREATOR_` varchar(128) NULL DEFAULT NULL COMMENT '创建人', `CREATE_TIME_` datetime NULL DEFAULT NULL, `CREATE_ORG_ID_` varchar(64) NULL DEFAULT NULL, `UPDATE_BY_` varchar(64) NULL DEFAULT NULL, `UPDATE_TIME_` datetime NULL DEFAULT NULL, `DECIDE_TYPE` varchar(20) NULL DEFAULT NULL COMMENT '决策类型\r\n同意 agree\r\n反对 oppose', `VOTE_TYPE_` varchar(20) NULL DEFAULT NULL COMMENT '投票类型', `VOTE_AMOUNT_` smallint NULL DEFAULT NULL COMMENT '票数', `SIGN_TYPE_` varchar(20) NULL DEFAULT NULL COMMENT '会签类型', `TOTAL_AMOUNT_` smallint NULL DEFAULT NULL COMMENT '总票数', `AGREE_AMOUNT_` smallint NULL DEFAULT NULL COMMENT '通过票数', `OPPOSE_AMOUNT_` smallint NULL DEFAULT NULL COMMENT '反对票数', `TRANS_USERS_` varchar(300) NULL DEFAULT NULL COMMENT '流转人员', `TASK_NAME_` varchar(200) NULL DEFAULT NULL COMMENT '任务名称', `TASK_SUBJECT_` varchar(300) NULL DEFAULT NULL COMMENT '流转任务标题', `STATUS_` smallint NULL DEFAULT NULL COMMENT '状态：0流转中 1流转结束 2已撤销', `TRANS_USER_IDS_` varchar(300) NULL DEFAULT NULL COMMENT '流转人员ids', `TRANS_OPINION_` varchar(200) NULL DEFAULT NULL COMMENT '流转意见(原因)', `TRANS_TIME_` datetime NULL DEFAULT NULL, `DEF_NAME_` varchar(200) NULL DEFAULT NULL COMMENT '流程名称', `TRANS_OWNER_` varchar(64) NULL DEFAULT NULL COMMENT '流转任务所属人ID', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_TASK_TRANS_RECT_ID`(`TASK_ID_` ASC) USING BTREE )COMMENT = '流程流转记录'; -- ---------------------------- -- Records of bpm_task_trans_record -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task_turn -- ---------------------------- DROP TABLE IF EXISTS `bpm_task_turn`; CREATE TABLE `bpm_task_turn` ( `ID_` varchar(64) NOT NULL, `TASK_ID_` varchar(64) NOT NULL COMMENT '任务ID', `TASK_NAME_` varchar(64) NOT NULL COMMENT '任务名称', `TASK_SUBJECT_` varchar(128) NOT NULL COMMENT '待办事项标题', `NODE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '关联 - 任务节点ID', `PROC_INST_ID_` varchar(64) NOT NULL COMMENT '关联 - 流程实例ID', `OWNER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务所属人ID', `OWNER_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '任务所属人姓名', `ASSIGNEE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务执行人ID', `ASSIGNEE_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '任务执行人姓名', `STATUS_` varchar(40) NULL DEFAULT NULL COMMENT '状态。running=正在运行；finish=完成；cancel=取消', `TURN_TYPE_` varchar(40) NULL DEFAULT NULL COMMENT '更改类型。agent=代理；shift=转办；copy_to=抄送', `TYPE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '所属分类ID', `CREATE_TIME_` datetime NULL DEFAULT NULL, `FINISH_TIME_` datetime NULL DEFAULT NULL, `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_TASKTURN_TASKID`(`TASK_ID_` ASC) USING BTREE )COMMENT = '任务的执行更改，更改类型。agent=代理；shift=转办；copy_to=抄送'; -- ---------------------------- -- Records of bpm_task_turn -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task_turnassign -- ---------------------------- DROP TABLE IF EXISTS `bpm_task_turnassign`; CREATE TABLE `bpm_task_turnassign` ( `ID_` varchar(64) NOT NULL, `TASK_TURN_ID_` varchar(64) NULL DEFAULT NULL COMMENT '转交ID和task_turn表主键关联', `FROM_USER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '任务转交人ID', `FROM_USER_` varchar(64) NULL DEFAULT NULL COMMENT '任务转交人', `RECEIVER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '接收人ID', `RECEIVER` varchar(64) NULL DEFAULT NULL COMMENT '接收人', `CREATE_TIME_` datetime NULL DEFAULT NULL, `COMMENT_` varchar(1024) NULL DEFAULT NULL COMMENT '备注', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_TASK_TURN_TASK_TURN_ID`(`TASK_TURN_ID_` ASC) USING BTREE )COMMENT = '任务指派人员'; -- ---------------------------- -- Records of bpm_task_turnassign -- ---------------------------- -- ---------------------------- -- Table structure for bpm_task_urgent -- ---------------------------- DROP TABLE IF EXISTS `bpm_task_urgent`; CREATE TABLE `bpm_task_urgent` ( `ID_` varchar(255) NOT NULL, `TASK_ID_` varchar(255) NULL DEFAULT NULL COMMENT '任务ID', `NODE_NAME_` varchar(255) NULL DEFAULT NULL COMMENT '节点名称', `INST_ID_` varchar(255) NULL DEFAULT NULL COMMENT '流程实例ID', `SUBJECT_` varchar(255) NULL DEFAULT NULL COMMENT '流程标题', `CONTENT_` text NULL COMMENT '催办内容', `URGRNT_DATE_` datetime NULL DEFAULT NULL, `PROMOTER_ID_` varchar(255) NULL DEFAULT NULL COMMENT '催办人ID', `PROMOTER_` varchar(255) NULL DEFAULT NULL COMMENT '催办人', `APPOINTEE_ID_` text NULL COMMENT '被催办人ID', `APPOINTEE_` text NULL COMMENT '被催办人', `TYPE_` varchar(255) NULL DEFAULT NULL COMMENT '催办类型', `APPOINTEE_SECRETARY_CONF_` varchar(1024) NULL DEFAULT NULL COMMENT '催办的领导和秘书的id关系map，方便秘书回复时确定代哪个领导审批的', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '人工催办表'; -- ---------------------------- -- Records of bpm_task_urgent -- ---------------------------- -- ---------------------------- -- Table structure for bpm_test_case -- ---------------------------- DROP TABLE IF EXISTS `bpm_test_case`; CREATE TABLE `bpm_test_case` ( `ID_` varchar(64) NOT NULL, `NAME_` varchar(128) NULL DEFAULT NULL COMMENT '测试用例名称', `BO_FORM_DATA_` text NULL COMMENT '表单数据', `FLOW_VARS_` text NULL COMMENT '流程变量', `ACTION_TYPE_` text NULL COMMENT '审批动作， 默认动作时 agree', `STARTOR_` text NULL COMMENT '发起人json', `BPM_DEBUGGER_` text NULL COMMENT '断点测试设置', `DEF_KEY_` varchar(64) NULL DEFAULT NULL COMMENT '流程定义key', `STARTOR_ACCOUNT_` varchar(64) NULL DEFAULT NULL COMMENT '发起人账号', `STARTOR_FULL_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '发起人姓名', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '流程仿真测试用例表'; -- ---------------------------- -- Records of bpm_test_case -- ---------------------------- -- ---------------------------- -- Table structure for bpm_test_case_logs -- ---------------------------- DROP TABLE IF EXISTS `bpm_test_case_logs`; CREATE TABLE `bpm_test_case_logs` ( `ID_` varchar(64) NOT NULL COMMENT '主键ID', `OPE_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '操作名称', `EXECUTION_TIME_` datetime NULL DEFAULT NULL, `OPE_CONTENT_` longtext NULL COMMENT '操作内容', `TENANT_ID_` varchar(255) NULL DEFAULT NULL COMMENT '租户ID', PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '流程仿真异常日志'; -- ---------------------------- -- Records of bpm_test_case_logs -- ---------------------------- -- ---------------------------- -- Table structure for bpm_trans_receiver -- ---------------------------- DROP TABLE IF EXISTS `bpm_trans_receiver`; CREATE TABLE `bpm_trans_receiver` ( `ID_` varchar(64) NOT NULL, `TRANS_RECORDID_` varchar(64) NULL DEFAULT NULL COMMENT '流转任务记录ID', `RECEIVER_` varchar(100) NULL DEFAULT NULL COMMENT '流转接受人员', `RECEIVER_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流转接收人id', `STATUS_` smallint NULL DEFAULT NULL COMMENT '状态:0尚未处理1已处理', `OPINION_` varchar(500) NULL DEFAULT NULL COMMENT '审核意见', `RECEIVER_TIME_` datetime NULL DEFAULT NULL, `CHECK_TIME_` datetime NULL DEFAULT NULL, `CHECK_TYPE_` smallint NULL DEFAULT NULL COMMENT '审核状态', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_TRANS_REC_TRANS_RDID`(`TRANS_RECORDID_` ASC) USING BTREE )COMMENT = '流转任务接收人'; -- ---------------------------- -- Records of bpm_trans_receiver -- ---------------------------- -- ---------------------------- -- Table structure for bpm_trans_record -- ---------------------------- DROP TABLE IF EXISTS `bpm_trans_record`; CREATE TABLE `bpm_trans_record` ( `ID_` varchar(64) NOT NULL, `TYPE_` varchar(20) NULL DEFAULT NULL COMMENT '移交类型', `TRANSFER_` varchar(64) NULL DEFAULT NULL COMMENT '移交人ID', `TRANSFER_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '移交人姓名', `TRANSFERED_` varchar(64) NULL DEFAULT NULL, `TRANSFERED_NAME_` varchar(64) NULL DEFAULT NULL COMMENT '被移交人姓名', `REASON_` varchar(2000) NULL DEFAULT NULL COMMENT '移交原因', `CREATE_TIME_` datetime NULL DEFAULT NULL, `CREATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '创建人ID', `CREATE_ORG_ID_` varchar(64) NULL DEFAULT NULL, `UPDATE_BY_` varchar(64) NULL DEFAULT NULL, `UPDATE_TIME_` datetime NULL DEFAULT NULL, `RESULT_` varchar(2000) NULL DEFAULT NULL COMMENT '移交结果', `VAR_` int NULL DEFAULT NULL COMMENT '移交方式', `PROC_INST_IDS_` varchar(2000) NULL DEFAULT NULL COMMENT '流程实例ID', `TENANT_ID_` varchar(64) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '移交记录'; -- ---------------------------- -- Records of bpm_trans_record -- ---------------------------- -- ---------------------------- -- Table structure for bpm_watermark -- ---------------------------- DROP TABLE IF EXISTS `bpm_watermark`; CREATE TABLE `bpm_watermark` ( `ID_` varchar(64) NOT NULL COMMENT '主键', `NAME_` varchar(128) NULL DEFAULT NULL COMMENT '名称', `CONTENT_` longtext NULL, `TYPE_` smallint NULL DEFAULT NULL COMMENT '类型 1文字 2图片', `COLOR_` varchar(32) NULL DEFAULT NULL COMMENT '颜色 透明度', `AMOUNT_` int NULL DEFAULT NULL COMMENT '页面展示数量', `CREATE_TIME_` datetime NULL DEFAULT NULL COMMENT '创建时间', `CREATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '创建人', `UPDATE_TIME_` datetime NULL DEFAULT NULL COMMENT '更新时间', `UPDATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '更新人', `CREATE_ORG_ID_` varchar(64) NULL DEFAULT NULL COMMENT '创建人组织ID', `TENANT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '租户ID', PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '流程水印'; -- ---------------------------- -- Records of bpm_watermark -- ---------------------------- -- ---------------------------- -- Table structure for bpm_watermark_process -- ---------------------------- DROP TABLE IF EXISTS `bpm_watermark_process`; CREATE TABLE `bpm_watermark_process` ( `ID_` varchar(64) NOT NULL COMMENT 'ID', `PROC_DEF_ID_` varchar(64) NULL DEFAULT NULL COMMENT '流程ID', `PROC_DEF_KEY_` varchar(128) NULL DEFAULT NULL COMMENT '流程KEY', `PROC_DEF_NAME_` varchar(128) NULL DEFAULT NULL COMMENT '流程名称', `WATERMARK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '水印ID', `TENANT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '租户ID', PRIMARY KEY (`ID_`) USING BTREE )COMMENT = '水印分配流程'; -- ---------------------------- -- Records of bpm_watermark_process -- ---------------------------- -- ---------------------------- -- Table structure for bpm_watermark_type -- ---------------------------- DROP TABLE IF EXISTS `bpm_watermark_type`; CREATE TABLE `bpm_watermark_type` ( `ID_` varchar(64) NOT NULL COMMENT '主键', `TYPE_ID_` varchar(64) NULL DEFAULT NULL COMMENT '分类ID', `WATERMARK_ID_` varchar(64) NULL DEFAULT NULL COMMENT '水印ID', `TYPE_NAME_` varchar(256) NULL DEFAULT NULL COMMENT '分类名称', `TENANT_ID_` varchar(64) NULL DEFAULT NULL COMMENT '租户ID', PRIMARY KEY (`ID_`) USING BTREE, INDEX `IDX_WATE_TYPE_WMA_ID`(`WATERMARK_ID_` ASC) USING BTREE )COMMENT = '水印分配分类'; -- ---------------------------- -- Records of bpm_watermark_type -- ---------------------------- SET FOREIGN_KEY_CHECKS = 1;