tbl_employeepayelementmaster

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_employeepayelementmaster_id_seq'::regclass)
employeeid varchar 500 null
tbl_employee.employeeid Implied Constraint R
effectivedate timestamp 29,6 √ null
templateid int8 19 √ null
templatetype varchar 50 null
mode varchar 50 null
ctcamount numeric 0 √ null
grossamount numeric 0 √ null
splitsectiona bool 1 √ null
isdelete bool 1 √ null
isactive bool 1 √ null
createdby varchar 50 null
modifiedby varchar 50 null
createddate timestamp 29,6 null
modifieddate timestamp 29,6 null
annual_ctc_amount numeric 0 √ null
annual_gross_amount numeric 0 √ null

Indexes

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

Relationships

Close relationships within degrees of separation