operacaolote


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idoperacaolote int8 19 null
operacaolote_aud.idoperacaolote Implied Constraint R
idlote int8 19 null
lote.idlote fk_loiebkkfjbr6i6q85xwupbq8j R
idoperacao int8 19 null
operacao.idoperacao fk_cp2g5w820id0cdmjtjgi7as3i R
valor numeric 18,6 √ null
valorminimo numeric 18,6 √ null
valormaximo numeric 18,6 √ null
datainiciovigencia date 13 √ null
datafimvigencia date 13 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk6874b792 Primary key Asc idoperacaolote
idx96e134a3 Performance Asc idlote
idxd2584cc Performance Asc idoperacao
idxwsversao_6874b792 Performance Desc wsversao
uce761cf28 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.