contatopessoaemail


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcontatopessoaemail int8 19 null
contatopessoaemail_aud.idcontatopessoaemail Implied Constraint R
pesquisausuarioemail.idcontatopessoaemail fk_ogvxas4danjwn81tjg2jr7jut R
pesquisausuarioemail_aud.idcontatopessoaemail Implied Constraint R
email varchar 80 √ null
observacao varchar 4000 √ null
idnpadrao int2 5 √ null
idcontatopessoa int8 19 √ null
contatopessoa.idcontatopessoa fk_ipsktofd0at834g3ub97m7uba R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 1 rows

Indexes

Constraint Name Type Sort Column(s)
pkd50d9bcb Primary key Asc idcontatopessoaemail
idx4b29e14b Performance Asc idcontatopessoa
idxwsversao_d50d9bcb Performance Desc wsversao
uc5b8bfbef 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.