master

分支 (1)

管理

管理

master

wx-ershou
/
ershuo.sql

/*
Navicat MySQL Data Transfer

Source Server         : mysql1
Source Server Version : 50730
Source Host           : localhost:3306
Source Database       : ershuo

Target Server Type    : MYSQL
Target Server Version : 50730
File Encoding         : 65001

Date: 2021-10-28 12:15:44
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for chat_list
-- ----------------------------
DROP TABLE IF EXISTS `chat_list`;
CREATE TABLE `chat_list` (
  `list_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '聊天列表主键',
  `from_openid` varchar(30) CHARACTER SET utf8 NOT NULL COMMENT '发送者',
  `from_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `from_headImage` varchar(255) CHARACTER SET utf8 NOT NULL,
  `from_state` int(3) NOT NULL COMMENT '用户认证状态',
  `last_context` varchar(255) NOT NULL COMMENT '最后一条内容',
  `to_openid` varchar(30) CHARACTER SET utf8 NOT NULL COMMENT '接收者',
  `send_time` datetime DEFAULT NULL COMMENT '最后一条消息发送时间',
  PRIMARY KEY (`list_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for chat_message
-- ----------------------------
DROP TABLE IF EXISTS `chat_message`;
CREATE TABLE `chat_message` (
  `message_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '聊天内容id',
  `from_openid` varchar(30) CHARACTER SET utf8 NOT NULL COMMENT '发送者',
  `content` varchar(255) NOT NULL COMMENT '聊天内容',
  `send_time` datetime NOT NULL COMMENT '发送时间',
  `to_openid` varchar(30) CHARACTER SET utf8 NOT NULL COMMENT '接收者',
  PRIMARY KEY (`message_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for comments_info
-- ----------------------------
DROP TABLE IF EXISTS `comments_info`;
CREATE TABLE `comments_info` (
  `in_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '评论主键id',
  `good_id` int(10) NOT NULL COMMENT '被评论物品gid',
  `from_openid` varchar(32) NOT NULL COMMENT '评论者id',
  `from_name` varchar(32) NOT NULL COMMENT '评论者名字',
  `from_avatar` varchar(512) DEFAULT '' COMMENT '评论者头像',
  `like_num` int(11) DEFAULT '0' COMMENT '点赞的数量',
  `content` varchar(512) DEFAULT NULL COMMENT '评论内容',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `user_state` int(3) DEFAULT NULL COMMENT '用户是否认证',
  PRIMARY KEY (`in_id`),
  KEY `owner_id` (`good_id`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8mb4 COMMENT='评论主表';

-- ----------------------------
-- Table structure for comments_reply
-- ----------------------------
DROP TABLE IF EXISTS `comments_reply`;
CREATE TABLE `comments_reply` (
  `rid` int(11) NOT NULL AUTO_INCREMENT,
  `comment_id` int(10) NOT NULL COMMENT '评论主表id',
  `from_openid` varchar(32) NOT NULL COMMENT '评论者id',
  `from_name` varchar(32) NOT NULL COMMENT '评论者名字',
  `from_avatar` varchar(512) DEFAULT '' COMMENT '评论者头像',
  `to_openid` varchar(32) NOT NULL COMMENT '被评论者id',
  `to_name` varchar(32) NOT NULL COMMENT '被评论者名字',
  `to_avatar` varchar(512) DEFAULT '' COMMENT '被评论者头像',
  `content` varchar(512) DEFAULT NULL COMMENT '评论内容',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `like_num` int(11) DEFAULT NULL COMMENT '点赞',
  `user_state` int(3) DEFAULT NULL COMMENT '用户是否认证',
  PRIMARY KEY (`rid`),
  KEY `comment_id` (`comment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4 COMMENT='评论回复表';

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `gid` int(20) NOT NULL AUTO_INCREMENT COMMENT '商品编号',
  `openid` varchar(255) DEFAULT NULL COMMENT '用户唯一id',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '物品名称',
  `goods_title` varchar(255) DEFAULT NULL COMMENT '物品标题',
  `goods_price_new` decimal(10,2) DEFAULT NULL COMMENT '物品现价',
  `goods_price_old` decimal(10,2) DEFAULT NULL COMMENT '物品原价',
  `goods_xueyuan` varchar(255) DEFAULT NULL COMMENT '发布者学院',
  `goods_dec` varchar(255) DEFAULT NULL COMMENT '物品描述',
  `goods_address` varchar(255) DEFAULT NULL COMMENT '交易地址',
  `state` int(3) DEFAULT NULL COMMENT '状态',
  `issue_time` datetime(5) DEFAULT NULL COMMENT '发布时间',
  `check_ok` datetime(5) DEFAULT NULL COMMENT '审核时间',
  `home_image` varchar(255) DEFAULT NULL COMMENT '物品封面',
  `open_sum` int(20) DEFAULT NULL COMMENT '浏览量',
  `like_sum` int(20) DEFAULT NULL COMMENT '点赞数量',
  PRIMARY KEY (`gid`),
  KEY `user_good` (`openid`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for images
-- ----------------------------
DROP TABLE IF EXISTS `images`;
CREATE TABLE `images` (
  `im_id` int(20) NOT NULL AUTO_INCREMENT COMMENT '图片编号',
  `openid` varchar(255) DEFAULT NULL COMMENT '用户编号',
  `gid` int(20) DEFAULT NULL COMMENT '商品编号',
  `image_name` varchar(255) DEFAULT NULL COMMENT '图片名称',
  `image_url` varchar(255) DEFAULT NULL COMMENT '图片地址',
  `image_address` varchar(255) DEFAULT NULL COMMENT '图片在服务器中存储地址',
  `state` int(10) DEFAULT NULL,
  PRIMARY KEY (`im_id`),
  KEY `user_im` (`openid`),
  KEY `good_im` (`gid`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for liked
-- ----------------------------
DROP TABLE IF EXISTS `liked`;
CREATE TABLE `liked` (
  `like_id` int(10) NOT NULL AUTO_INCREMENT,
  `obj_id` int(11) NOT NULL COMMENT '被点赞id ,可为gid,in_id,rid',
  `user_openid` varchar(255) NOT NULL COMMENT '点赞者的id',
  `like_status` int(2) NOT NULL COMMENT '点赞的状态，1标识已赞，0标识取消赞',
  `create_time` datetime(5) DEFAULT NULL,
  `update_time` datetime(5) DEFAULT NULL,
  `type` int(2) DEFAULT NULL COMMENT '区别物品，主评论，子评论',
  PRIMARY KEY (`like_id`),
  KEY `rid_liked` (`obj_id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
  `mid` int(2) NOT NULL AUTO_INCREMENT,
  `notice_info` varchar(255) DEFAULT NULL COMMENT '公告内容',
  `from_openid` varchar(30) DEFAULT NULL COMMENT '某人发送了一个评论',
  `gid` int(10) DEFAULT NULL COMMENT '针对某一个gid向用户发送',
  `send_time` datetime(5) DEFAULT NULL COMMENT '发布时间',
  `to_openid` varchar(30) DEFAULT NULL COMMENT '被评论的物品的发布者',
  PRIMARY KEY (`mid`),
  KEY `user_no` (`from_openid`),
  KEY `good_no` (`gid`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for shopping_car
-- ----------------------------
DROP TABLE IF EXISTS `shopping_car`;
CREATE TABLE `shopping_car` (
  `cid` int(10) NOT NULL AUTO_INCREMENT,
  `openid` varchar(255) NOT NULL,
  `gid` int(10) NOT NULL,
  PRIMARY KEY (`cid`),
  KEY `user_car` (`openid`),
  KEY `good_car` (`gid`)
) ENGINE=InnoDB AUTO_INCREMENT=194 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for user_detail
-- ----------------------------
DROP TABLE IF EXISTS `user_detail`;
CREATE TABLE `user_detail` (
  `uuid` int(10) NOT NULL AUTO_INCREMENT,
  `openid` varchar(255) DEFAULT NULL,
  `uclass` varchar(255) DEFAULT NULL,
  `xuehao` varchar(255) DEFAULT NULL,
  `school` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`uuid`),
  KEY `ude_uer` (`openid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for user_ershou
-- ----------------------------
DROP TABLE IF EXISTS `user_ershou`;
CREATE TABLE `user_ershou` (
  `uid` int(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID系统自动生成',
  `openid` varchar(255) NOT NULL,
  `wxname` varchar(255) NOT NULL,
  `head_img` varchar(255) NOT NULL,
  `sex` int(3) NOT NULL,
  `uname` varchar(255) NOT NULL,
  `qq` varchar(255) NOT NULL,
  `wx` varchar(255) NOT NULL,
  `state` int(3) NOT NULL COMMENT '用户状态/权限',
  PRIMARY KEY (`uid`),
  KEY `openid` (`openid`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4;