/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : localhost:3307
 Source Schema         : message

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

 Date: 25/08/2021 23:17:40
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for mc_comment
-- ----------------------------
DROP TABLE IF EXISTS `mc_comment`;
CREATE TABLE `mc_comment`  (
  `ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CONTENT` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `ATTACHMENT` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CREATE_TIME` datetime(0) NULL DEFAULT NULL,
  `SENDER` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SENDER_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `MESSAGE_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `COMMENT_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `TO_USER` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `TO_USER_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `MODULE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DOMAIN_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `TO_CONTENT` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `IS_READ` bit(1) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  INDEX `index_ID`(`ID`) USING BTREE,
  INDEX `index_MESSAGE_ID`(`MESSAGE_ID`) USING BTREE,
  INDEX `index_TO_USER_ID`(`TO_USER_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mc_message
-- ----------------------------
DROP TABLE IF EXISTS `mc_message`;
CREATE TABLE `mc_message`  (
  `ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TITLE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CONTENT` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `ATTACHMENT` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CREATE_TIME` datetime(0) NULL DEFAULT NULL,
  `SENDER` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SENDER_DEPT` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SENDER_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SENDER_DEPT_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SCOPE` int(11) NULL DEFAULT NULL,
  `RECEIVER_ID` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `RECEIVER_DEPT_ID` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `COMMENT_COUNT` int(11) NULL DEFAULT NULL,
  `TYPE` int(11) NULL DEFAULT NULL,
  `MODULE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DOMAIN_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `IS_COMMENT` bit(1) NULL DEFAULT NULL,
  `IS_STICKY` bit(1) NULL DEFAULT NULL,
  `RECEIVER_INFO` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  INDEX `index_ID`(`ID`) USING BTREE,
  INDEX `index_SENDER_ID`(`SENDER_ID`) USING BTREE,
  INDEX `index_MODULE`(`MODULE`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mc_notice
-- ----------------------------
DROP TABLE IF EXISTS `mc_notice`;
CREATE TABLE `mc_notice`  (
  `ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `IS_READ` bit(1) NULL DEFAULT NULL,
  `SUMMARY` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CONTENT` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `TO_USER_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATE_TIME` datetime(0) NULL DEFAULT NULL,
  `LINK_PARAMS` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `MODULE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DOMAIN_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SUBJECT_TYPE` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  INDEX `index_ID`(`ID`) USING BTREE,
  INDEX `index_TO_USER_ID`(`TO_USER_ID`) USING BTREE,
  INDEX `index_MODULE`(`MODULE`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mc_notification
-- ----------------------------
DROP TABLE IF EXISTS `mc_notification`;
CREATE TABLE `mc_notification`  (
  `ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `SENDER` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SENDER_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `RECEIVER_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `MESSAGE_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `MESSAGE_TYPE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `MODULE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `LINK_PARAMS` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `DOMAIN_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SUMMARY` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CREATE_TIME` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  INDEX `index_ID`(`ID`) USING BTREE,
  INDEX `index_MESSAGE_ID`(`MESSAGE_ID`) USING BTREE,
  INDEX `index_SENDER_ID`(`SENDER_ID`) USING BTREE,
  INDEX `index_RECEIVER_ID`(`RECEIVER_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;
