VADESCALA

35 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VGRADUACAOCOMP.CODCOLIGADA FKVADESCALA_VGRADUACAOCOMPR
VADAVALIACAO.CODCOLIGADA FKVADESCALA_VADAVALIACAOR
VADDEFINICAOESCALA.CODCOLIGADA FKVADESCALA_VADDEFINICAOESCALAR
CODAVALIACAO varchar 10 null
VADAVALIACAO.CODAVALIACAO FKVADESCALA_VADAVALIACAOR
VADDEFINICAOESCALA.CODAVALIACAO FKVADESCALA_VADDEFINICAOESCALAR
VALOR RMDVALOR2 17,2 null
NOME varchar 30 null
DESCRICAO MEMO 2147483647 √ null
PONTOCORTE DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
JUSTIFICATIVAOBRIGATORIA DLOGICO 2 (0)
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
INTERVALOINICIO RMDVALOR2 17,2 √ null
INTERVALOTERMINO RMDVALOR2 17,2 √ null
CODGRADUACAO varchar 10 √ null
VGRADUACAOCOMP.CODGRADUACAO FKVADESCALA_VGRADUACAOCOMPR
CODDEFINICAOESCALA varchar 10 null
VADDEFINICAOESCALA.CODDEFINICAOESCALA FKVADESCALA_VADDEFINICAOESCALAR

Indexes

Constraint Name Type Sort Column(s)
PKVADESCALA Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODAVALIACAO + VALOR + CODDEFINICAOESCALA

Relationships

Close relationships within degrees of separation