--
-- Host: localhost    Database: bw_sede_project
-- ------------------------------------------------------


--
-- Table structure for table `account_statement_blue_prints`
--

CREATE TABLE `account_statement_blue_prints` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `path` varchar(191) NOT NULL,
  `account_statement_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `account_statement_blue_prints_account_statement_id_foreign` (`account_statement_id`),
  CONSTRAINT `account_statement_blue_prints_account_statement_id_foreign` FOREIGN KEY (`account_statement_id`) REFERENCES `account_statements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_statement_blue_prints`
--

INSERT INTO `account_statement_blue_prints` VALUES (1,'Miguel Angel Caro Bahena','accountstatements-blueprints/GUXvWZyJJv1SkcHuZ0ZPOdOcls44CUxQRxJsje6T.jpg',1,'2025-08-13 00:54:30','2025-08-13 00:54:30'),(2,'TEST','accountstatements-blueprints/f5qMVwndNLsUH5ecc8ZxWQWrV0DcKvQuGpOP0edB.jpg',1,'2025-08-13 00:54:42','2025-08-13 00:54:42'),(3,'test2','accountstatements-blueprints/jDDKQJvfee2ZA5FUquYDLwUUWkKjxbIzGTWTi0jC.png',1,'2025-08-13 00:54:55','2025-08-13 00:54:55'),(4,'123','accountstatements-blueprints/AERJVu3SqIkJFhbej1sOUHs67DuehYVCk4UjRBo9.jpg',1,'2025-08-13 00:55:09','2025-08-13 00:55:09'),(5,'321','accountstatements-blueprints/N9DkqcOo6t2myeq5STb1YbPkAoUGnqqnvMESjYNu.jpg',1,'2025-08-13 00:55:18','2025-08-13 00:55:18'),(6,'345','accountstatements-blueprints/a5rTyqWtR9lqxWAiRcgMRLsrfEYi1aJLplzzvndX.jpg',1,'2025-08-13 00:55:28','2025-08-13 00:55:28');

--
-- Table structure for table `account_statement_conciliations`
--

CREATE TABLE `account_statement_conciliations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `amount` double NOT NULL,
  `conciliation_date` date NOT NULL,
  `description` varchar(191) NOT NULL,
  `payment_type` varchar(191) NOT NULL,
  `account_statement_id` bigint(20) unsigned NOT NULL,
  `account_statement_blue_prints_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `account_statement_conciliations_account_statement_id_foreign` (`account_statement_id`),
  KEY `conciliations_blueprints_id` (`account_statement_blue_prints_id`),
  CONSTRAINT `account_statement_conciliations_account_statement_id_foreign` FOREIGN KEY (`account_statement_id`) REFERENCES `account_statements` (`id`),
  CONSTRAINT `conciliations_blueprints_id` FOREIGN KEY (`account_statement_blue_prints_id`) REFERENCES `account_statement_blue_prints` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_statement_conciliations`
--


--
-- Table structure for table `account_statements`
--

