localtipocobranca


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocaltipocobranca int8 19 null
localtipocobranca_aud.idlocaltipocobranca Implied Constraint R
idlocal int8 19 √ null
local.idlocal fk_p7k5h262ymdx7m94x7rkv67xv R
idlocalfilial int8 19 √ null
local.idlocal fk_nxlas2ijp4a03wehv28r9fe22 R
idtipocobranca int8 19 null
tipocobranca.idtipocobranca fk_fd3ycdb9qovyom2s7qfpdstg8 R
idusuario int8 19 √ null
usuario.idusuario fk_8rtg695q3uyam10ol02ud6tui R
idsegmento int8 19 √ null
segmento.idsegmento fk_2st97lo9nre7axph2c3rmts3p R
idnpadrao int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idparceiro int8 19 √ null
parceiro.idparceiro fk_dy1we11ki8y1qoy4ctrapj1pj R

Table contained 7 rows

Indexes

Constraint Name Type Sort Column(s)
pk442e1f46 Primary key Asc idlocaltipocobranca
idx31763a15 Performance Asc idsegmento
idx4d8a1efc Performance Asc idtipocobranca
idx53dfc76 Performance Asc idparceiro
idx724dedc Performance Asc idusuario
idxbb666fef Performance Asc idlocalfilial
idxd87a15b3 Performance Asc idlocal
idxwsversao_442e1f46 Performance Desc wsversao
ucb324a36 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.