--
-- Host: localhost    Database: nadeen2
-- ------------------------------------------------------


--
-- Table structure for table `Jobs`
--

CREATE TABLE `Jobs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `jobTitle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `yearsOfExperiance` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Description` varchar(5000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'posted',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Jobs`
--

INSERT INTO `Jobs` VALUES (2,'QA','Amman','6-7','yhhghgh','posted'),(18,'Sr. PHP Developer and Sale Force effectiveness Lead','test','11','test','posted');

--
-- Table structure for table `NDAApprovals`
--

CREATE TABLE `NDAApprovals` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userId` int NOT NULL,
  `status` varchar(10) COLLATE utf8mb3_unicode_ci NOT NULL,
  `signture` varchar(200) COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `NDAApprovals`
--

INSERT INTO `NDAApprovals` VALUES (1,6,'Approved','signtures/sig-6922c84800afa0.42812143.txt'),(2,17,'Approved','signtures/sig-6953e3afe13af5.05467663.txt'),(3,17,'Approved','signtures/sig-6953e3fac05501.79642728.txt'),(4,17,'Approved','signtures/sig-6953e3fec4c8f1.44689008.txt'),(5,17,'Approved','signtures/sig-6953e40aecc027.90121251.txt'),(6,17,'Approved','signtures/sig-6953e48820e012.76053048.txt');

--
-- Table structure for table `applicants`
--

CREATE TABLE `applicants` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phoneNumber` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cv` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `coverLetter` varchar(6000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `JobID` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `applicants`
--

INSERT INTO `applicants` VALUES (1,'saqer basem','saqeralnairab@gmail.com','0790089551','uploads/Tasneem CV Updated.pdf','sa',1),(2,'nadine al-saifi','nadinenihadals@gmail.com','0799729026','uploads/bulk-upload - completed.xlsx','aaaa',1),(3,'nadine alsaifi','nadinenihadals@gmail.com','0799729027','uploads/bulk-upload - completed.xlsx','qqqqqq',1),(4,'test','saqeralnairab@gmail.com','+962790089551','uploads/images.png','test',1);

--
-- Table structure for table `attendance`
--

CREATE TABLE `attendance` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `attendance_date` varchar(20) NOT NULL,
  `checkin_time` varchar(20) DEFAULT NULL,
  `checkout_time` varchar(20) DEFAULT NULL,
  `lat` decimal(10,8) DEFAULT NULL,
  `lng` decimal(11,8) DEFAULT NULL,
  `distance` int unsigned DEFAULT NULL,
  `checkout_accuracy` int unsigned DEFAULT NULL,
  `checkout_lat` decimal(10,8) DEFAULT NULL,
  `checkout_lng` decimal(11,8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `attendance`
--

INSERT INTO `attendance` VALUES (1,6,'2025-12-22','2025-12-22 20:33:38',NULL,31.85499690,35.94257370,0,NULL,NULL,NULL),(2,17,'2026-01-05','2026-01-05 13:08:15',NULL,31.99913714,35.84594051,22057,NULL,NULL,NULL),(3,17,'2026-01-05','2026-01-05 13:08:15',NULL,31.99913714,35.84594051,22057,NULL,NULL,NULL),(4,17,'2026-01-07','2026-01-07 13:13:21',NULL,31.99894334,35.84585572,22058,NULL,NULL,NULL),(5,6,'2026-01-09','2026-01-09 18:40:20','2026-01-09 18:40:41',31.99913714,35.84594051,22057,22057,31.99913714,35.84594051),(6,6,'2026-01-09','2026-01-09 18:40:23','2026-01-09 18:40:41',31.99913714,35.84594051,22057,22057,31.99913714,35.84594051),(7,6,'2026-01-12','2026-01-12 21:18:00','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(8,6,'2026-01-12','2026-01-12 21:18:00','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(9,6,'2026-01-12','2026-01-12 21:18:00','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(10,6,'2026-01-12','2026-01-12 21:18:00','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(11,6,'2026-01-12','2026-01-12 21:18:00','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(12,6,'2026-01-12','2026-01-12 21:18:00','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(13,6,'2026-01-12','2026-01-12 21:18:01','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(14,6,'2026-01-12','2026-01-12 21:18:01','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(15,6,'2026-01-12','2026-01-12 21:18:01','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(16,6,'2026-01-12','2026-01-12 21:18:01','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(17,6,'2026-01-12','2026-01-12 21:18:01','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(18,6,'2026-01-12','2026-01-12 21:18:01','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(19,6,'2026-01-12','2026-01-12 21:18:01','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(20,6,'2026-01-12','2026-01-12 21:18:02','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(21,6,'2026-01-12','2026-01-12 21:18:02','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(22,6,'2026-01-12','2026-01-12 21:18:02','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(23,6,'2026-01-12','2026-01-12 21:18:02','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(24,6,'2026-01-12','2026-01-12 21:18:02','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(25,6,'2026-01-12','2026-01-12 21:18:02','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(26,6,'2026-01-12','2026-01-12 21:18:03','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(27,6,'2026-01-12','2026-01-12 21:18:03','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(28,6,'2026-01-12','2026-01-12 21:18:03','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398),(29,6,'2026-01-12','2026-01-12 21:18:03','2026-01-12 21:19:03',31.99931143,35.84601211,22077,22167,31.99944645,35.84565398);

--
-- Table structure for table `interviews`
--

CREATE TABLE `interviews` (
  `id` int NOT NULL AUTO_INCREMENT,
  `applicantID` int NOT NULL,
  `time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `interviews`
