localtipoestoque


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocaltipoestoque int8 19 null
localtipoestoque_aud.idlocaltipoestoque Implied Constraint R
idparceiro int8 19 √ null
parceiro.idparceiro fk_mpntcww6qcv2g9d0h7e9n18ge R
idlocal int8 19 √ null
local.idlocal fk_dphib0q3wdcgsos7n2gacnpis R
idtipoestoque int8 19 null
tipoestoque.idtipoestoque fk_oky8jakxx6s7bpm1i1vy65guu R
idlocalfilial int8 19 √ null
local.idlocal fk_qn89ej26hm8gc0kgolkgnisef R
idnpadrao int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 3 rows

Indexes

Constraint Name Type Sort Column(s)
pke76c5059 Primary key Asc idlocaltipoestoque
idx21f2f522 Performance Asc idlocalfilial
idx25b56b4e Performance Asc idparceiro
idx8fdbd110 Performance Asc idtipoestoque
idxc2e40109 Performance Asc idlocal
idxwsversao_e76c5059 Performance Desc wsversao
uc9a6371e1 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.