/*
 Navicat Premium Dump SQL

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 100432 (10.4.32-MariaDB)
 Source Host           : localhost:3306
 Source Schema         : sgd_v2

 Target Server Type    : MySQL
 Target Server Version : 100432 (10.4.32-MariaDB)
 File Encoding         : 65001

 Date: 10/01/2025 20:58:20
*/


-- ----------------------------
-- Table structure for areas
-- ----------------------------
CREATE TABLE `areas`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `iniciales` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of areas
-- ----------------------------
INSERT INTO `areas` VALUES (1, 'AREA DE GESTION ADMINISTRATIVA', 'AGA', '2024-05-24 17:11:52', '2024-05-24 17:11:55');

-- ----------------------------
-- Table structure for cargos
-- ----------------------------
CREATE TABLE `cargos`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `expediente_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `cargos_expediente_id_foreign`(`expediente_id` ASC) USING BTREE,
  CONSTRAINT `cargos_expediente_id_foreign` FOREIGN KEY (`expediente_id`) REFERENCES `expedientes` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of cargos
-- ----------------------------

-- ----------------------------
-- Table structure for empleados
-- ----------------------------
CREATE TABLE `empleados`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `dni` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `paterno` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `materno` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha_nac` date NULL DEFAULT NULL,
  `celular` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `direccion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `cargo_detalle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `correo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `cargo` enum('JEFE','SECRETARIA','RESPONSABLE','ASISTENTE','ESPECIALISTA') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `oficina_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `estado` enum('ACTIVO','INACTIVO') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'ACTIVO',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `empleados_oficina_id_foreign`(`oficina_id` ASC) USING BTREE,
  CONSTRAINT `empleados_oficina_id_foreign` FOREIGN KEY (`oficina_id`) REFERENCES `oficinas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of empleados
-- ----------------------------
INSERT INTO `empleados` VALUES (1, '73744393', 'FREDDY WALTERE', 'HUAYNAPATA', 'UCHARICO', NULL, '-', '-', NULL, '-', 'JEFE', 1, '2024-05-25 17:26:55', '2024-06-11 12:34:35', 'ACTIVO');
INSERT INTO `empleados` VALUES (2, '01338160', 'FRANCISCO', 'GUTIERREZ', 'CHALCO', NULL, '98745412', 'sad', NULL, 'ue308@gmail.com', 'RESPONSABLE', 2, '2024-05-25 17:28:36', '2024-06-11 12:34:41', 'ACTIVO');
INSERT INTO `empleados` VALUES (3, '73744395', 'MARY LUZ', 'HUAYNAPATA', 'UCHARICO', NULL, '98745412', 'JR. 31 DE MARZO S/N', NULL, 'soto@gmail.com', 'RESPONSABLE', 3, '2024-05-25 17:28:52', '2024-05-25 17:28:52', 'ACTIVO');
INSERT INTO `empleados` VALUES (4, '46701528', 'SONIA', 'ROJAS', 'HUANCAPAZA', NULL, '98745412', 'XC', NULL, 'ue308@gmail.com', 'RESPONSABLE', 4, '2024-05-25 17:29:34', '2024-06-11 12:34:46', 'ACTIVO');
INSERT INTO `empleados` VALUES (5, '73744394', 'ROSALINDA', 'HUAYNAPATA', 'UCHARICO', NULL, '98745412', 'JR. 31 DE MARZO S/N', NULL, 'ue308@gmail.com', 'ESPECIALISTA', 3, '2024-05-27 15:18:32', '2024-06-11 17:40:33', 'INACTIVO');

-- ----------------------------
-- Table structure for entidades
-- ----------------------------
CREATE TABLE `entidades`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `correo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `telefono` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ruc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_cargo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `representante` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombre_anio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of entidades
-- ----------------------------
INSERT INTO `entidades` VALUES (1, 'MUNICIPALIDAD DISTRITAL DE CHINCHERO', 'QWRQW', 'wrqrq', 'rqwr', '32423', 'storage/logo/1722974688_1.png', NULL, 'qwrqw', 'qwrqwr', '2024-05-24 17:04:50', '2024-08-06 15:39:34');

