ksm_hr - Laravel Schema Designer

core_employee

id increments
timestamps timestamps
softDeletes softDeletes
code char (10)
name string
id_type enum
id_no string (25)
home_address text
email string (100)
tel_no string (20)
mobile_no string (20)
dob date
gender char (1)
race string (100)
religion string (100)
resident_type enum
marital_status enum
nationality string (100)
is_disabled boolean
is_native boolean
passport_no string (25)
passport_expiry date
workpass_no string (25)
workpass_expiry date
health_card_no string (25)
health_card_expiry date
bank string (100)
bank_account_no string (50)
ec_name string
ec_relationship string
ec_address text
ec_contact_no string
sp_name string
sp_nric string (50)
sp_passport_no string (50)
sp_address text
sp_tax_no string (50)
sp_tax_location string (100)
sp_nationality string (100)
sp_dob date
sp_religion string
sp_is_disabled boolean
working_hours decimal (10,2)
working_days decimal (4,2)
lunch_hours decimal (4,2)
locality string
branch string
department string
section string
position string
direct_superior integer
secondary_superior integer
is_active boolean
remarks text
job_type string
punch_card_id string
old_id_no string
working_schedule string
working_type enum

payroll_employee_salary_trn

id increments
timestamps timestamps
type string (25)
amount decimal (10,2)
employee_id ^FK integer
employee_code string (50)
income_code integer

payroll_epf

id increments
timestamps timestamps
salary_from decimal (10,2)
salary_to decimal (10,2)
employee_below_sixty decimal (10,2)
employer_below_sixty decimal (10,2)
employee_above_sixty decimal (10,2)
employer_above_sixty decimal (10,2)

payroll_mtd

id increments
timestamps timestamps
year integer
p_from decimal (10,2)
p_to decimal (14,2)
m decimal (14,2)
rate decimal (14,2)
category_b1b3 decimal (14,2)
category_b2 decimal (14,2)

payroll_socso

id increments
timestamps timestamps
salary_from decimal (10,2)
salary_to decimal (10,2)
employee_below_sixty decimal (10,2)
employer_below_sixty decimal (10,2)
employee_above_sixty decimal (10,2)
employer_above_sixty decimal (10,2)

core_employee_family

id increments
timestamps timestamps
name string
relationship string
contact_no string
is_disabled boolean
dob date
marital_status string
academic_level string
employee_id ^FK integer
taxrelief_type enum

payroll_eis

id increments
timestamps timestamps
salary_from decimal (10,2)
salary_to decimal (10,2)
employee_below_sixty decimal (10,2)
employer_below_sixty decimal (10,2)

payroll_employee_salary

id increments
timestamps timestamps
employee char (10)
epf_type char (2)
epf_no string (25)
socso_type string (2)
socso_no string (25)
eis_type string (2)
tax_type enum
tax_no string (50)
tax_location string
epf_addition_coy_type enum
epf_addition_coy_value decimal (8,2)
epf_addition_staff_type enum
epf_addition_staff_value decimal (8,2)
income_basic decimal (10,2)
income_daily_wages decimal (10,2)
income_ot decimal (10,2)
income_rest_day decimal (10,2)
income_rest_day_ot decimal (10,2)
income_public_holiday decimal (10,2)
income_public_holiday_ot decimal (14,2)
income_unpaid_leave decimal (14,2)
income_annual_leave decimal (10,2)
income_director_fee decimal (10,2)
income_allowance decimal (10,2)
income_other decimal (10,2)
income_bik decimal (10,2)
income_vola decimal (10,2)
deduct_tax decimal (10,2)
deduct_epf decimal (14,2)
deduct_socso string
deduct_eis decimal (14,2)
deduct_zakat decimal (14,2)
deduct_cp38 decimal (14,2)
deduct_advance decimal (14,2)
epf_company decimal (14,2)
deduct_other decimal (14,2)
socso_company decimal (14,2)
eis_company decimal (14,2)
child_relief_1 integer
child_relief_2 string
child_relief_3 string
child_relief_4 string
child_relief_5 string
total_child_relief decimal (14,2)

core_branch

id increments
timestamps timestamps
softDeletes softDeletes
code char (10)
description string
active tinyInteger
key_by char (10)
modified_by char (10)
modified_datetime datetime

core_department

id increments
timestamps timestamps
softDeletes softDeletes
code char (10)
description string
active tinyInteger
key_by char (10)
modified_by char (10)
modified_datetime datetime

core_position

id increments
timestamps timestamps
softDeletes softDeletes
code char (10)
description string
active tinyInteger
key_by char (10)
modified_by char (10)
modified_datetime datetime

core_locality

id increments
timestamps timestamps
softDeletes softDeletes
code char (10)
description string
active tinyInteger
key_by char (10)
modified_by char (10)
modified_datetime datetime

core_section

id increments
timestamps timestamps
softDeletes softDeletes
code char (10)
description string
active tinyInteger
key_by char (10)
modified_by char (10)
modified_datetime datetime
working_days decimal (4,2)
working_hours decimal (4,2)

core_race

id increments
timestamps timestamps
softDeletes softDeletes
code char (10)
description string
active tinyInteger
key_by char (10)
modified_by char (10)
modified_datetime datetime

core_religion

id increments
timestamps timestamps
softDeletes softDeletes
code char (10)
description string
active tinyInteger
key_by char (10)
modified_by char (10)
modified_datetime datetime

core_nationality

id increments
timestamps timestamps
softDeletes softDeletes
code char (10)
description string
active tinyInteger
key_by char (10)
modified_by char (10)

core_bank

