algorithm - Laravel Schema Designer

users

id increments
role_id integer
full_name string
email string
password string

roles

id increments
role_name string

candidates

id increments
application_date date
full_name string
position_id integer
cv_filename string
phone_number string
email string
fit_id integer
salary integer
start_date string
language_leve_id integer
stage_id integer
comments text
cancelled boolean

pivot_cand_tech

id increments
candidate_id ^FK integer
tech_id ^FK integer
tech_position integer

tech

id increments
tech_name string

stage

id increments
stage_name string

social_media

id increments
url string
candidate_id integer

language

id increments
language_level string

position

id increments
timestamps timestamps
position_name string
position_link string
position_filename string

fit

id increments
fit_name string

department

id increments
department_name string

level_of_proficiency

id increments
proficiency_name string

employment_status

id increments
status_name string

employee

id increments
timestamps timestamps
name string
birth_date date
hiring_date date
resignition_date date
department_id ^FK integer
position_id ^FK integer
proficiency_level_id ^FK integer
employment_status_id ^FK integer

pivot_employment_tech

id increments
employee_id ^FK integer
tech_id ^FK integer
tech_position integer

day_off

id increments
timestamps timestamps
category_id ^FK integer
employee_id ^FK integer
day_off_date date
amount integer
comment text

category

id increments
category_name string

salary_review

id increments
timestamps timestamps
employee_id ^FK integer
requested boolean
salary_review_date date
amount bigInteger
comment text
requested_date date
requested_review bigInteger
requested_arguments text
request_reply text

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