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

START TRANSACTION;



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

--
-- Table structure for table `candidates`
--

CREATE TABLE `candidates` (
  `id` int(255) NOT NULL,
  `added_by` varchar(255) DEFAULT NULL,
  `agency` varchar(255) DEFAULT NULL,
  `agency_id` int(250) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `job_title` varchar(255) DEFAULT NULL,
  `qualification` varchar(255) DEFAULT NULL,
  `expected_salary` varchar(255) DEFAULT NULL,
  `current_salary` varchar(255) DEFAULT NULL,
  `experience` varchar(255) DEFAULT NULL,
  `hourly_rate` int(10) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `resume` text DEFAULT NULL,
  `picture` text DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `candidates`
--

INSERT INTO `candidates` (`id`, `added_by`, `agency`, `agency_id`, `name`, `email`, `phone`, `website`, `location`, `address`, `job_title`, `qualification`, `expected_salary`, `current_salary`, `experience`, `hourly_rate`, `status`, `resume`, `picture`, `created_at`) VALUES
(27, 'agency', 'LATAM UPDATED', 74, 'Sufiyan', 'sualeh@gmail.com', '34567', 'https://www.website.com', 'Karachi', 'Address', 'Title', 'Intermediate / A Levels', '3', '32', 'Fresh', 3, 'Active', 'Sufiyan_ID-123521.pdf', 'Sualeh_company1.png', '2023-09-20'),
(28, 'agency', 'LATAM UPDATED 2', 74, 'Sualeh', 'sualeh@gmai.com', '895678', 'https://www.wbs.com', 'Karachi', 'Addrerss', 'fghjk', 'Intermediate / A Levels', '792', '2', '0 - 6 Months', 2, 'Active', 'Sualeh_ID-123521.pdf', 'Sualeh_company1.png', '2023-09-20');

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

--
-- Table structure for table `candidates_notes`
--

CREATE TABLE `candidates_notes` (
  `id` int(250) NOT NULL,
  `added_by_name` varchar(250) DEFAULT NULL,
  `added_by_id` int(250) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `added_by_role` varchar(250) DEFAULT NULL,
  `added_by_picture` text DEFAULT NULL,
  `for_job` varchar(250) DEFAULT NULL,
  `for_JobId` int(250) DEFAULT NULL,
  `for_Candidate` varchar(250) DEFAULT NULL,
  `for_CandidateId` int(250) DEFAULT NULL,
  `for_submitCandId` int(250) DEFAULT NULL,
  `created_at` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int(11) NOT NULL,
  `logged_id` int(255) DEFAULT NULL,
  `logged_role` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `date` text DEFAULT NULL,
  `created_at` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`id`, `logged_id`, `logged_role`, `title`, `description`, `color`, `start_time`, `end_time`, `date`, `created_at`) VALUES
(29, 16, 'admin', 'Test Event 15', 'sasas', '#671e1e', '14:20:00', '15:20:00', '2023-09-15', '2023-09-18'),
(30, 39, 'company', '29 Event', 'blah blah', '#6f2525', '17:07:00', '17:20:00', '2023-09-29', '2023-09-18'),
(31, 45, 'company', 'sas', 'Sualeh', '#e02929', '20:27:00', '21:27:00', '2023-09-21', '2023-09-20'),
(32, 39, 'company', 'Sualeh Interview for Creative Proposal Developer', '4356789asASasA', 'undefined', '01:00:00', '01:30:00', '2023-09-28', '2023-09-26');

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

--
-- Table structure for table `feedbacks`
--

CREATE TABLE `feedbacks` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

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

CREATE TABLE `interviews` (
  `id` int(11) NOT NULL,
  `candidate_id` int(255) DEFAULT NULL,
  `candidate_submit_id` int(255) DEFAULT NULL,
  `candidate_name` varchar(255) DEFAULT NULL,
  `candidate_email` varchar(255) DEFAULT NULL,
  `candidate_image` text DEFAULT NULL,
  `for_jobId` int(255) DEFAULT NULL,
  `for_job` varchar(255) DEFAULT NULL,
  `agency_id` int(255) DEFAULT NULL,
  `agency_email` varchar(255) DEFAULT NULL,
  `interview_time` text DEFAULT NULL,
  `interview_date` text DEFAULT NULL,
  `interview_type` varchar(255) DEFAULT NULL,
  `meeting_link` text DEFAULT NULL,
  `schedule_by_company` varchar(255) DEFAULT NULL,
  `schedule_by_company_id` int(255) DEFAULT NULL,
  `interview_notes` text DEFAULT NULL,
  `interview_status` varchar(255) DEFAULT NULL,
  `created_at` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `interviews` (`id`, `candidate_id`, `candidate_submit_id`, `candidate_name`, `candidate_email`, `candidate_image`, `for_jobId`, `for_job`, `agency_id`, `agency_email`, `interview_time`, `interview_date`, `interview_type`, `meeting_link`, `schedule_by_company`, `schedule_by_company_id`, `interview_notes`, `interview_status`, `created_at`) VALUES
(58, 28, 58, 'Sualeh', 'sualeh@gmai.com', '/uploads/admin/images/Sualeh_company1.png', 43, 'Creative Proposal Developer', 74, 'latam@gmail.com', '01:00 PM-01:30 PM', '2023-09-28', 'Panel Interview', 'https://www.meeting.com', 'Jetnetiix Company ', 39, '4356789asASasA', 'Scheduled', '2023-09-26');

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` int(255) NOT NULL,
  `added_by` varchar(255) DEFAULT NULL,
  `job_title` varchar(255) DEFAULT NULL,
  `industry` varchar(255) DEFAULT NULL,
  `func_area` varchar(255) DEFAULT NULL,
  `positions` int(255) DEFAULT NULL,
  `shift` varchar(255) DEFAULT NULL,
  `job_type` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `qualification` varchar(255) DEFAULT NULL,
  `career` varchar(255) DEFAULT NULL,
  `experience` varchar(10) DEFAULT NULL,
  `apply_before` varchar(10) DEFAULT NULL,
  `salary_range` varchar(10) DEFAULT NULL,
  `skills` varchar(255) DEFAULT NULL,
  `job_desc` longtext DEFAULT NULL,
  `job_status` varchar(255) DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `company_id` int(250) DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` (`id`, `added_by`, `job_title`, `industry`, `func_area`, `positions`, `shift`, `job_type`, `location`, `gender`, `qualification`, `career`, `experience`, `apply_before`, `salary_range`, `skills`, `job_desc`, `job_status`, `company`, `company_id`, `created_at`) VALUES
(40, 'company', 'Software Developer - Next.js', 'Information Technology', 'Web App', 3, 'First Shift ( Morning )', 'Full Time ( Remote )', 'NY , London', 'No Preference', 'Undergraduate', 'Mid Level', '+ 3 Year', '2023-09-30', '2', 'React,Next.js,Typescript,Bootstrap,Tailwind', '<h2>About the job</h2><p><span style=\"color: rgba(0, 0, 0, 0.9);\">About Company:</span></p><p><br></p><p><span style=\"color: rgba(0, 0, 0, 0.9);\">At CodeNinja, we believe that there is a lot of untapped engineering potential in the world—and we re here to tap it. We re a mission-driven software company of 250+ engineers striving to solve the world s hardest problems for people, businesses, and Governments by tapping the untapped engineering potential of High-Growth and emerging markets.</span></p><p><br></p><p><span style=\"color: rgba(0, 0, 0, 0.9);\">About Role:</span></p><p><br></p><p><span style=\"color: rgba(0, 0, 0, 0.9);\">As a React.JS Developer, you will be a vital part of this mission, working with a team of talented professionals to create innovative solutions that change the world. Your primary responsibility will be to design and develop user-friendly, high-performance web applications that meet the needs of our clients. In this fast-paced and dynamic work environment, you will be challenged to push your skills to the limit, while constantly growing and learning.</span></p><p><br></p><p><span style=\"color: rgba(0, 0, 0, 0.9);\">Responsibilities:</span></p><p><br></p><ul><li><span style=\"color: rgba(0, 0, 0, 0.9);\">Develop new features and fix existing bugs in our web application</span></li><li><span style=\"color: rgba(0, 0, 0, 0.9);\">Attend our 2-week sprint cycles and get tasks assigned and help evaluate the complexity</span></li></ul><p><br></p><p><span style=\"color: rgba(0, 0, 0, 0.9);\">of tasks for other team members</span></p><p><br></p><ul><li><span style=\"color: rgba(0, 0, 0, 0.9);\">Giving and accepting constructive feedback, as well as being able to provide</span></li></ul><p><br></p><p><span style=\"color: rgba(0, 0, 0, 0.9);\">counter-points</span></p><p><br></p><ul><li><span style=\"color: rgba(0, 0, 0, 0.9);\">Assist other team members in resolving bugs that they may get stuck on</span></li><li><span style=\"color: rgba(0, 0, 0, 0.9);\">Optimize the rendering speed of pages, images, and React interactions</span></li><li><span style=\"color: rgba(0, 0, 0, 0.9);\">We want to put emphasis on the candidate being good with design as well</span></li></ul><p><br></p><p><span style=\"color: rgba(0, 0, 0, 0.9);\">Requirements</span></p><p><br></p><ul><li><span style=\"color: rgba(0, 0, 0, 0.9);\">As a frontend developer of 4+ years of experience, you will be working with Saudi fin-tech solution and understand how it operates. Moreover, you will also get the chance to optimize existing code, and use/add-to our flexible frontend technology stack (React, Next.js, TypeScript, and bootstrap-react)</span></li></ul><p><br></p><p><span style=\"color: rgba(0, 0, 0, 0.9);\">Must Have:</span></p><p><br></p><ul><li><span style=\"color: rgba(0, 0, 0, 0.9);\">React, Next.js, TypeScript, and bootstrap-react</span></li><li><span style=\"color: rgba(0, 0, 0, 0.9);\">4+ years of experience </span></li></ul><p><br></p><p><span style=\"color: rgba(0, 0, 0, 0.9);\">Nice to Have:</span></p><p><br></p><ul><li><span style=\"color: rgba(0, 0, 0, 0.9);\">Experience with fin-tech solutions, particularly in Saudi</span></li><li><span style=\"color: rgba(0, 0, 0, 0.9);\">Familiarity with agile methodologies, especially 2-week sprint cycles</span></li><li><span style=\"color: rgba(0, 0, 0, 0.9);\">Proven track record in debugging and helping team members troubleshoot issues</span></li></ul><p><br></p><p><span style=\"color: rgba(0, 0, 0, 0.9);\">Benefits</span></p><p><br></p><ul><li><span style=\"color: rgba(0, 0, 0, 0.9);\">Gratuity </span></li><li><span style=\"color: rgba(0, 0, 0, 0.9);\">Insurance </span></li><li><span style=\"color: rgba(0, 0, 0, 0.9);\">Gym Subscription</span></li><li><span style=\"color: rgba(0, 0, 0, 0.9);\">Market Competitive Pay</span></li></ul>', 'Active', 'Temp Email', 45, '2023-09-20'),
(41, 'company', 'Flutter Dev', 'Information Technology', 'Mobile App', 2, 'First Shift ( Morning )', 'Full Time ( Onsite )', 'Location', 'Male', 'Undergraduate', 'Fresh Graduate', 'Fresh', '2023-12-31', '2', 'HTM,CSS,KO,OK', '<h2>WE ARE LOOKING FOR A QUALIFIED FLUTTER DEVELOPER</h2>', 'Active', 'Temp Email', 45, '2023-09-20'),
(42, 'company', 'Full Stack Engineer', 'Information Technology', 'Web App', 2, 'First Shift ( Morning )', 'Full Time ( Onsite )', 'Karachi', 'Male', 'Intermediate / A-Level', 'Fresh Graduate', 'Fresh', '2023-09-30', '2', 'JS ,TS,REACT,NEXT.JS', '<p>Role: Full-stack developer</p><p>Type: Full-time</p><p><br></p><p>About Us:</p><p>At Micro1, we\'re passionate about connecting top-tier remote developers with handpicked Silicon Valley companies. Our goal is to provide developers with competitive and stable income and access to the best companies in the industry, all while offering them a flexible work environment and a host of amazing benefits. We\'re proud to work with trusted partners such as Webflow, IMX, Deel, and Ultraviolet. We\'re now seeking a talented Full-Stack Developer to join our team and work with one of our top-notch customers.</p><p><br></p><p>What We Offer:</p><ul><li>Remote work with flexible hours</li><li>Paid Time Off (PTO)</li><li>Monthly opportunities for salary increases</li><li>Health insurance coverage</li><li>Reimbursed internet costs</li><li>Unlimited access to Udemy courses and books</li></ul><p><br></p><p>Responsibilities:</p><ul><li>Developing and maintaining web applications, including front-end and back-end development.</li><li>Collaborating with designers, product managers, and other developers to create scalable software solutions.</li><li>Writing clean, efficient, and well-documented code that meets industry standards.</li><li>Testing and debugging software to ensure high-quality and error-free products.</li><li>Creating and maintaining software documentation, including technical specifications and user manuals.</li><li>Managing project timelines and ensuring deliverables are completed on time.</li><li>Staying up-to-date with the latest trends and technologies in software development.</li></ul><p><br></p><p>Requirements:</p><ul><li>Experience with Javascript and tools like Typescript and React.</li><li>Proficiency in Node.js and the Express framework for building the server-side component and RESTful API endpoints.</li><li>Experience in developing browser extensions, including creating manifest files (manifest.json) and working with content scripts (content.js) for browser interactions.</li><li>At least 2 years of experience using modern, responsive HTML and CSS.</li><li>Excellent knowledge of software development best practices.</li><li>Strong communication with a minimum B2 English level.</li><li>Availability to overlap at least 6 hours with US working hours (PST)</li><li>At least 4 years of relevant work experience in the field.</li><li>Bachelor\'s degree or equivalent experience in Computer Science</li></ul>', 'Active', 'Jetnetiix Company ', 39, '2023-09--21'),
(43, 'company', 'Creative Proposal Developer', 'Agriculture', 'Web App', 2, 'First Shift ( Morning )', 'Full Time ( Onsite )', 'Karachi', 'Male', 'Intermediate / A-Level', 'Junior Level', '+ 1 Year', '2023-09-30', '2', 'creative,adobe,proper', '<p>As a Creative Proposal Developer at Nas Studios, you will be responsible for crafting compelling pitch proposals and generating creative ideas. Your work will directly impact the success and direction of our content strategy. This is an exciting opportunity for someone who is passionate about storytelling and has a creative flair.</p><p><br></p><p>What This Job Involves</p><p><br></p><ul><li>Develop pitch proposals for potential video projects and collaborations.</li><li>Collaborate with the content team to brainstorm and generate creative ideas.</li><li>Research and stay updated on relevant trends and topics for content inspiration.</li><li>Assist in the development of content strategies and concepts.</li><li>Work closely with team members to ensure proposals align with our brand\'s vision and goals.</li></ul><p><br></p><p>Sound like you? To apply, you need to be / have:</p><p><br></p><ul><li>Strong passion for storytelling and content creation.</li><li>Excellent written and verbal communication skills.</li><li>Creative thinking and the ability to generate fresh, innovative ideas.</li><li>Attention to detail and the ability to work in a fast-paced environment.</li><li>Previous experience in proposal development, design or content creation is a plus.</li><li>A genuine love for people, community, and telling human stories from around the world </li><li>To love speed and efficiency and have the ability to work under pressure and tight timelines while delivering quality work </li><li>Familiarity with Nas Daily content and brand is essential. </li></ul><p><br></p><p>Benefits</p><p><br></p><p>At Nas Company, we work hard , REALLY HARD! So we value our employees\' well-being and believe that a supportive and fulfilling work environment contributes to their success. We\'re proud to offer a range of benefits that will enhance your professional and personal life. Here\'s what you can look forward to as part of our team:</p><p><br></p><p>???? Remote Working : For those based in our offices, we provide the flexibility of remote work. Enjoy a balance between the office and your preferred workspace.</p><p><br></p><p>???? Medical Insurance : We care about your health. Our comprehensive medical insurance plans are tailored to each region, ensuring you have the coverage you need.</p><p><br></p><p>????????‍♀️ Self Care/Wellness Fund : Your well-being matters. We provide a monthly fund of $100 USD to spend on activities that bring you joy and promote your self-care.</p><p><br></p><p>???? Fully Stocked Fridges : Stay fueled and energized with our fully stocked fridges featuring a selection of healthy, high-protein, and low-calorie snacks and drinks.</p><p><br></p><p>????‍♀️ Team Outings : We believe in the power of connection. Join us for team outings that foster strong relationships and create lasting memories.</p><p><br></p><p>????️ Yearly Retreats : Unwind, bond, and collaborate at our annual company retreats. A time for the entire company to come together to rejuvenate and bond.</p><p><br></p><p>???? Nas Summit and Nas Travels : Employees who successfully clear probation are eligible for a choice between attending 1 Nas Summit or 1 Nas Travels trip per year, fully sponsored (T&amp;Cs)</p><p><br></p><p>???? Profit Sharing : You\'ll be eligible for a quarterly bonus after successfully completing the probation period.</p><p><br></p><p>???? Transport Allowance : Employees located in Singapore and Dubai enjoy a transport allowance, making your daily commute more convenient.</p><p><br></p><p>At Nas Company, we\'re committed to nurturing a supportive and engaging workplace that promotes your growth and well-being. Join us and enjoy a comprehensive array of benefits designed with you in mind.</p><p><br></p><p><br></p>', 'Active', 'Jetnetiix Company ', 39, '2023-09--21'),
(45, 'admin', 'Test', 'Agriculture', 'Web App', 2, 'First Shift ( Morning )', 'Full Time ( Onsite )', 'Karachi', 'Male', 'Intermediate / A-Level', 'Fresh Graduate', 'Fresh', '2022-11-30', '2', 'HTM,SAS,SA,SAJL,SAKLa', '<p>The requested resource is not a valid image for /uploads/admin/images/null received text/html; charset=utf-8</p><p>wait&nbsp;- compiling /api/notification (client and server)...</p><p>event - compiled successfully in 171 ms (141 modules)</p><p>Database Connected</p><p>wait&nbsp;- compiling /admin/company_list (client and server)...</p><p>event - compiled client and server successfully in 578 ms (1083 modules)</p><p>Database Connected</p><p>wait&nbsp;- compiling...</p><p>event - compiled client and server successfully in 563 ms (903 modules)</p><p>wait&nbsp;- compiling /api/admin/get_jobs (client and server)...</p><p>event - compiled successfully in 39 ms (127 modules)</p><p>Database Connected</p><p>wait&nbsp;- compiling...</p><p>event - compiled client and server successfully in 708 ms (914 modules)</p><p>Database Connected</p><p>wait&nbsp;- compiling...</p><p>event - compiled client and server successfully in 362 ms (914 modules)</p>', 'Active', 'Cubix', 44, '2023-09-21'),
(46, 'company', 'PDF', 'Information Technology', 'Web App', 2, 'First Shift ( Morning )', 'Full Time ( Onsite )', 'Karachi', 'No Preference', 'Intermediate / A-Level', 'Fresh Graduate', '+ 3 Year', '2023-12-31', '2', 'css,html,ok', '<p>This is a small demonstration .pdf file - just for use in the Virtual Mechanics tutorials. More text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. Boring, zzzzz. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. Even more. Continued on page 2 ..</p>', 'Active', 'Jetnetiix Company ', 39, '2023-09--21'),
(47, 'company', 'Test', 'Automotive', 'WWeb App', 2, 'First Shift ( Morning )', 'Full Time ( Onsite )', 'Karachi', 'Male', 'Intermediate / A-Level', 'Fresh Graduate', 'Fresh', '2023-01-01', '2', 'skill,ok,html,isas', '<p>This is a small demonstration .pdf file - just for use in the Virtual Mechanics tutorials. More text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. Boring, zzzzz. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. And more text. Even more. Continued on page 2 ..</p>', 'Active', 'Jetnetiix Company ', 39, '2023-09--21');

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

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

CREATE TABLE `messages` (
  `id` int(255) NOT NULL,
  `sender_role` varchar(255) DEFAULT NULL,
  `sender_id` varchar(255) DEFAULT NULL,
  `receiver_role` varchar(255) DEFAULT NULL,
  `receiver_id` int(255) DEFAULT NULL,
  `message` text NOT NULL,
  `is_read` tinyint(1) DEFAULT NULL,
  `created_at` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `messages` (`id`, `sender_role`, `sender_id`, `receiver_role`, `receiver_id`, `message`, `is_read`, `created_at`) VALUES
(316, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:25 pm'),
(317, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:26 pm'),
(318, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:26 pm'),
(319, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:26 pm'),
(320, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:26 pm'),
(321, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:26 pm'),
(322, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:27 pm'),
(323, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:27 pm'),
(324, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:27 pm'),
(325, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:27 pm'),
(326, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:28 pm'),
(327, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:28 pm'),
(328, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:28 pm'),
(329, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:28 pm'),
(330, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:28 pm'),
(331, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:29 pm'),
(332, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:29 pm'),
(333, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:29 pm'),
(334, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:29 pm'),
(335, 'agency', '74', 'employee', 48, '/???', 0, 'September 6th 2023, 2:05:30 pm'),
(336, 'agency', '74', 'employee', 44, '?', 0, 'September 6th 2023, 2:07:40 pm'),
(342, 'agency', '74', 'employee', 48, '?', 0, 'September 6th 2023, 2:17:51 pm'),
(343, 'agency', '74', 'employee', 48, '?', 0, 'September 6th 2023, 2:20:15 pm'),
(344, 'agency', '74', 'employee', 48, '?', 0, 'September 6th 2023, 2:20:48 pm'),
(345, 'agency', '74', 'employee', 48, 'Okay', 0, 'September 6th 2023, 2:20:51 pm'),
(346, 'agency', '74', 'employee', 48, 'pl', 0, 'September 6th 2023, 2:21:35 pm'),
(347, 'agency', '74', 'employee', 48, 'Ok', 0, 'September 6th 2023, 2:29:00 pm'),
(348, 'agency', '74', 'employee', 48, 'OK', 0, 'September 6th 2023, 3:12:25 pm'),
(349, 'agency', '74', 'employee', 48, 'Hey', 0, 'September 6th 2023, 3:17:58 pm'),
(350, 'employee', '48', 'agency', 74, '??', 0, 'September 6th 2023, 3:19:32 pm'),
(351, 'agency', '74', 'employee', 48, 'Hello', 0, 'September 6th 2023, 3:20:43 pm'),
(352, 'employee', '48', 'agency', 74, 'Hey', 0, 'September 6th 2023, 3:20:47 pm'),
(353, 'agency', '74', 'employee', 48, 'Hello', 0, 'September 6th 2023, 3:20:53 pm'),
(354, 'employee', '48', 'agency', 74, '?', 0, 'September 6th 2023, 3:25:33 pm'),
(355, 'agency', '74', 'employee', 48, '?', 0, 'September 6th 2023, 3:25:39 pm'),
(356, 'employee', '48', 'agency', 74, 'Hello', 0, 'September 6th 2023, 3:29:59 pm'),
(357, 'employee', '45', 'company', 40, '??', 0, 'September 6th 2023, 3:56:39 pm'),
(358, 'employee', '45', 'company', 40, '???', 0, 'September 6th 2023, 3:56:41 pm'),
(359, 'employee', '45', 'company', 40, '?', 0, 'September 6th 2023, 3:56:42 pm'),
(360, 'employee', '45', 'company', 40, '???', 0, 'September 6th 2023, 3:56:50 pm'),
(361, 'employee', '45', 'company', 40, '???', 0, 'September 6th 2023, 3:56:51 pm'),
(362, 'employee', '45', 'company', 40, '???', 0, 'September 6th 2023, 3:56:51 pm'),
(363, 'employee', '45', 'company', 40, '???', 0, 'September 6th 2023, 3:56:51 pm'),
(364, 'employee', '45', 'company', 40, '???', 0, 'September 6th 2023, 3:56:52 pm'),
(365, 'employee', '45', 'company', 40, '???', 0, 'September 6th 2023, 3:56:52 pm'),
(366, 'employee', '45', 'company', 40, '???', 0, 'September 6th 2023, 3:56:52 pm'),
(367, 'employee', '45', 'company', 40, '???', 0, 'September 6th 2023, 3:56:52 pm'),
(368, 'employee', '45', 'company', 40, '???', 0, 'September 6th 2023, 3:56:53 pm'),
(369, 'employee', '45', 'company', 40, '???', 0, 'September 6th 2023, 3:56:53 pm'),
(370, 'employee', '45', 'company', 40, '???', 0, 'September 6th 2023, 3:56:53 pm'),
(371, 'employee', '45', 'company', 40, '???', 0, 'September 6th 2023, 3:56:53 pm'),
(372, 'employee', '45', 'company', 40, '???', 0, 'September 6th 2023, 3:56:53 pm'),
(373, 'employee', '45', 'company', 40, '?', 0, 'September 6th 2023, 3:56:57 pm'),
(374, 'employee', '45', 'company', 40, '?', 0, 'September 6th 2023, 3:57:00 pm'),
(375, 'employee', '45', 'company', 40, '?', 0, 'September 6th 2023, 3:57:02 pm'),
(376, 'employee', '45', 'company', 40, '?', 0, 'September 6th 2023, 3:57:06 pm'),
(377, 'employee', '45', 'company', 40, '?', 0, 'September 6th 2023, 3:57:07 pm'),
(378, 'employee', '45', 'company', 40, '?', 0, 'September 6th 2023, 3:57:07 pm'),
(379, 'employee', '45', 'company', 40, '?', 0, 'September 6th 2023, 3:57:08 pm'),
(380, 'employee', '45', 'company', 40, '?', 0, 'September 6th 2023, 3:57:09 pm'),
(381, 'employee', '45', 'company', 40, '?', 0, 'September 6th 2023, 3:57:09 pm'),
(382, 'employee', '45', 'company', 40, '?', 0, 'September 6th 2023, 3:57:10 pm'),
(383, 'employee', '45', 'company', 40, '?', 0, 'September 6th 2023, 3:57:11 pm'),
(384, 'company', '39', 'employee', 40, '?>', 0, 'September 6th 2023, 4:48:07 pm'),
(385, 'agency', '74', 'employee', 48, 'hey', 0, 'September 7th 2023, 5:43:19 pm'),
(386, 'company', '39', 'employee', 40, '?', 0, 'September 12th 2023, 2:36:00 pm'),
(387, 'company', '39', 'employee', 40, '??', 0, 'September 12th 2023, 2:36:08 pm'),
(389, 'employee', '40', 'company', 39, '??', 0, 'September 15th 2023, 6:23:39 pm'),
(390, 'employee', '48', 'agency', 74, '????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????', 0, 'September 15th 2023, 10:10:08 pm'),
(391, 'employee', '48', 'agency', 74, '????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????', 0, 'September 15th 2023, 10:10:12 pm'),
(392, 'employee', '48', 'agency', 74, '????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????', 0, 'September 15th 2023, 10:16:35 pm'),
(393, 'admin', '16', 'employee', 51, 'hey', 0, 'September 18th 2023, 12:58:43 pm'),
(394, 'employee', '58', 'admin', 16, 'hey', 0, 'September 20th 2023, 6:17:40 pm'),
(395, 'admin', '16', 'employee', 58, 'hey', 0, 'September 20th 2023, 6:17:44 pm'),
(396, 'employee', '58', 'admin', 16, 'How are you ?', 0, 'September 20th 2023, 6:17:50 pm'),
(397, 'employee', '58', 'admin', 16, 'fine', 0, 'September 20th 2023, 6:18:52 pm'),
(398, 'admin', '16', 'employee', 58, 'oK', 0, 'September 20th 2023, 6:18:56 pm'),
(399, 'admin', '16', 'employee', 58, 'oK', 0, 'September 20th 2023, 6:18:59 pm'),
(400, 'admin', '16', 'employee', 58, 'KK', 0, 'September 20th 2023, 6:19:00 pm'),
(401, 'admin', '16', 'employee', 58, 'KK', 0, 'September 20th 2023, 6:19:01 pm'),
(402, 'admin', '16', 'employee', 58, 'K', 0, 'September 20th 2023, 6:19:02 pm'),
(403, 'admin', '16', 'employee', 58, 'K', 0, 'September 20th 2023, 6:19:02 pm'),
(404, 'admin', '16', 'employee', 58, 'K', 0, 'September 20th 2023, 6:19:02 pm'),
(405, 'admin', '16', 'employee', 58, 'K', 0, 'September 20th 2023, 6:19:03 pm'),
(406, 'admin', '16', 'employee', 58, 'K', 0, 'September 20th 2023, 6:19:03 pm'),
(407, 'admin', '16', 'employee', 58, 'KK', 0, 'September 20th 2023, 6:19:04 pm'),
(408, 'company', '45', 'employee', 61, '?', 0, 'September 20th 2023, 7:26:05 pm');

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

--
-- Table structure for table `notes`
--

CREATE TABLE `notes` (
  `id` int(255) NOT NULL,
  `added_by_role` varchar(250) DEFAULT NULL,
  `added_by_id` varchar(250) DEFAULT NULL,
  `added_by_name` varchar(250) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `description` varchar(250) DEFAULT NULL,
  `created_at` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `from_id` int(255) DEFAULT NULL,
  `to_id` int(255) DEFAULT NULL,
  `from_role` varchar(255) DEFAULT NULL,
  `to_role` varchar(255) DEFAULT NULL,
  `notification` text DEFAULT NULL,
  `url` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `created_at` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `from_id`, `to_id`, `from_role`, `to_role`, `notification`, `url`, `status`, `created_at`) VALUES
(145, 45, 0, 'company', 'agencies', 'Temp Email has posted a job of React.JS Developer', NULL, NULL, 'September 20th 2023, 4:06:49 pm'),
(146, 45, 0, 'company', 'admins', 'Temp Email has posted a job React.JS Developer', NULL, NULL, 'September 20th 2023, 4:06:49 pm'),
(147, 45, 0, 'company', 'agencies', 'Temp Email has posted a job of React.JS Developer', NULL, NULL, 'September 20th 2023, 4:07:49 pm'),
(148, 45, 0, 'company', 'admins', 'Temp Email has posted a job React.JS Developer', NULL, NULL, 'September 20th 2023, 4:07:49 pm'),
(149, 39, 0, 'company', 'admins', 'Jetnetiix Company  has added it\'s Employee, Ovais Khan', NULL, NULL, 'September 20th 2023, 6:36:09 pm'),
(150, 39, 0, 'company', 'admins', 'Jetnetiix Company  has added it\'s Employee, Ovais Khan', NULL, NULL, 'September 20th 2023, 6:36:09 pm'),
(151, 45, 0, 'company', 'admins', 'Temp Email has added it\'s Employee, Faizan Mehboob', NULL, NULL, 'September 20th 2023, 6:43:26 pm'),
(152, 45, 0, 'company', 'admins', 'Temp Email has added it\'s Employee, Sualeh Farooq', NULL, NULL, 'September 20th 2023, 7:11:46 pm'),
(153, 45, 0, 'company', 'admins', 'Temp Email has added it\'s Employee, Shahab', NULL, NULL, 'September 20th 2023, 7:17:33 pm'),
(154, 45, 0, 'company', 'agencies', 'Temp Email has posted a job of Flutter Dev', NULL, NULL, 'September 20th 2023, 7:20:45 pm'),
(155, 45, 0, 'company', 'admins', 'Temp Email has posted a job Flutter Dev', NULL, NULL, 'September 20th 2023, 7:20:45 pm'),
(156, 39, 0, 'company', 'agencies', 'Jetnetiix Company  has posted a job of Full Stack Engineer', NULL, NULL, 'September 21st 2023, 1:52:24 pm'),
(157, 39, 0, 'company', 'admins', 'Jetnetiix Company  has posted a job Full Stack Engineer', NULL, NULL, 'September 21st 2023, 1:52:24 pm'),
(158, 39, 0, 'company', 'agencies', 'Jetnetiix Company  has posted a job of Full Stack Engineer', NULL, NULL, 'September 21st 2023, 2:02:54 pm'),
(159, 39, 0, 'company', 'admins', 'Jetnetiix Company  has posted a job Full Stack Engineer', NULL, NULL, 'September 21st 2023, 2:02:54 pm'),
(160, 39, 0, 'company', 'agencies', 'Jetnetiix Company  has posted a job of Full Stack Engineer', NULL, NULL, 'September 21st 2023, 2:04:05 pm'),
(161, 39, 0, 'company', 'admins', 'Jetnetiix Company  has posted a job Full Stack Engineer', NULL, NULL, 'September 21st 2023, 2:04:05 pm'),
(162, 39, 0, 'company', 'agencies', 'Jetnetiix Company  has posted a job of Full Stack Engineer', NULL, NULL, 'September 21st 2023, 2:15:56 pm'),
(163, 39, 0, 'company', 'admins', 'Jetnetiix Company  has posted a job Full Stack Engineer', NULL, NULL, 'September 21st 2023, 2:15:56 pm'),
(164, 39, 0, 'company', 'agencies', 'Jetnetiix Company  has posted a job of Creative Proposal Developer', NULL, NULL, 'September 21st 2023, 2:18:31 pm'),
(165, 39, 0, 'company', 'admins', 'Jetnetiix Company  has posted a job Creative Proposal Developer', NULL, NULL, 'September 21st 2023, 2:18:31 pm'),
(166, 39, 0, 'company', 'agencies', 'Jetnetiix Company  has posted a job of Creative Proposal Developer', NULL, NULL, 'September 21st 2023, 2:19:17 pm'),
(167, 39, 0, 'company', 'admins', 'Jetnetiix Company  has posted a job Creative Proposal Developer', NULL, NULL, 'September 21st 2023, 2:19:17 pm'),
(168, 39, 0, 'company', 'agencies', 'Jetnetiix Company  has posted a job of Sr DevOPS Engineer', NULL, NULL, 'September 21st 2023, 2:47:23 pm'),
(169, 39, 0, 'company', 'admins', 'Jetnetiix Company  has posted a job Sr DevOPS Engineer', NULL, NULL, 'September 21st 2023, 2:47:23 pm'),
(170, 39, 0, 'company', 'agencies', 'Jetnetiix Company  has posted a job of Sr DevOPS Engineer', NULL, NULL, 'September 21st 2023, 2:47:58 pm'),
(171, 39, 0, 'company', 'admins', 'Jetnetiix Company  has posted a job Sr DevOPS Engineer', NULL, NULL, 'September 21st 2023, 2:47:58 pm'),
(172, 39, 0, 'company', 'agencies', 'Jetnetiix Company  has posted a job of Sr DevOPS Engineer', NULL, NULL, 'September 21st 2023, 2:48:39 pm'),
(173, 39, 0, 'company', 'admins', 'Jetnetiix Company  has posted a job Sr DevOPS Engineer', NULL, NULL, 'September 21st 2023, 2:48:39 pm'),
(174, 39, 0, 'company', 'agencies', 'Jetnetiix Company  has posted a job of PDF', NULL, NULL, 'September 21st 2023, 2:51:20 pm'),
(175, 39, 0, 'company', 'admins', 'Jetnetiix Company  has posted a job PDF', NULL, NULL, 'September 21st 2023, 2:51:20 pm'),
(176, 39, 0, 'company', 'agencies', 'Jetnetiix Company  has posted a job of Test', NULL, NULL, 'September 21st 2023, 2:54:14 pm'),
(177, 39, 0, 'company', 'admins', 'Jetnetiix Company  has posted a job Test', NULL, NULL, 'September 21st 2023, 2:54:14 pm'),
(178, 74, 39, 'agency', 'company', 'LATAM UPDATED 2 has submitted a candidate for Creative Proposal Developer', NULL, NULL, 'September 21st 2023, 3:04:12 pm'),
(179, 0, 0, 'company', 'admins', 'LATAM UPDATED 2 has submitted a candidate for Creative Proposal Developer', NULL, NULL, 'September 21st 2023, 3:04:12 pm'),
(180, 39, 74, 'company', 'agency', 'Jetnetiix Company  has Moved Sualeh to Stage Challenge for Their Job Creative Proposal Developer', NULL, NULL, 'September 21st 2023, 3:06:18 pm'),
(181, 105, 0, 'agency', 'admins', 'Micheal has added it\'s Employee, Faizan Mehboob', NULL, NULL, 'September 22nd 2023, 3:55:07 pm'),
(182, 0, 74, 'company', 'agency', 'Jetnetiix Company  has Moved undefined to Stage Interview for Their Job Creative Proposal Developer', NULL, NULL, 'September 22nd 2023, 4:45:21 pm'),
(183, 39, 74, 'company', 'agency', 'Jetnetiix Company  has Moved Sualeh to Stage Challenge for Their Job Creative Proposal Developer', NULL, NULL, 'September 22nd 2023, 4:45:42 pm'),
(184, 39, 74, 'company', 'agency', 'Jetnetiix Company  has Moved Sualeh to Stage Screening for Their Job Creative Proposal Developer', NULL, NULL, 'September 22nd 2023, 4:45:42 pm'),
(185, 0, 39, 'agency', 'company', 'You have just earned 5 points as a referral bonus. asas Signup with Your Referral ID', NULL, NULL, 'September 26th 2023, 3:14:54 pm'),
(186, 0, 39, 'agency', 'company', 'You have just earned 5 points as a referral bonus. Name Signup with Your Referral ID', NULL, NULL, 'September 26th 2023, 6:05:09 pm'),
(187, 0, 0, 'companies', 'admins', ' Name Signup with Referral ID', NULL, NULL, 'September 26th 2023, 6:05:09 pm');

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

--
-- Table structure for table `submitted_candidates`
--

CREATE TABLE `submitted_candidates` (
  `id` int(11) NOT NULL,
  `submit_candidate` varchar(255) DEFAULT NULL,
  `candidate_id` int(255) DEFAULT NULL,
  `candidate_image` text DEFAULT NULL,
  `agency_submitted` varchar(255) DEFAULT NULL,
  `offer_hourly_rate` int(10) DEFAULT NULL,
  `for_job` varchar(255) DEFAULT NULL,
  `for_jobId` int(10) DEFAULT NULL,
  `for_AgencyId` int(255) DEFAULT NULL,
  `job_company` varchar(255) DEFAULT NULL,
  `job_comp_id` int(255) DEFAULT NULL,
  `stage` varchar(250) NOT NULL,
  `notes` text NOT NULL,
  `submitted_at` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `submitted_candidates`
--

INSERT INTO `submitted_candidates` (`id`, `submit_candidate`, `candidate_id`, `candidate_image`, `agency_submitted`, `offer_hourly_rate`, `for_job`, `for_jobId`, `for_AgencyId`, `job_company`, `job_comp_id`, `stage`, `notes`, `submitted_at`) VALUES
(56, 'Sufiyan', 27, 'Sualeh_company1.png', 'LATAM UPDATED', 2, 'Software Developer - Next.js', 40, 74, 'Temp Email', 45, 'Screening', '', '2023-09-20'),
(57, 'Sufiyan', 27, 'Sualeh_company1.png', 'LATAM UPDATED 2', 2, 'Flutter Dev', 41, 74, 'Temp Email', 45, 'Screening', '', '2023-09-20'),
(58, 'Sualeh', 28, 'Sualeh_company1.png', 'LATAM UPDATED 2', 2, 'Creative Proposal Developer', 43, 74, 'Jetnetiix Company ', 39, 'Screening', '', '2023-09-21');

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `candidates`
--
ALTER TABLE `candidates`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `candidates_notes`
--
ALTER TABLE `candidates_notes`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `feedbacks`
--
ALTER TABLE `feedbacks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `interviews`
--
ALTER TABLE `interviews`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=409;

--
-- AUTO_INCREMENT for table `notes`
--
ALTER TABLE `notes`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=188;

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

