/*
 Navicat Premium Data Transfer

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

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

 Date: 25/03/2024 14:29:54
*/


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

-- ----------------------------
-- Records of area_destino_envios
-- ----------------------------
INSERT INTO `area_destino_envios` VALUES (1, 2, '2024-03-12 18:21:05', '2024-03-12 18:21:05');

-- ----------------------------
-- Table structure for area_models
-- ----------------------------
CREATE TABLE `area_models`  (
  `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 = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of area_models
-- ----------------------------
INSERT INTO `area_models` VALUES (1, 'INFORMATICA', 'ACTIVO', '2024-03-01 17:25:23', '2024-03-01 17:27:26');
INSERT INTO `area_models` VALUES (2, 'RECURSOS HUMANOS', 'ACTIVO', '2024-03-12 18:16:48', '2024-03-12 18:16:48');

-- ----------------------------
-- Table structure for asistencias
-- ----------------------------
CREATE TABLE `asistencias`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `perosnal_id` bigint UNSIGNED NOT NULL,
  `calendario_id` bigint UNSIGNED NOT NULL,
  `fecha` date NOT NULL,
  `estado` enum('A','I','J','L','P','T','H','F','-') 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,
  INDEX `asistencias_perosnal_id_foreign`(`perosnal_id` ASC) USING BTREE,
  INDEX `asistencias_calendario_id_foreign`(`calendario_id` ASC) USING BTREE,
  CONSTRAINT `asistencias_calendario_id_foreign` FOREIGN KEY (`calendario_id`) REFERENCES `calendarios` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `asistencias_perosnal_id_foreign` FOREIGN KEY (`perosnal_id`) REFERENCES `personals` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 132 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of asistencias
-- ----------------------------
INSERT INTO `asistencias` VALUES (1, 1, 1, '2024-01-01', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (2, 1, 1, '2024-01-02', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (3, 1, 1, '2024-01-03', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (4, 1, 1, '2024-01-04', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (5, 1, 1, '2024-01-05', 'J', '2024-03-13 14:32:07', '2024-03-13 14:49:52');
INSERT INTO `asistencias` VALUES (6, 1, 1, '2024-01-08', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (7, 1, 1, '2024-01-09', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (8, 1, 1, '2024-01-10', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (9, 1, 1, '2024-01-11', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (10, 1, 1, '2024-01-12', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (11, 1, 1, '2024-01-15', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (12, 1, 1, '2024-01-16', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (13, 1, 1, '2024-01-17', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (14, 1, 1, '2024-01-18', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (15, 1, 1, '2024-01-19', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (16, 1, 1, '2024-01-22', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (17, 1, 1, '2024-01-23', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (18, 1, 1, '2024-01-24', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (19, 1, 1, '2024-01-25', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (20, 1, 1, '2024-01-26', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (21, 1, 1, '2024-01-29', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (22, 1, 1, '2024-01-30', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (23, 1, 1, '2024-01-31', 'A', '2024-03-13 14:32:07', '2024-03-13 14:32:07');
INSERT INTO `asistencias` VALUES (24, 1, 2, '2024-02-01', 'A', '2024-03-14 11:40:23', '2024-03-14 11:40:23');
INSERT INTO `asistencias` VALUES (25, 1, 2, '2024-02-02', 'A', '2024-03-14 11:40:23', '2024-03-14 11:40:23');
INSERT INTO `asistencias` VALUES (26, 1, 2, '2024-02-05', 'A', '2024-03-14 11:40:23', '2024-03-14 11:40:23');
INSERT INTO `asistencias` VALUES (27, 1, 2, '2024-02-06', 'A', '2024-03-14 11:40:23', '2024-03-14 11:40:23');
INSERT INTO `asistencias` VALUES (28, 1, 2, '2024-02-07', 'A', '2024-03-14 11:40:23', '2024-03-14 11:40:23');
INSERT INTO `asistencias` VALUES (29, 1, 2, '2024-02-08', 'A', '2024-03-14 11:40:23', '2024-03-14 11:40:23');
INSERT INTO `asistencias` VALUES (30, 1, 2, '2024-02-09', 'A', '2024-03-14 11:40:23', '2024-03-14 11:40:23');
INSERT INTO `asistencias` VALUES (31, 1, 2, '2024-02-12', 'T', '2024-03-14 11:40:23', '2024-03-14 12:09:11');
INSERT INTO `asistencias` VALUES (32, 1, 2, '2024-02-13', 'T', '2024-03-14 11:40:23', '2024-03-14 12:09:15');
INSERT INTO `asistencias` VALUES (33, 1, 2, '2024-02-14', 'T', '2024-03-14 11:40:23', '2024-03-14 12:09:18');
INSERT INTO `asistencias` VALUES (34, 1, 2, '2024-02-15', 'T', '2024-03-14 11:40:23', '2024-03-14 12:09:22');
INSERT INTO `asistencias` VALUES (35, 1, 2, '2024-02-16', 'T', '2024-03-14 11:40:23', '2024-03-14 12:09:24');
INSERT INTO `asistencias` VALUES (36, 1, 2, '2024-02-19', 'A', '2024-03-14 11:40:23', '2024-03-14 11:40:23');
INSERT INTO `asistencias` VALUES (37, 1, 2, '2024-02-20', 'A', '2024-03-14 11:40:23', '2024-03-14 11:40:23');
INSERT INTO `asistencias` VALUES (38, 1, 2, '2024-02-21', 'A', '2024-03-14 11:40:23', '2024-03-14 11:40:23');
INSERT INTO `asistencias` VALUES (39, 1, 2, '2024-02-22', 'A', '2024-03-14 11:40:23', '2024-03-14 11:40:23');
INSERT INTO `asistencias` VALUES (40, 1, 2, '2024-02-23', 'A', '2024-03-14 11:40:23', '2024-03-14 11:40:23');
INSERT INTO `asistencias` VALUES (41, 1, 2, '2024-02-26', 'A', '2024-03-14 11:40:23', '2024-03-14 11:40:23');
INSERT INTO `asistencias` VALUES (42, 1, 2, '2024-02-27', 'A', '2024-03-14 11:40:23', '2024-03-14 11:40:23');
INSERT INTO `asistencias` VALUES (43, 1, 2, '2024-02-28', 'A', '2024-03-14 11:40:23', '2024-03-14 11:40:23');
INSERT INTO `asistencias` VALUES (44, 1, 2, '2024-02-29', 'A', '2024-03-14 11:40:23', '2024-03-14 11:40:23');
INSERT INTO `asistencias` VALUES (45, 1, 3, '2024-03-01', 'A', '2024-03-25 11:16:11', '2024-03-25 11:22:36');
INSERT INTO `asistencias` VALUES (46, 1, 3, '2024-03-04', 'A', '2024-03-25 11:16:11', '2024-03-25 11:16:11');
INSERT INTO `asistencias` VALUES (47, 1, 3, '2024-03-05', 'A', '2024-03-25 11:16:11', '2024-03-25 11:16:11');
INSERT INTO `asistencias` VALUES (48, 1, 3, '2024-03-06', 'A', '2024-03-25 11:16:11', '2024-03-25 11:16:11');
INSERT INTO `asistencias` VALUES (49, 1, 3, '2024-03-07', 'A', '2024-03-25 11:16:11', '2024-03-25 11:16:11');
INSERT INTO `asistencias` VALUES (50, 1, 3, '2024-03-08', 'A', '2024-03-25 11:16:11', '2024-03-25 11:16:11');
INSERT INTO `asistencias` VALUES (51, 1, 3, '2024-03-11', 'A', '2024-03-25 11:16:11', '2024-03-25 11:16:11');
INSERT INTO `asistencias` VALUES (52, 1, 3, '2024-03-12', 'A', '2024-03-25 11:16:12', '2024-03-25 11:16:12');
INSERT INTO `asistencias` VALUES (53, 1, 3, '2024-03-13', 'A', '2024-03-25 11:16:12', '2024-03-25 11:16:12');
INSERT INTO `asistencias` VALUES (54, 1, 3, '2024-03-14', 'A', '2024-03-25 11:16:12', '2024-03-25 11:16:12');
INSERT INTO `asistencias` VALUES (55, 1, 3, '2024-03-15', 'A', '2024-03-25 11:16:12', '2024-03-25 11:16:12');
INSERT INTO `asistencias` VALUES (56, 1, 3, '2024-03-18', 'A', '2024-03-25 11:16:12', '2024-03-25 11:16:12');
INSERT INTO `asistencias` VALUES (57, 1, 3, '2024-03-19', 'A', '2024-03-25 11:16:12', '2024-03-25 11:16:12');
INSERT INTO `asistencias` VALUES (58, 1, 3, '2024-03-20', 'A', '2024-03-25 11:16:12', '2024-03-25 11:16:12');
INSERT INTO `asistencias` VALUES (59, 1, 3, '2024-03-21', 'A', '2024-03-25 11:16:12', '2024-03-25 11:16:12');
INSERT INTO `asistencias` VALUES (60, 1, 3, '2024-03-22', 'A', '2024-03-25 11:16:12', '2024-03-25 11:16:12');
INSERT INTO `asistencias` VALUES (61, 1, 3, '2024-03-25', 'A', '2024-03-25 11:16:12', '2024-03-25 11:16:12');
INSERT INTO `asistencias` VALUES (62, 1, 3, '2024-03-26', 'A', '2024-03-25 11:16:12', '2024-03-25 11:16:12');
INSERT INTO `asistencias` VALUES (63, 1, 3, '2024-03-27', 'A', '2024-03-25 11:16:12', '2024-03-25 11:16:12');
INSERT INTO `asistencias` VALUES (64, 1, 3, '2024-03-28', 'A', '2024-03-25 11:16:12', '2024-03-25 11:16:12');
INSERT INTO `asistencias` VALUES (65, 1, 3, '2024-03-29', 'A', '2024-03-25 11:16:12', '2024-03-25 11:16:12');
INSERT INTO `asistencias` VALUES (69, 1, 4, '2024-04-01', 'A', '2024-03-25 11:26:03', '2024-03-25 11:26:03');
INSERT INTO `asistencias` VALUES (70, 1, 4, '2024-04-02', 'A', '2024-03-25 11:26:03', '2024-03-25 11:26:03');
INSERT INTO `asistencias` VALUES (71, 1, 4, '2024-04-03', 'A', '2024-03-25 11:26:03', '2024-03-25 11:26:03');
INSERT INTO `asistencias` VALUES (72, 1, 4, '2024-04-04', 'A', '2024-03-25 11:26:03', '2024-03-25 11:26:03');
INSERT INTO `asistencias` VALUES (73, 1, 4, '2024-04-05', 'A', '2024-03-25 11:26:03', '2024-03-25 11:26:03');
INSERT INTO `asistencias` VALUES (74, 1, 4, '2024-04-06', 'I', '2024-03-25 11:28:46', '2024-03-25 11:28:55');
INSERT INTO `asistencias` VALUES (75, 1, 4, '2024-04-07', 'I', '2024-03-25 11:28:46', '2024-03-25 11:29:03');
INSERT INTO `asistencias` VALUES (76, 1, 4, '2024-04-08', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (77, 1, 4, '2024-04-09', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (78, 1, 4, '2024-04-10', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (79, 1, 4, '2024-04-11', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (80, 1, 4, '2024-04-12', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (81, 1, 4, '2024-04-13', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (82, 1, 4, '2024-04-14', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (83, 1, 4, '2024-04-15', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (84, 1, 4, '2024-04-16', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (85, 1, 4, '2024-04-17', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (86, 1, 4, '2024-04-18', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (87, 1, 4, '2024-04-19', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (88, 1, 4, '2024-04-20', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (89, 1, 4, '2024-04-21', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (90, 1, 4, '2024-04-22', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (91, 1, 4, '2024-04-23', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (92, 1, 4, '2024-04-24', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (93, 1, 4, '2024-04-25', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (94, 1, 4, '2024-04-26', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (95, 1, 4, '2024-04-27', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (96, 1, 4, '2024-04-28', 'J', '2024-03-25 11:28:46', '2024-03-25 14:18:09');
INSERT INTO `asistencias` VALUES (97, 1, 4, '2024-04-29', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (98, 1, 4, '2024-04-30', 'A', '2024-03-25 11:28:46', '2024-03-25 11:28:46');
INSERT INTO `asistencias` VALUES (99, 1, 3, '2024-03-02', 'I', '2024-03-25 11:29:46', '2024-03-25 13:36:43');
INSERT INTO `asistencias` VALUES (100, 1, 3, '2024-03-03', 'J', '2024-03-25 11:29:46', '2024-03-25 13:41:29');
INSERT INTO `asistencias` VALUES (101, 1, 3, '2024-03-09', '-', '2024-03-25 11:29:46', '2024-03-25 13:41:43');
INSERT INTO `asistencias` VALUES (102, 1, 3, '2024-03-10', '-', '2024-03-25 11:29:46', '2024-03-25 13:41:47');
INSERT INTO `asistencias` VALUES (103, 1, 3, '2024-03-16', 'A', '2024-03-25 11:29:46', '2024-03-25 11:29:46');
INSERT INTO `asistencias` VALUES (104, 1, 3, '2024-03-17', 'A', '2024-03-25 11:29:46', '2024-03-25 11:29:46');
INSERT INTO `asistencias` VALUES (105, 1, 3, '2024-03-23', 'A', '2024-03-25 11:29:46', '2024-03-25 11:29:46');
INSERT INTO `asistencias` VALUES (106, 1, 3, '2024-03-24', '-', '2024-03-25 11:29:46', '2024-03-25 13:41:50');
INSERT INTO `asistencias` VALUES (107, 1, 3, '2024-03-30', 'L', '2024-03-25 11:29:46', '2024-03-25 13:41:57');
INSERT INTO `asistencias` VALUES (108, 1, 3, '2024-03-31', 'A', '2024-03-25 11:29:46', '2024-03-25 11:29:46');
INSERT INTO `asistencias` VALUES (109, 2, 5, '2024-01-01', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (110, 2, 5, '2024-01-02', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (111, 2, 5, '2024-01-03', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (112, 2, 5, '2024-01-04', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (113, 2, 5, '2024-01-05', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (114, 2, 5, '2024-01-08', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (115, 2, 5, '2024-01-09', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (116, 2, 5, '2024-01-10', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (117, 2, 5, '2024-01-11', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (118, 2, 5, '2024-01-12', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (119, 2, 5, '2024-01-15', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (120, 2, 5, '2024-01-16', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (121, 2, 5, '2024-01-17', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (122, 2, 5, '2024-01-18', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (123, 2, 5, '2024-01-19', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (124, 2, 5, '2024-01-22', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (125, 2, 5, '2024-01-23', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (126, 2, 5, '2024-01-24', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (127, 2, 5, '2024-01-25', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (128, 2, 5, '2024-01-26', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (129, 2, 5, '2024-01-29', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (130, 2, 5, '2024-01-30', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');
INSERT INTO `asistencias` VALUES (131, 2, 5, '2024-01-31', 'A', '2024-03-25 14:18:55', '2024-03-25 14:18:55');

-- ----------------------------
-- Table structure for calendarios
-- ----------------------------
CREATE TABLE `calendarios`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `id_usuario` bigint UNSIGNED NOT NULL,
  `etiqueta` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `mes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `anio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_anexo03` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_anexo04` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_oficio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `of_titulo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `of_asunto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `of_contenido` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `enviado` enum('NO','SI') 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,
  INDEX `calendarios_id_usuario_foreign`(`id_usuario` ASC) USING BTREE,
  CONSTRAINT `calendarios_id_usuario_foreign` FOREIGN KEY (`id_usuario`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of calendarios
-- ----------------------------
INSERT INTO `calendarios` VALUES (1, 3, NULL, '1', '2024', 'storage/pdf/2024_1_1_1_3_2024-03-13_14-56-19.pdf', 'storage/pdf/2024_1_1_1_3_2024-03-13_14-57-27.pdf', 'storage/oficios/1_3_2024-03-13_15-00-01.pdf', 'OFICIO N° 0001-2024-DIES-\"JG\"-Y', 'DDDD', 'dddd', 'SI', '2024-03-13 14:31:30', '2024-03-13 15:00:43');
INSERT INTO `calendarios` VALUES (2, 3, NULL, '2', '2024', 'storage/pdf/2024_2_2_1_3_2024-03-14_11-40-25.pdf', 'storage/pdf/2024_2_2_1_3_2024-03-14_12-13-05.pdf', 'storage/oficios/2_3_2024-03-14_12-08-53.pdf', 'OFICIO N° 0002-2024-DIES-\"JG\"-Y', 'DDDD', 'dddd', 'SI', '2024-03-13 15:06:28', '2024-03-14 12:15:39');
INSERT INTO `calendarios` VALUES (3, 3, NULL, '3', '2024', 'storage/pdf/2024_3_3_1_3_2024-03-25_13-42-00.pdf', 'storage/pdf/2024_3_3_1_3_2024-03-25_13-45-59.pdf', 'storage/oficios/3_3_2024-03-25_13-46-20.pdf', 'OFICIO N° 0001-2024-DIES-\"JG\"-Y', 'F', 'f', 'SI', '2024-03-25 11:16:05', '2024-03-25 13:47:05');
INSERT INTO `calendarios` VALUES (4, 3, NULL, '4', '2024', 'storage/pdf/2024_4_4_1_3_2024-03-25_14-18-12.pdf', NULL, NULL, NULL, NULL, NULL, 'NO', '2024-03-25 11:25:55', '2024-03-25 14:18:14');
INSERT INTO `calendarios` VALUES (5, 2, NULL, '1', '2024', 'storage/pdf/2024_1_5_2_2_2024-03-25_14-19-22.pdf', NULL, NULL, NULL, NULL, NULL, 'NO', '2024-03-25 13:33:10', '2024-03-25 14:19:24');

-- ----------------------------
-- Table structure for cargos
-- ----------------------------
CREATE TABLE `cargos`  (
  `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 = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of cargos
-- ----------------------------
INSERT INTO `cargos` VALUES (1, 'Director(a)', 'ACTIVO', '2024-03-13 14:29:52', '2024-03-13 14:29:52');

-- ----------------------------
-- Table structure for detalles
-- ----------------------------
CREATE TABLE `detalles`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `perosnal_id` bigint UNSIGNED NOT NULL,
  `calendario_id` bigint UNSIGNED NOT NULL,
  `in_dias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `tar_hor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `tar_min` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lic_cg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lic_sg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `perm_hor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `perm_min` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `hue_dias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `obs` 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 `detalles_perosnal_id_foreign`(`perosnal_id` ASC) USING BTREE,
  INDEX `detalles_calendario_id_foreign`(`calendario_id` ASC) USING BTREE,
  CONSTRAINT `detalles_calendario_id_foreign` FOREIGN KEY (`calendario_id`) REFERENCES `calendarios` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `detalles_perosnal_id_foreign` FOREIGN KEY (`perosnal_id`) REFERENCES `personals` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of detalles
-- ----------------------------
INSERT INTO `detalles` VALUES (1, 1, 1, '0', '0', '0', '0', '0', '0', '0', '0', NULL, '2024-03-13 14:53:25', '2024-03-13 14:53:25');
INSERT INTO `detalles` VALUES (2, 1, 2, '0', '15', '0', '0', '0', '0', '0', '0', '15 Horas', '2024-03-14 12:08:19', '2024-03-14 12:10:22');
INSERT INTO `detalles` VALUES (3, 1, 3, '0', '0', '0', '0', '0', '0', '0', '0', NULL, '2024-03-25 13:45:57', '2024-03-25 13:45:57');

-- ----------------------------
-- Table structure for documentos
-- ----------------------------
CREATE TABLE `documentos`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `calendario_id` bigint UNSIGNED NOT NULL,
  `area_id` bigint UNSIGNED NOT NULL,
  `estado` enum('ENVIADO','ACEPTADO','RECHAZADO') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_anexo03` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_anexo04` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_oficio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `obs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `fecha_envio` datetime NULL DEFAULT NULL,
  `path_cargo` 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 `documentos_calendario_id_foreign`(`calendario_id` ASC) USING BTREE,
  INDEX `documentos_area_id_foreign`(`area_id` ASC) USING BTREE,
  CONSTRAINT `documentos_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `area_models` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `documentos_calendario_id_foreign` FOREIGN KEY (`calendario_id`) REFERENCES `calendarios` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of documentos
-- ----------------------------
INSERT INTO `documentos` VALUES (1, 1, 2, 'ACEPTADO', 'storage/pdf/2024_1_1_1_3_2024-03-13_14-56-19.pdf', 'storage/pdf/2024_1_1_1_3_2024-03-13_14-57-27.pdf', 'storage/oficios/1_3_2024-03-13_15-00-01.pdf', NULL, '2024-03-13 15:00:43', 'storage/cargos/Cargo_1_2024-03-13_15-09-36.pdf', '2024-03-13 15:00:43', '2024-03-13 15:09:42');
INSERT INTO `documentos` VALUES (2, 2, 2, 'ACEPTADO', 'storage/pdf/2024_2_2_1_3_2024-03-14_11-40-25.pdf', 'storage/pdf/2024_2_2_1_3_2024-03-14_12-13-05.pdf', 'storage/oficios/2_3_2024-03-14_12-08-53.pdf', NULL, '2024-03-14 12:15:39', 'storage/cargos/Cargo_2_2024-03-14_12-18-47.pdf', '2024-03-14 12:15:39', '2024-03-14 12:18:49');
INSERT INTO `documentos` VALUES (3, 3, 2, 'ACEPTADO', 'storage/pdf/2024_3_3_1_3_2024-03-25_13-42-00.pdf', 'storage/pdf/2024_3_3_1_3_2024-03-25_13-45-59.pdf', 'storage/oficios/3_3_2024-03-25_13-46-20.pdf', NULL, '2024-03-25 13:47:05', 'storage/cargos/Cargo_3_2024-03-25_13-48-18.pdf', '2024-03-25 13:47:05', '2024-03-25 13:48:19');

-- ----------------------------
-- Table structure for empleados
-- ----------------------------
CREATE TABLE `empleados`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `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,
  `documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tipo` enum('Administrativo','Director IIEE') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `celular` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `correo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_firma` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_foto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 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 = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of empleados
-- ----------------------------
INSERT INTO `empleados` VALUES (1, 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', '73744393', 'Administrativo', '98745412', 'soto@gmail.com', 'JR. INDEPENDENCIA  N°1034-YUNGUYO', NULL, NULL, 'ACTIVO', '2024-03-01 17:25:42', '2024-03-01 17:47:53');
INSERT INTO `empleados` VALUES (2, 'PEDRO LUIS', 'CHURA', 'CHAMBILA', '78102100', 'Director IIEE', '98745412', 'soto@gmail.com', 'Av. Colombia', 'storage/firmas/1711394354_2.png', NULL, 'ACTIVO', '2024-03-06 09:44:30', '2024-03-25 14:19:14');
INSERT INTO `empleados` VALUES (3, 'OBED DESIDERIO', 'QUISPE', 'TORRES', '87777747', 'Director IIEE', '98745412', 'soto@gmail.com', 'Av. Colombia', 'storage/firmas/1711383383_3.png', NULL, 'ACTIVO', '2024-03-06 09:44:55', '2024-03-25 11:16:23');
INSERT INTO `empleados` VALUES (4, 'DARLYS', 'QUISPE', 'CHAMBILLA', '435235423', 'Administrativo', '987542124', '0', '0', 'storage/firmas/1711392491_4.png', NULL, 'ACTIVO', '2024-03-12 18:17:37', '2024-03-25 13:48:11');

-- ----------------------------
-- 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 NOT NULL,
  `path_anexos` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_oficios` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_reportes` 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, 'UNIDAD DE GESTION EDUCATIVA LOCAL YUNGUYO FF', 'FDCGVX', 'VXCV', 'XCVXCV', 'XCVXC', 'storage/logo/1711382682_1.png', 'storage/logo/1711382717_1.png', 'storage/logo/1711382721_1.png', 'storage/logo/1711382727_1.png', 'Lic. EFRAIN CONFORI RIVERA', 'Año de', '2024-03-01 17:24:36', '2024-03-25 11:05:27');

-- ----------------------------
-- 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 instituciones
-- ----------------------------
CREATE TABLE `instituciones`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `distrito` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nivel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `turno` enum('MAÑANA','TARDE','NOCHE','MAÑANA-NOCHE','MAÑANA-TARDE','MAÑANA-TARDE-NOCHE') 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 = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of instituciones
-- ----------------------------
INSERT INTO `instituciones` VALUES (1, '4687156', 'JOSE GALVEZ', 'COPANI', 'EBA INICIAL - INTERMEDIO', 'Av. Colombia', 'MAÑANA', 'ACTIVO', '2024-03-06 09:43:29', '2024-03-25 13:30:56');
INSERT INTO `instituciones` VALUES (2, '897560', 'MICAELA BASTIDAS', 'ANAPIA', 'SECUNDARIA', 'Av. Colombia', 'TARDE', 'ACTIVO', '2024-03-06 09:43:50', '2024-03-25 13:35:27');

-- ----------------------------
-- 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, '2023_10_12_210942_create_area_models_table', 1);
INSERT INTO `migrations` VALUES (6, '2023_10_13_211001_create_instituciones_table', 1);
INSERT INTO `migrations` VALUES (7, '2023_10_14_170835_create_empleados_table', 1);
INSERT INTO `migrations` VALUES (8, '2023_10_16_155823_create_entidades_table', 1);
INSERT INTO `migrations` VALUES (9, '2023_10_16_221452_create_cargos_table', 1);
INSERT INTO `migrations` VALUES (10, '2023_10_17_000000_create_users_table', 1);
INSERT INTO `migrations` VALUES (11, '2023_10_17_211825_create_calendarios_table', 1);
INSERT INTO `migrations` VALUES (12, '2023_10_17_230654_create_personals_table', 1);
INSERT INTO `migrations` VALUES (13, '2023_10_17_291405_create_asistencias_table', 1);
INSERT INTO `migrations` VALUES (14, '2023_10_19_035445_create_detalles_table', 1);
INSERT INTO `migrations` VALUES (15, '2023_10_22_100417_create_documentos_table', 1);
INSERT INTO `migrations` VALUES (16, '2023_10_24_204355_create_reportes_alls_table', 1);
INSERT INTO `migrations` VALUES (17, '2023_10_30_120926_create_area_destino_envios_table', 1);

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

-- ----------------------------
-- Table structure for personals
-- ----------------------------
CREATE TABLE `personals`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `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,
  `dni` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cargo_id` bigint UNSIGNED NOT NULL,
  `condicion` enum('Nombrado','Contratado','Designado','CAS') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `jornada` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `institucion_id` bigint UNSIGNED 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,
  INDEX `personals_cargo_id_foreign`(`cargo_id` ASC) USING BTREE,
  INDEX `personals_institucion_id_foreign`(`institucion_id` ASC) USING BTREE,
  CONSTRAINT `personals_cargo_id_foreign` FOREIGN KEY (`cargo_id`) REFERENCES `cargos` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `personals_institucion_id_foreign` FOREIGN KEY (`institucion_id`) REFERENCES `instituciones` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of personals
-- ----------------------------
INSERT INTO `personals` VALUES (1, 'DSFGSDFSD', 'DSFDSF', 'FDSFSD', '235423523', 1, 'Nombrado', '30', 1, 'ACTIVO', '2024-03-13 14:31:17', '2024-03-13 14:31:17');
INSERT INTO `personals` VALUES (2, 'FDSFSDF', 'FSDF', 'SDFDSF', '23423423', 1, 'Nombrado', '30', 2, 'ACTIVO', '2024-03-25 13:33:29', '2024-03-25 13:33:29');

-- ----------------------------
-- Table structure for reportes_alls
-- ----------------------------
CREATE TABLE `reportes_alls`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `usuario_id` bigint UNSIGNED NOT NULL,
  `mes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `anio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_reporte` 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,
  INDEX `reportes_alls_usuario_id_foreign`(`usuario_id` ASC) USING BTREE,
  CONSTRAINT `reportes_alls_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

