tbl_resignationclearancehead

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
rcheaderid bigserial 19 √ nextval('tbl_resignationclearancehead_rcheaderid_seq'::regclass)
tbl_resignationclearance.rcheaderid Implied Constraint R
resignationid int8 19 √ null
tbl_resignationmaster.resignationid Implied Constraint R
rcemployeeid varchar 20 √ null
rcattachment varchar 150 √ null
clearancestatus varchar 10 √ null
hrstatus varchar 10 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
remarks varchar 500 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_resignationclearancehead_pk_tbl_resignationclearancehead Primary key Asc rcheaderid

Relationships

Close relationships within degrees of separation