-- phpMyAdmin SQL Dump -- version 5.2.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jul 25, 2026 at 08:21 AM -- Server version: 8.0.30 -- PHP Version: 8.3.32 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: `presguru` -- -- -------------------------------------------------------- -- -- Table structure for table `absensis` -- CREATE TABLE `absensis` ( `id` bigint UNSIGNED NOT NULL, `guru_id` bigint UNSIGNED NOT NULL, `jadwal_id` bigint UNSIGNED DEFAULT NULL, `tanggal` date NOT NULL, `jam_absen` time DEFAULT NULL, `status` enum('Hadir','Izin','Sakit','Alpha') COLLATE utf8mb4_unicode_ci NOT NULL, `jam_kerja` int 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 for table `absensis` -- INSERT INTO `absensis` (`id`, `guru_id`, `jadwal_id`, `tanggal`, `jam_absen`, `status`, `jam_kerja`, `created_at`, `updated_at`) VALUES (4, 1, NULL, '2026-06-14', NULL, 'Hadir', 6, '2026-06-14 05:09:15', '2026-06-14 05:09:15'), (5, 1, NULL, '2026-06-15', NULL, 'Hadir', 2, '2026-06-14 21:32:34', '2026-06-14 21:32:34'), (6, 1, NULL, '2026-06-16', NULL, 'Izin', 0, '2026-06-14 22:12:05', '2026-06-14 22:12:05'), (7, 3, NULL, '2026-06-15', NULL, 'Izin', 0, '2026-06-14 22:19:25', '2026-06-14 22:19:25'), (8, 2, NULL, '2026-06-15', NULL, 'Sakit', 0, '2026-06-14 22:23:26', '2026-06-14 22:23:26'), (9, 1, NULL, '2026-06-19', NULL, 'Hadir', 1, '2026-06-18 20:48:45', '2026-06-18 20:48:45'), (16, 4, NULL, '2026-07-15', NULL, 'Sakit', 0, '2026-07-16 05:46:56', '2026-07-16 05:46:56'); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint UNSIGNED NOT NULL, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `gurus` -- CREATE TABLE `gurus` ( `id` bigint UNSIGNED NOT NULL, `user_id` bigint UNSIGNED DEFAULT NULL, `nip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `jk` enum('L','P') COLLATE utf8mb4_unicode_ci NOT NULL, `alamat` text COLLATE utf8mb4_unicode_ci, `telepon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tanggal_masuk` date NOT NULL, `status` enum('Tetap','Honorer') COLLATE utf8mb4_unicode_ci NOT NULL, `tarif_per_jam` decimal(12,2) NOT NULL, `pengalaman_tahun` int NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `gurus` -- INSERT INTO `gurus` (`id`, `user_id`, `nip`, `nama`, `jk`, `alamat`, `telepon`, `tanggal_masuk`, `status`, `tarif_per_jam`, `pengalaman_tahun`, `created_at`, `updated_at`, `email`) VALUES (2, 5, '12222', 'andre ramdhan', 'L', NULL, NULL, '2026-06-01', 'Tetap', 10500.00, 0, '2026-06-13 09:08:26', '2026-07-13 03:45:50', 'andre@smkstarpansatu.sch.id'); -- -------------------------------------------------------- -- -- Table structure for table `izins` -- CREATE TABLE `izins` ( `id` bigint UNSIGNED NOT NULL, `guru_id` bigint UNSIGNED NOT NULL, `jenis` enum('Izin','Sakit') COLLATE utf8mb4_unicode_ci NOT NULL, `tanggal` date NOT NULL, `alasan` text COLLATE utf8mb4_unicode_ci 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 for table `izins` -- INSERT INTO `izins` (`id`, `guru_id`, `jenis`, `tanggal`, `alasan`, `created_at`, `updated_at`) VALUES (4, 3, 'Izin', '2026-06-15', 'jalan', '2026-06-14 22:19:25', '2026-06-14 22:19:25'), (5, 2, 'Izin', '2026-06-15', 'sakit perut', '2026-06-14 22:23:26', '2026-06-14 22:23:26'), (6, 4, 'Izin', '2026-07-15', 'sedang sakit', '2026-07-16 05:46:56', '2026-07-16 05:46:56'); -- -------------------------------------------------------- -- -- Table structure for table `jadwals` -- CREATE TABLE `jadwals` ( `id` bigint UNSIGNED NOT NULL, `guru_id` bigint UNSIGNED NOT NULL, `hari` enum('Senin','Selasa','Rabu','Kamis','Jumat','Sabtu') COLLATE utf8mb4_unicode_ci NOT NULL, `jam_mulai` time NOT NULL, `jam_selesai` time NOT NULL, `jam_mengajar` int NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `kelas_id` bigint UNSIGNED DEFAULT NULL, `mata_pelajaran_id` bigint UNSIGNED DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `jadwals` -- INSERT INTO `jadwals` (`id`, `guru_id`, `hari`, `jam_mulai`, `jam_selesai`, `jam_mengajar`, `created_at`, `updated_at`, `kelas_id`, `mata_pelajaran_id`) VALUES (18, 2, 'Kamis', '07:00:00', '09:00:00', 2, '2026-07-16 07:18:27', '2026-07-16 07:18:27', 7, 7), (19, 2, 'Senin', '10:00:00', '14:00:00', 4, '2026-07-16 07:18:45', '2026-07-16 07:18:45', 7, 6); -- -------------------------------------------------------- -- -- Table structure for table `kelas` -- CREATE TABLE `kelas` ( `id` bigint UNSIGNED NOT NULL, `kode_kelas` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `nama_kelas` varchar(255) COLLATE utf8mb4_unicode_ci 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 for table `kelas` -- INSERT INTO `kelas` (`id`, `kode_kelas`, `nama_kelas`, `created_at`, `updated_at`) VALUES (7, 'X-RPL-1', 'X Rekayasa Perangkat Lunak 1', '2026-07-16 05:19:48', '2026-07-16 05:19:48'), (8, 'XI-RPL-2', 'XI Rekayasa Perangkat Lunak 2', '2026-07-16 05:39:48', '2026-07-16 05:39:48'); -- -------------------------------------------------------- -- -- Table structure for table `mata_pelajarans` -- CREATE TABLE `mata_pelajarans` ( `id` bigint UNSIGNED NOT NULL, `kode_mapel` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `nama_mapel` varchar(255) COLLATE utf8mb4_unicode_ci 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 for table `mata_pelajarans` -- INSERT INTO `mata_pelajarans` (`id`, `kode_mapel`, `nama_mapel`, `created_at`, `updated_at`) VALUES (6, 'MTK', 'Matematika', '2026-07-16 05:40:02', '2026-07-16 05:40:02'), (7, 'BINDO', 'Bahasa Indonesia', '2026-07-16 05:40:14', '2026-07-16 05:40:14'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_reset_tokens_table', 1), (3, '2019_08_19_000000_create_failed_jobs_table', 1), (4, '2019_12_14_000001_create_personal_access_tokens_table', 1), (5, '2026_06_13_142833_add_role_to_users_table', 2), (6, '2026_06_13_143003_create_gurus_table', 3), (7, '2026_06_13_143009_create_staff_table', 3), (8, '2026_06_13_143016_create_absensis_table', 3), (9, '2026_06_13_143021_create_penggajians_table', 3), (10, '2026_06_13_143026_create_tunjangans_table', 3), (11, '2026_06_13_143031_create_potongans_table', 3), (12, '2026_06_13_154240_add_user_id_to_gurus_table', 4), (13, '2026_06_13_160114_add_email_to_gurus_table', 5), (14, '2026_06_14_020642_add_jam_kerja_to_absensis', 6), (15, '2026_06_14_023449_create_izins_table', 7), (16, '2026_06_14_121107_create_jadwals_table', 8), (17, '2026_06_14_123527_create_kelas_table', 9), (18, '2026_06_14_123724_create_mata_pelajarans_table', 9), (19, '2026_06_14_123950_alter_jadwals_table', 10), (20, '2026_06_14_172726_add_guru_id_to_staff', 11), (21, '2026_06_14_173305_add_gaji_staff_to_penggajians', 12), (22, '2026_06_15_050606_add_jenis_to_izins_table', 13), (23, '2026_06_26_144657_add_jadwal_to_absensis_table', 14), (24, '2026_07_13_063810_add_staff_id_to_penggajians_table', 15); -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `penggajians` -- CREATE TABLE `penggajians` ( `id` bigint UNSIGNED NOT NULL, `guru_id` bigint UNSIGNED DEFAULT NULL, `staff_id` bigint UNSIGNED DEFAULT NULL, `periode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `total_jam` int NOT NULL, `tarif` decimal(12,2) NOT NULL, `tunjangan` decimal(12,2) NOT NULL DEFAULT '0.00', `potongan` decimal(12,2) NOT NULL DEFAULT '0.00', `gaji_bersih` decimal(12,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `gaji_staff` decimal(12,2) NOT NULL DEFAULT '0.00' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `penggajians` -- INSERT INTO `penggajians` (`id`, `guru_id`, `staff_id`, `periode`, `total_jam`, `tarif`, `tunjangan`, `potongan`, `gaji_bersih`, `created_at`, `updated_at`, `gaji_staff`) VALUES (21, 2, NULL, '2026-07', 24, 10500.00, 63000.00, 0.00, 1065000.00, '2026-07-13 00:37:01', '2026-07-16 07:18:52', 750000.00); -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `potongans` -- CREATE TABLE `potongans` ( `id` bigint UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `staff` -- CREATE TABLE `staff` ( `id` bigint UNSIGNED NOT NULL, `guru_id` bigint UNSIGNED DEFAULT NULL, `nip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `jabatan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `gaji_pokok` decimal(12,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `staff` -- INSERT INTO `staff` (`id`, `guru_id`, `nip`, `nama`, `jabatan`, `gaji_pokok`, `created_at`, `updated_at`) VALUES (8, 2, '12345', 'andre ramadhan', 'Bendahara', 750000.00, '2026-07-16 07:17:53', '2026-07-16 07:17:53'); -- -------------------------------------------------------- -- -- Table structure for table `tunjangans` -- CREATE TABLE `tunjangans` ( `id` bigint UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'guru' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `role`) VALUES (1, 'Administrator', 'admin@sekolah.com', NULL, '$2y$12$Y.BWHQ.nzeR50TH3rbemXOaCR8eSFe5TuSwr4/xx0QR8YI7odll/m', NULL, '2026-06-13 15:24:22', '2026-06-13 08:40:42', 'admin'), (5, 'andre ramdhan', 'andre@smkstarpansatu.sch.id', NULL, '$2y$12$a5oQ13ANX/ZNd0UlYit1/OaRDvVZnfhuCqkMvD5G5PpOVHnLlDWL2', NULL, '2026-06-13 09:08:26', '2026-07-13 01:24:08', 'guru'); -- -- Indexes for dumped tables -- -- -- Indexes for table `absensis` -- ALTER TABLE `absensis` ADD PRIMARY KEY (`id`), ADD KEY `absensis_jadwal_id_foreign` (`jadwal_id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `gurus` -- ALTER TABLE `gurus` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `gurus_nip_unique` (`nip`), ADD UNIQUE KEY `gurus_email_unique` (`email`); -- -- Indexes for table `izins` -- ALTER TABLE `izins` ADD PRIMARY KEY (`id`); -- -- Indexes for table `jadwals` -- ALTER TABLE `jadwals` ADD PRIMARY KEY (`id`), ADD KEY `fk_jadwal_guru` (`guru_id`), ADD KEY `fk_jadwal_kelas` (`kelas_id`), ADD KEY `fk_jadwal_mapel` (`mata_pelajaran_id`); -- -- Indexes for table `kelas` -- ALTER TABLE `kelas` ADD PRIMARY KEY (`id`); -- -- Indexes for table `mata_pelajarans` -- ALTER TABLE `mata_pelajarans` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `penggajians` -- ALTER TABLE `penggajians` ADD PRIMARY KEY (`id`), ADD KEY `penggajians_staff_id_foreign` (`staff_id`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `potongans` -- ALTER TABLE `potongans` ADD PRIMARY KEY (`id`); -- -- Indexes for table `staff` -- ALTER TABLE `staff` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tunjangans` -- ALTER TABLE `tunjangans` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `absensis` -- ALTER TABLE `absensis` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `gurus` -- ALTER TABLE `gurus` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `izins` -- ALTER TABLE `izins` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `jadwals` -- ALTER TABLE `jadwals` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `kelas` -- ALTER TABLE `kelas` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `mata_pelajarans` -- ALTER TABLE `mata_pelajarans` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25; -- -- AUTO_INCREMENT for table `penggajians` -- ALTER TABLE `penggajians` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `potongans` -- ALTER TABLE `potongans` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `staff` -- ALTER TABLE `staff` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `tunjangans` -- ALTER TABLE `tunjangans` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- Constraints for dumped tables -- -- -- Constraints for table `absensis` -- ALTER TABLE `absensis` ADD CONSTRAINT `absensis_jadwal_id_foreign` FOREIGN KEY (`jadwal_id`) REFERENCES `jadwals` (`id`) ON DELETE CASCADE; -- -- Constraints for table `jadwals` -- ALTER TABLE `jadwals` ADD CONSTRAINT `fk_jadwal_guru` FOREIGN KEY (`guru_id`) REFERENCES `gurus` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk_jadwal_kelas` FOREIGN KEY (`kelas_id`) REFERENCES `kelas` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk_jadwal_mapel` FOREIGN KEY (`mata_pelajaran_id`) REFERENCES `mata_pelajarans` (`id`) ON DELETE CASCADE; -- -- Constraints for table `penggajians` -- ALTER TABLE `penggajians` ADD CONSTRAINT `penggajians_staff_id_foreign` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE SET NULL; 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 */;