usoft-fin-grpc-parent/usoft-fin-grpc-dal/db/t_message.sql

-- 消息表 t_messages/
CREATE TABLE `t_messages`  (
  `id` int NOT NULL auto_increment COMMENT '主键',
  `ms_code` varchar(10) NOT NULL COMMENT '消息ID',
  `ms_content` varchar(200) NOT NULL DEFAULT '' COMMENT '内容',
  `ms_isread` smallint(6) NOT NULL DEFAULT '' COMMENT '已读或未读',
  `ms_receiverenuu` bigint(20) NOT NULL DEFAULT '' COMMENT '接收人企业UU',
  `ms_type` varchar(30) NOT NULL DEFAULT '' COMMENT '消息类型',
  `ms_remark` varchar(120) NOT NULL DEFAULT '' COMMENT '备注',
  `ms_create_time` varchar(40) NOT NULL DEFAULT  '' COMMENT '消息生成时间',
  create_time TIMESTAMP DEFAULT current_timestamp COMMENT '创建时间',
  update_time TIMESTAMP DEFAULT current_timestamp ON UPDATE current_timestamp COMMENT '修改时间',
  PRIMARY KEY (id) USING BTREE,
  INDEX `ms_isread_index`(`ms_isread`) USING BTREE,
  INDEX `ms_receiverenuu_index`(`ms_receiverenuu`) USING BTREE,
  unique index(ms_core) comment '编号,唯一索引'
) ENGINE = INNODB auto_increment = 1 DEFAULT charset = utf8mb4 COMMENT '消息表';