CREATE TABLE `tb_user1` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`email` varchar(50) DEFAULT NULL,
`userName` varchar(25) NOT NULL DEFAULT '',
`password` varchar(18) NOT NULL,
`gender` varchar(1) NOT NULL DEFAULT '男',
`address` varchar(100) DEFAULT NULL,
`department` varchar(11) NOT NULL DEFAULT '1',
`createdTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`createdBy` varchar(25) NOT NULL DEFAULT 'admin',
`updatedTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`updatedBy` varchar(25) NOT NULL DEFAULT 'admin',
`isDeleted` varchar(1) NOT NULL DEFAULT 'N',
PRIMARY KEY (`id`),
UNIQUE KEY `userName` (`userName`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import lombok.Data;
import java.util.Date