freteadicional


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idfreteadicional int8 19 null
freteadicional_aud.idfreteadicional Implied Constraint R
percentual numeric 18,6 √ null
valor numeric 18,6 √ null
valormaximo numeric 18,6 √ null
valorminimo numeric 18,6 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idtipofreteadicional int8 19 null
tipofreteadicional.idtipofreteadicional fk_50a07q37cw656uow9m4dg98o4 R
idcidadedestino int8 19 √ null
cidade.idcidade fk_hpx4mwfbxvg88r34cyy9gnx35 R
idunidadefeddestino int8 19 √ null
unidadefederativa.idunidadefederativa fk_mluq9hqyoh3c3rsiymbv220i0 R
idlocalfilial int8 19 √ null
local.idlocal fk_b3r47j713vf2wpw9efo4ys26c R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk755e71cc Primary key Asc idfreteadicional
idxb01e748f Performance Asc idcidadedestino
idxd16ae30b Performance Asc idtipofreteadicional
idxd755ee5 Performance Asc idunidadefeddestino
idxec42079b Performance Asc idlocalfilial
idxwsversao_755e71cc Performance Desc wsversao
uce9a86b2e 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.