Home
hrms
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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)
×
Comments for hrms
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01