operacaofrete


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idoperacaofrete int8 19 null
operacaofrete_aud.idoperacaofrete Implied Constraint R
valor numeric 18,6 √ null
valormaximo numeric 18,6 √ null
valorminimo numeric 18,6 √ null
percentualbasecalculo numeric 18,6 √ null
datainiciovigencia date 13 √ null
datafimvigencia date 13 √ null
idfrete int8 19 √ null
frete.idfrete fk_2p6pm32fwte2n56h7tjg0y24h R
idoperacao int8 19 null
operacao.idoperacao fk_h0nq2geq1f10shgdk96q1abhe R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
kmfinal numeric 18,6 √ null
kminicial numeric 18,6 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pka5ced4ac Primary key Asc idoperacaofrete
idx6d317b34 Performance Asc idfrete
idx975d7aba Performance Asc idoperacao
idxwsversao_a5ced4ac Performance Desc wsversao
uc11a886b0 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.