HR-CRM - Laravel Schema Designer

categories

id increments
added_by_id ^FK integer
branch_id ^FK integer
timestamps timestamps
softDeletes softDeletes

users

id increments
email string (255)
image string (255)
password string (255)
phone string (255)
gender enum
birth_date string (255)
social_status string (255)
child_number string (255)
degree string (255)
graduation_date string (255)
military_status string (255)
whatsapp string (255)
user_type string (255)
notes longText
reset_code string (255)
verified_code string (255)
added_by_id ^FK integer
report_general tinyInteger
report_private tinyInteger
last_login_at timestamp
is_active tinyInteger
remember_token string (100)
role_id integer
branch_id ^FK integer
category_id ^FK integer
code string (255)
fingerprint_number string (255)
hiring_date date
contact_email string (255)
contact_phone string (255)
contact_whatsapp string (255)
university_id integer
college_id integer
last_salary_id integer
salary float
ended_date date
pass longText
is_team_leader tinyInteger
rate double
timestamps timestamps
softDeletes softDeletes

universities

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id ^FK integer
branch_id ^FK integer

countries

id increments
phonecode string (5)
short_name string (255)
show_phonecode string (255)
flag string (255)
continent enum
timestamps timestamps
softDeletes softDeletes

country_translations

id increments
country_id ^FK integer
name string (255)
slug string (255)
currency string (255)
nationality string (255)
locale string (255)
timestamps timestamps

cities

id increments
country_id ^FK integer
lat double
lng double
location string (255)
postal_code string (30)
short_cut string (255)
timestamps timestamps
softDeletes softDeletes

city_translations

id increments
timestamps timestamps
city_id ^FK integer
name string (255)
slug string (255)
locale string (255)

branches

id increments
timestamps timestamps
softDeletes softDeletes
country_id ^FK integer
city_id ^FK integer

branch_translations

id increments
timestamps timestamps
title string (255)
branch_id ^FK integer
locale string (255)

category_translations

id increments
name string (255)
category_id ^FK integer
locale string (100)
timestamps timestamps

university_translations

id increments
name string (255)
university_id ^FK integer
timestamps timestamps

colleges

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id ^FK integer
branch_id ^FK integer
university_id ^FK integer

college_translations

id increments
timestamps timestamps
name string (255)
college_id ^FK bigInteger
locale string (255)

colors

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id ^FK integer
hexa_code string (255)

color_translations

id increments
timestamps timestamps
name string (255)
color_id ^FK bigInteger
locale string (255)

visits

id increments
added_by_id ^FK integer
branch_id ^FK integer
date date
time string (255)
code string
mobile string
year string
status string (100)
month string (100)
timestamps timestamps
softDeletes softDeletes

visit_translations

id increments
timestamps timestamps
name string (255)
reason longText
report longText
visit_id ^FK integer
locale string

employee_months

id increments
timestamps timestamps
softDeletes softDeletes
employee_id ^FK integer
branch_id ^FK integer
year integer
month integer

promotions

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id ^FK integer
user_id ^FK integer
date date

promotion_translations

id increments
timestamps timestamps
title string
promotion_id ^FK integer
locale string

rate_factors

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id ^FK integer
color_id ^FK integer
type string

rate_factor_translations

id increments
timestamps timestamps
name string
rate_factor_id ^FK integer
locale string

rates

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id ^FK integer
employee_id ^FK integer
rate_factor_id ^FK integer
year integer
month integer
value double
date date

emp_vacations

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id ^FK integer
employee_id ^FK integer
branch_id ^FK integer
start_date date
end_date date
days_count integer
type string
status string
hr_status string
team_leader_status string

interviews

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id ^FK integer
branch_id ^FK integer
country_id ^FK integer
city_id ^FK integer
category_id ^FK integer
mobile string
email string
status string

interview_translations

id increments
timestamps timestamps
interview_id ^FK integer
name string
locale string

interview_mettings

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id ^FK integer
branch_id ^FK integer
interview_id ^FK integer
date date
time string
value string
status string

interview_metting_translations

id increments
timestamps timestamps
notes longText
interview_metting_id ^FK integer
locale string

questionnaires

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id ^FK integer
employee_id ^FK integer
branch_id ^FK integer

questionnaire_translations

id increments
timestamps timestamps
positive string
negative string
questionnaire_id ^FK integer
locale string

emp_requests

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id ^FK integer
employee_id ^FK integer
branch_id ^FK integer
date date
start_time string
end_time string
status string

emp_request_translations

id increments
timestamps timestamps
reason longText
emp_request_id ^FK bigInteger
locale string

discounts

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id ^FK integer
employee_id ^FK integer
branch_id ^FK integer
date date
total float
hours_count decimal
status string

discount_translations

id increments
timestamps timestamps
duration string
reason longText
discount_id ^FK integer
locale string

rewards

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id ^FK integer
employee_id ^FK integer
branch_id ^FK integer
date date
total double
status string

reward_translations

id increments
timestamps timestamps
reason longText
reward_id ^FK integer
locale string

vacations

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id ^FK integer
branch_id ^FK integer
year integer
start_date date
end_date date
days_count integer

vacation_translations

id increments
timestamps timestamps
name string
vacation_id ^FK integer
locale string

vacation_settings

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id ^FK integer
branch_id ^FK integer
days_count integer

vacation_setting_translations

id increments
timestamps timestamps
name string
locale string
vacation_setting_id ^FK integer

trainees

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id ^FK integer
branch_id ^FK integer
category_id ^FK integer
mobile string
email string
start_date date
end_date date
duration integer
duration_type string
status string

trainee_report_translations

id increments
timestamps timestamps
title string
desc longText
trainee_report_id ^FK integer
locale string

trainee_translations

id increments
timestamps timestamps
name string
trainee_id ^FK integer
locale string

trainee_reports

id increments
timestamps timestamps
added_by_id ^FK integer
branch_id ^FK integer
trainee_id ^FK integer
add_by string
extract_certificate string

applicants

id increments
timestamps timestamps
softDeletes softDeletes
category_id ^FK integer
mobile string
email string
status string

applicant_translations

id increments
timestamps timestamps
name string
applicant_id ^FK integer
locale string

password_requests

id increments
timestamps timestamps
employee_id ^FK integer
status string

email_settings

id increments
timestamps timestamps
added_by_id ^FK integer
branch_id ^FK integer

email_setting_translations

id increments
timestamps timestamps
title string
desc longText
email_setting_id ^FK integer
locale string

messages

id increments
timestamps timestamps
branch_id ^FK integer
email string
parent_id ^FK integer
from_id ^FK integer
to_id ^FK integer
subject string
message longText

message_files

id increments
timestamps timestamps
message_id ^FK integer
file string