-- ----------------------------
-- Table structure for expedientes
-- ----------------------------
CREATE TABLE `expedientes`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `numero_registro` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `numero_expediente` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `tipo_persona` enum('PERSONA NATURAL','PERSONA JURIDICA') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tipo_expediente` enum('INTERNO','EXTERNO') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `estado_expediente` enum('DERIVADO','ENVIADO','PENDIENTE','ACEPTADO','RECHAZADO','FINALIZADO','ARCHIVADO','ELIMINADO') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dni_remitente` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `nombre_remitente` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `paterno_remitente` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `materno_remitente` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion_remitente` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `correo_remitente` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `celular_remitente` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `ruc_remitente` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `razon_remitente` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `tipo_documento_id` bigint UNSIGNED NOT NULL,
  `numero_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `folios_documento` int NOT NULL,
  `cabecera_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `asunto_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_cargo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `ultimo_numero_registro` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `fecha_registro` datetime NOT NULL,
  `oficina_actual_id` bigint UNSIGNED NOT NULL,
  `oficina_anterior_id` bigint UNSIGNED NULL DEFAULT NULL,
  `empleado_destino_id` bigint UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tipo` enum('ORIGINAL','COPIA') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'ORIGINAL',
  `tipo_registro` enum('EXTERNO','INTERNO') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'EXTERNO',
  `path_anexo_01` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_anexo_02` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_anexo_03` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_anexo_04` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_anexo_05` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `expedientes_numero_registro_unique`(`numero_registro` ASC) USING BTREE,
  UNIQUE INDEX `expedientes_numero_expediente_unique`(`numero_expediente` ASC) USING BTREE,
  INDEX `expedientes_oficina_actual_id_foreign`(`oficina_actual_id` ASC) USING BTREE,
  INDEX `expedientes_oficina_anterior_id_foreign`(`oficina_anterior_id` ASC) USING BTREE,
  INDEX `expedientes_tipo_documento_id_foreign`(`tipo_documento_id` ASC) USING BTREE,
  INDEX `expedientes_empleado_destino_id_foreign`(`empleado_destino_id` ASC) USING BTREE,
  CONSTRAINT `expedientes_empleado_destino_id_foreign` FOREIGN KEY (`empleado_destino_id`) REFERENCES `empleados` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `expedientes_oficina_actual_id_foreign` FOREIGN KEY (`oficina_actual_id`) REFERENCES `oficinas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `expedientes_oficina_anterior_id_foreign` FOREIGN KEY (`oficina_anterior_id`) REFERENCES `oficinas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `expedientes_tipo_documento_id_foreign` FOREIGN KEY (`tipo_documento_id`) REFERENCES `tipos` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 72 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of expedientes
-- ----------------------------
INSERT INTO `expedientes` VALUES (1, 'GqzTmpP-', '0001-2024', 'PERSONA NATURAL', 'INTERNO', 'ACEPTADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 2, '454', 2, 'INFORME 0001-2024-YF-DF', 'REFAS', 'storage/expedientes/1716676466expedientes454_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_GqzTmpP-_2_2024-05-25_17-34-26.pdf', '00004-2024', '2024-05-25 17:34:26', 4, 3, 4, '2024-05-25 17:34:32', '2024-05-25 21:35:10', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (2, '2OHZmnW1', '0002-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 2, '456', 1, 'SOLICITUD S/N', 'NNNN', 'storage/expedientes/1716676512expedientes456_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_2OHZmnW1_2_2024-05-25_17-35-12.pdf', '00151-2024', '2024-05-25 17:35:12', 3, 3, 3, '2024-05-25 17:35:17', '2024-05-25 17:40:04', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (3, '-w9TSd5t', '0003-2024', 'PERSONA NATURAL', 'INTERNO', 'ARCHIVADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 2, '54', 2, 'SOLICITUD S/N', 'NNN', 'storage/expedientes/1716676543expedientes54_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_-w9TSd5t_2_2024-05-25_17-35-43.pdf', '00150-2024', '2024-05-25 17:35:43', 3, 3, 3, '2024-05-25 17:35:49', '2024-05-25 17:40:19', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (4, 'oLvd6Jcp', '0004-2024', 'PERSONA NATURAL', 'INTERNO', 'ACEPTADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 2, 'S/N', 2, 'FQWFQWFQWF', 'QFWWFQF', 'storage/expedientes/1716685022expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_oLvd6Jcp_2_2024-05-25_19-57-02.pdf', '00003-2024', '2024-05-25 19:57:02', 4, 3, 4, '2024-05-25 19:57:09', '2024-05-25 21:27:58', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (5, 'UD4bkVNj', NULL, 'PERSONA NATURAL', 'EXTERNO', 'ELIMINADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 2, 'S/N', 2, 'INFORME 0001-2024-YF-DF', 'VGHVHGVHG', 'storage/expedientes/1716690957expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_UD4bkVNj_2_2024-05-25_21-35-57.pdf', NULL, '2024-05-25 21:35:56', 2, NULL, 2, '2024-05-25 21:36:00', '2024-05-28 23:11:36', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (6, 't132fRmb', NULL, 'PERSONA NATURAL', 'EXTERNO', 'ELIMINADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 2, 'S/N', 2, 'INFORME 0001-2024-YF-DF', 'VGHVHGVHG', 'storage/expedientes/1716691023expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_t132fRmb_2_2024-05-25_21-37-03.pdf', NULL, '2024-05-25 21:37:02', 2, NULL, 2, '2024-05-25 21:37:05', '2024-05-28 23:11:20', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (7, 'y6nEbUvI', NULL, 'PERSONA NATURAL', 'EXTERNO', 'ELIMINADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'sdsd', '98745412', NULL, NULL, 1, 'S/N', 3, 'INFORME 0001-2024-YF-DF', 'SADAS', 'storage/expedientes/1716692539expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_y6nEbUvI_1_2024-05-25_22-02-19.pdf', NULL, '2024-05-25 22:02:19', 2, NULL, 2, '2024-05-25 22:02:22', '2024-05-28 23:07:39', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (8, '-PYTI6Re', '00014-2024', 'PERSONA NATURAL', 'INTERNO', 'ARCHIVADO', '73744395', 'MARY LUZ', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'sdsd', '98745412', NULL, NULL, 2, 'S/N', 3, 'INFORME 0001-2024-YF-DF', '77777777777', 'storage/expedientes/1716952970expedientesS/N_2.pdf', 'storage/cargos/INTERNO_-PYTI6Re_2_2024-05-29_12-45-28.pdf', '00014-2024', '2024-05-25 22:02:36', 2, 2, 2, '2024-05-25 22:02:39', '2024-06-10 09:41:34', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (9, '@iDHlVrg', '00013-2024', 'PERSONA NATURAL', 'INTERNO', 'ARCHIVADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'sdsd', '4324', NULL, NULL, 1, 'S/N', 2, 'INFORME 0001-2024-YF-DF', 'DS', 'storage/expedientes/1716692590expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_@iDHlVrg_1_2024-05-25_22-03-10.pdf', '00013-2024', '2024-05-25 22:03:09', 2, 2, 2, '2024-05-25 22:03:12', '2024-06-10 09:43:09', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (10, 'lA@ndBcP', '00011-2024', 'PERSONA NATURAL', 'INTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'sdsd', '4324', NULL, NULL, 1, 'S/N', 2, 'INFORME 0001-2024-YF-DF', 'DS', 'storage/expedientes/1716925215expedientesS/N_1.pdf', 'storage/cargos/EXTERNO_lA@ndBcP_1_2024-05-25_22-07-20.pdf', '00049-2024', '2024-05-25 22:07:20', 3, 2, 3, '2024-05-25 22:07:23', '2024-08-19 19:10:31', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (11, 'QGsxNvWO', '00010-2024', 'PERSONA NATURAL', 'INTERNO', 'RECHAZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'SADASD', 'SDASD', NULL, NULL, 1, 'S/N', 5, 'INFORME 0001-2024-YF-DF', 'ADSAS', 'storage/expedientes/1716692885expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_QGsxNvWO_1_2024-05-25_22-08-05.pdf', '00162-2024', '2024-05-25 22:08:05', 3, 3, 2, '2024-05-25 22:08:07', '2024-08-19 19:07:39', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (12, '7LXPG5Wv', '00009-2024', 'PERSONA NATURAL', 'INTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'SADASD', 'SDASD', NULL, NULL, 1, 'S/N', 4, 'INFORME 0001-2024-YF-DF', 'ADSAS', 'storage/expedientes/1716693047expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_7LXPG5Wv_1_2024-05-25_22-10-47.pdf', '00163-2024', '2024-05-25 22:10:47', 2, 3, 2, '2024-05-25 22:10:50', '2024-06-19 14:01:19', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (13, '3ZmaG@09', '00008-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'SADASD', 'SDASD', NULL, NULL, 1, 'S/N', 4, 'INFORME 0001-2024-YF-DF', 'ADSAS', 'storage/expedientes/1716693090expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_3ZmaG@09_1_2024-05-25_22-11-30.pdf', '00156-2024', '2024-05-25 22:11:29', 3, 3, 3, '2024-05-25 22:11:32', '2024-05-26 21:37:41', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (14, 'vW23owOg', '00007-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'SADASD', 'SDASD', NULL, NULL, 1, 'S/N', 4, 'INFORME 0001-2024-YF-DF', 'ADSAS', 'storage/expedientes/1716693194expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_vW23owOg_1_2024-05-25_22-13-14.pdf', '00157-2024', '2024-05-25 22:13:13', 3, 3, 3, '2024-05-25 22:13:16', '2024-05-26 21:42:33', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (15, 'mPhtw@Og', '00006-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'SADASD', 'SDASD', NULL, NULL, 1, 'S/N', 4, 'INFORME 0001-2024-YF-DF', 'ADSAS', 'storage/expedientes/1716693299expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_mPhtw@Og_1_2024-05-25_22-14-59.pdf', '00158-2024', '2024-05-25 22:14:59', 3, 3, 3, '2024-05-25 22:15:02', '2024-05-26 21:43:31', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (16, '7FpGaslz', '00005-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', 'SDASD', NULL, NULL, 1, 'S/N', 4, 'INFORME 0001-2024-YF-DF', 'ADSAS', 'storage/expedientes/1716693351expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_7FpGaslz_1_2024-05-25_22-15-51.pdf', '00159-2024', '2024-05-25 22:15:50', 3, 3, 3, '2024-05-25 22:15:53', '2024-05-26 21:50:07', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (17, '6SG5DN@m', '00015-2024', 'PERSONA NATURAL', 'INTERNO', 'PENDIENTE', '73744395', 'MARY LUZ', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 2, 'S/N', 4, 'INFORME 0001-2024-YF-DF', 'SFSDF', 'storage/expedientes/1716951811expedientesS/N_2.pdf', 'storage/cargos/INTERNO_6SG5DN@m_2_2024-05-28_16-30-13.pdf', '00045-2024', '2024-05-28 16:30:13', 3, 2, 3, '2024-05-28 16:30:15', '2024-08-06 16:00:17', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (18, 'yVEQsBuX', NULL, 'PERSONA NATURAL', 'EXTERNO', 'ELIMINADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '956960013', NULL, NULL, 1, 'S/N', 4, 'INFORME 0001-2024-YF-DF', 'KLNKJN', 'storage/expedientes/1716956040expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_yVEQsBuX_1_2024-05-28_23-14-00.pdf', NULL, '2024-05-28 23:13:59', 2, NULL, 2, '2024-05-28 23:14:05', '2024-05-28 23:20:33', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (19, 'JW9f2Hwb', NULL, 'PERSONA NATURAL', 'EXTERNO', 'ELIMINADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '956960013', NULL, NULL, 1, 'S/N', 4, 'INFORME 0001-2024-YF-DF', 'KLNKJN', 'storage/expedientes/1716956064expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_JW9f2Hwb_1_2024-05-28_23-14-24.pdf', NULL, '2024-05-28 23:14:23', 2, NULL, 2, '2024-05-28 23:14:28', '2024-05-28 23:20:06', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (20, 'TJi5YHWb', NULL, 'PERSONA NATURAL', 'EXTERNO', 'ELIMINADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '956960013', NULL, NULL, 1, 'S/N', 4, 'INFORME 0001-2024-YF-DF', 'KLNKJN', 'storage/expedientes/1716956086expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_TJi5YHWb_1_2024-05-28_23-14-46.pdf', NULL, '2024-05-28 23:14:46', 2, NULL, 2, '2024-05-28 23:14:49', '2024-05-28 23:15:12', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (21, 'XTDz4yj-', '00012-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 1, 'S/N', 2, 'INFORME 0001-2024-YF-DF', 'PROEBADNOI JAVASCRIPT', 'storage/expedientes/1717617806expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_XTDz4yj-_1_2024-06-05_15-03-26.pdf', '00012-2024', '2024-06-05 15:03:26', 2, 2, 2, '2024-06-05 15:03:28', '2024-06-10 09:48:46', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (22, 'YZaMepVP', '0013-2024', 'PERSONA NATURAL', 'INTERNO', 'ARCHIVADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 1, 'S/N', 2, 'INFORME 0001-2024-YF-DF', 'PRUEBA', 'storage/expedientes/1717618111expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_YZaMepVP_1_2024-06-05_15-08-31.pdf', '0013-2024', '2024-06-05 15:08:31', 2, 2, 2, '2024-06-05 15:08:33', '2024-06-10 09:44:15', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (23, '4gMNz-Yy', '0014-2024', 'PERSONA NATURAL', 'INTERNO', 'ARCHIVADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 1, 'S/N', 5, 'INFORME 0001-2024-YF-DF', 'MEDIO GEOGRAFICO', 'storage/expedientes/1717618585expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_4gMNz-Yy_1_2024-06-05_15-16-25.pdf', '0014-2024', '2024-06-05 15:16:25', 2, 2, 2, '2024-06-05 15:16:27', '2024-06-10 09:42:30', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (24, 'rBksAwOM', '00016-2024', 'PERSONA NATURAL', 'INTERNO', 'ARCHIVADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 1, 'S/N', 3, 'INFORME 0001-2024-YF-DF', 'TRABAJO DE INVESTIGACION', 'storage/expedientes/1717618821expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_rBksAwOM_1_2024-06-05_15-20-21.pdf', '00016-2024', '2024-06-05 15:20:21', 2, 2, 2, '2024-06-05 15:20:23', '2024-06-10 09:40:08', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (25, 'FKsp@1yV', '00017-2024', 'PERSONA NATURAL', 'INTERNO', 'ARCHIVADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 1, 'S/N', 3, 'INFORME 0001-2024-YF-DF', 'TRABAJO DE INVESTIGACION', 'storage/expedientes/1717618859expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_FKsp@1yV_1_2024-06-05_15-20-59.pdf', '00017-2024', '2024-06-05 15:20:59', 2, 2, 2, '2024-06-05 15:21:01', '2024-06-10 09:36:55', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (26, '-PB6sb4f', '00020-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 2, 'S/N', 2, 'INFORME 0001-2024-YF-DF', 'PROEBADNOI JAVASCRIPT', 'storage/expedientes/1718145503expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_-PB6sb4f_2_2024-06-11_17-38-23.pdf', '00020-2024', '2024-06-11 17:38:23', 2, 2, 2, '2024-06-11 17:38:25', '2024-08-05 14:38:14', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (27, 'hnXd-S1g', '00025-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 2, '2', 'WAFSFSD', 'storage/expedientes/1718727160expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_hnXd-S1g_1_2024-06-18_11-12-40.pdf', '00025-2024', '2024-06-18 11:12:40', 2, 2, 2, '2024-06-18 11:12:42', '2024-08-05 14:33:22', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (28, 'YpGU8nsq', '00024-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 23, 'INFORME 0001-2024-YF-DF', 'YUJJHNJN', 'storage/expedientes/1718727351expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_YpGU8nsq_1_2024-06-18_11-15-51.pdf', '00024-2024', '2024-06-18 11:15:51', 2, 2, 2, '2024-06-18 11:15:53', '2024-08-05 14:34:29', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (29, 'MwEZjAa9', '00023-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 23, 'INFORME 0001-2024-YF-DF', 'YUJJHNJN', 'storage/expedientes/1718727371expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_MwEZjAa9_1_2024-06-18_11-16-11.pdf', '00023-2024', '2024-06-18 11:16:11', 2, 2, 2, '2024-06-18 11:16:13', '2024-08-05 14:34:29', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (30, 'obl0WLv9', '00022-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 23, 'INFORME 0001-2024-YF-DF', 'YUJJHNJN', 'storage/expedientes/1718727390expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_obl0WLv9_1_2024-06-18_11-16-30.pdf', '00022-2024', '2024-06-18 11:16:30', 2, 2, 2, '2024-06-18 11:16:32', '2024-08-05 14:37:54', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (31, 'PmdpoCVG', '00021-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 23, 'INFORME 0001-2024-YF-DF', 'YUJJHNJN', 'storage/expedientes/1718727407expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_PmdpoCVG_1_2024-06-18_11-16-47.pdf', '00021-2024', '2024-06-18 11:16:47', 2, 2, 2, '2024-06-18 11:16:49', '2024-08-05 14:38:14', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (32, 'HJVmwgFk', '12-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 1, 'S/N', 23, 'INFORME 0001-2024-YF-DF', 'GEDG', 'storage/expedientes/1722886844expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_HJVmwgFk_1_2024-08-05_14-40-44.pdf', '12-2024', '2024-08-05 14:40:44', 2, 2, 2, '2024-08-05 14:40:46', '2024-08-05 14:41:02', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (33, 'rB0nhuIp', '00027-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'ue308@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 34, 'FSAF', 'EWFRSF', 'storage/expedientes/1722887423expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_rB0nhuIp_1_2024-08-05_14-50-23.pdf', '00027-2024', '2024-08-05 14:50:23', 2, 2, 2, '2024-08-05 14:50:25', '2024-08-05 14:51:24', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (34, 'Ro9Nwa3d', '00026-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'ue308@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 34, 'FSAF', 'EWFRSF', 'storage/expedientes/1722887447expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_Ro9Nwa3d_1_2024-08-05_14-50-47.pdf', '00026-2024', '2024-08-05 14:50:47', 2, 2, 2, '2024-08-05 14:50:49', '2024-08-05 14:51:24', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (35, 'kejzDP6M', '00030-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'ue308@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 34, 'FSAF', 'EWFRSF', 'storage/expedientes/1722887742expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_kejzDP6M_1_2024-08-05_14-55-42.pdf', '00030-2024', '2024-08-05 14:55:41', 2, 2, 2, '2024-08-05 14:55:44', '2024-08-05 14:57:02', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (36, 'l8O26iWF', '00029-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'ue308@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 34, 'FSAF', 'EWFRSF', 'storage/expedientes/1722887757expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_l8O26iWF_1_2024-08-05_14-55-57.pdf', '00029-2024', '2024-08-05 14:55:57', 2, 2, 2, '2024-08-05 14:55:59', '2024-08-05 14:57:02', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (37, '6utI8a7N', '00028-2024', 'PERSONA NATURAL', 'INTERNO', 'FINALIZADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'ue308@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 34, 'FSAF', 'EWFRSF', 'storage/expedientes/1722887780expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_6utI8a7N_1_2024-08-05_14-56-20.pdf', '00028-2024', '2024-08-05 14:56:19', 2, 2, 2, '2024-08-05 14:56:22', '2024-08-05 14:57:02', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (38, 'T6oKy3xV', '00035-2024', 'PERSONA NATURAL', 'INTERNO', 'ARCHIVADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'ue308@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 34, 'FSAF', 'EWFRSF', 'storage/expedientes/1722887889expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_T6oKy3xV_1_2024-08-05_14-58-09.pdf', '00035-2024', '2024-08-05 14:58:09', 2, 2, 2, '2024-08-05 14:58:11', '2024-08-05 22:12:09', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (39, 'TK-SydGs', '00034-2024', 'PERSONA NATURAL', 'INTERNO', 'ARCHIVADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'ue308@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 34, 'FSAF', 'EWFRSF', 'storage/expedientes/1722887905expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_TK-SydGs_1_2024-08-05_14-58-25.pdf', '00034-2024', '2024-08-05 14:58:25', 2, 2, 2, '2024-08-05 14:58:27', '2024-08-05 22:12:09', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (40, 'AslT3vPB', '00033-2024', 'PERSONA NATURAL', 'INTERNO', 'ARCHIVADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'ue308@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 34, 'FSAF', 'EWFRSF', 'storage/expedientes/1722887922expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_AslT3vPB_1_2024-08-05_14-58-42.pdf', '00033-2024', '2024-08-05 14:58:42', 2, 2, 2, '2024-08-05 14:58:44', '2024-08-05 22:17:20', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (41, 'anpoNBSd', '00032-2024', 'PERSONA NATURAL', 'INTERNO', 'ARCHIVADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'ue308@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 34, 'FSAF', 'EWFRSF', 'storage/expedientes/1722887942expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_anpoNBSd_1_2024-08-05_14-59-02.pdf', '00032-2024', '2024-08-05 14:59:01', 2, 2, 2, '2024-08-05 14:59:03', '2024-08-05 22:17:20', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (42, 'bKr49Ty8', '00031-2024', 'PERSONA NATURAL', 'INTERNO', 'ARCHIVADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'ue308@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 34, 'FSAF', 'EWFRSF', 'storage/expedientes/1722887958expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_bKr49Ty8_1_2024-08-05_14-59-18.pdf', '00031-2024', '2024-08-05 14:59:18', 2, 2, 2, '2024-08-05 14:59:20', '2024-08-05 22:23:06', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (43, 'n5Yl8-Xf', '00039-2024', 'PERSONA NATURAL', 'INTERNO', 'ARCHIVADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '4324', NULL, NULL, 1, 'S/N', 24, 'SOLICITUD S/N', 'WFAS', 'storage/expedientes/1722914727expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_n5Yl8-Xf_1_2024-08-05_22-25-27.pdf', '00039-2024', '2024-08-05 22:25:27', 2, 2, 2, '2024-08-05 22:25:30', '2024-08-05 22:27:50', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (44, 'srPnzkyE', '00038-2024', 'PERSONA NATURAL', 'INTERNO', 'ARCHIVADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '4324', NULL, NULL, 1, 'S/N', 24, 'SOLICITUD S/N', 'WFAS', 'storage/expedientes/1722914751expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_srPnzkyE_1_2024-08-05_22-25-52.pdf', '00038-2024', '2024-08-05 22:25:51', 2, 2, 2, '2024-08-05 22:25:54', '2024-08-05 22:27:50', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (45, '9Fc2Yad5', '00037-2024', 'PERSONA NATURAL', 'INTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '4324', NULL, NULL, 1, 'S/N', 24, 'SOLICITUD S/N', 'WFAS', 'storage/expedientes/1722914790expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_9Fc2Yad5_1_2024-08-05_22-26-30.pdf', '00037-2024', '2024-08-05 22:26:29', 3, 2, 3, '2024-08-05 22:26:34', '2024-08-05 23:21:46', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (46, 'DWmiBgzY', '00036-2024', 'PERSONA NATURAL', 'INTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '4324', NULL, NULL, 1, 'S/N', 24, 'SOLICITUD S/N', 'WFAS', 'storage/expedientes/1722914818expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_DWmiBgzY_1_2024-08-05_22-26-58.pdf', '00036-2024', '2024-08-05 22:26:57', 3, 2, 3, '2024-08-05 22:27:01', '2024-08-05 23:21:46', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (47, 'CfcwF-8D', '00041-2024', 'PERSONA NATURAL', 'INTERNO', 'ACEPTADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 13, 'SDCASD', 'FSFAS', 'storage/expedientes/1722960146expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_CfcwF-8D_1_2024-08-06_11-02-26.pdf', '00041-2024', '2024-08-06 11:02:25', 2, NULL, 2, '2024-08-06 11:02:33', '2024-08-06 11:03:41', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (48, 'm7HRF-xP', '00040-2024', 'PERSONA NATURAL', 'INTERNO', 'ACEPTADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 1, 'S/N', 13, 'SDCASD', 'FSFAS', 'storage/expedientes/1722960175expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_m7HRF-xP_1_2024-08-06_11-02-55.pdf', '00040-2024', '2024-08-06 11:02:54', 2, NULL, 2, '2024-08-06 11:03:01', '2024-08-06 11:03:33', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (49, 'e7RN5waO', NULL, 'PERSONA NATURAL', 'EXTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 2, '12', 123, 'INFORME 0001-2024-YF-DF', 'ASASFASFASF', 'storage/expedientes/1722976222expedientes12_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_e7RN5waO_2_2024-08-06_15-30-22.pdf', NULL, '2024-08-06 15:30:21', 2, NULL, 2, '2024-08-06 15:30:28', '2024-08-06 15:30:28', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (50, 'fCLQH8um', NULL, 'PERSONA NATURAL', 'EXTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 2, '12', 123, 'INFORME 0001-2024-YF-DF', 'ASASFASFASF', 'storage/expedientes/1722976254expedientes12_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_fCLQH8um_2_2024-08-06_15-30-54.pdf', NULL, '2024-08-06 15:30:53', 2, NULL, 2, '2024-08-06 15:31:00', '2024-08-06 15:31:00', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (51, 'm@IzBla8', NULL, 'PERSONA NATURAL', 'EXTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 2, '12', 123, 'INFORME 0001-2024-YF-DF', 'ASASFASFASF', 'storage/expedientes/1722976287expedientes12_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_m@IzBla8_2_2024-08-06_15-31-27.pdf', NULL, '2024-08-06 15:31:26', 2, NULL, 2, '2024-08-06 15:31:34', '2024-08-06 15:31:34', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (52, 'tEsbkpf6', NULL, 'PERSONA NATURAL', 'EXTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 2, '12', 123, 'INFORME 0001-2024-YF-DF', 'ASASFASFASF', 'storage/expedientes/1722976343expedientes12_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_tEsbkpf6_2_2024-08-06_15-32-23.pdf', NULL, '2024-08-06 15:32:22', 2, NULL, 2, '2024-08-06 15:32:29', '2024-08-06 15:32:29', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (53, 'fgMi1vqe', '00048-2024', 'PERSONA NATURAL', 'INTERNO', 'RECHAZADO', '73744393', 'FREDDY WALTERkjsad', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 2, '0001', 5, 'INFORME 0001-2024-YF-DF', 'SOLICITO PERMISOjhgjghhv', 'storage/expedientes/1722976515expedientes0001_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_fgMi1vqe_2_2024-08-12_23-30-36.pdf', '00005-2024', '2024-08-06 15:35:15', 2, 2, 4, '2024-08-06 15:35:21', '2024-09-09 13:51:09', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (54, 'VFrbuxHo', '00043-2024', 'PERSONA NATURAL', 'INTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 2, '1', 12, 'INFORME 0001-2024-YF-DF', 'INFORME ESCALOFONARIO', 'storage/expedientes/1722976729expedientes1_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_VFrbuxHo_2_2024-08-06_15-38-49.pdf', '00043-2024', '2024-08-06 15:38:49', 3, 2, 3, '2024-08-06 15:38:54', '2024-08-12 23:25:03', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (55, 'amhtyYcV', '00044-2024', 'PERSONA NATURAL', 'INTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 2, '0001', 5, 'INFORME 0001-2024-YF-DF', 'INFORME ESCALOFONARIO', 'storage/expedientes/1722976811expedientes0001_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_amhtyYcV_2_2024-08-06_15-40-11.pdf', '00044-2024', '2024-08-06 15:40:11', 3, 2, 3, '2024-08-06 15:40:16', '2024-08-12 23:25:03', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (56, 'gN7Tef0V', NULL, 'PERSONA NATURAL', 'EXTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 2, '12', 123, 'INFORME 0001-2024-YF-DF', 'ASASFASFASF', 'storage/expedientes/1722977653expedientes12_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_gN7Tef0V_2_2024-08-06_15-54-13.pdf', NULL, '2024-08-06 15:54:12', 2, NULL, 2, '2024-08-06 15:54:18', '2024-08-06 15:54:18', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (57, '49pQt0vd', NULL, 'PERSONA NATURAL', 'EXTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 2, '12', 123, 'INFORME 0001-2024-YF-DF', 'ASASFASFASF', 'storage/expedientes/1722977710expedientes12_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_49pQt0vd_2_2024-08-06_15-55-10.pdf', NULL, '2024-08-06 15:55:09', 2, NULL, 2, '2024-08-06 15:55:15', '2024-08-06 15:55:15', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (58, 'AGnty2IN', NULL, 'PERSONA NATURAL', 'EXTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 2, 'S/N', 3223, 'INFORME 0001-2024-YF-DF', 'WQEQWE', 'storage/expedientes/1722982603expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_AGnty2IN_2_2024-08-06_17-16-43.pdf', NULL, '2024-08-06 17:16:43', 2, NULL, 2, '2024-08-06 17:16:45', '2024-08-06 17:16:45', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (59, 'r8BLOcHA', '00046-2024', 'PERSONA NATURAL', 'INTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 2, 'S/N', 34, 'INFORME 0001-2024-YF-DF', 'SFSSFSDF', 'storage/expedientes/1722982730expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_r8BLOcHA_2_2024-08-06_17-18-50.pdf', '00046-2024', '2024-08-06 17:18:50', 3, 2, 3, '2024-08-06 17:18:51', '2024-08-12 23:25:03', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (60, 'RceVjL4k', '00047-2024', 'PERSONA NATURAL', 'INTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 2, '001', 4, 'INFORME 0001-2024-YF-DF', 'JCBKAJSBC', 'storage/expedientes/1723522422expedientes001_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_RceVjL4k_2_2024-08-12_23-13-42.pdf', '00164-2024', '2024-08-12 23:13:41', 4, 3, 4, '2024-08-12 23:13:45', '2024-08-12 23:34:20', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (61, 'hqc@uTt1', 'ORP00001-2024', 'PERSONA NATURAL', 'INTERNO', 'ACEPTADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 2, '001', 4, 'INFORME 0001-2024-YF-DF', 'TRABAJO DE INVESTIGACION', 'storage/expedientes/1725811225expedientes001_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_hqc@uTt1_2_2024-09-08_11-00-25.pdf', 'ORP00001-2024', '2024-09-08 11:00:25', 4, NULL, 2, '2024-09-08 11:00:27', '2024-09-08 11:00:27', 'ORIGINAL', 'INTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (62, 'xUfRmEnt', 'ORP00002-2024', 'PERSONA NATURAL', 'INTERNO', 'ACEPTADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 2, '001', 5, 'INFORME 0001-2024-YF-DF', 'TRABAJO DE INVESTIGACION', 'storage/expedientes/1725812619expedientes001_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_xUfRmEnt_2_2024-09-08_11-23-39.pdf', 'ORP00002-2024', '2024-09-08 11:23:39', 4, NULL, 2, '2024-09-08 11:23:41', '2024-09-08 11:23:41', 'ORIGINAL', 'INTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (63, 'XhJ1uSON', NULL, 'PERSONA NATURAL', 'EXTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 2, 'S/N', 4, 'INFORME 0001-2024-YF-DF', 'FAKAKS', 'storage/expedientes/1727036865expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_XhJ1uSON_2_2024-09-22_15-27-45.pdf', NULL, '2024-09-22 15:27:44', 2, NULL, 2, '2024-09-22 15:27:47', '2024-09-22 15:27:47', 'ORIGINAL', 'EXTERNO', 'storage/expedientes/1727036865expedientesS/N_FREDDY WALTER.pdf', 'storage/expedientes/1727036865expedientesS/N_FREDDY WALTER.pdf', 'storage/expedientes/1727036865expedientesS/N_FREDDY WALTER.pdf', 'storage/expedientes/1727036865expedientesS/N_FREDDY WALTER.pdf', 'storage/expedientes/1727036865expedientesS/N_FREDDY WALTER.pdf');
INSERT INTO `expedientes` VALUES (64, 'bPUpslDq', NULL, 'PERSONA NATURAL', 'EXTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.ucharico099@gmail.com', '98745412', NULL, NULL, 2, 'S/N', 4, 'INFORME 0001-2024-YF-DF', 'FAKAKS', 'storage/expedientes/1727037818expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_bPUpslDq_2_2024-09-22_15-43-38.pdf', NULL, '2024-09-22 15:43:37', 2, NULL, 2, '2024-09-22 15:43:45', '2024-09-22 15:43:45', 'ORIGINAL', 'EXTERNO', 'storage/expedientes/1727036865expedientesS/N_FREDDY WALTER.pdf', 'storage/expedientes/1727036865expedientesS/N_FREDDY WALTER.pdf', 'storage/expedientes/1727036865expedientesS/N_FREDDY WALTER.pdf', 'storage/expedientes/1727036865expedientesS/N_FREDDY WALTER.pdf', 'storage/expedientes/1727036865expedientesS/N_FREDDY WALTER.pdf');
INSERT INTO `expedientes` VALUES (65, 'OJ48bB-G', '00050-2024', 'PERSONA NATURAL', 'INTERNO', 'ACEPTADO', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', NULL, NULL, NULL, NULL, 1, 'S/N', 4, 'INFORME 0001-2024-YF-DF', 'ASF', 'storage/expedientes/1727038679expedientesS/N_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_OJ48bB-G_1_2024-09-22_15-57-59.pdf', '00050-2024', '2024-09-22 15:57:59', 2, NULL, 2, '2024-09-22 15:58:02', '2024-09-22 15:58:02', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (66, 'j@1wNJe0', 'OTD00001-2024', 'PERSONA NATURAL', 'INTERNO', 'ACEPTADO', NULL, 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', NULL, NULL, NULL, NULL, NULL, 2, '0001', 1, 'OFICIO N° 001-2024-SDF/DSF-S', 'PRUEBA DEL INICIO DE AÑO 2024', 'storage/expedientes/1733241564expedientes0001_FREDDY WALTER.pdf', 'storage/cargos/INTERNO_j@1wNJe0_2_2024-12-03_10-59-25.pdf', 'OTD00001-2024', '2024-12-03 10:59:24', 2, NULL, 2, '2024-12-03 10:59:39', '2024-12-03 10:59:39', 'ORIGINAL', 'INTERNO', 'storage/expedientes/1733241564expedientes0001_FREDDY WALTER.pdf', 'storage/expedientes/1733241564expedientes0001_FREDDY WALTER.pdf', 'storage/expedientes/1733241564expedientes0001_FREDDY WALTER.pdf', 'storage/expedientes/1733241564expedientes0001_FREDDY WALTER.pdf', 'storage/expedientes/1733241564expedientes0001_FREDDY WALTER.pdf');
INSERT INTO `expedientes` VALUES (67, 'qsvOE-pf', '00051-2024', 'PERSONA NATURAL', 'INTERNO', 'ACEPTADO', NULL, 'FREDDY', 'SADSAD', 'SADASD', NULL, NULL, NULL, NULL, NULL, 2, '12', 12, 'ASDSAD', 'CSSFSDFDSF', 'storage/expedientes/1735937881expedientes12_2.pdf', 'storage/cargos/INTERNO_qsvOE-pf_2_2025-01-03_15-58-01.pdf', '00051-2024', '2024-12-03 13:13:11', 2, NULL, 2, '2024-12-03 13:13:15', '2025-01-03 16:42:33', 'ORIGINAL', 'EXTERNO', 'storage/expedientes/1735940331Anexo_01_2025-01-03_16-38-51_67.pdf', 'storage/expedientes/1735940350Anexo_02_2025-01-03_16-39-10_67.pdf', 'storage/expedientes/1735940542Anexo_03_2025-01-03_16-42-22_67.pdf', 'storage/expedientes/1735940553Anexo_04_2025-01-03_16-42-33_67.pdf', 'storage/expedientes/1733249595Anexos_05__FREDDY_2024-12-03_13-13-11.pdf');
INSERT INTO `expedientes` VALUES (68, 'KcuY1BO-', 'OTD00002-2024', 'PERSONA NATURAL', 'INTERNO', 'ACEPTADO', NULL, 'FREDD', 'ASDAS', 'DSAD', NULL, NULL, NULL, NULL, NULL, 1, '123', 213, 'GFDGF', 'DSGDFG', 'storage/expedientes/1733250089expedientes_FREDD2024-12-03_13-21-29.pdf', 'storage/cargos/INTERNO_KcuY1BO-_1_2024-12-03_13-21-29.pdf', 'OTD00002-2024', '2024-12-03 13:21:29', 2, NULL, 2, '2024-12-03 13:21:33', '2024-12-03 13:21:33', 'ORIGINAL', 'INTERNO', NULL, 'storage/expedientes/1733250093Anexos_02__FREDD_2024-12-03_13-21-29.pdf', NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (69, 'ZyhG78YC', NULL, 'PERSONA NATURAL', 'EXTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'SD', 'freddy.hu099@gmail.com', '967444616', NULL, NULL, 1, '12', 12, 'OFICIO', 'SFDSF', 'storage/expedientes/1733250312expedientes12_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_ZyhG78YC_1_2024-12-03_13-25-12.pdf', NULL, '2024-12-03 13:25:11', 2, NULL, 2, '2024-12-03 13:25:16', '2024-12-03 13:25:16', 'ORIGINAL', 'EXTERNO', 'storage/expedientes/1733250316Anexos_01_73744393_FREDDY WALTER_2024-12-03_13-25-12.pdf', 'storage/expedientes/1733250316Anexos_02_73744393_FREDDY WALTER_2024-12-03_13-25-12.pdf', NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (70, '1cw30X56', '00001-2025', 'PERSONA NATURAL', 'INTERNO', 'PENDIENTE', 'rew', 'FERW', 'WER', 'EWR', NULL, NULL, NULL, NULL, NULL, 2, '12', 12, 'DSFSDF', 'DSFDFDSF', 'storage/expedientes/1735929385expedientes_rew_FERW2025-01-03_13-36-25.pdf', 'storage/cargos/INTERNO_1cw30X56_2_2025-01-03_13-36-25.pdf', '00001-2025', '2025-01-03 13:36:25', 1, 2, 1, '2025-01-03 13:36:28', '2025-01-03 13:58:38', 'ORIGINAL', 'EXTERNO', 'storage/expedientes/1735929388Anexos_01_rew_FERW_2025-01-03_13-36-25.pdf', NULL, NULL, NULL, NULL);
INSERT INTO `expedientes` VALUES (71, 'zbS-L09M', NULL, 'PERSONA NATURAL', 'EXTERNO', 'PENDIENTE', '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', 'freddy.hu099@gmail.com', '96744616', NULL, NULL, 2, '12', 213, 'CFDSDSF', 'SAFSF', 'storage/expedientes/1736182396expedientes12_FREDDY WALTER.pdf', 'storage/cargos/EXTERNO_zbS-L09M_2_2025-01-06_11-53-17.pdf', NULL, '2025-01-06 11:53:15', 2, NULL, 2, '2025-01-06 11:53:25', '2025-01-06 11:53:25', 'ORIGINAL', 'EXTERNO', NULL, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for failed_jobs
-- ----------------------------
CREATE TABLE `failed_jobs`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `failed_jobs_uuid_unique`(`uuid` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of failed_jobs
-- ----------------------------

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
CREATE TABLE `migrations`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of migrations
-- ----------------------------
INSERT INTO `migrations` VALUES (1, '2014_10_12_100000_create_password_reset_tokens_table', 1);
INSERT INTO `migrations` VALUES (2, '2014_10_12_100000_create_password_resets_table', 1);
INSERT INTO `migrations` VALUES (3, '2019_08_19_000000_create_failed_jobs_table', 1);
INSERT INTO `migrations` VALUES (4, '2019_12_14_000001_create_personal_access_tokens_table', 1);
INSERT INTO `migrations` VALUES (5, '2024_05_03_155524_create_areas_table', 1);
INSERT INTO `migrations` VALUES (6, '2024_05_03_174321_create_oficinas_table', 1);
INSERT INTO `migrations` VALUES (7, '2024_05_03_194903_create_empleados_table', 1);
INSERT INTO `migrations` VALUES (8, '2024_05_03_213332_create_tipos_table', 1);
INSERT INTO `migrations` VALUES (9, '2024_05_04_023310_create_entidades_table', 1);
INSERT INTO `migrations` VALUES (10, '2024_05_04_155000_create_tupas_table', 1);
INSERT INTO `migrations` VALUES (11, '2024_05_04_165910_create_requisitos_table', 1);
INSERT INTO `migrations` VALUES (12, '2024_05_04_220000_create_users_table', 1);
INSERT INTO `migrations` VALUES (13, '2024_05_05_004825_create_expedientes_table', 1);
INSERT INTO `migrations` VALUES (14, '2024_05_06_005252_create_movimientos_table', 1);
INSERT INTO `migrations` VALUES (15, '2024_05_11_172919_create_cargos_table', 1);
INSERT INTO `migrations` VALUES (16, '2024_05_12_014058_create_rutas_table', 1);
INSERT INTO `migrations` VALUES (17, '2024_05_23_154858_create_multiples_table', 1);

-- ----------------------------
-- Table structure for movimientos
-- ----------------------------
CREATE TABLE `movimientos`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `tipo_documento_id` bigint UNSIGNED NULL DEFAULT NULL,
  `path_cargo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `numero` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `folios` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `cabecera` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `asunto_movimiento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `fecha_registro_1` datetime NOT NULL,
  `numero_registro_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `estado_1` enum('DERIVADO','ENVIADO','PENDIENTE','ACEPTADO','RECHAZADO','FINALIZADO','ARCHIVADO','ELIMINADO') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `oficina_origen_id` bigint UNSIGNED NULL DEFAULT NULL,
  `expediente_id` bigint UNSIGNED NOT NULL,
  `empleado_origen_id` bigint UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `movimientos_oficina_origen_id_foreign`(`oficina_origen_id` ASC) USING BTREE,
  INDEX `movimientos_expediente_id_foreign`(`expediente_id` ASC) USING BTREE,
  INDEX `movimientos_tipo_documento_id_foreign`(`tipo_documento_id` ASC) USING BTREE,
  INDEX `movimientos_empleado_origen_id_foreign`(`empleado_origen_id` ASC) USING BTREE,
  CONSTRAINT `movimientos_empleado_origen_id_foreign` FOREIGN KEY (`empleado_origen_id`) REFERENCES `empleados` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `movimientos_expediente_id_foreign` FOREIGN KEY (`expediente_id`) REFERENCES `expedientes` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `movimientos_oficina_origen_id_foreign` FOREIGN KEY (`oficina_origen_id`) REFERENCES `oficinas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `movimientos_tipo_documento_id_foreign` FOREIGN KEY (`tipo_documento_id`) REFERENCES `tipos` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 83 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of movimientos
-- ----------------------------
INSERT INTO `movimientos` VALUES (1, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-25_17-38-24.pdf', NULL, NULL, NULL, NULL, '2024-05-25 17:38:24', '00001-2024', 'DERIVADO', NULL, 2, 1, 2, '2024-05-25 17:34:32', '2024-05-25 17:38:30');
INSERT INTO `movimientos` VALUES (2, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-25_17-38-01.pdf', NULL, NULL, NULL, NULL, '2024-05-25 17:38:01', '00002-2024', 'DERIVADO', NULL, 2, 2, 2, '2024-05-25 17:35:17', '2024-05-25 17:38:07');
INSERT INTO `movimientos` VALUES (3, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-25_17-36-29.pdf', NULL, NULL, NULL, NULL, '2024-05-25 17:36:29', '00003-2024', 'DERIVADO', NULL, 2, 3, 2, '2024-05-25 17:35:49', '2024-05-25 17:36:36');
INSERT INTO `movimientos` VALUES (4, NULL, 'storage/cargos/CARGO_ARCHIVAR__2024-05-25_17-40-19.pdf', NULL, NULL, NULL, NULL, '2024-05-25 17:40:19', '00150-2024', 'ARCHIVADO', NULL, 3, 3, 3, '2024-05-25 17:39:15', '2024-05-25 17:40:21');
INSERT INTO `movimientos` VALUES (5, 2, 'storage/cargos/CARGO_FINALIZAR_2_2024-05-25_17-40-04.pdf', NULL, NULL, NULL, NULL, '2024-05-25 17:40:04', '00151-2024', 'FINALIZADO', NULL, 3, 2, 3, '2024-05-25 17:39:23', '2024-05-25 17:40:07');
INSERT INTO `movimientos` VALUES (6, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-25_17-39-48.pdf', NULL, NULL, NULL, NULL, '2024-05-25 17:39:48', '00152-2024', 'DERIVADO', NULL, 3, 1, 3, '2024-05-25 17:39:31', '2024-05-25 17:39:51');
INSERT INTO `movimientos` VALUES (7, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-25_19-58-10.pdf', NULL, NULL, NULL, NULL, '2024-05-25 19:58:10', '00004-2024', 'DERIVADO', NULL, 2, 4, 2, '2024-05-25 19:57:09', '2024-05-25 19:58:16');
INSERT INTO `movimientos` VALUES (8, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-25_20-36-40.pdf', NULL, NULL, NULL, NULL, '2024-05-25 20:36:40', '00153-2024', 'DERIVADO', NULL, 3, 4, 3, '2024-05-25 20:36:20', '2024-05-25 20:36:44');
INSERT INTO `movimientos` VALUES (9, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-25_20-41-11.pdf', NULL, NULL, NULL, NULL, '2024-05-25 20:41:11', '00001-2024', 'DERIVADO', NULL, 4, 4, 4, '2024-05-25 20:37:36', '2024-05-25 20:41:15');
INSERT INTO `movimientos` VALUES (10, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-25_20-40-39.pdf', NULL, NULL, NULL, NULL, '2024-05-25 20:40:39', '00002-2024', 'DERIVADO', NULL, 4, 1, 4, '2024-05-25 20:40:22', '2024-05-25 20:40:44');
INSERT INTO `movimientos` VALUES (11, 2, 'storage/cargos/CARGO_DERIVAR_2_2024-05-25_21-18-07.pdf', NULL, NULL, NULL, NULL, '2024-05-25 21:18:07', '00154-2024', 'DERIVADO', NULL, 3, 4, 3, '2024-05-25 20:44:01', '2024-05-25 21:18:09');
INSERT INTO `movimientos` VALUES (12, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-25_21-17-49.pdf', NULL, NULL, NULL, NULL, '2024-05-25 21:17:49', '00155-2024', 'DERIVADO', NULL, 3, 1, 3, '2024-05-25 20:44:13', '2024-05-25 21:17:51');
INSERT INTO `movimientos` VALUES (13, NULL, NULL, NULL, NULL, NULL, NULL, '2024-05-25 21:27:58', '00003-2024', 'ACEPTADO', NULL, 4, 4, 4, '2024-05-25 21:27:58', '2024-05-25 21:27:58');
INSERT INTO `movimientos` VALUES (14, NULL, NULL, NULL, NULL, NULL, NULL, '2024-05-25 21:35:10', '00004-2024', 'ACEPTADO', NULL, 4, 1, 4, '2024-05-25 21:35:10', '2024-05-25 21:35:10');
INSERT INTO `movimientos` VALUES (15, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-26_21-33-03.pdf', 'S/N', '4', 'INFORME 0001-2024-YF-DF', 'ADSAS', '2024-05-26 21:33:03', '00005-2024', 'DERIVADO', NULL, 2, 16, 2, '2024-05-26 19:39:47', '2024-05-26 21:33:08');
INSERT INTO `movimientos` VALUES (16, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-26_21-36-38.pdf', 'S/N', '4', 'INFORME 0001-2024-YF-DF', 'ADSAS', '2024-05-26 21:36:38', '00006-2024', 'DERIVADO', NULL, 2, 15, 2, '2024-05-26 19:43:17', '2024-05-26 21:36:44');
INSERT INTO `movimientos` VALUES (17, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-26_20-32-24.pdf', '15', '5', 'ASDAS', 'ASDASD', '2024-05-26 20:32:24', '00007-2024', 'DERIVADO', NULL, 2, 14, 2, '2024-05-26 19:43:28', '2024-05-26 20:32:30');
INSERT INTO `movimientos` VALUES (18, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-26_20-29-45.pdf', 'sd', '3', 'SDDS', 'CSDDDD', '2024-05-26 20:29:45', '00008-2024', 'DERIVADO', NULL, 2, 13, 2, '2024-05-26 19:44:13', '2024-05-26 20:29:52');
INSERT INTO `movimientos` VALUES (19, 2, 'storage/cargos/CARGO_FINALIZAR_2_2024-05-26_21-37-41.pdf', NULL, NULL, NULL, 'BBBBBBBBBBBB', '2024-05-26 21:37:41', '00156-2024', 'FINALIZADO', NULL, 3, 13, 3, '2024-05-26 21:37:21', '2024-05-26 21:37:47');
INSERT INTO `movimientos` VALUES (20, NULL, NULL, NULL, NULL, NULL, NULL, '2024-05-26 21:42:07', '00157-2024', 'ACEPTADO', NULL, 3, 14, 3, '2024-05-26 21:42:07', '2024-05-26 21:42:07');
INSERT INTO `movimientos` VALUES (21, NULL, NULL, NULL, NULL, NULL, NULL, '2024-05-26 21:43:15', '00158-2024', 'ACEPTADO', NULL, 3, 15, 3, '2024-05-26 21:43:15', '2024-05-26 21:43:15');
INSERT INTO `movimientos` VALUES (22, 2, 'storage/cargos/CARGO_FINALIZAR_2_2024-05-26_21-50-07.pdf', NULL, NULL, NULL, NULL, '2024-05-26 21:50:07', '00159-2024', 'FINALIZADO', NULL, 3, 16, 3, '2024-05-26 21:46:33', '2024-05-26 21:50:14');
INSERT INTO `movimientos` VALUES (23, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-27_15-19-53.pdf', 'S/N', '4', 'INFORME 0001-2024-YF-DF', 'ADSAS', '2024-05-27 15:19:53', '00009-2024', 'DERIVADO', NULL, 2, 12, 2, '2024-05-27 15:17:17', '2024-05-27 15:19:55');
INSERT INTO `movimientos` VALUES (24, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-27_15-19-39.pdf', 'S/N', '4', 'INFORME 0001-2024-YF-DF', 'ADSAS', '2024-05-27 15:19:39', '00010-2024', 'DERIVADO', NULL, 2, 11, 2, '2024-05-27 15:17:26', '2024-05-27 15:19:41');
INSERT INTO `movimientos` VALUES (25, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-27_15-19-22.pdf', 'S/N', '2', 'INFORME 0001-2024-YF-DF', 'DS', '2024-05-27 15:19:22', '00011-2024', 'DERIVADO', NULL, 2, 10, 2, '2024-05-27 15:17:31', '2024-05-27 15:19:24');
INSERT INTO `movimientos` VALUES (26, 2, 'storage/cargos/CARGO_DERIVAR_2_2024-05-28_22-21-02.pdf', 'S/N', '4', 'INFORME 0001-2024-YF-DF', 'SFSDF', '2024-05-28 22:21:01', '00015-2024', 'DERIVADO', NULL, 2, 17, 2, '2024-05-28 16:30:15', '2024-05-28 22:21:07');
INSERT INTO `movimientos` VALUES (27, NULL, 'storage/cargos/CARGO_ARCHIVAR__2024-06-10_09-43-09.pdf', NULL, NULL, NULL, 'SE ANTEDIO AL USUARIO', '2024-06-10 09:43:09', '00013-2024', 'ARCHIVADO', NULL, 2, 9, 2, '2024-05-28 22:18:12', '2024-06-10 09:43:14');
INSERT INTO `movimientos` VALUES (28, NULL, 'storage/cargos/CARGO_ARCHIVAR__2024-06-10_09-41-34.pdf', NULL, NULL, NULL, 'SE ANTEDIO AL USUARIO', '2024-06-10 09:41:34', '00014-2024', 'ARCHIVADO', NULL, 2, 8, 2, '2024-05-28 22:18:18', '2024-06-10 09:41:39');
INSERT INTO `movimientos` VALUES (29, NULL, NULL, NULL, NULL, NULL, NULL, '2024-05-28 23:15:12', NULL, 'ELIMINADO', NULL, 2, 20, 2, '2024-05-28 23:15:12', '2024-05-28 23:15:12');
INSERT INTO `movimientos` VALUES (30, NULL, NULL, NULL, NULL, NULL, NULL, '2024-05-28 23:20:06', NULL, 'ELIMINADO', NULL, 2, 19, 2, '2024-05-28 23:20:06', '2024-05-28 23:20:06');
INSERT INTO `movimientos` VALUES (31, NULL, NULL, NULL, NULL, NULL, NULL, '2024-05-28 23:20:33', NULL, 'ELIMINADO', NULL, 2, 18, 2, '2024-05-28 23:20:33', '2024-05-28 23:20:33');
INSERT INTO `movimientos` VALUES (32, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-31_10-36-16.pdf', 'S/N', '5', 'INFORME 0001-2024-YF-DF', 'ADSAS', '2024-05-31 10:36:16', '00009-2024', 'DERIVADO', NULL, 3, 11, 5, '2024-05-31 10:34:21', '2024-05-31 10:36:18');
INSERT INTO `movimientos` VALUES (33, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-05-31_10-35-40.pdf', 'S/N', '4', 'INFORME 0001-2024-YF-DF', 'ADSAS', '2024-05-31 10:35:40', '00150-2024', 'DERIVADO', NULL, 3, 12, 5, '2024-05-31 10:34:52', '2024-05-31 10:35:42');
INSERT INTO `movimientos` VALUES (34, 1, 'storage/cargos/CARGO_FINALIZAR_1_2024-06-10_09-48-46.pdf', 'S/N', '2', 'INFORME 0001-2024-YF-DF', 'PROEBADNOI JAVASCRIPT', '2024-06-10 09:48:46', '00012-2024', 'FINALIZADO', NULL, 2, 21, 2, '2024-06-05 15:03:28', '2024-06-10 09:48:52');
INSERT INTO `movimientos` VALUES (35, NULL, 'storage/cargos/CARGO_ARCHIVAR__2024-06-10_09-44-16.pdf', NULL, NULL, NULL, 'SE ANTEDIO AL USUARIO', '2024-06-10 09:44:15', '0013-2024', 'ARCHIVADO', NULL, 2, 22, 2, '2024-06-05 15:08:33', '2024-06-10 09:44:21');
INSERT INTO `movimientos` VALUES (36, NULL, 'storage/cargos/CARGO_ARCHIVAR__2024-06-10_09-42-30.pdf', NULL, NULL, NULL, 'SE ANTEDIO AL USUARIO', '2024-06-10 09:42:30', '0014-2024', 'ARCHIVADO', NULL, 2, 23, 2, '2024-06-05 15:16:27', '2024-06-10 09:42:35');
INSERT INTO `movimientos` VALUES (37, NULL, 'storage/cargos/CARGO_ARCHIVAR__2024-06-10_09-40-08.pdf', NULL, NULL, NULL, 'SE ANTEDIO AL USUARIO', '2024-06-10 09:40:08', '00016-2024', 'ARCHIVADO', NULL, 2, 24, 2, '2024-06-05 15:20:23', '2024-06-10 09:40:13');
INSERT INTO `movimientos` VALUES (38, NULL, 'storage/cargos/CARGO_ARCHIVAR__2024-06-10_09-36-55.pdf', NULL, NULL, NULL, 'SE ANTEDIO AL USUARIO', '2024-06-10 09:36:55', '00017-2024', 'ARCHIVADO', NULL, 2, 25, 2, '2024-06-05 15:21:01', '2024-06-10 09:37:00');
INSERT INTO `movimientos` VALUES (39, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-06-10_09-49-22.pdf', 'S/N', '5', 'INFORME 0001-2024-YF-DF', 'ADSAS', '2024-06-10 09:49:22', '00018-2024', 'DERIVADO', NULL, 2, 11, 2, '2024-06-10 09:49:06', '2024-06-10 09:49:28');
INSERT INTO `movimientos` VALUES (40, 1, NULL, NULL, NULL, NULL, NULL, '2024-08-05 14:38:14', '00020-2024', 'DERIVADO', NULL, 2, 26, 2, '2024-06-11 17:38:25', '2024-08-05 14:38:14');
INSERT INTO `movimientos` VALUES (41, 1, NULL, NULL, NULL, NULL, NULL, '2024-08-05 14:38:14', '00021-2024', 'DERIVADO', NULL, 2, 31, 2, '2024-06-18 11:17:06', '2024-08-05 14:38:14');
INSERT INTO `movimientos` VALUES (42, 1, NULL, NULL, NULL, NULL, NULL, '2024-08-05 14:37:54', '00022-2024', 'DERIVADO', NULL, 2, 30, 2, '2024-06-18 11:17:10', '2024-08-05 14:37:54');
INSERT INTO `movimientos` VALUES (43, 2, NULL, NULL, NULL, NULL, NULL, '2024-08-05 14:34:29', '00023-2024', 'DERIVADO', NULL, 2, 29, 2, '2024-06-18 11:17:15', '2024-08-05 14:34:29');
INSERT INTO `movimientos` VALUES (44, 2, NULL, NULL, NULL, NULL, NULL, '2024-08-05 14:34:29', '00024-2024', 'DERIVADO', NULL, 2, 28, 2, '2024-06-18 11:17:22', '2024-08-05 14:34:29');
INSERT INTO `movimientos` VALUES (45, 2, NULL, NULL, NULL, NULL, NULL, '2024-08-05 14:34:09', '00025-2024', 'DERIVADO', NULL, 2, 27, 2, '2024-06-18 11:17:28', '2024-08-05 14:34:09');
INSERT INTO `movimientos` VALUES (46, 2, 'storage/cargos/CARGO_DERIVAR_2_2024-06-19_14-02-32.pdf', 'S/N', '4', 'INFORME 0001-2024-YF-DF', 'SFSDF', '2024-06-19 14:02:32', '00160-2024', 'DERIVADO', NULL, 3, 17, 3, '2024-06-19 14:00:24', '2024-06-19 14:02:38');
INSERT INTO `movimientos` VALUES (47, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-06-19_14-02-07.pdf', 'S/N', '2', 'INFORME 0001-2024-YF-DF', 'DS', '2024-06-19 14:02:07', '00161-2024', 'DERIVADO', NULL, 3, 10, 3, '2024-06-19 14:00:31', '2024-06-19 14:02:13');
INSERT INTO `movimientos` VALUES (48, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-06-19_14-01-42.pdf', 'S/N', '5', 'INFORME 0001-2024-YF-DF', 'ADSAS', '2024-06-19 14:01:42', '00162-2024', 'RECHAZADO', NULL, 3, 11, 3, '2024-06-19 14:00:37', '2024-08-19 19:07:39');
INSERT INTO `movimientos` VALUES (49, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-06-19_14-01-19.pdf', 'S/N', '4', 'INFORME 0001-2024-YF-DF', 'ADSAS', '2024-06-19 14:01:19', '00163-2024', 'DERIVADO', NULL, 3, 12, 3, '2024-06-19 14:00:42', '2024-06-19 14:01:26');
INSERT INTO `movimientos` VALUES (50, 2, NULL, NULL, NULL, NULL, NULL, '2024-08-05 14:41:02', '12-2024', 'DERIVADO', NULL, 2, 32, 2, '2024-08-05 14:40:46', '2024-08-05 14:41:02');
INSERT INTO `movimientos` VALUES (51, 1, NULL, NULL, NULL, NULL, 'DSVFDGVDFGVDF', '2024-08-05 14:52:32', '00026-2024', 'DERIVADO', NULL, 2, 34, 2, '2024-08-05 14:51:05', '2024-08-05 14:52:32');
INSERT INTO `movimientos` VALUES (52, 1, NULL, NULL, NULL, NULL, 'DSVFDGVDFGVDF', '2024-08-05 14:52:32', '00027-2024', 'DERIVADO', NULL, 2, 33, 2, '2024-08-05 14:51:11', '2024-08-05 14:52:32');
INSERT INTO `movimientos` VALUES (53, 2, NULL, NULL, NULL, NULL, 'DFGFDGFDG', '2024-08-05 14:57:02', '00028-2024', 'DERIVADO', NULL, 2, 37, 2, '2024-08-05 14:56:38', '2024-08-05 14:57:02');
INSERT INTO `movimientos` VALUES (54, 2, NULL, NULL, NULL, NULL, 'DFGFDGFDG', '2024-08-05 14:57:02', '00029-2024', 'DERIVADO', NULL, 2, 36, 2, '2024-08-05 14:56:42', '2024-08-05 14:57:02');
INSERT INTO `movimientos` VALUES (55, 2, NULL, NULL, NULL, NULL, 'DFGFDGFDG', '2024-08-05 14:57:02', '00030-2024', 'DERIVADO', NULL, 2, 35, 2, '2024-08-05 14:56:46', '2024-08-05 14:57:02');
INSERT INTO `movimientos` VALUES (56, NULL, 'storage/cargos/CARGO_ARCHIVAR_MULTIPLE_2024-08-05_22-23-06.pdf', NULL, NULL, NULL, 'AAAAAAAAAAAAAAAAAAA', '2024-08-05 22:23:06', '00031-2024', 'ARCHIVADO', NULL, 2, 42, 2, '2024-08-05 14:59:45', '2024-08-05 22:23:09');
INSERT INTO `movimientos` VALUES (57, NULL, NULL, NULL, NULL, NULL, 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ', '2024-08-05 22:17:53', '00032-2024', 'ARCHIVADO', NULL, 2, 41, 2, '2024-08-05 14:59:49', '2024-08-05 22:17:53');
INSERT INTO `movimientos` VALUES (58, NULL, NULL, NULL, NULL, NULL, 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ', '2024-08-05 22:17:52', '00033-2024', 'ARCHIVADO', NULL, 2, 40, 2, '2024-08-05 14:59:54', '2024-08-05 22:17:52');
INSERT INTO `movimientos` VALUES (59, NULL, NULL, NULL, NULL, NULL, 'XXXXXXXXXXXXXXXXXXXX', '2024-08-05 22:13:39', '00034-2024', 'ARCHIVADO', NULL, 2, 39, 2, '2024-08-05 14:59:58', '2024-08-05 22:13:39');
INSERT INTO `movimientos` VALUES (60, NULL, NULL, NULL, NULL, NULL, 'XXXXXXXXXXXXXXXXXXXX', '2024-08-05 22:13:39', '00035-2024', 'ARCHIVADO', NULL, 2, 38, 2, '2024-08-05 15:00:01', '2024-08-05 22:13:39');
INSERT INTO `movimientos` VALUES (61, 2, 'storage/cargos/CARGO_FINALIZAR_2_2024-08-05_23-22-32.pdf', '001', '5', NULL, 'SOLIICITAMOOOOOOOOOOOOOOOOOOOS', '2024-08-05 23:22:32', '00036-2024', 'DERIVADO', NULL, 2, 46, 2, '2024-08-05 22:27:21', '2024-08-05 23:22:34');
INSERT INTO `movimientos` VALUES (62, 2, 'storage/cargos/CARGO_FINALIZAR_2_2024-08-05_23-22-32.pdf', '001', '5', NULL, 'SOLIICITAMOOOOOOOOOOOOOOOOOOOS', '2024-08-05 23:22:32', '00037-2024', 'DERIVADO', NULL, 2, 45, 2, '2024-08-05 22:27:26', '2024-08-05 23:22:34');
INSERT INTO `movimientos` VALUES (63, NULL, 'storage/cargos/CARGO_ARCHIVAR_MULTIPLE_2024-08-05_22-27-50.pdf', NULL, NULL, NULL, 'BBBB', '2024-08-05 22:27:50', '00038-2024', 'ARCHIVADO', NULL, 2, 44, 2, '2024-08-05 22:27:30', '2024-08-05 22:27:53');
INSERT INTO `movimientos` VALUES (64, NULL, 'storage/cargos/CARGO_ARCHIVAR_MULTIPLE_2024-08-05_22-27-50.pdf', NULL, NULL, NULL, 'BBBB', '2024-08-05 22:27:50', '00039-2024', 'ARCHIVADO', NULL, 2, 43, 2, '2024-08-05 22:27:36', '2024-08-05 22:27:53');
INSERT INTO `movimientos` VALUES (65, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-06 11:03:33', '00040-2024', 'ACEPTADO', NULL, 2, 48, 2, '2024-08-06 11:03:33', '2024-08-06 11:03:33');
INSERT INTO `movimientos` VALUES (66, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-06 11:03:41', '00041-2024', 'ACEPTADO', NULL, 2, 47, 2, '2024-08-06 11:03:41', '2024-08-06 11:03:41');
INSERT INTO `movimientos` VALUES (67, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-09-09_13-29-21.pdf', NULL, NULL, NULL, NULL, '2024-09-09 13:29:21', '00048-2024', 'RECHAZADO', NULL, 2, 53, 2, '2024-08-06 15:35:21', '2024-09-09 13:51:09');
INSERT INTO `movimientos` VALUES (68, 1, 'storage/cargos/CARGO_FINALIZAR_1_2024-08-12_23-25-03.pdf', NULL, NULL, NULL, 'PARA SU CONOCIIENTO Y ATENCION', '2024-08-12 23:25:03', '00043-2024', 'DERIVADO', NULL, 2, 54, 2, '2024-08-06 15:38:54', '2024-08-12 23:25:08');
INSERT INTO `movimientos` VALUES (69, 1, 'storage/cargos/CARGO_FINALIZAR_1_2024-08-12_23-25-03.pdf', NULL, NULL, NULL, 'PARA SU CONOCIIENTO Y ATENCION', '2024-08-12 23:25:03', '00044-2024', 'DERIVADO', NULL, 2, 55, 2, '2024-08-06 15:40:16', '2024-08-12 23:25:08');
INSERT INTO `movimientos` VALUES (70, 2, 'storage/cargos/CARGO_DERIVAR_2_2024-08-06_16-00-17.pdf', 'S/N', '4', 'INFORME 0001-2024-YF-DF', 'SFSDF', '2024-08-06 16:00:17', '00045-2024', 'DERIVADO', NULL, 2, 17, 2, '2024-08-06 15:58:23', '2024-08-06 16:00:22');
INSERT INTO `movimientos` VALUES (71, 1, 'storage/cargos/CARGO_FINALIZAR_1_2024-08-12_23-25-03.pdf', NULL, NULL, NULL, 'PARA SU CONOCIIENTO Y ATENCION', '2024-08-12 23:25:03', '00046-2024', 'DERIVADO', NULL, 2, 59, 2, '2024-08-06 17:18:51', '2024-08-12 23:25:08');
INSERT INTO `movimientos` VALUES (72, 1, 'storage/cargos/CARGO_DERIVAR_1_2024-08-12_23-23-03.pdf', 'S/N', '1', '-', 'PARA SU CONOCIIENTO Y ATENCION', '2024-08-12 23:23:03', '00047-2024', 'DERIVADO', NULL, 2, 60, 2, '2024-08-12 23:20:49', '2024-08-12 23:23:05');
INSERT INTO `movimientos` VALUES (73, 2, 'storage/cargos/CARGO_DERIVAR_2_2024-08-12_23-34-20.pdf', '001', '2', NULL, 'PARA SU CONOCIIENTO Y ATENCION', '2024-08-12 23:34:20', '00164-2024', 'DERIVADO', NULL, 3, 60, 3, '2024-08-12 23:33:18', '2024-08-12 23:34:22');
INSERT INTO `movimientos` VALUES (74, 2, 'storage/cargos/CARGO_DERIVAR_2_2024-08-19_19-10-31.pdf', NULL, NULL, NULL, 'DDSFSDF', '2024-08-19 19:10:31', '00049-2024', 'DERIVADO', NULL, 2, 10, 2, '2024-08-19 19:07:23', '2024-08-19 19:10:36');
INSERT INTO `movimientos` VALUES (75, NULL, NULL, NULL, NULL, NULL, NULL, '2024-09-08 11:00:25', 'ORP00001-2024', 'ACEPTADO', NULL, 2, 61, 2, '2024-09-08 11:00:27', '2024-09-08 11:00:27');
INSERT INTO `movimientos` VALUES (76, NULL, NULL, NULL, NULL, NULL, NULL, '2024-09-08 11:23:39', 'ORP00002-2024', 'ACEPTADO', NULL, 2, 62, 2, '2024-09-08 11:23:41', '2024-09-08 11:23:41');
INSERT INTO `movimientos` VALUES (78, NULL, NULL, NULL, NULL, NULL, NULL, '2024-09-22 15:57:59', '00050-2024', 'ACEPTADO', NULL, 2, 65, 2, '2024-09-22 15:58:02', '2024-09-22 15:58:02');
INSERT INTO `movimientos` VALUES (79, NULL, NULL, NULL, NULL, NULL, NULL, '2024-12-03 10:59:24', 'OTD00001-2024', 'ACEPTADO', NULL, 2, 66, 2, '2024-12-03 10:59:39', '2024-12-03 10:59:39');
INSERT INTO `movimientos` VALUES (80, NULL, NULL, NULL, NULL, NULL, NULL, '2024-12-03 13:13:11', '00051-2024', 'ACEPTADO', NULL, 2, 67, 2, '2024-12-03 13:13:15', '2024-12-03 13:13:15');
INSERT INTO `movimientos` VALUES (81, NULL, NULL, NULL, NULL, NULL, NULL, '2024-12-03 13:21:29', 'OTD00002-2024', 'ACEPTADO', NULL, 2, 68, 2, '2024-12-03 13:21:33', '2024-12-03 13:21:33');
INSERT INTO `movimientos` VALUES (82, 2, 'storage/cargos/CARGO_DERIVAR_2_2025-01-03_13-58-40.pdf', '12', '12', 'DSFSDF', 'DSFDFDSF', '2025-01-03 13:58:38', '00001-2025', 'DERIVADO', NULL, 2, 70, 2, '2025-01-03 13:36:28', '2025-01-03 13:58:45');

-- ----------------------------
-- Table structure for multiples
-- ----------------------------
CREATE TABLE `multiples`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `expediente_id` bigint UNSIGNED NOT NULL,
  `oficina_id` bigint UNSIGNED NOT NULL,
  `oficina_origen_id` bigint UNSIGNED NOT NULL,
  `empleado_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `multiples_expediente_id_foreign`(`expediente_id` ASC) USING BTREE,
  INDEX `multiples_oficina_id_foreign`(`oficina_id` ASC) USING BTREE,
  INDEX `multiples_oficina_origen_id_foreign`(`oficina_origen_id` ASC) USING BTREE,
  INDEX `multiples_empleado_id_foreign`(`empleado_id` ASC) USING BTREE,
  CONSTRAINT `multiples_empleado_id_foreign` FOREIGN KEY (`empleado_id`) REFERENCES `empleados` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `multiples_expediente_id_foreign` FOREIGN KEY (`expediente_id`) REFERENCES `expedientes` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `multiples_oficina_id_foreign` FOREIGN KEY (`oficina_id`) REFERENCES `oficinas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `multiples_oficina_origen_id_foreign` FOREIGN KEY (`oficina_origen_id`) REFERENCES `oficinas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of multiples
