[go: up one dir, main page]
Scribd
Upload
70 views3 pages

Recruitment Database Schema

The document outlines an entity relationship diagram (ERD) for a recruitment database with tables for people, skills, job postings, candidates, users, departments, interviews and relationships between them. Key entities include people, candidates, users, job postings, skills and interviews with identifying and foreign keys to link them together.

Uploaded by

Zita Balás
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
70 views3 pages

Recruitment Database Schema

The document outlines an entity relationship diagram (ERD) for a recruitment database with tables for people, skills, job postings, candidates, users, departments, interviews and relationships between them. Key entities include people, candidates, users, job postings, skills and interviews with identifying and foreign keys to link them together.

Uploaded by

Zita Balás
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

skills

1 id int 1
job_posting_skill
person_skill name varchar[255]
id int
id int *
job_posting_id int
* person_id int * skill_id int
skill_id int *

level skill_level
people

1 id int 1
job_postings
first_name varchar[100]
1 id int 1
last_name varchar[100]
title varchar[255]
email varchar[100]
department int *

candidates users description text

id int 1 1
id int is_open boolean

person_id int 1 1 person_id int

CV_attachment varchar[255] username varchar[100]

priority priority_status roles password varchar[100]

source source_of_candidate id int 1 * role int departments

phase recruitment_phase name varchar[100] department int * 1 id int 1

status user_status name varchar[255]

interviews

id int

job_posting int *

1 candidate int

interviewer int *

feedback text

rating int

recommendation recommendation
skills

1 id int 1
job_posting_skill
person_skill name varchar[255]
id int
id int *
job_posting_id int
* person_id int * skill_id int
skill_id int *

level skill_level
people

1 id int 1
job_postings
first_name varchar[100]
1 id int 1
last_name varchar[100]
title varchar[255]
email varchar[100]
department int *

candidates users description text

id int 1 1
id int is_open boolean

person_id int 1 1 person_id int

CV_attachment varchar[255] username varchar[100]

priority priority_status roles password varchar[100]

source source_of_candidate id int 1 * role int departments

phase recruitment_phase name varchar[100] department int * 1 id int 1

status user_status name varchar[255]

interviews

id int

job_posting int *

1 candidate int

interviewer int *

feedback text

rating int

recommendation recommendation
Enum skill_level { Enum user_status {
junior inactive
medior registered
senior email_comfirmed
} approved
}

Enum priority_status {
low Enum recommendation {
med next_round
high hire
} reject
}

Enum source_of_candidate {
direct
agency
referral
}

Enum recruitment_phase {
sourcing
interviewing
offer_stage
offer_accepted
offer_declined
rejected
withdrew
onhold
}

You might also like