tbl_esicaccountdeductionmapping

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_esicaccountdeductionmapping_id_seq'::regclass)
sbuid int8 19 null
employeeid varchar 500 null
tbl_employee.employeeid Implied Constraint R
month int4 10 null
year int4 10 null
employeresicaccountno varchar 100 √ null
employeeesicaccountno varchar 100 √ null
employeeamount numeric 0 null
employeramount numeric 0 null
compliancebranchid int8 19 √ null
branchid int8 19 √ null
tbl_branchmaster.branchid Implied Constraint R
esicruleid int8 19 √ null
isimport bool 1 √ false
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_esicaccountdeductionmapping_pk_tbl_esicaccountdeductionmapp Primary key Asc id

Relationships

Close relationships within degrees of separation