forum_django_vue论坛项目-sql

/*
 Navicat Premium Data Transfer

 Source Server         : 127
 Source Server Type    : MySQL
 Source Server Version : 80022
 Source Host           : localhost:3306
 Source Schema         : forum_vue_django

 Target Server Type    : MySQL
 Target Server Version : 80022
 File Encoding         : 65001

 Date: 26/02/2026 12:18:38
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for jf3qapp_ad
-- ----------------------------
DROP TABLE IF EXISTS `jf3qapp_ad`;
CREATE TABLE `jf3qapp_ad`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `tsort` int(0) DEFAULT NULL COMMENT '排序，越小越靠前',
  `aimg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '轮播图',
  `ahref` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '连接',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建时间',
  `amsg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '轮播图' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for jf3qapp_collect_forum
-- ----------------------------
DROP TABLE IF EXISTS `jf3qapp_collect_forum`;
CREATE TABLE `jf3qapp_collect_forum`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int(0) DEFAULT NULL COMMENT '用户id',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建时间',
  `forum_id` int(0) DEFAULT NULL COMMENT '帖子id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '收藏帖子' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for jf3qapp_comment
-- ----------------------------
DROP TABLE IF EXISTS `jf3qapp_comment`;
CREATE TABLE `jf3qapp_comment`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `user_id` int(0) DEFAULT NULL COMMENT '用户id',
  `ccont` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '评论',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '评论时间',
  `col_id` int(0) DEFAULT NULL COMMENT '被评论主体的id',
  `ctype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '被评论主体的类型',
  `hitlikenum` int(0) DEFAULT NULL COMMENT '点赞数量',
  `hf_id` int(0) DEFAULT NULL COMMENT '被回复的评论id',
  `hfuser_id` int(0) DEFAULT NULL COMMENT '被回复的用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 43 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '评论' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for jf3qapp_feedback
-- ----------------------------
DROP TABLE IF EXISTS `jf3qapp_feedback`;
CREATE TABLE `jf3qapp_feedback`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `cont` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '建议聂荣',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '提交时间',
  `result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '处理结果，回复',
  `isdeal` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '0待处理，1已处理',
  `user_id` int(0) DEFAULT NULL COMMENT '提交用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '建议' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for jf3qapp_forum
-- ----------------------------
DROP TABLE IF EXISTS `jf3qapp_forum`;
CREATE TABLE `jf3qapp_forum`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `fname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
  `fcont` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '内容',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建时间',
  `sh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '0待审核1通过-1不通过',
  `user_id` int(0) DEFAULT NULL COMMENT '用户id',
  `imgs` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '图片集合',
  `msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '不通过原因',
  `comment_num` int(0) DEFAULT NULL COMMENT '评论数量',
  `csee_num` int(0) DEFAULT NULL COMMENT '浏览量',
  `fdesc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '简介',
  `type_id` int(0) DEFAULT NULL COMMENT '分类',
  `videos` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '上传的视频集合',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22222 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '帖子' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for jf3qapp_hitlike_comment
-- ----------------------------
DROP TABLE IF EXISTS `jf3qapp_hitlike_comment`;
CREATE TABLE `jf3qapp_hitlike_comment`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `user_id` int(0) DEFAULT NULL COMMENT '用户id',
  `comment_id` int(0) DEFAULT NULL COMMENT '评论id',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '点赞时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 145 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '点赞评论' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for jf3qapp_notice
-- ----------------------------
DROP TABLE IF EXISTS `jf3qapp_notice`;
CREATE TABLE `jf3qapp_notice`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建时间',
  `ntitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '标题',
  `ncont` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '内容',
  `ndesc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '描述',
  `ntype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '类型',
  `user_id` int(0) DEFAULT NULL COMMENT '发布者',
  `nimg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '封面',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `users_id`(`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '公告' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for jf3qapp_syslog
-- ----------------------------
DROP TABLE IF EXISTS `jf3qapp_syslog`;
CREATE TABLE `jf3qapp_syslog`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建时间',
  `lurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '请求路径',
  `lp` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '参数',
  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '角色',
  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '昵称',
  `user_id` int(0) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4379 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统日志' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for jf3qapp_tj
-- ----------------------------
DROP TABLE IF EXISTS `jf3qapp_tj`;
CREATE TABLE `jf3qapp_tj`  (
  `day` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '日期',
  `forumnum` bigint(0) DEFAULT NULL COMMENT '发帖量',
  `viewnum` bigint(0) DEFAULT NULL COMMENT '网站浏览量',
  `commentnum` bigint(0) DEFAULT NULL COMMENT '评论量',
  `hitlikenum` bigint(0) DEFAULT NULL COMMENT '点赞量',
  `collectnum` bigint(0) DEFAULT NULL COMMENT '收藏帖子数量',
  PRIMARY KEY (`day`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '统计' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for jf3qapp_type
-- ----------------------------
DROP TABLE IF EXISTS `jf3qapp_type`;
CREATE TABLE `jf3qapp_type`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `tname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '分类名称',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建时间',
  `tsort` int(0) DEFAULT NULL COMMENT '排序',
  `timg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '图标',
  `ttype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '分类' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for jf3qapp_users
-- ----------------------------
DROP TABLE IF EXISTS `jf3qapp_users`;
CREATE TABLE `jf3qapp_users`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '手机号',
  `upass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '密码',
  `faceimg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '头像',
  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '昵称',
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '1启用0禁用',
  `msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '禁用理由',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建时间',
  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '性别',
  `ulike` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '爱好',
  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '角色pt',
  `school` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '学校',
  `major` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '专业或者工作',
  `age` int(0) DEFAULT NULL COMMENT '年龄',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 43 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;