-- phpMyAdmin SQL Dump
-- version 5.3.0-dev+20221031.25fe766a26
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 05, 2025 at 12:29 PM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 8.1.5

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `klasifikasi_kredit`
--

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

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

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

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1);

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

--
-- Table structure for table `nasabah`
--

CREATE TABLE `nasabah` (
  `id_nasabah` int(11) NOT NULL,
  `nama` text NOT NULL,
  `golongan_pekerjaan` text DEFAULT NULL,
  `status_pekerjaan` text NOT NULL,
  `jumlah_pinjaman` text NOT NULL,
  `slip_gaji` text DEFAULT NULL,
  `alamat` text NOT NULL,
  `history_pinjaman` text NOT NULL DEFAULT '0',
  `setoran_per_bulan` text NOT NULL,
  `bunga` text NOT NULL,
  `setoran_dan_bunga` text NOT NULL,
  `sisa_pinjaman` text NOT NULL,
  `jumlah_setoran` text NOT NULL,
  `jangka_waktu` varchar(50) NOT NULL,
  `tabungan_simpanan_wajib` text NOT NULL,
  `status` varchar(250) NOT NULL DEFAULT 'Nasabah Lama',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `nasabah`
--

INSERT INTO `nasabah` (`id_nasabah`, `nama`, `golongan_pekerjaan`, `status_pekerjaan`, `jumlah_pinjaman`, `slip_gaji`, `alamat`, `history_pinjaman`, `setoran_per_bulan`, `bunga`, `setoran_dan_bunga`, `sisa_pinjaman`, `jumlah_setoran`, `jangka_waktu`, `tabungan_simpanan_wajib`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Widi', '3C', 'Tetap', '40000000', '8210000', '', '40000000', '1666670', '600000', '2266670', '29466710', '11', '24', '16335000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(2, 'Wahyu', '3C', 'Tetap', '30000000', '8225000', '', '30000000', '1250000', '450000', '1700000', '1700000', '23', '24', '15770000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(3, 'Janu', '3D', 'Tetap', '44000000', '8270000', '', '44000000', '1833335', '660000', '2493340', '14960040', '18', '24', '16395000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(4, 'Juli', '3A', 'Tetap', '20000000', '8120000', '', '20000000', '1666670', '300000', '1966670', '9833350', '7', '12', '14950000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(5, 'Rosi', '3B', 'Tetap', '35000000', '8165000', '', '35000000', '1458335', '525000', '1983340', '5950020', '21', '24', '16395000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(6, 'Halim', '2C', 'Tetap', '43000000', '5440000', '', '43000000', '1791670', '645000', '2436670', '21930030', '15', '24', '12820000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(7, 'Aldo', '2A', 'Tetap', '35000000', '5320000', '', '35000000', '1458335', '525000', '1983340', '23800080', '12', '24', '15695000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(8, 'Radit', '2D', 'Tetap', '45000000', '7870000', '', '45000000', '1875000', '675000', '2550000', '25500000', '14', '24', '1950000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(9, 'Wawan', '1C', 'Tetap', '42000000', '4650000', '', '42000000', '1750000', '630000', '2380000', '2380000', '23', '24', '16395000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(10, 'Juni', '1D', 'Tetap', '38000000', '4695000', '', '38000000', '1583335', '570000', '2153340', '0', '24', '24', '6995000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(11, 'Juminto', '-', 'PKWT', '5000000', '2800000', '', '5000000', '500000', '75000', '575000', '2300000', '6', '10', '13490000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(12, 'Jamik', '-', 'PKWT', '3500000', '2800000', '', '3500000', '875000', '52500', '927500', '927500', '3', '4', '16395000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(13, 'Sulaiman', '-', 'PKWT', '4500000', '2800000', '', '4500000', '450000', '67500', '517500', '3105000', '4', '10', '15695000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(14, 'Siti', '-', 'PKWT', '5000000', '2800000', '', '5000000', '500000', '75000', '575000', '2300000', '6', '10', '14750000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(15, 'Miskan', '-', 'PKWT', '5000000', '2800000', '', '5000000', '500000', '75000', '575000', '575000', '9', '10', '5200000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(16, 'Revi', '-', 'PKWT', '4000000', '2800000', '', '4000000', '400000', '60000', '460000', '2760000', '4', '10', '6120000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(17, 'Zidan', '-', 'PKWT', '5000000', '2800000', '', '5000000', '500000', '75000', '575000', '575000', '9', '10', '5970000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(18, 'Bani', '-', 'PKWT', '3000000', '2800000', '', '3000000', '750000', '45000', '795000', '1590000', '2', '4', '8200000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(19, 'Jumiko', '-', 'PKWT', '4000000', '2800000', '', '4000000', '400000', '60000', '460000', '0', '10', '10', '6200000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(20, 'Rena', '-', 'PKWT', '4500000', '2800000', '', '4500000', '450000', '67500', '517500', '3105000', '4', '10', '4310000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(21, 'Mita', '-', 'Kontrak', '8500000', '2800000', '', '8500000', '708335', '127500', '835840', '1671680', '10', '12', '16395000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(22, 'Dida', '-', 'Kontrak', '10000000', '2800000', '', '10000000', '833335', '150000', '983340', '983340', '11', '12', '15940000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(23, 'Luki', '-', 'Kontrak', '10000000', '2800000', '', '10000000', '833335', '150000', '983340', '5900040', '6', '12', '16400000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(24, 'Bayu', '-', 'Kontrak', '6500000', '2800000', '', '6500000', '541670', '97500', '639170', '1278340', '10', '12', '15000000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(25, 'Viki', '-', 'Kontrak', '10000000', '2800000', '', '10000000', '833335', '150000', '983340', '0', '12', '12', '15660000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(26, 'Retno', '-', 'Kontrak', '7000000', '2800000', '', '7000000', '583335', '105000', '688340', '0', '12', '12', '15660000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(27, 'Ifan', '-', 'Kontrak', '10000000', '2800000', '', '10000000', '833335', '150000', '983340', '0', '12', '12', '16395000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(28, 'Salsa', '-', 'Kontrak', '10000000', '2800000', '', '10000000', '833335', '150000', '983340', '983340', '11', '12', '16145000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(29, 'Suji', '-', 'Kontrak', '10000000', '2800000', '', '10000000', '833335', '150000', '983340', '0', '8', '12', '14820000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(30, 'Dalhar', '-', 'Kontrak', '8000000', '2800000', '', '8000000', '666670', '120000', '786670', '3933350', '7', '12', '6550000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(31, 'Yanto', '2A', 'Musiman', '10000000', '5335000', '', '10000000', '833335', '150000', '983340', '983340', '11', '12', '6595000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(32, 'Beni', '2A', 'Musiman', '8000000', '5365000', '', '8000000', '666670', '120000', '786670', '0', '12', '12', '5295000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(33, 'Febri', '2C', 'Musiman', '9000000', '5375000', '', '9000000', '750000', '135000', '885000', '0', '12', '12', '5260000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(34, 'Joko', '2C', 'Musiman', '10000000', '5395000', '', '10000000', '833335', '150000', '983340', '0', '12', '12', '5090000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(35, 'Linda', '2B', 'Musiman', '10000000', '5365000', '', '10000000', '833335', '150000', '983340', '983340', '11', '12', '5940000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(36, 'Muji', '1A', 'Musiman', '10000000', '4350000', '', '10000000', '833335', '150000', '983340', '5900040', '6', '12', '7420000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(37, 'Joko', '1A', 'Musiman', '8000000', '4380000', '', '8000000', '666670', '120000', '786670', '786670', '11', '12', '7790000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(38, 'Dedy', '1C', 'Musiman', '6000000', '4650000', '', '6000000', '500000', '90000', '590000', '4130000', '5', '12', '7150000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(39, 'Sugiono', '1D', 'Musiman', '8000000', '4695000', '', '8000000', '666670', '120000', '786670', '0', '12', '12', '7120000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(40, 'Luki', '1B', 'Musiman', '10000000', '4455000', '', '10000000', '833335', '150000', '983340', '0', '12', '12', '5550000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(41, 'Nur', '-', 'OS', '5000000', '2800000', '', '5000000', '500000', '75000', '575000', '575000', '9', '10', '4870000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(42, 'Aris', '-', 'OS', '6500000', '2800000', '', '6500000', '541670', '97500', '639170', '1278340', '10', '12', '7690000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(43, 'Sofyan', '-', 'OS', '6500000', '2800000', '', '6500000', '541670', '97500', '639170', '2556680', '8', '12', '5370000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(44, 'Arif', '-', 'OS', '5000000', '2800000', '', '5000000', '500000', '75000', '575000', '0', '10', '10', '5010000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(45, 'Cahyono', '-', 'OS', '5000000', '2800000', '', '5000000', '500000', '75000', '575000', '0', '10', '10', '4750000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(46, 'Misdi', '-', 'OS', '5000000', '2800000', '', '5000000', '500000', '75000', '575000', '2875000', '5', '10', '6700000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(47, 'Rivan', '-', 'OS', '4000000', '2800000', '', '4000000', '400000', '60000', '460000', '2300000', '5', '10', '4310000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(48, 'Rifai', '-', 'OS', '4500000', '2800000', '', '4500000', '450000', '67500', '517500', '3105000', '4', '10', '4500000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(49, 'Fathur', '-', 'OS', '4000000', '2800000', '', '4000000', '400000', '60000', '460000', '3680000', '2', '10', '3500000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(50, 'Fahim', '-', 'OS', '4500000', '2800000', '', '4500000', '450000', '67500', '517500', '3622500', '3', '10', '3950000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(51, 'Amin', '-', 'SW', '1000000', '2800000', '', '1000000', '250000', '15000', '265000', '530000', '2', '4', '14850000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(52, 'Danuwat', '-', 'SW', '1500000', '2800000', '', '1500000', '375000', '22500', '397500', '0', '4', '4', '14750000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(53, 'Rudi', '-', 'SW', '2000000', '2800000', '', '2000000', '500000', '30000', '560000', '1120000', '2', '4', '16395000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(54, 'Adit', '-', 'SW', '2000000', '2800000', '', '2000000', '500000', '30000', '560000', '560000', '3', '4', '5290000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(55, 'Roni', '-', 'SW', '2000000', '2800000', '', '2000000', '500000', '30000', '560000', '0', '4', '4', '5260000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(56, 'Firma', '-', 'SW', '2000000', '2800000', '', '2000000', '500000', '30000', '560000', '560000', '3', '4', '0', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(57, 'Tino', '-', 'SW', '1000000', '2800000', '', '1000000', '250000', '15000', '265000', '0', '4', '4', '7430000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(58, 'Tomi', '-', 'SW', '2000000', '2800000', '', '2000000', '500000', '30000', '560000', '0', '4', '4', '8160000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(59, 'Luna', '-', 'SW', '1500000', '2800000', '', '1500000', '375000', '22500', '397500', '397500', '3', '4', '1900000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL),
(60, 'Iqbal', '-', 'SW', '1000000', '2800000', '', '1000000', '250000', '15000', '265000', '0', '4', '4', '4470000', 'Nasabah Lama', '2023-01-01 00:00:00', NULL);

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `password_token` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `level` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `foto` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `username`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `password_token`, `level`, `foto`) VALUES
(1, NULL, 'admin', 'admin@gmail.com', NULL, '$2y$10$WyIclg9oFrZngpuJprRV4.Qczhfq/dFlbtBw7Bfed2O55LLCT/dee', NULL, '2025-02-09 19:00:02', '2025-02-09 19:00:02', NULL, 'Ketua', 'default.png'),
(5, 'Ketua', 'ketua1', 'ketua@gmail.com', NULL, '$2y$10$L.yB8UCp7AQ0wb4oLyCNd.K/LH6aemBlczlIF9BNKDsDEyOURU2v.', NULL, NULL, '2025-03-03 01:23:23', NULL, 'Ketua', 'default.png'),
(6, 'Bendahara', 'bendahara', 'bendahara@gmail.com', NULL, '$2y$10$lwKixAHrdnHYUpsbrIokFuSznOkuUgIGiQp3Fi0IO64j.7XOABPPe', NULL, NULL, NULL, NULL, 'Bendahara', 'default.png');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `nasabah`
--
ALTER TABLE `nasabah`
  ADD PRIMARY KEY (`id_nasabah`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `nasabah`
--
ALTER TABLE `nasabah`
  MODIFY `id_nasabah` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
