VRSSELECOESVAGASETAPASCOMP

69 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VGRADUACAOCOMP.CODCOLIGADA FKVRSSELVGETPCOMP_VGRADUACAOCOR
VCOMPETENCIA.CODCOLIGADA FKVRSSELVGETAPACOMP_VCOMPETENCR
CODSELECAO varchar 10 null
CODVAGA varchar 10 null
CODETAPA varchar 10 null
CODCOMPETENCIA varchar 10 null
VCOMPETENCIA.CODCOMPETENCIA FKVRSSELVGETAPACOMP_VCOMPETENCR
CODGRADUACAO varchar 10 null
VGRADUACAOCOMP.CODGRADUACAO FKVRSSELVGETPCOMP_VGRADUACAOCOR
DATACADASTRO DDATETIME 16,3 null
HABILITADO smallint 2 √ 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)
PKVRSSELECOESVAGASETAPASCOMP Primary key Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODSELECAO + CODVAGA + CODETAPA + CODCOMPETENCIA + CODGRADUACAO

Relationships

Close relationships within degrees of separation