--

INSERT INTO `interviews` VALUES (1,1,'2025-11-30T14:25'),(2,1,'2026-01-02T10:13'),(3,0,'2025-12-03T13:16'),(5,1,'2025-12-04T12:31'),(7,1,'2025-12-17T13:09');

--
-- Table structure for table `leaves`
--

CREATE TABLE `leaves` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `userID` int unsigned NOT NULL,
  `leave_date` varchar(20) NOT NULL,
  `leave_type` varchar(50) NOT NULL,
  `status` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `leaves`
--

INSERT INTO `leaves` VALUES (1,6,'2025-12-31','Personal','Approved'),(2,6,'2025-12-25','Sick','Approved'),(3,6,'2025-12-24','Sick','inserted'),(4,17,'2025-12-31','Personal','inserted'),(5,6,'2026-01-13','Personal','inserted'),(6,6,'2026-01-07','Sick','Approved'),(7,6,'2026-01-13','Sick','inserted'),(8,6,'','Personal','inserted'),(9,6,'2026-01-14','Personal','Approved');

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `message` varchar(500) COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` VALUES (1,'test','','',''),(2,'test','','',''),(3,'test2','','',''),(4,'test message','','',''),(5,'test message','','',''),(6,'Add your lifepulsecrm.com website in Google Search Index to have it displayed in Web Search Results.\r\n\r\nRegister lifepulsecrm.com at https://searchregister.info','contact@domainreg.pro','Benjamin','Spring'),(7,'Hi http://lifepulsecrm.com,\r\n\r\nThe New Year is coming, and this is the perfect time to upgrade your SEO and attract more customers.\r\n\r\nPlease share your target countries and main services so I can prepare your New Year SEO plan.\r\n\r\nExcited to support your growth this year.\r\n\r\nThank You,\r\nDeepa','deepa.dgtlsolution@gmail.com','Deepa','Gupta');

--
-- Table structure for table `nationalities`
--

CREATE TABLE `nationalities` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nationality` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `nationalities`
--

INSERT INTO `nationalities` VALUES (1,'Jordanian'),(2,'Lebanese'),(3,'Syrian'),(4,'Iraqi'),(5,'Palestinian'),(6,'Qatari'),(7,'Omani'),(8,'Emirati'),(9,'Kuwaiti'),(10,'Bahraini');

--
-- Table structure for table `objectives`
--

