Entities and Attributes of the Online Job Search and Recruitment Platform
1. Users:
- user_id (Primary Key): Unique identifier for each user.
- username: Username of the user.
- email: Email address of the user.
- password: Encrypted password of the user.
- role: Role of the user (job seeker or employer).
2. Job Listings:
- job_id (Primary Key): Unique identifier for each job listing.
- employer_id (Foreign Key referencing Users): Identifier of the employer posting the job.
- title: Title of the job listing.
- description: Description of the job.
- location: Location of the job.
- salary: Salary offered for the job.
3. Applications:
- application_id (Primary Key): Unique identifier for each job application.
- job_id (Foreign Key referencing Job Listings): Identifier of the job listing to which the application is made.
- user_id (Foreign Key referencing Users): Identifier of the user (job seeker) who made the application.
- status: Status of the application (e.g., pending, accepted, rejected).
4. Messages:
- message_id (Primary Key): Unique identifier for each message.
- sender_id (Foreign Key referencing Users): Identifier of the user sending the message.
- receiver_id (Foreign Key referencing Users): Identifier of the user receiving the message.
- message_text: Text of the message.
- timestamp: Timestamp of when the message was sent.
How to Design a Relational Database for Online Job Portal
Online job search and recruitment play an important role in connecting job seekers with employers. A well-structured relationship database is essential for managing communication between job listings, user profiles, applications, and applicants and employers.
In this article, we’ll examine the basic elements of such a database design, including entity identification, table creation, relationship establishment, and data integrity enforcement.
Contact Us