数据库建表语句
CREATE TABLE system_user ( id int NOT NULL AUTO_INCREMENT COMMENT 主键, username varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 用户名, real_name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 真实姓名, emp_no varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 工号, birthday date DEFAULT NULL COMMENT 生日, gender varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 性别, email varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 邮箱, email_digest varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 邮箱摘要, mobile varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 手机号码, mobile_digest varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 手机号码摘要, avatar varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 头像, password varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 密码, salt varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 密码盐, fixed tinyint(1) NOT NULL DEFAULT 0 COMMENT 是否为固定用户, created_by int DEFAULT NULL COMMENT 创建人, created_at datetime NOT NULL COMMENT 创建时间, updated_by int DEFAULT NULL COMMENT 更新人, updated_at datetime DEFAULT NULL COMMENT 更新时间, deleted tinyint(1) NOT NULL DEFAULT 0 COMMENT 是否已删除, PRIMARY KEY (id) ) ENGINEInnoDB AUTO_INCREMENT1026 DEFAULT CHARSETutf8mb4 COLLATEutf8mb4_general_ci COMMENT系统用户;表范式字段保证原子性即字段数据不可再划分一张表只描述同一类信息每张表都必须有主键、部分通用字段如创建人、创建时间、更新人、更新时间、是否已删除等
