-- MySQL dump 10.13  Distrib 8.0.33, for Linux (x86_64)
--
-- Host: localhost    Database: azlogistik
-- ------------------------------------------------------
-- Server version	8.0.33-0ubuntu0.22.04.2

/*!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 utf8mb4 */;
/*!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 `master_golongan`
--

DROP TABLE IF EXISTS `master_golongan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `master_golongan` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `id_master_karyawan` int NOT NULL,
  `nama` varchar(10) NOT NULL,
  `gaji_pokok` int unsigned NOT NULL,
  `uang_kehadiran` int unsigned NOT NULL,
  `total_gaji` int unsigned NOT NULL,
  `potongan_absen` int unsigned NOT NULL,
  `uang_lembur` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_golongan_karyawan` (`id_master_karyawan`),
  CONSTRAINT `fk_golongan_karyawan` FOREIGN KEY (`id_master_karyawan`) REFERENCES `master_karyawan` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `master_golongan`
--

LOCK TABLES `master_golongan` WRITE;
/*!40000 ALTER TABLE `master_golongan` DISABLE KEYS */;
INSERT INTO `master_golongan` VALUES (1,4,'A',4800000,700000,5502964,0,2964),(2,5,'A',4800000,700000,5503128,26592,3128),(3,6,'C',6400000,2100000,8503973,0,3973),(4,7,'A',4800000,700000,5503019,0,3019);
/*!40000 ALTER TABLE `master_golongan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `master_karyawan`
--

DROP TABLE IF EXISTS `master_karyawan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `master_karyawan` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nama` varchar(100) NOT NULL,
  `jumlah_cuti` int unsigned NOT NULL,
  `jatah_cuti` int unsigned NOT NULL,
  `jumlah_hadir` int unsigned NOT NULL,
  `jam_lembur` double unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `master_karyawan`
--

LOCK TABLES `master_karyawan` WRITE;
/*!40000 ALTER TABLE `master_karyawan` DISABLE KEYS */;
INSERT INTO `master_karyawan` VALUES (4,'closer',8,7,22,3.5),(5,'closer',8,7,21,2),(6,'arifin',8,8,22,2.5),(7,'aku',8,8,22,0);
/*!40000 ALTER TABLE `master_karyawan` 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 2023-06-24 17:48:56
