conversasituacao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idconversasituacao int8 19 null
conversasituacao_aud.idconversasituacao Implied Constraint R
idconversa int8 19 null
conversa.idconversa fk_5senyx2a3yhwjtogy3cbk31si R
idconversamensagem int8 19 √ null
conversamensagem.idconversamensagem fk_7qa9y4kiwbtw40vc66d6t68lt R
idusuariogerador int8 19 null
usuario.idusuario fk_m6ar4c2t31wt7ak72yg936tlt R
idusuariodestinatario int8 19 √ null
usuario.idusuario fk_1nr09jqy6y8mccwessb0xh7xf R
datavizualizacao int8 19 √ null
idnvizualizado int2 5 null
idnnotificado int2 5 null
idnativo int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 30 rows

Indexes

Constraint Name Type Sort Column(s)
pk6bdbd5d6 Primary key Asc idconversasituacao
idx2083a7aa Performance Asc idusuariogerador
idx56ed7fe0 Performance Asc idconversa
idx66f771f0 Performance Asc idconversamensagem
idxb5730b93 Performance Asc idusuariodestinatario
idxwsversao_6bdbd5d6 Performance Desc wsversao
uca41187e4 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.