zyml/mlxt.sql

/*
 Navicat Premium Data Transfer

 Source Server         : dokcer-mysql1
 Source Server Type    : MySQL
 Source Server Version : 80028 (8.0.28)
 Source Host           : localhost:3308
 Source Schema         : mlxt

 Target Server Type    : MySQL
 Target Server Version : 80028 (8.0.28)
 File Encoding         : 65001

 Date: 25/12/2023 16:46:20
*/

SET NAMES utf8mb4;
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) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `DATA_` longblob,
  `LOCK_OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  `IS_PROCESSED_` tinyint DEFAULT '0',
  PRIMARY KEY (`LOG_NR_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_ge_bytearray
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_bytearray`;
CREATE TABLE `act_ge_bytearray` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `REV_` int DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `BYTES_` longblob,
  `GENERATED_` tinyint DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_ge_property
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_property`;
CREATE TABLE `act_ge_property` (
  `NAME_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `VALUE_` varchar(300) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `REV_` int DEFAULT NULL,
  PRIMARY KEY (`NAME_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_hi_actinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_actinst`;
CREATE TABLE `act_hi_actinst` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `CALL_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `ACT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `ACT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`) USING BTREE,
  KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`) USING BTREE,
  KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_hi_attachment
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_attachment`;
CREATE TABLE `act_hi_attachment` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int DEFAULT NULL,
  `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `URL_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `CONTENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TIME_` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_hi_comment
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_comment`;
CREATE TABLE `act_hi_comment` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TIME_` datetime(3) NOT NULL,
  `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `ACTION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `MESSAGE_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `FULL_MSG_` longblob,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `index_act_hi_comment_proid` (`PROC_INST_ID_`) USING BTREE,
  KEY `index_act_hi_comment_action` (`ACTION_`) USING BTREE,
  KEY `index_act_hi_comment_taskid` (`TASK_ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_hi_detail
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_detail`;
CREATE TABLE `act_hi_detail` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `ACT_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `VAR_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `REV_` int DEFAULT NULL,
  `TIME_` datetime(3) NOT NULL,
  `BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint DEFAULT NULL,
  `TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`) USING BTREE,
  KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`) USING BTREE,
  KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_hi_identitylink
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_identitylink`;
CREATE TABLE `act_hi_identitylink` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `GROUP_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_hi_procinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_procinst`;
CREATE TABLE `act_hi_procinst` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `BUSINESS_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint DEFAULT NULL,
  `START_USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `START_ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `END_ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `SUPER_PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`) USING BTREE,
  KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_hi_taskinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_taskinst`;
CREATE TABLE `act_hi_taskinst` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TASK_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PARENT_TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `CLAIM_TIME_` datetime(3) DEFAULT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PRIORITY_` int DEFAULT NULL,
  `DUE_DATE_` datetime(3) DEFAULT NULL,
  `FORM_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`) USING BTREE,
  KEY `EXECUTION_ID_INDEX` (`EXECUTION_ID_`) USING BTREE,
  KEY `ID_INDEX` (`ID_`) USING BTREE,
  KEY `END_TIME_INDEX` (`END_TIME_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_hi_varinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_varinst`;
CREATE TABLE `act_hi_varinst` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `VAR_TYPE_` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `REV_` int DEFAULT NULL,
  `BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint DEFAULT NULL,
  `TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `CREATE_TIME_` datetime(3) DEFAULT NULL,
  `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`) USING BTREE,
  KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_id_group
-- ----------------------------
DROP TABLE IF EXISTS `act_id_group`;
CREATE TABLE `act_id_group` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `REV_` int DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_id_info
-- ----------------------------
DROP TABLE IF EXISTS `act_id_info`;
CREATE TABLE `act_id_info` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `REV_` int DEFAULT NULL,
  `USER_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `VALUE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PASSWORD_` longblob,
  `PARENT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_id_membership
-- ----------------------------
DROP TABLE IF EXISTS `act_id_membership`;
CREATE TABLE `act_id_membership` (
  `USER_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `GROUP_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`USER_ID_`,`GROUP_ID_`) USING BTREE,
  KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `act_id_group` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `act_id_user` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_id_user
-- ----------------------------
DROP TABLE IF EXISTS `act_id_user`;
CREATE TABLE `act_id_user` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `REV_` int DEFAULT NULL,
  `FIRST_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `LAST_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `EMAIL_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PWD_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PICTURE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_procdef_info
-- ----------------------------
DROP TABLE IF EXISTS `act_procdef_info`;
CREATE TABLE `act_procdef_info` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int DEFAULT NULL,
  `INFO_JSON_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`) USING BTREE,
  KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`) USING BTREE,
  KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_re_deployment
-- ----------------------------
DROP TABLE IF EXISTS `act_re_deployment`;
CREATE TABLE `act_re_deployment` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_re_model
-- ----------------------------
DROP TABLE IF EXISTS `act_re_model`;
CREATE TABLE `act_re_model` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `VERSION_` int DEFAULT NULL,
  `META_INFO_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `EDITOR_SOURCE_VALUE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`) USING BTREE,
  KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) USING BTREE,
  KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_re_procdef
-- ----------------------------
DROP TABLE IF EXISTS `act_re_procdef`;
CREATE TABLE `act_re_procdef` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int DEFAULT NULL,
  `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `VERSION_` int NOT NULL,
  `DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `DGRM_RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `HAS_START_FORM_KEY_` tinyint DEFAULT NULL,
  `HAS_GRAPHICAL_NOTATION_` tinyint DEFAULT NULL,
  `SUSPENSION_STATE_` int DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`,`TENANT_ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_ru_event_subscr
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_event_subscr`;
CREATE TABLE `act_ru_event_subscr` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int DEFAULT NULL,
  `EVENT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `EVENT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `ACTIVITY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `CONFIGURATION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `CREATED_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`) USING BTREE,
  KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_ru_execution
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_execution`;
CREATE TABLE `act_ru_execution` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `REV_` int DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `BUSINESS_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PARENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `SUPER_EXEC_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `IS_ACTIVE_` tinyint DEFAULT NULL,
  `IS_CONCURRENT_` tinyint DEFAULT NULL,
  `IS_SCOPE_` tinyint DEFAULT NULL,
  `IS_EVENT_SCOPE_` tinyint DEFAULT NULL,
  `SUSPENSION_STATE_` int DEFAULT NULL,
  `CACHED_ENT_STATE_` int DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`) USING BTREE,
  KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`) USING BTREE,
  KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`) USING BTREE,
  KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`) USING BTREE,
  KEY `ACT_FK_EXE_PROCDEF` (`PROC_DEF_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_ru_identitylink
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_identitylink`;
CREATE TABLE `act_ru_identitylink` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `REV_` int DEFAULT NULL,
  `GROUP_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`) USING BTREE,
  KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`) USING BTREE,
  KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`) USING BTREE,
  KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`) USING BTREE,
  KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `act_ru_task` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_ru_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_job`;
CREATE TABLE `act_ru_job` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int DEFAULT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LOCK_OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `RETRIES_` int DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_FK_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`) USING BTREE,
  KEY `idx_type_` (`TYPE_`) USING BTREE,
  CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_ru_task
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_task`;
CREATE TABLE `act_ru_task` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `REV_` int DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PARENT_TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TASK_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `DELEGATION_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PRIORITY_` int DEFAULT NULL,
  `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `DUE_DATE_` datetime(3) DEFAULT NULL,
  `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `SUSPENSION_STATE_` int DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `FORM_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`) USING BTREE,
  KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`) USING BTREE,
  KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`) USING BTREE,
  KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`) USING BTREE,
  KEY `INDEX_ASSIGNEE` (`ASSIGNEE_`) USING BTREE,
  CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for act_ru_variable
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_variable`;
CREATE TABLE `act_ru_variable` (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int DEFAULT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint DEFAULT NULL,
  `TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`) USING BTREE,
  KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`) USING BTREE,
  KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`) USING BTREE,
  KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`) 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 RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for application
