GMDATRIBUTO

20 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODIGO int 4 null
GMDCONSTRAINTCOL.CODATRIBUTO FKGMDCONSTRAINTCOL_GMDATRIBUTOR
GMDCONSTRAINTCOL.CODATRIBUTOREF FKGMDCONSTRAINTCOL_GMDATRIBUT2R
GMDCONTROLE.CODATRIBUTO FKGMDCONTROLE_GMDATRIBUTOR
CODTABELA int 4 √ null
GMDTABELA.CODIGO FKGMDATRIBUTO_GMDTABELAR
CODNEGOCIOTABELA int 4 √ null
GMDNEGOCIOTABELA.CODIGO FKGMDATRIBUTO_GMDNEGOCIOTABELAR
NOME varchar 30 null
CODTIPO int 4 √ null
GMDATRIBUTOTIPO.CODIGO FKGMDATRIBUTO_GMDATRIBUTOTIPOR
TAMANHO int 4 √ null
CHAVEPRIMARIA smallint 2 ((0))
AUTOINCREMENTO smallint 2 ((0))
VISIVELVISAO smallint 2 null
VISIVELEDICAO smallint 2 null
SOMENTELEITURA smallint 2 √ null
OBRIGATORIO int 4 ((0))
DESCRICAOLKP smallint 2 √ null
MASCARA varchar 60 √ null
VALORPADRAO varchar 50 √ null
ESCALA int 4 √ null
POSICAO int 4 null
ECFGAUTEN.POSICAO Implied ConstraintR
DOCUMENTACAO varchar 500 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
LAYER int 4 √ null
CRC int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKGMDATRIBUTO Primary key Asc CODIGO

Relationships

Close relationships within degrees of separation