/*
 Navicat Premium Dump SQL

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 80038 (8.0.38)
 Source Host           : localhost:3306
 Source Schema         : absensi-laravel

 Target Server Type    : MySQL
 Target Server Version : 80038 (8.0.38)
 File Encoding         : 65001

 Date: 11/05/2025 10:14:03
*/


-- ----------------------------
-- Table structure for auto_shifts
-- ----------------------------
CREATE TABLE `auto_shifts`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `jabatan_id` bigint UNSIGNED NOT NULL,
  `shift_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of auto_shifts
-- ----------------------------

-- ----------------------------
-- Table structure for beritas
-- ----------------------------
CREATE TABLE `beritas`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `tipe` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `judul` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `isi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `berita_file_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `berita_file_name` varchar(191) 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 = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of beritas
-- ----------------------------
INSERT INTO `beritas` VALUES (1, 'Berita', 'Berita 1', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Sequi provident sed, corporis amet sint ratione tenetur rerum non repudiandae. Voluptatibus pariatur facere voluptate neque aliquid doloribus corrupti natus. Blanditiis dolore, saepe debitis autem enim molestias? Neque dicta officia officiis ut sit! Iste dolor excepturi atque quidem ipsum quam dignissimos eum neque rem. Assumenda saepe eligendi amet? Iste earum soluta deleniti facilis odio! Temporibus ut veniam minima modi voluptatibus, consequatur quidem voluptates provident ratione eaque totam similique et in perferendis molestiae incidunt aut voluptatem ad, quisquam praesentium ex beatae, fugit aperiam. Quos sit ad est aspernatur in eum accusamus, asperiores voluptatum.', 'berita_file_path/banner.jpg', NULL, '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `beritas` VALUES (2, 'Berita', 'Berita 2', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Sequi provident sed, corporis amet sint ratione tenetur rerum non repudiandae. Voluptatibus pariatur facere voluptate neque aliquid doloribus corrupti natus. Blanditiis dolore, saepe debitis autem enim molestias? Neque dicta officia officiis ut sit! Iste dolor excepturi atque quidem ipsum quam dignissimos eum neque rem. Assumenda saepe eligendi amet? Iste earum soluta deleniti facilis odio! Temporibus ut veniam minima modi voluptatibus, consequatur quidem voluptates provident ratione eaque totam similique et in perferendis molestiae incidunt aut voluptatem ad, quisquam praesentium ex beatae, fugit aperiam. Quos sit ad est aspernatur in eum accusamus, asperiores voluptatum.', 'berita_file_path/banner2.jpg', NULL, '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `beritas` VALUES (3, 'Berita', 'Berita 3', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Sequi provident sed, corporis amet sint ratione tenetur rerum non repudiandae. Voluptatibus pariatur facere voluptate neque aliquid doloribus corrupti natus. Blanditiis dolore, saepe debitis autem enim molestias? Neque dicta officia officiis ut sit! Iste dolor excepturi atque quidem ipsum quam dignissimos eum neque rem. Assumenda saepe eligendi amet? Iste earum soluta deleniti facilis odio! Temporibus ut veniam minima modi voluptatibus, consequatur quidem voluptates provident ratione eaque totam similique et in perferendis molestiae incidunt aut voluptatem ad, quisquam praesentium ex beatae, fugit aperiam. Quos sit ad est aspernatur in eum accusamus, asperiores voluptatum.', 'berita_file_path/banner3.jpg', NULL, '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `beritas` VALUES (4, 'Berita', 'Berita 4', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Sequi provident sed, corporis amet sint ratione tenetur rerum non repudiandae. Voluptatibus pariatur facere voluptate neque aliquid doloribus corrupti natus. Blanditiis dolore, saepe debitis autem enim molestias? Neque dicta officia officiis ut sit! Iste dolor excepturi atque quidem ipsum quam dignissimos eum neque rem. Assumenda saepe eligendi amet? Iste earum soluta deleniti facilis odio! Temporibus ut veniam minima modi voluptatibus, consequatur quidem voluptates provident ratione eaque totam similique et in perferendis molestiae incidunt aut voluptatem ad, quisquam praesentium ex beatae, fugit aperiam. Quos sit ad est aspernatur in eum accusamus, asperiores voluptatum.', 'berita_file_path/banner4.jpg', NULL, '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `beritas` VALUES (5, 'Berita', 'Berita 5', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Sequi provident sed, corporis amet sint ratione tenetur rerum non repudiandae. Voluptatibus pariatur facere voluptate neque aliquid doloribus corrupti natus. Blanditiis dolore, saepe debitis autem enim molestias? Neque dicta officia officiis ut sit! Iste dolor excepturi atque quidem ipsum quam dignissimos eum neque rem. Assumenda saepe eligendi amet? Iste earum soluta deleniti facilis odio! Temporibus ut veniam minima modi voluptatibus, consequatur quidem voluptates provident ratione eaque totam similique et in perferendis molestiae incidunt aut voluptatem ad, quisquam praesentium ex beatae, fugit aperiam. Quos sit ad est aspernatur in eum accusamus, asperiores voluptatum.', 'berita_file_path/banner5.jpg', NULL, '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `beritas` VALUES (6, 'Informasi', 'Informasi 1', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Sequi provident sed, corporis amet sint ratione tenetur rerum non repudiandae. Voluptatibus pariatur facere voluptate neque aliquid doloribus corrupti natus. Blanditiis dolore, saepe debitis autem enim molestias? Neque dicta officia officiis ut sit! Iste dolor excepturi atque quidem ipsum quam dignissimos eum neque rem. Assumenda saepe eligendi amet? Iste earum soluta deleniti facilis odio! Temporibus ut veniam minima modi voluptatibus, consequatur quidem voluptates provident ratione eaque totam similique et in perferendis molestiae incidunt aut voluptatem ad, quisquam praesentium ex beatae, fugit aperiam. Quos sit ad est aspernatur in eum accusamus, asperiores voluptatum.', 'berita_file_path/informasi.png', NULL, '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `beritas` VALUES (7, 'Informasi', 'Informasi 2', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Sequi provident sed, corporis amet sint ratione tenetur rerum non repudiandae. Voluptatibus pariatur facere voluptate neque aliquid doloribus corrupti natus. Blanditiis dolore, saepe debitis autem enim molestias? Neque dicta officia officiis ut sit! Iste dolor excepturi atque quidem ipsum quam dignissimos eum neque rem. Assumenda saepe eligendi amet? Iste earum soluta deleniti facilis odio! Temporibus ut veniam minima modi voluptatibus, consequatur quidem voluptates provident ratione eaque totam similique et in perferendis molestiae incidunt aut voluptatem ad, quisquam praesentium ex beatae, fugit aperiam. Quos sit ad est aspernatur in eum accusamus, asperiores voluptatum.', 'berita_file_path/informasi.png', NULL, '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `beritas` VALUES (8, 'Informasi', 'Informasi 3', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Sequi provident sed, corporis amet sint ratione tenetur rerum non repudiandae. Voluptatibus pariatur facere voluptate neque aliquid doloribus corrupti natus. Blanditiis dolore, saepe debitis autem enim molestias? Neque dicta officia officiis ut sit! Iste dolor excepturi atque quidem ipsum quam dignissimos eum neque rem. Assumenda saepe eligendi amet? Iste earum soluta deleniti facilis odio! Temporibus ut veniam minima modi voluptatibus, consequatur quidem voluptates provident ratione eaque totam similique et in perferendis molestiae incidunt aut voluptatem ad, quisquam praesentium ex beatae, fugit aperiam. Quos sit ad est aspernatur in eum accusamus, asperiores voluptatum.', 'berita_file_path/informasi.png', NULL, '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `beritas` VALUES (9, 'Informasi', 'Informasi 4', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Sequi provident sed, corporis amet sint ratione tenetur rerum non repudiandae. Voluptatibus pariatur facere voluptate neque aliquid doloribus corrupti natus. Blanditiis dolore, saepe debitis autem enim molestias? Neque dicta officia officiis ut sit! Iste dolor excepturi atque quidem ipsum quam dignissimos eum neque rem. Assumenda saepe eligendi amet? Iste earum soluta deleniti facilis odio! Temporibus ut veniam minima modi voluptatibus, consequatur quidem voluptates provident ratione eaque totam similique et in perferendis molestiae incidunt aut voluptatem ad, quisquam praesentium ex beatae, fugit aperiam. Quos sit ad est aspernatur in eum accusamus, asperiores voluptatum.', 'berita_file_path/informasi.png', NULL, '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `beritas` VALUES (10, 'Informasi', 'Informasi 5', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Sequi provident sed, corporis amet sint ratione tenetur rerum non repudiandae. Voluptatibus pariatur facere voluptate neque aliquid doloribus corrupti natus. Blanditiis dolore, saepe debitis autem enim molestias? Neque dicta officia officiis ut sit! Iste dolor excepturi atque quidem ipsum quam dignissimos eum neque rem. Assumenda saepe eligendi amet? Iste earum soluta deleniti facilis odio! Temporibus ut veniam minima modi voluptatibus, consequatur quidem voluptates provident ratione eaque totam similique et in perferendis molestiae incidunt aut voluptatem ad, quisquam praesentium ex beatae, fugit aperiam. Quos sit ad est aspernatur in eum accusamus, asperiores voluptatum.', 'berita_file_path/informasi.png', NULL, '2025-05-04 21:25:24', '2025-05-04 21:25:24');

-- ----------------------------
-- Table structure for counters
-- ----------------------------
CREATE TABLE `counters`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `text` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `counter` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of counters
-- ----------------------------
INSERT INTO `counters` VALUES (1, 'Gaji', 'GJ', 0, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `counters` VALUES (2, 'Target Kinerja', 'TK', 0, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `counters` VALUES (3, 'Pengajuan Keuangan', 'PK', 0, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `counters` VALUES (4, 'Inventory', 'INV', 0, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `counters` VALUES (5, 'Penugasan', NULL, 0, '2025-05-04 21:25:25', '2025-05-04 21:25:25');

-- ----------------------------
-- Table structure for cutis
-- ----------------------------
CREATE TABLE `cutis`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `lokasi_id` bigint UNSIGNED NULL DEFAULT NULL,
  `user_id` bigint UNSIGNED NULL DEFAULT NULL,
  `nama_cuti` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `tanggal` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `alasan_cuti` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `foto_cuti` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `status_cuti` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `catatan` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `user_approval` bigint UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `cutis_user_approval_foreign`(`user_approval` ASC) USING BTREE,
  CONSTRAINT `cutis_user_approval_foreign` FOREIGN KEY (`user_approval`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cutis
-- ----------------------------

-- ----------------------------
-- Table structure for dinas_luars
-- ----------------------------
CREATE TABLE `dinas_luars`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NOT NULL,
  `shift_id` bigint UNSIGNED NOT NULL,
  `tanggal` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `jam_absen` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `telat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lat_absen` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `long_absen` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foto_jam_absen` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jam_pulang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `pulang_cepat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foto_jam_pulang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lat_pulang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `long_pulang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `status_absen` varchar(191) 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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dinas_luars
