-- https://www.phpmyadmin.net/
--
-- Servidor: localhost:3306
-- Tiempo de generación: 16-12-2022 a las 09:37:42
-- Versión del servidor: 8.0.31-0ubuntu0.20.04.2
-- Versión de PHP: 7.4.3

START TRANSACTION;



















CREATE TABLE `hotel_booking` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'related to branch office table',
  `hotel_room_id` varchar(50) NOT NULL COMMENT 'related to hotel room table',
  `since` date NOT NULL,
  `until` date NOT NULL,
  `type` enum('R','O','M') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'R' COMMENT 'R=Reservado, O=Ocupado, M=Mantenimiento',
  `reserved_fullname` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `cellphone_number` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `adults` int DEFAULT NULL COMMENT 'how many adults',
  `kids` int DEFAULT NULL COMMENT '0-17 years',
  `price_per_night` decimal(10,4) DEFAULT '0.0000',
  `currency_id` smallint DEFAULT NULL COMMENT 'Related to currency table',
  `comments` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `hotel_booking`
--

INSERT INTO `hotel_booking` (`relative`, `users_sid`, `global_branch_office_id`, `hotel_room_id`, `since`, `until`, `type`, `reserved_fullname`, `cellphone_number`, `email`, `adults`, `kids`, `price_per_night`, `currency_id`, `comments`, `status`, `created_at`, `updated_at`) VALUES
('0bcf9d75-df7d-4a3c-8920-9bcd50b64b90', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '397294b9-4bc7-45ba-b749-243b432a7723', '2022-10-01', '2022-10-02', 'O', 'Jose Aparicio', '76108443', NULL, 1, NULL, '0.0000', NULL, 'Sin comentarios', 'A', '2022-09-30 09:01:04', '2022-09-30 09:01:21'),
('1e58654d-1fa5-4830-9927-5a05a87b34d3', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '1c42f688-1ed6-4581-a19f-7b2de1b9c681', '2022-04-27', '2022-04-28', 'O', 'Pedro Muris', '+5915481212', NULL, 2, NULL, '0.0000', NULL, NULL, 'A', '2022-04-27 00:47:40', '2022-04-27 00:47:46'),
('3b279d1d-cce9-464f-a9c9-d3dd5ec3a749', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '397294b9-4bc7-45ba-b749-243b432a7723', '2022-04-26', '2022-04-27', 'O', 'Julio Calderon', '+59145787541', NULL, 1, NULL, '0.0000', NULL, NULL, 'A', '2022-04-27 00:45:02', '2022-04-27 00:49:52'),
('6cea9641-420b-4bd9-981d-32c0234c66b6', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '397294b9-4bc7-45ba-b749-243b432a7723', '2022-05-08', '2022-05-08', 'M', NULL, NULL, NULL, NULL, NULL, '0.0000', NULL, 'Fumigacion', 'A', '2022-04-27 00:45:27', '2022-04-27 00:45:27'),
('db15fab0-f58c-42db-9a75-fed764f965ce', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '1c42f688-1ed6-4581-a19f-7b2de1b9c681', '2022-05-02', '2022-05-03', 'R', 'Juan Perez', '+59170000000', NULL, 2, NULL, '0.0000', NULL, 'Llega a las 11 am al aeropuerto, recoger, enviar un taxi.', 'A', '2022-04-27 00:44:21', '2022-04-27 00:44:21');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `hotel_booking_guest`
--

