tbl_paidretentiondetails

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
rid bigserial 19 √ nextval('tbl_paidretentiondetails_rid_seq'::regclass)
employeeid varchar 50 √ null
rmonth int4 10 √ null
ryear int4 10 √ null
ramount numeric 0 √ null
calculateddate timestamp 29,6 √ null
paidstatus bool 1 √ null
paiddate timestamp 29,6 √ null
companyid int4 10 √ null
tbl_companymaster.companyid Implied Constraint R
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
comp1 varchar 500 √ null
comp2 varchar 500 √ null
comp3 timestamp 29,6 √ null
comp4 numeric 0 √ null
comp5 int8 19 √ null
comp6 bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_paidretentiondetails_pk_tbl_paidretentiondetails Primary key Asc rid

Relationships

Close relationships within degrees of separation