CREATE TABLE `account_statements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `issue_date` date NOT NULL,
  `payment_date` date DEFAULT NULL,
  `status` varchar(191) NOT NULL,
  `amount` double NOT NULL,
  `debt_to_date` double DEFAULT NULL,
  `tipo_de_pago` varchar(191) DEFAULT NULL,
  `customer_id` bigint(20) unsigned NOT NULL,
  `unit_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `account_statements_customer_id_foreign` (`customer_id`),
  KEY `account_statements_unit_id_foreign` (`unit_id`),
  CONSTRAINT `account_statements_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  CONSTRAINT `account_statements_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=667 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_statements`
--

INSERT INTO `account_statements` VALUES (1,'2024-11-26','2025-08-12','Por conciliar',90000,90000,NULL,1,1,'2024-11-27 04:24:29','2025-08-13 00:55:28'),(2,'2024-12-26',NULL,'Por pagar',5400,84600,NULL,1,1,'2024-11-27 04:24:29','2024-11-27 04:24:29'),(3,'2025-01-26',NULL,'Por pagar',5400,79200,NULL,1,1,'2024-11-27 04:24:29','2024-11-27 04:24:29'),(4,'2025-02-26',NULL,'Por pagar',5400,73800,NULL,1,1,'2024-11-27 04:24:29','2024-11-27 04:24:29'),(5,'2025-03-26',NULL,'Por pagar',5400,68400,NULL,1,1,'2024-11-27 04:24:29','2024-11-27 04:24:29'),(6,'2025-04-26',NULL,'Por pagar',5400,63000,NULL,1,1,'2024-11-27 04:24:29','2024-11-27 04:24:29'),(7,'2025-05-26',NULL,'Por pagar',5400,57600,NULL,1,1,'2024-11-27 04:24:29','2024-11-27 04:24:29'),(8,'2025-06-26',NULL,'Por pagar',5400,52200,NULL,1,1,'2024-11-27 04:24:29','2024-11-27 04:24:29'),(9,'2025-07-26',NULL,'Por pagar',5400,46800,NULL,1,1,'2024-11-27 04:24:29','2024-11-27 04:24:29'),(10,'2025-08-26',NULL,'Por pagar',5400,41400,NULL,1,1,'2024-11-27 04:24:29','2024-11-27 04:24:29'),(11,'2025-09-26',NULL,'Por pagar',5400,36000,NULL,1,1,'2024-11-27 04:24:29','2024-11-27 04:24:29'),(12,'2025-10-26',NULL,'Por pagar',36000,0,NULL,1,1,'2024-11-27 04:24:29','2024-11-27 04:24:29'),(13,'2024-11-26',NULL,'Por pagar',90000,90000,NULL,2,1,'2024-11-27 04:43:43','2024-11-27 04:43:43'),(14,'2024-12-26',NULL,'Por pagar',5400,84600,NULL,2,1,'2024-11-27 04:43:43','2024-11-27 04:43:43'),(15,'2025-01-26',NULL,'Por pagar',5400,79200,NULL,2,1,'2024-11-27 04:43:43','2024-11-27 04:43:43'),(16,'2025-02-26',NULL,'Por pagar',5400,73800,NULL,2,1,'2024-11-27 04:43:43','2024-11-27 04:43:43'),(17,'2025-03-26',NULL,'Por pagar',5400,68400,NULL,2,1,'2024-11-27 04:43:43','2024-11-27 04:43:43'),(18,'2025-04-26',NULL,'Por pagar',5400,63000,NULL,2,1,'2024-11-27 04:43:43','2024-11-27 04:43:43'),(19,'2025-05-26',NULL,'Por pagar',5400,57600,NULL,2,1,'2024-11-27 04:43:43','2024-11-27 04:43:43'),(20,'2025-06-26',NULL,'Por pagar',5400,52200,NULL,2,1,'2024-11-27 04:43:43','2024-11-27 04:43:43'),(21,'2025-07-26',NULL,'Por pagar',5400,46800,NULL,2,1,'2024-11-27 04:43:43','2024-11-27 04:43:43'),(22,'2025-08-26',NULL,'Por pagar',5400,41400,NULL,2,1,'2024-11-27 04:43:44','2024-11-27 04:43:44'),(23,'2025-09-26',NULL,'Por pagar',5400,36000,NULL,2,1,'2024-11-27 04:43:44','2024-11-27 04:43:44'),(24,'2025-10-26',NULL,'Por pagar',36000,0,NULL,2,1,'2024-11-27 04:43:44','2024-11-27 04:43:44'),(25,'2024-11-28',NULL,'Por pagar',90000,90000,NULL,2,1,'2024-11-29 02:15:45','2024-11-29 02:15:45'),(26,'2024-12-28',NULL,'Por pagar',4500,85500,NULL,2,1,'2024-11-29 02:15:45','2024-11-29 02:15:45'),(27,'2025-01-28',NULL,'Por pagar',4500,81000,NULL,2,1,'2024-11-29 02:15:45','2024-11-29 02:15:45'),(28,'2025-02-28',NULL,'Por pagar',4500,76500,NULL,2,1,'2024-11-29 02:15:45','2024-11-29 02:15:45'),(29,'2025-03-28',NULL,'Por pagar',4500,72000,NULL,2,1,'2024-11-29 02:15:45','2024-11-29 02:15:45'),(30,'2025-04-28',NULL,'Por pagar',4500,67500,NULL,2,1,'2024-11-29 02:15:45','2024-11-29 02:15:45'),(31,'2025-05-28',NULL,'Por pagar',4500,63000,NULL,2,1,'2024-11-29 02:15:45','2024-11-29 02:15:45'),(32,'2025-06-28',NULL,'Por pagar',4500,58500,NULL,2,1,'2024-11-29 02:15:45','2024-11-29 02:15:45'),(33,'2025-07-28',NULL,'Por pagar',4500,54000,NULL,2,1,'2024-11-29 02:15:45','2024-11-29 02:15:45'),(34,'2025-08-28',NULL,'Por pagar',4500,49500,NULL,2,1,'2024-11-29 02:15:45','2024-11-29 02:15:45'),(35,'2025-09-28',NULL,'Por pagar',4500,45000,NULL,2,1,'2024-11-29 02:15:45','2024-11-29 02:15:45'),(36,'2025-10-28',NULL,'Por pagar',4500,40500,NULL,2,1,'2024-11-29 02:15:45','2024-11-29 02:15:45'),(37,'2025-11-28',NULL,'Por pagar',4500,36000,NULL,2,1,'2024-11-29 02:15:45','2024-11-29 02:15:45'),(38,'2025-12-28',NULL,'Por pagar',36000,0,NULL,2,1,'2024-11-29 02:15:45','2024-11-29 02:15:45'),(39,'2024-11-28',NULL,'Por pagar',90000,90000,NULL,2,1,'2024-11-29 02:26:09','2024-11-29 02:26:09'),(40,'2024-12-28',NULL,'Por pagar',4500,85500,NULL,2,1,'2024-11-29 02:26:09','2024-11-29 02:26:09'),(41,'2025-01-28',NULL,'Por pagar',4500,81000,NULL,2,1,'2024-11-29 02:26:09','2024-11-29 02:26:09'),(42,'2025-02-28',NULL,'Por pagar',4500,76500,NULL,2,1,'2024-11-29 02:26:09','2024-11-29 02:26:09'),(43,'2025-03-28',NULL,'Por pagar',4500,72000,NULL,2,1,'2024-11-29 02:26:09','2024-11-29 02:26:09'),(44,'2025-04-28',NULL,'Por pagar',4500,67500,NULL,2,1,'2024-11-29 02:26:09','2024-11-29 02:26:09'),(45,'2025-05-28',NULL,'Por pagar',4500,63000,NULL,2,1,'2024-11-29 02:26:09','2024-11-29 02:26:09'),(46,'2025-06-28',NULL,'Por pagar',4500,58500,NULL,2,1,'2024-11-29 02:26:09','2024-11-29 02:26:09'),(47,'2025-07-28',NULL,'Por pagar',4500,54000,NULL,2,1,'2024-11-29 02:26:09','2024-11-29 02:26:09'),(48,'2025-08-28',NULL,'Por pagar',4500,49500,NULL,2,1,'2024-11-29 02:26:09','2024-11-29 02:26:09'),(49,'2025-09-28',NULL,'Por pagar',4500,45000,NULL,2,1,'2024-11-29 02:26:09','2024-11-29 02:26:09'),(50,'2025-10-28',NULL,'Por pagar',4500,40500,NULL,2,1,'2024-11-29 02:26:09','2024-11-29 02:26:09'),(51,'2025-11-28',NULL,'Por pagar',4500,36000,NULL,2,1,'2024-11-29 02:26:09','2024-11-29 02:26:09'),(52,'2026-01-28',NULL,'Por pagar',36000,-36000,NULL,2,1,'2024-11-29 02:26:09','2024-11-29 02:26:09'),(53,'2024-11-28',NULL,'Por pagar',90000,90000,NULL,3,1,'2024-11-29 02:29:12','2024-11-29 02:29:12'),(54,'2024-12-28',NULL,'Por pagar',4500,85500,NULL,3,1,'2024-11-29 02:29:12','2024-11-29 02:29:12'),(55,'2025-01-28',NULL,'Por pagar',4500,81000,NULL,3,1,'2024-11-29 02:29:12','2024-11-29 02:29:12'),(56,'2025-02-28',NULL,'Por pagar',4500,76500,NULL,3,1,'2024-11-29 02:29:12','2024-11-29 02:29:12'),(57,'2025-03-28',NULL,'Por pagar',4500,72000,NULL,3,1,'2024-11-29 02:29:12','2024-11-29 02:29:12'),(58,'2025-04-28',NULL,'Por pagar',4500,67500,NULL,3,1,'2024-11-29 02:29:12','2024-11-29 02:29:12'),(59,'2025-05-28',NULL,'Por pagar',4500,63000,NULL,3,1,'2024-11-29 02:29:12','2024-11-29 02:29:12'),(60,'2025-06-28',NULL,'Por pagar',4500,58500,NULL,3,1,'2024-11-29 02:29:12','2024-11-29 02:29:12'),(61,'2025-07-28',NULL,'Por pagar',4500,54000,NULL,3,1,'2024-11-29 02:29:12','2024-11-29 02:29:12'),(62,'2025-08-28',NULL,'Por pagar',4500,49500,NULL,3,1,'2024-11-29 02:29:12','2024-11-29 02:29:12'),(63,'2025-09-28',NULL,'Por pagar',4500,45000,NULL,3,1,'2024-11-29 02:29:12','2024-11-29 02:29:12'),(64,'2025-10-28',NULL,'Por pagar',4500,40500,NULL,3,1,'2024-11-29 02:29:12','2024-11-29 02:29:12'),(65,'2025-11-28',NULL,'Por pagar',4500,36000,NULL,3,1,'2024-11-29 02:29:12','2024-11-29 02:29:12'),(66,'2025-12-28',NULL,'Por pagar',36000,0,NULL,3,1,'2024-11-29 02:29:12','2024-11-29 02:29:12'),(67,'2024-11-28',NULL,'Por pagar',90000,90000,NULL,6,1,'2024-11-29 02:33:51','2024-11-29 02:33:51'),(68,'2024-12-28',NULL,'Por pagar',4153.85,85846.15,NULL,6,1,'2024-11-29 02:33:51','2024-11-29 02:33:51'),(69,'2025-01-28',NULL,'Por pagar',4153.85,81692.3,NULL,6,1,'2024-11-29 02:33:51','2024-11-29 02:33:51'),(70,'2025-02-28',NULL,'Por pagar',4153.85,77538.45,NULL,6,1,'2024-11-29 02:33:51','2024-11-29 02:33:51'),(71,'2025-03-28',NULL,'Por pagar',4153.85,73384.6,NULL,6,1,'2024-11-29 02:33:51','2024-11-29 02:33:51'),(72,'2025-04-28',NULL,'Por pagar',4153.85,69230.75,NULL,6,1,'2024-11-29 02:33:51','2024-11-29 02:33:51'),(73,'2025-05-28',NULL,'Por pagar',4153.85,65076.9,NULL,6,1,'2024-11-29 02:33:51','2024-11-29 02:33:51'),(74,'2025-06-28',NULL,'Por pagar',4153.85,60923.05,NULL,6,1,'2024-11-29 02:33:51','2024-11-29 02:33:51'),(75,'2025-07-28',NULL,'Por pagar',4153.85,56769.2,NULL,6,1,'2024-11-29 02:33:51','2024-11-29 02:33:51'),(76,'2025-08-28',NULL,'Por pagar',4153.85,52615.35,NULL,6,1,'2024-11-29 02:33:51','2024-11-29 02:33:51'),(77,'2025-09-28',NULL,'Por pagar',4153.85,48461.5,NULL,6,1,'2024-11-29 02:33:51','2024-11-29 02:33:51'),(78,'2025-10-28',NULL,'Por pagar',4153.85,44307.65,NULL,6,1,'2024-11-29 02:33:51','2024-11-29 02:33:51'),(79,'2025-11-28',NULL,'Por pagar',4153.85,40153.8,NULL,6,1,'2024-11-29 02:33:51','2024-11-29 02:33:51'),(80,'2025-12-28',NULL,'Por pagar',4153.85,35999.95,NULL,6,1,'2024-11-29 02:33:51','2024-11-29 02:33:51'),(81,'2026-01-28',NULL,'Por pagar',36000,-0.05000000000291,NULL,6,1,'2024-11-29 02:33:51','2024-11-29 02:33:51'),(82,'2024-11-28',NULL,'Por pagar',90000,90000,NULL,7,1,'2024-11-29 02:38:24','2024-11-29 02:38:24'),(83,'2024-12-28',NULL,'Por pagar',4500,85500,NULL,7,1,'2024-11-29 02:38:24','2024-11-29 02:38:24'),(84,'2025-01-28',NULL,'Por pagar',4500,81000,NULL,7,1,'2024-11-29 02:38:24','2024-11-29 02:38:24'),(85,'2025-02-28',NULL,'Por pagar',4500,76500,NULL,7,1,'2024-11-29 02:38:24','2024-11-29 02:38:24'),(86,'2025-03-28',NULL,'Por pagar',4500,72000,NULL,7,1,'2024-11-29 02:38:24','2024-11-29 02:38:24'),(87,'2025-04-28',NULL,'Por pagar',4500,67500,NULL,7,1,'2024-11-29 02:38:24','2024-11-29 02:38:24'),(88,'2025-05-28',NULL,'Por pagar',4500,63000,NULL,7,1,'2024-11-29 02:38:24','2024-11-29 02:38:24'),(89,'2025-06-28',NULL,'Por pagar',4500,58500,NULL,7,1,'2024-11-29 02:38:24','2024-11-29 02:38:24'),(90,'2025-07-28',NULL,'Por pagar',4500,54000,NULL,7,1,'2024-11-29 02:38:24','2024-11-29 02:38:24'),(91,'2025-08-28',NULL,'Por pagar',4500,49500,NULL,7,1,'2024-11-29 02:38:24','2024-11-29 02:38:24'),(92,'2025-09-28',NULL,'Por pagar',4500,45000,NULL,7,1,'2024-11-29 02:38:24','2024-11-29 02:38:24'),(93,'2025-10-28',NULL,'Por pagar',4500,40500,NULL,7,1,'2024-11-29 02:38:24','2024-11-29 02:38:24'),(94,'2025-11-28',NULL,'Por pagar',4500,36000,NULL,7,1,'2024-11-29 02:38:24','2024-11-29 02:38:24'),(95,'2025-12-28',NULL,'Por pagar',36000,0,NULL,7,1,'2024-11-29 02:38:24','2024-11-29 02:38:24'),(96,'2024-11-28',NULL,'Por pagar',90000,90000,NULL,8,1,'2024-11-29 02:41:46','2024-11-29 02:41:46'),(97,'2024-12-28',NULL,'Por pagar',4500,85500,NULL,8,1,'2024-11-29 02:41:46','2024-11-29 02:41:46'),(98,'2025-01-28',NULL,'Por pagar',4500,81000,NULL,8,1,'2024-11-29 02:41:46','2024-11-29 02:41:46'),(99,'2025-02-28',NULL,'Por pagar',4500,76500,NULL,8,1,'2024-11-29 02:41:46','2024-11-29 02:41:46'),(100,'2025-03-28',NULL,'Por pagar',4500,72000,NULL,8,1,'2024-11-29 02:41:46','2024-11-29 02:41:46'),(101,'2025-04-28',NULL,'Por pagar',4500,67500,NULL,8,1,'2024-11-29 02:41:46','2024-11-29 02:41:46'),(102,'2025-05-28',NULL,'Por pagar',4500,63000,NULL,8,1,'2024-11-29 02:41:46','2024-11-29 02:41:46'),(103,'2025-06-28',NULL,'Por pagar',4500,58500,NULL,8,1,'2024-11-29 02:41:46','2024-11-29 02:41:46'),(104,'2025-07-28',NULL,'Por pagar',4500,54000,NULL,8,1,'2024-11-29 02:41:46','2024-11-29 02:41:46'),(105,'2025-08-28',NULL,'Por pagar',4500,49500,NULL,8,1,'2024-11-29 02:41:46','2024-11-29 02:41:46'),(106,'2025-09-28',NULL,'Por pagar',4500,45000,NULL,8,1,'2024-11-29 02:41:46','2024-11-29 02:41:46'),(107,'2025-10-28',NULL,'Por pagar',4500,40500,NULL,8,1,'2024-11-29 02:41:46','2024-11-29 02:41:46'),(108,'2025-11-28',NULL,'Por pagar',4500,36000,NULL,8,1,'2024-11-29 02:41:46','2024-11-29 02:41:46'),(109,'2025-12-28',NULL,'Por pagar',36000,0,NULL,8,1,'2024-11-29 02:41:46','2024-11-29 02:41:46'),(110,'2025-02-07',NULL,'Por pagar',135,135,'Firma Contrato',3,2,'2025-02-07 17:53:55','2025-02-07 17:53:55'),(111,'2025-03-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 17:53:55','2025-02-07 17:53:55'),(112,'2025-04-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 17:53:55','2025-02-07 17:53:55'),(113,'2025-05-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 17:53:55','2025-02-07 17:53:55'),(114,'2025-06-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 17:53:55','2025-02-07 17:53:55'),(115,'2025-07-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 17:53:55','2025-02-07 17:53:55'),(116,'2025-08-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 17:53:55','2025-02-07 17:53:55'),(117,'2025-09-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 17:53:55','2025-02-07 17:53:55'),(118,'2025-10-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 17:53:55','2025-02-07 17:53:55'),(119,'2025-11-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 17:53:55','2025-02-07 17:53:55'),(120,'2025-12-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 17:53:55','2025-02-07 17:53:55'),(121,'2026-01-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 17:53:55','2025-02-07 17:53:55'),(122,'2026-02-07',NULL,'En espera',54,NULL,'Escrituración',3,2,'2025-02-07 17:53:55','2025-02-07 17:53:55'),(123,'2025-02-07',NULL,'Por pagar',135,135,'Firma Contrato',3,2,'2025-02-07 18:14:07','2025-02-07 18:14:07'),(124,'2025-03-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:14:07','2025-02-07 18:14:07'),(125,'2025-04-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:14:07','2025-02-07 18:14:07'),(126,'2025-05-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:14:07','2025-02-07 18:14:07'),(127,'2025-06-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:14:07','2025-02-07 18:14:07'),(128,'2025-07-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:14:07','2025-02-07 18:14:07'),(129,'2025-08-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:14:07','2025-02-07 18:14:07'),(130,'2025-09-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:14:07','2025-02-07 18:14:07'),(131,'2025-10-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:14:07','2025-02-07 18:14:07'),(132,'2025-11-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:14:07','2025-02-07 18:14:07'),(133,'2025-12-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:14:07','2025-02-07 18:14:07'),(134,'2026-01-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:14:07','2025-02-07 18:14:07'),(135,'2026-03-07',NULL,'En espera',54,NULL,'Escrituración',3,2,'2025-02-07 18:14:07','2025-02-07 18:14:07'),(136,'2025-02-07',NULL,'Por pagar',135,135,'Firma Contrato',3,2,'2025-02-07 18:30:28','2025-02-07 18:30:28'),(137,'2025-03-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:30:28','2025-02-07 18:30:28'),(138,'2025-04-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:30:28','2025-02-07 18:30:28'),(139,'2025-05-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:30:28','2025-02-07 18:30:28'),(140,'2025-06-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:30:28','2025-02-07 18:30:28'),(141,'2025-07-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:30:28','2025-02-07 18:30:28'),(142,'2025-08-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:30:28','2025-02-07 18:30:28'),(143,'2025-09-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:30:28','2025-02-07 18:30:28'),(144,'2025-10-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:30:28','2025-02-07 18:30:28'),(145,'2025-11-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:30:28','2025-02-07 18:30:28'),(146,'2025-12-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:30:28','2025-02-07 18:30:28'),(147,'2026-01-07',NULL,'En espera',7.36,NULL,'Pago parcial',3,2,'2025-02-07 18:30:28','2025-02-07 18:30:28'),(148,'2026-04-07',NULL,'En espera',54,NULL,'Escrituración',3,2,'2025-02-07 18:30:28','2025-02-07 18:30:28'),(149,'2025-02-07',NULL,'Por pagar',90000,90000,'Firma Contrato',3,1,'2025-02-07 18:45:50','2025-02-07 18:45:50'),(150,'2025-03-07',NULL,'En espera',5400,NULL,'Pago parcial',3,1,'2025-02-07 18:45:50','2025-02-07 18:45:50'),(151,'2025-04-07',NULL,'En espera',5400,NULL,'Pago parcial',3,1,'2025-02-07 18:45:50','2025-02-07 18:45:50'),(152,'2025-05-07',NULL,'En espera',5400,NULL,'Pago parcial',3,1,'2025-02-07 18:45:50','2025-02-07 18:45:50'),(153,'2025-06-07',NULL,'En espera',5400,NULL,'Pago parcial',3,1,'2025-02-07 18:45:50','2025-02-07 18:45:50'),(154,'2025-07-07',NULL,'En espera',5400,NULL,'Pago parcial',3,1,'2025-02-07 18:45:50','2025-02-07 18:45:50'),(155,'2025-08-07',NULL,'En espera',5400,NULL,'Pago parcial',3,1,'2025-02-07 18:45:50','2025-02-07 18:45:50'),(156,'2025-09-07',NULL,'En espera',5400,NULL,'Pago parcial',3,1,'2025-02-07 18:45:50','2025-02-07 18:45:50'),(157,'2025-10-07',NULL,'En espera',5400,NULL,'Pago parcial',3,1,'2025-02-07 18:45:50','2025-02-07 18:45:50'),(158,'2025-11-07',NULL,'En espera',5400,NULL,'Pago parcial',3,1,'2025-02-07 18:45:50','2025-02-07 18:45:50'),(159,'2025-12-07',NULL,'En espera',5400,NULL,'Pago parcial',3,1,'2025-02-07 18:45:50','2025-02-07 18:45:50'),(160,'2026-01-28',NULL,'En espera',36000,NULL,'Escrituración',3,1,'2025-02-07 18:45:50','2025-02-07 18:45:50'),(161,'2025-02-13',NULL,'Por pagar',11250000,11250000,'Firma Contrato',2,3,'2025-02-13 17:55:30','2025-02-13 17:55:30'),(162,'2025-03-13',NULL,'En espera',6750000,NULL,'Pago parcial',2,3,'2025-02-13 17:55:30','2025-02-13 17:55:30'),(163,'2025-04-13',NULL,'En espera',4500000,NULL,'Escrituración',2,3,'2025-02-13 17:55:30','2025-02-13 17:55:30'),(164,'2025-02-13',NULL,'Por pagar',11250000,11250000,'Firma Contrato',2,3,'2025-02-13 17:58:53','2025-02-13 17:58:53'),(165,'2025-03-13',NULL,'En espera',6750000,NULL,'Pago parcial',2,3,'2025-02-13 17:58:53','2025-02-13 17:58:53'),(166,'2025-05-13',NULL,'En espera',4500000,NULL,'Escrituración',2,3,'2025-02-13 17:58:53','2025-02-13 17:58:53'),(167,'2025-02-13',NULL,'Por pagar',11250000,11250000,'Firma Contrato',2,3,'2025-02-13 18:08:50','2025-02-13 18:08:50'),(168,'2025-03-13',NULL,'En espera',6750000,NULL,'Pago parcial',2,3,'2025-02-13 18:08:50','2025-02-13 18:08:50'),(169,'2025-06-13',NULL,'En espera',4500000,NULL,'Escrituración',2,3,'2025-02-13 18:08:50','2025-02-13 18:08:50'),(170,'2025-02-13',NULL,'Por pagar',11250000,11250000,'Firma Contrato',2,3,'2025-02-13 18:10:04','2025-02-13 18:10:04'),(171,'2025-03-13',NULL,'En espera',6750000,NULL,'Pago parcial',2,3,'2025-02-13 18:10:04','2025-02-13 18:10:04'),(172,'2025-07-13',NULL,'En espera',4500000,NULL,'Escrituración',2,3,'2025-02-13 18:10:04','2025-02-13 18:10:04'),(173,'2025-02-13',NULL,'Por pagar',11250000,11250000,'Firma Contrato',2,3,'2025-02-13 18:11:19','2025-02-13 18:11:19'),(174,'2025-03-13',NULL,'En espera',6750000,NULL,'Pago parcial',2,3,'2025-02-13 18:11:19','2025-02-13 18:11:19'),(175,'2025-08-13',NULL,'En espera',4500000,NULL,'Escrituración',2,3,'2025-02-13 18:11:19','2025-02-13 18:11:19'),(176,'2025-02-13',NULL,'Por pagar',11250000,11250000,'Firma Contrato',2,3,'2025-02-13 18:12:59','2025-02-13 18:12:59'),(177,'2025-03-13',NULL,'En espera',6750000,NULL,'Pago parcial',2,3,'2025-02-13 18:12:59','2025-02-13 18:12:59'),(178,'2025-09-13',NULL,'En espera',4500000,NULL,'Escrituración',2,3,'2025-02-13 18:12:59','2025-02-13 18:12:59'),(179,'2025-02-13',NULL,'Por pagar',11250000,11250000,'Firma Contrato',2,3,'2025-02-13 18:14:29','2025-02-13 18:14:29'),(180,'2025-03-13',NULL,'En espera',6750000,NULL,'Pago parcial',2,3,'2025-02-13 18:14:29','2025-02-13 18:14:29'),(181,'2025-10-13',NULL,'En espera',4500000,NULL,'Escrituración',2,3,'2025-02-13 18:14:29','2025-02-13 18:14:29'),(182,'2025-05-06',NULL,'Por pagar',90000,90000,'Firma Contrato',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(183,'2025-06-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(184,'2025-07-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(185,'2025-08-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(186,'2025-09-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(187,'2025-10-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(188,'2025-11-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(189,'2025-12-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(190,'2026-01-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(191,'2026-02-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(192,'2026-03-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(193,'2026-04-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(194,'2026-05-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(195,'2026-06-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(196,'2026-07-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(197,'2026-08-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(198,'2026-09-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(199,'2026-10-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(200,'2026-11-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(201,'2026-12-06',NULL,'En espera',2842.1052631579,NULL,'Pago parcial',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(202,'2027-01-06',NULL,'En espera',36000,NULL,'Escrituración',2,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(203,'2025-01-05',NULL,'Por pagar',135,135,'Firma Contrato',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(204,'2025-02-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(205,'2025-03-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(206,'2025-04-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(207,'2025-05-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(208,'2025-06-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(209,'2025-07-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(210,'2025-08-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(211,'2025-09-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(212,'2025-10-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(213,'2025-11-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(214,'2025-12-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(215,'2026-01-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(216,'2026-02-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(217,'2026-03-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(218,'2026-04-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(219,'2026-05-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(220,'2026-06-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(221,'2026-07-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(222,'2026-08-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(223,'2026-09-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(224,'2026-10-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(225,'2026-11-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(226,'2026-12-05',NULL,'En espera',3.5217391304348,NULL,'Pago parcial',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(227,'2027-01-05',NULL,'En espera',54,NULL,'Escrituración',2,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(228,'1994-01-02',NULL,'Por pagar',135,135,'Firma Contrato',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(229,'1994-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(230,'1994-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(231,'1994-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(232,'1994-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(233,'1994-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(234,'1994-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(235,'1994-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(236,'1994-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(237,'1994-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(238,'1994-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(239,'1994-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(240,'1995-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(241,'1995-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(242,'1995-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(243,'1995-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(244,'1995-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(245,'1995-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(246,'1995-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(247,'1995-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(248,'1995-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(249,'1995-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(250,'1995-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(251,'1995-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(252,'1996-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(253,'1996-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(254,'1996-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(255,'1996-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(256,'1996-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(257,'1996-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(258,'1996-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(259,'1996-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(260,'1996-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(261,'1996-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(262,'1996-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(263,'1996-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(264,'1997-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(265,'1997-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(266,'1997-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(267,'1997-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(268,'1997-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(269,'1997-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(270,'1997-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(271,'1997-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(272,'1997-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(273,'1997-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(274,'1997-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(275,'1997-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(276,'1998-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(277,'1998-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(278,'1998-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(279,'1998-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(280,'1998-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(281,'1998-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(282,'1998-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(283,'1998-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(284,'1998-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(285,'1998-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(286,'1998-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(287,'1998-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(288,'1999-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(289,'1999-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(290,'1999-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(291,'1999-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(292,'1999-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(293,'1999-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(294,'1999-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(295,'1999-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(296,'1999-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(297,'1999-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(298,'1999-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(299,'1999-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(300,'2000-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(301,'2000-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(302,'2000-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(303,'2000-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(304,'2000-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(305,'2000-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(306,'2000-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(307,'2000-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(308,'2000-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(309,'2000-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(310,'2000-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(311,'2000-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(312,'2001-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(313,'2001-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(314,'2001-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(315,'2001-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(316,'2001-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(317,'2001-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(318,'2001-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(319,'2001-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(320,'2001-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(321,'2001-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(322,'2001-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(323,'2001-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(324,'2002-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(325,'2002-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(326,'2002-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(327,'2002-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(328,'2002-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(329,'2002-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(330,'2002-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(331,'2002-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(332,'2002-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(333,'2002-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(334,'2002-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(335,'2002-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(336,'2003-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(337,'2003-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(338,'2003-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(339,'2003-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(340,'2003-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(341,'2003-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(342,'2003-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(343,'2003-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(344,'2003-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(345,'2003-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(346,'2003-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(347,'2003-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(348,'2004-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(349,'2004-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(350,'2004-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(351,'2004-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(352,'2004-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(353,'2004-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(354,'2004-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(355,'2004-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(356,'2004-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(357,'2004-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(358,'2004-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(359,'2004-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(360,'2005-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(361,'2005-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(362,'2005-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(363,'2005-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(364,'2005-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(365,'2005-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(366,'2005-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(367,'2005-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(368,'2005-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(369,'2005-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(370,'2005-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(371,'2005-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(372,'2006-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(373,'2006-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(374,'2006-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(375,'2006-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(376,'2006-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(377,'2006-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(378,'2006-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(379,'2006-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(380,'2006-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(381,'2006-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(382,'2006-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(383,'2006-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(384,'2007-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(385,'2007-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(386,'2007-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(387,'2007-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(388,'2007-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(389,'2007-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(390,'2007-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(391,'2007-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(392,'2007-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(393,'2007-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(394,'2007-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(395,'2007-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(396,'2008-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(397,'2008-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(398,'2008-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(399,'2008-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(400,'2008-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(401,'2008-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(402,'2008-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(403,'2008-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(404,'2008-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(405,'2008-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(406,'2008-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(407,'2008-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(408,'2009-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(409,'2009-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(410,'2009-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(411,'2009-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(412,'2009-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(413,'2009-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(414,'2009-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(415,'2009-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(416,'2009-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(417,'2009-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(418,'2009-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(419,'2009-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(420,'2010-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(421,'2010-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(422,'2010-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(423,'2010-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(424,'2010-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(425,'2010-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(426,'2010-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(427,'2010-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(428,'2010-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(429,'2010-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(430,'2010-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(431,'2010-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(432,'2011-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(433,'2011-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(434,'2011-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(435,'2011-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(436,'2011-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(437,'2011-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(438,'2011-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(439,'2011-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(440,'2011-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(441,'2011-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(442,'2011-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(443,'2011-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(444,'2012-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(445,'2012-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(446,'2012-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(447,'2012-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(448,'2012-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(449,'2012-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(450,'2012-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(451,'2012-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(452,'2012-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(453,'2012-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(454,'2012-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(455,'2012-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(456,'2013-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(457,'2013-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(458,'2013-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(459,'2013-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(460,'2013-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(461,'2013-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(462,'2013-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(463,'2013-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(464,'2013-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(465,'2013-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(466,'2013-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(467,'2013-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(468,'2014-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(469,'2014-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(470,'2014-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(471,'2014-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(472,'2014-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(473,'2014-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(474,'2014-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(475,'2014-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(476,'2014-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(477,'2014-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(478,'2014-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(479,'2014-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(480,'2015-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(481,'2015-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(482,'2015-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(483,'2015-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(484,'2015-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(485,'2015-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(486,'2015-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(487,'2015-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(488,'2015-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(489,'2015-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(490,'2015-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(491,'2015-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(492,'2016-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(493,'2016-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(494,'2016-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(495,'2016-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(496,'2016-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(497,'2016-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(498,'2016-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(499,'2016-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(500,'2016-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(501,'2016-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(502,'2016-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(503,'2016-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(504,'2017-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(505,'2017-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(506,'2017-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(507,'2017-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(508,'2017-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(509,'2017-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(510,'2017-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(511,'2017-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(512,'2017-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(513,'2017-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(514,'2017-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(515,'2017-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(516,'2018-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(517,'2018-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(518,'2018-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(519,'2018-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(520,'2018-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(521,'2018-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(522,'2018-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(523,'2018-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(524,'2018-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(525,'2018-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(526,'2018-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(527,'2018-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(528,'2019-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(529,'2019-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(530,'2019-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(531,'2019-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(532,'2019-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(533,'2019-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(534,'2019-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(535,'2019-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(536,'2019-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(537,'2019-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(538,'2019-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(539,'2019-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(540,'2020-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(541,'2020-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(542,'2020-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(543,'2020-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(544,'2020-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(545,'2020-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(546,'2020-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(547,'2020-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(548,'2020-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(549,'2020-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(550,'2020-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(551,'2020-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(552,'2021-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(553,'2021-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(554,'2021-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(555,'2021-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(556,'2021-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(557,'2021-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(558,'2021-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(559,'2021-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(560,'2021-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(561,'2021-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(562,'2021-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(563,'2021-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(564,'2022-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(565,'2022-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(566,'2022-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(567,'2022-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(568,'2022-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(569,'2022-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(570,'2022-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(571,'2022-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(572,'2022-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(573,'2022-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(574,'2022-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(575,'2022-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(576,'2023-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(577,'2023-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(578,'2023-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(579,'2023-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(580,'2023-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(581,'2023-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(582,'2023-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(583,'2023-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(584,'2023-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(585,'2023-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(586,'2023-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(587,'2023-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(588,'2024-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(589,'2024-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(590,'2024-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(591,'2024-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(592,'2024-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(593,'2024-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(594,'2024-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(595,'2024-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(596,'2024-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(597,'2024-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(598,'2024-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(599,'2024-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(600,'2025-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(601,'2025-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(602,'2025-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(603,'2025-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(604,'2025-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(605,'2025-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(606,'2025-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(607,'2025-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(608,'2025-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(609,'2025-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(610,'2025-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(611,'2025-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(612,'2026-01-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(613,'2026-02-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(614,'2026-03-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(615,'2026-04-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(616,'2026-05-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(617,'2026-06-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(618,'2026-07-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(619,'2026-08-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(620,'2026-09-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(621,'2026-10-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(622,'2026-11-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(623,'2026-12-02',NULL,'En espera',0.20506329113924,NULL,'Pago parcial',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(624,'2027-02-05',NULL,'En espera',54,NULL,'Escrituración',2,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(625,'2025-01-02',NULL,'Por pagar',90,90,'Firma Contrato',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(626,'2025-02-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(627,'2025-03-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(628,'2025-04-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(629,'2025-05-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(630,'2025-06-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(631,'2025-07-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(632,'2025-08-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(633,'2025-09-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(634,'2025-10-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(635,'2025-11-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(636,'2025-12-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(637,'2026-01-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(638,'2026-02-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(639,'2026-03-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(640,'2026-04-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(641,'2026-05-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(642,'2026-06-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(643,'2026-07-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(644,'2026-08-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(645,'2026-09-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(646,'2026-10-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(647,'2026-11-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(648,'2026-12-02',NULL,'En espera',2.3478260869565,NULL,'Pago parcial',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(649,'2027-01-02',NULL,'En espera',36,NULL,'Escrituración',1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(650,'2025-09-03',NULL,'Por pagar',90,90,'Firma Contrato',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10'),(651,'2025-10-03',NULL,'En espera',3.6,NULL,'Pago parcial',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10'),(652,'2025-11-03',NULL,'En espera',3.6,NULL,'Pago parcial',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10'),(653,'2025-12-03',NULL,'En espera',3.6,NULL,'Pago parcial',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10'),(654,'2026-01-03',NULL,'En espera',3.6,NULL,'Pago parcial',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10'),(655,'2026-02-03',NULL,'En espera',3.6,NULL,'Pago parcial',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10'),(656,'2026-03-03',NULL,'En espera',3.6,NULL,'Pago parcial',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10'),(657,'2026-04-03',NULL,'En espera',3.6,NULL,'Pago parcial',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10'),(658,'2026-05-03',NULL,'En espera',3.6,NULL,'Pago parcial',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10'),(659,'2026-06-03',NULL,'En espera',3.6,NULL,'Pago parcial',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10'),(660,'2026-07-03',NULL,'En espera',3.6,NULL,'Pago parcial',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10'),(661,'2026-08-03',NULL,'En espera',3.6,NULL,'Pago parcial',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10'),(662,'2026-09-03',NULL,'En espera',3.6,NULL,'Pago parcial',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10'),(663,'2026-10-03',NULL,'En espera',3.6,NULL,'Pago parcial',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10'),(664,'2026-11-03',NULL,'En espera',3.6,NULL,'Pago parcial',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10'),(665,'2026-12-03',NULL,'En espera',3.6,NULL,'Pago parcial',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10'),(666,'2027-01-03',NULL,'En espera',36,NULL,'Escrituración',19,5,'2025-09-04 00:35:10','2025-09-04 00:35:10');

--
-- Table structure for table `customer_blue_prints`
--

CREATE TABLE `customer_blue_prints` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `path` varchar(191) NOT NULL,
  `customer_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `customer_blue_prints_customer_id_foreign` (`customer_id`),
  CONSTRAINT `customer_blue_prints_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_blue_prints`
