--
-- Host: localhost    Database: originacion
-- ------------------------------------------------------


--
-- Table structure for table `absences`
--

CREATE TABLE `absences` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int NOT NULL,
  `user_id` int NOT NULL,
  `authorizing_user` int NOT NULL,
  `date` date NOT NULL,
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `absences`
--


--
-- Table structure for table `actions`
--

CREATE TABLE `actions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `module_id` int NOT NULL,
  `shortname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `actions`
--

INSERT INTO `actions` VALUES (1,NULL,NULL,1,'list','Ver listado de empresas',NULL),(2,NULL,NULL,1,'edit','Editar empresas',NULL),(3,NULL,NULL,1,'activate','Activar empresa',NULL),(4,NULL,NULL,1,'desactivate','Desactivar empresa',NULL),(6,NULL,NULL,1,'delete','Eliminar empresa',NULL),(7,NULL,NULL,2,'list','Ver listado de roles y permisos',NULL),(8,NULL,NULL,2,'edit','Editar roles',NULL),(9,NULL,NULL,2,'add','Agregar rol',NULL),(10,NULL,NULL,2,'activate','Activar rol',NULL),(11,NULL,NULL,2,'desactivate','Desactivar rol',NULL),(12,NULL,NULL,2,'delete','Eliminar rol',NULL),(13,NULL,NULL,1,'add','Agregar empresa',NULL),(14,NULL,NULL,2,'view','Ver detalle del rol',NULL),(15,NULL,NULL,3,'birthday','Tablero Cumpleaños del día','2024-01-11 00:00:00'),(16,NULL,NULL,3,'employees-range','Tablero Total de empleados (Por rango)','2024-01-11 00:00:00'),(17,NULL,NULL,3,'employees-area','Tablero Total de empleados (Por área)','2024-01-11 00:00:00'),(18,NULL,NULL,3,'employees-job','Tablero Total de empleados (Por puesto)','2024-01-11 00:00:00'),(19,NULL,NULL,2,'add-employee-role','Asociar usuarios a rol',NULL),(20,NULL,NULL,1,'add-employee-company','Asociar usuarios a empresas',NULL),(21,NULL,NULL,4,'list','Ver listado',NULL),(23,NULL,NULL,4,'edit','Editar',NULL),(27,NULL,NULL,5,'list','Ver listado',NULL),(28,NULL,NULL,4,'add','Agregar nuevo',NULL),(29,NULL,NULL,4,'delete','Eliminar',NULL),(30,NULL,NULL,5,'edit','Editar',NULL),(31,NULL,NULL,5,'add','Agregar',NULL),(32,NULL,NULL,5,'delete','Eliminar',NULL),(34,NULL,NULL,6,'list','Ver listado',NULL),(35,NULL,NULL,6,'edit','Editar',NULL),(36,NULL,NULL,5,'list','Ver listado',NULL),(37,NULL,NULL,6,'add','Agregar',NULL),(38,NULL,NULL,6,'delete','Eliminar',NULL),(39,NULL,NULL,7,'list','Ver listado',NULL),(40,NULL,NULL,7,'edit','Editar',NULL),(41,NULL,NULL,7,'add','Agregar',NULL),(42,NULL,NULL,7,'delete','Eliminar',NULL),(43,NULL,NULL,8,'list','Ver listado',NULL),(45,NULL,NULL,8,'edit','Editar',NULL),(46,NULL,NULL,8,'add','Agregar',NULL),(47,NULL,NULL,8,'delete','Eliminar',NULL),(48,NULL,NULL,9,'list','Ver listado',NULL),(49,NULL,NULL,9,'edit','Editar',NULL),(50,NULL,NULL,9,'add','Agregar',NULL),(51,NULL,NULL,9,'delete','Eliminar',NULL),(52,NULL,NULL,10,'list','Ver listado',NULL),(53,NULL,NULL,10,'edit','Editar',NULL),(54,NULL,NULL,10,'add','Agregar',NULL),(55,NULL,NULL,10,'delete','Eliminar',NULL),(56,NULL,NULL,12,'list','Ver listado de empleados activos',NULL),(57,NULL,NULL,12,'edit','Editar',NULL),(58,NULL,NULL,12,'add','Agregar',NULL),(59,NULL,NULL,12,'delete','Eliminar',NULL),(60,NULL,NULL,12,'activate','Reactivar empleado',NULL),(61,NULL,NULL,12,'desactivate','Baja empleado',NULL),(62,NULL,NULL,12,'list-inactive','Ver listado de empleados inactivos',NULL),(63,NULL,NULL,12,'view','Ver detalle de empleado',NULL),(64,NULL,NULL,12,'profile','Ver perfil público de empleados',NULL),(65,NULL,NULL,13,'list','Ver listado',NULL),(66,NULL,NULL,13,'make-report','Generar reporte',NULL),(67,NULL,NULL,13,'add','Registrar movimiento',NULL),(68,NULL,NULL,13,'reports','Listado de reportes guardados',NULL),(69,NULL,NULL,14,'list','Ver listado',NULL),(70,NULL,NULL,14,'edit','Editar',NULL),(71,NULL,NULL,14,'add','Agregar',NULL),(72,NULL,NULL,14,'delete','Eliminar',NULL),(73,NULL,NULL,15,'list','Ver listado',NULL),(74,NULL,NULL,15,'authorize','Autorizar vacaciones',NULL),(75,NULL,NULL,15,'deny','Rechazar vacaciones',NULL),(76,NULL,NULL,15,'request','Solicitar vacaciones',NULL),(77,NULL,NULL,16,'list','Ver listado de proveedores activos',NULL),(78,NULL,NULL,16,'list-inactive','Ver listado de proveedores inactivos',NULL),(79,NULL,NULL,16,'add','Agregar proveedor',NULL),(80,NULL,NULL,16,'edit','Editar',NULL),(81,NULL,NULL,16,'delete','Eliminar',NULL),(82,NULL,NULL,16,'activate','Activar',NULL),(83,NULL,NULL,16,'desactivate','Desactivar',NULL),(84,NULL,NULL,16,'view','Ver detalle de proveedor',NULL),(85,NULL,NULL,16,'evaluate','Aplicar evaluación',NULL),(86,NULL,NULL,17,'dashboard','Dashboard de gastos',NULL),(87,NULL,NULL,17,'board-dashboard-by-year','Tablero Gastos de proveedores por año',NULL),(88,NULL,NULL,17,'board-refund','Tablero Reembolsos por año',NULL),(89,NULL,NULL,17,'board-expenses','Tablero Egresos por tipo de salida',NULL),(90,NULL,NULL,17,'add','Agregar gasto',NULL),(91,NULL,NULL,13,'list','Ver listado',NULL),(92,NULL,NULL,17,'edit','Editar',NULL),(93,NULL,NULL,17,'delete','Eliminar',NULL),(94,NULL,NULL,17,'clone','Clonar gasto',NULL),(95,NULL,NULL,18,'list','Ver listado de activos',NULL),(96,NULL,NULL,18,'list-inactive','Ver listado de inactivos',NULL),(97,NULL,NULL,18,'authorize','Autorizar bajas',NULL),(98,NULL,NULL,18,'add','Agregar activo',NULL),(99,NULL,NULL,18,'assign','Asignar activo a empleado',NULL),(100,NULL,NULL,18,'edit','Editar',NULL),(101,NULL,NULL,18,'delete','Baja de inventario',NULL),(102,NULL,NULL,18,'my-own','Ver mis activos asignados',NULL),(103,NULL,NULL,18,'add-maintenance','Agregar mantenimiento',NULL),(104,NULL,NULL,18,'view-maintenance','Ver historial de mantenimientos',NULL),(105,NULL,NULL,19,'list','Listado de certificaciones',NULL),(106,NULL,NULL,19,'add','Agregar',NULL),(107,NULL,NULL,19,'edit','Editar',NULL),(108,NULL,NULL,19,'delete','Eliminar',NULL),(109,NULL,NULL,19,'assign','Asignar a empleados',NULL),(110,NULL,NULL,19,'view','Detalle de certificación',NULL),(111,NULL,NULL,14,'assign','Asignar capacitación a empleados',NULL),(112,NULL,NULL,14,'my-own','Ver mis capacitaciones',NULL),(113,NULL,NULL,14,'view','Ver detalle de capacitación',NULL),(114,NULL,NULL,20,'list','Mis tareas',NULL),(115,NULL,NULL,20,'add','Agregar',NULL),(116,NULL,NULL,20,'delete','Eliminar',NULL),(117,NULL,NULL,20,'assign','Asignar tareas',NULL),(118,NULL,NULL,20,'finish','Finalizar tarea',NULL),(119,NULL,NULL,20,'add-tag','Agregar tags',NULL),(120,NULL,NULL,21,'list','Calendario',NULL),(121,NULL,NULL,21,'add','Agregar evento',NULL),(122,NULL,NULL,21,'assign','Agregar invitados',NULL),(123,NULL,NULL,3,'main','Ver dashboard principal',NULL),(124,NULL,NULL,22,'list','Listado de oficinas',NULL),(125,NULL,NULL,22,'add','Agregar oficina',NULL),(126,NULL,NULL,22,'edit','Editar',NULL),(127,NULL,NULL,22,'delete','Eliminar',NULL),(128,NULL,NULL,23,'list','Lista de logs',NULL),(129,NULL,NULL,12,'export','Exportar listado',NULL),(131,NULL,NULL,3,'complete-profile','Tablero Completar perfil','2024-01-11 00:00:00'),(132,NULL,NULL,3,'birthday-month','Tablero Cumpleaños del mes','2024-01-11 00:00:00'),(133,NULL,NULL,3,'employees-total','Tablero Total de empleados','2024-01-11 00:00:00'),(134,NULL,NULL,3,'upcoming-anniversaries','Tablero Próximos aniversarios','2024-01-11 00:00:00'),(135,NULL,NULL,3,'upcoming-anniversaries-three','Tablero Próximos a cumplir 3 meses','2024-01-11 00:00:00'),(136,NULL,NULL,3,'uses-news','Tablero Nuevos ingresos del mes','2024-01-11 00:00:00'),(137,NULL,NULL,17,'list','Grid de gastos por filtro',NULL),(138,NULL,NULL,17,'board-payments-by-q','Tablero Egresos por cuadrantes',NULL),(139,NULL,NULL,17,'search','Filtros de búsqueda',NULL),(140,NULL,NULL,17,'approve','Aprobar',NULL),(141,NULL,NULL,17,'reject','Rechazar',NULL),(142,NULL,NULL,24,'list','Ver listado',NULL),(143,NULL,NULL,24,'edit','Editar',NULL),(144,NULL,NULL,24,'add','Agregar',NULL),(145,NULL,NULL,24,'delete','Eliminar',NULL),(146,NULL,NULL,18,'dashboard','Dashboard activos',NULL),(147,NULL,NULL,18,'board-dashboard-type','Tablero Tipo de Activo',NULL),(148,NULL,NULL,18,'board-dashboard-upcoming-maintenance','Tablero Próximos mantenimientos',NULL),(149,NULL,NULL,18,'board-dashboard-pending-responsives','Tablero Resonsivas pendientes',NULL),(150,NULL,NULL,18,'unauthorize','Rechazar baja',NULL),(151,NULL,NULL,15,'edit','Editar solicitud',NULL),(152,NULL,NULL,15,'delete','Eliminar solicitud',NULL),(153,'2024-01-11 16:03:55','2024-01-11 16:03:55',20,'edit','Editar tareas',NULL),(154,'2024-01-11 16:04:11','2024-01-11 16:04:11',6,'view','Visualizar detalles del aviso',NULL),(155,'2024-01-11 16:04:11','2024-01-11 16:04:11',6,'activate','Activar el aviso',NULL),(156,'2024-01-11 16:04:11','2024-01-11 16:04:11',6,'desactivate','Desactivar el aviso',NULL),(157,'2024-01-11 16:04:29','2024-01-11 16:04:29',3,'task','Tablero Tareas pendientes del día',NULL),(158,NULL,NULL,25,'list','Listado de productos',NULL),(159,NULL,NULL,25,'add','Agregar producto',NULL),(160,NULL,NULL,25,'activate','Activar producto',NULL),(161,NULL,NULL,24,'delete','Eliminar',NULL),(162,NULL,NULL,25,'edit','Editar',NULL),(163,NULL,NULL,25,'activate','Activar producto',NULL),(164,NULL,NULL,25,'desactivate','Desactivar producto',NULL),(165,NULL,NULL,3,'advertisements-dashboard','Tablero de anuncios',NULL),(166,NULL,NULL,26,'view-my-own-request-credit','Ver mis propios trámites',NULL),(167,NULL,NULL,3,'employees-range','Tablero Total de empleados (Por rango)','2024-01-11 00:00:00'),(168,NULL,NULL,26,'edit-my-own-request-credit','Editar mis propios trámites',NULL),(169,NULL,NULL,3,'employees-range','Tablero Total de empleados (Por rango)','2024-01-11 00:00:00'),(170,NULL,NULL,26,'delete-my-own-request-credit','Eliminar mis propios trámites',NULL),(171,NULL,NULL,26,'list','Ver listado de trámites completo',NULL),(172,NULL,NULL,3,'employees-range','Tablero Total de empleados (Por rango)','2024-01-11 00:00:00'),(173,NULL,NULL,26,'edit','Editar cualquier trámite (no solo los propios)',NULL),(174,NULL,NULL,26,'delete','Eliminar cualquier trámite (no solo los propios)',NULL),(175,NULL,NULL,26,'approve','Aprovar un trámite',NULL),(176,NULL,NULL,26,'reject','Rechazar un trámite',NULL),(177,NULL,NULL,26,'view-files','Ver documentos',NULL),(178,NULL,NULL,26,'dowload-files','Descargar documentos',NULL),(179,NULL,NULL,26,'dowload-all','Descargar expediente',NULL),(180,NULL,NULL,26,'add','Crear nuevo trámite',NULL),(181,NULL,NULL,26,'upload-files','Cargar documentos de acuerdo a la etapa',NULL),(182,NULL,NULL,26,'garbage','Ver papelera',NULL),(183,NULL,NULL,25,'delete','Eliminar producto',NULL),(184,'2025-05-07 07:13:24','2025-05-07 07:13:24',3,'advertisements-dashboard','Visualizar avisos en dashboard',NULL),(185,'2025-05-07 07:13:24','2025-05-07 07:13:24',6,'view','Visualizar detalles del aviso',NULL),(186,'2025-05-07 07:13:24','2025-05-07 07:13:24',6,'activate','Activar el aviso',NULL),(187,'2025-05-07 07:13:24','2025-05-07 07:13:24',6,'desactivate','Desactivar el aviso',NULL);

