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

DROP TABLE IF EXISTS `tb_pembayaran_honor_detail_tmp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_pembayaran_honor_detail_tmp` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tb_pembayaran_honor_id` int(10) unsigned NOT NULL,
  `tb_honor_dosen_id` int(10) unsigned NOT NULL,
  `jumlah` int(11) NOT NULL DEFAULT '0',
  `total` double(20,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tb_pembayaran_honor_detail_tmp_tb_pembayaran_honor_id_index` (`tb_pembayaran_honor_id`),
  KEY `tb_pembayaran_honor_detail_tmp_tb_honor_dosen_id_index` (`tb_honor_dosen_id`)
) ENGINE=InnoDB AUTO_INCREMENT=362 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_pembayaran_honor_detail_tmp`
--

LOCK TABLES `tb_pembayaran_honor_detail_tmp` WRITE;
/*!40000 ALTER TABLE `tb_pembayaran_honor_detail_tmp` DISABLE KEYS */;
INSERT INTO `tb_pembayaran_honor_detail_tmp` VALUES (8,4,3,0,100000.00,'2020-02-09 18:09:36','2020-02-09 18:09:36'),(9,4,4,0,150000.00,'2020-02-09 18:09:36','2020-02-09 18:09:36'),(13,5,11,0,100000.00,'2020-02-10 08:22:51','2020-02-10 08:22:51'),(14,5,12,0,50000.00,'2020-02-10 08:22:51','2020-02-10 08:22:51'),(15,6,15,0,100000.00,'2020-02-15 08:28:34','2020-02-15 08:28:34'),(16,6,16,0,150000.00,'2020-02-15 08:28:34','2020-02-15 08:28:34'),(17,7,17,0,125000.00,'2020-02-15 09:32:28','2020-02-15 09:32:28'),(18,7,18,0,225000.00,'2020-02-15 09:32:28','2020-02-15 09:32:28'),(43,11,24,0,125000.00,'2020-03-26 10:25:10','2020-03-26 10:25:10'),(44,11,25,0,100000.00,'2020-03-26 10:25:10','2020-03-26 10:25:10'),(45,12,24,0,125000.00,'2020-03-26 10:26:17','2020-03-26 10:26:17'),(46,12,25,0,100000.00,'2020-03-26 10:26:17','2020-03-26 10:26:17'),(47,13,3,0,100000.00,'2020-03-26 10:27:23','2020-03-26 10:27:23'),(48,13,4,0,150000.00,'2020-03-26 10:27:23','2020-03-26 10:27:23'),(54,16,21,0,100000.00,'2020-03-26 10:38:47','2020-03-26 10:38:47'),(55,17,21,0,100000.00,'2020-03-26 10:39:13','2020-03-26 10:39:13'),(56,18,21,0,100000.00,'2020-03-26 10:40:12','2020-03-26 10:40:12'),(60,21,27,0,200000.00,'2020-03-26 13:36:05','2020-03-26 13:36:05'),(61,22,63,0,100000.00,'2020-03-26 14:15:53','2020-03-26 14:15:53'),(94,28,34,0,100000.00,'2020-03-27 06:48:52','2020-03-27 06:48:52'),(95,28,35,0,100000.00,'2020-03-27 06:48:52','2020-03-27 06:48:52'),(98,30,37,0,100000.00,'2020-03-27 07:02:55','2020-03-27 07:02:55'),(100,31,38,0,100000.00,'2020-03-27 07:56:43','2020-03-27 07:56:43'),(102,32,39,0,100000.00,'2020-03-27 08:02:28','2020-03-27 08:02:28'),(109,33,41,0,100000.00,'2020-03-27 10:24:26','2020-03-27 10:24:26'),(110,33,42,0,175000.00,'2020-03-27 10:24:26','2020-03-27 10:24:26'),(111,34,43,0,100000.00,'2020-03-27 10:25:51','2020-03-27 10:25:51'),(116,35,44,0,100000.00,'2020-03-27 10:33:38','2020-03-27 10:33:38'),(117,35,45,0,100000.00,'2020-03-27 10:33:38','2020-03-27 10:33:38'),(121,38,51,0,100000.00,'2020-03-27 10:38:35','2020-03-27 10:38:35'),(123,39,52,0,100000.00,'2020-03-27 10:40:49','2020-03-27 10:40:49'),(126,40,53,0,100000.00,'2020-03-27 10:43:38','2020-03-27 10:43:38'),(128,41,54,0,100000.00,'2020-03-27 10:48:41','2020-03-27 10:48:41'),(130,42,55,0,100000.00,'2020-03-27 10:51:13','2020-03-27 10:51:13'),(132,43,64,0,100000.00,'2020-03-27 11:09:26','2020-03-27 11:09:26'),(142,45,58,0,100000.00,'2020-03-27 12:30:40','2020-03-27 12:30:40'),(143,45,59,0,100000.00,'2020-03-27 12:30:40','2020-03-27 12:30:40'),(158,46,60,0,125000.00,'2020-03-27 13:14:33','2020-03-27 13:14:33'),(159,46,61,0,175000.00,'2020-03-27 13:14:33','2020-03-27 13:14:33'),(162,47,62,0,100000.00,'2020-03-27 13:19:10','2020-03-27 13:19:10'),(191,14,3,0,100000.00,'2020-03-27 13:42:37','2020-03-27 13:42:37'),(192,14,4,0,150000.00,'2020-03-27 13:42:37','2020-03-27 13:42:37'),(193,48,65,0,100000.00,'2020-03-28 04:49:22','2020-03-28 04:49:22'),(194,49,66,0,100000.00,'2020-03-28 04:51:07','2020-03-28 04:51:07'),(205,50,67,0,125000.00,'2020-03-28 05:29:38','2020-03-28 05:29:38'),(206,50,68,0,125000.00,'2020-03-28 05:29:38','2020-03-28 05:29:38'),(207,51,69,0,125000.00,'2020-03-28 05:44:07','2020-03-28 05:44:07'),(208,51,70,0,175000.00,'2020-03-28 05:44:07','2020-03-28 05:44:07'),(209,52,71,0,100000.00,'2020-03-28 05:46:02','2020-03-28 05:46:02'),(210,53,72,0,100000.00,'2020-03-28 05:49:37','2020-03-28 05:49:37'),(211,54,73,0,100000.00,'2020-03-28 05:52:26','2020-03-28 05:52:26'),(212,54,74,0,100000.00,'2020-03-28 05:52:26','2020-03-28 05:52:26'),(213,19,26,0,100000.00,'2020-03-28 05:56:40','2020-03-28 05:56:40'),(214,55,75,0,150000.00,'2020-03-28 05:58:28','2020-03-28 05:58:28'),(215,55,76,0,250000.00,'2020-03-28 05:58:28','2020-03-28 05:58:28'),(220,56,77,0,125000.00,'2020-03-28 06:04:34','2020-03-28 06:04:34'),(221,56,78,0,175000.00,'2020-03-28 06:04:34','2020-03-28 06:04:34'),(222,57,79,0,100000.00,'2020-03-28 06:06:04','2020-03-28 06:06:04'),(224,26,32,0,100000.00,'2020-03-28 06:08:24','2020-03-28 06:08:24'),(226,58,80,0,100000.00,'2020-03-28 06:10:27','2020-03-28 06:10:27'),(228,59,81,0,100000.00,'2020-03-28 06:41:25','2020-03-28 06:41:25'),(233,60,82,0,125000.00,'2020-03-28 06:54:42','2020-03-28 06:54:42'),(234,60,83,0,175000.00,'2020-03-28 06:54:42','2020-03-28 06:54:42'),(239,61,84,0,100000.00,'2020-03-28 06:58:42','2020-03-28 06:58:42'),(241,27,33,0,100000.00,'2020-03-28 08:24:39','2020-03-28 08:24:39'),(242,62,85,0,100000.00,'2020-03-28 08:26:49','2020-03-28 08:26:49'),(243,63,86,0,100000.00,'2020-03-28 08:29:02','2020-03-28 08:29:02'),(244,64,121,0,100000.00,'2020-03-28 08:32:33','2020-03-28 08:32:33'),(245,64,122,0,150000.00,'2020-03-28 08:32:33','2020-03-28 08:32:33'),(248,29,36,0,100000.00,'2020-03-28 08:35:11','2020-03-28 08:35:11'),(249,65,89,0,100000.00,'2020-03-28 08:49:08','2020-03-28 08:49:08'),(252,66,90,0,125000.00,'2020-03-28 09:01:26','2020-03-28 09:01:26'),(253,66,91,0,150000.00,'2020-03-28 09:01:26','2020-03-28 09:01:26'),(258,68,92,0,100000.00,'2020-03-28 09:24:17','2020-03-28 09:24:17'),(259,69,93,0,100000.00,'2020-03-28 09:26:06','2020-03-28 09:26:06'),(260,70,94,0,100000.00,'2020-03-28 09:27:04','2020-03-28 09:27:04'),(261,71,95,0,100000.00,'2020-03-28 09:29:58','2020-03-28 09:29:58'),(262,72,40,0,250000.00,'2020-03-28 09:32:47','2020-03-28 09:32:47'),(263,73,96,0,100000.00,'2020-03-28 09:33:49','2020-03-28 09:33:49'),(268,74,17,0,125000.00,'2020-03-28 09:45:40','2020-03-28 09:45:40'),(269,74,18,0,225000.00,'2020-03-28 09:45:40','2020-03-28 09:45:40'),(270,75,97,0,125000.00,'2020-03-28 09:48:20','2020-03-28 09:48:20'),(271,75,98,0,125000.00,'2020-03-28 09:48:20','2020-03-28 09:48:20'),(272,76,100,0,150000.00,'2020-03-28 09:49:29','2020-03-28 09:49:29'),(273,76,101,0,200000.00,'2020-03-28 09:49:29','2020-03-28 09:49:29'),(274,77,102,0,100000.00,'2020-03-28 10:01:28','2020-03-28 10:01:28'),(277,36,48,0,125000.00,'2020-03-28 10:11:39','2020-03-28 10:11:39'),(278,36,49,0,150000.00,'2020-03-28 10:11:39','2020-03-28 10:11:39'),(279,37,50,0,100000.00,'2020-03-28 10:14:27','2020-03-28 10:14:27'),(280,78,106,0,125000.00,'2020-03-28 10:18:00','2020-03-28 10:18:00'),(281,78,107,0,125000.00,'2020-03-28 10:18:00','2020-03-28 10:18:00'),(286,80,111,0,100000.00,'2020-03-28 10:23:11','2020-03-28 10:23:11'),(287,80,112,0,150000.00,'2020-03-28 10:23:11','2020-03-28 10:23:11'),(288,81,113,0,100000.00,'2020-03-28 10:28:51','2020-03-28 10:28:51'),(289,81,114,0,150000.00,'2020-03-28 10:28:51','2020-03-28 10:28:51'),(290,82,115,0,100000.00,'2020-03-28 10:30:08','2020-03-28 10:30:08'),(291,82,116,0,100000.00,'2020-03-28 10:30:08','2020-03-28 10:30:08'),(292,83,117,0,150000.00,'2020-03-28 10:31:02','2020-03-28 10:31:02'),(293,83,118,0,200000.00,'2020-03-28 10:31:02','2020-03-28 10:31:02'),(294,84,119,0,100000.00,'2020-03-28 10:33:57','2020-03-28 10:33:57'),(296,86,108,0,100000.00,'2020-03-28 14:02:37','2020-03-28 14:02:37'),(297,44,57,0,100000.00,'2020-03-28 14:08:51','2020-03-28 14:08:51'),(312,87,105,0,100000.00,'2020-03-29 07:05:31','2020-03-29 07:05:31'),(321,96,103,0,100000.00,'2020-03-29 08:21:33','2020-03-29 08:21:33'),(322,96,104,0,100000.00,'2020-03-29 08:21:33','2020-03-29 08:21:33'),(323,97,99,0,100000.00,'2020-03-29 08:22:47','2020-03-29 08:22:47'),(324,98,57,0,100000.00,'2020-03-29 08:26:03','2020-03-29 08:26:03'),(327,67,87,0,100000.00,'2020-03-29 13:07:46','2020-03-29 13:07:46'),(328,67,88,0,125000.00,'2020-03-29 13:07:46','2020-03-29 13:07:46'),(335,79,109,0,125000.00,'2020-03-29 13:12:01','2020-03-29 13:12:01'),(336,79,110,0,125000.00,'2020-03-29 13:12:01','2020-03-29 13:12:01'),(343,100,123,0,250000.00,'2020-03-29 13:20:47','2020-03-29 13:20:47'),(344,99,124,0,100000.00,'2020-03-30 06:12:32','2020-03-30 06:12:32'),(345,99,125,0,150000.00,'2020-03-30 06:12:32','2020-03-30 06:12:32'),(346,8,19,0,125000.00,'2020-03-30 08:50:51','2020-03-30 08:50:51'),(347,8,20,0,175000.00,'2020-03-30 08:50:51','2020-03-30 08:50:51'),(348,9,22,0,125000.00,'2020-03-30 08:54:19','2020-03-30 08:54:19'),(349,9,23,0,150000.00,'2020-03-30 08:54:19','2020-03-30 08:54:19'),(350,10,24,0,125000.00,'2020-03-30 08:55:05','2020-03-30 08:55:05'),(351,10,25,0,100000.00,'2020-03-30 08:55:05','2020-03-30 08:55:05'),(352,15,21,0,100000.00,'2020-03-30 08:57:12','2020-03-30 08:57:12'),(353,20,27,0,200000.00,'2020-03-30 08:58:53','2020-03-30 08:58:53'),(357,24,29,0,100000.00,'2020-03-30 09:06:37','2020-03-30 09:06:37'),(358,24,30,0,100000.00,'2020-03-30 09:06:37','2020-03-30 09:06:37'),(359,25,31,0,250000.00,'2020-03-30 09:07:18','2020-03-30 09:07:18'),(360,23,63,0,100000.00,'2020-03-30 09:08:06','2020-03-30 09:08:06'),(361,85,120,0,100000.00,'2020-03-30 09:22:21','2020-03-30 09:22:21');
/*!40000 ALTER TABLE `tb_pembayaran_honor_detail_tmp` 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:45
