(2232,74,'App\\Client','Efectiva','SAC',8,'<p>08/09/2021  Llamo al banco Capital One para preguntar por la informacion de la linea de credito dicen que desde el mes de julio le enviaron la carta donde le solicitaban documentos para comprobar la identidad, lo que el puede enviar y es preferiblemente que sea por fax seria dos documentos: un documento de identificacion emitido por el gobierno (pasaporte,licencia de conducir,el id que no es para conducir, tarjeta de identificacion de residente permanente,documento de autorizacion para trabajar, certificado de ciudadaniao tarjeta de cruce fronterizo) el otro documento seria el id number, tarjeta de identificacion del contribuyente, declaracion de impuestos del año fiscal mas reciente,talon de sueldo emitido en los ultimos 3 meses.Envio por fax: 18444564558 Correo postal-Po Box 31290 ciudad de Salt Lake City UT codigo postal 84131-0290.<strong>PENDIENTE DARLE LA INFORMACION A JUNIOR</strong></p>',1,'2022-07-29 22:38:06','2022-07-29 22:38:06'),(2233,74,'App\\Client','Efectiva','SAC',8,'<p>08/13/2021  A partir de Sep se va a ubicar en una solca casilla con Junior Benites (Esposos), se acuerda continuar con un solo pago de $160 para ambos y queda programado para fin de mes (KR)</p>',1,'2022-07-29 22:38:32','2022-07-29 22:38:32'),(2234,74,'App\\Client','Efectiva','SAC',8,'<p>08/26/2021  Llamo al banco capital one a preguntar por la tarjeta. Me dicen que no han recibido documentos de parte de Junior debe vovler a enviarlos y puede ser por fax opor correo postal. (EA)</p>',1,'2022-07-29 22:38:45','2022-07-29 22:38:45'),(2235,74,'App\\Client','Efectiva','Buros',8,'<p>09/02/2021  Se realizan disputas por expirian ytransunion (EA)</p>',1,'2022-07-29 22:39:01','2022-07-29 22:39:01'),(2236,74,'App\\Client','Efectiva','SAC',8,'<p>09/07/2021  Envia resultados de equifax, y se sube a su respectiva acrpeta (JB)</p>',1,'2022-07-29 22:39:16','2022-07-29 22:39:16'),(2237,74,'App\\Client','Efectiva','SAC',8,'<p>09/23/2021  Hablo con Junior sobre el proceso, me dice que no recuerda haber enviado documentos a capital one, le explico que la comunicacion con nosotros es super importante. Le solicito el bill, tambien le explico que cuenta estamos disputando en este momento. Se despide super agradecido (EA)</p>',1,'2022-07-29 22:39:29','2022-07-29 22:39:29'),(2238,74,'App\\Client','Efectiva','SAC',8,'<p>09/24/2021  Envia bill actualizado y se sub e a su respetiva carpeta (JB)</p>',1,'2022-07-29 22:39:42','2022-07-29 22:39:42'),(2239,74,'App\\Client','Efectiva','SAC',8,'<p>10/05/2021  Envia resultados de transunion, y se sube a su respectiva acrpeta (JB)</p>',1,'2022-07-29 22:40:01','2022-07-29 22:40:01'),(2240,74,'App\\Client','Efectiva','SAC',8,'<p>10/08/2021  Le aprueban tarjeta <strong>QuickSilverOne por $500 por Cap One, </strong>le envian un texto con un link y en el momento el cliente hace la verificación de identidad. Queda a la espera de recibir la tarjeta (KR)</p>',1,'2022-07-29 22:40:15','2022-07-29 22:40:15'),(2241,74,'App\\Client','Efectiva','Cobro',8,'<p>10/08/2021  Llamo para darle la super noticia de la linea de credito que le aprobaron por capital one, en medio de lallamada hace la verificacion por medio del link. Lo felicito le explico que tambien eso es posible por todas las actualizaciones que hemos estado llevando con el, le recalco que siempre vamos teniendo un avance. El se pone super feliz y realizo el cobro de este mes por $150.00 para el 10/025/2021. Dice que esta perfecto se despide super agradecido (EA)</p>',1,'2022-07-29 22:40:27','2022-07-29 22:40:27'),(2242,74,'App\\Client','Efectiva','Buros',8,'<p>10/19/2021  Realizo disputas por transunion en expirian no puedo realizar disputas porque no tiene seguro social(EA)</p>',1,'2022-07-29 22:40:42','2022-07-29 22:40:42'),(2243,74,'App\\Client','Efectiva','Cobro',8,'<p>10/22/2021  Hablo con Junior sobre el manejo que debe darle a linea de credito, ademas le recuerdo que su proximo pago esta pactado para el 25 de octubre por $150.00. Se despide super agradecido (EA)</p>',1,'2022-07-29 22:40:57','2022-07-29 22:40:57'),(2244,74,'App\\Client','Efectiva','Cobro',8,'<p>11/05/2021  Hablamos de todo el proceso, le explico que cuentas estamos disputando, y ademas me dice que esta super contento por que tiene muy claro cual es la forma correcta en que debe manejar las tarjetas de credito. Realizo cobro para este mes 11/23/2021 por $150.00. Le explico a el cual es el documento que le estoy solicitando a Alba. Se despide super agradecido. (EA)</p>',1,'2022-07-29 22:41:17','2022-07-29 22:41:17'),(2245,74,'App\\Client','Efectiva','Cobro',8,'<p>11/22/2021  Hablo con Junior le explico que el ya el proximo mes entraria en la recta final de todo el proceso, y ademas le hago la recomendacion de aperturar una nueva tarjeta de credito, en este caso seria por la compañia oportun, dice que le parece perfecto. Le recuerdo que la fecha del proximo pago de ambos (Alba y él) esta programada para el dia de mañana, unicamente serian $150.00. Durante el transcurso del dia lo estarian realizando, se despide super agradecido (EA)</p>',1,'2022-07-29 22:41:38','2022-07-29 22:41:38'),(2246,74,'App\\Client','Efectiva','SAC',8,'<p>11/22/2021  Se hace proceso de aplicación por Oportun y queda pendiente de verificar la identidad (KR)</p>',1,'2022-07-29 22:42:02','2022-07-29 22:42:02'),(2247,74,'App\\Client','Efectiva','Cobro',8,'<p>12/03/2021  Hablo con Junior sobre el proceso, me cuenta que fue aprobado en oportun, q1uedo en contactarme mañana con la entidad para solicitar la informacion. Ademas realizo cobro para este mes 12/20/2021 por $150.00. Estarian realizando el pago en el transcurso del dia (EA)</p>',1,'2022-07-29 22:42:26','2022-07-29 22:42:26'),(2248,74,'App\\Client','Efectiva','SAC',8,'<p>12/03/2021  La tarjeta de oportun se la dieron por $500.00. Anualidad $29.00. (EA)</p>',1,'2022-07-29 22:42:40','2022-07-29 22:42:40'),(2249,74,'App\\Client','Efectiva','SAC',8,'<p>12/13/2021  Hablo con Junior me cuenta ya recibio la tarjeta de Oportun, le explico cual es el uso correcto, ademas le explico por cuanto esta el limite (EA)</p>',1,'2022-07-29 22:43:00','2022-07-29 22:43:00'),(2250,74,'App\\Client','Efectiva','Buros',8,'<p>12/15/2021  Realizo disputas por expirian y transunion (EA)</p>',1,'2022-07-29 22:43:18','2022-07-29 22:43:18'),(2251,74,'App\\Client','Efectiva','Cobro',8,'<p>12/17/2021  Hablo con Junior, me cuenta que esta presentando problemas con la tarjeta de capital one ya que no le estan dejando hacer movimientos . Ademas le recuerdo que para el 20 de diciembre esta pactado el pago de el y su esposa, le recuerdo que ya Alba finalziaria como tal todo el proceso y el continuaria el de el por $80.00. Queda super agradecido (EA)</p>',1,'2022-07-29 22:43:35','2022-07-29 22:43:35'),(2252,74,'App\\Client','Efectiva','Buros',8,'<p>12/18/2021  Se envian disputas por carta a Equifax (KR)</p>',1,'2022-07-29 22:43:52','2022-07-29 22:43:52'),(2253,74,'App\\Client','Efectiva','SAC',8,'<p>12/27/2021  Hablo con Junior le cuento que su esposa ya para este mes finalizaria con todo el proceso. Ademas me dice que la tarjeta de Capitasl one, le esta solicitando una contraseña de 4 digitos que el no tiene. Quedo en contactarme con el banco para solicitar la informacion. ( Numero de tarjeta 5178-0598-7076-0189) . Se despide super agradecido (EA)</p>',1,'2022-07-29 22:44:09','2022-07-29 22:44:09'),(2254,74,'App\\Client','Efectiva','SAC',8,'<p>01/10/2022  Envia resultados de transunion, y se sube a su respectiva carpeta (JB)</p>',1,'2022-07-29 22:44:26','2022-07-29 22:44:26'),(2255,74,'App\\Client','Efectiva','Cobro',8,'<p>01/17/2022  Hablo con Junior sobre las contestaciones que recibio. Y le digo que para el 20 de enero esta pactada la fecha de su proximo pago (EA)</p>',1,'2022-07-29 22:44:43','2022-07-29 22:44:43'),(2256,74,'App\\Client','Efectiva','Cobro',8,'<p>01/20/2020  Se envia carta con disputas al buro de crédito Equifax (KR)</p>',1,'2022-07-29 22:45:07','2022-07-29 22:45:07'),(2257,74,'App\\Client','Efectiva','Cobro',8,'<p>01/31/2022  Hablo con Junior, le hablo sobre la cuenta que seguimos dusputando hasta este momento, y realizo cobro para el mes de febrero 02/21/2022 ´por $80.00 con autorizacion a realizar el debito a las 8am (EA)</p>',1,'2022-07-29 22:45:25','2022-07-29 22:45:25'),(2258,74,'App\\Client','Efectiva','SAC',8,'<p>02/10/2022  Seguimiento del proceso, que estamos llevando , le hablo de los resultados que estamos teniendo y del amnejo que le estpa dando a las tarjetas, se dspide muy agradecido (JB)</p>',1,'2022-07-29 22:45:45','2022-07-29 22:45:45'),(2259,74,'App\\Client','Efectiva','Cobro',8,'<p>02/18/2022  Le damos segumiento a las tarejtas que nosotros le ayudamos a conseguir y me cuenta que ya la de Oportun se la aumentaron a $1000 y quedamos en gestionar aumento en el limite de Cap One y de una vez se confirma el pago que tiene para el 21, pero me dice que lo podemos debitar de una vez hoy (KR)</p>',1,'2022-07-29 22:46:02','2022-07-29 22:46:02'),(2260,74,'App\\Client','Efectiva','SAC',8,'<p>02/21/2022  Se gestiona aumento de limite en la tarjeta de Cap One (5178-0598-7076-0189) y queda en estudio, le dan respuesta de 7-10 días. Tambien se verifica estado actual de la tarjeta ya que el cliente la semana pasada me manifesto que en algun momento vio que decia tarjea restringida (El agente del banco dice que todo esta en perfectas condiciones). Le doy toda la infromación al cliente y queda agradecido (KR)</p>',1,'2022-07-29 22:46:16','2022-07-29 22:46:16'),(2261,74,'App\\Client','Efectiva','Cobro',8,'<p>02/28/2022 Hablo con Junior hablamos sobre el proceso, me dice que aun no ha recibido contestaciones de parte de capital one. Ademas organizo la fecha de su ultimo pago 03/18/2022 por $80.00 con autorizacion arealizar el debito (EA)</p>',1,'2022-07-29 22:46:37','2022-07-29 22:46:37'),(2262,74,'App\\Client','Efectiva','SAC',8,'<p>03/07/2022  Hablo con Junior, hablamos sobre todo el proceso, le explico que para el mes de marzo esta programado realizar el ultimo debito, y le digo que para la proxima semana estariamos hablando de todos los temas importante que hemos tomado hasta este momento, queda agradecido (EA)</p>',1,'2022-07-29 22:47:02','2022-07-29 22:47:02'),(2263,74,'App\\Client','Efectiva','Buros',8,'<p>03/08/2022  Se realiza disputa por transunion y experian (SL)</p>',1,'2022-07-29 22:47:17','2022-07-29 22:47:17'),(2264,74,'App\\Client','Efectiva','Buros',8,'<p>03/11/2022  Se envia carta con disputas al buro de crédito Equifax (KR)</p>',1,'2022-07-29 22:47:28','2022-07-29 22:47:28'),(2265,74,'App\\Client','Efectiva','Cobro',8,'<p>03/17/2022  Hablo con Junior le doy un saludo y le recuerdo que para el dia de mañana estariamos realizando el debito de los $80,00 correspondientes al proceso de reparacion de credito, incluso seria el ultimo. Tomo nota de la nueva numeracion queda super agradecido (EA)</p>',1,'2022-07-29 22:47:53','2022-07-29 22:47:53'),(2266,74,'App\\Client','Efectiva','Cobro',8,'<p>03/17/2022  Hablo con Junior le doy un saludo y le recuerdo que para el dia de mañana estariamos realizando el debito de los $80,00 correspondientes al proceso de reparacion de credito, incluso seria el ultimo. Tomo nota de la nueva numeracion queda super agradecido (EA)</p>',1,'2022-07-29 22:48:36','2022-07-29 22:48:36'),(2267,74,'App\\Client','Efectiva','SAC',8,'<p>03/31/2022  <strong>PEDIR BILL ACTUALIZADO</strong></p>',1,'2022-07-29 22:49:01','2022-07-29 22:49:01'),(2268,74,'App\\Client','Efectiva','Buros',8,'<p>04/06/2022  Se realiza disputa por Transunion y Experian (SL)</p>',1,'2022-07-29 22:49:14','2022-07-29 22:49:14');

