ChronicDisease_SpringBoot/docs/DB/t_news_info.txt

CREATE TABLE `t_news_info` (
  `id` bigint(20) NOT NULL COMMENT '主键ID',
  `version` int(11) DEFAULT '0' COMMENT '乐观锁版本',
  `create_user` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_user` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `title` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '资讯标题',
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Markdown内容',
  `summary` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '资讯概要',
  `author_id` bigint(20) NOT NULL COMMENT '医生ID',
  `publish_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '发布时间',
  PRIMARY KEY (`id`),
  KEY `idx_author_id` (`author_id`),
  KEY `idx_title` (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='资讯信息表';