operacaousuario


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idoperacaousuario int8 19 null
operacaousuario_aud.idoperacaousuario Implied Constraint R
datainiciovigencia date 13 √ null
datafimvigencia date 13 √ null
valorminimo numeric 18,6 √ null
valormaximo numeric 18,6 √ null
valor numeric 18,6 √ null
quantidademinima numeric 18,6 √ null
quantidademaxima numeric 18,6 √ null
idusuario int8 19 √ null
usuario.idusuario fk_mrfutpq033qq5behg65mu42ad R
idoperacao int8 19 null
operacao.idoperacao fk_rd1w4y1o1g1hykxp7oq8wdvqn R
idtipopedido int8 19 √ null
tipopedido.idtipopedido fk_89hdgnivuxioj0ac3rmgq7qru R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idlocalfilial int8 19 √ null
local.idlocal fk_5df5y1n0yccq81bd9483bq9mi R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk8977be10 Primary key Asc idoperacaousuario
idx1cdf0279 Performance Asc idtipopedido
idx6bd4659b Performance Asc idoperacao
idx82725b56 Performance Asc idusuario
idxfcc367cb Performance Asc idlocalfilial
idxwsversao_8977be10 Performance Desc wsversao
uce2a73b8c 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.