-- MySQL dump 10.13  Distrib 8.4.3, for Win64 (x86_64)
--
-- Host: localhost    Database: spj
-- ------------------------------------------------------
-- Server version	8.4.3

/*!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 */;
/*!50503 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 */;

--
-- Table structure for table `app_setting`
--

DROP TABLE IF EXISTS `app_setting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `app_setting` (
  `setting_id` int unsigned NOT NULL AUTO_INCREMENT,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `favicon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `nama_aplikasi` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `judul_aplikasi` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tagline` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `nama_perusahaan` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`setting_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `app_setting`
--

LOCK TABLES `app_setting` WRITE;
/*!40000 ALTER TABLE `app_setting` DISABLE KEYS */;
INSERT INTO `app_setting` VALUES (1,'1779512503_37b4f369a11adbc4db79.png','1779512503_f6f3e6363cc7a593bbd5.png','EKinerja',NULL,'Monitoring Aktivitas, Tugas, dan Produktivitas Pegawai','PT. Teknologi Indonesia');
/*!40000 ALTER TABLE `app_setting` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bidang`
--

DROP TABLE IF EXISTS `bidang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bidang` (
  `bidang_id` int unsigned NOT NULL AUTO_INCREMENT,
  `nama_bidang` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`bidang_id`),
  UNIQUE KEY `nama_bidang` (`nama_bidang`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bidang`
--

LOCK TABLES `bidang` WRITE;
/*!40000 ALTER TABLE `bidang` DISABLE KEYS */;
INSERT INTO `bidang` VALUES (1,'IT','2026-05-23 06:18:02','2026-05-23 06:18:02'),(2,'Keuangan','2026-05-23 06:18:08','2026-05-23 06:18:08');
/*!40000 ALTER TABLE `bidang` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hari_libur`
--

DROP TABLE IF EXISTS `hari_libur`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hari_libur` (
  `hari_libur_id` int unsigned NOT NULL AUTO_INCREMENT,
  `tanggal` date NOT NULL,
  `nama_hari_libur` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`hari_libur_id`),
  UNIQUE KEY `tanggal` (`tanggal`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hari_libur`
--

LOCK TABLES `hari_libur` WRITE;
/*!40000 ALTER TABLE `hari_libur` DISABLE KEYS */;
INSERT INTO `hari_libur` VALUES (2,'2026-01-01','Tahun Baru Masehi',NULL,NULL),(3,'2026-01-16','Isra Mikraj Nabi Muhammad SAW',NULL,NULL),(4,'2026-01-17','Tahun Baru Imlek 2577 Kongzili',NULL,NULL),(5,'2026-03-19','Hari Suci Nyepi',NULL,NULL),(6,'2026-03-21','Hari Raya Idul Fitri 1447 H',NULL,NULL),(7,'2026-03-22','Hari Raya Idul Fitri 1447 H',NULL,NULL),(8,'2026-04-03','Wafat Yesus Kristus',NULL,NULL),(9,'2026-04-05','Hari Paskah',NULL,NULL),(10,'2026-05-01','Hari Buruh Internasional',NULL,NULL),(11,'2026-05-14','Kenaikan Yesus Kristus',NULL,NULL),(12,'2026-05-27','Hari Raya Idul Adha 1447 H',NULL,NULL),(13,'2026-05-31','Hari Raya Waisak 2570 BE',NULL,NULL),(14,'2026-06-01','Hari Lahir Pancasila',NULL,NULL),(15,'2026-06-16','Tahun Baru Islam 1448 H',NULL,NULL),(16,'2026-08-17','Hari Kemerdekaan Republik Indonesia',NULL,NULL),(17,'2026-08-25','Maulid Nabi Muhammad SAW',NULL,NULL),(18,'2026-12-25','Hari Raya Natal',NULL,NULL);
/*!40000 ALTER TABLE `hari_libur` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hari_libur_mingguan`
--

DROP TABLE IF EXISTS `hari_libur_mingguan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hari_libur_mingguan` (
  `hari_libur_mingguan_id` int unsigned NOT NULL AUTO_INCREMENT,
  `nomor_hari` tinyint unsigned NOT NULL,
  `is_libur` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`hari_libur_mingguan_id`),
  UNIQUE KEY `nomor_hari` (`nomor_hari`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hari_libur_mingguan`
--

LOCK TABLES `hari_libur_mingguan` WRITE;
/*!40000 ALTER TABLE `hari_libur_mingguan` DISABLE KEYS */;
INSERT INTO `hari_libur_mingguan` VALUES (1,0,1,'2026-05-23 17:31:31','2026-05-23 17:32:36'),(2,1,0,'2026-05-23 17:31:31','2026-05-23 17:32:36'),(3,2,0,'2026-05-23 17:31:31','2026-05-23 17:32:36'),(4,3,0,'2026-05-23 17:31:31','2026-05-23 17:32:36'),(5,4,0,'2026-05-23 17:31:31','2026-05-23 17:32:36'),(6,5,0,'2026-05-23 17:31:31','2026-05-23 17:32:36'),(7,6,1,'2026-05-23 17:31:31','2026-05-23 17:32:36');
/*!40000 ALTER TABLE `hari_libur_mingguan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kegiatan`
--

DROP TABLE IF EXISTS `kegiatan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kegiatan` (
  `kegiatan_id` int unsigned NOT NULL AUTO_INCREMENT,
  `tanggal` date NOT NULL,
  `pegawai_id` int unsigned NOT NULL,
  `status_approval` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`kegiatan_id`),
  UNIQUE KEY `pegawai_id_tanggal` (`pegawai_id`,`tanggal`)
) ENGINE=InnoDB AUTO_INCREMENT=1805 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kegiatan`
--

LOCK TABLES `kegiatan` WRITE;
/*!40000 ALTER TABLE `kegiatan` DISABLE KEYS */;
INSERT INTO `kegiatan` VALUES (1768,'2026-05-18',1,1,'2026-05-24 08:35:01','2026-05-25 13:15:33'),(1769,'2026-05-19',1,1,'2026-05-24 08:35:01','2026-05-25 13:15:44'),(1770,'2026-05-20',1,1,'2026-05-24 08:35:01','2026-05-25 13:15:49'),(1771,'2026-05-21',1,1,'2026-05-24 08:35:01','2026-05-25 13:16:12'),(1772,'2026-05-22',1,1,'2026-05-24 08:35:01','2026-05-25 13:16:19'),(1773,'2026-05-18',2,1,'2026-05-24 08:35:01','2026-05-25 13:15:57'),(1774,'2026-05-19',2,1,'2026-05-24 08:35:01','2026-05-25 13:15:41'),(1775,'2026-05-20',2,1,'2026-05-24 08:35:01','2026-05-25 13:16:01'),(1776,'2026-05-21',2,1,'2026-05-24 08:35:01','2026-05-25 13:16:15'),(1777,'2026-05-22',2,1,'2026-05-24 08:35:01','2026-05-25 13:16:25'),(1778,'2026-05-18',3,1,'2026-05-24 08:35:01','2026-05-24 15:38:14'),(1779,'2026-05-19',3,1,'2026-05-24 08:35:01','2026-05-24 15:38:28'),(1780,'2026-05-20',3,1,'2026-05-24 08:35:01','2026-05-24 15:38:00'),(1781,'2026-05-21',3,1,'2026-05-24 08:35:01','2026-05-24 15:37:47'),(1782,'2026-05-22',3,1,'2026-05-24 08:35:01','2026-05-24 15:37:34'),(1783,'2026-05-18',4,1,'2026-05-24 08:35:01','2026-05-24 15:38:17'),(1784,'2026-05-19',4,1,'2026-05-24 08:35:01','2026-05-24 15:38:04'),(1785,'2026-05-20',4,1,'2026-05-24 08:35:01','2026-05-24 15:37:57'),(1786,'2026-05-21',4,1,'2026-05-24 08:35:01','2026-05-24 15:37:44'),(1787,'2026-05-22',4,1,'2026-05-24 08:35:01','2026-05-24 15:37:31'),(1788,'2026-05-18',5,1,'2026-05-24 08:35:01','2026-05-24 15:38:21'),(1789,'2026-05-19',5,1,'2026-05-24 08:35:01','2026-05-24 15:38:08'),(1790,'2026-05-20',5,1,'2026-05-24 08:35:01','2026-05-24 15:37:54'),(1791,'2026-05-21',5,1,'2026-05-24 08:35:01','2026-05-24 15:37:41'),(1792,'2026-05-22',5,1,'2026-05-24 08:35:01','2026-05-24 15:37:24'),(1793,'2026-05-18',6,1,'2026-05-24 08:35:01','2026-05-24 15:38:25'),(1794,'2026-05-19',6,1,'2026-05-24 08:35:01','2026-05-24 15:38:31'),(1795,'2026-05-20',6,1,'2026-05-24 08:35:01','2026-05-24 15:37:50'),(1796,'2026-05-21',6,1,'2026-05-24 08:35:01','2026-05-24 15:37:38'),(1797,'2026-05-22',6,1,'2026-05-24 08:35:01','2026-05-25 16:13:00'),(1798,'2026-05-18',7,1,'2026-05-24 08:35:01','2026-05-25 13:15:52'),(1799,'2026-05-19',7,1,'2026-05-24 08:35:01','2026-05-25 13:15:37'),(1800,'2026-05-20',7,1,'2026-05-24 08:35:01','2026-05-25 13:16:04'),(1801,'2026-05-21',7,1,'2026-05-24 08:35:01','2026-05-25 13:16:09'),(1802,'2026-05-22',7,0,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(1803,'2026-05-23',4,1,'2026-05-24 15:48:58','2026-05-24 15:52:29'),(1804,'2026-05-25',3,1,'2026-05-25 16:18:45','2026-05-25 16:19:24');
/*!40000 ALTER TABLE `kegiatan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kegiatan_rincian`
--

DROP TABLE IF EXISTS `kegiatan_rincian`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kegiatan_rincian` (
  `kegiatan_rincian_id` int unsigned NOT NULL AUTO_INCREMENT,
  `kegiatan_id` int unsigned NOT NULL,
  `nama_kegiatan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `menit` int unsigned NOT NULL,
  `lampiran` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`kegiatan_rincian_id`),
  KEY `kegiatan_id` (`kegiatan_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5719 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kegiatan_rincian`
--

LOCK TABLES `kegiatan_rincian` WRITE;
/*!40000 ALTER TABLE `kegiatan_rincian` DISABLE KEYS */;
INSERT INTO `kegiatan_rincian` VALUES (5603,1768,'Monitoring progres pekerjaan',200,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5604,1768,'Rapat koordinasi bidang',160,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5605,1768,'Penyelesaian tugas operasional',130,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5606,1769,'Validasi berkas masuk',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5607,1769,'Input data ke sistem',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5608,1769,'Pembuatan laporan harian',110,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5609,1769,'Tindak lanjut disposisi',110,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5610,1770,'Koordinasi pekerjaan harian',240,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5611,1770,'Penyusunan laporan administrasi',240,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5612,1771,'Verifikasi data dan dokumen',180,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5613,1771,'Rekapitulasi hasil pekerjaan',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5614,1771,'Koordinasi tindak lanjut',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5615,1772,'Pelayanan internal dan eksternal',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5616,1772,'Pengolahan data kegiatan',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5617,1772,'Penyusunan dokumen pendukung',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5618,1772,'Evaluasi hasil pekerjaan',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5619,1773,'Validasi berkas masuk',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5620,1773,'Input data ke sistem',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5621,1773,'Pembuatan laporan harian',110,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5622,1773,'Tindak lanjut disposisi',110,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5623,1774,'Koordinasi pekerjaan harian',240,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5624,1774,'Penyusunan laporan administrasi',240,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5625,1775,'Verifikasi data dan dokumen',180,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5626,1775,'Rekapitulasi hasil pekerjaan',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5627,1775,'Koordinasi tindak lanjut',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5628,1776,'Pelayanan internal dan eksternal',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5629,1776,'Pengolahan data kegiatan',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5630,1776,'Penyusunan dokumen pendukung',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5631,1776,'Evaluasi hasil pekerjaan',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5632,1777,'Monitoring progres pekerjaan',200,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5633,1777,'Rapat koordinasi bidang',160,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5634,1777,'Penyelesaian tugas operasional',130,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5635,1778,'Koordinasi pekerjaan harian',240,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5636,1778,'Penyusunan laporan administrasi',240,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5637,1779,'Verifikasi data dan dokumen',180,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5638,1779,'Rekapitulasi hasil pekerjaan',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5639,1779,'Koordinasi tindak lanjut',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5640,1780,'Pelayanan internal dan eksternal',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5641,1780,'Pengolahan data kegiatan',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5642,1780,'Penyusunan dokumen pendukung',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5643,1780,'Evaluasi hasil pekerjaan',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5644,1781,'Monitoring progres pekerjaan',200,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5645,1781,'Rapat koordinasi bidang',160,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5646,1781,'Penyelesaian tugas operasional',130,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5647,1782,'Validasi berkas masuk',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5648,1782,'Input data ke sistem',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5649,1782,'Pembuatan laporan harian',110,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5650,1782,'Tindak lanjut disposisi',110,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5651,1783,'Verifikasi data dan dokumen',180,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5652,1783,'Rekapitulasi hasil pekerjaan',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5653,1783,'Koordinasi tindak lanjut',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5654,1784,'Pelayanan internal dan eksternal',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5655,1784,'Pengolahan data kegiatan',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5656,1784,'Penyusunan dokumen pendukung',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5657,1784,'Evaluasi hasil pekerjaan',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5658,1785,'Monitoring progres pekerjaan',200,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5659,1785,'Rapat koordinasi bidang',160,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5660,1785,'Penyelesaian tugas operasional',130,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5661,1786,'Validasi berkas masuk',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5662,1786,'Input data ke sistem',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5663,1786,'Pembuatan laporan harian',110,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5664,1786,'Tindak lanjut disposisi',110,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5665,1787,'Koordinasi pekerjaan harian',240,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5666,1787,'Penyusunan laporan administrasi',240,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5667,1788,'Pelayanan internal dan eksternal',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5668,1788,'Pengolahan data kegiatan',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5669,1788,'Penyusunan dokumen pendukung',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5670,1788,'Evaluasi hasil pekerjaan',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5671,1789,'Monitoring progres pekerjaan',200,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5672,1789,'Rapat koordinasi bidang',160,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5673,1789,'Penyelesaian tugas operasional',130,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5674,1790,'Validasi berkas masuk',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5675,1790,'Input data ke sistem',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5676,1790,'Pembuatan laporan harian',110,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5677,1790,'Tindak lanjut disposisi',110,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5678,1791,'Koordinasi pekerjaan harian',240,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5679,1791,'Penyusunan laporan administrasi',240,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5680,1792,'Verifikasi data dan dokumen',180,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5681,1792,'Rekapitulasi hasil pekerjaan',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5682,1792,'Koordinasi tindak lanjut',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5683,1793,'Monitoring progres pekerjaan',200,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5684,1793,'Rapat koordinasi bidang',160,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5685,1793,'Penyelesaian tugas operasional',130,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5686,1794,'Validasi berkas masuk',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5687,1794,'Input data ke sistem',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5688,1794,'Pembuatan laporan harian',110,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5689,1794,'Tindak lanjut disposisi',110,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5690,1795,'Koordinasi pekerjaan harian',240,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5691,1795,'Penyusunan laporan administrasi',240,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5692,1796,'Verifikasi data dan dokumen',180,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5693,1796,'Rekapitulasi hasil pekerjaan',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5694,1796,'Koordinasi tindak lanjut',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5695,1797,'Pelayanan internal dan eksternal',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5696,1797,'Pengolahan data kegiatan',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5697,1797,'Penyusunan dokumen pendukung',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5698,1797,'Evaluasi hasil pekerjaan',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5699,1798,'Validasi berkas masuk',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5700,1798,'Input data ke sistem',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5701,1798,'Pembuatan laporan harian',110,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5702,1798,'Tindak lanjut disposisi',110,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5703,1799,'Koordinasi pekerjaan harian',240,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5704,1799,'Penyusunan laporan administrasi',240,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5705,1800,'Verifikasi data dan dokumen',180,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5706,1800,'Rekapitulasi hasil pekerjaan',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5707,1800,'Koordinasi tindak lanjut',150,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5708,1801,'Pelayanan internal dan eksternal',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5709,1801,'Pengolahan data kegiatan',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5710,1801,'Penyusunan dokumen pendukung',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5711,1801,'Evaluasi hasil pekerjaan',120,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5712,1802,'Monitoring progres pekerjaan',200,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5713,1802,'Rapat koordinasi bidang',160,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5714,1802,'Penyelesaian tugas operasional',130,NULL,'2026-05-24 08:35:01','2026-05-24 08:35:01'),(5715,1803,'Merapikan database user pengguna',240,'5783dbdba9456a598cc482ba30cbf04d.png','2026-05-24 15:48:58','2026-05-25 14:09:36'),(5716,1803,'Merapikan database pelanggan',249,NULL,'2026-05-24 15:52:23','2026-05-24 15:52:23'),(5717,1804,'menyiapkan database user',120,NULL,'2026-05-25 16:18:45','2026-05-25 16:18:45'),(5718,1804,'mengikuti rapat denagn tim devops dan keuangan',350,NULL,'2026-05-25 16:19:01','2026-05-25 16:22:04');
/*!40000 ALTER TABLE `kegiatan_rincian` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `group` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `namespace` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `time` int NOT NULL,
  `batch` int unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'2026-05-07-224500','App\\Database\\Migrations\\CreateUserTable','default','App',1778168978,1),(2,'2026-05-08-011500','App\\Database\\Migrations\\AddPhotoToUserTable','default','App',1778177978,2),(3,'2026-05-08-021000','App\\Database\\Migrations\\CreateKategoriTable','default','App',1778179253,3),(4,'2026-05-08-021100','App\\Database\\Migrations\\CreateRekeningTable','default','App',1778179253,3),(5,'2026-05-08-023500','App\\Database\\Migrations\\CreateTransaksiTable','default','App',1778180080,4),(6,'2026-05-08-030000','App\\Database\\Migrations\\CreateAppSettingTable','default','App',1778207616,5),(7,'2026-05-08-040000','App\\Database\\Migrations\\CreateTransferTable','default','App',1778224866,6),(8,'2026-05-08-050000','App\\Database\\Migrations\\CreatePelangganTable','default','App',1778254226,7),(9,'2026-05-08-051000','App\\Database\\Migrations\\CreateCabangLaundryTable','default','App',1778254846,8),(10,'2026-05-08-052000','App\\Database\\Migrations\\CreateLayananLaundryTable','default','App',1778255884,9),(11,'2026-05-08-053000','App\\Database\\Migrations\\CreateTransaksiLaundryTable','default','App',1778257780,10),(12,'2026-05-08-053100','App\\Database\\Migrations\\CreateTransaksiLaundryDetailTable','default','App',1778257780,10),(13,'2026-05-09-000000','App\\Database\\Migrations\\RemovePaymentFieldsFromTransaksiLaundryTable','default','App',1778286378,11),(14,'2026-05-09-001000','App\\Database\\Migrations\\AddKeteranganToTransaksiLaundryTable','default','App',1778287295,12),(15,'2026-05-09-002000','App\\Database\\Migrations\\AddKeuanganRelationToTransaksiLaundryTable','default','App',1778289765,13),(16,'2026-05-09-003000','App\\Database\\Migrations\\AddSaldoAwalTanggalToRekeningTable','default','App',1778305945,14),(17,'2026-05-09-004000','App\\Database\\Migrations\\AddCabangIdToUserTable','default','App',1778316306,15),(18,'2026-05-23-000000','App\\Database\\Migrations\\AddFaviconToAppSettingTable','default','App',1779512378,16),(19,'2026-05-23-010000','App\\Database\\Migrations\\CreatePegawaiTable','default','App',1779512799,17),(20,'2026-05-23-020000','App\\Database\\Migrations\\AddJudulAplikasiToAppSettingTable','default','App',1779513079,18),(21,'2026-05-23-030000','App\\Database\\Migrations\\AddIsActiveToPegawaiTable','default','App',1779513169,19),(22,'2026-05-23-040000','App\\Database\\Migrations\\AddTanggalTerdaftarToPegawaiTable','default','App',1779513310,20),(23,'2026-05-23-050000','App\\Database\\Migrations\\CreatePimpinanTable','default','App',1779513777,21),(24,'2026-05-23-060000','App\\Database\\Migrations\\CreateBidangTable','default','App',1779516987,22),(25,'2026-05-23-070000','App\\Database\\Migrations\\AddBidangToPegawaiAndPimpinanTables','default','App',1779517332,23),(26,'2026-05-23-080000','App\\Database\\Migrations\\RemoveStaffUserRole','default','App',1779519719,24),(27,'2026-05-23-090000','App\\Database\\Migrations\\RequireAdministratorUserRole','default','App',1779519782,25),(28,'2026-05-23-100000','App\\Database\\Migrations\\CreateKegiatanTables','default','App',1779529509,26),(29,'2026-05-24-010000','App\\Database\\Migrations\\CreateHariLiburTables','default','App',1779557491,27),(30,'2026-05-24-020000','App\\Database\\Migrations\\CreateProyekTaskTables','default','App',1779592510,28),(31,'2026-05-24-030000','App\\Database\\Migrations\\AddPegawaiProgressToProyekTaskTable','default','App',1779594151,29),(32,'2026-05-24-040000','App\\Database\\Migrations\\CreateProyekTaskPekerjaanTable','default','App',1779596939,30),(33,'2026-05-24-050000','App\\Database\\Migrations\\MigrateTaskWorkHistoryAndDropOldTaskFields','default','App',1779597093,31);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pegawai`
--

DROP TABLE IF EXISTS `pegawai`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pegawai` (
  `pegawai_id` int unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `nip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `jenis_kelamin` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `no_hp` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `jabatan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `bidang_id` int unsigned DEFAULT NULL,
  `alamat` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `foto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `tanggal_terdaftar` date NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`pegawai_id`),
  UNIQUE KEY `nip` (`nip`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pegawai`
--

LOCK TABLES `pegawai` WRITE;
/*!40000 ALTER TABLE `pegawai` DISABLE KEYS */;
INSERT INTO `pegawai` VALUES (1,'Ahmad Fauzi Pratama','199105152020121001','Laki-laki','081234567801','Akuntan',2,'Jl. Melati No. 12, Kecamatan Lowokwaru, Kota Malang','pegawai1@malasngoding.com','$2y$10$z9pO4WeThgytUa/Rc.7iBOZoZe0Rp0MTmOhvK2DcnQkOw00IuAnwq',NULL,1,'2026-05-17','2026-05-23 05:29:20','2026-05-23 07:14:32'),(2,'Siti Nur Aisyah','199207182021122002','Perempuan','081234567802','Marketing',2,'Jl. Cempaka No. 8, Kecamatan Blimbing, Kota Malang','pegawai2@malasngoding.com','$2y$10$sr.JdTt.no8RpKPdKCDaius5cyvSi6btsQu9..kfTv8oagw7ULqEy',NULL,1,'2026-05-17','2026-05-23 05:29:20','2026-05-23 07:02:24'),(3,'Rizky Aditya Saputra','199403092022121003','Laki-laki','081234567803','Teknisi Komputer',1,'Jl. Danau Toba No. 21, Kecamatan Kedungkandang, Kota Malang','pegawai3@malasngoding.com','$2y$10$OZo9bqyICeXfWQ3p8zkoWuJtDOv6VN15awybRdXf1Xe90IB.gY6l2',NULL,1,'2026-05-17','2026-05-23 05:29:20','2026-05-23 07:02:55'),(4,'Dewi Lestari Wulandari','199609242023122004','Perempuan','081234567804','Designer',1,'Jl. Ijen No. 44, Kecamatan Klojen, Kota Malang','pegawai4@malasngoding.com','$2y$10$KVtOR0T/jyWDyjZy5nkE7eBxZssrpQ3Ce6IVouK7zmzL9mg8.z94.',NULL,1,'2026-05-17','2026-05-23 05:29:20','2026-05-23 07:01:16'),(5,'Bima Setiawan Nugroho','199811112024121005','Laki-laki','081234567805','Software Engineer',1,'Jl. Raya Tlogomas No. 17, Kecamatan Lowokwaru, Kota Malang','pegawai5@malasngoding.com','$2y$10$/bE/3uio4slBwR.eMGhw/.igsnaGaCTkvLWbMGVcz54QkAwruLgbS',NULL,1,'2026-05-17','2026-05-23 05:29:20','2026-05-23 07:00:59'),(6,'Fajar Maulana Prasetyo','199002102019031006','Laki-laki','081234567806','Analis Sistem Informasi',1,'Jl. Melati Raya No. 18, Jakarta Selatan','pegawai6@malasngoding.com','$2y$10$fUfuxlAsgZL1grDThDqiqu/HxK5ZPr9JGYi1qNY8qwyAcQ1CKtWB6',NULL,1,'2026-05-17','2026-05-24 08:16:31','2026-05-24 08:16:31'),(7,'Nurul Fitri Handayani','199306222020122007','Perempuan','081234567807','Bendahara Pengeluaran',2,'Jl. Kenanga Indah No. 27, Jakarta Pusat','pegawai7@malasngoding.com','$2y$10$fUfuxlAsgZL1grDThDqiqu/HxK5ZPr9JGYi1qNY8qwyAcQ1CKtWB6',NULL,1,'2026-05-17','2026-05-24 08:16:31','2026-05-24 08:16:31');
/*!40000 ALTER TABLE `pegawai` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pimpinan`
--

DROP TABLE IF EXISTS `pimpinan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pimpinan` (
  `pimpinan_id` int unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `nip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `jenis_kelamin` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `no_hp` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `jabatan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `bidang_id` int unsigned DEFAULT NULL,
  `alamat` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `foto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `tanggal_terdaftar` date NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`pimpinan_id`),
  UNIQUE KEY `nip` (`nip`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pimpinan`
--

LOCK TABLES `pimpinan` WRITE;
/*!40000 ALTER TABLE `pimpinan` DISABLE KEYS */;
INSERT INTO `pimpinan` VALUES (3,'Arif Rahman Hakim, S.STP.','198304082005011003','Laki-laki','081250000103','Kepala Bidang Keuangan',2,'Jl. Soekarno Hatta No. 31, Kecamatan Lowokwaru, Kota Malang','pimpinan1@malasngoding.com','$2y$10$KBzegPfjMvVcq8bdE4u47OWxTNMecrevQce/C2yJOjrH.Vg69AMp.',NULL,1,'2026-01-03','2026-05-23 05:31:39','2026-05-23 10:35:25'),(5,'Mochamad Yusuf Kurniawan, M.M.','198709102010011005','Laki-laki','081250000105','Kepala Bidang IT',1,'Jl. Raya Langsep No. 19, Kecamatan Sukun, Kota Malang','pimpinan2@malasngoding.com','$2y$10$ASlrfTexqB7qUTyamvZ75ehIlBX9LBxCakxiAUmSAsGgxg7TQRNDC',NULL,1,'2026-01-04','2026-05-23 05:31:39','2026-05-23 10:28:03');
/*!40000 ALTER TABLE `pimpinan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `proyek`
--

DROP TABLE IF EXISTS `proyek`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `proyek` (
  `proyek_id` int unsigned NOT NULL AUTO_INCREMENT,
  `bidang_id` int unsigned NOT NULL,
  `pimpinan_id` int unsigned NOT NULL,
  `nama_proyek` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `deskripsi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `tanggal_mulai` date NOT NULL,
  `deadline` date DEFAULT NULL,
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'berjalan',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`proyek_id`),
  KEY `bidang_id` (`bidang_id`),
  KEY `pimpinan_id` (`pimpinan_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `proyek`
--

LOCK TABLES `proyek` WRITE;
/*!40000 ALTER TABLE `proyek` DISABLE KEYS */;
INSERT INTO `proyek` VALUES (1,2,3,'Pembuatan website ekinerja dan task management','Website ini digunakan untuk memudahkan manajemen tugas pegawai dan monitoring perkembangan proyek','2026-05-24','2026-06-30','berjalan','2026-05-24 05:04:38','2026-05-24 05:04:38'),(4,2,3,'Pembuatan Laporan Akhir Tahun','Laporan penerimaan perusahaan tahun 2026','2026-05-24','2026-05-31','berjalan','2026-05-24 12:46:38','2026-05-24 12:46:38'),(6,1,5,'Optimalisasi Layanan Sistem Informasi Internal','Proyek peningkatan kualitas layanan sistem informasi, monitoring infrastruktur, dan dukungan teknis bidang IT.','2026-05-25','2026-06-10','berjalan','2026-05-24 08:40:16','2026-05-24 08:40:16');
/*!40000 ALTER TABLE `proyek` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `proyek_task`
--

DROP TABLE IF EXISTS `proyek_task`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `proyek_task` (
  `proyek_task_id` int unsigned NOT NULL AUTO_INCREMENT,
  `proyek_id` int unsigned NOT NULL,
  `pegawai_id` int unsigned NOT NULL,
  `judul_task` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `deskripsi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `deadline` date DEFAULT NULL,
  `prioritas` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'sedang',
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'menunggu',
  `started_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`proyek_task_id`),
  KEY `proyek_id` (`proyek_id`),
  KEY `pegawai_id` (`pegawai_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `proyek_task`
--

LOCK TABLES `proyek_task` WRITE;
/*!40000 ALTER TABLE `proyek_task` DISABLE KEYS */;
INSERT INTO `proyek_task` VALUES (1,1,1,'Desain tampilan UI/UX','Buat tampilan halaman login yang secure','2026-05-27','sedang','disetujui','2026-05-24 05:08:39','2026-05-24 05:07:18','2026-05-24 05:12:02'),(5,4,1,'Kumpulkan data penerimaan','Segera kumpulkan semua data penerimaan dari semua pemasukan perusahaan','2026-05-27','sedang','disetujui','2026-05-24 12:49:13','2026-05-24 12:47:22','2026-05-24 12:56:28'),(7,6,3,'Pengecekan Infrastruktur Jaringan','Melakukan pengecekan koneksi jaringan, perangkat router, switch, dan dokumentasi kondisi awal.','2026-05-29','tinggi','revisi',NULL,'2026-05-24 08:40:16','2026-05-24 15:56:02'),(8,6,3,'Penyusunan Laporan Gangguan IT','Merekap gangguan perangkat dan jaringan yang terjadi selama periode berjalan untuk bahan evaluasi.','2026-06-02','sedang','disetujui',NULL,'2026-05-24 08:40:16','2026-05-24 15:55:31'),(9,6,4,'Desain Tampilan Dashboard Monitoring','Membuat rancangan UI dashboard monitoring kinerja yang lebih mudah dibaca pimpinan.','2026-05-30','sedang','disetujui',NULL,'2026-05-24 08:40:16','2026-05-24 15:55:19'),(10,6,4,'Pembuatan Template Dokumen Digital','Menyiapkan template desain dokumen digital untuk kebutuhan publikasi internal bidang IT.','2026-06-03','rendah','disetujui',NULL,'2026-05-24 08:40:16','2026-05-24 15:55:08'),(11,6,5,'Pengembangan Modul Validasi Data','Membuat validasi tambahan pada modul input agar data yang tersimpan lebih konsisten.','2026-06-05','tinggi','disetujui',NULL,'2026-05-24 08:40:16','2026-05-24 15:54:59'),(12,6,6,'Analisis Kebutuhan Integrasi Sistem','Mengumpulkan kebutuhan integrasi data antar modul dan menyusun catatan teknis implementasi.','2026-06-04','sedang','disetujui',NULL,'2026-05-24 08:40:16','2026-05-24 15:54:51'),(13,6,3,'Siapkan database dummy untuk launching aplikasi','segera','2026-05-28','sedang','disetujui','2026-05-25 16:15:13','2026-05-25 16:14:23','2026-05-25 16:17:18');
/*!40000 ALTER TABLE `proyek_task` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `proyek_task_pekerjaan`
--

DROP TABLE IF EXISTS `proyek_task_pekerjaan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `proyek_task_pekerjaan` (
  `proyek_task_pekerjaan_id` int unsigned NOT NULL AUTO_INCREMENT,
  `proyek_task_id` int unsigned NOT NULL,
  `pegawai_id` int unsigned NOT NULL,
  `catatan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `lampiran` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `catatan_pimpinan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `reviewed_at` datetime DEFAULT NULL,
  `reviewed_by` int unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`proyek_task_pekerjaan_id`),
  KEY `proyek_task_id` (`proyek_task_id`),
  KEY `pegawai_id` (`pegawai_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `proyek_task_pekerjaan`
--

LOCK TABLES `proyek_task_pekerjaan` WRITE;
/*!40000 ALTER TABLE `proyek_task_pekerjaan` DISABLE KEYS */;
INSERT INTO `proyek_task_pekerjaan` VALUES (1,1,1,'Sudah beres dan sudah saya submit ke hosting, tolong bapak periksa','500e7b93dfc7f24aed50999cdddbd02d.png',2,'Tampilan kurang responsive di tablet','2026-05-24 05:10:45',3,'2026-05-24 05:09:22','2026-05-24 05:10:45'),(2,1,1,'Baik pak perbaikan responsive sudah dikerjakan, mohon diperiksa kembali',NULL,1,'bagus','2026-05-24 05:12:02',3,'2026-05-24 05:11:48','2026-05-24 05:12:02'),(4,5,1,'Berikut data laporan tahun 2026','41896731b3ff38908b4ee408d7a65b34.png',2,'Kurang lengkap bulan 1','2026-05-24 12:55:22',3,'2026-05-24 12:49:47','2026-05-24 12:55:22'),(5,5,1,'Baik pak berikut pembaharuan data yang sudah saya lakukan','2879fdcb2f2f48f7fe835888f3defa37.png',1,'bagus','2026-05-24 12:56:28',3,'2026-05-24 12:56:09','2026-05-24 12:56:28'),(6,7,3,'Pengecekan awal infrastruktur jaringan telah dilakukan. Kondisi router, switch, dan koneksi antar ruangan sudah didata untuk tindak lanjut optimasi.',NULL,2,'Tolong di cek kembali karena jaringan masih kurang stabil','2026-05-24 15:56:02',5,'2026-05-24 08:45:06','2026-05-24 15:56:02'),(7,8,3,'Data gangguan IT periode berjalan sudah direkap. Catatan kendala perangkat dan jaringan telah disusun sebagai bahan evaluasi pimpinan.',NULL,1,'','2026-05-24 15:55:31',5,'2026-05-24 08:45:06','2026-05-24 15:55:31'),(8,9,4,'Draft tampilan dashboard monitoring telah dibuat dengan fokus pada ringkasan status kegiatan, task, dan performa pegawai.',NULL,1,'','2026-05-24 15:55:19',5,'2026-05-24 08:45:06','2026-05-24 15:55:19'),(9,10,4,'Template dokumen digital untuk kebutuhan publikasi internal telah disiapkan dalam beberapa variasi layout sesuai kebutuhan bidang IT.',NULL,1,'','2026-05-24 15:55:08',5,'2026-05-24 08:45:06','2026-05-24 15:55:08'),(10,11,5,'Validasi tambahan pada modul input mulai diterapkan untuk memastikan field wajib, format data, dan status pekerjaan tersimpan lebih konsisten.',NULL,1,'','2026-05-24 15:54:59',5,'2026-05-24 08:45:06','2026-05-24 15:54:59'),(11,12,6,'Analisis kebutuhan integrasi antar modul telah disusun, termasuk alur data, kebutuhan validasi, dan daftar endpoint yang perlu disiapkan.',NULL,1,'','2026-05-24 15:54:51',5,'2026-05-24 08:45:06','2026-05-24 15:54:51'),(12,13,3,'Sudah selesai pak, berikut saya lampirkan','9b2023cf71b2bccabd44d631bde69720.webp',2,'oke terima kasih, tapi kurang lengkap','2026-05-25 16:16:21',5,'2026-05-25 16:15:47','2026-05-25 16:16:21'),(13,13,3,'baik. berikut sudah saya lengkapi pak.','97e5210c497e0a73e47181c7f1c652b0.png',1,'terima kasih','2026-05-25 16:17:18',5,'2026-05-25 16:17:03','2026-05-25 16:17:18');
/*!40000 ALTER TABLE `proyek_task_pekerjaan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `role` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'administrator',
  `cabang_id` int unsigned DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'Sulaiman Yusuf','admin@malasngoding.com','1778178074_6a1fd751d160a04c739a.png','$2y$10$psQwdQbXvotnPd2V7mZqg.tt..Z1LVES6sxZiCgrVaMBfU3WQHCFq','administrator',NULL,1,'2026-05-07 15:49:42','2026-05-08 03:19:58');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 */;

-- Dump completed on 2026-05-26 13:06:22
