localregiao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocalregiao int8 19 null
localregiao_aud.idlocalregiao Implied Constraint R
idlocal int8 19 null
local.idlocal fk_p95l9k2lfodl44ngt7sn28tvn R
idregiao int8 19 null
regiao.idregiao fk_2uqb1fvq8y9la6ca7u9nm2mw9 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idlocalfilial int8 19 √ null
local.idlocal fk_72gsvthaigs7cra9srku8ok47 R
idnpadrao int2 5 '0'::smallint

Table contained 4 rows

Indexes

Constraint Name Type Sort Column(s)
pkb5541c6e Primary key Asc idlocalregiao
idx6510f992 Performance Asc idregiao
idxb7566058 Performance Asc idlocal
idxff23a8ed Performance Asc idlocalfilial
idxwsversao_b5541c6e Performance Desc wsversao
uc86f3baae 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.