结构
源码
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
最后编辑:柳杨 更新时间:2025-04-24 13:55
