planpermacesso


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idplanpermacesso int8 19 null
planpermacesso_aud.idplanpermacesso Implied Constraint R
idplanejamento int8 19 null
planejamento.idplanejamento fk_djp40rxqc9almdghlbv7kmirt R
idperfilacesso int8 19 √ null
perfilacesso.idperfilacesso fk_qqoupxeq2pfkvp2gatla0pa4s R
idgrupousuario int8 19 √ null
grupousuario.idgrupousuario fk_r0k12fsk2mbf2i393ymfqsful R
idusuario int8 19 √ null
usuario.idusuario fk_quq2t0ny9kvkowijyn0x508lo R
datacadastro date 13 null
idnleitura int2 5 √ null
idneditar int2 5 √ null
idnaddexcluir int2 5 √ null
idnconsiderarvinculos int2 5 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 8 rows

Indexes

Constraint Name Type Sort Column(s)
pk2bf851e5 Primary key Asc idplanpermacesso
idx1b7de292 Performance Asc idperfilacesso
idx53fabbda Performance Asc idplanejamento
idx5a253636 Performance Asc idgrupousuario
idxcdfb1013 Performance Asc idusuario
idxwsversao_2bf851e5 Performance Desc wsversao
ucbd8b4815 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.