-- ----------------------------

-- ----------------------------
-- Table structure for oficinas
-- ----------------------------
CREATE TABLE `oficinas`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `area_id` bigint UNSIGNED NOT NULL,
  `tipo_oficina` enum('NORMAL','BUZON') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `siglas` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `oficinas_area_id_foreign`(`area_id` ASC) USING BTREE,
  CONSTRAINT `oficinas_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of oficinas
-- ----------------------------
INSERT INTO `oficinas` VALUES (1, 'TECNOLOGIA E INFORMATICA', 1, 'NORMAL', '2024-05-25 17:26:17', '2024-05-25 17:26:20', 'OTI');
INSERT INTO `oficinas` VALUES (2, 'TRAMITE DOCUMENTARIO', 1, 'BUZON', '2024-05-25 17:28:06', '2024-05-25 17:31:06', 'OTD');
INSERT INTO `oficinas` VALUES (3, 'RECURSOS HUMANOS', 1, 'NORMAL', '2024-05-25 17:28:14', '2024-05-25 17:28:14', 'ORH');
INSERT INTO `oficinas` VALUES (4, 'REMUENERACIONES Y PENSIONES', 1, 'NORMAL', '2024-05-25 17:29:12', '2024-05-25 17:29:12', 'ORP');
INSERT INTO `oficinas` VALUES (5, 'PRESUPUESTO Y PLANIFICACION', 1, 'NORMAL', '2024-08-12 23:04:18', '2024-08-12 23:04:18', 'OPP');
INSERT INTO `oficinas` VALUES (6, 'ALMACEN Y PATRIMONIO', 1, 'NORMAL', '2024-08-12 23:08:27', '2024-08-12 23:08:27', 'OAP');

-- ----------------------------
-- Records of personal_access_tokens
-- ----------------------------

-- ----------------------------
-- Table structure for requisitos
-- ----------------------------
CREATE TABLE `requisitos`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `tupa_id` bigint UNSIGNED NOT NULL,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `requisitos_tupa_id_foreign`(`tupa_id` ASC) USING BTREE,
  CONSTRAINT `requisitos_tupa_id_foreign` FOREIGN KEY (`tupa_id`) REFERENCES `tupas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of requisitos
