parceirotransportador


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idparceirotransportador int8 19 null
parceirotransportador_aud.idparceirotransportador Implied Constraint R
pedidoentrega_aud.idparceirotransportador Implied Constraint R
idparceiro int8 19 null
parceiro.idparceiro fk_2ai1cv4lkaiqhw37qpl2swl9y R
idtransportador int8 19 null
parceiro.idparceiro fk_dhens82l24xxnkshlbg72lyd R
idnpadrao int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idlocalfilial int8 19 √ null
local.idlocal fk_7w6tigh8lkmuumklqk31ps1mw R
idsegmento int8 19 √ null
segmento.idsegmento fk_excbu4at03vpbba6t4yss3mio R
idusuario int8 19 √ null
usuario.idusuario fk_mfbg994o1mnelsoppppsobfn5 R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk719f47cc Primary key Asc idparceirotransportador
idx124c8c85 Performance Asc idtransportador
idx14729796 Performance Asc idparceiro
idx2cc79909 Performance Asc idsegmento
idx8461b0da Performance Asc idlocalfilial
idxe5f87069 Performance Asc idusuario
idxwsversao_719f47cc Performance Desc wsversao
uc7b5d7690 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.