gender varchar(10) default null comment '性别',7
telephone varchar(20) default null comment '电话'8
) comment '宿舍管理员表';9
insert into f_dormitory_admin values (null,'user1','1234','赵国栋','男','13300000000');10
insert into f_dormitory_admin values (null,'user2','1234','张无忌','男','13400000000');11
insert into f_dormitory_admin values (null,'user3','1234','张亚琴','女','18800000000');12
13
drop table if exists f_system_admin;14
create table f_system_admin(15
id int not null auto_increment primary key comment 'id',16
user_name varchar(20) not null comment '登录名',17
password varchar(20) not null comment '密码',18
name varchar(20) not null comment '姓名',19
gender varchar(10) default null comment '性别',20
telephone varchar(20) default null comment '电话'21
) comment '系统管理员表';22
insert into f_system_admin values (null,'admin1','1234','管理员1','男','13300000000');23
insert into f_system_admin values (null,'admin2','1234','管理员2','男','13400000000');24
insert into f_system_admin values (null,'admin3','1234','管理员3','女','18800000000');25
26
drop table if exists f_student;27
create table f_student(28
id int not null auto_increment primary key comment 'id',29
number varchar(20) not null comment '学号',30
name varchar(20) not null comment '姓名',31
gender varchar(10) default null comment '性别',32
dormitory_id int not null comment '宿舍id',33
state varchar(10) not null comment '状态',34
create_date datetime default CURRENT_TIMESTAMP comment '创建时间'35
) comment '学生表';36
insert into f_student values(null,'001','周润发','男',1,'入住','2023-01-01');37
insert into f_student values(null,'002','周星驰','男',1,'入住','2023-01-01');38
insert into f_student values(null,'003','刘德华','男',1,'入住','2023-01-01');39
insert into f_student values(null,'004','迪丽热巴','女',2,'入住','2023-01-01');40
41
drop table if exists f_dormitory;42
create table f_dormitory(43
id int not null auto_increment primary key comment 'id',44
building_id int not null comment '楼宇id',45
name varchar(30) not null comment '宿舍名称',46
