VRSVAGASETAPASDEFAULTCOMP

992 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VGRADUACAOCOMP.CODCOLIGADA FKVRSVAGASETAPDEFCOMP_VGRADUACR
VRSVAGASETAPASDEFAULT.CODCOLIGADA FKVRSVAGASETAPDEFCOMP_VRSVAGASR
VCOMPETENCIA.CODCOLIGADA FKVRSVAGASETAPDEFCOMP_VCOMPETER
CODETAPA varchar 10 null
VRSVAGASETAPASDEFAULT.CODETAPA FKVRSVAGASETAPDEFCOMP_VRSVAGASR
CODVAGA varchar 10 null
VRSVAGASETAPASDEFAULT.CODVAGA FKVRSVAGASETAPDEFCOMP_VRSVAGASR
CODCOMPETENCIA varchar 10 null
VCOMPETENCIA.CODCOMPETENCIA FKVRSVAGASETAPDEFCOMP_VCOMPETER
CODGRADUACAO varchar 10 null
VGRADUACAOCOMP.CODGRADUACAO FKVRSVAGASETAPDEFCOMP_VGRADUACR
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)
PKVRSVAGASETAPASDEFAULTCOMP Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODVAGA + CODETAPA + CODCOMPETENCIA + CODGRADUACAO

Relationships

Close relationships within degrees of separation