CREATE TABLE `objectives` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userId` int NOT NULL,
  `objective` varchar(5000) DEFAULT NULL,
  `rate` int DEFAULT NULL,
  `rate_date` date DEFAULT NULL,
  `month` int DEFAULT NULL,
  `year` int DEFAULT NULL,
  `comments` varchar(5000) DEFAULT NULL,
  `file` varchar(5000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `objectives`
--

INSERT INTO `objectives` VALUES (6,6,'test ',90,'2025-12-03',1,2025,NULL,NULL),(7,6,'test ',70,'2025-12-03',2,2025,NULL,NULL),(8,6,'hjkl;',90,'2025-12-07',2,2025,NULL,NULL),(9,6,'nadine',90,'2025-12-14',3,2025,NULL,NULL),(10,6,'nadine',0,NULL,3,2025,NULL,NULL),(11,6,'testt objv',0,NULL,6,2025,NULL,NULL),(12,6,'testt objv',0,NULL,6,2025,NULL,NULL),(13,6,'t2',60,'2025-12-07',4,2025,NULL,NULL),(14,6,'ts',0,NULL,8,2025,NULL,NULL),(15,6,'test 1',90,'2025-12-14',4,2025,'test comments',NULL),(16,6,'test 2',0,NULL,3,2025,'test comments2',NULL),(17,6,'nnnn',0,NULL,3,2027,'nnnnn',NULL),(18,6,'test doc',89,'2025-12-14',12,2025,'nnn',NULL),(19,9,'testtest',89,'2025-12-14',1,2025,'hhh',NULL),(20,6,'kpi',100,'2025-12-16',1,2025,'fghjkl',NULL),(21,6,'test',0,NULL,1,2026,'test 1 ','Picture2.png'),(22,6,'test 2',0,NULL,2,2026,'test 2 ','Screenshot 2025-09-16 105239.png'),(23,6,'test',0,NULL,1,2025,'test','Picture2.png');

--
-- Table structure for table `positions`
--

CREATE TABLE `positions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `positions`
--

INSERT INTO `positions` VALUES (1,'Developer'),(2,'Team Leader'),(3,'QA'),(4,'Project Manager'),(5,'Trainee'),(6,'HR'),(7,'Recruiter'),(8,'CEO'),(9,'CHRO'),(10,'CTO');

--
-- Table structure for table `rates`
--

CREATE TABLE `rates` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userid` int NOT NULL,
  `rate` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `rates`
--

INSERT INTO `rates` VALUES (1,9,4),(2,9,4),(3,9,5),(4,9,5),(5,6,0),(6,6,5),(7,6,0),(8,6,0),(9,6,0),(10,9,0),(11,9,5),(12,9,5),(13,6,0),(14,6,5),(15,6,4),(16,6,0),(17,6,5),(18,6,5),(19,6,5),(20,6,5),(21,6,5),(22,6,5),(23,6,5),(24,6,5),(25,6,5),(26,6,5),(27,6,5),(28,6,4),(29,9,1),(30,6,4),(31,9,3),(32,9,5),(33,6,5),(34,6,5),(35,6,5),(36,6,5);

--
-- Table structure for table `timesheet`
--

CREATE TABLE `timesheet` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userid` int NOT NULL,
  `tasks` varchar(1000) COLLATE utf8mb3_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `status` varchar(10) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'new',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `timesheet`
--

INSERT INTO `timesheet` VALUES (1,6,'test','2025-11-19','Completed'),(2,17,'nnnn','2025-12-30','Completed'),(5,17,'nnnn','2026-01-06','new');

--
-- Table structure for table `usersMessages`
--

CREATE TABLE `usersMessages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sender_id` int NOT NULL,
  `recipient_id` int NOT NULL,
  `subject` varchar(100) COLLATE utf8mb3_unicode_ci NOT NULL,
  `message` varchar(500) COLLATE utf8mb3_unicode_ci NOT NULL,
  `status` varchar(20) COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `usersMessages`
--

INSERT INTO `usersMessages` VALUES (1,5,6,'test','test',''),(2,5,6,'test','nnnnn',''),(3,6,5,'hi','asking','');