-- ----------------------------
INSERT INTO `requisitos` VALUES (1, 1, 'FORMATA XY', 'storage/requisitos/1723522258_FORMATA XY_1.pdf', '2024-08-12 23:10:58', '2024-08-12 23:10:58');
INSERT INTO `requisitos` VALUES (2, 1, 'MJSCBAMSC', NULL, '2024-08-12 23:11:13', '2024-08-12 23:11:13');
INSERT INTO `requisitos` VALUES (3, 3, 'FOTOCOPIA DE DNO', NULL, '2024-10-21 15:13:52', '2024-10-21 15:13:52');
INSERT INTO `requisitos` VALUES (4, 3, 'PAGO A CAJA MUNICIPAL S/.20.00', NULL, '2024-10-21 15:14:09', '2024-10-21 15:14:09');
INSERT INTO `requisitos` VALUES (5, 3, 'DECLARACION JURADA', 'storage/requisitos/1729541660_DECLARACION JURADA_3.pdf', '2024-10-21 15:14:20', '2024-10-21 15:14:20');

-- ----------------------------
-- Table structure for rutas
-- ----------------------------
CREATE TABLE `rutas`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `expediente_id` bigint UNSIGNED NOT NULL,
  `oficina_origen_id` bigint UNSIGNED NOT NULL,
  `empleado_origen_id` bigint UNSIGNED NULL DEFAULT NULL,
  `estado` enum('PENDIENTE','ACEPTADO','DERIVADO','FINALIZADO','RECHAZADO','ARCHIVADO','ELIMINADO') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha_registro` datetime NOT NULL,
  `ultimo_numero_registro` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `rutas_expediente_id_foreign`(`expediente_id` ASC) USING BTREE,
  INDEX `rutas_oficina_origen_id_foreign`(`oficina_origen_id` ASC) USING BTREE,
  INDEX `rutas_empleado_origen_id_foreign`(`empleado_origen_id` ASC) USING BTREE,
  CONSTRAINT `rutas_empleado_origen_id_foreign` FOREIGN KEY (`empleado_origen_id`) REFERENCES `empleados` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `rutas_expediente_id_foreign` FOREIGN KEY (`expediente_id`) REFERENCES `expedientes` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `rutas_oficina_origen_id_foreign` FOREIGN KEY (`oficina_origen_id`) REFERENCES `oficinas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 254 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of rutas
