 -- --------------------------------------------------------
 
 --
--- Table structure for table `jns_usaha`
---
-
-CREATE TABLE IF NOT EXISTS `jns_usaha` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `jns_usaha_kd` varchar(255) DEFAULT NULL,
-  `nama` varchar(255) DEFAULT NULL,
-  `ket` varchar(255) DEFAULT NULL,
+-- Table structure for table `hr_m_agama`
+--
+
+CREATE TABLE IF NOT EXISTS `hr_m_agama` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `nm_agama` varchar(20) DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
+
+--
+-- Dumping data for table `hr_m_agama`
+--
+
+INSERT INTO `hr_m_agama` (`id`, `nm_agama`) VALUES
+(1, 'Islam'),
+(2, 'Kristen'),
+(3, 'Hindu'),
+(4, 'Budha');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `hr_m_bagian`
+--
+
+CREATE TABLE IF NOT EXISTS `hr_m_bagian` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `nm_bagian` varchar(20) DEFAULT NULL,
+  `kd_jns_usaha` varchar(255) DEFAULT NULL,
   `created_at` datetime DEFAULT NULL,
   `created_by` int(11) DEFAULT NULL,
   `updated_at` datetime DEFAULT NULL,

-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 27, 2016 at 07:57 PM
-- Server version: 5.1.33
-- PHP Version: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `a001`
--

  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `hr_m_gaji`
--


-- --------------------------------------------------------

--
-- Table structure for table `hr_m_karyawan`
--

CREATE TABLE IF NOT EXISTS `hr_m_karyawan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nik_kary` varchar(10) DEFAULT NULL,
  `nama_kary` varchar(50) DEFAULT NULL,
  `tgl_lahir_kary` datetime DEFAULT NULL,