id increments
timestamps timestamps
softDeletes softDeletes
description string
active tinyInteger
key_by char (10)
code char (10)
modified_by char (10)

core_employee_academic

id increments
timestamps timestamps
softDeletes softDeletes
date_from date
date_to date
academy_name string
description string
remark string

core_employee_workexp

id increments
timestamps timestamps
softDeletes softDeletes
date_from date
date_to date
company_name string
position string
remark string

core_employee_traincert

id increments
timestamps timestamps
softDeletes softDeletes
date_from date
date_to date
name string
description string
remark string

core_employee_recruit

id increments
timestamps timestamps
employee char (10)
join_date date
confirm_date date
resign_date date

core_holiday_scheme

id increments
timestamps timestamps
code char (10)
description string
active tinyInteger

core_holiday

id increments
timestamps timestamps
softDeletes softDeletes
date date
description string

core_holiday_scheme_trn

id increments
timestamps timestamps
holiday_scheme integer
holiday integer

core_working_schedule

id increments
timestamps timestamps
softDeletes softDeletes
code char (10)
description string
active tinyInteger

core_working_schedule_trn

id increments
timestamps timestamps
softDeletes softDeletes
working_schedule char (10)
day tinyInteger
time_from time
time_to time
time_from_crossday tinyInteger
time_to_crossday string
lunch_from time
lunch_to time
lunch_from_crossday tinyInteger
lunch_to_crossday tinyInteger
is_rest_day tinyInteger

core_user

id increments
timestamps timestamps
softDeletes softDeletes

core_usergroup

id increments
timestamps timestamps
softDeletes softDeletes

payroll_income_deduct_type

id increments
timestamps timestamps
softDeletes softDeletes
code char (10)
description string
field enum
rate decimal (14,2)
remuneration_type enum
payslip_sort integer
epf integer
socso integer
tax integer
type enum

payroll_tax_exempt

id increments
timestamps timestamps
softDeletes softDeletes
year integer
code enum
description string
limit decimal (14,2)

payroll_cp38

id increments
timestamps timestamps
softDeletes softDeletes
employee char (10)
term date
total decimal (14,2)
payroll tinyInteger

payroll_employee_tax_exempt

id increments
timestamps timestamps
softDeletes softDeletes
term date
employee char (10)
code enum
total decimal (14,2)
payroll tinyInteger

payroll_mtd_calculation

id increments
timestamps timestamps
softDeletes softDeletes
term date
employee char (10)
p_value decimal (14,2)
m_value decimal (14,2)

payroll_employee_update_request

id increments
timestamps timestamps
softDeletes softDeletes

payroll_adjust_trn

id increments
timestamps timestamps
softDeletes softDeletes
apply_date date
employee char (10)
proposed_basic string
effective_date date
approve1_by string
approve1_datetime string
approve1_feedback string
approve1_action enum
approve2_by string
approve2_datetime datetime
approve2_feedback string
approve2_action string
approve3_by string
approve3_datetime datetime
approve3_feedback string
approve3_action enum
status enum

payroll_adjust_approval

id increments
timestamps timestamps
employee char (10)
approval_1 string
approval_2 string
approval_3 string

leave_type

id increments
timestamps timestamps
softDeletes softDeletes
code char (10)
description string
active tinyInteger
deduct_payroll tinyInteger
calc_prorate string
include_holiday tinyInteger
is_medical tinyInteger
allow_bf tinyInteger
max_bf tinyInteger
notice_day integer
balance_type enum
deduct_next_year_leave_type char (10)

leave_structure

id increments
timestamps timestamps
softDeletes softDeletes
code char (10)
description string
active tinyInteger

leave_structure_trn

id increments
timestamps timestamps
softDeletes softDeletes
leave_structure char (10)
leave_type char (10)
period1 decimal (14,2)
period2 decimal (14,2)
period3 decimal (14,2)
period4 decimal (14,2)
period5 decimal (14,2)
period1_medical decimal (14,2)
period2_medical decimal (14,2)
period3_medical decimal (14,2)
period4_medical decimal (14,2)
period5_medical decimal (14,2)
max_medical_per_trn decimal (14,2)

leave_approval

id increments
timestamps timestamps
employee char (10)
approval_1 string
approval_2 string
approval_3 string

leave_trn

id increments
timestamps timestamps
softDeletes softDeletes
apply_date date
type enum
employee char (10)
leave_type char (10)
date_from date
date_from_full tinyInteger
date_from_shift enum
date_to date
date_to_full tinyInteger
date_to_shift enum
reason string
total_days decimal (14,2)
medical_claim decimal (14,2)
approve1_by string
approve1_datetime string
approve1_feedback string
approve1_action enum
approve2_by string
approve2_datetime datetime
approve2_feedback string
approve2_action string
approve3_by string
approve3_datetime datetime
approve3_feedback string
approve3_action enum
status enum
bf tinyInteger

loan_mt

id increments
timestamps timestamps
softDeletes softDeletes
docno string
apply_date date
employee char (10)
total decimal (14,2)
repay_term string
tenure integer
approve1_by string
approve1_datetime string
approve1_feedback string
approve1_action enum
approve2_by string
approve2_datetime datetime
approve2_feedback string
approve2_action string
approve3_by string
approve3_datetime datetime
approve3_feedback string
approve3_action enum
status enum

loan_trn

id increments
timestamps timestamps
softDeletes softDeletes
employee char (10)
docno char (10)
term date
total decimal (14,2)
payroll tinyInteger

loan_approval

id increments
timestamps timestamps
employee char (10)
approval_1 string
approval_2 string
approval_3 string