usuariopesquisa


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idusuariopesquisa int8 19 null
usuariopesquisa_aud.idusuariopesquisa Implied Constraint R
idpesquisa int8 19 null
pesquisa.idpesquisa fk_fv9dsdexxqpkuugygvnajg6gs R
idusuario int8 19 √ null
usuario.idusuario fk_htqo9lguarh04dwmy9es6mw9o R
idgrupousuario int8 19 √ null
grupousuario.idgrupousuario fk_onohsvto7o65jctfliklrannm R
idperfilacesso int8 19 √ null
perfilacesso.idperfilacesso fk_8px72wlx0unaxnidc34pmnyby R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 8 rows

Indexes

Constraint Name Type Sort Column(s)
pk22307aa3 Primary key Asc idusuariopesquisa
idx92a2e3a4 Performance Asc idpesquisa
idxc6a21578 Performance Asc idperfilacesso
idxcfac9fc4 Performance Asc idusuario
idxfec1a16e Performance Asc idgrupousuario
idxwsversao_22307aa3 Performance Desc wsversao
uc663eaa19 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.