parceiropositivacao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idparceiropositivacao int8 19 null
parceiropositivacao_aud.idparceiropositivacao Implied Constraint R
idparceiro int8 19 null
parceiro.idparceiro fk_3sgk4eryv360bcchebccpgyam R
idlocal int8 19 √ null
local.idlocal fk_b0b12b3wwqjwjmtvhnoaeftuh R
idpedido int8 19 √ null
pedido.idpedido fk_44yve4j5l8x1a7c5pyiavrau R
idnotafiscal int8 19 √ null
notafiscal.idnotafiscal fk_7493en0inedffxkjnmh9utv27 R
idatendimento int8 19 √ null
atendimento.idatendimento fk_8h5ig2li1429mve2f5afumbge R
idusuario int8 19 √ null
usuario.idusuario fk_kesm78as7gpomdxgo3nj3wcsq R
dataultimopedido date 13 √ null
dataultimanotafiscal date 13 √ null
dataultimoatendimento date 13 √ null
idnpositivado int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pke71068d9 Primary key Asc idparceiropositivacao
idx505ba97e Performance Asc idparceiro
idx866c714f Performance Asc idnotafiscal
idx9e92efa7 Performance Asc idusuario
idxa6d3a9b7 Performance Asc idlocal
idxc28d318f Performance Asc idpedido
idxd72d6f4e Performance Asc idatendimento
idxwsversao_e71068d9 Performance Desc wsversao
ucf576c6e3 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation