localreferencia


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocalreferencia int8 19 null
localreferencia_aud.idlocalreferencia Implied Constraint R
descricao varchar 80 √ null
observacao varchar 4000 √ null
idnativo int2 5 null
idlocal int8 19 √ null
local.idlocal fk_i82q2ofb30lo4rn67dui83nyd R
idparceiro int8 19 √ null
parceiro.idparceiro fk_oqeuhhu557cwj6s0fx59y2j3o R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idnexportadoerp int2 5 null
observacaointegracao varchar 4000 √ null
telefone varchar 40 √ null
email varchar 80 √ null
idtiporeferencia int8 19 √ null
tiporeferencia.idtiporeferencia fk_ipolv42p5g3hdh1q5nr3hmdxa R
ordem int8 19 √ null
responsavel varchar 80 √ null

Indexes

Constraint Name Type Sort Column(s)
pk5d23149d Primary key Asc idlocalreferencia
idx89d855f6 Performance Asc idlocal
idxa504ffcc Performance Asc idparceiro
idxbc0f5e29 Performance Asc idtiporeferencia
idxwsversao_5d23149d Performance Desc wsversao
ucd7b80e5f Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation