Livoa LogoLivoa
Job Hunt Portal
USER


+ user_id (PK)

+ name

+ email : String

+ password

+ role : String

+ registratioDate Date

name
Password
role
phone
reg_date
id (PK)
name
Password
role
phone
reg_date
RECRUITERS


+ recruiter_id (PK)

+ company_name

+ company_email

+ company_address

JOB SEEKERS


+ seeker_id (PK)

+ skills

+ experience

+ resume

is a
1
0..n
RECRUITERS


+ recruiter_id (PK)

+ company_name

+ company_email

+ company_address

JOB SEEKERS


+ seeker_id (PK)

+ title

+ description

+ location

+ salary

+ recruiter_id (FK)

JOBS


+ job_id (PK)

+ title

+ description

+ location

+ recruiter_id (FK)

APPLICATIONS


+ application_id (PK)

+ job_id (FK)

+ seeker_id (FK)

+ apply_date

+ status

posts
applies for
posts
applies for
1
0..n
1
1
1
1
1
0..n
0..*
1
PK
FK
PK
FK
PK
FK
FK
USERS


user_id/int PK

name int

email int

password int

phone bigint

role int

ADMIN


admin_id/int PK

user_id/int FK

RECRUITER


recruiter_id/int PK

company_name int

user_id/int FK

ADMIN


admin_id/int PK

user_id/int FK

RECRUITER


recruiter_id/int PK

company_name int

user_id/int FK

JOB


job_id/int PK

title int

location varchar

salary int

recruiter_id/int FK

JOB SEEKER


seeker_id/PK PK

skills text

resume varchar

user_id/FK FK

APPLICATION


application_id/int PK

job_id/int FK

seeker_id/int FK

status varchar

WISHLIST


wishlist_id/int PK

job_id/int FK

seeker_id/int FK

ab

by Prasad

0
0 uses