CREATE TABLE `hotel_booking_guest` (
  `relative` varchar(50) NOT NULL COMMENT 'unique',
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch office',
  `hotel_booking_id` varchar(50) NOT NULL COMMENT 'Related to booking table',
  `customers_id` varchar(50) NOT NULL COMMENT 'Related to portfolio customers',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Volcado de datos para la tabla `hotel_booking_guest`
--

INSERT INTO `hotel_booking_guest` (`relative`, `users_sid`, `global_branch_office_id`, `hotel_booking_id`, `customers_id`, `status`, `created_at`, `updated_at`) VALUES
('7afb5864-a850-4b10-aef0-2815d45ad8b9', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '0bcf9d75-df7d-4a3c-8920-9bcd50b64b90', '0225ef41-d47a-4c8b-822c-83fe7802900c', 'A', '2022-09-30 09:02:08', '2022-09-30 09:02:08'),
('7bc57ca8-392c-4be1-9d57-07faed575b8c', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '3b279d1d-cce9-464f-a9c9-d3dd5ec3a749', '9a20f7f2-4bbd-4490-985d-861128c1e6b0', 'A', '2022-04-27 00:48:36', '2022-04-27 00:48:36'),
('9e1ef908-0497-4ffb-a547-6c038a6b21b7', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '0bcf9d75-df7d-4a3c-8920-9bcd50b64b90', '59749823-ae2c-410f-9d5d-8f8e65d21ab0', 'A', '2022-09-30 09:01:48', '2022-09-30 09:01:48'),
('bad88ec3-ae73-4b68-9d8d-4e403f5a0a25', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '0bcf9d75-df7d-4a3c-8920-9bcd50b64b90', '0225ef41-d47a-4c8b-822c-83fe7802900c', 'A', '2022-09-30 09:01:41', '2022-09-30 09:01:41'),
('f32cbce0-2292-487b-91cc-13f2133c332f', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '0bcf9d75-df7d-4a3c-8920-9bcd50b64b90', '59749823-ae2c-410f-9d5d-8f8e65d21ab0', 'A', '2022-09-30 09:02:41', '2022-09-30 09:02:41');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `hotel_catalog_items`
--

CREATE TABLE `hotel_catalog_items` (
  `id` int NOT NULL,
  `catalogs_id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `value` int NOT NULL,
  `label` varchar(250) NOT NULL,
  `lang` varchar(5) NOT NULL,
  `catalog_code` varchar(50) NOT NULL,
  `catalog_code_dep` varchar(50) NOT NULL,
  `catalog_id_dep` int NOT NULL,
  `description` varchar(512) NOT NULL,
  `svg_image` varchar(150) DEFAULT NULL,
  `status` varchar(2) NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Volcado de datos para la tabla `hotel_catalog_items`
--

INSERT INTO `hotel_catalog_items` (`id`, `catalogs_id`, `users_sid`, `global_branch_office_id`, `value`, `label`, `lang`, `catalog_code`, `catalog_code_dep`, `catalog_id_dep`, `description`, `svg_image`, `status`, `created_at`, `updated_at`) VALUES
(46, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'HOTEL', 'es', 'TIPOHOTEL', '0', 0, 'HOTEL', NULL, 'A', '2022-02-26 14:57:55', '2022-02-26 14:57:55'),
(47, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'HOTEL RESIDENCIAL', 'es', 'CATEGORIA', '0', 0, 'HOTEL RESIDENCIAL', NULL, 'A', '2022-02-26 14:58:17', '2022-02-26 14:58:17'),
(48, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'MATRIMONIAL', 'es', 'TIPOHABITACION', '0', 0, 'MATRIMONIAL', NULL, 'A', '2022-02-26 14:58:28', '2022-02-26 14:58:28'),
(49, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'SIMPLE', 'es', 'TIPOHABITACION', '0', 0, 'SIMPLE', NULL, 'A', '2022-02-26 14:58:33', '2022-02-26 14:58:33'),
(50, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'DOBLE', 'es', 'TIPOHABITACION', '0', 0, 'doble', NULL, 'A', '2022-02-26 14:58:37', '2022-02-26 14:58:37'),
(51, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'TRIPLE', 'es', 'TIPOHABITACION', '0', 0, 'triple', NULL, 'A', '2022-02-26 14:58:42', '2022-02-26 14:58:42'),
(52, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'PLANTA BAJA', 'es', 'PISO', '0', 0, 'PB', NULL, 'A', '2022-02-26 14:58:59', '2022-02-26 14:58:59'),
(53, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'PRIMER PISO', 'es', 'PISO', '0', 0, '1', NULL, 'A', '2022-02-26 14:59:07', '2022-02-26 14:59:07'),
(54, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'A', 'es', 'BLOQUE', '0', 0, 'a', NULL, 'A', '2022-02-26 14:59:14', '2022-02-26 14:59:14'),
(55, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'B', 'es', 'BLOQUE', '0', 0, 'b', NULL, 'A', '2022-02-26 14:59:22', '2022-02-26 14:59:22'),
(56, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'PASAPORTE', 'es', 'DOCUMENTO', '0', 0, 'PASAPORTE', NULL, 'A', '2022-02-26 14:59:33', '2022-02-26 14:59:33'),
(57, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'CEDULA DE IDENTIDAD', 'es', 'DOCUMENTO', '0', 0, 'CEDULA DE IDENTIDAD', NULL, 'A', '2022-02-26 14:59:43', '2022-02-26 14:59:43'),
(58, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'CPF', 'es', 'DOCUMENTO', '0', 0, 'cpf', NULL, 'A', '2022-02-26 14:59:49', '2022-02-26 14:59:49'),
(59, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'SI', 'es', 'YESNO', '0', 0, 'si', NULL, 'A', '2022-02-26 14:59:58', '2022-02-26 14:59:58'),
(60, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'NO', 'es', 'YESNO', '0', 0, 'NO', NULL, 'A', '2022-02-26 15:00:01', '2022-02-26 15:00:01'),
(61, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'HAB', 'es', 'MEASUREMENT', '0', 0, 'hab', NULL, 'A', '2022-02-26 15:00:29', '2022-02-26 15:00:29'),
(62, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'SERVICIO', 'es', 'MEASUREMENT', '0', 0, 'servicio', NULL, 'A', '2022-02-26 15:00:36', '2022-02-26 15:00:36'),
(63, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'SERVICIO DE FRIGOBAR', 'es', 'SERVICIOS', '0', 0, 'SERVICIO DE FRIGOBAR', NULL, 'A', '2022-03-06 16:35:10', '2022-03-06 16:35:10'),
(64, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'SERVICIO DE TRANSPORTE', 'es', 'SERVICIOS', '0', 0, 'SERVICIO DE TRANSPORTE', NULL, 'A', '2022-03-06 16:35:20', '2022-03-06 16:35:20'),
(65, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'ALIMENTOS EXTERNOS', 'es', 'SERVICIOS', '0', 0, 'ALIMENTOS EXTERNOS', NULL, 'A', '2022-03-06 16:35:44', '2022-03-06 16:35:44'),
(66, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'SERVICIO A LA HABITACION', 'es', 'SERVICIOS', '0', 0, 'SERVICIO A LA HABITACION', NULL, 'A', '2022-03-06 16:36:10', '2022-03-06 16:36:10'),
(1016, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'CI - CEDULA DE IDENTIDAD', 'es', 'TIPODOCUMENTO', '0', 0, 'CI - CEDULA DE IDENTIDAD', NULL, 'A', '2022-03-27 11:32:41', '2022-03-27 11:32:41'),
(1017, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'CEX - CEDULA DE IDENTIDAD DE EXTRANJERO', 'es', 'TIPODOCUMENTO', '0', 0, 'CEX - CEDULA DE IDENTIDAD DE EXTRANJERO', NULL, 'A', '2022-03-27 11:32:41', '2022-03-27 11:32:41'),
(1018, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'PAS - PASAPORTE', 'es', 'TIPODOCUMENTO', '0', 0, 'PAS - PASAPORTE', NULL, 'A', '2022-03-27 11:32:41', '2022-03-27 11:32:41'),
(1019, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'OD - OTRO DOCUMENTO DE IDENTIDAD', 'es', 'TIPODOCUMENTO', '0', 0, 'OD - OTRO DOCUMENTO DE IDENTIDAD', NULL, 'A', '2022-03-27 11:32:41', '2022-03-27 11:32:41'),
(1020, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'NIT - NÚMERO DE IDENTIFICACIÓN TRIBUTARIA', 'es', 'TIPODOCUMENTO', '0', 0, 'NIT - NÚMERO DE IDENTIFICACIÓN TRIBUTARIA', NULL, 'A', '2022-03-27 11:32:41', '2022-03-27 11:32:41'),
(1021, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'CUADRUPLE', 'es', 'TIPOHABITACION', '0', 0, 'CUADRUPLE', NULL, 'A', '2022-04-27 00:32:11', '2022-04-27 00:32:11');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `hotel_checkout`
--

CREATE TABLE `hotel_checkout` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `booking_id` varchar(50) NOT NULL COMMENT 'related to booking',
  `client_fullname` varchar(200) NOT NULL,
  `client_document` varchar(50) DEFAULT NULL,
  `detail` text NOT NULL,
  `room_cost` decimal(10,4) NOT NULL DEFAULT '0.0000',
  `services_cost` decimal(10,4) NOT NULL DEFAULT '0.0000',
  `subtotal` decimal(10,4) NOT NULL COMMENT 'related to checkout',
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `hotel_checkout`
--

INSERT INTO `hotel_checkout` (`relative`, `users_sid`, `global_branch_office_id`, `booking_id`, `client_fullname`, `client_document`, `detail`, `room_cost`, `services_cost`, `subtotal`, `currency_id`, `status`, `created_at`, `updated_at`) VALUES
('867605c2-1fc7-48c6-8f2a-bbe8fc8aa4f3', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '3b279d1d-cce9-464f-a9c9-d3dd5ec3a749', 'Julio Calderon', NULL, 'Habitación SPB-01 Desde 26/04/2022 Hasta 27/04/2022\nServicios a la habitación por compra de pizza', '100.0000', '60.0000', '160.0000', 2, 'A', '2022-04-27 00:50:36', '2022-04-27 00:50:36');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `hotel_configuration`
--

CREATE TABLE `hotel_configuration` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch office on core',
  `decimals` smallint NOT NULL,
  `currency_id` int NOT NULL DEFAULT '1' COMMENT 'Related to currency table',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Volcado de datos para la tabla `hotel_configuration`
--

INSERT INTO `hotel_configuration` (`relative`, `users_sid`, `global_branch_office_id`, `decimals`, `currency_id`, `status`, `created_at`, `updated_at`) VALUES
('025bf892-39f3-4d27-a5ea-d58ef44603bd', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 2, 'A', '2022-03-09 08:13:36', '2022-03-09 08:13:36');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `hotel_enterprise`
--

CREATE TABLE `hotel_enterprise` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch office on core',
  `fullname` varchar(250) NOT NULL,
  `economic_activity` mediumtext NOT NULL,
  `owner` varchar(250) NOT NULL,
  `address` mediumtext NOT NULL,
  `phones` varchar(150) NOT NULL,
  `branch_office` varchar(200) DEFAULT NULL,
  `branch_code` varchar(25) DEFAULT NULL,
  `city` tinytext NOT NULL,
  `photo` varchar(250) DEFAULT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Volcado de datos para la tabla `hotel_enterprise`
--

INSERT INTO `hotel_enterprise` (`relative`, `users_sid`, `global_branch_office_id`, `fullname`, `economic_activity`, `owner`, `address`, `phones`, `branch_office`, `branch_code`, `city`, `photo`, `status`, `created_at`, `updated_at`) VALUES
('5dde3040-d69e-4d6e-a1cf-4abd36acc4a9', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 'HOTEL DE EJEMPLO', 'Activiadad hotelera', 'Fulano sultano', 'direccion fisica', '+59175454124', 'Casa matriz', '1', 'Cochabamba', '1651034195-9794657-8e89ff36-4917-4907-95bf-433ef314ad03.png', 'A', '2022-04-27 00:36:35', '2022-04-27 00:36:35');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `hotel_room`
--

CREATE TABLE `hotel_room` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch id',
  `block_id` int NOT NULL COMMENT 'related to catalogs items',
  `floor_id` int NOT NULL COMMENT 'related to catalogs items',
  `kind_id` int NOT NULL COMMENT 'related to catalogs items',
  `room` varchar(50) NOT NULL,
  `beds` int NOT NULL DEFAULT '1',
  `room_description` text,
  `season_price_id` varchar(50) NOT NULL COMMENT 'Related to season price',
  `max_person_regular_price` smallint NOT NULL DEFAULT '1',
  `max_person_inside` int NOT NULL DEFAULT '1',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `hotel_room`
--

INSERT INTO `hotel_room` (`relative`, `users_sid`, `global_branch_office_id`, `block_id`, `floor_id`, `kind_id`, `room`, `beds`, `room_description`, `season_price_id`, `max_person_regular_price`, `max_person_inside`, `status`, `created_at`, `updated_at`) VALUES
('1c42f688-1ed6-4581-a19f-7b2de1b9c681', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 1, 1, 'MPB-01', 1, 'Cama matrimonial', 'a4d42685-4ec5-4065-9692-c9a5eee392f7', 1, 2, 'A', '2022-04-27 00:39:33', '2022-04-27 00:39:33'),
('26aadb7e-fe28-44d5-a14c-1206509533e1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 1, 3, 'DPB-06', 2, 'habitacion doble', '09db7f89-71eb-423f-bb27-b9a5afb8b4ce', 1, 2, 'A', '2022-04-27 00:41:07', '2022-04-27 00:41:07'),
('397294b9-4bc7-45ba-b749-243b432a7723', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 1, 2, 'SPB-01', 1, 'adasd asdasdasdasd', 'afbe4ca3-a798-4971-b99e-f5bd03d90d0d', 1, 1, 'A', '2022-04-27 00:40:36', '2022-04-27 00:40:36'),
('e58c3c40-86c6-4718-bc50-112dff843b28', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 1, 1, 'MPB-02', 1, 'asdasdasdasdas', 'a4d42685-4ec5-4065-9692-c9a5eee392f7', 1, 2, 'A', '2022-04-27 00:40:06', '2022-04-27 00:40:06');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `hotel_season_price`
--

CREATE TABLE `hotel_season_price` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch',
  `kind_id` int NOT NULL COMMENT 'Related to catalogs table = TIPOHABITACION',
  `since` date NOT NULL,
  `until` date NOT NULL,
  `referral_price` decimal(10,4) NOT NULL,
  `price_per_extra_person` decimal(10,4) NOT NULL DEFAULT '0.0000',
  `currency_id` int NOT NULL COMMENT 'related to global currency',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `hotel_season_price`
--

INSERT INTO `hotel_season_price` (`relative`, `users_sid`, `global_branch_office_id`, `kind_id`, `since`, `until`, `referral_price`, `price_per_extra_person`, `currency_id`, `status`, `created_at`, `updated_at`) VALUES
('09db7f89-71eb-423f-bb27-b9a5afb8b4ce', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, '2022-04-27', '2022-11-30', '200.0000', '0.0000', 2, 'A', '2022-04-27 00:37:54', '2022-04-27 00:37:54'),
('27bffab1-e419-4d3d-8e69-34a17bc3868b', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, '2022-04-27', '2022-11-30', '350.0000', '0.0000', 2, 'A', '2022-04-27 00:38:21', '2022-04-27 00:38:21'),
('5c47e51d-184c-40e9-bdf0-208152d64065', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, '2022-04-27', '2022-11-30', '450.0000', '70.0000', 2, 'A', '2022-04-27 00:38:34', '2022-05-06 08:01:13'),
('a4d42685-4ec5-4065-9692-c9a5eee392f7', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, '2022-04-27', '2022-11-30', '300.0000', '0.0000', 2, 'A', '2022-04-27 00:37:24', '2022-04-27 00:37:24'),
('afbe4ca3-a798-4971-b99e-f5bd03d90d0d', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, '2022-04-27', '2022-11-30', '100.0000', '0.0000', 2, 'A', '2022-04-27 00:37:40', '2022-04-27 00:37:40');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `hotel_services`
--

CREATE TABLE `hotel_services` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `booking_id` varchar(50) NOT NULL,
  `service_id` int NOT NULL COMMENT 'Related to catalogs items = ''SERVICIOS''',
  `detail` mediumtext,
  `quantity` decimal(10,2) NOT NULL,
  `measurement_id` int NOT NULL COMMENT 'related to catalogs',
  `price` decimal(10,4) NOT NULL,
  `subtotal` decimal(10,4) NOT NULL,
  `currency_id` int NOT NULL COMMENT 'related to currency',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `hotel_services`
--

INSERT INTO `hotel_services` (`relative`, `users_sid`, `global_branch_office_id`, `booking_id`, `service_id`, `detail`, `quantity`, `measurement_id`, `price`, `subtotal`, `currency_id`, `status`, `created_at`, `updated_at`) VALUES
('b396324c-32c4-47a2-941d-0ebe56be8384', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '3b279d1d-cce9-464f-a9c9-d3dd5ec3a749', 3, 'Compra de pizza', '1.00', 2, '60.0000', '60.0000', 2, 'A', '2022-04-27 00:49:18', '2022-04-27 00:49:18');

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `hotel_booking`
--
ALTER TABLE `hotel_booking`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `relative` (`relative`);

--
-- Indices de la tabla `hotel_booking_guest`
--
ALTER TABLE `hotel_booking_guest`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `hotel_booking_guest.relative` (`relative`);

--
-- Indices de la tabla `hotel_catalog_items`
--
ALTER TABLE `hotel_catalog_items`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `hotel_checkout`
--
ALTER TABLE `hotel_checkout`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `hotel_checkouts.relative` (`relative`);

--
-- Indices de la tabla `hotel_configuration`
--
ALTER TABLE `hotel_configuration`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `configuration.relative` (`relative`);

--
-- Indices de la tabla `hotel_enterprise`
--
ALTER TABLE `hotel_enterprise`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `sivir_enterprise.relative` (`relative`);

--
-- Indices de la tabla `hotel_room`
--
ALTER TABLE `hotel_room`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `relative` (`relative`);

--
-- Indices de la tabla `hotel_season_price`
--
ALTER TABLE `hotel_season_price`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `relative` (`relative`);

--
-- Indices de la tabla `hotel_services`
--
ALTER TABLE `hotel_services`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `hotel_services.relative` (`relative`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `hotel_catalog_items`
--
ALTER TABLE `hotel_catalog_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1022;
COMMIT;

