-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Waktu pembuatan: 07 Bulan Mei 2026 pada 13.25 -- Versi server: 10.4.32-MariaDB -- Versi PHP: 8.1.25 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: `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_access_tokens` -- CREATE TABLE `oauth_access_tokens` ( `id` varchar(100) NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `client_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) DEFAULT NULL, `scopes` text DEFAULT NULL, `revoked` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `expires_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- 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_clients` -- CREATE TABLE `oauth_clients` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `name` varchar(191) NOT NULL, `secret` varchar(100) DEFAULT NULL, `provider` varchar(191) DEFAULT NULL, `redirect` text NOT NULL, `personal_access_client` tinyint(1) NOT NULL, `password_client` tinyint(1) NOT NULL, `revoked` tinyint(1) 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 `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 `oauth_refresh_tokens` -- CREATE TABLE `oauth_refresh_tokens` ( `id` varchar(100) NOT NULL, `access_token_id` varchar(100) NOT NULL, `revoked` tinyint(1) NOT NULL, `expires_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(191) NOT NULL, `token` varchar(191) NOT NULL, `created_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', '

Pastikan administrator sudah melakukan setting data master pada menu KELOLA DATA, mulai dari data Sekolah, GTK, Tahun Pelajaran, Rombongan Belajar dan Peserta Didik.

', 1, '2026-02-26 00:39:31', '2026-02-26 00:39:31'), (3, 'masuk sekolah', '

masuk sekolah mulai tanggal 30 maret 2026

', 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'); -- -------------------------------------------------------- -- -- Struktur dari tabel `users` -- CREATE TABLE `users` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(30) NOT NULL, `email` varchar(191) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(191) NOT NULL, `role` varchar(35) NOT NULL, `remember_token` varchar(100) 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`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Zainul Wafa', 'zainulwafa1983@gmail.com', NULL, '$2y$10$YK/QcQQWibMDvbJY.BnCgu0pUBNGHX6tD60P/4u7BaLlQrYWyMUjS', 'admin', NULL, '2022-06-07 15:29:24', '2026-02-26 00:46:16'), (2, 'Panjul A.B', '1111111111@siswa.com', NULL, '$2y$10$dCevVPMGThRftvVt6fTIGuowwrH640jQG9moXZ5JpVD5ybjLhZrGW', 'Siswa', NULL, '2022-09-13 02:10:22', '2023-02-03 11:54:59'), (3, 'Paijo', '2222222222@siswa.com', NULL, '$2y$10$T2aBNs5DGAoHG4Z.6wli9Oh64Joo6PnfhBw8LcEfsxNdjNQom87Wa', 'Siswa', NULL, '2022-09-14 14:42:02', '2026-03-08 17:01:33'), (4, 'udik kuswanto', '1212133333@siswa.com', NULL, '$2y$10$tJAzO93XvCN3q37qZ5el/.gMvRZUDkzNiQT.kFx8rbfhR1l5N5ulq', 'Siswa', NULL, '2023-02-03 11:50:53', '2023-02-03 11:50:53'), (5, 'Surat', 'Suratwafa@gmail.com', NULL, '$2y$10$EDyKftyyy2.HfnP7Q4auYubp0z3Jtb7.6WbVlKmbS/TIzIdPD2f62', 'PetugasAdministrasiSurat', NULL, '2023-02-03 12:01:50', '2026-02-25 17:44:53'), (6, 'Keuangan', 'zainul123@gmail.com', NULL, '$2y$10$ku6x9ukOAr1Ug1Z9n6hLMuwA3oLzKqBoCJGK/JlMSrxHo9ogoomhq', 'PetugasAdministrasiKeuangan', NULL, '2023-02-03 12:03:34', '2026-02-25 17:43:40'), (7, 'Rama Briliant', '2020112234@siswa.com', NULL, '$2y$10$gG2qaLgf6TcC8.Q8H7qawOA/1Egb2S0A6ER7TpZ6xemeTtfQdNnsm', 'Siswa', NULL, '2026-04-08 03:41:55', '2026-04-08 03:47:34'), (8, 'NAIM MUR ROHMAN', 'naim@gmail.com', NULL, '$2y$10$inNQUdqE3j4n0n80ho8bZOJKc4eKGKWuCGpHwEtJ1EsGhKZlI67XS', 'PetugasAdministrasiSurat', NULL, '2026-04-15 13:40:26', '2026-04-15 13:40:26'), (9, 'arya ramadani', '2020112235@siswa.com', NULL, '$2y$10$kTbJRb/AvNuDdrDcgJhqDO2Wk2NAwHnuiBIqgXuodPhO6O/fXPU/W', 'Siswa', NULL, '2026-04-15 14:13:32', '2026-04-16 06:42:06'), (10, 'dono setiawan', '2020112239@siswa.com', NULL, '$2y$10$w1eiVmRp7dQxXhq9F6OA9.FwjAHxJJ57KDTUlT6jkNGaNOrHU48Xq', 'Siswa', NULL, '2026-04-15 14:59:35', '2026-04-15 14:59:35'), (11, 'andre bagus', '2020112230@siswa.com', NULL, '$2y$10$UUoAV6oDMbJWwkPU5OVajOymmlW/IhN1zqJGphc7QtR/s4jKE0fRu', 'Siswa', NULL, '2026-04-15 15:05:34', '2026-04-15 15:05:34'), (12, 'gio ramdani', '2020112245@siswa.com', NULL, '$2y$10$s4fYf.Vk3.bNd6SZhFNs3.kcrXiQjAMO4Yw1ctxeXKxE1mutUbff6', 'Siswa', NULL, '2026-04-15 15:22:50', '2026-04-15 15:22:50'), (13, 'DODIK', '2567889754@siswa.com', NULL, '$2y$10$dJ6R1YaYGMbsL5o4m3ULB.ivYuQ4dySf8MJgGgOsBul.MO8uKDDFK', 'Siswa', NULL, '2026-04-17 06:51:39', '2026-04-18 01:58:04'); -- -- 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_access_tokens` -- ALTER TABLE `oauth_access_tokens` ADD PRIMARY KEY (`id`), ADD KEY `oauth_access_tokens_user_id_index` (`user_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_clients` -- ALTER TABLE `oauth_clients` ADD PRIMARY KEY (`id`), ADD KEY `oauth_clients_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 `oauth_refresh_tokens` -- ALTER TABLE `oauth_refresh_tokens` ADD PRIMARY KEY (`id`), ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`); -- -- Indeks untuk tabel `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- 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`); -- -- 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 `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_clients` -- ALTER TABLE `oauth_clients` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- 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; -- -- AUTO_INCREMENT untuk tabel `users` -- ALTER TABLE `users` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- 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; /*!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 */;