dashboardviewpermissao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
iddashboardviewpermissao int8 19 null
dashboardviewpermissao_aud.iddashboardviewpermissao Implied Constraint R
iddashboardview int8 19 null
dashboardview.iddashboardview fk_7erqy23e9uhnjn5wr6m53c37v R
idgrupousuario int8 19 √ null
grupousuario.idgrupousuario fk_betauh87094nki8ntabep14ok R
idusuario int8 19 √ null
usuario.idusuario fk_mihstr22lpqbx3734nx4sws2a R
idperfilacesso int8 19 √ null
perfilacesso.idperfilacesso fk_osl1j1nkq1t0485qr0n4orbd2 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 35 rows

Indexes

Constraint Name Type Sort Column(s)
pk407f5a4e Primary key Asc iddashboardviewpermissao
idx2b7d4e1c Performance Asc iddashboardview
idx380990e6 Performance Asc idperfilacesso
idx8d8c588c Performance Asc idgrupousuario
idxb7cbecdd Performance Asc idusuario
idxwsversao_407f5a4e Performance Desc wsversao
uccb25facc 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.