-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Aug 03, 2026 at 12:07 PM
-- Server version: 8.0.30
-- PHP Version: 8.1.10

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

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

--
-- Table structure for table `anecdote`
--

CREATE TABLE `anecdote` (
  `id` int NOT NULL,
  `pengirim_tipe` enum('Guru','Perpustakaan','Sistem','Admin') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pengirim_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pengirim_nama` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipe_pesan` enum('Informasi','Peringatan','Tugas','Prestasi') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Informasi',
  `target_jenis` enum('Semua','Perorangan','Kelas') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Semua',
  `target_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isi_pesan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal_kirim` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `status_dibaca` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `anecdote`
--

INSERT INTO `anecdote` (`id`, `pengirim_tipe`, `pengirim_id`, `pengirim_nama`, `tipe_pesan`, `target_jenis`, `target_id`, `isi_pesan`, `tanggal_kirim`, `status_dibaca`) VALUES
(1, 'Guru', '0987654321234567', 'siti anisa', 'Peringatan', 'Perorangan', '1234567890', 'test', '2026-08-01 18:10:46', 0),
(2, 'Guru', '0987654321234567', 'siti anisa', 'Prestasi', 'Perorangan', '1234567890', 'test2', '2026-08-01 19:04:58', 0),
(3, 'Guru', '0987654321234567', 'siti anisa', 'Peringatan', 'Perorangan', '1234567890', 'test3', '2026-08-01 19:48:20', 0),
(4, 'Admin', 'perpus_admin', 'Admin Perpustakaan', 'Informasi', 'Perorangan', '1234567895', '📚 Anda telah meminjam buku dari Perpustakaan. Mohon kembalikan paling lambat tanggal 10/8/2026.', '2026-08-03 09:52:58', 0),
(5, 'Admin', 'perpus', 'Perpustakaan', 'Peringatan', 'Perorangan', '1234567895', '📚 Jangan lupa! Batas pengembalian buku \"test\" adalah 7 hari lagi.', '2026-08-03 09:53:04', 0),
(6, 'Admin', 'perpus_admin', 'Admin Perpustakaan', 'Informasi', 'Perorangan', '1234567890', '📚 Anda telah meminjam buku dari Perpustakaan. Mohon kembalikan paling lambat tanggal 10/8/2026.', '2026-08-03 09:53:13', 0),
(7, 'Admin', 'perpus', 'Perpustakaan', 'Peringatan', 'Perorangan', '1234567890', '📚 Jangan lupa! Batas pengembalian buku \"test\" adalah 7 hari lagi.', '2026-08-03 09:53:16', 0);

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

--
-- Table structure for table `elearning_aktivitas`
--

CREATE TABLE `elearning_aktivitas` (
  `id` int NOT NULL,
  `nuptk_guru` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `tanggal` date DEFAULT NULL,
  `badge` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `warna_icon` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `elearning_balasan_diskusi`
--

CREATE TABLE `elearning_balasan_diskusi` (
  `id` int NOT NULL,
  `id_diskusi` int NOT NULL,
  `isi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pembalas_tipe` enum('Guru','Siswa') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Guru',
  `pembalas_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pembalas_nama` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `waktu` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `elearning_diskusi`
--

CREATE TABLE `elearning_diskusi` (
  `id` int NOT NULL,
  `id_pertemuan` int NOT NULL,
  `judul` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `isi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pembuat_tipe` enum('Guru','Siswa') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Guru',
  `pembuat_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pembuat_nama` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `waktu` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `elearning_jawaban_quiz`
--

CREATE TABLE `elearning_jawaban_quiz` (
  `id` int NOT NULL,
  `id_quiz` int NOT NULL,
  `nis_siswa` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `teks_jawaban` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `file_jawaban_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `waktu_kirim` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `balasan_nilai_guru` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `elearning_modul`
--

CREATE TABLE `elearning_modul` (
  `id` int NOT NULL,
  `id_pertemuan` int NOT NULL,
  `judul` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `elearning_pertemuan`
--

CREATE TABLE `elearning_pertemuan` (
  `id` int NOT NULL,
  `id_aktivitas` int NOT NULL,
  `judul` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `waktu` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `elearning_quiz`
--

CREATE TABLE `elearning_quiz` (
  `id` int NOT NULL,
  `id_pertemuan` int NOT NULL,
  `judul` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tipe` enum('Quiz','Tugas') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Quiz',
  `deskripsi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `soal` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deadline` datetime DEFAULT NULL,
  `file_lampiran_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `elearning_video`
--

CREATE TABLE `elearning_video` (
  `id` int NOT NULL,
  `id_pertemuan` int NOT NULL,
  `judul` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `link_video` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `durasi` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `guru`
--

CREATE TABLE `guru` (
  `nuptk` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_lengkap` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mapel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '-',
  `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '-',
  `jabatan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Tenaga Pendidik',
  `tanggal_bergabung` date DEFAULT NULL,
  `foto_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `guru`
--

INSERT INTO `guru` (`nuptk`, `nama_lengkap`, `mapel`, `email`, `jabatan`, `tanggal_bergabung`, `foto_url`, `created_at`) VALUES
('0987654321234560', 'bagas subianto', 'mewarnai', 'sud@gmail.com', 'Tenaga Pendidik', '2026-01-01', '', '2026-08-03 08:43:28'),
('0987654321234567', 'siti anisa', 'indonesia', 'siti@gmail.com', 'Tenaga Pendidik', NULL, NULL, '2026-07-31 03:44:11'),
('1234567890654321', 'asep surasep', '', 'asep@gmail.com', 'Tenaga Pendidik', '2026-08-03', '', '2026-08-03 08:56:21'),
('9039761662230303', 'Dina Nurzanah Sari', 'mewarnai', 'deechanstore', 'Tenaga Pendidik', '2026-08-03', '', '2026-08-03 05:17:01');

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

--
-- Table structure for table `info_berita`
--

CREATE TABLE `info_berita` (
  `id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `judul` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `konten` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `gambar_url` longtext COLLATE utf8mb4_unicode_ci,
  `tanggal` date DEFAULT NULL,
  `status` enum('Published','Draft') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Draft',
  `link_luar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `teks_tombol_link` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jumlah_dilihat` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `info_galeri_album`
--

CREATE TABLE `info_galeri_album` (
  `id` int NOT NULL,
  `judul` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kategori` enum('Kegiatan','Fasilitas','Prestasi') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Kegiatan',
  `deskripsi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `tanggal_dibuat` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `info_galeri_item`
--

CREATE TABLE `info_galeri_item` (
  `id` int NOT NULL,
  `id_album` int NOT NULL,
  `tipe` enum('image','video') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'image',
  `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `info_kontak`
--

CREATE TABLE `info_kontak` (
  `id` int NOT NULL DEFAULT '1',
  `alamat` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `telepon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jam_operasional` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `info_kontak`
--

INSERT INTO `info_kontak` (`id`, `alamat`, `telepon`, `email`, `jam_operasional`, `updated_at`) VALUES
(1, 'Jl. Pendidikan No. 123, Kota', '081234567890', 'info@jisc.com', 'Senin-Jumat: 07:00 - 16:00', '2026-08-01 13:35:51');

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

--
-- Table structure for table `info_pesan`
--

CREATE TABLE `info_pesan` (
  `id` int NOT NULL,
  `nama` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pesan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('Baru','Dibaca') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Baru',
  `tanggal` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `info_profil`
--

CREATE TABLE `info_profil` (
  `id` int NOT NULL DEFAULT '1',
  `sejarah` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `gambar_sejarah` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `visi` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `misi` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `npsn` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun_berdiri` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `akreditasi` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nilai_akreditasi` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_sekolah` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `info_profil`
--

INSERT INTO `info_profil` (`id`, `sejarah`, `gambar_sejarah`, `visi`, `misi`, `npsn`, `tahun_berdiri`, `akreditasi`, `nilai_akreditasi`, `status_sekolah`, `updated_at`) VALUES
(1, 'Sejarah sekolah JISC...', NULL, 'Visi sekolah JISC...', 'Misi sekolah JISC...', '12345678', '2000', 'A', '95', 'Swasta', '2026-08-01 13:35:51');

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

--
-- Table structure for table `info_slider`
--

CREATE TABLE `info_slider` (
  `id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `judul` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deskripsi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gambar_url` longtext COLLATE utf8mb4_unicode_ci,
  `urutan` int DEFAULT '0',
  `status` enum('aktif','nonaktif') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'aktif',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `info_sosmed`
--

CREATE TABLE `info_sosmed` (
  `id` int NOT NULL,
  `platform` enum('facebook','instagram','youtube','twitter') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `inventaris_barang`
--

CREATE TABLE `inventaris_barang` (
  `id` int NOT NULL,
  `id_ruangan` int NOT NULL,
  `kode_barang` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_barang` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kondisi` enum('Baik','Rusak Ringan','Rusak Berat') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Baik',
  `harga` decimal(15,2) DEFAULT '0.00',
  `tahun_perolehan` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jadwal_mengajar`
--

CREATE TABLE `jadwal_mengajar` (
  `id` int NOT NULL,
  `nuptk_guru` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_kelas` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `hari` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `jam` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mapel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ruang` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun_ajaran` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '2024/2025',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jadwal_mengajar`
--

INSERT INTO `jadwal_mengajar` (`id`, `nuptk_guru`, `id_kelas`, `hari`, `jam`, `mapel`, `ruang`, `tahun_ajaran`, `created_at`) VALUES
(1, '0987654321234567', 'KLS_1785489957668', 'Monday', '07:30-09:50', 'indonesia', '', '2024/2025', '2026-08-03 05:12:06'),
(2, '9039761662230303', 'KLS_1785745397762', 'Tuesday', '07:30-09:59', 'mewarnai', '', '2024/2025', '2026-08-03 08:25:50');

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

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

CREATE TABLE `kelas` (
  `id_kelas` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_kelas` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tingkat` enum('Nursery','TK A','TK B','K1','K2','K3') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'TK A',
  `nuptk_wali_kelas` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun_ajaran` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '2024/2025',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `kelas` (`id_kelas`, `nama_kelas`, `tingkat`, `nuptk_wali_kelas`, `tahun_ajaran`, `created_at`) VALUES
('KLS_1785489957668', 'K1A', 'TK A', '0987654321234567', '2024/2025', '2026-07-31 09:25:57'),
('KLS_1785745397762', 'K1B', 'TK A', '9039761662230303', '2024/2025', '2026-08-03 08:23:17'),
('KLS_1785749612912', 'NURSERY', 'TK A', '0987654321234560', '2024/2025', '2026-08-03 09:33:32');

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

--
-- Table structure for table `laporan_kerusakan`
--

CREATE TABLE `laporan_kerusakan` (
  `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_pelapor` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jabatan_pelapor` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telp_pelapor` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_pelapor` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_barang` int DEFAULT NULL,
  `nama_barang` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_barang` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ruangan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deskripsi_kerusakan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` enum('pending','proses','selesai','ditolak') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `catatan_admin` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `tanggal_lapor` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `laporan_kerusakan`
--

INSERT INTO `laporan_kerusakan` (`id`, `nama_pelapor`, `jabatan_pelapor`, `telp_pelapor`, `email_pelapor`, `id_barang`, `nama_barang`, `kode_barang`, `ruangan`, `deskripsi_kerusakan`, `status`, `catatan_admin`, `tanggal_lapor`, `created_at`) VALUES
('LPR_1785750257150', 'siti anisa', 'Guru', '24798149816', 'siti@gmail.com', NULL, 'printer', '001', 'Perpustakaan', 'test', 'pending', NULL, '2026-08-03', '2026-08-03 09:44:17');

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

--
-- Table structure for table `perpus_buku`
--

CREATE TABLE `perpus_buku` (
  `kode_buku` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `judul` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kategori` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `penerbit` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sinopsis` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `stok_total` int DEFAULT '1',
  `stok_tersedia` int DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `perpus_buku`
--

INSERT INTO `perpus_buku` (`kode_buku`, `judul`, `kategori`, `penerbit`, `sinopsis`, `stok_total`, `stok_tersedia`, `created_at`) VALUES
('012', 'test', 'Cerita Rakyat', 'vsdv', 'test', 12, 10, '2026-08-03 08:59:04');

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

--
-- Table structure for table `perpus_peminjaman`
--

CREATE TABLE `perpus_peminjaman` (
  `id_transaksi` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nis_siswa` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_buku` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_pinjam` date DEFAULT NULL,
  `batas_kembali` date DEFAULT NULL,
  `tanggal_kembali` date DEFAULT NULL,
  `status` enum('dipinjam','terlambat','dikembalikan') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'dipinjam',
  `denda` int DEFAULT '0',
  `kondisi_saat_kembali` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `perpus_peminjaman`
--

INSERT INTO `perpus_peminjaman` (`id_transaksi`, `nis_siswa`, `kode_buku`, `tanggal_pinjam`, `batas_kembali`, `tanggal_kembali`, `status`, `denda`, `kondisi_saat_kembali`, `created_at`) VALUES
('TRX-1785750778555', '1234567895', '012', '2026-08-03', '2026-08-10', NULL, 'dipinjam', 0, NULL, '2026-08-03 09:52:58'),
('TRX-1785750793320', '1234567890', '012', '2026-08-03', '2026-08-10', NULL, 'dipinjam', 0, NULL, '2026-08-03 09:53:13');

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

--
-- Table structure for table `perpus_pengaturan`
--

CREATE TABLE `perpus_pengaturan` (
  `id` int NOT NULL DEFAULT '1',
  `denda_per_hari` int DEFAULT '1000',
  `maks_pinjam` int DEFAULT '3'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `perpus_pengaturan`
--

INSERT INTO `perpus_pengaturan` (`id`, `denda_per_hari`, `maks_pinjam`) VALUES
(1, 1000, 3);

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

--
-- Table structure for table `prestasi`
--

CREATE TABLE `prestasi` (
  `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kategori` enum('Siswa','Guru','Sekolah') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Siswa',
  `id_penerima` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_penerima` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kegiatan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `penghargaan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tingkat` enum('Sekolah','Kecamatan','Kota','Provinsi','Nasional','Internasional') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal` date DEFAULT NULL,
  `file_bukti_url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `psb_pendaftar`
--

CREATE TABLE `psb_pendaftar` (
  `id` int NOT NULL,
  `nama_anak` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `level` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_lahir` date DEFAULT NULL,
  `jenis_kelamin` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sekolah_asal` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_ortu` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `telepon` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sumber_info` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('pending','interview','approved','rejected') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `file_bukti_bayar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_akta_lahir` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_kk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_ktp_ortu` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_form_wawancara` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_foto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `psb_settings`
--

CREATE TABLE `psb_settings` (
  `id` int NOT NULL DEFAULT '1',
  `nomor_wa_admin` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `template_pesan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `psb_settings`
--

INSERT INTO `psb_settings` (`id`, `nomor_wa_admin`, `template_pesan`, `updated_at`) VALUES
(1, '6281234567890', 'Assalamu\'alaikum {nama}...', '2026-08-01 13:35:51');

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

--
-- Table structure for table `psb_wa_log`
--

CREATE TABLE `psb_wa_log` (
  `id` int NOT NULL,
  `id_pendaftar` int DEFAULT NULL,
  `jenis_aksi` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nomor_tujuan` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isi_pesan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `waktu_kirim` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `raport_arsip_pdf`
--

CREATE TABLE `raport_arsip_pdf` (
  `id` int NOT NULL,
  `nis_siswa` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `semester` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun_ajaran` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_file` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal_upload` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `raport_isi`
--

CREATE TABLE `raport_isi` (
  `id` int NOT NULL,
  `nis_siswa` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nuptk_guru` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_template` int NOT NULL,
  `semester` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun_ajaran` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data_isian` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `tanggal_isi` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `raport_isi`
--

INSERT INTO `raport_isi` (`id`, `nis_siswa`, `nuptk_guru`, `id_template`, `semester`, `tahun_ajaran`, `data_isian`, `tanggal_isi`) VALUES
(1, '1234567890', '0987654321234567', 2, 'I', '2025 / 2026', '{\"htmlContent\":\"\\n\\n    <!-- ================= BAR PENGATURAN ================= -->\\n    <div class=\\\"control-bar\\\" style=\\\"display: none;\\\">\\n        <div class=\\\"control-info\\\">\\n            <b>\\u2728 EDIT MANUAL DI WEB:<\\/b> Klik teks apa saja untuk langsung mengetik.<br>\\n            <b>\\u2714\\ufe0f CENTANG NILAI:<\\/b> Klik kotak kosong untuk memberi tanda centang (\\u2713).\\n        <\\/div>\\n        <button class=\\\"btn-save\\\" onclick=\\\"saveAndClose()\\\">\\ud83d\\udcbe Save &amp; Tutup<\\/button>\\n    <\\/div>\\n\\n    <!-- ================= HALAMAN 1 ================= -->\\n    <div class=\\\"page-sheet\\\">\\n        <div class=\\\"header-box\\\">\\n            <h1 contenteditable=\\\"false\\\">KINDERGARTEN<br>JAKARTA ISLAMIC SCHOOL (JISc)<br>TEMPORARY REPORT<\\/h1>\\n        <\\/div>\\n\\n        <div class=\\\"student-info\\\">\\n            <div class=\\\"info-col\\\">\\n                <div class=\\\"info-row\\\"><span class=\\\"info-label\\\">Student\'s Name<\\/span><span class=\\\"info-sep\\\">:<\\/span><span contenteditable=\\\"true\\\" id=\\\"studentName\\\">eko setiawan<\\/span><\\/div>\\n                <div class=\\\"info-row\\\"><span class=\\\"info-label\\\">Class<\\/span><span class=\\\"info-sep\\\">:<\\/span><span contenteditable=\\\"true\\\" id=\\\"studentClass\\\">K2B (Al Kahfi)<\\/span><\\/div>\\n            <\\/div>\\n            <div class=\\\"info-col\\\">\\n                <div class=\\\"info-row\\\"><span class=\\\"info-label\\\">Term<\\/span><span class=\\\"info-sep\\\">:<\\/span><span contenteditable=\\\"true\\\" id=\\\"studentTerm\\\">I<\\/span><\\/div>\\n                <div class=\\\"info-row\\\"><span class=\\\"info-label\\\">Year<\\/span><span class=\\\"info-sep\\\">:<\\/span><span contenteditable=\\\"true\\\" id=\\\"studentYear\\\">2025 \\/ 2026<\\/span><\\/div>\\n            <\\/div>\\n        <\\/div>\\n        <div class=\\\"divider-thick\\\"><\\/div>\\n\\n        <div class=\\\"section-title\\\" contenteditable=\\\"false\\\">ISLAMIC STUDIES CURRICULUM<\\/div>\\n        <table class=\\\"custom-table\\\">\\n            <thead>\\n                <tr>\\n                    <th class=\\\"col-no\\\">NO<\\/th>\\n                    <th>SUBJECT<\\/th>\\n                    <th>E<\\/th>\\n                    <th>G<\\/th>\\n                    <th>D<\\/th>\\n                    <th>NI<\\/th>\\n                <\\/tr>\\n            <\\/thead>\\n            <tbody>\\n                <tr class=\\\"row-header\\\"><td class=\\\"col-no\\\">1<\\/td><td colspan=\\\"5\\\" contenteditable=\\\"false\\\">SPIRITUAL<\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Reciting basmallah before doing something<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Reciting hamdallah after doing something<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Khusyuk when reciting du\'a<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Knowing \\\"20 sifat Allah\\\"<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n\\n                <tr class=\\\"row-header\\\"><td class=\\\"col-no\\\">2<\\/td><td colspan=\\\"5\\\" contenteditable=\\\"false\\\">SHOLAT<\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Du\'a after wudhu<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Du\'a iftitah<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n\\n                <tr class=\\\"row-header\\\"><td class=\\\"col-no\\\">3<\\/td><td colspan=\\\"5\\\" contenteditable=\\\"false\\\">DUA<\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">For healthy with meaning<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">After studying<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n\\n                <tr class=\\\"row-header\\\"><td class=\\\"col-no\\\">4<\\/td><td colspan=\\\"5\\\" contenteditable=\\\"false\\\">HADIST<\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Menutup aurat<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Pekerjaan rapih<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Salam<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n\\n                <tr class=\\\"row-header\\\"><td class=\\\"col-no\\\">5<\\/td><td colspan=\\\"5\\\" contenteditable=\\\"false\\\">TAHSIN<\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Writing<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Imla harakat fathah, kasrah, and dhumah<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Reading<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n\\n                <tr class=\\\"row-header\\\"><td class=\\\"col-no\\\">6<\\/td><td colspan=\\\"5\\\" contenteditable=\\\"false\\\">ARABIC<\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Vocabularies<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Conversations<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n\\n                <tr class=\\\"row-header\\\"><td class=\\\"col-no\\\">7<\\/td><td colspan=\\\"5\\\" contenteditable=\\\"false\\\">SIROH<\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Prophet Syuaib as, Prophet Musa as, Prophet Harun as, Zaid bin Haritsah and Bilal bin Rabbah<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n            <\\/tbody>\\n        <\\/table>\\n\\n        <div class=\\\"section-title\\\" style=\\\"margin-top: 10px;\\\" contenteditable=\\\"false\\\">TAHFIDZ<\\/div>\\n        <table class=\\\"tahfidz-table\\\">\\n            <thead>\\n                <tr>\\n                    <th style=\\\"width: 35px;\\\">No<\\/th>\\n                    <th>Name of Surah<\\/th>\\n                    <th style=\\\"width: 95px;\\\">Mumtaz<br>(Excellent)<\\/th>\\n                    <th style=\\\"width: 95px;\\\">Jayyid Jiddan<br>(Good)<\\/th>\\n                    <th style=\\\"width: 95px;\\\">Jayyid<br>(Developing)<\\/th>\\n                    <th style=\\\"width: 95px;\\\">Maqbul<br>(Need Improvement)<\\/th>\\n                <\\/tr>\\n            <\\/thead>\\n            <tbody>\\n                <tr><td contenteditable=\\\"false\\\">1<\\/td><td contenteditable=\\\"false\\\">Qs Al Zalzalah<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td contenteditable=\\\"false\\\">2<\\/td><td contenteditable=\\\"false\\\">Qs Al Bayyinah<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td contenteditable=\\\"false\\\">3<\\/td><td contenteditable=\\\"false\\\">Qs Al Qadr<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n            <\\/tbody>\\n        <\\/table>\\n    <\\/div>\\n\\n    <!-- ================= HALAMAN 2 ================= -->\\n    <div class=\\\"page-sheet\\\">\\n        <div class=\\\"section-title\\\" contenteditable=\\\"false\\\">INTERNATIONAL CURRICULUM<\\/div>\\n        <table class=\\\"custom-table\\\">\\n            <thead>\\n                <tr>\\n                    <th class=\\\"col-no\\\">NO<\\/th>\\n                    <th>SUBJECT<\\/th>\\n                    <th>E<\\/th>\\n                    <th>G<\\/th>\\n                    <th>D<\\/th>\\n                    <th>NI<\\/th>\\n                <\\/tr>\\n            <\\/thead>\\n            <tbody>\\n                <tr class=\\\"row-header\\\"><td class=\\\"col-no\\\">1<\\/td><td colspan=\\\"5\\\" contenteditable=\\\"false\\\">ENGLISH<\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Vocabularies<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Conversation<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Listen to and follow two step directions<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n\\n                <tr class=\\\"row-header\\\"><td class=\\\"col-no\\\">2<\\/td><td colspan=\\\"5\\\" contenteditable=\\\"false\\\">MATH<\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Counts by 1\'s to 50<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Pattern<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Number form<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Additional<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Subtraction<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Count to tell the number object<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Sequence numbers 1-30<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n\\n                <tr class=\\\"row-header\\\"><td class=\\\"col-no\\\">3<\\/td><td colspan=\\\"5\\\" contenteditable=\\\"false\\\">SCIENCE<\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Identifying the things are can be attracted by magnet<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Distinguish same and different objects<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Clasifying the things are living things and non-living things<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Clasifying the things are solid and liquid<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n            <\\/tbody>\\n        <\\/table>\\n\\n        <div class=\\\"section-title\\\" style=\\\"margin-top: 12px;\\\" contenteditable=\\\"false\\\">INDONESIAN CURRICULUM<\\/div>\\n        <table class=\\\"custom-table\\\">\\n            <thead>\\n                <tr>\\n                    <th class=\\\"col-no\\\">NO<\\/th>\\n                    <th>SUBJECT<\\/th>\\n                    <th>E<\\/th>\\n                    <th>G<\\/th>\\n                    <th>D<\\/th>\\n                    <th>NI<\\/th>\\n                <\\/tr>\\n            <\\/thead>\\n            <tbody>\\n                <tr class=\\\"row-header\\\"><td class=\\\"col-no\\\">1<\\/td><td colspan=\\\"5\\\" contenteditable=\\\"false\\\">Language Development<\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Communicates information verbally and in writing<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Follow multi-step directions<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Writing simple sentences<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Dictation<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Poem<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n\\n                <tr class=\\\"row-header\\\"><td class=\\\"col-no\\\">2<\\/td><td colspan=\\\"5\\\" contenteditable=\\\"false\\\">Social Emotional Development<\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Shows self-control<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Plays well with others<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Cares for properly<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Participates in a group activities<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n\\n                <tr class=\\\"row-header\\\"><td class=\\\"col-no\\\">3<\\/td><td colspan=\\\"5\\\" contenteditable=\\\"false\\\">Art\\/Music\\/Physical Development<\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Shows small muscle control (colouring, collage, cutting and folding )<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Shows large muscle control<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">a.Jumping with one leg<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">b.Jumping with two legs<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">c.Crawling<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Moves Rhythmically to music<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n\\n                <tr class=\\\"row-header\\\"><td class=\\\"col-no\\\">4<\\/td><td colspan=\\\"5\\\" contenteditable=\\\"false\\\">Character Development<\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Completes works on time<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Follow instructions<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Follow classroom routines<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Works well independently<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Takes responsibility for own actions<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Respects others<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n                <tr><td><\\/td><td class=\\\"sub-item\\\" contenteditable=\\\"false\\\">Discipline<\\/td><td class=\\\"check-cell\\\">\\u2713<\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><td class=\\\"check-cell\\\"><\\/td><\\/tr>\\n            <\\/tbody>\\n        <\\/table>\\n    <\\/div>\\n\\n    <!-- ================= HALAMAN 3 ================= -->\\n    <div class=\\\"page-sheet\\\">\\n        <div class=\\\"grid-2col\\\">\\n            <div class=\\\"prog-box\\\">\\n                <div class=\\\"prog-title\\\" contenteditable=\\\"false\\\">Reading Program<\\/div>\\n                <table class=\\\"prog-table\\\">\\n                    <thead>\\n                        <tr><th style=\\\"width:30px;\\\">No<\\/th><th>Description<\\/th><th style=\\\"width:65px;\\\">Mark<\\/th><\\/tr>\\n                    <\\/thead>\\n                    <tbody>\\n                        <tr>\\n                            <td contenteditable=\\\"false\\\"><b>1<\\/b><\\/td>\\n                            <td contenteditable=\\\"false\\\">Modul Membaca<\\/td>\\n                            <td>\\n                                <select>\\n                                    <option selected=\\\"\\\">-- Select --<\\/option>\\n                                    <option value=\\\"E\\\">Excellent<\\/option>\\n                                    <option value=\\\"G\\\">Good<\\/option>\\n                                    <option value=\\\"D\\\">Developing<\\/option>\\n                                    <option value=\\\"NI\\\">Need Improvement<\\/option>\\n                                <\\/select>\\n                            <\\/td>\\n                        <\\/tr>\\n                        <tr>\\n                            <td contenteditable=\\\"false\\\"><b>2<\\/b><\\/td>\\n                            <td contenteditable=\\\"false\\\">Peter &amp; Jane<\\/td>\\n                            <td>\\n                                <select>\\n                                    <option selected=\\\"\\\">-- Select --<\\/option>\\n                                    <option value=\\\"E\\\">Excellent<\\/option>\\n                                    <option value=\\\"G\\\">Good<\\/option>\\n                                    <option value=\\\"D\\\">Developing<\\/option>\\n                                    <option value=\\\"NI\\\">Need Improvement<\\/option>\\n                                <\\/select>\\n                            <\\/td>\\n                        <\\/tr>\\n                    <\\/tbody>\\n                <\\/table>\\n            <\\/div>\\n            <div class=\\\"prog-box\\\">\\n                <div class=\\\"prog-title\\\" contenteditable=\\\"false\\\">Additional Program<\\/div>\\n                <table class=\\\"prog-table\\\">\\n                    <thead>\\n                        <tr><th style=\\\"width:30px;\\\">No<\\/th><th>Description<\\/th><th style=\\\"width:75px;\\\">Mark<\\/th><\\/tr>\\n                    <\\/thead>\\n                    <tbody>\\n                        <tr>\\n                            <td contenteditable=\\\"false\\\"><b>1<\\/b><\\/td>\\n                            <td contenteditable=\\\"false\\\">School Activities<\\/td>\\n                            <td>\\n                                <select>\\n                                    <option selected=\\\"\\\">-- Select --<\\/option>\\n                                    <option value=\\\"E\\\">Excellent<\\/option>\\n                                    <option value=\\\"G\\\">Good<\\/option>\\n                                    <option value=\\\"D\\\">Developing<\\/option>\\n                                    <option value=\\\"NI\\\">Need Improvement<\\/option>\\n                                <\\/select>\\n                            <\\/td>\\n                        <\\/tr>\\n                        <tr>\\n                            <td contenteditable=\\\"false\\\"><b>2<\\/b><\\/td>\\n                            <td contenteditable=\\\"false\\\">Exschool<\\/td>\\n                            <td>\\n                                <select>\\n                                    <option selected=\\\"\\\">-- Select --<\\/option>\\n                                    <option value=\\\"E\\\">Excellent<\\/option>\\n                                    <option value=\\\"G\\\">Good<\\/option>\\n                                    <option value=\\\"D\\\">Developing<\\/option>\\n                                    <option value=\\\"NI\\\">Need Improvement<\\/option>\\n                                <\\/select>\\n                            <\\/td>\\n                        <\\/tr>\\n                    <\\/tbody>\\n                <\\/table>\\n            <\\/div>\\n        <\\/div>\\n\\n        <div class=\\\"prog-att-grid\\\">\\n            <div class=\\\"progress-list\\\" contenteditable=\\\"false\\\">\\n                <div class=\\\"title\\\">Progress:<\\/div>\\n                <div><b>E<\\/b> &nbsp;&nbsp;&nbsp;: Excellent<\\/div>\\n                <div><b>G<\\/b> &nbsp;&nbsp;&nbsp;: Good<\\/div>\\n                <div><b>D<\\/b> &nbsp;&nbsp;&nbsp;: Developing<\\/div>\\n                <div><b>NI<\\/b> &nbsp;&nbsp;: Need Improvement<\\/div>\\n            <\\/div>\\n            <div class=\\\"attendance-box\\\">\\n                <div class=\\\"title\\\" contenteditable=\\\"false\\\">Attendance<\\/div>\\n                <table class=\\\"att-table\\\">\\n                    <tbody><tr><td>1<\\/td><td contenteditable=\\\"false\\\">Absent<\\/td><td contenteditable=\\\"true\\\">-<\\/td><\\/tr>\\n                    <tr><td>2<\\/td><td contenteditable=\\\"false\\\">Sick<\\/td><td contenteditable=\\\"true\\\">-<\\/td><\\/tr>\\n                    <tr><td>3<\\/td><td contenteditable=\\\"false\\\">Permission<\\/td><td contenteditable=\\\"true\\\">-<\\/td><\\/tr>\\n                <\\/tbody><\\/table>\\n            <\\/div>\\n        <\\/div>\\n\\n        <div class=\\\"message-section\\\">\\n            <div class=\\\"message-title\\\" contenteditable=\\\"false\\\">Message for Parent<\\/div>\\n            <div class=\\\"message-box\\\" contenteditable=\\\"true\\\">Dear lovely parents,<br><br>It has been pleasure to have Alecia\'s enthusiasm and positivity in our class. She has finished her lesson in this term well. She shows a conscientious effort to learn. Sometime, she needs to listen to directions more attentively during lessons. She needs to improve on working independently and be sure to ask for assistance only when it is needed. Please encourage her to be confidence to do the task and pay attention to detail in her assignments. Hopefully, Alecia will be better in the next term. Thank you.<\\/div>\\n        <\\/div>\\n\\n        <div class=\\\"signatures\\\">\\n            <div class=\\\"sign-left\\\">\\n                <div contenteditable=\\\"false\\\">Class Teacher 1<\\/div>\\n                <div class=\\\"sign-name\\\" contenteditable=\\\"true\\\">Hanifah, S.Pd, AUD<\\/div>\\n            <\\/div>\\n            <div class=\\\"sign-right\\\">\\n                <div style=\\\"margin-bottom: 5px;\\\"><span contenteditable=\\\"true\\\">Jakarta, September 27th 2025<\\/span><\\/div>\\n                <div contenteditable=\\\"true\\\">Headmistress,<\\/div>\\n                <div class=\\\"sign-name underline\\\" contenteditable=\\\"true\\\">Dwi Komala Sari, S.Pd.AUD<\\/div>\\n                <div class=\\\"nuks-text\\\" contenteditable=\\\"true\\\">NUKS: 1902310890162212122569<\\/div>\\n            <\\/div>\\n            <div class=\\\"sign-left\\\">\\n                <div contenteditable=\\\"false\\\">Class Teacher 2<\\/div>\\n                <div class=\\\"sign-name\\\" contenteditable=\\\"true\\\">Anggi Charisma, A.Ma<\\/div>\\n            <\\/div>\\n            <div class=\\\"sign-right\\\">\\n                <div contenteditable=\\\"false\\\">Parent<\\/div>\\n                <div class=\\\"sign-name\\\" contenteditable=\\\"true\\\">----------------------<\\/div>\\n            <\\/div>\\n        <\\/div>\\n    <\\/div>\\n\\n    <!-- ================= SCRIPT INTERAKTIF ================= -->\\n    <script>\\n        \\/\\/ Fitur klik untuk otomatis mencentang nilai\\n        document.querySelectorAll(\'.check-cell\').forEach(cell => {\\n            cell.addEventListener(\'click\', function() {\\n                const row = this.parentElement;\\n                if (this.textContent === \'\\u2713\') {\\n                    this.textContent = \'\';\\n                } else {\\n                    row.querySelectorAll(\'.check-cell\').forEach(c => c.textContent = \'\');\\n                    this.textContent = \'\\u2713\';\\n                }\\n            });\\n        });\\n\\n        \\/\\/ ==================== FUNGSI SAVE & CLOSE KE DATABASE ====================\\n        async function saveAndClose() {\\n            \\/\\/ Ambil data dasar\\n            const nama = document.getElementById(\'studentName\')?.textContent?.trim() || \'Siswa\';\\n            const kelas = document.getElementById(\'studentClass\')?.textContent?.trim() || \'\';\\n            const semester = document.getElementById(\'studentTerm\')?.textContent?.trim() || \'Ganjil\';\\n            const tahun = document.getElementById(\'studentYear\')?.textContent?.trim() || \'2024\\/2025\';\\n\\n            \\/\\/ Ambil NIS dan ID Template yang dilempar dari data_guru.js via URL\\n            const urlParams = new URLSearchParams(window.location.search);\\n            const nis = urlParams.get(\'nis\') || \'\';\\n            const id_template = urlParams.get(\'id_template\') || 0;\\n\\n            if (!nis || !id_template) {\\n                alert(\'\\u274c Error: NIS atau ID Template tidak ditemukan. Pastikan membuka dari Portal Guru.\');\\n                return;\\n            }\\n\\n            \\/\\/ Sembunyikan control-bar sebelum mengambil HTML agar tombol \\\"Save\\\" tidak ikut tersimpan di Raport Siswa\\n            const controlBar = document.querySelector(\'.control-bar\');\\n            if (controlBar) controlBar.style.display = \'none\';\\n            \\n            \\/\\/ Ambil seluruh desain HTML yang sudah dicentang dan diketik\\n            const htmlIsian = document.body.innerHTML;\\n            \\n            \\/\\/ Munculkan lagi bar-nya\\n            if (controlBar) controlBar.style.display = \'flex\';\\n\\n            const data = {\\n                nis: nis,\\n                nama: nama,\\n                kelas: kelas,\\n                semester: semester,\\n                tahun: tahun,\\n                id_template: id_template,\\n                htmlContent: htmlIsian\\n            };\\n\\n            \\/\\/ MENGIRIM KE PARENT WINDOW (data_guru.js)\\n            if (window.opener && typeof window.opener.saveRaportFromTemplate === \'function\') {\\n                showSaveSuccess(\'\\u23f3 Menyimpan raport ke database...\');\\n                \\n                \\/\\/ Panggil fungsi di data_guru.js\\n                const success = await window.opener.saveRaportFromTemplate(data);\\n                \\n                if (success) {\\n                    showSaveSuccess(\'\\u2705 Raport berhasil disimpan!\');\\n                    setTimeout(() => window.close(), 1500); \\/\\/ Tutup otomatis\\n                } else {\\n                    showSaveSuccess(\'\\u274c Gagal menyimpan ke database.\');\\n                }\\n            } else {\\n                alert(\'\\u274c Halaman Guru tidak terhubung. Raport gagal disimpan.\');\\n            }\\n        }\\n\\n        function showSaveSuccess(message) {\\n            const controlBar = document.querySelector(\'.control-bar\');\\n            if (controlBar) {\\n                let existing = controlBar.querySelector(\'.save-success-msg\');\\n                if (!existing) {\\n                    existing = document.createElement(\'div\');\\n                    existing.className = \'save-success-msg\';\\n                    existing.style.cssText = \'background: #10b981; color: white; padding: 8px 16px; border-radius: 6px; font-weight: bold; font-size: 14px; margin-left: 10px;\';\\n                    controlBar.appendChild(existing);\\n                }\\n                existing.textContent = message;\\n            }\\n        }\\n\\n        \\/\\/ AUTO-FILL NAMA SISWA DARI URL SAAT HALAMAN DIBUKA\\n        (function loadFromQuery() {\\n            const urlParams = new URLSearchParams(window.location.search);\\n            if (urlParams.get(\'nama\')) {\\n                const nameEl = document.getElementById(\'studentName\');\\n                if (nameEl) nameEl.textContent = urlParams.get(\'nama\');\\n            }\\n        })();\\n    <\\/script>\\n\\n\"}', '2026-08-03 09:41:15');

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

--
-- Table structure for table `raport_kirim`
--

CREATE TABLE `raport_kirim` (
  `id` int NOT NULL,
  `id_template` int NOT NULL,
  `nuptk_guru_tujuan` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_kelas` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `semester` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun_ajaran` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pesan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` enum('pending','dikirim','dibaca') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `tanggal_kirim` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `nis_siswa` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `raport_template`
--

CREATE TABLE `raport_template` (
  `id` int NOT NULL,
  `nama_template` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal_upload` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `raport_template`
--

INSERT INTO `raport_template` (`id`, `nama_template`, `path_file`, `tanggal_upload`) VALUES
(1, 'minggu1', 'data_guru/template/K2B_term2.html', '2026-08-03 09:39:14'),
(2, 'semester1', 'data_guru/template/K2B_term1.html', '2026-08-03 09:41:01');

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

--
-- Table structure for table `ruangan`
--

CREATE TABLE `ruangan` (
  `id_ruangan` int NOT NULL,
  `nama_ruangan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `siswa` (
  `nis` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_lengkap` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_kelas` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `foto_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `siswa` (`nis`, `nama_lengkap`, `id_kelas`, `foto_url`, `created_at`) VALUES
('1234567890', 'eko setiawan', 'KLS_1785489957668', NULL, '2026-07-31 03:37:35'),
('1234567895', 'test', 'KLS_1785749612912', '', '2026-08-03 09:34:30'),
('9087654321', 'udin padidin', 'KLS_1785745397762', '', '2026-08-03 09:33:11');

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

--
-- Table structure for table `siswa_data_pribadi`
--

CREATE TABLE `siswa_data_pribadi` (
  `nis` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nisn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tempat_lahir` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_lahir` date DEFAULT NULL,
  `jenis_kelamin` enum('Laki-laki','Perempuan') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agama` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kewarganegaraan` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Indonesia',
  `alamat` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `rt` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rw` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kelurahan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kecamatan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kota` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provinsi` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telp` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_ayah` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pendidikan_ayah` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pekerjaan_ayah` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_hp_ayah` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_ibu` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pendidikan_ibu` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pekerjaan_ibu` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_hp_ibu` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `siswa_data_pribadi`
--

INSERT INTO `siswa_data_pribadi` (`nis`, `nisn`, `tempat_lahir`, `tanggal_lahir`, `jenis_kelamin`, `agama`, `kewarganegaraan`, `alamat`, `rt`, `rw`, `kelurahan`, `kecamatan`, `kota`, `provinsi`, `telp`, `email`, `nama_ayah`, `pendidikan_ayah`, `pekerjaan_ayah`, `no_hp_ayah`, `nama_ibu`, `pendidikan_ibu`, `pekerjaan_ibu`, `no_hp_ibu`, `updated_at`) VALUES
('1234567890', '11223344', 'bogor', '2026-08-02', NULL, '', 'Indonesia', '123', '04', '01', 'bogor ', 'bogor ', 'bogor ', 'bogor ', '579856236586348689 ', 'eko@gmail.com', 'udin ', 's3 ', 'pns ', '29487289356896 ', 'idin', 's1 ', 'test ', '1827489356892536 ', '2026-08-03 11:55:20'),
('1234567895', '', '', NULL, NULL, '', 'Indonesia', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2026-08-03 09:37:57'),
('9087654321', '', '', '0000-00-00', '', '', 'Indonesia', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2026-08-03 09:33:11');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL,
  `username` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` enum('Admin','Guru','Siswa','Viewer') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Viewer',
  `tipe_akun` enum('admin','guru','siswa','viewer') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'viewer',
  `nuptk` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nis` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `foto_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_aktif` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `nama`, `email`, `role`, `tipe_akun`, `nuptk`, `nis`, `foto_url`, `status_aktif`, `created_at`, `updated_at`) VALUES
(1, 'admin', '$2y$10$NV/pLvfeVwpR9XGucuBSO.24oEV1u4ehNS1GdgUjI8QneiI5epHuu', 'Administrator', 'admin@jisc.com', 'Admin', 'admin', NULL, NULL, NULL, 1, '2026-07-31 02:34:56', '2026-08-01 14:17:35'),
(2, '1234567890', '$2y$10$oR8o/DmRjc3hum9Q4FFtveRT78AuGnCwyrIb41LSIo.RDd6HyriQS', 'eko setiawan', 'eko@gmail.com', 'Siswa', 'siswa', NULL, '1234567890', NULL, 1, '2026-07-31 03:37:35', '2026-08-01 14:16:22'),
(3, '0987654321234567', '$2y$10$V/o3VgFMHwOw89Q89dfvB.m5JhZDDr10fOUSA80nlgFevBZKWtaam', 'siti anisa', 'siti@gmail.com', 'Guru', 'guru', '0987654321234567', NULL, NULL, 1, '2026-07-31 03:44:11', '2026-08-01 14:16:59'),
(5, '9039761662230303', '$2y$10$Vlr29vR4Shrmm6gFGCF.rO0knwRi5x3vZUn3UjsdYPTbpL2.a.MDi', 'Dina Nurzanah Sari', 'deechanstore', 'Guru', 'guru', '9039761662230303', '', NULL, 1, '2026-08-03 05:17:01', '2026-08-03 05:17:01'),
(10, '1234567895', '$2y$10$FIG.bbfkGb/2eu0smYPsi.QtYDpjvNB15Y15m1odnIiZjFEWYQYy6', 'test', '', 'Siswa', 'siswa', NULL, '1234567895', NULL, 1, '2026-08-03 05:24:40', '2026-08-03 09:37:57'),
(14, '0987654321234560', '$2y$10$9/NP66fOPGNYfR2luTec7uK54CmTup36dA4mGY4ImJxN5WAcU8xZq', 'bagas subianto', 'sud@gmail.com', 'Guru', 'guru', '0987654321234560', NULL, NULL, 1, '2026-08-03 08:43:28', '2026-08-03 08:43:28'),
(15, '9087654321', '$2y$10$ETBU.zCoVfXvZNCWb6Rs..UbVsSzk/l7J0juSmDWnrnI7sE8MfpIG', 'udin padidin', 'udin@gmail.com', 'Siswa', 'siswa', NULL, '9087654321', NULL, 1, '2026-08-03 08:55:15', '2026-08-03 08:55:15'),
(16, '1234567890654321', '$2y$10$y.Uui1CGGkzPIq9aKv/pbuGOXsrEpbQNYb73fjElvrw/HTH94JS4y', 'asep surasep', 'asep@gmail.com', 'Guru', 'guru', '1234567890654321', NULL, NULL, 1, '2026-08-03 08:56:21', '2026-08-03 08:56:21');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `anecdote`
--
ALTER TABLE `anecdote`
  ADD PRIMARY KEY (`id`),
  ADD KEY `target_id` (`target_id`);

--
-- Indexes for table `elearning_aktivitas`
--
ALTER TABLE `elearning_aktivitas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `nuptk_guru` (`nuptk_guru`);

--
-- Indexes for table `elearning_balasan_diskusi`
--
ALTER TABLE `elearning_balasan_diskusi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_diskusi` (`id_diskusi`);

--
-- Indexes for table `elearning_diskusi`
--
ALTER TABLE `elearning_diskusi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_pertemuan` (`id_pertemuan`);

--
-- Indexes for table `elearning_jawaban_quiz`
--
ALTER TABLE `elearning_jawaban_quiz`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_quiz` (`id_quiz`),
  ADD KEY `nis_siswa` (`nis_siswa`);

--
-- Indexes for table `elearning_modul`
--
ALTER TABLE `elearning_modul`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_pertemuan` (`id_pertemuan`);

--
-- Indexes for table `elearning_pertemuan`
--
ALTER TABLE `elearning_pertemuan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_aktivitas` (`id_aktivitas`);

--
-- Indexes for table `elearning_quiz`
--
ALTER TABLE `elearning_quiz`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_pertemuan` (`id_pertemuan`);

--
-- Indexes for table `elearning_video`
--
ALTER TABLE `elearning_video`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_pertemuan` (`id_pertemuan`);

--
-- Indexes for table `guru`
--
ALTER TABLE `guru`
  ADD PRIMARY KEY (`nuptk`);

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

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

--
-- Indexes for table `info_galeri_item`
--
ALTER TABLE `info_galeri_item`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_album` (`id_album`);

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

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

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

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

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

--
-- Indexes for table `inventaris_barang`
--
ALTER TABLE `inventaris_barang`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `kode_barang` (`kode_barang`),
  ADD KEY `id_ruangan` (`id_ruangan`);

--
-- Indexes for table `jadwal_mengajar`
--
ALTER TABLE `jadwal_mengajar`
  ADD PRIMARY KEY (`id`),
  ADD KEY `nuptk_guru` (`nuptk_guru`),
  ADD KEY `id_kelas` (`id_kelas`);

--
-- Indexes for table `kelas`
--
ALTER TABLE `kelas`
  ADD PRIMARY KEY (`id_kelas`),
  ADD UNIQUE KEY `nama_kelas` (`nama_kelas`),
  ADD KEY `nuptk_wali_kelas` (`nuptk_wali_kelas`);

--
-- Indexes for table `laporan_kerusakan`
--
ALTER TABLE `laporan_kerusakan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_barang` (`id_barang`);

--
-- Indexes for table `perpus_buku`
--
ALTER TABLE `perpus_buku`
  ADD PRIMARY KEY (`kode_buku`);

--
-- Indexes for table `perpus_peminjaman`
--
ALTER TABLE `perpus_peminjaman`
  ADD PRIMARY KEY (`id_transaksi`),
  ADD KEY `nis_siswa` (`nis_siswa`),
  ADD KEY `kode_buku` (`kode_buku`);

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

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

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

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

--
-- Indexes for table `psb_wa_log`
--
ALTER TABLE `psb_wa_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_pendaftar` (`id_pendaftar`);

--
-- Indexes for table `raport_arsip_pdf`
--
ALTER TABLE `raport_arsip_pdf`
  ADD PRIMARY KEY (`id`),
  ADD KEY `nis_siswa` (`nis_siswa`);

--
-- Indexes for table `raport_isi`
--
ALTER TABLE `raport_isi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `nis_siswa` (`nis_siswa`),
  ADD KEY `nuptk_guru` (`nuptk_guru`),
  ADD KEY `id_template` (`id_template`);

--
-- Indexes for table `raport_kirim`
--
ALTER TABLE `raport_kirim`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_template` (`id_template`),
  ADD KEY `nuptk_guru_tujuan` (`nuptk_guru_tujuan`),
  ADD KEY `nis_siswa` (`nis_siswa`);

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

--
-- Indexes for table `ruangan`
--
ALTER TABLE `ruangan`
  ADD PRIMARY KEY (`id_ruangan`),
  ADD UNIQUE KEY `nama_ruangan` (`nama_ruangan`);

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

--
-- Indexes for table `siswa_data_pribadi`
--
ALTER TABLE `siswa_data_pribadi`
  ADD PRIMARY KEY (`nis`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `nuptk` (`nuptk`),
  ADD UNIQUE KEY `nis` (`nis`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `anecdote`
--
ALTER TABLE `anecdote`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `elearning_aktivitas`
--
ALTER TABLE `elearning_aktivitas`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `elearning_balasan_diskusi`
--
ALTER TABLE `elearning_balasan_diskusi`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `elearning_diskusi`
--
ALTER TABLE `elearning_diskusi`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `elearning_jawaban_quiz`
--
ALTER TABLE `elearning_jawaban_quiz`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `elearning_modul`
--
ALTER TABLE `elearning_modul`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `elearning_pertemuan`
--
ALTER TABLE `elearning_pertemuan`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `elearning_quiz`
--
ALTER TABLE `elearning_quiz`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `elearning_video`
--
ALTER TABLE `elearning_video`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `info_galeri_album`
--
ALTER TABLE `info_galeri_album`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `info_galeri_item`
--
ALTER TABLE `info_galeri_item`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `info_pesan`
--
ALTER TABLE `info_pesan`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `info_sosmed`
--
ALTER TABLE `info_sosmed`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inventaris_barang`
--
ALTER TABLE `inventaris_barang`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jadwal_mengajar`
--
ALTER TABLE `jadwal_mengajar`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `psb_pendaftar`
--
ALTER TABLE `psb_pendaftar`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `psb_wa_log`
--
ALTER TABLE `psb_wa_log`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `raport_arsip_pdf`
--
ALTER TABLE `raport_arsip_pdf`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `raport_isi`
--
ALTER TABLE `raport_isi`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `raport_kirim`
--
ALTER TABLE `raport_kirim`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `raport_template`
--
ALTER TABLE `raport_template`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `ruangan`
--
ALTER TABLE `ruangan`
  MODIFY `id_ruangan` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `elearning_aktivitas`
--
ALTER TABLE `elearning_aktivitas`
  ADD CONSTRAINT `elearning_aktivitas_ibfk_1` FOREIGN KEY (`nuptk_guru`) REFERENCES `guru` (`nuptk`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `elearning_balasan_diskusi`
--
ALTER TABLE `elearning_balasan_diskusi`
  ADD CONSTRAINT `elearning_balasan_diskusi_ibfk_1` FOREIGN KEY (`id_diskusi`) REFERENCES `elearning_diskusi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `elearning_diskusi`
--
ALTER TABLE `elearning_diskusi`
  ADD CONSTRAINT `elearning_diskusi_ibfk_1` FOREIGN KEY (`id_pertemuan`) REFERENCES `elearning_pertemuan` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `elearning_jawaban_quiz`
--
ALTER TABLE `elearning_jawaban_quiz`
  ADD CONSTRAINT `elearning_jawaban_quiz_ibfk_1` FOREIGN KEY (`id_quiz`) REFERENCES `elearning_quiz` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `elearning_jawaban_quiz_ibfk_2` FOREIGN KEY (`nis_siswa`) REFERENCES `siswa` (`nis`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `elearning_modul`
--
ALTER TABLE `elearning_modul`
  ADD CONSTRAINT `elearning_modul_ibfk_1` FOREIGN KEY (`id_pertemuan`) REFERENCES `elearning_pertemuan` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `elearning_pertemuan`
--
ALTER TABLE `elearning_pertemuan`
  ADD CONSTRAINT `elearning_pertemuan_ibfk_1` FOREIGN KEY (`id_aktivitas`) REFERENCES `elearning_aktivitas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `elearning_quiz`
--
ALTER TABLE `elearning_quiz`
  ADD CONSTRAINT `elearning_quiz_ibfk_1` FOREIGN KEY (`id_pertemuan`) REFERENCES `elearning_pertemuan` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `elearning_video`
--
ALTER TABLE `elearning_video`
  ADD CONSTRAINT `elearning_video_ibfk_1` FOREIGN KEY (`id_pertemuan`) REFERENCES `elearning_pertemuan` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `guru`
--
ALTER TABLE `guru`
  ADD CONSTRAINT `guru_ibfk_1` FOREIGN KEY (`nuptk`) REFERENCES `users` (`nuptk`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `info_galeri_item`
--
ALTER TABLE `info_galeri_item`
  ADD CONSTRAINT `info_galeri_item_ibfk_1` FOREIGN KEY (`id_album`) REFERENCES `info_galeri_album` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `inventaris_barang`
--
ALTER TABLE `inventaris_barang`
  ADD CONSTRAINT `inventaris_barang_ibfk_1` FOREIGN KEY (`id_ruangan`) REFERENCES `ruangan` (`id_ruangan`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `jadwal_mengajar`
--
ALTER TABLE `jadwal_mengajar`
  ADD CONSTRAINT `jadwal_mengajar_ibfk_1` FOREIGN KEY (`nuptk_guru`) REFERENCES `guru` (`nuptk`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `jadwal_mengajar_ibfk_2` FOREIGN KEY (`id_kelas`) REFERENCES `kelas` (`id_kelas`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kelas`
--
ALTER TABLE `kelas`
  ADD CONSTRAINT `kelas_ibfk_1` FOREIGN KEY (`nuptk_wali_kelas`) REFERENCES `guru` (`nuptk`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `laporan_kerusakan`
--
ALTER TABLE `laporan_kerusakan`
  ADD CONSTRAINT `laporan_kerusakan_ibfk_1` FOREIGN KEY (`id_barang`) REFERENCES `inventaris_barang` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `perpus_peminjaman`
--
ALTER TABLE `perpus_peminjaman`
  ADD CONSTRAINT `perpus_peminjaman_ibfk_1` FOREIGN KEY (`nis_siswa`) REFERENCES `siswa` (`nis`) ON DELETE SET NULL,
  ADD CONSTRAINT `perpus_peminjaman_ibfk_2` FOREIGN KEY (`kode_buku`) REFERENCES `perpus_buku` (`kode_buku`) ON DELETE SET NULL;

--
-- Constraints for table `psb_wa_log`
--
ALTER TABLE `psb_wa_log`
  ADD CONSTRAINT `psb_wa_log_ibfk_1` FOREIGN KEY (`id_pendaftar`) REFERENCES `psb_pendaftar` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `raport_isi`
--
ALTER TABLE `raport_isi`
  ADD CONSTRAINT `raport_isi_ibfk_1` FOREIGN KEY (`nis_siswa`) REFERENCES `siswa` (`nis`) ON DELETE CASCADE,
  ADD CONSTRAINT `raport_isi_ibfk_2` FOREIGN KEY (`nuptk_guru`) REFERENCES `guru` (`nuptk`) ON DELETE CASCADE,
  ADD CONSTRAINT `raport_isi_ibfk_3` FOREIGN KEY (`id_template`) REFERENCES `raport_template` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `raport_kirim`
--
ALTER TABLE `raport_kirim`
  ADD CONSTRAINT `raport_kirim_ibfk_1` FOREIGN KEY (`id_template`) REFERENCES `raport_template` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `raport_kirim_ibfk_2` FOREIGN KEY (`nuptk_guru_tujuan`) REFERENCES `guru` (`nuptk`) ON DELETE SET NULL,
  ADD CONSTRAINT `raport_kirim_ibfk_3` FOREIGN KEY (`nis_siswa`) REFERENCES `siswa` (`nis`) ON DELETE SET NULL;

--
-- Constraints for table `siswa`
--
ALTER TABLE `siswa`
  ADD CONSTRAINT `siswa_ibfk_1` FOREIGN KEY (`nis`) REFERENCES `users` (`nis`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `siswa_ibfk_2` FOREIGN KEY (`id_kelas`) REFERENCES `kelas` (`id_kelas`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `siswa_data_pribadi`
--
ALTER TABLE `siswa_data_pribadi`
  ADD CONSTRAINT `siswa_data_pribadi_ibfk_1` FOREIGN KEY (`nis`) REFERENCES `siswa` (`nis`) 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 */;