job-portal - Laravel Schema Designer

users

id increments
user_type_id integer
email string (255)
password string (60)
remember_token string (100)
is_active string (1)
sms_notification_active string (1)
email_notification_active string (1)
user_image string (255)
timestamps timestamps

user_type

id increments
user_type_name string (20)
timestamps timestamps

password_resets

timestamps timestamps
email string
token string

candidate_profile

user_id ^FK integer
candidate_resume string (255)
first_name string (50)
last_name string (50)
job_category string (60)
gender string (1)
year_of_birth date
country_of_birth string (50)
marital_status string (50)
current_salary integer
disability string (1)
current_country string (100)
current_state string (50)
current_city string (50)
address text
primary_phone bigInteger
secondary_phone bigInteger
timestamps timestamps
softDeletes softDeletes

education_detail

id integer
user_id ^FK integer
degree string (50)
major string (50)
specialization string (50)
university string (50)
starting_date date
completion_date date
gpa float
country string (50)
state string (50)
city string (50)
status string (20)
timestamps timestamps
softDeletes softDeletes

experience_detail

id integer
user_id ^FK integer
is_current_job string (1)
position string (50)
company string (50)
start_date date
end_date date
salary integer
frequency string (50)
city string (50)
country string (50)
job_category string (50)
seniority_level string (50)
reporting_to string (20)
description text
timestamps timestamps

reference_detail

id integer
user_id ^FK integer
reference_name string (50)
position string (50)
email string (50)
company string (50)
phone integer
timestamps timestamps

certificate_detail

id integer
user_id ^FK integer
license string (100)
issuer string (100)
effective_date smallInteger
expiry_date smallInteger
country string (50)
timestamps timestamps

skill_detail

id integer
user_id ^FK integer
software string (100)
type string (100)
skill_level string (100)
timestamps timestamps

training_detail

id integer
user_id ^FK integer
course_title string (100)
school_name string (100)
course_length smallInteger
date date
country string (50)
timestamps timestamps

preference_detail

id integer
user_id ^FK integer
work_type string (100)
work_time string (100)
work_travel string (100)
work_relocate string (1)
work_hours string (20)
work_location string (100)
work_min_pay string (100)
work_comments text
cv_permission string (1)
general_comments text
ielts_exam_status string (1)
ielts_exam_score string (10)
toefl_exam_status string (1)
toefl_exam_score string (10)
timestamps timestamps

company

user_id ^FK integer
title string (100)
company_type string (50)
employees_count string (20)
desc text
img string (100)
timestamps timestamps
softDeletes softDeletes

Post

id increments
company_id ^FK integer
job_category string (50)
position string (100)
country string (50)
state string (50)
city string (50)
requirements text
desc text
gender string (1)
age_from smallInteger
age_to smallInteger
experience_years smallInteger
job_type string (20)
seniority_level string (20)
english_ability string (20)
timestamps timestamps
softDeletes softDeletes

post_candidate_activity

id increments
post_id ^FK integer
candidate_id ^FK integer
status string (20)
timestamps timestamps
softDeletes softDeletes

job_categories

id increments
timestamps timestamps
softDeletes softDeletes
title string (60)

newsletter_subscribers

id increments
email string (255)
timestamps timestamps
softDeletes softDeletes

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