tbl_employeereimbursementpaycycle

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
paycycleid bigserial 19 √ nextval('tbl_employeereimbursementpaycycle_paycycleid_seq'::regclass)
paymentid int8 19 √ null
payelementid int4 10 √ null
payelementcode varchar 50 √ null
employeeid varchar 20 √ null
tbl_employee_previous_pf.employeeid Implied Constraint R
payslipmonth int4 10 √ null
psyear int4 10 √ null
attachment varchar 2147483647 √ null
eligibleamount numeric 18,2 √ '0'::numeric
claimamount numeric 18,2 √ '0'::numeric
status varchar 100 √ null
paymentstatus varchar 100 √ null
modeofpayment varchar 100 √ null
bankname varchar 100 √ null
chequeno varchar 100 √ null
remark varchar 100 √ null
paymentdate timestamp 29,6 √ null
createdby varchar 50 null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
comment varchar 1000 √ null
isfreezed bool 1 √ false
actualpaydays numeric 18,2 √ '0'::numeric
isimported bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_employeereimbursementpaycycle_pk_tbl_employeereimbursementp Primary key Asc paycycleid

Relationships

Close relationships within degrees of separation