-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `presensi`
--

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

--
-- Table structure for table `absen`
--

CREATE TABLE `absen` (
  `IdAbsen` int(11) NOT NULL,
  `Nip` varchar(30) DEFAULT NULL,
  `TglAbsen` date DEFAULT NULL,
  `JamDatang` time DEFAULT NULL,
  `JamPulang` time DEFAULT '00:00:00',
  `Keterangan` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `absen`
--

INSERT INTO `absen` (`IdAbsen`, `Nip`, `TglAbsen`, `JamDatang`, `JamPulang`, `Keterangan`) VALUES
(1, '121347384738', '2018-01-05', '07:23:39', '14:23:51', 'Hadir'),
(2, '1988100110', '2018-12-03', '07:31:49', '00:00:00', 'Hadir'),
(3, '1988100110', '2017-11-01', '08:01:49', '00:00:00', 'Hadir'),
(4, '1988100110', '2017-11-02', '08:10:33', '00:00:00', 'Hadir'),
(5, '1988100110', '2017-11-03', '08:11:00', '00:00:00', 'Hadir'),
(7, '1988100110', '2017-11-07', '08:32:33', '00:00:00', 'Hadir'),
(8, '1988100110', '2017-11-08', '08:27:43', '00:00:00', 'Hadir'),
(9, '1988100110', '2017-11-09', '08:22:52', '00:00:00', 'Hadir'),
(10, '1988100110', '2017-11-10', '08:26:05', '00:00:00', 'Hadir'),
(11, '1988100110', '2017-11-13', '08:37:32', '00:00:00', 'Hadir'),
(12, '1988100110', '2017-11-14', '08:26:46', '00:00:00', 'Hadir'),
(13, '1988100110', '2017-11-15', '08:17:57', '00:00:00', 'Hadir'),
(14, '1988100110', '2017-11-16', '08:17:06', '00:00:00', 'Hadir'),
(15, '1988100110', '2017-11-17', '08:10:17', '00:00:00', 'Hadir'),
(16, '1988100110', '2017-11-20', '08:07:29', '00:00:00', 'Hadir'),
(17, '1988100110', '2017-11-21', '08:04:39', '00:00:00', 'Hadir'),
(18, '1988100110', '2017-11-22', '08:13:48', '00:00:00', 'Hadir'),
(19, '1988100110', '2017-11-23', '08:39:57', '00:00:00', 'Hadir'),
(20, '1988100110', '2017-11-24', '08:42:07', '00:00:00', 'Hadir'),
(21, '1988100110', '2017-11-27', '08:30:21', '00:00:00', 'Hadir'),
(22, '1988100110', '2017-11-28', '08:26:29', '00:00:00', 'Hadir'),
(23, '1988100110', '2017-11-29', '08:21:37', '00:00:00', 'Hadir'),
(24, '1988100110', '2017-11-30', '08:23:52', '00:00:00', 'Hadir'),
(25, '1988100110', '2017-12-08', '08:25:27', '00:00:00', 'Hadir'),
(26, '1988100110', '2017-12-11', '08:22:40', '00:00:00', 'Hadir'),
(27, '1988100110', '2017-12-12', '08:56:49', '00:00:00', 'Hadir'),
(28, '1988100110', '2017-12-13', '08:50:57', '00:00:00', 'Hadir'),
(29, '1988100110', '2017-12-14', '08:23:04', '00:00:00', 'Hadir'),
(30, '1988100110', '2017-12-15', '08:07:17', '00:00:00', 'Hadir'),
(31, '1988100110', '2018-01-02', '08:08:10', '00:00:00', 'Hadir'),
(32, '1988100110', '2018-01-03', '08:14:19', '00:00:00', 'Hadir'),
(33, '1988100110', '2018-01-04', '08:16:26', '00:00:00', 'Hadir'),
(34, '1988100110', '2018-01-05', '08:23:34', '00:00:00', 'Hadir'),
(35, '1988100110', '2018-01-08', '08:37:42', '00:00:00', 'Hadir'),
(36, '1988100110', '2018-01-09', '08:20:49', '00:00:00', 'Hadir'),
(37, '1988100110', '2018-01-10', '08:22:57', '00:00:00', 'Hadir'),
(38, '1988100110', '2018-01-11', '08:01:06', '00:00:00', 'Hadir'),
(39, '198810 0110', '2018-01-12', '08:17:13', '00:00:00', 'Hadir'),
(40, '1988100110', '2018-01-15', '08:19:25', '00:00:00', 'Hadir'),
(41, '1988100110', '2018-01-16', '08:21:31', '00:00:00', 'Hadir'),
(42, '1988100110', '2018-01-17', '08:33:36', '00:00:00', 'Hadir'),
(43, '1988100110', '2018-01-18', '08:35:42', '00:00:00', 'Hadir'),
(44, '1988100110', '2018-01-19', '08:45:59', '00:00:00', 'Hadir'),
(45, '1988100110', '2018-01-22', '08:51:15', '00:00:00', 'Hadir'),
(46, '2001122003', '2017-11-01', '08:54:44', '00:00:00', 'Hadir'),
(47, '2001122003', '2017-11-02', '08:19:56', '00:00:00', 'Hadir'),
(48, '2001122003', '2017-11-03', '08:36:03', '00:00:00', 'Hadir'),
(49, '2001122003', '2017-11-10', '08:39:04', '00:00:00', 'Hadir'),
(50, '2001122003', '2017-11-13', '08:49:16', '00:00:00', 'Hadir'),
(51, '2001122003', '2017-11-14', '08:55:26', '00:00:00', 'Hadir'),
(52, '2001122003', '2017-11-15', '08:20:34', '00:00:00', 'Hadir'),
(53, '2001122003', '2017-11-16', '08:03:40', '00:00:00', 'Hadir'),
(54, '2001122003', '2017-11-17', '08:13:47', '00:00:00', 'Hadir'),
(55, '2001122003', '2017-11-20', '08:24:54', '00:00:00', 'Hadir'),
(56, '2001122003', '2017-11-21', '08:37:02', '00:00:00', 'Hadir'),
(57, '2001122003', '2017-11-22', '08:48:11', '00:00:00', 'Hadir'),
(58, '2001122003', '2017-11-23', '08:46:19', '00:00:00', 'Hadir'),
(59, '2001122003', '2017-11-24', '08:25:27', '00:00:00', 'Hadir'),
(60, '2001122003', '2017-11-27', '08:19:35', '00:00:00', 'Hadir'),
(61, '2001122003', '2017-11-28', '08:41:41', '00:00:00', 'Hadir'),
(62, '2001122003', '2017-11-29', '08:39:46', '00:00:00', 'Hadir'),
(63, '2001122003', '2017-11-30', '08:54:56', '00:00:00', 'Hadir'),
(64, '2001122003', '2017-12-04', '08:55:15', '00:00:00', 'Hadir'),
(65, '2001122003', '2017-12-05', '08:27:22', '00:00:00', 'Hadir'),
(66, '2001122003', '2017-12-06', '08:10:31', '00:00:00', 'Hadir'),
(67, '2001122003', '2017-12-07', '08:22:43', '00:00:00', 'Hadir'),
(68, '2001122003', '2017-12-08', '08:23:50', '00:00:00', 'Hadir'),
(69, '2001122003', '2017-12-11', '08:34:02', '00:00:00', 'Hadir'),
(70, '2001122003', '2017-12-12', '08:43:08', '00:00:00', 'Hadir'),
(71, '2001122003', '2017-12-13', '08:33:15', '00:00:00', 'Hadir'),
(72, '2001122003', '2017-12-14', '08:45:21', '00:00:00', 'Hadir'),
(73, '2001122003', '2017-12-15', '08:06:35', '00:00:00', 'Hadir'),
(74, '2001122003', '2018-01-02', '08:08:51', '00:00:00', 'Hadir'),
(75, '2001122003', '2018-01-03', '08:20:57', '00:00:00', 'Hadir'),
(76, '2001122003', '2018-01-04', '08:32:03', '00:00:00', 'Hadir'),
(77, '2001122003', '2018-01-05', '08:38:09', '00:00:00', 'Hadir'),
(78, '2001122003', '2018-01-08', '08:26:15', '00:00:00', 'Hadir'),
(79, '2001122003', '2018-01-09', '08:54:25', '00:00:00', 'Hadir'),
(80, '2001122003', '2018-01-10', '08:58:32', '00:00:00', 'Hadir'),
(81, '2001122003', '2018-01-11', '08:54:52', '00:00:00', 'Hadir'),
(82, '2001122003', '2018-01-12', '08:04:00', '00:00:00', 'Hadir'),
(83, '2001122003', '2018-01-15', '08:31:08', '00:00:00', 'Hadir'),
(84, '2001122003', '2018-01-16', '08:33:16', '00:00:00', 'Hadir'),
(85, '2001122003', '2018-01-17', '08:06:22', '00:00:00', 'Hadir'),
(86, '2001122003', '2018-01-18', '08:15:31', '00:00:00', 'Hadir'),
(87, '2001122003', '2018-01-19', '08:18:38', '00:00:00', 'Hadir'),
(88, '2001122003', '2018-01-22', '08:20:48', '00:00:00', 'Hadir');

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

--
-- Table structure for table `bidang`
--

CREATE TABLE `bidang` (
  `IdBidang` int(11) NOT NULL,
  `NamaBidang` varchar(30) DEFAULT NULL,
  `KepalaBagian` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bidang`
--

INSERT INTO `bidang` (`IdBidang`, `NamaBidang`, `KepalaBagian`) VALUES
(8, 'Seketariat', 'Ali. Mas\'udi'),
(9, 'Penetapan', 'Titus Toding'),
(10, 'Pendaftaran dan Pendataan', 'Roby Kepas Awi'),
(11, 'Penagihan dan Pembukuan', 'Margarheta Waromi'),
(12, 'PBB-P2 dan BPHTB', 'Adolfina Taniau');

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

--
-- Table structure for table `harilibur`
--

CREATE TABLE `harilibur` (
  `IdHari` int(11) NOT NULL,
  `DariTgl` date DEFAULT NULL,
  `SampaiTgl` date DEFAULT NULL,
  `Keterangan` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `harilibur`
--

INSERT INTO `harilibur` (`IdHari`, `DariTgl`, `SampaiTgl`, `Keterangan`) VALUES
(1, '2017-12-24', '2018-01-07', 'Libur Natal'),
(2, '2017-11-04', '2017-11-04', 'Sabtu'),
(3, '2017-11-05', '2017-11-05', 'Minggu'),
(4, '2017-11-11', '2017-11-11', 'Sabtu'),
(5, '2017-11-12', '2017-11-12', 'Minggu'),
(6, '2017-11-18', '2017-11-18', 'Sabtu'),
(7, '2017-11-19', '2017-11-19', 'Minggu'),
(8, '2017-11-25', '2017-11-25', 'Sabtu'),
(9, '2017-11-26', '2017-11-26', 'Minggu'),
(10, '2017-12-01', '2017-12-01', 'Maulid Nabi'),
(11, '2017-12-02', '2017-12-02', 'Sabtu'),
(12, '2017-12-03', '2017-12-03', 'Minggu'),
(13, '2017-12-09', '2017-12-09', 'Sabtu'),
(14, '2017-12-10', '2017-12-10', 'Minggu'),
(15, '2017-12-16', '2017-12-16', 'Sabtu'),
(16, '2017-12-17', '2017-12-17', 'Minggu'),
(17, '2017-12-23', '2017-12-23', 'Sabtu'),
(18, '2017-12-24', '2017-12-24', 'Minggu'),
(19, '2017-12-30', '2017-12-30', 'Sabtu'),
(20, '2017-12-31', '2017-12-31', 'Minggu'),
(21, '2018-01-01', '2018-01-01', 'Tahun Baru Masehi'),
(22, '2018-01-06', '2018-01-06', 'Sabtu'),
(23, '2018-01-07', '2018-01-07', 'Minggu'),
(24, '2018-01-13', '2018-01-13', 'Sabtu'),
(25, '2018-01-14', '2018-01-14', 'Minggu'),
(26, '2018-01-20', '2018-01-20', 'Sabtu'),
(27, '2018-01-21', '2018-01-21', 'Minggu'),
(28, '2018-01-27', '2018-01-27', 'Sabtu'),
(29, '2018-01-28', '2018-01-28', 'Minggu');

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

--
-- Table structure for table `keteranganabsen`
--

CREATE TABLE `keteranganabsen` (
  `Id` int(11) NOT NULL,
  `Nip` varchar(30) DEFAULT NULL,
  `Jenis` enum('Izin','Cuti','Sakit','DL') DEFAULT NULL,
  `TglPengajuan` date DEFAULT NULL,
  `TglMulai` date DEFAULT NULL,
  `TglSelesai` date DEFAULT NULL,
  `Keterangan` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `keteranganabsen`
--

INSERT INTO `keteranganabsen` (`Id`, `Nip`, `Jenis`, `TglPengajuan`, `TglMulai`, `TglSelesai`, `Keterangan`) VALUES
(1, '19822102003', 'Izin', '2017-11-01', '2017-11-02', '2017-11-08', 'Kepentingan Keluarga'),
(2, '1988100110', 'Sakit', '2017-12-04', '2017-12-04', '2017-12-07', 'Sakit'),
(3, '2003122008', 'DL', '2018-01-03', '2018-01-05', '2018-01-11', 'Dinas Luar');

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

--
-- Table structure for table `perangkat`
--

CREATE TABLE `perangkat` (
  `IdPerangkat` int(11) NOT NULL,
  `Nip` varchar(30) NOT NULL DEFAULT '',
  `MacAddress` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `perangkat`
--

INSERT INTO `perangkat` (`IdPerangkat`, `Nip`, `MacAddress`) VALUES
(4, '121347384738', '3c-b6-b7-1d-6f-ed'),
(5, '1988100110', '30-cb-f8-e3-c9-af'),
(6, '19822102003', '70-78-8b-c6-6d-37'),
(7, '1997031004', '20-72-0d-39-09-cc'),
(8, '2001122003', '30-c7-AE-76-2E-ED');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `absen`
--
ALTER TABLE `absen`
  ADD PRIMARY KEY (`IdAbsen`);

--
-- Indexes for table `bidang`
--
ALTER TABLE `bidang`
  ADD PRIMARY KEY (`IdBidang`);

--
-- Indexes for table `harilibur`
--
ALTER TABLE `harilibur`
  ADD PRIMARY KEY (`IdHari`);

--
-- Indexes for table `keteranganabsen`
--
ALTER TABLE `keteranganabsen`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `perangkat`
--
ALTER TABLE `perangkat`
  ADD PRIMARY KEY (`IdPerangkat`,`Nip`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `absen`
--
ALTER TABLE `absen`
  MODIFY `IdAbsen` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=89;

--
-- AUTO_INCREMENT for table `bidang`
--
ALTER TABLE `bidang`
  MODIFY `IdBidang` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `harilibur`
--
ALTER TABLE `harilibur`
  MODIFY `IdHari` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `keteranganabsen`
--
ALTER TABLE `keteranganabsen`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `perangkat`
--
ALTER TABLE `perangkat`
  MODIFY `IdPerangkat` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;

