/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `inspeksi` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nama_taman` varchar(150) NOT NULL,
  `alamat` varchar(255) NOT NULL,
  `pengelola` varchar(150) NOT NULL,
  `tanggal` date NOT NULL,
  `petugas` varchar(150) NOT NULL,
  `puskesmas` varchar(150) NOT NULL,
  `saran` text DEFAULT NULL,
  `skor` decimal(10,2) NOT NULL,
  `skor_maks` decimal(10,2) NOT NULL,
  `persen` decimal(5,2) NOT NULL,
  `ambang_persen` decimal(5,2) NOT NULL,
  `status` varchar(3) NOT NULL,
  `verifikasi` varchar(10) NOT NULL DEFAULT 'menunggu',
  `ip` varchar(45) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40000 ALTER TABLE `inspeksi` DISABLE KEYS */;
/*!40000 ALTER TABLE `inspeksi` ENABLE KEYS */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `inspeksi_detail` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `inspeksi_id` int(11) unsigned NOT NULL,
  `kode_kelompok` varchar(5) NOT NULL,
  `nama_kelompok` varchar(150) NOT NULL,
  `nomor` int(11) NOT NULL,
  `variabel` varchar(150) NOT NULL,
  `komponen` text NOT NULL,
  `bobot` decimal(8,4) NOT NULL,
  `nilai` tinyint(3) NOT NULL,
  `skor` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `inspeksi_detail_inspeksi_id_foreign` (`inspeksi_id`),
  CONSTRAINT `inspeksi_detail_inspeksi_id_foreign` FOREIGN KEY (`inspeksi_id`) REFERENCES `inspeksi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40000 ALTER TABLE `inspeksi_detail` DISABLE KEYS */;
/*!40000 ALTER TABLE `inspeksi_detail` ENABLE KEYS */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `kelompok` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kode` varchar(5) NOT NULL,
  `nama` varchar(150) NOT NULL,
  `bobot` decimal(6,2) NOT NULL,
  `urutan` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `kode` (`kode`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40000 ALTER TABLE `kelompok` DISABLE KEYS */;
INSERT INTO `kelompok` VALUES
(1,'A','Kualitas Media Lingkungan',30.00,1),
(2,'B','Sarana dan Bangunan Taman',25.00,2),
(3,'C','Fasilitas Sanitasi Dasar',25.00,3),
(4,'D','Pengendalian Vektor Penyakit',10.00,4),
(5,'E','Fasilitas Penunjang & Perilaku',10.00,5);
/*!40000 ALTER TABLE `kelompok` ENABLE KEYS */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `version` varchar(255) NOT NULL,
  `class` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL,
  `namespace` varchar(255) NOT NULL,
  `time` int(11) NOT NULL,
  `batch` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES
(1,'2026-11-12-000001','App\\Database\\Migrations\\CreateIklTables','default','App',1794487959,1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `pengaturan` (
  `kunci` varchar(50) NOT NULL,
  `nilai` text DEFAULT NULL,
  PRIMARY KEY (`kunci`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40000 ALTER TABLE `pengaturan` DISABLE KEYS */;
INSERT INTO `pengaturan` VALUES
('ambang_persen','70'),
('batas_kiriman','20'),
('kode_akses',''),
('kode_akses_aktif','0');
/*!40000 ALTER TABLE `pengaturan` ENABLE KEYS */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `pertanyaan` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kelompok_id` int(11) unsigned NOT NULL,
  `variabel` varchar(150) NOT NULL,
  `komponen` text NOT NULL,
  `urutan` int(11) NOT NULL DEFAULT 0,
  `aktif` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `pertanyaan_kelompok_id_foreign` (`kelompok_id`),
  CONSTRAINT `pertanyaan_kelompok_id_foreign` FOREIGN KEY (`kelompok_id`) REFERENCES `kelompok` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40000 ALTER TABLE `pertanyaan` DISABLE KEYS */;
INSERT INTO `pertanyaan` VALUES
(1,1,'Kualitas Udara Ruang/Kawasan','Bebas dari asap rokok, bau menyengat, debu, dan zat pencemar jalan raya luar.',1,1),
(2,1,'Kondisi Tanah & Lahan','Tanah permukaan bersih, tidak rawan longsor, bebas pencemaran limbah B3/kimia.',2,1),
(3,1,'Sarana Kebisingan & Radiasi','Tingkat kebisingan di zona santai terjaga (nyaman/teduh), tidak dekat gardu tegangan tinggi tanpa pagar.',3,1),
(4,2,'Zonasi & Penataan Kawasan','Pemisahan jelas area bermain anak, olahraga, kuliner, dan area tenang/hijau.',1,1),
(5,2,'Fasilitas Bermain Anak (Playground)','Material aman (tidak berkarat/tajam), landasan empuk (pasir/rumput), terawat.',2,1),
(6,2,'Jalur Pejalan Kaki (Pedestrian/Jogging)','Permukaan rata, tidak licin, tidak berlubang, dan aksesibel bagi disabilitas.',3,1),
(7,2,'Pencahayaan & Penerangan Malam','Penerangan jalan umum dan sudut taman cukup terang untuk mencegah kriminalitas.',4,1),
(8,3,'Penyediaan Air Bersih (SAB)','Kuantitas cukup, fisik jernih, tidak berbau, tidak berasa. Tersedia keran umum/bilas.',1,1),
(9,3,'Toilet Umum & Urinal','Terpisah pria/wanita, bersih, tidak bau, air mengalir, lantai tidak licin, ada sabun.',2,1),
(10,3,'Tempat Sampah Terpilah','Jumlah cukup, bertutup, terpisah organik/anorganik, tersebar merata di setiap sudut.',3,1),
(11,3,'Saluran Air Limbah (SPAL)','Saluran tertutup, air mengalir lancar, tidak ada genangan atau penyumbatan sampah.',4,1),
(12,3,'Fasilitas Cuci Tangan (CTPS)','Tersedia sabun dan air mengalir di dekat area kuliner, toilet, dan pintu masuk.',5,1),
(13,4,'Kepadatan Jentik Nyamuk','Indeks jentik (ABJ > 95%), tidak ada air tergenang di pot/barang bekas.',1,1),
(14,4,'Keberadaan Tikus & Lalat','Tidak ada tanda keberadaan tikus (kotoran/sarang) dan lalat terkendali di area kuliner.',2,1),
(15,5,'Area Kuliner / Pedagang Makanan','Kios rapi, memiliki tempat cuci piring mandiri, pedagang menjaga higiene makanan.',1,1),
(16,5,'Pos Kesehatan & P3K','Tersedia kotak P3K darurat atau pos informasi/keamanan yang aktif.',2,1),
(17,5,'Media Informasi & Larangan','Adanya rambu petunjuk, larangan membuang sampah sembarangan, rambu K3/Evakuasi.',3,1),
(18,5,'Perilaku Hidup Bersih & Sehat (PHBS)','Pengunjung membuang sampah pada tempatnya, tidak merokok di area non-rokok.',4,1);
/*!40000 ALTER TABLE `pertanyaan` ENABLE KEYS */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(1,'admin','Administrator','$2y$10$uocoLwOEW.zh7t59nYsveOhUPJATQxJkoK4kbPoBbOelDt9o/ATXa','2026-11-12 12:52:39');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;