Column |
Internal relation An internal relation is not necessary when a corresponding FOREIGN KEY relation exists. |
---|
id
|
|
mst_www_userid
|
|
emp_site
|
|
employment_type
|
|
employee_type
|
|
emp_code
|
|
emp_name
|
|
fh_name
|
|
nationality
|
|
religion
|
|
dob
|
|
doj
|
|
dol
|
|
department
|
|
emp_shift
|
|
emp_weekly_off
|
|
designation
|
|
marital_status
|
|
marriage
|
|
wh_name
|
|
sons
|
|
daughters
|
|
sex
|
|
grade
|
|
personalEmail
|
|
offEmail
|
|
PFno
|
|
ESIno
|
|
leave_eff_date
|
|
bachelor
|
|
other_bachelor
|
|
master
|
|
other_master
|
|
basic_perc
|
|
basic_salary
|
|
allow_tot
|
|
deduct_tot
|
|
gross_sal
|
|
gross
|
|
net_sal
|
|
eff_sal_date
|
|
pf_calculation
|
|
adv_amount
|
|
adv_date
|
|
over_time
|
|
overtime_salary
|
|
image
|
|
document2
|
|
document3
|
|
document
|
|
bank_account
|
|
bank_name
|
|
ESI_account
|
|
PF_accountno
|
|
payment_mode
|
|
created_by
|
|
created_date
|
|
CompanyId
|
|
blocked
|
|
bloodgroup
|
|
course1
|
|
course2
|
|
course3
|
|
pf_Reimbursement_per
|
|
pf_Reimbursement
|
|
medical_Reimbursement_per
|
|
medical_Reimbursement
|
|
tenth_standard
|
|
tenthplus2_standard
|
|
pending_wo
|
|
multi_site_att
|
|
otapplicable
|
|
ottype
|
|
auth
|
|
status
|
|
loan_ledger
|
|
advance_ledger
|
|
staff_type
|
|
biomatric_id
|
|