--
-- Table structure for table `advertisements`
--

CREATE TABLE `advertisements` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_start` date DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT 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 `advertisements`
--


--
-- Table structure for table `advertisements_files`
--

CREATE TABLE `advertisements_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `advertisement_id` int NOT NULL,
  `file_id` int 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `advertisements_files`
--


--
-- Table structure for table `advertisements_jobs`
--

CREATE TABLE `advertisements_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `advertisement_id` int NOT NULL,
  `job_id` int 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `advertisements_jobs`
--


--
-- Table structure for table `banks`
--

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

--
-- Dumping data for table `banks`
--


--
-- Table structure for table `capacitation`
--

CREATE TABLE `capacitation` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `company_id` int NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `objective` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_evaluation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cover` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_start` date DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `evaluable` tinyint(1) NOT NULL DEFAULT '1',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT 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 `capacitation`
--


--
-- Table structure for table `capacitation_files`
--

CREATE TABLE `capacitation_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `capacitation_id` int NOT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci 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 `capacitation_files`
--


--
-- Table structure for table `capacitation_jobs`
--

CREATE TABLE `capacitation_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `capacitation_id` int NOT NULL,
  `job_id` int 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 `capacitation_jobs`
--


--
-- Table structure for table `capacitation_users`
--

CREATE TABLE `capacitation_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `capacitation_id` int NOT NULL,
  `user_id` int NOT NULL,
  `user_score` int DEFAULT NULL,
  `score` int DEFAULT NULL,
  `approved` tinyint(1) NOT NULL DEFAULT '0',
  `evaluated` tinyint(1) NOT NULL DEFAULT '0',
  `date_start` date DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `status` enum('Pendiente','Iniciado','Finalizado','Evaluado') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pendiente',
  `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 `capacitation_users`
--


--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `primary_color` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '#7367f0',
  `secondary_color` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '#f4ac5d',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company`
--

INSERT INTO `company` VALUES (1,'Tobb Cobranza','Tobb','#f4ee2f','#000',NULL,'admin@tobb.com.mx','+52 55 37 43 04 80',1,'2025-05-07 07:13:21','2025-05-07 09:58:26',NULL);

--
-- Table structure for table `credit_history`
--

CREATE TABLE `credit_history` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `credit_id` int NOT NULL,
  `prev_credit` json DEFAULT NULL,
  `current_credit` json DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `post_history` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `credit_history`
--


--
-- Table structure for table `credit_users`
--

CREATE TABLE `credit_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `role_id` int NOT NULL,
  `credit_id` int 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `credit_users`
--


--
-- Table structure for table `credits`
--

CREATE TABLE `credits` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `credit_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `rejected_by` int DEFAULT NULL,
  `approved_by` int DEFAULT NULL,
  `asiggned` int DEFAULT NULL,
  `current_step` int NOT NULL,
  `status` enum('Pendiente','Aprobada','Rechazada','Usurpación','Eliminado') COLLATE utf8mb4_unicode_ci DEFAULT 'Pendiente',
  `reason_for_rejection` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fields` json DEFAULT NULL,
  `documents` json DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `product_id` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `credits`
--


--
-- Table structure for table `discount`
--

CREATE TABLE `discount` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int NOT NULL,
  `user_id` int NOT NULL,
  `authorizing_user` int DEFAULT NULL,
  `date` date DEFAULT NULL,
  `amount` decimal(8,2) unsigned DEFAULT NULL,
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `discount`
--


--
-- Table structure for table `document_bases`
--

CREATE TABLE `document_bases` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` enum('Image','PDF','Excel','Word') COLLATE utf8mb4_unicode_ci NOT NULL,
  `max_length` int DEFAULT NULL,
  `className` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `helpText` varchar(255) COLLATE utf8mb4_unicode_ci 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=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `document_bases`
--

