hr_documentcategorymaster

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
doccategoryid bigserial 19 √ nextval('hr_documentcategorymaster_doccategoryid_seq'::regclass)
hr_documentmaster.doccategoryid Implied Constraint R
documentcategoryname varchar 2147483647 √ null
description varchar 2147483647 √ null
status bool 1 √ null
com1 varchar 2147483647 √ null
com2 varchar 2147483647 √ null
com3 varchar 2147483647 √ null
com4 varchar 2147483647 √ null
com5 varchar 2147483647 √ null
com6 varchar 2147483647 √ null
com7 varchar 2147483647 √ null
com8 varchar 2147483647 √ null
com9 varchar 2147483647 √ null
com10 varchar 2147483647 √ null
createdby varchar 50 √ null
createdon timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifiedon timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
hr_documentcategorymaster_pk_hr_documentcategorymaster Primary key Asc doccategoryid

Relationships

Close relationships within degrees of separation