数据库表设计的字段
CREATE TABLE `tb_user` (
id
bigint(20) NOT NULL AUTO_INCREMENT,
username
varchar(50) NOT NULL COMMENT ‘用户名’,
password
varchar(32) NOT NULL COMMENT ‘密码,加密存储’,
phone
varchar(20) DEFAULT NULL COMMENT ‘注册手机号’,
email
varchar(50) DEFAULT NULL COMMENT ‘注册邮箱’,
created
datetime NOT NULL,
updated
datetime NOT NULL,
PRIMARY KEY (id
),
UNIQUE KEY username
(username
) USING BTREE,
UNIQUE KEY phone
(phone
) USING BTREE,
UNIQUE KEY email
(email
) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 COMMENT=‘用户表’;
mybatis逆向工程的字段
insert into tb_user (id, username, password,
phone, email, created,
updated)
values (#{id,jdbcType=BIGINT}, #{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR},
#{phone,jdbcType=VARCHAR}, #{email,jdbcType=VARCHAR}, #{created,jdbcType=TIMESTAMP},
#{updated,jdbcType=TIMESTAMP})