--

INSERT INTO `customer_blue_prints` VALUES (1,'Documento test','-',14,'2025-07-17 00:52:13','2025-07-17 00:52:13'),(2,'123','customers-blueprints/ydid7mX5g8WSFztkPRk4lhSisGJxoYPkBU2hzws3.jpg',1,'2025-08-13 00:57:57','2025-08-13 00:57:57');

--
-- Table structure for table `customer_units`
--

CREATE TABLE `customer_units` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) unsigned NOT NULL,
  `houseDevelopment_id` bigint(20) unsigned NOT NULL,
  `typology_id` bigint(20) unsigned NOT NULL,
  `unit_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `customer_units_customer_id_foreign` (`customer_id`),
  CONSTRAINT `customer_units_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_units`
--

INSERT INTO `customer_units` VALUES (1,1,1,1,1,'2024-10-30 01:17:11','2024-10-30 01:17:11'),(2,2,1,1,1,'2024-11-29 02:26:09','2024-11-29 02:26:09'),(3,3,1,1,1,'2024-11-29 02:29:12','2024-11-29 02:29:12'),(4,6,1,1,1,'2024-11-29 02:33:51','2024-11-29 02:33:51'),(5,7,1,1,1,'2024-11-29 02:38:24','2024-11-29 02:38:24'),(6,8,1,1,1,'2024-11-29 02:41:46','2024-11-29 02:41:46'),(7,9,1,1,1,'2025-01-27 19:16:06','2025-01-27 19:16:06'),(8,3,1,1,2,'2025-02-07 17:53:55','2025-02-07 17:53:55'),(9,3,1,1,2,'2025-02-07 18:14:07','2025-02-07 18:14:07'),(10,3,1,1,2,'2025-02-07 18:30:28','2025-02-07 18:30:28'),(11,3,1,1,1,'2025-02-07 18:45:50','2025-02-07 18:45:50'),(12,2,15,2,3,'2025-02-13 17:55:30','2025-02-13 17:55:30'),(13,2,15,2,3,'2025-02-13 17:58:53','2025-02-13 17:58:53'),(14,2,15,2,3,'2025-02-13 18:08:50','2025-02-13 18:08:50'),(15,2,15,2,3,'2025-02-13 18:10:04','2025-02-13 18:10:04'),(16,2,15,2,3,'2025-02-13 18:11:19','2025-02-13 18:11:19'),(17,2,15,2,3,'2025-02-13 18:12:59','2025-02-13 18:12:59'),(18,2,15,2,3,'2025-02-13 18:14:29','2025-02-13 18:14:29'),(19,2,1,1,1,'2025-07-18 20:14:52','2025-07-18 20:14:52'),(20,2,1,1,2,'2025-07-25 02:04:06','2025-07-25 02:04:06'),(21,2,1,1,2,'2025-07-25 02:06:54','2025-07-25 02:06:54'),(22,1,1,1,6,'2025-07-31 02:18:24','2025-07-31 02:18:24'),(23,19,1,1,5,'2025-09-04 00:35:10','2025-09-04 00:35:10');

--
-- Table structure for table `estimate_status_logs`
--

CREATE TABLE `estimate_status_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comments` varchar(191) NOT NULL,
  `old_status` varchar(191) NOT NULL,
  `new_status` varchar(191) NOT NULL,
  `estimate_id` bigint(20) unsigned NOT NULL,
  `responsable_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `estimate_status_logs_estimate_id_foreign` (`estimate_id`),
  KEY `estimate_status_logs_responsable_id_foreign` (`responsable_id`),
  CONSTRAINT `estimate_status_logs_estimate_id_foreign` FOREIGN KEY (`estimate_id`) REFERENCES `estimates` (`id`),
  CONSTRAINT `estimate_status_logs_responsable_id_foreign` FOREIGN KEY (`responsable_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `estimate_status_logs`
--


--
-- Table structure for table `estimates`
--

CREATE TABLE `estimates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `total_down_payment` double NOT NULL,
  `monthly_down_payment_amount` double DEFAULT NULL,
  `down_payment_installments` int(11) DEFAULT NULL,
  `down_payment_percentage` int(11) NOT NULL,
  `total_partial_payments` double NOT NULL,
  `monthly_partial_payments_amount` double NOT NULL,
  `partial_payments_installments` int(11) NOT NULL,
  `partial_payments_percentage` int(11) NOT NULL,
  `settlement_amount` double NOT NULL,
  `settlement_amount_percentage` int(11) NOT NULL,
  `list_price` double NOT NULL,
  `origin` varchar(191) NOT NULL,
  `status` varchar(191) NOT NULL,
  `unit_id` bigint(20) unsigned NOT NULL,
  `prospect_id` bigint(20) unsigned DEFAULT NULL,
  `customer_id` bigint(20) unsigned DEFAULT NULL,
  `assigned_to` bigint(20) unsigned DEFAULT NULL,
  `payment_plan_id` bigint(20) unsigned NOT NULL,
  `close_date` timestamp NULL DEFAULT NULL,
  `expiration_date` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `estimates_unit_id_foreign` (`unit_id`),
  KEY `estimates_prospect_id_foreign` (`prospect_id`),
  KEY `estimates_assigned_to_foreign` (`assigned_to`),
  KEY `estimates_payment_plan_id_foreign` (`payment_plan_id`),
  KEY `estimates_customer_id_foreign` (`customer_id`),
  CONSTRAINT `estimates_assigned_to_foreign` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`id`),
  CONSTRAINT `estimates_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  CONSTRAINT `estimates_payment_plan_id_foreign` FOREIGN KEY (`payment_plan_id`) REFERENCES `payment_plans` (`id`),
  CONSTRAINT `estimates_prospect_id_foreign` FOREIGN KEY (`prospect_id`) REFERENCES `prospects` (`id`),
  CONSTRAINT `estimates_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `estimates`
