itemconfiguracao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
iditemconfiguracao int8 19 null
chamadoitconfiguracao.iditemconfiguracao fk_earlk897wepaq6njl8httm20g R
chamadoitconfiguracao_aud.iditemconfiguracao Implied Constraint R
itemconfiguracao_aud.iditemconfiguracao Implied Constraint R
itemconfvincitemconf.iditemconfiguracao fk_7ytbrirfgr3sgk0keefrvr727 R
itemconfvincitemconf.iditemconfvinculado fk_mjw9hafb3l8oh36j6oilmhl2x R
itemconfvincitemconf_aud.iditemconfiguracao Implied Constraint R
descricao varchar 80 null
idtipoitemconfiguracao int8 19 null
tipoitemconfiguracao.idtipoitemconfiguracao fk_76eltylcucpcej3u37cjevc85 R
idparceiro int8 19 √ null
parceiro.idparceiro fk_qtib8anilq0n445ypi6b3p5el R
idusuario int8 19 √ null
usuario.idusuario fk_ielwcoi11kyiguvjfnyeubo88 R
datahoracadastro timestamp 29,6 null
idnativo int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk3e1a882 Primary key Asc iditemconfiguracao
idx463ab9a0 Performance Asc idtipoitemconfiguracao
idx684ad3b9 Performance Asc idparceiro
idx97e5e40d Performance Asc idusuario
idxwsversao_3e1a882 Performance Desc wsversao
uc9f7f5cb8 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation