localreferepagamento


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocalreferepagamento int8 19 null
localreferepagamento_aud.idlocalreferepagamento Implied Constraint R
idreferenciapagamento int8 19 √ null
referenciapagamento.idreferenciapagamento fk_sivbceci528sg76nrdt11qf4g R
idsegmento int8 19 √ null
segmento.idsegmento fk_9fil7kshia36j7n1r7lwdk3ch R
idlocal int8 19 √ null
local.idlocal fk_xdpotbb9w9mwkdf8yvd4a92e R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idparceiro int8 19 √ null
parceiro.idparceiro fk_qv2llypx6apm1o19kj78ptd84 R

Indexes

Constraint Name Type Sort Column(s)
pkfa2e09f6 Primary key Asc idlocalreferepagamento
idx96a51d40 Performance Asc idparceiro
idxccf7d239 Performance Asc idlocal
idxd6ec6f43 Performance Asc idsegmento
idxf5ea55e6 Performance Asc idreferenciapagamento
idxwsversao_fa2e09f6 Performance Desc wsversao
uc6a2fefe4 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation