tbl_pmscompetencytypemaster

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
competencyid bigserial 19 √ nextval('tbl_pmscompetencytypemaster_competencyid_seq'::regclass)
employeeid varchar 50 √ null
emprat numeric 0 √ null
rep1id varchar 50 √ null
ret1rat numeric 0 √ null
rep2id varchar 50 √ null
rep2rat numeric 0 √ null
formid int8 19 √ null
tbl_formdetail.formid Implied Constraint R
companyid int8 19 √ null
catid int8 19 √ null
questionid int8 19 √ null
subquestionid int8 19 √ null
column1 varchar 500 √ null
column2 int8 19 √ null
column3 varchar 500 √ null
column4 varchar 500 √ null
isemprat bool 1 √ false
isrep1rat bool 1 √ false
isrep2rat bool 1 √ false
effectivedate timestamp 29,6 √ null
isopenended bool 1 √ false
openanswer varchar 2000 √ null
empanswer varchar 2000 √ null
rep1answer varchar 2000 √ null
rep2answer varchar 2000 √ null
column5 int4 10 √ null
column6 varchar 500 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_pmscompetencytypemaster_pk_tbl_pmscompetencytypemaster Primary key Asc competencyid

Relationships

Close relationships within degrees of separation