Column |
Internal relation An internal relation is not necessary when a corresponding FOREIGN KEY relation exists. |
---|
id
|
|
empid
|
|
current_date
|
|
emp_name
|
|
dob
|
|
qualification
|
|
marital_status
|
|
a_year
|
|
a_month
|
|
a_day
|
|
gender
|
|
doj
|
|
blood_group
|
|
dol
|
|
father_sp
|
|
pf
|
|
relegion
|
|
location
|
|
staff_type
|
|
department_master_id
|
|
dept_code
|
|
dept_desc
|
|
status
|
|
desigcode
|
|
designation_id
|
|
description
|
|
house_no
|
|
street
|
|
a_location
|
|
district
|
|
town
|
|
state
|
|
country
|
|
pin
|
|
email
|
|
ph1
|
|
ph2
|
|
ph3
|
|
mob
|
|
fax
|
|
pager
|
|
created_date
|
|
created_by
|
|
modified_date
|
|
modified_by
|
|
auth
|
|
min_discount
|
|
max_discount
|
|
dis_request
|
|
req_dis_min
|
|
req_dis_max
|
|
cash
|
|
nippon_emp_id
|
|
posted_voucher_dis_apr_1
|
|
posted_voucher_dis_apr_2
|
|
locationname
|
|
biomatric_id
|
|