localtipologia


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocaltipologia int8 19 null
localtipologia_aud.idlocaltipologia Implied Constraint R
idlocal int8 19 √ null
local.idlocal fk_2h4uil6p9p5vnh423a08ku10g R
idsegmento int8 19 √ null
segmento.idsegmento fk_qqepeod7r5km56aan6hjeowkd R
idtipologia int8 19 √ null
tipologia.idtipologia fk_m9hrukoymqjldahdos18ad5y9 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idnpadrao int2 5 null
idlocalfilial int8 19 √ null
local.idlocal fk_rqolm5mq7rempitpcnv3pu5ha R
idparceiro int8 19 √ null
parceiro.idparceiro fk_pui8ix66evm7yd1mbwm117r91 R
idusuario int8 19 √ null
usuario.idusuario fk_12j9va43tsaeq8fp6xrmvaic3 R

Table contained 1 rows

Indexes

Constraint Name Type Sort Column(s)
pk1617b19d Primary key Asc idlocaltipologia
idx2e32d734 Performance Asc idsegmento
idx4cbd88b8 Performance Asc idtipologia
idx7bef20ea Performance Asc idlocal
idx832f2049 Performance Asc idusuario
idx864fa50c Performance Asc idparceiro
idxf9630c87 Performance Asc idlocalfilial
idxwsversao_1617b19d Performance Desc wsversao
ucf83f26fd 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.