-- tamp_community.collection definition CREATE TABLE `collection` ( `id` varchar(64) NOT NULL COMMENT 'id', `collection_type` int(4) NOT NULL DEFAULT '-1' COMMENT '类型 1:点赞主题，2：收藏主题 3、点赞评论', `user_id` varchar(64) NOT NULL DEFAULT '' COMMENT '用户id', `target_id` varchar(64) NOT NULL DEFAULT '' COMMENT '目标id', `collection_time` datetime DEFAULT NULL COMMENT '收藏时间', `uncollection_time` datetime DEFAULT NULL COMMENT '取消收藏时间', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `delete_tag` int(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uk_user_type_target` (`user_id`,`collection_type`,`target_id`) USING BTREE, KEY `idx_target_id_and_type` (`target_id`,`collection_time`) USING BTREE, KEY `idx_user_create_time` (`user_id`,`create_time`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='收藏/点赞'; -- tamp_community.comment definition CREATE TABLE `comment` ( `id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT 'id', `comment_id` varchar(64) NOT NULL DEFAULT '' COMMENT '评论主键Id', `comment_type` int(4) NOT NULL DEFAULT '-1' COMMENT '类型 1：评论', `content` varchar(1024) NOT NULL DEFAULT '' COMMENT '文本内容', `author_id` varchar(64) NOT NULL DEFAULT '' COMMENT '作者id', `theme_id` varchar(64) NOT NULL DEFAULT '' COMMENT '主题id', `parent_id` varchar(64) NOT NULL DEFAULT '' COMMENT '一级评论id', `reply_id` varchar(64) NOT NULL DEFAULT '' COMMENT '回复评论id', `review_status` int(4) NOT NULL DEFAULT '0' COMMENT '审核状态 0：初始值 1：已通过（管理后台使用）', `report_status` int(4) NOT NULL DEFAULT '0' COMMENT '举报状态 0：未被举报 1:被举报 2：已处理', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `delete_tag` int(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uk_comment` (`comment_id`) USING BTREE, KEY `idx_author` (`author_id`) USING BTREE, KEY `idx_reply` (`reply_id`) USING BTREE, KEY `idx_theme` (`theme_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='评论'; -- tamp_community.file_record definition CREATE TABLE `file_record` ( `id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT 'id', `file_id` varchar(64) NOT NULL DEFAULT '' COMMENT '文件主键Id', `file_type` int(4) NOT NULL DEFAULT '-1' COMMENT '类型：1：图片', `file_name` varchar(64) NOT NULL DEFAULT '' COMMENT '文件名称', `file_oss_key` varchar(64) NOT NULL DEFAULT '' COMMENT '阿里云key', `preview_url` varchar(512) NOT NULL DEFAULT '' COMMENT '预签名预览url', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `delete_tag` int(3) NOT NULL DEFAULT '0', `ext_info` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uk_fileId` (`file_id`) USING BTREE, UNIQUE KEY `uk_osskey` (`file_oss_key`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='上传文件'; -- tamp_community.follow_rel definition CREATE TABLE `follow_rel` ( `id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT 'id', `idol_id` varchar(64) NOT NULL DEFAULT '' COMMENT '被关注的人id', `fans_id` varchar(64) NOT NULL DEFAULT '' COMMENT '粉丝id', `follow_time` datetime DEFAULT NULL COMMENT '关注时间', `unfollow_time` datetime DEFAULT NULL COMMENT '取消关注时间', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `delete_tag` int(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uk_idol_follower` (`idol_id`,`fans_id`) USING BTREE, KEY `idx_follower` (`fans_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='粉丝关系'; -- tamp_community.rank_log definition CREATE TABLE `rank_log` ( `id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT 'id', `type` int(4) NOT NULL COMMENT '1:话题 2：主题', `total_count` int(11) NOT NULL COMMENT '总排序数量', `page_number` int(11) NOT NULL COMMENT '页码', `page_size` int(11) NOT NULL COMMENT '页面大小', `content` text COMMENT '排序内容', `round` bigint(20) NOT NULL DEFAULT '0', `rank_cost` bigint(20) NOT NULL DEFAULT '0' COMMENT '花费间隔，单位毫秒', `rank_time` datetime DEFAULT NULL COMMENT '排序时间', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `delete_tag` int(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, KEY `uk_round_pageNumber` (`type`,`round`,`page_number`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='话题排序日志记录’'; -- tamp_community.report_log definition CREATE TABLE `report_log` ( `id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT 'id', `user_id` varchar(64) NOT NULL COMMENT '举报发起人', `report_type` int(4) NOT NULL COMMENT '举报类型，1：主题，2：评论 3、用户', `target_id` varchar(64) NOT NULL COMMENT '举报对象id', `target_user_id` varchar(64) NOT NULL COMMENT '举报对象作者id', `report_reason` varchar(64) NOT NULL DEFAULT '' COMMENT '举报理由', `report_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上报时间', `review_result` int(4) DEFAULT NULL COMMENT '处理结果 0：无操作 1：屏蔽 2：删除 ', `review_user_id` varchar(64) NOT NULL DEFAULT '' COMMENT '处理管理员', `review_time` datetime DEFAULT NULL COMMENT '处理时间', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `delete_tag` int(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, KEY `idx_user` (`user_id`) USING BTREE, KEY `idx_report_target_id` (`target_id`) USING BTREE, KEY `idx_targetUserId` (`target_user_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='举报记录'; -- tamp_community.theme definition CREATE TABLE `theme` ( `id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT 'id', `theme_id` varchar(64) NOT NULL DEFAULT '' COMMENT '主题主键Id', `title` varchar(128) NOT NULL DEFAULT '' COMMENT '标题', `theme_type` int(4) NOT NULL DEFAULT '-1' COMMENT '类型 1：讨论无标题 2：长文有标题 3:转发', `content` longtext NOT NULL COMMENT '文本内容(json)，type：附件类型（108：文本，88:产品 3：直播 6：短视频 303：新版课程-音频，304: 新版课程-视频，109：单图（长文） 110：多图（讨论）），productType：基金类型（0 公募，1 私募，2 白名单，3 私有）', `author_id` varchar(64) NOT NULL DEFAULT '' COMMENT '作者id', `former_theme_id` varchar(64) NOT NULL DEFAULT '' COMMENT '转发的主题', `topic_id` varchar(64) NOT NULL DEFAULT '' COMMENT '所属的话题', `review_status` int(4) NOT NULL DEFAULT '0' COMMENT '审核状态 0：未审核 1：审核通过（管理后台使用）', `report_status` int(4) NOT NULL DEFAULT '0' COMMENT '举报状态 0：未被举报 1:被举报 2：已处理', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `delete_tag` int(3) NOT NULL DEFAULT '0' COMMENT '1：删除', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uk_themeId` (`theme_id`) USING BTREE, KEY `idx_author_createTime` (`author_id`,`create_time`) USING BTREE, KEY `idx_former` (`former_theme_id`) USING BTREE, KEY `idx_create_time` (`create_time`) USING BTREE, KEY `idx_topic_id_create_time` (`topic_id`,`create_time`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='主题内容'; -- tamp_community.theme_attachment definition CREATE TABLE `theme_attachment` ( `id` varchar(64) NOT NULL COMMENT 'id', `theme_id` varchar(64) NOT NULL DEFAULT '' COMMENT '主题ID', `attach_type` int(4) NOT NULL DEFAULT '-1' COMMENT '附件类型：108：文本，88:产品 3：直播 6：短视频 303：新版课程-视频，304: 新版课程-音频，109：单图（长文） 110：多图（讨论））', `attach_id` varchar(64) NOT NULL DEFAULT '' COMMENT '附件对应的ID', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `delete_tag` int(3) NOT NULL DEFAULT '0', `ext_info` varchar(512) NOT NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE, KEY `theme_id` (`theme_id`) USING BTREE, KEY `uk_attach_type` (`attach_id`,`attach_type`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='主题附件'; -- tamp_community.topic definition CREATE TABLE `topic` ( `id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT 'id', `topic_id` varchar(64) NOT NULL DEFAULT '' COMMENT '话题主键Id', `topic_title` varchar(64) NOT NULL DEFAULT '' COMMENT '话题名称', `is_top` int(4) NOT NULL DEFAULT '0' COMMENT '是否置顶', `is_conceal` int(4) NOT NULL DEFAULT '0' COMMENT '是否隐藏', `view_cnt_adjust` int(11) NOT NULL DEFAULT '0' COMMENT '浏览量调整基数', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `delete_tag` int(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uk_title` (`topic_title`) USING BTREE, UNIQUE KEY `uk_topicId` (`topic_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='话题'; -- tamp_community.visit_log definition CREATE TABLE `visit_log` ( `id` bigint(32) NOT NULL COMMENT 'id', `ident` varchar(64) NOT NULL DEFAULT '' COMMENT 'session_id', `visitor_id` varchar(64) NOT NULL DEFAULT '' COMMENT '浏览者id', `author_id` varchar(64) NOT NULL DEFAULT '' COMMENT '作者id', `ref_id` varchar(64) NOT NULL DEFAULT '' COMMENT '关联目标ID', `ref_type` varchar(16) NOT NULL DEFAULT '' COMMENT '关联目标类型 ：p13508:进入话题页 p13503:进入主题正文 3、用户查看首页-关注', `duration` int(16) NOT NULL DEFAULT '0' COMMENT '浏览时间 单位秒', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `delete_tag` int(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, KEY `idx_session` (`ident`) USING BTREE, KEY `idx_visitor_ref` (`visitor_id`,`ref_id`,`ref_type`) USING BTREE, KEY `idx_author_ref` (`author_id`,`ref_id`,`ref_type`) USING BTREE, KEY `idx_ref_id_and_type` (`ref_id`,`ref_type`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='浏览记录'; -- tamp_community.worker_node definition CREATE TABLE `worker_node` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'auto increment id', `host_name` varchar(64) NOT NULL COMMENT 'host name', `port` varchar(64) NOT NULL COMMENT 'port', `type` varchar(32) NOT NULL COMMENT 'node type: realhost or container', `launch_date` date NOT NULL COMMENT 'launch date', `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created time', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'modified time', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `idx_host_name_port` (`host_name`,`port`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='分布式唯一ID生成，DB WorkerID Assigner for UID Generator';