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

START TRANSACTION;



--
-- Database: `hr`
--

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

--
-- Table structure for table `applicant_decisions`
--

CREATE TABLE IF NOT EXISTS `applicant_decisions` (
  `decision_id` int NOT NULL AUTO_INCREMENT,
  `applicant_id` int NOT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `gender` varchar(50) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `address` text,
  `experience` text,
  `skills` text,
  `expected_salary` varchar(255) DEFAULT NULL,
  `decision_status` enum('Accepted','Rejected') NOT NULL,
  `decision_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`decision_id`),
  KEY `applicant_id` (`applicant_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `applicant_decisions`
--

INSERT INTO `applicant_decisions` (`decision_id`, `applicant_id`, `first_name`, `last_name`, `email`, `phone`, `gender`, `dob`, `address`, `experience`, `skills`, `expected_salary`, `decision_status`, `decision_date`) VALUES
(1, 4, 'Ahmed', 'Saacid', 'mirede6@gmail.com', '0617141691', 'Male', '2000-01-20', 'Suuqa xoolaha', 'I am a good player I can play football in every position that you can think of, I am that guy!', 'Dribbling, shooting, corner taking especialist', '800–1000', 'Rejected', '2025-07-14 08:26:53'),
(2, 5, 'Abdulahi', 'Mire', 'abdullaahimirejoogax@gmail.com', '0617510061', 'Male', '2004-02-01', 'suuqa xoolaha', 'Magaceygu was Abdulahi', 'waxaan aqanaa tafsiirka iyo axaadiista', '1000+', 'Accepted', '2025-07-14 14:34:47'),
(3, 5, 'Abdulahi', 'Mire', 'abdullaahimirejoogax@gmail.com', '0617510061', 'Male', '2004-02-01', 'suuqa xoolaha', 'Magaceygu was Abdulahi', 'waxaan aqanaa tafsiirka iyo axaadiista', '1000+', 'Rejected', '2025-07-14 14:39:55'),
(4, 7, 'Shafici', 'Mohamud', 'shafieeese@gmail.com', '0621416915', 'Male', '2000-01-28', 'Cadaado, suuqa', 'none', 'none', '500–700', 'Accepted', '2025-08-01 18:07:32');

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

--
-- Table structure for table `company_time`
--

CREATE TABLE IF NOT EXISTS `company_time` (
  `timeID` int NOT NULL AUTO_INCREMENT,
  `checkIn` datetime NOT NULL,
  `checkOut` datetime DEFAULT NULL,
  `date` date NOT NULL,
  `qrCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`timeID`)
) ENGINE=MyISAM AUTO_INCREMENT=142 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `company_time`
--

INSERT INTO `company_time` (`timeID`, `checkIn`, `checkOut`, `date`, `qrCode`) VALUES
(1, '2025-01-27 08:00:00', '2025-01-27 17:00:00', '2025-01-27', 'exampleQRCode1'),
(2, '2025-01-28 09:00:00', '2025-01-28 18:00:00', '2025-01-28', 'exampleQRCode2'),
(3, '2025-01-29 10:00:00', '2025-01-29 19:00:00', '2025-01-29', 'exampleQRCode3'),
(4, '2025-01-29 13:33:00', '2025-01-29 13:33:00', '2025-01-29', NULL),
(5, '2025-01-31 22:27:00', '2025-01-31 22:27:00', '2025-01-31', '1234'),
(6, '2025-02-11 14:01:00', '2025-02-11 17:01:00', '2025-02-11', '2582'),
(7, '2025-02-11 13:25:00', '2025-02-11 13:27:00', '2025-02-11', 'Darshan'),
(8, '2025-02-11 13:42:00', '2025-02-11 13:43:00', '2025-02-11', 'Darshan'),
(9, '2025-02-11 14:03:00', '2025-02-11 14:03:00', '2025-02-11', 'mayank'),
(10, '2025-02-11 14:03:00', '2025-02-11 14:05:00', '2025-02-11', 'Mayank'),
(11, '2025-02-11 21:42:00', '2025-02-11 21:45:00', '2025-02-11', 'night'),
(12, '2025-02-11 21:51:00', '2025-02-11 21:55:00', '2025-02-11', 'night'),
(13, '2025-02-11 22:04:00', '2025-02-11 22:07:00', '2025-02-11', 'night'),
(14, '2025-02-11 22:08:00', '2025-02-11 22:10:00', '2025-02-11', 'ja'),
(15, '2025-02-11 22:36:00', '2025-02-11 22:40:00', '2025-02-11', 'ka'),
(16, '2025-02-11 22:45:00', '2025-02-11 22:47:00', '2025-02-11', 'ha'),
(17, '2025-02-11 22:48:00', '2025-02-11 22:50:00', '2025-02-11', 'ha'),
(18, '2025-02-11 22:50:00', '2025-02-11 22:52:00', '2025-02-11', 'ja'),
(19, '2025-02-11 23:04:00', '2025-02-11 23:06:00', '2025-02-11', 'ha'),
(20, '2025-02-11 23:21:00', '2025-02-11 23:22:00', '2025-02-11', 'ja'),
(21, '2025-02-11 23:24:00', '2025-02-11 23:26:00', '2025-02-11', 'ja'),
(22, '2025-02-11 23:32:00', '2025-02-11 23:33:00', '2025-02-11', 'ka'),
(23, '2025-02-11 23:33:00', '2025-02-11 23:35:00', '2025-02-11', 'k'),
(24, '2025-02-11 23:44:00', '2025-02-11 23:48:00', '2025-02-11', 'ma'),
(25, '2025-02-11 23:50:00', '2025-02-11 23:52:00', '2025-02-11', 'ka'),
(26, '2025-02-12 14:10:00', '2025-02-12 14:15:00', '2025-02-12', 'check'),
(27, '2025-02-12 14:39:00', '2025-02-12 14:40:00', '2025-02-12', 'j'),
(28, '2025-02-12 16:08:00', '2025-02-12 16:10:00', '2025-02-12', 'ja'),
(29, '2025-02-12 16:38:00', '2025-02-12 16:40:00', '2025-02-12', 'bhavya'),
(30, '2025-02-14 13:31:00', '2025-02-14 13:34:00', '2025-02-14', 'om'),
(31, '2025-02-14 13:37:00', '2025-02-14 13:40:00', '2025-02-14', 'ch'),
(32, '2025-02-14 14:07:00', '2025-02-14 14:08:00', '2025-02-14', 'hb'),
(33, '2025-02-18 16:11:00', '2025-02-18 16:11:00', '2025-02-18', 'jk'),
(34, '2025-02-18 16:11:00', '2025-02-18 16:13:00', '2025-02-18', 'bhg'),
(35, '2025-02-18 16:22:00', '2025-02-18 16:23:00', '2025-02-18', 'kfk'),
(36, '2025-02-18 16:25:00', '2025-02-18 16:26:00', '2025-02-18', 'hgjh'),
(37, '2025-02-18 16:27:00', '2025-02-18 16:28:00', '2025-02-18', 'gxgf'),
(38, '2025-02-19 15:43:00', '2025-02-19 15:45:00', '2025-02-19', 'jj'),
(39, '2025-02-19 15:46:00', '2025-02-19 15:47:00', '2025-02-19', 'hghjg'),
(40, '2025-02-23 21:01:00', '2025-02-23 21:02:00', '2025-02-23', 'hbvhv'),
(41, '2025-02-24 17:05:00', '2025-02-24 17:07:00', '2025-02-24', '566'),
(42, '2025-02-25 15:16:00', '2025-02-25 15:17:00', '2025-02-25', 'test '),
(43, '2025-02-25 15:19:00', '2025-02-25 15:24:00', '2025-02-25', 'jhgj'),
(44, '2025-02-25 15:29:00', '2025-02-25 15:30:00', '2025-02-25', 'jhgyg'),
(45, '2025-02-25 15:40:00', '2025-02-25 15:41:00', '2025-02-25', 'ghfygf'),
(46, '2025-02-25 16:01:00', '2025-02-25 16:02:00', '2025-02-25', 'hfhd'),
(47, '2025-02-25 16:02:00', '2025-02-25 16:02:00', '2025-02-25', 'jhfhg'),
(48, '2025-02-25 16:04:00', '2025-02-25 16:06:00', '2025-02-25', 'uyryd'),
(49, '2025-02-25 16:13:00', '2025-02-25 16:13:00', '2025-02-25', 'gfytf'),
(50, '2025-02-27 21:15:00', '2025-02-27 21:17:00', '2025-02-27', 'ghfhgf'),
(51, '2025-02-28 15:13:00', '2025-02-28 15:14:00', '2025-02-28', 'ghfghg'),
(52, '2025-02-28 16:05:00', '2025-02-28 16:08:00', '2025-02-28', 'pranavgor'),
(53, '2025-03-05 10:05:00', '2025-03-05 10:03:00', '2025-03-05', 'ses'),
(54, '2025-03-05 10:04:00', '2025-03-05 10:06:00', '2025-03-05', 'mhgjh'),
(55, '2025-03-05 10:11:00', '2025-03-05 10:12:00', '2025-03-05', 'fghf'),
(56, '2025-03-05 10:12:00', '2025-03-05 10:13:00', '2025-03-05', 'hug'),
(57, '2025-03-05 10:26:00', '2025-03-05 10:27:00', '2025-03-05', 'jhfu'),
(58, '2025-03-05 10:35:00', '2025-03-05 10:37:00', '2025-03-05', 'cvgdfg'),
(59, '2025-03-05 10:38:00', '2025-03-05 10:39:00', '2025-03-05', 'vghjfg'),
(60, '2025-03-05 11:00:00', '2025-03-05 11:02:00', '2025-03-05', 'hdd'),
(61, '2025-03-05 11:26:00', '2025-03-05 11:27:00', '2025-03-05', 'dfgdf'),
(62, '2025-03-05 11:32:00', '2025-03-05 11:34:00', '2025-03-05', 'gfhfgth'),
(63, '2025-03-05 11:45:00', '2025-03-05 11:46:00', '2025-03-05', 'ghf'),
(64, '2025-03-05 11:47:00', '2025-03-05 11:48:00', '2025-03-05', 'ydrgrd'),
(65, '2025-03-05 12:01:00', '2025-03-05 12:03:00', '2025-03-05', 'hgdfd'),
(66, '2025-03-05 13:08:00', '2025-03-05 13:09:00', '2025-03-05', 'hgfg'),
(67, '2025-03-05 13:11:00', '2025-03-05 13:12:00', '2025-03-05', 'jhvg'),
(68, '2025-03-05 13:16:00', '2025-03-05 13:17:00', '2025-03-05', 'uftf'),
(69, '2025-03-05 13:40:00', '2025-03-05 13:42:00', '2025-03-05', 'hvgvf'),
(70, '2025-03-06 10:04:00', '2025-03-06 10:05:00', '2025-03-06', 'uyguy'),
(71, '2025-03-06 10:07:00', '2025-03-06 10:08:00', '2025-03-06', 'gfhf'),
(72, '2025-03-06 12:52:00', '2025-03-06 12:53:00', '2025-03-06', 'jbbjhg'),
(73, '2025-03-06 13:00:00', '2025-03-06 13:02:00', '2025-03-06', 'nvjvhg'),
(74, '2025-03-06 13:18:00', '2025-03-06 13:20:00', '2025-03-06', 'hfgf'),
(75, '2025-03-06 13:18:00', '2025-03-06 13:20:00', '2025-03-06', ''),
(76, '2025-03-06 13:23:00', '2025-03-06 13:24:00', '2025-03-06', 'iuuguyg'),
(77, '2025-03-06 13:33:00', '2025-03-06 13:35:00', '2025-03-06', 'hftyf'),
(78, '2025-03-06 13:40:00', '2025-03-06 13:42:00', '2025-03-06', 'fyd'),
(79, '2025-03-06 13:50:00', '2025-03-06 13:52:00', '2025-03-06', 'jhguf'),
(80, '2025-03-06 13:53:00', '2025-03-06 13:55:00', '2025-03-06', 'jj'),
(81, '2025-03-06 13:56:00', '2025-03-06 13:57:00', '2025-03-06', 'khiu'),
(82, '2025-03-06 14:04:00', '2025-03-06 14:06:00', '2025-03-06', '76r7r'),
(83, '2025-03-06 14:07:00', '2025-03-06 14:09:00', '2025-03-06', ',ihjbhh'),
(84, '2025-03-06 20:07:00', '2025-03-06 20:08:00', '2025-03-06', 'tr'),
(85, '2025-03-06 20:09:00', '2025-03-06 20:11:00', '2025-03-06', 'hyh'),
(86, '2025-03-06 20:19:00', '2025-03-06 20:20:00', '2025-03-06', 'ggg'),
(87, '2025-03-06 20:21:00', '2025-03-06 20:22:00', '2025-03-06', 'kkk'),
(88, '2025-03-06 20:59:00', '2025-03-06 20:00:00', '2025-03-06', 'jj'),
(89, '2025-03-06 21:00:00', '2025-03-06 21:01:00', '2025-03-06', 'hgf'),
(90, '2025-03-07 17:04:00', '2025-03-07 17:06:00', '2025-03-07', 'Office '),
(91, '2025-03-07 17:12:00', '2025-03-07 17:14:00', '2025-03-07', 'office'),
(92, '2025-03-10 14:59:00', '2025-03-10 14:00:00', '2025-03-10', 'kk'),
(93, '2025-03-10 15:00:00', '2025-03-10 15:01:00', '2025-03-10', 'kk'),
(94, '2025-03-10 15:22:00', '2025-03-10 15:22:00', '2025-03-10', 'mn'),
(95, '2025-03-10 15:22:00', '2025-03-10 15:23:00', '2025-03-10', 'kk'),
(96, '2025-03-10 15:28:00', '2025-03-10 15:29:00', '2025-03-10', 'kk'),
(97, '2025-03-10 15:35:00', '2025-03-10 15:37:00', '2025-03-10', 'lklk'),
(98, '2025-03-10 15:40:00', '2025-03-10 15:41:00', '2025-03-10', 'kk'),
(99, '2025-03-10 16:15:00', '2025-03-10 16:17:00', '2025-03-10', '33'),
(100, '2025-03-10 16:21:00', '2025-03-10 16:22:00', '2025-03-10', 'lklk'),
(101, '2025-03-10 16:30:00', '2025-03-10 16:32:00', '2025-03-10', 'lklk'),
(102, '2025-03-10 16:35:00', '2025-03-10 16:37:00', '2025-03-10', 'lklk'),
(103, '2025-03-10 16:42:00', '2025-03-10 16:43:00', '2025-03-10', 'kj'),
(104, '2025-03-10 16:44:00', '2025-03-10 16:45:00', '2025-03-10', 'lkj'),
(105, '2025-03-10 16:54:00', '2025-03-10 16:55:00', '2025-03-10', 'jjh'),
(106, '2025-03-10 16:56:00', '2025-03-10 16:57:00', '2025-03-10', 'llkk'),
(107, '2025-03-10 16:59:00', '2025-03-10 17:00:00', '2025-03-10', 'lm'),
(108, '2025-03-11 14:41:00', '2025-03-11 14:42:00', '2025-03-11', 'mnm'),
(109, '2025-03-11 14:49:00', '2025-03-11 14:50:00', '2025-03-11', 'khk'),
(110, '2025-03-11 15:02:00', '2025-03-11 15:04:00', '2025-03-11', 'ofic'),
(111, '2025-03-11 15:10:00', '2025-03-11 15:11:00', '2025-03-11', 'kjk'),
(112, '2025-03-11 15:25:00', '2025-03-11 15:26:00', '2025-03-11', 'kjk'),
(113, '2025-03-11 15:42:00', '2025-03-11 15:44:00', '2025-03-11', 'jhh'),
(114, '2025-03-11 15:46:00', '2025-03-11 15:48:00', '2025-03-11', ',, '),
(115, '2025-03-11 15:56:00', '2025-03-11 15:57:00', '2025-03-11', 'kj'),
(116, '2025-03-11 16:00:00', '2025-03-11 16:02:00', '2025-03-11', 'hvh'),
(117, '2025-03-11 16:28:00', '2025-03-11 16:30:00', '2025-03-11', 'jhjh'),
(118, '2025-03-17 11:10:00', '2025-03-17 11:12:00', '2025-03-17', 'jh'),
(119, '2025-03-17 11:14:00', '2025-03-17 11:16:00', '2025-03-17', 'kk'),
(120, '2025-03-17 11:27:00', '2025-03-17 11:29:00', '2025-03-17', 'kk'),
(121, '2025-03-17 11:32:00', '2025-03-17 11:35:00', '2025-03-17', 'kk'),
(122, '2025-03-17 12:16:00', '2025-03-17 12:19:00', '2025-03-17', 'kmk'),
(123, '2025-03-18 13:56:00', '2025-03-18 13:58:00', '2025-03-18', 'oo'),
(124, '2025-03-18 13:59:00', '2025-03-18 13:01:00', '2025-03-18', 'pp'),
(125, '2025-03-18 14:00:00', '2025-03-18 14:02:00', '2025-03-18', 'lii'),
(126, '2025-03-18 14:10:00', '2025-03-18 14:12:00', '2025-03-18', 'zz'),
(127, '2025-03-18 14:12:00', '2025-03-18 14:14:00', '2025-03-18', 'pp'),
(128, '2025-03-18 14:15:00', '2025-03-18 14:16:00', '2025-03-18', 'll'),
(129, '2025-03-18 14:26:00', '2025-03-18 14:26:00', '2025-03-18', 'll'),
(130, '2025-03-18 15:39:00', '2025-03-18 15:41:00', '2025-03-18', 'pp'),
(131, '2025-03-19 10:27:00', '2025-03-19 10:30:00', '2025-03-19', 'll'),
(132, '2025-03-19 11:44:00', '2025-03-19 11:46:00', '2025-03-19', 'kl'),
(133, '2025-03-19 11:50:00', '2025-03-19 11:52:00', '2025-03-19', 'yty'),
(134, '2025-03-19 11:58:00', '2025-03-19 11:01:00', '2025-03-19', 'po'),
(135, '2025-03-19 11:59:00', '2025-03-19 11:01:00', '2025-03-19', 'wq'),
(136, '2025-03-19 12:00:00', '2025-03-19 12:02:00', '2025-03-19', 'rer'),
(137, '2025-04-12 11:44:00', '2025-04-12 11:44:00', '2025-04-12', ''),
(138, '2025-04-29 07:30:00', '2025-04-29 15:30:00', '2025-04-29', ''),
(139, '2025-04-29 07:37:00', '2025-04-29 07:37:00', '2025-04-29', ''),
(140, '2025-05-14 21:40:00', '2025-05-14 21:40:00', '2025-05-14', ''),
(141, '2025-05-30 18:05:00', '2025-05-30 18:05:00', '2025-05-30', '');

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

--
-- Table structure for table `dept`
--

CREATE TABLE IF NOT EXISTS `dept` (
  `deptID` int NOT NULL AUTO_INCREMENT,
  `deptName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`deptID`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dept`
--

INSERT INTO `dept` (`deptID`, `deptName`) VALUES
(1, 'Human Resources'),
(2, 'Engineering'),
(9, 'New'),
(11, 'ICT'),
(13, 'Networking'),
(14, 'Top Management'),
(15, 'Security '),
(16, 'Marketing '),
(17, 'Telecommunications '),
(18, 'Company efficiency ');

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

--
-- Table structure for table `employee`
--

CREATE TABLE IF NOT EXISTS `employee` (
  `userID` int NOT NULL,
  `firstName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `lastName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `birthdate` date NOT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `netSalary` decimal(10,2) NOT NULL,
  `photo` longblob,
  `contactNumber` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `deptID` int DEFAULT NULL,
  `gender` enum('Male','Female','Other') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `face_image` longtext COLLATE utf8mb4_general_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`userID`),
  KEY `deptID` (`deptID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee`
--

INSERT INTO `employee` (`userID`, `firstName`, `lastName`, `birthdate`, `address`, `netSalary`, `photo`, `contactNumber`, `deptID`, `gender`, `face_image`, `created_at`) VALUES
(38, 'saacid', 'faarah', '2002-04-17', 'suuqa xoolaha', 362781.00, NULL, '617141691', 1, 'Male', NULL, '2025-05-17 19:24:01');
INSERT INTO `employee` (`userID`, `firstName`, `lastName`, `birthdate`, `address`, `netSalary`, `photo`, `contactNumber`, `deptID`, `gender`, `face_image`, `created_at`) VALUES
(39, 'Dahabo', 'Artan', '1982-05-14', 'Guricel, Somalia', 5000.00, '', '615808382', 2, 'Female', '[BLOB]', '2025-05-17 19:24:01');
INSERT INTO `employee` (`userID`, `firstName`, `lastName`, `birthdate`, `address`, `netSalary`, `photo`, `contactNumber`, `deptID`, `gender`, `face_image`, `created_at`) VALUES
(40, 'Hanad', 'Mohamed', '2000-05-15', 'carafat, xamarr', 6000.00, 0x[BLOB]