wssynclog


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idwssynclog int8 19 null
wssynclog_aud.idwssynclog Implied Constraint R
idnatualizouversao int2 5 null
idnfinalizado int2 5 null
idndeviceregistrado int2 5 null
iddvid int8 19 √ null
wsdvid.idwsdvid fk_g3287qovqkp56k6b770wdr4mb R
inicioconexao timestamp 29,6 √ null
fimconexao timestamp 29,6 √ null
inicioatualizacaoversao timestamp 29,6 √ null
fimatualizacaoversao timestamp 29,6 √ null
inicioenvio timestamp 29,6 √ null
fimenvio timestamp 29,6 √ null
inicioprocessamento timestamp 29,6 √ null
fimprocessamento timestamp 29,6 √ null
iniciorecebimento timestamp 29,6 √ null
fimrecebimento timestamp 29,6 √ null
versaoatual varchar 200 √ null
bytesenviados numeric 18,6 √ null
bytesrecebidos numeric 18,6 √ null
taxatransferenciainicial numeric 18,6 √ null
taxatransferenciafinal numeric 18,6 √ null
observacao varchar 4000 √ null
caminholog varchar 255 √ null
iporigem varchar 80 √ null
serial varchar 255 √ null
ipservidor varchar 80 √ null
portaservidor int8 19 √ null
iniciodescompactacao timestamp 29,6 √ null
fimdescompactacao timestamp 29,6 √ null
idusuario int8 19 √ null
usuario.idusuario fk_povn892h13u7tlq7qbnemswkd R
caminhologtransacao varchar 255 √ null
arquivosrestantes varchar 4000 √ null
percentualbateria int8 19 √ null
tipoconexao varchar 20 √ null
idnutilizassl int2 5 √ null
tamanhodats int8 19 √ null
idnimagensemidias int2 5 null
iddispositivo int8 19 √ null
dispositivo.iddispositivo fk_74easqtdpgtuilgurkios57ee R

Table contained 550 rows

Indexes

Constraint Name Type Sort Column(s)
pk8c4c00d Primary key Asc idwssynclog
idx8fbeb4ec Performance Asc iddispositivo
idxaec88627 Performance Asc iddvid
idxec294c18 Performance Asc idusuario

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.