llooper-dev commented on issue #10384:
URL:
https://github.com/apache/shardingsphere/issues/10384#issuecomment-843844040
CREATE TABLE `t_comment_user` (
`id` bigint NOT NULL COMMENT '主键id',
`uid` bigint DEFAULT NULL COMMENT '当前操作用户id',
`ugc_id` bigint DEFAULT NULL COMMENT '新鲜事id',
`ugc_uid` bigint DEFAULT NULL COMMENT '发布新鲜事的作者id （散表字段）',
`comment_type` int DEFAULT NULL COMMENT '评论类型: image,text',
`comment_text` varchar(1000) CHARACTER SET utf8mb4 COLLATE
utf8mb4_general_ci DEFAULT NULL COMMENT '评论的内容',
`comment_status` int DEFAULT NULL COMMENT '评论状态，0：未审核，1：审核通过 2：未通过',
`offreason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
DEFAULT NULL COMMENT '下架原因',
`root_id` bigint DEFAULT NULL COMMENT '评论的根ID，保存第一级的评论ID',
`parent_id` bigint DEFAULT '0' COMMENT '评论父id',
`icon_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
DEFAULT NULL COMMENT '头像icon(备用)',
`nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
DEFAULT NULL COMMENT '用户昵称（备用）',
`is_author` int DEFAULT '0' COMMENT '是否为新鲜事作者 0：否，1：是',
`manage_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT
'平台用户身份 如：组长，运营，管理员',
`like_count` int DEFAULT '0' COMMENT '点赞数量,用于计算热度值',
`comment_count` int DEFAULT '0' COMMENT '评论数量,用于计算热度值',
`hot_score` double DEFAULT '0' COMMENT '热度分值',
`is_delete` tinyint DEFAULT NULL COMMENT '是否逻辑删除 0：否，1：是',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
`update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `uqidx_old_comment_id` (`old_comment_id`) USING BTREE,
KEY `idx_root_id` (`root_id`) USING BTREE,
KEY `idx_ugc_uid` (`ugc_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
ROW_FORMAT=COMPACT COMMENT='评论用户表，根据ugc_uid字段散库散表';
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