--
-- Table structure for table `number_contacs`
--

CREATE TABLE `number_contacs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `typephone` bigint(20) unsigned NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `number_contacs`
--

INSERT INTO `number_contacs` VALUES (1,1,'(201)-424-7584',1,1,'2022-06-04 00:29:15','2022-06-04 00:29:15'),(2,2,'(786)-343-9046',1,1,'2022-06-04 02:27:34','2022-06-04 02:27:34'),(3,3,'(786)-523-4623',1,1,'2022-06-04 20:57:31','2022-06-04 20:57:31'),(4,4,'(201)-920-7019',1,1,'2022-06-28 19:49:51','2022-06-28 19:49:51'),(5,5,'(201)-779-2920',1,1,'2022-06-28 21:02:58','2022-06-28 21:02:58'),(6,6,'(863)-934-5939',1,1,'2022-06-28 22:43:38','2022-06-28 22:43:38'),(7,7,'(978)-235-3116',1,1,'2022-06-29 00:43:49','2022-06-29 00:43:49'),(8,8,'(201)-467-6575',1,1,'2022-06-29 01:44:46','2022-06-29 01:44:46'),(9,9,'(978)-902-0195',1,1,'2022-06-29 02:42:43','2022-06-29 02:42:43'),(10,10,'(732)-619-7221',1,1,'2022-06-29 03:30:31','2022-06-29 03:30:31'),(11,11,'(561)-809-0125',1,1,'2022-06-29 03:45:35','2022-06-29 03:45:35'),(12,12,'(978)-208-9309',1,1,'2022-06-29 04:31:52','2022-06-29 04:31:52'),(13,13,'(631)-972-2572',1,1,'2022-06-29 20:00:36','2022-06-29 20:00:36'),(14,14,'(978)-985-3174',1,1,'2022-06-29 21:34:20','2022-06-29 21:34:20'),(15,15,'(978)-885-7652',1,1,'2022-06-29 21:55:16','2022-06-29 21:55:16'),(16,16,'(631)-522-8087',1,1,'2022-06-29 23:42:53','2022-06-29 23:42:53'),(17,17,'(978)-918-8140',1,1,'2022-06-30 00:46:53','2022-06-30 00:46:53'),(18,18,'(617)-959-7204',1,1,'2022-06-30 01:57:58','2022-06-30 01:57:58'),(20,20,'(551)-253-9262',1,1,'2022-06-30 20:00:47','2022-06-30 20:00:47'),(21,21,'(361)-816-8826',1,1,'2022-06-30 20:45:19','2022-06-30 20:45:19'),(22,22,'(978)-590-1983',1,1,'2022-06-30 21:28:43','2022-06-30 21:28:43'),(23,23,'(864)-293-4868',1,1,'2022-06-30 21:45:20','2022-06-30 21:45:20'),(24,24,'(978)-221-1847',1,1,'2022-06-30 22:33:33','2022-06-30 22:33:33'),(25,25,'(631)-575-3277',1,1,'2022-06-30 23:02:50','2022-06-30 23:02:50'),(26,26,'(857)-540-6111',1,1,'2022-07-01 01:10:39','2022-07-01 01:10:39'),(27,27,'(570)-497-9355',1,1,'2022-07-01 02:15:56','2022-07-01 02:15:56'),(28,28,'(857)-200-8610',1,1,'2022-07-01 02:38:19','2022-07-01 02:38:19'),(29,29,'(203)-999-2506',1,1,'2022-07-01 03:19:02','2022-07-01 03:19:02'),(30,30,'(973)-210-1124',1,1,'2022-07-01 03:30:47','2022-07-01 03:30:47'),(31,31,'(860)-770-1399',1,1,'2022-07-01 03:50:40','2022-07-01 03:50:40'),(32,32,'(781)-346-2349',1,1,'2022-07-01 04:20:36','2022-07-01 04:20:36'),(33,33,'(201)-884-0694',1,1,'2022-07-01 19:56:52','2022-07-01 19:56:52'),(34,34,'(857)-333-4828',1,1,'2022-07-01 20:40:56','2022-07-01 20:40:56'),(35,35,'(813)-652-1181',1,1,'2022-07-01 21:37:23','2022-07-01 21:37:23'),(36,36,'(305)-297-9030',1,1,'2022-07-01 22:01:21','2022-07-01 22:01:21'),(37,37,'(786)-234-5912',1,1,'2022-07-01 23:47:59','2022-07-01 23:47:59'),(38,38,'(727)-320-6317',1,1,'2022-07-02 02:18:15','2022-07-02 02:18:15'),(39,39,'(631)-220-5060',1,1,'2022-07-02 21:02:30','2022-07-02 21:02:30'),(40,40,'(904)-514-7746',1,1,'2022-07-02 21:07:02','2022-07-02 21:07:02'),(41,41,'(786)-286-4179',1,1,'2022-07-02 21:13:44','2022-07-02 21:13:44'),(42,42,'(786)-349-8632',1,1,'2022-07-06 01:13:23','2022-07-06 01:13:23'),(43,43,'(786)-352-4722',1,1,'2022-07-06 01:24:39','2022-07-06 01:24:39'),(44,44,'(786)-817-0176',1,1,'2022-07-06 01:47:35','2022-07-06 01:47:35'),(45,45,'(813)-323-8504',1,1,'2022-07-06 02:01:08','2022-07-06 02:01:08'),(46,46,'(781)-484-7263',1,1,'2022-07-06 20:58:48','2022-07-06 20:58:48'),(47,47,'(631)-639-8049',1,1,'2022-07-06 21:16:48','2022-07-06 21:16:48'),(48,48,'(786)-444-5317',1,1,'2022-07-06 21:50:08','2022-07-06 21:50:08'),(49,49,'(863)-274-0765',1,1,'2022-07-07 00:40:04','2022-07-07 00:40:04'),(50,50,'(978)-685-6637',1,1,'2022-07-07 18:43:44','2022-07-07 18:43:44'),(51,51,'(617)-820-6287',1,1,'2022-07-07 19:16:21','2022-07-07 19:16:21'),(52,52,'(631)-782-7931',1,1,'2022-07-07 20:13:15','2022-07-07 20:13:15'),(53,53,'(813)-447-3004',1,1,'2022-07-07 21:10:00','2022-07-07 21:10:00'),(54,54,'(203)-540-2163',1,1,'2022-07-07 21:20:53','2022-07-07 21:20:53'),(55,55,'(813)-735-1483',1,1,'2022-07-07 21:33:26','2022-07-07 21:33:26'),(56,56,'(352)-328-9956',1,1,'2022-07-07 21:34:15','2022-07-07 21:34:15'),(57,57,'(813)-863-2323',1,1,'2022-07-09 19:38:56','2022-07-09 19:38:56'),(58,58,'(551)-263-4065',1,1,'2022-07-09 19:51:58','2022-07-09 19:51:58'),(59,59,'(786)-493-7773',1,1,'2022-07-09 20:19:22','2022-07-09 20:19:22'),(60,60,'(813)-764-5777',1,1,'2022-07-09 20:36:27','2022-07-09 20:36:27'),(61,61,'(313)-231-5436',1,1,'2022-07-09 20:47:06','2022-07-09 20:47:06'),(62,62,'(813)-409-6789',1,1,'2022-07-09 20:49:39','2022-07-09 20:49:39'),(63,63,'(727)-944-6005',1,1,'2022-07-16 20:14:59','2022-07-16 20:14:59'),(64,64,'(727)-333-1513',1,1,'2022-07-16 22:25:18','2022-07-16 22:25:18'),(65,65,'(123)-456-7890',1,1,'2022-07-25 22:46:02','2022-07-25 22:46:02'),(66,66,'(617)-331-7359',1,1,'2022-07-29 20:35:55','2022-07-29 20:35:55'),(67,67,'(754)-246-2506',1,1,'2022-07-29 21:09:49','2022-07-29 21:09:49'),(68,68,'(786)-532-8406',1,1,'2022-07-29 21:38:38','2022-07-29 21:38:38'),(69,69,'(954)-999-7130',1,1,'2022-07-29 21:45:04','2022-07-29 21:45:04'),(70,70,'(813)-447-8482',1,1,'2022-07-29 21:51:35','2022-07-29 21:51:35'),(71,71,'(954)-488-4905',1,1,'2022-07-29 21:55:32','2022-07-29 21:55:32'),(72,72,'(754)-281-3571',1,1,'2022-07-29 21:59:39','2022-07-29 21:59:39'),(73,73,'(703)-283-7833',1,1,'2022-07-29 22:04:12','2022-07-29 22:04:12'),(74,74,'(617)-953-9855',1,1,'2022-07-29 22:15:57','2022-07-29 22:15:57');

--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_access_tokens`
--


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

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci 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_clients`
--

CREATE TABLE `oauth_clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_clients`
--


--
-- 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_refresh_tokens`
--


