hrms - Laravel Schema Designer

Parties

party_id increments
timestamps timestamps
softDeletes softDeletes
email_id string (100)
contact_no string (20)
address string (300)
location_id ^FK integer

Locations

location_id increments
timestamps timestamps
pincode string (20)
city string (100)
location_states_id ^FK integer

Location_States

location_states_id increments
timestamps timestamps
state_name string (100)
country_name string (100)

Persons

perosn_id increments
party_id ^FK integer
timestamps timestamps
softDeletes softDeletes
first_name string (100)
last_name string (100)
date_of_birth date
insurance_id ^FK integer

Person_Family_Relations

person_family_relation_id increments
timestamps timestamps
softDeletes softDeletes
person_party_id ^FK integer
family_member_party_id ^FK integer
relation string (30)

Insurances

insurance_id increments
timestamps timestamps
softDeletes softDeletes
provider_name string (300)
start_date date
end_date date
premium_amount decimal (15,2)
type string (50)

Organizations

organization_id increments
timestamps timestamps
softDeletes softDeletes
organization_party_id ^FK integer
type integer
organization_name string (200)

Employees

employee_id increments
timestamps timestamps
softDeletes softDeletes
employee_person_party_id ^FK integer
joining_date date
type integer
designation_id integer
organization_party_id ^FK integer

Employee_details

employee_detail_id increments
timestamps timestamps
softDeletes softDeletes
employee_person_party_id ^FK integer
email_id_personal string (100)
contact_no_personal string (20)
social_security_number string (12)
passport_number string (20)
bank_account_no string
bank_routing_id string
passport_validity_end_date date

Designations

designation_id increments
timestamps timestamps
designation string (50)

Employee_managers

employee_manager_id increments
timestamps timestamps
softDeletes softDeletes
employee_party_id ^FK integer
manager_party_id ^FK integer

Employee_projects

employee_project_id increments
timestamps timestamps
softDeletes softDeletes
employee_party_id ^FK integer
project_id ^FK integer

Projects

project_id increments
timestamps timestamps
softDeletes softDeletes
project_name string (100)
project_description string (500)
start_date date
end_date date
budget_code string (30)

Organization_projects

organization_project_id increments
timestamps timestamps
softDeletes softDeletes
organization_party_id ^FK integer
project_id ^FK integer

Work_hours

work_hour_id increments
timestamps timestamps
softDeletes softDeletes
employee_party_id ^FK integer
project_id ^FK integer
start_date date
end_date date
approval_status boolean
client_manager_party_id ^FK integer
finance_processed_status boolean
total_worked_hours integer

Users

user_id increments
timestamps timestamps
softDeletes softDeletes
username string (30)
password string (300)
confirmation_code string (300)
confirmed boolean
role_id ^FK integer
party_id ^FK integer

Roles

role_id increments
timestamps timestamps
role string (30)

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