CREATE TABLE `THA` (
  `tha_id` int(11) NOT NULL AUTO_INCREMENT,
  `tha_name` char(80) COLLATE utf8_spanish_ci NOT NULL DEFAULT '' COMMENT 'Informacion almacenada en TRT',
  `tha_hot_id` int(11) NOT NULL COMMENT 'Id del hotel al que pertenece el tipo de habitacion',
  `tha_description` char(120) COLLATE utf8_spanish_ci NOT NULL DEFAULT '' COMMENT 'Informacion almacenada en TRT',
  `tha_tot_hab` int(11) NOT NULL DEFAULT '0',
  `tha_std_capacity` int(11) NOT NULL DEFAULT '0' COMMENT 'Capacidad Estandar',
  `tha_min_capacity` int(11) NOT NULL DEFAULT '0' COMMENT 'Capacidad Minima',
  `tha_max_capacity` int(11) NOT NULL DEFAULT '0' COMMENT 'Capacidad Maxima',
  `tha_king_bed` int(11) NOT NULL DEFAULT '0',
  `tha_queen_bed` int(11) NOT NULL DEFAULT '0',
  `tha_marital_bed` int(11) NOT NULL DEFAULT '0',
  `tha_single_bed` int(11) NOT NULL DEFAULT '0',
  `tha_litter_bed` int(11) NOT NULL DEFAULT '0',
  `tha_double_sofa` int(11) NOT NULL DEFAULT '0',
  `tha_single_sofa` int(11) NOT NULL DEFAULT '0',
  `tha_hammock` int(11) NOT NULL DEFAULT '0',
  `tha_wc` int(1) NOT NULL DEFAULT '0' COMMENT 'Excusado',
  `tha_shower` int(1) NOT NULL DEFAULT '0' COMMENT 'Ducha',
  `tha_bath` int(1) NOT NULL DEFAULT '0' COMMENT 'Bañera',
  `tha_hot_water` int(1) NOT NULL DEFAULT '0' COMMENT 'Agua Caliente',
  `tha_jacuzzi` int(1) NOT NULL DEFAULT '0' COMMENT 'Jacuzzi',
  `tha_hairdryer` int(1) NOT NULL DEFAULT '0' COMMENT 'Secador de Pelo',
  `tha_aircool` int(1) NOT NULL DEFAULT '0' COMMENT 'Aire Acondicionado',
  `tha_heating` int(1) NOT NULL DEFAULT '0' COMMENT 'Calefacion',
  `tha_fan` int(1) NOT NULL DEFAULT '0' COMMENT 'Ventilador',
  `tha_hearth` int(1) NOT NULL DEFAULT '0' COMMENT 'Chimenea',
  `tha_refrigerator` int(1) NOT NULL DEFAULT '0' COMMENT 'Nevera',
  `tha_minibar` int(1) NOT NULL DEFAULT '0' COMMENT 'Mini Bar',
  `tha_kitchen` int(1) NOT NULL DEFAULT '0' COMMENT 'Cocina',
  `tha_daily_clean` int(1) NOT NULL DEFAULT '0' COMMENT 'Limpieza Diaria',
  `tha_tv` int(1) NOT NULL DEFAULT '0' COMMENT 'Television',
  `tha_internet` int(1) NOT NULL DEFAULT '0' COMMENT 'Internet por cable',
  `tha_wifi` int(1) NOT NULL DEFAULT '0' COMMENT 'Internet Inalambrico',
  `tha_phone` int(1) NOT NULL DEFAULT '0' COMMENT 'Telefono',
  `tha_smoker` int(1) NOT NULL DEFAULT '0' COMMENT 'Fumadores',
  `tha_other_fac` char(120) COLLATE utf8_spanish_ci NOT NULL DEFAULT '' COMMENT 'Otras Facilidades',
  `tha_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `tha_created` timestamp NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`tha_id`),
  KEY `tha_hot_id` (`tha_hot_id`),
  CONSTRAINT `THA-HOT` FOREIGN KEY (`tha_hot_id`) REFERENCES `HOT` (`hot_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;