规范的建表语句

 

CREATE TABLE student_info (`id` INT  NOT NULL AUTO_INCREMENT COMMENT '主键',`stu_name` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '姓名',`stu_class` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '班级',`stu_num` INT NOT NULL DEFAULT '0' COMMENT '学号',`stu_score` SMALLINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '总分',`tuition` DECIMAL(5, 2) NOT NULL DEFAULT '0' COMMENT '学费',`phone_number` VARCHAR(20) NOT NULL DEFAULT '0' COMMENT '电话号码',`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录更新时间',`status` TINYINT NOT NULL DEFAULT '1' COMMENT '1代表记录有效，0代表记录无效',PRIMARY KEY (`id`),UNIQUE KEY uniq_stu_num (`stu_num`),KEY idx_stu_score (`stu_score`),KEY idx_update_time_tuition (`update_time`, `tuition`)) ENGINE = INNODB charset = utf8mb4 COMMENT '学生信息表';