صفحهٔ اصلی گشت‌و‌گذار راهنما
ثبت نام ورود
lizhenghang
/
dev
1
0
انشعاب 0
پرونده‌ها مشکلات 0 درخواست واکشی 0 ویکی
شاخه: master
شاخه‌ها تگ‌ها
dev
/
2020
/
2020-010(OK)
/
2020-010-ljh-001.sql

2020-010-ljh-001.sql 21 KB
لینک دائمی تاريخچه خام

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 10.0.30.11_3306
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50727
    7. 

  7.  Source Host           : 10.0.30.11:3306
    8. 

  8.  Source Schema         : dcp
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50727
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 13/10/2020 17:23:36
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. USE DCP;
    20. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for base_portal_model_type
    22. 

  22. -- ----------------------------
    23. 

  23. 

  24. DROP TABLE IF EXISTS `base_portal_model_type`;
    25. 

  25. CREATE TABLE `base_portal_model_type`  (
    26. 

  26.   `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键ID',
    27. 

  27.   `model_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块名称',
    28. 

  28.   `language` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '语言类型',
    29. 

  29.   `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块类型',
    30. 

  30.   `model_get_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块查询url',
    31. 

  31.   `follow_time` datetime(0) NULL DEFAULT NULL COMMENT '浏览时间',
    32. 

  32.   `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
    33. 

  33.   `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    34. 

  34.   `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
    35. 

  35.   `update_date` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
    36. 

  36.   PRIMARY KEY (`id`) USING BTREE
    37. 

  37. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门户-关注记录' ROW_FORMAT = Dynamic;
    38. 

  38. 

  39. -- ----------------------------
    40. 

  40. -- Records of base_portal_model_type
    41. 

  41. -- ----------------------------
    42. 

  42. INSERT INTO `base_portal_model_type` VALUES ('88245820e13a11eab4d30040ff5ec9c', '会展', 'ZH', 'exhibition', 'http://itim-project-service/baseProjectViews/getViewByProjectId', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    43. 

  43. INSERT INTO `base_portal_model_type` VALUES ('88245820e13a11eab4da20040ff5ec9c', '会议', 'ZH', 'meeting', 'http://itim-project-service/activityInfos/getByIdAndLanguage', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
    44. 

  44. INSERT INTO `base_portal_model_type` VALUES ('88245820e13a11eab4da20040ff5fc9c', '项目', 'ZH', 'project', 'http://itim-project-service/baseProjectViews/getViewByProjectId', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
    45. 

  45. INSERT INTO `base_portal_model_type` VALUES ('88245820e13a11eab4da20040ff5fc9e', 'Project', 'EN', 'project', 'http://itim-project-service/baseProjectViews/getViewByProjectId', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
    46. 

  46. INSERT INTO `base_portal_model_type` VALUES ('88245820e13a11eab4da20040ff5fc9z', 'Meeting', 'EN', 'meeting', 'http://itim-project-service/activityInfos/getByIdAndLanguage', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
    47. 

  47. INSERT INTO `base_portal_model_type` VALUES ('88245820e13a11eab4da30040ff5ec9c', '活动', 'ZH', 'activity', 'http://itim-project-service/activityInfos/getByIdAndLanguageByFollow', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
    48. 

  48. INSERT INTO `base_portal_model_type` VALUES ('88245820e13a11eab4da30040ff5fc9z', 'Activity', 'EN', 'activity', 'http://itim-project-service/activityInfos/getByIdAndLanguageByFollow', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
    49. 

  49. INSERT INTO `base_portal_model_type` VALUES ('88245820e13a11eab4da31040ff5fc9z', 'Exhibition', 'EN', 'exhibition', 'http://itim-project-service/baseProjectViews/getViewByProjectId', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    50. 

  50. INSERT INTO `base_portal_model_type` VALUES ('913d7028e29711eab4da20040ff5fc91', '国别', 'ZH', 'country', 'http://itim-project-service/baseCountryViews/getViewByEntityIdFollow', '2020-08-20 11:46:58', NULL, '2020-08-20 11:45:19', NULL, '2020-08-18 04:45:19');
    51. 

  51. INSERT INTO `base_portal_model_type` VALUES ('913d7028e29711eab4da20040ff5fc92', 'Country', 'EN', 'country', 'http://itim-project-service/baseCountryViews/getViewByEntityIdFollow', '2020-08-20 11:46:58', NULL, '2020-08-20 11:45:19', NULL, '2020-08-18 04:45:19');
    52. 

  52. INSERT INTO `base_portal_model_type` VALUES ('913d7028e29711eab4da20040ff5fc9c', '企业', 'ZH', 'enterprise', 'http://itim-project-service/baseUnitViews/getViewByEntityId', '2020-08-20 11:46:58', NULL, '2020-08-20 11:45:19', NULL, '2020-08-18 02:45:19');
    53. 

  53. INSERT INTO `base_portal_model_type` VALUES ('913d7028e29711eab4Ea20040ff5fc9c', 'Enterprise', 'EN', 'enterprise', 'http://itim-project-service/baseUnitViews/getViewByEntityId', '2020-08-20 11:46:58', NULL, '2020-08-20 11:45:19', NULL, '2020-08-18 02:45:19');
    54. 

  54. 

  55. -- ----------------------------
    56. 

  56. -- Table structure for base_portal_model_type_field
    57. 

  57. -- ----------------------------
    58. 

  58. DROP TABLE IF EXISTS `base_portal_model_type_field`;
    59. 

  59. CREATE TABLE `base_portal_model_type_field`  (
    60. 

  60.   `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键ID',
    61. 

  61.   `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块名称',
    62. 

  62.   `model_field_k` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原数据字段名',
    63. 

  63.   `model_field_v` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '转换数据字段名',
    64. 

  64.   `model_field_k_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'k字段的数据格式化',
    65. 

  65.   `model_field_k_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'k字段的数据类型',
    66. 

  66.   `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '语言版本',
    67. 

  67.   `order_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块顺序处理',
    68. 

  68.   `status` datetime(0) NULL DEFAULT NULL COMMENT '浏览时间',
    69. 

  69.   `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
    70. 

  70.   `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    71. 

  71.   `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
    72. 

  72.   `update_date` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
    73. 

  73.   PRIMARY KEY (`id`) USING BTREE
    74. 

  74. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门户-关注记录模块字段对应' ROW_FORMAT = Dynamic;
    75. 

  75. 

  76. -- ----------------------------
    77. 

  77. -- Records of base_portal_model_type_field
    78. 

  78. -- ----------------------------
    79. 

  79. 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');
    80. 

  80. 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');
    81. 

  81. 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');
    82. 

  82. 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');
    83. 

  83. 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');
    84. 

  84. 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');
    85. 

  85. 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');
    86. 

  86. 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');
    87. 

  87. 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');
    88. 

  88. 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');
    89. 

  89. 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');
    90. 

  90. 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');
    91. 

  91. 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');
    92. 

  92. 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');
    93. 

  93. 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');
    94. 

  94. 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');
    95. 

  95. 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');
    96. 

  96. 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');
    97. 

  97. 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');
    98. 

  98. 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');
    99. 

  99. 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');
    100. 

  100. 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');
    101. 

  101. 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');
    102. 

  102. 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');
    103. 

  103. 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');
    104. 

  104. 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');
    105. 

  105. 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');
    106. 

  106. 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');
    107. 

  107. 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');
    108. 

  108. 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');
    109. 

  109. 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');
    110. 

  110. 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');
    111. 

  111. 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');
    112. 

  112. 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');
    113. 

  113. 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');
    114. 

  114. 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');
    115. 

  115. 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');
    116. 

  116. 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');
    117. 

  117. 

  118. -- ----------------------------
    119. 

  119. -- Table structure for base_portal_model_type_query_field
    120. 

  120. -- ----------------------------
    121. 

  121. DROP TABLE IF EXISTS `base_portal_model_type_query_field`;
    122. 

  122. CREATE TABLE `base_portal_model_type_query_field`  (
    123. 

  123.   `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键ID',
    124. 

  124.   `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块名称',
    125. 

  125.   `model_field_k` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原数据字段名',
    126. 

  126.   `model_field_v` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '转换数据字段名',
    127. 

  127.   `model_field_k_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'k字段的数据格式化',
    128. 

  128.   `model_field_k_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'k字段的数据类型',
    129. 

  129.   `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '语言版本',
    130. 

  130.   `order_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块顺序处理',
    131. 

  131.   `status` datetime(0) NULL DEFAULT NULL COMMENT '浏览时间',
    132. 

  132.   `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
    133. 

  133.   `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    134. 

  134.   `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
    135. 

  135.   `update_date` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
    136. 

  136.   PRIMARY KEY (`id`) USING BTREE
    137. 

  137. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门户-关注记录模块字段对应' ROW_FORMAT = Dynamic;
    138. 

  138. 

  139. -- ----------------------------
    140. 

  140. -- Records of base_portal_model_type_query_field
    141. 

  141. -- ----------------------------
    142. 

  142. INSERT INTO `base_portal_model_type_query_field` VALUES ('78245820e13a11eab4d30040ff5e291', 'activity', 'ids', 'ids', NULL, 'string', 'ZH', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    143. 

  143. INSERT INTO `base_portal_model_type_query_field` VALUES ('78245820e13a11eab4d30040ff5e292', 'activity', 'ids', 'ids', NULL, 'string', 'EN', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    144. 

  144. INSERT INTO `base_portal_model_type_query_field` VALUES ('78245820e13a11eab4d30040ff5ec91', 'activity', 'language', 'language', NULL, 'string', 'ZH', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    145. 

  145. INSERT INTO `base_portal_model_type_query_field` VALUES ('78245820e13a11eab4d30040ff5ec95', 'activity', 'language', 'language', NULL, 'string', 'EN', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    146. 

  146. INSERT INTO `base_portal_model_type_query_field` VALUES ('88245820e13a11eab4d30040ff5e181', 'enterprise', 'ids', 'ids', NULL, 'string', 'EN', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    147. 

  147. INSERT INTO `base_portal_model_type_query_field` VALUES ('88245820e13a11eab4d30040ff5e18c', 'enterprise', 'ids', 'ids', NULL, 'string', 'ZH', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    148. 

  148. INSERT INTO `base_portal_model_type_query_field` VALUES ('88245820e13a11eab4d30040ff5e291', 'country', 'ids', 'ids', NULL, 'string', 'ZH', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    149. 

  149. INSERT INTO `base_portal_model_type_query_field` VALUES ('88245820e13a11eab4d30040ff5e292', 'country', 'ids', 'ids', NULL, 'string', 'EN', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    150. 

  150. INSERT INTO `base_portal_model_type_query_field` VALUES ('88245820e13a11eab4d30040ff5e393', 'project', 'ids', 'ids', NULL, 'string', 'EN', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    151. 

  151. INSERT INTO `base_portal_model_type_query_field` VALUES ('88245820e13a11eab4d30040ff5e39c', 'project', 'ids', 'ids', NULL, 'string', 'ZH', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    152. 

  152. INSERT INTO `base_portal_model_type_query_field` VALUES ('88245820e13a11eab4d30040ff5ec84', 'enterprise', 'language', 'language', NULL, 'string', 'EN', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    153. 

  153. INSERT INTO `base_portal_model_type_query_field` VALUES ('88245820e13a11eab4d30040ff5ec8c', 'enterprise', 'language', 'language', NULL, 'string', 'ZH', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    154. 

  154. INSERT INTO `base_portal_model_type_query_field` VALUES ('88245820e13a11eab4d30040ff5ec91', 'country', 'language', 'language', NULL, 'string', 'ZH', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    155. 

  155. INSERT INTO `base_portal_model_type_query_field` VALUES ('88245820e13a11eab4d30040ff5ec95', 'country', 'language', 'language', NULL, 'string', 'EN', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    156. 

  156. INSERT INTO `base_portal_model_type_query_field` VALUES ('88245820e13a11eab4d30040ff5ec96', 'project', 'language', 'language', NULL, 'string', 'EN', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    157. 

  157. INSERT INTO `base_portal_model_type_query_field` VALUES ('88245820e13a11eab4d30040ff5ec9c', 'project', 'language', 'language', NULL, 'string', 'ZH', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    158. 

  158. 

  159. SET FOREIGN_KEY_CHECKS = 1;
    160.