/*
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;