tipoitemconfiguracao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idtipoitemconfiguracao int8 19 null
itemconfiguracao.idtipoitemconfiguracao fk_76eltylcucpcej3u37cjevc85 R
itemconfiguracao_aud.idtipoitemconfiguracao Implied Constraint R
tipoitemconfiguracao.idtipoitemconfsuperior fk_br5t3dgefdftnrdjustka1jde R
tipoitemconfiguracao_aud.idtipoitemconfiguracao Implied Constraint R
usuariotipoitemconfig.idtipoitemconfiguracao fk_8fc6i2rasstkhpbo74d3kaww8 R
usuariotipoitemconfig_aud.idtipoitemconfiguracao Implied Constraint R
descricao varchar 80 null
idtipoitemconfsuperior int8 19 √ null
tipoitemconfiguracao.idtipoitemconfiguracao fk_br5t3dgefdftnrdjustka1jde R
sgltipoitemconfiguracao varchar 10 √ null
idnativo int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk595847d6 Primary key Asc idtipoitemconfiguracao
idx83e85558 Performance Asc idtipoitemconfsuperior
idxwsversao_595847d6 Performance Desc wsversao
ucbf8f2e84 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.