-- MySQL dump 10.13  Distrib 8.0.22, for Win64 (x86_64)
--
-- Host: localhost    Database: keuangan_jayakarta
-- ------------------------------------------------------
-- Server version	5.7.32-0ubuntu0.18.04.1

/*!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 utf8 */;
/*!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 `tb_pinjaman_pegawai`
--

DROP TABLE IF EXISTS `tb_pinjaman_pegawai`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_pinjaman_pegawai` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pegawai_id` int(10) unsigned DEFAULT NULL,
  `nama_pinjaman` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jumlah` double(20,2) NOT NULL DEFAULT '0.00',
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tb_pinjaman_pegawai_pegawai_id_index` (`pegawai_id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_pinjaman_pegawai`
--

LOCK TABLES `tb_pinjaman_pegawai` WRITE;
/*!40000 ALTER TABLE `tb_pinjaman_pegawai` DISABLE KEYS */;
INSERT INTO `tb_pinjaman_pegawai` VALUES (6,10,'PINJAMAN KOPERASI',14700000.00,'Belum Lunas','rachmawaty-haroen-mm-pinjaman-koperasi','2020-05-11 04:42:14','2020-05-11 04:42:14'),(7,5,'PINJAMAN KOPERASI',6300000.00,'Belum Lunas','ihsan-nur-se-pinjaman-koperasi','2020-05-12 22:55:41','2020-05-12 22:55:41'),(8,5,'PINJAMAN YAYASAN',24000000.00,'Belum Lunas','ihsan-nur-se-pinjaman-yayasan','2020-05-12 22:55:41','2020-05-12 22:55:41'),(9,6,'PINJAMAN KOPERASI',8400000.00,'Belum Lunas','hetty-farida-se-pinjaman-koperasi','2020-05-12 22:58:04','2020-05-12 22:58:04'),(10,8,'PINJAMAN KOPERASI',11550000.00,'Belum Lunas','asih-septiarini-se-pinjaman-koperasi','2020-05-12 22:58:47','2020-05-12 22:58:47'),(11,7,'PINJAMAN KOPERASI',4725000.00,'Belum Lunas','usman-gultom-m-kom-pinjaman-koperasi','2020-05-12 22:59:13','2020-05-12 22:59:13'),(12,11,'PINJAMAN KOPERASI',12600000.00,'Belum Lunas','natalia-kristina-pinjaman-koperasi','2020-05-12 22:59:50','2020-05-12 22:59:50'),(13,11,'PINJAMAN YAYASAN',7000000.00,'Belum Lunas','natalia-kristina-pinjaman-yayasan','2020-05-12 22:59:50','2020-05-12 22:59:50'),(14,9,'PINJAMAN KOPERASI',3360000.00,'Belum Lunas','anton-sianipar-m-pd-pinjaman-koperasi','2020-05-12 23:00:58','2020-05-12 23:00:58'),(15,9,'PINJAMAN YAYASAN',10000000.00,'Belum Lunas','anton-sianipar-m-pd-pinjaman-yayasan','2020-05-12 23:00:58','2020-05-12 23:00:58'),(16,14,'PINJAMAN KOPERASI',8400000.00,'Belum Lunas','horas-gultom-pinjaman-koperasi','2020-05-12 23:01:43','2020-05-12 23:01:43'),(17,15,'PINJAMAN KOPERASI',2520000.00,'Belum Lunas','ade-jefry-pinjaman-koperasi','2020-05-12 23:02:11','2020-05-12 23:02:11'),(18,18,'PINJAMAN KOPERASI',2835000.00,'Belum Lunas','mulyana-pinjaman-koperasi','2020-05-12 23:02:45','2020-05-12 23:02:45'),(19,17,'PINJAMAN KOPERASI',6720000.00,'Belum Lunas','paisah-pinjaman-koperasi','2020-05-12 23:03:11','2020-05-12 23:03:11'),(20,16,'PINJAMAN KOPERASI',525000.00,'Belum Lunas','rukmidi-kurnia-budi-pinjaman-koperasi','2020-05-12 23:03:46','2020-05-12 23:03:46'),(21,16,'PINJAMAN YAYASAN',8500000.00,'Belum Lunas','rukmidi-kurnia-budi-pinjaman-yayasan','2020-05-12 23:03:46','2020-05-12 23:03:46'),(22,23,'PINJAMAN KOPERASI',3150000.00,'Belum Lunas','drs-reynold-l-tobing-ak-pinjaman-koperasi','2020-05-12 23:04:42','2020-05-12 23:04:42'),(23,23,'PINJAMAN YAYASAN',71000000.00,'Belum Lunas','drs-reynold-l-tobing-ak-pinjaman-yayasan','2020-05-12 23:04:42','2020-05-12 23:04:42'),(24,25,'PINJAMAN KOPERASI',18900000.00,'Belum Lunas','rina-dameria-napitupulu-mm-pinjaman-koperasi','2020-05-12 23:05:16','2020-05-12 23:05:16'),(25,28,'PINJAMAN KOPERASI',9450000.00,'Belum Lunas','titi-aslah-m-ak-pinjaman-koperasi','2020-05-12 23:06:57','2020-05-12 23:06:57'),(26,28,'PINJAMAN YAYASAN',3000000.00,'Belum Lunas','titi-aslah-m-ak-pinjaman-yayasan','2020-05-12 23:06:57','2020-05-12 23:06:57'),(27,30,'PINJAMAN KOPERASI',15750000.00,'Belum Lunas','zulkarnain-pinjaman-koperasi','2020-05-12 23:07:44','2020-05-12 23:07:44'),(28,30,'PINJAMAN YAYASAN',6000000.00,'Belum Lunas','zulkarnain-pinjaman-yayasan','2020-05-12 23:07:44','2020-05-12 23:07:44'),(29,31,'PINJAMAN KOPERASI',14700000.00,'Belum Lunas','anna-yulisca-pinjaman-koperasi','2020-05-12 23:08:38','2020-05-12 23:08:38'),(30,31,'PINJAMAN YAYASAN',47500000.00,'Belum Lunas','anna-yulisca-pinjaman-yayasan','2020-05-12 23:08:38','2020-05-12 23:08:38'),(32,34,'PINJAMAN KOPERASI',4200000.00,'Belum Lunas','supoco-pinjaman-koperasi','2020-05-12 23:10:55','2020-05-12 23:10:55'),(33,35,'PINJAMAN KOPERASI',5145000.00,'Belum Lunas','susanto-pinjaman-koperasi','2020-05-12 23:11:25','2020-05-12 23:11:25'),(34,36,'PINJAMAN KOPERASI',4725000.00,'Belum Lunas','suratmi-pinjaman-koperasi','2020-05-12 23:12:06','2020-05-12 23:12:06'),(35,36,'PINJAMAN YAYASAN',1650000.00,'Belum Lunas','suratmi-pinjaman-yayasan','2020-05-12 23:12:06','2020-05-12 23:12:06'),(37,37,'PINJAMAN KOPERASI',4200000.00,'Belum Lunas','asep-apidin-pinjaman-koperasi','2020-05-12 23:13:00','2020-05-12 23:13:00'),(38,38,'PINJAMAN KOPERASI',4200000.00,'Belum Lunas','embad-pinjaman-koperasi','2020-05-12 23:13:23','2020-05-12 23:13:23'),(39,5,'PINJAMAN KOPERASI',5250000.00,'Belum Lunas','ihsan-nur-se-pinjaman-koperasi-1','2020-06-28 14:37:03','2020-06-28 14:37:03'),(40,12,'PINJAMAN KOPERASI',10500000.00,'Belum Lunas','suwarno-a-md-pinjaman-koperasi','2020-06-28 15:02:44','2020-06-28 15:02:44'),(41,23,'PINJAMAN KOPERASI',3780000.00,'Belum Lunas','drs-reynold-l-tobing-ak-pinjaman-koperasi-1','2020-06-29 02:38:47','2020-06-29 02:38:47'),(42,13,'PINJAMAN KOPERASI',5250000.00,'Belum Lunas','rosmawati-hutabarat-pinjaman-koperasi','2020-08-25 02:33:24','2020-08-25 02:33:24'),(43,33,'PINJAMAN KOPERASI',4725000.00,'Belum Lunas','novianti-silalahi-se-pinjaman-koperasi','2020-08-25 02:33:56','2020-10-24 19:13:19'),(44,32,'PINJAMAN KOPERASI',10500000.00,'Belum Lunas','febrianti-ratnasari-se-pinjaman-koperasi','2020-11-27 14:11:07','2020-11-27 14:11:07');
/*!40000 ALTER TABLE `tb_pinjaman_pegawai` 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 2020-12-07 11:33:27
