-- 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_bank_pegawai`
--

DROP TABLE IF EXISTS `tb_bank_pegawai`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_bank_pegawai` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pegawai_id` int(10) unsigned DEFAULT NULL,
  `nama_bank` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nomor_rekening` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_rekening` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tb_bank_pegawai_pegawai_id_index` (`pegawai_id`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_bank_pegawai`
--

LOCK TABLES `tb_bank_pegawai` WRITE;
/*!40000 ALTER TABLE `tb_bank_pegawai` DISABLE KEYS */;
INSERT INTO `tb_bank_pegawai` VALUES (6,4,'BCA','3731224445','THOMAS BUDIMAN','2020-05-11 03:35:24','2020-05-11 03:35:24'),(9,7,'BCA','4211912388','USMAN GULTOM','2020-05-11 03:51:09','2020-05-11 03:51:09'),(10,8,'BCA','3422398373','ASIH SEPTIARINI','2020-05-11 03:59:30','2020-05-11 03:59:30'),(13,11,'BCA','3423370315','NATALIA KRISTINA','2020-05-11 04:08:42','2020-05-11 04:08:42'),(15,13,'BCA','3420068602','ROSMAWATI HUTABARAT','2020-05-11 04:13:12','2020-05-11 04:13:12'),(16,14,'BCA','8840530010','HORAS GULTOM','2020-05-11 04:15:15','2020-05-11 04:15:15'),(23,20,'BCA','0689053515','RUKMIDI KURNIA BUDI','2020-05-11 05:46:07','2020-05-11 05:46:07'),(24,21,'BCA','0657507583','TIMBUL SIMANGUNSONG','2020-05-11 07:19:37','2020-05-11 07:19:37'),(25,22,'BCA','4141642761','RUDY SARAGIH','2020-05-11 07:27:35','2020-05-11 07:27:35'),(26,23,'BCA','0650200713','REYNOLD  TOBING','2020-05-11 07:29:48','2020-05-11 07:29:48'),(28,25,'BCA','6610471844','RINA DAMERIA NAPITUPULU','2020-05-11 07:33:38','2020-05-11 07:33:38'),(29,26,'BCA','6790186778','ARIE MARTIN NAPITUPULU','2020-05-11 07:35:44','2020-05-11 07:35:44'),(30,27,'BCA','6330232496','SOPAR SILAEN','2020-05-11 07:37:21','2020-05-11 07:37:21'),(34,31,'BCA','3422999806','ANNA YULISCA','2020-05-11 07:43:55','2020-05-11 07:43:55'),(36,33,'BCA','5465125087','NOVIANTI SILALAHI','2020-05-11 07:48:11','2020-05-11 07:48:11'),(38,32,'BCA','3970083447','FEBRIANTI RATNASARI','2020-05-11 07:55:20','2020-05-11 07:55:20'),(43,1,'BCA','6310111820','HARDY BENRI SIMBOLON','2020-05-11 08:35:49','2020-05-11 08:35:49'),(44,2,'BCA','3422468703','IFAN JUNAEDI','2020-05-12 23:27:06','2020-05-12 23:27:06'),(45,3,'BCA','3423395415','ZULHALIM','2020-05-12 23:36:19','2020-05-12 23:36:19'),(46,5,'BCA','0050181171','IHSAN NUR','2020-05-12 23:37:11','2020-05-12 23:37:11'),(47,6,'BCA','0680028427','HETTY FARIDA','2020-05-12 23:37:46','2020-05-12 23:37:46'),(48,9,'BCA','6089127381','ANTON SIANIPAR','2020-05-12 23:38:29','2020-05-12 23:38:29'),(49,10,'BCA','6310295050','RACHMAWATY HAROEN','2020-05-12 23:39:15','2020-05-12 23:39:15'),(50,12,'MANDIRI','1230004899912','SUWARNO','2020-05-12 23:39:59','2020-05-12 23:39:59'),(51,15,'BCA','1650208010','ADE JEFRY','2020-05-12 23:40:46','2020-05-12 23:40:46'),(52,18,'BCA','1970554803','MULYANA','2020-05-12 23:41:22','2020-05-12 23:41:22'),(53,17,'BCA','0689102648','PAISAH','2020-05-12 23:42:13','2020-05-12 23:42:13'),(54,16,'BCA','0689053515','RUKMIDI KURNIA BUDI','2020-05-12 23:42:46','2020-05-12 23:42:46'),(55,19,'BCA','3570411089','SUSI CAHYANTI','2020-05-12 23:43:28','2020-05-12 23:43:28'),(56,24,'BCA','0751176839','LOEKY RONO PRADOPO','2020-05-12 23:44:21','2020-05-12 23:44:21'),(57,28,'BCA','3421868814','TITI ASLAH','2020-05-12 23:45:05','2020-05-12 23:45:05'),(59,30,'MANDIRI','1230004898757','ZULKARNAIN','2020-05-12 23:46:32','2020-05-12 23:46:32'),(62,36,'BCA','0689101340','SURATMI','2020-05-12 23:49:30','2020-05-12 23:49:30'),(63,37,'BCA','0689118749','ASEP APIDIN','2020-05-12 23:51:37','2020-05-12 23:51:37'),(64,38,'BCA','7360455801','EMBAD','2020-05-12 23:52:08','2020-05-12 23:52:08'),(75,39,'BCA','0600075560','SUGENG WALUYO','2020-10-10 08:03:31','2020-10-10 08:03:31'),(78,34,'BCA','1271259455','LIA / ANAK','2020-10-24 18:45:07','2020-10-24 18:45:07'),(79,29,'BCA','3422624128','INDAH PURWANI','2020-10-24 18:45:43','2020-10-24 18:45:43'),(80,35,'BCA','3423348433','SUSANTO','2020-10-24 18:46:21','2020-10-24 18:46:21');
/*!40000 ALTER TABLE `tb_bank_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:24