INSERT INTO `document_bases` VALUES (1,'Solicitud de inscripción de crédito',NULL,'PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(2,'CURP',NULL,'PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(3,'Constancia de Situación Fiscal (RFC)',NULL,'PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(4,'Estado de cuenta bancario',NULL,'PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(5,'Comprobante de domicilio','No mayor a 3 meses de antigüedad','PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(6,'Acta de nacimiento','Acta de nacimiento','PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(7,'Acta de matrimonio','Acta de matrimonio o constancia de cuncubinato de quien comprueba la propiedad','PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(8,'INE','INE','PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(9,'Vigencia de credencial de elector','INE','PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(10,'Pasaporte','Pasaporte','PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(11,'Expediente','Expediente','PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(12,'Título de propiedad de la vivienda','Documento que acredite la legítima tenencia','PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(13,'Carta bajo protesta de decir la verdad',NULL,'PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(14,'Presupuesto de la mejora a realizar',NULL,'PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(15,'Acuse o folio de evidencia fotográfica',NULL,'PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(16,'Reporte fotgráfico inicial de vivienda a mejorar',NULL,'PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(17,'Presupuesto de la notaria','Para los trámites de regularización de vivienda con clabe interbancaria(en caso de aplicar)','PDF',NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24');

--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_id` int NOT NULL DEFAULT '1',
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `documents`
--

INSERT INTO `documents` VALUES (1,'Comprobante de domicilio',1,1,NULL,NULL,NULL,'Comprobante de domicilio'),(2,'Identificación oficial (INE/ Pasaporte)',1,1,NULL,NULL,NULL,'Identificación oficial (INE/ Pasaporte)'),(3,'Cedula RFC',1,1,NULL,NULL,NULL,'Cedula RFC'),(4,'Contrato de Confidencialidad',1,1,NULL,NULL,NULL,'Contrato de Confidencialidad'),(5,'Comprobante de estudios',1,1,NULL,NULL,NULL,'Comprobante de estudios'),(6,'Acta de nacimiento',1,1,NULL,NULL,NULL,'Acta de nacimiento'),(7,'Acta de nacimiento hijos',1,0,NULL,NULL,NULL,'Acta de nacimiento hijos'),(8,'NSS',1,1,NULL,NULL,NULL,'NSS'),(9,'Carta de recomendación',1,1,NULL,NULL,NULL,'Carta de recomendación'),(10,'Aviso de retención',1,0,NULL,NULL,NULL,'Aviso de retención'),(11,'Cuestionario de emergencia',1,1,NULL,NULL,NULL,'Cuestionario de emergencia'),(12,'Descripción de puesto',1,1,NULL,NULL,NULL,'Descripción de puesto'),(13,'Inducción al SGC',1,0,NULL,NULL,NULL,'Inducción al SGC'),(14,'Carta de oferta laboral',1,1,NULL,NULL,NULL,'Carta de oferta laboral'),(15,'Pruebas psicométricas',1,1,NULL,NULL,NULL,'Pruebas psicométricas'),(16,'CURP',1,1,NULL,NULL,NULL,'CURP'),(17,'CV/ Solicitud de empleo',1,1,NULL,NULL,NULL,'CV/ Solicitud de empleo'),(18,'Acta de matrimonio',1,0,NULL,NULL,NULL,'Acta de matrimonio'),(19,'Evaluación de desempeño',1,0,NULL,NULL,NULL,'Evaluación de desempeño'),(20,'Reglamento Interno',1,0,NULL,NULL,NULL,'Reglamento Interno'),(21,'Carta renuncia',1,0,NULL,NULL,NULL,'Carta renuncia');

--
-- Table structure for table `drive`
--

CREATE TABLE `drive` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `file_id` int DEFAULT NULL,
  `parent_id` int DEFAULT NULL,
  `type` enum('File','Folder') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'File',
  `accesibility` enum('Public','Private') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Public',
  `read_only` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `drive`
--


--
-- Table structure for table `employee_growth`
--

CREATE TABLE `employee_growth` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_role_company_id` int DEFAULT NULL,
  `job_id` int DEFAULT 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 `employee_growth`
--


--
-- Table structure for table `event_users`
--

CREATE TABLE `event_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `event_id` int NOT NULL,
  `accepted` enum('Si','No','Tal vez','Pendiente') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Si',
  `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 `event_users`
--


--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int NOT NULL,
  `user_id` int NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_start` datetime NOT NULL,
  `date_end` datetime DEFAULT NULL,
  `all_day` tinyint(1) NOT NULL DEFAULT '0',
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `events`
--


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

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

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


--
-- Table structure for table `field_bases`
--

CREATE TABLE `field_bases` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` enum('Text','Number','Date','DropDown','Radio','Checkbox') COLLATE utf8mb4_unicode_ci NOT NULL,
  `min_length` int DEFAULT NULL,
  `max_length` int DEFAULT NULL,
  `options` text COLLATE utf8mb4_unicode_ci,
  `className` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `helpText` varchar(255) COLLATE utf8mb4_unicode_ci 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=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `field_bases`
--

INSERT INTO `field_bases` VALUES (1,'Nombre(s)','Nombre del derechohabiente','Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(2,'Apellido Paterno','Apellido Paterno','Text',3,30,NULL,NULL,NULL,NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(3,'Apellido Materno','Apellido Materno','Text',3,30,NULL,NULL,NULL,NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(4,'Monto de crédito solicitado','Monto de crédito solicitado','Number',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(5,'Número de folio del acuse de carga de evidencia inicial de la mejora','','Number',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(6,'CURP','CURP','Text',18,18,NULL,NULL,NULL,NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(7,'NSS','NSS','Text',11,11,NULL,NULL,NULL,NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(8,'RFC','RFC','Text',12,13,NULL,NULL,NULL,NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(9,'Clabe','Clave Interbancaria','Text',18,18,NULL,NULL,NULL,NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(10,'Celular','Celular','Number',10,10,NULL,NULL,NULL,NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(11,'Teléfono','Teléfono','Number',10,10,NULL,NULL,NULL,NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(12,'Email','Correo electrónico','Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(13,'Tipo de identificación','Tipo de identificación','DropDown',NULL,NULL,'INE,PASAPORTE,DNI',NULL,NULL,NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(14,'Número de indentificación','Número de indentificación','Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(15,'Fecha de validez de identificación','Fecha de validez de identificación','Date',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(16,'Género','Género','DropDown',NULL,NULL,'Masculino,Femenino',NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(17,'Estado Civil','Estado Civil','DropDown',NULL,NULL,'Soltero(o),Casado(o)',NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(18,'Regimen Patrimonial del matrimonio','Regimen Patrimonial del matrimonio','DropDown',NULL,NULL,'N/A,Separación de bienes,Sociedad Conyugal',NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(19,'Nombre de la empresa o patrón','Nombre de la empresa o patrón','Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(20,'Número de Registro Patronal (NRPP)','Número de Registro Patronal (NRPP)','Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(21,'Teléfono de la empresa donde trabaja el derechohabiente','Número de Registro Patronal (NRPP)','Number',10,10,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(22,'Extensión de la empresa donde trabaja el derechohabiente','Extensión de la empresa donde trabaja el derechohabiente','Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(23,'La vivienda para mejorar es','La vivienda para mejorar es','DropDown',NULL,NULL,'Propia,Cónyugue o concubino(a),Familiar,Rentada',NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(24,'Entidad',NULL,'DropDown',NULL,NULL,'Aguascalientes,Baja California,Baja California Sur,Campeche,Coahuila de Zaragoza,Colima,Chiapas,Chihuahua,CDMX,Durango,Guanajuato,Guerrero,Hidalgo,Jalisco,Estado de México,Michoacán de Ocampo,Morelos,Nayarit,Nuevo León,Oaxaca de Juárez,Puebla,Querétaro,Quintana Roo,San Luis Potosí,Sinaloa,Sonora,Tabasco,Tamaulipas,Tlaxcala,Veracruz de Ignacio de la Llave,Yucatán,Zacatecas',NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(25,'Calle',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(26,'No Exterior',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(27,'No Interior',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(28,'Lote',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(29,'Manzana',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(30,'Código Postal',NULL,'Number',5,5,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(31,'Municipio',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(32,'Colonia o Fraccionamiento',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(33,'Número de folio del acuse de carga de evidencia inicial de la mejora','Solo en caso de aplicar','Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(34,'Mejoravit',NULL,'DropDown',NULL,NULL,'Repara,Renueva',NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(35,'Plazo solicitado en años','(máximo 5 años Repara, máximo 10 años Renueva)','Number',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(36,'Estado CESI',NULL,'DropDown',NULL,NULL,'Aguascalientes,Baja California,Baja California Sur,Campeche,Coahuila de Zaragoza,Colima,Chiapas,Chihuahua,CDMX,Durango,Guanajuato,Guerrero,Hidalgo,Jalisco,Estado de México,Michoacán de Ocampo,Morelos,Nayarit,Nuevo León,Oaxaca de Juárez,Puebla,Querétaro,Quintana Roo,San Luis Potosí,Sinaloa,Sonora,Tabasco,Tamaulipas,Tlaxcala,Veracruz de Ignacio de la Llave,Yucatán,Zacatecas',NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(37,'Porcentaje del monto de crédito otorgado para pago de mano de obra para las reparaciones, ampliaciones o mejoras de la vivienda que habitó',NULL,'Number',1,3,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(38,'Porcentaje del monto de crédito otorgado para el pago de titulación de la vivienda a mi nombre, presentando previa cotización emitida por el Notario Público a cargo del trámite de Titulación',NULL,'Number',1,3,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(39,'Cuenta CLABE de la notaría a la que se le realizará el pago',NULL,'Number',18,18,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(40,'Primer Referencia - Nombre(s)',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(41,'Primer Referencia - Teléfono',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(42,'Primer Referencia - Celular',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(43,'Segunda Referencia - Nombre(s)',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(44,'Segunda Referencia - Teléfono',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(45,'Segunda Referencia - Celular',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(46,'Parentezco',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(47,'Beneficiario - Apellido Paterno',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(48,'Beneficiario - Apellido Materno',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24'),(49,'Beneficiario - Nombre(s)',NULL,'Text',NULL,NULL,NULL,NULL,NULL,NULL,'2025-05-07 07:13:24','2025-05-07 07:13:24');

--
-- Table structure for table `fields`
--

CREATE TABLE `fields` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `group_field_id` int NOT NULL,
  `step_id` int NOT NULL,
  `read_only` tinyint(1) NOT NULL DEFAULT '0',
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `unique` tinyint(1) NOT NULL DEFAULT '0',
  `header` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('Text','Number','Date','DropDown','Radio','Checkbox') COLLATE utf8mb4_unicode_ci NOT NULL,
  `min_length` int DEFAULT NULL,
  `max_length` int DEFAULT NULL,
  `options` text COLLATE utf8mb4_unicode_ci,
  `className` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `helpText` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int NOT NULL,
  `size` int NOT NULL DEFAULT '4',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `resume` tinyint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fields`
--

INSERT INTO `fields` VALUES (1,1,1,1,0,1,0,1,'Nombre(s)','Nombre del derechohabiente','Text',NULL,NULL,NULL,NULL,NULL,1,4,NULL,'2025-05-09 12:36:44','2025-05-09 12:36:44',0),(2,1,1,1,0,1,0,1,'Apellido Paterno','Apellido Paterno','Text',3,24,NULL,NULL,NULL,9,4,NULL,'2025-05-09 12:36:44','2025-05-09 12:36:44',0),(3,1,1,1,0,0,0,0,'Apellido Materno','Apellido Materno','Text',3,30,NULL,NULL,NULL,3,4,NULL,'2025-05-09 12:36:44','2025-05-09 12:36:44',0),(4,1,1,1,0,1,0,1,'RFC','RFC','Text',12,13,NULL,NULL,NULL,4,4,NULL,'2025-05-09 12:36:44','2025-05-09 12:36:44',0),(5,1,1,1,0,0,0,0,'Celular','Celular','Number',10,10,NULL,NULL,NULL,5,4,NULL,'2025-05-09 12:36:44','2025-05-09 12:36:44',0),(6,1,1,1,0,0,0,0,'Email','Correo electrónico','Text',NULL,NULL,NULL,NULL,NULL,6,4,NULL,'2025-05-09 12:36:44','2025-05-09 12:36:44',0);

--
-- Table structure for table `files`
--

CREATE TABLE `files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `files`
--


--
-- Table structure for table `group_fields`
--

CREATE TABLE `group_fields` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `step_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int 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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `group_fields`
--

INSERT INTO `group_fields` VALUES (1,1,1,'Datos Generales','Datos Generales',1,NULL,'2025-05-09 09:43:24','2025-05-09 09:43:24'),(2,1,1,'Domicilio','Domicilio',2,NULL,'2025-05-09 11:04:45','2025-05-09 11:04:45');

--
-- Table structure for table `holidays`
--

CREATE TABLE `holidays` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int NOT NULL,
  `user_id` int NOT NULL,
  `authorizing_user` int DEFAULT NULL,
  `days_requested` int NOT NULL DEFAULT '0',
  `days_approved` int NOT NULL DEFAULT '0',
  `days_granted` int NOT NULL DEFAULT '0',
  `date_request` date DEFAULT NULL,
  `date_approved` date DEFAULT NULL,
  `date_start` date DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `year` int DEFAULT NULL,
  `comments_requested` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comments_approved` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comments_rejected` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Aprobado','Pendiente','Finalizado','En ejecución','Rechazado') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pendiente',
  `deleted_at` timestamp NULL DEFAULT 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 `holidays`
--


--
-- Table structure for table `holidays_config`
--

CREATE TABLE `holidays_config` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `years` int NOT NULL,
  `days` int 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 `holidays_config`
--


--
-- Table structure for table `inventory_active_files`
--

CREATE TABLE `inventory_active_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `inventory_active_id` int NOT NULL,
  `file_id` int 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 `inventory_active_files`
--


--
-- Table structure for table `inventory_actives`
--

CREATE TABLE `inventory_actives` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `office_id` int NOT NULL,
  `assigned_id` int DEFAULT NULL,
  `inventory_category_id` int NOT NULL,
  `inventory_projects_id` bigint unsigned NOT NULL,
  `brand` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serial_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `barcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upcoming_maintenance` date DEFAULT NULL,
  `responsive` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Activo','Inactivo') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Activo',
  `frequency` enum('Unico','Diario','Semanal','Mensual','Anual') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` enum('Básico','Intermedio','Avanzado') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Básico',
  `reason_for_delete` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `evidence_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_deleting` int DEFAULT NULL,
  `user_authorizing` int DEFAULT NULL,
  `is_authorized` tinyint(1) 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventory_actives`
--


--
-- Table structure for table `inventory_categories`
--

CREATE TABLE `inventory_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventory_categories`
--


--
-- Table structure for table `inventory_categories_extra`
--

CREATE TABLE `inventory_categories_extra` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `inventory_category_id` int NOT NULL,
  `field_name` varchar(255) COLLATE utf8mb4_unicode_ci 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventory_categories_extra`
--


--
-- Table structure for table `inventory_inactive_files`
--

CREATE TABLE `inventory_inactive_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `inventory_active_id` int NOT NULL,
  `file_id` int 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 `inventory_inactive_files`
--


--
-- Table structure for table `inventory_projects`
--

CREATE TABLE `inventory_projects` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_id` bigint 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventory_projects`
--


--
-- Table structure for table `inventory_providers`
--

CREATE TABLE `inventory_providers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventory_providers`
--


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

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `objective` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scholarship` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `experience` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `technical_skills` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `social_skills` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `minimum_salary` decimal(8,2) DEFAULT NULL,
  `maximum_salary` decimal(8,2) DEFAULT NULL,
  `job_functions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `rank` enum('A','B','C','D','E','F','G','H') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `company_id` int NOT NULL DEFAULT '1',
  `direct_boss` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `jobs` VALUES (1,NULL,NULL,'Vicepresidente','Vicepresidente','Asegurar la correcta operación de los procesos operativos y administrativos dentro de la organización, así como fomentar el crecimiento organizado de la compañía.','Licenciatura concluida','Coordinador / Gerente de Operaciones		1 año','Manejo de equipo de cómputo				\r\nManejo de Microsoft Office			\r\nElaboración de reportes de actividades','Comunicación efectiva (oral y escrita)				\r\nCapacidad de sintésis			\r\nOrientación a objetivos				\r\nAdministración de talento			\r\nTrabajo en equipo				\r\nResolución de conflictos',36000.00,50000.00,'1) Supervisión del proyecto\r\n   - Establecimiento de metas e indicadores de proceso\r\n   - Definición y asignación de recursos necesarios\r\n   - Atención de necesidades del personal a su cargo\r\n   - Revisar reportes del proyecto\r\n   - Detección y atención de proyectos de mejora\r\n   - Detectar y atender las necesidades de capacitación de su personal a cargo\r\n\r\n2) Entrega de reportes\r\n   - Comunicar las necesidades de recursos y mejoras en el proyecto\r\n   - Reportar los resultados del proyecto así como los planes de acción\r\n  \r\n3) Atención del cliente\r\n   - Obtener los requerimientos del cliente y comunicarlos dentro de la organización\r\n   - Asegurar que se cumplan los requerimientos del cliente y que cualquier cambio sea notificado\r\n   - Mantener comunicación con el cliente, detectar y atender sus necesidades\r\n   - Detecatr y atender oportunidades de mejora','A','test',NULL,1,NULL),(2,NULL,NULL,'Intern','Intern','Etiquetar, escanear y empacar los expedientes para entrega a Guardavalores.','Bachillerato concluido, trunco o en proceso','Elaboración de reportes				1 año','Manejo de equipo de cómputo			\r\nElaboración de reportes de actividades','Trabajo en Equipo				\r\nCapacidad de Organización			\r\nCapacidad de aprendizaje				\r\nProactiva/iniciativa',3500.00,6000.00,'. Recepción de expedientes\r\n- Revisar que el expediente venga completo\r\n- Colocar etiquetas \"U\" a los documentos que integran el expediente\r\n- Colocar documentos en folder\r\n- Colocar etiquetas \"T\" a cada uno de los folders\r\n- Colocar folders en caja colectiva\r\n- Colocar etiqueta \"G\" a la caja colectiva\r\n- Elaborar reporte de expedientes empacados\r\n- Entregar expedientes a Guardavalores','B','test',NULL,1,NULL),(3,NULL,NULL,'Asesor de archivo Sr.','Asesor de archivo Sr.','Coordinar las actividades que se llevan a cabo en archivo, así como asegurar la entrega correcta y oportuna de los expedientes.','Bachillerato concluido','Manejo de personal				        1 año						\r\nSupervisor / Coordinador de proyectos	1 año						\r\nGeneración de reportes				1 año						\r\nAtención a clientes				        1 año','Manejo básico / intermedio de Microsoft Office				\r\nElaboración de reportes			\r\nManejo de equipo de cómputo','Escucha activa				\r\nToma de decisiones			\r\nLiderazgo con visión a futuro				\r\nComunicación efectiva (oral y escrita)			\r\nTrabajo en equipo',6500.00,8500.00,'- Gestionar las actividades para la recolección de los expedientes						\r\n- Supervisar la entrega en tiempo oportuno						\r\n- Asegurar el cumplimiento a los requisitos del cliente para la entrega de expedientes						\r\n- Entregar reportes de operación						\r\n- Capacitar al personal que estará a su cargo						\r\n- Reportar el % de rezago y dar seguimiento para su atención oportuna						\r\n- Asegurar que se tengan los insumos necesarios para la operación del proceso						\r\n- Generar guía para entrega de expedientes						\r\n- Recepción de expedientes						\r\n- Revisión de documentos						\r\n- Seguimiento a expedientes rezagados						\r\n- Capturar los expedientes que ingresan						\r\n- Entrega de expedientes completos a Guardavalores						\r\n- Generar reporte de expedientes aprobados						\r\n- Entregar reporte al Coordinador de Calidad						\r\n- Asegurar el abasto de insumos necesarios (etiquetas, cajas, folders, escaner, etc.)','C','test',NULL,1,129),(4,NULL,'2022-12-27 18:34:34','Asesor de credito','Asesor de credito','<p>Iniciar y dar seguimiento al proceso de otorgamiento de créditos a los usuarios que lo soliciten.</p>','<p>Bachillerato concluido, trunco o en proceso</p>','<p>Atención al cliente	1 año</p>','<p>Manejo de equipo de cómputo				<br>Manejo de Microsoft Office			<br>Elaboración de reportes de actividades</p>','<p>Iniciativa / Proactivo				<br>Aprendizaje			<br>Tolerancia				<br>Trabajo bajo presión			<br>Trato amable				<br>Gestión del tiempo</p>',6000.00,6000.00,'<p>Proporcionar información a usuarios.<br>Dar seguimiento al proceso de otorgamiento de créditos.<br>Enviar reportes de originación.<br>Enviar expedientes al área de archivo.<br>Atender quejas de los clientes y reportarlas al Coordinador de zona.<br>Atender las necesidades reportadas por los Gerentes de CESI.<br>Notificar cualquier necesidad de recursos o mantenimiento.</p>','B','Operaciones',NULL,1,NULL),(5,NULL,NULL,'Verificador de expedientes','Verificador de expedientes','Asegurar el correcto uso de las claves de usuario para la formalización de un crédito en sistema','Bachillerato concluido','Captura de información				6 meses	\r\nGeneración de reportes				6 meses','Manejo de equipo de cómputo				\r\nManejo de Microsoft Office			\r\nElaboración de reporte de actividades','Iniciativa/Proactivo				\r\nDinámica			\r\nAprendizaje',6000.00,8500.00,'- Solicitar al Gerente de Zona los créditos capturados en sistema.\r\n- Ingresar a la base de datos para verificar la hora en que fueron dados de alta los créditos\r\n- Validar las altas que estén fuera de horario\r\n- Reportar las altas que fueron generadas fuera de horario\r\n- Realizar reporte de validación\r\n- Dar seguimiento hasta el cierre del reporte de desviación','A','test',NULL,1,NULL),(6,NULL,NULL,'Asistente de operación','Asistente de operación','Asegurar la operación del proceso de originación en cuestión de insumos, servicios y herramientas necesarias para llevar a cabo el proceso de originación de créditos MEJORAVIT.','Bachillerato terminado','Labores administrativas           1 año','Manejo básico / intermedio de Microsoft Office				\r\nManejo de equio de cómputo			\r\nManejo de personal','Escucha activa				\r\nToma de decisiones			\r\nCapacidad de aprendizaje				\r\nComunicación efectiva (oral y escrita)			\r\nLiderazgo con visión a futuro				\r\nSolución de problemas 			\r\nTrabajo en equipo							\r\nCapacidad de organización',6000.00,8500.00,'Reporte de asistencias e incidencias de los asesores\r\nSeguimiento de facturas\r\nControl de inventarios (playeras, papeleria y tarjetas)\r\nConfirmar la asistencia del asesor\r\n Asegurar que el asesor cuente con las herramientas necesarias para la ejecución de su trabajo\r\nCoordinación de guias para envío de tarjetas y recolección de expedientes','B','test',NULL,1,NULL),(7,NULL,NULL,'Asesor Call center Reestructura','Asesor Call center Reestructura','Localizar y promocionar el programa de reestructura a los derechohabientes que apliquen.','Escucha activa				\r\nTrato amable			\r\nCapacidad de aprendizaje				\r\nProactiva/iniciativa			\r\nFacilidad de palabra 				\r\nComunicación efectiva','Ventas/ Atención al cliente    1año','Manejo de equipo de cómputo				\r\nManejo de office 			\r\nElaboración de reportes de actividades','Escucha activa				\r\nTrato amable			\r\nCapacidad de aprendizaje				\r\nProactiva/iniciativa			\r\nFacilidad de palabra 				\r\nComunicación efectiva',6000.00,8000.00,'- Recepción de llamadas\r\n- Atención a llamadas\r\n- Reportar quejas a coordinador de calidad \r\nDar información respecto al programa de reestructura\r\n- Seguimiento para la entrega de documentación original\r\n- Integración de expedientes \r\n- Colocar el programa de reestructura \r\n- Reporte de llamadas y estatus de las mismas','C','test',NULL,1,NULL),(9,NULL,NULL,'Verificador de clabes interbancarias','Verificador de clabes interbancarias','Verificar las clabes interbancarias de los derechohabientes para disminuir la probabilidad de robo de identidad durante el proceso de originación del crédito.','Bachillerato concluido','Captura de información			6 meses	\r\nMovimientos interbancarios		6 meses','Manejo de equipo de cómputo				Manejo de Microsoft Office			\r\nElaboración de reportes de actividades','Iniciativa / Proactivo				\r\nDinámica			\r\nGestión del tiempo							\r\nAprendizaje',6000.00,8500.00,'Solicitar al Coordinador de Zona el reporte de créditos generados\r\nRealizar transferencias bancarias para conciliaciar la veracidad de la información\r\nValidar información del derechohabiente\r\nReportar diferencias en información\r\nRealizar reporte de validación\r\nDar seguimiento hasta el cierre del reporte de desviación','A','test',NULL,1,NULL),(10,NULL,NULL,'Gerente de operaciones','Gerente de operaciones','Coordinar y apoyar al personal a su cargo en el seguimiento al proceso de otorgamiento de créditos, así como proporcionar los recursos necesarios para asegurar la correcta operación del proceso.','Licenciatura concluida','Coordinador / Gerente de Operaciones				1 año','Manejo de equipo de cómputo				\r\nManejo de Microsoft Office			\r\nElaboración de reportes de actividades','Comunicación efectiva (oral y escrita)				\r\nCapacidad de sintésis			\r\nOrientación a objetivos				\r\nAdministración de talento			\r\nTrabajo en equipo				\r\nResolución de conflictos',20000.00,35000.00,'1) Coordinación de actividades con Coordinadores de zona.							\r\n   - Definición de zonas por Coordinador de Operación							\r\n   - Supervisión de actividades							\r\n   - Revisión de reportes							\r\n   - Determinación de proyectos de mejora							\r\n   - Atención a las necesidades de recursos							\r\n							\r\n2) Atención a clientes							\r\n   - Seguimiento a necesidades del cliente							\r\n   - Coordinar la evaluación de satisfacción con el cliente y usuarios							\r\n   - Detección y atención de necesidades							\r\n							\r\n3) Entrega de reportes							\r\n   - Elaboración de reportes de proyecto							\r\n   - Asegurar el cumplimiento a los indicadores de desempeño y metas del cliente','B','test',NULL,1,129),(11,NULL,NULL,'Call center atención a clientes','Call center atención a clientes','Realizar encuestas de satisfacción, dar seguimiento a créditos otorgados, recibir y direccionar quejas.','Bachillerato concluido, trunco o en proceso','Atención a clientes     1 año','Manejo de equipo de cómputo			\r\nElaboración de reportes de actividades','Escucha activa				\r\nTrato amable			\r\nCapacidad de aprendizaje				\r\nProactiva/iniciativa',6000.00,8000.00,'- Recepción de llamadas\r\n- Atención a llamadas\r\n- Reportar quejas a Coordinador de Zona\r\n- Realización de encuestas de satisfacción\r\n- Realizar reporte de encuestas\r\n- Entregar reporte de encuestas al coordinador de calidad','C','test',NULL,1,NULL),(12,NULL,NULL,'Coordinadora de zona','Coordinadora de zona','Supervisar las actividades que llevan a cabo los asesores durante el proceso de otorgamiento de créditos  de MEJORAVIT.','Licenciatura concluida o trunca','Supervisor de operaciones		        1 año	\r\nAtención al cliente				1 año','Manejo intermedio de Microsoft Office				\r\nManejo de equipo de cómputo			\r\nElaboración de reportes de actividades','Trabajo en equipo				\r\nCapacidad de negociación			\r\nResolución de conflictos				\r\nProactivo			\r\nToma de decisiones				\r\nComunicación efectiva',15000.00,18000.00,'1) Supervisión de las actividades del asesor\r\n   - Asesorar y capacitar al personal en la resolución de dudas\r\n   - Notificar las necesidades de capacitación del personal a cargo\r\n   - Asegurar que los sitios a cargo cuenten con el personal suficiente para la operación\r\n   - Solicitar la baja y reposición de personal cuando sea aplicable\r\n\r\n2) Reportes de producción\r\n   - Solicitar y revisar los reportes diarios de productividad\r\n   - Entregar los reportes de productividad de su personal a cargo\r\n   - Asegurar el cumplimiento de los objetivos del cliente y de Tobb\r\n\r\n3) Monitoreo del servicio\r\n   - Mantener comunicación constante con los Gerentes de CESI para retroalimentación del servicio\r\n   - Atender las quejas y comentarios recibidas por parte de los usuarios o del cliente','D','test',NULL,1,NULL),(13,NULL,NULL,'Coordinador de contabilidad','Coordinador de contabilidad','Monitoreo y control de los gastos generados a partir de la originación, así como el cálculo y análisis de la rentabilidad de cada centro.','Licenciatura concluida en contabilidad, finanzas o a fin','Cálculo de gastos 				1 año					\r\nControl de facturas		        1 año						\r\nDesarrollo de formatos 		1 año','Manejo  intermedio de Microsoft Office				\r\nManejo de facturas 			\r\nManejo de equio de cómputo','Resolución de problemas 				\r\nToma de decisiones			\r\nCapacidad de aprendizaje				\r\nComunicación efectiva (oral y escrita)			\r\nLiderazgo con visión a futuro				\r\nOrganización 			\r\nTrabajo en equipo							\r\nCapacidad de organización',14000.00,18000.00,'- Control de facturación y pago a proveedores\r\n- Cálculo del pago a proveedores\r\n- Cálculo de la rentabilidad por centro \r\n- Cálculo de los gastos mensuales \r\n- Pago de facturas','A','test',NULL,1,NULL),(14,NULL,NULL,'Coordinador de auditorías','Coordinador de auditorías','Asegurar el correcto funcionamiento y retroalimentación del Sistema de Gestión de Calidad','Licenciatura trunca o terminada','Administración de proyectos 				1 año','Manejo básico / intermedio de Microsoft Office				\r\nManejo de equio de cómputo			\r\nManejo de personal','Escucha activa				\r\nToma de decisiones			\r\nCapacidad de aprendizaje				\r\nComunicación efectiva (oral y escrita)			\r\nLiderazgo con visión a futuro				\r\nOrganización 			\r\nTrabajo en equipo							\r\nCapacidad de organización',11000.00,17000.00,'-Implementación y mantenimiento del SGC\r\n- Coordinar la capacitación del personal en la Norma ISO 9001: 2015\r\n- Documentar los procesos que integran el Sistema de Gestión de  Calidad\r\n- Actualizar la planeación estratégica para alcanzar los objetivos del siguiente año\r\n- Notificar los cambios en procedimientos\r\n- Definición y seguimiento a medición de indicadores\r\n- Seguimiento a indicadores de desempeño\r\n- Programación, actualización y ejecución de auditorías\r\n- Seguimiento a acciones correctivas con responsables de cada área\r\n- Seguimiento a producto no conforme\r\n- Seguimiento a bitácora de quejas y cierre de las mismas.\r\n- Capacitación y desarrollo de auditores internos\r\n- Detección y atención a oportunidades de mejora\r\n- Asegurar que las actualizaciones del sistema se mantengan alineados a los requisitos normativos\r\n- Asegurar el mantenimiento de la certificación ISO 9001 :2015','B','test',NULL,1,NULL),(15,NULL,NULL,'Director General','Director General','Garantizar la eficiencia operativa de la empresa procurando el crecimiento de la misma.','Licenciatura concluida (preferentemente administración de negocios / Economía o a fin)','Operaciones		Coordinador / Director de Operaciones				1 año','Manejo de equipo de cómputo				\r\nManejo de Microsoft Office			\r\nElaboración de presupuestos				\r\nLectura y comprensión de estados financieros			\r\nDesarrollo de planes de negocio','Comunicación efectiva (oral y escrita)				Liderazgo			\r\nOrientación a objetivos				\r\nAdministración de talento			\r\nMotivación al logro				\r\nInfluencia positiva			\r\nTrabajo en equipo				\r\nGestión de relaciones',50000.00,70000.00,'- Gestionar las actividades de la organización.\r\n   - Determinar los objetivos de la organización.\r\n   - Asignar y controlar el presupuesto.\r\n   - Asegurar la rentabilidad del negocio.\r\n   -  Establecer critérios para la toma de decisiones y resolución de conflictos.\r\n   - Determinar y difundir la misión y la visión al personal en general\r\n   - Proporcionar los recursos necesarios para la operación de la empresa\r\n   - Administrar la correcta distribución de recursos.\r\n   - Delegar autoridad en caso de ser necesario.\r\n   -  Monitorear los gastos.\r\n   -  Realizar un análisis de rentabilidad.\r\n   - Promover la mejora continua.\r\n   - Fomentar el uso del Sistema de Gestión de Calidad\r\n   - Definir estrategias para el crecimiento de la compañía\r\n   - Identificar y buscar nuevos negocios\r\n   - Mantener una buena relación comercial con los clientes actuales y potenciales','C','test',NULL,1,NULL),(16,NULL,NULL,'Coordinador de prevención de fraudes','Coordinador de prevención de fraudes','','','','','',15000.00,17000.00,'','D','test',NULL,1,NULL);

--
-- Table structure for table `labels`
--

CREATE TABLE `labels` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int NOT NULL,
  `user_id` int NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('payment','event','todo') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'payment',
  `color` varchar(255) COLLATE utf8mb4_unicode_ci 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 `labels`
--

INSERT INTO `labels` VALUES (1,1,1,'KASAI','payment',NULL,'2025-05-07 07:13:22','2025-05-07 07:13:22');

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `company_id` int NOT NULL,
  `module_id` int DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `logs`
--

INSERT INTO `logs` VALUES (1,1,1,12,'Inició sesión en la organización Tobb','2025-05-07 09:38:35','2025-05-07 09:38:35'),(2,1,1,12,'Inició sesión en la organización Tobb','2025-05-07 09:56:23','2025-05-07 09:56:23'),(3,1,1,1,'Editó los datos de la organización Tobb Cobranza','2025-05-07 09:58:26','2025-05-07 09:58:26'),(4,1,1,12,'Inició sesión en la organización Tobb Cobranza','2025-05-09 09:21:25','2025-05-09 09:21:25'),(5,1,1,25,'Editó los datos del step: Validacion de Cuenta','2025-05-09 09:22:55','2025-05-09 09:22:55'),(6,1,1,25,'Editó los datos del step: Captura de la información','2025-05-09 09:24:02','2025-05-09 09:24:02'),(7,1,1,25,'Editó los datos del step: Formalizacion','2025-05-09 09:25:39','2025-05-09 09:25:39'),(8,1,1,25,'Editó los datos del step: Formalizacion','2025-05-09 09:26:08','2025-05-09 09:26:08'),(9,1,1,25,'Editó los datos del step: Proceso de Cobranza','2025-05-09 09:26:25','2025-05-09 09:26:25'),(10,1,1,25,'Editó los datos del step: Solicitudes Cobradas','2025-05-09 09:26:43','2025-05-09 09:26:43'),(11,1,1,25,'Editó los datos del step: Validacion de Cuenta','2025-05-09 09:27:17','2025-05-09 09:27:17'),(12,1,1,25,'Editó los datos del step: Validacion de Formalizacion','2025-05-09 09:27:37','2025-05-09 09:27:37'),(13,1,1,25,'Editó los datos del step: Formalizacion','2025-05-09 09:27:52','2025-05-09 09:27:52'),(14,1,1,25,'Editó los datos del step: Proceso de Cobranza','2025-05-09 09:28:00','2025-05-09 09:28:00'),(15,1,1,25,'Editó los datos del step: Proceso de Cobranza','2025-05-09 09:28:16','2025-05-09 09:28:16'),(16,1,1,12,'Inició sesión en la organización Tobb Cobranza','2025-05-09 10:49:16','2025-05-09 10:49:16'),(17,1,1,NULL,'Editó los datos del producto: Originacion cobranza','2025-05-09 10:52:15','2025-05-09 10:52:15'),(18,1,1,25,'Editó los datos del step: Captura de la información','2025-05-09 12:36:44','2025-05-09 12:36:44');

--
-- Table structure for table `maintenances`
--

CREATE TABLE `maintenances` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `inventory_active_id` int NOT NULL,
  `date` date DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cost` decimal(8,2) unsigned DEFAULT NULL,
  `provider_id` int 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 `maintenances`
--


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

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

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

INSERT INTO `migrations` VALUES (1,'2014_10_11_000000_create_roles_table',1),(2,'2014_10_11_000001_create_company_table',1),(3,'2014_10_12_000000_create_users_table',1),(4,'2014_10_12_100000_create_password_resets_table',1),(5,'2019_08_19_000000_create_failed_jobs_table',1),(6,'2019_12_14_000001_create_personal_access_tokens_table',1),(7,'2022_05_11_154355_create_offices_table',1),(8,'2022_05_11_163331_create_jobs_table',1),(9,'2022_05_11_163842_create_states_table',1),(10,'2022_05_11_163850_create_banks_table',1),(11,'2022_05_11_164255_create_schedules_table',1),(12,'2022_05_11_165327_create_unsubscribed_users_table',1),(13,'2022_05_11_172528_create_modules_table',1),(14,'2022_05_11_172836_create_actions_table',1),(15,'2022_05_11_173507_create_permissions_table',1),(16,'2022_05_11_174358_create_user_info_table',1),(17,'2022_05_23_214519_create_provider_enterprise_table',1),(18,'2022_05_23_220211_create_provider_category_table',1),(19,'2022_05_23_220212_create_provider_table',1),(20,'2022_05_23_234748_create_provider_file_table',1),(21,'2022_08_01_222445_create_user_company_table',1),(22,'2022_09_15_220756_add_company_id_to_roles',1),(23,'2022_09_15_221217_add_last_company_id_to_users',1),(24,'2022_09_19_220947_add_role_id_column_to_user_company',1),(25,'2022_09_21_154622_create_user_role_company_table',1),(26,'2022_09_28_215925_add_direct_boss_to_jobs',1),(27,'2022_10_07_154925_create_documents_table',1),(28,'2022_10_07_155251_create_user_documents_table',1),(29,'2022_10_14_002345_add_job_id_to_user_role_company',1),(30,'2022_10_24_161330_add_delete_to_user_role_company',1),(31,'2022_10_24_175148_create_logs_table',1),(32,'2022_11_14_145623_create_employee_growth_table',1),(33,'2022_11_15_233641_add_job_type_to_user_role_company',1),(34,'2022_11_15_234328_add_company_id_to_schedules',1),(35,'2022_11_23_213204_add_fields_to_user_info',1),(36,'2022_11_24_191232_create_user_info_temp_table',1),(37,'2022_12_05_223546_create_notifications_table',1),(38,'2023_01_16_165723_create_labels_table',1),(39,'2023_01_16_170350_create_payments_table',1),(40,'2023_01_16_171748_create_payment_files_table',1),(41,'2023_02_15_145811_create_inventory_categories_table',1),(42,'2023_02_15_150050_create_inventory_categories_extra_table',1),(43,'2023_03_08_060922_create_inventory_providers_table',1),(44,'2023_03_08_064028_create_inventory_actives_table',1),(45,'2023_03_23_222821_create_maintenances_table',1),(46,'2023_04_10_113938_create_holidays_table',1),(47,'2023_04_10_115826_create_holidays_config_table',1),(48,'2023_05_01_154531_create_absences_table',1),(49,'2023_05_01_155852_create_paysheet_reports_table',1),(50,'2023_05_02_043807_create_paysheet_reports_detail_table',1),(51,'2023_05_02_044238_create_discount_table',1),(52,'2023_05_02_182655_add_monthly_salary_to_user_info',1),(53,'2023_05_22_155102_add_monthly_salary_to_user_role_company',1),(54,'2023_05_22_155112_add_salary_to_user_role_company',1),(55,'2023_05_25_161940_create_user_relationships_table',1),(56,'2023_05_29_171105_create_capacitation_table',1),(57,'2023_05_29_172718_create_capacitation_jobs_table',1),(58,'2023_05_29_172835_create_capacitation_users_table',1),(59,'2023_05_29_172846_create_capacitation_files_table',1),(60,'2023_06_02_151336_create_files_table',1),(61,'2023_06_02_151340_create_inventory_active_files_table',1),(62,'2023_06_06_035914_create_drive_table',1),(63,'2023_06_19_192504_add_file_id_to_payment_files',1),(64,'2023_06_30_010749_add_status_to_payments',1),(65,'2023_07_03_164154_add_direct_boss_to_payments',1),(66,'2023_07_12_030543_create_inventory_projects_table',1),(67,'2023_07_18_035825_add_company_to_inventory_project',1),(68,'2023_07_19_054148_add_inventory_project_to_inventory_actives',1),(69,'2023_07_26_040409_create_provider_questions_table',1),(70,'2023_08_01_230141_create_inventory_inactves_files_table',1),(71,'2023_08_07_223906_create_providers_evaluation',1),(72,'2023_08_23_181855_create_advertisements_table',1),(73,'2023_08_23_182948_create_advertisements_jobs_table',1),(74,'2023_08_23_183003_create_advertisements_files_table',1),(75,'2023_08_25_034141_create_tags_table',1),(76,'2023_09_06_030206_create_tasks_table',1),(77,'2023_09_06_034507_create_tags_tasks_table',1),(78,'2023_09_11_184220_add_user_id_to_advertisements',1),(79,'2023_09_14_043143_add_process_to_tasks_table',1),(80,'2023_09_15_023813_create_events_table',1),(81,'2023_09_15_025426_create_event_users_table',1),(82,'2024_01_11_185411_create_products_table',1),(83,'2024_01_11_205029_create_step_bases_table',1),(84,'2024_01_11_210052_create_steps_table',1),(85,'2024_01_12_014924_create_field_bases_table',1),(86,'2024_01_12_025445_create_group_fields_table',1),(87,'2024_01_12_030033_create_fields_table',1),(88,'2024_01_12_033034_create_step_role_table',1),(89,'2024_01_12_193121_create_document_bases_table',1),(90,'2024_01_15_061629_create_credit_table',1),(91,'2024_01_17_170132_create_step_documents_table',1),(92,'2024_01_19_041555_create_credit_history_table',1),(93,'2024_01_30_155854_add_read_only_to_step_documents',1),(94,'2024_01_31_170409_add_fields_to_user_info',1),(95,'2024_01_31_181049_add_saveable_to_steps',1),(96,'2024_02_01_041339_add_unique_to_fields',1),(97,'2024_02_08_172651_add_deleted_status_to_credits_table',1),(98,'2024_02_12_040605_create_credit_users_table',1),(99,'2024_02_16_030559_add_pdf_view_to_products',1),(100,'2024_02_29_010937_add_post_history_number_to_credit_history',1),(101,'2024_04_29_111024_add_in_record_to_step_documents',1),(102,'2024_07_08_140223_add_product_id_to_credits',1);

--
-- Table structure for table `modules`
--

CREATE TABLE `modules` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` int NOT NULL DEFAULT '0',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` VALUES (1,NULL,NULL,'company','Empresas',11,'',1,'',NULL),(2,NULL,NULL,'role','Roles y permisos',11,'',2,'',NULL),(3,NULL,NULL,'dashboard','Dashboard',0,'',1,'',NULL),(4,NULL,NULL,'job','Perfiles',11,'',2,'',NULL),(5,NULL,NULL,'document','Documentos',11,'',3,'',NULL),(6,NULL,NULL,'ad','Anuncios',11,'',4,'',NULL),(7,NULL,NULL,'evaluation-question-employees','Preguntas de evaluación (Empleados)',11,'',5,'','2024-01-11 00:00:00'),(8,NULL,NULL,'provider-crud','Proveedores (CRUD)',11,'',6,'','2024-01-11 00:00:00'),(9,NULL,NULL,'evaluation-question-providers','Preguntas de evaluación (Proveedor)',11,'',7,'','2024-01-11 00:00:00'),(10,NULL,NULL,'inventory-category-crud','CRUD Categorías(Inventario)',11,'',8,'','2024-01-11 00:00:00'),(11,NULL,NULL,'config','Configuración',0,'',2,'',NULL),(12,NULL,NULL,'employee','Usuarios',0,'',0,'',NULL),(13,NULL,NULL,'prenominate','Prenómina',0,'',0,'','2024-01-11 00:00:00'),(14,NULL,NULL,'training','Capacitación',0,'',0,'','2024-01-11 00:00:00'),(15,NULL,NULL,'holiday','Vacaciones',0,'',0,'','2024-01-11 00:00:00'),(16,NULL,NULL,'provider','Proveedores',0,'',0,'','2024-01-11 00:00:00'),(17,NULL,NULL,'payment','Pagos',0,'',0,'','2024-01-11 00:00:00'),(18,NULL,NULL,'inventory','Recursos materiales',0,'',0,'','2024-01-11 00:00:00'),(19,NULL,NULL,'certification','Certificaciones',0,'',0,'','2024-01-11 00:00:00'),(20,NULL,NULL,'todo','Tareas',0,'',0,'',NULL),(21,NULL,NULL,'calendar','Calendario',0,'',0,'','2024-01-11 00:00:00'),(22,NULL,NULL,'office','Oficinas',0,'',0,'',NULL),(23,NULL,NULL,'log','Log de movimientos',0,'',0,'',NULL),(24,NULL,NULL,'inventory-provider-crud','CRUD Proveedores(Inventario)',11,'',8,'','2024-01-11 00:00:00'),(25,NULL,NULL,'products','Productos',11,'',8,'',NULL),(26,NULL,NULL,'credit-request','Trámites',0,'1',9,'',NULL);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int NOT NULL,
  `user_from_id` int NOT NULL,
  `user_to_id` int NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('new','read','deleted') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'new',
  `data` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `offices`
--

CREATE TABLE `offices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_id` int DEFAULT NULL,
  `street` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `suburb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `outside_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inside_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `municipality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `offices`
--

INSERT INTO `offices` VALUES (1,NULL,'2023-02-15 15:40:20','Vallejos',14,'Infonavit 909 E.N 45. Pte 134 num 631, Colonia Industrial Vallejo Azcapotzalco C.P. 02300','Colonia Industrial','6135','34','34','Azcapotzalco','02300',1,NULL),(2,NULL,NULL,'Cuautitlan',14,'Autopista México-Qro, Plaza San Marcos num. E','Jardines de la Hacienda Sur','E','',NULL,'Cuautitlan Izcalli','54726',1,NULL),(3,NULL,NULL,'Ermita',14,'Calz. Ermita Iztapalapa','Sta Isabel Industrial','927','',NULL,'Iztapalapa','09820',1,NULL),(4,NULL,NULL,'CTM',14,'Ignacio L. Vallarta','Tabacalera','8','',NULL,'Cuahutemoc','06030',1,NULL),(5,NULL,NULL,'Ermita',14,'Calz. Ermita Iztapalapa','Sta Isabel Industrial','927','',NULL,'Iztapalapa','09820',1,NULL),(6,NULL,NULL,'Tlalnepantla',14,'Av. Presidente Juárez','Industrial Puente de Vigas','2034','',NULL,'Tlalnepantla','54070',1,NULL),(7,NULL,NULL,'Barranca de Muerto',14,'Av. Barranca del Muerto','Guadalupe Inn','280','',NULL,'Alvaro Obregon','01029',1,NULL),(8,NULL,NULL,'La Viga',14,'Calz. de la Viga','Jamaica','398','',NULL,'Venustiano Carranza','15800',1,NULL),(9,NULL,NULL,'Tepic',17,'Av. Insurgentes Pte. Plaza Fiesta Tepic','Fracc Las Brisas Tepic Nayarit','S/N','',NULL,'Tepic','63117',1,NULL),(10,NULL,NULL,'Nuevo Vallarta',17,'Av. Los Tules Plaza Local 14-17','Fracc Los Tules Puerto Valalrta','179','14-17',NULL,'Puerto Vallarta','48310',1,NULL),(11,NULL,NULL,'Celaya',10,'Eje Norponiente (Avenida Araucarias)','Fracc Villas de la Hacienda','1013','',NULL,'Celaya','38088',1,NULL),(12,NULL,NULL,'Irapuato',10,'Av. Murano num. 151','Ejido','151','',NULL,'Irapuato','37200',1,NULL),(13,NULL,NULL,'Leon',10,'Blvd. Juan Alonso de Torres','San José del Consuelo','1315','',NULL,'León','37200',1,NULL),(14,NULL,NULL,'Salamanca',10,'Av. Faja de Oro','Guadalupe','1502','',NULL,'Salamanca','36740',1,NULL),(15,NULL,NULL,'Tapachula',6,'Central Norte num. 11','5 de Febrero','11','',NULL,'Tapachula','30710',1,NULL),(16,NULL,NULL,'Tuxtla Gutierrez',6,'Blvd. Belisario Domínguez','Fracc Plaza Platino','2775','',NULL,'Tuxtla Gutierrez','29020',1,NULL),(17,NULL,NULL,'Ciudad Juaréz',7,'Av. Teófilo Borunda','Las Acequias','7387','',NULL,'Ciudad Juarez','32617',1,NULL),(18,NULL,NULL,'Chihuahua',7,'Allende num. 1500','Centro','1500','',NULL,'Chihuahua','31000',1,NULL),(19,NULL,NULL,'Parral',7,'Av. Independencia','Primavera Hidalgo','399','',NULL,'Parral','33800',1,NULL),(20,NULL,NULL,'Lazaro Cardenas',15,'Av. Melchor Ocampo','Segundo Sector de FIDELAC','31','1',NULL,'Lazaro Cardenas','60953',1,NULL),(21,NULL,NULL,'Morelia',15,'Siervo de la Nación num. 2000','Libertad','2000','',NULL,'Morelia','58170',1,NULL),(22,NULL,NULL,'Uruapan',15,'Paseo Lázaro Cárdenas','Morelos','10','',NULL,'Uruapan','60050',1,NULL),(23,NULL,NULL,'Campeche',4,'Av. Miguel Alemán','Área ah-Kim-pech','8','',NULL,'Campeche','24010',1,NULL),(24,NULL,NULL,'Ciudad del Carmen',4,'Av. Aviacion','Petrolera','245','',NULL,'Ciudad del Carmen','24179',1,NULL),(25,NULL,NULL,'Zamora',15,'Av. Prolongación Ferrocarril','Fracc La Sandovaleña','211','',NULL,'Zamora','59660',1,NULL),(26,NULL,NULL,'San Juan del Río',21,'Blvd. Miguel Hidalgo','Centro','229','',NULL,'San Juan del Río','76800',1,NULL),(27,NULL,NULL,'Querétaro',21,'Blvd. Bernardo Quintana','Balcón Campestre','4038','',NULL,'Querétaro','76159',1,NULL),(28,NULL,NULL,'Toluca',14,'Blvd. Miguel Alemán Valdés num. 4530','San Pedro Totoltepec','4530','',NULL,'Toluca','50226',1,NULL),(29,NULL,NULL,'Tlaxcala',28,'Blvd. Revolución','Atempan','56','',NULL,'Tlaxcala','90010',1,NULL),(30,NULL,NULL,'Fresnillo',31,'Av. Fco García Salinas','Centro','498','',NULL,'Fresnillo','99000',1,NULL),(31,NULL,NULL,'Tuxtepec',19,'Blvd. Benito Juárez','Los Ángeles San Juan Bautista','795','4142',NULL,'Tuxtepec','68301',1,NULL),(32,NULL,NULL,'Juchitan',19,'2 de Abril Esq. con Álvaro Obregón','Segunda Sección','s/n','',NULL,'Juchitan Zaragoza','7000',1,NULL),(33,NULL,NULL,'Huatulco',19,'Carrizal Sector H','La crucecita Santa María','603','',NULL,'Huatulco','70989',1,NULL),(34,NULL,NULL,'Oaxaca',19,'Mártires de Tacubaya','Santa María Icotel Santa Lucía del Camino','400','',NULL,'Oaxaca','68100',1,NULL),(35,NULL,NULL,'Playa del Carmen',22,'Av. Chemuyil','Toscana Solidaridad','Mza 9','',NULL,'Playa del Carmen','77725',1,NULL),(36,NULL,NULL,'Chetumal',22,'Calz. Veracruz','Barrio Bravo','63','',NULL,'Chetumal','77098',1,NULL),(37,NULL,NULL,'Cancun',22,'Av. Tulum Sur Mz. 4,5 Y 9','Super Manzana 7','217','',NULL,'Cancun','77500',1,NULL),(38,NULL,NULL,'Manzanillo',33,'Av. Manzanillo','Arboledas','133','',NULL,'Manzanillo','28869',1,NULL),(39,NULL,NULL,'Colima',33,'Av. 20 de Noviembre','Fracc. San Pablo','695','',NULL,'Colima','28063',1,NULL),(40,NULL,NULL,'RMVM',14,'-','-','-','-',NULL,'-','0',1,NULL),(41,NULL,NULL,'Jalisco',13,'Av Juan Palomar y Arias','Col. Vallarta San Jorge','37','-',NULL,'Guadalajra','44590',1,NULL);

--
-- Table structure for table `payment_files`
--

CREATE TABLE `payment_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `payment_id` int NOT NULL,
  `type` enum('Factura','Comprobante') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Factura',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `file_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_files`
--


--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int NOT NULL,
  `user_id` int NOT NULL,
  `provider_id` int DEFAULT NULL,
  `office_id` int DEFAULT NULL,
  `label_id` int NOT NULL,
  `amount` decimal(8,2) unsigned DEFAULT NULL,
  `concept` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `invoice_number` int DEFAULT NULL,
  `output_type` enum('Proveedor','Viáticos','Caja chica','Reembolsos','Prima vacacional','Bono','Nómina') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Proveedor',
  `payment_date` date DEFAULT NULL,
  `movement_date` date DEFAULT NULL,
  `year` int DEFAULT NULL,
  `month` int DEFAULT NULL,
  `fortnight` enum('1','2') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `status` enum('Pendiente','Pagado','Rechazado','Eliminado','Solicitado','Autorizado') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pendiente',
  `reason_rejection` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_payment` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `direct_boss_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments`
--


--
-- Table structure for table `paysheet_reports`
--

CREATE TABLE `paysheet_reports` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_id` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `date_start` date DEFAULT NULL,
  `date_end` date 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `paysheet_reports`
--


--
-- Table structure for table `paysheet_reports_detail`
--

CREATE TABLE `paysheet_reports_detail` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `paysheet_report_id` int NOT NULL,
  `user_id` int NOT NULL,
  `user_role_company_id` int DEFAULT NULL,
  `payment_id` int DEFAULT NULL,
  `absences` int NOT NULL DEFAULT '0',
  `discount` decimal(8,2) unsigned DEFAULT '0.00',
  `amount` decimal(8,2) unsigned DEFAULT '0.00',
  `bonus` decimal(8,2) unsigned DEFAULT '0.00',
  `refunds` decimal(8,2) unsigned DEFAULT '0.00',
  `perdiem` decimal(8,2) unsigned DEFAULT '0.00',
  `vacation` decimal(8,2) unsigned DEFAULT '0.00',
  `status` enum('Pagado','Pendiente') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pendiente',
  `deleted_at` timestamp NULL DEFAULT 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 `paysheet_reports_detail`
--


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

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int NOT NULL,
  `action_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permissions` VALUES (1,1,1,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(2,1,2,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(3,1,3,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(4,1,4,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(5,1,6,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(6,1,7,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(7,1,8,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(8,1,9,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(9,1,10,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(10,1,11,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(11,1,12,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(12,1,13,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(13,1,14,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(14,1,19,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(15,1,20,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(16,1,21,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(17,1,23,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(18,1,27,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(19,1,28,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(20,1,29,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(21,1,30,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(22,1,31,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(23,1,32,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(24,1,34,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(25,1,35,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(26,1,36,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(27,1,37,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(28,1,38,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(29,1,39,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(30,1,40,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(31,1,41,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(32,1,42,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(33,1,43,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(34,1,45,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(35,1,46,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(36,1,47,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(37,1,48,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(38,1,49,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(39,1,50,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(40,1,51,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(41,1,52,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(42,1,53,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(43,1,54,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(44,1,55,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(45,1,56,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(46,1,57,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(47,1,58,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(48,1,59,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(49,1,60,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(50,1,61,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(51,1,62,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(52,1,63,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(53,1,64,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(54,1,65,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(55,1,66,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(56,1,67,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(57,1,68,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(58,1,69,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(59,1,70,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(60,1,71,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(61,1,72,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(62,1,73,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(63,1,74,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(64,1,75,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(65,1,76,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(66,1,77,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(67,1,78,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(68,1,79,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(69,1,80,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(70,1,81,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(71,1,82,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(72,1,83,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL),(73,1,84,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(74,1,85,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(75,1,86,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(76,1,87,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(77,1,88,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(78,1,89,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(79,1,90,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(80,1,91,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(81,1,92,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(82,1,93,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(83,1,94,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(84,1,95,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(85,1,96,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(86,1,97,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(87,1,98,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(88,1,99,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(89,1,100,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(90,1,101,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(91,1,102,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(92,1,103,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(93,1,104,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(94,1,105,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(95,1,106,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(96,1,107,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(97,1,108,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(98,1,109,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(99,1,110,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(100,1,111,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(101,1,112,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(102,1,113,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(103,1,114,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(104,1,115,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(105,1,116,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(106,1,117,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(107,1,118,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(108,1,119,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(109,1,120,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(110,1,121,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(111,1,122,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(112,1,123,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(113,1,124,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(114,1,125,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(115,1,126,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(116,1,127,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(117,1,128,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(118,1,129,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(119,1,137,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(120,1,138,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(121,1,139,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(122,1,140,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(123,1,141,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(124,1,142,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(125,1,143,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(126,1,144,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(127,1,145,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(128,1,146,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(129,1,147,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(130,1,148,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(131,1,149,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(132,1,150,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(133,1,151,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(134,1,152,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(135,1,153,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(136,1,154,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(137,1,155,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(138,1,156,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(139,1,157,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(140,1,158,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(141,1,159,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(142,1,160,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(143,1,161,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(144,1,162,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(145,1,163,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(146,1,164,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(147,1,165,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(148,1,166,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(149,1,168,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(150,1,170,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(151,1,171,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(152,1,173,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(153,1,174,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(154,1,175,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(155,1,176,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(156,1,177,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(157,1,178,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(158,1,179,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(159,1,180,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(160,1,181,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(161,1,182,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL),(162,1,183,'2025-05-07 07:13:23','2025-05-07 07:13:23',NULL);

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `company_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('Cartera','Originación') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Originación',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pdf_view` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo_pdf` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `default` tinyint(1) NOT NULL DEFAULT '0',
  `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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` VALUES (1,1,1,'Originacion cobranza','Originación','Originacion cobranza','export_infonavit',NULL,1,1,NULL,'2025-05-07 11:35:38','2025-05-09 10:52:15');

--
-- Table structure for table `provider`
--

CREATE TABLE `provider` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `enterprise_id` int NOT NULL,
  `bank_id` int NOT NULL,
  `category_id` int NOT NULL,
  `company_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `clabe` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `account` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cellphone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment` enum('1','2') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `provider`
--


--
-- Table structure for table `provider_category`
--

CREATE TABLE `provider_category` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `provider_category`
--


--
-- Table structure for table `provider_enterprise`
--

CREATE TABLE `provider_enterprise` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `provider_enterprise`
--


--
-- Table structure for table `provider_evaluations`
--

CREATE TABLE `provider_evaluations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `provider_id` int NOT NULL,
  `user_id` int NOT NULL,
  `result` bigint 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `provider_evaluations`
--


--
-- Table structure for table `provider_file`
--

CREATE TABLE `provider_file` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `provider_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `provider_file`
--


--
-- Table structure for table `provider_questions`
--

CREATE TABLE `provider_questions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `orden` bigint NOT NULL,
  `categoria` enum('Entrega','Calidad','Atención') COLLATE utf8mb4_unicode_ci 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `provider_questions`
--


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

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `editable` tinyint(1) NOT NULL DEFAULT '1',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `company_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` VALUES (1,'Root','User root',0,1,'2025-05-07 07:13:22','2025-05-07 07:13:22',NULL,1);

--
-- Table structure for table `schedules`
--

CREATE TABLE `schedules` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `start` time NOT NULL,
  `end` time NOT NULL,
  `tolerance` smallint NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `company_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `schedules`
--


--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `states`
--

INSERT INTO `states` VALUES (1,'Aguascalientes'),(2,'Baja California'),(3,'Baja California Sur'),(4,'Campeche'),(5,'Coahuila de Zaragoza'),(6,'Colima'),(7,'Chiapas'),(8,'Chihuahua'),(9,'CDMX'),(10,'Durango'),(11,'Guanajuato'),(12,'Guerrero'),(13,'Hidalgo'),(14,'Jalisco'),(15,'Estado de México'),(16,'Michoacán de Ocampo'),(17,'Morelos'),(18,'Nayarit'),(19,'Nuevo León'),(20,'Oaxaca de Juárez'),(21,'Puebla'),(22,'Querétaro'),(23,'Quintana Roo'),(24,'San Luis Potosí'),(25,'Sinaloa'),(26,'Sonora'),(27,'Tabasco'),(28,'Tamaulipas'),(29,'Tlaxcala'),(30,'Veracruz de Ignacio de la Llave'),(31,'Yucatán'),(32,'Zacatecas');

--
-- Table structure for table `step_bases`
--

CREATE TABLE `step_bases` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci 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=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `step_bases`
--

INSERT INTO `step_bases` VALUES (1,'Captura de la información','Primer etapa',NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(2,'Validación interna','Validación interna de solicitud',NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(3,'Validación externa','Validación externa de solicitud',NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(4,'Confirmación de Acuse de Recepción','Confirmación de Acuse de Recepción',NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(5,'Creación de Contrato','Creación de Contrato',NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(6,'Formalización ','Formalización del crédito',NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23'),(7,'Fondeo ','Fondeo del crédito',NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23');

--
-- Table structure for table `step_documents`
--

CREATE TABLE `step_documents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `step_id` int NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('Image','PDF','Excel','Word') COLLATE utf8mb4_unicode_ci NOT NULL,
  `max_length` int DEFAULT NULL,
  `show_record` tinyint(1) NOT NULL DEFAULT '1',
  `className` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `helpText` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `read_only` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `step_documents`
--


--
-- Table structure for table `step_role`
--

CREATE TABLE `step_role` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `step_id` int NOT NULL,
  `role_id` int 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 `step_role`
--


--
-- Table structure for table `steps`
--

CREATE TABLE `steps` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `product_id` int NOT NULL,
  `step_reject_id` int DEFAULT NULL,
  `step_approve_id` int DEFAULT NULL,
  `asign_to_role` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `max_days` int DEFAULT NULL,
  `order` int DEFAULT NULL,
  `active` tinyint(1) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `saveable` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `steps`
--

INSERT INTO `steps` VALUES (1,1,1,0,2,NULL,'Captura de la información','Primer etapa',NULL,1,0,NULL,'2025-05-07 11:35:38','2025-05-09 10:56:56',1),(2,1,1,0,3,NULL,'Validacion de Cuenta','Validación interna de solicitud',NULL,2,0,NULL,'2025-05-07 11:35:38','2025-05-09 09:27:17',1),(3,1,1,0,4,NULL,'Formalizacion','Formalizacion de Tramite',NULL,3,0,NULL,'2025-05-07 11:35:38','2025-05-09 09:27:52',1),(4,1,1,0,5,NULL,'Validacion de Formalizacion','Revision de formalizacion de solicitud',NULL,4,0,NULL,'2025-05-07 11:35:38','2025-05-09 09:27:37',1),(5,1,1,0,6,NULL,'Proceso de Cobranza','Seguimiento de cobranza de la solicitud',NULL,5,0,NULL,'2025-05-07 11:35:38','2025-05-09 09:28:00',1),(6,1,1,0,0,NULL,'Solicitudes Cobradas','Historial de solicitudes cobradas',NULL,6,0,NULL,'2025-05-07 11:35:38','2025-05-09 09:26:43',1),(7,1,1,NULL,NULL,NULL,'Fondeo ','Fondeo del crédito',NULL,7,NULL,'2025-05-09 09:26:53','2025-05-07 11:35:38','2025-05-09 09:26:53',1);

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tags`
--


--
-- Table structure for table `tags_tasks`
--

CREATE TABLE `tags_tasks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tags_id` bigint unsigned NOT NULL,
  `tasks_id` bigint 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 `tags_tasks`
--


--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `creator_id` bigint unsigned NOT NULL,
  `due_date` date NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `important` tinyint(1) DEFAULT NULL,
  `trash` tinyint(1) DEFAULT NULL,
  `process` tinyint(1) DEFAULT NULL,
  `completed` tinyint(1) 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tasks`
--


--
-- Table structure for table `unsubscribed_users`
--

CREATE TABLE `unsubscribed_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `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 `unsubscribed_users`
--


--
-- Table structure for table `user_company`
--

CREATE TABLE `user_company` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int NOT NULL,
  `user_id` int NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `role_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_company`
--


--
-- Table structure for table `user_documents`
--

CREATE TABLE `user_documents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `document_id` int NOT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 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 `user_documents`
--


--
-- Table structure for table `user_info_temp`
--

CREATE TABLE `user_info_temp` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `field_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci 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 `user_info_temp`
--


--
-- Table structure for table `user_relationships`
--

CREATE TABLE `user_relationships` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relationship` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_office` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_house` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cellphone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relationship2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_office2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_house2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cellphone2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 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 `user_relationships`
--


--
-- Table structure for table `user_role_company`
--

CREATE TABLE `user_role_company` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int NOT NULL,
  `user_id` int NOT NULL,
  `role_id` int DEFAULT NULL,
  `office_id` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `job_id` int DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `reason_for_leaving` enum('Renuncia','Interna','Otra') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_for_leaving` enum('Abierta','Cerrada') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `working_letter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exit_poll` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comments` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_start` timestamp NULL DEFAULT NULL,
  `date_end` timestamp NULL DEFAULT NULL,
  `type_job` enum('Fijo','Itinerante') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `monthly_salary` decimal(8,2) DEFAULT NULL,
  `salary` decimal(8,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_role_company`
--

INSERT INTO `user_role_company` VALUES (1,1,1,1,1,NULL,'2025-05-07 07:13:23','2025-05-07 07:13:23',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,3,1,1,NULL,'2025-05-07 13:45:37','2025-05-07 13:45:37',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);