--

INSERT INTO `estimates` VALUES (1,128800,13,13,70,11040,11040,1,20,44160,10,184000,'portal','pending_assignment',1,1,NULL,3,2,NULL,NULL,NULL,'2024-09-27 02:46:35','2024-11-07 04:30:55'),(2,128800,10,10,70,11040,5,5,20,44160,10,184000,'portal','pending_assignment',1,2,NULL,3,2,NULL,NULL,NULL,'2024-09-27 02:58:04','2024-11-07 04:28:22'),(3,95000,10,10,50,19000,4,4,20,76000,30,190000,'portal','pending_assignment',1,1,NULL,NULL,3,NULL,NULL,'2024-12-07 02:06:33','2024-10-09 02:04:50','2024-12-07 02:06:33'),(4,95000,11,11,50,19000,6333.33,3,20,76000,30,190000,'portal','pending_assignment',1,1,NULL,NULL,3,NULL,NULL,NULL,'2024-10-09 05:51:37','2024-10-09 05:52:15'),(5,78400,12,12,40,23520,2,2,20,94080,40,196000,'portal','pending_assignment',1,2,NULL,NULL,4,NULL,NULL,NULL,'2024-10-09 05:53:03','2024-10-09 05:53:03'),(6,40000,10,10,20,32000,4,4,20,128000,60,200000,'portal','pending_assignment',1,1,NULL,NULL,6,NULL,NULL,NULL,'2024-10-09 05:54:15','2024-10-09 05:54:15'),(7,78400,7840,10,40,23520,5880,4,20,94080,40,196000,'portal','pending_assignment',1,1,NULL,NULL,4,NULL,NULL,NULL,'2024-10-09 05:59:02','2024-10-09 05:59:02'),(8,95000,9500,10,50,28500,9500,3,30,66500,20,190000,'portal','pending_assignment',1,1,NULL,NULL,3,NULL,NULL,NULL,'2024-11-07 05:00:06','2024-11-07 05:00:06'),(9,95000,9500,10,50,28500,9500,3,30,66500,20,190000,'portal','pending_assignment',1,NULL,1,NULL,3,NULL,NULL,NULL,'2024-11-07 05:06:19','2024-11-07 05:06:19'),(10,78400,784,NULL,40,47040,4704,10,40,70560,20,196000,'portal','pending_assignment',1,NULL,1,NULL,4,NULL,NULL,NULL,'2024-11-07 05:29:08','2024-11-07 05:29:08'),(12,90000,90000,1,50,54000,5400,10,30,36000,20,180000,'portal','pending_assignment',1,1,NULL,NULL,1,NULL,NULL,NULL,'2024-11-22 01:40:20','2024-11-22 01:48:00'),(13,90000,90000,1,50,54000,5400,10,30,36000,20,180000,'portal','winned',1,1,NULL,NULL,1,NULL,'2024-12-12 03:36:03',NULL,'2024-11-27 03:36:03','2024-11-27 04:43:44'),(14,90000,90000,1,50,54000,4500,12,30,36000,20,180000,'portal','winned',1,NULL,2,NULL,1,NULL,'2024-12-14 02:14:59',NULL,'2024-11-29 02:14:59','2024-11-29 02:26:09'),(15,90000,90000,1,50,54000,4500,12,30,36000,20,180000,'portal','winned',1,3,NULL,NULL,1,NULL,'2024-12-14 02:28:53',NULL,'2024-11-29 02:28:53','2024-11-29 02:29:12'),(16,90000,90000,1,50,54000,4500,12,30,36000,20,180000,'portal','pending_assignment',1,3,NULL,NULL,1,NULL,'2024-12-14 02:32:34',NULL,'2024-11-29 02:32:34','2024-11-29 02:32:34'),(17,90000,90000,1,50,54000,4153.85,13,30,36000,20,180000,'portal','winned',1,2,NULL,NULL,1,NULL,'2024-12-14 02:33:39',NULL,'2024-11-29 02:33:39','2024-11-29 02:33:51'),(18,90000,90000,1,50,54000,4500,12,30,36000,20,180000,'portal','pending_assignment',1,5,NULL,NULL,1,NULL,'2024-12-14 02:38:14',NULL,'2024-11-29 02:38:14','2024-11-29 02:38:14'),(19,90000,90000,1,50,54000,4500,12,30,36000,20,180000,'portal','winned',1,NULL,8,5,1,NULL,'2024-12-14 02:41:35',NULL,'2024-11-29 02:41:35','2025-03-06 01:27:48'),(20,11250000,11250000,1,50,6750000,6750000,1,30,4500000,20,22500000,'portal','winned',3,NULL,2,5,9,'2025-02-01 06:00:00','2025-01-30 00:29:08',NULL,'2025-01-15 00:29:08','2025-03-06 01:27:48'),(21,135,135,1,50,81,7.36,11,30,54,20,270,'portal','winned',2,NULL,3,5,1,NULL,'2025-02-07 02:32:12',NULL,'2025-01-23 02:32:12','2025-03-06 01:27:48'),(22,90000,90000,1,50,54000,5400,10,30,36000,20,180000,'portal','pending_assignment',1,NULL,3,NULL,1,NULL,'2025-02-22 18:45:41',NULL,'2025-02-07 18:45:41','2025-02-07 18:45:50'),(23,90000,90000,1,50,54000,6750,8,30,36000,20,180000,'web','pending_assignment',1,8,NULL,NULL,1,NULL,'2025-04-20 15:20:03',NULL,'2025-04-05 16:20:03','2025-04-05 16:20:03'),(24,90000,90000,1,50,54000,6750,8,30,36000,20,180000,'web','pending_assignment',1,8,NULL,NULL,1,NULL,'2025-04-20 15:21:05',NULL,'2025-04-05 16:21:05','2025-04-05 16:21:05'),(25,90000,90000,1,50,54000,6750,8,30,36000,20,180000,'web','pending_assignment',1,8,NULL,NULL,1,NULL,'2025-04-20 15:23:10',NULL,'2025-04-05 16:23:10','2025-04-05 16:23:10'),(26,90000,90000,1,50,54000,6750,8,30,36000,20,180000,'web','pending_assignment',1,8,NULL,NULL,1,NULL,'2025-04-22 13:44:16',NULL,'2025-04-07 13:44:16','2025-04-07 13:44:16'),(27,90000,90000,1,50,54000,2842.1052631579,19,30,36000,20,180000,'portal','winned',1,NULL,2,NULL,1,'2025-05-06 05:00:00','2025-08-01 00:03:40',NULL,'2025-07-17 00:03:40','2025-07-18 20:14:52'),(28,135,135,1,50,81,0.20506329113924,395,30,54,20,270,'portal','winned',2,NULL,2,NULL,1,'1994-01-02 06:00:00','2025-08-09 02:03:42',NULL,'2025-07-25 02:03:42','2025-07-25 02:06:54'),(29,90,90,1,50,54,2.3478260869565,23,30,36,20,180,'portal','winned',6,NULL,1,4,1,'2025-01-02 06:00:00','2025-08-15 02:10:49',NULL,'2025-07-31 02:10:49','2025-07-31 02:18:24'),(30,90,90,1,50,54,3.6,15,30,36,20,180,'portal','winned',5,NULL,19,3,1,'2025-09-03 05:00:00','2025-09-19 00:31:11',NULL,'2025-09-04 00:31:11','2025-09-04 00:35:10'),(31,90,90,1,50,54,3.86,14,30,36,20,180,'portal','pending_assignment',7,1,NULL,4,1,NULL,'2025-11-01 02:53:41',NULL,'2025-10-17 01:53:41','2025-10-17 01:53:41');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `house_development_amenities`
--

CREATE TABLE `house_development_amenities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `image` varchar(191) NOT NULL,
  `description` text NOT NULL,
  `house_development_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `house_development_amenities_house_development_id_foreign` (`house_development_id`),
  CONSTRAINT `house_development_amenities_house_development_id_foreign` FOREIGN KEY (`house_development_id`) REFERENCES `house_developments` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `house_development_amenities`
--

