-- phpMyAdmin SQL Dump
-- version 5.1.1deb5ubuntu1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 23, 2026 at 12:18 PM
-- Server version: 8.0.45-0ubuntu0.22.04.1
-- PHP Version: 8.2.23

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `MQT_RMS_DB`
--

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

--
-- Table structure for table `righttoworklists`
--

CREATE TABLE `righttoworklists` (
  `id` int NOT NULL,
  `full_name` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dob` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `nationality` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `passport_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `passport_expiry` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `brp_card_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `education_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `indefinite_leave_details` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `job_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `worked_hour_per_week` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `right_to_work_code` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `right_to_work_expiry` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `right_to_work_document` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `passport_proof` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `brp_card_proof` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `brp_card_expiry` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `photo` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `education_proof` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `university_degree` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `checked_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
  `checked_at` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `last_checked_at` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_by` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `righttoworklists`
--

INSERT INTO `righttoworklists` (`id`, `full_name`, `dob`, `phone`, `email`, `nationality`, `address`, `passport_no`, `passport_expiry`, `brp_card_no`, `education_details`, `indefinite_leave_details`, `job_title`, `worked_hour_per_week`, `right_to_work_code`, `right_to_work_expiry`, `right_to_work_document`, `passport_proof`, `brp_card_proof`, `brp_card_expiry`, `photo`, `education_proof`, `university_degree`, `checked_by`, `checked_at`, `last_checked_at`, `created_by`, `status`) VALUES
(8, 'Sanket Bapu Pawar', '1999-10-28', '+44 7946711998', 'pawarsanket181@gmail.com', 'India', '89A Ryan and Rohan house Kingsley Road , Hounslow east , London , TW34AH', 'U2556771', '2029-12-25', 'RY5859117', 'B.E in Electronics and Telecommunication ', '28', 'Test Engineer Intern', '40', NULL, NULL, 'right_to_work_check (5).pdf', 'Sanket passport.pdf', 'Sanket BRP.pdf', '2023-03-31', 'Sanket photo.jpeg', 'Transcript certificate.pdf', NULL, '32', 'London, United Kingdom', '2022-05-06', '29374455', 1),
(9, 'Rahul Ashok Kadam', '0199-10-04', '+44 7535381159', 'rahulrkadam19@gmail.com', 'India', NULL, 'V5059066', '2031-12-20', 'RX0782605', 'B.E in Electronics & Telecommunications Engineering ', NULL, 'Test Engineer Intern', '40', NULL, NULL, NULL, 'Rahul Kadam Passport.pdf', 'BRP.pdf', '2023-09-18', 'Rahul Photo.jpeg', 'Transcript_Certificate_Rahul.pdf', NULL, '32', 'London, United Kingdom', '2022-10-17', '14', 2),
(10, 'Sarthak Ravindra Mhatre', '1999-10-15', '07506359744', 'Sarthak.mhatre22@gmail.com', 'India', '89A, Ryan and Rohan house, Kingsley road, Hounslow East, London, TW34AH', 'S4061133', '2028-05-29', 'RY0859043', 'BE in Electronics and Telecommunication engineering', NULL, 'Test Engineer Intern', '40', NULL, NULL, NULL, 'Sarthak Passport.pdf', 'Sarthak BRP.pdf', '2023-03-31', 'Sarthak Photo.jpeg', 'Transcript_Sarthak (1).pdf', NULL, '32', 'London, United Kingdom', '2022-04-14', '14', 2),
(11, 'Rohit Laxmikant Sawant', '1985-02-20', '447984639356', 'rsawant@marquistech.com', 'India', '20 Selwood Gardens Stanwell, Staines- Upon-Thames TW19 7NX London', 'Z4234056', '2027-05-23', 'RK7793640', 'B.E in Electronics & Telecommunications Engineering ', NULL, 'General Manager Operations (Engineering)', '40', NULL, NULL, NULL, 'Rohit Sawant New passport.pdf', 'Rohit BRP.pdf', '2023-11-23', 'Rohit Photo.jpg', NULL, NULL, '1', 'Online from Navi Mumbai, India', '2021-01-27', '14', 1),
(12, 'Vishwanath Prabhakar Madduru', '1999-02-21', '+91 8779393320', 'vmadduru@marquistech.com', 'India', '89A Ryan and Rohan House, Kingsley Road, Hounslow, TW34AH', 'T7985319', '2029-09-02', 'R27787543', 'Bachelors in Electronics and Telecommunications', NULL, 'Test Engineer Intern', '40', NULL, NULL, NULL, 'Vishwanath passport.pdf', 'Vishwanath BRP.pdf', '2022-08-31', NULL, 'Scan20210701105253.pdf', NULL, '32', 'London, United Kingdom', '2022-09-20', '14', 2),
(13, 'Rushikesh Vijay Shinde', '1994-04-13', '91 7039392937', 'er.rushishinde@gmail.com', 'India', '89A, Ryan and Rohan House ,Kingsley Road ,Hounslow East TW3 4AH', 'T1855434', '2028-12-17', 'RY7150707', 'BE Electronics and Telecommunication', NULL, 'Test Engineer Intern', '40', NULL, NULL, NULL, 'Rushikesh Passport.pdf', 'Rushikesh BRP.pdf', '2022-11-23', NULL, 'Transcript .pdf', NULL, '32', 'London, United Kingdom', '2021-12-01', '14', 2),
(14, 'Kishore Kumar Kola', '1997-05-24', '+44 7515 495812', 'kkola@marquistech.com', 'United Kingdom', '18 ST AWDRYS ROAD BARKING IG117QD', '559772724', '2029-04-07', '559772724', NULL, NULL, 'Test Engineer', '40', NULL, NULL, NULL, 'British Passport.jpg', 'British Passport.jpg', '2029-04-07', NULL, NULL, NULL, '32', 'London, United Kingdom', '2022-03-01', '14', 2),
(16, 'Ankit Patel', '1997-10-17', '+447765673952', 'anpatel@marquistech.com', 'India', '29, Calder Gardens, HA8 5PR', 'M3239925', '2024-10-29', 'RYX896500', 'Master of Science in Electronics Engineering', NULL, 'Test Engineer', '40', NULL, NULL, NULL, 'passport.pdf', 'BRP Graduate.pdf', '2024-03-25', 'Pic.png', 'masters certificate.pdf', NULL, '0', NULL, NULL, '1', 2),
(17, 'Emin James Hovanessian', '1995-01-23', '+44 7861757066', 'ehovanessian@marquistech.com', 'Virgin Islands (British)', NULL, '128081792', '2032-02-07', '73882147', 'Bachelor in Electronic Engineering', NULL, 'Test Engineer', '40', NULL, NULL, NULL, 'Passport.jpg', NULL, '2024-03-31', 'Self photograph.jpg', 'Degree.png', NULL, '0', NULL, NULL, '1', 2),
(18, 'Charan Potli', '1995-01-05', '+44 7417464755', 'cpotli@marquistech.com', 'India', '35 Olympia House Iver Buckinghamshire SL0 9BY', 'P4701520', '2026-09-19', 'RZO459482', 'Masters of Science in Cyber Security', 'NA', 'Senior Test Engineer ', '40', NULL, '2025-07-23', 'right_to_work_check (3).pdf', NULL, NULL, '2024-04-24', NULL, 'masters hertfordshire certificate_Charan Potli.jpg', NULL, '0', NULL, NULL, '14', 1),
(19, 'Atul Nikam', '1997-01-17', '+91 9922011948', 'anikam@marquistech.com', 'India', '89A, Kingsley Road, Ryan and Rohan House, Hounslow East, Post code- TW34AH', 'X7068444', '2033-02-26', 'RV4908530', 'BE in Electronics and Telecommunication Engineering', 'NA', 'Test Engineering - Intern', '40', 'WJAXL73GA', '2024-08-14', 'right_to_work_check (3).pdf', 'Passport True copy .pdf', 'BRP Document .pdf', '2024-08-14', 'PASSPORT SIZE PHOTO..pdf', 'BE Marksheet..all.pdf', NULL, '0', NULL, NULL, '14', 2),
(20, 'Amol Saxena', '1991-08-21', '+44 7721 704216', 'asaxena@marquistech.com', 'India', NULL, 'U1217973', '2029-11-05', 'RU8712785', 'Bachelor of Technology', 'NA', 'Senior Test Engineer ', '40 hrs', 'WTJ 8H7 45M', '2025-10-15', 'right_to_work_check (3).pdf', 'Amol Passport copy.pdf', 'Amol BRP.pdf', '2024-12-31', 'Amol photo.pdf', 'Amol Degree certificate.pdf', NULL, '0', NULL, NULL, '14', 1),
(21, 'Vignesh Poojary', '2001-05-02', '98926 59766', 'vpoojary@marquistech.com', 'India', '75 juniper court , Hanworth Road , Hounslow central TW33TL', 'B9764335', '2034-01-22', 'RS5325422', 'B.tech', NULL, 'Test Engineer', NULL, 'WRDGCM49C', '2025-07-21', 'right_to_work_check_Vignesh.pdf', 'Passport.pdf', 'BRP.pdf', '2024-12-31', 'Photo.jpeg', 'Degree Certificate.pdf', NULL, '0', NULL, NULL, '29374455', 2),
(22, 'Pavan Kumar Koduri', '1996-08-09', '+44 7448 445142', 'pkoduri@marquistech.com', 'India', '80 Ryefield Avenue Uxbridge UB10 9BZ', 'T5255821', '2029-05-12', 'RT7770695', 'B.E in Electronics & Communications Engineering', 'NA', 'Test Engineer', '40', ' ', '2027-04-15', 'right_to_work_check (4).pdf', 'PASS PORT.pdf', 'BRP front side.jpg', '2024-12-31', 'Photo.jpg', 'ENGINEERING.pdf', NULL, '0', NULL, NULL, '14', 1),
(23, 'Vivek Raval', '1996-10-29', '+44 7867054182', 'vraval@marquistech.com', 'India', 'Flat 3, 1 Bond Street, B19 3LB, Birmingham, United Kingdom', ' T4041990', '2029-02-11', 'RT4667592', 'B.E in Electronic and communication', NULL, 'Test Engineer', NULL, 'WGM WFB 4CP', '2026-02-24', 'Right to work permit.png', NULL, 'Vivek Raval_PSW_BRP.pdf', '2024-12-31', '4506_0632380.jpg', 'Vivek_Sem1_to_Sem8_BE_Marksheets.pdf', NULL, '0', NULL, NULL, '29374455', 1),
(24, 'Tejas Sakharam jadhav', '2001-09-04', '+918956049526', 'tejadhav@marquistech.com', 'India', NULL, 'Y8325888', '2023-08-25', 'RS8430832', 'B.tech in Electronics and communication', NULL, 'Test Engineer ', NULL, 'RS8430832', '2024-11-16', 'right_to_work_check_Tejas.pdf', 'passport  (1).pdf', 'BRP_2024_08_19_13_24_56_276.pdf', '2024-12-31', 'Photo.jpg', 'Degree_certificate.pdf', NULL, '0', NULL, NULL, '29374455', 2),
(25, 'Parash Chapani', '1991-03-02', '07867051521', 'pchapani@marquistech.com', 'India', '43, HIGH WORPLE, HARROW, LONDON. POST CODE – HA2 9SX', 'X7359717', '2033-06-06', 'RT1549596', 'B.E in Electronic and communication', '28', 'Test Engineer', NULL, 'W85 A5S 4SK', '2026-02-09', 'right_to_work_check.pdf', 'Passport address.PDF', 'BRP front.PDF', '2026-02-09', NULL, 'B.E Certificate.pdf', NULL, '0', NULL, NULL, '29374455', 1),
(26, 'Arpit Ghodake', '1998-07-16', '8104829760', 'aghodake@marquistech.com', 'India', '75 juniper court , Hanworth Road , Hounslow central TW33TL', 'V9800344', '2032-04-18', 'RS8703805', 'B.E in Electronic and communication', NULL, 'Test Engineer', NULL, 'WFL 9XW 4BF', '2025-08-14', NULL, 'passport .pdf', 'BRP_ARPIT.pdf', '2024-12-31', 'PHOTO (1).jpeg', 'Degree certificate.pdf', NULL, '0', NULL, NULL, '29374455', 1),
(27, 'Daniel Michael Dharmaraj Aloysius', '1994-08-01', '+447919809719', 'daloysius@marquistech.com', 'India', 'Flat 9, 67-69 The Greenway, Uxbridge UB8 2PL - London,UK', 'Z6309645', '2032-02-02', ' SB6 69M 3GK', 'B.E in Electronic and communication', 'NA', 'Senior Test Engineer', '40', ' SB6 69M 3GK', '2026-11-17', 'Daniel Uk e visa.jpeg', 'Passport_Daniel_Z6309645.pdf', NULL, '2026-11-17', 'Photo of Resource.JPEG', 'Degree Certificate.pdf', NULL, '0', NULL, NULL, '14', 1),
(28, 'ARADHYA SHRIKANT SAWANT', '2001-08-24', '+44 7587777982', 'aradhya.sawant.2408@gmail.com', 'India', '75 juniper court , Hanworth Road , Hounslow central TW33TL', 'Y7484821', '2033-08-04', '00', 'Bachelor Of Engineering', 'NA', 'Test Engineer Intern', '40', 'WTE JSP 3B9', '2025-12-01', 'right_to_work_check (1).pdf', 'Passport signed and verified.pdf', NULL, '2025-12-01', 'photo.pdf', 'degree certificate.pdf', NULL, '0', NULL, NULL, '14', 1),
(30, 'Jayesh Kunbi', '1992-04-24', '+447424548430', 'jayeshkunabi05@gmail.com', 'India', '102, Aspects Court, Slough SL1 2EZ', 'Z5749285', '2031-10-17', NULL, 'Bachelor in Engineering', NULL, 'Project Manager', '40', NULL, '2026-12-01', 'Jayesh UK e visa .jpeg', 'PassportCopy_Jayesh.pdf', NULL, '2026-12-01', 'Jayesh Photo.jpg', NULL, NULL, '0', NULL, NULL, '14', 1),
(31, 'Leroy Pereira', '1989-12-18', '+919833641126', 'lpereira@marquistech.com', 'India', '20-28 Mill St. Flat 5, Churchill House SL2 5DH Slough, United Kingdom', 'AE569738', '2035-05-08', 'Yes', 'Bachelor of Engineering ', NULL, 'Test Engineer ', NULL, 'WC8 42L 6PZ ', '2027-10-14', 'Leroy right_to_work_check (1).pdf', 'Leroy New Passport 2025 full (1).jpeg', NULL, '2027-10-14', NULL, NULL, NULL, '0', NULL, NULL, '29374455', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `righttoworklists`
--
ALTER TABLE `righttoworklists`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `phone` (`phone`),
  ADD UNIQUE KEY `email` (`email`),
  ADD UNIQUE KEY `passport_no` (`passport_no`),
  ADD UNIQUE KEY `brp_card_no` (`brp_card_no`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `righttoworklists`
--
ALTER TABLE `righttoworklists`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
