-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 07 Bulan Mei 2026 pada 13.25
-- Versi server: 10.4.32-MariaDB
-- Versi PHP: 8.1.25

START TRANSACTION;



--
-- Database: `mnjnadminsklh`
--

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

--
-- Struktur dari tabel `anggotarombel`
--

CREATE TABLE `anggotarombel` (
  `id` int(10) UNSIGNED NOT NULL,
  `pesdik_id` int(10) UNSIGNED NOT NULL,
  `rombel_id` int(10) UNSIGNED 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 `anggotarombel`
--

INSERT INTO `anggotarombel` (`id`, `pesdik_id`, `rombel_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '2022-09-13 02:10:22', '2022-09-13 02:10:22'),
(2, 2, 1, '2022-09-14 14:42:02', '2022-09-14 14:42:02'),
(3, 4, 1, '2023-02-03 11:50:52', '2023-02-03 11:50:52'),
(4, 3, 2, '2026-02-25 17:59:05', '2026-02-25 17:59:05'),
(5, 1, 2, '2026-02-25 17:59:05', '2026-02-25 17:59:05'),
(6, 2, 2, '2026-02-25 17:59:05', '2026-02-25 17:59:05'),
(7, 4, 2, '2026-02-25 17:59:05', '2026-02-25 17:59:05'),
(8, 5, 3, '2026-04-08 03:41:54', '2026-04-08 03:41:54'),
(9, 6, 3, '2026-04-15 14:13:32', '2026-04-15 14:13:32'),
(10, 7, 5, '2026-04-15 14:59:35', '2026-04-15 14:59:35'),
(11, 8, 5, '2026-04-15 15:05:34', '2026-04-15 15:05:34'),
(12, 9, 5, '2026-04-15 15:22:50', '2026-04-15 15:22:50'),
(13, 10, 4, '2026-04-17 06:51:39', '2026-04-17 06:51:39'),
(14, 10, 7, '2026-04-17 07:03:23', '2026-04-17 07:03:23'),
(15, 10, 8, '2026-04-17 07:06:42', '2026-04-17 07:06:42'),
(16, 10, 9, '2026-04-17 07:11:50', '2026-04-17 07:11:50'),
(17, 10, 10, '2026-04-17 07:16:11', '2026-04-17 07:16:11');

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

--
-- Struktur dari tabel `disposisis`
--

CREATE TABLE `disposisis` (
  `id` int(10) UNSIGNED NOT NULL,
  `users_id` int(10) UNSIGNED NOT NULL,
  `suratmasuk_id` int(10) UNSIGNED NOT NULL,
  `tujuan` varchar(30) NOT NULL,
  `isi` varchar(30) NOT NULL,
  `sifat` varchar(25) NOT NULL,
  `batas_waktu` date NOT NULL,
  `catatan` varchar(50) 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 `disposisis`
--

INSERT INTO `disposisis` (`id`, `users_id`, `suratmasuk_id`, `tujuan`, `isi`, `sifat`, `batas_waktu`, `catatan`, `created_at`, `updated_at`) VALUES
(1, 1, 2, 'Penelitian', 'Permohonan Penelitian', 'Penting Sekali', '2026-04-30', 'di lanjutkan ke kakomli', '2026-04-13 05:27:13', '2026-04-13 05:27:13'),
(2, 1, 1, 'Penelitian', 'Permohonan Penelitian', 'Penting Sekali', '2026-04-15', 'di lanjutkan ke kakomli', '2026-04-15 10:25:48', '2026-04-15 10:25:48'),
(3, 1, 1, 'pengembangan', 'permohonan pengembangan', 'penting', '2026-04-15', 'di lanjutkan ke kepala sekolah', '2026-04-15 11:14:44', '2026-04-15 11:14:44'),
(4, 1, 3, 'undangan', 'undangan resmi', 'penting', '2026-04-16', 'dilanjukan ke kepala sekolah', '2026-04-15 11:23:57', '2026-04-15 11:23:57'),
(5, 5, 2, 'pengembangan', 'permohonan pengembangan', 'penting', '2026-04-30', 'di lanjutkan ke kepala sekolah', '2026-04-15 15:38:45', '2026-04-15 15:38:45');

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

--
-- Struktur dari tabel `guru`
--

CREATE TABLE `guru` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(30) NOT NULL,
  `jenis_kelamin` varchar(9) NOT NULL,
  `tempat_lahir` varchar(25) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `alamat` varchar(100) NOT NULL,
  `no_hp` varchar(13) NOT NULL,
  `email` varchar(35) 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 `guru`
--

INSERT INTO `guru` (`id`, `nama`, `jenis_kelamin`, `tempat_lahir`, `tanggal_lahir`, `alamat`, `no_hp`, `email`, `created_at`, `updated_at`) VALUES
(1, 'SARINEM', 'Perempuan', 'Kab. Nganjuk', '1988-09-13', 'Gang 7 asdsda', '0811111111111', 'sarinem@gmail.com', '2022-09-13 02:07:38', '2022-09-13 02:07:38'),
(2, 'KRISNA MAHA MERU S.KOM', 'Laki-Laki', 'NGANJUK', '2002-06-04', 'MUSIR KIDUL NGANJUK', '085607024776', 'krisna@gmail.com', '2026-04-15 13:38:22', '2026-04-15 13:38:22'),
(3, 'SURADI S.KOM', 'Laki-Laki', 'NGANJUK', '1997-06-19', 'PACE NGANJUK', '067856456347', 'SURADI@GMAIL.COM', '2026-04-17 07:02:22', '2026-04-17 07:02:22'),
(4, 'DIMAS', 'Laki-Laki', 'NGANJUK', '2003-02-02', 'SUKOREJO NGANJUK', '0867895678908', 'DIMAS@GMAIL.COM', '2026-04-17 07:10:32', '2026-04-17 07:10:32');

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

--
-- Struktur dari tabel `instansis`
--

CREATE TABLE `instansis` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(30) NOT NULL,
  `alamat` varchar(100) NOT NULL,
  `pimpinan` varchar(100) NOT NULL,
  `email` varchar(35) NOT NULL,
  `file` varchar(50) 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 `instansis`
--

INSERT INTO `instansis` (`id`, `nama`, `alamat`, `pimpinan`, `email`, `file`, `created_at`, `updated_at`) VALUES
(1, 'SMK AL HUSNA', 'JL. RAYA KEDIRI GG. KWAGEAN NO. 4 LOCERET, Kec. Loceret, Kab. Nganjuk, Prov. Jawa Timur', 'H. Riza Fachri, S.Kom', 'smksalhusna.nganjuk@gmail.com', 'uploads/logo/1772041809LOGO SMK.jpg', '2022-06-07 15:29:24', '2026-05-07 11:16:10');

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

--
-- Struktur dari tabel `kategori`
--

CREATE TABLE `kategori` (
  `id` int(10) UNSIGNED NOT NULL,
  `jenis_kategori` int(11) NOT NULL,
  `nama_kategori` varchar(25) 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 `kategori`
--

INSERT INTO `kategori` (`id`, `jenis_kategori`, `nama_kategori`, `created_at`, `updated_at`) VALUES
(1, 1, 'Pembayaran Siswa', '2022-06-07 15:29:24', '2022-06-07 15:29:24'),
(2, 1, 'PEMBAYARAN SPP', '2022-09-14 14:37:51', '2022-09-14 14:37:51'),
(3, 2, 'Pengeluaran Dana Bos', '2026-04-08 02:25:15', '2026-04-08 02:25:15'),
(4, 2, 'Pengeluaran Dana BPOPP', '2026-04-08 02:25:40', '2026-04-08 02:25:40'),
(5, 2, 'cetak LKPD', '2026-04-18 04:40:54', '2026-04-18 04:40:54');

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

--
-- Struktur dari tabel `klasifikasi`
--

CREATE TABLE `klasifikasi` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(20) NOT NULL,
  `kode` varchar(2) NOT NULL,
  `uraian` text 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 `klasifikasi`
--

INSERT INTO `klasifikasi` (`id`, `nama`, `kode`, `uraian`, `created_at`, `updated_at`) VALUES
(1, 'SMK AL HUSNA', '01', 'SMK AL HUSNA', '2022-06-07 15:35:11', '2026-02-25 17:51:15');

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

--
-- Struktur dari tabel `login`
--

CREATE TABLE `login` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(30) NOT NULL,
  `email` varchar(35) 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 `login`
--

INSERT INTO `login` (`id`, `name`, `email`, `created_at`, `updated_at`) VALUES
(17, 'Administrator', 'zainulwafa1983@gmail.com', '2026-02-25 18:04:28', '2026-02-25 18:04:28'),
(18, 'Administrator', 'zainulwafa1983@gmail.com', '2026-02-25 18:05:51', '2026-02-25 18:05:51'),
(19, 'Administrator', 'zainulwafa1983@gmail.com', '2026-02-26 00:38:37', '2026-02-26 00:38:37'),
(20, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-02-26 00:47:21', '2026-02-26 00:47:21'),
(21, 'Surat', 'Suratwafa@gmail.com', '2026-02-26 00:47:41', '2026-02-26 00:47:41'),
(22, 'Keuangan', 'zainul123@gmail.com', '2026-02-26 00:49:28', '2026-02-26 00:49:28'),
(23, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-03-07 14:17:08', '2026-03-07 14:17:08'),
(24, 'Surat', 'Suratwafa@gmail.com', '2026-03-07 14:18:08', '2026-03-07 14:18:08'),
(25, 'Keuangan', 'zainul123@gmail.com', '2026-03-07 14:18:31', '2026-03-07 14:18:31'),
(26, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-03-07 14:20:57', '2026-03-07 14:20:57'),
(27, 'Parni', '2222222222@siswa.com', '2026-03-07 14:21:59', '2026-03-07 14:21:59'),
(28, 'Parni', '2222222222@siswa.com', '2026-03-07 14:59:31', '2026-03-07 14:59:31'),
(29, 'Parni', '2222222222@siswa.com', '2026-03-07 14:59:43', '2026-03-07 14:59:43'),
(30, 'Parni', '2222222222@siswa.com', '2026-03-07 15:06:55', '2026-03-07 15:06:55'),
(31, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-03-07 15:10:15', '2026-03-07 15:10:15'),
(32, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-03-08 16:49:53', '2026-03-08 16:49:53'),
(33, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-03-08 17:08:47', '2026-03-08 17:08:47'),
(34, 'Paijo', '2222222222@siswa.com', '2026-03-08 17:45:35', '2026-03-08 17:45:35'),
(35, 'Surat', 'Suratwafa@gmail.com', '2026-03-08 18:02:41', '2026-03-08 18:02:41'),
(36, 'Keuangan', 'zainul123@gmail.com', '2026-03-08 18:03:44', '2026-03-08 18:03:44'),
(37, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-03-08 18:07:16', '2026-03-08 18:07:16'),
(38, 'Keuangan', 'zainul123@gmail.com', '2026-03-08 19:11:32', '2026-03-08 19:11:32'),
(39, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-03-25 11:03:32', '2026-03-25 11:03:32'),
(40, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-06 12:11:59', '2026-04-06 12:11:59'),
(41, 'Surat', 'Suratwafa@gmail.com', '2026-04-06 12:14:59', '2026-04-06 12:14:59'),
(42, 'Keuangan', 'zainul123@gmail.com', '2026-04-06 12:15:36', '2026-04-06 12:15:36'),
(43, 'Paijo', '2222222222@siswa.com', '2026-04-06 12:16:55', '2026-04-06 12:16:55'),
(44, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-08 02:15:28', '2026-04-08 02:15:28'),
(45, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-08 04:25:58', '2026-04-08 04:25:58'),
(46, 'Surat', 'Suratwafa@gmail.com', '2026-04-08 05:57:59', '2026-04-08 05:57:59'),
(47, 'Surat', 'Suratwafa@gmail.com', '2026-04-09 03:10:45', '2026-04-09 03:10:45'),
(48, 'Keuangan', 'zainul123@gmail.com', '2026-04-09 03:43:25', '2026-04-09 03:43:25'),
(49, 'Keuangan', 'zainul123@gmail.com', '2026-04-09 03:56:18', '2026-04-09 03:56:18'),
(50, 'Keuangan', 'zainul123@gmail.com', '2026-04-09 09:18:00', '2026-04-09 09:18:00'),
(51, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-09 09:45:31', '2026-04-09 09:45:31'),
(52, 'Rama Briliant', '2020112234@siswa.com', '2026-04-09 09:46:33', '2026-04-09 09:46:33'),
(53, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-11 14:49:42', '2026-04-11 14:49:42'),
(54, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-13 05:10:03', '2026-04-13 05:10:03'),
(55, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-13 05:15:10', '2026-04-13 05:15:10'),
(56, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-15 10:24:56', '2026-04-15 10:24:56'),
(57, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-15 15:19:35', '2026-04-15 15:19:35'),
(58, 'Surat', 'Suratwafa@gmail.com', '2026-04-15 15:37:58', '2026-04-15 15:37:58'),
(59, 'Keuangan', 'zainul123@gmail.com', '2026-04-15 15:40:23', '2026-04-15 15:40:23'),
(60, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-16 00:36:15', '2026-04-16 00:36:15'),
(61, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-16 00:36:46', '2026-04-16 00:36:46'),
(62, 'Keuangan', 'zainul123@gmail.com', '2026-04-16 00:37:14', '2026-04-16 00:37:14'),
(63, 'Rama Briliant', '2020112234@siswa.com', '2026-04-16 02:33:46', '2026-04-16 02:33:46'),
(64, 'Rama Briliant', '2020112234@siswa.com', '2026-04-16 06:16:44', '2026-04-16 06:16:44'),
(65, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-16 06:25:26', '2026-04-16 06:25:26'),
(66, 'Paijo', '2222222222@siswa.com', '2026-04-16 06:29:26', '2026-04-16 06:29:26'),
(67, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-16 06:36:18', '2026-04-16 06:36:18'),
(68, 'Rama Briliant', '2020112234@siswa.com', '2026-04-16 06:37:41', '2026-04-16 06:37:41'),
(69, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-16 06:38:24', '2026-04-16 06:38:24'),
(70, 'arya ramadani', '2020112235@siswa.com', '2026-04-16 06:42:27', '2026-04-16 06:42:27'),
(71, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-16 06:43:11', '2026-04-16 06:43:11'),
(72, 'Rama Briliant', '2020112234@siswa.com', '2026-04-16 06:44:21', '2026-04-16 06:44:21'),
(73, 'Paijo', '2222222222@siswa.com', '2026-04-16 06:44:44', '2026-04-16 06:44:44'),
(74, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-16 06:45:32', '2026-04-16 06:45:32'),
(75, 'arya ramadani', '2020112235@siswa.com', '2026-04-16 06:46:18', '2026-04-16 06:46:18'),
(76, 'arya ramadani', '2020112235@siswa.com', '2026-04-17 06:07:26', '2026-04-17 06:07:26'),
(77, 'Surat', 'Suratwafa@gmail.com', '2026-04-17 06:08:09', '2026-04-17 06:08:09'),
(78, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-17 06:21:04', '2026-04-17 06:21:04'),
(79, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-18 01:56:12', '2026-04-18 01:56:12'),
(80, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-18 01:56:36', '2026-04-18 01:56:36'),
(81, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-18 01:57:38', '2026-04-18 01:57:38'),
(82, 'DODIK', '2567889754@siswa.com', '2026-04-18 01:58:22', '2026-04-18 01:58:22'),
(83, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-18 04:29:05', '2026-04-18 04:29:05'),
(84, 'Keuangan', 'zainul123@gmail.com', '2026-04-18 04:30:01', '2026-04-18 04:30:01'),
(85, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-18 04:32:51', '2026-04-18 04:32:51'),
(86, 'Rama Briliant', '2020112234@siswa.com', '2026-04-19 10:55:44', '2026-04-19 10:55:44'),
(87, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-19 14:18:34', '2026-04-19 14:18:34'),
(88, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-20 14:40:44', '2026-04-20 14:40:44'),
(89, 'Surat', 'Suratwafa@gmail.com', '2026-04-20 15:10:07', '2026-04-20 15:10:07'),
(90, 'Keuangan', 'zainul123@gmail.com', '2026-04-20 15:18:57', '2026-04-20 15:18:57'),
(91, 'arya ramadani', '2020112235@siswa.com', '2026-04-20 15:28:51', '2026-04-20 15:28:51'),
(92, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-22 05:17:45', '2026-04-22 05:17:45'),
(93, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-04-22 12:19:27', '2026-04-22 12:19:27'),
(94, 'Zainul Wafa', 'zainulwafa1983@gmail.com', '2026-05-07 11:11:36', '2026-05-07 11:11:36');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) 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, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
(4, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
(5, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
(6, '2016_06_01_000004_create_oauth_clients_table', 1),
(7, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
(8, '2020_01_12_102424_create_suratmasuk_table', 1),
(9, '2020_01_12_102608_create_suratkeluar_table', 1),
(10, '2020_01_12_102751_create_klasifikasi_table', 1),
(11, '2020_02_01_150517_create_instansis_table', 1),
(12, '2020_02_03_030401_create_disposisi_table', 1),
(13, '2020_03_11_105629_create_guru_table', 1),
(14, '2020_03_11_151552_create_tendik_table', 1),
(15, '2020_03_11_165200_create_rombel_table', 1),
(16, '2020_03_12_002830_create_pesdik_table', 1),
(17, '2020_03_14_035908_create_pengumuman_table', 1),
(18, '2020_03_15_132829_create_pesdikkeluar_table', 1),
(19, '2020_03_16_145519_create_pesdikalumni_table', 1),
(20, '2020_03_18_045010_create_tapel_table', 1),
(21, '2020_03_18_145532_create_kategori_table', 1),
(22, '2020_03_18_152452_create_pemasukan_table', 1),
(23, '2020_03_21_101644_create_pengeluaran_table', 1),
(24, '2020_03_21_142613_create_setor_table', 1),
(25, '2020_03_22_034043_create_tarik_table', 1),
(26, '2020_03_24_044951_create_anggotarombel_table', 1),
(27, '2020_03_24_133753_create_tagihan_table', 1),
(28, '2020_04_08_142650_create_transaksipembayaran_table', 1),
(29, '2020_06_18_222709_create_login_table', 1),
(30, '2020_06_19_014420_tambah_foreign_key_constraint', 1);

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

--
-- Struktur dari tabel `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED 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 `pemasukan`
--

CREATE TABLE `pemasukan` (
  `id` int(10) UNSIGNED NOT NULL,
  `kategori_id` int(10) UNSIGNED NOT NULL,
  `tanggal` date NOT NULL,
  `jumlah` int(11) NOT NULL,
  `keterangan` varchar(50) 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 `pemasukan`
--

INSERT INTO `pemasukan` (`id`, `kategori_id`, `tanggal`, `jumlah`, `keterangan`, `created_at`, `updated_at`) VALUES
(1, 2, '0000-00-00', 500000, 'PEMBAYARAN SPP', '2022-09-14 14:38:04', '2022-09-14 14:38:04'),
(2, 1, '0000-00-00', 100000, 'Panjul A.B', '2022-09-14 15:46:56', '2022-09-14 15:46:56'),
(3, 1, '0000-00-00', 850000, 'Parni', '2022-09-15 16:20:28', '2022-09-15 16:20:28'),
(4, 1, '0000-00-00', 850000, 'ASAD', '2022-09-15 16:20:59', '2022-09-15 16:20:59'),
(5, 1, '0000-00-00', 100000, 'Paijo', '2026-03-08 16:52:20', '2026-03-08 16:52:20'),
(6, 2, '0000-00-00', 500, 'Pembayaran SPP', '2026-04-08 02:23:56', '2026-04-08 02:23:56'),
(7, 1, '0000-00-00', 50000, 'ASAD', '2026-04-08 02:33:17', '2026-04-08 02:33:17'),
(8, 1, '0000-00-00', 100000, 'ASAD', '2026-04-08 02:33:43', '2026-04-08 02:33:43'),
(9, 1, '0000-00-00', 50000, 'Panjul A.B', '2026-04-08 02:50:52', '2026-04-08 02:50:52'),
(10, 1, '0000-00-00', 85000, 'Rama Briliant', '2026-04-13 06:23:10', '2026-04-13 06:23:10'),
(11, 1, '0000-00-00', 85000, 'Rama Briliant', '2026-04-15 11:56:41', '2026-04-15 11:56:41'),
(12, 1, '0000-00-00', 100000, 'Rama Briliant', '2026-04-15 12:01:38', '2026-04-15 12:01:38'),
(13, 1, '0000-00-00', 200000, 'Rama Briliant', '2026-04-15 12:07:06', '2026-04-15 12:07:06'),
(14, 1, '0000-00-00', 200000, 'Rama Briliant', '2026-04-15 12:08:39', '2026-04-15 12:08:39'),
(15, 1, '0000-00-00', 400000, 'Rama Briliant', '2026-04-15 12:14:06', '2026-04-15 12:14:06'),
(16, 1, '0000-00-00', 95000, 'Rama Briliant', '2026-04-15 12:15:48', '2026-04-15 12:15:48'),
(17, 1, '0000-00-00', 190000, 'Rama Briliant', '2026-04-15 12:45:27', '2026-04-15 12:45:27'),
(18, 1, '0000-00-00', 285000, 'Rama Briliant', '2026-04-15 13:09:47', '2026-04-15 13:09:47'),
(19, 1, '0000-00-00', 380000, 'Rama Briliant', '2026-04-15 13:15:17', '2026-04-15 13:15:17'),
(20, 1, '0000-00-00', 475000, 'Rama Briliant', '2026-04-15 13:16:41', '2026-04-15 13:16:41'),
(21, 1, '0000-00-00', 85000, 'arya ramadani', '2026-04-16 00:39:11', '2026-04-16 00:39:11'),
(22, 1, '0000-00-00', 85000, 'arya ramadani', '2026-04-16 02:30:09', '2026-04-16 02:30:09'),
(23, 1, '0000-00-00', 100000, 'arya ramadani', '2026-04-16 06:26:03', '2026-04-16 06:26:03'),
(24, 1, '0000-00-00', 85000, 'arya ramadani', '2026-04-16 06:43:48', '2026-04-16 06:43:48'),
(25, 1, '0000-00-00', 85000, 'dono setiawan', '2026-04-17 06:47:57', '2026-04-17 06:47:57'),
(26, 1, '0000-00-00', 85000, 'DODIK', '2026-04-17 07:19:44', '2026-04-17 07:19:44'),
(27, 1, '0000-00-00', 1260000, 'DODIK', '2026-04-17 07:27:03', '2026-04-17 07:27:03'),
(28, 1, '0000-00-00', 200000, 'arya ramadani', '2026-04-18 04:43:41', '2026-04-18 04:43:41'),
(29, 1, '0000-00-00', 85000, 'arya ramadani', '2026-04-22 05:20:06', '2026-04-22 05:20:06');

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

--
-- Struktur dari tabel `pengeluaran`
--

CREATE TABLE `pengeluaran` (
  `id` int(10) UNSIGNED NOT NULL,
  `kategori_id` int(10) UNSIGNED NOT NULL,
  `tanggal` date NOT NULL,
  `jumlah` int(11) NOT NULL,
  `keterangan` varchar(50) 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 `pengeluaran`
--

INSERT INTO `pengeluaran` (`id`, `kategori_id`, `tanggal`, `jumlah`, `keterangan`, `created_at`, `updated_at`) VALUES
(1, 3, '0000-00-00', 5000, 'Anggaran UKK 2026', '2026-04-08 02:26:12', '2026-04-08 02:26:12'),
(2, 5, '0000-00-00', 1000000, 'ikbhytrfr5', '2026-04-18 04:41:34', '2026-04-18 04:41:34');

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

--
-- Struktur dari tabel `pengumuman`
--

CREATE TABLE `pengumuman` (
  `id` int(10) UNSIGNED NOT NULL,
  `judul` varchar(50) NOT NULL,
  `isi` text NOT NULL,
  `users_id` int(10) UNSIGNED 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 `pengumuman`
--

INSERT INTO `pengumuman` (`id`, `judul`, `isi`, `users_id`, `created_at`, `updated_at`) VALUES
(2, 'Setting Data Master', '<p>Pastikan administrator sudah melakukan setting data master pada menu KELOLA DATA, mulai dari data Sekolah, GTK, Tahun Pelajaran, Rombongan Belajar dan Peserta Didik.</p>', 1, '2026-02-26 00:39:31', '2026-02-26 00:39:31'),
(3, 'masuk sekolah', '<p>masuk sekolah mulai tanggal 30 maret 2026</p>', 1, '2026-03-08 18:08:42', '2026-03-08 18:08:42');

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

--
-- Struktur dari tabel `pesdik`
--

CREATE TABLE `pesdik` (
  `id` int(10) UNSIGNED NOT NULL,
  `status` varchar(7) NOT NULL,
  `nama` varchar(30) NOT NULL,
  `jenis_kelamin` varchar(9) NOT NULL,
  `nisn` varchar(10) NOT NULL,
  `induk` varchar(6) NOT NULL,
  `rombel_id` int(10) UNSIGNED NOT NULL,
  `tempat_lahir` varchar(25) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `jenis_pendaftaran` varchar(10) NOT NULL,
  `tanggal_masuk` date 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 `pesdik`
--

INSERT INTO `pesdik` (`id`, `status`, `nama`, `jenis_kelamin`, `nisn`, `induk`, `rombel_id`, `tempat_lahir`, `tanggal_lahir`, `jenis_pendaftaran`, `tanggal_masuk`, `created_at`, `updated_at`) VALUES
(1, 'Keluar', 'Panjul A.B', 'Laki-Laki', '1111111111', '3314', 2, 'Kota Nganjuk', '2013-07-22', 'Siswa Baru', '2026-07-22', '2022-09-13 02:10:22', '2026-04-08 03:50:11'),
(2, 'Keluar', 'Paijo', 'Laki-Laki', '2222222222', '3315', 2, 'Kota Nganjuk', '1999-08-22', 'Siswa Baru', '2024-08-22', '2022-09-14 14:42:02', '2026-04-08 03:49:17'),
(3, 'Keluar', 'ASAD', 'Laki-Laki', '1111111111', '3316', 2, 'Kota Nganjuk', '2013-07-22', 'Siswa Baru', '2024-07-22', '2022-09-13 02:10:22', '2026-04-08 03:45:32'),
(4, 'Keluar', 'udik kuswanto', 'Laki-Laki', '1212133333', '122334', 2, 'Kota Nganjuk', '2023-02-03', 'Siswa Baru', '2024-02-03', '2023-02-03 11:50:51', '2026-04-08 03:50:42'),
(5, 'Aktif', 'Rama Briliant', 'Laki-Laki', '2020112234', '0132', 3, 'Nganjuk', '2005-10-12', 'Siswa Baru', '2026-04-08', '2026-04-08 03:41:54', '2026-04-08 03:41:54'),
(6, 'Aktif', 'arya ramadani', 'Laki-Laki', '2020112235', '0192', 3, 'nganjuk', '2005-10-11', 'Siswa Baru', '2026-04-15', '2026-04-15 14:13:32', '2026-04-15 14:13:32'),
(7, 'Lulus', 'dono setiawan', 'Laki-Laki', '2020112239', '0912', 5, 'nganjuk', '2026-04-15', 'Pindahan', '2026-04-15', '2026-04-15 14:59:35', '2026-04-17 06:47:17'),
(8, 'Keluar', 'andre bagus', 'Laki-Laki', '2020112230', '0910', 5, 'nganjuk', '2003-06-10', 'Pindahan', '2025-02-05', '2026-04-15 15:05:34', '2026-04-15 15:06:36'),
(9, 'Lulus', 'gio ramdani', 'Laki-Laki', '2020112245', '0293', 5, 'nganjuk', '2005-11-23', 'Pindahan', '2025-01-14', '2026-04-15 15:22:50', '2026-04-15 15:36:57'),
(10, 'Lulus', 'DODIK', 'Laki-Laki', '2567889754', '226876', 10, 'nganjuk', '2026-04-01', 'Pindahan', '2026-04-25', '2026-04-17 06:51:39', '2026-04-17 07:20:49');

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

--
-- Struktur dari tabel `pesdikalumni`
--

CREATE TABLE `pesdikalumni` (
  `id` int(10) UNSIGNED NOT NULL,
  `pesdik_id` int(10) UNSIGNED NOT NULL,
  `tanggal_lulus` date NOT NULL,
  `melanjutkan_ke` varchar(20) NOT NULL,
  `keterangan` varchar(100) 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 `pesdikalumni`
--

INSERT INTO `pesdikalumni` (`id`, `pesdik_id`, `tanggal_lulus`, `melanjutkan_ke`, `keterangan`, `created_at`, `updated_at`) VALUES
(1, 9, '2026-05-07', 'Kuliah dan Kerja', 'kuliah di ITM', '2026-04-15 15:36:57', '2026-04-15 15:36:57'),
(2, 7, '2026-05-07', 'Kerja', 'KRGDTFJH,J', '2026-04-17 06:47:17', '2026-04-17 06:47:17'),
(3, 10, '2026-05-08', 'Kuliah dan Kerja', 'HFCHGGGJ,HJGHJGYHGJHVJH', '2026-04-17 07:20:49', '2026-04-17 07:20:49');

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

--
-- Struktur dari tabel `pesdikkeluar`
--

CREATE TABLE `pesdikkeluar` (
  `id` int(10) UNSIGNED NOT NULL,
  `pesdik_id` int(10) UNSIGNED NOT NULL,
  `keluar_karena` varchar(20) NOT NULL,
  `tanggal_keluar` date NOT NULL,
  `alasan_keluar` varchar(100) 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 `pesdikkeluar`
--

INSERT INTO `pesdikkeluar` (`id`, `pesdik_id`, `keluar_karena`, `tanggal_keluar`, `alasan_keluar`, `created_at`, `updated_at`) VALUES
(1, 3, 'Mutasi', '2026-04-08', 'pindah domisili', '2026-04-08 03:45:32', '2026-04-08 03:45:32'),
(2, 2, 'Dikeluarkan', '2026-04-22', 'terlalu banyak kasus', '2026-04-08 03:49:17', '2026-04-08 03:49:17'),
(3, 1, 'Putus Sekolah', '2026-04-30', 'tidak ada alasan yang jelas', '2026-04-08 03:50:11', '2026-04-08 03:50:11'),
(4, 4, 'Wafat', '2026-04-15', 'meninggal karena sakit', '2026-04-08 03:50:42', '2026-04-08 03:50:42'),
(5, 8, 'Lainnya', '2026-04-30', 'lulus sekoah', '2026-04-15 15:06:36', '2026-04-15 15:06:36');

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

--
-- Struktur dari tabel `rombel`
--

CREATE TABLE `rombel` (
  `id` int(10) UNSIGNED NOT NULL,
  `tapel_id` int(10) UNSIGNED NOT NULL,
  `guru_id` int(10) UNSIGNED NOT NULL,
  `kelas` int(11) NOT NULL,
  `nama_rombel` varchar(15) 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 `rombel`
--

INSERT INTO `rombel` (`id`, `tapel_id`, `guru_id`, `kelas`, `nama_rombel`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 7, 'VIIA', '2022-09-13 02:08:15', '2022-09-13 02:08:15'),
(2, 2, 1, 8, 'XI TKR 1', '2026-02-25 17:58:39', '2026-04-17 06:41:27'),
(3, 2, 1, 11, 'XI TKR 1', '2026-04-08 03:37:55', '2026-04-08 03:37:55'),
(4, 2, 1, 10, 'X TKR 1', '2026-04-08 03:44:26', '2026-04-08 03:44:26'),
(5, 2, 2, 12, 'XII TKR 3', '2026-04-15 14:58:18', '2026-04-15 14:58:18'),
(6, 2, 2, 12, 'XII TKR 4', '2026-04-17 06:34:13', '2026-04-17 06:34:13'),
(7, 3, 3, 11, 'XI TKR 1', '2026-04-17 07:02:50', '2026-04-17 07:02:50'),
(8, 4, 3, 11, 'XI TKR 1', '2026-04-17 07:06:24', '2026-04-17 07:06:24'),
(9, 5, 4, 9, 'XII TKR 1', '2026-04-17 07:11:26', '2026-04-17 07:12:07'),
(10, 6, 4, 12, 'XII TKR 1', '2026-04-17 07:15:55', '2026-04-17 07:15:55');

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

--
-- Struktur dari tabel `setor`
--

CREATE TABLE `setor` (
  `id` int(10) UNSIGNED NOT NULL,
  `pesdik_id` int(10) UNSIGNED NOT NULL,
  `users_id` int(10) UNSIGNED NOT NULL,
  `rombel_id` int(10) UNSIGNED NOT NULL,
  `tanggal` date NOT NULL,
  `jumlah` int(11) NOT NULL,
  `keterangan` varchar(50) 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 `setor`
--

INSERT INTO `setor` (`id`, `pesdik_id`, `users_id`, `rombel_id`, `tanggal`, `jumlah`, `keterangan`, `created_at`, `updated_at`) VALUES
(1, 2, 1, 2, '2026-03-02', 100, 'bayar spp', '2026-03-08 16:54:21', '2026-03-08 16:54:21'),
(2, 3, 1, 2, '2026-04-08', 50, 'SPP', '2026-04-08 03:05:00', '2026-04-08 03:05:00');

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

--
-- Struktur dari tabel `suratkeluar`
--

CREATE TABLE `suratkeluar` (
  `id` int(10) UNSIGNED NOT NULL,
  `klasifikasi_id` int(10) UNSIGNED NOT NULL,
  `users_id` int(10) UNSIGNED NOT NULL,
  `no_surat` varchar(30) NOT NULL,
  `tujuan_surat` varchar(50) NOT NULL,
  `isi` varchar(191) NOT NULL,
  `tgl_surat` date NOT NULL,
  `tgl_catat` date NOT NULL,
  `filekeluar` varchar(100) NOT NULL,
  `keterangan` varchar(191) 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 `suratkeluar`
--

INSERT INTO `suratkeluar` (`id`, `klasifikasi_id`, `users_id`, `no_surat`, `tujuan_surat`, `isi`, `tgl_surat`, `tgl_catat`, `filekeluar`, `keterangan`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '001/KS/2025', 'wali murid', 'edaran', '2026-04-14', '2026-04-15', 'S_keluar-Nota_Telkom_Lengkap.docx', 'wali murid', '2026-04-13 06:02:38', '2026-04-13 06:02:38');

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

--
-- Struktur dari tabel `suratmasuk`
--

CREATE TABLE `suratmasuk` (
  `id` int(10) UNSIGNED NOT NULL,
  `klasifikasi_id` int(10) UNSIGNED NOT NULL,
  `users_id` int(10) UNSIGNED NOT NULL,
  `no_surat` varchar(30) NOT NULL,
  `asal_surat` varchar(50) NOT NULL,
  `isi` text NOT NULL,
  `tgl_surat` date NOT NULL,
  `tgl_terima` date NOT NULL,
  `filemasuk` varchar(100) NOT NULL,
  `keterangan` text 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 `suratmasuk`
--

INSERT INTO `suratmasuk` (`id`, `klasifikasi_id`, `users_id`, `no_surat`, `asal_surat`, `isi`, `tgl_surat`, `tgl_terima`, `filemasuk`, `keterangan`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '001/KS/2022', 'SMK AL HUSNA', 'ALHUSNA', '2026-02-03', '2026-02-07', 'S_Masuk-LOGO SMK.jpg', 'OK SURAT SIAP DISPOSISI', '2022-06-07 15:36:28', '2026-02-25 17:53:39'),
(2, 1, 1, '001/KS/2024', 'ITM', 'Permohonan Penelitian', '2026-04-04', '2026-04-13', 'S_Masuk-WhatsApp Image 2026-04-13 at 12.24.00.jpeg', 'di terima Bapak naim Butuh Balasan Segera', '2026-04-13 05:24:16', '2026-04-13 05:24:16'),
(3, 1, 1, '001/KS/2028', 'SMK', 'surat resmi undangan', '2026-04-01', '2026-04-15', 'S_Masuk-surat.jpeg', 'di terima bapak krisna', '2026-04-15 11:22:53', '2026-04-15 11:22:53'),
(4, 1, 5, '421/005/SMK-AH/IV.2026', 'SD ISLAM MIFTAHUL HUDA', 'Permohonan', '2026-01-02', '0206-10-02', 'S_Masuk-Laporan UKK KHOIRUL MUTTAQIN 12345678[1] (1).docx', 'disposisi ke KS', '2026-04-17 06:11:20', '2026-04-17 06:11:20');

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

--
-- Struktur dari tabel `tagihan`
--

CREATE TABLE `tagihan` (
  `id` int(10) UNSIGNED NOT NULL,
  `rombel_id` int(10) UNSIGNED NOT NULL,
  `rincian` varchar(50) NOT NULL,
  `jenis_kelamin` varchar(9) NOT NULL,
  `nominal` int(11) NOT NULL,
  `batas_bayar` date 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 `tagihan`
--

INSERT INTO `tagihan` (`id`, `rombel_id`, `rincian`, `jenis_kelamin`, `nominal`, `batas_bayar`, `created_at`, `updated_at`) VALUES
(2, 1, 'UangPangkal', 'Semua', 100000, '2022-09-30', '2022-09-13 02:12:28', '2022-09-14 15:24:44'),
(6, 2, 'bayar spp', 'Semua', 50000, '2026-02-27', '2026-02-26 00:51:24', '2026-02-26 00:51:24'),
(8, 3, 'spp', 'Semua', 85000, '2026-04-30', '2026-04-13 06:19:32', '2026-04-13 06:19:32'),
(9, 3, 'pembayaran spp', 'Semua', 85000, '2026-04-29', '2026-04-15 11:47:41', '2026-04-15 11:47:41'),
(10, 3, 'pembayaran ukk', 'Semua', 100000, '2026-04-16', '2026-04-15 12:00:46', '2026-04-15 12:00:46'),
(11, 3, 'pembayaran PSAJ', 'Laki-Laki', 200000, '2026-04-30', '2026-04-15 12:08:07', '2026-04-15 12:08:07'),
(12, 3, 'pembayaran PTS Genap', 'Laki-Laki', 95000, '2026-04-30', '2026-04-15 12:15:15', '2026-04-15 12:15:15'),
(13, 3, 'pembayaran spp 2026', 'Laki-Laki', 85000, '2026-05-01', '2026-04-16 00:38:08', '2026-04-16 00:38:08'),
(14, 3, 'pembayaran spp bulan april', 'Semua', 85000, '2026-04-13', '2026-04-16 06:37:16', '2026-04-16 06:37:16'),
(15, 5, 'SPP', 'Semua', 85000, '2026-05-07', '2026-04-17 06:46:18', '2026-04-17 06:46:18'),
(16, 4, 'SPP', 'Semua', 85000, '2026-04-29', '2026-04-17 06:53:41', '2026-04-17 06:53:41'),
(17, 4, 'PTS', 'Semua', 75000, '2026-04-23', '2026-04-17 06:53:41', '2026-04-17 06:53:41'),
(18, 4, 'UAS', 'Semua', 75000, '2026-04-30', '2026-04-17 06:53:41', '2026-04-17 06:53:41'),
(19, 7, 'SPP', 'Laki-Laki', 85000, '2026-04-25', '2026-04-17 07:04:54', '2026-04-17 07:04:54'),
(20, 7, 'PTS', 'Laki-Laki', 75000, '2026-04-29', '2026-04-17 07:04:54', '2026-04-17 07:04:54'),
(21, 7, 'UAS', 'Laki-Laki', 75000, '2026-04-30', '2026-04-17 07:04:54', '2026-04-17 07:04:54'),
(22, 8, 'SPP', 'Semua', 85000, '2026-04-22', '2026-04-17 07:08:24', '2026-04-17 07:08:24'),
(23, 8, 'PTS', 'Semua', 75000, '2026-04-30', '2026-04-17 07:08:24', '2026-04-17 07:08:24'),
(24, 8, 'UAS', 'Semua', 75000, '2026-04-29', '2026-04-17 07:08:24', '2026-04-17 07:08:24'),
(25, 9, 'SPP BULAN APRIL', 'Semua', 85000, '2026-04-30', '2026-04-17 07:13:01', '2026-04-17 07:13:01'),
(26, 9, 'PKL', 'Semua', 300000, '2026-04-28', '2026-04-17 07:13:23', '2026-04-17 07:13:23'),
(27, 10, 'SPP BULAN APRIL', 'Semua', 85000, '2026-04-23', '2026-04-17 07:18:43', '2026-04-17 07:18:43'),
(28, 10, 'SPP BULAN MEI', 'Semua', 85000, '2026-04-28', '2026-04-17 07:18:43', '2026-04-17 07:18:43'),
(29, 10, 'SPP BULAN JUNI', 'Semua', 85000, '2026-04-29', '2026-04-17 07:18:43', '2026-04-17 07:18:43'),
(30, 10, 'uts', 'Semua', 90000, '2026-05-01', '2026-04-22 05:19:34', '2026-04-22 05:19:34');

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

--
-- Struktur dari tabel `tapel`
--

CREATE TABLE `tapel` (
  `id` int(10) UNSIGNED NOT NULL,
  `tahun` varchar(9) NOT NULL,
  `semester` varchar(15) 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 `tapel`
--

INSERT INTO `tapel` (`id`, `tahun`, `semester`, `created_at`, `updated_at`) VALUES
(1, '2027/2028', 'Semester Genap', '2022-06-07 16:23:57', '2026-04-17 06:40:01'),
(2, '2026/2027', 'Semester Genap', '2026-02-25 17:57:47', '2026-02-25 17:57:47'),
(3, '2027/2028', 'Semester Ganjil', '2026-04-17 06:55:48', '2026-04-17 06:55:48'),
(4, '2027/2028', 'Semester Genap', '2026-04-17 07:05:47', '2026-04-17 07:05:47'),
(5, '2028/2029', 'Semester Ganjil', '2026-04-17 07:08:51', '2026-04-17 07:08:51'),
(6, '2028/2029', 'Semester Genap', '2026-04-17 07:15:26', '2026-04-17 07:15:26');

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

--
-- Struktur dari tabel `tarik`
--

CREATE TABLE `tarik` (
  `id` int(10) UNSIGNED NOT NULL,
  `pesdik_id` int(10) UNSIGNED NOT NULL,
  `users_id` int(10) UNSIGNED NOT NULL,
  `rombel_id` int(10) UNSIGNED NOT NULL,
  `tanggal` date NOT NULL,
  `jumlah` int(11) NOT NULL,
  `keterangan` varchar(50) 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 `tarik`
--

INSERT INTO `tarik` (`id`, `pesdik_id`, `users_id`, `rombel_id`, `tanggal`, `jumlah`, `keterangan`, `created_at`, `updated_at`) VALUES
(1, 3, 1, 2, '2026-04-08', 50, '-', '2026-04-08 03:06:24', '2026-04-08 03:06:24');

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

--
-- Struktur dari tabel `tendik`
--

CREATE TABLE `tendik` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(30) NOT NULL,
  `jenis_kelamin` varchar(9) NOT NULL,
  `tempat_lahir` varchar(25) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `alamat` varchar(100) NOT NULL,
  `no_hp` varchar(13) NOT NULL,
  `email` varchar(35) NOT NULL,
  `tugas` varchar(35) 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 `tendik`
--

INSERT INTO `tendik` (`id`, `nama`, `jenis_kelamin`, `tempat_lahir`, `tanggal_lahir`, `alamat`, `no_hp`, `email`, `tugas`, `created_at`, `updated_at`) VALUES
(1, 'NAIM MUR ROHMAN', 'Laki-Laki', 'NGANJUK', '2002-07-18', 'cempoko , nganjuk', '083607833024', 'naim@gmail.com', 'Pengelola Administrasi Surat', '2026-04-15 13:40:26', '2026-04-15 13:40:46');

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

--
-- Struktur dari tabel `transaksipembayaran`
--

CREATE TABLE `transaksipembayaran` (
  `id` int(10) UNSIGNED NOT NULL,
  `tagihan_id` int(10) UNSIGNED NOT NULL,
  `users_id` int(10) UNSIGNED NOT NULL,
  `pesdik_id` int(10) UNSIGNED NOT NULL,
  `rombel_id` int(10) UNSIGNED NOT NULL,
  `jumlah_bayar` 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 `transaksipembayaran`
--

INSERT INTO `transaksipembayaran` (`id`, `tagihan_id`, `users_id`, `pesdik_id`, `rombel_id`, `jumlah_bayar`, `created_at`, `updated_at`) VALUES
(11, 2, 1, 2, 1, 100000, '2026-03-08 16:52:20', '2026-03-08 16:52:20'),
(12, 6, 1, 3, 2, 50000, '2026-04-08 02:33:17', '2026-04-08 02:33:17'),
(13, 6, 1, 3, 2, 50000, '2026-04-08 02:33:43', '2026-04-08 02:33:43'),
(14, 6, 1, 1, 2, 50000, '2026-04-08 02:50:52', '2026-04-08 02:50:52'),
(15, 8, 1, 5, 3, 85000, '2026-04-13 06:23:10', '2026-04-13 06:23:10'),
(16, 9, 1, 5, 3, 85000, '2026-04-15 11:56:41', '2026-04-15 11:56:41'),
(17, 10, 1, 5, 3, 100000, '2026-04-15 12:01:38', '2026-04-15 12:01:38'),
(18, 10, 1, 5, 3, 100000, '2026-04-15 12:07:06', '2026-04-15 12:07:06'),
(19, 11, 1, 5, 3, 200000, '2026-04-15 12:08:39', '2026-04-15 12:08:39'),
(20, 11, 1, 5, 3, 200000, '2026-04-15 12:14:06', '2026-04-15 12:14:06'),
(21, 12, 1, 5, 3, 95000, '2026-04-15 12:15:48', '2026-04-15 12:15:48'),
(22, 12, 1, 5, 3, 95000, '2026-04-15 12:45:27', '2026-04-15 12:45:27'),
(23, 12, 1, 5, 3, 95000, '2026-04-15 13:09:47', '2026-04-15 13:09:47'),
(24, 12, 1, 5, 3, 95000, '2026-04-15 13:15:17', '2026-04-15 13:15:17'),
(25, 12, 1, 5, 3, 95000, '2026-04-15 13:16:41', '2026-04-15 13:16:41'),
(26, 8, 6, 6, 3, 85000, '2026-04-16 00:39:11', '2026-04-16 00:39:11'),
(27, 9, 6, 6, 3, 85000, '2026-04-16 02:30:09', '2026-04-16 02:30:09'),
(28, 10, 1, 6, 3, 100000, '2026-04-16 06:26:03', '2026-04-16 06:26:03'),
(29, 14, 1, 6, 3, 85000, '2026-04-16 06:43:48', '2026-04-16 06:43:48'),
(30, 15, 1, 7, 5, 85000, '2026-04-17 06:47:57', '2026-04-17 06:47:57'),
(31, 16, 1, 10, 4, 85000, '2026-04-17 07:19:44', '2026-04-17 07:19:44'),
(32, 17, 1, 10, 4, 75000, '2026-04-17 07:27:03', '2026-04-17 07:27:03'),
(33, 18, 1, 10, 4, 75000, '2026-04-17 07:27:03', '2026-04-17 07:27:03'),
(34, 19, 1, 10, 7, 85000, '2026-04-17 07:27:03', '2026-04-17 07:27:03'),
(35, 20, 1, 10, 7, 75000, '2026-04-17 07:27:03', '2026-04-17 07:27:03'),
(36, 21, 1, 10, 7, 75000, '2026-04-17 07:27:03', '2026-04-17 07:27:03'),
(37, 22, 1, 10, 8, 85000, '2026-04-17 07:27:03', '2026-04-17 07:27:03'),
(38, 23, 1, 10, 8, 75000, '2026-04-17 07:27:03', '2026-04-17 07:27:03'),
(39, 24, 1, 10, 8, 75000, '2026-04-17 07:27:03', '2026-04-17 07:27:03'),
(40, 25, 1, 10, 9, 85000, '2026-04-17 07:27:03', '2026-04-17 07:27:03'),
(41, 26, 1, 10, 9, 300000, '2026-04-17 07:27:03', '2026-04-17 07:27:03'),
(42, 27, 1, 10, 10, 85000, '2026-04-17 07:27:03', '2026-04-17 07:27:03'),
(43, 28, 1, 10, 10, 85000, '2026-04-17 07:27:03', '2026-04-17 07:27:03'),
(44, 29, 1, 10, 10, 85000, '2026-04-17 07:27:03', '2026-04-17 07:27:03'),
(45, 11, 1, 6, 3, 200000, '2026-04-18 04:43:41', '2026-04-18 04:43:41'),
(46, 13, 1, 6, 3, 85000, '2026-04-22 05:20:06', '2026-04-22 05:20:06');

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `anggotarombel`
--
ALTER TABLE `anggotarombel`
  ADD PRIMARY KEY (`id`),
  ADD KEY `anggotarombel_pesdik_id_foreign` (`pesdik_id`),
  ADD KEY `anggotarombel_rombel_id_foreign` (`rombel_id`);

--
-- Indeks untuk tabel `disposisis`
--
ALTER TABLE `disposisis`
  ADD PRIMARY KEY (`id`),
  ADD KEY `disposisis_users_id_foreign` (`users_id`),
  ADD KEY `disposisis_suratmasuk_id_foreign` (`suratmasuk_id`);

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

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

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

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

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

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

--
-- Indeks untuk tabel `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_auth_codes_user_id_index` (`user_id`);

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

--
-- Indeks untuk tabel `pemasukan`
--
ALTER TABLE `pemasukan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pemasukan_kategori_id_foreign` (`kategori_id`);

--
-- Indeks untuk tabel `pengeluaran`
--
ALTER TABLE `pengeluaran`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pengeluaran_kategori_id_foreign` (`kategori_id`);

--
-- Indeks untuk tabel `pengumuman`
--
ALTER TABLE `pengumuman`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pengumuman_users_id_foreign` (`users_id`);

--
-- Indeks untuk tabel `pesdik`
--
ALTER TABLE `pesdik`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pesdik_rombel_id_foreign` (`rombel_id`);

--
-- Indeks untuk tabel `pesdikalumni`
--
ALTER TABLE `pesdikalumni`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pesdikalumni_pesdik_id_foreign` (`pesdik_id`);

--
-- Indeks untuk tabel `pesdikkeluar`
--
ALTER TABLE `pesdikkeluar`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pesdikkeluar_pesdik_id_foreign` (`pesdik_id`);

--
-- Indeks untuk tabel `rombel`
--
ALTER TABLE `rombel`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rombel_tapel_id_foreign` (`tapel_id`),
  ADD KEY `rombel_guru_id_foreign` (`guru_id`);

--
-- Indeks untuk tabel `setor`
--
ALTER TABLE `setor`
  ADD PRIMARY KEY (`id`),
  ADD KEY `setor_users_id_foreign` (`users_id`),
  ADD KEY `setor_pesdik_id_foreign` (`pesdik_id`),
  ADD KEY `setor_rombel_id_foreign` (`rombel_id`);

--
-- Indeks untuk tabel `suratkeluar`
--
ALTER TABLE `suratkeluar`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `suratkeluar_no_surat_unique` (`no_surat`),
  ADD KEY `suratkeluar_users_id_foreign` (`users_id`),
  ADD KEY `suratkeluar_klasifikasi_id_foreign` (`klasifikasi_id`);

--
-- Indeks untuk tabel `suratmasuk`
--
ALTER TABLE `suratmasuk`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `suratmasuk_no_surat_unique` (`no_surat`),
  ADD KEY `suratmasuk_users_id_foreign` (`users_id`),
  ADD KEY `suratmasuk_klasifikasi_id_foreign` (`klasifikasi_id`);

--
-- Indeks untuk tabel `tagihan`
--
ALTER TABLE `tagihan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tagihan_rombel_id_foreign` (`rombel_id`);

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

--
-- Indeks untuk tabel `tarik`
--
ALTER TABLE `tarik`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tarik_users_id_foreign` (`users_id`),
  ADD KEY `tarik_pesdik_id_foreign` (`pesdik_id`),
  ADD KEY `tarik_rombel_id_foreign` (`rombel_id`);

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

--
-- Indeks untuk tabel `transaksipembayaran`
--
ALTER TABLE `transaksipembayaran`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transaksipembayaran_tagihan_id_foreign` (`tagihan_id`),
  ADD KEY `transaksipembayaran_users_id_foreign` (`users_id`),
  ADD KEY `transaksipembayaran_pesdik_id_foreign` (`pesdik_id`),
  ADD KEY `transaksipembayaran_rombel_id_foreign` (`rombel_id`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Ketidakleluasaan untuk tabel `anggotarombel`
--
ALTER TABLE `anggotarombel`
  ADD CONSTRAINT `anggotarombel_pesdik_id_foreign` FOREIGN KEY (`pesdik_id`) REFERENCES `pesdik` (`id`),
  ADD CONSTRAINT `anggotarombel_rombel_id_foreign` FOREIGN KEY (`rombel_id`) REFERENCES `rombel` (`id`);

--
-- Ketidakleluasaan untuk tabel `disposisis`
--
ALTER TABLE `disposisis`
  ADD CONSTRAINT `disposisis_suratmasuk_id_foreign` FOREIGN KEY (`suratmasuk_id`) REFERENCES `suratmasuk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `disposisis_users_id_foreign` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Ketidakleluasaan untuk tabel `pemasukan`
--
ALTER TABLE `pemasukan`
  ADD CONSTRAINT `pemasukan_kategori_id_foreign` FOREIGN KEY (`kategori_id`) REFERENCES `kategori` (`id`);

--
-- Ketidakleluasaan untuk tabel `pengeluaran`
--
ALTER TABLE `pengeluaran`
  ADD CONSTRAINT `pengeluaran_kategori_id_foreign` FOREIGN KEY (`kategori_id`) REFERENCES `kategori` (`id`);

--
-- Ketidakleluasaan untuk tabel `pengumuman`
--
ALTER TABLE `pengumuman`
  ADD CONSTRAINT `pengumuman_users_id_foreign` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Ketidakleluasaan untuk tabel `pesdik`
--
ALTER TABLE `pesdik`
  ADD CONSTRAINT `pesdik_rombel_id_foreign` FOREIGN KEY (`rombel_id`) REFERENCES `rombel` (`id`);

--
-- Ketidakleluasaan untuk tabel `pesdikalumni`
--
ALTER TABLE `pesdikalumni`
  ADD CONSTRAINT `pesdikalumni_pesdik_id_foreign` FOREIGN KEY (`pesdik_id`) REFERENCES `pesdik` (`id`);

--
-- Ketidakleluasaan untuk tabel `pesdikkeluar`
--
ALTER TABLE `pesdikkeluar`
  ADD CONSTRAINT `pesdikkeluar_pesdik_id_foreign` FOREIGN KEY (`pesdik_id`) REFERENCES `pesdik` (`id`);

--
-- Ketidakleluasaan untuk tabel `rombel`
--
ALTER TABLE `rombel`
  ADD CONSTRAINT `rombel_guru_id_foreign` FOREIGN KEY (`guru_id`) REFERENCES `guru` (`id`),
  ADD CONSTRAINT `rombel_tapel_id_foreign` FOREIGN KEY (`tapel_id`) REFERENCES `tapel` (`id`);

--
-- Ketidakleluasaan untuk tabel `setor`
--
ALTER TABLE `setor`
  ADD CONSTRAINT `setor_pesdik_id_foreign` FOREIGN KEY (`pesdik_id`) REFERENCES `pesdik` (`id`),
  ADD CONSTRAINT `setor_rombel_id_foreign` FOREIGN KEY (`rombel_id`) REFERENCES `rombel` (`id`),
  ADD CONSTRAINT `setor_users_id_foreign` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Ketidakleluasaan untuk tabel `suratkeluar`
--
ALTER TABLE `suratkeluar`
  ADD CONSTRAINT `suratkeluar_klasifikasi_id_foreign` FOREIGN KEY (`klasifikasi_id`) REFERENCES `klasifikasi` (`id`),
  ADD CONSTRAINT `suratkeluar_users_id_foreign` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Ketidakleluasaan untuk tabel `suratmasuk`
--
ALTER TABLE `suratmasuk`
  ADD CONSTRAINT `suratmasuk_klasifikasi_id_foreign` FOREIGN KEY (`klasifikasi_id`) REFERENCES `klasifikasi` (`id`),
  ADD CONSTRAINT `suratmasuk_users_id_foreign` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Ketidakleluasaan untuk tabel `tagihan`
--
ALTER TABLE `tagihan`
  ADD CONSTRAINT `tagihan_rombel_id_foreign` FOREIGN KEY (`rombel_id`) REFERENCES `rombel` (`id`);

--
-- Ketidakleluasaan untuk tabel `tarik`
--
ALTER TABLE `tarik`
  ADD CONSTRAINT `tarik_pesdik_id_foreign` FOREIGN KEY (`pesdik_id`) REFERENCES `pesdik` (`id`),
  ADD CONSTRAINT `tarik_rombel_id_foreign` FOREIGN KEY (`rombel_id`) REFERENCES `rombel` (`id`),
  ADD CONSTRAINT `tarik_users_id_foreign` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Ketidakleluasaan untuk tabel `transaksipembayaran`
--
ALTER TABLE `transaksipembayaran`
  ADD CONSTRAINT `transaksipembayaran_pesdik_id_foreign` FOREIGN KEY (`pesdik_id`) REFERENCES `pesdik` (`id`),
  ADD CONSTRAINT `transaksipembayaran_rombel_id_foreign` FOREIGN KEY (`rombel_id`) REFERENCES `rombel` (`id`),
  ADD CONSTRAINT `transaksipembayaran_tagihan_id_foreign` FOREIGN KEY (`tagihan_id`) REFERENCES `tagihan` (`id`),
  ADD CONSTRAINT `transaksipembayaran_users_id_foreign` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);
COMMIT;

