operacaotipopedido


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idoperacaotipopedido int8 19 null
operacaotipopedido_aud.idoperacaotipopedido Implied Constraint R
descricao varchar 80 √ null
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
idtipopedido int8 19 null
tipopedido.idtipopedido fk_6082fd9vo7blhwwy62fca9kgu R
idoperacao int8 19 null
operacao.idoperacao fk_5wo0gd0edfenfuw9s9a4sd6i3 R
idlocalfilial int8 19 √ null
local.idlocal fk_2wfyj5ww564a3hi756gg185by R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idembalagem int8 19 √ null
embalagem.idembalagem fk_ql3ne0ouf79x08cbr3h1wxpa5 R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk2989d177 Primary key Asc idoperacaotipopedido
idx15dfeaab Performance Asc idoperacao
idx75420e1c Performance Asc idtipopedido
idx7aca2416 Performance Asc idlocalfilial
idx892fb8c1 Performance Asc idembalagem
idxwsversao_2989d177 Performance Desc wsversao
ucc5629e43 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.