Database Schema - Kelvin-K-Cho/recruited GitHub Wiki
users
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
username |
string | not null, indexed, unique |
email |
string | not null, indexed, unique |
full_name |
string | not null |
city |
string | not null |
phone_number |
integer | not null |
profile_pic |
image | paperclip gem |
password_digest |
string | not null |
session_token |
string | not null, indexed, unique |
created_at |
datetime | not null |
updated_at |
datetime | not null |
companies
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
name |
string | not null, indexed |
about |
text | not null |
website_url |
string | not null |
created_at |
datetime | not null |
updated_at |
datetime | not null |
reviews (company review, this can be our bonus)
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
company_id |
integer | not null, foreign key |
user_id |
integer | not null, foreign key |
body |
text | not null |
created_at |
datetime | not null |
updated_at |
datetime | not null |
jobs
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
title |
string | not null |
summary/description |
text | |
responsibilities |
text | |
qualification/requirement |
text | |
recruiter_id |
integer | not null, foreign key |
company_id |
string | not null, foreign key |
type |
string | ["Full-time, Part-time, Contract, Internship, etc"] |
experience |
string | ["Entry, Mid, Senior"] |
location |
string | not null |
salary_estimate |
integer | |
created_at |
datetime | not null |
updated_at |
datetime | not null |
resumes
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
jobseeker_id |
integer | not null, foreign key |
role/position |
string | not null |
github_url |
string | |
linkedin_url |
string | |
headline/sumary |
text | |
education |
text | |
experience_id |
text | |
project_id |
text | |
skills |
text | |
created_at |
datetime | not null |
updated_at |
datetime | not null |
experiences
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
role |
string | not null |
company_id |
string | not null |
resume_id |
integer | not null |
start_time |
datetime | not null |
end_time |
datetime | not null |
description |
text | not null |
created_at |
datetime | not null |
updated_at |
datetime | not null |
projects
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
resume_id |
integer | not null |
title |
string | not null |
start_time |
datetime | not null |
end_time |
datetime | not null |
description |
text | not null |
created_at |
datetime | not null |
updated_at |
datetime | not null |