48 lines
2.3 KiB
Java
48 lines
2.3 KiB
Java
CREATE TABLE `user_book_list`
|
||
(
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`user_id` bigint(20) NOT NULL COMMENT '创建用户ID',
|
||
`list_name` varchar(50) NOT NULL COMMENT '书单名',
|
||
`description` varchar(300) DEFAULT NULL COMMENT '书单简介',
|
||
`book_count` int(11) NOT NULL DEFAULT 0 COMMENT '书籍数量(冗余)',
|
||
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：1正常 0已删除',
|
||
`create_time` datetime NOT NULL COMMENT '创建时间',
|
||
`update_time` datetime NOT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_user_id` (`user_id`)
|
||
) ENGINE = InnoDB
|
||
DEFAULT CHARSET = utf8mb4 COMMENT ='用户书单表';
|
||
|
||
CREATE TABLE `user_book_list_item`
|
||
(
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`list_id` bigint(20) NOT NULL COMMENT '书单ID',
|
||
`book_id` bigint(20) NOT NULL COMMENT '书籍ID',
|
||
`remark` varchar(100) DEFAULT NULL COMMENT '推荐语',
|
||
`create_time` datetime NOT NULL COMMENT '加入时间',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `uk_list_book` (`list_id`, `book_id`)
|
||
) ENGINE = InnoDB
|
||
DEFAULT CHARSET = utf8mb4 COMMENT ='书单条目表';
|
||
|
||
|
||
CREATE TABLE `book_paragraph_comment`
|
||
(
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`book_id` bigint(20) NOT NULL COMMENT '书籍ID',
|
||
`book_index_id` bigint(20) NOT NULL COMMENT '章节ID',
|
||
`paragraph_idx` int(11) NOT NULL COMMENT '段落序号（前端按正文拆分顺序，从0开始）',
|
||
`root_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '所属顶层评论ID，0表示顶层评论',
|
||
`reply_user_name` varchar(50) DEFAULT NULL COMMENT '被回复人昵称（回复时记录）',
|
||
`reply_count` int(11) NOT NULL DEFAULT 0 COMMENT '回复数（冗余，仅顶层评论维护）',
|
||
`comment_content` varchar(500) NOT NULL COMMENT '评论内容',
|
||
`location` varchar(50) DEFAULT NULL COMMENT '数据来源ip所在地',
|
||
`create_user_id` bigint(20) NOT NULL COMMENT '创建用户ID',
|
||
`create_time` datetime NOT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_index_paragraph` (`book_index_id`, `paragraph_idx`),
|
||
KEY `idx_root_id` (`root_id`)
|
||
) ENGINE = InnoDB
|
||
DEFAULT CHARSET = utf8mb4 COMMENT ='书籍段落评论表（含回复）';
|
||
|