/*
Navicat Premium Data Transfer
Source Server : chenpeng
Source Server Type : MySQL
Source Server Version : 50723
Source Host : 192.168.12.103:3306
Source Schema : cmidata
Target Server Type : MySQL
Target Server Version : 50723
File Encoding : 65001
Date: 12/11/2018 20:12:16
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_dq_catalog
-- ----------------------------
DROP TABLE IF EXISTS `t_dq_catalog`;
CREATE TABLE `t_dq_catalog` (
`CATALOG_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`CATALOG_TYPE` int(11) NOT NULL COMMENT '层级，1代表数据源系统，2代表源数据分类',
`CATALOG_NAME_ZH` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`PARENT_CATALOG_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`CATALOG_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_dq_catalog
-- ----------------------------
INSERT INTO `t_dq_catalog` VALUES ('1', 1, '资源管理系统', '0');
INSERT INTO `t_dq_catalog` VALUES ('10', 1, '电子运维系统', '0');
INSERT INTO `t_dq_catalog` VALUES ('11', 2, '电子资源', '10');
INSERT INTO `t_dq_catalog` VALUES ('12', 2, '运维资源', '10');
INSERT INTO `t_dq_catalog` VALUES ('2', 2, '客户信息', '1');
INSERT INTO `t_dq_catalog` VALUES ('3', 2, '业务电脑', '1');
INSERT INTO `t_dq_catalog` VALUES ('4', 2, '网络资源', '1');
INSERT INTO `t_dq_catalog` VALUES ('5', 2, '空间资源', '1');
INSERT INTO `t_dq_catalog` VALUES ('6', 2, '电脑资源', '1');
INSERT INTO `t_dq_catalog` VALUES ('7', 1, '传输网管系统', '0');
INSERT INTO `t_dq_catalog` VALUES ('8', 2, '传输资源', '7');
INSERT INTO `t_dq_catalog` VALUES ('9', 2, '网管资源', '7');
SET FOREIGN_KEY_CHECKS = 1;