• View
• Edit
• History
• Print

ConfigRoom

A list of Rooms at a Venue.

Schema

CREATE TABLE `config_rooms` (
  `room_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `room_venue` smallint(5) unsigned NOT NULL,
  `room_name` varchar(40) DEFAULT NULL,
  `room_locationinvenue` varchar(40) DEFAULT NULL,
  `room_width` smallint(5) DEFAULT NULL,
  `room_length` smallint(5) DEFAULT NULL,
  `room_capacity` smallint(5) DEFAULT NULL,
  `room_phone` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`room_id`),
  KEY `room_venue` (`room_venue`),
  KEY `room_name` (`room_venue`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 | 

See Also

• Scheduling - Scheduling home page