HPARAM

12 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
HPARAMATENDIMENTO.CODCOLIGADA FKHPARAMATATEND_HPARAMR
HPARAMETROTIPOTABELA.CODCOLIGADA FKHPARAMETROTIPOTABELA_HPARAMR
HPARAMTIPOATEND.CODCOLIGADA FKHPARAMTI_HPARAMR
CODPARAMETRO int 4 null
HPARAMATENDIMENTO.CODPARAMETRO FKHPARAMATATEND_HPARAMR
HPARAMETROTIPOTABELA.IDPARAMETRO FKHPARAMETROTIPOTABELA_HPARAMR
HPARAMTIPOATEND.CODPARAMETRO FKHPARAMTI_HPARAMR
APLICACAO char 1 √ null
GCONSSQL.APLICACAO FKHPARAM_GCONSSQLR
CODSENTENCA varchar 16 √ null
GCONSSQL.CODSENTENCA FKHPARAM_GCONSSQLR
NOME varchar 30 null
DESCRICAO varchar 255 √ null
TIPO varchar 30 √ null
TAMANHO int 4 √ null
EXIBIR int 4 √ (0)
TIPOLINK varchar 30 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
TIPOLOOKUP int 4 √ null
TIPOLOOKUPPK varchar 100 √ null
AUTOSHOWPESQUISAATENDIMENTOS DLOGICO 2 √ null
CODCOLIGADASENTENCA DCODCOLIGADANULL 2 √ null
GCONSSQL.CODCOLIGADA FKHPARAM_GCONSSQLR

Indexes

Constraint Name Type Sort Column(s)
PKHPARAM Primary key Asc/Asc CODCOLIGADA + CODPARAMETRO
HXHPARAM Must be unique Asc NOME

Relationships

Close relationships within degrees of separation