text: CREATE TABLE `room` (
    `room_id` int(11) NOT NULL AUTO_INCREMENT,
    `venue_id` int(11) NOT NULL,
    `room_name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
    `capacity` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
    `rental_cost` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_by` int(11) NOT NULL,
    `modified_by` int(11) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` datetime DEFAULT NULL,
    `available` varchar(45) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
    PRIMARY KEY (`room_id`,`venue_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  