contatopessoatelefone


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcontatopessoatelefone int8 19 null
contatopessoatelefone_aud.idcontatopessoatelefone Implied Constraint R
telefone varchar 40 √ null
observacao varchar 4000 √ null
idnpadrao int2 5 √ null
operadora varchar 20 √ null
idcontatopessoa int8 19 √ null
contatopessoa.idcontatopessoa fk_maoerjaxjg33sbkd9g16q109s R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idtipotelefone int8 19 √ null
tipotelefone.idtipotelefone fk_80kjxbed6r7cq3r68t8lbwtvl R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pkbc30785b Primary key Asc idcontatopessoatelefone
idx49e74abd Performance Asc idtipotelefone
idxc76bbbf Performance Asc idcontatopessoa
idxwsversao_bc30785b Performance Desc wsversao
uce7344ac1 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.