/*
 Navicat Premium Data Transfer

 Source Server         : 10.0.1.159_3306
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : 10.0.1.159:3306
 Source Schema         : dcp

 Target Server Type    : MySQL
 Target Server Version : 50722
 File Encoding         : 65001

 Date: 13/10/2020 20:21:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
use dcp;

-- ----------------------------
-- Table structure for base_portal_model_type_field
-- ----------------------------
DROP TABLE IF EXISTS `base_portal_model_type_field`;
CREATE TABLE `base_portal_model_type_field`  (
  `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键ID',
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块名称',
  `model_field_k` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原数据字段名',
  `model_field_v` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '转换数据字段名',
  `model_field_k_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'k字段的数据格式化',
  `model_field_k_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'k字段的数据类型',
  `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '语言版本',
  `order_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块顺序处理',
  `status` datetime(0) NULL DEFAULT NULL COMMENT '浏览时间',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门户-关注记录模块字段对应' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of base_portal_model_type_field
-- ----------------------------
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4d30040ff5e18c', 'enterprise', 'baseEntityId', 'id', NULL, 'string', 'EN', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4d30040ff5e19z', 'activity', 'baseActivityEntityId', 'id', NULL, 'string', 'EN', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4d30040ff5e291', 'country', 'baseEntityId', 'id', NULL, 'string', 'EN', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4d30040ff5e39c', 'project', 'projectId', 'id', NULL, 'string', 'EN', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4d30040ff5ec8c', 'enterprise', 'baseEntityId', 'id', NULL, 'string', 'ZH', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4d30040ff5ec90', 'activity', 'baseActivityEntityId', 'id', NULL, 'string', 'ZH', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4d30040ff5ec91', 'country', 'baseEntityId', 'id', NULL, 'string', 'ZH', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4d30040ff5ec9c', 'project', 'projectId', 'id', NULL, 'string', 'ZH', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da10040ff51597', 'activity', 'activityLogo', 'bannerImg', '0', 'string', 'EN', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da11040ff5fc97', 'activity', 'activityLogo', 'bannerImg', '0', 'string', 'ZH', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5109c', 'project', 'unitCountry', 'followUnitCountry', NULL, 'string', 'EN', '3', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5119e', 'project', 'setUpDate', 'followSetUpDate', 'yyyy-MM-dd HH:mm:ss', 'date', 'EN', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5129z', 'project', 'setDownDate', 'Deadline', 'yyyy-MM-dd HH:mm:ss', 'date', 'EN', '5', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff54c8c', 'enterprise', 'unitName', 'followName', NULL, 'string', 'EN', '2', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff55192', 'activity', 'activityName', 'followName', NULL, 'string', 'EN', '2', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff55c92', 'country', 'zhName', 'followName', NULL, 'string', 'EN', '2', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5e69c', 'project', 'projectName', 'followName', NULL, 'string', 'EN', '2', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5ec8c', 'enterprise', 'unitName', 'followName', NULL, 'string', 'ZH', '2', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5ec92', 'country', 'zhName', 'followName', NULL, 'string', 'ZH', '2', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5ec9c', 'project', 'projectName', 'followName', NULL, 'string', 'ZH', '2', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5ed92', 'activity', 'activityName', 'followName', NULL, 'string', 'ZH', '2', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5f88c', 'enterprise', 'unitCountry', 'followUnitCountry', NULL, 'string', 'EN', '3', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5f993', 'country', 'are', 'followUnitCountry', NULL, 'string', 'EN', '3', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5fc8c', 'enterprise', 'unitCountry', 'followUnitCountry', NULL, 'string', 'ZH', '3', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5fc93', 'country', 'are', 'followUnitCountry', NULL, 'string', 'ZH', '3', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5fc9c', 'project', 'unitCountry', 'followUnitCountry', NULL, 'string', 'ZH', '3', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5fc9e', 'project', 'setUpDate', 'followSetUpDate', 'yyyy-MM-dd HH:mm:ss', 'date', 'ZH', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5fc9z', 'project', 'setDownDate', 'Deadline', 'yyyy-MM-dd HH:mm:ss', 'date', 'ZH', '5', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5fm93', 'activity', 'activityArea', 'followUnitCountry', NULL, 'string', 'ZH', '3', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5fy93', 'activity', 'activityArea', 'followUnitCountry', NULL, 'string', 'EN', '3', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da30040ff5138c', 'enterprise', 'industry', 'unitLabel', NULL, 'string', 'EN', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da30040ff5149c', 'project', 'projectLabel', 'unitLabel', NULL, 'string', 'EN', '6', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da30040ff51597', 'country', 'note', 'bannerImg', '0', 'string', 'EN', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da30040ff5169z', 'project', 'bannerList', 'bannerImg', '0', 'string', 'EN', '7', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da30040ff5ec8c', 'enterprise', 'industry', 'unitLabel', NULL, 'string', 'ZH', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da30040ff5ec9c', 'project', 'projectLabel', 'unitLabel', NULL, 'string', 'ZH', '6', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da30040ff5fc97', 'country', 'note', 'bannerImg', '0', 'string', 'ZH', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da30040ff5fc9z', 'project', 'bannerList', 'bannerImg', '0', 'string', 'ZH', '7', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eae4da30040ff51597', 'enterprise', 'photo', 'bannerImg', '0', 'string', 'EN', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eae4da30040ff5fc97', 'enterprise', 'photo', 'bannerImg', '0', 'string', 'ZH', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');

SET FOREIGN_KEY_CHECKS = 1;