INSERT INTO `house_development_amenities` VALUES (1,'Pet park 2','house-development-images/7zBUjyn48UQam7cUTzOu7qw6Ta3U9UZPEKFmD4We.png','-',1,NULL,'2024-08-08 17:17:27','2024-08-08 23:22:02'),(2,'Tienda','house-development-images/6fI0veVfxpPszqHZpnysqJInTYaM8rxCuZrIssEq.png','-',1,NULL,'2024-08-08 17:17:27','2024-08-08 23:25:08'),(3,'Hospital','house-development-images/aMFrLBbkPkGcjb2XqdjzX61bIKn1MASDdUpsckqj.png','-',1,NULL,'2024-08-08 23:37:43','2024-08-08 23:42:50'),(4,'Amenidad 1','house-development-images/cEajV9J9T0RrkMCGtxpEQKacL8R1Ef8fm8mZpRbL.png','-',2,NULL,'2024-08-09 01:19:01','2024-08-09 01:19:01'),(5,'Amenidad 1','house-development-images/JUh6Ec9Bv7ej9GqfYGL6eSxurcNJVRYOfMKx0v4b.jpg','-',6,NULL,'2024-09-11 01:58:36','2024-09-11 01:58:36'),(6,'Amenidad 2','-','-',6,NULL,'2024-09-11 01:58:36','2024-09-11 01:58:36'),(7,'Aemindad 3','house-development-images/ENTgBVflUZu3GvN9XZhRVaoRF9vJZUhfAePWcp1D.jpg','-',6,NULL,'2024-09-11 01:58:36','2024-09-11 01:58:36'),(8,'Asdasdas','house-development-images/ti1fBP9NLvHyCBWgxnSopjrcLLSULuZ5Gj4HSHkH.jpg','-',7,NULL,'2024-12-03 00:04:43','2024-12-03 00:04:43'),(9,'CasdAsd','house-development-images/09UQmskGOkY0mWeDRAaQ3pwt8PJA3AWzV8vBw1MO.jpg','-',7,NULL,'2024-12-03 00:04:43','2024-12-03 00:04:43'),(10,'Alberca','house-development-images/AN0zJMRBjdTLRs083ECu3mB7tCPTMrzzrIL8HUQk.jpg','-',8,NULL,'2024-12-03 00:07:33','2024-12-03 00:07:33'),(11,'asdfasdf','house-development-images/bcjT1sCp7xwcNKGTEl0i4PmdtOnoenhsRiDAb5JZ.png','-',9,NULL,'2024-12-06 23:46:23','2024-12-06 23:46:23'),(12,'GOLF','house-development-images/hDWif9zweT9liXGHLkkmgwfUzZFjHLFLj5xTfZTp.jpg','-',10,NULL,'2024-12-07 00:18:46','2024-12-07 00:18:46'),(13,'asdasdasd','house-development-images/iU8PNs0GpesZEFgc5UxzjZaR56SA1uhC6gMGegjM.jpg','-',11,NULL,'2024-12-07 00:20:04','2024-12-07 00:20:04'),(14,'hjklhj kl','house-development-images/cmE9GAOQZmcuv1TBGfHEPrrGVf2amwZxgxUpDPx0.png','-',12,NULL,'2024-12-07 00:24:53','2024-12-07 00:24:53'),(15,'aaaaaaaaaaaaaaaaa','house-development-images/FcqBnfBkyarRSRuJPbBCrxYjsgaZyQS8zRgyvu11.jpg','-',13,NULL,'2024-12-07 00:30:09','2024-12-07 00:30:09'),(16,'bbbbbbbbbbb','house-development-images/a0oStJyFLzmJWfvS5lczodr62AsckpNd6W7exaWm.jpg','-',14,NULL,'2024-12-07 00:40:20','2024-12-07 00:40:20'),(17,'test','house-development-images/GvzziFAqLqtDBDt3Lt3k2T6m9UYa8ZwZ7CfdgvHC.jpg','-',15,NULL,'2025-01-15 00:09:33','2025-01-15 00:09:33');

--
-- Table structure for table `house_development_blueprints`
--

CREATE TABLE `house_development_blueprints` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `path` varchar(191) NOT NULL,
  `house_development_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `house_development_blueprints_house_development_id_foreign` (`house_development_id`),
  CONSTRAINT `house_development_blueprints_house_development_id_foreign` FOREIGN KEY (`house_development_id`) REFERENCES `house_developments` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `house_development_blueprints`
--

INSERT INTO `house_development_blueprints` VALUES (1,'Planos principales','house-developments-blueprints/kOurSZDvgF1NpfBbx21I4lGEyKELL78WgE3AUmHr.pdf',1,NULL,'2024-08-08 17:17:27','2024-08-09 00:47:20'),(2,'Planos principales 2','house-developments-blueprints/NwPayi1np1aE360plUSIEd5tsbuTrh7HyCu0on9t.pdf',1,NULL,'2024-08-09 00:54:01','2024-08-09 00:54:01'),(3,'Planos principales 2','house-developments-blueprints/ZZ8m8ssV3zNR3D05hK6pSj0MZDzI1AQT4j6dY7ib.pdf',1,NULL,'2024-08-09 00:54:55','2024-08-09 00:58:14'),(4,'Altosur_brochure general_compressed.pdf','house-developments-blueprints/XUSQUGvPeeIJ9K9nsStNYsVpGYHaknynFWt01ZoL.pdf',14,NULL,'2024-12-07 00:40:20','2024-12-07 00:40:20'),(5,'Propuesta_cotización2.pdf','house-developments-blueprints/1mTNLpLBzqTdMrLfED6aGzeoNsFZnFKg47dVpHIK.pdf',14,NULL,'2024-12-07 00:40:20','2024-12-07 00:40:20'),(6,'PruebasWeb_PB.pdf','house-developments-blueprints/hhuDr82VtVNXjc97dyZL3Jw5fND31jxjHsWqOfIV.pdf',14,NULL,'2024-12-07 00:40:20','2024-12-07 00:40:20');

--
-- Table structure for table `house_development_floor_web_images`
--

CREATE TABLE `house_development_floor_web_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `path` text NOT NULL,
  `house_development_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `house_development_floor_web_images_house_development_id_foreign` (`house_development_id`),
  CONSTRAINT `house_development_floor_web_images_house_development_id_foreign` FOREIGN KEY (`house_development_id`) REFERENCES `house_developments` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `house_development_floor_web_images`
--

INSERT INTO `house_development_floor_web_images` VALUES (1,'image_gallery','house-development-images/BTnTLoFEXfC8c426uri9PIlOYzDH5S5uFUQFRVdr.jpg',1,'2025-07-17 02:26:10','2025-07-17 02:26:10'),(2,'image_gallery','house-development-images/7tFSTFLUCxHFO2v8JAOJOEEOO45dqhBhj8ldgJE7.jpg',1,'2025-07-17 02:26:10','2025-07-17 02:26:10'),(3,'image_gallery','house-development-images/znhq0wnmrgJjyWIr98XSt9bqz1b2jULzqr0D0msp.png',1,'2025-07-17 02:26:10','2025-07-17 02:26:10');

--
-- Table structure for table `house_development_highlights`
--

CREATE TABLE `house_development_highlights` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `icon` varchar(191) NOT NULL,
  `house_development_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `house_development_highlights_house_development_id_foreign` (`house_development_id`),
  CONSTRAINT `house_development_highlights_house_development_id_foreign` FOREIGN KEY (`house_development_id`) REFERENCES `house_developments` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `house_development_highlights`
--

INSERT INTO `house_development_highlights` VALUES (1,'HighLight 1','icon1',1,NULL,'2024-08-08 17:17:27','2024-08-08 21:17:40'),(2,'HighLight 2','icon2',1,NULL,'2024-08-08 17:17:27','2024-08-08 21:17:55'),(3,'HighLight 3','icon2',1,NULL,'2024-08-08 22:30:14','2024-08-08 22:30:14'),(4,'Vista H4','icon1',1,NULL,'2024-08-08 22:31:08','2024-08-08 22:32:14'),(5,'High 1','icon1',2,NULL,'2024-08-09 01:14:05','2024-08-09 01:14:05'),(6,'High 2','icon2',2,NULL,'2024-08-09 01:14:05','2024-08-09 01:14:05'),(7,'High 3','icon2',2,NULL,'2024-08-09 01:14:05','2024-08-09 01:14:05'),(8,'Hospitales','icon1',3,NULL,'2024-08-27 02:02:09','2024-08-27 02:02:09'),(9,'asdasd','icon1',4,NULL,'2024-09-11 01:42:56','2024-09-11 01:42:56'),(10,'asdfsadf','icon2',5,NULL,'2024-09-11 01:43:12','2024-09-11 01:43:12'),(11,'asd','icon1',6,NULL,'2024-09-11 01:58:36','2024-09-11 01:58:36'),(12,'asdfasdf','icon1',7,NULL,'2024-12-03 00:04:43','2024-12-03 00:04:43'),(13,'asdfasdfasdfasdf','icon2',7,NULL,'2024-12-03 00:04:43','2024-12-03 00:04:43'),(14,'Zona pet','icon1',8,NULL,'2024-12-03 00:07:33','2024-12-03 00:07:33'),(15,'asdfasdf','icon1',9,NULL,'2024-12-06 23:46:23','2024-12-06 23:46:23'),(16,'TESDT','icon1',10,NULL,'2024-12-07 00:18:46','2024-12-07 00:18:46'),(17,'asdasdasd','icon1',11,NULL,'2024-12-07 00:20:04','2024-12-07 00:20:04'),(18,'jhklhjkljhkl','icon1',12,NULL,'2024-12-07 00:24:53','2024-12-07 00:24:53'),(19,'aaaaaaaaaaaaaaaaa','icon1',13,NULL,'2024-12-07 00:30:09','2024-12-07 00:30:09'),(20,'bbbbbbbbbbb','icon2',14,NULL,'2024-12-07 00:40:20','2024-12-07 00:40:20'),(21,'Icono 1','icon1',15,NULL,'2025-01-15 00:09:33','2025-01-15 00:09:33'),(22,'Icono 2','icon2',15,NULL,'2025-01-15 00:09:33','2025-01-15 00:09:33'),(23,'Icono 3','icon3',15,NULL,'2025-01-15 00:09:33','2025-01-15 00:09:33'),(24,'Icono 4','icon4',15,NULL,'2025-01-15 00:16:35','2025-01-15 00:16:35'),(25,'a','icon1',16,NULL,'2025-07-17 01:56:36','2025-07-17 01:56:36'),(26,'b','icon2',16,NULL,'2025-07-17 01:56:36','2025-07-17 01:56:36');

--
-- Table structure for table `house_development_images`
--

CREATE TABLE `house_development_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `path` text NOT NULL,
  `house_development_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `house_development_images_house_development_id_foreign` (`house_development_id`),
  CONSTRAINT `house_development_images_house_development_id_foreign` FOREIGN KEY (`house_development_id`) REFERENCES `house_developments` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `house_development_images`
--

