localtabprecoareavenda


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocaltabprecoareavenda int8 19 null
localtabprecoareavenda_aud.idlocaltabprecoareavenda Implied Constraint R
idtabelapreco int8 19 √ null
tabelapreco.idtabelapreco fk_7w66qtymak0jot5rpoqo9ijhj R
idparceirodistribuidor int8 19 √ null
parceiro.idparceiro fk_9ikpoh0k0tlxcthodcsv33him R
idtipologia int8 19 √ null
tipologia.idtipologia fk_8qhs42uh5msgryackw5bes6i9 R
idlocalfilial int8 19 √ null
local.idlocal fk_grm92pagqllk3abkfd32n8rsw R
idlocal int8 19 √ null
local.idlocal fk_2jyjnhah4qud1a62ex60ucnn3 R
observacaoregime varchar 4000 √ null
codigo varchar 20 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pkf0ab312a Primary key Asc idlocaltabprecoareavenda
idx2c10d45f Performance Asc idparceirodistribuidor
idx302b905c Performance Asc idlocal
idx41867229 Performance Asc idlocalfilial
idx4f39b47b Performance Asc idtipologia
idxf6e7848 Performance Asc idtabelapreco
idxwsversao_f0ab312a Performance Desc wsversao
uc10c89570 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.