-- ----------------------------
DROP TABLE IF EXISTS `application`;
CREATE TABLE `application` (
  `ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '主键',
  `OFFERDEP` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '（提供部门）',
  `APPLYDEP` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '（申请部门）',
  `APPLICANT` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '（申请人）',
  `APPLYREASON` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '（申请原因）',
  `APPLYDATE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '（申请时间）',
  `AUDITDEP` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '（审核部门）',
  `AUDITREASON` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '（审核原因）',
  `AUDITOR` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '（审核人）',
  `AUDITDATE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '（审核时间）',
  `RECORDEP` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '（审核部门）',
  `RECORDMAN` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '（审核人）',
  `RECORDDATE` datetime DEFAULT NULL COMMENT '（审核时间）',
  `STATE` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '（状态）',
  `INFOCLASSNAMES` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '（记录的信息类名称）',
  `INFOCLASSIDS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '（记录的信息类id）',
  `APPLYTYPE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '（申请类型）',
  `SYSTEMCODE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '数据显示部门code',
  `CATALOGDEPTID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '编目处室id',
  `CATALOGORGID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '编目审核部门id',
  `CATALOGORGGNAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '编目审核部门名称',
  `AUDITOPINION` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '审核意见',
  `COORDOPINION` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '协调意见',
  `CONFIGTYPE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '配置实施管理',
  `REGION_CODE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for apply_class
-- ----------------------------
DROP TABLE IF EXISTS `apply_class`;
CREATE TABLE `apply_class` (
  `ID` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `T_INFOCLASS_DATAMETA_ID` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '信息项id',
  `T_SHAREAPPLY_ID` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '共享申请id',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for code
-- ----------------------------
DROP TABLE IF EXISTS `code`;
CREATE TABLE `code` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CATEGORY` decimal(10,0) DEFAULT NULL,
  `CODE_CODE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CODE_INDEX` decimal(10,0) DEFAULT NULL,
  `CODE_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CODE_TYPE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CODE_TYPE_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATE_TIME` datetime(6) DEFAULT NULL,
  `CREATOR_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REMARK` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `STATE` decimal(10,0) DEFAULT NULL,
  `UPDATE_TIME` datetime(6) DEFAULT NULL,
  `UPDATER_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PARENT_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CODE_VALUE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for comp
-- ----------------------------
DROP TABLE IF EXISTS `comp`;
CREATE TABLE `comp` (
  `COMP_ID` decimal(19,0) NOT NULL,
  `COMP_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`COMP_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for current_infoclass
-- ----------------------------
DROP TABLE IF EXISTS `current_infoclass`;
CREATE TABLE `current_infoclass` (
  `dept_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '单位ID',
  `tablename` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '表名称',
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '时间戳',
  KEY `idx_tablename` (`tablename`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='展示版信息类信息';

-- ----------------------------
-- Table structure for data_count
-- ----------------------------
DROP TABLE IF EXISTS `data_count`;
CREATE TABLE `data_count` (
  `infocode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `rowcount` decimal(16,0) DEFAULT '0',
  PRIMARY KEY (`infocode`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for datacount_all
-- ----------------------------
DROP TABLE IF EXISTS `datacount_all`;
CREATE TABLE `datacount_all` (
  `infocode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '信息类code',
  `rowcount` decimal(16,0) DEFAULT '0' COMMENT '数据量',
  PRIMARY KEY (`infocode`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT COMMENT='汇聚数据量统计';

-- ----------------------------
-- Table structure for dept_res
-- ----------------------------
DROP TABLE IF EXISTS `dept_res`;
CREATE TABLE `dept_res` (
  `DEPT_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `RES_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`DEPT_ID`,`RES_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for dept_user
-- ----------------------------
DROP TABLE IF EXISTS `dept_user`;
CREATE TABLE `dept_user` (
  `USER_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DEPT_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`DEPT_ID`,`USER_ID`) USING BTREE,
  KEY `index_deptuser_deptid` (`DEPT_ID`) USING BTREE,
  KEY `index_deptuser_userid` (`USER_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for deptinfo
-- ----------------------------
DROP TABLE IF EXISTS `deptinfo`;
CREATE TABLE `deptinfo` (
  `DEPT_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DEPT_DESC` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPT_INDEX` decimal(65,0) DEFAULT NULL,
  `DEPT_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPT_STATE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPT_TYPE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPT_URL` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PARENT_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATE_TIME` datetime(6) DEFAULT NULL,
  `CREATOR_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `UPDATER_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `FLAG` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REMARK` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `YWBMNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务部门名称',
  `YWBMCODE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务部门编码',
  `XZQHNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '行政区划名称',
  `XZQHCODE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '行政区划编码',
  `CREDITNO` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '统一社会信用代码',
  `YWBMID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务部门对应数据字典',
  `XZQHID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '行政区划对应数据字典',
  `PDEPTIDS` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `pdept_id` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '父节点ids',
  `DEPT_ABBREVIATION` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '机构简称',
  `DEPT_PROPERTY` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPT_TEL` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`DEPT_ID`) USING BTREE,
  UNIQUE KEY `DEPT_ID` (`DEPT_ID`) USING BTREE,
  KEY `PARENT_ID` (`PARENT_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for deptinfo_copy1
-- ----------------------------
DROP TABLE IF EXISTS `deptinfo_copy1`;
CREATE TABLE `deptinfo_copy1` (
  `DEPT_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DEPT_DESC` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPT_INDEX` decimal(65,0) DEFAULT NULL,
  `DEPT_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPT_STATE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPT_TYPE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPT_URL` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PARENT_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATE_TIME` datetime(6) DEFAULT NULL,
  `CREATOR_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `UPDATER_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `FLAG` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REMARK` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `YWBMNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务部门名称',
  `YWBMCODE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务部门编码',
  `XZQHNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '行政区划名称',
  `XZQHCODE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '行政区划编码',
  `CREDITNO` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '统一社会信用代码',
  `YWBMID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务部门对应数据字典',
  `XZQHID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '行政区划对应数据字典',
  `PDEPTIDS` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `pdept_id` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '父节点ids',
  `DEPT_ABBREVIATION` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '机构简称',
  `DEPT_PROPERTY` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  UNIQUE KEY `DEPT_ID` (`DEPT_ID`) USING BTREE,
  KEY `PARENT_ID` (`PARENT_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for deptinfo_copy2
-- ----------------------------
DROP TABLE IF EXISTS `deptinfo_copy2`;
CREATE TABLE `deptinfo_copy2` (
  `DEPT_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DEPT_DESC` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPT_INDEX` decimal(65,0) DEFAULT NULL,
  `DEPT_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPT_STATE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPT_TYPE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPT_URL` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PARENT_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATE_TIME` datetime(6) DEFAULT NULL,
  `CREATOR_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `UPDATER_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `FLAG` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REMARK` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `YWBMNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务部门名称',
  `YWBMCODE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务部门编码',
  `XZQHNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '行政区划名称',
  `XZQHCODE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '行政区划编码',
  `CREDITNO` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '统一社会信用代码',
  `YWBMID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务部门对应数据字典',
  `XZQHID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '行政区划对应数据字典',
  `PDEPTIDS` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `pdept_id` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '父节点ids',
  `DEPT_ABBREVIATION` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '机构简称',
  `DEPT_PROPERTY` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  UNIQUE KEY `DEPT_ID` (`DEPT_ID`) USING BTREE,
  KEY `PARENT_ID` (`PARENT_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for gxwz_codevalue_picurl_rel
-- ----------------------------
DROP TABLE IF EXISTS `gxwz_codevalue_picurl_rel`;
CREATE TABLE `gxwz_codevalue_picurl_rel` (
  `ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CATEGORY_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '目录名称',
  `CATEGORY_CODE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编码',
  `PARENT_CODE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '父节点code【父节点为部门时，code为上四级父节点code的拼接】',
  `PARENT_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '父节点',
  `PIC_URL` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '图片存储路径',
  `IS_SHOW` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否显示  0：不显示  1：显示',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for gxwz_codevalue_picurl_rel2
-- ----------------------------
DROP TABLE IF EXISTS `gxwz_codevalue_picurl_rel2`;
CREATE TABLE `gxwz_codevalue_picurl_rel2` (
  `ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CATEGORY_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '目录名称',
  `CATEGORY_CODE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编码',
  `PARENT_CODE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '父节点code【父节点为部门时，code为上四级父节点code的拼接】',
  `PARENT_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '父节点',
  `PIC_URL` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '图片存储路径',
  `IS_SHOW` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否显示  0：不显示  1：显示',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for gxwz_infoclass_catalog_rel
-- ----------------------------
DROP TABLE IF EXISTS `gxwz_infoclass_catalog_rel`;
CREATE TABLE `gxwz_infoclass_catalog_rel` (
  `INFOCLASS_CODE` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '信息类的编码',
  `INFOCLASS_NAME` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '信息类名称',
  `INFOCLASS_DEPT` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '信息类提供方',
  `ISHANGON` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否挂接（是否与编目表关联）',
  `CATALOG_TABLE_NAME` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '编目名称',
  `CATALOG_TABLE_TIMECOLUM` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '时间戳字段',
  `EXCHANGE_COUNT` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '数据交换量',
  `VISIT_COUNT` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '访问量',
  `APPLY_COUNT` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请次数',
  `SUBSCRIBE_COUNT` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订阅量',
  `CATALOG_TABLE_LASTTIME` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '最后更新时间',
  `rowcount` decimal(16,0) DEFAULT NULL COMMENT '数据量',
  `createtime` datetime DEFAULT NULL,
  `updatetime` datetime DEFAULT NULL,
  PRIMARY KEY (`INFOCLASS_CODE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for last_infoclass
-- ----------------------------
DROP TABLE IF EXISTS `last_infoclass`;
CREATE TABLE `last_infoclass` (
  `dept_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '单位ID',
  `tablename` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '表名称',
  `updatecycle` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sharemodetype` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `isopensocial` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否开放',
  `shijian` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='定版信息类信息';

-- ----------------------------
-- Table structure for loadingcache
-- ----------------------------
DROP TABLE IF EXISTS `loadingcache`;
CREATE TABLE `loadingcache` (
  `LOADNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '??????',
  `LOADTIME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '????????????',
  `ISBLOCKED` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '??????????',
  `ERRORLOADNUMS` decimal(65,0) DEFAULT NULL COMMENT '????????????',
  PRIMARY KEY (`LOADNAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for loginfo
-- ----------------------------
DROP TABLE IF EXISTS `loginfo`;
CREATE TABLE `loginfo` (
  `LOGID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `LOGTIME` datetime(6) DEFAULT NULL,
  `LOGIP` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `LOGUSERNAME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `LOGUSERID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `LOGTYPE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `LOGDETAIL` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `LOGMOKUAI` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `LOGTABLE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DATAID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `LOGURL` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`LOGID`) USING BTREE,
  KEY `dataid_index` (`DATAID`) USING BTREE,
  KEY `logtable_index` (`LOGTABLE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `MENU_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CONTROLLER_CLASS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATE_TIME` datetime(6) DEFAULT NULL,
  `CREATOR_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `FLAG` decimal(10,0) DEFAULT NULL,
  `MENU_DESC` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `MENU_INDEX` decimal(10,0) DEFAULT NULL,
  `MENU_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `MENU_URL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REMARK` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `SMALL_ICON_PATH` longblob,
  `UPDATE_TIME` datetime(6) DEFAULT NULL,
  `UPDATER_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PARENT_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ICON_PATH` longblob,
  `ICON_CLS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ISSENSIVITE` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否敏感资源',
  PRIMARY KEY (`MENU_ID`) USING BTREE,
  KEY `index_parentid` (`PARENT_ID`) USING BTREE,
  KEY `index_menuurl` (`MENU_URL`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for mh_model
-- ----------------------------
DROP TABLE IF EXISTS `mh_model`;
CREATE TABLE `mh_model` (
  `MH_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模版信息的数据主键标识',
  `MH_ZYID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '模版信息的业务标识，唯一',
  `MH_ZYNAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '模版信息类的中文名称',
  `MH_ZYDEPTID` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '信息资源提供部门',
  `CREATE_TIME` datetime(6) NOT NULL COMMENT '数据创建时间',
  `UPDATE_TIME` datetime(6) DEFAULT NULL COMMENT '数据修改的时间',
  `CREATE_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '模版创建人员姓名',
  `UPDATE_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '模版修改人员姓名',
  `MH_MODELNAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '模版文件名称',
  `MH_MODELADDRES` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '模板文件存放路径',
  `MH_MODELSTATUS` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '上传文件的类型',
  `UPLOAD_TIME` datetime(6) DEFAULT NULL COMMENT '上传时间已最终为准',
  `ISDELETE` decimal(65,0) DEFAULT NULL,
  `MH_ZYDEPTNAME` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '信息资源提供部门',
  `MH_XXTABLECNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '信息类在中心库的表名  中文',
  `MH_XXTABLENAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '信息类在中心库的表名 英文',
  PRIMARY KEY (`MH_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for mh_model_datas
-- ----------------------------
DROP TABLE IF EXISTS `mh_model_datas`;
CREATE TABLE `mh_model_datas` (
  `MH_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '任务的数据主键标识',
  `MH_MODELNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '模版信息的业务标识，唯一',
  `MH_ZYDEPTID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '信息资源提供部门',
  `CREATE_TIME` datetime(6) DEFAULT NULL COMMENT '上传时间',
  `CREATE_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '上传人',
  `PUBLISHER_TIME` datetime(6) DEFAULT NULL COMMENT '发布时间',
  `STATUS` decimal(1,0) NOT NULL,
  `DATANUM` decimal(65,0) DEFAULT NULL COMMENT '"导入数据条数"',
  PRIMARY KEY (`MH_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for mh_model_dept
-- ----------------------------
DROP TABLE IF EXISTS `mh_model_dept`;
CREATE TABLE `mh_model_dept` (
  `MH_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `MODEL_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPT_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`MH_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for mh_modeltask
-- ----------------------------
DROP TABLE IF EXISTS `mh_modeltask`;
CREATE TABLE `mh_modeltask` (
  `MH_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '任务的数据主键标识',
  `MH_ZYID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '模版信息的业务标识，唯一',
  `MH_ZYDEPTID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '信息资源提供部门',
  `PUBLISHER` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务操作员-发布人',
  `PUBLISHER_STATUS` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '默认为0，发布为1，撤销为0',
  `PUBLISHER_TIME` datetime(6) DEFAULT NULL COMMENT '发布时间',
  PRIMARY KEY (`MH_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for qrtz_blob_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
CREATE TABLE `qrtz_blob_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `BLOB_DATA` longblob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for qrtz_calendars
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_calendars`;
CREATE TABLE `qrtz_calendars` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CALENDAR` longblob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for qrtz_cron_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
CREATE TABLE `qrtz_cron_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CRON_EXPRESSION` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TIME_ZONE_ID` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for qrtz_fired_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
CREATE TABLE `qrtz_fired_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ENTRY_ID` varchar(95) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `FIRED_TIME` decimal(13,0) NOT NULL,
  `SCHED_TIME` decimal(13,0) NOT NULL,
  `PRIORITY` decimal(13,0) NOT NULL,
  `STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`) USING BTREE,
  KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`) USING BTREE,
  KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`) USING BTREE,
  KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for qrtz_job_details
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_job_details`;
CREATE TABLE `qrtz_job_details` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `IS_DURABLE` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `IS_UPDATE_DATA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_DATA` longblob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for qrtz_locks
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_locks`;
CREATE TABLE `qrtz_locks` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `LOCK_NAME` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for qrtz_paused_trigger_grps
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
CREATE TABLE `qrtz_paused_trigger_grps` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for qrtz_scheduler_state
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
CREATE TABLE `qrtz_scheduler_state` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `LAST_CHECKIN_TIME` decimal(13,0) NOT NULL,
  `CHECKIN_INTERVAL` decimal(13,0) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for qrtz_simple_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
CREATE TABLE `qrtz_simple_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `REPEAT_COUNT` decimal(7,0) NOT NULL,
  `REPEAT_INTERVAL` decimal(12,0) NOT NULL,
  `TIMES_TRIGGERED` decimal(10,0) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for qrtz_simprop_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
CREATE TABLE `qrtz_simprop_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `STR_PROP_1` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `STR_PROP_2` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `STR_PROP_3` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `INT_PROP_1` decimal(10,0) DEFAULT NULL,
  `INT_PROP_2` decimal(10,0) DEFAULT NULL,
  `LONG_PROP_1` decimal(13,0) DEFAULT NULL,
  `LONG_PROP_2` decimal(13,0) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for qrtz_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_triggers`;
CREATE TABLE `qrtz_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `NEXT_FIRE_TIME` decimal(13,0) DEFAULT NULL,
  `PREV_FIRE_TIME` decimal(13,0) DEFAULT NULL,
  `PRIORITY` decimal(13,0) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_TYPE` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `START_TIME` decimal(13,0) NOT NULL,
  `END_TIME` decimal(13,0) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `MISFIRE_INSTR` decimal(2,0) DEFAULT NULL,
  `JOB_DATA` longblob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`) USING BTREE,
  KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`) USING BTREE,
  KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`) USING BTREE,
  KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`) USING BTREE,
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`) USING BTREE,
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
  KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
  KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
  KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`) USING BTREE,
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for r_infoclass_lifeinfo
-- ----------------------------
DROP TABLE IF EXISTS `r_infoclass_lifeinfo`;
CREATE TABLE `r_infoclass_lifeinfo` (
  `taskstart` datetime DEFAULT NULL,
  `taskname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `info_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `infocode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `state` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `uuid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `versionid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='信息类生命周期表';

-- ----------------------------
-- Table structure for rkrm_zl_probeinfo
-- ----------------------------
DROP TABLE IF EXISTS `rkrm_zl_probeinfo`;
CREATE TABLE `rkrm_zl_probeinfo` (
  `TABLENAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '表名称',
  `PKNUM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '主键字段数量',
  `FKNUM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '外键字段数量',
  `COLNUM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '字段数量',
  `NOTNULLNUM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '必填字段数量',
  `RECNUM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '记录数',
  `NULLRATIO` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '空值率',
  `NULLVALUENUM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '空值比',
  `TCTIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '入库时间',
  KEY `idx_tablename` (`TABLENAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='空值率统计表';

-- ----------------------------
-- Table structure for rkrm_zl_probeinfo_copy
-- ----------------------------
DROP TABLE IF EXISTS `rkrm_zl_probeinfo_copy`;
CREATE TABLE `rkrm_zl_probeinfo_copy` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DBID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TABLENAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '表名称',
  `PKNUM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '主键字段数量',
  `FKNUM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '外键字段数量',
  `COLNUM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '字段数量',
  `NOTNULLNUM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '必填字段数量',
  `RECNUM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '记录数',
  `NULLRATIO` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '空值率',
  `NULLVALUENUM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '空值比',
  `TCTIME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '入库时间',
  `DWID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `USERID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='空值率统计表';

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `ROLE_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CREATE_TIME` datetime(6) DEFAULT NULL,
  `CREATOR_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `FLAG` decimal(10,0) DEFAULT NULL,
  `REMARK` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ROLE_DESCRIPTION` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ROLE_INDEX` decimal(10,0) DEFAULT NULL,
  `ROLE_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `SHOW_USERS` decimal(10,0) DEFAULT NULL,
  `UPDATE_TIME` datetime(6) DEFAULT NULL,
  `UPDATER_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ROLE_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for role_menu
-- ----------------------------
DROP TABLE IF EXISTS `role_menu`;
CREATE TABLE `role_menu` (
  `MENU_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ROLE_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ADD_PRIV` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '增加权限',
  `EDIT_PRIV` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改权限',
  `VIEW_PRIV` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '查看权限',
  `DELETE_PRIV` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '删除权限',
  `IMP_PRIV` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '导入权限',
  `EXP_PRIV` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '导出权限',
  PRIMARY KEY (`MENU_ID`,`ROLE_ID`) USING BTREE,
  KEY `index_rolemenu_menuid` (`MENU_ID`) USING BTREE,
  KEY `index_rolemenu_roleid` (`ROLE_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for role_user
-- ----------------------------
DROP TABLE IF EXISTS `role_user`;
CREATE TABLE `role_user` (
  `ROLE_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `USER_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`USER_ID`,`ROLE_ID`) USING BTREE,
  KEY `index_roleid` (`ROLE_ID`) USING BTREE,
  KEY `index_userid` (`USER_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for role_user_20200131
-- ----------------------------
DROP TABLE IF EXISTS `role_user_20200131`;
CREATE TABLE `role_user_20200131` (
  `ROLE_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `USER_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`USER_ID`,`ROLE_ID`) USING BTREE,
  KEY `index_roleid` (`ROLE_ID`) USING BTREE,
  KEY `index_userid` (`USER_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for role_user_copy1
-- ----------------------------
DROP TABLE IF EXISTS `role_user_copy1`;
CREATE TABLE `role_user_copy1` (
  `ROLE_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `USER_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`USER_ID`,`ROLE_ID`) USING BTREE,
  KEY `index_roleid` (`ROLE_ID`) USING BTREE,
  KEY `index_userid` (`USER_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for subscribemanage
-- ----------------------------
DROP TABLE IF EXISTS `subscribemanage`;
CREATE TABLE `subscribemanage` (
  `ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `INFOCLASSNAMES` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '信息类名称',
  `INFOCLASSIDS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '信息类id',
  `CREATENAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订阅人',
  `CREATENAMEID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订阅人id',
  `OFFICEREVIEWNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '所在处室',
  `OFFICEREVIEWNAMEID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '所在处室id',
  `DEPARTREVIEWNAMEID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '所在部门id',
  `DEPARTREVIEWNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '所在部门',
  `SUBSCRIBEDATE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订阅时间',
  `STATE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订阅状态1订阅;2取消订阅',
  `UNSUBSCRIDATE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '取消订阅时间',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='信息类订阅信息表';

-- ----------------------------
-- Table structure for t
-- ----------------------------
DROP TABLE IF EXISTS `t`;
CREATE TABLE `t` (
  `t_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_area_info
-- ----------------------------
DROP TABLE IF EXISTS `t_area_info`;
CREATE TABLE `t_area_info` (
  `AREAID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `CODE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '编码',
  `AREATYPE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '区域类型',
  `AREANAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '区域名称',
  `REMARK` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
  `PID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '父级id',
  `PIDS` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '父级ids',
  `INDEX_NUM` decimal(65,0) DEFAULT NULL COMMENT '排序值',
  `CREATOR` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建者',
  `CREATORID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建者id',
  `UPDATOR` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '更新者',
  `UPDATORID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '更新者id',
  `CREATEDATE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建时间 yyyy-MM-dd hh:mm:ss',
  `UPDATEDATE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '更新时间 yyyy-MM-dd hh:mm:ss',
  `STATE` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否删除0正常,1删除',
  PRIMARY KEY (`AREAID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='区域信息表';

-- ----------------------------
-- Table structure for t_authinfo
-- ----------------------------
DROP TABLE IF EXISTS `t_authinfo`;
CREATE TABLE `t_authinfo` (
  `id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ak` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sk` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `authtoken` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_batchapply_info
-- ----------------------------
DROP TABLE IF EXISTS `t_batchapply_info`;
CREATE TABLE `t_batchapply_info` (
  `batchid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `batchtime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '批量申请时间',
  `batchuser` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '批量申请人员id',
  `batchtype` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '批量申请类型 0 信息类批量申请 1 服务接口批量申请',
  PRIMARY KEY (`batchid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_batchapply_subinfo
-- ----------------------------
DROP TABLE IF EXISTS `t_batchapply_subinfo`;
CREATE TABLE `t_batchapply_subinfo` (
  `subid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `batchid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '批量申请单id',
  `applyid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请表id',
  `applytype` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请类型 0 信息类批量申请 1 服务接口批量申请',
  PRIMARY KEY (`subid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_business_item
-- ----------------------------
DROP TABLE IF EXISTS `t_business_item`;
CREATE TABLE `t_business_item` (
  `ITEM_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '业务事项id',
  `ITEM_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务事项名称',
  `ITEM_CODE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务事项编码',
  `ITEM_TYPE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务事项类型',
  `ITEM_DES` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '业务事项描述',
  `CREATOR` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATOR_NAME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATE_TIME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR_NAME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATE_TIME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `LYBM` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '来源部门',
  `ZXMC` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ITEM_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='业务事项信息表';

-- ----------------------------
-- Table structure for t_businessitem_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_businessitem_detail`;
CREATE TABLE `t_businessitem_detail` (
  `DETAIL_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ITEM_ID` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '事项id',
  `DETAIL_NAME` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '细项名称',
  `DETAIL_DES` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '细项说明',
  `INFOCLASS_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否匹配信息类,若匹配：信息类id,若不匹配，为空',
  `DETAIL_TYPE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DETAIL_SOURCE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ZHENGZHAO` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ZHENGZHAOID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`DETAIL_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='业务事项细项要素信息';

-- ----------------------------
-- Table structure for t_businessitem_infoclass
-- ----------------------------
DROP TABLE IF EXISTS `t_businessitem_infoclass`;
CREATE TABLE `t_businessitem_infoclass` (
  `DATAID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ITEMID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ITEMNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `INFOCLASSID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `INFOCLASSNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`DATAID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='信息类与业务事项关系表';

-- ----------------------------
-- Table structure for t_businessitem_shareapply
-- ----------------------------
DROP TABLE IF EXISTS `t_businessitem_shareapply`;
CREATE TABLE `t_businessitem_shareapply` (
  `RELATIONSHIP_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `APPLYID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ITEM_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ITEM_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`RELATIONSHIP_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='业务事项与共享申请关系信息表';

-- ----------------------------
-- Table structure for t_businessitem_systeminfo
-- ----------------------------
DROP TABLE IF EXISTS `t_businessitem_systeminfo`;
CREATE TABLE `t_businessitem_systeminfo` (
  `RELATIONSHIP_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `SYSTEMINFO_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ITEM_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`RELATIONSHIP_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='业务事项与业务系统关系表';

-- ----------------------------
-- Table structure for t_bussiness_processinfo
-- ----------------------------
DROP TABLE IF EXISTS `t_bussiness_processinfo`;
CREATE TABLE `t_bussiness_processinfo` (
  `id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `busid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `processid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `createtime` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `creator` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `bustable` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_changeapply
-- ----------------------------
DROP TABLE IF EXISTS `t_changeapply`;
CREATE TABLE `t_changeapply` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `APPLYDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请日期',
  `APPLYDEPTID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请部门id',
  `APPLYDEPTNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请部门名称',
  `APPLYREASON` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '变更原因',
  `APPLYUSERID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请人id',
  `APPLYUSERNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请人名称',
  `STATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '数据状态 0:保存 1:待审核 2:审核通过 3:审核不通过 4:删除',
  `UPDATOR_ORG_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATETIME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR_ORG` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TINFOCLASSID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CHECKREASON` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核意见',
  `CHECKUSER` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人id',
  `CHECKUSERNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人名',
  `CHECKDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核时间',
  `CHECKORG` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核部门id',
  `CHECKORGNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核部门名称',
  `LATESTTINFOCLASSID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '变更后信息类id',
  `TREQCONF_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `GUAJIE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  KEY `TINFOCLASSID` (`TINFOCLASSID`) USING BTREE,
  CONSTRAINT `t_changeapply_ibfk_1` FOREIGN KEY (`TINFOCLASSID`) REFERENCES `t_infoclass` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='变更申请表';

-- ----------------------------
-- Table structure for t_codeset
-- ----------------------------
DROP TABLE IF EXISTS `t_codeset`;
CREATE TABLE `t_codeset` (
  `ID` varchar(100) NOT NULL COMMENT '主键uuid',
  `CODESET_ID` varchar(200) DEFAULT NULL COMMENT '代码集编码',
  `CODESET_NAME` varchar(200) DEFAULT NULL COMMENT '代码集名称',
  `CODESET_DETAIL` text COMMENT '代码集说明',
  `STATE` varchar(10) DEFAULT NULL COMMENT '代码集状态: 0.删除,1.保存,2.提交,3.待启用,4.启用,5.禁用,6审核通过,7退回修改',
  `LEVEL_TYPE` varchar(10) DEFAULT NULL COMMENT '采用标准0-国家标准，1-省级标准2.地方标准3.行业标准，4-其他标准',
  `CREATOR_ORG` varchar(200) DEFAULT NULL COMMENT '创建者所在部门id',
  `CREATOR` varchar(200) DEFAULT NULL COMMENT ' 创建者id',
  `CREATOR_NAME` varchar(200) DEFAULT NULL COMMENT '创建人员姓名',
  `CREATEDATE` varchar(200) DEFAULT NULL COMMENT '创建时间  保存为 yyyy-MM-dd hh:mm:ss',
  `UPDATEDATE` varchar(200) DEFAULT NULL COMMENT '更新时间  保存为 yyyy-MM-dd hh:mm:ss',
  `UPDATOR_ORG` varchar(200) DEFAULT NULL COMMENT '修改者部门id',
  `LEVEL_NAME` varchar(200) DEFAULT NULL COMMENT '采用标准:中文显示',
  `CODESET_INDEX` decimal(65,0) DEFAULT NULL COMMENT '代码集顺序',
  `CHECKDATE` varchar(255) DEFAULT NULL COMMENT '审核日期',
  `CHECKER` varchar(255) DEFAULT NULL COMMENT '审核人id',
  `CHECKER_NAME` varchar(255) DEFAULT NULL COMMENT '审核人员名称',
  `CHECKER_ORG` varchar(255) DEFAULT NULL COMMENT '审核人机构id',
  `CHECKER_ORG_NAME` varchar(255) DEFAULT NULL COMMENT '审核人所在机构名称',
  `CREATOR_ORGNAME` varchar(255) DEFAULT NULL COMMENT '创建者部门名称',
  `LEVEL_ID` varchar(255) DEFAULT NULL COMMENT '采用标准对应数据字典id',
  `UPDATOR_ORG_NAME` varchar(255) DEFAULT NULL COMMENT '修改者部门名称',
  `UPDATETIME` varchar(255) DEFAULT NULL COMMENT '修改时间',
  `UPDATOR` varchar(255) DEFAULT NULL COMMENT '修改人员id',
  `UPDATOR_NAME` varchar(255) DEFAULT NULL COMMENT '修改者姓名',
  `XZQHCODE` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='代码集信息表';

-- ----------------------------
-- Table structure for t_codeset_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_codeset_detail`;
CREATE TABLE `t_codeset_detail` (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `FID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '与代码集信息表主键关联',
  `CODENUM` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '代码',
  `CODENAME` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '代码名称',
  `DESCRIPTION` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '描述',
  `CODE_INDEX` decimal(65,0) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`ID`) USING BTREE,
  KEY `FID` (`FID`) USING BTREE,
  CONSTRAINT `t_codeset_detail_ibfk_1` FOREIGN KEY (`FID`) REFERENCES `t_codeset` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='代码集详细信息表';

-- ----------------------------
-- Table structure for t_common_aduitrecord
-- ----------------------------
DROP TABLE IF EXISTS `t_common_aduitrecord`;
CREATE TABLE `t_common_aduitrecord` (
  `id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `busid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务id',
  `bustable` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '对应业务表',
  `aduitresult` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核结果',
  `aduitopinion` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核意见',
  `aduitman` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人',
  `aduitid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人id',
  `aduitdeptname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人部门名称',
  `aduitdeptid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人部门id',
  `aduitdate` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核时间',
  `taskname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '环节名称',
  `aduitrole` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '经办角色',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='通用审核记录表';

-- ----------------------------
-- Table structure for t_data_preparation
-- ----------------------------
DROP TABLE IF EXISTS `t_data_preparation`;
CREATE TABLE `t_data_preparation` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ATTANAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ATTAURL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATETIME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATOR` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATORNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DATADESC` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PROCESSID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REQUIREID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `STATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATETIME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATORNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CLASSID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DATAITEMID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_datameta
-- ----------------------------
DROP TABLE IF EXISTS `t_datameta`;
CREATE TABLE `t_datameta` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CHECKDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CHECKER` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CHECKER_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CHECKER_ORG` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CHECKER_ORG_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATEDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATOR` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATOR_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATOR_ORG` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATOR_ORGNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DATASIZE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DATATYPE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DATATYPE_DIS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DATATYPEID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DESCRIPTION` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `METACODE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `METACODE_DIS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `METACODEID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `METANAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `RANGES` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `STATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR_ORG_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATETIME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR_ORG` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CODESETID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `AUDITDESCRIPT` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `DATACODE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `XZQHCODE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  KEY `CODESETID` (`CODESETID`) USING BTREE,
  CONSTRAINT `t_datameta_ibfk_1` FOREIGN KEY (`CODESETID`) REFERENCES `t_codeset` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='数据元信息表';

-- ----------------------------
-- Table structure for t_datameta_opinion
-- ----------------------------
DROP TABLE IF EXISTS `t_datameta_opinion`;
CREATE TABLE `t_datameta_opinion` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CHECKDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CHECKER` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CHECKER_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CHECKER_ORG` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CHECKER_ORGNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `AUDITDESCRIPT` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DATAMETAID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKRESULT` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for t_dbinfo
-- ----------------------------
DROP TABLE IF EXISTS `t_dbinfo`;
CREATE TABLE `t_dbinfo` (
  `db_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `db_deptid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '部门id',
  `db_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '数据库名称',
  `db_connectname` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '连接名称',
  `db_type` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '类型',
  `db_port` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '端口',
  `db_ip` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '数据库地址',
  `db_username` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户名',
  `db_pwd` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '数据库密码',
  `db_flag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `jdbcurl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'jdbcurl',
  `db_contactname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人名称',
  `db_contactphone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人电话',
  PRIMARY KEY (`db_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_gjpt_servicefiles
-- ----------------------------
DROP TABLE IF EXISTS `t_gjpt_servicefiles`;
CREATE TABLE `t_gjpt_servicefiles` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `SERVICE_CODE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `LINK_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `FILE_NAME` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `FILE_PATH` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='接口服务附件表';

-- ----------------------------
-- Table structure for t_gjpt_serviceinfo
-- ----------------------------
DROP TABLE IF EXISTS `t_gjpt_serviceinfo`;
CREATE TABLE `t_gjpt_serviceinfo` (
  `SERVICE_CODE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '服务代码',
  `OPEN_SERVICE_NAME` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '接口中文名称',
  `CATA_TITLE` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '所属目录',
  `DEPT` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '接口提供方',
  `VERSION` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '接口版本',
  `PUBLISH_DATE` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '注册时间',
  `SERVICE_DES` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '接口描述',
  `REGISTER` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '接口注册者姓名',
  `VALIDITY_DATE` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '有效期',
  `LINK_ID` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '连接标识',
  PRIMARY KEY (`SERVICE_CODE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='国家平台接口信息表';

-- ----------------------------
-- Table structure for t_guajieopinion_list
-- ----------------------------
DROP TABLE IF EXISTS `t_guajieopinion_list`;
CREATE TABLE `t_guajieopinion_list` (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `dataid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '数据id',
  `datatype` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '信息类或者服务',
  `opinion` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '审核意见',
  `checkuser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人',
  `checkdate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核时间',
  `result` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核结果',
  `checkusername` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idxdatatype` (`datatype`) USING BTREE,
  KEY `idx_dataid` (`dataid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='挂接审核意见表';

-- ----------------------------
-- Table structure for t_indicators
-- ----------------------------
DROP TABLE IF EXISTS `t_indicators`;
CREATE TABLE `t_indicators` (
  `id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `insertdate` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `state` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `deptid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ywfgl_c` double DEFAULT NULL,
  `ywfgl_f` double DEFAULT NULL,
  `ywfgl_value` double DEFAULT NULL,
  `ywfgl_score` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ywfgl_per` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `yyfgl_c` double DEFAULT NULL,
  `yyfgl_f` double DEFAULT NULL,
  `yyfgl_value` double DEFAULT NULL,
  `yyfgl_score` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `yyfgl_per` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `qzgll_c` double DEFAULT NULL,
  `qzgll_f` double DEFAULT NULL,
  `qzgll_value` double DEFAULT NULL,
  `qzgll_score` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `qzgll_per` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `xtgll_c` double DEFAULT NULL,
  `xtgll_f` double DEFAULT NULL,
  `xtgll_value` double DEFAULT NULL,
  `xtgll_score` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `xtgll_per` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `gjl_c` double DEFAULT NULL,
  `gjl_f` double DEFAULT NULL,
  `gjl_value` double DEFAULT NULL,
  `gjl_score` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `gjl_per` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `kbl_c` double DEFAULT NULL,
  `kbl_f` double DEFAULT NULL,
  `kbl_value` double DEFAULT NULL,
  `kbl_score` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `kbl_per` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sjgx_c` double DEFAULT NULL,
  `sjgx_f` double DEFAULT NULL,
  `sjgx_value` double DEFAULT NULL,
  `sjgx_score` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sjgx_per` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `kzl_c` double DEFAULT NULL,
  `kzl_f` double DEFAULT NULL,
  `kzl_value` double DEFAULT NULL,
  `kzl_score` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `kzl_per` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `mlsh_c` double DEFAULT NULL,
  `mlsh_f` double DEFAULT NULL,
  `mlsh_value` double DEFAULT NULL,
  `mlsh_score` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `mlsh_per` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `gjsh_c` double DEFAULT NULL,
  `gjsh_f` double DEFAULT NULL,
  `gjsh_value` double DEFAULT NULL,
  `gjsh_score` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `gjsh_per` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `total_score` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_deptid` (`deptid`) USING BTREE,
  KEY `idx_state` (`state`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='指标项';

-- ----------------------------
-- Table structure for t_infoclass
-- ----------------------------
DROP TABLE IF EXISTS `t_infoclass`;
CREATE TABLE `t_infoclass` (
  `ID` varchar(255) NOT NULL COMMENT '主键',
  `CREATEDATE` varchar(255) DEFAULT NULL COMMENT '创建时间',
  `CREATOR` varchar(255) DEFAULT NULL COMMENT '创建者id',
  `CREATOR_NAME` varchar(255) DEFAULT NULL COMMENT '创建者姓名',
  `CREATOR_ORG` varchar(255) DEFAULT NULL COMMENT '创建者机构id',
  `CREATOR_ORGNAME` varchar(255) DEFAULT NULL COMMENT '创建者机构名称',
  `DATARANGE` varchar(255) DEFAULT NULL COMMENT '数据范围',
  `FORMATTYPE` varchar(255) DEFAULT NULL COMMENT '信息资源格式',
  `FORMATTYPEID` varchar(255) DEFAULT NULL COMMENT '信息资源格式id',
  `FORMATTYPENAME` varchar(255) DEFAULT NULL COMMENT '信息资源格式中文',
  `INFOABSTRACTS` text COMMENT '信息类摘要',
  `INFOCODE` varchar(255) DEFAULT NULL COMMENT '信息类编码',
  `INFONAME` varchar(255) DEFAULT NULL COMMENT '信息类名称',
  `INFOTYPE` varchar(255) DEFAULT NULL COMMENT '资源分类',
  `INFOTYPEID` varchar(255) DEFAULT NULL COMMENT '资源分类id',
  `INPROCESS` varchar(255) DEFAULT NULL COMMENT '是否启动流程0 未启动 1启动流转中，2流程结束(通过) 3 流程结束（不通过）4.删除 5停用',
  `ISOPENSOCIAL` varchar(255) DEFAULT NULL COMMENT '是否对社会开放',
  `ISSECRET` varchar(255) DEFAULT NULL COMMENT '是否涉密',
  `OPENCONDITION` varchar(255) DEFAULT NULL COMMENT '开放条件',
  `PARENTID` varchar(255) DEFAULT NULL COMMENT '父版本id',
  `PROCESSID` varchar(255) DEFAULT NULL COMMENT '对应流程实例id',
  `PROVIDECODE` varchar(255) DEFAULT NULL COMMENT '提供机构编码',
  `PROVIDENAME` varchar(255) DEFAULT NULL COMMENT '提供机构名称',
  `SHARECONDITIONS` varchar(255) DEFAULT NULL COMMENT '共享条件',
  `SHAREMODE` varchar(255) DEFAULT NULL COMMENT '共享方式分类 取数据字典',
  `SHAREMODETYPE` varchar(255) DEFAULT NULL COMMENT '共享方式类型 取数据字典',
  `SHARETYPE` varchar(255) DEFAULT NULL COMMENT '共享类型：1 有条件共享2无条件共享3不予共享',
  `SOURCEID` varchar(255) DEFAULT NULL COMMENT '源版本id',
  `SYSTEMINFO` varchar(255) DEFAULT NULL COMMENT '关联系统名称',
  `UPDATOR_ORG_NAME` varchar(255) DEFAULT NULL COMMENT '修改者机构名称',
  `UPDATECYCLE` varchar(255) DEFAULT NULL COMMENT '选择项：实时、每日、每周、每月、每季度、每半年、每年、其他',
  `UPDATETIME` varchar(255) DEFAULT NULL COMMENT '修改时间',
  `UPDATOR` varchar(255) DEFAULT NULL COMMENT '修改人',
  `UPDATOR_NAME` varchar(255) DEFAULT NULL COMMENT '修改人姓名',
  `UPDATOR_ORG` varchar(255) DEFAULT NULL COMMENT '修改人机构',
  `SUBVERSIONID` decimal(10,0) DEFAULT NULL,
  `VERSIONID` decimal(10,0) DEFAULT NULL COMMENT '版本号',
  `LATESTVERSION` varchar(10) DEFAULT NULL COMMENT '1表示最新版本,0表示历史版本',
  `INFOTYPENAME` varchar(200) DEFAULT NULL COMMENT '信息类分类名称',
  `SUBFORMATTYPE` varchar(200) DEFAULT NULL COMMENT '二级信息资源格式',
  `SUBFORMATTYPENAME` varchar(200) DEFAULT NULL COMMENT '二级信息资源格式名称',
  `SUBFORMATTYPEID` varchar(200) DEFAULT NULL COMMENT '二级信息资源格式id',
  `SHAREMODEID` varchar(200) DEFAULT NULL COMMENT '共享方式分类id',
  `SHAREMODENAME` varchar(200) DEFAULT NULL COMMENT '共享方式分类名称',
  `SHAREMODETYPEID` varchar(200) DEFAULT NULL COMMENT '共享方式类型id',
  `SHAREMODETYPENAME` varchar(200) DEFAULT NULL COMMENT '共享方式类型名称',
  `BGSTATUS` varchar(10) DEFAULT NULL COMMENT '1未变更,2变更中',
  `ISBG` varchar(10) DEFAULT NULL COMMENT '是否属于变更申请数据',
  `BGID` varchar(100) DEFAULT NULL COMMENT '需求方变更申请id',
  `PROVIDEBMCODE` varchar(200) DEFAULT NULL COMMENT '提供方部门编码',
  `PROVIDEBMNAME` varchar(200) DEFAULT NULL COMMENT '提供方部门名称',
  `PROVIDEZGCODE` varchar(200) DEFAULT NULL COMMENT '提供方主管部门编码',
  `PROVIDEZGNAME` varchar(200) DEFAULT NULL COMMENT '提供方主管部门名称',
  `TASKNAME` varchar(200) DEFAULT NULL COMMENT '当前环节名称',
  `YWBMNAME` varchar(200) DEFAULT NULL COMMENT '所属业务部门',
  `YWBMID` varchar(200) DEFAULT NULL COMMENT '所属业务部门id(数据字典)',
  `YWBMCODE` varchar(200) DEFAULT NULL COMMENT '所属业务部门编码',
  `XZQHNAME` varchar(200) DEFAULT NULL COMMENT '属地名称',
  `XZQHID` varchar(200) DEFAULT NULL COMMENT '属地id(数据字典)',
  `XZQHCODE` varchar(200) DEFAULT NULL COMMENT '属地编码',
  `CREDITNO` varchar(200) DEFAULT NULL COMMENT '统一社会信用代码',
  `MANAGETYPE` varchar(200) DEFAULT NULL,
  `BMID` varchar(200) DEFAULT NULL,
  `INFOCATALOGCODE` varchar(200) DEFAULT NULL COMMENT '资源分类编码',
  `ISDELETE` varchar(10) DEFAULT 'N',
  `HITCH` varchar(2000) DEFAULT NULL,
  `HITCH_UP_ADRESS` varchar(400) DEFAULT NULL,
  `HITCH_UP_NAME` varchar(400) DEFAULT NULL,
  `HITCH_SIZE` decimal(10,0) DEFAULT NULL,
  `HITCHDATE` varchar(200) DEFAULT NULL,
  `HITCHUSER` varchar(200) DEFAULT NULL,
  `ISZGBMBZ` varchar(200) DEFAULT '0',
  `HITCH_STATUS` int DEFAULT '0' COMMENT '挂接状态 未挂接0，已挂接1',
  `GLINFOTYPENAME` text,
  `DBID` varchar(255) DEFAULT NULL,
  `GJCHECKSTATE` varchar(200) DEFAULT NULL COMMENT '挂接审核情况 1 待审核 2审核通过 3 退回修改',
  `ISZC` varchar(200) DEFAULT NULL,
  `ISGLQZ` varchar(100) DEFAULT NULL COMMENT '是否关联权责清单',
  `QZQD_DES` varchar(400) DEFAULT NULL,
  `CHANGEINSTRUCTIONS` text COMMENT '变更说明',
  `PARALLELTIME` varchar(200) DEFAULT NULL COMMENT '数据并行时间',
  `SWITCHINGTIME` varchar(200) DEFAULT NULL COMMENT '数据切换时间',
  `DISABLESTATE` varchar(100) DEFAULT NULL COMMENT '停用状态 1 停用中 2已停用 3退回',
  `DISABLEDESC` varchar(400) DEFAULT NULL COMMENT '停用说明',
  `DISABLETIME` varchar(100) DEFAULT NULL COMMENT '停用提出时间',
  `ISREMOVEDATA` varchar(100) DEFAULT NULL COMMENT '是否删除数据',
  `FLTAG` varchar(200) DEFAULT NULL COMMENT '资源分类标签',
  `implementation_data` varchar(20) DEFAULT NULL COMMENT '实施日期',
  `implementation_userid` varchar(100) DEFAULT NULL COMMENT '实施用户id',
  `implementation_state` varchar(20) DEFAULT NULL COMMENT '实施状态:0-未实施 1-已实施',
  `tytype` varchar(255) DEFAULT NULL,
  `sharerange` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `index_infoclass_processid` (`PROCESSID`) USING BTREE,
  KEY `index_infoclass_inprocess` (`INPROCESS`) USING BTREE,
  KEY `index_infoclass_latestversion` (`LATESTVERSION`),
  KEY `index_parent_id` (`PARENTID`) USING BTREE,
  KEY `index_infocode` (`INFOCODE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='信息类表';

-- ----------------------------
-- Table structure for t_infoclass_datacount
-- ----------------------------
DROP TABLE IF EXISTS `t_infoclass_datacount`;
CREATE TABLE `t_infoclass_datacount` (
  `class_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '信息类名称',
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id主键',
  `class_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '关联的信息类id',
  `class_infocode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '信息类编码',
  `class_data_count` bigint DEFAULT NULL COMMENT '数据条数（中心库中对应信息类表内数据量（条数））',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_infoclass_datameta
-- ----------------------------
DROP TABLE IF EXISTS `t_infoclass_datameta`;
CREATE TABLE `t_infoclass_datameta` (
  `ID` varchar(255) NOT NULL,
  `DATAMETAID` varchar(255) DEFAULT NULL,
  `DATASIZE` varchar(255) DEFAULT NULL,
  `DATATYPE` varchar(255) DEFAULT NULL,
  `DATATYPE_DIS` varchar(255) DEFAULT NULL,
  `DATATYPEID` varchar(255) DEFAULT NULL,
  `DESCRIPTION` varchar(255) DEFAULT NULL,
  `ISPRIMARY` varchar(255) DEFAULT NULL,
  `METACODE` varchar(255) DEFAULT NULL,
  `METACODE_DIS` varchar(255) DEFAULT NULL,
  `METACODEID` varchar(255) DEFAULT NULL,
  `METANAME` varchar(255) DEFAULT NULL,
  `RANGES` varchar(255) DEFAULT NULL,
  `CODESETID` varchar(255) DEFAULT NULL,
  `TINFOCLASSID` varchar(255) DEFAULT NULL,
  `INDEXNUM` decimal(10,0) DEFAULT NULL,
  `XXXMC` varchar(255) DEFAULT NULL,
  `GLSJY` varchar(255) DEFAULT NULL,
  `SHARETYPE` varchar(255) DEFAULT NULL,
  `SHARECONDITIONS` varchar(255) DEFAULT NULL,
  `SHAREMODENAME` varchar(255) DEFAULT NULL,
  `SHAREMODE` varchar(255) DEFAULT NULL,
  `SHAREMODEID` varchar(255) DEFAULT NULL,
  `SHAREMODETYPENAME` varchar(255) DEFAULT NULL,
  `SHAREMODETYPE` varchar(255) DEFAULT NULL,
  `SHAREMODETYPEID` varchar(255) DEFAULT NULL,
  `ISOPENSOCIAL` varchar(255) DEFAULT NULL,
  `OPENCONDITION` varchar(255) DEFAULT NULL,
  `XXXBM` varchar(255) DEFAULT NULL,
  `GLXXXID` varchar(200) DEFAULT NULL,
  `UPDATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`),
  KEY `TINFOCLASSID` (`TINFOCLASSID`),
  KEY `CODESETID` (`CODESETID`),
  CONSTRAINT `t_infoclass_datameta_ibfk_1` FOREIGN KEY (`TINFOCLASSID`) REFERENCES `t_infoclass` (`ID`),
  CONSTRAINT `t_infoclass_datameta_ibfk_2` FOREIGN KEY (`CODESETID`) REFERENCES `t_codeset` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='信息项表';

-- ----------------------------
-- Table structure for t_infoclass_res
-- ----------------------------
DROP TABLE IF EXISTS `t_infoclass_res`;
CREATE TABLE `t_infoclass_res` (
  `ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `RESID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TINFOCLASSID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='信息类与资源关联表';

-- ----------------------------
-- Table structure for t_infoclass_res_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_infoclass_res_detail`;
CREATE TABLE `t_infoclass_res_detail` (
  `ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `RESID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TINFOCLASSID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='信息类与资源关联表';

-- ----------------------------
-- Table structure for t_infocode
-- ----------------------------
DROP TABLE IF EXISTS `t_infocode`;
CREATE TABLE `t_infocode` (
  `ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `PRE_CODE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '前缀码',
  `SEQ_CODE` decimal(65,0) DEFAULT NULL COMMENT '序列码',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='信息类编码顺序表';

-- ----------------------------
-- Table structure for t_itemdetail_infoclass
-- ----------------------------
DROP TABLE IF EXISTS `t_itemdetail_infoclass`;
CREATE TABLE `t_itemdetail_infoclass` (
  `DATAID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DETAILID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '细项id',
  `INFOCLASSID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '信息类id',
  `INFOCLASSNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '信息类名称',
  PRIMARY KEY (`DATAID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='业务细项与信息类匹配关系表';

-- ----------------------------
-- Table structure for t_login_user
-- ----------------------------
DROP TABLE IF EXISTS `t_login_user`;
CREATE TABLE `t_login_user` (
  `SESSIONID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `IP_ADDR` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATION_TIME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `MAX_INACTIVEINTERVAL` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`SESSIONID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_messageinfo
-- ----------------------------
DROP TABLE IF EXISTS `t_messageinfo`;
CREATE TABLE `t_messageinfo` (
  `id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `content` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sendtime` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `dealtime` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `state` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `receiver` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `receivername` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `serialno` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `senduser` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `providebmcode` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_message_state` (`state`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_noticeinfo
-- ----------------------------
DROP TABLE IF EXISTS `t_noticeinfo`;
CREATE TABLE `t_noticeinfo` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ATTACHMENTFILE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CONTENTS` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `CREATEDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATOR` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATOR_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ISRELEASE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `RELEASETIME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TITLE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR_ORG_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATETIME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR_ORG` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `STATE` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DELETEID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `INDEXS` decimal(11,0) DEFAULT NULL,
  `INFOTYPE` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_online_user
-- ----------------------------
DROP TABLE IF EXISTS `t_online_user`;
CREATE TABLE `t_online_user` (
  `SESSIONID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `LOGIN_NAME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `LAST_REQUEST` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`SESSIONID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_power_responsibility
-- ----------------------------
DROP TABLE IF EXISTS `t_power_responsibility`;
CREATE TABLE `t_power_responsibility` (
  `id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `enforcementbody` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `enforcementbody_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `dutyinfo` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '职责',
  `dutyname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `dutytype` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `creator` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `updator` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `createtime` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `updatetime` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `state` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_reginfo_file
-- ----------------------------
DROP TABLE IF EXISTS `t_reginfo_file`;
CREATE TABLE `t_reginfo_file` (
  `id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文件id',
  `fileid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `regid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '服务注册信息表',
  `filetype` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '服务说明和服务使用说明附件',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_req_info
-- ----------------------------
DROP TABLE IF EXISTS `t_req_info`;
CREATE TABLE `t_req_info` (
  `TCHANGE_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'T_CHANGEAPPLY 表id',
  `TREQDATA_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'T_REQUIREDATAITEM表id',
  `TREQCONF_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'T_REQUIRECONFIRM 表Id',
  `ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_reqdataitem_xxx
-- ----------------------------
DROP TABLE IF EXISTS `t_reqdataitem_xxx`;
CREATE TABLE `t_reqdataitem_xxx` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DATAITEMID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `SHARETYPE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `XXXBM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `XXXMC` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_reqparameters_info
-- ----------------------------
DROP TABLE IF EXISTS `t_reqparameters_info`;
CREATE TABLE `t_reqparameters_info` (
  `parameterid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '参数id',
  `paraname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '参数名',
  `paratype` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '参数类型',
  `isneed` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否必需',
  `defaultvalue` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '默认值',
  `example` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '示例',
  `des` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '描述',
  `regid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '服务注册id',
  PRIMARY KEY (`parameterid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_require_apply
-- ----------------------------
DROP TABLE IF EXISTS `t_require_apply`;
CREATE TABLE `t_require_apply` (
  `ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `REQUIRE_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '需求id',
  `APPLY_USERNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请人姓名',
  `APPLY_DEPTNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请部门',
  `APPLY_REASON` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '申请原因',
  `CREATEDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建时间',
  `UPDATE_USERNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '更新人姓名',
  `UPDATEDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '更改时间',
  `UPLOAD_ID` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '附件id',
  `APPLY_STATE` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请状态 0:不通过 ；1：通过',
  `APPLY_USERID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请人id',
  `AUDITOR_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人姓名',
  `AUDITOR_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人id',
  `AUDITOR_DATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核时间',
  `AUDITOR_OPINION` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '审核意见',
  `DATAITEMID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='需求申请单';

-- ----------------------------
-- Table structure for t_require_bm_task
-- ----------------------------
DROP TABLE IF EXISTS `t_require_bm_task`;
CREATE TABLE `t_require_bm_task` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `APPLYREASON` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `BMNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATEDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PROVIDEBMCODE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REQUIRECONFIRMID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATEUSERID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `JINDU` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATETIME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `XXLID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PROVIDEBMNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REQUIRECODE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REQUIRENAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `APPLYMAN` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `APPLYTEL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `FILEID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `FILENAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `INPROCESS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_require_bm_task_data_item
-- ----------------------------
DROP TABLE IF EXISTS `t_require_bm_task_data_item`;
CREATE TABLE `t_require_bm_task_data_item` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `BMID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DATAITEMID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_require_checkuser
-- ----------------------------
DROP TABLE IF EXISTS `t_require_checkuser`;
CREATE TABLE `t_require_checkuser` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DEPTID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ROLEID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `USERID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_require_zbinfo
-- ----------------------------
DROP TABLE IF EXISTS `t_require_zbinfo`;
CREATE TABLE `t_require_zbinfo` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `REUSER` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REUSERID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ZBDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ZBOPINION` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ZBUSER` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ZBUSERID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_requireconfirm
-- ----------------------------
DROP TABLE IF EXISTS `t_requireconfirm`;
CREATE TABLE `t_requireconfirm` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `BUSINESS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CONTACT` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CONTACTTEL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATEDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATOR` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATORNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATORORG` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATORORGNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REMARKS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REQUIREORG` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REQUIREORGNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKSTATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DATAITEMCOUNT` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `EDITDATAITEMCOUNT` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ISEXISTITEMCOUNT` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ISPARTIALPRIVODE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `NEWDATAITEMCOUNT` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `NOPROVIDEDATAITEMCOUNT` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PLATFORMPRIVODELATESTDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PRIVODEDATAITEMCOUNT` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REQUIRESUBMITDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PROCESSID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `BGNO` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `BMNO` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ISKCJ` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `SJBM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `SJBMID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `BMBGDETAIL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DATASYN` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `GJDETAIL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ISSXCL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PGWCS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PZDETAIL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_requireconfirm_task
-- ----------------------------
DROP TABLE IF EXISTS `t_requireconfirm_task`;
CREATE TABLE `t_requireconfirm_task` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `REQUIREID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKCANDIDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKEND` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKOPINION` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKPAGE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKRESULT` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKSTART` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKUSER` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKZBDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKZBOPINION` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKZBUSER` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CLAIMDATE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_requiredataitem
-- ----------------------------
DROP TABLE IF EXISTS `t_requiredataitem`;
CREATE TABLE `t_requiredataitem` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `BUSINESS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CATALOGCODE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CATALOGITEMCODE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CATALOGNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CATALOGSHAREDTYPE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CATALOGTYPE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `COORDINATIONLATESTDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATEDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CURRENTUPDATEFREQUENCY` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DATAEARLIESTTIME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DATAITEMNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DATALATESTTIME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DATARANGE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `EXCHANGELATESTDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `EXISTPROBLEM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `EXPECTEARLIESTDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `EXPECTPROVIDEDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `EXPECTUPATETIME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `EXPECTUPDATEFREQUENCY` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ISARTICULATEDDATA` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ISCONDITIONS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ISNEEDCATALOG` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ISSECONDARYPACKAGING` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ISSENDLETTER` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ITEMCODE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ITEMNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ITEMREMARK` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `MODIFIER` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `MODIFYDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `OPINION` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PROVIDEWAY` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REMARK` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REQUIRECONFIRMID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `RISKLEVEL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `SOLUTION` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `SOURCEISPROVIDED` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `SOURCEORG` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `SOURCEORGNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `SOURCEPROVIDEWAY` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `SYSTEMTYPE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CATALOGITEMID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CATALOGITEMNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ISCHANG` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REQUIRETYPE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `IS_CHANGE_STATUE` decimal(65,30) DEFAULT NULL,
  `DATARANGEQT` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `GJDETAIL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PZDETAIL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `BMBGDETAIL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CATALOGCODEID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `JKRULE` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `RCRULE` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `SCRULE` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `PROVIDEWAYQT` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `ISDEAL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `YJWCXYSJ` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '预计完成需要时间',
  `GJJKFWDM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `GJJKMC` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `GJJKTGF` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `GJSSML` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PZDETAILDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PZDETAILUSER` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `XQSHTG` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_requirejd
-- ----------------------------
DROP TABLE IF EXISTS `t_requirejd`;
CREATE TABLE `t_requirejd` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `FXTS` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `GXSJ` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `JZQK` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `REQUIREBM` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REQUIREDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `SJXQ` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `YYCJ` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `YYJZ` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_requireprogress
-- ----------------------------
DROP TABLE IF EXISTS `t_requireprogress`;
CREATE TABLE `t_requireprogress` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `COORDINATIONLATESTDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATEDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `EXCHANGELATESTDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `EXISTPROBLEM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `MODIFIER` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `MODIFYDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REQUIRECONFIRMID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REQUIREDATAITEMID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `RISKLEVEL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `SOLUTION` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TASKID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_requireyzc
-- ----------------------------
DROP TABLE IF EXISTS `t_requireyzc`;
CREATE TABLE `t_requireyzc` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DYCS` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `DYDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `GXSJ` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `YYCJ` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `YYXT` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_res_classify
-- ----------------------------
DROP TABLE IF EXISTS `t_res_classify`;
CREATE TABLE `t_res_classify` (
  `RESID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
  `PRESID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '父id',
  `RESCODE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '代码',
  `RESNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '名称',
  `RESDES` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '说明',
  `STATE` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '状态0启用,1停用,2删除',
  `CREATOR` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATEDATE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATEDATE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `INDEXNUM` decimal(65,0) DEFAULT NULL COMMENT '排序',
  `INFOCLASSNUM` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPTID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPTNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CATEGORY` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '标明基础 主题 还是部门分类',
  PRIMARY KEY (`RESID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='资源分类信息表';

-- ----------------------------
-- Table structure for t_res_classify1
-- ----------------------------
DROP TABLE IF EXISTS `t_res_classify1`;
CREATE TABLE `t_res_classify1` (
  `RESID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
  `PRESID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '父id',
  `RESCODE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '代码',
  `RESNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '名称',
  `RESDES` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '说明',
  `STATE` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '状态0启用,1停用,2删除',
  `CREATOR` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATEDATE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATEDATE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `INDEXNUM` decimal(65,0) DEFAULT NULL COMMENT '排序',
  `INFOCLASSNUM` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPTID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DEPTNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`RESID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='资源分类信息表';

-- ----------------------------
-- Table structure for t_res_user
-- ----------------------------
DROP TABLE IF EXISTS `t_res_user`;
CREATE TABLE `t_res_user` (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `resid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `userid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for t_returnstate_info
-- ----------------------------
DROP TABLE IF EXISTS `t_returnstate_info`;
CREATE TABLE `t_returnstate_info` (
  `stateid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '描述',
  `stateno` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '状态码',
  `statevalue` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '状态码返回值',
  `statedesc` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '状态描述',
  `regid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '服务注册id',
  PRIMARY KEY (`stateid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_scene_dept
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_dept`;
CREATE TABLE `t_scene_dept` (
  `rid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `deptid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sceneid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`rid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_scene_glinfo
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_glinfo`;
CREATE TABLE `t_scene_glinfo` (
  `rid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `zcjsceneid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `cjsceneid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`rid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_scene_info
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_info`;
CREATE TABLE `t_scene_info` (
  `sceneid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `scene_name` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '场景名称',
  `scene_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '场景编码',
  `scene_desc` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '场景描述',
  `lead_dept` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '牵头部门',
  `status` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '推进状态 0 推进中 1 已完成 2 暂停 3删除',
  `creator` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建者',
  `createtime` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建时间',
  `updator` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改者',
  `updatetime` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改时间',
  `cjtype` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `visiable` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否全市可见',
  PRIMARY KEY (`sceneid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='场景应用';

-- ----------------------------
-- Table structure for t_scene_relation
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_relation`;
CREATE TABLE `t_scene_relation` (
  `rid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ywid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ywtable` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sceneid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `issyn` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`rid`) USING BTREE,
  KEY `idx_ywid` (`ywid`) USING BTREE,
  KEY `idx_ywtable` (`ywtable`) USING BTREE,
  KEY `idx_sceneid` (`sceneid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_sensitive_words
-- ----------------------------
DROP TABLE IF EXISTS `t_sensitive_words`;
CREATE TABLE `t_sensitive_words` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
  `SENSITIVE_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '敏感词名称',
  `ALTERNATIVE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '校正名称',
  `SENSITIVE_TYPE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '敏感词类型',
  `CODE_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '数据字典id',
  `STATE` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '状态: 0.删除1.待启用 2.启用 3.禁用',
  `CREATE_TIME` datetime(6) DEFAULT NULL COMMENT '创建时间',
  `CREATOR_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建者id',
  `CREATE_USER` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建者姓名',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_service_applyinfo
-- ----------------------------
DROP TABLE IF EXISTS `t_service_applyinfo`;
CREATE TABLE `t_service_applyinfo` (
  `applyid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '申请id',
  `reqid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '服务id',
  `mingcheng` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '名称',
  `contactman` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人',
  `tel` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话',
  `email` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '电子邮件',
  `workscenario` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '办事场景',
  `usescopedes` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '使用范围说明',
  `systemname` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `reason` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '申请依据',
  `peak_querypc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '峰值查询频次',
  `avg_querypc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '平均查询频次',
  `uselife` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '使用期限',
  `timerange` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '时间范围',
  `othertechnical` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '其他技术要求',
  `creator` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `creatorname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `createtime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `inprocess` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `processid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `taskname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `beiantime` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `mingchengid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `dealdate` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `dealman` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `systemnameid` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `isprecheck` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否需要预审 1需要',
  `business_label` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务申请标签',
  `glxt` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'shi否系統支撐',
  `scenename` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `scenecode` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `peak_querypcs` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '峰值查询频次s',
  `peak_querypch` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '峰值查询频次h',
  `isrevoke` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '撤销 0',
  `revoketime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '撤销时间',
  `distributetime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '派发时间',
  `knowopinion` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `knowstate` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '0已知悉 1 未知悉 2变更完成',
  `knowtime` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `serialno` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请流水号',
  `isdeal` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `zwwwip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`applyid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_service_reginfo
-- ----------------------------
DROP TABLE IF EXISTS `t_service_reginfo`;
CREATE TABLE `t_service_reginfo` (
  `regid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '服务注册id',
  `provideid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '提供方id',
  `providename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '提供方名称',
  `cnname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '服务中文名称',
  `enname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '服务英文名称',
  `accesstype` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '接入类型',
  `classid` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '目录系统id',
  `classname` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '目录名称',
  `sourcesystem` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '来源系统',
  `abstractinfo` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '服务摘要',
  `frequency` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '调用频率',
  `timeout` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '超时时间',
  `readtimeout` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '读超时时间',
  `scenedes` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '使用场景描述',
  `updatefrequence` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '数据更新周期',
  `sharetype` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '共享类型',
  `shareconditions` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '共享条件',
  `isuploadfile` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请时是否必须上传附件',
  `versionnum` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '版本号',
  `processid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '流程id',
  `taskname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '当前审核环节',
  `inprocess` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '0:未进入流程 1 流程中 2 流程审核通过 3 流程审核不通过 4 删除',
  `releasedate` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布时间',
  `sourceid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '祖先id',
  `parentid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '父版本id',
  `latestversion` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '1 当前版本 0 历史版本',
  `createtime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `creator` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `creatorname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `updatetime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `updator` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `updatorname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `isbg` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '1 变更中;0 未变更',
  `isgj` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '1 已挂接;0 未挂接',
  `gjsj` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '挂接时间',
  `gjrid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '挂接人id',
  `gjr` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `validurl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '服务的有效地址',
  `requesttype` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '请求方式',
  `returntype` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '返回值类型',
  `technicalunit` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '技术支持单位',
  `technicalman` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '技术支持联系人',
  `technicaltel` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '技术支持联系电话',
  `apicode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `qjdate` datetime DEFAULT NULL,
  `qjman` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `xzqhcode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `networktype` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '网络情况',
  `gjcheckstate` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sourcesystemid` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `day_max_visit` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '每天最大访问',
  `hour_max_visit` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '每小时最大访问',
  `sec_max_visit` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '每秒最大访问',
  `service_time` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '服务时间',
  `service_source` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '接口来源',
  `changeinstructions` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '变更说明',
  `paralleltime` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '并行时间',
  `switchingtime` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '数据切换时间',
  PRIMARY KEY (`regid`) USING BTREE,
  KEY `index_processid` (`processid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_shareapply
-- ----------------------------
DROP TABLE IF EXISTS `t_shareapply`;
CREATE TABLE `t_shareapply` (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `APPLYDATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请日期',
  `APPLYDEPTID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请部门id',
  `APPLYDEPTNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请部门名称',
  `APPLYREASON` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请原因',
  `APPLYUSERID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请人id',
  `APPLYUSERNAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请人名称',
  `STATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '数据状态',
  `UPDATOR_ORG_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATETIME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR_ORG` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TINFOCLASSID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PROCESSID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '对应流程实例',
  `TASKNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '当前所处环节',
  `REQUIREID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ISCONDITIONS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ACTUALIZE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否已实施 -1 未派单 0未实施   1已实施',
  `ACTUALIZETIME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ISREVOKE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REVOKETIME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `HASYWXT` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '有无业务系统',
  `YWXT_NAME` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `YWXT_DES` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `CJ_DES` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `ISPRECHECK` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否需要预审 1 需要 ',
  `CONTACTMAN` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人',
  `CONTACTTEL` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话',
  `BUSINESS_LABEL` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务申请标签',
  `YWXT_ID` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务系统id',
  `SHARINGCYCLE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '共享周期',
  `EXPECTUPDATECYCLE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '期望数据更新周求',
  `SHARESERIALNO` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请流水号',
  `SCENENAME` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `SCENECODE` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `DISTRIBUTETIME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '派发时间',
  `KNOWOPINION` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '反馈意见',
  `KNOWSTATE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '知悉状态 0已知悉 1需要进行知悉反馈',
  `KNOWTIME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '知悉反馈时间',
  PRIMARY KEY (`ID`) USING BTREE,
  KEY `TINFOCLASSID` (`TINFOCLASSID`) USING BTREE,
  KEY `INDEX_PROCESSID` (`PROCESSID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='共享申请表信息';

-- ----------------------------
-- Table structure for t_subpower_responsibility
-- ----------------------------
DROP TABLE IF EXISTS `t_subpower_responsibility`;
CREATE TABLE `t_subpower_responsibility` (
  `id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `mainid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `subdutyname` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '权责名称',
  `subdutytype` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `subdutycode` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_subres_infoclass
-- ----------------------------
DROP TABLE IF EXISTS `t_subres_infoclass`;
CREATE TABLE `t_subres_infoclass` (
  `id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `subid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `infoclassid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_subres_subid` (`subid`) USING BTREE,
  KEY `index_subres_infoclassid` (`infoclassid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='权责关联表';

-- ----------------------------
-- Table structure for t_system_info
-- ----------------------------
DROP TABLE IF EXISTS `t_system_info`;
CREATE TABLE `t_system_info` (
  `SYS_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `SYS_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '系统名称',
  `SYS_DETAIL` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '系统描述',
  `SYS_DEPT_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '系统所属部门',
  `SYS_DEPT_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '系统所属部门id',
  `CREATOR` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATOR_NAME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATE_TIME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATOR_NAME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATE_TIME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CHECKBM` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审批部门',
  `CHECKDATE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审批时间',
  `SYSTEMSTATE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '系统状态，在建、已建',
  `BUSINESSFUNC` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '业务功能',
  `FUNDSOURCE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '资金来源',
  `SYSTEMTYPE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '系统类别',
  `CURRENTSTAGE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '当前建设阶段',
  `JIANSHETYPE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '建设方式',
  `CHENGJIANUNIT` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '承建单位名称',
  `UNITMAN` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '单位联系人',
  `UNITTEL` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '单位电话',
  `HETONGDATE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '合同签署时间',
  `HETONGWCDATE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '合同约定完成时间',
  `WEIBAODATE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '维保时间',
  `LIXIANGREASON` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '立项依据',
  `BUSHUADDR` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '部署位置',
  `SECRETTYPE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '涉密分类',
  `SECURITYLEVEL` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '安全级别',
  `NETWORKTYPE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '网络环境类型',
  `SHIYONGFANWEI` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '使用范围',
  `ISDUIJIE` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '是否与其他系统对接',
  `DUIJIEPROJECT` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '对接项目',
  `ISVIRTUAL` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否虚拟化',
  `VIRTUALSOFTWARE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '虚拟软件',
  `ISBACKUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否备份',
  `BACKUPTYPE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备份方式',
  `BACKUPADDR` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备份地点',
  `BACKUPNUM` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备份数量',
  `ISRONGZAI` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '应用容灾',
  `LATERPLAN` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '系统后续计划',
  `JXJSREASON` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '继续建设原因',
  `REMARK` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '备注',
  `JSUNIT` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '建设单位',
  `JSMAN` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '建设单位联系人',
  `JSTEL` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '建设单位联系电话',
  `YWUNIT` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '运维单位名称',
  `YWMAN` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '运维单位联系人',
  `YWTEL` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '运维单位联系电话',
  `JCDATE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '建成时间',
  `YWHTDATE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '运维合同到期时间',
  `JSMONEY` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '建设金额',
  `YEARYWMONEY` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '年度运维资金',
  `YEARYWSOURCE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '年度运维资金来源',
  `YWTYPE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '运维方式',
  `ISDEAD` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否僵尸系统',
  `USERATE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '使用频率（每月使用用户量）',
  `ISAPPLYZH` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否申请暂缓整合',
  `ZHREASON` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '暂缓原因',
  `ISSJXUQIU` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否有升级需求',
  `SJREASON` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '升级需求说明',
  `USEOBJ` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '使用对象',
  `YIFUORRATE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '已付金额或比例 ',
  `JSGOAL` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '建设目标',
  `JINPOLEVEL` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '紧迫程度',
  `JINPODETAIL` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '紧迫说明',
  `DAOWEIDETAIL` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '资金到位情况',
  `SYS_CODE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `SYS_USEDETAIL` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ISDELETE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否删除 1表示删除',
  `ISKJ` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否可见',
  `ISGQ` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否挂起',
  PRIMARY KEY (`SYS_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='系统信息表';

-- ----------------------------
-- Table structure for t_systeminfo_infoclass
-- ----------------------------
DROP TABLE IF EXISTS `t_systeminfo_infoclass`;
CREATE TABLE `t_systeminfo_infoclass` (
  `SYSTEMINFOCLASS_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `SYSTEMINFO_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '系统信息id',
  `INFOCLASS_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '信息类id',
  `SYSTEMINFO_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`SYSTEMINFOCLASS_ID`) USING BTREE,
  KEY `index_systeminfo_sysid` (`SYSTEMINFO_ID`) USING BTREE,
  KEY `infdex_systeminfo_infoid` (`INFOCLASS_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT=' 业务系统与信息类对应关系表';

-- ----------------------------
-- Table structure for t_systeminfo_qz
-- ----------------------------
DROP TABLE IF EXISTS `t_systeminfo_qz`;
CREATE TABLE `t_systeminfo_qz` (
  `id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `systemid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `qzid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `fileid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `filename` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_qz_systemid` (`systemid`) USING BTREE,
  KEY `index_qz_qzid` (`qzid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_time
-- ----------------------------
DROP TABLE IF EXISTS `t_time`;
CREATE TABLE `t_time` (
  `t_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_version_info
-- ----------------------------
DROP TABLE IF EXISTS `t_version_info`;
CREATE TABLE `t_version_info` (
  `version_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `version_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '版本名称',
  `version_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '版本号',
  `version_remarks` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '版本说明',
  `version_datetime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '版本发布时间',
  `version_state` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '状态 0-未删除,1-已删除',
  `creator_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建者id',
  `creator_org` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建者部门',
  `creator_date` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建日期',
  PRIMARY KEY (`version_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='版本信息';

-- ----------------------------
-- Table structure for t_wishlist
-- ----------------------------
DROP TABLE IF EXISTS `t_wishlist`;
CREATE TABLE `t_wishlist` (
  `wishid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ywid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务表id',
  `ywtype` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务表名',
  `collect_time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '加入申请箱时间',
  `remove_time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '移除申请箱时间',
  `collectstate` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '状态 0加入 1 移除 ',
  `collect_userid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '加入申请箱人员id',
  PRIMARY KEY (`wishid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_wishlist_subinfo
-- ----------------------------
DROP TABLE IF EXISTS `t_wishlist_subinfo`;
CREATE TABLE `t_wishlist_subinfo` (
  `subid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `wishid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请箱id',
  `dataid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '信息项id',
  PRIMARY KEY (`subid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_zhengzhao_info
-- ----------------------------
DROP TABLE IF EXISTS `t_zhengzhao_info`;
CREATE TABLE `t_zhengzhao_info` (
  `ZHENGZHAOID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ZHENGZHAONAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '证照名称',
  `ZHENGZHAOSOURCE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '证照来源',
  PRIMARY KEY (`ZHENGZHAOID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='证照信息表';

-- ----------------------------
-- Table structure for taskinfo
-- ----------------------------
DROP TABLE IF EXISTS `taskinfo`;
CREATE TABLE `taskinfo` (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `JOB_DESCRIPTION` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `JOB_STATUS` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CRON_EXPRESSION` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CREATE_TIME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for test
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `qzcode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for tnoticeinfo_userinfo
-- ----------------------------
DROP TABLE IF EXISTS `tnoticeinfo_userinfo`;
CREATE TABLE `tnoticeinfo_userinfo` (
  `T_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `U_IDS` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `U_NAMES` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `U_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `U_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `READE_STATE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`T_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for update_rate
-- ----------------------------
DROP TABLE IF EXISTS `update_rate`;
CREATE TABLE `update_rate` (
  `table_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '表名称',
  `is_update` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否更新（1已更新，0未更新）',
  `isopensocial` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否开放',
  `insert_time` datetime NOT NULL COMMENT '入表时间',
  `content` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '说明',
  KEY `idx_table_name` (`table_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='更新率';

-- ----------------------------
-- Table structure for upload_file
-- ----------------------------
DROP TABLE IF EXISTS `upload_file`;
CREATE TABLE `upload_file` (
  `FILE_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '附件ID',
  `CREAT_TIME` datetime(6) DEFAULT NULL COMMENT '创建时间',
  `CREATED_USER` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `DELETE_FLOG` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '删除标记（1：有效，-1：无效）',
  `FILE_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文件原名称',
  `FILE_SIZE` decimal(20,0) DEFAULT NULL COMMENT '文件大小',
  `FILE_TYPE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文件类型',
  `FK_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '对象ID',
  `MODULE_LABEL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATA_TIME` datetime(6) DEFAULT NULL COMMENT '更新时间',
  `UPDATA_USER` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '更新人',
  `FILE_SAVE_PATH` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文件保存路径',
  `FILE_SAVE_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文件保存名称',
  PRIMARY KEY (`FILE_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
  `CODE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ENABLED` decimal(1,0) NOT NULL,
  `NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`CODE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for userinfo
-- ----------------------------
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
  `USER_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CREATE_TIME` datetime(6) DEFAULT NULL,
  `CREATOR_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `EMAIL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `FLAG` decimal(10,0) DEFAULT NULL,
  `LOGIN_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PASSWORD` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REMARK` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `STATE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UPDATE_TIME` datetime(6) DEFAULT NULL,
  `UPDATER_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `USER_INDEX` decimal(10,0) DEFAULT NULL,
  `USER_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PHONE_NUM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `USERTYPE` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `DEPTID` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `PDEPTIDS` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `USERKEY` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PRIORITY` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户优先级',
  `PWD_DATE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码修改时间',
  PRIMARY KEY (`USER_ID`) USING BTREE,
  KEY `index_loginname` (`LOGIN_NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for v_histasklist_t
-- ----------------------------
DROP TABLE IF EXISTS `v_histasklist_t`;
CREATE TABLE `v_histasklist_t` (
  `busid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `taskid` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `proinstid` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `taskname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `taskman` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `manname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `taskstart` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `taskend` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `taskmessage` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  KEY `tt_proinstid` (`proinstid`) USING BTREE,
  KEY `tt_taskid` (`taskid`) USING BTREE,
  KEY `idx_busid` (`busid`) USING BTREE,
  KEY `idx_taskname` (`taskname`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for workcalendar
-- ----------------------------
DROP TABLE IF EXISTS `workcalendar`;
CREATE TABLE `workcalendar` (
  `id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
  `year` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `workdate` datetime(6) DEFAULT NULL,
  `iswork` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `updatetime` datetime(6) DEFAULT NULL,
  `updator` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- View structure for bm_delay
-- ----------------------------
DROP VIEW IF EXISTS `bm_delay`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `bm_delay` AS select `serviceshare_bm_delay`.`PROVIDEBMCODE` AS `PROVIDEBMCODE`,`serviceshare_bm_delay`.`PROVIDEBMNAME` AS `PROVIDEBMNAME` from `serviceshare_bm_delay` union select `datashare_bm_delay`.`PROVIDEBMCODE` AS `PROVIDEBMCODE`,`datashare_bm_delay`.`PROVIDEBMNAME` AS `PROVIDEBMNAME` from `datashare_bm_delay`;

-- ----------------------------
-- View structure for bp_share_view
-- ----------------------------
DROP VIEW IF EXISTS `bp_share_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `bp_share_view` AS select `a`.`share_type` AS `share_type`,`a`.`dept_id` AS `dept_id`,`a`.`apply_num` AS `apply_num`,`a`.`finish_num` AS `finish_num`,`a`.`being_num` AS `being_num`,`a`.`coordinate_num` AS `coordinate_num` from (select '1' AS `share_type`,(select `t_infoclass`.`PROVIDEBMCODE` from `t_infoclass` where (`t_infoclass`.`ID` = `t_shareapply`.`TINFOCLASSID`)) AS `dept_id`,count(1) AS `apply_num`,sum((case when ((`t_shareapply`.`STATE` = '2') or (`t_shareapply`.`STATE` = '3')) then 1 else 0 end)) AS `finish_num`,sum((case when ((`t_shareapply`.`TASKNAME` <> '需求方协调') and (`t_shareapply`.`STATE` = '1')) then 1 else 0 end)) AS `being_num`,sum((case when ((`t_shareapply`.`TASKNAME` = '需求方协调') and (`t_shareapply`.`STATE` = '1')) then 1 else 0 end)) AS `coordinate_num` from `t_shareapply` where (`t_shareapply`.`STATE` not in ('0','4')) group by (select `t_infoclass`.`PROVIDEBMCODE` from `t_infoclass` where (`t_infoclass`.`ID` = `t_shareapply`.`TINFOCLASSID`)) union select '2' AS `share_type`,(select `t_service_reginfo`.`provideid` from `t_service_reginfo` where (`t_service_reginfo`.`regid` = `t_service_applyinfo`.`reqid`)) AS `dept_id`,count(1) AS `apply_num`,sum((case when ((`t_service_applyinfo`.`inprocess` = '2') or (`t_service_applyinfo`.`inprocess` = '3')) then 1 else 0 end)) AS `finish_num`,sum((case when ((`t_service_applyinfo`.`taskname` <> '需求方协调') and (`t_service_applyinfo`.`inprocess` = '1')) then 1 else 0 end)) AS `being_num`,sum((case when ((`t_service_applyinfo`.`taskname` = '需求方协调') and (`t_service_applyinfo`.`inprocess` = '1')) then 1 else 0 end)) AS `coordinate_num` from `t_service_applyinfo` where (`t_service_applyinfo`.`inprocess` not in ('0','4')) group by (select `t_service_reginfo`.`provideid` from `t_service_reginfo` where (`t_service_reginfo`.`regid` = `t_service_applyinfo`.`reqid`))) `a`;

-- ----------------------------
-- View structure for da_scene_view
-- ----------------------------
DROP VIEW IF EXISTS `da_scene_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `da_scene_view` AS select `t_scene_info`.`sceneid` AS `scene_id`,`t_scene_info`.`scene_name` AS `scene_name`,`t_scene_info`.`scene_desc` AS `scene_des`,`t_scene_info`.`status` AS `status`,`t_scene_info`.`createtime` AS `createtime` from `t_scene_info`;

-- ----------------------------
-- View structure for datashare_bm_delay
-- ----------------------------
DROP VIEW IF EXISTS `datashare_bm_delay`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `datashare_bm_delay` AS select `t`.`PROVIDEBMCODE` AS `PROVIDEBMCODE`,`t`.`PROVIDEBMNAME` AS `PROVIDEBMNAME`,count(1) AS `num` from (select distinct `w`.`PROVIDEBMCODE` AS `PROVIDEBMCODE`,`w`.`PROVIDEBMNAME` AS `PROVIDEBMNAME`,`p`.`TASK_ID` AS `TASK_ID` from ((`v_tasklist_delay` `p` join `t_shareapply` `q`) join `t_infoclass` `w`) where ((`p`.`PROC_INST_ID` = `q`.`PROCESSID`) and (`q`.`TINFOCLASSID` = `w`.`ID`))) `t` group by `t`.`PROVIDEBMCODE`,`t`.`PROVIDEBMNAME`;

-- ----------------------------
-- View structure for ds_catalog_inter_view
-- ----------------------------
DROP VIEW IF EXISTS `ds_catalog_inter_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `ds_catalog_inter_view` AS select `t_service_reginfo`.`regid` AS `inter_id`,`t_service_reginfo`.`cnname` AS `inter_name`,`t_service_reginfo`.`provideid` AS `provider_id`,'' AS `inter_type`,'' AS `inter_code`,`t_service_reginfo`.`frequency` AS `data_update_freq`,'' AS `created_by`,'' AS `deleted`,'' AS `created_date`,'' AS `modified_by`,'' AS `modified_date` from `t_service_reginfo` where ((`t_service_reginfo`.`inprocess` = '2') and (`t_service_reginfo`.`latestversion` = '1'));

-- ----------------------------
-- View structure for dtxxls
-- ----------------------------
DROP VIEW IF EXISTS `dtxxls`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `dtxxls` AS select count(1) AS `COUNT(1)` from `t_infoclass` where ((`t_infoclass`.`INPROCESS` = '2') and (not((`t_infoclass`.`INFOCODE` like '1%'))) and (`t_infoclass`.`LATESTVERSION` = '1'));

-- ----------------------------
-- View structure for dtxxlslq
-- ----------------------------
DROP VIEW IF EXISTS `dtxxlslq`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `dtxxlslq` AS select count(1) AS `COUNT(1)` from `t_infoclass` where ((`t_infoclass`.`INPROCESS` = '2') and (`t_infoclass`.`LATESTVERSION` = '1') and `t_infoclass`.`INFOTYPEID` in (select `t_res_classify`.`RESID` from `t_res_classify` where `t_res_classify`.`PRESID` in (select `t_res_classify`.`RESID` from `t_res_classify` where ((`t_res_classify`.`PRESID` = '8012344641b74b8ca57879147e5746bd') and (`t_res_classify`.`RESID` <> '4be5df7a1876474d940be89b494677a7')))));

-- ----------------------------
-- View structure for dtxxlslsj
-- ----------------------------
DROP VIEW IF EXISTS `dtxxlslsj`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `dtxxlslsj` AS select count(1) AS `COUNT(1)` from `t_infoclass` where ((`t_infoclass`.`INPROCESS` = '2') and (`t_infoclass`.`LATESTVERSION` = '1') and `t_infoclass`.`INFOTYPEID` in (select `t_res_classify`.`RESID` from `t_res_classify` where (`t_res_classify`.`PRESID` = '4be5df7a1876474d940be89b494677a7')));

-- ----------------------------
-- View structure for dtxxlslzt0
-- ----------------------------
DROP VIEW IF EXISTS `dtxxlslzt0`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `dtxxlslzt0` AS select `t`.`ID` AS `ID`,`t`.`CREATEDATE` AS `CREATEDATE`,`t`.`CREATOR` AS `CREATOR`,`t`.`CREATOR_NAME` AS `CREATOR_NAME`,`t`.`CREATOR_ORG` AS `CREATOR_ORG`,`t`.`CREATOR_ORGNAME` AS `CREATOR_ORGNAME`,`t`.`DATARANGE` AS `DATARANGE`,`t`.`FORMATTYPE` AS `FORMATTYPE`,`t`.`FORMATTYPEID` AS `FORMATTYPEID`,`t`.`FORMATTYPENAME` AS `FORMATTYPENAME`,`t`.`INFOABSTRACTS` AS `INFOABSTRACTS`,`t`.`INFOCODE` AS `INFOCODE`,`t`.`INFONAME` AS `INFONAME`,`t`.`INFOTYPE` AS `INFOTYPE`,`t`.`INFOTYPEID` AS `INFOTYPEID`,`t`.`INPROCESS` AS `INPROCESS`,`t`.`ISOPENSOCIAL` AS `ISOPENSOCIAL`,`t`.`ISSECRET` AS `ISSECRET`,`t`.`OPENCONDITION` AS `OPENCONDITION`,`t`.`PARENTID` AS `PARENTID`,`t`.`PROCESSID` AS `PROCESSID`,`t`.`PROVIDECODE` AS `PROVIDECODE`,`t`.`PROVIDENAME` AS `PROVIDENAME`,`t`.`SHARECONDITIONS` AS `SHARECONDITIONS`,`t`.`SHAREMODE` AS `SHAREMODE`,`t`.`SHAREMODETYPE` AS `SHAREMODETYPE`,`t`.`SHARETYPE` AS `SHARETYPE`,`t`.`SOURCEID` AS `SOURCEID`,`t`.`SYSTEMINFO` AS `SYSTEMINFO`,`t`.`UPDATOR_ORG_NAME` AS `UPDATOR_ORG_NAME`,`t`.`UPDATECYCLE` AS `UPDATECYCLE`,`t`.`UPDATETIME` AS `UPDATETIME`,`t`.`UPDATOR` AS `UPDATOR`,`t`.`UPDATOR_NAME` AS `UPDATOR_NAME`,`t`.`UPDATOR_ORG` AS `UPDATOR_ORG`,`t`.`VERSIONID` AS `VERSIONID`,`t`.`LATESTVERSION` AS `LATESTVERSION`,`t`.`INFOTYPENAME` AS `INFOTYPENAME`,`t`.`SUBFORMATTYPE` AS `SUBFORMATTYPE`,`t`.`SUBFORMATTYPENAME` AS `SUBFORMATTYPENAME`,`t`.`SUBFORMATTYPEID` AS `SUBFORMATTYPEID`,`t`.`SHAREMODEID` AS `SHAREMODEID`,`t`.`SHAREMODENAME` AS `SHAREMODENAME`,`t`.`SHAREMODETYPEID` AS `SHAREMODETYPEID`,`t`.`SHAREMODETYPENAME` AS `SHAREMODETYPENAME`,`t`.`BGSTATUS` AS `BGSTATUS`,`t`.`ISBG` AS `ISBG`,`t`.`BGID` AS `BGID`,`t`.`PROVIDEBMCODE` AS `PROVIDEBMCODE`,`t`.`PROVIDEBMNAME` AS `PROVIDEBMNAME`,`t`.`PROVIDEZGCODE` AS `PROVIDEZGCODE`,`t`.`PROVIDEZGNAME` AS `PROVIDEZGNAME`,`t`.`TASKNAME` AS `TASKNAME`,`t`.`YWBMNAME` AS `YWBMNAME`,`t`.`YWBMID` AS `YWBMID`,`t`.`YWBMCODE` AS `YWBMCODE`,`t`.`XZQHNAME` AS `XZQHNAME`,`t`.`XZQHID` AS `XZQHID`,`t`.`XZQHCODE` AS `XZQHCODE`,`t`.`CREDITNO` AS `CREDITNO`,`t`.`MANAGETYPE` AS `MANAGETYPE`,`t`.`BMID` AS `BMID`,`t`.`INFOCATALOGCODE` AS `INFOCATALOGCODE`,`b`.`RESID` AS `b_resid`,`a`.`RESID` AS `a_resid`,`a`.`PRESID` AS `a_presid`,`a`.`RESNAME` AS `a_resname`,`b`.`RESNAME` AS `b_resname` from ((`t_res_classify` `a` left join `t_res_classify` `b` on((`a`.`RESID` = `b`.`PRESID`))) left join `t_infoclass` `t` on((`b`.`RESID` = `t`.`INFOTYPEID`))) where ((`a`.`PRESID` = 'zt') and (`t`.`INPROCESS` = '2') and (`t`.`LATESTVERSION` = '1'));

-- ----------------------------
-- View structure for gxlcx_view
-- ----------------------------
DROP VIEW IF EXISTS `gxlcx_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `gxlcx_view` AS select `last_infoclass`.`tablename` AS `表名称`,`deptinfo`.`DEPT_NAME` AS `部门名称`,`last_infoclass`.`updatecycle` AS `更新频率`,(case `last_infoclass`.`sharemodetype` when 'gxsjk' then '共享数据库' when 'wj' then '文件' when 'jk' then '接口' else '其他' end) AS `数据提供方式`,(case `update_rate`.`is_update` when '0' then '否' else '是' end) AS `是否更新`,`update_rate`.`insert_time` AS `统计时间` from ((`last_infoclass` join `deptinfo` on((`last_infoclass`.`dept_id` = `deptinfo`.`DEPT_ID`))) join `update_rate` on((`update_rate`.`table_name` = `last_infoclass`.`tablename`))) where (date_format(`update_rate`.`insert_time`,'%Y-%m-%d') = (select date_format(max(`update_rate`.`insert_time`),'%Y-%m-%d') from `update_rate`)) order by `update_rate`.`table_name`;

-- ----------------------------
-- View structure for info_count
-- ----------------------------
DROP VIEW IF EXISTS `info_count`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `info_count` AS select count(1) AS `count` from ((select `d`.`HITCH_STATUS` AS `HITCH_STATUS`,`d`.`INFOTYPEID` AS `INFOTYPEID`,`d`.`LATESTVERSION` AS `LATESTVERSION`,`d`.`INPROCESS` AS `INPROCESS`,`d`.`INFOCODE` AS `INFOCODE`,`d`.`INFOTYPE` AS `INFOTYPE`,`d`.`SHAREMODETYPE` AS `SHAREMODETYPE`,`d`.`SHAREMODE` AS `SHAREMODE`,`d`.`FORMATTYPE` AS `FORMATTYPE`,`d`.`ID` AS `id`,`d`.`ISOPENSOCIAL` AS `ISOPENSOCIAL`,`d`.`INFONAME` AS `infoname`,`d`.`PROVIDEBMNAME` AS `PROVIDEZGNAME`,`d`.`SHARETYPE` AS `SHARETYPE`,`d`.`UPDATETIME` AS `UPDATETIME`,`d`.`VERSIONID` AS `VERSIONID`,`d`.`INFOTYPENAME` AS `INFOTYPENAME`,`d`.`UPDATECYCLE` AS `UPDATECYCLE`,`d`.`SHAREMODETYPENAME` AS `SHAREMODETYPENAME`,sum((case when (`c`.`TINFOCLASSID` is null) then 0 else 1 end)) AS `apply_count` from (`t_infoclass` `d` left join `t_shareapply` `c` on(((`d`.`ID` = `c`.`TINFOCLASSID`) and (`c`.`STATE` = '2')))) group by `d`.`INFONAME`,`d`.`ID`) `a` left join `data_count` `b` on((`a`.`INFOCODE` = `b`.`infocode`))) where ((`a`.`INPROCESS` = '2') and (`a`.`LATESTVERSION` = '1') and (`a`.`SHAREMODETYPENAME` = '数据库') and (`a`.`INFOTYPEID` in (select `t_res_classify`.`RESID` from `t_res_classify` where (`t_res_classify`.`RESID` in (select `t_res_classify`.`RESID` from `t_res_classify` where (`t_res_classify`.`PRESID` = '4be5df7a1876474d940be89b494677a7')) and (`t_res_classify`.`STATE` = 0))) or `a`.`INFOTYPEID` in (select `t_res_classify`.`RESID` from `t_res_classify` where `t_res_classify`.`PRESID` in (select `t_res_classify`.`RESID` from `t_res_classify` where `t_res_classify`.`PRESID` in (select `t_res_classify`.`RESID` from `t_res_classify` where `t_res_classify`.`PRESID` in (select `t_res_classify`.`RESID` from `t_res_classify` where ((`t_res_classify`.`PRESID` = 'bm') and (`t_res_classify`.`STATE` = 0))))))));

-- ----------------------------
-- View structure for info_view
-- ----------------------------
DROP VIEW IF EXISTS `info_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `info_view` AS select `a`.`HITCH_STATUS` AS `HITCH_STATUS`,`a`.`INFOTYPEID` AS `INFOTYPEID`,`a`.`LATESTVERSION` AS `LATESTVERSION`,`a`.`INPROCESS` AS `INPROCESS`,`a`.`INFOCODE` AS `INFOCODE`,`a`.`INFOTYPE` AS `INFOTYPE`,`a`.`SHAREMODETYPE` AS `SHAREMODETYPE`,`a`.`SHAREMODE` AS `SHAREMODE`,`a`.`FORMATTYPE` AS `FORMATTYPE`,`a`.`id` AS `id`,`a`.`ISOPENSOCIAL` AS `ISOPENSOCIAL`,`a`.`infoname` AS `infoname`,`a`.`PROVIDEZGNAME` AS `PROVIDEZGNAME`,`a`.`SHARETYPE` AS `SHARETYPE`,`a`.`UPDATETIME` AS `UPDATETIME`,`a`.`VERSIONID` AS `VERSIONID`,`a`.`INFOTYPENAME` AS `INFOTYPENAME`,`a`.`UPDATECYCLE` AS `UPDATECYCLE`,`a`.`SHAREMODETYPENAME` AS `SHAREMODETYPENAME`,`a`.`apply_count` AS `apply_count`,`b`.`rowcount` AS `exchange_count` from ((select `d`.`HITCH_STATUS` AS `HITCH_STATUS`,`d`.`INFOTYPEID` AS `INFOTYPEID`,`d`.`LATESTVERSION` AS `LATESTVERSION`,`d`.`INPROCESS` AS `INPROCESS`,`d`.`INFOCODE` AS `INFOCODE`,`d`.`INFOTYPE` AS `INFOTYPE`,`d`.`SHAREMODETYPE` AS `SHAREMODETYPE`,`d`.`SHAREMODE` AS `SHAREMODE`,`d`.`FORMATTYPE` AS `FORMATTYPE`,`d`.`ID` AS `id`,`d`.`ISOPENSOCIAL` AS `ISOPENSOCIAL`,`d`.`INFONAME` AS `infoname`,`d`.`PROVIDEBMNAME` AS `PROVIDEZGNAME`,`d`.`SHARETYPE` AS `SHARETYPE`,`d`.`UPDATETIME` AS `UPDATETIME`,`d`.`VERSIONID` AS `VERSIONID`,`d`.`INFOTYPENAME` AS `INFOTYPENAME`,`d`.`UPDATECYCLE` AS `UPDATECYCLE`,`d`.`SHAREMODETYPENAME` AS `SHAREMODETYPENAME`,sum((case when (`c`.`TINFOCLASSID` is null) then 0 else 1 end)) AS `apply_count` from (`t_infoclass` `d` left join `t_shareapply` `c` on(((`d`.`ID` = `c`.`TINFOCLASSID`) and (`c`.`STATE` = '2')))) group by `d`.`INFONAME`,`d`.`ID`) `a` left join `data_count` `b` on((`a`.`INFOCODE` = `b`.`infocode`))) where ((`a`.`INPROCESS` = '2') and (`a`.`LATESTVERSION` = '1') and (`a`.`SHAREMODETYPENAME` = '数据库') and (`a`.`INFOTYPEID` in (select `t_res_classify`.`RESID` from `t_res_classify` where (`t_res_classify`.`PRESID` in (select `t_res_classify`.`RESID` from `t_res_classify` where (`t_res_classify`.`PRESID` = '4be5df7a1876474d940be89b494677a7')) and (`t_res_classify`.`STATE` = 0))) or `a`.`INFOTYPEID` in (select `t_res_classify`.`RESID` from `t_res_classify` where `t_res_classify`.`PRESID` in (select `t_res_classify`.`RESID` from `t_res_classify` where `t_res_classify`.`PRESID` in (select `t_res_classify`.`RESID` from `t_res_classify` where `t_res_classify`.`PRESID` in (select `t_res_classify`.`RESID` from `t_res_classify` where ((`t_res_classify`.`PRESID` = 'bm') and (`t_res_classify`.`STATE` = 0)))))))) order by `a`.`INFOCODE` limit 0,10;

-- ----------------------------
-- View structure for infoclass
-- ----------------------------
DROP VIEW IF EXISTS `infoclass`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `infoclass` AS select `b`.`INFOCODE` AS `INFOCODE`,`b`.`INFONAME` AS `INFONAME`,`b`.`HITCH_STATUS` AS `ISHANGON`,(case when (`b`.`ISOPENSOCIAL` = '不予开放') then 0 else 1 end) AS `ISOPENSOCIAL`,(case when (`b`.`SHAREMODETYPE` = 'wj') then 1 else 0 end) AS `SHAREMODETYPE`,`b`.`SHARETYPE` AS `SHARETYPE`,`b`.`PROVIDEBMCODE` AS `PROVIDEBMCODE`,`b`.`PROVIDEBMNAME` AS `PROVIDEBmNAME`,`b`.`INPROCESS` AS `INPROCESS` from `t_infoclass` `b` where ((`b`.`LATESTVERSION` = '1') and (`b`.`INPROCESS` in ('2','5')));

-- ----------------------------
-- View structure for login_user_info
-- ----------------------------
DROP VIEW IF EXISTS `login_user_info`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `login_user_info` AS select `deptinfo`.`DEPT_NAME` AS `单位名称`,`userinfo`.`LOGIN_NAME` AS `登录名`,`role`.`ROLE_NAME` AS `角色名称` from (((`deptinfo` left join `userinfo` on((`deptinfo`.`DEPT_ID` = `userinfo`.`DEPTID`))) left join `role_user` on((`userinfo`.`USER_ID` = `role_user`.`USER_ID`))) left join `role` on((`role`.`ROLE_ID` = `role_user`.`ROLE_ID`)));

-- ----------------------------
-- View structure for new_govername
-- ----------------------------
DROP VIEW IF EXISTS `new_govername`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `new_govername` AS select `deptinfo`.`DEPT_ID` AS `id`,`deptinfo`.`DEPT_INDEX` AS `order`,`deptinfo`.`DEPT_NAME` AS `new_name`,`deptinfo`.`DEPT_ABBREVIATION` AS `old_name`,`deptinfo`.`XZQHCODE` AS `xzqhname`,`deptinfo`.`DEPT_PROPERTY` AS `dept_property` from `deptinfo` where (`deptinfo`.`PARENT_ID` in ('c271fb9c6e7e4faab8d27c91352b597d','59cf7812bf1f4b8ab61f2ac8ab08eb36','fab35d8246a448f9834bf492d41aa56c','c45f71f7268549a39c9d0cbef17475c9','099d5e5d613847f484de24b5bf727c9a','7138881327fb46f1b1d2d0acb2d98165','9ba7b4bb3f054181b7096974747c554b','c58168c12c8b4a5c9a938f0b4fb71f36','ab4256baa8f948329bb88e9988d7daf1','ff91669e1eff475b996d2ef88beb2ae0','0f2b2f4c1b484757a683b367d4a1c4ee','4caa3ec75c8949c08a6f523a804d30b9','818165795a164cd7a973c7705e4e9ea7','cb48bb89ad0344e6b4d9dc1fc91c4a78','ddef73cfba08421e8d2c1f28fa4d845c','a688378b07094278a5a0e06f218906b7','269a11aff2714a32bc46086ced59ed20')) order by `deptinfo`.`XZQHNAME`;

-- ----------------------------
-- View structure for r_dutyinfo_view
-- ----------------------------
DROP VIEW IF EXISTS `r_dutyinfo_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `r_dutyinfo_view` AS select `p`.`id` AS `dutyid`,`p`.`enforcementbody` AS `enforcementbody`,`p`.`enforcementbody_name` AS `enforcementbody_name`,`p`.`dutyinfo` AS `dutyinfo`,`q`.`id` AS `subid`,`q`.`id` AS `uuid`,`q`.`subdutyname` AS `subdutyname`,`q`.`subdutycode` AS `subdutycode`,`q`.`subdutytype` AS `subdutytype` from (`t_power_responsibility` `p` join `t_subpower_responsibility` `q`) where ((`p`.`id` = `q`.`mainid`) and (`p`.`state` = '1') and (`q`.`state` = '1'));

-- ----------------------------
-- View structure for r_info_interface_view
-- ----------------------------
DROP VIEW IF EXISTS `r_info_interface_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `r_info_interface_view` AS select `p`.`regid` AS `inter_id`,`q`.`ID` AS `info_id` from (`t_service_reginfo` `p` join `t_infoclass` `q`) where ((`p`.`inprocess` = '2') and (`p`.`latestversion` = '1') and (locate(`q`.`ID`,`p`.`classid`) > 0));

-- ----------------------------
-- View structure for r_infoclass_lifeinfo_view
-- ----------------------------
DROP VIEW IF EXISTS `r_infoclass_lifeinfo_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `r_infoclass_lifeinfo_view` AS select `p`.`taskstart` AS `taskstart`,`p`.`taskname` AS `taskname`,`p`.`id` AS `info_id`,`q`.`INFOCODE` AS `infocode`,`p`.`state` AS `state`,concat(`p`.`taskstart`,convert(`p`.`taskname` using utf8mb4),convert(`p`.`id` using utf8mb4),convert(convert(`p`.`state` using utf8mb3) using utf8mb4)) AS `uuid`,concat(`q`.`VERSIONID`,'.',`q`.`SUBVERSIONID`) AS `versionid` from ((select `t_infoclass`.`CREATEDATE` AS `taskstart`,'注册' AS `taskname`,`t_infoclass`.`ID` AS `id`,'0' AS `state` from `t_infoclass` where ((`t_infoclass`.`INPROCESS` = '2') or (`t_infoclass`.`INPROCESS` = '5')) union select `t_infoclass`.`UPDATETIME` AS `taskstart`,'启用' AS `taskname`,`t_infoclass`.`ID` AS `id`,'2' AS `state` from `t_infoclass` where ((`t_infoclass`.`INPROCESS` = '2') or (`t_infoclass`.`INPROCESS` = '5')) union select `p`.`taskend` AS `taskstart`,`p`.`taskname` AS `taskname`,`q`.`ID` AS `id`,'1' AS `state` from (`v_histasklist_t` `p` join `t_infoclass` `q`) where (`p`.`proinstid` = `q`.`PROCESSID`) union select date_format(`p`.`LOGTIME`,'%Y-%m-%d %h:%m:%s') AS `taskstart`,(case when (`p`.`LOGDETAIL` = '信息类更新(启用)') then '启用' else '禁用' end) AS `taskname`,`p`.`DATAID` AS `id`,(case when (`p`.`LOGDETAIL` = '信息类更新(启用)') then '2' else '3' end) AS `state` from `loginfo` `p` where ((`p`.`LOGTABLE` = 't_infoclass') and ((`p`.`LOGDETAIL` = '信息类更新(启用)') or (`p`.`LOGDETAIL` = '信息类更新(禁用)'))) union select (date_format(`p`.`CREATEDATE`,'%Y-%m-%d %H:%i:%s') + interval -(1) second) AS `taskstart`,'变更' AS `taskname`,`p`.`ID` AS `id`,'4' AS `state` from `t_infoclass` `p` where ((`p`.`PARENTID` is not null) and (`p`.`PARENTID` <> ''))) `p` join `t_infoclass` `q`) where (`p`.`id` = `q`.`ID`);

-- ----------------------------
-- View structure for r_inter_dept_view
-- ----------------------------
DROP VIEW IF EXISTS `r_inter_dept_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `r_inter_dept_view` AS select `t_service_applyinfo`.`reqid` AS `inter_id`,`t_service_applyinfo`.`mingchengid` AS `dept_id` from `t_service_applyinfo` where (`t_service_applyinfo`.`inprocess` = '2');

-- ----------------------------
-- View structure for r_scene_dept_view
-- ----------------------------
DROP VIEW IF EXISTS `r_scene_dept_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `r_scene_dept_view` AS select `t_scene_info`.`sceneid` AS `scene_id`,`t_scene_info`.`lead_dept` AS `dept_id` from `t_scene_info`;

-- ----------------------------
-- View structure for r_scene_info_view
-- ----------------------------
DROP VIEW IF EXISTS `r_scene_info_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `r_scene_info_view` AS select `p`.`sceneid` AS `scence_id`,`q`.`TINFOCLASSID` AS `info_id` from (`t_scene_relation` `p` join `t_shareapply` `q`) where ((`p`.`ywtable` = 't_shareapply') and (`p`.`ywid` = `q`.`ID`)) union select `p`.`sceneid` AS `scence_id`,`qq`.`ID` AS `info_id` from (((`t_scene_relation` `p` join `t_service_applyinfo` `q`) join `t_service_reginfo` `pp`) join `t_infoclass` `qq`) where ((`pp`.`inprocess` = '2') and (`pp`.`latestversion` = '1') and (locate(`qq`.`ID`,`pp`.`classid`) > 0) and (`p`.`ywtable` = 't_service_applyinfo') and (`p`.`ywid` = `q`.`applyid`));

-- ----------------------------
-- View structure for r_service_applyinfo_lifeinfo_view
-- ----------------------------
DROP VIEW IF EXISTS `r_service_applyinfo_lifeinfo_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `r_service_applyinfo_lifeinfo_view` AS select `p`.`taskname` AS `taskname`,`p`.`taskstart` AS `taskstart`,`p`.`applyid` AS `applyid`,`p`.`state` AS `state`,concat(convert(`p`.`applyid` using utf8mb4),convert(convert(`p`.`state` using utf8mb3) using utf8mb4),convert(`p`.`taskname` using utf8mb4),`p`.`taskstart`) AS `uuid`,`t`.`apicode` AS `apicode` from ((select '申请' AS `taskname`,`t_service_applyinfo`.`createtime` AS `taskstart`,`t_service_applyinfo`.`applyid` AS `applyid`,'0' AS `state` from `t_service_applyinfo` union select '实施' AS `taskname`,`t_service_applyinfo`.`dealdate` AS `taskstart`,`t_service_applyinfo`.`applyid` AS `applyid`,'3' AS `state` from `t_service_applyinfo` where (`t_service_applyinfo`.`isdeal` = '1') union select `p`.`taskname` AS `taskname`,`p`.`taskend` AS `taskstart`,`q`.`applyid` AS `applyid`,'1' AS `state` from (`v_histasklist_t` `p` join `t_service_applyinfo` `q`) where (`p`.`proinstid` = `q`.`processid`) union select '备案' AS `taskname`,`t_service_applyinfo`.`beiantime` AS `taskstart`,`t_service_applyinfo`.`applyid` AS `applyid`,'2' AS `state` from `t_service_applyinfo` where (`t_service_applyinfo`.`beiantime` is not null)) `p` left join (select `p`.`applyid` AS `applyid`,`q`.`apicode` AS `apicode` from (`t_service_applyinfo` `p` join `t_service_reginfo` `q`) where (`p`.`reqid` = `q`.`regid`)) `t` on((`p`.`applyid` = `t`.`applyid`)));

-- ----------------------------
-- View structure for r_service_reginfo_lifeinfo_view
-- ----------------------------
DROP VIEW IF EXISTS `r_service_reginfo_lifeinfo_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `r_service_reginfo_lifeinfo_view` AS select `p`.`taskstart` AS `taskstart`,`p`.`taskname` AS `taskname`,`p`.`id` AS `service_id`,`p`.`state` AS `state`,`p`.`apicode` AS `apicode`,`p`.`versionnum` AS `versionnum`,concat(`p`.`taskstart`,convert(`p`.`taskname` using utf8mb4),convert(`p`.`id` using utf8mb4),convert(convert(`p`.`state` using utf8mb3) using utf8mb4)) AS `uuid` from ((select `t_service_reginfo`.`createtime` AS `taskstart`,'注册' AS `taskname`,`t_service_reginfo`.`regid` AS `id`,'0' AS `state`,`t_service_reginfo`.`apicode` AS `apicode`,`t_service_reginfo`.`versionnum` AS `versionnum` from `t_service_reginfo` where ((`t_service_reginfo`.`inprocess` = '2') or (`t_service_reginfo`.`inprocess` = '5')) union select `p`.`taskend` AS `taskstart`,`p`.`taskname` AS `taskname`,`q`.`regid` AS `id`,'1' AS `state`,`q`.`apicode` AS `apicode`,`q`.`versionnum` AS `versionnum` from (`v_histasklist_t` `p` join `t_service_reginfo` `q`) where (`p`.`proinstid` = `q`.`processid`) union select `t_service_reginfo`.`qjdate` AS `taskstart`,(case when (`t_service_reginfo`.`inprocess` = '2') then '启用' when (`t_service_reginfo`.`inprocess` = '5') then '停用' end) AS `taskname`,`t_service_reginfo`.`regid` AS `id`,(case when (`t_service_reginfo`.`inprocess` = '2') then '2' when (`t_service_reginfo`.`inprocess` = '5') then '3' end) AS `state`,`t_service_reginfo`.`apicode` AS `apicode`,`t_service_reginfo`.`versionnum` AS `versionnum` from `t_service_reginfo` where (((`t_service_reginfo`.`inprocess` = '5') or (`t_service_reginfo`.`inprocess` = '2')) and (`t_service_reginfo`.`qjdate` is not null)) union select `t_service_reginfo`.`gjsj` AS `taskstart`,'服务挂接' AS `taskname`,`t_service_reginfo`.`regid` AS `id`,'5' AS `state`,`t_service_reginfo`.`apicode` AS `apicode`,`t_service_reginfo`.`versionnum` AS `versionnum` from `t_service_reginfo` where (((`t_service_reginfo`.`inprocess` = '5') or (`t_service_reginfo`.`inprocess` = '2')) and (`t_service_reginfo`.`gjsj` is not null) and (`t_service_reginfo`.`isgj` = '1')) union select `t_service_reginfo`.`releasedate` AS `taskstart`,'启用' AS `taskname`,`t_service_reginfo`.`regid` AS `id`,'2' AS `state`,`t_service_reginfo`.`apicode` AS `apicode`,`t_service_reginfo`.`versionnum` AS `versionnum` from `t_service_reginfo` where (((`t_service_reginfo`.`inprocess` = '5') or (`t_service_reginfo`.`inprocess` = '2')) and (`t_service_reginfo`.`releasedate` is not null)) union select `p`.`createtime` AS `taskstart`,'变更' AS `taskname`,`p`.`regid` AS `id`,'4' AS `state`,`p`.`apicode` AS `apicode`,`p`.`versionnum` AS `versionnum` from `t_service_reginfo` `p` where ((`p`.`parentid` is not null) and (`p`.`parentid` <> ''))) `p` join `t_service_reginfo` `q`) where (`p`.`id` = `q`.`regid`) order by `p`.`id`,`p`.`taskstart`;

-- ----------------------------
-- View structure for r_shareapply_lifeinfo_view
-- ----------------------------
DROP VIEW IF EXISTS `r_shareapply_lifeinfo_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `r_shareapply_lifeinfo_view` AS select `p`.`taskname` AS `taskname`,`p`.`taskstart` AS `taskstart`,`p`.`id` AS `applyid`,`p`.`state` AS `state`,concat(convert(`p`.`id` using utf8mb4),convert(`p`.`taskname` using utf8mb4),`p`.`taskstart`) AS `uuid` from (select '申请' AS `taskname`,`t_shareapply`.`APPLYDATE` AS `taskstart`,`t_shareapply`.`ID` AS `id`,'0' AS `state` from `t_shareapply` union select '备案' AS `taskname`,`t_shareapply`.`UPDATETIME` AS `taskstart`,`t_shareapply`.`ID` AS `id`,'2' AS `state` from `t_shareapply` where (`t_shareapply`.`STATE` = '2') union select '实施' AS `taskname`,`t_shareapply`.`ACTUALIZETIME` AS `taskstart`,`t_shareapply`.`ID` AS `id`,'3' AS `state` from `t_shareapply` where ((`t_shareapply`.`ACTUALIZETIME` is not null) and (`t_shareapply`.`ACTUALIZETIME` <> '')) union select `p`.`taskname` AS `taskname`,`p`.`taskend` AS `taskstart`,`q`.`ID` AS `id`,'1' AS `state` from (`v_histasklist_t` `p` join `t_shareapply` `q`) where (`p`.`proinstid` = `q`.`PROCESSID`)) `p`;

-- ----------------------------
-- View structure for serviceshare_bm_delay
-- ----------------------------
DROP VIEW IF EXISTS `serviceshare_bm_delay`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `serviceshare_bm_delay` AS select `t`.`PROVIDEid` AS `PROVIDEBMCODE`,`t`.`PROVIDENAME` AS `PROVIDEBMNAME`,count(1) AS `num` from (select distinct `w`.`provideid` AS `PROVIDEid`,`w`.`providename` AS `PROVIDENAME`,`p`.`TASK_ID` AS `TASK_ID` from ((`v_tasklist_delay` `p` join `t_service_applyinfo` `q`) join `t_service_reginfo` `w`) where ((`p`.`PROC_INST_ID` = `q`.`processid`) and (`q`.`reqid` = `w`.`regid`))) `t` group by `t`.`PROVIDEid`,`t`.`PROVIDENAME`;

-- ----------------------------
-- View structure for t_infoclass_updatecycle_diff_view
-- ----------------------------
DROP VIEW IF EXISTS `t_infoclass_updatecycle_diff_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `t_infoclass_updatecycle_diff_view` AS select `p`.`INFONAME` AS `信息类名称`,`p`.`INFOCODE` AS `信息类编码`,concat(`p`.`VERSIONID`,'.',`p`.`SUBVERSIONID`) AS `版本号`,`p`.`PROVIDEBMNAME` AS `提供方部门`,`p`.`UPDATECYCLE` AS `更新频率`,`p`.`UPDATETIME` AS `发布时间`,`q`.`INFONAME` AS `信息类名称OLD`,`q`.`INFOCODE` AS `信息类编码OLD`,concat(`q`.`VERSIONID`,'.',`q`.`SUBVERSIONID`) AS `版本号OLD`,`q`.`UPDATECYCLE` AS `更新频率OLD`,`q`.`UPDATETIME` AS `发布时间OLD` from (`t_infoclass` `p` join `t_infoclass` `q`) where ((`p`.`LATESTVERSION` = '1') and (`p`.`INPROCESS` = '2') and (`q`.`ID` = `p`.`PARENTID`) and (`p`.`UPDATECYCLE` <> `q`.`UPDATECYCLE`));

-- ----------------------------
-- View structure for v_apply_passrate
-- ----------------------------
DROP VIEW IF EXISTS `v_apply_passrate`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_apply_passrate` AS select sum((case when (`t_shareapply`.`STATE` = '2') then 1 else 0 end)) AS `oknum`,count(1) AS `totalnum`,`t_shareapply`.`APPLYDEPTID` AS `applydeptid` from `t_shareapply` where (`t_shareapply`.`STATE` in (2,3)) group by `t_shareapply`.`APPLYDEPTID`;

-- ----------------------------
-- View structure for v_create_table_sql
-- ----------------------------
DROP VIEW IF EXISTS `v_create_table_sql`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_create_table_sql` AS select `t_infoclass`.`INFOCODE` AS `infocode`,concat('CREATE TABLE t_',replace(`t_infoclass`.`INFOCODE`,'/','_'),'(GUID VARCHAR(100), ',group_concat('f_',replace(`t_infoclass_datameta`.`XXXBM`,'/','_'),' ',(case when (`t_infoclass_datameta`.`DATATYPE_DIS` = 'Varchar2') then convert((case when ((3999 > (`t_infoclass_datameta`.`DATASIZE` * 3)) > 254) then concat('LVARCHAR (',(`t_infoclass_datameta`.`DATASIZE` * 3),') ') when ((`t_infoclass_datameta`.`DATASIZE` * 3) > 4000) then 'JSON ' else concat('VARCHAR(',(`t_infoclass_datameta`.`DATASIZE` * 3),') ') end) using utf8mb3) when (`t_infoclass_datameta`.`DATATYPE_DIS` = 'Varchar') then convert((case when ((`t_infoclass_datameta`.`DATASIZE` * 3) > 254) then concat('LVARCHAR (',(`t_infoclass_datameta`.`DATASIZE` * 3),') ') when ((`t_infoclass_datameta`.`DATASIZE` * 3) > 4000) then 'JSON ' else concat('VARCHAR(',(`t_infoclass_datameta`.`DATASIZE` * 3),') ') end) using utf8mb3) when (`t_infoclass_datameta`.`DATATYPE_DIS` = 'Text') then 'JSON ' when (`t_infoclass_datameta`.`DATATYPE_DIS` = 'Clob') then 'JSON ' when (`t_infoclass_datameta`.`DATATYPE_DIS` = 'Integer') then 'DECIMAL(16,0) ' when (`t_infoclass_datameta`.`DATATYPE_DIS` = 'Number') then 'DECIMAL(16,2) ' when (`t_infoclass_datameta`.`DATATYPE_DIS` = 'Decimal') then 'DECIMAL(16,2) ' when (`t_infoclass_datameta`.`DATATYPE_DIS` = 'Blob') then 'JSON ' when (`t_infoclass_datameta`.`DATATYPE_DIS` = 'Float') then 'DECIMAL(16,2) ' when (`t_infoclass_datameta`.`DATATYPE_DIS` = 'Datetime') then 'DATETIME YEAR TO SECOND ' when (`t_infoclass_datameta`.`DATATYPE_DIS` = 'Timestamp') then 'DATETIME YEAR TO SECOND ' else concat(`t_infoclass_datameta`.`DATATYPE_DIS`,' (',`t_infoclass_datameta`.`DATASIZE`,') ') end) order by `t_infoclass_datameta`.`XXXBM` ASC separator ','),',TOPIC_UPDATE_TIME DATETIME YEAR TO SECOND,TOPIC_ADD_TIME DATETIME YEAR TO SECOND,OPERATETYPE VARCHAR(2))') AS `f_column` from (`t_infoclass` join `t_infoclass_datameta`) where ((`t_infoclass`.`ID` = `t_infoclass_datameta`.`TINFOCLASSID`) and (`t_infoclass`.`LATESTVERSION` = '1') and (`t_infoclass`.`INPROCESS` = '2')) group by `t_infoclass`.`INFOCODE`;

-- ----------------------------
-- View structure for v_datacout
-- ----------------------------
DROP VIEW IF EXISTS `v_datacout`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_datacout` AS select `t_infoclass`.`PROVIDEBMNAME` AS `PROVIDEBMNAMENAME`,`t_infoclass`.`INFOCODE` AS `INFOCODE`,`t_infoclass`.`INFONAME` AS `INFONAME`,`t_infoclass`.`HITCH_STATUS` AS `HITCH_STATUS`,`t_infoclass`.`XZQHCODE` AS `XZQHCODE`,`t_infoclass`.`SHAREMODETYPENAME` AS `SHAREMODETYPENAME`,`t_infoclass_datameta`.`ID` AS `XXXID`,`t_infoclass_datameta`.`XXXMC` AS `XXXMC`,`t_infoclass_datameta`.`XXXBM` AS `XXXBM`,`t_infoclass_datameta`.`DATATYPE_DIS` AS `DATATYPE_DIS`,`t_infoclass_datameta`.`METACODE_DIS` AS `METACODE_DIS`,`t_infoclass_datameta`.`DATASIZE` AS `DATASIZE`,`t_infoclass_datameta`.`SHARETYPE` AS `SHARETYPE`,`t_infoclass_datameta`.`INDEXNUM` AS `INDEXNUM` from (`t_infoclass` left join `t_infoclass_datameta` on((`t_infoclass`.`ID` = `t_infoclass_datameta`.`TINFOCLASSID`))) where ((`t_infoclass`.`INPROCESS` = '2') and (`t_infoclass`.`LATESTVERSION` = '1')) order by `t_infoclass`.`PROVIDENAME`,`t_infoclass`.`INFOCODE`,`t_infoclass_datameta`.`XXXBM`;

-- ----------------------------
-- View structure for v_histasklist
-- ----------------------------
DROP VIEW IF EXISTS `v_histasklist`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_histasklist` AS select `inst`.`BUSINESS_KEY_` AS `busid`,`p`.`ID_` AS `taskid`,`p`.`EXECUTION_ID_` AS `proinstid`,`p`.`NAME_` AS `taskname`,`p`.`ASSIGNEE_` AS `taskman`,`c`.`USER_ID_` AS `manname`,date_format(`p`.`START_TIME_`,'%Y-%m-%d %H:%i:%s') AS `taskstart`,date_format(`p`.`END_TIME_`,'%Y-%m-%d %H:%i:%s') AS `taskend`,`c`.`MESSAGE_` AS `taskmessage` from ((`act_hi_taskinst` `p` join `act_hi_comment` `c`) join `act_hi_procinst` `inst`) where ((`c`.`PROC_INST_ID_` = `p`.`EXECUTION_ID_`) and (`c`.`ACTION_` = 'AddComment') and (`c`.`TASK_ID_` = `p`.`ID_`) and (`inst`.`PROC_INST_ID_` = `p`.`EXECUTION_ID_`) and (`p`.`END_TIME_` is not null));

-- ----------------------------
-- View structure for v_hitch_passrate
-- ----------------------------
DROP VIEW IF EXISTS `v_hitch_passrate`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_hitch_passrate` AS select sum((case when (`p`.`GJCHECKSTATE` = '2') then 1 else 0 end)) AS `oknum`,count(1) AS `totalnum`,`p`.`PROVIDEBMCODE` AS `providebmcode` from `t_infoclass` `p` where ((`p`.`INPROCESS` = '2') and (`p`.`LATESTVERSION` = '1') and (`p`.`GJCHECKSTATE` in ('2','3'))) group by `p`.`PROVIDEBMCODE`;

-- ----------------------------
-- View structure for v_infoclass_apply_info
-- ----------------------------
DROP VIEW IF EXISTS `v_infoclass_apply_info`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_infoclass_apply_info` AS select distinct `p`.`ID` AS `ID`,`p`.`TINFOCLASSID` AS `TINFOCLASSID`,`q`.`INFOCODE` AS `INFOCODE`,`q`.`INFONAME` AS `infoname`,`q`.`SHAREMODETYPEID` AS `SHAREMODETYPEID`,`q`.`PROVIDEBMCODE` AS `PROVIDEBMCODE`,`p`.`APPLYDEPTID` AS `APPLYDEPTID`,`p`.`APPLYDATE` AS `APPLYDATE`,`p`.`APPLYREASON` AS `APPLYREASON`,(case when (`p`.`STATE` = '2') then '审核通过' when (`p`.`STATE` = '3') then '审核不通过' when (`p`.`STATE` = '0') then '保存' when ((`p`.`TASKNAME` <> '需求方协调') and (`p`.`STATE` = '1')) then `p`.`TASKNAME` when ((`p`.`TASKNAME` = '需求方协调') and (`p`.`STATE` = '1')) then `p`.`TASKNAME` end) AS `taskname`,(case when (`p`.`STATE` = '2') then 3 when (`p`.`STATE` = '0') then 0 when ((`p`.`TASKNAME` <> '需求方协调') and (`p`.`STATE` = '1')) then 1 when ((`p`.`TASKNAME` = '需求方协调') and (`p`.`STATE` = '1')) then 2 when (`p`.`STATE` = '3') then 4 end) AS `STATE`,(case when (`z`.`PROC_INST_ID` is null) then 0 else 1 end) AS `OVERDUE` from ((`t_shareapply` `p` left join `t_infoclass` `q` on((`p`.`TINFOCLASSID` = `q`.`ID`))) left join `v_tasklist_delay` `z` on((`p`.`PROCESSID` = `z`.`PROC_INST_ID`))) where (`p`.`STATE` is not null);

-- ----------------------------
-- View structure for v_infoclass_apply_summary
-- ----------------------------
DROP VIEW IF EXISTS `v_infoclass_apply_summary`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_infoclass_apply_summary` AS select `a`.`share_type` AS `share_type`,`a`.`dept_id` AS `dept_id`,`a`.`apply_num` AS `apply_num`,`a`.`finish_num` AS `finish_num`,`a`.`being_num` AS `being_num`,`a`.`coordinate_num` AS `coordinate_num`,(case when (`b`.`num` > 0) then `b`.`num` else 0 end) AS `OVERDUE` from (`bp_share_view` `a` left join (select `datashare_bm_delay`.`PROVIDEBMCODE` AS `PROVIDEBMCODE`,`datashare_bm_delay`.`PROVIDEBMNAME` AS `PROVIDEBMNAME`,`datashare_bm_delay`.`num` AS `num` from `datashare_bm_delay` group by `datashare_bm_delay`.`PROVIDEBMCODE`) `b` on((`a`.`dept_id` = `b`.`PROVIDEBMCODE`))) where (`a`.`share_type` = '1');

-- ----------------------------
-- View structure for v_infoclass_passrate
-- ----------------------------
DROP VIEW IF EXISTS `v_infoclass_passrate`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_infoclass_passrate` AS select sum((case when (`t_infoclass`.`INPROCESS` = '2') then 1 else 0 end)) AS `oknum`,count(1) AS `totalnum`,`t_infoclass`.`PROVIDEBMCODE` AS `providebmcode` from `t_infoclass` where (((`t_infoclass`.`INPROCESS` = '2') and (`t_infoclass`.`LATESTVERSION` = '1')) or ((`t_infoclass`.`INPROCESS` = '1') and (`t_infoclass`.`TASKNAME` = '编目人员修改'))) group by `t_infoclass`.`PROVIDEBMCODE`;

-- ----------------------------
-- View structure for v_infoclass_published
-- ----------------------------
DROP VIEW IF EXISTS `v_infoclass_published`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_infoclass_published` AS select `a`.`PROVIDEBMNAME` AS `bmmc`,`a`.`INFOCODE` AS `infocode`,`a`.`INFONAME` AS `xxlmc` from (`t_infoclass` `a` left join `t_res_classify` `b` on((`a`.`INFOTYPEID` = `b`.`RESID`))) where ((`b`.`PRESID` = '4be5df7a1876474d940be89b494677a7') and (`a`.`LATESTVERSION` = '1') and (`a`.`INPROCESS` = '2')) order by `a`.`PROVIDEBMNAME`,`a`.`INFOCODE`;

-- ----------------------------
-- View structure for v_service_apply_info
-- ----------------------------
DROP VIEW IF EXISTS `v_service_apply_info`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_service_apply_info` AS select distinct `p`.`taskname` AS `taskname`,`p`.`applyid` AS `applyid`,`q`.`regid` AS `regid`,`q`.`cnname` AS `cnname`,`q`.`enname` AS `enname`,`q`.`provideid` AS `provideid`,`p`.`mingchengid` AS `mingchengid`,`q`.`apicode` AS `apicode`,`p`.`createtime` AS `createtime`,`p`.`reason` AS `reason`,(case when (`p`.`inprocess` = '2') then 3 when (`p`.`inprocess` = '0') then 0 when ((`p`.`taskname` <> '需求方协调') and (`p`.`inprocess` = '1')) then 1 when ((`p`.`taskname` = '需求方协调') and (`p`.`inprocess` = '1')) then 2 when (`p`.`inprocess` = '3') then 4 end) AS `STATE`,(case when (`z`.`PROC_INST_ID` is null) then 0 else 1 end) AS `OVERDUE` from ((`t_service_applyinfo` `p` left join `t_service_reginfo` `q` on((`q`.`regid` = `p`.`reqid`))) left join `v_tasklist_delay` `z` on((`p`.`processid` = `z`.`PROC_INST_ID`))) where (`p`.`inprocess` <> '4');

-- ----------------------------
-- View structure for v_service_apply_summary
-- ----------------------------
DROP VIEW IF EXISTS `v_service_apply_summary`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_service_apply_summary` AS select `a`.`share_type` AS `share_type`,`a`.`dept_id` AS `dept_id`,`a`.`apply_num` AS `apply_num`,`a`.`finish_num` AS `finish_num`,`a`.`being_num` AS `being_num`,`a`.`coordinate_num` AS `coordinate_num`,(case when ((`b`.`num` > 0) and (`b`.`num` is not null)) then `b`.`num` else 0 end) AS `OVERDUE` from (`bp_share_view` `a` left join (select `serviceshare_bm_delay`.`PROVIDEBMCODE` AS `PROVIDEBMCODE`,`serviceshare_bm_delay`.`PROVIDEBMNAME` AS `PROVIDEBMNAME`,`serviceshare_bm_delay`.`num` AS `num` from `serviceshare_bm_delay` group by `serviceshare_bm_delay`.`PROVIDEBMCODE`) `b` on((`a`.`dept_id` = `b`.`PROVIDEBMCODE`))) where (`a`.`share_type` = '2');

-- ----------------------------
-- View structure for v_shareapplyintime_passrate
-- ----------------------------
DROP VIEW IF EXISTS `v_shareapplyintime_passrate`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_shareapplyintime_passrate` AS select sum((case when (`l`.`duration_time` > 2) then 1 else 0 end)) AS `intime`,count(1) AS `total`,`l`.`providebmcode` AS `providebmcode` from (select (select count(1) from `workcalendar` where ((date_format(`workcalendar`.`workdate`,'%Y-%m-%d') >= substr(`p`.`START_TIME_`,1,10)) and (substr(`p`.`END_TIME_`,1,10) >= date_format(`workcalendar`.`workdate`,'%Y-%m-%d')) and (`workcalendar`.`iswork` = '0'))) AS `duration_time`,`z`.`PROVIDEBMCODE` AS `providebmcode` from ((`act_hi_taskinst` `p` join `t_shareapply` `q`) join `t_infoclass` `z`) where ((`z`.`ID` = `q`.`TINFOCLASSID`) and (`p`.`PROC_DEF_ID_` like 'shareApply%') and (`p`.`NAME_` = '提供方部门审核') and (`p`.`PROC_INST_ID_` = `q`.`PROCESSID`) and (`p`.`END_TIME_` is not null))) `l` group by `l`.`providebmcode`;

-- ----------------------------
-- View structure for v_task_userid
-- ----------------------------
DROP VIEW IF EXISTS `v_task_userid`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_task_userid` AS select `i`.`TASK_ID_` AS `TASK_ID_`,`i`.`USER_ID_` AS `USER_ID` from (`act_ru_identitylink` `i` join `act_ru_task` `t`) where ((`i`.`TASK_ID_` is not null) and (`i`.`USER_ID_` is not null) and (`i`.`TASK_ID_` = `t`.`ID_`) and (`t`.`ASSIGNEE_` is null) and (`i`.`TYPE_` = 'candidate')) union select `i`.`TASK_ID_` AS `TASK_ID_`,`r`.`USER_ID` AS `USER_ID` from ((`act_ru_identitylink` `i` join `role_user` `r`) join `act_ru_task` `t`) where ((`i`.`TASK_ID_` is not null) and (`i`.`GROUP_ID_` is not null) and (`i`.`TASK_ID_` = `t`.`ID_`) and (`t`.`ASSIGNEE_` is null) and (`i`.`TYPE_` = 'candidate') and (`i`.`GROUP_ID_` = `r`.`ROLE_ID`));

-- ----------------------------
-- View structure for v_task_userid_last
-- ----------------------------
DROP VIEW IF EXISTS `v_task_userid_last`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_task_userid_last` AS select distinct `u`.`TASK_ID_` AS `TASK_ID_`,`u`.`USER_ID` AS `USER_ID` from `v_task_userid` `u`;

-- ----------------------------
-- View structure for v_tasklist
-- ----------------------------
DROP VIEW IF EXISTS `v_tasklist`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_tasklist` AS select `a`.`ID_` AS `task_id`,`a`.`PROC_INST_ID_` AS `proc_inst_id`,`a`.`TASK_DEF_KEY_` AS `act_id`,`a`.`NAME_` AS `act_name`,`a`.`ASSIGNEE_` AS `assignee`,`a`.`DELEGATION_` AS `delegation_id`,`a`.`DESCRIPTION_` AS `description`,date_format(`a`.`CREATE_TIME_`,'%Y-%m-%d %H:%i:%s') AS `create_time`,date_format(`a`.`DUE_DATE_`,'%Y-%m-%d %H:%i:%s') AS `due_date`,`i`.`USER_ID` AS `candidate`,`a`.`FORM_KEY_` AS `form_key` from (`act_ru_task` `a` left join `v_task_userid_last` `i` on((`a`.`ID_` = `i`.`TASK_ID_`)));

-- ----------------------------
-- View structure for v_tasklist_delay
-- ----------------------------
DROP VIEW IF EXISTS `v_tasklist_delay`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_tasklist_delay` AS select `p`.`task_id` AS `TASK_ID`,`p`.`proc_inst_id` AS `PROC_INST_ID`,`p`.`act_id` AS `ACT_ID`,`p`.`act_name` AS `ACT_NAME`,(case when (`p`.`assignee` is null) then `p`.`candidate` else `p`.`assignee` end) AS `ASSIGNEE`,`u`.`USER_NAME` AS `USER_NAME`,`p`.`delegation_id` AS `DELEGATION_ID`,`p`.`description` AS `DESCRIPTION`,`p`.`create_time` AS `CREATE_TIME`,`p`.`due_date` AS `DUE_DATE`,`p`.`candidate` AS `CANDIDATE`,`p`.`form_key` AS `FORM_KEY` from (`v_tasklist` `p` join `userinfo` `u`) where (((`p`.`assignee` = `u`.`USER_ID`) or (`p`.`candidate` = `u`.`USER_ID`)) and ((select count(1) from `workcalendar` where ((date_format(`workcalendar`.`workdate`,'%Y-%m-%d') >= substr(`p`.`create_time`,1,10)) and (date_format(now(),'%Y-%m-%d') >= date_format(`workcalendar`.`workdate`,'%Y-%m-%d')) and (`workcalendar`.`iswork` = '0'))) >= 2));

-- ----------------------------
-- Function structure for getParentList
-- ----------------------------
DROP FUNCTION IF EXISTS `getParentList`;
delimiter ;;
CREATE FUNCTION `getParentList`(rootId varchar(100))
 RETURNS varchar(1000) CHARSET utf8mb3
BEGIN 
DECLARE fid varchar(100) default ''; 
DECLARE fname varchar(100) default ''; 
DECLARE str varchar(1000) default ''; 
 
WHILE rootId is not null  do 
	SET fid =(SELECT presid FROM t_res_classify WHERE resid = rootId); 
 SET fname =(SELECT resname FROM t_res_classify WHERE resid = rootId); 
 if fname is not null THEN
    if str <>''  then 
		SET str = concat(fname, '-',str); 
		else
		SET str = concat(fname, '',str); 
end if;
END if;
	IF fid is not null THEN 
		SET rootId = fid; 
	ELSE 
		SET rootId = fid; 
	END IF; 
END WHILE; 
return str;
end
;;
delimiter ;

-- ----------------------------
-- Function structure for getParentList2
-- ----------------------------
DROP FUNCTION IF EXISTS `getParentList2`;
delimiter ;;
CREATE FUNCTION `getParentList2`(rootId varchar(100))
 RETURNS varchar(1000) CHARSET utf8mb3
BEGIN 
DECLARE fid varchar(100) default ''; 
DECLARE str varchar(1000) default rootId; 
 
WHILE rootId is not null  do 
	SET fid =(SELECT parent_id FROM deptinfo WHERE dept_id = rootId); 
	IF fid is not null THEN 
		SET str = concat(fid, ',', str); 
		SET rootId = fid; 
	ELSE 
		SET rootId = fid; 
	END IF; 
END WHILE; 
return str;
END
;;
delimiter ;

-- ----------------------------
-- Procedure structure for save_last_infoclass
-- ----------------------------
DROP PROCEDURE IF EXISTS `save_last_infoclass`;
delimiter ;;
CREATE PROCEDURE `save_last_infoclass`()
BEGIN
declare tinfoclassid varchar(100);
declare tablename varchar(100) default '';
declare dept_id varchar(100) default '';
declare up_cycle varchar(255);
declare isopen varchar(50);
declare data_type varchar(100);
declare done int default 0;
declare cur cursor for select id from t_infoclass where inprocess='2' and LATESTVERSION='1' and HITCH_STATUS='1' and XZQHCODE='120000' and infocode not like '%Q%';
declare continue handler for not found set done=1;

truncate table last_infoclass;
open cur;
	fetch next from cur into tinfoclassid;
repeat
if not done then
	select infocode,providebmcode,UPDATECYCLE,SHAREMODETYPE,ISOPENSOCIAL into tablename,dept_id,up_cycle,data_type,isopen from t_infoclass where id = tinfoclassid;
	insert into last_infoclass(dept_id,tablename,updatecycle,sharemodetype,isopensocial,shijian) value(dept_id,concat('t_',replace(tablename,'/','_')),up_cycle,data_type,isopen,now());
end if;
fetch next from cur into tinfoclassid;
until done end repeat;
close cur;
end
;;
delimiter ;

-- ----------------------------
-- Procedure structure for save_r_infoclass_lifeinfo
-- ----------------------------
DROP PROCEDURE IF EXISTS `save_r_infoclass_lifeinfo`;
delimiter ;;
CREATE PROCEDURE `save_r_infoclass_lifeinfo`()
BEGIN
truncate table r_infoclass_lifeinfo;
insert into r_infoclass_lifeinfo(taskstart,taskname,info_id,infocode,state,uuid,versionid) select taskstart,taskname,info_id,infocode,state,uuid,versionid from r_infoclass_lifeinfo_view;
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table gxwz_infoclass_catalog_rel
-- ----------------------------
DROP TRIGGER IF EXISTS `createtime_trri`;
delimiter ;;
CREATE TRIGGER `createtime_trri` BEFORE INSERT ON `gxwz_infoclass_catalog_rel` FOR EACH ROW set new.createtime=now()
;
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table gxwz_infoclass_catalog_rel
-- ----------------------------
DROP TRIGGER IF EXISTS `updatetime_trri`;
delimiter ;;
CREATE TRIGGER `updatetime_trri` BEFORE UPDATE ON `gxwz_infoclass_catalog_rel` FOR EACH ROW set new.updatetime=now()
;
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table t_indicators
-- ----------------------------
DROP TRIGGER IF EXISTS `tri_insertdate`;
delimiter ;;
CREATE TRIGGER `tri_insertdate` BEFORE INSERT ON `t_indicators` FOR EACH ROW set new.insertdate=DATE_FORMAT(NOW(),   '%Y-%m-%d %H:%i:%S')
;
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;