INSERT INTO `employee` (`userID`, `firstName`, `lastName`, `birthdate`, `address`, `netSalary`, `photo`, `contactNumber`, `deptID`, `gender`, `face_image`, `created_at`) VALUES
(63, 'Abdi', 'Mohamed', '2025-05-14', 'Xamar jadiid', 600.00, NULL, '611588085', 13, 'Male', NULL, '2025-05-31 08:24:08'),
(64, 'Farhan', 'Mohamed', '2025-05-14', 'Xamar jadiid', 600.00, NULL, '611588085', 13, 'Male', NULL, '2025-05-31 08:24:32'),
(65, 'Ahmed', 'Abdi', '2025-03-20', 'Xamarjadid, muqdisho', 500.00, NULL, '645808284', 2, 'Male', NULL, '2025-05-31 08:29:51'),
(67, 'Said', 'Farah', '2003-06-09', 'carafaat, xamar', 500.00, NULL, '612588087', 2, 'Male', NULL, '2025-06-10 07:28:26');
INSERT INTO `employee` (`userID`, `firstName`, `lastName`, `birthdate`, `address`, `netSalary`, `photo`, `contactNumber`, `deptID`, `gender`, `face_image`, `created_at`) VALUES
(68, 'Zakariye', 'Elmi', '2025-06-20', 'Suuqa xoolaha', 600.00, NULL, '615808283', 17, 'Male', '[BLOB]', '2025-06-25 08:28:40');
INSERT INTO `employee` (`userID`, `firstName`, `lastName`, `birthdate`, `address`, `netSalary`, `photo`, `contactNumber`, `deptID`, `gender`, `face_image`, `created_at`) VALUES
(69, 'Abdulahi', 'Mire', '2004-02-01', 'suuqa xoolaha', 500.00, NULL, '617510061', 13, 'Male', NULL, '2025-07-14 14:34:47');

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

--
-- Table structure for table `employee_timestamp`
--

CREATE TABLE IF NOT EXISTS `employee_timestamp` (
  `timestampID` int NOT NULL AUTO_INCREMENT,
  `userID` int DEFAULT NULL,
  `checkIn` datetime DEFAULT NULL,
  `checkOut` datetime DEFAULT NULL,
  `status` enum('present','on leave','absent') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `checkin_image` longtext COLLATE utf8mb4_general_ci,
  `checkout_image` longtext COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`timestampID`),
  KEY `userID` (`userID`)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee_timestamp`
--

INSERT INTO `employee_timestamp` (`timestampID`, `userID`, `checkIn`, `checkOut`, `status`, `createdAt`, `updatedAt`, `checkin_image`, `checkout_image`) VALUES
(79, 40, '2025-05-26 04:11:41', '2025-05-26 04:16:23', 'present', '2025-05-26 11:11:41', '2025-05-26 11:16:23', '[BLOB]', '[BLOB]');
INSERT INTO `employee_timestamp` (`timestampID`, `userID`, `checkIn`, `checkOut`, `status`, `createdAt`, `updatedAt`, `checkin_image`, `checkout_image`) VALUES
(81, 40, '2025-05-27 21:17:12', NULL, 'present', '2025-05-28 04:17:12', '2025-05-28 04:17:12', '[BLOB]', NULL);
