catalogo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
int8 19 null
catalogo_aud.idcatalogo Implied Constraint R
catalogogrupousuario.idcatalogo fk_c271f2m0l7nli7rx5ou91bnnx R
catalogogrupousuario_aud.idcatalogo Implied Constraint R
catalogoparceiro.idcatalogo fk_mg90nogj6rl7x3yccy84dmq0q R
catalogoparceiro_aud.idcatalogo Implied Constraint R
catalogopermissao.idcatalogo fk_3bj0x47jnnskqk7sx9u6xrgis R
catalogopermissao_aud.idcatalogo Implied Constraint R
catalogousuario.idcatalogo fk_1ymonr20rjt2l41vv6c6c0qep R
catalogousuario_aud.idcatalogo Implied Constraint R
conjuntocatalogo.idcatalogo fk_r68wrfguxf774lywp0b10ekqb R
conjuntocatalogo_aud.idcatalogo Implied Constraint R
formatacao.idcatalogo fk_p1mbfius2fs1kr81xbc434df0 R
formatacao_aud.idcatalogo Implied Constraint R
produtocatalogo.idcatalogo fk_pvw6cdj2hqjqy23xd7fpp0bdm R
produtocatalogo_aud.idcatalogo Implied Constraint R
codigo varchar 20 √ null
titulo varchar 80 √ null
descricao varchar 4000 √ null
datainicio date 13 √ null
datafim date 13 √ null
capa bytea 2147483647 √ null
idimagemminiatura int8 19 √ null
imagemminiatura.idimagemminiatura fk_jvgio8sa3h8p5va3omepleuwo R
linkvideo varchar 4000 √ null
codigoerp varchar 80 √ null
idnativo int2 5 null
wsversao int8 19 √ null

Table contained 1 rows

Indexes

Constraint Name Type Sort Column(s)
pk6a70796 Primary key Asc idcatalogo
idx98ac49ac Performance Asc idimagemminiatura
idxwsversao_6a70796 Performance Desc wsversao
ucb3c30d04 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.