dispositivo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
iddispositivo int8 19 null
dispositivo_aud.iddispositivo Implied Constraint R
pontogps.iddispositivo fk_6sd07kqi7s82rsdok8wlbdlnd R
pontogps_aud.iddispositivo Implied Constraint R
usuariodispositivo.iddispositivo fk_5b919uhia1irp3ldi3u7y8sef R
usuariodispositivo_aud.iddispositivo Implied Constraint R
wssynclog.iddispositivo fk_74easqtdpgtuilgurkios57ee R
wssynclog_aud.iddispositivo Implied Constraint R
descricao varchar 80 √ null
marca varchar 80 √ null
modelo varchar 80 √ null
identificador varchar 80 null
sistemaoperacional varchar 80 √ null
versaoso varchar 80 √ null
idnbloqueiopermanente int2 5 null
numero varchar 80 √ null
idnativo int2 5 null
idveiculo int8 19 √ null
veiculo.idveiculo fk_1tedjkcfuu34tfbbt4a1ekup6 R
idusuario int8 19 √ null
usuario.idusuario fk_6dq54x4ahcno77pgobfqc0fvt R
ultimatransmissao timestamp 29,6 √ null
observacao varchar 4000 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 22 rows

Indexes

Constraint Name Type Sort Column(s)
pk862f5871 Primary key Asc iddispositivo
idx6b80b469 Performance Asc idusuario
idx98895432 Performance Asc idveiculo
idxwsversao_862f5871 Performance Desc wsversao
uc1d87236b 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.