-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 14 Nov 2024 pada 06.56
-- Versi server: 10.4.32-MariaDB
-- Versi PHP: 8.2.12

START TRANSACTION;



--
-- Database: `laravelkaryawan`
--

-- --------------------------------------------------------

--
-- Struktur dari tabel `absensis`
--

CREATE TABLE `absensis` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `karyawan_id` bigint(20) UNSIGNED NOT NULL,
  `status_absen` enum('hadir','alpha','cuti') NOT NULL,
  `keterangan` varchar(255) DEFAULT NULL,
  `tanggal_absensi` date NOT NULL DEFAULT '2024-11-14',
  `time` time NOT NULL DEFAULT '00:00:00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `absensis`
--

INSERT INTO `absensis` (`id`, `karyawan_id`, `status_absen`, `keterangan`, `tanggal_absensi`, `time`, `created_at`, `updated_at`) VALUES
(1, 2, 'hadir', NULL, '2024-11-13', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(2, 2, 'alpha', 'Sick', '2024-11-12', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(3, 3, 'hadir', NULL, '2024-11-11', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(4, 4, 'hadir', NULL, '2024-11-10', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(5, 5, 'alpha', 'Personal reasons', '2024-11-09', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(6, 6, 'hadir', NULL, '2024-11-08', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(7, 7, 'hadir', NULL, '2024-11-07', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(8, 8, 'alpha', 'Family emergency', '2024-11-06', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(9, 9, 'hadir', NULL, '2024-11-05', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(10, 10, 'hadir', NULL, '2024-11-04', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(11, 2, 'hadir', NULL, '2024-11-03', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(12, 2, 'alpha', 'Sick', '2024-11-02', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(13, 3, 'hadir', NULL, '2024-11-01', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(14, 4, 'hadir', NULL, '2024-10-31', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(15, 5, 'alpha', 'Personal reasons', '2024-10-30', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(16, 6, 'hadir', NULL, '2024-10-29', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(17, 7, 'hadir', NULL, '2024-10-28', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(18, 8, 'alpha', 'Family emergency', '2024-10-27', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(19, 9, 'hadir', NULL, '2024-10-26', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(20, 10, 'hadir', NULL, '2024-10-25', '08:00:00', '2024-11-13 22:50:59', '2024-11-13 22:50:59');

-- --------------------------------------------------------

--
-- Struktur dari tabel `cutis`
--

CREATE TABLE `cutis` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `karyawan_id` bigint(20) UNSIGNED NOT NULL,
  `tanggal_mulai` date NOT NULL,
  `tanggal_berakhir` date NOT NULL,
  `keterangan` varchar(255) NOT NULL,
  `jenis_cuti` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur dari tabel `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur dari tabel `gajis`
--

CREATE TABLE `gajis` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `karyawan_id` bigint(20) UNSIGNED NOT NULL,
  `total` decimal(15,2) NOT NULL,
  `potongan` decimal(15,2) NOT NULL,
  `tunjangan` decimal(15,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `gajis`
--

INSERT INTO `gajis` (`id`, `karyawan_id`, `total`, `potongan`, `tunjangan`, `created_at`, `updated_at`) VALUES
(1, 51, 4321691.00, 807472.00, 614661.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(2, 52, 3702158.00, 767986.00, 604722.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(3, 53, 6113809.00, 547602.00, 986960.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(4, 54, 6865052.00, 344736.00, 1920663.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(5, 55, 6707037.00, 830213.00, 688100.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(6, 56, 6602886.00, 601473.00, 1009990.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(7, 57, 6255874.00, 687059.00, 1146085.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(8, 58, 5115408.00, 356823.00, 1944981.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(9, 59, 5826118.00, 821066.00, 1575315.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(10, 60, 4042437.00, 345959.00, 931171.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(11, 61, 6708888.00, 757476.00, 1890325.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(12, 62, 4950302.00, 340112.00, 1883685.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(13, 63, 5308044.00, 223559.00, 909000.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(14, 64, 4170275.00, 202925.00, 745856.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(15, 65, 4303865.00, 897878.00, 1152184.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(16, 66, 4633272.00, 138619.00, 1243356.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(17, 67, 5720882.00, 948441.00, 1180776.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(18, 68, 3616496.00, 686938.00, 606187.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(19, 69, 4935712.00, 906205.00, 1024748.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(20, 70, 3240740.00, 737054.00, 1905230.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(21, 71, 6612391.00, 747403.00, 1435512.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(22, 72, 6863157.00, 428106.00, 1239129.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(23, 73, 6233530.00, 622681.00, 1193542.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(24, 74, 5969614.00, 210424.00, 742336.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(25, 75, 5710181.00, 251152.00, 1753246.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(26, 76, 3512668.00, 573032.00, 1948504.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(27, 77, 4281288.00, 668904.00, 1463234.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(28, 78, 4734400.00, 477192.00, 1941729.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(29, 79, 4065729.00, 531134.00, 1199309.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(30, 80, 5620266.00, 545865.00, 939179.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(31, 81, 4066143.00, 117038.00, 1997032.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(32, 82, 3093736.00, 909066.00, 1201647.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(33, 83, 6421778.00, 204473.00, 1379970.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(34, 84, 6168430.00, 991459.00, 1232643.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(35, 85, 6114289.00, 652144.00, 1507272.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(36, 86, 5215644.00, 774776.00, 1115460.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(37, 87, 6290309.00, 835881.00, 847715.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(38, 88, 5987234.00, 441837.00, 1425346.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(39, 89, 3501957.00, 268223.00, 1332317.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(40, 90, 6588765.00, 263975.00, 1115146.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(41, 91, 3529981.00, 952327.00, 1291396.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(42, 92, 4897825.00, 540242.00, 1508506.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(43, 93, 3715746.00, 796991.00, 1562388.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(44, 94, 3350662.00, 204228.00, 1747666.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(45, 95, 4798587.00, 547534.00, 1056093.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(46, 96, 6753412.00, 876375.00, 596635.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(47, 97, 6015081.00, 546763.00, 1128152.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(48, 98, 3154535.00, 354353.00, 1697336.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(49, 99, 4678444.00, 882961.00, 1920445.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(50, 100, 6657621.00, 327492.00, 1486041.00, '2024-11-13 22:50:59', '2024-11-13 22:50:59');

-- --------------------------------------------------------

--
-- Struktur dari tabel `jabatans`
--

CREATE TABLE `jabatans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama_jabatan` varchar(255) NOT NULL,
  `jam_mulai_kerja` time NOT NULL,
  `jam_selesai_kerja` time NOT NULL,
  `note_pekerjaan` varchar(255) NOT NULL,
  `gaji_pokok` int(11) NOT NULL,
  `tunjangan` int(11) NOT NULL,
  `potongan` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `jabatans`
--

INSERT INTO `jabatans` (`id`, `nama_jabatan`, `jam_mulai_kerja`, `jam_selesai_kerja`, `note_pekerjaan`, `gaji_pokok`, `tunjangan`, `potongan`, `created_at`, `updated_at`) VALUES
(1, 'IT Project Manager', '08:49:49', '14:32:01', 'Laborum tenetur porro velit asperiores est qui.', 5543120, 1291374, 612352, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(2, 'Frontend Developer', '08:50:27', '12:12:28', 'Et est dolor saepe consectetur.', 6426297, 1112777, 406241, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(3, 'DevOps Engineer', '09:49:44', '15:57:04', 'Dolores magnam distinctio id cumque.', 4191799, 1993024, 621558, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(4, 'Quality Assurance Engineer', '09:28:22', '13:25:47', 'Quo laboriosam ut consectetur sit quae corrupti.', 5695202, 1460097, 796955, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(5, 'IT Support Specialist', '09:34:18', '14:15:22', 'Quia voluptatem rerum animi nulla beatae necessitatibus est et.', 5747601, 727463, 497648, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(6, 'IT Support Specialist', '09:01:44', '15:58:43', 'Illo et recusandae facere omnis repudiandae provident commodi.', 6896399, 964163, 335553, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(7, 'Database Administrator', '08:08:03', '15:48:36', 'Asperiores eos vero voluptas vero delectus laboriosam ducimus.', 3146591, 1874079, 130400, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(8, 'Backend Developer', '08:23:06', '15:19:09', 'Iste officia incidunt qui dolor omnis quasi.', 5044821, 640606, 665338, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(9, 'IT Support Specialist', '08:15:08', '14:55:36', 'Fuga neque cupiditate ea ratione eos voluptate.', 6208680, 880285, 304685, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(10, 'UI/UX Designer', '08:56:56', '14:18:17', 'Repudiandae iste vel ad minima voluptates dolorum ut.', 6079955, 541652, 962067, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(11, 'Cloud Engineer', '09:36:25', '12:48:37', 'Est qui tempore harum pariatur eius.', 6930239, 796871, 234419, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(12, 'IT Support Specialist', '09:23:59', '15:15:14', 'Labore quo in quaerat ut.', 6257468, 1552042, 520876, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(13, 'UI/UX Designer', '09:44:38', '14:22:57', 'Nostrum eos dolorem id reiciendis.', 5084664, 1420266, 804780, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(14, 'Cloud Engineer', '08:04:04', '14:46:12', 'Quod quos magni asperiores laboriosam nam ex.', 6890793, 562361, 641101, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(15, 'DevOps Engineer', '08:24:47', '14:41:30', 'Dolorum quibusdam excepturi amet vitae aut libero provident.', 4173363, 785420, 493568, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(16, 'IT Support Specialist', '08:50:46', '12:51:03', 'Eos pariatur quo ipsam quis porro.', 6407532, 1080282, 112243, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(17, 'Network Engineer', '08:56:50', '14:54:41', 'Sit dolor eligendi eveniet odio autem reprehenderit non.', 3031232, 1988924, 350685, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(18, 'Cyber Security Specialist', '08:13:34', '15:53:04', 'Animi ut commodi et quo voluptatem eius non.', 6911140, 789357, 823854, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(19, 'Data Scientist', '09:32:22', '12:54:14', 'Omnis fugit libero vel dolorum iste exercitationem blanditiis.', 5987287, 1657542, 253863, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(20, 'IT Project Manager', '09:00:23', '15:41:36', 'Iste qui nihil est quo cum.', 4012028, 720896, 942441, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(21, 'IT Support Specialist', '09:28:15', '15:17:46', 'Mollitia asperiores labore deleniti sunt earum ea.', 4276306, 1549982, 847204, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(22, 'IT Support Specialist', '09:49:16', '13:01:13', 'Rerum eius cum qui dolor consequuntur sed id et.', 3091001, 1905620, 761378, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(23, 'Software Engineer', '08:59:14', '13:29:53', 'Quia et voluptatem amet.', 3287759, 1949286, 976602, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(24, 'Cyber Security Specialist', '09:18:31', '15:58:09', 'Sint tempora aut sed reiciendis eos et.', 3569410, 1254733, 224432, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(25, 'Software Engineer', '08:35:13', '12:52:16', 'Omnis voluptas in nobis id ex tenetur facilis.', 4418653, 1100008, 196910, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(26, 'Frontend Developer', '09:22:11', '15:20:00', 'Sequi et laborum incidunt.', 4612367, 857399, 860856, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(27, 'Cyber Security Specialist', '08:50:25', '14:45:36', 'Sed ipsa rerum iusto qui rerum.', 4533185, 1335481, 557458, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(28, 'Database Administrator', '09:19:21', '15:47:47', 'Quidem dolorum eum magnam earum veritatis aliquid non.', 6544726, 696523, 442280, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(29, 'IT Project Manager', '08:57:28', '12:34:29', 'Expedita ea repellendus aut suscipit qui quae.', 4753172, 1734013, 461972, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(30, 'Quality Assurance Engineer', '09:46:48', '12:44:23', 'Error quia dolorem odit impedit ex omnis sed recusandae.', 5635736, 1720274, 416071, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(31, 'Database Administrator', '09:55:34', '12:31:00', 'Consequatur dolores ipsam unde amet accusantium sed libero consequatur.', 3485889, 919223, 621613, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(32, 'Network Engineer', '08:19:32', '13:13:34', 'Dolore deserunt omnis doloribus vitae rem.', 6286789, 1876725, 934305, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(33, 'IT Support Specialist', '09:22:12', '15:59:51', 'Vel occaecati quaerat exercitationem quidem non adipisci molestiae repudiandae.', 6924331, 852686, 454621, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(34, 'Data Scientist', '08:01:05', '13:44:25', 'Iusto deleniti quisquam dolor voluptas.', 5587382, 710863, 601230, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(35, 'Mobile App Developer', '08:32:42', '14:15:09', 'Vel aut rem temporibus est quia non aliquid.', 4678914, 1929118, 938791, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(36, 'Quality Assurance Engineer', '08:32:52', '14:37:35', 'Accusantium ea aperiam molestias fugiat.', 5545932, 617015, 854158, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(37, 'IT Project Manager', '08:58:44', '15:24:16', 'Non ipsam voluptate omnis architecto illum voluptatem voluptatem optio.', 5544869, 833379, 464847, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(38, 'Software Engineer', '08:36:23', '15:32:45', 'Id dolor autem est.', 5519705, 642775, 948171, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(39, 'Cyber Security Specialist', '08:51:03', '14:08:55', 'Ab ullam vero consequatur quae in.', 4272395, 1109133, 119248, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(40, 'Mobile App Developer', '09:51:31', '13:41:38', 'Illum maxime placeat aut facilis.', 3769177, 981822, 256993, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(41, 'Mobile App Developer', '08:46:42', '13:56:08', 'Consequatur ducimus doloremque voluptatem officiis quas fugiat impedit voluptate.', 3428752, 1567770, 623224, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(42, 'IT Support Specialist', '09:23:33', '12:19:27', 'Atque asperiores eligendi corporis magnam quaerat dolor exercitationem.', 4207763, 1652262, 633522, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(43, 'IT Support Specialist', '09:39:39', '12:15:46', 'Dignissimos excepturi autem assumenda deleniti.', 6367089, 701461, 131108, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(44, 'Cyber Security Specialist', '09:28:43', '15:08:06', 'Similique voluptatem odit reprehenderit fugit ipsa nemo.', 5713745, 1342060, 615618, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(45, 'IT Project Manager', '09:05:36', '13:38:16', 'Omnis officia porro architecto illo.', 3762133, 1513744, 168756, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(46, 'IT Project Manager', '08:12:10', '15:08:52', 'Ut perspiciatis aut recusandae cum laborum quis.', 5431668, 1021897, 849464, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(47, 'System Analyst', '08:20:40', '12:33:14', 'Voluptas repudiandae et maiores odit vel ut.', 5477866, 854638, 308102, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(48, 'Full Stack Developer', '09:10:21', '15:16:04', 'Fuga omnis enim expedita eum illo ab.', 4106883, 1885432, 637081, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(49, 'Network Engineer', '08:33:14', '12:58:02', 'Rem quas rerum ab quidem id fugit.', 5795128, 1761917, 169538, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(50, 'Network Engineer', '09:07:58', '12:24:37', 'Aut quos iste voluptate sit et quae ad alias.', 6987867, 524037, 846181, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(51, 'Quality Assurance Engineer', '09:37:19', '13:16:38', 'Deleniti exercitationem repellat distinctio.', 5198836, 1679676, 217712, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(52, 'Network Engineer', '08:41:15', '12:43:07', 'Perferendis unde repellendus sint quam sit quia alias temporibus.', 3452285, 583857, 505508, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(53, 'System Analyst', '08:48:13', '15:17:42', 'Repudiandae eum voluptatem molestias autem recusandae velit.', 3424354, 1370322, 780225, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(54, 'Full Stack Developer', '09:03:17', '13:18:28', 'Veniam nulla qui aliquid cum ut et quis occaecati.', 3385526, 1008855, 875647, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(55, 'Frontend Developer', '08:17:50', '12:25:49', 'Vel quaerat corporis voluptates aliquam voluptas ut.', 5674939, 1530810, 387823, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(56, 'DevOps Engineer', '08:31:49', '14:27:40', 'Natus eligendi provident impedit rem quaerat.', 6214981, 1415047, 104129, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(57, 'Cloud Engineer', '08:54:12', '13:47:45', 'Dolorem dolorem aliquid dolor earum.', 6898119, 1137564, 760168, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(58, 'Network Engineer', '08:12:53', '12:36:24', 'Quam accusamus voluptates dolores debitis.', 5910176, 1683132, 990656, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(59, 'Cyber Security Specialist', '08:32:23', '12:32:31', 'Et non exercitationem sapiente sint nihil ducimus repellat.', 6328421, 1051400, 779199, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(60, 'Software Engineer', '09:47:08', '13:38:15', 'Qui accusamus quia ipsum nemo expedita velit.', 6652240, 1802324, 593507, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(61, 'Mobile App Developer', '08:10:59', '12:22:44', 'Voluptas culpa inventore temporibus sed vel.', 6108571, 614661, 807472, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(62, 'DevOps Engineer', '09:59:24', '14:38:56', 'Eum provident in velit nostrum.', 6400151, 604722, 767986, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(63, 'Cyber Security Specialist', '09:53:29', '15:15:13', 'Qui officia corporis est et perspiciatis.', 3601297, 986960, 547602, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(64, 'IT Support Specialist', '08:42:32', '15:46:12', 'Ut dolorem dolorem sint sint nisi asperiores.', 3509837, 1920663, 344736, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(65, 'UI/UX Designer', '08:47:25', '13:18:38', 'Aspernatur sint et neque.', 6700879, 688100, 830213, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(66, 'System Analyst', '09:52:19', '14:06:12', 'Occaecati laboriosam veniam vel recusandae mollitia qui autem.', 6288057, 1009990, 601473, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(67, 'Quality Assurance Engineer', '08:21:07', '15:47:12', 'Rerum optio ex aut a ut rerum occaecati.', 3586032, 1146085, 687059, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(68, 'DevOps Engineer', '08:48:53', '15:39:31', 'Ut tempore quis illum.', 5021738, 1944981, 356823, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(69, 'Full Stack Developer', '09:00:37', '12:00:05', 'Nobis illum et vel voluptatibus.', 6446408, 1575315, 821066, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(70, 'Network Engineer', '08:13:34', '13:43:23', 'Quia et eos enim non aut incidunt.', 4643984, 931171, 345959, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(71, 'Software Engineer', '08:38:42', '12:02:12', 'Neque dolorum aut et quo autem.', 3845321, 1890325, 757476, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(72, 'DevOps Engineer', '08:28:55', '15:33:28', 'Molestiae aliquam et ipsa quo officiis quis quo.', 5510243, 1883685, 340112, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(73, 'IT Support Specialist', '09:53:18', '12:22:38', 'Quas et omnis deleniti numquam.', 5551246, 909000, 223559, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(74, 'Full Stack Developer', '08:43:10', '14:52:40', 'Quia ea ipsa cupiditate quae.', 3500913, 745856, 202925, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(75, 'Cyber Security Specialist', '09:21:29', '15:59:04', 'Assumenda quia sunt voluptatem.', 5373818, 1152184, 897878, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(76, 'Mobile App Developer', '09:51:28', '13:43:28', 'Illo explicabo in dicta voluptas sed.', 6586436, 1243356, 138619, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(77, 'Full Stack Developer', '08:33:33', '15:32:12', 'Labore nulla est inventore.', 3945625, 1180776, 948441, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(78, 'IT Support Specialist', '08:34:49', '14:17:58', 'Delectus minus neque vel possimus.', 5399754, 606187, 686938, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(79, 'DevOps Engineer', '08:07:53', '14:43:39', 'Numquam quod dolor atque.', 6806833, 1024748, 906205, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(80, 'IT Project Manager', '08:24:49', '14:24:45', 'Voluptas perspiciatis maxime ipsam et laudantium.', 6593193, 1905230, 737054, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(81, 'IT Support Specialist', '09:26:58', '12:05:16', 'Veniam quia repellendus qui voluptatibus incidunt.', 6249240, 1435512, 747403, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(82, 'Frontend Developer', '09:30:41', '12:22:51', 'Ea iste ea nemo id vel quibusdam beatae a.', 5209440, 1239129, 428106, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(83, 'Full Stack Developer', '08:36:06', '15:39:08', 'Minus aliquam ut aut.', 5810214, 1193542, 622681, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(84, 'System Analyst', '08:22:30', '14:29:38', 'Corrupti id doloremque officiis voluptatibus a est.', 5632454, 742336, 210424, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(85, 'Mobile App Developer', '09:03:29', '14:45:41', 'Aut sed fuga omnis qui sed.', 5722269, 1753246, 251152, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(86, 'Database Administrator', '08:35:51', '13:40:50', 'Non velit sapiente aliquam explicabo ut sed.', 5379985, 1948504, 573032, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(87, 'Quality Assurance Engineer', '09:32:27', '13:31:08', 'Esse magnam iusto aut qui vel.', 6284624, 1463234, 668904, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(88, 'UI/UX Designer', '09:12:30', '13:08:17', 'Tenetur et repudiandae minima fuga assumenda.', 5238832, 1941729, 477192, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(89, 'Frontend Developer', '09:48:29', '12:05:07', 'Consectetur consequuntur ipsum commodi repellat.', 4525087, 1199309, 531134, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(90, 'Full Stack Developer', '08:59:06', '13:01:15', 'Dicta explicabo magnam voluptate qui asperiores et.', 5084573, 939179, 545865, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(91, 'DevOps Engineer', '08:37:20', '14:56:43', 'Praesentium aspernatur quae expedita dolores.', 3515710, 1997032, 117038, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(92, 'Quality Assurance Engineer', '08:03:34', '14:42:11', 'Iusto sit quos et porro magnam dolores repellat.', 3729786, 1201647, 909066, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(93, 'Cyber Security Specialist', '08:07:38', '15:25:39', 'Quaerat est et commodi omnis.', 3967680, 1379970, 204473, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(94, 'IT Support Specialist', '09:34:38', '13:03:33', 'Modi velit corporis quo neque.', 5891574, 1232643, 991459, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(95, 'Network Engineer', '09:36:26', '12:59:30', 'Iusto soluta quia est ut molestias molestiae veritatis.', 3184840, 1507272, 652144, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(96, 'IT Project Manager', '08:55:04', '13:56:25', 'Veniam sit est sint sint.', 4926662, 1115460, 774776, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(97, 'UI/UX Designer', '08:31:03', '12:08:30', 'Numquam repellat et numquam possimus qui suscipit eveniet.', 3320217, 847715, 835881, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(98, 'UI/UX Designer', '09:25:27', '13:26:01', 'Ex eaque numquam qui dicta nihil ut exercitationem.', 5122395, 1425346, 441837, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(99, 'Database Administrator', '09:42:39', '13:54:35', 'Quo dolores voluptatem ipsum et veniam.', 6922432, 1332317, 268223, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(100, 'IT Support Specialist', '09:46:33', '14:07:02', 'Et in repellat maiores aut.', 3148958, 1115146, 263975, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(101, 'Mobile App Developer', '09:45:58', '14:57:46', 'Quam animi dicta delectus iste.', 5419161, 1291396, 952327, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(102, 'Quality Assurance Engineer', '08:00:30', '15:14:09', 'Libero et sint aut et.', 6038905, 1508506, 540242, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(103, 'Data Scientist', '08:10:10', '14:13:29', 'Dicta eos consectetur rerum ut consequatur aspernatur.', 3220244, 1562388, 796991, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(104, 'UI/UX Designer', '08:19:11', '14:42:35', 'Laboriosam sed blanditiis porro molestiae quia minima sit nulla.', 5700402, 1747666, 204228, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(105, 'Cyber Security Specialist', '09:19:21', '14:46:36', 'Commodi suscipit molestiae culpa est voluptatibus.', 6763549, 1056093, 547534, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(106, 'Database Administrator', '08:44:47', '13:59:19', 'Impedit molestias amet nemo sit quia omnis enim.', 3648848, 596635, 876375, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(107, 'Data Scientist', '09:41:43', '12:09:43', 'Dolorem fugit dicta vel dicta nihil.', 6615797, 1128152, 546763, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(108, 'Quality Assurance Engineer', '09:48:23', '15:47:35', 'Quidem accusantium velit sit numquam omnis.', 6700158, 1697336, 354353, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(109, 'Cloud Engineer', '08:41:25', '12:37:05', 'Non totam nobis nostrum laborum quo quibusdam veniam.', 3982603, 1920445, 882961, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(110, 'Software Engineer', '09:53:16', '14:38:52', 'Enim fuga perferendis non quisquam praesentium consequatur.', 3209748, 1486041, 327492, '2024-11-13 22:50:59', '2024-11-13 22:50:59');

-- --------------------------------------------------------

--
-- Struktur dari tabel `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur dari tabel `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur dari tabel `karyawans`
--

CREATE TABLE `karyawans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `jenis_kelamin` varchar(255) NOT NULL,
  `telephone` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `jabatan_id` bigint(20) UNSIGNED NOT NULL,
  `ktp` varchar(255) NOT NULL,
  `NPWP` varchar(255) NOT NULL,
  `total_kontak` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `karyawans`
--

INSERT INTO `karyawans` (`id`, `name`, `email`, `jenis_kelamin`, `telephone`, `status`, `jabatan_id`, `ktp`, `NPWP`, `total_kontak`, `created_at`, `updated_at`) VALUES
(1, 'Monte Klein', 'nbednar@example.com', 'Laki-laki', '1-941-569-0252', 'Aktif', 11, '1978745576056342', '9281166234138484', 9, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(2, 'Mara Renner Jr.', 'freida64@example.net', 'Laki-laki', '(573) 837-0683', 'Aktif', 12, '4073150347080481', '7847969264457592', 7, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(3, 'Dulce Waelchi IV', 'lisette.medhurst@example.org', 'Laki-laki', '220-969-3585', 'Aktif', 13, '1801929215036355', '0059661245721916', 6, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(4, 'Allen Deckow', 'nkulas@example.com', 'Perempuan', '+1-954-903-1062', 'Aktif', 14, '6089240353951128', '1251784566029722', 7, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(5, 'Alysha Gaylord', 'gfunk@example.net', 'Perempuan', '1-463-623-5791', 'Aktif', 15, '6959449862038949', '5242932088355775', 9, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(6, 'Viola Hartmann', 'kirk.ondricka@example.com', 'Perempuan', '475.960.3137', 'Aktif', 16, '6639877369364189', '1305130235483396', 3, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(7, 'Dr. Fleta Dicki', 'lreichert@example.net', 'Laki-laki', '747.914.0848', 'Non-aktif', 17, '9991398721800403', '3186566430522050', 8, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(8, 'Antonietta Connelly', 'oledner@example.com', 'Laki-laki', '657.562.8250', 'Aktif', 18, '8417340799512675', '3884964025700633', 10, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(9, 'Zena Dach PhD', 'kay.spencer@example.net', 'Perempuan', '(678) 663-1657', 'Aktif', 19, '5159593456093034', '8900723254372671', 1, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(10, 'Carmen Waters', 'monserrat49@example.com', 'Perempuan', '1-607-566-5127', 'Aktif', 20, '1479816170283220', '5470787656271263', 12, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(11, 'Aaliyah Hackett', 'mckenzie.fred@example.org', 'Perempuan', '1-417-398-7428', 'Aktif', 21, '8374380404926622', '6324824845563742', 4, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(12, 'Bertram Waters Sr.', 'mwelch@example.com', 'Laki-laki', '+1.208.340.5557', 'Non-aktif', 22, '2253089786555261', '3398097596944364', 1, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(13, 'Juanita Heathcote', 'jermain93@example.org', 'Laki-laki', '1-380-963-9025', 'Non-aktif', 23, '0619025770968117', '5138506914716293', 12, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(14, 'Dr. Lincoln Wilderman I', 'aryanna31@example.net', 'Perempuan', '+1-231-908-1637', 'Non-aktif', 24, '1274129617790652', '9288935204701133', 4, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(15, 'Catherine Reinger', 'aaliyah.bode@example.com', 'Laki-laki', '808.954.9722', 'Non-aktif', 25, '7880152156969013', '1161856238992696', 9, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(16, 'Jeffrey Zemlak', 'rory76@example.net', 'Perempuan', '209-790-9191', 'Aktif', 26, '0841577455113643', '0605395390581865', 10, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(17, 'Pietro Ratke DDS', 'wisoky.marvin@example.com', 'Laki-laki', '+1-212-994-2414', 'Non-aktif', 27, '5085461538054835', '0296512183004387', 4, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(18, 'Carley Rodriguez IV', 'metz.anastasia@example.net', 'Laki-laki', '+12014586099', 'Non-aktif', 28, '8923567574741221', '5167243006589963', 9, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(19, 'Mr. Walton Erdman', 'rnienow@example.com', 'Perempuan', '1-878-672-4303', 'Non-aktif', 29, '4553859660220902', '6231955132292378', 1, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(20, 'Enos Ledner', 'myrtie13@example.com', 'Laki-laki', '(908) 792-3186', 'Aktif', 30, '7985564417269495', '8457620920557996', 6, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(21, 'Eldora Brown DDS', 'tleuschke@example.org', 'Perempuan', '936-398-5042', 'Aktif', 31, '1748275595313761', '9156069792470205', 7, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(22, 'Prof. Shayne Kilback', 'qmoen@example.org', 'Laki-laki', '+1.314.355.9362', 'Non-aktif', 32, '3000411092421981', '9547166917670082', 6, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(23, 'Faye Aufderhar', 'winnifred39@example.org', 'Laki-laki', '+12408778282', 'Non-aktif', 33, '5627121311873741', '6597034170407882', 9, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(24, 'Kurtis Hauck MD', 'wkassulke@example.com', 'Laki-laki', '1-445-406-1566', 'Aktif', 34, '5329561967147550', '6075124003504913', 11, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(25, 'Joannie Mraz V', 'shad35@example.net', 'Perempuan', '+1-214-776-8766', 'Non-aktif', 35, '0559614606831561', '4229824228535383', 3, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(26, 'Joanne Towne II', 'raynor.kiara@example.net', 'Perempuan', '+1 (440) 997-5829', 'Aktif', 36, '3721355302281609', '8215013722943606', 8, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(27, 'Mr. Jordyn Altenwerth IV', 'dickens.gregory@example.net', 'Perempuan', '1-928-987-0504', 'Aktif', 37, '4812629592675375', '1822305627559330', 9, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(28, 'Prof. Dean Windler Sr.', 'gutmann.mckenzie@example.com', 'Perempuan', '+1-319-920-0087', 'Aktif', 38, '3109582238350766', '1379583268755138', 5, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(29, 'Rusty Kuhic', 'swindler@example.com', 'Laki-laki', '+12165189746', 'Non-aktif', 39, '1810267555258238', '1944064988366734', 11, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(30, 'Providenci Keeling', 'alessandra.schmeler@example.org', 'Laki-laki', '+1-930-268-0653', 'Aktif', 40, '1875727934400932', '0416309115231476', 10, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(31, 'Mr. Jaleel Huels I', 'korey75@example.net', 'Perempuan', '+1.347.796.3280', 'Aktif', 41, '0522869067331991', '0100606176146864', 7, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(32, 'Reymundo Franecki', 'kunze.cassandra@example.org', 'Perempuan', '+1 (678) 489-1893', 'Aktif', 42, '3694910137196299', '6659147594640723', 9, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(33, 'Wilfrid Hauck IV', 'jarvis.mertz@example.net', 'Perempuan', '1-712-667-1412', 'Aktif', 43, '6807232034466842', '8321413000583824', 11, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(34, 'Aurelio Macejkovic I', 'waters.terence@example.net', 'Laki-laki', '+1-640-806-2792', 'Non-aktif', 44, '8790391727767909', '3480035581763701', 7, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(35, 'Prof. Daija Denesik PhD', 'armstrong.chandler@example.com', 'Perempuan', '847-371-8580', 'Aktif', 45, '6173880839823847', '9628783774367765', 3, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(36, 'Mr. Bradly Hessel V', 'jarrod80@example.org', 'Laki-laki', '+15085864024', 'Non-aktif', 46, '5641102963779623', '0220805326402842', 9, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(37, 'Jermaine Wuckert', 'pnienow@example.org', 'Laki-laki', '380-442-8032', 'Aktif', 47, '8929120045994035', '3750861320584411', 7, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(38, 'Nettie O\'Connell', 'dana.balistreri@example.org', 'Perempuan', '1-925-227-2449', 'Aktif', 48, '3028977951975242', '3170352416784001', 3, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(39, 'Caleigh Nikolaus', 'hhaley@example.net', 'Perempuan', '+1.678.349.4573', 'Non-aktif', 49, '8662527031439223', '6108438721324836', 10, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(40, 'Mr. Napoleon Morissette', 'hessel.abby@example.org', 'Perempuan', '+15049349160', 'Non-aktif', 50, '2611661171856180', '6718333288914849', 7, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(41, 'Alison Hintz', 'rosalinda.ullrich@example.org', 'Perempuan', '850.374.9996', 'Non-aktif', 51, '9771759340880172', '6810040467064128', 7, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(42, 'Kameron Auer', 'christopher22@example.org', 'Perempuan', '1-984-401-8526', 'Non-aktif', 52, '9611073235158185', '1119506140929287', 10, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(43, 'Adell Yost DDS', 'mosciski.zita@example.net', 'Laki-laki', '+1.480.784.7863', 'Aktif', 53, '9565117267257137', '6330589784453385', 6, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(44, 'Dr. Raheem Collier II', 'harris.chanel@example.com', 'Laki-laki', '+1.469.525.5293', 'Non-aktif', 54, '0541302473549282', '3218700590892097', 4, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(45, 'Mr. Anastacio Block PhD', 'tara29@example.net', 'Perempuan', '(229) 328-6263', 'Aktif', 55, '3817110516214318', '0932121835969921', 8, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(46, 'Prof. Ford Waelchi', 'fbahringer@example.org', 'Perempuan', '681-757-7981', 'Aktif', 56, '3037787530011656', '5346555335120909', 6, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(47, 'Verner Little', 'cade.koelpin@example.org', 'Laki-laki', '(252) 602-2078', 'Non-aktif', 57, '3471020663900305', '5145681856309060', 5, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(48, 'Melisa Cronin', 'leon.schneider@example.net', 'Perempuan', '+1-351-816-1627', 'Aktif', 58, '3238966190293857', '1748882389658753', 4, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(49, 'Eunice Cummerata', 'lazaro65@example.com', 'Laki-laki', '805-869-3285', 'Non-aktif', 59, '9837827108464130', '6151938028673153', 2, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(50, 'Prof. Nyasia Heaney', 'royce78@example.net', 'Perempuan', '1-305-832-5025', 'Non-aktif', 60, '6712928467161696', '4816942998911465', 12, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(51, 'Katelin Bins', 'oda82@example.org', 'Laki-laki', '(769) 819-9309', 'Aktif', 61, '8453442687732540', '7476282857382541', 3, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(52, 'Jayne Goyette', 'bechtelar.vincenzo@example.net', 'Perempuan', '716.924.5472', 'Non-aktif', 62, '6488601257329924', '8859361490550012', 6, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(53, 'Katelyn Turner', 'adriel.jenkins@example.com', 'Perempuan', '352-922-2018', 'Non-aktif', 63, '1931071123209904', '6576784063748542', 5, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(54, 'Prof. Rodrigo Kovacek DVM', 'wilburn.doyle@example.com', 'Perempuan', '253.409.0658', 'Non-aktif', 64, '9381231803327412', '4228584712838532', 12, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(55, 'Jordane Sauer', 'egusikowski@example.org', 'Laki-laki', '+1 (667) 254-1375', 'Aktif', 65, '1680006507988241', '9916624243946198', 1, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(56, 'Javonte Dickinson II', 'goodwin.casey@example.com', 'Perempuan', '734.360.3595', 'Non-aktif', 66, '2509527703313021', '7969445349768083', 7, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(57, 'Olaf Funk', 'susan17@example.org', 'Laki-laki', '361-727-9178', 'Aktif', 67, '0075673282792070', '7099989662898008', 2, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(58, 'Gene O\'Conner', 'henry48@example.net', 'Perempuan', '+1.848.641.0851', 'Aktif', 68, '9849898330559287', '8676955892754962', 2, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(59, 'Mrs. Myah Predovic', 'ariane.hills@example.com', 'Perempuan', '+1.651.795.0660', 'Aktif', 69, '1246443616062015', '0543221008543905', 2, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(60, 'Austin Smitham', 'franco.gutmann@example.org', 'Laki-laki', '+1-862-672-7693', 'Aktif', 70, '3670818798126217', '1057359073160723', 7, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(61, 'Myron Connelly', 'crona.larissa@example.com', 'Perempuan', '+1-208-546-9507', 'Aktif', 71, '5644707386987424', '0796377638658742', 11, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(62, 'Avery Gusikowski', 'xreilly@example.net', 'Laki-laki', '(641) 601-9254', 'Non-aktif', 72, '2451490229208852', '8792687304219754', 2, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(63, 'Name Towne', 'norma.labadie@example.org', 'Laki-laki', '1-551-901-1630', 'Non-aktif', 73, '9787756161000362', '5022378277969081', 12, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(64, 'Edwardo Schumm', 'mflatley@example.com', 'Perempuan', '512.329.2601', 'Aktif', 74, '5585048720291613', '3987348311598579', 4, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(65, 'Cordia Johnson DDS', 'aletha68@example.net', 'Perempuan', '919-814-6442', 'Non-aktif', 75, '7043195813490015', '7409030238316884', 6, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(66, 'Mr. Foster Cole', 'wolff.saul@example.com', 'Laki-laki', '1-607-971-3516', 'Aktif', 76, '0551082087861094', '5898781244709133', 5, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(67, 'Mr. Jovanny Rau', 'sid74@example.org', 'Laki-laki', '417.288.0943', 'Non-aktif', 77, '4872115281162981', '4827845548033629', 6, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(68, 'Miss Monica Hayes III', 'shanny.schmitt@example.org', 'Laki-laki', '+1-682-604-8887', 'Aktif', 78, '7948869688610831', '8440666949916098', 11, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(69, 'Prof. Buck Johns', 'marjolaine68@example.org', 'Perempuan', '+1.458.381.1747', 'Non-aktif', 79, '6251990745926989', '2882802358248960', 9, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(70, 'Danyka Tillman', 'maggio.winnifred@example.com', 'Perempuan', '+1-520-442-2343', 'Non-aktif', 80, '4572667498111623', '2117990576866068', 7, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(71, 'Prof. Osbaldo Wolf', 'leora82@example.net', 'Laki-laki', '+1 (716) 802-3483', 'Non-aktif', 81, '7171018329314982', '6714924361798019', 8, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(72, 'Delphia Schowalter', 'xkerluke@example.net', 'Laki-laki', '(239) 326-8577', 'Non-aktif', 82, '4374455218654130', '4034543276854323', 4, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(73, 'Nicklaus Yundt MD', 'gwillms@example.com', 'Laki-laki', '(425) 272-4642', 'Non-aktif', 83, '0237658260868522', '1682540566081547', 12, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(74, 'Viola Hamill', 'mayra.runolfsson@example.com', 'Perempuan', '341-666-1676', 'Aktif', 84, '6328896860029969', '8965739432413058', 7, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(75, 'Eliza Yundt DVM', 'wilfredo75@example.org', 'Laki-laki', '1-619-278-4160', 'Non-aktif', 85, '1531011126889953', '6414985990724163', 1, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(76, 'Dr. Rosemarie Considine', 'sanford58@example.org', 'Laki-laki', '725.709.7724', 'Non-aktif', 86, '0329903018766706', '7530778957988167', 1, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(77, 'Tad Schmitt', 'milan96@example.net', 'Laki-laki', '231.617.5315', 'Aktif', 87, '2010095392385986', '1008365469378049', 8, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(78, 'Adrienne Abernathy II', 'shane.pollich@example.com', 'Perempuan', '325.844.2269', 'Non-aktif', 88, '2231146760806293', '0044364607131329', 11, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(79, 'Geovanny Langosh Sr.', 'bert28@example.org', 'Laki-laki', '531-436-1886', 'Non-aktif', 89, '9012443411769761', '4101602632860160', 3, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(80, 'Dr. Rogelio Nolan Jr.', 'nfarrell@example.net', 'Perempuan', '(774) 471-3531', 'Non-aktif', 90, '8859673767209907', '7335548771266199', 6, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(81, 'Mr. Monroe Kris', 'leonardo01@example.net', 'Perempuan', '+1-385-774-3078', 'Non-aktif', 91, '8652093980046989', '9191296518259509', 5, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(82, 'Francisca Hyatt', 'pansy.pollich@example.com', 'Laki-laki', '479.714.1296', 'Non-aktif', 92, '2639819224686578', '8878246172701590', 1, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(83, 'Hilma Toy', 'barrows.genoveva@example.com', 'Laki-laki', '1-541-795-3681', 'Non-aktif', 93, '1304213292160161', '0648597086973542', 1, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(84, 'Lester O\'Reilly', 'brody.corkery@example.org', 'Perempuan', '(224) 525-1422', 'Aktif', 94, '6243478252125848', '8627560932365430', 12, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(85, 'Prof. Julie Turner', 'samantha99@example.org', 'Perempuan', '(830) 428-9073', 'Non-aktif', 95, '2999119726339662', '4205910154493917', 4, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(86, 'Gavin Bahringer', 'angie38@example.org', 'Perempuan', '(352) 832-9442', 'Non-aktif', 96, '8049983481050873', '2853225668669593', 1, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(87, 'Prof. Blanca Russel', 'tommie62@example.org', 'Perempuan', '+19892638631', 'Non-aktif', 97, '4240715261783893', '5342965439765903', 4, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(88, 'Xavier Haley', 'abernathy.colin@example.net', 'Perempuan', '+1 (820) 283-7349', 'Non-aktif', 98, '8592562639260795', '5868728311110525', 3, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(89, 'Prof. Angie McCullough IV', 'shemar.kihn@example.org', 'Laki-laki', '360-263-2235', 'Aktif', 99, '6441483967794321', '9697781687803426', 6, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(90, 'Leo Barton', 'orin.lindgren@example.com', 'Perempuan', '479-661-3044', 'Non-aktif', 100, '7258497725629910', '2574894575657007', 9, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(91, 'Dolly Rempel', 'emard.estell@example.com', 'Laki-laki', '+17015294432', 'Aktif', 101, '2112135657487215', '2492213106705074', 7, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(92, 'Dustin Nicolas DDS', 'ted.dickinson@example.org', 'Laki-laki', '339-704-3862', 'Aktif', 102, '6301716052647271', '3181710278294314', 5, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(93, 'Selina Vandervort', 'genesis56@example.org', 'Perempuan', '(774) 707-5503', 'Aktif', 103, '1006118199563807', '6567275415996690', 5, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(94, 'Adeline Cronin', 'zieme.una@example.com', 'Perempuan', '954.914.0680', 'Aktif', 104, '9027703735192096', '5747865455358105', 7, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(95, 'Adela Schimmel III', 'jakubowski.dandre@example.net', 'Laki-laki', '+13208919862', 'Non-aktif', 105, '2848681985163753', '1915084323106101', 12, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(96, 'Bria Gerhold DDS', 'katarina.bauch@example.com', 'Perempuan', '(434) 658-8249', 'Aktif', 106, '4619404143769205', '3071627818825373', 6, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(97, 'Nya Klein', 'kautzer.waylon@example.org', 'Laki-laki', '541.770.3776', 'Non-aktif', 107, '0627267209463597', '6561549270108050', 8, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(98, 'Waylon Cartwright', 'sydnee.kreiger@example.net', 'Laki-laki', '(281) 500-1354', 'Non-aktif', 108, '1016265594334397', '3805688489275889', 7, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(99, 'Ms. Malika Purdy DDS', 'clyde.hettinger@example.net', 'Laki-laki', '(520) 702-0066', 'Non-aktif', 109, '2478425335366604', '5737401995985642', 8, '2024-11-13 22:50:59', '2024-11-13 22:50:59'),
(100, 'Bud Farrell', 'nicolas15@example.net', 'Laki-laki', '1-864-421-5308', 'Non-aktif', 110, '4122064057736651', '9418458963169463', 5, '2024-11-13 22:50:59', '2024-11-13 22:50:59');

-- --------------------------------------------------------

--
-- Struktur dari tabel `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2024_06_06_072747_create_jabatans_table', 1),
(5, '2024_06_06_093200_create_karyawans_table', 1),
(6, '2024_06_07_135614_create_cutis_table', 1),
(7, '2024_06_10_114409_create_absensis_table', 1),
(8, '2024_06_11_030512_create_gajis_table', 1);

-- --------------------------------------------------------

--
-- Struktur dari tabel `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('LsoX3uydvnGhW7iXHgd7n5YkbMZrlpAsgW7cH3Ye', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoicUJpd3BnVVdERkpsRFJqekVGV3BjMFVZZVB5Um96MjhSRnk0S3F0ayI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo0OiJ1c2VyIjtPOjE1OiJBcHBcTW9kZWxzXFVzZXIiOjMyOntzOjEzOiIAKgBjb25uZWN0aW9uIjtzOjU6Im15c3FsIjtzOjg6IgAqAHRhYmxlIjtzOjU6InVzZXJzIjtzOjEzOiIAKgBwcmltYXJ5S2V5IjtzOjI6ImlkIjtzOjEwOiIAKgBrZXlUeXBlIjtzOjM6ImludCI7czoxMjoiaW5jcmVtZW50aW5nIjtiOjE7czo3OiIAKgB3aXRoIjthOjA6e31zOjEyOiIAKgB3aXRoQ291bnQiO2E6MDp7fXM6MTk6InByZXZlbnRzTGF6eUxvYWRpbmciO2I6MDtzOjEwOiIAKgBwZXJQYWdlIjtpOjE1O3M6NjoiZXhpc3RzIjtiOjE7czoxODoid2FzUmVjZW50bHlDcmVhdGVkIjtiOjA7czoyODoiACoAZXNjYXBlV2hlbkNhc3RpbmdUb1N0cmluZyI7YjowO3M6MTM6IgAqAGF0dHJpYnV0ZXMiO2E6OTp7czoyOiJpZCI7aToxO3M6NDoibmFtZSI7czo4OiJKb2huIERvZSI7czo1OiJlbWFpbCI7czoxNToiYWRtaW5AZ21haWwuY29tIjtzOjE3OiJlbWFpbF92ZXJpZmllZF9hdCI7TjtzOjg6InBhc3N3b3JkIjtzOjYwOiIkMnkkMTIkZVF0VzNOOGsuS0lzRWo4cG1MbVdOT29kd1lLU2tFTzhLY2JpR0FOSmNGY084TExISExhUG0iO3M6MTA6ImltZ1Byb2ZpbGUiO3M6ODoidXNlci5qcGciO3M6MTQ6InJlbWVtYmVyX3Rva2VuIjtOO3M6MTA6ImNyZWF0ZWRfYXQiO3M6MTk6IjIwMjQtMTEtMTQgMDU6NTA6NTkiO3M6MTA6InVwZGF0ZWRfYXQiO3M6MTk6IjIwMjQtMTEtMTQgMDU6NTA6NTkiO31zOjExOiIAKgBvcmlnaW5hbCI7YTo5OntzOjI6ImlkIjtpOjE7czo0OiJuYW1lIjtzOjg6IkpvaG4gRG9lIjtzOjU6ImVtYWlsIjtzOjE1OiJhZG1pbkBnbWFpbC5jb20iO3M6MTc6ImVtYWlsX3ZlcmlmaWVkX2F0IjtOO3M6ODoicGFzc3dvcmQiO3M6NjA6IiQyeSQxMiRlUXRXM044ay5LSXNFajhwbUxtV05Pb2R3WUtTa0VPOEtjYmlHQU5KY0ZjTzhMTEhITGFQbSI7czoxMDoiaW1nUHJvZmlsZSI7czo4OiJ1c2VyLmpwZyI7czoxNDoicmVtZW1iZXJfdG9rZW4iO047czoxMDoiY3JlYXRlZF9hdCI7czoxOToiMjAyNC0xMS0xNCAwNTo1MDo1OSI7czoxMDoidXBkYXRlZF9hdCI7czoxOToiMjAyNC0xMS0xNCAwNTo1MDo1OSI7fXM6MTA6IgAqAGNoYW5nZXMiO2E6MDp7fXM6ODoiACoAY2FzdHMiO2E6Mjp7czoxNzoiZW1haWxfdmVyaWZpZWRfYXQiO3M6ODoiZGF0ZXRpbWUiO3M6ODoicGFzc3dvcmQiO3M6NjoiaGFzaGVkIjt9czoxNzoiACoAY2xhc3NDYXN0Q2FjaGUiO2E6MDp7fXM6MjE6IgAqAGF0dHJpYnV0ZUNhc3RDYWNoZSI7YTowOnt9czoxMzoiACoAZGF0ZUZvcm1hdCI7TjtzOjEwOiIAKgBhcHBlbmRzIjthOjA6e31zOjE5OiIAKgBkaXNwYXRjaGVzRXZlbnRzIjthOjA6e31zOjE0OiIAKgBvYnNlcnZhYmxlcyI7YTowOnt9czoxMjoiACoAcmVsYXRpb25zIjthOjA6e31zOjEwOiIAKgB0b3VjaGVzIjthOjA6e31zOjEwOiJ0aW1lc3RhbXBzIjtiOjE7czoxMzoidXNlc1VuaXF1ZUlkcyI7YjowO3M6OToiACoAaGlkZGVuIjthOjI6e2k6MDtzOjg6InBhc3N3b3JkIjtpOjE7czoxNDoicmVtZW1iZXJfdG9rZW4iO31zOjEwOiIAKgB2aXNpYmxlIjthOjA6e31zOjExOiIAKgBmaWxsYWJsZSI7YTo0OntpOjA7czo0OiJuYW1lIjtpOjE7czo1OiJlbWFpbCI7aToyO3M6ODoicGFzc3dvcmQiO2k6MztzOjEwOiJpbWdQcm9maWxlIjt9czoxMDoiACoAZ3VhcmRlZCI7YToxOntpOjA7czoxOiIqIjt9czoxOToiACoAYXV0aFBhc3N3b3JkTmFtZSI7czo4OiJwYXNzd29yZCI7czoyMDoiACoAcmVtZW1iZXJUb2tlbk5hbWUiO3M6MTQ6InJlbWVtYmVyX3Rva2VuIjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fX0=', 1731563628);

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `absensis`
--
ALTER TABLE `absensis`
  ADD PRIMARY KEY (`id`),
  ADD KEY `absensis_karyawan_id_foreign` (`karyawan_id`);

--
-- Indeks untuk tabel `cutis`
--
ALTER TABLE `cutis`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cutis_karyawan_id_foreign` (`karyawan_id`);

--
-- Indeks untuk tabel `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `gajis`
--
ALTER TABLE `gajis`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gajis_karyawan_id_foreign` (`karyawan_id`);

--
-- Indeks untuk tabel `jabatans`
--
ALTER TABLE `jabatans`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indeks untuk tabel `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `karyawans`
--
ALTER TABLE `karyawans`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `karyawans_email_unique` (`email`),
  ADD KEY `karyawans_jabatan_id_foreign` (`jabatan_id`);

--
-- Indeks untuk tabel `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `absensis`
--
ALTER TABLE `absensis`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT untuk tabel `cutis`
--
ALTER TABLE `cutis`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `gajis`
--
ALTER TABLE `gajis`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT untuk tabel `jabatans`
--
ALTER TABLE `jabatans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=111;

--
-- AUTO_INCREMENT untuk tabel `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `karyawans`
--
ALTER TABLE `karyawans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;

--
-- AUTO_INCREMENT untuk tabel `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
--

--
-- Ketidakleluasaan untuk tabel `absensis`
--
ALTER TABLE `absensis`
  ADD CONSTRAINT `absensis_karyawan_id_foreign` FOREIGN KEY (`karyawan_id`) REFERENCES `karyawans` (`id`);

--
-- Ketidakleluasaan untuk tabel `cutis`
--
ALTER TABLE `cutis`
  ADD CONSTRAINT `cutis_karyawan_id_foreign` FOREIGN KEY (`karyawan_id`) REFERENCES `karyawans` (`id`);

--
-- Ketidakleluasaan untuk tabel `gajis`
--
ALTER TABLE `gajis`
  ADD CONSTRAINT `gajis_karyawan_id_foreign` FOREIGN KEY (`karyawan_id`) REFERENCES `karyawans` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `karyawans`
--
ALTER TABLE `karyawans`
  ADD CONSTRAINT `karyawans_jabatan_id_foreign` FOREIGN KEY (`jabatan_id`) REFERENCES `jabatans` (`id`);
COMMIT;

