jobsalon - Laravel Schema Designer

applications

id increments
timestamps timestamps
softDeletes softDeletes
first_name string
last_name string
street string
postal_code string
city string
region_id ^FK integer
country_id integer
email string
phone_number string
photo_path string
birthdate date
current_job_sector_id integer
current_job_category_id integer
current_job_title string
employed_since smallInteger
gross_salary float (7,2)
driving_license string
cv_path string
motivation_letter_path string
relevant_info text
linkedin string
facebook string
twitter string

application_experiences

id increments
timestamps timestamps
application_id ^FK integer
date_from date
date_to date
job_title string
company string
short_description text
tasks text

application_educations

id increments
timestamps timestamps
date_from date
date_to date
title string
institution string
short_description string
application_id ^FK integer

job

id increments
timestamps timestamps
softDeletes softDeletes
photo_path string
enabled boolean
reference_number integer
status tinyInteger
type tinyInteger
timing tinyInteger
contract_type tinyInteger
region_id ^FK integer
postal_code string
city string
video_url string
wanted_experience tinyInteger
wanted_education tinyInteger

job_translation

timestamps timestamps
id increments
title string
description text
profile text
offer text

job_category

id increments
timestamps timestamps
softDeletes softDeletes
enabled boolean

job_category_translation

id increments
job_category_id ^FK integer
title string

regions

id increments
timestamps timestamps
title string

tags

id increments
title string

job_domains

id increments
timestamps timestamps
softDeletes softDeletes

job_domain_translations

id increments
job_domain_id ^FK integer
title string

logs

id increments
timestamps timestamps
user_id integer
action string
description text
icon string

application_stages

id increments
application_id ^FK integer

application_stage_translation

id increments
title string

carts

id increments
timestamps timestamps

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