-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: sql113.infinityfree.com
-- Generation Time: Sep 29, 2026 at 09:27 AM
-- Server version: 11.4.13-MariaDB
-- PHP Version: 7.2.22

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+07: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: `if0_43031141_db_dojo`
--

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

--
-- Table structure for table `t_dojo`
--

CREATE TABLE `t_dojo` (
  `id` int(11) NOT NULL,
  `nama_dojo` varchar(100) NOT NULL,
  `deskripsi` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `t_dojo`
--

INSERT INTO `t_dojo` (`id`, `nama_dojo`, `deskripsi`, `created_at`) VALUES
(3, 'Barcode', '', '2026-09-28 08:08:28'),
(5, 'Pengukuran', '', '2026-09-29 12:19:51'),
(6, 'Panel', '', '2026-09-29 12:32:50'),
(7, 'Spec', '', '2026-09-29 12:56:13'),
(8, 'Safetyman', '', '2026-09-29 13:18:33'),
(9, 'quality', '', '2026-09-29 13:18:50');

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

--
-- Table structure for table `t_elemen`
--

CREATE TABLE `t_elemen` (
  `id` int(11) NOT NULL,
  `id_dojo` int(11) NOT NULL,
  `judul_elemen` varchar(150) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `t_elemen`
--

INSERT INTO `t_elemen` (`id`, `id_dojo`, `judul_elemen`, `created_at`) VALUES
(19, 3, '1 Menyiapkan Pengoperasian Mesin Barcode Scan', '2026-09-29 07:54:14'),
(20, 3, '2. Melakukan Scanning Komponen dengan Magellan', '2026-09-29 07:54:14'),
(21, 3, '3 Melakukan Scanning Komponen dengan PDT', '2026-09-29 07:54:14'),
(22, 5, '1. K3 dan 5R dilaksanakan', '2026-09-29 12:31:51'),
(23, 5, '2 Persiapan menggunakan alat ukur', '2026-09-29 12:31:51'),
(24, 5, '3 Melakukan Pengukuran', '2026-09-29 12:31:51'),
(25, 5, '4 Tindak lanjut pengukuran', '2026-09-29 12:31:51'),
(26, 6, '1. Menyiapkan pengoperasian panel', '2026-09-29 12:55:21'),
(27, 6, '2 Menyiapkan start up Panel Control', '2026-09-29 12:55:21'),
(28, 6, '3 Mengendalikan operasi panel control', '2026-09-29 12:55:21'),
(29, 6, '4 Melaksanakan shutdown panel control', '2026-09-29 12:55:21'),
(30, 6, '5 Mengendalikan bahaya', '2026-09-29 12:55:21'),
(31, 7, '1 Menggunakan APD sesuai prosedur', '2026-09-29 13:17:56'),
(32, 7, '2 Mengidentifikasi dan mengakses dokumen spesifikasi', '2026-09-29 13:17:56'),
(33, 7, '3 Menginterpretasi / membaca dokumen spesifikasi', '2026-09-29 13:17:56'),
(34, 7, '4 Hasil identifikasi dilaporkan sesuai prosedur', '2026-09-29 13:17:56');

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

--
-- Table structure for table `t_kompetensi`
--

CREATE TABLE `t_kompetensi` (
  `id` int(11) NOT NULL,
  `id_elemen` int(11) NOT NULL,
  `sub_judul` varchar(150) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `t_kompetensi`
--

INSERT INTO `t_kompetensi` (`id`, `id_elemen`, `sub_judul`, `created_at`) VALUES
(56, 19, '1.1 K3 dan 5R dilaksanakan', '2026-09-29 07:54:14'),
(57, 20, '2.1 Scan ID Karyawan', '2026-09-29 07:54:14'),
(58, 20, '2.2 Scan Kode Barcode Material', '2026-09-29 07:54:14'),
(59, 20, '2.3 Input Quantity', '2026-09-29 07:54:14'),
(60, 20, '2.4 Catat hasil scan pada form aktivitas', '2026-09-29 07:54:14'),
(61, 20, '2.5 Simpan Hasil Scan', '2026-09-29 07:54:14'),
(62, 21, '3.1 Periksa PDT', '2026-09-29 07:54:14'),
(63, 21, '3.2 Scan ID Karyawan', '2026-09-29 07:54:14'),
(64, 21, '3.3 Scan ID Mesin', '2026-09-29 07:54:14'),
(65, 21, '3.4 Scan kode barcode green tire', '2026-09-29 07:54:14'),
(66, 22, '1.1 Menggunakan APD yang sesuai (topi, dan safety shoes)', '2026-09-29 12:31:51'),
(67, 23, '2.1 Memulai praktik', '2026-09-29 12:31:51'),
(68, 23, '2.2 Cek fisik alat ukur', '2026-09-29 12:31:51'),
(69, 23, '2.3 Memposisikan objek ukur', '2026-09-29 12:31:51'),
(70, 24, '3.1 Mengukur benda', '2026-09-29 12:31:51'),
(71, 25, '4.1 Catat hasil pengukuran pada form aktivitas', '2026-09-29 12:31:51'),
(72, 25, '4.2 Beri kesimpulan hasil pengukuran', '2026-09-29 12:31:51'),
(73, 25, '4.3 Mengakhiri praktek', '2026-09-29 12:31:51'),
(74, 26, '1.1 K3 dan 5R dilaksanakan', '2026-09-29 12:55:21'),
(75, 27, '2.1 Dokumen kerja disiapkan kelengkapannya', '2026-09-29 12:55:21'),
(76, 27, '2.2 Sistem interlock diperiksa', '2026-09-29 12:55:21'),
(77, 27, '2.3 Panel control dipastikan ready to start', '2026-09-29 12:55:21'),
(78, 28, '3.1 Start up dilakukan sesuai instruksi kerja', '2026-09-29 12:55:21'),
(79, 28, '3.2 Kondisi operasi', '2026-09-29 12:55:21'),
(80, 28, '3.3 Kondisi operasi dan kendala operasional dicatat dalam log sheet dan logb book', '2026-09-29 12:55:21'),
(81, 28, '3.4 Dampak pengaturan/pengoperasian panel control', '2026-09-29 12:55:21'),
(82, 29, '4.1 Shutdown panel control', '2026-09-29 12:55:21'),
(83, 29, '4.2 Pengamanan panel control', '2026-09-29 12:55:21'),
(84, 29, '4.3 Work permit dipastikan ada', '2026-09-29 12:55:21'),
(85, 30, '5.1 Bahaya di panel control diidentifikasi', '2026-09-29 12:55:21'),
(86, 30, '5.2 Penanganan bahaya', '2026-09-29 12:55:21'),
(87, 31, '1.1 Menggunakan topi sesuai prosedur', '2026-09-29 13:17:56'),
(88, 31, '1.2 Menggunakan sepatu safety sesuai prosedur', '2026-09-29 13:17:56'),
(89, 32, '2.1 Dokumen spesifikasi sesuai kebutuhan diidentifikasi', '2026-09-29 13:17:56'),
(90, 32, '2.2 Dokumen spesifikasi diverifikasi sesuai prosedur', '2026-09-29 13:17:56'),
(91, 32, '2.3 Dokumen spesifikasi diletakkan di area proses sesuai prosedur', '2026-09-29 13:17:56'),
(92, 33, '3.1 Persyaratan material sesuai kebutuhan diidentifikasi dan diinterpretasi', '2026-09-29 13:17:56'),
(93, 33, '3.2 Persyaratan proses sesuai kebutuhan diidentifikasi dan diinterpretasi', '2026-09-29 13:17:56'),
(94, 33, '3.3 Persyaratan output/produk sesuai standar didentifikasi dan diinterprasu', '2026-09-29 13:17:56'),
(95, 34, '4.1 Persyaratan material dilaporkan', '2026-09-29 13:17:56'),
(96, 34, '4.2 Persyaratan proses dilaporkan', '2026-09-29 13:17:56'),
(97, 34, '4.3 Persyaratan output dilaporkan', '2026-09-29 13:17:56'),
(98, 34, '4.4 Checksheet disimpan sesuai prosedur', '2026-09-29 13:17:56');

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

--
-- Table structure for table `t_penilaian`
--

CREATE TABLE `t_penilaian` (
  `id` int(11) NOT NULL,
  `id_peserta` int(11) NOT NULL,
  `id_dojo` int(11) NOT NULL,
  `id_asesor` int(11) DEFAULT NULL,
  `status_kelulusan` enum('KOMPETEN','TIDAK KOMPETEN') NOT NULL,
  `catatan` text DEFAULT NULL,
  `tanggal` datetime DEFAULT current_timestamp(),
  `waktu_mulai` datetime DEFAULT NULL,
  `waktu_selesai` datetime DEFAULT NULL,
  `durasi_detik` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `t_penilaian_detail`
--

CREATE TABLE `t_penilaian_detail` (
  `id` int(11) NOT NULL,
  `id_penilaian` int(11) NOT NULL,
  `id_pertanyaan` int(11) NOT NULL,
  `jawaban` tinyint(1) NOT NULL COMMENT '1 = Ya, 0 = Tidak'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `t_pertanyaan`
--

CREATE TABLE `t_pertanyaan` (
  `id` int(11) NOT NULL,
  `id_kompetensi` int(11) NOT NULL,
  `teks_pertanyaan` text NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `t_pertanyaan`
--

INSERT INTO `t_pertanyaan` (`id`, `id_kompetensi`, `teks_pertanyaan`, `created_at`) VALUES
(181, 56, '1.1.1 Menggunakan APD yang sesuai (Topi, dan Safety Shoes)', '2026-09-29 07:54:14'),
(182, 56, '1.1.2 Mempersiapkan peralatan yang digunakan untuk melakukan barcode scanning', '2026-09-29 07:54:14'),
(183, 57, '2.1.1 Memulai praktek dengan me-release tombol emergency', '2026-09-29 07:54:14'),
(184, 57, '2.1.2 Mesin Magellan berbunyi \"Bip\"', '2026-09-29 07:54:14'),
(185, 57, '2.1.3 Nomer ID Card muncul pada layar', '2026-09-29 07:54:14'),
(186, 58, '2.2.1 Kode barcode menghadap magellan', '2026-09-29 07:54:14'),
(187, 58, '2.2.2 Mesin magellan berbunyi \"Bip\"', '2026-09-29 07:54:14'),
(188, 58, '2.2.3 Nomer ID Card Muncul Pada Layar', '2026-09-29 07:54:14'),
(189, 59, '2.3.1 Masukan jumlah quantity pada layar', '2026-09-29 07:54:14'),
(190, 59, '2.3.2 Sesuai jumlah pada kode barcode', '2026-09-29 07:54:14'),
(191, 60, '2.4.1 Catat nomer id card yang muncul pada layar', '2026-09-29 07:54:14'),
(192, 60, '2.4.2 Catat nomer kode material yang muncul pada layar', '2026-09-29 07:54:14'),
(193, 60, '2.4.3 Catat jumlah quantity sesuai pada layar', '2026-09-29 07:54:14'),
(194, 61, '2.5.1 Pilih tombol simpan', '2026-09-29 07:54:14'),
(195, 61, '2.5.2 Data berhasil disimpan', '2026-09-29 07:54:14'),
(196, 62, '3.1.1 Ambil PDT', '2026-09-29 07:54:14'),
(197, 62, '3.1.2 Baterai PDT terisi', '2026-09-29 07:54:14'),
(198, 62, '3.1.3 PDT terhubung ke jaringan wifi', '2026-09-29 07:54:14'),
(199, 63, '3.2.1 Arahkan bagian PDT ke kode barcode ID Card', '2026-09-29 07:54:14'),
(200, 63, '3.2.2 Tekan tombol kuning, lampu senter menyala', '2026-09-29 07:54:14'),
(201, 63, '3.2.3 PDT berbunyi BIP', '2026-09-29 07:54:14'),
(202, 63, '3.2.4 Nomer ID Karyawan muncul pada layar', '2026-09-29 07:54:14'),
(203, 64, '3.3.1 Arahkan bagian PDT ke kode barcode ID Mesin', '2026-09-29 07:54:14'),
(204, 64, '3.3.2 Tekan tombol kuning, lampu senter menyala', '2026-09-29 07:54:14'),
(205, 64, '3.3.3 PDT berbunyi BIP', '2026-09-29 07:54:14'),
(206, 64, '3.3.4 Nomer ID Mesin muncul pada layar', '2026-09-29 07:54:14'),
(207, 64, '3.3.5 Catat ID Mesin yang muncul pada form', '2026-09-29 07:54:14'),
(208, 65, '3.4.1 Arahkan bagian PDT ke kode barcode green tire', '2026-09-29 07:54:14'),
(209, 65, '3.4.2 Tekan tombol kuning, lampu senter menyala', '2026-09-29 07:54:14'),
(210, 65, '3.4.3 PDT berbunyi BIP', '2026-09-29 07:54:14'),
(211, 65, '3.4.4 Nomer barcode green tire muncul pada layar', '2026-09-29 07:54:14'),
(212, 65, '3.4.5 Catat ID Mesin yang muncul pada form', '2026-09-29 07:54:14'),
(213, 65, '3.4.6 Membaca komitmen dojo', '2026-09-29 07:54:14'),
(214, 65, '3.4.7 Mengakhir dojo dengan menekan tombol emergency', '2026-09-29 07:54:14'),
(215, 66, '1.1.1 Lidah topi menghadap ke depan', '2026-09-29 12:31:51'),
(216, 66, '1.1.2 Semua bagian kaki (jari hingga tumit) masuk ke dalam safety', '2026-09-29 12:31:51'),
(217, 67, '2.1.1  Memulai praktik dengan me-release tombol emergency', '2026-09-29 12:31:51'),
(218, 68, '2.2.1 Ambil steel roll meter dari penyimpanan', '2026-09-29 12:31:51'),
(219, 68, '2.2.2 Cek bagian plat stainless steel roll meter', '2026-09-29 12:31:51'),
(220, 68, '2.2.3 Cek bagian pita steel roll meter', '2026-09-29 12:31:51'),
(221, 68, '2.2.4 Cek bagian skala steel roll meter', '2026-09-29 12:31:51'),
(222, 68, '2.2.5 Cek bagian pengunci steel roll meter', '2026-09-29 12:31:51'),
(223, 68, '2.2.6 Cek bagian case steel roll meter', '2026-09-29 12:31:51'),
(224, 68, '2.2.7 Cek tanggal kalibrasi alat ukur', '2026-09-29 12:31:51'),
(225, 69, '2.3.1 Posisikan benda pada bidang datar', '2026-09-29 12:31:51'),
(226, 70, '3.1.1 Ukur panjang benda', '2026-09-29 12:31:51'),
(227, 70, '3.1.2 Ukur lebar benda', '2026-09-29 12:31:51'),
(228, 70, '3.1.3 Ukur tinggi benda', '2026-09-29 12:31:51'),
(229, 71, '4.1.1 Catat hasil ukur panjang pada kolom aktual panjang', '2026-09-29 12:31:51'),
(230, 71, '4.1.2 Catat hasil ukur lebar pada kolom aktual panjang', '2026-09-29 12:31:51'),
(231, 71, '4.1.3 Catat hasil ukur tinggi pada kolom aktual panjang', '2026-09-29 12:31:51'),
(232, 72, '4.2.1 Ceklis kolom OK apabila hasil ukur sesuai pada spec', '2026-09-29 12:31:51'),
(233, 72, '4.2.2 Ceklis kolom NG apabila hasil ukur sesuai pada spec', '2026-09-29 12:31:51'),
(234, 73, '4.3.1 Membaca komitmen Dojo', '2026-09-29 12:31:51'),
(235, 73, '4.3.2 Mengakhiri dojo dengan menekan tombol emergency', '2026-09-29 12:31:51'),
(236, 74, '1.1.1 Menggunakan APD yang sesuai (topi dan safety shoes)', '2026-09-29 12:55:21'),
(237, 74, '1.1.2 Menyiapkan peralatan yang digunakan untuk mengoperasikan panel', '2026-09-29 12:55:21'),
(238, 75, '2.1.1 Mulai (Tekan dan release Emergency Stop)', '2026-09-29 12:55:21'),
(239, 75, '2.1.2 Baca dojo statement', '2026-09-29 12:55:21'),
(240, 75, '2.1.3 Siapkan spek manual', '2026-09-29 12:55:21'),
(241, 75, '2.1.4 Siapkan IKL mode manual', '2026-09-29 12:55:21'),
(242, 75, '2.1.5 Siapkan laporan hasil pengoperasian panel kontrol', '2026-09-29 12:55:21'),
(243, 75, '2.1.6 Siapkan laporan untuk atasan atau dampak proses', '2026-09-29 12:55:21'),
(244, 75, '2.1.7 Siapkan form EJO', '2026-09-29 12:55:21'),
(245, 75, '2.1.8 Siapkan alat tulis', '2026-09-29 12:55:21'),
(246, 76, '2.2.1 Check lampu indikator power suply panel (jika hidup berarti oke)', '2026-09-29 12:55:21'),
(247, 76, '2.2.2 Check lampu indikator emergency stop (jika mati berarti oke)', '2026-09-29 12:55:21'),
(248, 77, '2.3.1 Check lampu indikator ready (jika hidup berarti oke)', '2026-09-29 12:55:21'),
(249, 77, '2.3.2  Check dan pastikan selector switch pada mode manual', '2026-09-29 12:55:21'),
(250, 78, '3.1.1 Tekan tombol start 1', '2026-09-29 12:55:21'),
(251, 78, '3.1.2 Tekan tombol start 2', '2026-09-29 12:55:21'),
(252, 78, '3.1.3 Tekan tombol start 3', '2026-09-29 12:55:21'),
(253, 78, '3.1.4 Tekan tombol start 4', '2026-09-29 12:55:21'),
(254, 79, '3.2.1 Cek kondisi lampu indikator lampu 1,2,3 dan 4 apakah sesuai spek dan standart', '2026-09-29 12:55:21'),
(255, 80, '3.3.1 Tulis hasil cek pada form laporan hasil pengoperasian panel', '2026-09-29 12:55:21'),
(256, 81, '3.4.1 isi form laporan ke atasan/dampak operasi', '2026-09-29 12:55:21'),
(257, 82, '4.1.1 Tekan tombol stop 1', '2026-09-29 12:55:21'),
(258, 82, '4.1.2 Tekan tombol stop 2', '2026-09-29 12:55:21'),
(259, 82, '4.1.3 Tekan tombol stop 3', '2026-09-29 12:55:21'),
(260, 82, '4.1.4 Tekan tombol stop 4', '2026-09-29 12:55:21'),
(261, 83, '4.2.1 Tekan tombol emergency stop', '2026-09-29 12:55:21'),
(262, 83, '4.2.2 Tekan dan release emergency stop', '2026-09-29 12:55:21'),
(263, 83, '4.2.3 Tekan tombol ready hingga lampu indikator mati', '2026-09-29 12:55:21'),
(264, 84, '4.3.1 Pastikan status EJO', '2026-09-29 12:55:21'),
(265, 85, '5.1.1 Tunjukan dan pastikan tidak ada barang di atas panel dan di dalam panel', '2026-09-29 12:55:21'),
(266, 86, '5.2.1 Tunjukan apar untuk penanggulangan', '2026-09-29 12:55:21'),
(267, 86, '5.2.2 Mengakhiri dojo dengan menekan tombol emergency', '2026-09-29 12:55:21'),
(268, 87, '1.1.1 Lidah topi menghadap kedepan', '2026-09-29 13:17:56'),
(269, 88, '1.2.1 Semua bagian kaki masuk kedalam safety shoes', '2026-09-29 13:17:56'),
(270, 89, '2.1.1 Dokumen spec sesuai schedule diambil dari tempat penyimpanan', '2026-09-29 13:17:56'),
(271, 90, '2.2.1 Nomor pengendalian dokumen dipastikan terupdate', '2026-09-29 13:17:56'),
(272, 91, '2.3.1 Dokumen spec diletakkan sesuai layout', '2026-09-29 13:17:56'),
(273, 92, '3.1.1 Jenis material yang dibutuhkan disebutkan', '2026-09-29 13:17:56'),
(274, 92, '3.1.2 Parameter material disebutkan', '2026-09-29 13:17:56'),
(275, 92, '3.1.3 Kriteria material OK disebutkan', '2026-09-29 13:17:56'),
(276, 93, '3.2.1 Item proses yang dibutuhkan disebutkan', '2026-09-29 13:17:56'),
(277, 93, '3.2.2 Parameter proses disebutkan', '2026-09-29 13:17:56'),
(278, 93, '3.2.3 Kriteria proses OK disebutkan', '2026-09-29 13:17:56'),
(279, 94, '3.3.1 Kriteria produk OK Disebutkan', '2026-09-29 13:17:56'),
(280, 95, '4.1.1 Jenis material sesuai spec dilaporkan di checksheet', '2026-09-29 13:17:56'),
(281, 95, '4.1.2 Parameter material sesuai spec dilaporkan di checksheet', '2026-09-29 13:17:56'),
(282, 96, '4.2.1  Persyaratan proses dilaporkan di checksheet', '2026-09-29 13:17:56'),
(283, 96, '4.2.2 Parameter proses sesuai spec dilaporkan di checksheet', '2026-09-29 13:17:56'),
(284, 97, '4.3.1  Persyaratan output dilaporkan di checksheet', '2026-09-29 13:17:56'),
(285, 97, '4.3.2 Parameter output sesuai spec dilaporkan di checksheet', '2026-09-29 13:17:56'),
(286, 98, '4.4.1 Checksheet diletakkan sesuai layout', '2026-09-29 13:17:56');

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

--
-- Table structure for table `t_peserta`
--

CREATE TABLE `t_peserta` (
  `id` int(11) NOT NULL,
  `nip` varchar(50) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `batch` varchar(50) DEFAULT 'Batch 1',
  `uid_nfc` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `t_peserta`
--

INSERT INTO `t_peserta` (`id`, `nip`, `nama`, `batch`, `uid_nfc`, `created_at`) VALUES
(9, 'M26-0031', 'Moh Kemal Ainur Ardiansyah', 'Batch 99', 'F6:9B:71:1A', '2026-09-28 14:00:06');

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

--
-- Table structure for table `t_user`
--

CREATE TABLE `t_user` (
  `id` int(11) NOT NULL,
  `nip` varchar(50) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('ADMIN','ASESOR') NOT NULL DEFAULT 'ASESOR',
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `t_user`
--

INSERT INTO `t_user` (`id`, `nip`, `nama`, `password`, `role`, `created_at`) VALUES
(2, 'M26-0031', 'Kemal', '$2y$12$jyMajGZKczp6tO69Sde/tuLfSCPgM0XCO76jcWAiOi/yUNY.08BCO', 'ADMIN', '2026-09-29 07:36:04'),
(3, '00-0001', 'asessor', '$2y$10$bO5RZ75xoyzZ8rz62vODbOyexhXJqoBzvGt1tU6itz7NvQnNsxpjW', 'ASESOR', '2026-09-28 07:25:22');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `t_elemen`
--
ALTER TABLE `t_elemen`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_elemen_dojo` (`id_dojo`);

--
-- Indexes for table `t_kompetensi`
--
ALTER TABLE `t_kompetensi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_kompetensi_elemen` (`id_elemen`);

--
-- Indexes for table `t_penilaian`
--
ALTER TABLE `t_penilaian`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_penilaian_peserta` (`id_peserta`),
  ADD KEY `fk_penilaian_dojo` (`id_dojo`);

--
-- Indexes for table `t_penilaian_detail`
--
ALTER TABLE `t_penilaian_detail`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_detail_penilaian` (`id_penilaian`),
  ADD KEY `fk_detail_pertanyaan` (`id_pertanyaan`);

--
-- Indexes for table `t_pertanyaan`
--
ALTER TABLE `t_pertanyaan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_pertanyaan_kompetensi` (`id_kompetensi`);

--
-- Indexes for table `t_peserta`
--
ALTER TABLE `t_peserta`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nip` (`nip`),
  ADD UNIQUE KEY `uid_nfc` (`uid_nfc`);

--
-- Indexes for table `t_user`
--
ALTER TABLE `t_user`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nip` (`nip`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `t_dojo`
--
ALTER TABLE `t_dojo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `t_elemen`
--
ALTER TABLE `t_elemen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `t_kompetensi`
--
ALTER TABLE `t_kompetensi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=99;

--
-- AUTO_INCREMENT for table `t_penilaian`
--
ALTER TABLE `t_penilaian`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `t_penilaian_detail`
--
ALTER TABLE `t_penilaian_detail`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- AUTO_INCREMENT for table `t_pertanyaan`
--
ALTER TABLE `t_pertanyaan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=287;

--
-- AUTO_INCREMENT for table `t_peserta`
--
ALTER TABLE `t_peserta`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `t_user`
--
ALTER TABLE `t_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `t_elemen`
--
ALTER TABLE `t_elemen`
  ADD CONSTRAINT `fk_elemen_dojo` FOREIGN KEY (`id_dojo`) REFERENCES `t_dojo` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `t_kompetensi`
--
ALTER TABLE `t_kompetensi`
  ADD CONSTRAINT `fk_kompetensi_elemen` FOREIGN KEY (`id_elemen`) REFERENCES `t_elemen` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `t_penilaian`
--
ALTER TABLE `t_penilaian`
  ADD CONSTRAINT `fk_penilaian_dojo` FOREIGN KEY (`id_dojo`) REFERENCES `t_dojo` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_penilaian_peserta` FOREIGN KEY (`id_peserta`) REFERENCES `t_peserta` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `t_penilaian_detail`
--
ALTER TABLE `t_penilaian_detail`
  ADD CONSTRAINT `fk_detail_penilaian` FOREIGN KEY (`id_penilaian`) REFERENCES `t_penilaian` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_detail_pertanyaan` FOREIGN KEY (`id_pertanyaan`) REFERENCES `t_pertanyaan` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `t_pertanyaan`
--
ALTER TABLE `t_pertanyaan`
  ADD CONSTRAINT `fk_pertanyaan_kompetensi` FOREIGN KEY (`id_kompetensi`) REFERENCES `t_kompetensi` (`id`) 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 */;
