wssynclog_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
idnatualizouversao int2 5 √ null
idnfinalizado int2 5 √ null
idndeviceregistrado int2 5 √ null
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 19,2 √ null
bytesrecebidos numeric 19,2 √ null
taxatransferenciainicial numeric 19,2 √ null
taxatransferenciafinal numeric 19,2 √ 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
caminhologtransacao varchar 255 √ null
arquivosrestantes varchar 4000 √ null
iddvid int8 19 √ null
idusuario int8 19 √ null
usuario.idusuario Implied Constraint R
idwssynclog int8 19 √ null
wssynclog.idwssynclog Implied Constraint R
rev int8 19 √ null
revtype int8 19 √ null
idnimagensemidias int2 5 √ null
idnutilizassl int2 5 √ null
percentualbateria int8 19 √ null
tamanhodats int8 19 √ null
tipoconexao varchar 20 √ null
iddispositivo int8 19 √ null
dispositivo.iddispositivo Implied Constraint R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk9948235e Primary key Asc id

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.