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

DROP TABLE IF EXISTS `tb_bank_dosen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_bank_dosen` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `dosen_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_dosen_dosen_id_index` (`dosen_id`)
) ENGINE=InnoDB AUTO_INCREMENT=154 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_bank_dosen`
--

LOCK TABLES `tb_bank_dosen` WRITE;
/*!40000 ALTER TABLE `tb_bank_dosen` DISABLE KEYS */;
INSERT INTO `tb_bank_dosen` VALUES (2,2,'Mandiri','1234567890','ANTON ZULKARNAIN S','2020-02-09 18:00:01','2020-02-09 18:00:01'),(3,2,'BCA','987654321','ANTON ZULKARNAIN','2020-02-09 18:00:01','2020-02-09 18:00:01'),(12,6,'BCA','3422468703','Ifan Junaedi','2020-02-27 07:51:19','2020-02-27 07:51:19'),(14,8,'BCA','3423395415','Zulhalim','2020-03-25 09:18:45','2020-03-25 09:18:45'),(15,9,'BCA','2211101107','AGUS SULISTYANTO','2020-03-26 05:36:13','2020-03-26 05:36:13'),(16,10,'BCA','2731558622','DIMAS  PRASETYO  TEGAR','2020-03-26 05:44:31','2020-03-26 05:44:31'),(17,11,'BCA','6870740466','SPENCER RIPELHOT HUTAPEA','2020-03-26 05:46:20','2020-03-26 05:46:20'),(20,14,'BCA','6310111820','HARDY BENRY','2020-03-26 10:53:50','2020-03-26 10:53:50'),(22,16,'BCA','4212748319','IRMA MURTI KUSUMA','2020-03-26 11:38:06','2020-03-26 11:38:06'),(23,17,'BCA','7651012094','ITO RIRIS IMMASARI','2020-03-26 11:39:24','2020-03-26 11:39:24'),(25,19,'MANDIRI','1290004454787','MOHAMMAD  NARDJI','2020-03-26 11:49:15','2020-03-26 11:49:15'),(26,20,'BCA','6330714971','MURYAN  AWALUDDIN','2020-03-26 11:51:08','2020-03-26 11:51:08'),(27,21,'BCA','0940387493','PENIARSIH','2020-03-26 11:51:57','2020-03-26 11:51:57'),(28,22,'MANDIRI','207901000063568','PIRMA SIMBOLON','2020-03-26 11:54:16','2020-03-26 11:54:16'),(29,23,'BCA','6310295050','RACHMAWATY  HAROEN','2020-03-26 11:56:37','2020-03-26 11:56:37'),(31,25,'BCA','0751217861','RUMADI HARTAWAN','2020-03-26 11:58:44','2020-03-26 11:58:44'),(33,26,'BCA','3422385468','SITA  DEWI','2020-03-26 12:01:03','2020-03-26 12:01:03'),(34,27,'BCA','8555068154','SITI ROHAYYA','2020-03-26 12:01:49','2020-03-26 12:01:49'),(37,30,'BCA','3731224445','THOMAS BUDIMAN','2020-03-26 12:09:31','2020-03-26 12:09:31'),(41,34,'BCA','3971263430','URIM CARRY','2020-03-26 12:46:38','2020-03-26 12:46:38'),(42,35,'BCA','4211912388','USMAN  GULTOM','2020-03-26 12:47:31','2020-03-26 12:47:31'),(43,36,'BCA','0741175273','VERDI YASIN','2020-03-26 12:48:45','2020-03-26 12:48:45'),(44,37,'BCA','4661242382','YUDI HARIANTO','2020-03-26 12:49:39','2020-03-26 12:49:39'),(45,12,'BCA','0761145117','Ester','2020-03-26 14:00:00','2020-03-26 14:00:00'),(47,38,'BCA','5780302331','ADRIAN','2020-03-27 14:00:58','2020-03-27 14:00:58'),(49,40,'BCA','3423002588','BERTHA  ELVY','2020-03-27 23:33:11','2020-03-27 23:33:11'),(51,42,'BCA','6070400161','CHADAFY MARADEN','2020-03-27 23:36:55','2020-03-27 23:36:55'),(52,43,'BCA','3351382064','DAVID ISKANDAR','2020-03-27 23:38:03','2020-03-27 23:38:03'),(54,45,'BCA','0848166286','DONGSINA NAPITUPULU','2020-03-27 23:41:38','2020-03-27 23:41:38'),(55,46,'BCA','6340099883','DWI LISTYOWATI','2020-03-27 23:51:56','2020-03-27 23:51:56'),(57,48,'BCA','8410995493','FEBY KINANDA','2020-03-27 23:54:00','2020-03-27 23:54:00'),(58,49,'BCA','7410616992','FRANKLIN ASIDO','2020-03-27 23:55:16','2020-03-27 23:55:16'),(59,50,'BCA','3421879042','GLORY  KOESWARDHANA','2020-03-27 23:58:55','2020-03-27 23:58:55'),(61,52,'MANDIRI','1030099616407','ISMAN PEPADRI','2020-03-28 02:48:16','2020-03-28 02:48:16'),(62,53,'BCA','7420057576','JANA SANDRA,','2020-03-28 03:48:43','2020-03-28 03:48:43'),(63,54,'BCA','0751176839','LOEKY RONO','2020-03-28 03:50:21','2020-03-28 03:50:21'),(64,55,'BCA','6870015125','KUNCORO WIBOWO','2020-03-28 03:51:46','2020-03-28 03:51:46'),(65,56,'BCA','5385023224','KUNCU SARAGIH','2020-03-28 03:52:46','2020-03-28 03:52:46'),(66,57,'BCA','3423106448','MALEM UKUR SIMANGUNSONG','2020-03-28 03:54:22','2020-03-28 03:54:22'),(67,58,'BCA','5220685162','MANIAR ARNIDA SAMOSIR','2020-03-28 03:55:07','2020-03-28 03:55:07'),(68,59,'BCA','0','Ningsih','2020-03-28 04:09:19','2020-03-28 04:09:19'),(69,60,'BCA','7050112521','OKTAVIA MARPAUNG','2020-03-28 04:10:23','2020-03-28 04:10:23'),(70,61,'BCA','0940787131','RACHMATIKA IRFANI','2020-03-28 04:14:52','2020-03-28 04:14:52'),(71,62,'BCA','3420069099','RIYANTO WUJARSO','2020-03-28 04:21:06','2020-03-28 04:21:06'),(73,64,'BCA','4141642761','RUDI HEDIANTO','2020-03-28 04:23:36','2020-03-28 04:23:36'),(75,66,'BCA','0844352138','SAPRUDIN','2020-03-28 04:27:18','2020-03-28 04:27:18'),(76,67,'BCA','0050566005','SLAMET HADIYONO','2020-03-28 04:32:53','2020-03-28 04:32:53'),(77,68,'BCA','6330232496','SOFAR SILAEN','2020-03-28 04:34:40','2020-03-28 04:34:40'),(79,70,'BCA','0657507583','TIMBUL SIMANGUNSONG','2020-03-28 04:37:55','2020-03-28 04:37:55'),(80,71,'BCA','3421868814','TITI ASLAH','2020-03-28 04:42:11','2020-03-28 04:42:11'),(81,72,'BCA','3421661560','TIUR N TOBING','2020-03-28 04:43:08','2020-03-28 04:43:08'),(82,73,'BCA','6610149420','TUFRIDA','2020-03-28 04:44:54','2020-03-28 04:44:54'),(83,74,'BCA','8810993830','TUMPAL SINAGA','2020-03-28 04:45:48','2020-03-28 04:45:48'),(84,75,'BCA','3051341773','VICTOR','2020-03-28 04:46:56','2020-03-28 04:46:56'),(85,76,'BCA','5440043366','VIVI ADEYANI','2020-03-28 04:48:07','2020-03-28 04:48:07'),(86,77,'BCA','3421047420','JOHAN HURSEPUNY','2020-03-28 08:31:31','2020-03-28 08:31:31'),(90,3,'BCA','0946508840','ANDHIKA NAPITUPULU','2020-03-30 05:56:58','2020-03-30 05:56:58'),(91,79,'BCA','6790186778','ARIE MARTIN','2020-04-02 12:15:24','2020-04-02 12:15:24'),(93,81,'BCA','0689127381','Anton Zulkarnain Sianipar','2020-04-28 13:44:30','2020-04-28 13:44:30'),(94,80,'bca','0161616175','denny','2020-04-29 04:18:36','2020-04-29 04:18:36'),(98,47,'BNI','0018173156','EKRON SITANGGANG','2020-05-06 03:14:52','2020-05-06 03:14:52'),(99,63,'BNI','0010225706','RUTH LAM DORMA','2020-05-06 03:16:09','2020-05-06 03:16:09'),(103,82,'MANDIRI','58000290343','RAHMAT SYAH','2020-05-17 03:50:19','2020-05-17 03:50:19'),(104,83,'BCA','0438316701','YUANA','2020-05-17 04:02:13','2020-05-17 04:02:13'),(111,84,'bca','048454','hahah','2020-08-17 18:25:14','2020-08-17 18:25:14'),(112,85,'  Akaka','646','baba','2020-08-17 18:27:45','2020-08-17 18:27:45'),(113,86,'BCA','2761366132','Erie Hotman H Tobing','2020-09-27 08:08:10','2020-09-27 08:08:10'),(125,7,'BCA','0942194402','Balthasar Sebastian','2020-11-06 13:26:55','2020-11-06 13:26:55'),(128,24,'BCA','0060474052','RADIAN WARDI','2020-11-25 14:51:38','2020-11-25 14:51:38'),(129,39,'BCA','5000497306','Annisa Vini Cahyati','2020-11-27 09:59:33','2020-11-27 09:59:33'),(130,44,'BCA','3420429940','DIANA SETIYO DEWI','2020-11-27 10:00:45','2020-11-27 10:00:45'),(131,51,'BCA','3420429800','IBRAHIM','2020-11-27 10:01:09','2020-11-27 10:01:09'),(132,33,'BCA','4372604143','TRIO HARDIYANTO','2020-11-27 22:16:04','2020-11-27 22:16:04'),(133,32,'BCA','3420429796','TOMI LOVERI','2020-11-27 22:20:39','2020-11-27 22:20:39'),(134,18,'BCA','6630911131','JUSMAITA','2020-11-27 22:23:24','2020-11-27 22:23:24'),(135,65,'BCA','0948101133','SAMUEL','2020-11-28 09:35:44','2020-11-28 09:35:44'),(136,13,'BCA','6281604080','FANNY EKA','2020-11-28 10:26:39','2020-11-28 10:26:39'),(137,69,'BCA','1662481941','SOFYAN HADI','2020-11-29 21:56:17','2020-11-29 21:56:17'),(138,41,'BCA','2302700185','BINTON  SIBURIAN','2020-11-30 09:59:56','2020-11-30 09:59:56'),(139,4,'BCA','6610471844','Rina Dameria Napitupulu','2020-11-30 10:01:42','2020-11-30 10:01:42'),(143,91,'BCA','3422398373','ASIH','2020-11-30 19:05:31','2020-11-30 19:05:31'),(144,31,'BCA','3420430751','TOMI DEFISA','2020-11-30 19:09:14','2020-11-30 19:09:14'),(145,28,'BCA','7635147458','SUTISNA','2020-11-30 20:20:43','2020-11-30 20:20:43'),(146,89,'BCA','0600075560','SUGENG WALUYO','2020-11-30 20:24:58','2020-11-30 20:24:58'),(147,88,'BCA','5405020413','DANIEL ROLAND HASIBUAN','2020-11-30 20:25:17','2020-11-30 20:25:17'),(148,87,'BCA','3422939340','TITIES HARJANTI','2020-11-30 20:27:12','2020-11-30 20:27:12'),(149,5,'BCA','6540051575','REVAN ANDHITYARA','2020-11-30 20:27:28','2020-11-30 20:27:28'),(150,15,'BCA','2540291643','Raden Lintang Kusumawardhono','2020-12-01 06:36:15','2020-12-01 06:36:15'),(151,90,'BCA','6030711881','Yola Rinayanti','2020-12-01 12:33:00','2020-12-01 12:33:00'),(152,29,'BCA','6825434449','TERI MENGKASRINAL','2020-12-01 12:33:37','2020-12-01 12:33:37'),(153,78,'BCA','7121807070','HENRYCH NAPITUPULU','2020-12-02 09:25:25','2020-12-02 09:25:25');
/*!40000 ALTER TABLE `tb_bank_dosen` 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:07
