-- CreateTable
CREATE TABLE `Rooms` (
    `room_id` VARCHAR(191) NOT NULL,
    `length` VARCHAR(191) NOT NULL,
    `width` VARCHAR(191) NOT NULL,
    `hieght` VARCHAR(191) NOT NULL,
    `numOfPeople` VARCHAR(191) NOT NULL,
    `relative_humidity` VARCHAR(191) NOT NULL,
    `temperature` VARCHAR(191) NOT NULL,
    `building_id` VARCHAR(191) NOT NULL,

    PRIMARY KEY (`room_id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- AddForeignKey
ALTER TABLE `Rooms` ADD CONSTRAINT `Rooms_building_id_fkey` FOREIGN KEY (`building_id`) REFERENCES `User_Building_Details`(`user_building_details_id`) ON DELETE RESTRICT ON UPDATE CASCADE;