-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: May 12, 2024 at 08:21 AM
-- Server version: 8.0.30
-- PHP Version: 7.4.33

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: `db_prakerin`
--

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

--
-- Table structure for table `absensi`
--

CREATE TABLE `absensi` (
  `id_absen` int NOT NULL,
  `tgl` date DEFAULT NULL,
  `status` enum('hadir','sakit','ijin','alfa','pending') DEFAULT NULL,
  `id_penempatan` int DEFAULT NULL,
  `catatan` varchar(225) DEFAULT NULL,
  `foto` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(200) DEFAULT NULL,
  `nama` varchar(200) DEFAULT NULL,
  `id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`username`, `password`, `nama`, `id`) VALUES
('admin', '$2y$10$gKOq3g/rWca/C9Mwsb1J8eq2nNDpz2kwCFyakH47Co6vO3.Swk1H2', 'Ardhika Restu Yoviyanto', 1),
('admin2', '$2y$10$nQDZtAtPE3aBAJhMkOQB9OdO7gNcY/0O0wGtJVRYq.KFRV/dkZeta', 'Reza Bagaskara', 4);

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

--
-- Table structure for table `agenda`
--

CREATE TABLE `agenda` (
  `id_agenda` int NOT NULL,
  `id_kategoriagenda` int DEFAULT NULL,
  `judul` varchar(225) DEFAULT NULL,
  `slug` varchar(226) DEFAULT NULL,
  `isi` mediumtext,
  `gambar` varchar(225) DEFAULT NULL,
  `file` varchar(225) DEFAULT NULL,
  `dilihat` int DEFAULT NULL,
  `tgl` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `aspek_penilaian`
--

CREATE TABLE `aspek_penilaian` (
  `id_aspek` int NOT NULL,
  `id_jurusan` int DEFAULT NULL,
  `nama_aspek` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `aspek_penilaian`
--

INSERT INTO `aspek_penilaian` (`id_aspek`, `id_jurusan`, `nama_aspek`) VALUES
(13, 5, 'KEJUJURAN'),
(14, 5, 'DISIPLIN'),
(15, 5, 'KEPINTERAN');

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

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `judul` varchar(255) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `banner`
--

INSERT INTO `banner` (`judul`, `file`, `id`) VALUES
('Manfaat Kegiatan Prakerin Bagi Siswa SMK', 'undraw_co-working_825n.png', 1),
('Tips Prakerin Agar Sukses dan dapat hasil memuaskan', 'undraw_digital_nomad_9kgl.png', 2),
('Prakerin Itu Asyik Kok', 'undraw_QA_engineers_dg5p.png', 3);

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

--
-- Table structure for table `chat`
--

CREATE TABLE `chat` (
  `id_chat` int NOT NULL,
  `isi` mediumtext,
  `lampiran` varchar(225) DEFAULT NULL,
  `id_pembimbing` int DEFAULT NULL,
  `tgl` datetime DEFAULT NULL,
  `pengirim` enum('admin','guru') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `chat_pembimbing`
--

CREATE TABLE `chat_pembimbing` (
  `id_chat_pembimbing` int NOT NULL,
  `isi` mediumtext,
  `lampiran` varchar(225) DEFAULT NULL,
  `id_pengirim` int DEFAULT NULL,
  `tgl` datetime DEFAULT NULL,
  `id_penerima` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `industri`
--

CREATE TABLE `industri` (
  `id_industri` int NOT NULL,
  `nama_industri` varchar(225) DEFAULT NULL,
  `alamat_industri` varchar(250) DEFAULT NULL,
  `deskripsi` mediumtext,
  `kuota` int DEFAULT NULL,
  `foto` varchar(200) DEFAULT NULL,
  `bidang_kerja` varchar(200) DEFAULT NULL,
  `telp` varchar(50) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `syarat` mediumtext,
  `slug` varchar(300) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `industri`
--

INSERT INTO `industri` (`id_industri`, `nama_industri`, `alamat_industri`, `deskripsi`, `kuota`, `foto`, `bidang_kerja`, `telp`, `email`, `syarat`, `slug`) VALUES
(2, 'PT GOOGLE', 'Jl Magelang Km 08 Jogjakarta', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).<br></p>', 23, '905369_720.jpg', 'Software Engineer', '0876767621123', 'nirawanacomputer@company.com', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).<br></p>', 'pt-google'),
(6, 'PT BANK INDONESIA', 'Jln. Kebon Jeruk, Km 06 Jakarta Pusat', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p><p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p><p><br></p>', 36, 'bank.jpg', 'Perbankan', '087654321235', 'bank@gmail.com', '<ol><li>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</li><li>Praesent faucibus est ut nibh condimentum euismod.</li><li>Fusce sit amet dolor venenatis, sodales felis non, aliquet nibh.</li><li>Praesent eu nulla a massa blandit iaculis.</li><li>Mauris sit amet nibh ac erat eleifend varius ac euismod turpis.</li></ol>', 'pt-bank-indonesia'),
(7, 'ASTRA MOTORCYCLE', 'Solo, Jawa Tengah', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).<br></p>', 20, '017889900_1481687934-Astra-Internasional_jasalowongankerja.com.jpg', 'Teknik Mesin', '08876543456', 'astra@gmail.com', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).<br></p>', 'astra-motorcycle');

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

--
-- Table structure for table `industri_join_pembimbing`
--

CREATE TABLE `industri_join_pembimbing` (
  `id` int NOT NULL,
  `id_industri` int DEFAULT NULL,
  `id_pembimbing` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `industri_join_pembimbing`
--

INSERT INTO `industri_join_pembimbing` (`id`, `id_industri`, `id_pembimbing`) VALUES
(26, 7, 41),
(27, 6, 41),
(30, 6, 43),
(31, 2, 43),
(74, 7, 42),
(75, 2, 42);

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

--
-- Table structure for table `instansi`
--

CREATE TABLE `instansi` (
  `nama_instansi` varchar(100) DEFAULT NULL,
  `notelp` varchar(100) DEFAULT NULL,
  `alamat` varchar(200) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `logo_kanan` varchar(200) DEFAULT NULL,
  `logo_kiri` varchar(200) DEFAULT NULL,
  `nama_app` varchar(100) DEFAULT NULL,
  `kepala_sekolah` varchar(100) DEFAULT NULL,
  `badansurat` mediumtext,
  `disqus` mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `instansi`
--

INSERT INTO `instansi` (`nama_instansi`, `notelp`, `alamat`, `email`, `logo_kanan`, `logo_kiri`, `nama_app`, `kepala_sekolah`, `badansurat`, `disqus`) VALUES
('SMK Percobaan', '082313104589', 'Jln Jumapolo Km 01, Karanganyar Jawa Tengah', 'smkpercobaan@gmail.com', 'kanan.png', 'kiri_2.jpg', 'Sistem Informasi Prakerin', 'Drs, Mulyadi Suprapto', '<p><span style=\"font-family: \" segoe=\"\" ui\";\"=\"\">Dengan Hormat,</span></p><p>Assalamu’alaikum Wr.Wb.</p><p>Sehubungan dengan pelaksanaan kegiatan rutin SMK Banten Raya Pandeglang Tahun Pelajaran 2019/2020 yang mewajibkan setiap siswa/I untuk melaksanakan kegiatan Praktek Kerja Industri (PRAKERIN) sebagai salah satu syarat untuk menempuh Ujian Akhir di kelas XII.</p><p>Berkenaan dengan hal tersebut, kami bermaksud untuk mengajukan permohonan serta kesediaan instansi/perusahaan yang Bapak/Ibu Pimpin untuk dapat menerima siswa/I kami dalam pelaksanaan kegiatan PKL terhitung mulai tanggal 9 Maret s/d 8 April 2020. Adapun siswa yang mengikuti kegiatan ini terlampir.</p><p>Demikian surat ini disampaikan Atas perhatian dan kerjasamanya kami ucapkan terimakasih.</p><p>Wassalamu’alaikum Wr.Wb.</p>', '<script>\r\n(function() { // DON\'T EDIT BELOW THIS LINE\r\nvar d = document, s = d.createElement(\'script\');\r\ns.src = \'https://ardhikayoviyanto-1.disqus.com/embed.js\';\r\ns.setAttribute(\'data-timestamp\', +new Date());\r\n(d.head || d.body).appendChild(s);\r\n})();\r\n</script>');

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

--
-- Table structure for table `jurnal`
--

CREATE TABLE `jurnal` (
  `id_jurnal` int NOT NULL,
  `file` varchar(225) DEFAULT NULL,
  `judul` varchar(225) DEFAULT NULL,
  `keterangan` varchar(500) DEFAULT NULL,
  `tgl_kumpul` datetime DEFAULT NULL,
  `id_penempatan` int DEFAULT NULL,
  `nilai` float DEFAULT NULL,
  `status` enum('N','Y','P') DEFAULT NULL,
  `catatan` varchar(225) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `jurnal_harian`
--

CREATE TABLE `jurnal_harian` (
  `id_jurnal_harian` int NOT NULL,
  `tgl` date DEFAULT NULL,
  `kegiatan` mediumtext,
  `id_penempatan` int DEFAULT NULL,
  `status` enum('Y','N','P') DEFAULT NULL,
  `catatan` varchar(255) DEFAULT NULL,
  `tempat` varchar(255) DEFAULT NULL,
  `jenis_kegiatan` varchar(255) DEFAULT NULL,
  `dokumentasi_kegiatan` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `jurnal_harian`
--

INSERT INTO `jurnal_harian` (`id_jurnal_harian`, `tgl`, `kegiatan`, `id_penempatan`, `status`, `catatan`, `tempat`, `jenis_kegiatan`, `dokumentasi_kegiatan`) VALUES
(8, '2023-07-19', 'Membuat CV di Linkedin,Mengerjakan Service Motor', 19, 'P', 'kosong', NULL, NULL, NULL),
(9, '2023-07-19', 'Mengerjakan Laporan Perbankan ,Memberikan presentasi pada nasabah bank mengenai pinjol', 24, 'P', 'kosong', NULL, NULL, NULL),
(12, '2024-05-12', 'TEST 3 - TEST 4', 18, 'P', 'kosong', 'TEST 1', 'TEST 2', 'sdsdsdsd.png');

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

--
-- Table structure for table `jurusan`
--

CREATE TABLE `jurusan` (
  `id_jurusan` int NOT NULL,
  `nama_jurusan` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `jurusan`
--

INSERT INTO `jurusan` (`id_jurusan`, `nama_jurusan`) VALUES
(1, 'TKJ'),
(4, 'TKR'),
(5, 'PERBANKAN');

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

--
-- Table structure for table `kategori_agenda`
--

CREATE TABLE `kategori_agenda` (
  `id_kategoriagenda` int NOT NULL,
  `nama_kategoriagenda` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kategori_agenda`
--

INSERT INTO `kategori_agenda` (`id_kategoriagenda`, `nama_kategoriagenda`) VALUES
(1, 'Pengumuman Prakerin'),
(2, 'Tips Prakerin'),
(3, 'Berita Harian');

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

--
-- Table structure for table `kelas`
--

CREATE TABLE `kelas` (
  `id_kelas` int NOT NULL,
  `nama_kelas` varchar(200) DEFAULT NULL,
  `id_jurusan` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kelas`
--

INSERT INTO `kelas` (`id_kelas`, `nama_kelas`, `id_jurusan`) VALUES
(4, 'XII TKR', 4),
(7, 'XII TKJ', 1),
(10, 'XII PERBANKAN', 5);

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

--
-- Table structure for table `nilai`
--

CREATE TABLE `nilai` (
  `id_nilai` int NOT NULL,
  `id_penempatan` int DEFAULT NULL,
  `id_aspek` int DEFAULT NULL,
  `nilai_angka` double DEFAULT NULL,
  `nilai_huruf` enum('Baik Sekali','Baik','Cukup','Kurang') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `nilai`
--

INSERT INTO `nilai` (`id_nilai`, `id_penempatan`, `id_aspek`, `nilai_angka`, `nilai_huruf`) VALUES
(86, 7, 13, 90, 'Baik Sekali'),
(87, 7, 14, 90, 'Baik Sekali'),
(88, 7, 15, 80, 'Baik');

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

--
-- Table structure for table `pembimbing`
--

CREATE TABLE `pembimbing` (
  `id_pembimbing` int NOT NULL,
  `username` varchar(200) DEFAULT NULL,
  `password` varchar(200) DEFAULT NULL,
  `nip` varchar(100) DEFAULT NULL,
  `nama_pembimbing` varchar(200) DEFAULT NULL,
  `nohp` varchar(200) DEFAULT NULL,
  `type` enum('I','S') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `pembimbing`
--

INSERT INTO `pembimbing` (`id_pembimbing`, `username`, `password`, `nip`, `nama_pembimbing`, `nohp`, `type`) VALUES
(41, '@tino', '$2y$10$rq5QKsH5oVxzEkhXxvF.DuAYwJJv9RZjz.0b88bj4XMtfNZYZvP0m', '-', 'TINO SUHARTONO', '081217145682', 'I'),
(42, '@riyan', '$2y$10$/6/bzTJ5I9.SKTY9TuU65ewP3qKbDPT5c4YTWunkcRcYAxzkS8YFu', '-', 'RIYAN PRASTOWO', '081217145683', 'S'),
(43, '@pyrwanto', '$2y$10$leDIC50qPQoRiKrnxv4OuuQ0Xs4dNrhFAJPIK9eBM.5l02LQ8O.52', '-', 'PURWANTO ADI PAMUNGKAS S.KOM', NULL, NULL);

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

--
-- Table structure for table `penempatan`
--

CREATE TABLE `penempatan` (
  `id_penempatan` int NOT NULL,
  `id_siswa` int DEFAULT NULL,
  `id_industri` int DEFAULT NULL,
  `tgl_request` datetime DEFAULT NULL,
  `status` enum('diterima','ditolak','pending') DEFAULT NULL,
  `surat` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `penempatan`
--

INSERT INTO `penempatan` (`id_penempatan`, `id_siswa`, `id_industri`, `tgl_request`, `status`, `surat`) VALUES
(6, 10, 6, '2021-06-21 16:08:12', 'diterima', 'kosong'),
(7, 9, 6, '2021-06-21 16:08:12', 'diterima', 'kosong'),
(8, 2, 2, '2021-06-21 21:49:56', 'diterima', 'kosong'),
(9, 1, 2, '2021-06-21 21:49:56', 'diterima', 'kosong'),
(15, 14, 6, '2021-07-03 12:09:34', 'diterima', 'kosong'),
(18, 16, 7, '2021-07-07 18:56:37', 'diterima', 'kosong'),
(19, 15, 7, '2021-07-07 18:56:37', 'diterima', 'kosong'),
(24, 8, 6, '2022-01-04 10:19:59', 'diterima', 'kosong');

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

--
-- Table structure for table `siswa`
--

CREATE TABLE `siswa` (
  `id_siswa` int NOT NULL,
  `nis` varchar(50) DEFAULT NULL,
  `alamat` varchar(200) DEFAULT NULL,
  `password` varchar(200) DEFAULT NULL,
  `nama_siswa` varchar(200) DEFAULT NULL,
  `id_kelas` int DEFAULT NULL,
  `username` varchar(200) DEFAULT NULL,
  `jenis_kelamin` enum('L','P') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `siswa`
--

INSERT INTO `siswa` (`id_siswa`, `nis`, `alamat`, `password`, `nama_siswa`, `id_kelas`, `username`, `jenis_kelamin`) VALUES
(1, '100', 'Ndlangin, Jumapolo', '$2y$10$toMdNimhIyphhkD/emYG4OEjlJPx6SbJ6vs2THyWo.EZxR.TRBimq', 'PUTRI INDAH LESTARI', 7, '@putri', 'P'),
(2, '101', 'Sleman, Jogjakarta', '$2y$10$mjBO4VoeHbtJcwMsDL2wReuOjLPvyMwYaOFEt5TyPp9LyGbcCOdHG', 'AGUNG CAHYO SUMIRAT', 7, '@agung', 'L'),
(8, '102', 'Solo, Jawa Tengah', '$2y$10$LkgyngI49/C0lGsWlDpVyeeY20l1U0weWUZRUF.73ii08AGDyltcS', 'ANDIKA BAGASKARA', 10, '@siswa2', 'L'),
(9, '103', 'Kedawung, Karanganyar', '$2y$10$fNvOOdX9USx9wJ7t1Lq8/ur1OdPPTsPHVjW9k6JzaQ1waRByzGmGm', 'ARTIKA EVA', 10, '@eva', 'P'),
(10, '104', 'Giriwondo, Jumapolo', '$2y$10$Mfaj/28e9ODk3I/ELRIxg.BChVpBTRBi9n3Mlaj.JQ1.6CkZqJUp.', 'RIO ALEXANDER', 10, '@rio', 'L'),
(14, '105', 'Bondalem, Jumantoro, Jumapolo', '$2y$10$BnwC0Ld97MqdTqDs2XnF8erDtI5nmUQGg69L5HhcCNAgmK6JciaXW', 'ALEXANDER', 10, '@alex', 'L'),
(15, '106', 'Bantul, Yogyakarta', '$2y$10$ChglMUIoTx4NqCHDoT7zNuL0AOsV38neNSBH0whc9zBPwLXw1pIQe', 'MUHAMMAD HAFIZ', 4, '@siswa1', 'L'),
(16, '107', 'Bantul, Yogyakarta', '$2y$10$Sbx43cw.PW7MsgkmTozsI.nLDZcIyBje8ySNZUCjCeqXPcMv0fxiS', 'AHMAD ZULFIKAR PRASETYO', 4, '@zulfikar', 'L');

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

--
-- Table structure for table `tolak_penempatan`
--

CREATE TABLE `tolak_penempatan` (
  `id_penolakan` int NOT NULL,
  `id_penempatan` int DEFAULT NULL,
  `tgl` datetime DEFAULT NULL,
  `alasan` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `absensi`
--
ALTER TABLE `absensi`
  ADD PRIMARY KEY (`id_absen`),
  ADD KEY `IdPenempatan` (`id_penempatan`);

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD KEY `id` (`id`);

--
-- Indexes for table `agenda`
--
ALTER TABLE `agenda`
  ADD PRIMARY KEY (`id_agenda`),
  ADD KEY `IdKategoriAgenda` (`id_kategoriagenda`);

--
-- Indexes for table `aspek_penilaian`
--
ALTER TABLE `aspek_penilaian`
  ADD PRIMARY KEY (`id_aspek`),
  ADD KEY `Jurusan` (`id_jurusan`);

--
-- Indexes for table `banner`
--
ALTER TABLE `banner`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `chat`
--
ALTER TABLE `chat`
  ADD PRIMARY KEY (`id_chat`),
  ADD KEY `IdPembimbing` (`id_pembimbing`);

--
-- Indexes for table `chat_pembimbing`
--
ALTER TABLE `chat_pembimbing`
  ADD PRIMARY KEY (`id_chat_pembimbing`),
  ADD KEY `PenerimaChat` (`id_penerima`),
  ADD KEY `PengirimChat` (`id_pengirim`);

--
-- Indexes for table `industri`
--
ALTER TABLE `industri`
  ADD PRIMARY KEY (`id_industri`);

--
-- Indexes for table `industri_join_pembimbing`
--
ALTER TABLE `industri_join_pembimbing`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_industri` (`id_industri`),
  ADD KEY `id_pembimbing` (`id_pembimbing`);

--
-- Indexes for table `jurnal`
--
ALTER TABLE `jurnal`
  ADD PRIMARY KEY (`id_jurnal`),
  ADD KEY `_IdPenempatan` (`id_penempatan`);

--
-- Indexes for table `jurnal_harian`
--
ALTER TABLE `jurnal_harian`
  ADD PRIMARY KEY (`id_jurnal_harian`),
  ADD KEY `HarianJurnal` (`id_penempatan`);

--
-- Indexes for table `jurusan`
--
ALTER TABLE `jurusan`
  ADD PRIMARY KEY (`id_jurusan`);

--
-- Indexes for table `kategori_agenda`
--
ALTER TABLE `kategori_agenda`
  ADD PRIMARY KEY (`id_kategoriagenda`);

--
-- Indexes for table `kelas`
--
ALTER TABLE `kelas`
  ADD PRIMARY KEY (`id_kelas`),
  ADD KEY `IdJurusan` (`id_jurusan`);

--
-- Indexes for table `nilai`
--
ALTER TABLE `nilai`
  ADD PRIMARY KEY (`id_nilai`),
  ADD KEY `_Id_Penempatan` (`id_penempatan`),
  ADD KEY `_Id_Aspek` (`id_aspek`);

--
-- Indexes for table `pembimbing`
--
ALTER TABLE `pembimbing`
  ADD PRIMARY KEY (`id_pembimbing`);

--
-- Indexes for table `penempatan`
--
ALTER TABLE `penempatan`
  ADD PRIMARY KEY (`id_penempatan`),
  ADD KEY `Id_Siswa` (`id_siswa`),
  ADD KEY `Id_Industri` (`id_industri`);

--
-- Indexes for table `siswa`
--
ALTER TABLE `siswa`
  ADD PRIMARY KEY (`id_siswa`),
  ADD KEY `IdKelas` (`id_kelas`);

--
-- Indexes for table `tolak_penempatan`
--
ALTER TABLE `tolak_penempatan`
  ADD PRIMARY KEY (`id_penolakan`),
  ADD KEY `PenempatanId` (`id_penempatan`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `absensi`
--
ALTER TABLE `absensi`
  MODIFY `id_absen` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=124;

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `agenda`
--
ALTER TABLE `agenda`
  MODIFY `id_agenda` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `aspek_penilaian`
--
ALTER TABLE `aspek_penilaian`
  MODIFY `id_aspek` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `banner`
--
ALTER TABLE `banner`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `chat`
--
ALTER TABLE `chat`
  MODIFY `id_chat` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `chat_pembimbing`
--
ALTER TABLE `chat_pembimbing`
  MODIFY `id_chat_pembimbing` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `industri`
--
ALTER TABLE `industri`
  MODIFY `id_industri` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `industri_join_pembimbing`
--
ALTER TABLE `industri_join_pembimbing`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- AUTO_INCREMENT for table `jurnal`
--
ALTER TABLE `jurnal`
  MODIFY `id_jurnal` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `jurnal_harian`
--
ALTER TABLE `jurnal_harian`
  MODIFY `id_jurnal_harian` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `jurusan`
--
ALTER TABLE `jurusan`
  MODIFY `id_jurusan` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `kategori_agenda`
--
ALTER TABLE `kategori_agenda`
  MODIFY `id_kategoriagenda` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `kelas`
--
ALTER TABLE `kelas`
  MODIFY `id_kelas` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `nilai`
--
ALTER TABLE `nilai`
  MODIFY `id_nilai` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=89;

--
-- AUTO_INCREMENT for table `pembimbing`
--
ALTER TABLE `pembimbing`
  MODIFY `id_pembimbing` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `penempatan`
--
ALTER TABLE `penempatan`
  MODIFY `id_penempatan` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `siswa`
--
ALTER TABLE `siswa`
  MODIFY `id_siswa` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `tolak_penempatan`
--
ALTER TABLE `tolak_penempatan`
  MODIFY `id_penolakan` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `absensi`
--
ALTER TABLE `absensi`
  ADD CONSTRAINT `IdPenempatan` FOREIGN KEY (`id_penempatan`) REFERENCES `penempatan` (`id_penempatan`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `agenda`
--
ALTER TABLE `agenda`
  ADD CONSTRAINT `IdKategoriAgenda` FOREIGN KEY (`id_kategoriagenda`) REFERENCES `kategori_agenda` (`id_kategoriagenda`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `aspek_penilaian`
--
ALTER TABLE `aspek_penilaian`
  ADD CONSTRAINT `Jurusan` FOREIGN KEY (`id_jurusan`) REFERENCES `jurusan` (`id_jurusan`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `chat`
--
ALTER TABLE `chat`
  ADD CONSTRAINT `IdPembimbing` FOREIGN KEY (`id_pembimbing`) REFERENCES `pembimbing` (`id_pembimbing`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `chat_pembimbing`
--
ALTER TABLE `chat_pembimbing`
  ADD CONSTRAINT `PenerimaChat` FOREIGN KEY (`id_penerima`) REFERENCES `pembimbing` (`id_pembimbing`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `PengirimChat` FOREIGN KEY (`id_pengirim`) REFERENCES `pembimbing` (`id_pembimbing`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `industri_join_pembimbing`
--
ALTER TABLE `industri_join_pembimbing`
  ADD CONSTRAINT `industri_join_pembimbing_ibfk_1` FOREIGN KEY (`id_industri`) REFERENCES `industri` (`id_industri`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `industri_join_pembimbing_ibfk_2` FOREIGN KEY (`id_pembimbing`) REFERENCES `pembimbing` (`id_pembimbing`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `jurnal`
--
ALTER TABLE `jurnal`
  ADD CONSTRAINT `_IdPenempatan` FOREIGN KEY (`id_penempatan`) REFERENCES `penempatan` (`id_penempatan`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `jurnal_harian`
--
ALTER TABLE `jurnal_harian`
  ADD CONSTRAINT `HarianJurnal` FOREIGN KEY (`id_penempatan`) REFERENCES `penempatan` (`id_penempatan`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kelas`
--
ALTER TABLE `kelas`
  ADD CONSTRAINT `IdJurusan` FOREIGN KEY (`id_jurusan`) REFERENCES `jurusan` (`id_jurusan`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `nilai`
--
ALTER TABLE `nilai`
  ADD CONSTRAINT `_Id_Aspek` FOREIGN KEY (`id_aspek`) REFERENCES `aspek_penilaian` (`id_aspek`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `_Id_Penempatan` FOREIGN KEY (`id_penempatan`) REFERENCES `penempatan` (`id_penempatan`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `penempatan`
--
ALTER TABLE `penempatan`
  ADD CONSTRAINT `Id_Industri` FOREIGN KEY (`id_industri`) REFERENCES `industri` (`id_industri`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `Id_Siswa` FOREIGN KEY (`id_siswa`) REFERENCES `siswa` (`id_siswa`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `siswa`
--
ALTER TABLE `siswa`
  ADD CONSTRAINT `IdKelas` FOREIGN KEY (`id_kelas`) REFERENCES `kelas` (`id_kelas`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `tolak_penempatan`
--
ALTER TABLE `tolak_penempatan`
  ADD CONSTRAINT `PenempatanId` FOREIGN KEY (`id_penempatan`) REFERENCES `penempatan` (`id_penempatan`) ON DELETE CASCADE ON UPDATE 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 */;
