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

START TRANSACTION;



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

--
-- Table structure for table `presensi`
--

CREATE TABLE `presensi` (
  `id` int(11) NOT NULL,
  `pegawai_id` int(11) NOT NULL,
  `tanggal` date NOT NULL,
  `jam_masuk` time DEFAULT NULL,
  `jam_keluar` time DEFAULT NULL,
  `status_masuk` varchar(20) DEFAULT NULL,
  `latitude` varchar(50) DEFAULT NULL,
  `longitude` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `presensi`
--

INSERT INTO `presensi` (`id`, `pegawai_id`, `tanggal`, `jam_masuk`, `jam_keluar`, `status_masuk`, `latitude`, `longitude`) VALUES
(1, 1, '2026-02-03', '03:23:43', '03:23:49', NULL, NULL, NULL),
(2, 1, '2026-02-04', '00:00:00', '00:00:00', NULL, NULL, NULL),
(3, 2, '2026-02-04', '00:00:00', '00:00:00', NULL, NULL, NULL),
(4, 3, '2026-02-04', '00:00:00', '00:00:00', NULL, NULL, NULL),
(5, 1, '2026-02-18', '00:00:00', '00:00:00', NULL, NULL, NULL),
(6, 3, '2026-02-18', '06:25:37', NULL, 'Tepat Waktu', NULL, NULL),
(7, 4, '2026-02-18', '06:57:08', NULL, 'Tepat Waktu', '-6.84784775', '110.71939475'),
(8, 5, '2026-02-18', '11:52:46', NULL, 'Terlambat', '-7.0168842967862135', '110.41804290857542'),
(9, 6, '2026-02-18', '11:54:50', NULL, 'Terlambat', '-7.016847540951898', '110.41803111600073'),
(10, 7, '2026-02-18', '12:10:20', NULL, 'Terlambat', '-7.016882416239535', '110.41804023033194'),
(11, 4, '2026-03-04', '07:31:45', NULL, 'Tepat Waktu', '-6.984446331631025', '110.45204946824131'),
(12, 8, '2026-03-04', '08:21:16', NULL, 'Terlambat', '-6.984446331631025', '110.45204946824131'),
(13, 1, '2026-03-04', '09:00:53', NULL, 'Terlambat', '-6.984446331631025', '110.45204946824131'),
(14, 9, '2026-07-09', '16:42:54', '17:20:40', 'Terlambat', '-7.060843', '110.411288'),
(15, 1, '2026-07-10', '21:56:33', '21:56:37', 'Terlambat', '-6.846745000000001', '110.719666'),
(16, 0, '2026-07-30', '00:05:03', NULL, 'Tepat Waktu', '-6.984457315624432', '110.45207496050365'),
(17, 1, '2026-08-04', '01:02:55', NULL, 'Tepat Waktu', '-6.984462806575167', '110.45214389977657'),
(18, 11, '2026-08-04', '09:56:15', NULL, 'Terlambat', '-6.98447008066163', '110.45215654359814'),
(19, 0, '2026-08-04', '11:34:07', NULL, 'Terlambat', '-6.984462427839395', '110.45217172422669'),
(20, 0, '2026-08-11', '14:13:45', NULL, 'Terlambat', '-6.980349262897441', '110.45415965474864'),
(21, 13, '2026-08-11', '14:29:02', '19:23:44', 'Terlambat', '-6.980296945256716', '110.45398130091806'),
(22, 14, '2026-08-11', '14:34:03', NULL, 'Terlambat', '-6.980138210567787', '110.45402211763577'),
(23, 11, '2026-08-11', '14:39:39', NULL, 'Terlambat', '-6.980348932030598', '110.4540144324889'),
(24, 11, '2026-08-18', '21:31:41', '21:31:42', 'Terlambat', '-6.984413371670433', '110.45218092644738');

--
-- Indexes for table `presensi`
--
ALTER TABLE `presensi`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for table `presensi`
--
ALTER TABLE `presensi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
COMMIT;

