ofertavinculo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idofertavinculo int8 19 null
ofertavinculo_aud.idofertavinculo Implied Constraint R
idusuario int8 19 √ null
usuario.idusuario fk_9grhi3xlopqy6uc7kw9lbgysi R
idlocal int8 19 √ null
local.idlocal fk_hlvrd66vf8hcdgo33wv26okiu R
idparceiro int8 19 √ null
parceiro.idparceiro fk_qmphr7jy7y73a1pextreltrp4 R
idlocalfilial int8 19 √ null
local.idlocal fk_gky25xjxfhwpk2jiej0ahir2e R
idgrupoparceiro int8 19 √ null
grupoparceiro.idgrupoparceiro fk_syogfnkyvjx76va67xntledox R
idtipopedido int8 19 √ null
tipopedido.idtipopedido fk_e0mb4krja3u3eicubtdd97dep R
idoferta int8 19 null
oferta.idoferta fk_cjt5qb6jj08e16t0qc4174jhi R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idnexportadoerp int2 5 null

Indexes

Constraint Name Type Sort Column(s)
pk3c3bb87f Primary key Asc idofertavinculo
idx2bc04be5 Performance Asc idlocalfilial
idx3d5a7873 Performance Asc idusuario
idx63b3de70 Performance Asc idtipopedido
idx982fe95e Performance Asc idlocal
idxa4127397 Performance Asc idgrupoparceiro
idxf7894a3a Performance Asc idparceiro
idxfac84164 Performance Asc idoferta
idxwsversao_3c3bb87f Performance Desc wsversao
uc805039bd Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation