-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 01 Agu 2026 pada 09.50
-- Versi server: 8.4.3
-- Versi PHP: 8.3.16

START TRANSACTION;



--
-- Basis data: `koperasi`
--

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

--
-- Struktur dari tabel `anggota`
--

CREATE TABLE `anggota` (
  `id` bigint UNSIGNED NOT NULL,
  `no_anggota` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tempat_lahir` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_lahir` date DEFAULT NULL,
  `tanggal_terdaftar` date DEFAULT NULL,
  `jenis_kelamin` enum('L','P') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat` text COLLATE utf8mb4_unicode_ci,
  `no_hp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `foto` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('aktif','nonaktif') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'aktif',
  `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 `anggota`
--

INSERT INTO `anggota` (`id`, `no_anggota`, `nama`, `email`, `password`, `tempat_lahir`, `tanggal_lahir`, `tanggal_terdaftar`, `jenis_kelamin`, `alamat`, `no_hp`, `foto`, `status`, `created_at`, `updated_at`) VALUES
(2, 'AGT0001', 'Bambang Supriyadi', 'anggota1@malasngoding.com', '$2y$12$AwF/Yg0MNbSEEC4gFeSPEud9oN.ZHQtPHjnOWiDHR0G5sVfHSUxoS', 'Surabaya', '1985-03-12', '2020-01-15', 'L', 'Jl. Ketintang Baru No. 45, Surabaya', '081234567890', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:45'),
(3, 'AGT0002', 'Siti Rahmawati', 'anggota2@malasngoding.com', '$2y$12$bBIGFwKrseEv6h3mnQRsOuLh1zcbjY/3q6MxpgHBjob9GVLjuB/Uu', 'Malang', '1990-07-22', '2020-03-20', 'P', 'Perumahan Ijen Estate Blok A2, Malang', '081345678901', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:45'),
(4, 'AGT0003', 'Agus Wijaya', 'anggota3@malasngoding.com', '$2y$12$7AraOEXknz8YXtPF2CoI0OM9eBSYFJCRRWnDsBV1BaoeYsw3dIn3y', 'Jakarta', '1982-11-05', '2020-06-10', 'L', 'Jl. Merpati Raya No. 12, Jakarta Timur', '081456789012', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:45'),
(5, 'AGT0004', 'Dewi Sartika', 'anggota4@malasngoding.com', '$2y$12$gj15H/oPli2jcHgWwmuoW.pUd0ervgNms7ABRlCAb5XW6DQ38QUTy', 'Bandung', '1993-09-18', '2020-09-05', 'P', 'Jl. Dipatiukur No. 78, Bandung', '081567890123', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:46'),
(6, 'AGT0005', 'Hendra Gunawan', 'anggota5@malasngoding.com', '$2y$12$3ws8CYBckYJ2T7FwlUn3ZeYtuVgqbdR/Buq/Mwa8Vmv0tQelSqUPm', 'Semarang', '1987-12-30', '2020-11-22', 'L', 'Jl. Pandanaran No. 56, Semarang', '081678901234', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:46'),
(7, 'AGT0006', 'Rina Marlina', 'anggota6@malasngoding.com', '$2y$12$erXoh8TsXeTnrQb/FoxXCuZrEoJ1qlj588coN.qfcFaMojedHwPF2', 'Yogyakarta', '1995-04-14', '2021-02-08', 'P', 'Jl. Kaliurang Km. 5 No. 23, Sleman', '081789012345', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:46'),
(8, 'AGT0007', 'Ahmad Fauzi', 'anggota7@malasngoding.com', '$2y$12$cxL.uWr2IRGAWAsDyqEIeeOUWv3R7Go9YyZ/8xcyW45yPKze7ZkhC', 'Medan', '1988-08-25', '2021-04-17', 'L', 'Jl. Gatot Subroto No. 234, Medan', '081890123456', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:46'),
(9, 'AGT0008', 'Fitri Handayani', 'anggota8@malasngoding.com', '$2y$12$YderNyeFCDL.pNxoWBTwPuukSB3D9BzmZw34GpLspRPYP1bk5nwce', 'Palembang', '1991-06-07', '2021-07-01', 'P', 'Jl. Demang Lebar Daun No. 89, Palembang', '081901234567', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:46'),
(10, 'AGT0009', 'Dodi Firmansyah', 'anggota9@malasngoding.com', '$2y$12$Wk41KN8Nb5Hg.InqEuelrOrWqc4/Iw5oyJp9lpLW/mvBg1LogIvfy', 'Makassar', '1986-02-19', '2021-09-14', 'L', 'Jl. Pettarani No. 67, Makassar', '082123456789', NULL, 'nonaktif', '2026-06-05 03:14:09', '2026-08-01 08:38:47'),
(11, 'AGT0010', 'Nurul Hidayah', 'anggota10@malasngoding.com', '$2y$12$Hf95TqaIj.XOx7yB4gzOF.JlmXJpDoM483JzCA1OvDhtJv4s/SGAu', 'Denpasar', '1994-10-03', '2021-12-05', 'P', 'Jl. Sunset Road No. 34, Denpasar', '082234567890', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:47'),
(12, 'AGT0011', 'Eko Prasetyo', 'anggota11@malasngoding.com', '$2y$12$gMCL9GftsWotV0Q82YNpz.TU3ioD8KXDnvfh964/dyrNAsejt0R/e', 'Solo', '1984-05-28', '2022-02-20', 'L', 'Jl. Slamet Riyadi No. 145, Surakarta', '082345678901', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:47'),
(13, 'AGT0012', 'Rini Anggraeni', 'anggota12@malasngoding.com', '$2y$12$suQh6njVdflWcA4GFZMRle8eSdc8EMZG7e9QjqDmEpwyh7HnsI63q', 'Bogor', '1992-07-15', '2022-05-12', 'P', 'Perumahan Cimanggu Permai Blok C8, Bogor', '082456789012', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:47'),
(14, 'AGT0013', 'Rudi Hartono', 'anggota13@malasngoding.com', '$2y$12$BxDOpwfri5uNexFBn7Iq2e5w5ySGQZVO4s8kENPdpafdPjDN7fUJ6', 'Banjarmasin', '1989-01-20', '2022-08-08', 'L', 'Jl. A. Yani Km. 4 No. 56, Banjarmasin', '082567890123', NULL, 'nonaktif', '2026-06-05 03:14:09', '2026-08-01 08:38:48'),
(15, 'AGT0014', 'Maya Sari', 'anggota14@malasngoding.com', '$2y$12$r4fCfAOmNEsTNoVWYPJSF.YSkS5h0k1KQtQGx5bUeVOytw/cCfVJa', 'Padang', '1996-11-11', '2022-10-25', 'P', 'Jl. Sudirman No. 78, Padang', '082678901234', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:48'),
(16, 'AGT0015', 'Adi Nugroho', 'anggota15@malasngoding.com', '$2y$12$RdzSFHCFPMW0euFcRgvTMeOlbYCB1ztRzEYykJTwla04puysm20ZW', 'Manado', '1983-03-09', '2023-01-18', 'L', 'Jl. Sam Ratulangi No. 25, Manado', '082789012345', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:48'),
(17, 'AGT0016', 'Yuni Astuti', 'anggota16@malasngoding.com', '$2y$12$ZJ4miZceOuVWzTfaBKTXy.9bJb3uNetpu.vuP3tYwxi7CtM0lSNjy', 'Pekanbaru', '1990-08-30', '2023-04-03', 'P', 'Jl. Tuanku Tambusai No. 90, Pekanbaru', '082890123456', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:49'),
(18, 'AGT0017', 'Slamet Riyadi', 'anggota17@malasngoding.com', '$2y$12$kpggKthdyuNx0wfxCbEJieX4aRLBfeNkJU4v6N4RscxQlwVqOO/w2', 'Pontianak', '1981-12-17', '2023-07-22', 'L', 'Jl. Gusti Hamzah No. 33, Pontianak', '082901234567', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:49'),
(19, 'AGT0018', 'Tina Susanti', 'anggota18@malasngoding.com', '$2y$12$IQvZ.pMcSHuxto4QBD5RduQdBVFr/oU1XEs1G0GS/RbM2KRumF3iu', 'Aceh', '1995-04-25', '2023-10-10', 'P', 'Jl. Teuku Umar No. 12, Banda Aceh', '083123456789', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:50'),
(20, 'AGT0019', 'Bayu Pamungkas', 'anggota19@malasngoding.com', '$2y$12$SQrf.PNAUyfDY/ts7vlnOe4kfhMQefsK/VgvPB7kyIEPCwP8b.nlK', 'Balikpapan', '1987-06-08', '2024-02-14', 'L', 'Jl. MT Haryono No. 45, Balikpapan', '083234567890', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:50'),
(21, 'AGT0020', 'Indah Permata Sari', 'anggota20@malasngoding.com', '$2y$12$mvH6EbE/ZVdSD/kV4DzmY.mcx2gx8UcVlp03YRlTvY3Y3/foi1.By', 'Mataram', '1993-09-01', '2024-06-05', 'P', 'Jl. Pejanggik No. 67, Mataram', '083345678901', NULL, 'aktif', '2026-06-05 03:14:09', '2026-08-01 08:38:51');

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

--
-- Struktur dari tabel `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` varchar(255) 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;

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

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

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

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

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

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

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

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int 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, '2026_06_05_093359_add_role_to_users_table', 1),
(5, '2026_06_05_094550_create_anggota_table', 1),
(6, '2026_06_05_100000_add_foto_to_users_table', 1),
(7, '2026_06_05_100040_create_simpanan_table', 1),
(8, '2026_06_05_101205_add_tanggal_terdaftar_to_anggota_table', 1),
(9, '2026_06_05_101917_add_status_to_simpanan_table', 1),
(10, '2026_06_05_103535_create_pinjaman_table', 1),
(11, '2026_06_05_103544_create_pinjaman_detail_table', 1),
(12, '2026_06_05_104437_change_nominal_to_bigint_in_pinjaman_table', 1),
(13, '2026_06_05_110000_create_settings_table', 1),
(14, '2026_06_05_110100_create_pembayaran_table', 1),
(15, '2026_06_05_110200_add_nama_aplikasi_to_settings_table', 1),
(16, '2026_06_05_110300_add_bunga_default_to_settings_table', 1),
(17, '2026_06_05_110500_add_denda_persen_to_pinjaman_table', 1),
(18, '2026_06_11_000001_add_password_to_anggota_table', 2),
(19, '2026_06_11_000002_add_keterangan_to_pinjaman_table', 3);

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

--
-- Struktur dari tabel `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;

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

--
-- Struktur dari tabel `pembayaran`
--

CREATE TABLE `pembayaran` (
  `id` bigint UNSIGNED NOT NULL,
  `pinjaman_detail_id` bigint UNSIGNED NOT NULL,
  `tanggal_bayar` date NOT NULL,
  `jumlah_dibayar` decimal(18,2) NOT NULL,
  `denda` decimal(18,2) NOT NULL DEFAULT '0.00',
  `keterangan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 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 `pembayaran`
--

INSERT INTO `pembayaran` (`id`, `pinjaman_detail_id`, `tanggal_bayar`, `jumlah_dibayar`, `denda`, `keterangan`, `created_at`, `updated_at`) VALUES
(9, 25, '2026-06-06', 84167.00, 0.00, 'Pembayaran angsuran ke-1 pinjaman PJN-20260605-0002', '2026-06-05 21:49:18', '2026-06-05 21:49:18'),
(10, 26, '2026-10-22', 116992.13, 32825.13, 'Pembayaran angsuran ke-2 pinjaman PJN-20260605-0002', '2026-06-05 21:49:27', '2026-06-05 21:49:27'),
(11, 27, '2026-06-06', 84167.00, 0.00, 'Pembayaran angsuran ke-3 pinjaman PJN-20260605-0002', '2026-06-05 21:51:47', '2026-06-05 21:51:47'),
(12, 28, '2026-06-06', 84167.00, 0.00, 'Pembayaran angsuran ke-4 pinjaman PJN-20260605-0002', '2026-06-05 21:51:53', '2026-06-05 21:51:53'),
(13, 29, '2026-06-06', 84167.00, 0.00, 'Pembayaran angsuran ke-5 pinjaman PJN-20260605-0002', '2026-06-05 21:51:59', '2026-06-05 21:51:59'),
(14, 30, '2026-06-06', 84167.00, 0.00, 'Pembayaran angsuran ke-6 pinjaman PJN-20260605-0002', '2026-06-05 21:52:04', '2026-06-05 21:52:04'),
(15, 31, '2026-06-11', 8417.00, 0.00, 'Pembayaran angsuran ke-1 pinjaman PJN-20260611-0001', '2026-06-11 15:17:22', '2026-06-11 15:17:22'),
(16, 32, '2026-06-11', 8417.00, 0.00, 'Pembayaran angsuran ke-2 pinjaman PJN-20260611-0001', '2026-06-11 15:17:26', '2026-06-11 15:17:26'),
(17, 33, '2026-06-11', 8417.00, 0.00, 'Pembayaran angsuran ke-3 pinjaman PJN-20260611-0001', '2026-06-11 15:17:33', '2026-06-11 15:17:33'),
(18, 34, '2026-06-11', 8417.00, 0.00, 'Pembayaran angsuran ke-4 pinjaman PJN-20260611-0001', '2026-06-11 15:17:37', '2026-06-11 15:17:37'),
(19, 35, '2026-06-11', 8417.00, 0.00, 'Pembayaran angsuran ke-5 pinjaman PJN-20260611-0001', '2026-06-11 15:17:42', '2026-06-11 15:17:42'),
(20, 36, '2026-06-11', 8417.00, 0.00, 'Pembayaran angsuran ke-6 pinjaman PJN-20260611-0001', '2026-06-11 15:17:45', '2026-06-11 15:17:45'),
(21, 37, '2026-06-11', 8417.00, 0.00, 'Pembayaran angsuran ke-7 pinjaman PJN-20260611-0001', '2026-06-11 15:17:52', '2026-06-11 15:17:52'),
(22, 38, '2026-06-11', 8417.00, 0.00, 'Pembayaran angsuran ke-8 pinjaman PJN-20260611-0001', '2026-06-11 15:17:57', '2026-06-11 15:17:57'),
(23, 39, '2026-06-11', 8417.00, 0.00, 'Pembayaran angsuran ke-9 pinjaman PJN-20260611-0001', '2026-06-11 15:18:01', '2026-06-11 15:18:01'),
(24, 40, '2026-06-11', 8417.00, 0.00, 'Pembayaran angsuran ke-10 pinjaman PJN-20260611-0001', '2026-06-11 15:18:05', '2026-06-11 15:18:05'),
(25, 41, '2026-06-11', 8417.00, 0.00, 'Pembayaran angsuran ke-11 pinjaman PJN-20260611-0001', '2026-06-11 15:18:09', '2026-06-11 15:18:09'),
(26, 42, '2026-06-11', 8417.00, 0.00, 'Pembayaran angsuran ke-12 pinjaman PJN-20260611-0001', '2026-06-11 15:18:13', '2026-06-11 15:18:13'),
(27, 70, '2026-08-01', 16833.00, 0.00, 'Pembayaran angsuran ke-1 pinjaman PJN-20260801-0001', '2026-08-01 07:23:35', '2026-08-01 07:23:35'),
(28, 71, '2026-08-01', 16833.00, 0.00, 'Pembayaran angsuran ke-2 pinjaman PJN-20260801-0001', '2026-08-01 07:23:48', '2026-08-01 07:23:48'),
(29, 76, '2026-08-01', 50500.00, 0.00, 'Pembayaran angsuran ke-1 pinjaman PJN-20260801-0002', '2026-08-01 09:21:20', '2026-08-01 09:21:20'),
(30, 77, '2026-08-01', 50500.00, 0.00, 'Pembayaran angsuran ke-2 pinjaman PJN-20260801-0002', '2026-08-01 09:21:31', '2026-08-01 09:21:31'),
(31, 78, '2026-08-01', 50500.00, 0.00, 'Pembayaran angsuran ke-3 pinjaman PJN-20260801-0002', '2026-08-01 09:22:28', '2026-08-01 09:22:28'),
(32, 79, '2026-08-01', 50500.00, 0.00, 'Pembayaran angsuran ke-4 pinjaman PJN-20260801-0002', '2026-08-01 09:22:35', '2026-08-01 09:22:35'),
(33, 80, '2026-08-01', 50500.00, 0.00, 'Pembayaran angsuran ke-5 pinjaman PJN-20260801-0002', '2026-08-01 09:22:41', '2026-08-01 09:22:41'),
(34, 81, '2027-03-25', 63630.00, 13130.00, 'Pembayaran angsuran ke-6 pinjaman PJN-20260801-0002', '2026-08-01 09:22:57', '2026-08-01 09:22:57');

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

--
-- Struktur dari tabel `pinjaman`
--

CREATE TABLE `pinjaman` (
  `id` bigint UNSIGNED NOT NULL,
  `tanggal` date NOT NULL,
  `no_pinjaman` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `anggota_id` bigint UNSIGNED NOT NULL,
  `nominal` bigint NOT NULL,
  `bunga` decimal(5,2) NOT NULL,
  `jangka_waktu` int NOT NULL,
  `tanggal_selesai` date NOT NULL,
  `status` enum('lunas','belum_lunas') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'belum_lunas',
  `keterangan` enum('menunggu_konfirmasi','disetujui','ditolak') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'menunggu_konfirmasi',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `denda_persen` decimal(5,2) NOT NULL DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `pinjaman`
--

INSERT INTO `pinjaman` (`id`, `tanggal`, `no_pinjaman`, `anggota_id`, `nominal`, `bunga`, `jangka_waktu`, `tanggal_selesai`, `status`, `keterangan`, `created_at`, `updated_at`, `denda_persen`) VALUES
(2, '2026-06-05', 'PJN-20260605-0002', 3, 500000, 1.00, 6, '2026-12-05', 'lunas', 'disetujui', '2026-06-05 03:43:17', '2026-06-05 21:52:04', 0.50),
(3, '2026-06-11', 'PJN-20260611-0001', 4, 100000, 1.00, 12, '2027-06-11', 'lunas', 'disetujui', '2026-06-11 14:48:50', '2026-06-11 15:18:13', 0.50),
(4, '2026-06-11', 'PJN-20260611-0002', 4, 10000, 1.00, 12, '2027-06-11', 'belum_lunas', 'menunggu_konfirmasi', '2026-06-11 15:16:06', '2026-06-11 15:16:06', 0.50),
(5, '2026-06-11', 'PJN-20260611-0003', 4, 100, 1.00, 12, '2027-06-11', 'belum_lunas', 'menunggu_konfirmasi', '2026-06-11 15:16:17', '2026-06-11 15:16:17', 0.50),
(7, '2026-08-01', 'PJN-20260801-0001', 2, 100000, 1.00, 6, '2027-02-01', 'belum_lunas', 'disetujui', '2026-08-01 07:23:13', '2026-08-01 07:23:13', 0.50),
(8, '2026-08-01', 'PJN-20260801-0002', 16, 300000, 1.00, 6, '2027-02-01', 'lunas', 'disetujui', '2026-08-01 09:21:06', '2026-08-01 09:22:57', 0.50);

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

--
-- Struktur dari tabel `pinjaman_detail`
--

CREATE TABLE `pinjaman_detail` (
  `id` bigint UNSIGNED NOT NULL,
  `pinjaman_id` bigint UNSIGNED NOT NULL,
  `angsuran_ke` int NOT NULL,
  `tanggal_jatuh_tempo` date NOT NULL,
  `jumlah_angsuran` bigint NOT NULL,
  `sisa_bayar` bigint NOT NULL,
  `status_pembayaran` enum('lunas','belum_lunas') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'belum_lunas',
  `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 `pinjaman_detail`
--

INSERT INTO `pinjaman_detail` (`id`, `pinjaman_id`, `angsuran_ke`, `tanggal_jatuh_tempo`, `jumlah_angsuran`, `sisa_bayar`, `status_pembayaran`, `created_at`, `updated_at`) VALUES
(25, 2, 1, '2026-07-05', 84167, 0, 'lunas', '2026-06-05 21:49:11', '2026-06-05 21:49:18'),
(26, 2, 2, '2026-08-05', 84167, 0, 'lunas', '2026-06-05 21:49:11', '2026-06-05 21:49:27'),
(27, 2, 3, '2026-09-05', 84167, 0, 'lunas', '2026-06-05 21:49:11', '2026-06-05 21:51:47'),
(28, 2, 4, '2026-10-05', 84167, 0, 'lunas', '2026-06-05 21:49:11', '2026-06-05 21:51:53'),
(29, 2, 5, '2026-11-05', 84167, 0, 'lunas', '2026-06-05 21:49:11', '2026-06-05 21:51:59'),
(30, 2, 6, '2026-12-05', 84167, 0, 'lunas', '2026-06-05 21:49:11', '2026-06-05 21:52:04'),
(31, 3, 1, '2026-07-11', 8417, 0, 'lunas', '2026-06-11 14:48:50', '2026-06-11 15:17:22'),
(32, 3, 2, '2026-08-11', 8417, 0, 'lunas', '2026-06-11 14:48:50', '2026-06-11 15:17:26'),
(33, 3, 3, '2026-09-11', 8417, 0, 'lunas', '2026-06-11 14:48:50', '2026-06-11 15:17:33'),
(34, 3, 4, '2026-10-11', 8417, 0, 'lunas', '2026-06-11 14:48:50', '2026-06-11 15:17:37'),
(35, 3, 5, '2026-11-11', 8417, 0, 'lunas', '2026-06-11 14:48:50', '2026-06-11 15:17:42'),
(36, 3, 6, '2026-12-11', 8417, 0, 'lunas', '2026-06-11 14:48:50', '2026-06-11 15:17:45'),
(37, 3, 7, '2027-01-11', 8417, 0, 'lunas', '2026-06-11 14:48:50', '2026-06-11 15:17:52'),
(38, 3, 8, '2027-02-11', 8417, 0, 'lunas', '2026-06-11 14:48:50', '2026-06-11 15:17:57'),
(39, 3, 9, '2027-03-11', 8417, 0, 'lunas', '2026-06-11 14:48:50', '2026-06-11 15:18:01'),
(40, 3, 10, '2027-04-11', 8417, 0, 'lunas', '2026-06-11 14:48:50', '2026-06-11 15:18:05'),
(41, 3, 11, '2027-05-11', 8417, 0, 'lunas', '2026-06-11 14:48:50', '2026-06-11 15:18:09'),
(42, 3, 12, '2027-06-11', 8417, 0, 'lunas', '2026-06-11 14:48:50', '2026-06-11 15:18:13'),
(43, 4, 1, '2026-07-11', 842, 9258, 'belum_lunas', '2026-06-11 15:16:06', '2026-06-11 15:16:06'),
(44, 4, 2, '2026-08-11', 842, 8417, 'belum_lunas', '2026-06-11 15:16:06', '2026-06-11 15:16:06'),
(45, 4, 3, '2026-09-11', 842, 7575, 'belum_lunas', '2026-06-11 15:16:06', '2026-06-11 15:16:06'),
(46, 4, 4, '2026-10-11', 842, 6733, 'belum_lunas', '2026-06-11 15:16:06', '2026-06-11 15:16:06'),
(47, 4, 5, '2026-11-11', 842, 5892, 'belum_lunas', '2026-06-11 15:16:06', '2026-06-11 15:16:06'),
(48, 4, 6, '2026-12-11', 842, 5050, 'belum_lunas', '2026-06-11 15:16:06', '2026-06-11 15:16:06'),
(49, 4, 7, '2027-01-11', 842, 4208, 'belum_lunas', '2026-06-11 15:16:06', '2026-06-11 15:16:06'),
(50, 4, 8, '2027-02-11', 842, 3367, 'belum_lunas', '2026-06-11 15:16:06', '2026-06-11 15:16:06'),
(51, 4, 9, '2027-03-11', 842, 2525, 'belum_lunas', '2026-06-11 15:16:06', '2026-06-11 15:16:06'),
(52, 4, 10, '2027-04-11', 842, 1683, 'belum_lunas', '2026-06-11 15:16:06', '2026-06-11 15:16:06'),
(53, 4, 11, '2027-05-11', 842, 842, 'belum_lunas', '2026-06-11 15:16:06', '2026-06-11 15:16:06'),
(54, 4, 12, '2027-06-11', 842, 0, 'belum_lunas', '2026-06-11 15:16:06', '2026-06-11 15:16:06'),
(55, 5, 1, '2026-07-11', 8, 93, 'belum_lunas', '2026-06-11 15:16:17', '2026-06-11 15:16:17'),
(56, 5, 2, '2026-08-11', 8, 84, 'belum_lunas', '2026-06-11 15:16:17', '2026-06-11 15:16:17'),
(57, 5, 3, '2026-09-11', 8, 76, 'belum_lunas', '2026-06-11 15:16:17', '2026-06-11 15:16:17'),
(58, 5, 4, '2026-10-11', 8, 67, 'belum_lunas', '2026-06-11 15:16:17', '2026-06-11 15:16:17'),
(59, 5, 5, '2026-11-11', 8, 59, 'belum_lunas', '2026-06-11 15:16:17', '2026-06-11 15:16:17'),
(60, 5, 6, '2026-12-11', 8, 51, 'belum_lunas', '2026-06-11 15:16:17', '2026-06-11 15:16:17'),
(61, 5, 7, '2027-01-11', 8, 42, 'belum_lunas', '2026-06-11 15:16:17', '2026-06-11 15:16:17'),
(62, 5, 8, '2027-02-11', 8, 34, 'belum_lunas', '2026-06-11 15:16:17', '2026-06-11 15:16:17'),
(63, 5, 9, '2027-03-11', 8, 25, 'belum_lunas', '2026-06-11 15:16:17', '2026-06-11 15:16:17'),
(64, 5, 10, '2027-04-11', 8, 17, 'belum_lunas', '2026-06-11 15:16:17', '2026-06-11 15:16:17'),
(65, 5, 11, '2027-05-11', 8, 8, 'belum_lunas', '2026-06-11 15:16:17', '2026-06-11 15:16:17'),
(66, 5, 12, '2027-06-11', 8, 0, 'belum_lunas', '2026-06-11 15:16:17', '2026-06-11 15:16:17'),
(70, 7, 1, '2026-09-01', 16833, 0, 'lunas', '2026-08-01 07:23:13', '2026-08-01 07:23:35'),
(71, 7, 2, '2026-10-01', 16833, 0, 'lunas', '2026-08-01 07:23:13', '2026-08-01 07:23:48'),
(72, 7, 3, '2026-11-01', 16833, 50500, 'belum_lunas', '2026-08-01 07:23:13', '2026-08-01 07:23:13'),
(73, 7, 4, '2026-12-01', 16833, 33667, 'belum_lunas', '2026-08-01 07:23:13', '2026-08-01 07:23:13'),
(74, 7, 5, '2027-01-01', 16833, 16833, 'belum_lunas', '2026-08-01 07:23:13', '2026-08-01 07:23:13'),
(75, 7, 6, '2027-02-01', 16833, 0, 'belum_lunas', '2026-08-01 07:23:13', '2026-08-01 07:23:13'),
(76, 8, 1, '2026-09-01', 50500, 0, 'lunas', '2026-08-01 09:21:06', '2026-08-01 09:21:20'),
(77, 8, 2, '2026-10-01', 50500, 0, 'lunas', '2026-08-01 09:21:06', '2026-08-01 09:21:31'),
(78, 8, 3, '2026-11-01', 50500, 0, 'lunas', '2026-08-01 09:21:06', '2026-08-01 09:22:28'),
(79, 8, 4, '2026-12-01', 50500, 0, 'lunas', '2026-08-01 09:21:06', '2026-08-01 09:22:35'),
(80, 8, 5, '2027-01-01', 50500, 0, 'lunas', '2026-08-01 09:21:06', '2026-08-01 09:22:41'),
(81, 8, 6, '2027-02-01', 50500, 0, 'lunas', '2026-08-01 09:21:06', '2026-08-01 09:22:57');

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

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

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

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

--
-- Struktur dari tabel `settings`
--

CREATE TABLE `settings` (
  `id` bigint UNSIGNED NOT NULL,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `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 `settings`
--

INSERT INTO `settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'nama_koperasi', 'KoperasiKu', NULL, '2026-06-05 04:23:00'),
(2, 'tagline', 'Solusi Keuangan Bersama', NULL, NULL),
(5, 'denda_persen_per_hari', '0.5', NULL, NULL),
(6, 'nama_aplikasi', 'KoperasiKu', NULL, '2026-06-05 04:22:49'),
(7, 'bunga_default', '1', NULL, NULL),
(8, 'logo', 'uploads/settings/yWFwQdwrt9Rn7GNUCBTQVLYAcBFAnl12ZuHZaMsn.png', '2026-06-05 22:48:08', '2026-06-05 22:52:11'),
(9, 'favicon', 'uploads/settings/pjj7qORgxs6SoxeTqNqsKUnyKYia9fSvrdmiL1HA.png', '2026-06-05 22:48:08', '2026-06-05 22:52:18');

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

--
-- Struktur dari tabel `simpanan`
--

CREATE TABLE `simpanan` (
  `id` bigint UNSIGNED NOT NULL,
  `no_simpanan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal` date NOT NULL,
  `anggota_id` bigint UNSIGNED NOT NULL,
  `jenis_simpanan` enum('pokok','wajib','sukarela') COLLATE utf8mb4_unicode_ci NOT NULL,
  `nominal` decimal(15,2) NOT NULL,
  `status` enum('pending','disetujui','ditolak') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `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 `simpanan`
--

INSERT INTO `simpanan` (`id`, `no_simpanan`, `tanggal`, `anggota_id`, `jenis_simpanan`, `nominal`, `status`, `created_at`, `updated_at`) VALUES
(3, 'SPN-20260605-0003', '2024-01-10', 3, 'pokok', 500000.00, 'disetujui', '2026-06-05 03:17:47', '2026-06-05 03:20:22'),
(4, 'SPN-20260605-0004', '2024-01-10', 4, 'pokok', 500000.00, 'disetujui', '2026-06-05 03:17:47', '2026-06-05 03:20:22'),
(6, 'SPN-20260605-0006', '2024-01-15', 2, 'wajib', 100000.00, 'ditolak', '2026-06-05 03:17:47', '2026-06-05 03:20:22'),
(7, 'SPN-20260605-0007', '2024-01-15', 3, 'wajib', 100000.00, 'disetujui', '2026-06-05 03:17:47', '2026-06-05 03:20:22'),
(8, 'SPN-20260605-0008', '2024-01-20', 5, 'pokok', 500000.00, 'disetujui', '2026-06-05 03:17:47', '2026-06-05 03:20:22'),
(9, 'SPN-20260605-0009', '2024-01-20', 5, 'sukarela', 200000.00, 'disetujui', '2026-06-05 03:17:47', '2026-06-05 03:20:22'),
(11, 'SPN-20260605-0011', '2024-02-15', 2, 'wajib', 100000.00, 'pending', '2026-06-05 03:17:47', '2026-06-05 03:20:22'),
(12, 'SPN-20260605-0012', '2024-02-15', 3, 'wajib', 100000.00, 'pending', '2026-06-05 03:17:47', '2026-06-05 03:20:22'),
(13, 'SPN-20260605-0013', '2024-02-20', 5, 'sukarela', 150000.00, 'disetujui', '2026-06-05 03:17:47', '2026-06-05 03:20:22'),
(14, 'SPN-20260605-0014', '2024-03-10', 6, 'pokok', 500000.00, 'disetujui', '2026-06-05 03:17:47', '2026-06-05 03:20:22'),
(15, 'SPN-20260605-0015', '2024-03-15', 6, 'wajib', 100000.00, 'disetujui', '2026-06-05 03:17:47', '2026-06-05 03:20:22'),
(17, 'SPN-20260605-0017', '2024-03-15', 2, 'wajib', 100000.00, 'disetujui', '2026-06-05 03:17:47', '2026-06-05 03:20:22'),
(18, 'SPN-20260605-0018', '2024-04-01', 7, 'pokok', 500000.00, 'disetujui', '2026-06-05 03:17:47', '2026-06-05 03:20:22'),
(19, 'SPN-20260605-0019', '2024-04-15', 7, 'wajib', 100000.00, 'disetujui', '2026-06-05 03:17:47', '2026-06-05 03:20:22'),
(20, 'SPN-20260611-0001', '1999-09-19', 20, 'wajib', 1000000.00, 'disetujui', '2026-06-11 14:56:04', '2026-06-11 14:56:04'),
(21, 'SPN-20260801-0001', '2026-08-01', 2, 'pokok', 200000.00, 'disetujui', '2026-08-01 07:22:15', '2026-08-01 07:22:15'),
(22, 'SPN-20260801-0002', '2026-08-01', 16, 'pokok', 500000.00, 'disetujui', '2026-08-01 09:19:59', '2026-08-01 09:20:12');

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

--
-- Struktur dari tabel `users`
--

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) 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,
  `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user',
  `foto` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 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 `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `foto`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Suni Marhaban', 'admin@malasngoding.com', NULL, '$2y$12$s9I7mUsl2m8PRD9RccwWee2OoSgEEyTmgf5UN7p698ZMUzJSd5i9y', 'admin', 'uploads/users/DZioNstSkZjm6k99LTJgHO4wUKOSlRBtW1sajDbM.jpg', NULL, '2026-06-05 02:35:24', '2026-06-11 14:37:41');

--
-- Indeks untuk tabel yang dibuang
--

--
-- Indeks untuk tabel `anggota`
--
ALTER TABLE `anggota`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `anggota_no_anggota_unique` (`no_anggota`),
  ADD UNIQUE KEY `anggota_email_unique` (`email`);

--
-- Indeks untuk tabel `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_expiration_index` (`expiration`);

--
-- Indeks untuk tabel `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_locks_expiration_index` (`expiration`);

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

--
-- 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 `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indeks untuk tabel `pembayaran`
--
ALTER TABLE `pembayaran`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pembayaran_pinjaman_detail_id_foreign` (`pinjaman_detail_id`);

--
-- Indeks untuk tabel `pinjaman`
--
ALTER TABLE `pinjaman`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pinjaman_no_pinjaman_unique` (`no_pinjaman`),
  ADD KEY `pinjaman_anggota_id_foreign` (`anggota_id`);

--
-- Indeks untuk tabel `pinjaman_detail`
--
ALTER TABLE `pinjaman_detail`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pinjaman_detail_pinjaman_id_foreign` (`pinjaman_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`);

--
-- Indeks untuk tabel `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_key_unique` (`key`);

--
-- Indeks untuk tabel `simpanan`
--
ALTER TABLE `simpanan`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `simpanan_no_simpanan_unique` (`no_simpanan`),
  ADD KEY `simpanan_anggota_id_foreign` (`anggota_id`);

--
-- Indeks untuk tabel `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `anggota`
--
ALTER TABLE `anggota`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

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

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

--
-- AUTO_INCREMENT untuk tabel `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT untuk tabel `pembayaran`
--
ALTER TABLE `pembayaran`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT untuk tabel `pinjaman`
--
ALTER TABLE `pinjaman`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT untuk tabel `pinjaman_detail`
--
ALTER TABLE `pinjaman_detail`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=82;

--
-- AUTO_INCREMENT untuk tabel `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT untuk tabel `simpanan`
--
ALTER TABLE `simpanan`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT untuk tabel `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- Ketidakleluasaan untuk tabel `pembayaran`
--
ALTER TABLE `pembayaran`
  ADD CONSTRAINT `pembayaran_pinjaman_detail_id_foreign` FOREIGN KEY (`pinjaman_detail_id`) REFERENCES `pinjaman_detail` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `pinjaman`
--
ALTER TABLE `pinjaman`
  ADD CONSTRAINT `pinjaman_anggota_id_foreign` FOREIGN KEY (`anggota_id`) REFERENCES `anggota` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `pinjaman_detail`
--
ALTER TABLE `pinjaman_detail`
  ADD CONSTRAINT `pinjaman_detail_pinjaman_id_foreign` FOREIGN KEY (`pinjaman_id`) REFERENCES `pinjaman` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `simpanan`
--
ALTER TABLE `simpanan`
  ADD CONSTRAINT `simpanan_anggota_id_foreign` FOREIGN KEY (`anggota_id`) REFERENCES `anggota` (`id`) ON DELETE CASCADE;
COMMIT;

