lote


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlote int8 19 null
desconto.idlote fk_k4rmsh8j7hycy4o8hk0erol3p R
desconto_aud.idlote Implied Constraint R
lote_aud.idlote Implied Constraint R
lotemovimento.idlote fk_3csy410d1bgaiteqbaxq40ljk R
lotemovimento_aud.idlote Implied Constraint R
operacaolote.idlote fk_loiebkkfjbr6i6q85xwupbq8j R
operacaolote_aud.idlote Implied Constraint R
pedido.idlote fk_culxukvd6mp9s65hjtvm2mcnj R
pedido_aud.idlote Implied Constraint R
pedidoproduto.idlote fk_sie4x00fhrraxhpqo9w1u4grd R
pedidoproduto_aud.idlote Implied Constraint R
codigo varchar 20 √ null
descricao varchar 80 √ null
quantidade numeric 18,6 √ null
idestoque int8 19 null
estoque.idestoque fk_h5u8k5t49d55dxe4dklr51n11 R
percentualminimo numeric 18,6 √ null
percentualmaximo numeric 18,6 √ null
datainicio date 13 √ null
datafim date 13 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
quantidadeoriginal numeric 18,6 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk243b54 Primary key Asc idlote
idxe0f57843 Performance Asc idestoque
idxwsversao_243b54 Performance Desc wsversao
uc9b824586 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.