-- ----------------------------

-- ----------------------------
-- Table structure for failed_jobs
-- ----------------------------
CREATE TABLE `failed_jobs`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) 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 files
-- ----------------------------
CREATE TABLE `files`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `jenis_file` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED NULL DEFAULT NULL,
  `fileUpload` varchar(191) 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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of files
-- ----------------------------

-- ----------------------------
-- Table structure for golongans
-- ----------------------------
CREATE TABLE `golongans`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) 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 golongans
-- ----------------------------
INSERT INTO `golongans` VALUES (1, 'DIREKSI', '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `golongans` VALUES (2, 'KABAG', '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `golongans` VALUES (3, 'STAFF', '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `golongans` VALUES (4, 'PELAKSANA', '2025-05-04 21:25:25', '2025-05-04 21:25:25');

-- ----------------------------
-- Table structure for inventories
-- ----------------------------
CREATE TABLE `inventories`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `kode_barang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `nama_barang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `stok` double(8, 2) NULL DEFAULT NULL,
  `uom` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `lokasi_id` bigint UNSIGNED NULL DEFAULT NULL,
  `jabatan_id` bigint UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of inventories
-- ----------------------------

-- ----------------------------
-- Table structure for jabatans
-- ----------------------------
CREATE TABLE `jabatans`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nama_jabatan` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `manager` bigint UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `jabatans_manager_foreign`(`manager` ASC) USING BTREE,
  CONSTRAINT `jabatans_manager_foreign` FOREIGN KEY (`manager`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of jabatans
-- ----------------------------
INSERT INTO `jabatans` VALUES (1, 'Teknologi Informasi', 1, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `jabatans` VALUES (2, 'Keuangan dan Akutansi', NULL, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `jabatans` VALUES (3, 'Administrasi & Umum', NULL, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `jabatans` VALUES (4, 'Humas & Pemasaran', NULL, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `jabatans` VALUES (5, 'Sekretariat', NULL, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `jabatans` VALUES (6, 'Direktur', NULL, '2025-05-04 21:25:25', '2025-05-04 21:25:25');

-- ----------------------------
-- Table structure for jenis_kinerjas
-- ----------------------------
CREATE TABLE `jenis_kinerjas`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nama` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bobot` bigint NULL DEFAULT NULL,
  `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of jenis_kinerjas
-- ----------------------------
INSERT INTO `jenis_kinerjas` VALUES (1, 'Menyelesaikan Penugasan Kerja', 20, 'Jika pegawai menyelesaikan Penugasan Kerja yang diberikan pimpinan', '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `jenis_kinerjas` VALUES (2, 'Menghadiri Pertemuan', 5, 'Jika pegawai melakukan melakukan presensi saat pertemuan/rapat', '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `jenis_kinerjas` VALUES (3, 'Laporan Kerja', 10, 'Jika pegawai melaporkan pekerjaan sesuai tugas kerjanya', '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `jenis_kinerjas` VALUES (4, 'Pulang tepat waktu', 10, 'Jika pegawai tidak melakukan presensi pulang kerja', '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `jenis_kinerjas` VALUES (5, 'Pulang Sebelum waktunya', -5, 'Jika pegawai melakukan melakukan presensi sebelum jam kerja selesai', '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `jenis_kinerjas` VALUES (6, 'Telat Presensi Masuk', -10, 'Jika pegawai telat melakukan presensi masuk kerja', '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `jenis_kinerjas` VALUES (7, 'Presensi Kehadiran Ontime', 10, 'Jika pegawai melakukan presensi masuk kerja', '2025-05-04 21:25:25', '2025-05-04 21:25:25');

-- ----------------------------
-- Table structure for kasbons
-- ----------------------------
CREATE TABLE `kasbons`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NOT NULL,
  `tanggal` date NOT NULL,
  `nominal` int NOT NULL,
  `keperluan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) 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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kasbons
-- ----------------------------

-- ----------------------------
-- Table structure for kategoris
-- ----------------------------
CREATE TABLE `kategoris`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `jumlah` bigint NULL DEFAULT NULL,
  `active` int NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kategoris
-- ----------------------------
INSERT INTO `kategoris` VALUES (1, 'Bensin Pertalite (Mobil)', 200000, 1, '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `kategoris` VALUES (2, 'Bensin Pertalite (Motor)', 100000, 1, '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `kategoris` VALUES (3, 'Biaya Jasa Pasang PSB (50.000)', 50000, 1, '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `kategoris` VALUES (4, 'Pasang ODP (200.000)', 200000, 1, '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `kategoris` VALUES (5, 'Tarik Kabel DC Backbone (500/m)', 2000000, 1, '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `kategoris` VALUES (6, 'Lain-lain', NULL, 1, '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `kategoris` VALUES (7, 'Pelatihan Olahraga', 1000000, NULL, '2025-05-04 21:25:24', '2025-05-04 21:25:24');

-- ----------------------------
-- Table structure for kontraks
-- ----------------------------
CREATE TABLE `kontraks`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NOT NULL,
  `tanggal` date NULL DEFAULT NULL,
  `jenis_kontrak` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `tanggal_mulai` date NULL DEFAULT NULL,
  `tanggal_selesai` date NULL DEFAULT NULL,
  `masa_berlaku_sebelumnya` date NULL DEFAULT NULL,
  `keterangan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `kontrak_file_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `kontrak_file_name` varchar(191) 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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kontraks
-- ----------------------------

-- ----------------------------
-- Table structure for kunjungans
-- ----------------------------
CREATE TABLE `kunjungans`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NOT NULL,
  `tanggal` date NULL DEFAULT NULL,
  `visit_in` datetime NULL DEFAULT NULL,
  `foto_in` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lat_in` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `long_in` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `keterangan_in` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `visit_out` datetime NULL DEFAULT NULL,
  `foto_out` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lat_out` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `long_out` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `keterangan_out` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `status` varchar(191) 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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kunjungans
-- ----------------------------

-- ----------------------------
-- Table structure for laporan_kerjas
-- ----------------------------
CREATE TABLE `laporan_kerjas`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NULL DEFAULT NULL,
  `tanggal` date NULL DEFAULT NULL,
  `informasi_umum` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `pekerjaan_dilaksanakan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `pekerjaan_belum_selesai` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `catatan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of laporan_kerjas
-- ----------------------------

-- ----------------------------
-- Table structure for laporan_kinerjas
-- ----------------------------
CREATE TABLE `laporan_kinerjas`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NULL DEFAULT NULL,
  `tanggal` date NULL DEFAULT NULL,
  `jenis_kinerja_id` bigint UNSIGNED NULL DEFAULT NULL,
  `nilai` bigint NULL DEFAULT NULL,
  `penilaian_berjalan` bigint NULL DEFAULT NULL,
  `reference` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `reference_id` int NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of laporan_kinerjas
-- ----------------------------

-- ----------------------------
-- Table structure for lemburs
-- ----------------------------
CREATE TABLE `lemburs`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NOT NULL,
  `lokasi_id` bigint UNSIGNED NOT NULL,
  `tanggal` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `jam_masuk` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lat_masuk` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `long_masuk` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `jarak_masuk` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `foto_jam_masuk` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `jam_keluar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lat_keluar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `long_keluar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jarak_keluar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foto_jam_keluar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `total_lembur` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `notes` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `approved_by` bigint UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `lemburs_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  CONSTRAINT `lemburs_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of lemburs
-- ----------------------------

-- ----------------------------
-- Table structure for lokasis
-- ----------------------------
CREATE TABLE `lokasis`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nama_lokasi` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lat_kantor` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `long_kantor` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `radius` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `keterangan` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED NULL DEFAULT NULL,
  `approved_by` bigint UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `lokasis_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `lokasis_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  CONSTRAINT `lokasis_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `lokasis_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of lokasis
-- ----------------------------
INSERT INTO `lokasis` VALUES (1, 'Kantor Cabang A', '-6.3707314', '106.8138057', '200', 'Office', 'approved', 1, NULL, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `lokasis` VALUES (2, 'Kantor Cabang B', '-6.3707314', '106.8138057', '200', 'Office', 'approved', 1, NULL, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `lokasis` VALUES (3, 'Gedung A', '-6.3707314', '106.8138057', '200', 'Patroli', 'approved', 1, NULL, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `lokasis` VALUES (4, 'Gedung B', '-6.3707332', '106.81380572', '200', 'Patroli', 'approved', 1, NULL, '2025-05-04 21:25:25', '2025-05-04 21:25:25');

-- ----------------------------
-- Table structure for mapping_shifts
-- ----------------------------
CREATE TABLE `mapping_shifts`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NOT NULL,
  `shift_id` bigint UNSIGNED NULL DEFAULT NULL,
  `tanggal` date NOT NULL,
  `jam_absen` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `telat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lat_absen` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `long_absen` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jarak_masuk` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foto_jam_absen` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `keterangan_masuk` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jam_pulang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `pulang_cepat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lat_pulang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `long_pulang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jarak_pulang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foto_jam_pulang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `keterangan_pulang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `status_absen` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lock_location` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jam_masuk_pengajuan` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jam_pulang_pengajuan` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `deskripsi` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `status_pengajuan` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `file_pengajuan` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `komentar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `approved_by` bigint UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `mapping_shifts_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  CONSTRAINT `mapping_shifts_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of mapping_shifts
-- ----------------------------

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

-- ----------------------------
-- Records of migrations
-- ----------------------------
INSERT INTO `migrations` VALUES (1, '2014_10_12_000000_create_users_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, '2022_09_16_095447_create_shifts_table', 1);
INSERT INTO `migrations` VALUES (6, '2022_09_19_032649_create_mapping_shifts_table', 1);
INSERT INTO `migrations` VALUES (7, '2022_09_20_074944_create_lemburs_table', 1);
INSERT INTO `migrations` VALUES (8, '2022_09_20_092230_create_cutis_table', 1);
INSERT INTO `migrations` VALUES (9, '2022_10_31_083510_create_lokasis_table', 1);
INSERT INTO `migrations` VALUES (10, '2022_11_02_061554_create_reset_cutis_table', 1);
INSERT INTO `migrations` VALUES (11, '2022_12_01_041742_create_sips_table', 1);
INSERT INTO `migrations` VALUES (12, '2022_12_14_080034_create_jabatans_table', 1);
INSERT INTO `migrations` VALUES (13, '2023_03_22_103407_create_dinas_luars_table', 1);
INSERT INTO `migrations` VALUES (14, '2023_04_10_130307_create_auto_shifts_table', 1);
INSERT INTO `migrations` VALUES (15, '2023_06_28_042019_create_files_table', 1);
INSERT INTO `migrations` VALUES (16, '2023_07_15_095632_create_tunjangans_table', 1);
INSERT INTO `migrations` VALUES (17, '2023_07_16_152608_create_golongans_table', 1);
INSERT INTO `migrations` VALUES (18, '2023_07_19_122052_create_status_ptkps_table', 1);
INSERT INTO `migrations` VALUES (19, '2023_07_20_082307_create_pajaks_table', 1);
INSERT INTO `migrations` VALUES (20, '2023_07_21_085614_create_payrolls_table', 1);
INSERT INTO `migrations` VALUES (21, '2023_12_05_140334_create_counters_table', 1);
INSERT INTO `migrations` VALUES (22, '2023_12_06_163716_create_kasbons_table', 1);
INSERT INTO `migrations` VALUES (23, '2024_06_15_075202_create_notifications_table', 1);
INSERT INTO `migrations` VALUES (24, '2024_07_27_095429_create_settings_table', 1);
INSERT INTO `migrations` VALUES (25, '2024_09_19_040613_create_reimbursements_table', 1);
INSERT INTO `migrations` VALUES (26, '2024_09_19_040828_create_kategoris_table', 1);
INSERT INTO `migrations` VALUES (27, '2024_09_22_082937_create_kunjungans_table', 1);
INSERT INTO `migrations` VALUES (28, '2024_10_02_182404_create_reimbursements_items_table', 1);
INSERT INTO `migrations` VALUES (29, '2024_11_23_125436_create_jenis_kinerjas_table', 1);
INSERT INTO `migrations` VALUES (30, '2024_11_23_143017_create_laporan_kinerjas_table', 1);
INSERT INTO `migrations` VALUES (31, '2024_11_23_190924_create_penugasans_table', 1);
INSERT INTO `migrations` VALUES (32, '2024_11_23_200000_create_penugasan_items_table', 1);
INSERT INTO `migrations` VALUES (33, '2024_11_26_031205_create_rapats_table', 1);
INSERT INTO `migrations` VALUES (34, '2024_11_26_040949_create_rapat_pegawais_table', 1);
INSERT INTO `migrations` VALUES (35, '2024_11_26_081727_create_rapat_notulens_table', 1);
INSERT INTO `migrations` VALUES (36, '2024_11_26_140652_create_inventories_table', 1);
INSERT INTO `migrations` VALUES (37, '2024_12_06_123720_create_kontraks_table', 1);
INSERT INTO `migrations` VALUES (38, '2024_12_08_072818_create_pegawai_keluars_table', 1);
INSERT INTO `migrations` VALUES (39, '2024_12_16_100744_create_patrolis_table', 1);
INSERT INTO `migrations` VALUES (40, '2024_12_21_174829_create_target_kinerjas_table', 1);
INSERT INTO `migrations` VALUES (41, '2024_12_23_163056_create_target_kinerja_teams_table', 1);
INSERT INTO `migrations` VALUES (42, '2025_01_01_155603_create_laporan_kerjas_table', 1);
INSERT INTO `migrations` VALUES (43, '2025_01_24_171233_create_permission_tables', 1);
INSERT INTO `migrations` VALUES (44, '2025_01_31_124509_create_pengajuan_keuangans_table', 1);
INSERT INTO `migrations` VALUES (45, '2025_01_31_161224_create_pengajuan_keuangan_items_table', 1);
INSERT INTO `migrations` VALUES (46, '2025_02_01_160925_create_beritas_table', 1);

-- ----------------------------
-- Table structure for model_has_permissions
-- ----------------------------
CREATE TABLE `model_has_permissions`  (
  `permission_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`, `model_id`, `model_type`) USING BTREE,
  INDEX `model_has_permissions_model_id_model_type_index`(`model_id` ASC, `model_type` ASC) USING BTREE,
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of model_has_permissions
-- ----------------------------

-- ----------------------------
-- Table structure for model_has_roles
-- ----------------------------
CREATE TABLE `model_has_roles`  (
  `role_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`role_id`, `model_id`, `model_type`) USING BTREE,
  INDEX `model_has_roles_model_id_model_type_index`(`model_id` ASC, `model_type` ASC) USING BTREE,
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

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

-- ----------------------------
-- Table structure for notifications
-- ----------------------------
CREATE TABLE `notifications`  (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint UNSIGNED NOT NULL,
  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `notifications_notifiable_type_notifiable_id_index`(`notifiable_type` ASC, `notifiable_id` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of notifications
-- ----------------------------

-- ----------------------------
-- Table structure for pajaks
-- ----------------------------
CREATE TABLE `pajaks`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NOT NULL,
  `status_id` bigint UNSIGNED NOT NULL,
  `bulan` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tahun` varchar(191) 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 `pajaks_status_id_foreign`(`status_id` ASC) USING BTREE,
  CONSTRAINT `pajaks_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `status_ptkps` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of password_resets
-- ----------------------------

-- ----------------------------
-- Table structure for patrolis
-- ----------------------------
CREATE TABLE `patrolis`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NULL DEFAULT NULL,
  `lokasi_id` bigint UNSIGNED NULL DEFAULT NULL,
  `tanggal` date NULL DEFAULT NULL,
  `jam` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `long` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jarak` varchar(191) 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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of patrolis
-- ----------------------------

-- ----------------------------
-- Table structure for payrolls
-- ----------------------------
CREATE TABLE `payrolls`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NOT NULL,
  `tanggal_mulai` date NOT NULL,
  `tanggal_akhir` date NOT NULL,
  `bulan` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tahun` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `persentase_kehadiran` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_gaji` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `gaji_pokok` bigint NOT NULL,
  `uang_transport` bigint NOT NULL,
  `total_reimbursement` bigint NOT NULL,
  `jumlah_mangkir` bigint NOT NULL,
  `uang_mangkir` bigint NOT NULL,
  `total_mangkir` bigint NOT NULL,
  `jumlah_lembur` bigint NOT NULL,
  `uang_lembur` bigint NOT NULL,
  `total_lembur` bigint NOT NULL,
  `jumlah_izin` bigint NOT NULL,
  `uang_izin` bigint NOT NULL,
  `total_izin` bigint NOT NULL,
  `bonus_pribadi` bigint NOT NULL,
  `bonus_team` bigint NOT NULL,
  `bonus_jackpot` bigint NOT NULL,
  `jumlah_terlambat` bigint NOT NULL,
  `uang_terlambat` bigint NOT NULL,
  `total_terlambat` bigint NOT NULL,
  `jumlah_kehadiran` bigint NOT NULL,
  `uang_kehadiran` bigint NOT NULL,
  `total_kehadiran` bigint NOT NULL,
  `saldo_kasbon` bigint NOT NULL,
  `bayar_kasbon` bigint NOT NULL,
  `jumlah_thr` bigint NOT NULL,
  `uang_thr` bigint NOT NULL,
  `total_thr` bigint NOT NULL,
  `loss` bigint NOT NULL,
  `total_penjumlahan` bigint NOT NULL,
  `total_pengurangan` bigint NOT NULL,
  `grand_total` bigint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of payrolls
-- ----------------------------

-- ----------------------------
-- Table structure for pegawai_keluars
-- ----------------------------
CREATE TABLE `pegawai_keluars`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NOT NULL,
  `tanggal` date NULL DEFAULT NULL,
  `jenis` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `alasan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `pegawai_keluar_file_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `pegawai_keluar_file_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `approved_by` bigint UNSIGNED NULL DEFAULT NULL,
  `tanggal_approval` date NULL DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `status` varchar(191) 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 `pegawai_keluars_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  CONSTRAINT `pegawai_keluars_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of pegawai_keluars
-- ----------------------------

-- ----------------------------
-- Table structure for pengajuan_keuangan_items
-- ----------------------------
CREATE TABLE `pengajuan_keuangan_items`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `pengajuan_keuangan_id` bigint UNSIGNED NULL DEFAULT NULL,
  `nama` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `qty` double NULL DEFAULT NULL,
  `harga` bigint NULL DEFAULT NULL,
  `total` bigint NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of pengajuan_keuangan_items
-- ----------------------------

-- ----------------------------
-- Table structure for pengajuan_keuangans
-- ----------------------------
CREATE TABLE `pengajuan_keuangans`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NULL DEFAULT NULL,
  `nomor` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `tanggal` date NULL DEFAULT NULL,
  `total_harga` bigint NULL DEFAULT NULL,
  `keterangan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `pk_file_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `pk_file_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `nota_file_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `nota_file_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `user_approval` bigint UNSIGNED NULL DEFAULT NULL,
  `note_approval` varchar(191) 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 `pengajuan_keuangans_user_approval_foreign`(`user_approval` ASC) USING BTREE,
  CONSTRAINT `pengajuan_keuangans_user_approval_foreign` FOREIGN KEY (`user_approval`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of pengajuan_keuangans
-- ----------------------------

-- ----------------------------
-- Table structure for penugasan_items
-- ----------------------------
CREATE TABLE `penugasan_items`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `penugasan_id` bigint UNSIGNED NULL DEFAULT NULL,
  `user_id` bigint UNSIGNED NULL DEFAULT NULL,
  `flow` varchar(191) 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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of penugasan_items
-- ----------------------------

-- ----------------------------
-- Table structure for penugasans
-- ----------------------------
CREATE TABLE `penugasans`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nomor_penugasan` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `user_id` bigint UNSIGNED NULL DEFAULT NULL,
  `tanggal` date NULL DEFAULT NULL,
  `judul` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `rincian` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `status` varchar(191) 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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of penugasans
-- ----------------------------

-- ----------------------------
-- Table structure for permissions
-- ----------------------------
CREATE TABLE `permissions`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) 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,
  UNIQUE INDEX `permissions_name_guard_name_unique`(`name` ASC, `guard_name` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

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

-- ----------------------------
-- Table structure for rapat_notulens
-- ----------------------------
CREATE TABLE `rapat_notulens`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `rapat_id` bigint UNSIGNED NULL DEFAULT NULL,
  `user_id` bigint UNSIGNED NULL DEFAULT NULL,
  `notulen` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of rapat_notulens
-- ----------------------------

-- ----------------------------
-- Table structure for rapat_pegawais
-- ----------------------------
CREATE TABLE `rapat_pegawais`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `rapat_id` bigint UNSIGNED NULL DEFAULT NULL,
  `user_id` bigint UNSIGNED NULL DEFAULT NULL,
  `hadir` datetime NULL DEFAULT NULL,
  `status` varchar(191) 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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of rapat_pegawais
-- ----------------------------

-- ----------------------------
-- Table structure for rapats
-- ----------------------------
CREATE TABLE `rapats`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nama` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal` date NOT NULL,
  `jam_mulai` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `jam_selesai` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lokasi` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `jenis` varchar(191) 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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of rapats
-- ----------------------------

-- ----------------------------
-- Table structure for reimbursements
-- ----------------------------
CREATE TABLE `reimbursements`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NOT NULL,
  `kategori_id` bigint UNSIGNED NOT NULL,
  `tanggal` date NULL DEFAULT NULL,
  `event` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jumlah` bigint NULL DEFAULT NULL,
  `qty` int NULL DEFAULT NULL,
  `total` bigint NULL DEFAULT NULL,
  `sisa` bigint NULL DEFAULT NULL,
  `file_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `file_name` varchar(191) 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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of reimbursements
-- ----------------------------

-- ----------------------------
-- Table structure for reimbursements_items
-- ----------------------------
CREATE TABLE `reimbursements_items`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `reimbursement_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NULL DEFAULT NULL,
  `fee` bigint NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of reimbursements_items
-- ----------------------------

-- ----------------------------
-- Table structure for reset_cutis
-- ----------------------------
CREATE TABLE `reset_cutis`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `izin_cuti` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `izin_dinas_luar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `izin_sakit` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `izin_cek_kesehatan` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `izin_keperluan_pribadi` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `izin_telat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `izin_pulang_cepat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `izin_lainnya` varchar(191) 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 reset_cutis
-- ----------------------------
INSERT INTO `reset_cutis` VALUES (1, '10', '10', '10', '10', '10', '10', '10', '10', '2025-05-04 21:25:25', '2025-05-04 21:25:25');

-- ----------------------------
-- Table structure for role_has_permissions
-- ----------------------------
CREATE TABLE `role_has_permissions`  (
  `permission_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`, `role_id`) USING BTREE,
  INDEX `role_has_permissions_role_id_foreign`(`role_id` ASC) USING BTREE,
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of role_has_permissions
-- ----------------------------

-- ----------------------------
-- Table structure for roles
-- ----------------------------
CREATE TABLE `roles`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) 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,
  UNIQUE INDEX `roles_name_guard_name_unique`(`name` ASC, `guard_name` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES (1, 'admin', 'web', '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `roles` VALUES (2, 'user', 'web', '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `roles` VALUES (3, 'hrd', 'web', '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `roles` VALUES (4, 'general_manager', 'web', '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `roles` VALUES (5, 'finance', 'web', '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `roles` VALUES (6, 'kepala_cabang', 'web', '2025-05-04 21:25:24', '2025-05-04 21:25:24');
INSERT INTO `roles` VALUES (7, 'regional_manager', 'web', '2025-05-04 21:25:24', '2025-05-04 21:25:24');

-- ----------------------------
-- Table structure for settings
-- ----------------------------
CREATE TABLE `settings`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `logo` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `alamat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `whatsapp` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `api_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `api_whatsapp` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `email` varchar(191) 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 settings
-- ----------------------------
INSERT INTO `settings` VALUES (1, 'Absensi', 'logo/absensi.png', 'jln. akasia 1 c.221, purwakarta, aceh', '6281212099664', '6285183397739', 'https://wa.haihalo.com/send-message', 'AI3BsRRM9bVwBZB5zHhDjoq4SLBFBkNj', 'absensi@gmail.com', '2025-05-04 21:25:24', '2025-05-04 21:25:24');

-- ----------------------------
-- Table structure for shifts
-- ----------------------------
CREATE TABLE `shifts`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nama_shift` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `jam_masuk` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `jam_keluar` varchar(191) 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 shifts
-- ----------------------------
INSERT INTO `shifts` VALUES (1, 'Libur', '00:00', '00:00', '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `shifts` VALUES (2, 'Office', '08:00', '17:00', '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `shifts` VALUES (3, 'Siang', '13:00', '21:00', '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `shifts` VALUES (4, 'Malam', '21:00', '07:00', '2025-05-04 21:25:25', '2025-05-04 21:25:25');

-- ----------------------------
-- Table structure for sips
-- ----------------------------
CREATE TABLE `sips`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NOT NULL,
  `nama_dokumen` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal_berakhir` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` varchar(191) 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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sips
-- ----------------------------

-- ----------------------------
-- Table structure for status_ptkps
-- ----------------------------
CREATE TABLE `status_ptkps`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ptkp_2016` decimal(15, 2) NOT NULL DEFAULT 0.00,
  `ptkp_2015` decimal(15, 2) NOT NULL DEFAULT 0.00,
  `ptkp_2009_2012` decimal(15, 2) NOT NULL DEFAULT 0.00,
  `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 status_ptkps
-- ----------------------------
INSERT INTO `status_ptkps` VALUES (1, 'TK/0', 54000000.00, 36000000.00, 15840000.00, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `status_ptkps` VALUES (2, 'TK/1', 58500000.00, 39000000.00, 17160000.00, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `status_ptkps` VALUES (3, 'TK/2', 63000000.00, 42000000.00, 18480000.00, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `status_ptkps` VALUES (4, 'TK/3', 67500000.00, 45000000.00, 19800000.00, '2025-05-04 21:25:25', '2025-05-04 21:25:25');

-- ----------------------------
-- Table structure for target_kinerja_teams
-- ----------------------------
CREATE TABLE `target_kinerja_teams`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `target_kinerja_id` bigint UNSIGNED NULL DEFAULT NULL,
  `user_id` bigint UNSIGNED NULL DEFAULT NULL,
  `jabatan_id` bigint UNSIGNED NULL DEFAULT NULL,
  `target_pribadi` bigint NULL DEFAULT NULL,
  `jumlah_persen_pribadi` bigint NULL DEFAULT NULL,
  `bonus_pribadi` bigint NULL DEFAULT NULL,
  `judul` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jumlah` bigint NULL DEFAULT NULL,
  `capai` double NULL DEFAULT NULL,
  `nilai` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bonus_p` bigint NULL DEFAULT NULL,
  `bonus_t` bigint NULL DEFAULT NULL,
  `bonus_j` bigint NULL DEFAULT NULL,
  `keterangan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `target_kinerja_teams_target_kinerja_id_foreign`(`target_kinerja_id` ASC) USING BTREE,
  INDEX `target_kinerja_teams_user_id_foreign`(`user_id` ASC) USING BTREE,
  INDEX `target_kinerja_teams_jabatan_id_foreign`(`jabatan_id` ASC) USING BTREE,
  CONSTRAINT `target_kinerja_teams_jabatan_id_foreign` FOREIGN KEY (`jabatan_id`) REFERENCES `jabatans` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `target_kinerja_teams_target_kinerja_id_foreign` FOREIGN KEY (`target_kinerja_id`) REFERENCES `target_kinerjas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `target_kinerja_teams_user_id_foreign` FOREIGN KEY (`user_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;

-- ----------------------------
-- Records of target_kinerja_teams
-- ----------------------------

-- ----------------------------
-- Table structure for target_kinerjas
-- ----------------------------
CREATE TABLE `target_kinerjas`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nomor` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `target_team` bigint NULL DEFAULT NULL,
  `jumlah_persen_team` bigint NULL DEFAULT NULL,
  `bonus_team` bigint NULL DEFAULT NULL,
  `jackpot` bigint NULL DEFAULT NULL,
  `tanggal_awal` date NULL DEFAULT NULL,
  `tanggal_akhir` date NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of target_kinerjas
-- ----------------------------

-- ----------------------------
-- Table structure for tunjangans
-- ----------------------------
CREATE TABLE `tunjangans`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `golongan_id` bigint UNSIGNED NOT NULL,
  `tunjangan_makan` decimal(15, 2) NOT NULL DEFAULT 0.00,
  `tunjangan_transport` decimal(15, 2) NOT NULL DEFAULT 0.00,
  `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 tunjangans
-- ----------------------------
INSERT INTO `tunjangans` VALUES (1, 1, 20000.00, 20000.00, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `tunjangans` VALUES (2, 2, 30000.00, 20000.00, '2025-05-04 21:25:25', '2025-05-04 21:25:25');
INSERT INTO `tunjangans` VALUES (3, 3, 30000.00, 30000.00, '2025-05-04 21:25:25', '2025-05-04 21:25:25');

