CREATE TABLE IF NOT EXISTS `#__sr_housekeeping` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `room_id` INT(11) UNSIGNED NULL,
  `room_status` TINYINT(3) NULL,
  `reservation_status` TINYINT(3) NULL,
  `note` VARCHAR(255) NULL,
  `employee_id` INT(11) UNSIGNED NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_housekeeping_rooms1_idx` (`room_id` ASC),
  CONSTRAINT `fk_housekeeping_sr_rooms1`
    FOREIGN KEY (`room_id`)
    REFERENCES `#__sr_rooms` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;