-- ----------------------------
INSERT INTO `rutas` VALUES (1, 1, 2, 2, 'ACEPTADO', '2024-05-25 17:34:26', '0001-2024', '2024-05-25 17:34:32', '2024-05-25 17:34:32');
INSERT INTO `rutas` VALUES (2, 2, 2, 2, 'ACEPTADO', '2024-05-25 17:35:12', '0002-2024', '2024-05-25 17:35:17', '2024-05-25 17:35:17');
INSERT INTO `rutas` VALUES (3, 3, 2, 2, 'ACEPTADO', '2024-05-25 17:35:43', '0003-2024', '2024-05-25 17:35:49', '2024-05-25 17:35:49');
INSERT INTO `rutas` VALUES (4, 3, 2, 2, 'DERIVADO', '2024-05-25 17:36:29', NULL, '2024-05-25 17:36:36', '2024-05-25 17:36:36');
INSERT INTO `rutas` VALUES (5, 3, 3, 3, 'PENDIENTE', '2024-05-25 17:36:29', NULL, '2024-05-25 17:36:36', '2024-05-25 17:36:36');
INSERT INTO `rutas` VALUES (6, 2, 2, 2, 'DERIVADO', '2024-05-25 17:38:01', NULL, '2024-05-25 17:38:07', '2024-05-25 17:38:07');
INSERT INTO `rutas` VALUES (7, 2, 3, 3, 'PENDIENTE', '2024-05-25 17:38:01', NULL, '2024-05-25 17:38:07', '2024-05-25 17:38:07');
INSERT INTO `rutas` VALUES (8, 1, 2, 2, 'DERIVADO', '2024-05-25 17:38:24', NULL, '2024-05-25 17:38:30', '2024-05-25 17:38:30');
INSERT INTO `rutas` VALUES (9, 1, 3, 3, 'PENDIENTE', '2024-05-25 17:38:24', NULL, '2024-05-25 17:38:30', '2024-05-25 17:38:30');
INSERT INTO `rutas` VALUES (10, 3, 3, 3, 'ACEPTADO', '2024-05-25 17:39:15', '150-2024', '2024-05-25 17:39:15', '2024-05-25 17:39:15');
INSERT INTO `rutas` VALUES (11, 2, 3, 3, 'ACEPTADO', '2024-05-25 17:39:23', '151-2024', '2024-05-25 17:39:23', '2024-05-25 17:39:23');
INSERT INTO `rutas` VALUES (12, 1, 3, 3, 'ACEPTADO', '2024-05-25 17:39:31', '152-2024', '2024-05-25 17:39:31', '2024-05-25 17:39:31');
INSERT INTO `rutas` VALUES (13, 1, 3, 3, 'DERIVADO', '2024-05-25 17:39:48', NULL, '2024-05-25 17:39:51', '2024-05-25 17:39:51');
INSERT INTO `rutas` VALUES (14, 1, 4, 4, 'PENDIENTE', '2024-05-25 17:39:48', NULL, '2024-05-25 17:39:51', '2024-05-25 17:39:51');
INSERT INTO `rutas` VALUES (15, 2, 3, 3, 'FINALIZADO', '2024-05-25 17:40:04', NULL, '2024-05-25 17:40:07', '2024-05-25 17:40:07');
INSERT INTO `rutas` VALUES (16, 3, 3, 3, 'ARCHIVADO', '2024-05-25 17:40:19', NULL, '2024-05-25 17:40:21', '2024-05-25 17:40:21');
INSERT INTO `rutas` VALUES (17, 4, 2, 2, 'ACEPTADO', '2024-05-25 19:57:02', '0004-2024', '2024-05-25 19:57:09', '2024-05-25 19:57:09');
INSERT INTO `rutas` VALUES (18, 4, 2, 2, 'DERIVADO', '2024-05-25 19:58:10', NULL, '2024-05-25 19:58:16', '2024-05-25 19:58:16');
INSERT INTO `rutas` VALUES (19, 4, 3, 3, 'PENDIENTE', '2024-05-25 19:58:10', NULL, '2024-05-25 19:58:16', '2024-05-25 19:58:16');
INSERT INTO `rutas` VALUES (20, 4, 3, 3, 'ACEPTADO', '2024-05-25 20:36:20', '153-2024', '2024-05-25 20:36:20', '2024-05-25 20:36:20');
INSERT INTO `rutas` VALUES (21, 4, 3, 3, 'DERIVADO', '2024-05-25 20:36:40', NULL, '2024-05-25 20:36:44', '2024-05-25 20:36:44');
INSERT INTO `rutas` VALUES (22, 4, 4, 4, 'PENDIENTE', '2024-05-25 20:36:40', NULL, '2024-05-25 20:36:44', '2024-05-25 20:36:44');
INSERT INTO `rutas` VALUES (23, 4, 4, 4, 'ACEPTADO', '2024-05-25 20:37:36', '00001-2024', '2024-05-25 20:37:36', '2024-05-25 20:37:36');
INSERT INTO `rutas` VALUES (24, 1, 4, 4, 'ACEPTADO', '2024-05-25 20:40:22', '00002-2024', '2024-05-25 20:40:22', '2024-05-25 20:40:22');
INSERT INTO `rutas` VALUES (25, 1, 4, 4, 'DERIVADO', '2024-05-25 20:40:39', NULL, '2024-05-25 20:40:44', '2024-05-25 20:40:44');
INSERT INTO `rutas` VALUES (26, 1, 3, 3, 'PENDIENTE', '2024-05-25 20:40:39', NULL, '2024-05-25 20:40:44', '2024-05-25 20:40:44');
INSERT INTO `rutas` VALUES (27, 4, 4, 4, 'DERIVADO', '2024-05-25 20:41:11', NULL, '2024-05-25 20:41:15', '2024-05-25 20:41:15');
INSERT INTO `rutas` VALUES (28, 4, 3, 3, 'PENDIENTE', '2024-05-25 20:41:11', NULL, '2024-05-25 20:41:15', '2024-05-25 20:41:15');
INSERT INTO `rutas` VALUES (29, 4, 3, 3, 'ACEPTADO', '2024-05-25 20:44:01', '00154-2024', '2024-05-25 20:44:01', '2024-05-25 20:44:01');
INSERT INTO `rutas` VALUES (30, 1, 3, 3, 'ACEPTADO', '2024-05-25 20:44:13', '00155-2024', '2024-05-25 20:44:13', '2024-05-25 20:44:13');
INSERT INTO `rutas` VALUES (31, 1, 3, 3, 'DERIVADO', '2024-05-25 21:17:49', NULL, '2024-05-25 21:17:51', '2024-05-25 21:17:51');
INSERT INTO `rutas` VALUES (32, 1, 4, 4, 'PENDIENTE', '2024-05-25 21:17:49', NULL, '2024-05-25 21:17:51', '2024-05-25 21:17:51');
INSERT INTO `rutas` VALUES (33, 4, 3, 3, 'DERIVADO', '2024-05-25 21:18:07', NULL, '2024-05-25 21:18:09', '2024-05-25 21:18:09');
INSERT INTO `rutas` VALUES (34, 4, 4, 4, 'PENDIENTE', '2024-05-25 21:18:07', NULL, '2024-05-25 21:18:09', '2024-05-25 21:18:09');
INSERT INTO `rutas` VALUES (35, 4, 4, 4, 'ACEPTADO', '2024-05-25 21:27:58', '00003-2024', '2024-05-25 21:27:58', '2024-05-25 21:27:58');
INSERT INTO `rutas` VALUES (36, 1, 4, 4, 'ACEPTADO', '2024-05-25 21:35:10', '00004-2024', '2024-05-25 21:35:10', '2024-05-25 21:35:10');
INSERT INTO `rutas` VALUES (37, 5, 2, 2, 'PENDIENTE', '2024-05-25 21:35:56', NULL, '2024-05-25 21:36:00', '2024-05-25 21:36:00');
INSERT INTO `rutas` VALUES (38, 6, 2, 2, 'PENDIENTE', '2024-05-25 21:37:02', NULL, '2024-05-25 21:37:05', '2024-05-25 21:37:05');
INSERT INTO `rutas` VALUES (39, 7, 2, 2, 'PENDIENTE', '2024-05-25 22:02:19', NULL, '2024-05-25 22:02:22', '2024-05-25 22:02:22');
INSERT INTO `rutas` VALUES (40, 8, 2, 2, 'PENDIENTE', '2024-05-25 22:02:36', '00014-2024', '2024-05-25 22:02:39', '2024-05-29 12:42:44');
INSERT INTO `rutas` VALUES (41, 9, 2, 2, 'PENDIENTE', '2024-05-25 22:03:09', NULL, '2024-05-25 22:03:12', '2024-05-25 22:03:12');
INSERT INTO `rutas` VALUES (42, 10, 2, 2, 'PENDIENTE', '2024-05-25 22:07:20', NULL, '2024-05-25 22:07:23', '2024-05-25 22:07:23');
INSERT INTO `rutas` VALUES (43, 11, 2, 2, 'PENDIENTE', '2024-05-25 22:08:05', NULL, '2024-05-25 22:08:07', '2024-05-25 22:08:07');
INSERT INTO `rutas` VALUES (44, 12, 2, 2, 'PENDIENTE', '2024-05-25 22:10:47', NULL, '2024-05-25 22:10:50', '2024-05-25 22:10:50');
INSERT INTO `rutas` VALUES (45, 13, 2, 2, 'PENDIENTE', '2024-05-25 22:11:29', NULL, '2024-05-25 22:11:32', '2024-05-25 22:11:32');
INSERT INTO `rutas` VALUES (46, 14, 2, 2, 'PENDIENTE', '2024-05-25 22:13:13', NULL, '2024-05-25 22:13:16', '2024-05-25 22:13:16');
INSERT INTO `rutas` VALUES (47, 15, 2, 2, 'PENDIENTE', '2024-05-25 22:14:59', NULL, '2024-05-25 22:15:02', '2024-05-25 22:15:02');
INSERT INTO `rutas` VALUES (48, 16, 2, 2, 'PENDIENTE', '2024-05-25 22:15:50', NULL, '2024-05-25 22:15:53', '2024-05-25 22:15:53');
INSERT INTO `rutas` VALUES (49, 16, 2, 2, 'ACEPTADO', '2024-05-26 19:39:47', '00005-2024', '2024-05-26 19:39:47', '2024-05-26 19:39:47');
INSERT INTO `rutas` VALUES (50, 15, 2, 2, 'ACEPTADO', '2024-05-26 19:43:17', '00006-2024', '2024-05-26 19:43:17', '2024-05-26 19:43:17');
INSERT INTO `rutas` VALUES (51, 14, 2, 2, 'ACEPTADO', '2024-05-26 19:43:28', '00007-2024', '2024-05-26 19:43:28', '2024-05-26 19:43:28');
INSERT INTO `rutas` VALUES (52, 13, 2, 2, 'ACEPTADO', '2024-05-26 19:44:12', '00008-2024', '2024-05-26 19:44:13', '2024-05-26 19:44:13');
INSERT INTO `rutas` VALUES (53, 13, 2, 2, 'DERIVADO', '2024-05-26 20:29:45', NULL, '2024-05-26 20:29:52', '2024-05-26 20:29:52');
INSERT INTO `rutas` VALUES (54, 13, 3, 3, 'PENDIENTE', '2024-05-26 20:29:45', NULL, '2024-05-26 20:29:52', '2024-05-26 20:29:52');
INSERT INTO `rutas` VALUES (55, 14, 2, 2, 'DERIVADO', '2024-05-26 20:32:24', NULL, '2024-05-26 20:32:30', '2024-05-26 20:32:30');
INSERT INTO `rutas` VALUES (56, 14, 3, 3, 'PENDIENTE', '2024-05-26 20:32:24', NULL, '2024-05-26 20:32:30', '2024-05-26 20:32:30');
INSERT INTO `rutas` VALUES (57, 16, 2, 2, 'DERIVADO', '2024-05-26 21:33:03', NULL, '2024-05-26 21:33:08', '2024-05-26 21:33:08');
INSERT INTO `rutas` VALUES (58, 16, 3, 3, 'PENDIENTE', '2024-05-26 21:33:03', NULL, '2024-05-26 21:33:08', '2024-05-26 21:33:08');
INSERT INTO `rutas` VALUES (59, 15, 2, 2, 'DERIVADO', '2024-05-26 21:36:38', NULL, '2024-05-26 21:36:44', '2024-05-26 21:36:44');
INSERT INTO `rutas` VALUES (60, 15, 3, 3, 'PENDIENTE', '2024-05-26 21:36:38', NULL, '2024-05-26 21:36:44', '2024-05-26 21:36:44');
INSERT INTO `rutas` VALUES (61, 13, 3, 3, 'ACEPTADO', '2024-05-26 21:37:21', '00156-2024', '2024-05-26 21:37:21', '2024-05-26 21:37:21');
INSERT INTO `rutas` VALUES (62, 13, 3, 3, 'FINALIZADO', '2024-05-26 21:37:41', NULL, '2024-05-26 21:37:47', '2024-05-26 21:37:47');
INSERT INTO `rutas` VALUES (63, 14, 3, 3, 'ACEPTADO', '2024-05-26 21:42:07', '00157-2024', '2024-05-26 21:42:07', '2024-05-26 21:42:07');
INSERT INTO `rutas` VALUES (64, 15, 3, 3, 'ACEPTADO', '2024-05-26 21:43:15', '00158-2024', '2024-05-26 21:43:15', '2024-05-26 21:43:15');
INSERT INTO `rutas` VALUES (65, 16, 3, 3, 'ACEPTADO', '2024-05-26 21:46:33', '00159-2024', '2024-05-26 21:46:33', '2024-05-26 21:46:33');
INSERT INTO `rutas` VALUES (66, 16, 3, 3, 'FINALIZADO', '2024-05-26 21:50:07', NULL, '2024-05-26 21:50:14', '2024-05-26 21:50:14');
INSERT INTO `rutas` VALUES (67, 12, 2, 2, 'ACEPTADO', '2024-05-27 15:17:17', '00009-2024', '2024-05-27 15:17:17', '2024-05-27 15:17:17');
INSERT INTO `rutas` VALUES (68, 11, 2, 2, 'ACEPTADO', '2024-05-27 15:17:26', '00010-2024', '2024-05-27 15:17:26', '2024-05-27 15:17:26');
INSERT INTO `rutas` VALUES (69, 10, 2, 2, 'ACEPTADO', '2024-05-27 15:17:31', '00011-2024', '2024-05-27 15:17:31', '2024-05-27 15:17:31');
INSERT INTO `rutas` VALUES (70, 10, 2, 2, 'DERIVADO', '2024-05-27 15:19:22', NULL, '2024-05-27 15:19:24', '2024-05-27 15:19:24');
INSERT INTO `rutas` VALUES (71, 10, 3, 3, 'PENDIENTE', '2024-05-27 15:19:22', NULL, '2024-05-27 15:19:24', '2024-05-27 15:19:24');
INSERT INTO `rutas` VALUES (72, 11, 2, 2, 'DERIVADO', '2024-05-27 15:19:39', NULL, '2024-05-27 15:19:41', '2024-05-27 15:19:41');
INSERT INTO `rutas` VALUES (73, 11, 3, 5, 'PENDIENTE', '2024-05-27 15:19:39', NULL, '2024-05-27 15:19:41', '2024-05-27 15:19:41');
INSERT INTO `rutas` VALUES (74, 12, 2, 2, 'DERIVADO', '2024-05-27 15:19:53', NULL, '2024-05-27 15:19:55', '2024-05-27 15:19:55');
INSERT INTO `rutas` VALUES (75, 12, 3, 5, 'PENDIENTE', '2024-05-27 15:19:53', NULL, '2024-05-27 15:19:55', '2024-05-27 15:19:55');
INSERT INTO `rutas` VALUES (76, 17, 2, 2, 'ACEPTADO', '2024-05-28 16:30:13', '00015-2024', '2024-05-28 16:30:15', '2024-05-28 22:19:32');
INSERT INTO `rutas` VALUES (77, 9, 2, 2, 'ACEPTADO', '2024-05-28 22:18:12', '00013-2024', '2024-05-28 22:18:12', '2024-05-28 22:18:12');
INSERT INTO `rutas` VALUES (78, 8, 2, 2, 'ACEPTADO', '2024-05-28 22:18:18', '00014-2024', '2024-05-28 22:18:18', '2024-05-28 22:18:18');
INSERT INTO `rutas` VALUES (79, 17, 2, 2, 'DERIVADO', '2024-05-28 22:21:01', NULL, '2024-05-28 22:21:07', '2024-05-28 22:21:07');
INSERT INTO `rutas` VALUES (80, 17, 3, 3, 'PENDIENTE', '2024-05-28 22:21:01', NULL, '2024-05-28 22:21:07', '2024-05-28 22:21:07');
INSERT INTO `rutas` VALUES (81, 18, 2, 2, 'PENDIENTE', '2024-05-28 23:13:59', NULL, '2024-05-28 23:14:05', '2024-05-28 23:14:05');
INSERT INTO `rutas` VALUES (82, 19, 2, 2, 'PENDIENTE', '2024-05-28 23:14:23', NULL, '2024-05-28 23:14:28', '2024-05-28 23:14:28');
INSERT INTO `rutas` VALUES (83, 20, 2, 2, 'PENDIENTE', '2024-05-28 23:14:46', NULL, '2024-05-28 23:14:49', '2024-05-28 23:14:49');
INSERT INTO `rutas` VALUES (84, 20, 2, 2, 'ELIMINADO', '2024-05-28 23:15:12', NULL, '2024-05-28 23:15:12', '2024-05-28 23:15:12');
INSERT INTO `rutas` VALUES (85, 19, 2, 2, 'ELIMINADO', '2024-05-28 23:20:06', NULL, '2024-05-28 23:20:06', '2024-05-28 23:20:06');
INSERT INTO `rutas` VALUES (86, 18, 2, 2, 'ELIMINADO', '2024-05-28 23:20:33', NULL, '2024-05-28 23:20:33', '2024-05-28 23:20:33');
INSERT INTO `rutas` VALUES (87, 11, 3, 5, 'ACEPTADO', '2024-05-31 10:34:21', '00009-2024', '2024-05-31 10:34:21', '2024-05-31 10:34:21');
INSERT INTO `rutas` VALUES (88, 12, 3, 5, 'ACEPTADO', '2024-05-31 10:34:52', '00150-2024', '2024-05-31 10:34:52', '2024-05-31 10:34:52');
INSERT INTO `rutas` VALUES (89, 12, 3, 5, 'DERIVADO', '2024-05-31 10:35:40', NULL, '2024-05-31 10:35:42', '2024-05-31 10:35:42');
INSERT INTO `rutas` VALUES (90, 12, 3, 3, 'PENDIENTE', '2024-05-31 10:35:40', NULL, '2024-05-31 10:35:42', '2024-05-31 10:35:42');
INSERT INTO `rutas` VALUES (91, 11, 3, 5, 'DERIVADO', '2024-05-31 10:36:16', NULL, '2024-05-31 10:36:18', '2024-05-31 10:36:18');
INSERT INTO `rutas` VALUES (92, 11, 2, 2, 'PENDIENTE', '2024-05-31 10:36:16', NULL, '2024-05-31 10:36:18', '2024-05-31 10:36:18');
INSERT INTO `rutas` VALUES (93, 21, 2, 2, 'ACEPTADO', '2024-06-05 15:03:26', '00012-2024', '2024-06-05 15:03:28', '2024-06-05 15:03:28');
INSERT INTO `rutas` VALUES (94, 22, 2, 2, 'ACEPTADO', '2024-06-05 15:08:31', '0013-2024', '2024-06-05 15:08:33', '2024-06-05 15:08:33');
INSERT INTO `rutas` VALUES (95, 23, 2, 2, 'ACEPTADO', '2024-06-05 15:16:25', '0014-2024', '2024-06-05 15:16:27', '2024-06-05 15:16:27');
INSERT INTO `rutas` VALUES (96, 24, 2, 2, 'ACEPTADO', '2024-06-05 15:20:21', '00016-2024', '2024-06-05 15:20:23', '2024-06-05 15:20:23');
INSERT INTO `rutas` VALUES (97, 25, 2, 2, 'ACEPTADO', '2024-06-05 15:20:59', '00017-2024', '2024-06-05 15:21:01', '2024-06-05 15:21:01');
INSERT INTO `rutas` VALUES (98, 25, 2, 2, 'ARCHIVADO', '2024-06-10 09:36:55', NULL, '2024-06-10 09:37:00', '2024-06-10 09:37:00');
INSERT INTO `rutas` VALUES (99, 24, 2, 2, 'ARCHIVADO', '2024-06-10 09:40:08', NULL, '2024-06-10 09:40:13', '2024-06-10 09:40:13');
INSERT INTO `rutas` VALUES (100, 8, 2, 2, 'ARCHIVADO', '2024-06-10 09:41:34', NULL, '2024-06-10 09:41:39', '2024-06-10 09:41:39');
INSERT INTO `rutas` VALUES (101, 23, 2, 2, 'ARCHIVADO', '2024-06-10 09:42:30', NULL, '2024-06-10 09:42:35', '2024-06-10 09:42:35');
INSERT INTO `rutas` VALUES (102, 9, 2, 2, 'ARCHIVADO', '2024-06-10 09:43:09', NULL, '2024-06-10 09:43:14', '2024-06-10 09:43:14');
INSERT INTO `rutas` VALUES (103, 22, 2, 2, 'ARCHIVADO', '2024-06-10 09:44:15', NULL, '2024-06-10 09:44:21', '2024-06-10 09:44:21');
INSERT INTO `rutas` VALUES (104, 21, 2, 2, 'FINALIZADO', '2024-06-10 09:48:46', NULL, '2024-06-10 09:48:52', '2024-06-10 09:48:52');
INSERT INTO `rutas` VALUES (105, 11, 2, 2, 'ACEPTADO', '2024-06-10 09:49:06', '00018-2024', '2024-06-10 09:49:06', '2024-06-10 09:49:06');
INSERT INTO `rutas` VALUES (106, 11, 2, 2, 'DERIVADO', '2024-06-10 09:49:22', NULL, '2024-06-10 09:49:28', '2024-06-10 09:49:28');
INSERT INTO `rutas` VALUES (107, 11, 3, 3, 'PENDIENTE', '2024-06-10 09:49:22', NULL, '2024-06-10 09:49:28', '2024-06-10 09:49:28');
INSERT INTO `rutas` VALUES (108, 26, 2, 2, 'ACEPTADO', '2024-06-11 17:38:23', '00020-2024', '2024-06-11 17:38:25', '2024-06-11 17:38:25');
INSERT INTO `rutas` VALUES (109, 27, 2, 2, 'PENDIENTE', '2024-06-18 11:12:40', NULL, '2024-06-18 11:12:42', '2024-06-18 11:12:42');
INSERT INTO `rutas` VALUES (110, 28, 2, 2, 'PENDIENTE', '2024-06-18 11:15:51', NULL, '2024-06-18 11:15:53', '2024-06-18 11:15:53');
INSERT INTO `rutas` VALUES (111, 29, 2, 2, 'PENDIENTE', '2024-06-18 11:16:11', NULL, '2024-06-18 11:16:13', '2024-06-18 11:16:13');
INSERT INTO `rutas` VALUES (112, 30, 2, 2, 'PENDIENTE', '2024-06-18 11:16:30', NULL, '2024-06-18 11:16:32', '2024-06-18 11:16:32');
INSERT INTO `rutas` VALUES (113, 31, 2, 2, 'PENDIENTE', '2024-06-18 11:16:47', NULL, '2024-06-18 11:16:49', '2024-06-18 11:16:49');
INSERT INTO `rutas` VALUES (114, 31, 2, 2, 'ACEPTADO', '2024-06-18 11:17:06', '00021-2024', '2024-06-18 11:17:06', '2024-06-18 11:17:06');
INSERT INTO `rutas` VALUES (115, 30, 2, 2, 'ACEPTADO', '2024-06-18 11:17:10', '00022-2024', '2024-06-18 11:17:10', '2024-06-18 11:17:10');
INSERT INTO `rutas` VALUES (116, 29, 2, 2, 'ACEPTADO', '2024-06-18 11:17:15', '00023-2024', '2024-06-18 11:17:15', '2024-06-18 11:17:15');
INSERT INTO `rutas` VALUES (117, 28, 2, 2, 'ACEPTADO', '2024-06-18 11:17:22', '00024-2024', '2024-06-18 11:17:22', '2024-06-18 11:17:22');
INSERT INTO `rutas` VALUES (118, 27, 2, 2, 'ACEPTADO', '2024-06-18 11:17:28', '00025-2024', '2024-06-18 11:17:28', '2024-06-18 11:17:28');
INSERT INTO `rutas` VALUES (119, 17, 3, 3, 'ACEPTADO', '2024-06-19 14:00:24', '00160-2024', '2024-06-19 14:00:24', '2024-06-19 14:00:24');
INSERT INTO `rutas` VALUES (120, 10, 3, 3, 'ACEPTADO', '2024-06-19 14:00:31', '00161-2024', '2024-06-19 14:00:31', '2024-06-19 14:00:31');
INSERT INTO `rutas` VALUES (121, 11, 3, 3, 'ACEPTADO', '2024-06-19 14:00:37', '00162-2024', '2024-06-19 14:00:37', '2024-06-19 14:00:37');
INSERT INTO `rutas` VALUES (122, 12, 3, 3, 'ACEPTADO', '2024-06-19 14:00:42', '00163-2024', '2024-06-19 14:00:42', '2024-06-19 14:00:42');
INSERT INTO `rutas` VALUES (123, 12, 3, 3, 'DERIVADO', '2024-06-19 14:01:19', NULL, '2024-06-19 14:01:26', '2024-06-19 14:01:26');
INSERT INTO `rutas` VALUES (124, 12, 2, 2, 'PENDIENTE', '2024-06-19 14:01:19', NULL, '2024-06-19 14:01:26', '2024-06-19 14:01:26');
INSERT INTO `rutas` VALUES (125, 11, 3, 3, 'DERIVADO', '2024-06-19 14:01:42', NULL, '2024-06-19 14:01:48', '2024-06-19 14:01:48');
INSERT INTO `rutas` VALUES (126, 11, 2, 2, 'PENDIENTE', '2024-06-19 14:01:42', NULL, '2024-06-19 14:01:48', '2024-06-19 14:01:48');
INSERT INTO `rutas` VALUES (127, 10, 3, 3, 'DERIVADO', '2024-06-19 14:02:07', NULL, '2024-06-19 14:02:13', '2024-06-19 14:02:13');
INSERT INTO `rutas` VALUES (128, 10, 2, 2, 'PENDIENTE', '2024-06-19 14:02:07', NULL, '2024-06-19 14:02:13', '2024-06-19 14:02:13');
INSERT INTO `rutas` VALUES (129, 17, 3, 3, 'DERIVADO', '2024-06-19 14:02:32', NULL, '2024-06-19 14:02:38', '2024-06-19 14:02:38');
INSERT INTO `rutas` VALUES (130, 17, 2, 2, 'PENDIENTE', '2024-06-19 14:02:32', NULL, '2024-06-19 14:02:38', '2024-06-19 14:02:38');
INSERT INTO `rutas` VALUES (131, 27, 2, 2, 'FINALIZADO', '2024-08-05 14:33:22', NULL, '2024-08-05 14:33:22', '2024-08-05 14:33:22');
INSERT INTO `rutas` VALUES (132, 27, 2, 2, 'FINALIZADO', '2024-08-05 14:34:09', NULL, '2024-08-05 14:34:09', '2024-08-05 14:34:09');
INSERT INTO `rutas` VALUES (133, 28, 2, 2, 'FINALIZADO', '2024-08-05 14:34:29', NULL, '2024-08-05 14:34:29', '2024-08-05 14:34:29');
INSERT INTO `rutas` VALUES (134, 29, 2, 2, 'FINALIZADO', '2024-08-05 14:34:29', NULL, '2024-08-05 14:34:29', '2024-08-05 14:34:29');
INSERT INTO `rutas` VALUES (135, 30, 2, 2, 'FINALIZADO', '2024-08-05 14:37:54', NULL, '2024-08-05 14:37:54', '2024-08-05 14:37:54');
INSERT INTO `rutas` VALUES (136, 31, 2, 2, 'FINALIZADO', '2024-08-05 14:38:14', NULL, '2024-08-05 14:38:14', '2024-08-05 14:38:14');
INSERT INTO `rutas` VALUES (137, 26, 2, 2, 'FINALIZADO', '2024-08-05 14:38:14', NULL, '2024-08-05 14:38:14', '2024-08-05 14:38:14');
INSERT INTO `rutas` VALUES (138, 32, 2, 2, 'ACEPTADO', '2024-08-05 14:40:44', '12-2024', '2024-08-05 14:40:46', '2024-08-05 14:40:46');
INSERT INTO `rutas` VALUES (139, 32, 2, 2, 'FINALIZADO', '2024-08-05 14:41:02', NULL, '2024-08-05 14:41:02', '2024-08-05 14:41:02');
INSERT INTO `rutas` VALUES (140, 33, 2, 2, 'PENDIENTE', '2024-08-05 14:50:23', NULL, '2024-08-05 14:50:25', '2024-08-05 14:50:25');
INSERT INTO `rutas` VALUES (141, 34, 2, 2, 'PENDIENTE', '2024-08-05 14:50:47', NULL, '2024-08-05 14:50:49', '2024-08-05 14:50:49');
INSERT INTO `rutas` VALUES (142, 34, 2, 2, 'ACEPTADO', '2024-08-05 14:51:05', '00026-2024', '2024-08-05 14:51:05', '2024-08-05 14:51:05');
INSERT INTO `rutas` VALUES (143, 33, 2, 2, 'ACEPTADO', '2024-08-05 14:51:11', '00027-2024', '2024-08-05 14:51:11', '2024-08-05 14:51:11');
INSERT INTO `rutas` VALUES (144, 33, 2, 2, 'FINALIZADO', '2024-08-05 14:51:24', NULL, '2024-08-05 14:51:24', '2024-08-05 14:51:24');
INSERT INTO `rutas` VALUES (145, 34, 2, 2, 'FINALIZADO', '2024-08-05 14:51:24', NULL, '2024-08-05 14:51:24', '2024-08-05 14:51:24');
INSERT INTO `rutas` VALUES (146, 33, 2, 2, 'FINALIZADO', '2024-08-05 14:51:48', NULL, '2024-08-05 14:51:48', '2024-08-05 14:51:48');
INSERT INTO `rutas` VALUES (147, 34, 2, 2, 'FINALIZADO', '2024-08-05 14:51:48', NULL, '2024-08-05 14:51:48', '2024-08-05 14:51:48');
INSERT INTO `rutas` VALUES (148, 33, 2, 2, 'FINALIZADO', '2024-08-05 14:52:26', NULL, '2024-08-05 14:52:26', '2024-08-05 14:52:26');
INSERT INTO `rutas` VALUES (149, 34, 2, 2, 'FINALIZADO', '2024-08-05 14:52:26', NULL, '2024-08-05 14:52:26', '2024-08-05 14:52:26');
INSERT INTO `rutas` VALUES (150, 33, 2, 2, 'FINALIZADO', '2024-08-05 14:52:32', NULL, '2024-08-05 14:52:32', '2024-08-05 14:52:32');
INSERT INTO `rutas` VALUES (151, 34, 2, 2, 'FINALIZADO', '2024-08-05 14:52:32', NULL, '2024-08-05 14:52:32', '2024-08-05 14:52:32');
INSERT INTO `rutas` VALUES (152, 35, 2, 2, 'PENDIENTE', '2024-08-05 14:55:41', NULL, '2024-08-05 14:55:44', '2024-08-05 14:55:44');
INSERT INTO `rutas` VALUES (153, 36, 2, 2, 'PENDIENTE', '2024-08-05 14:55:57', NULL, '2024-08-05 14:55:59', '2024-08-05 14:55:59');
INSERT INTO `rutas` VALUES (154, 37, 2, 2, 'PENDIENTE', '2024-08-05 14:56:19', NULL, '2024-08-05 14:56:22', '2024-08-05 14:56:22');
INSERT INTO `rutas` VALUES (155, 37, 2, 2, 'ACEPTADO', '2024-08-05 14:56:38', '00028-2024', '2024-08-05 14:56:38', '2024-08-05 14:56:38');
INSERT INTO `rutas` VALUES (156, 36, 2, 2, 'ACEPTADO', '2024-08-05 14:56:42', '00029-2024', '2024-08-05 14:56:42', '2024-08-05 14:56:42');
INSERT INTO `rutas` VALUES (157, 35, 2, 2, 'ACEPTADO', '2024-08-05 14:56:46', '00030-2024', '2024-08-05 14:56:46', '2024-08-05 14:56:46');
INSERT INTO `rutas` VALUES (158, 35, 2, 2, 'FINALIZADO', '2024-08-05 14:57:02', NULL, '2024-08-05 14:57:02', '2024-08-05 14:57:02');
INSERT INTO `rutas` VALUES (159, 36, 2, 2, 'FINALIZADO', '2024-08-05 14:57:02', NULL, '2024-08-05 14:57:02', '2024-08-05 14:57:02');
INSERT INTO `rutas` VALUES (160, 37, 2, 2, 'FINALIZADO', '2024-08-05 14:57:02', NULL, '2024-08-05 14:57:02', '2024-08-05 14:57:02');
INSERT INTO `rutas` VALUES (161, 38, 2, 2, 'PENDIENTE', '2024-08-05 14:58:09', NULL, '2024-08-05 14:58:11', '2024-08-05 14:58:11');
INSERT INTO `rutas` VALUES (162, 39, 2, 2, 'PENDIENTE', '2024-08-05 14:58:25', NULL, '2024-08-05 14:58:27', '2024-08-05 14:58:27');
INSERT INTO `rutas` VALUES (163, 40, 2, 2, 'PENDIENTE', '2024-08-05 14:58:42', NULL, '2024-08-05 14:58:44', '2024-08-05 14:58:44');
INSERT INTO `rutas` VALUES (164, 41, 2, 2, 'PENDIENTE', '2024-08-05 14:59:01', NULL, '2024-08-05 14:59:03', '2024-08-05 14:59:03');
INSERT INTO `rutas` VALUES (165, 42, 2, 2, 'PENDIENTE', '2024-08-05 14:59:18', NULL, '2024-08-05 14:59:20', '2024-08-05 14:59:20');
INSERT INTO `rutas` VALUES (166, 42, 2, 2, 'ACEPTADO', '2024-08-05 14:59:45', '00031-2024', '2024-08-05 14:59:45', '2024-08-05 14:59:45');
INSERT INTO `rutas` VALUES (167, 41, 2, 2, 'ACEPTADO', '2024-08-05 14:59:49', '00032-2024', '2024-08-05 14:59:49', '2024-08-05 14:59:49');
INSERT INTO `rutas` VALUES (168, 40, 2, 2, 'ACEPTADO', '2024-08-05 14:59:54', '00033-2024', '2024-08-05 14:59:54', '2024-08-05 14:59:54');
INSERT INTO `rutas` VALUES (169, 39, 2, 2, 'ACEPTADO', '2024-08-05 14:59:58', '00034-2024', '2024-08-05 14:59:58', '2024-08-05 14:59:58');
INSERT INTO `rutas` VALUES (170, 38, 2, 2, 'ACEPTADO', '2024-08-05 15:00:01', '00035-2024', '2024-08-05 15:00:01', '2024-08-05 15:00:01');
INSERT INTO `rutas` VALUES (171, 38, 2, 2, 'ARCHIVADO', '2024-08-05 22:12:09', NULL, '2024-08-05 22:12:09', '2024-08-05 22:12:09');
INSERT INTO `rutas` VALUES (172, 39, 2, 2, 'ARCHIVADO', '2024-08-05 22:12:09', NULL, '2024-08-05 22:12:09', '2024-08-05 22:12:09');
INSERT INTO `rutas` VALUES (173, 38, 2, 2, 'ARCHIVADO', '2024-08-05 22:12:23', NULL, '2024-08-05 22:12:23', '2024-08-05 22:12:23');
INSERT INTO `rutas` VALUES (174, 39, 2, 2, 'ARCHIVADO', '2024-08-05 22:12:23', NULL, '2024-08-05 22:12:23', '2024-08-05 22:12:23');
INSERT INTO `rutas` VALUES (175, 38, 2, 2, 'ARCHIVADO', '2024-08-05 22:12:28', NULL, '2024-08-05 22:12:28', '2024-08-05 22:12:28');
INSERT INTO `rutas` VALUES (176, 39, 2, 2, 'ARCHIVADO', '2024-08-05 22:12:28', NULL, '2024-08-05 22:12:28', '2024-08-05 22:12:28');
INSERT INTO `rutas` VALUES (177, 38, 2, 2, 'ARCHIVADO', '2024-08-05 22:13:39', NULL, '2024-08-05 22:13:39', '2024-08-05 22:13:39');
INSERT INTO `rutas` VALUES (178, 39, 2, 2, 'ARCHIVADO', '2024-08-05 22:13:39', NULL, '2024-08-05 22:13:39', '2024-08-05 22:13:39');
INSERT INTO `rutas` VALUES (179, 40, 2, 2, 'ARCHIVADO', '2024-08-05 22:17:20', NULL, '2024-08-05 22:17:20', '2024-08-05 22:17:20');
INSERT INTO `rutas` VALUES (180, 41, 2, 2, 'ARCHIVADO', '2024-08-05 22:17:20', NULL, '2024-08-05 22:17:20', '2024-08-05 22:17:20');
INSERT INTO `rutas` VALUES (181, 40, 2, 2, 'ARCHIVADO', '2024-08-05 22:17:52', NULL, '2024-08-05 22:17:53', '2024-08-05 22:17:53');
INSERT INTO `rutas` VALUES (182, 41, 2, 2, 'ARCHIVADO', '2024-08-05 22:17:53', NULL, '2024-08-05 22:17:53', '2024-08-05 22:17:53');
INSERT INTO `rutas` VALUES (183, 42, 2, 2, 'ARCHIVADO', '2024-08-05 22:23:06', NULL, '2024-08-05 22:23:06', '2024-08-05 22:23:06');
INSERT INTO `rutas` VALUES (184, 43, 2, 2, 'PENDIENTE', '2024-08-05 22:25:27', NULL, '2024-08-05 22:25:30', '2024-08-05 22:25:30');
INSERT INTO `rutas` VALUES (185, 44, 2, 2, 'PENDIENTE', '2024-08-05 22:25:51', NULL, '2024-08-05 22:25:54', '2024-08-05 22:25:54');
INSERT INTO `rutas` VALUES (186, 45, 2, 2, 'PENDIENTE', '2024-08-05 22:26:29', NULL, '2024-08-05 22:26:34', '2024-08-05 22:26:34');
INSERT INTO `rutas` VALUES (187, 46, 2, 2, 'PENDIENTE', '2024-08-05 22:26:57', NULL, '2024-08-05 22:27:01', '2024-08-05 22:27:01');
INSERT INTO `rutas` VALUES (188, 46, 2, 2, 'ACEPTADO', '2024-08-05 22:27:21', '00036-2024', '2024-08-05 22:27:21', '2024-08-05 22:27:21');
INSERT INTO `rutas` VALUES (189, 45, 2, 2, 'ACEPTADO', '2024-08-05 22:27:26', '00037-2024', '2024-08-05 22:27:26', '2024-08-05 22:27:26');
INSERT INTO `rutas` VALUES (190, 44, 2, 2, 'ACEPTADO', '2024-08-05 22:27:30', '00038-2024', '2024-08-05 22:27:30', '2024-08-05 22:27:30');
INSERT INTO `rutas` VALUES (191, 43, 2, 2, 'ACEPTADO', '2024-08-05 22:27:36', '00039-2024', '2024-08-05 22:27:36', '2024-08-05 22:27:36');
INSERT INTO `rutas` VALUES (192, 43, 2, 2, 'ARCHIVADO', '2024-08-05 22:27:50', NULL, '2024-08-05 22:27:50', '2024-08-05 22:27:50');
INSERT INTO `rutas` VALUES (193, 44, 2, 2, 'ARCHIVADO', '2024-08-05 22:27:50', NULL, '2024-08-05 22:27:50', '2024-08-05 22:27:50');
INSERT INTO `rutas` VALUES (194, 45, 2, 2, 'DERIVADO', '2024-08-05 23:21:46', NULL, '2024-08-05 23:21:46', '2024-08-05 23:21:46');
INSERT INTO `rutas` VALUES (195, 45, 3, 3, 'PENDIENTE', '2024-08-05 23:21:46', NULL, '2024-08-05 23:21:46', '2024-08-05 23:21:46');
INSERT INTO `rutas` VALUES (196, 46, 2, 2, 'DERIVADO', '2024-08-05 23:21:46', NULL, '2024-08-05 23:21:46', '2024-08-05 23:21:46');
INSERT INTO `rutas` VALUES (197, 46, 3, 3, 'PENDIENTE', '2024-08-05 23:21:46', NULL, '2024-08-05 23:21:46', '2024-08-05 23:21:46');
INSERT INTO `rutas` VALUES (198, 45, 2, 2, 'DERIVADO', '2024-08-05 23:22:32', NULL, '2024-08-05 23:22:32', '2024-08-05 23:22:32');
INSERT INTO `rutas` VALUES (199, 45, 3, 3, 'PENDIENTE', '2024-08-05 23:22:32', NULL, '2024-08-05 23:22:32', '2024-08-05 23:22:32');
INSERT INTO `rutas` VALUES (200, 46, 2, 2, 'DERIVADO', '2024-08-05 23:22:32', NULL, '2024-08-05 23:22:32', '2024-08-05 23:22:32');
INSERT INTO `rutas` VALUES (201, 46, 3, 3, 'PENDIENTE', '2024-08-05 23:22:32', NULL, '2024-08-05 23:22:32', '2024-08-05 23:22:32');
INSERT INTO `rutas` VALUES (202, 47, 2, 2, 'PENDIENTE', '2024-08-06 11:02:25', NULL, '2024-08-06 11:02:33', '2024-08-06 11:02:33');
INSERT INTO `rutas` VALUES (203, 48, 2, 2, 'PENDIENTE', '2024-08-06 11:02:54', NULL, '2024-08-06 11:03:01', '2024-08-06 11:03:01');
INSERT INTO `rutas` VALUES (204, 48, 2, 2, 'ACEPTADO', '2024-08-06 11:03:33', '00040-2024', '2024-08-06 11:03:33', '2024-08-06 11:03:33');
INSERT INTO `rutas` VALUES (205, 47, 2, 2, 'ACEPTADO', '2024-08-06 11:03:41', '00041-2024', '2024-08-06 11:03:41', '2024-08-06 11:03:41');
INSERT INTO `rutas` VALUES (206, 49, 2, 2, 'PENDIENTE', '2024-08-06 15:30:21', NULL, '2024-08-06 15:30:28', '2024-08-06 15:30:28');
INSERT INTO `rutas` VALUES (207, 50, 2, 2, 'PENDIENTE', '2024-08-06 15:30:53', NULL, '2024-08-06 15:31:00', '2024-08-06 15:31:00');
INSERT INTO `rutas` VALUES (208, 51, 2, 2, 'PENDIENTE', '2024-08-06 15:31:26', NULL, '2024-08-06 15:31:34', '2024-08-06 15:31:34');
INSERT INTO `rutas` VALUES (209, 52, 2, 2, 'PENDIENTE', '2024-08-06 15:32:22', NULL, '2024-08-06 15:32:29', '2024-08-06 15:32:29');
INSERT INTO `rutas` VALUES (210, 53, 2, 2, 'ACEPTADO', '2024-08-06 15:35:15', '00048-2024', '2024-08-06 15:35:21', '2024-08-12 23:29:30');
INSERT INTO `rutas` VALUES (211, 54, 2, 2, 'ACEPTADO', '2024-08-06 15:38:49', '00043-2024', '2024-08-06 15:38:54', '2024-08-06 15:38:54');
INSERT INTO `rutas` VALUES (212, 55, 2, 2, 'ACEPTADO', '2024-08-06 15:40:11', '00044-2024', '2024-08-06 15:40:16', '2024-08-06 15:40:16');
INSERT INTO `rutas` VALUES (213, 56, 2, 2, 'PENDIENTE', '2024-08-06 15:54:12', NULL, '2024-08-06 15:54:18', '2024-08-06 15:54:18');
INSERT INTO `rutas` VALUES (214, 57, 2, 2, 'PENDIENTE', '2024-08-06 15:55:09', NULL, '2024-08-06 15:55:15', '2024-08-06 15:55:15');
INSERT INTO `rutas` VALUES (215, 17, 2, 2, 'ACEPTADO', '2024-08-06 15:58:23', '00045-2024', '2024-08-06 15:58:23', '2024-08-06 15:58:23');
INSERT INTO `rutas` VALUES (216, 17, 2, 2, 'DERIVADO', '2024-08-06 16:00:17', NULL, '2024-08-06 16:00:22', '2024-08-06 16:00:22');
INSERT INTO `rutas` VALUES (217, 17, 3, 3, 'PENDIENTE', '2024-08-06 16:00:17', NULL, '2024-08-06 16:00:22', '2024-08-06 16:00:22');
INSERT INTO `rutas` VALUES (218, 58, 2, 2, 'PENDIENTE', '2024-08-06 17:16:43', NULL, '2024-08-06 17:16:45', '2024-08-06 17:16:45');
INSERT INTO `rutas` VALUES (219, 59, 2, 2, 'ACEPTADO', '2024-08-06 17:18:50', '00046-2024', '2024-08-06 17:18:51', '2024-08-06 17:18:51');
INSERT INTO `rutas` VALUES (220, 60, 2, 2, 'PENDIENTE', '2024-08-12 23:13:41', NULL, '2024-08-12 23:13:45', '2024-08-12 23:13:45');
INSERT INTO `rutas` VALUES (221, 60, 2, 2, 'ACEPTADO', '2024-08-12 23:20:49', '00047-2024', '2024-08-12 23:20:49', '2024-08-12 23:20:49');
INSERT INTO `rutas` VALUES (222, 60, 2, 2, 'DERIVADO', '2024-08-12 23:23:03', NULL, '2024-08-12 23:23:05', '2024-08-12 23:23:05');
INSERT INTO `rutas` VALUES (223, 60, 3, 3, 'PENDIENTE', '2024-08-12 23:23:03', NULL, '2024-08-12 23:23:05', '2024-08-12 23:23:05');
INSERT INTO `rutas` VALUES (224, 59, 2, 2, 'DERIVADO', '2024-08-12 23:25:03', NULL, '2024-08-12 23:25:03', '2024-08-12 23:25:03');
INSERT INTO `rutas` VALUES (225, 59, 3, 3, 'PENDIENTE', '2024-08-12 23:25:03', NULL, '2024-08-12 23:25:03', '2024-08-12 23:25:03');
INSERT INTO `rutas` VALUES (226, 55, 2, 2, 'DERIVADO', '2024-08-12 23:25:03', NULL, '2024-08-12 23:25:03', '2024-08-12 23:25:03');
INSERT INTO `rutas` VALUES (227, 55, 3, 3, 'PENDIENTE', '2024-08-12 23:25:03', NULL, '2024-08-12 23:25:03', '2024-08-12 23:25:03');
INSERT INTO `rutas` VALUES (228, 54, 2, 2, 'DERIVADO', '2024-08-12 23:25:03', NULL, '2024-08-12 23:25:03', '2024-08-12 23:25:03');
INSERT INTO `rutas` VALUES (229, 54, 3, 3, 'PENDIENTE', '2024-08-12 23:25:03', NULL, '2024-08-12 23:25:03', '2024-08-12 23:25:03');
INSERT INTO `rutas` VALUES (230, 60, 3, 3, 'ACEPTADO', '2024-08-12 23:33:18', '00164-2024', '2024-08-12 23:33:18', '2024-08-12 23:33:18');
INSERT INTO `rutas` VALUES (231, 60, 3, 3, 'DERIVADO', '2024-08-12 23:34:20', NULL, '2024-08-12 23:34:22', '2024-08-12 23:34:22');
INSERT INTO `rutas` VALUES (232, 60, 4, 4, 'PENDIENTE', '2024-08-12 23:34:20', NULL, '2024-08-12 23:34:22', '2024-08-12 23:34:22');
INSERT INTO `rutas` VALUES (233, 10, 2, 2, 'ACEPTADO', '2024-08-19 19:07:23', '00049-2024', '2024-08-19 19:07:23', '2024-08-19 19:07:23');
INSERT INTO `rutas` VALUES (234, 11, 2, 2, 'RECHAZADO', '2024-08-19 19:07:39', NULL, '2024-08-19 19:07:39', '2024-08-19 19:07:39');
INSERT INTO `rutas` VALUES (235, 10, 2, 2, 'DERIVADO', '2024-08-19 19:10:31', NULL, '2024-08-19 19:10:36', '2024-08-19 19:10:36');
INSERT INTO `rutas` VALUES (236, 10, 3, 3, 'PENDIENTE', '2024-08-19 19:10:31', NULL, '2024-08-19 19:10:36', '2024-08-19 19:10:36');
INSERT INTO `rutas` VALUES (237, 61, 2, 2, 'ACEPTADO', '2024-09-08 11:00:25', 'ORP00001-2024', '2024-09-08 11:00:27', '2024-09-08 11:00:27');
INSERT INTO `rutas` VALUES (238, 62, 2, 2, 'ACEPTADO', '2024-09-08 11:23:39', 'ORP00002-2024', '2024-09-08 11:23:41', '2024-09-08 11:23:41');
INSERT INTO `rutas` VALUES (239, 53, 2, 2, 'DERIVADO', '2024-09-09 13:29:21', NULL, '2024-09-09 13:29:22', '2024-09-09 13:29:22');
INSERT INTO `rutas` VALUES (240, 53, 4, 4, 'PENDIENTE', '2024-09-09 13:29:21', NULL, '2024-09-09 13:29:22', '2024-09-09 13:29:22');
INSERT INTO `rutas` VALUES (242, 53, 4, 4, 'RECHAZADO', '2024-09-09 13:51:09', NULL, '2024-09-09 13:51:09', '2024-09-09 13:51:09');
INSERT INTO `rutas` VALUES (243, 63, 2, 2, 'PENDIENTE', '2024-09-22 15:27:44', NULL, '2024-09-22 15:27:47', '2024-09-22 15:27:47');
INSERT INTO `rutas` VALUES (244, 64, 2, 2, 'PENDIENTE', '2024-09-22 15:43:37', NULL, '2024-09-22 15:43:45', '2024-09-22 15:43:45');
INSERT INTO `rutas` VALUES (245, 65, 2, 2, 'ACEPTADO', '2024-09-22 15:57:59', '00050-2024', '2024-09-22 15:58:02', '2024-09-22 15:58:02');
INSERT INTO `rutas` VALUES (246, 66, 2, 2, 'ACEPTADO', '2024-12-03 10:59:24', 'OTD00001-2024', '2024-12-03 10:59:39', '2024-12-03 10:59:39');
INSERT INTO `rutas` VALUES (247, 67, 2, 2, 'ACEPTADO', '2024-12-03 13:13:11', '00051-2024', '2024-12-03 13:13:15', '2024-12-03 13:13:15');
INSERT INTO `rutas` VALUES (248, 68, 2, 2, 'ACEPTADO', '2024-12-03 13:21:29', 'OTD00002-2024', '2024-12-03 13:21:33', '2024-12-03 13:21:33');
INSERT INTO `rutas` VALUES (249, 69, 2, 2, 'PENDIENTE', '2024-12-03 13:25:11', NULL, '2024-12-03 13:25:16', '2024-12-03 13:25:16');
INSERT INTO `rutas` VALUES (250, 70, 2, 2, 'ACEPTADO', '2025-01-03 13:36:25', '00001-2025', '2025-01-03 13:36:28', '2025-01-03 13:36:28');
INSERT INTO `rutas` VALUES (251, 70, 2, 2, 'DERIVADO', '2025-01-03 13:58:38', NULL, '2025-01-03 13:58:45', '2025-01-03 13:58:45');
INSERT INTO `rutas` VALUES (252, 70, 1, 1, 'PENDIENTE', '2025-01-03 13:58:38', NULL, '2025-01-03 13:58:45', '2025-01-03 13:58:45');
INSERT INTO `rutas` VALUES (253, 71, 2, 2, 'PENDIENTE', '2025-01-06 11:53:15', NULL, '2025-01-06 11:53:25', '2025-01-06 11:53:25');

-- ----------------------------
-- Table structure for tipos
-- ----------------------------
CREATE TABLE `tipos`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tipos
-- ----------------------------
INSERT INTO `tipos` VALUES (1, 'PROVEÍDO', '2024-05-25 17:29:48', '2024-05-25 17:29:48');
INSERT INTO `tipos` VALUES (2, 'INFORME', '2024-05-25 17:29:56', '2024-05-25 17:29:56');

-- ----------------------------
-- Table structure for tupas
-- ----------------------------
CREATE TABLE `tupas`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `estado` enum('ACTIVO','INACTIVO') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tupas
-- ----------------------------
INSERT INTO `tupas` VALUES (1, 'PRUEBA', 'ACTIVO', '2024-08-02 11:02:19', '2024-08-02 11:02:19');
INSERT INTO `tupas` VALUES (2, 'LASKNSLKDV', 'ACTIVO', '2024-08-12 23:10:12', '2024-08-12 23:10:12');
INSERT INTO `tupas` VALUES (3, 'CERTIFICADO DE MATRIMONIO', 'ACTIVO', '2024-10-21 15:13:42', '2024-10-21 15:13:42');

