-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Feb 19, 2026 at 02:48 AM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 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: `laravel_magang` -- -- -------------------------------------------------------- -- -- Table structure for table `bimbingan` -- CREATE TABLE `bimbingan` ( `id` bigint(20) UNSIGNED NOT NULL, `mahasiswa_id` bigint(20) UNSIGNED NOT NULL, `dosen_id` bigint(20) UNSIGNED NOT NULL, `tanggal_bimbingan` date NOT NULL, `catatan` text DEFAULT NULL, `status` enum('pending','disetujui','ditolak') NOT NULL DEFAULT 'pending', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `bimbingan` -- INSERT INTO `bimbingan` (`id`, `mahasiswa_id`, `dosen_id`, `tanggal_bimbingan`, `catatan`, `status`, `created_at`, `updated_at`) VALUES (1, 3, 1, '2026-02-19', 'Waalaikumsalam, oke baik', 'disetujui', '2026-02-18 22:48:03', '2026-02-18 22:50:48'), (2, 3, 1, '2026-02-20', 'Good Man', 'disetujui', '2026-02-18 22:54:29', '2026-02-18 22:55:39'), (3, 3, 1, '2026-02-21', 'Mantap, mau caleg kamu?', 'disetujui', '2026-02-18 22:54:49', '2026-02-18 22:55:49'), (4, 3, 1, '2026-02-23', 'Oke good boy', 'disetujui', '2026-02-18 22:55:05', '2026-02-18 22:55:33'); -- -------------------------------------------------------- -- -- Table structure for table `cache` -- CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `dosen` -- CREATE TABLE `dosen` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `nama` varchar(255) NOT NULL, `nip` varchar(255) NOT NULL, `program_studi` varchar(255) 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 `dosen` -- INSERT INTO `dosen` (`id`, `user_id`, `nama`, `nip`, `program_studi`, `created_at`, `updated_at`) VALUES (1, 5, 'Budi', '1313', 'Teknik Informatika', '2026-02-18 22:09:25', '2026-02-18 22:09:25'); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `format_laporan` -- CREATE TABLE `format_laporan` ( `id` bigint(20) UNSIGNED NOT NULL, `nama` varchar(255) NOT NULL, `file` varchar(255) 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 `format_laporan` -- INSERT INTO `format_laporan` (`id`, `nama`, `file`, `created_at`, `updated_at`) VALUES (3, 'Format Laporan Magang 2026', 'format-laporan/DnYDYXP1eAG62PqeNQBf1lyObn7Vs1aGqgemItal.docx', '2026-02-18 22:44:43', '2026-02-18 22:44:43'); -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) UNSIGNED NOT NULL, `reserved_at` int(10) UNSIGNED DEFAULT NULL, `available_at` int(10) UNSIGNED NOT NULL, `created_at` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `job_batches` -- CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `laporan_pkl` -- CREATE TABLE `laporan_pkl` ( `id` bigint(20) UNSIGNED NOT NULL, `mahasiswa_id` bigint(20) UNSIGNED NOT NULL, `perusahaan_id` bigint(20) UNSIGNED DEFAULT NULL, `file` varchar(255) NOT NULL, `status` enum('pending','diterima','ditolak') NOT NULL DEFAULT 'pending', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `laporan_pkl` -- INSERT INTO `laporan_pkl` (`id`, `mahasiswa_id`, `perusahaan_id`, `file`, `status`, `created_at`, `updated_at`) VALUES (1, 3, 1, 'laporan_pkl/MvZhpzpd0dVHIbQFt9SALeCQGNb24PKAYDe9Ji45.pdf', 'diterima', '2026-02-18 22:18:47', '2026-02-18 22:24:38'); -- -------------------------------------------------------- -- -- Table structure for table `mahasiswa` -- CREATE TABLE `mahasiswa` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `nama` varchar(255) NOT NULL, `nim` varchar(255) NOT NULL, `program_studi` varchar(255) NOT NULL, `kelas` varchar(255) NOT NULL, `semester` varchar(255) 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 `mahasiswa` -- INSERT INTO `mahasiswa` (`id`, `user_id`, `nama`, `nim`, `program_studi`, `kelas`, `semester`, `created_at`, `updated_at`) VALUES (1, 2, 'Nama Mahasiswa 1', '2215323031', 'Manajemen Informatika', '5A - MI', '5', '2026-02-18 04:03:43', '2026-02-18 04:03:43'), (2, 3, 'Nama Mahasiswa 2', '2215323032', 'Teknologi Rekayasa Perangkat Lunak', '7A - TRPL', '7', '2026-02-18 04:03:43', '2026-02-18 04:03:43'), (3, 4, 'Kisrun', '1212', 'Teknik Informatika', '3B - TI', '3', '2026-02-18 04:03:43', '2026-02-18 04:03:43'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '0001_01_01_000000_create_users_table', 1), (2, '0001_01_01_000001_create_cache_table', 1), (3, '0001_01_01_000002_create_jobs_table', 1), (4, '2025_05_24_171838_add_role_to_users_table', 1), (5, '2025_05_24_200742_create_mahasiswas_table', 1), (6, '2025_05_24_201738_create_dosens_table', 1), (7, '2025_05_24_203528_create_perusahaans_table', 1), (8, '2025_05_24_204121_create_laporan_pkls_table', 1), (9, '2025_05_24_204950_create_bimbingans_table', 1), (10, '2025_05_27_171842_remove_email_verified_at_from_users_table', 1), (11, '2025_05_29_133401_create_format_laporans_table', 1), (12, '2025_05_31_093816_create_pendaftaran_pkls_table', 1), (13, '2025_05_31_111231_add_bidang_pkl_and_status_to_pendaftaran_pkl_table', 1), (14, '2025_06_01_120740_create_nilai_pkl_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `nilai_pkl` -- CREATE TABLE `nilai_pkl` ( `id` bigint(20) UNSIGNED NOT NULL, `mahasiswa_id` bigint(20) UNSIGNED NOT NULL, `dosen_id` bigint(20) UNSIGNED NOT NULL, `nilai` decimal(5,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 `nilai_pkl` -- INSERT INTO `nilai_pkl` (`id`, `mahasiswa_id`, `dosen_id`, `nilai`, `created_at`, `updated_at`) VALUES (1, 3, 1, 87.00, '2026-02-18 22:56:07', '2026-02-18 22:56:07'); -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pendaftaran_pkl` -- CREATE TABLE `pendaftaran_pkl` ( `id` bigint(20) UNSIGNED NOT NULL, `mahasiswa_id` bigint(20) UNSIGNED NOT NULL, `perusahaan_id` bigint(20) UNSIGNED NOT NULL, `bidang_pkl` varchar(100) NOT NULL, `periode` varchar(255) NOT NULL, `status` varchar(20) NOT NULL DEFAULT 'menunggu', `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 `pendaftaran_pkl` -- INSERT INTO `pendaftaran_pkl` (`id`, `mahasiswa_id`, `perusahaan_id`, `bidang_pkl`, `periode`, `status`, `created_at`, `updated_at`) VALUES (1, 3, 1, 'Web Desain', 'Ganjil 2026', 'diterima', '2026-02-18 22:18:09', '2026-02-18 22:24:21'); -- -------------------------------------------------------- -- -- Table structure for table `perusahaan` -- CREATE TABLE `perusahaan` ( `id` bigint(20) UNSIGNED NOT NULL, `nama` varchar(255) NOT NULL, `alamat` varchar(255) NOT NULL, `no_hp` varchar(255) 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 for table `perusahaan` -- INSERT INTO `perusahaan` (`id`, `nama`, `alamat`, `no_hp`, `created_at`, `updated_at`) VALUES (1, 'PT. Kasep Muncul', 'Konoha Timur NO.1309 Konoha', '08121313131313', '2026-02-18 22:10:03', '2026-02-18 22:10:03'); -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sessions` -- INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('CsSUuDg6fKZdnKsHC83nqThz26isjpcgxm8gOdUU', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:147.0) Gecko/20100101 Firefox/147.0', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiaVYyblFkMThxTndjSGlsUFlWUG5RSDlFS1FlU0JRdE1YN2FNeWxuWSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==', 1771387124); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `role` enum('admin','mahasiswa','dosen') 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 for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `password`, `role`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Admin', 'admin@gmail.com', '$2y$12$eAqAOQlj9L2xs1wIsV6oLOPfLVh5w0jW7aqrc6.ui9PWYtuCLzSY6', 'admin', '1VHTvmH2emxf8MYAffDlEH2uuhVyxWfp3MrkqgAFQIP6IatWqyf60Ql1teEb', '2026-02-18 02:20:48', '2026-02-18 02:24:17'), (2, 'Nama Mahasiswa 1', 'mahasiswa1@gmail.com', '$2y$12$yNCq6Nle43zgLdASDPBJfewWFRfuG/xziZDXk2LnYZ8egGG0Ha7g6', 'mahasiswa', NULL, '2026-02-18 04:03:43', '2026-02-18 04:03:43'), (3, 'Nama Mahasiswa 2', 'mahasiswa2@gmail.com', '$2y$12$q1.JyiDlxNdeDgHbq84cRuNHrpjs35yiV2QORlFc9z1820IOns/T2', 'mahasiswa', NULL, '2026-02-18 04:03:43', '2026-02-18 04:03:43'), (4, 'Kisrun', 'kisrun@gmail.com', '$2y$12$eAqAOQlj9L2xs1wIsV6oLOPfLVh5w0jW7aqrc6.ui9PWYtuCLzSY6', 'mahasiswa', NULL, '2026-02-18 04:03:43', '2026-02-18 04:03:43'), (5, 'Budi', 'budi@gmail.com', '$2y$12$eAqAOQlj9L2xs1wIsV6oLOPfLVh5w0jW7aqrc6.ui9PWYtuCLzSY6', 'dosen', NULL, '2026-02-18 22:09:25', '2026-02-18 22:09:25'); -- -- Indexes for dumped tables -- -- -- Indexes for table `bimbingan` -- ALTER TABLE `bimbingan` ADD PRIMARY KEY (`id`), ADD KEY `bimbingan_mahasiswa_id_foreign` (`mahasiswa_id`), ADD KEY `bimbingan_dosen_id_foreign` (`dosen_id`); -- -- Indexes for table `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`); -- -- Indexes for table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`); -- -- Indexes for table `dosen` -- ALTER TABLE `dosen` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `dosen_nip_unique` (`nip`), ADD KEY `dosen_user_id_foreign` (`user_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 `format_laporan` -- ALTER TABLE `format_laporan` ADD PRIMARY KEY (`id`); -- -- Indexes for table `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `jobs_queue_index` (`queue`); -- -- Indexes for table `job_batches` -- ALTER TABLE `job_batches` ADD PRIMARY KEY (`id`); -- -- Indexes for table `laporan_pkl` -- ALTER TABLE `laporan_pkl` ADD PRIMARY KEY (`id`), ADD KEY `laporan_pkl_mahasiswa_id_foreign` (`mahasiswa_id`), ADD KEY `laporan_pkl_perusahaan_id_foreign` (`perusahaan_id`); -- -- Indexes for table `mahasiswa` -- ALTER TABLE `mahasiswa` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `mahasiswa_nim_unique` (`nim`), ADD KEY `mahasiswa_user_id_foreign` (`user_id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `nilai_pkl` -- ALTER TABLE `nilai_pkl` ADD PRIMARY KEY (`id`), ADD KEY `nilai_pkl_mahasiswa_id_foreign` (`mahasiswa_id`), ADD KEY `nilai_pkl_dosen_id_foreign` (`dosen_id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `pendaftaran_pkl` -- ALTER TABLE `pendaftaran_pkl` ADD PRIMARY KEY (`id`), ADD KEY `pendaftaran_pkl_mahasiswa_id_foreign` (`mahasiswa_id`), ADD KEY `pendaftaran_pkl_perusahaan_id_foreign` (`perusahaan_id`); -- -- Indexes for table `perusahaan` -- ALTER TABLE `perusahaan` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sessions` -- ALTER TABLE `sessions` ADD PRIMARY KEY (`id`), ADD KEY `sessions_user_id_index` (`user_id`), ADD KEY `sessions_last_activity_index` (`last_activity`); -- -- 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 `bimbingan` -- ALTER TABLE `bimbingan` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `dosen` -- ALTER TABLE `dosen` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `format_laporan` -- ALTER TABLE `format_laporan` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `jobs` -- ALTER TABLE `jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `laporan_pkl` -- ALTER TABLE `laporan_pkl` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `mahasiswa` -- ALTER TABLE `mahasiswa` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `nilai_pkl` -- ALTER TABLE `nilai_pkl` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `pendaftaran_pkl` -- ALTER TABLE `pendaftaran_pkl` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `perusahaan` -- ALTER TABLE `perusahaan` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- Constraints for dumped tables -- -- -- Constraints for table `bimbingan` -- ALTER TABLE `bimbingan` ADD CONSTRAINT `bimbingan_dosen_id_foreign` FOREIGN KEY (`dosen_id`) REFERENCES `dosen` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `bimbingan_mahasiswa_id_foreign` FOREIGN KEY (`mahasiswa_id`) REFERENCES `mahasiswa` (`id`) ON DELETE CASCADE; -- -- Constraints for table `dosen` -- ALTER TABLE `dosen` ADD CONSTRAINT `dosen_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `laporan_pkl` -- ALTER TABLE `laporan_pkl` ADD CONSTRAINT `laporan_pkl_mahasiswa_id_foreign` FOREIGN KEY (`mahasiswa_id`) REFERENCES `mahasiswa` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `laporan_pkl_perusahaan_id_foreign` FOREIGN KEY (`perusahaan_id`) REFERENCES `perusahaan` (`id`) ON DELETE SET NULL; -- -- Constraints for table `mahasiswa` -- ALTER TABLE `mahasiswa` ADD CONSTRAINT `mahasiswa_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `nilai_pkl` -- ALTER TABLE `nilai_pkl` ADD CONSTRAINT `nilai_pkl_dosen_id_foreign` FOREIGN KEY (`dosen_id`) REFERENCES `dosen` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `nilai_pkl_mahasiswa_id_foreign` FOREIGN KEY (`mahasiswa_id`) REFERENCES `mahasiswa` (`id`) ON DELETE CASCADE; -- -- Constraints for table `pendaftaran_pkl` -- ALTER TABLE `pendaftaran_pkl` ADD CONSTRAINT `pendaftaran_pkl_mahasiswa_id_foreign` FOREIGN KEY (`mahasiswa_id`) REFERENCES `mahasiswa` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `pendaftaran_pkl_perusahaan_id_foreign` FOREIGN KEY (`perusahaan_id`) REFERENCES `perusahaan` (`id`) ON DELETE CASCADE; 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 */;