mixpremiacao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idmixpremiacao int8 19 null
mixpremiacao_aud.idmixpremiacao Implied Constraint R
quantidade numeric 18,6 null
idmix int8 19 null
mix.idmix fk_h53vt3e6jk3u4866cbdhpgeqn R
idmixpremio int8 19 √ null
mix.idmix fk_gsav1917fartfo5thy1xtvpp2 R
idproduto int8 19 √ null
produto.idproduto fk_3iihpigmdsmdxisukwjs3hsa0 R
percentualdesconto numeric 18,6 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk1b1c98f3 Primary key Asc idmixpremiacao
idx8f12f7aa Performance Asc idmixpremio
idxcf925407 Performance Asc idmix
idxd2d06131 Performance Asc idproduto
idxwsversao_1b1c98f3 Performance Desc wsversao
uc3ad48727 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.