VCOMPETENCIAFUNCAO

264 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VGRADUACAOCOMP.CODCOLIGADA FKVCOMPETENFUNC_VGRADUACAOCOMPR
PFUNCAO.CODCOLIGADA FKVCOMPETENCIAFUNCAO_PFUNCAOR
VCOMPETENCIA.CODCOLIGADA FKVCOMPETENCIAFUN_VCOMPETENCIAR
CODCOMPETENCIA varchar 10 null
VCOMPETENCIA.CODCOMPETENCIA FKVCOMPETENCIAFUN_VCOMPETENCIAR
CODFUNCAO varchar 10 null
PFUNCAO.CODIGO FKVCOMPETENCIAFUNCAO_PFUNCAOR
CODGRADUACAO varchar 10 √ null
VGRADUACAOCOMP.CODGRADUACAO FKVCOMPETENFUNC_VGRADUACAOCOMPR
OBSERVACAO MEMO 2147483647 √ null
DATAINCLUSAO datetime 16,3 √ null
HABILITADO DLOGICO 2 null
PESO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKVCOMPETENCIAFUNCAO Primary key Asc/Asc/Asc CODCOLIGADA + CODCOMPETENCIA + CODFUNCAO

Relationships

Close relationships within degrees of separation