
--
-- Table structure for table `sivir_configuration`
--

CREATE TABLE `sivir_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',
  `zofra` enum('Y','N') NOT NULL DEFAULT 'N',
  `inventory_method` enum('PEPS','UEPS','PEPP','UEPP') NOT NULL DEFAULT 'UEPS',
  `costs_method` enum('PPP','CE') NOT NULL DEFAULT 'CE' COMMENT 'PPP=Precio promedio ponderado, CE=Costo especifico',
  `iva` decimal(10,2) NOT NULL,
  `send_invoice_automatically` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'Send or not the invoice to the customer automatically',
  `round_price` enum('Y','N') NOT NULL DEFAULT 'Y' COMMENT 'Except the .50 ammount',
  `internal_control` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'Just control the inventory, do not worry about the invoice',
  `show_due_date` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'Show or not the due date on the sell',
  `supermarket_mode` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'Enable the super market mode?',
  `adjust_inventory_on_sell` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'Adjust the inventory on sell?',
  `show_supplier_vendor_on_sell` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'Show or not, the supplier vendor on the search inside the sell',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `configuration.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_configuration`
--

INSERT INTO `sivir_configuration` VALUES ('6c181c07-6323-11f0-b0b9-00163c31d95c','69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',2,1,'N','UEPS','PPP',13.00,'N','N','Y','N','N','N','N','A','2025-07-17 00:00:00','2025-07-17 11:34:17');

--
-- Table structure for table `sivir_coupons`
--

CREATE TABLE `sivir_coupons` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'Autoincrement',
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `coupon_group` varchar(50) NOT NULL COMMENT 'The coupon name',
  `quantity_generated` int NOT NULL DEFAULT '1' COMMENT 'For the automaticaly generated',
  `product_id` varchar(50) DEFAULT NULL COMMENT 'Related to product table relative column',
  `amount` decimal(10,5) NOT NULL DEFAULT '0.00000' COMMENT 'The coupon ammount',
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `expiration_date` date NOT NULL COMMENT 'The expiration date',
  `coupon_status` enum('V','U') NOT NULL DEFAULT 'V' COMMENT 'V=Valid, U=Used',
  `status` enum('A','X') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A' COMMENT 'A=Active, X=Deleted',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_coupons`
--


--
-- Table structure for table `sivir_cuis`
--

CREATE TABLE `sivir_cuis` (
  `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',
  `sell_point_id` varchar(50) NOT NULL COMMENT 'Related to sell point table',
  `codigo_punto_venta` int NOT NULL,
  `nombre_punto_venta` varchar(200) NOT NULL,
  `cuis` varchar(50) NOT NULL,
  `cuis_expiration_datetime` datetime NOT NULL,
  `message` varchar(150) NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sivir_cuis.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_cuis`
--

INSERT INTO `sivir_cuis` VALUES ('3db0e0bd-3e0e-47c1-9bb2-444671175d60','69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','6c17ae3b-6323-11f0-b0b9-00163c31d95c',0,'PV0','AA4C3771','2026-07-17 11:35:58','CUIS GENERADO CORRECTAMENTE','A','2025-07-17 11:35:58','2025-07-17 11:35:58');

--
-- Table structure for table `sivir_customer_on_service`
--

CREATE TABLE `sivir_customer_on_service` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'The unique UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Relate to branch office table',
  `product_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to products table',
  `customer_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to portfolio customers, this could be null for the special clients	',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_customer_on_service`
--


--
-- Table structure for table `sivir_deliver_input`
--

CREATE TABLE `sivir_deliver_input` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `id` bigint NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to global_branch_office',
  `person_id` int NOT NULL COMMENT 'Related to person table',
  `deliver_reason` text NOT NULL COMMENT 'The complete reason',
  `total_items` decimal(15,5) NOT NULL COMMENT 'The total items',
  `date_delivered` date NOT NULL COMMENT 'The date delivered',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_deliver_input`
--


--
-- Table structure for table `sivir_deliver_items`
--

CREATE TABLE `sivir_deliver_items` (
  `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 table',
  `provisional` varchar(50) DEFAULT NULL COMMENT ' The provisional uuid for the sale ',
  `deliver_input_id` bigint DEFAULT NULL COMMENT 'related to deliver table',
  `product_id` varchar(50) NOT NULL COMMENT 'related to product table',
  `product_code` varchar(50) DEFAULT NULL,
  `product_fullname` varchar(250) NOT NULL,
  `quantity` decimal(15,5) NOT NULL,
  `observations` text,
  `numeroSerie` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT 'Serial number',
  `numeroImei` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT 'Imei number',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_deliver_items`
--


--
-- Table structure for table `sivir_enterprise`
--

CREATE TABLE `sivir_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) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Enterprise name',
  `owner` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The owner',
  `address` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The address',
  `phones` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The phones',
  `country` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Country',
  `city` tinytext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'City, as a text',
  `photo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT 'Image as attachment',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sivir_enterprise.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_enterprise`
--

INSERT INTO `sivir_enterprise` VALUES ('2a6b2023-c6d0-4916-9921-98c460ae2c72','a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','SURGICALMED','JOSE ALCIDES GASPAR SOLIZ','UNIDAD VECINAL: 50, CALLE: DOCTOR CARLOS ZAMBRANA F., NRO: 40','68582168','Bolivia','Santa Cruz de la Sierra','20250722083740_TOj0XVDsa8139e95-e504-4f5d-866a-8ffe8718bad7.jpeg','A','2025-07-17 11:33:02','2025-07-22 08:37:40');

--
-- Table structure for table `sivir_gift_card`
--

CREATE TABLE `sivir_gift_card` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID Autoincrement',
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch office',
  `gc_group` varchar(50) NOT NULL COMMENT 'The Gift card group for gift card',
  `quantity_generated` int NOT NULL DEFAULT '1' COMMENT 'For the automaticaly generated',
  `gc_serial` varchar(50) NOT NULL COMMENT 'The gift card alphanumeric serial unique',
  `amount` decimal(15,5) NOT NULL DEFAULT '0.00000' COMMENT 'The gift card amount total',
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `expiration_date` date DEFAULT NULL COMMENT 'The expiration date for the gift card',
  `balance` decimal(15,5) NOT NULL DEFAULT '0.00000' COMMENT 'The total balance (El Saldo total)',
  `gc_status` enum('V','E','C','EO') NOT NULL DEFAULT 'V' COMMENT 'V=Valid, E=Expired, C=Cancelled, EO=Employees only',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'The date time, current',
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sivir_gift_card.gc_serial` (`gc_serial`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_gift_card`
--


--
-- Table structure for table `sivir_hotel_room_prices`
--

CREATE TABLE `sivir_hotel_room_prices` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Unique UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch office',
  `room_code` varchar(25) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'ROOM001' COMMENT 'The hotel room code, for the product code on the sell invoice',
  `tipo_habitacion_id` int NOT NULL COMMENT 'Related to catalogs items TIPOHABITACION',
  `product_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL COMMENT 'Related to product ID	',
  `sincode_id` int DEFAULT NULL COMMENT 'related to sivir_products_catalog_in_bolivian table	',
  `sin_code` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `room_capacity` smallint NOT NULL DEFAULT '1',
  `room_price_overnight` decimal(15,5) NOT NULL,
  `room_price_per_extra_person` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `room_price_per_extra_kid` decimal(15,5) DEFAULT NULL,
  `currency_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT '	related to currency table',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_hotel_room_prices`
--


--
-- Table structure for table `sivir_hotel_rules`
--

CREATE TABLE `sivir_hotel_rules` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Unique UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch office',
  `apply_half_dat` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'N' COMMENT 'Always as No',
  `halfday_after_hour` time DEFAULT NULL,
  `halfday_before_hour` time DEFAULT NULL,
  `complete_day_after_hour` time NOT NULL,
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_hotel_rules`
--


--
-- Table structure for table `sivir_mass_mailing`
--

