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

DROP TABLE IF EXISTS `tb_honor_dosen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_honor_dosen` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `dosen_id` int(10) unsigned DEFAULT NULL,
  `nama_honor` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nominal` double(20,2) NOT NULL DEFAULT '0.00',
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status_honor` 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_honor_dosen_dosen_id_index` (`dosen_id`)
) ENGINE=InnoDB AUTO_INCREMENT=205 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_honor_dosen`
--

LOCK TABLES `tb_honor_dosen` WRITE;
/*!40000 ALTER TABLE `tb_honor_dosen` DISABLE KEYS */;
INSERT INTO `tb_honor_dosen` VALUES (3,2,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-02-09 18:00:01','2020-02-09 18:00:01'),(4,2,'Homebase',150000.00,'Nominal Tetap',NULL,'2020-02-09 18:00:01','2020-02-09 18:00:01'),(19,6,'Gelar',125000.00,'Nominal Tetap',NULL,'2020-02-27 07:51:19','2020-02-27 07:51:19'),(20,6,'Homebase',175000.00,'Nominal Tetap',NULL,'2020-02-27 07:51:19','2020-02-27 07:51:19'),(22,8,'Gelar',125000.00,'Nominal Tetap',NULL,'2020-03-25 09:18:45','2020-03-25 09:18:45'),(23,8,'Homebase',150000.00,'Nominal Tetap',NULL,'2020-03-25 09:18:45','2020-03-25 09:18:45'),(24,9,'Gelar',125000.00,'Nominal Tetap',NULL,'2020-03-26 05:36:13','2020-03-26 05:36:13'),(25,9,'Homebase',100000.00,'Nominal Tetap',NULL,'2020-03-26 05:36:13','2020-03-26 05:36:13'),(26,10,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-26 05:44:31','2020-03-26 05:44:31'),(27,11,'Gelar',200000.00,'Nominal Tetap',NULL,'2020-03-26 05:46:20','2020-03-26 05:46:20'),(31,14,'Gelar',250000.00,'Nominal Tetap',NULL,'2020-03-26 10:53:50','2020-03-26 10:53:50'),(33,16,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-26 11:38:06','2020-03-26 11:38:06'),(34,17,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-26 11:39:24','2020-03-26 11:39:24'),(35,17,'Homebase',100000.00,'Nominal Tetap',NULL,'2020-03-26 11:39:24','2020-03-26 11:39:24'),(37,19,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-26 11:49:15','2020-03-26 11:49:15'),(38,20,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-26 11:51:08','2020-03-26 11:51:08'),(39,21,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-26 11:51:57','2020-03-26 11:51:57'),(40,22,'Gelar',250000.00,'Nominal Tetap',NULL,'2020-03-26 11:54:16','2020-03-26 11:54:16'),(41,23,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-26 11:56:37','2020-03-26 11:56:37'),(42,23,'Homebase',175000.00,'Nominal Tetap',NULL,'2020-03-26 11:56:37','2020-03-26 11:56:37'),(44,25,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-26 11:58:44','2020-03-26 11:58:44'),(45,25,'Homebase',100000.00,'Nominal Tetap',NULL,'2020-03-26 11:58:44','2020-03-26 11:58:44'),(48,26,'Gelar',125000.00,'Nominal Tetap',NULL,'2020-03-26 12:01:03','2020-03-26 12:01:03'),(49,26,'Homebase',150000.00,'Nominal Tetap',NULL,'2020-03-26 12:01:03','2020-03-26 12:01:03'),(50,27,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-26 12:01:49','2020-03-26 12:01:49'),(53,30,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-26 12:09:31','2020-03-26 12:09:31'),(57,34,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-26 12:46:38','2020-03-26 12:46:38'),(58,35,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-26 12:47:31','2020-03-26 12:47:31'),(59,35,'Homebase',100000.00,'Nominal Tetap',NULL,'2020-03-26 12:47:31','2020-03-26 12:47:31'),(60,36,'Gelar',125000.00,'Nominal Tetap',NULL,'2020-03-26 12:48:45','2020-03-26 12:48:45'),(61,36,'Homebase',175000.00,'Nominal Tetap',NULL,'2020-03-26 12:48:45','2020-03-26 12:48:45'),(62,37,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-26 12:49:39','2020-03-26 12:49:39'),(63,12,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-26 14:00:00','2020-03-26 14:00:00'),(65,38,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-27 14:00:58','2020-03-27 14:00:58'),(67,40,'Gelar',125000.00,'Nominal Tetap',NULL,'2020-03-27 23:33:11','2020-03-27 23:33:11'),(68,40,'Homebase',125000.00,'Nominal Tetap',NULL,'2020-03-27 23:33:11','2020-03-27 23:33:11'),(71,42,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-27 23:36:55','2020-03-27 23:36:55'),(72,43,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-27 23:38:03','2020-03-27 23:38:03'),(75,45,'Gelar',150000.00,'Nominal Tetap',NULL,'2020-03-27 23:41:38','2020-03-27 23:41:38'),(76,45,'Homebase',250000.00,'Nominal Tetap',NULL,'2020-03-27 23:41:38','2020-03-27 23:41:38'),(77,46,'Gelar',125000.00,'Nominal Tetap',NULL,'2020-03-27 23:51:56','2020-03-27 23:51:56'),(78,46,'Homebase',175000.00,'Nominal Tetap',NULL,'2020-03-27 23:51:56','2020-03-27 23:51:56'),(80,48,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-27 23:54:00','2020-03-27 23:54:00'),(81,49,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-27 23:55:16','2020-03-27 23:55:16'),(82,50,'Gelar',125000.00,'Nominal Tetap',NULL,'2020-03-27 23:58:55','2020-03-27 23:58:55'),(83,50,'Homebase',175000.00,'Nominal Tetap',NULL,'2020-03-27 23:58:55','2020-03-27 23:58:55'),(85,52,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 02:48:16','2020-03-28 02:48:16'),(86,53,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 03:48:43','2020-03-28 03:48:43'),(87,54,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 03:50:21','2020-03-28 03:50:21'),(88,54,'Homebase',125000.00,'Nominal Tetap',NULL,'2020-03-28 03:50:21','2020-03-28 03:50:21'),(89,55,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 03:51:46','2020-03-28 03:51:46'),(90,56,'Gelar',125000.00,'Nominal Tetap',NULL,'2020-03-28 03:52:46','2020-03-28 03:52:46'),(91,56,'Homebase',150000.00,'Nominal Tetap',NULL,'2020-03-28 03:52:46','2020-03-28 03:52:46'),(92,57,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 03:54:22','2020-03-28 03:54:22'),(93,58,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 03:55:07','2020-03-28 03:55:07'),(94,59,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 04:09:19','2020-03-28 04:09:19'),(95,60,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 04:10:23','2020-03-28 04:10:23'),(96,61,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 04:14:52','2020-03-28 04:14:52'),(97,62,'Gelar',125000.00,'Nominal Tetap',NULL,'2020-03-28 04:21:06','2020-03-28 04:21:06'),(98,62,'Homebase',125000.00,'Nominal Tetap',NULL,'2020-03-28 04:21:06','2020-03-28 04:21:06'),(100,64,'Gelar',150000.00,'Nominal Tetap',NULL,'2020-03-28 04:23:36','2020-03-28 04:23:36'),(101,64,'Homebase',200000.00,'Nominal Tetap',NULL,'2020-03-28 04:23:36','2020-03-28 04:23:36'),(103,66,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 04:27:18','2020-03-28 04:27:18'),(104,66,'Homebase',100000.00,'Nominal Tetap',NULL,'2020-03-28 04:27:18','2020-03-28 04:27:18'),(105,67,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 04:32:53','2020-03-28 04:32:53'),(106,68,'Gelar',125000.00,'Nominal Tetap',NULL,'2020-03-28 04:34:40','2020-03-28 04:34:40'),(107,68,'Homebase',125000.00,'Nominal Tetap',NULL,'2020-03-28 04:34:40','2020-03-28 04:34:40'),(109,70,'Gelar',125000.00,'Nominal Tetap',NULL,'2020-03-28 04:37:55','2020-03-28 04:37:55'),(110,70,'Homebase',125000.00,'Nominal Tetap',NULL,'2020-03-28 04:37:55','2020-03-28 04:37:55'),(111,71,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 04:42:11','2020-03-28 04:42:11'),(112,71,'Homebase',150000.00,'Nominal Tetap',NULL,'2020-03-28 04:42:11','2020-03-28 04:42:11'),(113,72,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 04:43:08','2020-03-28 04:43:08'),(114,72,'Homebase',150000.00,'Nominal Tetap',NULL,'2020-03-28 04:43:08','2020-03-28 04:43:08'),(115,73,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 04:44:54','2020-03-28 04:44:54'),(116,73,'Homebase',100000.00,'Nominal Tetap',NULL,'2020-03-28 04:44:54','2020-03-28 04:44:54'),(117,74,'Gelar',150000.00,'Nominal Tetap',NULL,'2020-03-28 04:45:48','2020-03-28 04:45:48'),(118,74,'Homebase',200000.00,'Nominal Tetap',NULL,'2020-03-28 04:45:48','2020-03-28 04:45:48'),(119,75,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 04:46:56','2020-03-28 04:46:56'),(120,76,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 04:48:07','2020-03-28 04:48:07'),(121,77,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-28 08:31:31','2020-03-28 08:31:31'),(122,77,'Homebase',150000.00,'Nominal Tetap',NULL,'2020-03-28 08:31:31','2020-03-28 08:31:31'),(128,3,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-03-30 05:56:58','2020-03-30 05:56:58'),(129,79,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-04-02 12:15:24','2020-04-02 12:15:24'),(133,81,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-04-28 13:44:30','2020-04-28 13:44:30'),(134,81,'Homebase',150000.00,'Nominal Tetap',NULL,'2020-04-28 13:44:30','2020-04-28 13:44:30'),(135,80,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-04-29 04:18:36','2020-04-29 04:18:36'),(139,47,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-05-06 03:14:52','2020-05-06 03:14:52'),(140,63,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-05-06 03:16:09','2020-05-06 03:16:09'),(144,82,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-05-17 03:50:19','2020-05-17 03:50:19'),(145,83,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-05-17 04:02:13','2020-05-17 04:02:13'),(153,84,'Homebase',150000.00,'Nominal Tetap',NULL,'2020-08-17 18:25:14','2020-08-17 18:25:14'),(154,85,'Gelar',110000.00,'Nominal Tetap',NULL,'2020-08-17 18:27:45','2020-08-17 18:27:45'),(155,86,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-09-27 08:08:10','2020-09-27 08:08:10'),(171,7,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-06 13:26:55','2020-11-06 13:26:55'),(174,24,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-25 14:51:38','2020-11-25 14:51:38'),(175,39,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-27 09:59:33','2020-11-27 09:59:33'),(176,44,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-27 10:00:45','2020-11-27 10:00:45'),(177,44,'Homebase',100000.00,'Nominal Tetap',NULL,'2020-11-27 10:00:45','2020-11-27 10:00:45'),(178,51,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-27 10:01:09','2020-11-27 10:01:09'),(179,33,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-27 22:16:04','2020-11-27 22:16:04'),(180,32,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-27 22:20:39','2020-11-27 22:20:39'),(181,18,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-27 22:23:24','2020-11-27 22:23:24'),(182,65,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-28 09:35:44','2020-11-28 09:35:44'),(183,13,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-28 10:26:39','2020-11-28 10:26:39'),(184,13,'Homebase',100000.00,'Nominal Tetap',NULL,'2020-11-28 10:26:39','2020-11-28 10:26:39'),(185,69,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-29 21:56:17','2020-11-29 21:56:17'),(186,41,'Gelar',125000.00,'Nominal Tetap',NULL,'2020-11-30 09:59:56','2020-11-30 09:59:56'),(187,41,'Homebase',175000.00,'Nominal Tetap',NULL,'2020-11-30 09:59:56','2020-11-30 09:59:56'),(188,4,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-30 10:01:42','2020-11-30 10:01:42'),(189,4,'Homebase',150000.00,'Nominal Tetap',NULL,'2020-11-30 10:01:42','2020-11-30 10:01:42'),(193,91,'Homebase',0.00,'Nominal Tetap',NULL,'2020-11-30 19:05:31','2020-11-30 19:05:31'),(194,31,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-30 19:09:14','2020-11-30 19:09:14'),(195,28,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-30 20:20:43','2020-11-30 20:20:43'),(196,89,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-30 20:24:58','2020-11-30 20:24:58'),(197,88,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-30 20:25:17','2020-11-30 20:25:17'),(198,87,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-11-30 20:27:12','2020-11-30 20:27:12'),(199,5,'Gelar',125000.00,'Nominal Tetap',NULL,'2020-11-30 20:27:28','2020-11-30 20:27:28'),(200,5,'Homebase',225000.00,'Nominal Tetap',NULL,'2020-11-30 20:27:28','2020-11-30 20:27:28'),(201,15,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-12-01 06:36:15','2020-12-01 06:36:15'),(202,90,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-12-01 12:33:00','2020-12-01 12:33:00'),(203,29,'Gelar',100000.00,'Nominal Tetap',NULL,'2020-12-01 12:33:37','2020-12-01 12:33:37'),(204,78,'Gelar',250000.00,'Nominal Tetap',NULL,'2020-12-02 09:25:25','2020-12-02 09:25:25');
/*!40000 ALTER TABLE `tb_honor_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:34:08
