dashboard


Columns

Column Type Size Nulls Auto Default Children Parents Comments
iddashboard int8 19 null
atualizacao.iddashboard fk_8i7itclrvrnen2mej8kcdi5rh R
atualizacao_aud.iddashboard Implied Constraint R
dashboard.iddashboardsuperior fk_5yscihiuk2d3wgtlfs13ainoh R
dashboard_aud.iddashboard Implied Constraint R
dashboardtelainicial.iddashboard fk_nv6ul9h5lwqm2dxh71bjc3kqe R
dashboardtelainicial_aud.iddashboard Implied Constraint R
dashboardview.iddashboard fk_hflah3is8l0bfgvxq3hl84v8u R
dashboardview_aud.iddashboard Implied Constraint R
indicador.iddashboard fk_e03iyxsh1w4wv7xfq2ugpv217 R
indicador_aud.iddashboard Implied Constraint R
sglmodulo varchar 10 √ null
tempoparaatualizacao int8 19 null
tempotrocaslide int8 19 null
quantidadevisoes int8 19 null
dataultimamodificacao date 13 null
idntrocamanual int2 5 null
descricao varchar 80 null
idntelainicial int2 5 null
idnpadrao int2 5 null
idnativo int2 5 null
idnbloqueado int2 5 null
nivel int8 19 null
iddashboardsuperior int8 19 √ null
dashboard.iddashboard fk_5yscihiuk2d3wgtlfs13ainoh R
idninconsistente int2 5 null
icone bytea 2147483647 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
iddashboardviewindicador int8 19 √ null
dashboardviewindicador.iddashboardviewindicador fk_orokamh0v672dqb196o25idb9 R

Table contained 28 rows

Indexes

Constraint Name Type Sort Column(s)
pk38fd0a74 Primary key Asc iddashboard
idx34bfbd39 Performance Asc iddashboardsuperior
idxc6bee343 Performance Asc iddashboardviewindicador
idxwsversao_38fd0a74 Performance Desc wsversao
uce1b07a88 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.