parametro


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idparametro int8 19 null
parametro.idparametrosuperior fk_6s1rrc2fnk12lvvxwp4dfw10 R
parametro_aud.idparametro Implied Constraint R
parametrofilial.idparametro fk_pnw2cl1wnjnuiqtqkf95djvrr R
parametrofilial_aud.idparametro Implied Constraint R
parametrousuario.idparametro fk_6jwejkmw85kudngktvmp7ue3e R
parametrousuario_aud.idparametro Implied Constraint R
idnativo int2 5 √ null
idnespecializa int2 5 √ null
idnpermitealteracao int2 5 √ null
idtipodado int8 19 √ null
tipodado.idtipodado fk_hexjcp6c4v38dke4gsg01vv2j R
precisao numeric 18,6 √ null
chave varchar 80 null
descricao varchar 400 √ null
observacao varchar 400 √ null
valor varchar 255 null
valorminimo varchar 255 √ null
valormaximo varchar 255 √ null
sglorigem varchar 10 √ null
sglambiente varchar 20 √ null
sglmodulo varchar 20 √ null
sglcontexto varchar 20 √ null
observacaoes varchar 400 √ null
observacaoen varchar 400 √ null
descricaoen varchar 400 √ null
descricaoes varchar 400 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idparametrosuperior int8 19 √ null
parametro.idparametro fk_6s1rrc2fnk12lvvxwp4dfw10 R

Table contained 314 rows

Indexes

Constraint Name Type Sort Column(s)
pkebf0d519 Primary key Asc idparametro
idx67c176a0 Performance Asc idparametrosuperior
idxe4694a94 Performance Asc idtipodado
idxwsversao_ebf0d519 Performance Desc wsversao
uc66a7e403 Must be unique Asc codigoerp
ucf82dd3a4 Must be unique Asc chave

Graphviz Needed!

SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz graphvizVersion 2.26 or versions greater than 2.31 from www.graphviz.org.