set foreign_key_checks = 0;

create table dims.maintenancerecords(
    MaintenceRecordID int not null auto_increment primary key comment "表记录编号",
    DormitoryID int not null comment "宿舍号",
    MDate date not null comment "报修时间",
    MPerson varchar(50) not null comment "维修人员",
    MContent varchar(255) not null comment "维修内容",
    foreign key (DormitoryID) references dims.dormitory(DormitoryID)
) engine = InnoDB default charset = utf8 comment "维修记录表";

set foreign_key_checks = 1;

insert into dims.maintenancerecords(DormitoryID, MDate, MPerson, MContent) values
(801, 20230506, '赵师傅', '喷淋头堵塞，更换喷淋头。'),
(811, 20230507, '钱师傅', '宿舍吸顶灯坏了，更换吸顶灯。'),
(901, 20230507, '孙师傅', '床体松动，维修床体。'),
(911, 20230525, '李师傅', '洗手池堵塞，通洗手池管道。'),
(1001, 20230606, '周师傅', '宿舍洗手台地砖破裂，更换地砖。'),
(1011, 20230607, '钱师傅', '阳台门门把手损坏，更坏门把手。');