hr_portal - Laravel Schema Designer

users

id increments
name string (255)
emp_status_id ^FK integer
cnic integer
mobile integer
alt_phone integer
email string (255)
join_date date
address string (255)
designation_id ^FK integer
photo string (255)
timestamps timestamps

emp_status

id increments
name string (255)
timestamps timestamps

designations

id increments
name string (255)
status string (255)
timestamps timestamps

attendance

id increments
user_id ^FK integer
date date
time_in time
time_out time
timestamps timestamps

leave_policies

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

leave_policy_details

id increments
leave_policy_id ^FK integer
exp_in_years integer
no_of_days integer
timestamps timestamps

leave_types

id increments
name string (255)
status string (255)
timestamps timestamps

leave_policy_user

id increments
leave_policy_id ^FK integer
leave_balance integer
user_id ^FK integer
timestamps timestamps

leave_type_user

id increments
user_id ^FK integer
leave_type_id ^FK integer
no_of_days integer
from_date date
to_date date
noted text
approved boolean
timestamps timestamps

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