通过下面的类给我生成建表语句@TableName("answer") public class Answer { @TableId(value = "id", type = IdType.AUTO) private Integer id; private Integer uid; private String uname; private String avatar; private String content; private Date time; //回复的评论id private Integer commentId; private Integer status; private Date createTime; private Date updateTime; //删除标志(0代表未删除,1代表已删除) private Integer delFlag; }
时间: 2023-05-21 14:05:53 浏览: 41
生成建表语句如下:
CREATE TABLE `answer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) DEFAULT NULL,
`uname` varchar(255) DEFAULT NULL,
`avatar` varchar(255) DEFAULT NULL,
`content` varchar(255) DEFAULT NULL,
`time` timestamp NULL DEFAULT NULL,
`commentId` int(11) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
`createTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updateTime` timestamp NULL DEFAULT NULL,
`delFlag` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_commentId` (`commentId`),
KEY `idx_delFlag` (`delFlag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
相关问题
根据下面类生成数据库建表语句 @TableName("type") public class Type { @TableId(value = "id", type = IdType.AUTO) private Integer id; private String name; private String description; @TableField(exist = false) private Integer type_num; } @TableName("user") public class User {
CREATE TABLE type (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
description VARCHAR(255) NOT NULL,
type_num INT
);
CREATE TABLE user (
-- assuming default ID is AUTO_INCREMENT and PRIMARY KEY
id INT PRIMARY KEY AUTO_INCREMENT,
-- assuming name is varchar with max length 255
name VARCHAR(255) NOT NULL,
-- assuming email is unique for each user
email VARCHAR(255) UNIQUE NOT NULL
);
通过下面的类给我生成建表语句 @TableName("comment") public class Comment { @TableId(value = "id", type = IdType.AUTO) private Integer id; private Integer uid; private String uname; private String avatar; private Date time; private String content; //回复的帖子id private Integer pid; private Integer status; private Date createTime; private Date updateTime; //删除标志(0代表未删除,1代表已删除) private Integer delFlag; @TableField(exist = false) private List<Answer> answerList;//记录这条评论的所有回复 }
生成建表语句如下:
CREATE TABLE `comment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) DEFAULT NULL,
`uname` varchar(255) DEFAULT NULL,
`avatar` varchar(255) DEFAULT NULL,
`time` datetime DEFAULT NULL,
`content` varchar(255) DEFAULT NULL,
`pid` int(11) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
`createTime` datetime DEFAULT NULL,
`updateTime` datetime DEFAULT NULL,
`delFlag` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;