catalogopermissao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcatalogopermissao int8 19 null
catalogopermissao_aud.idcatalogopermissao Implied Constraint R
int8 19 null
catalogo.idcatalogo fk_3bj0x47jnnskqk7sx9u6xrgis R
idusuario int8 19 √ null
usuario.idusuario fk_2xjbt9b7m3p09qk8v8yttpsyk R
idparceiro int8 19 √ null
parceiro.idparceiro fk_pvvqlhg1s3d1gnfn7aa5c2j2v R
idgrupoparceiro int8 19 √ null
grupoparceiro.idgrupoparceiro fk_otgnr4nwrp59a16y90nlis5cn R
idgrupousuario int8 19 √ null
grupousuario.idgrupousuario fk_rwi98637rs7314hp9w5nu417x R
idperfilacesso int8 19 √ null
perfilacesso.idperfilacesso fk_fbmxgo0vkyy0a923b99qti04k R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 82 rows

Indexes

Constraint Name Type Sort Column(s)
pk4a16ca91 Primary key Asc idcatalogopermissao
idx132b8f5b Performance Asc idgrupoparceiro
idx37d5fbd6 Performance Asc idperfilacesso
idx6182a549 Performance Asc idcatalogo
idx628badc4 Performance Asc idparceiro
idxae4d60c3 Performance Asc idgrupousuario
idxb8b906af Performance Asc idusuario
idxwsversao_4a16ca91 Performance Desc wsversao
uce780946b 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.