variavel


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idvariavel int8 19 null
planejamentovariavel.idvariavel fk_88lxu4j3ijj71klouwbj40rqf R
planejamentovariavel_aud.idvariavel Implied Constraint R
variavel_aud.idvariavel Implied Constraint R
descricao varchar 80 null
nomevariavel varchar 80 null
tipovariavel varchar 80 null
valorvarchar varchar 80 √ null
valordata date 13 √ null
valornumero numeric 18,6 √ null
idnativo int2 5 null
sglmodulo varchar 80 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 1 rows

Indexes

Constraint Name Type Sort Column(s)
pkb95f80de Primary key Asc idvariavel
idxwsversao_b95f80de Performance Desc wsversao
uc86b7e8bc Must be unique Asc codigoerp

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.