tbl_leaveencashment

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
lencashmentid serial 10 √ nextval('tbl_leaveencashment_lencashmentid_seq'::regclass)
employeeid varchar 20 √ null
tbl_employee_previous_pf.employeeid Implied Constraint R
employeename varchar 60 √ null
leavebalance numeric 0 √ null
leaveencashed numeric 0 √ null
leavetoencash numeric 0 √ null
paymentdate timestamp 29,6 √ null
lenyear int4 10 √ null
lenmonth int4 10 √ null
encashamount numeric 0 √ null
encashperson varchar 60 √ null
encashstatus varchar 10 √ null
leavecode varchar 50 √ null
requestencashamount numeric 0 √ null
cmpid int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_leaveencashment_pk_tbl_leaveencashment Primary key Asc lencashmentid

Relationships

Close relationships within degrees of separation