email_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
assunto varchar 400 √ null
emailremetente varchar 80 √ null
nomeremetente varchar 80 √ null
destinatario varchar 4000 √ null
comcopia varchar 4000 √ null
comcopiaoculta varchar 4000 √ null
texto bytea 2147483647 √ null
idemail int8 19 √ null
email.idemail Implied Constraint R
rev int8 19 √ null
revtype int8 19 √ null
dataenvio date 13 √ null
idpesquisa int8 19 √ null
pesquisa.idpesquisa Implied Constraint R
codigoerp varchar 80 √ null
datacadastro date 13 √ null
horacadastro varchar 8 √ null
horaenvio varchar 8 √ null
idconfiguracaoenvio int8 19 √ null
configuracaoenvio.idconfiguracaoenvio Implied Constraint R
idoportunidade int8 19 √ null
oportunidade.idoportunidade Implied Constraint R
wsversao int8 19 √ null
idnrecorrencia int2 5 √ null
idpedido int8 19 √ null
pedido.idpedido Implied Constraint R
idncopiausuario int2 5 √ null
idnexibeobsped int2 5 √ null
idnsubstemplate int2 5 √ null
idpesquisaresultado int8 19 √ null
pesquisaresultado.idpesquisaresultado Implied Constraint R
idpedidoaprovacao int8 19 √ null
pedidoaprovacao.idpedidoaprovacao Implied Constraint R
iddesconto int8 19 √ null
desconto.iddesconto Implied Constraint R
iddescontoaprovacao int8 19 √ null
descontoaprovacao.iddescontoaprovacao Implied Constraint R
tentativaenvio int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pkf5d96f4d Primary key Asc id
idxwsversao_f5d96f4d Performance Desc wsversao

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.