INSERT INTO `house_development_images` VALUES (2,'main_image','house-development-images/Y006lOIbN3a4qkC0UBvuqGbA3u8RPi187o3RZsGa.jpg',1,NULL,'2024-08-08 17:17:27','2024-08-08 18:15:22'),(3,'image_gallery','house-development-images/v9PPxSSuzFCektl5UJaqK2OC8ZhtXYOvMfnagvOE.jpg',1,NULL,'2024-08-08 17:17:27','2024-08-08 17:17:27'),(4,'image_gallery','house-development-images/Iyek9lPThYkPyW0m38nrVWHP3vGO0N2jUxV5OrDM.jpg',1,NULL,'2024-08-08 17:17:27','2024-08-08 17:17:27'),(5,'image_gallery','house-development-images/rYN6PWCdUDWrGrNBMR1vC6MlTRm2jLR7YYChjarJ.jpg',1,NULL,'2024-08-08 17:17:27','2024-08-08 17:17:27'),(6,'image_gallery','house-development-images/BhLJshmrGoPJLpWirLGEvNxpODjKI4jbKRuwyjD3.jpg',1,NULL,'2024-08-08 17:17:27','2024-08-08 17:17:27'),(7,'image_gallery','house-development-images/KjQtzQfUlLTI5iA06oevTu3uDXVEv3OpH9FIviMQ.jpg',1,NULL,'2024-08-08 17:17:27','2024-08-08 17:17:27'),(8,'logo','house-development-images/LQHmRGKXWZlpjPH5fD8uws7qvfEVe8SBBk9wIGpM.png',1,NULL,'2024-08-08 18:13:59','2024-08-08 18:14:29'),(9,'image_gallery','house-development-images/x9V8BBRXIu3Zi1FWke437MXSG4i79EASdoPEkjLG.png',1,NULL,'2024-08-08 18:25:38','2024-08-08 18:25:38'),(10,'image_gallery','house-development-images/dXgEYgXfcHH1AViNRD6EFO4N5eAvCQsKZhqKHSN1.png',1,NULL,'2024-08-08 18:25:38','2024-08-08 18:25:38'),(11,'image_gallery','house-development-images/tCfs9m9Y3JeQGylobPeHjNbIwmZpGqudJYHl8fST.png',1,NULL,'2024-08-08 18:25:38','2024-08-08 18:25:38'),(12,'image_gallery','house-development-images/4iAfJrEuADo81LcddoyGyUcCmspyoKLMYTWRWaQA.png',1,NULL,'2024-08-08 18:26:26','2024-08-08 18:26:26'),(13,'image_gallery','house-development-images/Y8SckVUwuZow5CUEH0yiOxOHLF0K0F0G9UQ4vjDI.png',1,NULL,'2024-08-08 18:26:45','2024-08-08 18:26:45'),(14,'logo','house-development-images/siZNSECHAVnRJpAwS6PmYBOX2v1OM5gQfVMn5tFo.png',2,NULL,'2024-08-09 01:14:05','2024-08-09 01:14:05'),(15,'main_image','house-development-images/qR2o5EP0iw5VDovabLyqxBUp8u8UYEN8FtquGuET.png',2,NULL,'2024-08-09 01:14:05','2024-08-09 01:14:05'),(16,'logo','house-development-images/2VZLqMetHGmY4e1V59p3GN1EERq3blEtcDG3DsbO.jpg',3,NULL,'2024-08-27 02:02:09','2024-08-27 02:02:09'),(17,'main_image','house-development-images/vat3t1okSuIMfPq7nwp7WEras7PRhlFIyAixxgSk.jpg',3,NULL,'2024-08-27 02:02:09','2024-08-27 02:02:09'),(18,'logo','house-development-images/NCwDkECUdaNL8yW6esdPHUhpaTTa5fcaZVvw2KXt.jpg',7,NULL,'2024-12-03 00:04:43','2024-12-03 00:04:43'),(19,'main_image','house-development-images/eHANhobKgrCraNt50VSXfHm6eG9WOoYbNK1sSryv.jpg',7,NULL,'2024-12-03 00:04:43','2024-12-03 00:04:43'),(20,'image_gallery','house-development-images/5FiHKnQkfB8fC2E0K2fUjUNQL0LMLlv0x7IXWcVx.jpg',7,NULL,'2024-12-03 00:04:43','2024-12-03 00:04:43'),(21,'image_gallery','house-development-images/7mvicqKg9DQHJ63caruLHQRHasr4oyaIHaZE5jMx.jpg',7,NULL,'2024-12-03 00:04:43','2024-12-03 00:04:43'),(22,'image_gallery','house-development-images/gLWlOy6ytA98NC0ZlpAR9KrmhSoIQJvS6r7ljl9y.jpg',7,NULL,'2024-12-03 00:04:43','2024-12-03 00:04:43'),(23,'image_gallery','house-development-images/1R0sowbTZl24AjbrtXsCd0B9wVWnleIpA6hiOITF.jpg',7,NULL,'2024-12-03 00:04:43','2024-12-03 00:04:43'),(24,'logo','house-development-images/7DxZ556nwMnJrGq7oMJIKlvZiJ7kCX8AtTZaw6Jb.jpg',8,NULL,'2024-12-03 00:07:33','2024-12-03 00:07:33'),(25,'main_image','house-development-images/vCpz2fUdg4KBdp0aIzxoF3iRUiNdBt3lYIBIrxRh.jpg',8,NULL,'2024-12-03 00:07:33','2024-12-03 00:07:33'),(26,'image_gallery','house-development-images/iiFjLM66arCy4PTeDKpQEwJsHE319nER0H7TU5gY.jpg',8,NULL,'2024-12-03 00:07:33','2024-12-03 00:07:33'),(27,'image_gallery','house-development-images/Gi143UgtBnJc6GwxSSiOZ6ywm3XHQWwzZLyDUxSn.jpg',8,NULL,'2024-12-03 00:07:33','2024-12-03 00:07:33'),(28,'image_gallery','house-development-images/0sV5LONCWnaqnARJLXyHqvO4hRN9jzHf9py1NC2U.jpg',8,NULL,'2024-12-03 00:07:33','2024-12-03 00:07:33'),(29,'image_gallery','house-development-images/jklIswYsifUN2p3Z4DO9Nq1akwlWPmJIYgQqIjBs.jpg',8,NULL,'2024-12-03 00:07:33','2024-12-03 00:07:33'),(30,'logo','house-development-images/67538ccf2edb7.jpg',9,NULL,'2024-12-06 23:46:23','2024-12-06 23:46:23'),(31,'main_image','house-development-images/67538ccf37337.jpg',9,NULL,'2024-12-06 23:46:23','2024-12-06 23:46:23'),(32,'image_gallery','house-development-images/67538ccf446a1.jpg',9,NULL,'2024-12-06 23:46:23','2024-12-06 23:46:23'),(33,'image_gallery','house-development-images/67538ccf4bbd7.jpg',9,NULL,'2024-12-06 23:46:23','2024-12-06 23:46:23'),(34,'image_gallery','house-development-images/67538ccf53532.jpg',9,NULL,'2024-12-06 23:46:23','2024-12-06 23:46:23'),(35,'image_gallery','house-development-images/67538ccf5afef.jpg',9,NULL,'2024-12-06 23:46:23','2024-12-06 23:46:23'),(36,'image_gallery','house-development-images/67538ccf62165.jpg',9,NULL,'2024-12-06 23:46:23','2024-12-06 23:46:23'),(37,'logo','house-development-images/67539465728f0.jpg',10,NULL,'2024-12-07 00:18:45','2024-12-07 00:18:45'),(38,'main_image','house-development-images/675394657dc31.jpg',10,NULL,'2024-12-07 00:18:45','2024-12-07 00:18:45'),(39,'image_gallery','house-development-images/6753946586ba5.jpg',10,NULL,'2024-12-07 00:18:45','2024-12-07 00:18:45'),(40,'image_gallery','house-development-images/675394659385d.jpg',10,NULL,'2024-12-07 00:18:45','2024-12-07 00:18:45'),(41,'image_gallery','house-development-images/67539465ad777.jpg',10,NULL,'2024-12-07 00:18:45','2024-12-07 00:18:45'),(42,'image_gallery','house-development-images/67539465cb44e.jpg',10,NULL,'2024-12-07 00:18:45','2024-12-07 00:18:45'),(43,'image_gallery','house-development-images/67539465e86af.jpg',10,NULL,'2024-12-07 00:18:45','2024-12-07 00:18:45'),(44,'image_gallery','house-development-images/6753946609ead.jpg',10,NULL,'2024-12-07 00:18:46','2024-12-07 00:18:46'),(45,'image_gallery','house-development-images/675394662736c.jpg',10,NULL,'2024-12-07 00:18:46','2024-12-07 00:18:46'),(46,'logo','house-development-images/675394b40f0e6.jpg',11,NULL,'2024-12-07 00:20:04','2024-12-07 00:20:04'),(47,'main_image','house-development-images/675394b4215c5.jpg',11,NULL,'2024-12-07 00:20:04','2024-12-07 00:20:04'),(48,'image_gallery','house-development-images/675394b42e421.jpg',11,NULL,'2024-12-07 00:20:04','2024-12-07 00:20:04'),(49,'image_gallery','house-development-images/675394b4355a8.jpg',11,NULL,'2024-12-07 00:20:04','2024-12-07 00:20:04'),(50,'image_gallery','house-development-images/675394b43cb14.jpg',11,NULL,'2024-12-07 00:20:04','2024-12-07 00:20:04'),(51,'image_gallery','house-development-images/675394b444305.jpg',11,NULL,'2024-12-07 00:20:04','2024-12-07 00:20:04'),(52,'logo','house-development-images/675395d544450.jpg',12,NULL,'2024-12-07 00:24:53','2024-12-07 00:24:53'),(53,'main_image','house-development-images/675395d54656a.jpg',12,NULL,'2024-12-07 00:24:53','2024-12-07 00:24:53'),(54,'image_gallery','house-development-images/675395d55447a.jpg',12,NULL,'2024-12-07 00:24:53','2024-12-07 00:24:53'),(55,'image_gallery','house-development-images/675395d55b679.jpg',12,NULL,'2024-12-07 00:24:53','2024-12-07 00:24:53'),(56,'image_gallery','house-development-images/675395d56334b.jpg',12,NULL,'2024-12-07 00:24:53','2024-12-07 00:24:53'),(57,'image_gallery','house-development-images/675395d56b7d8.jpg',12,NULL,'2024-12-07 00:24:53','2024-12-07 00:24:53'),(58,'image_gallery','house-development-images/675395d572c72.jpg',12,NULL,'2024-12-07 00:24:53','2024-12-07 00:24:53'),(59,'logo','house-development-images/675397116f2ea.jpg',13,NULL,'2024-12-07 00:30:09','2024-12-07 00:30:09'),(60,'main_image','house-development-images/675397117963f.jpg',13,NULL,'2024-12-07 00:30:09','2024-12-07 00:30:09'),(61,'image_gallery','house-development-images/6753971189fb1.jpg',13,NULL,'2024-12-07 00:30:09','2024-12-07 00:30:09'),(62,'image_gallery','house-development-images/675397119ada1.jpg',13,NULL,'2024-12-07 00:30:09','2024-12-07 00:30:09'),(63,'image_gallery','house-development-images/67539711ac07d.jpg',13,NULL,'2024-12-07 00:30:09','2024-12-07 00:30:09'),(64,'logo','house-development-images/675399734702d.jpg',14,NULL,'2024-12-07 00:40:19','2024-12-07 00:40:19'),(65,'main_image','house-development-images/6753997353b22.jpg',14,NULL,'2024-12-07 00:40:19','2024-12-07 00:40:19'),(66,'image_gallery','house-development-images/675399735c789.jpg',14,NULL,'2024-12-07 00:40:19','2024-12-07 00:40:19'),(67,'image_gallery','house-development-images/6753997369980.jpg',14,NULL,'2024-12-07 00:40:19','2024-12-07 00:40:19'),(68,'image_gallery','house-development-images/6753997384481.jpg',14,NULL,'2024-12-07 00:40:19','2024-12-07 00:40:19'),(69,'image_gallery','house-development-images/67539973a2545.jpg',14,NULL,'2024-12-07 00:40:19','2024-12-07 00:40:19'),(70,'image_gallery','house-development-images/67539973c0360.jpg',14,NULL,'2024-12-07 00:40:19','2024-12-07 00:40:19'),(71,'image_gallery','house-development-images/67539973d6d2b.jpg',14,NULL,'2024-12-07 00:40:19','2024-12-07 00:40:19'),(72,'image_gallery','house-development-images/6753997401516.jpg',14,NULL,'2024-12-07 00:40:20','2024-12-07 00:40:20'),(73,'logo','house-development-images/6786fcbdbce1c.jpg',15,NULL,'2025-01-15 00:09:33','2025-01-15 00:09:33'),(74,'main_image','house-development-images/6786fcbdc683a.jpg',15,NULL,'2025-01-15 00:09:33','2025-01-15 00:09:33');

--
-- Table structure for table `house_development_report_progress`
--

CREATE TABLE `house_development_report_progress` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `description` text NOT NULL,
  `house_development_id` bigint(20) unsigned NOT NULL,
  `reported_date` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `house_development_report_progress`
--

INSERT INTO `house_development_report_progress` VALUES (1,'Avances  2','Se avanza en la obra 2',1,NULL,'2024-08-27 02:51:43','2024-08-27 02:18:15','2024-08-27 02:51:43'),(2,'Avances HD','Se avanza en la obra',1,NULL,NULL,'2024-08-27 02:18:33','2024-08-27 02:18:33'),(3,'Avances HD','Se avanza en la obra',1,NULL,NULL,'2024-08-27 02:19:25','2024-08-27 02:19:25'),(4,'Avances HD','Se avanza en la obra',1,NULL,NULL,'2024-08-27 02:19:50','2024-08-27 02:19:50'),(5,'Avances HD','Se avanza en la obra',1,NULL,NULL,'2024-08-27 02:19:58','2024-08-27 02:19:58'),(6,'Avances HD','Se avanza en la obra',1,NULL,NULL,'2024-08-27 02:20:22','2024-08-27 02:20:22'),(7,'Avances HD','Se avanza en la obra',1,NULL,NULL,'2024-08-27 02:21:41','2024-08-27 02:21:41'),(8,'Avances nuevos','Testing',1,NULL,NULL,'2024-08-27 02:22:20','2024-08-27 02:22:20'),(9,'Avances nuevos','Testing',1,'2025-02-05 06:00:00',NULL,'2024-08-27 02:22:53','2025-02-13 17:40:22'),(10,'AVANCE NUEVO ULTIMO','TEST2',1,'2025-02-10 06:00:00',NULL,'2024-08-27 02:23:52','2025-02-13 17:39:15'),(11,'ULTIMO AVANCE DE OBRA','DESCRIPCION DE ULTIMO AVANCE DE OBRA',1,'2025-02-01 06:00:00',NULL,'2025-02-13 17:12:20','2025-02-13 17:12:20');

--
-- Table structure for table `house_development_report_progress_media`
--

CREATE TABLE `house_development_report_progress_media` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `path` text NOT NULL,
  `hd_report_progress_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `house_development_report_progress_media`
--

INSERT INTO `house_development_report_progress_media` VALUES (1,'house-development-progress-reports/qwND1OgFR1NnvaPoeYw7aUlrHa9IvytxJI0aqi5V.jpg',6,NULL,'2024-08-27 02:20:22','2024-08-27 02:20:22'),(2,'house-development-progress-reports/W3pY5u5mzs3ooAei2a5FAEsAYebkchbIUokmwFcq.jpg',6,NULL,'2024-08-27 02:20:22','2024-08-27 02:20:22'),(3,'house-development-progress-reports/qai4onVStMQ6O7YhSIks0jgE27HMyo9FZZisR6L8.jpg',6,NULL,'2024-08-27 02:20:22','2024-08-27 02:20:22'),(4,'house-development-progress-reports/yszZS7U7zdGtDHoAXxULb9O7CHKDTFw3mBg5fQnO.jpg',7,NULL,'2024-08-27 02:21:41','2024-08-27 02:21:41'),(5,'house-development-progress-reports/W5njVTlx9qMJ9hxoNQInebUArBLcsh13qCBm0x1j.jpg',7,NULL,'2024-08-27 02:21:41','2024-08-27 02:21:41'),(6,'house-development-progress-reports/YgOqrdw0bSTk4LQ3vqPA2wxxEi6EuHDNFJtyeR0s.jpg',7,NULL,'2024-08-27 02:21:41','2024-08-27 02:21:41'),(7,'house-development-progress-reports/nsIm0FjizLPlNFiadOtkMjRkUxWdEx1lhbtZp0nu.jpg',8,NULL,'2024-08-27 02:22:20','2024-08-27 02:22:20'),(8,'house-development-progress-reports/sfWWuRA8zcJTOkpdELkz5ZF7OdL817kS2fbmQhl3.jpg',8,NULL,'2024-08-27 02:22:20','2024-08-27 02:22:20'),(9,'house-development-progress-reports/OWccjHUvHBbmW5gVV8KbUk7DUQGIR7aR042IIY84.jpg',9,NULL,'2024-08-27 02:22:53','2024-08-27 02:22:53'),(10,'house-development-progress-reports/UdJY209jkRt0wg5pIfHPGnG3P0fbYpPOsGtm340i.jpg',9,NULL,'2024-08-27 02:22:53','2024-08-27 02:22:53'),(11,'house-development-progress-reports/1GETonS2QexyvMdwcnnhH4o5cg5xO2Jvl9gbozqr.jpg',10,NULL,'2024-08-27 02:23:52','2024-08-27 02:23:52'),(12,'house-development-progress-reports/JsuxQhQkr2qYzL06b54PJcwdHNeAZEs2qJNFHRhS.jpg',10,NULL,'2024-08-27 02:23:52','2024-08-27 02:23:52'),(13,'house-development-progress-reports/Njb2FfDRHjF705CXJuTzwPKUkWyEio2OyAkfCxao.jpg',10,NULL,'2024-08-27 02:23:52','2024-08-27 02:23:52'),(15,'house-development-progress-reports/2Bg0WJYUVgomOXUqMwd73SYymFPIJjT3KCfpjQev.jpg',7,NULL,'2024-09-06 01:35:50','2024-09-06 01:35:50'),(16,'house-development-progress-reports/SGDo6GziAmTn7L0J9JXTUtleg8RBOmxYQl8HRUAw.jpg',11,NULL,'2025-02-13 17:12:20','2025-02-13 17:12:20'),(17,'house-development-progress-reports/Zbe5gaMD28AocfBx77tMUyJiC48u5aZvjHCJirnU.jpg',11,NULL,'2025-02-13 17:12:20','2025-02-13 17:12:20'),(18,'house-development-progress-reports/tGsgKiedK7TGx1cKFI6ZBrFbiPgojC8xM9jM7HnB.jpg',11,NULL,'2025-02-13 17:12:20','2025-02-13 17:12:20'),(19,'house-development-progress-reports/BXEapogZTh8x5gjWHF4U9p8SmWis5m3K8QvwCBZP.jpg',11,NULL,'2025-02-13 17:12:20','2025-02-13 17:12:20'),(20,'house-development-progress-reports/QdEYYdRq4Xh0ZWPt2QmaaKBdL27qCmxwYBoIaqyV.png',11,NULL,'2025-02-13 17:12:20','2025-02-13 17:12:20');

--
-- Table structure for table `house_development_views`
--

CREATE TABLE `house_development_views` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `house_development_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `house_development_views_house_development_id_foreign` (`house_development_id`),
  CONSTRAINT `house_development_views_house_development_id_foreign` FOREIGN KEY (`house_development_id`) REFERENCES `house_developments` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `house_development_views`
