结构

源码

CREATE TABLE `business_comment_user_info` (
  `comment_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `volume_name` varchar(64) DEFAULT NULL,
  `file_name` varchar(64) DEFAULT NULL,
  `tenant_id` varchar(64) DEFAULT NULL,
  `business_id` varchar(64) DEFAULT NULL,
  `content` varchar(500) DEFAULT NULL,
  `reply_id` bigint(20) DEFAULT NULL,
  `root_reply_id` bigint(20) DEFAULT NULL,
  `agree_count` bigint(20) DEFAULT NULL,
  `comment_count` bigint(20) DEFAULT NULL,
  `user_id` varchar(64) DEFAULT NULL,
  `user_name` varchar(64) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  PRIMARY KEY (`comment_id`),
  KEY `business_index` (`volume_name`,`file_name`,`tenant_id`,`business_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户评论表';
作者:Eric  创建时间:2024-06-28 10:12
最后编辑:柳杨  更新时间:2025-04-24 13:55