--
-- Table structure for table `otros_documentos`
--

CREATE TABLE `otros_documentos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned NOT NULL,
  `user_id_create` bigint(20) unsigned NOT NULL,
  `type_document` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_document` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `document_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `reviewed` tinyint(1) NOT NULL DEFAULT 0,
  `reviewing_user_id` bigint(20) DEFAULT 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 `otros_documentos`
--

INSERT INTO `otros_documentos` VALUES (1,65,1,'prueba',NULL,'png','clientes/65/otros-documentos/1e0onpDrq34pNhbED2tYtMFT7cB9x5J9vSqQ2ktS.png',1,0,NULL,'2022-07-25 22:49:44','2022-07-25 22:49:44');

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `sale_informations`
--

CREATE TABLE `sale_informations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned NOT NULL,
  `sold_by` bigint(20) unsigned DEFAULT NULL,
  `type_service` bigint(20) unsigned DEFAULT NULL,
  `first_payment` double(10,2) DEFAULT NULL,
  `first_payment_agreement` datetime DEFAULT NULL,
  `date_sale` date DEFAULT NULL,
  `type_sale` bigint(20) unsigned DEFAULT NULL,
  `goal` bigint(20) unsigned DEFAULT NULL,
  `MonthlyValue` double(10,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sale_informations`
--

INSERT INTO `sale_informations` VALUES (1,1,7,1,NULL,NULL,'2020-09-25',2,4,59.00,'2022-06-04 00:29:15','2022-06-04 00:44:53'),(2,2,5,1,NULL,NULL,'2020-09-16',2,4,59.00,'2022-06-04 02:27:34','2022-06-04 02:28:17'),(3,3,7,1,NULL,NULL,'2020-09-23',2,6,59.00,'2022-06-04 20:57:31','2022-06-04 20:59:07'),(4,4,5,1,NULL,NULL,'2020-11-11',3,5,150.00,'2022-06-28 19:49:51','2022-06-28 19:51:12'),(5,5,8,1,NULL,NULL,'2020-11-11',3,7,150.00,'2022-06-28 21:02:58','2022-06-28 21:05:53'),(6,6,8,1,NULL,NULL,'2020-11-16',3,4,150.00,'2022-06-28 22:43:38','2022-06-28 22:45:10'),(7,7,8,1,NULL,NULL,'2020-11-18',3,4,120.00,'2022-06-29 00:43:49','2022-06-29 00:45:36'),(8,8,8,1,NULL,NULL,'2020-11-20',3,7,180.00,'2022-06-29 01:44:46','2022-06-29 01:45:31'),(9,9,8,2,NULL,NULL,'2020-11-19',3,4,120.00,'2022-06-29 02:42:43','2022-06-29 02:50:33'),(10,10,8,2,120.00,NULL,'2020-11-15',3,4,120.00,'2022-06-29 03:30:31','2022-06-29 03:30:31'),(11,11,8,1,NULL,NULL,'2020-11-28',3,4,100.00,'2022-06-29 03:45:35','2022-06-29 03:47:52'),(12,12,8,1,NULL,NULL,'2020-11-27',3,7,150.00,'2022-06-29 04:31:52','2022-06-29 04:32:58'),(13,13,9,1,NULL,NULL,'2020-11-24',3,6,120.00,'2022-06-29 20:00:36','2022-06-29 20:05:14'),(14,14,9,1,NULL,NULL,'2020-11-18',3,4,130.00,'2022-06-29 21:34:20','2022-06-29 21:38:43'),(15,15,9,1,NULL,NULL,'2020-11-27',3,7,120.00,'2022-06-29 21:55:16','2022-06-29 22:06:57'),(16,16,9,1,NULL,NULL,'2020-12-03',3,7,200.00,'2022-06-29 23:42:53','2022-06-29 23:51:48'),(17,17,9,1,NULL,NULL,'2020-12-03',3,7,130.00,'2022-06-30 00:46:53','2022-06-30 00:48:06'),(18,18,9,1,NULL,NULL,'2020-11-28',3,7,150.00,'2022-06-30 01:57:58','2022-06-30 02:01:05'),(19,19,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'2022-06-30 19:42:19','2022-06-30 19:42:19'),(20,20,8,1,NULL,NULL,'2020-12-07',3,7,100.00,'2022-06-30 20:00:47','2022-06-30 20:01:51'),(21,21,8,1,NULL,NULL,'2020-11-23',3,4,120.00,'2022-06-30 20:45:19','2022-06-30 20:46:14'),(22,22,9,1,NULL,NULL,'2020-12-15',1,4,150.00,'2022-06-30 21:28:43','2022-06-30 21:29:44'),(23,23,8,1,NULL,NULL,'2020-12-16',1,7,150.00,'2022-06-30 21:45:20','2022-06-30 21:46:02'),(24,24,8,1,NULL,NULL,'2020-12-13',1,4,100.00,'2022-06-30 22:33:33','2022-06-30 22:34:12'),(25,25,8,1,NULL,NULL,'2020-12-22',1,4,120.00,'2022-06-30 23:02:50','2022-06-30 23:03:30'),(26,26,8,1,NULL,NULL,'2021-01-06',3,4,130.00,'2022-07-01 01:10:39','2022-07-01 01:11:21'),(27,27,8,1,NULL,NULL,'2021-01-16',1,7,180.00,'2022-07-01 02:15:56','2022-07-01 02:16:35'),(28,28,NULL,1,NULL,NULL,'2021-01-13',1,4,150.00,'2022-07-01 02:38:19','2022-07-01 02:38:54'),(29,29,8,1,NULL,NULL,'2020-12-26',3,7,150.00,'2022-07-01 03:19:02','2022-07-01 03:19:57'),(30,30,8,1,NULL,NULL,'2021-01-12',3,7,150.00,'2022-07-01 03:30:47','2022-07-01 03:31:23'),(31,31,8,1,NULL,NULL,'2020-12-23',3,4,120.00,'2022-07-01 03:50:40','2022-07-01 03:51:07'),(32,32,8,1,NULL,NULL,'2021-01-12',3,4,100.00,'2022-07-01 04:20:36','2022-07-01 04:21:17'),(33,33,9,1,NULL,NULL,'2020-01-24',1,11,125.00,'2022-07-01 19:56:52','2022-07-01 19:58:12'),(34,34,9,1,NULL,NULL,'2021-02-08',3,4,180.00,'2022-07-01 20:40:56','2022-07-01 20:43:01'),(35,35,9,1,NULL,NULL,'2021-02-12',2,4,230.00,'2022-07-01 21:37:23','2022-07-01 21:40:17'),(36,36,9,1,NULL,NULL,'2021-02-12',2,7,220.00,'2022-07-01 22:01:21','2022-07-01 22:08:14'),(37,37,9,1,NULL,NULL,'2021-02-04',2,4,220.00,'2022-07-01 23:47:59','2022-07-01 23:49:34'),(38,38,9,1,NULL,NULL,'2021-02-10',2,4,220.00,'2022-07-02 02:18:15','2022-07-02 02:26:12'),(39,39,8,1,NULL,NULL,'2021-02-04',3,7,99.00,'2022-07-02 21:02:30','2022-07-02 21:03:14'),(40,40,9,2,NULL,NULL,'2021-02-18',2,4,100.00,'2022-07-02 21:07:02','2022-07-02 21:22:54'),(41,41,8,1,NULL,NULL,'2021-02-11',2,7,150.00,'2022-07-02 21:13:44','2022-07-02 21:14:23'),(42,42,8,2,NULL,NULL,'2021-02-05',2,4,100.00,'2022-07-06 01:13:23','2022-07-06 01:13:56'),(43,43,8,1,NULL,NULL,'2021-02-08',2,7,160.00,'2022-07-06 01:24:39','2022-07-06 01:25:11'),(44,44,8,1,NULL,NULL,'2021-02-17',3,4,120.00,'2022-07-06 01:47:35','2022-07-06 01:48:07'),(45,45,8,1,NULL,NULL,'2021-02-25',2,7,130.00,'2022-07-06 02:01:08','2022-07-06 02:01:37'),(46,46,8,1,NULL,NULL,'2021-02-02',3,4,100.00,'2022-07-06 20:58:48','2022-07-06 20:59:22'),(47,47,8,1,NULL,NULL,'2021-02-17',1,4,120.00,'2022-07-06 21:16:48','2022-07-06 21:17:23'),(48,48,8,1,NULL,NULL,'2021-03-01',2,4,125.00,'2022-07-06 21:50:08','2022-07-06 21:50:35'),(49,49,5,1,NULL,NULL,'2021-03-01',2,7,125.00,'2022-07-07 00:40:04','2022-07-07 00:48:20'),(50,50,9,1,NULL,NULL,'2021-03-02',1,7,130.00,'2022-07-07 18:43:44','2022-07-07 18:45:09'),(51,51,9,2,NULL,NULL,'2021-03-02',3,4,130.00,'2022-07-07 19:16:21','2022-07-07 19:18:12'),(52,52,9,1,NULL,NULL,'2021-02-18',1,4,120.00,'2022-07-07 20:13:15','2022-07-07 20:14:09'),(53,53,8,1,NULL,NULL,'2021-03-10',2,4,150.00,'2022-07-07 21:10:00','2022-07-07 21:10:26'),(54,54,7,1,NULL,NULL,'2021-03-08',3,1,100.00,'2022-07-07 21:20:53','2022-07-07 21:22:33'),(55,55,7,1,NULL,NULL,'2021-03-15',1,7,80.00,'2022-07-07 21:33:26','2022-07-07 21:35:10'),(56,56,8,1,NULL,NULL,'2021-02-20',1,4,130.00,'2022-07-07 21:34:15','2022-07-07 21:40:24'),(57,57,8,1,NULL,NULL,'2021-03-10',2,4,150.00,'2022-07-09 19:38:56','2022-07-09 19:39:22'),(58,58,8,1,NULL,NULL,'2021-03-17',3,4,120.00,'2022-07-09 19:51:58','2022-07-09 19:52:30'),(59,59,8,1,NULL,NULL,'2021-03-05',5,7,170.00,'2022-07-09 20:19:22','2022-07-09 20:20:39'),(60,60,9,1,NULL,NULL,'2021-02-12',2,4,200.00,'2022-07-09 20:36:27','2022-07-09 20:37:50'),(61,61,8,1,NULL,NULL,'2021-03-22',2,4,90.00,'2022-07-09 20:47:06','2022-07-09 20:47:34'),(62,62,9,1,NULL,NULL,'2021-03-09',2,7,160.00,'2022-07-09 20:49:39','2022-07-09 20:50:17'),(63,63,8,1,NULL,NULL,'2021-03-24',2,7,120.00,'2022-07-16 20:14:59','2022-07-16 20:15:30'),(64,64,8,1,NULL,NULL,'2021-03-11',2,4,150.00,'2022-07-16 22:25:18','2022-07-16 22:26:05'),(65,65,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-25 22:46:02','2022-07-25 22:46:02'),(66,66,8,2,NULL,NULL,'2021-03-30',1,7,80.00,'2022-07-29 20:35:55','2022-07-29 20:36:16'),(67,67,8,1,NULL,NULL,'2021-03-30',2,7,120.00,'2022-07-29 21:09:50','2022-07-29 21:10:18'),(68,68,8,1,NULL,NULL,'2021-03-16',2,4,150.00,'2022-07-29 21:38:38','2022-07-29 21:39:18'),(69,69,NULL,1,NULL,NULL,NULL,2,7,NULL,'2022-07-29 21:45:04','2022-07-29 21:45:04'),(70,70,NULL,1,NULL,NULL,NULL,3,7,NULL,'2022-07-29 21:51:35','2022-07-29 21:51:35'),(71,71,NULL,1,NULL,NULL,NULL,2,4,NULL,'2022-07-29 21:55:32','2022-07-29 21:55:32'),(72,72,NULL,2,NULL,NULL,NULL,2,7,NULL,'2022-07-29 21:59:39','2022-07-29 21:59:39'),(73,73,NULL,1,NULL,NULL,NULL,2,4,NULL,'2022-07-29 22:04:12','2022-07-29 22:04:12'),(74,74,8,2,NULL,NULL,'2021-05-05',1,7,130.00,'2022-07-29 22:15:57','2022-07-29 22:19:17');

--
-- Table structure for table `scores`
--

CREATE TABLE `scores` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned NOT NULL,
  `user_id_create` bigint(20) unsigned NOT NULL,
  `report_date` date DEFAULT NULL,
  `score_equifax` double DEFAULT NULL,
  `score_expirian` double DEFAULT NULL,
  `score_transunion` double DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `scores`
--

INSERT INTO `scores` VALUES (1,2,5,'2021-01-19',666,672,655,1,'2022-06-04 21:51:17','2022-06-04 21:51:17'),(2,2,5,'2021-05-11',644,705,721,1,'2022-06-04 21:52:04','2022-06-04 21:52:04'),(3,2,5,'2021-11-11',747,751,751,1,'2022-06-04 21:52:47','2022-06-04 21:52:47'),(4,4,8,'2020-11-11',639,637,642,1,'2022-06-28 20:18:58','2022-06-28 20:18:58'),(5,4,8,'2021-04-16',506,517,519,1,'2022-06-28 20:19:43','2022-06-28 20:19:43'),(6,4,8,'2021-05-25',541,510,547,1,'2022-06-28 20:20:28','2022-06-28 20:20:28'),(7,6,8,'2020-11-16',492,519,498,1,'2022-06-28 22:56:44','2022-06-28 22:56:44'),(8,7,8,'2021-05-04',723,661,661,1,'2022-06-29 01:02:09','2022-06-29 01:02:09'),(9,8,8,'2020-11-20',659,659,642,1,'2022-06-29 01:57:00','2022-06-29 01:57:00'),(10,8,8,'2021-04-13',661,661,661,1,'2022-06-29 01:57:37','2022-06-29 01:57:37'),(11,8,8,'2021-08-19',619,734,734,1,'2022-06-29 01:58:17','2022-06-29 01:58:17'),(12,9,8,'2020-11-19',643,651,626,1,'2022-06-29 03:06:20','2022-06-29 03:06:20'),(13,11,8,'2020-11-28',636,664,685,1,'2022-06-29 03:58:09','2022-06-29 03:58:09'),(14,10,8,'2020-12-15',573,624,619,1,'2022-06-29 04:21:01','2022-06-29 04:21:01'),(15,12,8,'2021-09-14',439,447,513,1,'2022-06-29 04:45:04','2022-06-29 04:45:04'),(16,12,8,'2020-11-27',465,450,484,1,'2022-06-29 04:46:11','2022-06-29 04:46:11'),(17,13,9,'2020-11-24',536,573,573,1,'2022-06-29 20:25:35','2022-06-29 20:25:35'),(18,14,9,'2020-11-18',503,501,471,1,'2022-06-29 21:44:55','2022-06-29 21:44:55'),(19,15,9,'2020-11-27',NULL,502,NULL,1,'2022-06-29 22:04:10','2022-06-29 22:04:10'),(20,15,9,'2021-05-26',NULL,509,NULL,1,'2022-06-29 22:04:39','2022-06-29 22:04:39'),(21,16,9,'2020-12-02',550,576,565,1,'2022-06-29 23:44:33','2022-06-29 23:44:33'),(22,16,9,'2021-04-08',622,639,644,1,'2022-06-29 23:45:10','2022-06-29 23:45:10'),(23,16,9,'2021-07-09',613,571,554,1,'2022-06-29 23:45:56','2022-06-29 23:45:56'),(24,16,9,'2021-10-18',593,635,566,1,'2022-06-29 23:46:58','2022-06-29 23:46:58'),(25,17,9,'2020-12-03',627,635,580,1,'2022-06-30 00:49:49','2022-06-30 00:49:49'),(26,17,9,'2021-04-08',638,643,629,1,'2022-06-30 00:50:26','2022-06-30 00:50:26'),(27,17,9,'2021-09-18',NULL,658,NULL,1,'2022-06-30 01:02:50','2022-06-30 01:02:50'),(28,17,9,'2021-11-25',699,704,744,1,'2022-06-30 01:03:29','2022-06-30 01:03:29'),(29,18,9,'2020-11-28',515,515,516,1,'2022-06-30 02:15:56','2022-06-30 02:15:56'),(30,18,9,'2021-05-10',NULL,576,NULL,1,'2022-06-30 02:16:26','2022-06-30 02:16:26'),(31,20,8,'2020-11-18',641,622,627,1,'2022-06-30 20:19:47','2022-06-30 20:19:47'),(32,20,8,'2021-05-13',630,662,700,1,'2022-06-30 20:20:19','2022-06-30 20:20:19'),(33,21,8,'2021-04-16',671,628,691,1,'2022-06-30 20:58:56','2022-06-30 20:58:56'),(34,21,8,'2022-04-14',727,708,726,1,'2022-06-30 20:59:45','2022-06-30 20:59:45'),(35,22,9,'2020-12-15',651,631,644,1,'2022-06-30 21:30:49','2022-06-30 21:30:49'),(36,22,9,'2021-04-16',662,661,NULL,1,'2022-06-30 21:31:27','2022-06-30 21:31:27'),(37,22,9,'2021-12-09',611,624,704,1,'2022-06-30 21:32:22','2022-06-30 21:32:22'),(38,23,8,'2020-12-16',536,487,527,1,'2022-06-30 21:57:47','2022-06-30 21:57:47'),(39,23,8,'2021-04-13',582,573,582,1,'2022-06-30 21:58:27','2022-06-30 21:58:27'),(40,23,8,'2021-08-23',528,460,481,1,'2022-06-30 21:59:04','2022-06-30 21:59:04'),(41,23,8,'2021-11-04',502,584,595,1,'2022-06-30 21:59:42','2022-06-30 21:59:42'),(42,24,8,'2020-12-13',654,646,645,1,'2022-06-30 22:42:24','2022-06-30 22:42:24'),(43,25,8,'2020-12-09',541,562,542,1,'2022-06-30 23:19:53','2022-06-30 23:19:53'),(44,25,8,'2021-05-08',536,492,532,1,'2022-06-30 23:20:26','2022-06-30 23:20:26'),(45,27,8,'2021-01-16',634,623,609,1,'2022-07-01 02:22:30','2022-07-01 02:22:30'),(46,27,8,'2021-04-08',681,672,673,1,'2022-07-01 02:23:08','2022-07-01 02:23:08'),(47,28,8,'2021-01-13',598,543,554,1,'2022-07-01 02:48:42','2022-07-01 02:48:42'),(48,28,8,'2021-04-26',616,594,615,1,'2022-07-01 02:49:14','2022-07-01 02:49:14'),(49,28,8,'2021-11-15',642,599,644,1,'2022-07-01 02:49:47','2022-07-01 02:49:47'),(50,29,8,'2020-12-26',626,649,619,1,'2022-07-01 03:23:17','2022-07-01 03:23:17'),(51,30,8,'2021-05-06',599,585,544,1,'2022-07-01 03:37:13','2022-07-01 03:37:13'),(52,31,8,'2020-12-23',661,574,622,1,'2022-07-01 03:58:49','2022-07-01 03:58:49'),(53,31,8,'2021-04-08',645,593,678,1,'2022-07-01 03:59:21','2022-07-01 03:59:21'),(54,32,8,'2021-01-05',560,605,602,1,'2022-07-01 04:29:44','2022-07-01 04:29:44'),(55,32,8,'2021-05-12',603,598,603,1,'2022-07-01 04:30:11','2022-07-01 04:30:11'),(56,32,8,'2021-12-09',622,686,687,1,'2022-07-01 04:30:39','2022-07-01 04:30:39'),(57,33,9,'2021-01-25',532,529,536,1,'2022-07-01 19:58:46','2022-07-01 19:58:46'),(58,34,9,'2021-05-21',NULL,582,NULL,1,'2022-07-01 20:45:08','2022-07-01 20:45:08'),(59,34,9,'2021-07-14',713,699,704,1,'2022-07-01 20:45:44','2022-07-01 20:45:44'),(60,34,9,'2021-10-18',597,629,629,1,'2022-07-01 20:46:21','2022-07-01 20:46:21'),(61,34,9,'2021-01-08',NULL,593,NULL,1,'2022-07-01 20:46:43','2022-07-01 20:46:43'),(62,35,9,'2021-02-12',NULL,548,NULL,1,'2022-07-01 21:44:04','2022-07-01 21:44:04'),(63,35,9,'2021-05-04',NULL,598,NULL,1,'2022-07-01 21:44:31','2022-07-01 21:44:31'),(64,36,9,'2021-02-11',679,664,657,1,'2022-07-01 22:03:11','2022-07-01 22:03:11'),(65,36,9,'2021-05-10',683,667,661,1,'2022-07-01 22:03:40','2022-07-01 22:03:40'),(66,36,9,'2021-09-14',NULL,682,NULL,1,'2022-07-01 22:04:15','2022-07-01 22:04:15'),(67,36,9,'2022-02-16',NULL,714,NULL,1,'2022-07-01 22:04:38','2022-07-01 22:04:38'),(68,37,9,'2021-05-10',631,642,639,1,'2022-07-01 23:50:27','2022-07-01 23:50:27'),(69,37,9,'2021-02-04',622,607,615,1,'2022-07-01 23:51:13','2022-07-01 23:51:13'),(70,38,9,'2021-02-10',569,565,593,1,'2022-07-02 02:28:08','2022-07-02 02:28:08'),(71,38,9,'2021-05-13',607,571,628,1,'2022-07-02 02:29:01','2022-07-02 02:29:01'),(72,38,9,'2021-07-28',NULL,601,NULL,1,'2022-07-02 02:29:40','2022-07-02 02:29:40'),(73,38,9,'2022-02-04',711,664,711,1,'2022-07-02 02:30:13','2022-07-02 02:30:13'),(74,39,8,'2021-02-04',672,524,524,1,'2022-07-02 21:06:02','2022-07-02 21:06:02'),(75,40,9,'2021-02-18',552,552,552,1,'2022-07-02 21:08:53','2022-07-02 21:08:53'),(76,40,9,'2021-09-14',667,647,667,1,'2022-07-02 21:09:29','2022-07-02 21:09:29'),(77,40,9,'2022-02-04',682,674,687,1,'2022-07-02 21:10:01','2022-07-02 21:10:01'),(78,42,8,'2021-02-05',682,679,680,1,'2022-07-06 01:16:46','2022-07-06 01:16:46'),(79,43,8,'2021-02-08',561,605,590,1,'2022-07-06 01:31:42','2022-07-06 01:31:42'),(80,45,8,'2021-02-25',662,656,660,1,'2022-07-06 02:11:03','2022-07-06 02:11:03'),(81,46,8,'2021-02-02',597,603,592,1,'2022-07-06 21:02:31','2022-07-06 21:02:31'),(82,48,8,'2021-03-01',635,632,631,1,'2022-07-06 21:59:36','2022-07-06 21:59:36'),(83,48,8,'2021-10-13',697,666,697,1,'2022-07-06 22:00:12','2022-07-06 22:00:12'),(84,49,5,'2021-02-23',736,638,649,1,'2022-07-07 00:52:05','2022-07-07 00:52:05'),(85,49,5,'2021-06-22',NULL,686,NULL,1,'2022-07-07 01:16:38','2022-07-07 01:16:38'),(86,49,5,'2021-11-25',744,676,719,1,'2022-07-07 01:17:18','2022-07-07 01:17:18'),(87,50,9,'2021-01-04',643,639,645,1,'2022-07-07 18:52:36','2022-07-07 18:52:36'),(88,50,9,'2021-06-16',674,664,675,1,'2022-07-07 18:53:10','2022-07-07 18:53:10'),(89,51,9,'2021-02-03',562,560,559,1,'2022-07-07 19:18:51','2022-07-07 19:18:51'),(90,51,9,'2022-01-19',NULL,512,NULL,1,'2022-07-07 19:19:21','2022-07-07 19:19:21'),(91,52,9,'2021-02-18',528,532,537,1,'2022-07-07 20:14:48','2022-07-07 20:14:48'),(92,52,9,'2021-11-11',564,569,567,1,'2022-07-07 20:15:12','2022-07-07 20:15:12'),(93,53,8,'2021-03-10',557,416,594,1,'2022-07-07 21:16:13','2022-07-07 21:16:13'),(94,53,8,'2021-06-16',608,521,622,1,'2022-07-07 21:16:49','2022-07-07 21:16:49'),(95,56,8,'2021-02-20',627,619,618,1,'2022-07-07 21:57:11','2022-07-07 21:57:11'),(96,57,8,'2021-03-10',532,527,539,1,'2022-07-09 19:42:23','2022-07-09 19:42:23'),(97,58,8,'2021-03-17',540,522,532,1,'2022-07-09 19:59:02','2022-07-09 19:59:02'),(98,58,8,'2021-06-17',648,650,664,1,'2022-07-09 19:59:33','2022-07-09 19:59:33'),(99,59,8,'2021-03-05',423,396,422,1,'2022-07-09 20:27:20','2022-07-09 20:27:20'),(100,60,9,'2021-02-12',609,592,604,1,'2022-07-09 20:39:59','2022-07-09 20:39:59'),(101,62,9,'2021-03-09',552,552,552,1,'2022-07-09 20:51:50','2022-07-09 20:51:50'),(102,62,9,'2021-08-03',583,635,635,1,'2022-07-09 20:52:24','2022-07-09 20:52:24'),(103,62,9,'2021-12-09',661,612,612,1,'2022-07-09 20:53:06','2022-07-09 20:53:06'),(104,61,8,'2021-03-22',670,655,661,1,'2022-07-09 20:59:26','2022-07-09 20:59:26'),(105,61,8,'2021-06-03',679,697,713,1,'2022-07-09 20:59:58','2022-07-09 20:59:58'),(106,61,8,'2021-09-01',657,635,652,1,'2022-07-09 21:00:57','2022-07-09 21:00:57'),(107,61,8,'2022-02-16',701,673,688,1,'2022-07-09 21:01:29','2022-07-09 21:01:29'),(108,63,8,'2021-03-24',517,517,517,1,'2022-07-16 21:44:33','2022-07-16 21:44:33'),(109,67,8,'2021-03-30',742,705,725,1,'2022-07-29 21:14:01','2022-07-29 21:14:01'),(110,67,8,'2021-06-18',738,733,752,1,'2022-07-29 21:28:44','2022-07-29 21:28:44'),(111,68,8,'2021-03-16',740,536,659,1,'2022-07-29 21:40:50','2022-07-29 21:40:50');

--
-- Table structure for table `select_goals`
--

CREATE TABLE `select_goals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id_create` bigint(20) unsigned NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `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 `select_goals`
--

INSERT INTO `select_goals` VALUES (1,'Unificar deudas','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(2,'Obtener Creditos','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(3,'Negocias deudas','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(4,'Aplicar para casa','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(5,'Aplicar para auto','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(6,'Aplicar para nuevos creditos','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(7,'Construcción de credito','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(8,'Refinanciar Cuentas','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(9,'Recuperar Identida','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(10,'Bajar Porcentajes de credito','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(11,'Subir Score','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21');

--
-- Table structure for table `select_method_payments`
--

CREATE TABLE `select_method_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id_create` bigint(20) unsigned NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `select_method_payments`
--

INSERT INTO `select_method_payments` VALUES (1,'Procesador','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(2,'Link DE Pago','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(3,'Banck Of America','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(4,'Cash App','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(5,'Zelle','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(6,'Banesco','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21');

--
-- Table structure for table `select_sales_channels`
--

CREATE TABLE `select_sales_channels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id_create` bigint(20) unsigned NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `select_sales_channels`
--

INSERT INTO `select_sales_channels` VALUES (1,'Referido','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(2,'Radio','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(3,'Base de datos','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(4,'Branding llamada','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(5,'Instagram','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(6,'Facebook','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(7,'Branding WhatssApp','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(8,'Branding Fomulario web','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21');

--
-- Table structure for table `select_statuses`
--

CREATE TABLE `select_statuses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id_create` bigint(20) unsigned NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `select_statuses`
--

INSERT INTO `select_statuses` VALUES (1,'Activo','Cuando un cliente esta al día y sigue su proceso',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(2,'Burned','Cuando un cliente esta al día y sigue su proceso',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(3,'Prospecto datos','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(4,'Atrasado','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(5,'Venta Fallida','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21');

--
-- Table structure for table `select_time_addresses`
--

CREATE TABLE `select_time_addresses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id_create` bigint(20) unsigned NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `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 `select_time_addresses`
--

INSERT INTO `select_time_addresses` VALUES (1,'1 - 11 Meses','',1,1,'2022-06-04 00:20:22','2022-06-04 00:20:22'),(2,'+1 año','',1,1,'2022-06-04 00:20:22','2022-06-04 00:20:22'),(3,'+2 año','',1,1,'2022-06-04 00:20:22','2022-06-04 00:20:22'),(4,'+5 año','',1,1,'2022-06-04 00:20:22','2022-06-04 00:20:22');

--
-- Table structure for table `select_type_addresses`
--

CREATE TABLE `select_type_addresses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id_create` bigint(20) unsigned NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `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 `select_type_addresses`
--

INSERT INTO `select_type_addresses` VALUES (1,'Principal','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(2,'Anterior','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(3,'Espos@','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(4,'Otro','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21');

--
-- Table structure for table `select_type_contacs`
--

CREATE TABLE `select_type_contacs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id_create` bigint(20) unsigned NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `select_type_contacs`
--

INSERT INTO `select_type_contacs` VALUES (1,'Venta','Cuando un cliente se vende por primera vez',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(2,'Intento de venta','Cuando un propstecto se intenta vender',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(3,'Cobro','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(4,'Servicio al cliente','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(5,'Recordatorio de pago','',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21');

--
-- Table structure for table `select_type_documents`
--

CREATE TABLE `select_type_documents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id_create` bigint(20) unsigned NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `select_type_documents`
--

INSERT INTO `select_type_documents` VALUES (1,'SSN','Social Segurity Number',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(2,'Tax Id','Numero de Tax Id',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21');

--
-- Table structure for table `select_type_numbers`
--

CREATE TABLE `select_type_numbers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id_create` bigint(20) unsigned NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `select_type_numbers`
--

INSERT INTO `select_type_numbers` VALUES (1,'Principal','Principal',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(2,'Trabajo','Trabajo',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(3,'Espos@','Espos@',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(4,'Familiar','Familiar',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(5,'Otro','Otro',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21');

--
-- Table structure for table `select_type_services`
--

CREATE TABLE `select_type_services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id_create` bigint(20) unsigned NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `select_type_services`
--

INSERT INTO `select_type_services` VALUES (1,'Reparación de credito','Reparación de credito',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21'),(2,'Asesoria Financiera','Asesoria Financiera',1,1,'2022-06-04 00:20:21','2022-06-04 00:20:21');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--



