prism - Laravel Schema Designer

candidates

id increments
timestamps timestamps
softDeletes softDeletes
gender_id ^FK integer
first_name string (255)
surname string (255)
email string (255)
password string (128)
location_id ^FK integer
email2 string (255)
how_find_id ^FK integer
how_find_other string (100)
date_of_birth date
nationality_1_id ^FK integer
nationality_2_id ^FK integer
marital_status boolean
military_status_id ^FK integer
has_degree boolean
field_of_study_id ^FK integer
english_knowledge_level_id ^FK integer
mailshot_career_related_news boolean
mailshot_event_product_service boolean

lookups

id increments
timestamps timestamps
softDeletes softDeletes
title string (30)
title_farsi string (30)
sequence integer
subscriber_count integer
value integer
type integer
description text

terms_and_conditions

id increments
timestamps timestamps
softDeletes softDeletes
title string (30)
text text

locations

id increments
timestamps timestamps
softDeletes softDeletes
parent_id ^FK integer
type integer
title string (255)
title_farsi string (255)
country_code string (10)
sequence integer

candidate_phone_numbers

id increments
timestamps timestamps
softDeletes softDeletes
candidate_id ^FK integer
country_code_id ^FK integer
area_code string (10)
phone_number string (30)
type_id ^FK integer

candidates_cv

id increments
timestamps timestamps
softDeletes softDeletes
candidate_id ^FK integer
fresh_graduate boolean
receive_job_update_alert_type_id ^FK integer
comments text

candidate_cv_current_employment

id increments
timestamps timestamps
softDeletes softDeletes
cv_id ^FK integer
title string (60)
job_category_id ^FK integer
seniority_id ^FK integer
campany_name string (60)
location_id ^FK integer
industry_id ^FK integer
company_size_id ^FK integer
company_nationality_type_id ^FK integer
net_salary string (30)
salary_currency_type_id ^FK integer
salary_period_id ^FK integer
cash_benefits string (255)
benefit_period_id ^FK integer
other_benefits text

candidate_cv_job_alert

id increments
timestamps timestamps
cv_id ^FK integer
alert_type_id ^FK integer

candidate_cv_professional_experience

id increments
timestamps timestamps
softDeletes softDeletes
cv_id ^FK integer
start_date date
end_date date
currently_employed boolean
location_id ^FK integer
job_title string (60)
company_name string (60)
company_size_id ^FK integer
main_responsibilities text
main_achievement text
reporting_to string (60)
subordinate string (255)
reason_to_leave string (255)
description text

candidate_cv_educations

id increments
timestamps timestamps
softDeletes softDeletes
cv_id ^FK integer
university_name string (255)
university_type_id ^FK integer
field_of_study_id ^FK integer
start_date date
end_date date
currently_educating boolean
degree_level_id ^FK integer
gpa string (30)

candidate_cv_languages

id increments
timestamps timestamps
softDeletes softDeletes
cv_id ^FK integer
language_id ^FK integer
language_skill_id ^FK integer

candidate_cv_certificates

id increments
timestamps timestamps
softDeletes softDeletes
cv_id ^FK integer
title string (255)
issuer string (255)
issue_date date
location_id ^FK integer

candidate_cv_skills

id increments
timestamps timestamps
softDeletes softDeletes
cv_id ^FK integer
title string (255)
skill_level_id ^FK integer
skill_type_id ^FK integer

candidate_cv_additional_files

id increments
timestamps timestamps
softDeletes softDeletes
cv_id ^FK integer
name string (255)
path string (255)
file_type_id ^FK integer

candidate_saved_searchs

id increments
timestamps timestamps
softDeletes softDeletes
candidate_id ^FK integer
title string (255)
phrase string (255)

candidate_cv_target_job

id increments
timestamps timestamps
softDeletes softDeletes
cv_id ^FK integer
title string (255)
career_level_id ^FK integer
career_objectives text
willing_to_relocate boolean
willing_to_travel_id ^FK integer
employment_type_id ^FK integer
employment_status_id ^FK integer
salary_expected integer
salary_expected_currency_id ^FK integer
salary_expected_period_id ^FK integer
expected_benefits text

candidate_target_job_job_category

id increments
timestamps timestamps
target_job_id ^FK integer
job_category_id ^FK integer

candidate_target_job_job_industry

id increments
timestamps timestamps
target_job_id ^FK integer
job_industry_id ^FK integer

candidate_target_job_location

id increments
timestamps timestamps
target_job_id ^FK integer
location_id ^FK integer

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01