tbl_tniformemployeemaster

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tniid bigserial 19 √ nextval('tbl_tniformemployeemaster_tniid_seq'::regclass)
employeeid varchar 50 √ null
companyid int8 19 √ null
empcomments varchar 500 √ null
rep1comments varchar 500 √ null
rep2comments varchar 500 √ null
ext1comments varchar 500 √ null
ext2comments varchar 500 √ null
reviewdate1 timestamp 29,6 √ null
reviewdate2 timestamp 29,6 √ null
tnicatid int8 19 √ null
tniqueid int8 19 √ null
column1 varchar 500 √ null
column2 int8 19 √ null
isemprat bool 1 √ false
isrep1rat bool 1 √ false
isrep2rat bool 1 √ false
effectivedate timestamp 29,6 √ null
rep1approve bool 1 √ null
rep2approve bool 1 √ null
finalapprove bool 1 √ null
recommendby varchar 50 √ null
comm1 varchar 50 √ null
comm2 varchar 50 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
pms_goal_list_id int8 19 √ null
tbl_pmsgoallist.id fk_tniformemployeemaster_pms_goal_list_id R

Indexes

Constraint Name Type Sort Column(s)
tbl_tniformemployeemaster_pk_tbl_tniformemployeemaster Primary key Asc tniid

Relationships

Close relationships within degrees of separation