hadoop_dw/hadoop_dw.sql

/*
Navicat MySQL Data Transfer

Source Server         : local
Source Server Version : 50613
Source Host           : localhost:3306
Source Database       : hadoop_dw

Target Server Type    : MYSQL
Target Server Version : 50613
File Encoding         : 65001

Date: 2019-04-22 02:21:39
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for hibernate_sequences
-- ----------------------------
DROP TABLE IF EXISTS `hibernate_sequences`;
CREATE TABLE `hibernate_sequences` (
  `sequence_name` varchar(255) NOT NULL,
  `next_val` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`sequence_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hibernate_sequences
-- ----------------------------

-- ----------------------------
-- Table structure for omc_project
-- ----------------------------
DROP TABLE IF EXISTS `omc_project`;
CREATE TABLE `omc_project` (
  `id` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_user` varchar(255) DEFAULT NULL,
  `demander` varchar(255) DEFAULT NULL,
  `demander_user` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `developer` varchar(255) DEFAULT NULL,
  `hadoop_user` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `owner_group` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_user` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of omc_project
-- ----------------------------

-- ----------------------------
-- Table structure for omc_project_user_relation
-- ----------------------------
DROP TABLE IF EXISTS `omc_project_user_relation`;
CREATE TABLE `omc_project_user_relation` (
  `id` varchar(255) NOT NULL,
  `account` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_user` varchar(255) DEFAULT NULL,
  `project` varchar(255) DEFAULT NULL,
  `project_role` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_user` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of omc_project_user_relation
-- ----------------------------

-- ----------------------------
-- Table structure for pprt_core_dict
-- ----------------------------
DROP TABLE IF EXISTS `pprt_core_dict`;
CREATE TABLE `pprt_core_dict` (
  `class_code` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`class_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pprt_core_dict
-- ----------------------------
INSERT INTO `pprt_core_dict` VALUES ('data.dbtype', '数据库类型');

-- ----------------------------
-- Table structure for pprt_core_dict_code_map
-- ----------------------------
DROP TABLE IF EXISTS `pprt_core_dict_code_map`;
CREATE TABLE `pprt_core_dict_code_map` (
  `cid` int(11) NOT NULL,
  `class_code` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `ord_num` varchar(255) DEFAULT NULL,
  `quick_code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cid`),
  KEY `FK543864F0453A2E93` (`class_code`),
  CONSTRAINT `FK543864F0453A2E93` FOREIGN KEY (`class_code`) REFERENCES `pprt_core_dict` (`class_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pprt_core_dict_code_map
-- ----------------------------
INSERT INTO `pprt_core_dict_code_map` VALUES ('1', 'data.dbtype', 'HIVE', 'hive数据库', '1', 'HIVE');
INSERT INTO `pprt_core_dict_code_map` VALUES ('2', 'data.dbtype', 'MySQL', 'mysql数据库', '2', 'MySQL');
INSERT INTO `pprt_core_dict_code_map` VALUES ('3', 'data.dbtype', 'MsSQL', 'mysql数据库', '3', 'MsSQL');

-- ----------------------------
-- Table structure for pprt_dg_meta_core
-- ----------------------------
DROP TABLE IF EXISTS `pprt_dg_meta_core`;
CREATE TABLE `pprt_dg_meta_core` (
  `id` varchar(255) NOT NULL,
  `BIZ_DOMAIN` varchar(255) DEFAULT NULL,
  `BIZ_NO` varchar(255) DEFAULT NULL,
  `CH_NAME` varchar(255) DEFAULT NULL,
  `cmt` varchar(255) DEFAULT NULL,
  `CRT_DATE` datetime DEFAULT NULL,
  `CRT_USER` varchar(255) DEFAULT NULL,
  `cycle` varchar(255) DEFAULT NULL,
  `DATA_TYPE` varchar(255) DEFAULT NULL,
  `DEFAULT_VIEW` varchar(255) DEFAULT NULL,
  `entity` varchar(255) DEFAULT NULL,
  `FILE_HEADER` varchar(255) DEFAULT NULL,
  `FILE_NAME` varchar(255) DEFAULT NULL,
  `FMT_RULE` varchar(255) DEFAULT NULL,
  `LAST_UPDATE` datetime DEFAULT NULL,
  `LAYER` varchar(255) DEFAULT NULL,
  `length` int(11) DEFAULT NULL,
  `lvel` varchar(255) DEFAULT NULL,
  `META_MDL` varchar(255) DEFAULT NULL,
  `MGR_TYPE` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `namespace` varchar(255) DEFAULT NULL,
  `PREC` int(11) DEFAULT NULL,
  `PRT_ID` varchar(255) DEFAULT NULL,
  `REF_OBJECT` varchar(255) DEFAULT NULL,
  `REMARKS` varchar(255) DEFAULT NULL,
  `TENANTID` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `USE_TABLE` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pprt_dg_meta_core
-- ----------------------------
INSERT INTO `pprt_dg_meta_core` VALUES ('4028fc8b6a40d38f016a40d47b3b0000', 'HOST', null, 'test', 'test', '2019-04-22 00:57:08', 'admin', null, null, null, null, null, null, null, '2019-04-22 00:57:08', null, null, null, 'core.BasePackage', null, 'test', 'HOST', null, 'HOST', null, null, null, 'pkg', null);
INSERT INTO `pprt_dg_meta_core` VALUES ('4028fc8b6a40d38f016a40d4afd20001', 'PDM', null, 'test1', 'test1', '2019-04-22 00:57:21', 'admin', null, null, null, null, null, null, null, '2019-04-22 00:57:21', null, null, null, 'core.BasePackage', null, 'test1', 'PDM', null, 'PDM', null, null, null, 'pkg', null);
INSERT INTO `pprt_dg_meta_core` VALUES ('4028fc8b6a40d38f016a40d7d1060002', null, null, '', '', null, null, null, null, null, null, null, null, null, null, null, null, null, 'model.PhysicalModel', null, 'events', null, null, '4028fc8b6a40d38f016a40d4afd20001', null, null, null, null, null);
INSERT INTO `pprt_dg_meta_core` VALUES ('4028fc8b6a40d38f016a40d7d1070003', null, null, 'bar', '', null, null, null, null, null, '{\"nullable\":false, \"pk\":true}', null, null, null, null, null, '20', null, 'model.PhysicalModelClm', null, 'bar', null, '0', '4028fc8b6a40d38f016a40d7d1060002', null, '字符串', null, 'VARCHAR', null);
INSERT INTO `pprt_dg_meta_core` VALUES ('4028fc8b6a40d38f016a40d7d1070004', null, null, 'foo1', '', null, null, null, null, null, '{\"nullable\":true, \"pk\":false}', null, null, null, null, null, '10', null, 'model.PhysicalModelClm', null, 'foo1', null, '2', '4028fc8b6a40d38f016a40d7d1060002', null, '小数', null, 'DECIMAL', null);
INSERT INTO `pprt_dg_meta_core` VALUES ('4028fc8b6a40d38f016a40d7d1070005', null, null, 'foo2', '', null, null, null, null, null, '{\"nullable\":true, \"pk\":false}', null, null, null, null, null, '10', null, 'model.PhysicalModelClm', null, 'foo2', null, '0', '4028fc8b6a40d38f016a40d7d1060002', null, '整型', null, 'INT', null);
INSERT INTO `pprt_dg_meta_core` VALUES ('4028fc8b6a40d38f016a40d91ade0006', 'ITF', null, 'test2', 'test2', '2019-04-22 01:02:11', 'admin', null, null, null, null, null, null, null, '2019-04-22 01:02:11', null, null, null, 'core.BasePackage', null, 'test2', 'ITF', null, 'ITF', null, null, null, 'pkg', null);
INSERT INTO `pprt_dg_meta_core` VALUES ('4028fc8b6a40d38f016a40d9f0170007', 'core.BasePackage', null, 'test3', 'test3', '2019-04-22 01:03:05', 'admin', null, null, null, null, null, null, null, '2019-04-22 01:03:05', null, null, null, 'core.BasePackage', null, 'test3', '4028fc8b6a40d38f016a40d47b3b0000', null, '4028fc8b6a40d38f016a40d47b3b0000', null, null, null, 'pkg', null);
INSERT INTO `pprt_dg_meta_core` VALUES ('4028fc8b6a40d38f016a40e0bdf80008', 'DB', null, null, '', '2019-04-22 01:10:31', 'admin', null, null, null, '{\"DS_TYPE_HIVE\":\"HIVE\",\"host\":\"coop.360lj.com\",\"port\":\"10008\",\"user\":\"zhangsan\",\"pwd\":\"123456789\",\"serverName\":\"test\",\"keytabPath\":\"\",\"krb5ConfigPath\":\"\",\"hadoopHomeDir\":\"\",\"principal\":\"\",\"crtUser\":\"\"}', '', '', null, '2019-04-22 01:10:31', null, null, null, 'phy.DataSource', null, 'ee', null, null, 'DB', null, null, null, 'ds', null);
INSERT INTO `pprt_dg_meta_core` VALUES ('4028fc8b6a40d38f016a40e727230009', null, null, '邀请', '', null, null, null, null, null, null, null, null, null, null, null, null, null, 'model.PhysicalModel', null, 'invites', null, null, '4028fc8b6a40d38f016a40d4afd20001', null, null, null, null, null);
INSERT INTO `pprt_dg_meta_core` VALUES ('4028fc8b6a40d38f016a40e72723000a', null, null, 'bar', '', null, null, null, null, null, '{\"nullable\":false, \"pk\":false}', null, null, null, null, null, '20', null, 'model.PhysicalModelClm', null, 'bar', null, '0', '4028fc8b6a40d38f016a40e727230009', null, 'invites', null, 'VARCHAR', null);
INSERT INTO `pprt_dg_meta_core` VALUES ('4028fc8b6a40d38f016a40e81035000b', null, null, 'foo', '', null, null, null, null, null, '{\"nullable\":false, \"pk\":true}', null, null, null, null, null, '20', null, 'model.PhysicalModelClm', null, 'foo', null, '0', '4028fc8b6a40d38f016a40e727230009', null, '', null, 'INT', null);

-- ----------------------------
-- Table structure for pprt_dg_meta_exprule
-- ----------------------------
DROP TABLE IF EXISTS `pprt_dg_meta_exprule`;
CREATE TABLE `pprt_dg_meta_exprule` (
  `code` varchar(255) NOT NULL,
  `meta_model` varchar(255) DEFAULT NULL,
  `meta_sheet_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pprt_dg_meta_exprule
-- ----------------------------

-- ----------------------------
-- Table structure for pprt_dg_meta_meta
-- ----------------------------
DROP TABLE IF EXISTS `pprt_dg_meta_meta`;
CREATE TABLE `pprt_dg_meta_meta` (
  `name` varchar(255) NOT NULL,
  `CH_NAME` varchar(255) DEFAULT NULL,
  `clz` varchar(255) DEFAULT NULL,
  `cmt` varchar(255) DEFAULT NULL,
  `CRT_DATE` datetime DEFAULT NULL,
  `def` varchar(255) DEFAULT NULL,
  `SUB_NODE` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pprt_dg_meta_meta
-- ----------------------------

-- ----------------------------
-- Table structure for pprt_dg_meta_rel
-- ----------------------------
DROP TABLE IF EXISTS `pprt_dg_meta_rel`;
CREATE TABLE `pprt_dg_meta_rel` (
  `rid` varchar(255) NOT NULL,
  `CAL_TYPE` varchar(255) DEFAULT NULL,
  `cmt` varchar(255) DEFAULT NULL,
  `CRT_DATE` datetime DEFAULT NULL,
  `CRT_USER` varchar(255) DEFAULT NULL,
  `dest` varchar(255) DEFAULT NULL,
  `DEST_NAME` varchar(255) DEFAULT NULL,
  `REF_JOB` varchar(255) DEFAULT NULL,
  `REL_CND` varchar(255) DEFAULT NULL,
  `REL_DTL` varchar(255) DEFAULT NULL,
  `REL_TYPE` varchar(255) DEFAULT NULL,
  `rgroup` varchar(255) DEFAULT NULL,
  `src` varchar(255) DEFAULT NULL,
  `SRC_NAME` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pprt_dg_meta_rel
-- ----------------------------
INSERT INTO `pprt_dg_meta_rel` VALUES ('4028fc8b6a40d38f016a40eaad7e000d', '', 'test', null, null, 'invites', 'bar', null, null, 'ces', '', null, '4028fc8b6a40d38f016a40d7d1060002', 'bar');
INSERT INTO `pprt_dg_meta_rel` VALUES ('4028fc8b6a40d38f016a40ebc829000f', '\"null\"', 'bar', null, null, 'events', 'bar', null, null, '\"null\"', '\"null\"', null, '4028fc8b6a40d38f016a40e727230009', 'bar');

-- ----------------------------
-- Table structure for pprt_dg_para
-- ----------------------------
DROP TABLE IF EXISTS `pprt_dg_para`;
CREATE TABLE `pprt_dg_para` (
  `name` varchar(255) NOT NULL,
  `cmt` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pprt_dg_para
-- ----------------------------

-- ----------------------------
-- Table structure for v_hadoopgroup_project_relation
-- ----------------------------
DROP TABLE IF EXISTS `v_hadoopgroup_project_relation`;
CREATE TABLE `v_hadoopgroup_project_relation` (
  `projectId` varchar(255) NOT NULL,
  `userGroup` varchar(255) DEFAULT NULL,
  `userName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`projectId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of v_hadoopgroup_project_relation
-- ----------------------------