Table of Contents
The Job Portal Web App is a comprehensive platform designed to streamline the job recruitment process. It caters to two types of users: recruiters and candidates.
Job Listings: Recruiters can post job openings, and candidates can view job posts with detailed descriptions.
Resume Uploads: Candidates can upload their resumes for recruiters to view.
Application Tracking: Recruiters can see who applied for their job posts, along with the candidate's information and resume.
Global Job Search: Users can search for jobs globally without the need to log in.
This schema effectively models our job portal system with clear relationships between users, their profiles, job postings, and interactions such as saving and applying for jobs. Each table has a specific role and is interconnected through foreign keys to ensure referential integrity.
Users: Divided into recruiters and job seekers through the users_type table. Each user has a profile stored in either recruiter_profile or job_seeker_profile.
Job Postings: Managed by recruiters, stored in job_post_activity, with references to companies (job_company) and locations (job_location).
Job Seekers: Can save (job_seeker_save) and apply (job_seeker_apply) to job postings. Their skills are tracked in the skills table.