VADESCALAPADRAO

15 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
VALOR RMDVALOR2 17,2 null
NOME varchar 30 null
DESCRICAO MEMO 2147483647 √ null
HABILITADO DLOGICO 2 null
CODESCALA smallint 2 null
JUSTIFICATIVAOBRIGATORIA DLOGICO 2 (0)
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODGRADUACAO varchar 10 √ null
VGRADUACAOCOMP.CODGRADUACAO FKVADESCALAPADRAO_VGRADUACAOCOR
CODCOLIGADA DCODCOLIGADA 2 null
VGRADUACAOCOMP.CODCOLIGADA FKVADESCALAPADRAO_VGRADUACAOCOR
VADDEFINICAOESCALAPADRAO.CODCOLIGADA FKVADESCALAPADRAO_VADDEFISCPADR
CODDEFINICAOESCALA varchar 10 null
VADDEFINICAOESCALAPADRAO.CODDEFINICAOESCALA FKVADESCALAPADRAO_VADDEFISCPADR

Indexes

Constraint Name Type Sort Column(s)
PKVADESCALAPADRAO Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODESCALA + VALOR + CODDEFINICAOESCALA
VXADESCALAPADRAO Must be unique Asc/Asc CODESCALA + CODCOLIGADA

Relationships

Close relationships within degrees of separation