ConfigRoom

  `room_locationinvenue` varchar(40) DEFAULT NULL,

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_width` smallint(5) DEFAULT NULL,
  `room_length` smallint(5) DEFAULT NULL,
  `room_tables` 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 |

A list of Rooms at a Venue.

Schema

See Also

• Scheduling - Scheduling home page