workish_db - Laravel Schema Designer

users

id increments
email string (191)
password string (191)
user_type_id integer
allow_email_notifications boolean
allow_push_notifications boolean
site_lang_id integer
timestamps timestamps

user_types

id increments
name string (191)
timestamps timestamps

candidates

id increments
user_id ^FK integer
first_name string (191)
last_name string (191)
avatar text
phone string (20)
description text
cover_letter text
dob date
region_id integer
status tinyInteger
is_educated tinyInteger
is_experienced tinyInteger
profile_level integer
timestamps timestamps

companies

id increments
user_id integer
name string (191)
logo text
phone bigInteger
website string (191)
description text
status tinyInteger
address text
lat decimal (10,8)
lng decimal (11,8)
timestamps timestamps

site_languages

id increments
name string (191)
timestamps timestamps

regions

id increments
name string (191)
timestamps timestamps

candidate_languages

id increments
language_id integer
candidate_id integer
timestamps timestamps

industries

id increments
parent_id integer
name string (191)
description text
slug string (191)
image text
timestamps timestamps

job_types

id increments
name string (191)
timestamps timestamps

jobs

id increments
company_id integer
candidate_id integer
user_id integer
company_name string (191)
company_logo text
title string (191)
description text
image text
industry_id integer
job_type_id integer
job_mode_id integer
edu_level_id integer
address text
region_id integer
application_deadline date
status tinyInteger
published_date date
start_date date
end_date date
timestamps timestamps

job_industries

id increments
job_id integer
industry_id integer
timestamps timestamps

job_applications

id increments
job_id integer
candidate_id integer
user_id integer
status tinyInteger
timestamps timestamps

saved_jobs

id increments
job_id integer
candidate_id integer
user_id integer
status tinyInteger
timestamps timestamps

industry_preferences

id increments
category_id integer
candidate_id integer
user_id integer
timestamps timestamps

push_notifications

id increments
timestamps timestamps
name string (191)
content text
status tinyInteger

push_notification_targets

id increments
target_user_id integer
noti_id integer
status tinyInteger
timestamps timestamps

education_levels

id increments
timestamps timestamps
title string (191)

job_modes

id increments
name string (191)
timestamps timestamps

languages

id increments
timestamps timestamps

requirements

id increments
name string (191)
timestamps timestamps

job_requirements

id increments
job_id integer
requirement_id integer
timestamps timestamps

job_languages

id increments
job_id integer
language_id integer
timestamps timestamps

candidate_qualifications

id increments
candidate_id integer
edu_level_id tinyInteger
institution string (191)
description text
start_date date
finish_date date
timestamps timestamps

candidate_experiences

id increments
timestamps timestamps
candidate_id integer
industry_id integer
position string (191)
company string (191)
description text
start_date date
end_date date
is_current boolean

micro_jobs

id increments
job_id integer
wage_type string (191)
price integer
estimated_hours float
is_scheduled tinyInteger
date_from date
date_to date
time_from string
time_to string
timestamps timestamps

courses

id increments
company_id integer
company_name string
company_logo text
title string
description text
image text
address text
region_id integer
application_deadline date
published_date date
timestamps timestamps
status tinyInteger