--

INSERT INTO `house_development_views` VALUES (1,'Vista 12',1,NULL,'2024-08-08 17:17:27','2024-08-08 21:15:10'),(2,'Vista 2',1,NULL,'2024-08-08 17:17:27','2024-08-08 17:17:27'),(3,'Vista 3',1,'2024-08-08 17:24:31','2024-08-08 17:17:43','2024-08-08 17:24:31'),(4,'Vista 4',1,NULL,'2024-08-08 17:24:48','2024-08-08 17:24:48'),(5,'Vista 1',2,NULL,'2024-08-09 01:19:17','2024-08-09 01:19:17'),(6,'Vista 2',2,NULL,'2024-08-09 01:20:57','2024-08-09 01:20:57'),(7,'Vista 3',2,NULL,'2024-08-09 01:21:46','2024-08-09 01:21:46'),(8,'asdfasdfasdf',7,NULL,'2024-12-03 00:04:43','2024-12-03 00:04:43'),(9,'sdfsdgwerfgasdf',7,NULL,'2024-12-03 00:04:43','2024-12-03 00:04:43'),(10,'Campo de golf',10,NULL,'2024-12-07 00:18:45','2024-12-07 00:18:45'),(11,'asdasdasd',11,NULL,'2024-12-07 00:20:04','2024-12-07 00:20:04'),(12,'Vista 1',15,NULL,'2025-04-04 02:49:37','2025-04-04 02:49:37'),(13,'Vista 2',15,NULL,'2025-04-04 02:49:42','2025-04-04 02:49:42');

--
-- Table structure for table `house_developments`
--

CREATE TABLE `house_developments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `description` text NOT NULL,
  `address` varchar(191) NOT NULL DEFAULT "-",
  `view_3d` text NOT NULL,
  `type` char(191) NOT NULL DEFAULT "h",
  `has_views` tinyint(1) NOT NULL DEFAULT 0,
  `levels` int(11) NOT NULL DEFAULT 1,
  `is_visible` char(191) NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `delivery_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `location_subtitle` varchar(191) DEFAULT NULL,
  `location_link` longtext DEFAULT NULL,
  `location_image` varchar(191) DEFAULT NULL,
  `housedevelopments_book` varchar(191) DEFAULT NULL,
  `highlights_description` varchar(191) DEFAULT NULL,
  `floorcharacteristics` varchar(191) DEFAULT NULL,
  `floorname` varchar(191) DEFAULT NULL,
  `detail_development_first_image` varchar(191) DEFAULT NULL,
  `detail_development_second_image` varchar(191) DEFAULT NULL,
  `detail_development_third_image` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `house_developments`
--

