tipofrete


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idtipofrete int8 19 null
desconto.idtipofrete fk_vlnmres570qyx2jdfs4uc8jw R
desconto_aud.idtipofrete Implied Constraint R
frete.idtipofrete fk_r5vpxr7hxdde31vad4onhdk32 R
frete_aud.idtipofrete Implied Constraint R
localtabelapreco.iduftipofrete fk_rsj1ssgsfjs0e57u9ymntkm4g R
localtipofrete.idtipofrete fk_r35xau4ytxpwt1la63qcopxbk R
localtipofrete_aud.idtipofrete Implied Constraint R
pedidoentrega.idtipofrete fk_oib05krgedc44yy828ce98mjk R
pedidoentrega_aud.idtipofrete Implied Constraint R
tabelapreco.idtipofrete fk_qe7go7i4tlxjdehnffe22ll86 R
tabelapreco_aud.idtipofrete Implied Constraint R
tabelaprecoproduto.idtipofrete fk_pfv8s6o5b045vo1d9cs4si02a R
tabelaprecoproduto_aud.idtipofrete Implied Constraint R
tabelaprecoproduto_bkp.idtipofrete Implied Constraint R
tipofrete_aud.idtipofrete Implied Constraint R
valorminimopedido.idtipofrete fk_jcvio4c3bv387jlrbulv38so R
valorminimopedido_aud.idtipofrete Implied Constraint R
valorminimopedidoconfig.idtipofrete fk_4kxwf4cf51iheb58akpoo0wla R
valorminimopedidoconfig_aud.idtipofrete Implied Constraint R
descricao varchar 80 null
sgltipofrete varchar 10 √ null
idnativo int2 5 null
idnpadrao int2 5 null
idnsomarfrete int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
percentual numeric 18,6 √ null

Table contained 6 rows

Indexes

Constraint Name Type Sort Column(s)
pk28037656 Primary key Asc idtipofrete
idxwsversao_28037656 Performance Desc wsversao
ucb7b831c6 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.