VCOMPETENCIA

57 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VADCOMPETENCIAAVALIADA.CODCOLIGADAAGRUPADOR FKVADCOMPAVALIADA_VCOMPETENCIAR
VADPDI.CODCOLIGADA FKVADPDI_VCOMPETENCIAR
VCOMPETENCIAFUNCAO.CODCOLIGADA FKVCOMPETENCIAFUN_VCOMPETENCIAR
VCOMPETENCIAPERFORMANCE.CODCOLIGADA FKVCOMPETPERF_VCOMPETENCIAR
VCOMPETENCIAPESSOA.CODCOLIGADA FKVCOMPPESSOA_VCOMPETENCIAR
VCOMPETENCIAPESSOAHIST.CODCOLIGADA FKVCOMPETEPESHIST_VCOMPETENCIAR
VCOMPETENCIAREQUISITO.CODCOLIGADA FKVCOMPETENCIAREQ_VCOMPETENCIAR
VGMETAATRIBUICAO.CODCOLIGADACOMPETENCIA FKVGMETAATRIBUICAO_VCOMPETENCIR
VGMETACOMPETENCIA.CODCOLIGADACOMPETENCIA FKVGMETACOMPETENCIA_VCOMPETENCR
VLNTCOMPCALC.CODCOLIGADA FKVLNTCOMPCALC_VCOMPETENCIAR
VLNTPESSOASCOMP.CODCOLIGADA FKVLNTPESSOASCOMP_VCOMPETR
VMAPACONHECIMENTOCOMPETENCIA.CODCOLIGADA FKVMAPACONHECCOMPET_VCOMPETENCR
VPDISUGESTAO.CODCOLIGADACOMPETENCIA FKVPDISUGESTAO_VCOMPETENCIAR
VRSSELECOESVAGASETAPASCOMP.CODCOLIGADA FKVRSSELVGETAPACOMP_VCOMPETENCR
VRSVAGASETAPASDEFAULTCOMP.CODCOLIGADA FKVRSVAGASETAPDEFCOMP_VCOMPETER
CODCOMPETENCIA varchar 10 null
VADCOMPETENCIAAVALIADA.CODCOMPETENCIA FKVADCOMPAVALIADA_VCOMPETENCIAR
VADPDI.CODCOMPETENCIA FKVADPDI_VCOMPETENCIAR
VCOMPETENCIAFUNCAO.CODCOMPETENCIA FKVCOMPETENCIAFUN_VCOMPETENCIAR
VCOMPETENCIAPERFORMANCE.CODCOMPETENCIA FKVCOMPETPERF_VCOMPETENCIAR
VCOMPETENCIAPESSOA.CODCOMPETENCIA FKVCOMPPESSOA_VCOMPETENCIAR
VCOMPETENCIAPESSOAHIST.CODCOMPETENCIA FKVCOMPETEPESHIST_VCOMPETENCIAR
VCOMPETENCIAREQUISITO.CODCOMPETENCIA FKVCOMPETENCIAREQ_VCOMPETENCIAR
VGMETAATRIBUICAO.CODCOMPETENCIA FKVGMETAATRIBUICAO_VCOMPETENCIR
VGMETACOMPETENCIA.CODCOMPETENCIA FKVGMETACOMPETENCIA_VCOMPETENCR
VLNTCOMPCALC.CODCOMPETENCIA FKVLNTCOMPCALC_VCOMPETENCIAR
VLNTPESSOASCOMP.CODCOMPETENCIA FKVLNTPESSOASCOMP_VCOMPETR
VMAPACONHECIMENTOCOMPETENCIA.CODCOMPETENCIA FKVMAPACONHECCOMPET_VCOMPETENCR
VPDISUGESTAO.CODCOMPETENCIA FKVPDISUGESTAO_VCOMPETENCIAR
VRSSELECOESVAGASETAPASCOMP.CODCOMPETENCIA FKVRSSELVGETAPACOMP_VCOMPETENCR
VRSVAGASETAPASDEFAULTCOMP.CODCOMPETENCIA FKVRSVAGASETAPDEFCOMP_VCOMPETER
NOME varchar 200 null
CONCEITO MEMO 2147483647 √ null
TIPO varchar 5 √ null
VTIPOCOMP.CODCLIENTE FKVCOMPETENCIA_VTIPOCOMPR
TREINAVEL DLOGICO 2 null
METACOMPETENCIA varchar 5 √ null
PERFORMANCE int 4 √ null
CODHABILIDADE varchar 16 √ null
VHABILIDADES.CODHABILIDADE Implied ConstraintR
ID int identity 4 √ null
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)
PKVCOMPETENCIA Primary key Asc/Asc CODCOLIGADA + CODCOMPETENCIA
VXCOMPETENCIAID Must be unique Asc ID

Relationships

Close relationships within degrees of separation