localtelefone


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocaltelefone int8 19 null
localtelefone_aud.idlocaltelefone Implied Constraint R
telefone varchar 40 √ null
observacao varchar 4000 √ null
idnpadrao int2 5 null
operadora varchar 20 √ null
idlocal int8 19 √ null
local.idlocal fk_bc8mn74hs69ohrw8u7g5yp6e1 R
idparceiro int8 19 √ null
parceiro.idparceiro fk_q3ynh889k88reyugocpymrca R
idtipotelefone int8 19 √ null
tipotelefone.idtipotelefone fk_2f9m1618g2yyc985m2yjp4f2n R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idnexportadoerp int2 5 null
observacaointegracao varchar 4000 √ null

Table contained 11191 rows

Indexes

Constraint Name Type Sort Column(s)
pk88d34355 Primary key Asc idlocaltelefone
idx2d33666a Performance Asc idlocal
idxdfc5c30f Performance Asc idparceiro
idxf970e7dc Performance Asc idtipotelefone
idxwsversao_88d34355 Performance Desc wsversao
uc9e135ee7 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.