-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: May 18, 2026 at 07:23 AM -- Server version: 8.4.3 -- PHP Version: 8.3.30 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: `jurusan_otomotif` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id_admin` int NOT NULL, `nama_admin` varchar(100) NOT NULL, `username` varchar(100) NOT NULL, `password` varchar(255) NOT NULL, `foto` varchar(255) NOT NULL, `level` enum('superadmin','admin') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `alumni` -- CREATE TABLE `alumni` ( `id_alumni` int NOT NULL, `id_profil` int NOT NULL, `nama` varchar(200) NOT NULL, `tahun_lulus` year NOT NULL, `kelanjutan` enum('kerja','kuliah') NOT NULL, `tempat` varchar(150) NOT NULL, `jabatan` varchar(100) NOT NULL, `testimoni` text NOT NULL, `foto` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `berita` -- CREATE TABLE `berita` ( `id_berita` int NOT NULL, `kategori_berita` varchar(200) NOT NULL, `judul` varchar(200) NOT NULL, `isi_berita` text NOT NULL, `tanggal` date NOT NULL, `gambar` varchar(255) NOT NULL, `id_petugas` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `galeri` -- CREATE TABLE `galeri` ( `id_galeri` int NOT NULL, `id_petugas` int NOT NULL, `judul` varchar(100) NOT NULL, `foto` varchar(225) NOT NULL, `deskripsi` text NOT NULL, `tanggal_kegiatan` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `guru` -- CREATE TABLE `guru` ( `nip` int NOT NULL, `id_profil` int NOT NULL, `nama_guru` varchar(100) NOT NULL, `mapel` varchar(200) NOT NULL, `jabatan` varchar(200) NOT NULL, `foto` varchar(225) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `jadwal_praktik` -- CREATE TABLE `jadwal_praktik` ( `id_jadwal` int NOT NULL, `kelas` varchar(50) NOT NULL, `hari` varchar(50) NOT NULL, `jam` time NOT NULL, `guru_pengajar` varchar(100) NOT NULL, `nip_guru` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `pengumuman` -- CREATE TABLE `pengumuman` ( `id_pengumuman` int NOT NULL, `judul` varchar(200) NOT NULL, `isi` text NOT NULL, `tanggal` date NOT NULL, `id_petugas` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `petugas` -- CREATE TABLE `petugas` ( `id_petugas` int NOT NULL, `nama_petugas` varchar(100) NOT NULL, `username` varchar(100) NOT NULL, `password` varchar(255) NOT NULL, `jabatan` varchar(100) NOT NULL, `foto` varchar(255) NOT NULL, `id_admin` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `pkl` -- CREATE TABLE `pkl` ( `id_pkl` int NOT NULL, `nama_perusahaan` varchar(150) NOT NULL, `alamat` text NOT NULL, `bidang` varchar(100) NOT NULL, `tahun_kerjasama` year NOT NULL, `id_profil` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `prestasi` -- CREATE TABLE `prestasi` ( `id_prestasi` int NOT NULL, `id_petugas` int NOT NULL, `nama_prestasi` varchar(100) NOT NULL, `tingkat` varchar(225) NOT NULL, `tahun` year NOT NULL, `deskripsi` text NOT NULL, `foto` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `profil_jurusan` -- CREATE TABLE `profil_jurusan` ( `id_profil` int NOT NULL, `nama_jurusan` varchar(100) NOT NULL, `deskripsi` text NOT NULL, `visi` text NOT NULL, `misi` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `siswa` -- CREATE TABLE `siswa` ( `nis` int NOT NULL, `nama_siswa` varchar(100) NOT NULL, `kelas` varchar(50) NOT NULL, `jk` enum('laki-laki','perempuan') NOT NULL, `alamat` varchar(255) NOT NULL, `foto` varchar(255) NOT NULL, `id_profil` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `admin` -- ALTER TABLE `admin` ADD PRIMARY KEY (`id_admin`); -- -- Indexes for table `alumni` -- ALTER TABLE `alumni` ADD PRIMARY KEY (`id_alumni`), ADD KEY `id_profil` (`id_profil`); -- -- Indexes for table `berita` -- ALTER TABLE `berita` ADD PRIMARY KEY (`id_berita`), ADD KEY `id_petugas` (`id_petugas`); -- -- Indexes for table `galeri` -- ALTER TABLE `galeri` ADD PRIMARY KEY (`id_galeri`), ADD KEY `id_profil` (`id_petugas`), ADD KEY `id_petugas` (`id_petugas`); -- -- Indexes for table `guru` -- ALTER TABLE `guru` ADD PRIMARY KEY (`nip`), ADD KEY `id_profil` (`id_profil`); -- -- Indexes for table `jadwal_praktik` -- ALTER TABLE `jadwal_praktik` ADD PRIMARY KEY (`id_jadwal`), ADD KEY `id_guru` (`nip_guru`), ADD KEY `nip_guru` (`nip_guru`); -- -- Indexes for table `pengumuman` -- ALTER TABLE `pengumuman` ADD PRIMARY KEY (`id_pengumuman`), ADD KEY `id_petugas` (`id_petugas`); -- -- Indexes for table `petugas` -- ALTER TABLE `petugas` ADD PRIMARY KEY (`id_petugas`), ADD KEY `id_admin` (`id_admin`); -- -- Indexes for table `pkl` -- ALTER TABLE `pkl` ADD PRIMARY KEY (`id_pkl`), ADD KEY `id_profil` (`id_profil`); -- -- Indexes for table `prestasi` -- ALTER TABLE `prestasi` ADD PRIMARY KEY (`id_prestasi`), ADD KEY `id_profil` (`id_petugas`), ADD KEY `id_petugas` (`id_petugas`); -- -- Indexes for table `profil_jurusan` -- ALTER TABLE `profil_jurusan` ADD PRIMARY KEY (`id_profil`); -- -- Indexes for table `siswa` -- ALTER TABLE `siswa` ADD PRIMARY KEY (`nis`), ADD KEY `id_profil` (`id_profil`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin` -- ALTER TABLE `admin` MODIFY `id_admin` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `alumni` -- ALTER TABLE `alumni` MODIFY `id_alumni` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `berita` -- ALTER TABLE `berita` MODIFY `id_berita` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `galeri` -- ALTER TABLE `galeri` MODIFY `id_galeri` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `jadwal_praktik` -- ALTER TABLE `jadwal_praktik` MODIFY `id_jadwal` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pengumuman` -- ALTER TABLE `pengumuman` MODIFY `id_pengumuman` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `petugas` -- ALTER TABLE `petugas` MODIFY `id_petugas` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pkl` -- ALTER TABLE `pkl` MODIFY `id_pkl` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `prestasi` -- ALTER TABLE `prestasi` MODIFY `id_prestasi` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `profil_jurusan` -- ALTER TABLE `profil_jurusan` MODIFY `id_profil` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `siswa` -- ALTER TABLE `siswa` MODIFY `nis` int NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `alumni` -- ALTER TABLE `alumni` ADD CONSTRAINT `alumni_ibfk_1` FOREIGN KEY (`id_profil`) REFERENCES `profil_jurusan` (`id_profil`); -- -- Constraints for table `berita` -- ALTER TABLE `berita` ADD CONSTRAINT `berita_ibfk_1` FOREIGN KEY (`id_petugas`) REFERENCES `petugas` (`id_petugas`); -- -- Constraints for table `galeri` -- ALTER TABLE `galeri` ADD CONSTRAINT `galeri_ibfk_1` FOREIGN KEY (`id_petugas`) REFERENCES `petugas` (`id_petugas`); -- -- Constraints for table `guru` -- ALTER TABLE `guru` ADD CONSTRAINT `guru_ibfk_1` FOREIGN KEY (`id_profil`) REFERENCES `profil_jurusan` (`id_profil`); -- -- Constraints for table `jadwal_praktik` -- ALTER TABLE `jadwal_praktik` ADD CONSTRAINT `jadwal_praktik_ibfk_1` FOREIGN KEY (`nip_guru`) REFERENCES `guru` (`nip`); -- -- Constraints for table `pengumuman` -- ALTER TABLE `pengumuman` ADD CONSTRAINT `pengumuman_ibfk_1` FOREIGN KEY (`id_petugas`) REFERENCES `petugas` (`id_petugas`); -- -- Constraints for table `petugas` -- ALTER TABLE `petugas` ADD CONSTRAINT `petugas_ibfk_1` FOREIGN KEY (`id_admin`) REFERENCES `admin` (`id_admin`); -- -- Constraints for table `pkl` -- ALTER TABLE `pkl` ADD CONSTRAINT `pkl_ibfk_1` FOREIGN KEY (`id_profil`) REFERENCES `profil_jurusan` (`id_profil`); -- -- Constraints for table `prestasi` -- ALTER TABLE `prestasi` ADD CONSTRAINT `prestasi_ibfk_1` FOREIGN KEY (`id_petugas`) REFERENCES `petugas` (`id_petugas`); -- -- Constraints for table `siswa` -- ALTER TABLE `siswa` ADD CONSTRAINT `siswa_ibfk_1` FOREIGN KEY (`id_profil`) REFERENCES `profil_jurusan` (`id_profil`); 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 */;