INSERT INTO `house_developments` VALUES (1,'Desarrollo 1 de pruebasasdfa sdfasdfasdf','Descripcion de pruebas','Av. Mexico #123','https://www.recorridohd.com','v',1,10,'1',NULL,'2026-12-25','2024-08-08 17:17:27','2025-07-17 02:27:31',NULL,NULL,NULL,'house-developments-blueprints/Ooqf0MjX5i1dRCHyKZhZBNpXg0M2OQ38Doh2EwIq.pdf',NULL,'Lobby,Restaurante,','PLANTA TEST','images/rhcDRv8zYJSPG1pAlAUdztEOLJCX8OtwIP0oIA3X.jpg','images/gCGLHidabjYxxkeBS1Ln8X8SqV8UDxE2dnbeGoIf.jpg','images/2c4B84Ga4lmrQQW6XPV1gR8rTO59PTEbVQYXeMHa.png'),(2,'Desarrollo 2','Descripcion 2 de desarollo','-','https://www.ubi.com','h',1,1,'0',NULL,'2024-08-31','2024-08-09 01:14:05','2025-06-23 14:25:45',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'Desarrollo de pruebas #3','Descripcion de pruebas 3','Av. De las Aves #43123','https:testing.com','h',0,1,'0',NULL,'2024-08-30','2024-08-27 02:02:09','2024-08-27 02:02:09',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'Test 4','descr','asdasdad',NULL,'h',0,1,'0',NULL,'2024-09-11','2024-09-11 01:42:56','2024-09-11 01:42:56',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'TEst 5','asdfasdf','asdfasdfasd',NULL,'h',0,1,'0',NULL,'2024-09-13','2024-09-11 01:43:12','2025-06-23 14:25:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'TEST 5','DESCR','asdasdasd',NULL,'h',0,1,'0',NULL,'2024-09-19','2024-09-11 01:58:36','2024-09-11 01:58:36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'Valle Imperial','asdfgasfdgqwerfasdfasdfqw','asdfasdfgasdfasdfasdfasd','asdfasdfasdf','h',1,1,'0',NULL,'2025-01-01','2024-12-03 00:04:43','2024-12-03 00:04:43',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'asdfasdfasdfasdfsadf','fgsdfgsdfgsdfgsdf','fgsadfgsd',NULL,'h',0,1,'0','2024-12-06 23:37:36','2024-12-30','2024-12-03 00:07:33','2024-12-06 23:37:36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'ghkjyuoluiol;uiolhjkl','asdfasdfasdfasdfasdfasdf','asdfasdgasdfasdfasdgf','asdfasdfasdfasdf','v',0,1,'0',NULL,'2024-12-31','2024-12-06 23:46:23','2024-12-06 23:46:23',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'Nuevo desarrollo de pruebas','asdasdasd','Av testing HD',NULL,'h',1,1,'0',NULL,'2025-01-31','2024-12-07 00:18:45','2024-12-07 00:18:45',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'sdfgsdfgsdfgsdfgsdfg','sadasdasdasdasd','asdasdasdasdasd',NULL,'h',1,1,'0',NULL,'2024-12-26','2024-12-07 00:20:04','2024-12-07 00:20:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'hjkljhkljhklhjklhjkljhkl','hjklhjklhjklhjkl','hjklhjklhjklhjkl','hjklhjkljhkl','h',0,1,'0',NULL,'2024-12-26','2024-12-07 00:24:53','2024-12-07 00:24:53',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'aaaaaaaaa','aaaaaaaaaaaaaaaaa','aaaaaaaaaaaaaaaaa','aaaaaaaaaaaaaaaaa','h',0,1,'0',NULL,'2024-12-25','2024-12-07 00:30:09','2024-12-07 00:30:09',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'bbbbbbbbbbb','bbbbbbbbbbb','bbbbbbbbbbb',NULL,'h',0,1,'0',NULL,'2027-12-06','2024-12-07 00:40:19','2024-12-07 00:40:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'Desarrollo Nuevo','PRUEBAS HD','asdasdas','asdasdasd','h',1,1,'0',NULL,'2025-01-31','2025-01-15 00:09:33','2025-04-04 02:49:37',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'TEST DESARROLLO','asdasdasdasdasd','asdasdasd',NULL,'h',0,1,'0',NULL,'2026-01-02','2025-07-17 01:56:36','2025-07-17 01:56:36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(191) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (74,'2014_09_11_000000_create_permission_tables',1),(75,'2014_09_12_000000_create_roles_table',1),(76,'2014_10_12_000000_create_users_table',1),(77,'2014_10_12_100000_create_password_resets_table',1),(78,'2016_06_01_000001_create_oauth_auth_codes_table',1),(79,'2016_06_01_000002_create_oauth_access_tokens_table',1),(80,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(81,'2016_06_01_000004_create_oauth_clients_table',1),(82,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(83,'2019_07_23_155807_create_jobs_table',1),(84,'2019_08_19_000000_create_failed_jobs_table',1),(85,'2024_07_16_213343_create_house_developments_table',1),(86,'2024_07_22_132541_create_typologies_table',1),(87,'2024_08_01_131856_create_typology_images_table',2),(88,'2024_08_09_002305_add_characteristics_typologies_to_typologies_table',2),(89,'2024_08_13_190455_create_payment_plans_table',2),(91,'2024_08_15_195008_add_column_is_visible_to_house_developments_table',3),(93,'2024_08_15_204049_create_house_development_report_progress_table',4),(94,'2024_08_13_004708_create_unit_stages_table',5),(95,'2024_08_13_004709_create_units_table',5),(96,'2024_08_13_130755_create_unit_blue_prints_table',5),(97,'2024_08_14_223529_create_unit_views_table',5),(98,'2024_08_19_005405_create_unit_prospects_table',5),(99,'2024_08_19_005418_create_unit_customers_table',5),(100,'2024_08_19_114229_add_prospect_field_to_units',5),(101,'2024_08_19_174021_create_price_updates_table',5),(102,'2024_08_26_205559_add_column_addres_to_house_developments_table',5),(106,'2024_09_05_205948_create_prospects_table',6),(107,'2024_09_05_210017_create_estimates_table',6),(108,'2024_09_05_214820_create_estimate_status_logs_table',6),(109,'2024_08_30_141036_create_customers_table',7),(110,'2024_08_30_141926_create_customer_blue_prints_table',7),(111,'2024_10_14_193527_add_customer_password_to_customers',8),(112,'2024_10_17_155526_create_customer_units_table',9),(113,'2024_10_18_141518_remove_columns_about_units_from_customers_table',9),(117,'2024_10_25_162254_modify_levels_nullable_in_units_table',10),(118,'2024_11_06_225412_add_column_to_estimates_table',10),(120,'2024_11_19_204553_add_columns_to_payment_plans_table',11),(121,'2024_11_13_152513_create_account_statements_table',12),(122,'2024_11_22_122342_create_typology_blue_prints_table',12),(123,'2024_11_22_142133_add_view_3d_to_typologies_table',12),(124,'2024_11_25_002550_add_unit_id_to_account_statements_table',12),(125,'2024_11_25_014951_create_account_statement_blue_prints_table',12),(126,'2024_11_25_113302_modify_payment_date_in_account_statements_table',12),(127,'2024_11_26_210830_add_column_expiration_date_to_estimates_table',13),(128,'2024_11_27_122618_add_tipo_de_pago_to_account_statements_table',14),(129,'2024_11_28_022824_create_account_statement_conciliations_table',14),(130,'2024_12_03_093327_change_columns_to_string_in_typologies_table',14),(131,'2024_12_03_094413_create_unit_images_table',14),(132,'2024_12_12_095649_make_debt_to_date_nullable',15),(133,'2025_01_08_160851_account_statement_blue_prints_id_to_conciliations',16),(134,'2025_01_27_155401_add_reset_password_token_to_customers_table',17),(135,'2025_02_07_125237_payment_type_to_account_statement_conciliations_table',18),(136,'2025_02_13_110750_add_column_to_house_development_report_progress_table',19),(137,'2025_02_13_114631_add_column_close_date_to_estimates_table',20),(138,'2025_02_26_150705_add_estimate_image_to_units_table',21),(139,'2025_04_01_180918_add_web_fields_to_house_developments_table',22),(140,'2025_04_01_230225_add_web_field_to_typologies_table',22),(141,'2025_04_07_061401_add_two_web_fields_to_typologies_table',23),(142,'2025_04_22_021446_create_house_development_floor_web_images_table',23),(143,'2025_04_22_030911_floor_web_fields_to_housedevelopment_table',23),(144,'2025_04_22_161955_add_three_images_web_fields_to_house_developments_table',23),(145,'2025_04_28_144517_change_location_link_type_in_house_developments_table',24),(146,'2025_07_16_195653_alter_columns_customers_table',24),(147,'2025_07_16_202842_alter_columns_payment_plans',25),(150,'2025_07_30_192715_add_columns_to_units_table',26);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(191) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(191) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(2,'App\\Models\\User',2),(2,'App\\Models\\User',6),(3,'App\\Models\\User',3),(3,'App\\Models\\User',4),(3,'App\\Models\\User',5);

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_auth_codes`
--


--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` VALUES (1,1,'2025-03-21 14:02:43','2025-03-21 14:02:43');

--
-- Table structure for table `payment_plans`
--

CREATE TABLE `payment_plans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `advance_percentage` decimal(5,2) NOT NULL,
  `montly_payment_percentage` decimal(5,2) NOT NULL DEFAULT 0.00,
  `last_payment` decimal(5,2) NOT NULL DEFAULT 0.00,
  `discount_percentage` decimal(5,2) NOT NULL,
  `house_development_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payment_plans_house_development_id_foreign` (`house_development_id`),
  CONSTRAINT `payment_plans_house_development_id_foreign` FOREIGN KEY (`house_development_id`) REFERENCES `house_developments` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_plans`
--

INSERT INTO `payment_plans` VALUES (1,50.00,30.00,20.00,10.00,1,NULL,'2024-08-15 23:51:16','2024-11-20 03:02:53'),(2,70.00,0.00,0.00,8.00,1,NULL,'2024-08-15 23:55:37','2024-08-15 23:55:37'),(3,0.00,0.00,100.00,0.00,1,NULL,'2024-08-15 23:55:51','2024-12-07 01:35:31'),(4,30.00,60.00,10.00,3.00,1,NULL,'2024-08-15 23:55:56','2024-12-07 02:17:23'),(5,30.00,10.20,0.05,1.20,1,NULL,'2024-08-15 23:56:11','2025-07-17 01:34:14'),(6,20.00,0.00,0.00,0.00,1,'2025-07-17 01:20:38','2024-08-15 23:56:17','2025-07-17 01:20:38'),(7,100.00,0.00,0.00,12.00,2,NULL,'2024-08-21 17:53:48','2024-08-21 17:53:57'),(9,50.00,30.00,20.00,10.00,15,NULL,'2025-01-15 00:26:11','2025-01-15 00:26:11'),(10,40.20,30.20,10.10,0.00,1,NULL,'2025-07-22 22:29:11','2025-07-23 22:59:35');

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `guard_name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'desarrollos','web','2025-02-13 16:54:00','2025-02-13 16:54:00'),(2,'configuracion','web','2025-02-13 16:54:00','2025-02-13 16:54:00'),(3,'detalle_desarrollo','web','2025-02-13 16:54:00','2025-02-13 16:54:00'),(4,'cotizaciones','web','2025-02-13 16:54:00','2025-02-13 16:54:00'),(5,'asignar_vendedor_cotizacion','web','2025-02-13 16:54:00','2025-02-13 16:54:00'),(6,'prospectos','web','2025-02-13 16:54:00','2025-02-13 16:54:00'),(7,'ganar_cotizacion','web','2025-02-13 16:54:00','2025-02-13 16:54:00'),(8,'conciliar_pagos','web','2025-02-13 16:54:00','2025-02-13 16:54:00');

--
-- Table structure for table `price_updates`
--

CREATE TABLE `price_updates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `old_price` double NOT NULL,
  `new_price` double NOT NULL,
  `date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `price_updateable_id` bigint(20) unsigned NOT NULL,
  `price_updateable_type` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `price_updates`
--

INSERT INTO `price_updates` VALUES (1,'Admin BW','admin@bwdigital.io',200,200000,'2024-09-17','2024-09-18 02:25:02','2024-09-18 02:25:02',1,'App\\Models\\Unit'),(2,'Admin BW','admin@bwdigital.io',25000000,15000000,'2025-04-03','2025-04-04 02:23:35','2025-04-04 02:23:35',4,'App\\Models\\Unit');

--
-- Table structure for table `prospects`
--

CREATE TABLE `prospects` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `phonenumber` varchar(191) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `prospects_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `prospects`
--

INSERT INTO `prospects` VALUES (1,'Miguel Angel Bahena','miguel.caro@test.com','3336703917',NULL,'2024-09-06 04:04:19','2024-09-06 04:04:19'),(2,'Lebron James','ljames@test.com','2233445566','2024-11-29 02:33:51','2024-09-06 04:11:45','2024-11-29 02:33:51'),(3,'Stephen Curry II','sthepchef@test.com','11223343455',NULL,'2024-10-22 02:18:08','2025-02-07 17:53:55'),(4,'Prospecto 4','test@test.com','34342354','2024-10-22 02:33:31','2024-10-22 02:18:43','2024-10-22 02:33:31'),(5,'New Prospect','new@prospect.com','3322112233','2024-11-29 02:41:46','2024-11-29 02:38:02','2024-11-29 02:41:46'),(6,'Mike Tyson','miket@tyson.com','123123124123',NULL,'2025-01-28 00:33:29','2025-01-28 00:33:29'),(7,'Nuevo prospecto','prospect@pr.com','2233441122','2025-09-04 00:35:09','2025-04-05 04:53:21','2025-09-04 00:35:09'),(8,'Test','test@example.com','123456789',NULL,'2025-04-05 15:32:43','2025-04-05 15:32:43'),(9,'NUEVVOV PROSPECTO','a@aaaa.com','123123123',NULL,'2025-09-04 00:30:57','2025-09-04 00:30:57');

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (1,1),(2,1),(3,1),(4,1),(4,3),(5,1),(6,1),(6,3),(7,1),(8,1);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `guard_name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Super Admin','web','2025-02-13 16:54:00','2025-02-13 16:54:00'),(2,'Gerente de ventas','web','2025-02-13 16:54:00','2025-02-13 16:54:00'),(3,'Vendedor','web','2025-02-13 16:54:00','2025-10-23 02:28:49');

--
-- Table structure for table `typologies`
--

CREATE TABLE `typologies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `construction_meters` varchar(191) NOT NULL DEFAULT '1 m2',
  `meters_of_free_area` varchar(191) NOT NULL DEFAULT '1 m2',
  `price` double NOT NULL DEFAULT 1,
  `view_3d` text DEFAULT NULL,
  `mainImage` varchar(191) DEFAULT NULL,
  `house_development_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `characteristicsTypologies` varchar(191) DEFAULT NULL,
  `web_main_image` varchar(191) DEFAULT NULL,
  `secondary_image_one` varchar(191) DEFAULT NULL,
  `secondary_image_two` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `typologies_house_development_id_foreign` (`house_development_id`),
  CONSTRAINT `typologies_house_development_id_foreign` FOREIGN KEY (`house_development_id`) REFERENCES `house_developments` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `typologies`
--

INSERT INTO `typologies` VALUES (1,'Tipologia #1','200','0',200,NULL,NULL,1,'2024-09-06 04:16:05','2026-02-12 21:47:30',NULL,'Sala,Cocina integral,Área de guardado,Medio Baño,Área para escritorio / Oficina,Terraza,Test',NULL,NULL,NULL),(2,'Tipologia 1','200','245',25000000,'asdfasdfasdf',NULL,15,'2025-01-15 00:25:04','2025-01-15 00:25:04',NULL,'Comedor,Recamara,Baño completo,Área para escritorio / Oficina,Balcón,Patio Interior,TEST CARACTERISTICA',NULL,NULL,NULL),(3,'Tipologia 2','150','170',200000,NULL,'images/q51T5djp7xEn6coTuQKue8iUNUKOZDVo6c5LbVtm.jpg',15,'2025-04-04 02:16:05','2025-04-04 02:16:05',NULL,'Sala,Recamara,Área de guardado,Medio Baño,Balcón,Patio Interior,Circulación vertical,TEST 1 Caracteristica','images/kmJjZnAyrh1F1dnRSt0GoyrVyNNO1WS7K9phfbwI.jpg',NULL,NULL);

--
-- Table structure for table `typology_blue_prints`
--

CREATE TABLE `typology_blue_prints` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `path` varchar(191) NOT NULL,
  `typology_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `typology_blue_prints_typology_id_foreign` (`typology_id`),
  CONSTRAINT `typology_blue_prints_typology_id_foreign` FOREIGN KEY (`typology_id`) REFERENCES `typologies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `typology_blue_prints`
--


--
-- Table structure for table `typology_images`
--

CREATE TABLE `typology_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `path` text NOT NULL,
  `typology_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `typology_images_typology_id_foreign` (`typology_id`),
  CONSTRAINT `typology_images_typology_id_foreign` FOREIGN KEY (`typology_id`) REFERENCES `typologies` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `typology_images`
--

INSERT INTO `typology_images` VALUES (1,'image_gallery','typology-images/35CMjbLtoI5iivHru4CFUORuZvTBa9CszpieIv9K.jpg',3,'2025-04-04 02:16:05','2025-04-04 02:16:05'),(2,'image_gallery','typology-images/kr6KJFEPICxv5Lhw1QPtxKeMgSil1exeRicPnBSM.jpg',3,'2025-04-04 02:16:05','2025-04-04 02:16:05'),(3,'image_gallery','typology-images/iF5fBPzokTNtaqZAbsoxmNL8H1ZiKRT14SQxm0Mk.jpg',3,'2025-04-04 02:16:05','2025-04-04 02:16:05');

--
-- Table structure for table `unit_blue_prints`
--

CREATE TABLE `unit_blue_prints` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `path` varchar(191) NOT NULL,
  `unit_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `unit_blue_prints_unit_id_foreign` (`unit_id`),
  CONSTRAINT `unit_blue_prints_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `unit_blue_prints`
--


--
-- Table structure for table `unit_customers`
--

CREATE TABLE `unit_customers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `phone` varchar(191) NOT NULL,
  `unit_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `unit_customers_unit_id_foreign` (`unit_id`),
  CONSTRAINT `unit_customers_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `unit_customers`
--


--
-- Table structure for table `unit_images`
--

CREATE TABLE `unit_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `path` text NOT NULL,
  `unit_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `unit_images_unit_id_foreign` (`unit_id`),
  CONSTRAINT `unit_images_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `unit_images`
--

INSERT INTO `unit_images` VALUES (1,'image_gallery','unit-images/uyHL4bmbqKEKWIoKWYQKW9Tmo0gJiwiojZTv0X8o.jpg',3,'2025-01-15 00:25:28','2025-01-15 00:25:28'),(2,'image_gallery','unit-images/BHVMSVv8yLaGpGiV7rLjI8ZWqIg5dbiLT1qv8Flq.jpg',3,'2025-01-15 00:25:28','2025-01-15 00:25:28'),(3,'image_gallery','unit-images/OyCYfu9Ub03tdHObNUJcE9dTuj9CUpOBFPsLtywn.jpg',3,'2025-01-15 00:25:28','2025-01-15 00:25:28'),(4,'image_gallery','unit-images/JecmdVajcq41CiUFlmm5aJOjNq4JEvTi1y5ZSkJP.jpg',1,'2025-08-13 00:37:20','2025-08-13 00:37:20'),(5,'image_gallery','unit-images/iVF9M4bVdzHppEBAoQ7063Mnw6gVWdWydSDuRudN.jpg',6,'2025-08-13 00:37:44','2025-08-13 00:37:44');

--
-- Table structure for table `unit_prospects`
--

CREATE TABLE `unit_prospects` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `phone` varchar(191) NOT NULL,
  `amount` double NOT NULL,
  `reference` varchar(191) NOT NULL,
  `prospect_date` date NOT NULL,
  `unit_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `unit_prospects_unit_id_foreign` (`unit_id`),
  CONSTRAINT `unit_prospects_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `unit_prospects`
--


--
-- Table structure for table `unit_stages`
--

CREATE TABLE `unit_stages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `unit_stages`
--

INSERT INTO `unit_stages` VALUES (1,'Disponible','2024-09-06 04:18:58','2024-09-06 04:18:58'),(2,'Apartada','2024-09-06 04:18:58','2024-09-06 04:18:58'),(3,'Unidad Bloqueada','2024-09-06 04:18:58','2024-09-06 04:18:58'),(4,'Vendida','2024-09-06 04:18:58','2024-09-06 04:18:58');

--
-- Table structure for table `unit_views`
--

CREATE TABLE `unit_views` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `unit_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `unit_views_unit_id_foreign` (`unit_id`),
  CONSTRAINT `unit_views_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `unit_views`
--

INSERT INTO `unit_views` VALUES (1,'Vista 12',1,NULL,'2024-09-06 04:19:10','2024-09-06 04:19:10'),(2,'Vista 2',1,NULL,'2024-09-06 04:19:10','2024-09-06 04:19:10'),(3,'Vista 4',1,NULL,'2024-09-06 04:19:10','2024-09-06 04:19:10'),(4,'Vista 12',2,NULL,'2024-09-06 04:19:21','2024-09-06 04:19:21'),(5,'Vista 2',2,NULL,'2024-09-06 04:19:21','2024-09-06 04:19:21'),(6,'Vista 4',2,NULL,'2024-09-06 04:19:21','2024-09-06 04:19:21'),(7,'Vista 1',4,NULL,'2025-04-04 02:55:28','2025-04-04 02:55:28'),(8,'Vista 2',4,NULL,'2025-04-04 02:55:28','2025-04-04 02:55:28');

--
-- Table structure for table `units`
--

CREATE TABLE `units` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `levels` int(11) DEFAULT NULL,
  `has_own_measurement` tinyint(1) NOT NULL DEFAULT 0,
  `construction_meters` varchar(191) DEFAULT NULL,
  `meters_of_free_area` varchar(191) DEFAULT NULL,
  `price` double NOT NULL,
  `estimate_image` varchar(191) DEFAULT NULL,
  `typology_id` bigint(20) unsigned DEFAULT NULL,
  `unit_stage_id` bigint(20) unsigned NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `prospect_name` varchar(191) DEFAULT NULL,
  `prospect_email` varchar(191) DEFAULT NULL,
  `prospect_phone` varchar(191) DEFAULT NULL,
  `prospect_amount` double DEFAULT NULL,
  `prospect_reference` varchar(191) DEFAULT NULL,
  `prospect_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `units_typology_id_foreign` (`typology_id`),
  KEY `units_unit_stage_id_foreign` (`unit_stage_id`),
  CONSTRAINT `units_typology_id_foreign` FOREIGN KEY (`typology_id`) REFERENCES `typologies` (`id`),
  CONSTRAINT `units_unit_stage_id_foreign` FOREIGN KEY (`unit_stage_id`) REFERENCES `unit_stages` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `units`
--

INSERT INTO `units` VALUES (1,'Unidad 1',10,0,NULL,NULL,200000,'images/R0kkiseiznYg321wN7NCOk15ueuntyLqLAYUVCqi.jpg',1,3,'2024-09-06 04:19:10','2025-08-13 01:08:43',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'Unidad 2 PRUEBA',10,0,NULL,NULL,300,NULL,1,3,'2024-09-06 04:19:21','2025-07-25 02:06:54',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'Unidad 1',NULL,0,NULL,NULL,25000000,NULL,2,1,'2025-01-15 00:25:28','2025-02-13 18:14:29',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'UNIDAD TEST 2',NULL,0,NULL,NULL,15000000,NULL,2,1,'2025-04-04 02:23:04','2025-04-04 02:23:35',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'asdfasdf',2,0,NULL,NULL,200,NULL,1,4,'2025-07-31 01:46:00','2025-09-04 00:35:10',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'Nueva Unidad',2,1,'300','302',200,NULL,1,3,'2025-07-31 01:46:27','2025-08-13 00:37:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'Nueva Unidad 2',1,0,NULL,NULL,200,NULL,1,1,'2025-07-31 01:51:45','2025-07-31 02:02:24',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'asdasdasd',1,0,'123','321',200,NULL,1,1,'2025-07-31 01:52:30','2025-07-31 01:52:30',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'asdasdasd',2,1,'123123123','123',200,NULL,1,1,'2025-07-31 01:56:44','2025-07-31 01:56:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'TEST',6,0,NULL,NULL,200,NULL,1,1,'2025-07-31 02:33:03','2025-07-31 02:33:03',NULL,NULL,NULL,NULL,NULL,NULL,NULL);