CREATE TABLE `sivir_mass_mailing` (
  `id` int NOT NULL AUTO_INCREMENT,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `event_number` int DEFAULT NULL,
  `invoices` text COMMENT 'Non related, separated by commas',
  `codigo_punto_venta` int DEFAULT NULL COMMENT 'Sellpoint code',
  `zofra` enum('Y','N') DEFAULT 'N' COMMENT 'Its zofra?',
  `tipo_emision` smallint DEFAULT '1' COMMENT '1: Online 2: Offline 3: Masiva',
  `codigoDescripcion` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `codigoEstado` int DEFAULT NULL,
  `codigoRecepcion` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_mass_mailing`
--


--
-- Table structure for table `sivir_notifications`
--

CREATE TABLE `sivir_notifications` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'The unique UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users sid',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch office',
  `notification_flags` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Bitmask of notification preferences',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `global_branch_office_id` (`global_branch_office_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_notifications`
--

INSERT INTO `sivir_notifications` VALUES ('7c9b1a9b-348a-474a-a87c-84f93900e5d9','69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',0,'A','2025-07-17 11:42:56','2025-07-17 11:42:56');

--
-- Table structure for table `sivir_order`
--

CREATE TABLE `sivir_order` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `id` bigint NOT NULL,
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'related to global_branch_office',
  `order_date` date NOT NULL COMMENT 'The current date',
  `order_number` smallint NOT NULL COMMENT 'This number reboots every day',
  `order_type` enum('M','LL','D') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'M' COMMENT 'M=MESA, LL=PARA LLEVAR, D=DELIVERY',
  `order_detail` varchar(250) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL COMMENT 'Detalles de la orden',
  `discount_all_products` decimal(15,5) NOT NULL DEFAULT '0.00000' COMMENT 'The sum for all products discount',
  `total` decimal(15,5) NOT NULL,
  `currency_id` int NOT NULL COMMENT 'related to currency table',
  `order_status` enum('P','PP','E','C') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'P' COMMENT 'P=Pendiente\r\nPP=Preparacion\r\nE=Entregado\r\nC=Cancelado',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sell_point.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_order`
--


--
-- Table structure for table `sivir_order_sold`
--

CREATE TABLE `sivir_order_sold` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'related to branch table',
  `provisional` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL COMMENT ' The provisional uuid for the sale ',
  `order_id` bigint DEFAULT NULL COMMENT 'related to sivir_order table',
  `product_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'related to product table',
  `product_code` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `product_fullname` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `with_ingredients` varchar(250) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `without_ingredients` varchar(250) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `price` decimal(15,5) NOT NULL,
  `quantity` decimal(15,5) NOT NULL,
  `total_price` decimal(15,5) NOT NULL,
  `discount` decimal(15,5) DEFAULT '0.00000',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sivir_products_price.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_order_sold`
--


--
-- Table structure for table `sivir_payment_way`
--

CREATE TABLE `sivir_payment_way` (
  `id` int NOT NULL AUTO_INCREMENT,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `payment_id` int NOT NULL COMMENT 'Related to catalogs items (PAYMENT)',
  `multiple` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'Multiple payment or single payment (N means single)',
  `payments_related` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The payments number, separated by comma, related to catalogs items (PAYMENT)',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=307 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_payment_way`
--

INSERT INTO `sivir_payment_way` VALUES (1,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',1,'N','1','A','2025-07-17 00:00:00',NULL),(2,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',2,'N','2','A','2025-07-17 00:00:00',NULL),(3,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',3,'N','3','A','2025-07-17 00:00:00',NULL),(4,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',4,'N','4','A','2025-07-17 00:00:00',NULL),(5,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',5,'N','5','A','2025-07-17 00:00:00',NULL),(6,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',6,'N','6','A','2025-07-17 00:00:00',NULL),(7,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',7,'N','7','A','2025-07-17 00:00:00',NULL),(8,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',8,'N','8','A','2025-07-17 00:00:00',NULL),(9,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',9,'N','9','A','2025-07-17 00:00:00',NULL),(10,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',10,'Y','1,2','A','2025-07-17 00:00:00',NULL),(11,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',11,'Y','1,3','A','2025-07-17 00:00:00',NULL),(12,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',12,'Y','1,4','A','2025-07-17 00:00:00',NULL),(13,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',13,'Y','1,7','A','2025-07-17 00:00:00',NULL),(14,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',14,'Y','1,8','A','2025-07-17 00:00:00',NULL),(15,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',15,'Y','1,9','A','2025-07-17 00:00:00',NULL),(16,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',16,'Y','2,3','A','2025-07-17 00:00:00',NULL),(17,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',17,'Y','2,4','A','2025-07-17 00:00:00',NULL),(18,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',18,'Y','2,7','A','2025-07-17 00:00:00',NULL),(19,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',19,'Y','2,8','A','2025-07-17 00:00:00',NULL),(20,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',20,'Y','2,9','A','2025-07-17 00:00:00',NULL),(21,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',21,'Y','4,7','A','2025-07-17 00:00:00',NULL),(22,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',22,'Y','4,8','A','2025-07-17 00:00:00',NULL),(23,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',23,'Y','4,9','A','2025-07-17 00:00:00',NULL),(24,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',24,'Y','7,8','A','2025-07-17 00:00:00',NULL),(25,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',25,'Y','7,9','A','2025-07-17 00:00:00',NULL),(26,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',26,'Y','8,9','A','2025-07-17 00:00:00',NULL),(27,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',27,'N','27','A','2025-07-17 00:00:00',NULL),(28,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',30,'Y','27,5','A','2025-07-17 00:00:00',NULL),(29,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',31,'N','31','A','2025-07-17 00:00:00',NULL),(30,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',32,'N','32','A','2025-07-17 00:00:00',NULL),(31,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',33,'N','33','A','2025-07-17 00:00:00',NULL),(32,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',34,'Y','1,6','A','2025-07-17 00:00:00',NULL),(33,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',35,'Y','1,27','A','2025-07-17 00:00:00',NULL),(34,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',36,'Y','1,31','A','2025-07-17 00:00:00',NULL),(35,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',37,'Y','1,32','A','2025-07-17 00:00:00',NULL),(36,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',38,'Y','1,33','A','2025-07-17 00:00:00',NULL),(37,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',39,'Y','2,6','A','2025-07-17 00:00:00',NULL),(38,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',40,'Y','2,27','A','2025-07-17 00:00:00',NULL),(39,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',41,'Y','2,31','A','2025-07-17 00:00:00',NULL),(40,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',42,'Y','2,32','A','2025-07-17 00:00:00',NULL),(41,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',43,'Y','2,33','A','2025-07-17 00:00:00',NULL),(42,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',44,'Y','3,4','A','2025-07-17 00:00:00',NULL),(43,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',45,'Y','3,6','A','2025-07-17 00:00:00',NULL),(44,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',46,'Y','3,7','A','2025-07-17 00:00:00',NULL),(45,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',47,'Y','3,8','A','2025-07-17 00:00:00',NULL),(46,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',48,'Y','3,9','A','2025-07-17 00:00:00',NULL),(47,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',49,'Y','3,27','A','2025-07-17 00:00:00',NULL),(48,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',50,'Y','3,31','A','2025-07-17 00:00:00',NULL),(49,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',51,'Y','3,32','A','2025-07-17 00:00:00',NULL),(50,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',52,'Y','3,33','A','2025-07-17 00:00:00',NULL),(51,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',53,'Y','4,27','A','2025-07-17 00:00:00',NULL),(52,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',54,'Y','4,31','A','2025-07-17 00:00:00',NULL),(53,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',55,'Y','4,32','A','2025-07-17 00:00:00',NULL),(54,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',56,'Y','4,33','A','2025-07-17 00:00:00',NULL),(55,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',57,'Y','6,7','A','2025-07-17 00:00:00',NULL),(56,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',58,'Y','6,8','A','2025-07-17 00:00:00',NULL),(57,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',59,'Y','6,9','A','2025-07-17 00:00:00',NULL),(58,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',60,'Y','6,27','A','2025-07-17 00:00:00',NULL),(59,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',61,'Y','6,31','A','2025-07-17 00:00:00',NULL),(60,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',62,'Y','6,32','A','2025-07-17 00:00:00',NULL),(61,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',63,'Y','6,33','A','2025-07-17 00:00:00',NULL),(62,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',64,'Y','7,27','A','2025-07-17 00:00:00',NULL),(63,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',65,'Y','7,31','A','2025-07-17 00:00:00',NULL),(64,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',66,'Y','7,32','A','2025-07-17 00:00:00',NULL),(65,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',67,'Y','7,33','A','2025-07-17 00:00:00',NULL),(66,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',68,'Y','8,27','A','2025-07-17 00:00:00',NULL),(67,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',69,'Y','8,31','A','2025-07-17 00:00:00',NULL),(68,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',70,'Y','8,32','A','2025-07-17 00:00:00',NULL),(69,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',71,'Y','8,33','A','2025-07-17 00:00:00',NULL),(70,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',72,'Y','9,27','A','2025-07-17 00:00:00',NULL),(71,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',73,'Y','9,31','A','2025-07-17 00:00:00',NULL),(72,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',74,'Y','9,32','A','2025-07-17 00:00:00',NULL),(73,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',75,'Y','9,33','A','2025-07-17 00:00:00',NULL),(74,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',76,'Y','27,31','A','2025-07-17 00:00:00',NULL),(75,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',77,'Y','27,32','A','2025-07-17 00:00:00',NULL),(76,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',78,'Y','27,33','A','2025-07-17 00:00:00',NULL),(77,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',79,'Y','31,32','A','2025-07-17 00:00:00',NULL),(78,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',80,'Y','31,33','A','2025-07-17 00:00:00',NULL),(79,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',81,'Y','32,33','A','2025-07-17 00:00:00',NULL),(80,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',82,'Y','1,2,6','A','2025-07-17 00:00:00',NULL),(81,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',83,'Y','1,2,7','A','2025-07-17 00:00:00',NULL),(82,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',84,'Y','1,2,8','A','2025-07-17 00:00:00',NULL),(83,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',85,'Y','1,2,9','A','2025-07-17 00:00:00',NULL),(84,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',86,'Y','1,2,27','A','2025-07-17 00:00:00',NULL),(85,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',87,'Y','1,2,31','A','2025-07-17 00:00:00',NULL),(86,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',88,'Y','1,2,32','A','2025-07-17 00:00:00',NULL),(87,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',89,'Y','1,2,33','A','2025-07-17 00:00:00',NULL),(88,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',90,'Y','1,3,6','A','2025-07-17 00:00:00',NULL),(89,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',91,'Y','1,3,7','A','2025-07-17 00:00:00',NULL),(90,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',92,'Y','1,3,8','A','2025-07-17 00:00:00',NULL),(91,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',93,'Y','1,3,9','A','2025-07-17 00:00:00',NULL),(92,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',94,'Y','1,3,27','A','2025-07-17 00:00:00',NULL),(93,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',95,'Y','1,3,31','A','2025-07-17 00:00:00',NULL),(94,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',96,'Y','1,3,32','A','2025-07-17 00:00:00',NULL),(95,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',97,'Y','1,3,33','A','2025-07-17 00:00:00',NULL),(96,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',98,'Y','1,4,6','A','2025-07-17 00:00:00',NULL),(97,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',99,'Y','1,4,7','A','2025-07-17 00:00:00',NULL),(98,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',100,'Y','1,4,8','A','2025-07-17 00:00:00',NULL),(99,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',101,'Y','1,4,9','A','2025-07-17 00:00:00',NULL),(100,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',102,'Y','1,4,27','A','2025-07-17 00:00:00',NULL),(101,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',103,'Y','1,4,31','A','2025-07-17 00:00:00',NULL),(102,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',104,'Y','1,4,32','A','2025-07-17 00:00:00',NULL),(103,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',105,'Y','1,4,33','A','2025-07-17 00:00:00',NULL),(104,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',106,'Y','1,6,7','A','2025-07-17 00:00:00',NULL),(105,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',107,'Y','1,6,8','A','2025-07-17 00:00:00',NULL),(106,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',108,'Y','1,6,9','A','2025-07-17 00:00:00',NULL),(107,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',109,'Y','1,6,27','A','2025-07-17 00:00:00',NULL),(108,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',110,'Y','1,6,31','A','2025-07-17 00:00:00',NULL),(109,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',111,'Y','1,6,32','A','2025-07-17 00:00:00',NULL),(110,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',112,'Y','1,6,33','A','2025-07-17 00:00:00',NULL),(111,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',113,'Y','1,7,8','A','2025-07-17 00:00:00',NULL),(112,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',114,'Y','1,7,9','A','2025-07-17 00:00:00',NULL),(113,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',115,'Y','1,7,27','A','2025-07-17 00:00:00',NULL),(114,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',116,'Y','1,7,31','A','2025-07-17 00:00:00',NULL),(115,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',117,'Y','1,7,32','A','2025-07-17 00:00:00',NULL),(116,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',118,'Y','1,7,33','A','2025-07-17 00:00:00',NULL),(117,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',119,'Y','1,8,9','A','2025-07-17 00:00:00',NULL),(118,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',120,'Y','1,8,27','A','2025-07-17 00:00:00',NULL),(119,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',121,'Y','1,8,31','A','2025-07-17 00:00:00',NULL),(120,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',122,'Y','1,8,32','A','2025-07-17 00:00:00',NULL),(121,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',123,'Y','1,8,33','A','2025-07-17 00:00:00',NULL),(122,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',124,'Y','1,9,27','A','2025-07-17 00:00:00',NULL),(123,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',125,'Y','1,9,31','A','2025-07-17 00:00:00',NULL),(124,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',126,'Y','1,9,32','A','2025-07-17 00:00:00',NULL),(125,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',127,'Y','1,9,33','A','2025-07-17 00:00:00',NULL),(126,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',128,'Y','1,27,31','A','2025-07-17 00:00:00',NULL),(127,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',129,'Y','1,27,32','A','2025-07-17 00:00:00',NULL),(128,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',130,'Y','1,27,33','A','2025-07-17 00:00:00',NULL),(129,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',131,'Y','1,31,32','A','2025-07-17 00:00:00',NULL),(130,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',132,'Y','1,31,33','A','2025-07-17 00:00:00',NULL),(131,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',133,'Y','1,32,33','A','2025-07-17 00:00:00',NULL),(132,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',134,'Y','2,3,6','A','2025-07-17 00:00:00',NULL),(133,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',135,'Y','2,3,7','A','2025-07-17 00:00:00',NULL),(134,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',136,'Y','2,3,8','A','2025-07-17 00:00:00',NULL),(135,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',137,'Y','2,3,9','A','2025-07-17 00:00:00',NULL),(136,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',138,'Y','2,3,27','A','2025-07-17 00:00:00',NULL),(137,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',139,'Y','2,3,31','A','2025-07-17 00:00:00',NULL),(138,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',140,'Y','2,3,32','A','2025-07-17 00:00:00',NULL),(139,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',141,'Y','2,3,33','A','2025-07-17 00:00:00',NULL),(140,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',142,'Y','2,4,6','A','2025-07-17 00:00:00',NULL),(141,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',143,'Y','2,4,7','A','2025-07-17 00:00:00',NULL),(142,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',144,'Y','2,4,8','A','2025-07-17 00:00:00',NULL),(143,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',145,'Y','2,4,9','A','2025-07-17 00:00:00',NULL),(144,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',146,'Y','2,4,27','A','2025-07-17 00:00:00',NULL),(145,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',147,'Y','2,4,31','A','2025-07-17 00:00:00',NULL),(146,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',148,'Y','2,4,32','A','2025-07-17 00:00:00',NULL),(147,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',149,'Y','2,4,33','A','2025-07-17 00:00:00',NULL),(148,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',150,'Y','2,6,7','A','2025-07-17 00:00:00',NULL),(149,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',151,'Y','2,6,8','A','2025-07-17 00:00:00',NULL),(150,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',152,'Y','2,6,9','A','2025-07-17 00:00:00',NULL),(151,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',153,'Y','2,6,27','A','2025-07-17 00:00:00',NULL),(152,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',154,'Y','2,6,31','A','2025-07-17 00:00:00',NULL),(153,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',155,'Y','2,6,32','A','2025-07-17 00:00:00',NULL),(154,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',156,'Y','2,6,33','A','2025-07-17 00:00:00',NULL),(155,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',157,'Y','2,7,8','A','2025-07-17 00:00:00',NULL),(156,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',158,'Y','2,7,9','A','2025-07-17 00:00:00',NULL),(157,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',159,'Y','2,7,27','A','2025-07-17 00:00:00',NULL),(158,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',160,'Y','2,7,31','A','2025-07-17 00:00:00',NULL),(159,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',161,'Y','2,7,32','A','2025-07-17 00:00:00',NULL),(160,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',162,'Y','2,7,33','A','2025-07-17 00:00:00',NULL),(161,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',163,'Y','2,8,9','A','2025-07-17 00:00:00',NULL),(162,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',164,'Y','2,8,27','A','2025-07-17 00:00:00',NULL),(163,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',165,'Y','2,8,31','A','2025-07-17 00:00:00',NULL),(164,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',166,'Y','2,8,32','A','2025-07-17 00:00:00',NULL),(165,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',167,'Y','2,8,33','A','2025-07-17 00:00:00',NULL),(166,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',168,'Y','2,9,27','A','2025-07-17 00:00:00',NULL),(167,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',169,'Y','2,9,31','A','2025-07-17 00:00:00',NULL),(168,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',170,'Y','2,9,32','A','2025-07-17 00:00:00',NULL),(169,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',171,'Y','2,9,33','A','2025-07-17 00:00:00',NULL),(170,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',172,'Y','2,27,31','A','2025-07-17 00:00:00',NULL),(171,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',173,'Y','2,27,32','A','2025-07-17 00:00:00',NULL),(172,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',174,'Y','2,27,33','A','2025-07-17 00:00:00',NULL),(173,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',175,'Y','2,31,32','A','2025-07-17 00:00:00',NULL),(174,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',176,'Y','2,31,33','A','2025-07-17 00:00:00',NULL),(175,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',177,'Y','2,32,33','A','2025-07-17 00:00:00',NULL),(176,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',178,'Y','3,4,6','A','2025-07-17 00:00:00',NULL),(177,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',179,'Y','3,4,7','A','2025-07-17 00:00:00',NULL),(178,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',180,'Y','3,4,8','A','2025-07-17 00:00:00',NULL),(179,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',181,'Y','3,4,9','A','2025-07-17 00:00:00',NULL),(180,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',182,'Y','3,4,27','A','2025-07-17 00:00:00',NULL),(181,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',183,'Y','3,4,31','A','2025-07-17 00:00:00',NULL),(182,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',184,'Y','3,4,32','A','2025-07-17 00:00:00',NULL),(183,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',185,'Y','3,4,33','A','2025-07-17 00:00:00',NULL),(184,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',186,'Y','3,6,7','A','2025-07-17 00:00:00',NULL),(185,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',187,'Y','3,6,8','A','2025-07-17 00:00:00',NULL),(186,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',188,'Y','3,6,9','A','2025-07-17 00:00:00',NULL),(187,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',189,'Y','3,6,27','A','2025-07-17 00:00:00',NULL),(188,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',190,'Y','3,6,31','A','2025-07-17 00:00:00',NULL),(189,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',191,'Y','3,6,32','A','2025-07-17 00:00:00',NULL),(190,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',192,'Y','3,6,33','A','2025-07-17 00:00:00',NULL),(191,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',193,'Y','3,7,8','A','2025-07-17 00:00:00',NULL),(192,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',194,'Y','3,7,9','A','2025-07-17 00:00:00',NULL),(193,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',195,'Y','3,7,27','A','2025-07-17 00:00:00',NULL),(194,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',196,'Y','3,7,31','A','2025-07-17 00:00:00',NULL),(195,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',197,'Y','3,7,32','A','2025-07-17 00:00:00',NULL),(196,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',198,'Y','3,7,33','A','2025-07-17 00:00:00',NULL),(197,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',199,'Y','3,8,9','A','2025-07-17 00:00:00',NULL),(198,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',200,'Y','3,8,27','A','2025-07-17 00:00:00',NULL),(199,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',201,'Y','3,8,31','A','2025-07-17 00:00:00',NULL),(200,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',202,'Y','3,8,32','A','2025-07-17 00:00:00',NULL),(201,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',203,'Y','3,8,33','A','2025-07-17 00:00:00',NULL),(202,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',204,'Y','3,9,27','A','2025-07-17 00:00:00',NULL),(203,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',205,'Y','3,9,31','A','2025-07-17 00:00:00',NULL),(204,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',206,'Y','3,9,32','A','2025-07-17 00:00:00',NULL),(205,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',207,'Y','3,9,33','A','2025-07-17 00:00:00',NULL),(206,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',208,'Y','3,27,31','A','2025-07-17 00:00:00',NULL),(207,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',209,'Y','3,27,32','A','2025-07-17 00:00:00',NULL),(208,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',210,'Y','3,27,33','A','2025-07-17 00:00:00',NULL),(209,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',211,'Y','3,31,32','A','2025-07-17 00:00:00',NULL),(210,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',212,'Y','3,31,33','A','2025-07-17 00:00:00',NULL),(211,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',213,'Y','3,32,33','A','2025-07-17 00:00:00',NULL),(212,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',214,'Y','4,9,7','A','2025-07-17 00:00:00',NULL),(213,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',215,'Y','4,9,8','A','2025-07-17 00:00:00',NULL),(214,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',216,'Y','4,9,9','A','2025-07-17 00:00:00',NULL),(215,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',217,'Y','4,9,27','A','2025-07-17 00:00:00',NULL),(216,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',218,'Y','4,9,31','A','2025-07-17 00:00:00',NULL),(217,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',219,'Y','4,9,32','A','2025-07-17 00:00:00',NULL),(218,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',220,'Y','4,9,33','A','2025-07-17 00:00:00',NULL),(219,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',221,'Y','4,27,8','A','2025-07-17 00:00:00',NULL),(220,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',222,'Y','4,27,9','A','2025-07-17 00:00:00',NULL),(221,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',223,'Y','4,27,27','A','2025-07-17 00:00:00',NULL),(222,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',224,'Y','4,27,31','A','2025-07-17 00:00:00',NULL),(223,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',225,'Y','4,27,32','A','2025-07-17 00:00:00',NULL),(224,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',226,'Y','4,27,33','A','2025-07-17 00:00:00',NULL),(225,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',227,'Y','4,31,9','A','2025-07-17 00:00:00',NULL),(226,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',228,'Y','4,31,27','A','2025-07-17 00:00:00',NULL),(227,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',229,'Y','4,31,31','A','2025-07-17 00:00:00',NULL),(228,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',230,'Y','4,31,32','A','2025-07-17 00:00:00',NULL),(229,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',231,'Y','4,31,33','A','2025-07-17 00:00:00',NULL),(230,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',232,'Y','4,32,27','A','2025-07-17 00:00:00',NULL),(231,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',233,'Y','4,32,31','A','2025-07-17 00:00:00',NULL),(232,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',234,'Y','4,32,32','A','2025-07-17 00:00:00',NULL),(233,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',235,'Y','4,32,33','A','2025-07-17 00:00:00',NULL),(234,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',236,'Y','4,33,31','A','2025-07-17 00:00:00',NULL),(235,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',237,'Y','4,33,32','A','2025-07-17 00:00:00',NULL),(236,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',238,'Y','4,33,33','A','2025-07-17 00:00:00',NULL),(237,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',239,'Y','6,7,8','A','2025-07-17 00:00:00',NULL),(238,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',240,'Y','6,7,9','A','2025-07-17 00:00:00',NULL),(239,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',241,'Y','6,7,27','A','2025-07-17 00:00:00',NULL),(240,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',242,'Y','6,7,31','A','2025-07-17 00:00:00',NULL),(241,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',243,'Y','6,7,32','A','2025-07-17 00:00:00',NULL),(242,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',244,'Y','6,7,33','A','2025-07-17 00:00:00',NULL),(243,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',245,'Y','6,8,9','A','2025-07-17 00:00:00',NULL),(244,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',246,'Y','6,8,27','A','2025-07-17 00:00:00',NULL),(245,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',247,'Y','6,8,31','A','2025-07-17 00:00:00',NULL),(246,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',248,'Y','6,8,32','A','2025-07-17 00:00:00',NULL),(247,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',249,'Y','6,8,33','A','2025-07-17 00:00:00',NULL),(248,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',250,'Y','6,9,27','A','2025-07-17 00:00:00',NULL),(249,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',251,'Y','6,9,31','A','2025-07-17 00:00:00',NULL),(250,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',252,'Y','6,9,32','A','2025-07-17 00:00:00',NULL),(251,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',253,'Y','6,9,33','A','2025-07-17 00:00:00',NULL),(252,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',254,'Y','6,27,31','A','2025-07-17 00:00:00',NULL),(253,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',255,'Y','6,27,32','A','2025-07-17 00:00:00',NULL),(254,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',256,'Y','6,27,33','A','2025-07-17 00:00:00',NULL),(255,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',257,'Y','6,31,32','A','2025-07-17 00:00:00',NULL),(256,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',258,'Y','6,31,33','A','2025-07-17 00:00:00',NULL),(257,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',259,'Y','6,32,33','A','2025-07-17 00:00:00',NULL),(258,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',260,'Y','7,8,9','A','2025-07-17 00:00:00',NULL),(259,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',261,'Y','7,8,27','A','2025-07-17 00:00:00',NULL),(260,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',262,'Y','7,8,31','A','2025-07-17 00:00:00',NULL),(261,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',263,'Y','7,8,32','A','2025-07-17 00:00:00',NULL),(262,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',264,'Y','7,8,33','A','2025-07-17 00:00:00',NULL),(263,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',265,'Y','7,9,27','A','2025-07-17 00:00:00',NULL),(264,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',266,'Y','7,9,31','A','2025-07-17 00:00:00',NULL),(265,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',267,'Y','7,9,32','A','2025-07-17 00:00:00',NULL),(266,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',268,'Y','7,9,33','A','2025-07-17 00:00:00',NULL),(267,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',269,'Y','7,27,31','A','2025-07-17 00:00:00',NULL),(268,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',270,'Y','7,27,32','A','2025-07-17 00:00:00',NULL),(269,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',271,'Y','7,27,33','A','2025-07-17 00:00:00',NULL),(270,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',272,'Y','7,31,32','A','2025-07-17 00:00:00',NULL),(271,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',273,'Y','7,31,33','A','2025-07-17 00:00:00',NULL),(272,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',274,'Y','7,32,33','A','2025-07-17 00:00:00',NULL),(273,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',275,'Y','8,9,27','A','2025-07-17 00:00:00',NULL),(274,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',276,'Y','8,9,31','A','2025-07-17 00:00:00',NULL),(275,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',277,'Y','8,9,32','A','2025-07-17 00:00:00',NULL),(276,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',278,'Y','8,9,33','A','2025-07-17 00:00:00',NULL),(277,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',279,'Y','8,27,31','A','2025-07-17 00:00:00',NULL),(278,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',280,'Y','8,27,32','A','2025-07-17 00:00:00',NULL),(279,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',281,'Y','8,27,33','A','2025-07-17 00:00:00',NULL),(280,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',282,'Y','8,31,32','A','2025-07-17 00:00:00',NULL),(281,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',283,'Y','8,31,33','A','2025-07-17 00:00:00',NULL),(282,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',284,'Y','8,32,33','A','2025-07-17 00:00:00',NULL),(283,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',285,'Y','9,27,31','A','2025-07-17 00:00:00',NULL),(284,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',286,'Y','9,27,32','A','2025-07-17 00:00:00',NULL),(285,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',287,'Y','9,27,33','A','2025-07-17 00:00:00',NULL),(286,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',288,'Y','9,31,32','A','2025-07-17 00:00:00',NULL),(287,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',289,'Y','9,31,33','A','2025-07-17 00:00:00',NULL),(288,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',290,'Y','9,32,33','A','2025-07-17 00:00:00',NULL),(289,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',291,'Y','27,31,32','A','2025-07-17 00:00:00',NULL),(290,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',292,'Y','27,31,33','A','2025-07-17 00:00:00',NULL),(291,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',293,'Y','27,32,33','A','2025-07-17 00:00:00',NULL),(292,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',294,'Y','31,32,33','A','2025-07-17 00:00:00',NULL),(293,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',295,'N','295','A','2025-07-17 00:00:00',NULL),(294,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',296,'Y','295,1','A','2025-07-17 00:00:00',NULL),(295,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',297,'Y','295,2','A','2025-07-17 00:00:00',NULL),(296,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',298,'Y','295,3','A','2025-07-17 00:00:00',NULL),(297,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',299,'Y','295,4','A','2025-07-17 00:00:00',NULL),(298,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',300,'Y','295,6','A','2025-07-17 00:00:00',NULL),(299,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',301,'Y','295,7','A','2025-07-17 00:00:00',NULL),(300,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',302,'Y','295,8','A','2025-07-17 00:00:00',NULL),(301,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',303,'Y','295,9','A','2025-07-17 00:00:00',NULL),(302,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',304,'Y','295,27','A','2025-07-17 00:00:00',NULL),(303,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',305,'Y','295,31','A','2025-07-17 00:00:00',NULL),(304,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',306,'Y','295,32','A','2025-07-17 00:00:00',NULL),(305,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',307,'Y','295,33','A','2025-07-17 00:00:00',NULL),(306,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f',308,'Y','295,5','A','2025-07-17 00:00:00',NULL);

--
-- Table structure for table `sivir_products`
--

CREATE TABLE `sivir_products` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT '	related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'related to global_branch_office',
  `product_kind` enum('PCV','PCV0','IAF','PSF','DOC') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'PCV' COMMENT 'PCV = Regular product with inventory  Task actions \r\n\r\n        \r\n      \r\n PCV0 = Special product without inventory  Task actions \r\n\r\n        \r\n      \r\n IAF = Regular product with inventory but cant sell, PSF=Producto sin factura\r\n\r\nDOC = Documents',
  `fullname` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `description` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `code` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `psychotropic` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'N',
  `medical_prescription` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'N' COMMENT 'If, requires a medical prescription',
  `category_id` int NOT NULL COMMENT 'Related to Catalogs item, catalog code = CATEGORY',
  `subcategory_id` int DEFAULT NULL COMMENT 'Related to Catalogs item = CATEGORY | SUBCATEGORY	',
  `brand_id` int NOT NULL COMMENT 'Related to catalogs items = BRAND',
  `images` text CHARACTER SET latin1 COLLATE latin1_swedish_ci COMMENT 'Max 5 images, Many URL separated by | on each data',
  `barcode` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `commission` decimal(10,5) DEFAULT NULL COMMENT 'The commission',
  `commission_type` enum('#','%') CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT '%',
  `year` year DEFAULT NULL COMMENT 'The 4 digits year',
  `period` tinytext CHARACTER SET latin1 COLLATE latin1_general_ci COMMENT 'The period like (January)',
  `volume` tinytext CHARACTER SET latin1 COLLATE latin1_general_ci COMMENT 'The volume',
  `leaves` smallint DEFAULT NULL COMMENT 'The leaves count like (16)',
  `enabled` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Y' COMMENT 'Enable the product',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_products`
--


--
-- Table structure for table `sivir_products_assistant`
--

CREATE TABLE `sivir_products_assistant` (
  `id` int NOT NULL AUTO_INCREMENT,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to catalogs = BRANCH',
  `provisional` varchar(50) DEFAULT NULL,
  `product_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'Related to product table',
  `assistant_id` smallint NOT NULL COMMENT 'Related to catalogs = ASSISTANT	',
  `specification` varchar(200) NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_products_assistant`
--


--
-- Table structure for table `sivir_products_catalog_in_bolivian`
--

CREATE TABLE `sivir_products_catalog_in_bolivian` (
  `id` int NOT NULL AUTO_INCREMENT,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users sid',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `codigo_producto` varchar(50) NOT NULL,
  `codigo_actividad` varchar(50) NOT NULL,
  `producto` text NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_products_catalog_in_bolivian`
--

INSERT INTO `sivir_products_catalog_in_bolivian` VALUES (1,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1003655','4772100','preparados farmacéuticos para uso médico como: ampollas, tabletas, cápsulas, ungüentos, polvos y soluciones.','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(2,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001479','4772100','Ácido acetilsalicílico-aspirina','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(3,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001480','4772100','Salicilato de metilo','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(4,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001481','4772100','Ácido salicílico','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(5,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001482','4772100','Lisina y compuestos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(6,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001483','4772100','Ácido glutámico y sus sales','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(7,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001484','4772100','Lecitina y otros animolípidos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(8,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001485','4772100','Amidas acíclicas','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(9,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001486','4772100','Amidas cíclicas','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(10,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001487','4772100','Lactonas y compuestos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(11,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001488','4772100','Hidantoina y compuestos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(12,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001489','4772100','Sulfonamidas','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(13,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001490','4772100','Provitaminas y vitaminas','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(14,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001491','4772100','Productos farmacéuticos hormonales','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(15,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001492','4772100','Azúcares químicamente puros','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(16,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001493','4772100','Productos farmacéuticos homeopáticos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(17,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001494','4772100','Productos farmacéuticos antiinflamatorios','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(18,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001495','4772100','Productos farmacéuticos antiinfecciosos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(19,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001496','4772100','Productos farmacéuticos antisépticos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(20,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001497','4772100','Productos farmacéuticos antivirales','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(21,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001498','4772100','Productos farmacéuticos antigripales','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(22,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001499','4772100','Productos farmacéuticos antiespasmódicos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(23,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001500','4772100','Productos farmacéuticos antialérgicos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(24,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001501','4772100','Productos farmacéuticos ginecológicos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(25,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001502','4772100','Productos farmacéuticos antitusivos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(26,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001503','4772100','Productos farmacéuticos dermatológicos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(27,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001504','4772100','Productos farmacéuticos metabólicos (digestivos)','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(28,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001505','4772100','Productos farmacéuticos para el sistema nerviosos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(29,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001506','4772100','Productos farmacéuticos para los sentidos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(30,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001507','4772100','Productos farmacéuticos antiparasitarios','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(31,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001508','4772100','Productos farmacéuticos antireumáticos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(32,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001509','4772100','Agua estéril para inyectables','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(33,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001510','4772100','Endulzantes sintéticos y edulcorantes','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(34,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001511','4772100','Coagulantes microbianos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(35,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001512','4772100','Productos farmacéuticos, para uso veterinario','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(36,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001513','4772100','Productos farmacéuticos anticonceptivos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(37,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001514','4772100','Sueros y plasma','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(38,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001516','4772100','Vacunas','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(39,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001517','4772100','Interferones','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(40,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001518','4772100','Apósitos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(41,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001519','4772100','Algodón esterilizado','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(42,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001520','4772100','Jarabes medicinales','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(43,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001521','4772100','Veneno de serpientes','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(44,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001522','4772100','Medicamentos anestésicos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(45,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001524','4772100','Parche transdérmico','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(46,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001525','4772100','Vendas adhesivas','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(47,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001526','4772100','Suturas quirúrgicas','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(48,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001527','4772100','Botiquines de emergencia','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(49,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001528','4772100','Cemento para prótesis dental','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(50,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001529','4772100','Amalgamas para prótesis dental','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(51,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001530','4772100','Metales para prótesis dental','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(52,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001531','4772100','Pomadas y ungüentos medicinales','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(53,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001532','4772100','Gasa','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(54,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001533','4772100','Antibióticos','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(55,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001534','4772100','cementos para la reconstrucción de huesos.','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(56,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001535','4772100','pruebas de embarazo.','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(57,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001536','4772100','azúcares químicamente puros.','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(58,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001537','4772100','productos endocrinos y extractos endocrinos.','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(59,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001538','4772100','hilo de sutura quirúrgica.','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(60,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1001539','4772100','productos de biotecnología.','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(61,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1003223','4772100','Productos para el cuidado de Piel','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(62,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1003224','4772100','Productos para el cuidado Oral','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(63,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1003225','4772100','Leche de fórmula.','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(64,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1003226','4772100','Pañales desechables y toallitas húmedas.','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(65,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1003227','4772100','Descongestionantes nasales.','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(66,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1003228','4772100','Expectorantes.','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(67,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1003229','4772100','Sprays nasales y aerosoles para la tos.','A','2025-07-17 11:43:43','2025-07-17 11:43:43'),(68,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','1003230','4772100','Productos para la higiene íntima femenina (toallitas, geles, desodorantes íntimos).','A','2025-07-17 11:43:43','2025-07-17 11:43:43');

--
-- Table structure for table `sivir_products_code_approved`
--

CREATE TABLE `sivir_products_code_approved` (
  `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',
  `product_id` varchar(50) NOT NULL COMMENT 'Related to products relative',
  `sincode_id` varchar(50) NOT NULL COMMENT 'related to sivir_products_catalog_in_bolivian table',
  `sin_code` varchar(50) NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sivir_products_code_aapproved.relative` (`relative`),
  UNIQUE KEY `product_id` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_products_code_approved`
--


--
-- Table structure for table `sivir_products_deleted`
--

CREATE TABLE `sivir_products_deleted` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Unique UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'The branch office',
  `product_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to product ID',
  `reason` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_products_deleted`
--


--
-- Table structure for table `sivir_products_discount`
--

CREATE TABLE `sivir_products_discount` (
  `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 global_branch_office',
  `groupby` enum('*','C','P') NOT NULL DEFAULT '*' COMMENT 'Group by',
  `category_id` int DEFAULT NULL COMMENT 'category from catalogs items',
  `product_id` varchar(50) DEFAULT NULL COMMENT 'related to products table',
  `limited_time` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'yes or no',
  `starts_date` date DEFAULT NULL,
  `ends_date` date DEFAULT NULL,
  `kind` enum('T','VA') CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL COMMENT 'T = Total\r\nVA = Valor agregado',
  `math` enum('#','%') NOT NULL DEFAULT '%' COMMENT '#=Descuento numeral %=Descuento porcentual',
  `discount` decimal(10,5) NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_products_discount`
--


--
-- Table structure for table `sivir_products_kardex`
--

CREATE TABLE `sivir_products_kardex` (
  `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 global_branch_office	',
  `product_id` varchar(50) NOT NULL COMMENT 'related to products table	',
  `iet` enum('I','E','T') NOT NULL DEFAULT 'E',
  `quantity` decimal(15,5) NOT NULL,
  `measurement_id` int NOT NULL COMMENT 'Related to Catalogs',
  `detail` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `global_kardex.relative` (`relative`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_products_kardex`
--


--
-- Table structure for table `sivir_products_lot`
--

CREATE TABLE `sivir_products_lot` (
  `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 global_branch_office',
  `product_id` varchar(50) NOT NULL COMMENT 'related to products table',
  `warehouse_id` varchar(50) NOT NULL COMMENT 'Related to warehouse table',
  `physical_location` mediumtext,
  `lot` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `measurement_id` int NOT NULL COMMENT 'Related to catalogs prod (MEASUREMENT)',
  `initial_quantity` decimal(10,2) NOT NULL,
  `quantity` decimal(10,2) NOT NULL,
  `unit_cost` decimal(15,5) NOT NULL,
  `currency_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT 'Related to global currency',
  `total_price` decimal(15,5) NOT NULL,
  `expires` enum('Y','N') NOT NULL DEFAULT 'N',
  `expiration_date` date DEFAULT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_products_lot`
--


--
-- Table structure for table `sivir_products_lot_history`
--

CREATE TABLE `sivir_products_lot_history` (
  `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 global_branch_office',
  `product_id` varchar(50) NOT NULL COMMENT 'related to products table',
  `warehouse_id` varchar(50) NOT NULL COMMENT 'Related to warehouse table',
  `physical_location` text,
  `lot` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `measurement_id` int NOT NULL COMMENT 'Related to catalogs prod (MEASUREMENT)',
  `quantity` decimal(10,2) NOT NULL,
  `unit_cost` decimal(15,5) NOT NULL,
  `currency_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT 'Related to global currency',
  `total_price` decimal(15,5) NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_products_lot_history`
--


--
-- Table structure for table `sivir_products_price`
--

CREATE TABLE `sivir_products_price` (
  `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 table',
  `product_id` varchar(50) NOT NULL COMMENT 'related to product table',
  `price` decimal(15,5) NOT NULL,
  `currency_id` varchar(50) 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,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sivir_products_price.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_products_price`
--


--
-- Table structure for table `sivir_products_price_history`
--

CREATE TABLE `sivir_products_price_history` (
  `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 table',
  `product_id` varchar(50) NOT NULL COMMENT 'related to product table',
  `price` decimal(15,5) NOT NULL,
  `currency_id` varchar(50) 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,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sivir_products_price.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_products_price_history`
--


--
-- Table structure for table `sivir_products_purchase_pending`
--

CREATE TABLE `sivir_products_purchase_pending` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Unique UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch office table',
  `product_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Related to product ID	',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `purchase.pending.uuid` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;

--
-- Dumping data for table `sivir_products_purchase_pending`
--


--
-- Table structure for table `sivir_products_sell_price`
--

CREATE TABLE `sivir_products_sell_price` (
  `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 table',
  `product_id` varchar(50) NOT NULL COMMENT 'related to products table',
  `unit_cost` decimal(15,5) NOT NULL,
  `quantity` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `fob` decimal(15,5) DEFAULT NULL,
  `costs` decimal(15,5) DEFAULT NULL,
  `profit` decimal(15,5) NOT NULL,
  `price` decimal(15,5) NOT NULL,
  `currency_id` varchar(50) 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,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sivir_products_sell_price.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_products_sell_price`
--


--
-- Table structure for table `sivir_products_stock`
--

CREATE TABLE `sivir_products_stock` (
  `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 global_branch_office',
  `product_id` varchar(50) NOT NULL COMMENT 'related to products table',
  `quantity` decimal(10,2) NOT NULL,
  `measurement_id` int NOT NULL COMMENT 'Related to catalogs prod (MEASUREMENT)',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `relative` (`relative`),
  UNIQUE KEY `product_id` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_products_stock`
--


--
-- Table structure for table `sivir_products_stock_adjustment`
--

CREATE TABLE `sivir_products_stock_adjustment` (
  `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 global_branch_office',
  `product_id` varchar(50) NOT NULL COMMENT 'related to products table',
  `previous_quantity` decimal(10,2) NOT NULL,
  `quantity` decimal(10,2) NOT NULL,
  `measurement_id` int NOT NULL COMMENT 'Related to catalogs prod (MEASUREMENT)',
  `type` enum('I','E') NOT NULL DEFAULT 'I',
  `lot_id` varchar(50) NOT NULL COMMENT 'Related to lot table',
  `drops_id` int NOT NULL COMMENT 'Related to catalogs = ''DROPS''',
  `reason` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_products_stock_adjustment`
--


--
-- Table structure for table `sivir_products_stock_history`
--

CREATE TABLE `sivir_products_stock_history` (
  `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 global_branch_office',
  `product_id` varchar(50) NOT NULL COMMENT 'related to products table',
  `quantity` decimal(10,2) NOT NULL,
  `measurement_id` int NOT NULL COMMENT 'Related to catalogs prod (MEASUREMENT)',
  `price` decimal(10,5) NOT NULL,
  `currency_id` varchar(50) 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,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_products_stock_history`
--


--
-- Table structure for table `sivir_products_transfer`
--

CREATE TABLE `sivir_products_transfer` (
  `id` int NOT NULL AUTO_INCREMENT,
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to the branch office',
  `reason` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_products_transfer`
--


--
-- Table structure for table `sivir_products_transfer_between_warehouses`
--

CREATE TABLE `sivir_products_transfer_between_warehouses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to the branch office',
  `from_warehouse_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Non related',
  `to_warehouse_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Non related',
  `date` date DEFAULT NULL COMMENT 'Transfer date',
  `who_receives_id` int DEFAULT NULL COMMENT 'Related to person table',
  `reason` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_products_transfer_between_warehouses`
--


--
-- Table structure for table `sivir_products_transfer_between_warehouses_detail`
--

CREATE TABLE `sivir_products_transfer_between_warehouses_detail` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'uuid data',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to the branch office',
  `products_transfer_between_warehouses_id` int DEFAULT NULL COMMENT 'Related to products_transfer table',
  `provisional` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `from_product_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to product table',
  `from_lot_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to lot table',
  `quantity` decimal(15,5) NOT NULL,
  `to_product_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to product table',
  `to_lot_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to lot table',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_products_transfer_between_warehouses_detail`
--


--
-- Table structure for table `sivir_products_transfer_detail`
--

CREATE TABLE `sivir_products_transfer_detail` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'uuid data',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to the branch office',
  `products_transfer_id` int DEFAULT NULL COMMENT 'Related to products_transfer table',
  `provisional` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `from_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Non related',
  `from_warehouse_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Non related',
  `from_product_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to product table',
  `from_lot_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to lot table',
  `quantity` decimal(15,5) NOT NULL,
  `to_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Non related',
  `to_warehouse_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Non related',
  `to_product_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to product table',
  `to_lot_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to lot table',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_products_transfer_detail`
--


--
-- Table structure for table `sivir_products_wholesale_applied`
--

CREATE TABLE `sivir_products_wholesale_applied` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'The unique UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to the users sid table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to the branch office table',
  `products_wholesale_rule_id` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to wholesale rule for the product, separated by commas',
  `product_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to product table',
  `has_due_date` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'N',
  `wholesale_due_date` date DEFAULT NULL,
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_products_wholesale_applied`
--


--
-- Table structure for table `sivir_products_wholesale_rule`
--

CREATE TABLE `sivir_products_wholesale_rule` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Unique UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch office table',
  `from_quantity` decimal(15,5) NOT NULL DEFAULT '0.00000' COMMENT 'From quantity',
  `to_quantity` decimal(15,5) DEFAULT NULL COMMENT 'To quantity',
  `infinity` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'N' COMMENT 'To infinity',
  `discount` decimal(15,5) NOT NULL COMMENT 'The discount quantity',
  `discount_type` enum('%','#') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '%' COMMENT 'The discount type',
  `way_to_apply` enum('NP','D') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'NP' COMMENT 'Way to aply:\r\nNP=As a New Price\r\nD= As a discount',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_products_wholesale_rule`
--


--
-- Table structure for table `sivir_purchase`
--

CREATE TABLE `sivir_purchase` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office table',
  `relative` varchar(50) NOT NULL,
  `supplier_id` varchar(50) NOT NULL COMMENT 'related to supplier database and supplier vendor table',
  `type` int NOT NULL DEFAULT '1' COMMENT 'Invoice type',
  `kind` enum('FCV','FCVZF','DIM','DUI','OD') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'FCV' COMMENT 'FCV=Factura local nacional, (FCVFZ) Factura compra venta en zona franca DIM, DUI, OD = Otro documento',
  `voucher` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Numero de comprobante',
  `invoice_nit` varchar(100) DEFAULT NULL,
  `autorization_number` varchar(100) DEFAULT NULL,
  `control_code` varchar(50) DEFAULT NULL,
  `total_items` int DEFAULT NULL,
  `packages` int DEFAULT NULL,
  `weight` decimal(10,4) DEFAULT NULL,
  `purchase_date` date NOT NULL,
  `comments` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_purchase`
--


--
-- Table structure for table `sivir_purchase_costs`
--

CREATE TABLE `sivir_purchase_costs` (
  `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 table',
  `purchase_id` varchar(50) DEFAULT NULL COMMENT 'related to sivir purchase',
  `costs_id` int NOT NULL COMMENT 'related to catalogs items',
  `cost` decimal(15,5) NOT NULL,
  `currency_id` varchar(50) NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sivir_costs.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_purchase_costs`
--


--
-- Table structure for table `sivir_purchase_products`
--

CREATE TABLE `sivir_purchase_products` (
  `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 'elated to branch office table',
  `purchase_id` int DEFAULT NULL COMMENT 'related to sivir_purchase',
  `fob` decimal(10,5) DEFAULT NULL,
  `costs` decimal(10,5) DEFAULT NULL,
  `product_id` varchar(50) NOT NULL COMMENT 'related to products table',
  `quantity` decimal(10,5) NOT NULL,
  `measurement_id` int NOT NULL COMMENT 'related to catalogs table',
  `purchase_price` decimal(10,5) NOT NULL,
  `currency_id` int DEFAULT NULL COMMENT 'related to currency table',
  `cost_aditional` decimal(10,5) DEFAULT NULL,
  `warehouse_id` varchar(50) NOT NULL COMMENT 'Related to warehouse table',
  `physical_location` mediumtext,
  `lot` varchar(50) DEFAULT NULL,
  `expires` enum('Y','N') NOT NULL DEFAULT 'N',
  `expiration_date` date DEFAULT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `online_purchase_products.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_purchase_products`
--


--
-- Table structure for table `sivir_sell`
--

CREATE TABLE `sivir_sell` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `id` bigint NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to global_branch_office',
  `sellpoint_id` varchar(50) NOT NULL COMMENT 'related to sellpoint table',
  `payment_type` int NOT NULL DEFAULT '1' COMMENT 'Payment kind, intern control',
  `payment_detail` text COMMENT 'The payment detail',
  `customer_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT 'Related to portfolio customers, this could be null for the special clients',
  `document_type` int NOT NULL,
  `customer_full_name` varchar(150) NOT NULL DEFAULT '''Sin nombre''',
  `customer_nit` varchar(50) NOT NULL DEFAULT '0',
  `customer_complemento` varchar(5) DEFAULT NULL COMMENT 'The CI complement',
  `customer_email` varchar(250) DEFAULT NULL COMMENT 'This is for send the invoice in xml format',
  `discount_all_products` decimal(15,5) NOT NULL DEFAULT '0.00000' COMMENT 'The sum for all products discount',
  `descuentoAdicional` decimal(15,5) NOT NULL DEFAULT '0.00000' COMMENT 'Additional discount, for the hole sell ',
  `discount_total` decimal(15,5) NOT NULL,
  `total` decimal(15,5) NOT NULL,
  `currency_id` int NOT NULL COMMENT 'related to currency table',
  `exchange_used` text NOT NULL COMMENT 'Must have all the exchange rate from currencies',
  `codigoExcepcion` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'En caso de que el NIT sea invalido o sea fuera de linea',
  `medical_prescription_detail` text COMMENT 'The medical_prescription detail',
  `sended` enum('F','C','P','O') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'F' COMMENT 'Where to send:\r\nF = ended\r\nC = ready to finish\r\nP = proforma\r\nO = Pedido (Orden)',
  `date_movement` date NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sell_point.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_sell`
--


--
-- Table structure for table `sivir_sell_aditional_discount`
--

CREATE TABLE `sivir_sell_aditional_discount` (
  `id` int NOT NULL AUTO_INCREMENT,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `sell_id` int DEFAULT NULL COMMENT 'Related to sell table',
  `provisional` varchar(50) DEFAULT NULL COMMENT 'The provisional UUID for the new sell',
  `ammount` decimal(10,5) NOT NULL COMMENT 'This should be the 100% of the sell, in most cases',
  `currency_id` int NOT NULL COMMENT 'Related to currency table, could be null at the begining when the sell its only by provisional code	',
  `reason` varchar(200) DEFAULT NULL COMMENT 'The reason for the aditional disccount',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_sell_aditional_discount`
--


--
-- Table structure for table `sivir_sell_attachments`
--

CREATE TABLE `sivir_sell_attachments` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'The unique UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Related to branch office table',
  `sell_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Related to sell table',
  `attachments` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'The file name and extension',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_sell_attachments`
--


--
-- Table structure for table `sivir_sell_debit_credit`
--

CREATE TABLE `sivir_sell_debit_credit` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `id` bigint NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to global_branch_office',
  `sellpoint_id` varchar(50) NOT NULL COMMENT 'related to sellpoint table',
  `payment_type` int NOT NULL DEFAULT '1' COMMENT 'Payment kind, intern control',
  `payment_detail` text COMMENT 'The payment detail',
  `customer_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT 'Related to portfolio customers, this could be null for the special clients',
  `document_type` int NOT NULL,
  `customer_full_name` varchar(150) NOT NULL DEFAULT '''Sin nombre''',
  `customer_nit` varchar(50) NOT NULL DEFAULT '0',
  `customer_complemento` varchar(5) DEFAULT NULL COMMENT 'The CI complement',
  `customer_email` varchar(250) DEFAULT NULL COMMENT 'This is for send the invoice in xml format',
  `discount_all_products` decimal(15,5) NOT NULL DEFAULT '0.00000' COMMENT 'The sum for all products discount',
  `descuentoAdicional` decimal(15,5) NOT NULL DEFAULT '0.00000' COMMENT 'Additional discount, for the hole sell ',
  `discount_total` decimal(15,5) NOT NULL,
  `total` decimal(15,5) NOT NULL,
  `currency_id` int NOT NULL COMMENT 'related to currency table',
  `exchange_used` text NOT NULL COMMENT 'Must have all the exchange rate from currencies',
  `codigoExcepcion` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'En caso de que el NIT sea invalido o sea fuera de linea',
  `sended` enum('F','C','P','O') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'F' COMMENT 'Where to send:\r\nF = ended\r\nC = ready to finish\r\nP = proforma\r\nO = Pedido (Orden)',
  `date_movement` date NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sell_point.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_sell_debit_credit`
--


--
-- Table structure for table `sivir_sell_debit_credit_returned`
--

CREATE TABLE `sivir_sell_debit_credit_returned` (
  `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 table',
  `provisional` varchar(50) DEFAULT NULL COMMENT ' The provisional uuid for the sale ',
  `sell_id` bigint DEFAULT NULL COMMENT 'related to sivir_sell table',
  `product_id` varchar(50) NOT NULL COMMENT 'related to product table',
  `product_code` varchar(50) DEFAULT NULL,
  `product_fullname` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `price` decimal(15,5) NOT NULL,
  `quantity` decimal(15,5) NOT NULL,
  `total_price` decimal(15,5) NOT NULL,
  `discount` decimal(15,5) DEFAULT '0.00000',
  `numeroSerie` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT 'Serial number',
  `numeroImei` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT 'Imei number',
  `codigoDetalleTransaccion` smallint NOT NULL DEFAULT '2' COMMENT 'Código que permite especificar si se trata de la transacción original (enviar 1) o del monto que está siendo devuelto (enviar 2).',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sivir_products_price.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_sell_debit_credit_returned`
--


--
-- Table structure for table `sivir_sell_invoice`
--

CREATE TABLE `sivir_sell_invoice` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `id` bigint NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to global_branch_office',
  `sell_id` bigint NOT NULL COMMENT 'Related to sivir sell table',
  `sellpoint_id` varchar(50) NOT NULL COMMENT 'related to sellpoint table',
  `payment_type` int NOT NULL DEFAULT '1' COMMENT 'Payment kind, intern control',
  `payment_detail` text COMMENT 'The payment detail',
  `cuis` tinytext NOT NULL COMMENT 'CUIS',
  `cufd` tinytext NOT NULL COMMENT 'CUFD per day',
  `cafc` varchar(50) DEFAULT NULL COMMENT 'Codigo CAFC para facturas en contingencia',
  `codigo_control` varchar(50) DEFAULT NULL,
  `cuf` tinytext CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `legend` mediumtext NOT NULL,
  `law` mediumtext NOT NULL,
  `zofra` enum('Y','N') NOT NULL DEFAULT 'N',
  `nitConjunto` varchar(50) DEFAULT NULL COMMENT 'Nit conjunto no obligatorio',
  `modalidadServicio` tinytext COMMENT 'EJ: Post operatorio',
  `numeroParteRecepcion` mediumtext COMMENT 'numeroParteRecepcion en caso de ZOFRA',
  `nombreEstudiante` varchar(250) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `periodoFacturado` varchar(250) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `tipo_factura_id` int NOT NULL DEFAULT '1' COMMENT 'Related to catalogs items = "TIPOFACTURA"	',
  `tipo_emision` int NOT NULL DEFAULT '1' COMMENT '1 = Online 2 = Offline 3 = Masiva',
  `codigo_sucursal` tinyint NOT NULL DEFAULT '0' COMMENT 'Codigo de la sucursal',
  `hospedaje` text CHARACTER SET latin1 COLLATE latin1_swedish_ci COMMENT 'Hotel information {razonSocialOperadorTurismo, cantidadHuespedes, cantidadHabitaciones, cantidadMayores, cantidadMenores, fechaIngresoHospedaje}',
  `estado` enum('A','C','V') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'V' COMMENT 'A=Anulado, V=Valido, C=Caja',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `milliseconds` smallint DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sell_point.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_sell_invoice`
--


--
-- Table structure for table `sivir_sell_invoice_cancel`
--

CREATE TABLE `sivir_sell_invoice_cancel` (
  `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',
  `sell_invoice_id` int NOT NULL COMMENT 'Related to sivir sell invoice table',
  `codigo_motivo_id` int NOT NULL COMMENT 'Related to catalogs items = "REASONOFCANCELLATION"',
  `tipo_factura_id` int NOT NULL COMMENT 'Related to catalogs items = "TIPOFACTURA"',
  `codigoDescripcion` varchar(200) NOT NULL COMMENT 'Codigo de descripcion',
  `codigoEstado` int NOT NULL DEFAULT '0' COMMENT 'el codigo del estado',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sivir_sell_invoice_cancel.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_sell_invoice_cancel`
--


--
-- Table structure for table `sivir_sell_invoice_debit_credit`
--

CREATE TABLE `sivir_sell_invoice_debit_credit` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `id` bigint NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to global_branch_office',
  `sell_id` bigint NOT NULL COMMENT 'Related to sivir sell table',
  `sellpoint_id` varchar(50) NOT NULL COMMENT 'related to sellpoint table',
  `payment_type` int NOT NULL DEFAULT '1' COMMENT 'Payment kind, intern control',
  `payment_detail` text COMMENT 'The payment detail',
  `cuis` tinytext NOT NULL COMMENT 'CUIS',
  `cufd` tinytext NOT NULL COMMENT 'CUFD per day',
  `codigo_control` varchar(50) DEFAULT NULL,
  `cuf` tinytext CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `legend` mediumtext NOT NULL,
  `law` mediumtext NOT NULL,
  `zofra` enum('Y','N') NOT NULL DEFAULT 'N',
  `tipo_factura_id` int NOT NULL DEFAULT '1' COMMENT 'Related to catalogs items = "TIPOFACTURA"	',
  `tipo_emision` int NOT NULL DEFAULT '1' COMMENT '1 = Online 2 = Offline 3 = Masiva',
  `codigo_sucursal` tinyint NOT NULL DEFAULT '0' COMMENT 'Codigo de la sucursal',
  `estado` enum('A','C','V') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'V' COMMENT 'A=Anulado, V=Valido, C=Caja',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `milliseconds` smallint DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sell_point.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_sell_invoice_debit_credit`
--


--
-- Table structure for table `sivir_sell_invoice_military`
--

CREATE TABLE `sivir_sell_invoice_military` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Unique UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'related to global_branch_office	',
  `provisional` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL COMMENT 'The provisional uuid for the sale	',
  `sell_id` bigint DEFAULT NULL COMMENT 'Related to sivir sell table	',
  `fuerza_id` int NOT NULL COMMENT 'Related to Catalogs item, catalog code = MILITARY',
  `grado_id` int NOT NULL COMMENT 'Related to Catalogs item = MILITARY | GRADE',
  `tipo_armamento` varchar(200) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `departamento_actual_id` int NOT NULL COMMENT 'Related to catalogs items=DEPARTAMENTO',
  `domicilio_actual` mediumtext CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Texto',
  `domicilio_destino_actual` mediumtext CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Texto',
  `observacion` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_sell_invoice_military`
--


--
-- Table structure for table `sivir_sell_invoice_status`
--

CREATE TABLE `sivir_sell_invoice_status` (
  `relative` varchar(50) NOT NULL COMMENT 'UUID data',
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `invoice_id` int NOT NULL COMMENT 'Related to invoice table',
  `codigoDescripcion` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'Descripcion del codigo',
  `codigoEstado` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'Codigo del estado',
  `codigoRecepcion` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'Codigo de recepcion',
  `codigo` varchar(10) DEFAULT NULL COMMENT 'Codigo del error',
  `descripcion` mediumtext COMMENT 'Descripcion del error',
  `attempts` int DEFAULT '0' COMMENT 'Numero de intentos',
  `timeout` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Fuera de plazo',
  `sended` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Sended or not boolean',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sivir_sell_invoice_status.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_sell_invoice_status`
--


--
-- Table structure for table `sivir_sell_note`
--

CREATE TABLE `sivir_sell_note` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `id` bigint NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to global_branch_office',
  `sell_id` bigint NOT NULL COMMENT 'Related to sivir sell table',
  `sellpoint_id` varchar(50) NOT NULL COMMENT 'related to sellpoint table',
  `payment_type` int NOT NULL DEFAULT '1' COMMENT 'Payment kind, intern control',
  `zofra` enum('Y','N') NOT NULL DEFAULT 'N',
  `codigo_sucursal` tinyint NOT NULL DEFAULT '0' COMMENT 'Codigo de la sucursal',
  `source` enum('L','N') NOT NULL DEFAULT 'L' COMMENT 'The sell source, local or network',
  `estado` enum('A','C','V') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'V' COMMENT 'A=Anulado, V=Valido, C=Caja',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sell_point.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_sell_note`
--


--
-- Table structure for table `sivir_sell_order`
--

CREATE TABLE `sivir_sell_order` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `id` bigint NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to global_branch_office',
  `sell_id` bigint NOT NULL COMMENT 'Related to sivir sell table',
  `sellpoint_id` varchar(50) NOT NULL COMMENT 'related to sellpoint table',
  `payment_type` int NOT NULL DEFAULT '1' COMMENT 'Payment kind, intern control',
  `zofra` enum('Y','N') NOT NULL DEFAULT 'N',
  `codigo_sucursal` tinyint NOT NULL DEFAULT '0' COMMENT 'Codigo de la sucursal',
  `deliverydate` date DEFAULT NULL COMMENT 'The delivery date',
  `deliveryaddress` text CHARACTER SET latin1 COLLATE latin1_swedish_ci COMMENT 'Address',
  `deliveryobs` text CHARACTER SET latin1 COLLATE latin1_swedish_ci COMMENT 'Obs',
  `deliverycoordinates` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT 'Lat and Long',
  `deliver_status` enum('P','D') NOT NULL DEFAULT 'P' COMMENT 'P=Pending(Pendiente)\r\nD=Delivered(Entregado)',
  `estado` enum('A','C','V') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'V' COMMENT 'A=Anulado, V=Valido, C=Caja',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sell_point.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_sell_order`
--


--
-- Table structure for table `sivir_sell_payment_way`
--

CREATE TABLE `sivir_sell_payment_way` (
  `id` int NOT NULL AUTO_INCREMENT,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `sell_id` int DEFAULT NULL COMMENT 'Related to sell table',
  `provisional` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'The provisional UUID for the new sell',
  `payment_id` int NOT NULL DEFAULT '1' COMMENT 'Related to catalogs items (PAYMENT), the most common its the (1)',
  `payment_data` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'The payment way data, for example the VISA number',
  `payment_date` date DEFAULT NULL,
  `ammount` decimal(15,5) NOT NULL DEFAULT '0.00000' COMMENT 'This should be the 100% of the sell, in most cases',
  `currency_id` int DEFAULT NULL COMMENT 'Related to currency table, could be null at the begining when the sell its only by provisional code',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_sell_payment_way`
--


--
-- Table structure for table `sivir_sell_point`
--

CREATE TABLE `sivir_sell_point` (
  `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 global_branch_office',
  `descripcion` varchar(50) NOT NULL,
  `nombre_punto_venta` varchar(250) NOT NULL,
  `sellpoint_kind_id` int NOT NULL DEFAULT '2' COMMENT 'Related to catalogs items TIPOPUNTOVENTA',
  `enable_restaurant_mode` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'N' COMMENT 'Enable or not the restaurant mode on sellpoint',
  `enable_room_mode` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'N' COMMENT 'Enable de hotel room mode',
  `enable_supermarket_mode` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'Enable or not the supermarket mode',
  `could_close` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Y' COMMENT 'Could finish the sell?',
  `allow_credits` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'N' COMMENT 'Allow to create credits on this sell point...?',
  `allow_expenses` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'N' COMMENT 'Allow expenses on this sell point?',
  `could_register_other_incomes` enum('Y','N') NOT NULL DEFAULT 'Y' COMMENT 'Could register other incommes?',
  `could_homologate_product_on_sell` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'N' COMMENT 'Could homologate a new product on the sell?',
  `could_sell_empty_inventory` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'Could sell products without inventory?',
  `could_make_proforma` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'Could make proforma?',
  `could_search_other_branches` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'Could search products on another branch',
  `warehouses_allowed` varchar(50) NOT NULL DEFAULT '*' COMMENT 'On which warehouse could search to sell ',
  `users_allowed` longtext NOT NULL,
  `codigo_punto_venta` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sell_point.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_sell_point`
--

INSERT INTO `sivir_sell_point` VALUES ('6c17ae3b-6323-11f0-b0b9-00163c31d95c','69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','Punto de venta 0','PV0',5,'N','N','N','Y','Y','Y','Y','Y','Y','Y','N','*','69abe0de-7812-41bd-9124-6a7238aee7d1,a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3,150af320-63e3-43f6-adcb-20dde5b69274','0','A','2024-08-26 00:00:00','2025-07-21 18:43:41');

--
-- Table structure for table `sivir_sell_point_closed`
--

CREATE TABLE `sivir_sell_point_closed` (
  `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 global_branch_office',
  `sell_point_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'related to sellpoint table',
  `date_closed` date NOT NULL COMMENT 'The day that was opened',
  `exchange_open` text NOT NULL COMMENT 'JSON stringlify',
  `incomes_on_sellpoint` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'JSON stringlify',
  `incomes_by_credit` text CHARACTER SET latin1 COLLATE latin1_swedish_ci COMMENT 'Incomes by credit',
  `incomes_by_booking` text CHARACTER SET latin1 COLLATE latin1_general_ci COMMENT 'Incomes by booking',
  `expenses_on_sellpoint` text NOT NULL COMMENT 'JSON stringlify',
  `payment_pending_on_sellpoint` text CHARACTER SET latin1 COLLATE latin1_swedish_ci COMMENT 'JSON stringlify',
  `other_payment_on_sellpoint` text CHARACTER SET latin1 COLLATE latin1_swedish_ci COMMENT 'Other incomes, could be null',
  `incomes_sum` text COMMENT 'The json incomes sum',
  `expenses_sum` text COMMENT 'The json expenses sum',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_sell_point_closed`
--


--
-- Table structure for table `sivir_sell_point_cufd`
--

CREATE TABLE `sivir_sell_point_cufd` (
  `id` int NOT NULL AUTO_INCREMENT,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to global_branch_office',
  `sellpoint_id` varchar(50) NOT NULL COMMENT 'related to sellpoint table',
  `codigo_cufd` mediumtext NOT NULL,
  `codigo_control` varchar(200) NOT NULL,
  `direccion` text NOT NULL,
  `fecha_vigencia` datetime NOT NULL,
  `has_been_increased` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'N' COMMENT 'If the cufd has been increased',
  `reason_for_increase` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT 'The reason',
  `days_increased` smallint DEFAULT NULL COMMENT 'how long',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_sell_point_cufd`
--

INSERT INTO `sivir_sell_point_cufd` VALUES (1,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','6c17ae3b-6323-11f0-b0b9-00163c31d95c','BQcKhRCVvPUFBODTUxNzMzNDg1Qjc=QzlwRGtMU0haVUFE0RkE1NDgwQjVCR','5855D0008BE1F74','UNIDAD VECINAL: 50, CALLE: DOCTOR CARLOS ZAMBRANA F., NRO: 40','2025-07-18 11:36:03','N',NULL,0,'A','2025-07-17 11:36:03','2025-07-17 11:36:03'),(2,'a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','6c17ae3b-6323-11f0-b0b9-00163c31d95c','BQcKhRCVvPUFBODTUxNzMzNDg1Qjc=Q2UrYktMV0haVUFE0RkE1NDgwQjVCR','2150B44E6CE1F74','UNIDAD VECINAL: 50, CALLE: DOCTOR CARLOS ZAMBRANA F., NRO: 40','2025-07-22 11:10:27','N',NULL,0,'A','2025-07-21 11:10:27','2025-07-21 11:10:27'),(3,'a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','6c17ae3b-6323-11f0-b0b9-00163c31d95c','BQcKhRCVvPUFBODTUxNzMzNDg1Qjc=Qz42NGlJWEhaVUFE0RkE1NDgwQjVCR','5A52CA38ACE1F74','UNIDAD VECINAL: 50, CALLE: DOCTOR CARLOS ZAMBRANA F., NRO: 40','2025-07-23 08:34:55','N',NULL,0,'A','2025-07-22 08:34:55','2025-07-22 08:34:55');

--
-- Table structure for table `sivir_sell_point_expenses`
--

CREATE TABLE `sivir_sell_point_expenses` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'Autoincrement',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users sid',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch table',
  `sell_point_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to sellpoint table',
  `expense_date` date NOT NULL COMMENT 'The date of the expense',
  `payment_type` int DEFAULT '1' COMMENT 'Payment kind, intern control',
  `amount` decimal(10,5) NOT NULL COMMENT 'The expense amount',
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `expenses_id` int NOT NULL COMMENT 'Related to catalogs = EXPENSES',
  `comments` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'The reason of the expense',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_sell_point_expenses`
--


--
-- Table structure for table `sivir_sell_point_external_income`
--

CREATE TABLE `sivir_sell_point_external_income` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'related to global_branch_office',
  `sell_point_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'related to sellpoint table',
  `date_movement` date NOT NULL COMMENT 'Date of the movement',
  `income_reason` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'The external income reason detailed',
  `payment_type` int NOT NULL DEFAULT '1' COMMENT 'Payment kind, intern control',
  `amount` decimal(15,5) NOT NULL COMMENT 'The income amount',
  `currency_id` int NOT NULL COMMENT '	Related to currency table',
  `attachments` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_sell_point_external_income`
--


--
-- Table structure for table `sivir_sell_point_movement`
--

CREATE TABLE `sivir_sell_point_movement` (
  `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 global_branch_office',
  `sellpoint_id` varchar(50) NOT NULL COMMENT 'related to sellpoint table',
  `date_movement` date NOT NULL COMMENT 'Current date',
  `type` enum('I','E','P') NOT NULL DEFAULT 'I' COMMENT 'I=Ingreso E=Egreso P=Pendiente de pago',
  `amount` decimal(15,5) NOT NULL,
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `reason` mediumtext,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sell_point_movement.relative` (`relative`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_sell_point_movement`
--


--
-- Table structure for table `sivir_sell_point_open`
--

CREATE TABLE `sivir_sell_point_open` (
  `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 global_branch_office',
  `sellpoint_id` varchar(50) NOT NULL COMMENT 'related to sellpoint table',
  `date_open` date NOT NULL COMMENT 'The day that was opened',
  `exchange_open` text NOT NULL COMMENT 'JSON stringlify',
  `terminal` varchar(50) DEFAULT NULL COMMENT 'The terminal number, sell point code by default',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sell_point_movement.relative` (`relative`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sivir_sell_point_open`
--


--
-- Table structure for table `sivir_sell_sold`
--

CREATE TABLE `sivir_sell_sold` (
  `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 table',
  `provisional` varchar(50) DEFAULT NULL COMMENT ' The provisional uuid for the sale ',
  `sell_id` bigint DEFAULT NULL COMMENT 'related to sivir_sell table',
  `product_id` varchar(50) NOT NULL COMMENT 'related to product table',
  `product_code` varchar(50) DEFAULT NULL,
  `product_fullname` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `hospital_clinicas` text COMMENT 'especialidad, especialidadDetalle, nroQuirofanoSalaOperaciones, especialidadMedico, nombreApellidoMedico, nitDocumentoMedico, nroMatriculaMedico, nroFacturaMedico',
  `price` decimal(15,5) NOT NULL,
  `quantity` decimal(15,5) NOT NULL,
  `total_price` decimal(15,5) NOT NULL,
  `discount` decimal(15,5) DEFAULT '0.00000',
  `numeroSerie` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT 'Serial number',
  `numeroImei` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT 'Imei number',
  `detalleHuespedes` text COMMENT 'The list of hosts in the hotel room, an array of objects',
  `hospedajeIngresoYSalida` text COMMENT 'FORMATO JSON\r\nfechaIngresoHospedaje, fechaSalidaHospedaje, tipo_habitacion_id',
  `status` enum('A','X') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sivir_products_price.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_sell_sold`
--


--
-- Table structure for table `sivir_sell_sold_lot_used`
--

CREATE TABLE `sivir_sell_sold_lot_used` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'The UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch office table',
  `sell_id` bigint NOT NULL COMMENT 'related to sivir_sell table	',
  `product_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'related to product table',
  `product_lot_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to sivir_products_lot table',
  `lot` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL COMMENT 'The lot number or data',
  `quantity` decimal(15,5) NOT NULL COMMENT 'The lot quantity used',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_sell_sold_lot_used`
--


--
-- Table structure for table `sivir_service_periods`
--

CREATE TABLE `sivir_service_periods` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'The unique uuid ',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch office',
  `products_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to product table',
  `code` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'The payment month code',
  `period_type` enum('D','M','A') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'M' COMMENT 'D=Diario\r\nM=Mensual\r\nA=Anual',
  `days_of_interval` int DEFAULT NULL,
  `starts_on_date` date NOT NULL COMMENT 'The date for the begining',
  `hole_year` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'Y' COMMENT 'The hole year?',
  `ends_of_date` date DEFAULT NULL,
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_service_periods`
--


--
-- Table structure for table `sivir_service_periods_payments`
--

CREATE TABLE `sivir_service_periods_payments` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'The unique uuid',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch office table',
  `service_period_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to service period',
  `product_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to product table',
  `period_title` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'The period title',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_service_periods_payments`
--


--
-- Table structure for table `sivir_service_periods_payments_made`
--

CREATE TABLE `sivir_service_periods_payments_made` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'The unique uuid data',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch office table',
  `service_periods_payments_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL COMMENT 'Related to service periods payment',
  `product_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'product_id',
  `provisional` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `sell_id` bigint DEFAULT NULL COMMENT 'Related to sivir sell table',
  `amount` decimal(15,5) NOT NULL COMMENT 'The amount',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_service_periods_payments_made`
--


--
-- Table structure for table `sivir_significant_event`
--

CREATE TABLE `sivir_significant_event` (
  `id` int NOT NULL AUTO_INCREMENT,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `cufd` varchar(200) NOT NULL,
  `cufdEvento` varchar(200) NOT NULL,
  `codigoMotivoEvento` varchar(200) DEFAULT NULL COMMENT 'Codigo motivo del evento',
  `descripcion` varchar(200) DEFAULT NULL COMMENT 'Descripcion del evento',
  `fechaHoraInicioEvento` timestamp NOT NULL,
  `fechaHoraFinEvento` timestamp NOT NULL,
  `codigoRecepcionEventoSignificativo` varchar(25) NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_significant_event`
--


--
-- Table structure for table `sivir_store_credit`
--

CREATE TABLE `sivir_store_credit` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Uuid data',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch table',
  `customer_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to portfolio customers, this could be null for the special clients	',
  `credit_reason` varchar(150) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'The credit reason, sell number in some cases',
  `sell_id` bigint DEFAULT NULL COMMENT 'Related to sell id, not mandatory',
  `sellpoint_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL COMMENT 'Related to the sellpoint',
  `ammount` decimal(15,5) NOT NULL COMMENT 'The credit total ammount',
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `how_many_payments` int NOT NULL COMMENT 'The quantity number',
  `payment_intervals` int NOT NULL COMMENT 'Interval payment days',
  `first_payment_date` date NOT NULL COMMENT 'The first payment date',
  `paid_complete` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is the complete credit paid?',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_store_credit`
--


--
-- Table structure for table `sivir_store_credit_payments_made`
--

CREATE TABLE `sivir_store_credit_payments_made` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch table',
  `store_credit_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to store credit table',
  `store_credit_payments_todo_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to store credit payments todo table',
  `sellpoint_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'related to sellpoint table',
  `payment_type` int NOT NULL DEFAULT '1' COMMENT 'Payment kind, intern control',
  `payment_ammount` decimal(15,5) NOT NULL COMMENT 'The payment made ammount',
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `payment_made_date` date NOT NULL COMMENT 'The real date, no the register date',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_store_credit_payments_made`
--


--
-- Table structure for table `sivir_store_credit_payments_todo`
--

CREATE TABLE `sivir_store_credit_payments_todo` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch table',
  `store_credit_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to store credit',
  `total_ammount` decimal(15,5) NOT NULL COMMENT 'The payment total ammount',
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `payment_duedate` date NOT NULL COMMENT 'The due date for the payment',
  `paid` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Its paid completed?',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_store_credit_payments_todo`
--


--
-- Table structure for table `sivir_store_debt`
--

CREATE TABLE `sivir_store_debt` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Uuid data',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch table',
  `supplier_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'related to supplier database and supplier vendor table	',
  `debt_reason` varchar(250) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'The credit reason, sell number in some cases',
  `purchase_id` int DEFAULT NULL COMMENT 'related to sivir_purchase',
  `sellpoint_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL COMMENT 'Related to the sellpoint',
  `ammount` decimal(15,5) NOT NULL COMMENT 'The credit total ammount',
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `how_many_payments` int NOT NULL COMMENT 'The quantity number',
  `payment_intervals` int NOT NULL COMMENT 'Interval payment days',
  `first_payment_date` date NOT NULL COMMENT 'The first payment date',
  `paid_complete` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is the complete credit paid?',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_store_debt`
--


--
-- Table structure for table `sivir_store_debt_payments_made`
--

CREATE TABLE `sivir_store_debt_payments_made` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch table',
  `store_debt_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to store debt table',
  `store_debt_payments_todo_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to store debt payments todo table',
  `sellpoint_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'related to sellpoint table',
  `payment_type` int NOT NULL DEFAULT '1' COMMENT 'Payment kind, intern control',
  `payment_ammount` decimal(15,5) NOT NULL COMMENT 'The payment made ammount',
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `payment_made_date` date NOT NULL COMMENT 'The real date, no the register date',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_store_debt_payments_made`
--


--
-- Table structure for table `sivir_store_debt_payments_todo`
--

CREATE TABLE `sivir_store_debt_payments_todo` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch table',
  `store_debt_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to store debt',
  `total_ammount` decimal(15,5) NOT NULL COMMENT 'The payment total ammount',
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `payment_duedate` date NOT NULL COMMENT 'The due date for the payment',
  `paid` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Its paid completed?',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_store_debt_payments_todo`
--


--
-- Table structure for table `sivir_sync_by_day`
--

CREATE TABLE `sivir_sync_by_day` (
  `id` int NOT NULL AUTO_INCREMENT,
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch table',
  `day` date NOT NULL COMMENT 'The date for sync',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_sync_by_day`
--

INSERT INTO `sivir_sync_by_day` VALUES (1,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','2025-07-17','A','2025-07-17 11:33:56','2025-07-17 11:33:56'),(2,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','2025-07-17','A','2025-07-17 11:37:12','2025-07-17 11:37:12'),(3,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','2025-07-17','A','2025-07-17 11:37:18','2025-07-17 11:37:18'),(4,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','2025-07-17','A','2025-07-17 11:42:52','2025-07-17 11:42:52'),(5,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','2025-07-17','A','2025-07-17 11:43:49','2025-07-17 11:43:49'),(6,'a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','2025-07-17','A','2025-07-17 11:47:08','2025-07-17 11:47:08'),(7,'a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','2025-07-17','A','2025-07-17 23:00:09','2025-07-17 23:00:09'),(8,'a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','2025-07-17','A','2025-07-17 23:02:50','2025-07-17 23:02:50'),(9,'a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','2025-07-21','A','2025-07-21 11:10:29','2025-07-21 11:10:29'),(10,'a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','2025-07-21','A','2025-07-21 12:18:57','2025-07-21 12:18:57'),(11,'a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','2025-07-21','A','2025-07-21 12:28:21','2025-07-21 12:28:21'),(12,'a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','2025-07-21','A','2025-07-21 14:16:22','2025-07-21 14:16:22'),(13,'a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','2025-07-21','A','2025-07-21 14:17:34','2025-07-21 14:17:34'),(14,'a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','2025-07-21','A','2025-07-21 14:28:59','2025-07-21 14:28:59'),(15,'a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','2025-07-21','A','2025-07-21 18:24:57','2025-07-21 18:24:57'),(16,'a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','2025-07-21','A','2025-07-21 18:31:02','2025-07-21 18:31:02'),(17,'150af320-63e3-43f6-adcb-20dde5b69274','caf33099-4810-4388-8713-b99bbd19832f','2025-07-21','A','2025-07-21 18:39:02','2025-07-21 18:39:02'),(18,'a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','2025-07-21','A','2025-07-21 18:39:19','2025-07-21 18:39:19'),(19,'69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','2025-07-21','A','2025-07-21 18:43:17','2025-07-21 18:43:17'),(20,'a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','2025-07-21','A','2025-07-21 19:11:13','2025-07-21 19:11:13'),(21,'a7d992a8-74c1-49b0-a0d0-ef0f2ff2fcf3','caf33099-4810-4388-8713-b99bbd19832f','2025-07-22','A','2025-07-22 08:34:57','2025-07-22 08:34:57');

--
-- Table structure for table `sivir_system_behavior`
--

CREATE TABLE `sivir_system_behavior` (
  `relative` varchar(50) NOT NULL COMMENT 'UUID data',
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `token` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'System token',
  `codigo_sistema` tinytext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'system code',
  `qr_url` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Url para el QR de la factura',
  `codigo_ambiente` tinyint NOT NULL COMMENT 'Codigo ambiebte del sistema',
  `privatekey` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT 'llave.pem' COMMENT 'The private key llave.pem',
  `publickey` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT 'certificado.pem' COMMENT 'The public key, certificado.pem',
  `key_due_date` date DEFAULT NULL COMMENT 'The key due date',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sivir_system_behavior.relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sivir_system_behavior`
--

INSERT INTO `sivir_system_behavior` VALUES ('92ebeaf7-4d20-4f17-8b4c-fd878af3853e','69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJqb3NlcG9saWxsYTI0MDVAZ21haWwuY29tIiwiY29kaWdvU2lzdGVtYSI6IjgxNEZBNTQ4MEI1QkU1MTczMzQ4NUI3Iiwibml0IjoiSDRzSUFBQUFBQUFBQURNek56RXdNelV3TmdjQVpCRlY3UWtBQUFBPSIsImlkIjo1ODkxNTMwLCJleHAiOjE3NTM5NjE3MzAsImlhdCI6MTc1Mjc2NjUwMSwibml0RGVsZWdhZG8iOjQ4MDc0MTQwMTksInN1YnNpc3RlbWEiOiJTRkUifQ.1EtGuFsIpkuY-A5Wrv98sU0ZZLkdLBQk7aFogAtHOISYmKKYl_jz-M_ZfhHxdpPXZn7bHJVH6zdJ8Mhw3bdNqw','814FA5480B5BE51733485B7','https://pilotosiat.impuestos.gob.bo/consulta/QR?',2,'llave.pem','certificado.pem',NULL,'A','2025-07-17 11:33:40','2025-07-17 11:35:40');

--
-- Table structure for table `sivir_weight_scale_configuration`
--

CREATE TABLE `sivir_weight_scale_configuration` (
  `relative` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'The unique UUID',
  `users_sid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Related to branch office table',
  `sector_digit` tinyint NOT NULL DEFAULT '0',
  `article_code_size` tinyint NOT NULL DEFAULT '0',
  `weight_digit` tinyint NOT NULL DEFAULT '4',
  `control_code_size` tinyint NOT NULL DEFAULT '0',
  `status` enum('A','X') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `weight_scale_relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `sivir_weight_scale_configuration`
--


--
-- Table structure for table `warehouse`
--

CREATE TABLE `warehouse` (
  `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 global_branch_office	',
  `warehouse` varchar(200) NOT NULL,
  `location` text NOT NULL,
  `type_id` int NOT NULL COMMENT 'Related to catalogs',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `relative` (`relative`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `warehouse`
--

INSERT INTO `warehouse` VALUES ('6c18c58c-6323-11f0-b0b9-00163c31d95c','69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','DEPOSITO DE PRODUCTOS','SIN UBICACION DEFINIDA',4,'A','2025-07-17 00:00:00',NULL),('6c18d4d5-6323-11f0-b0b9-00163c31d95c','69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','ALMACEN DE ACTIVOS FIJOS','SIN UBICACION DEFINIDA',3,'A','2025-07-17 00:00:00',NULL),('6c18d68b-6323-11f0-b0b9-00163c31d95c','69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','ALMACEN DE INSUMOS','SIN UBICACION DEFINIDA',2,'A','2025-07-17 00:00:00',NULL),('6c18d729-6323-11f0-b0b9-00163c31d95c','69abe0de-7812-41bd-9124-6a7238aee7d1','caf33099-4810-4388-8713-b99bbd19832f','ALMACEN GENERAL DE COMPRA VENTA','SIN UBICACION DEFINIDA',1,'A','2025-07-17 00:00:00',NULL);


