mensagemdestinatario


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idmensagemdestinatario int8 19 null
mensagemdestinatario_aud.idmensagemdestinatario Implied Constraint R
idnlida int2 5 null
idnlidasms int2 5 √ null
dataleitura date 13 √ null
horaleitura varchar 8 √ null
idmensagem int8 19 null
mensagem.idmensagem fk_py4usuqvex406qoorjpkwwyl0 R
idusuariodestinatario int8 19 null
usuario.idusuario fk_ke959i8q1e0xse2gcu3vacjmo R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 25 rows

Indexes

Constraint Name Type Sort Column(s)
pk84850bbc Primary key Asc idmensagemdestinatario
idx1244415 Performance Asc idmensagem
idxcda38599 Performance Asc idusuariodestinatario
idxwsversao_84850bbc Performance Desc wsversao
uccfbde03e 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.