usuariodispositivo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idusuariodispositivo int8 19 null
usuariodispositivo_aud.idusuariodispositivo Implied Constraint R
idlicencausuario int8 19 null
licencausuario.idlicencausuario fk_a3ovgi8m5yxvp273pbkbxdm2q R
iddispositivo int8 19 null
dispositivo.iddispositivo fk_5b919uhia1irp3ldi3u7y8sef R
idnprincipal int2 5 null
idnpermitiracesso int2 5 null
dataativacao timestamp 29,6 √ null
datadesativacao timestamp 29,6 √ null
observacao varchar 4000 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pke943f8a3 Primary key Asc idusuariodispositivo
idx7fc6ead Performance Asc idlicencausuario
idxa69012f9 Performance Asc iddispositivo
idxwsversao_e943f8a3 Performance Desc wsversao
uc470fa37 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.