demanda


Columns

Column Type Size Nulls Auto Default Children Parents Comments
iddemanda int8 19 null
camporesposta.iddemanda fk_re7thkyjcp2wgimg4bu1j75au R
camporesposta_aud.iddemanda Implied Constraint R
demanda_aud.iddemanda Implied Constraint R
demandaprodconcorr.iddemanda fk_4w0mjcpkprmukcb78pm2kabrv R
demandaprodconcorr_aud.iddemanda Implied Constraint R
demandaproduto.iddemanda fk_po7xbu2ch8abm3n45lcsyisfw R
demandaproduto_aud.iddemanda Implied Constraint R
demandausuario.iddemanda fk_bnu45af78hrhks5tqeoew5k9p R
demandausuario_aud.iddemanda Implied Constraint R
visita.iddemanda fk_kgka5bruy55hil32525x6y48m R
visita_aud.iddemanda Implied Constraint R
datainicio date 13 null
datacadastro date 13 null
dataalteracao date 13 null
observacao varchar 4000 √ null
nomeparceiro varchar 500 null
localparceiro varchar 500 null
idparceirolocal int8 19 √ null
parceirolocal.idparceirolocal fk_eclns8h8jsme7ebroualcopln R
idsafra int8 19 null
safra.idsafra fk_k0ida8vopl0iltyera8a671is R
idparceiro int8 19 null
parceiro.idparceiro fk_c22eef6wawbbk6amhmkd94ceu R
idcultura int8 19 null
cultura.idcultura fk_2kdpqa77spalk4jegxmn813co R
iddemandatipo int8 19 null
demandatipo.iddemandatipo fk_s85kpikf04oxm63ybm3dv1q20 R
idusuariocriador int8 19 null
usuario.idusuario fk_nsdxel9q0soqa1kt0k2m133vk R
idprofissional int8 19 null
usuario.idusuario fk_fv6d1vbp7bdfc8tuthseev9ab R
idlocal int8 19 null
local.idlocal fk_bc3hymiat6tko8oqk9y502qye R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idculturaanterior int8 19 √ null
cultura.idcultura fk_f5hxxdnwud5t9qq5tca8khl0e R
idnativo int2 5 null

Indexes

Constraint Name Type Sort Column(s)
pkbfaef756 Primary key Asc iddemanda
idx36a57fb9 Performance Asc idcultura
idx6242706 Performance Asc idculturaanterior
idx711245b1 Performance Asc idlocal
idx85ad7253 Performance Asc iddemandatipo
idx8694954f Performance Asc idparceiro
idxa0e32447 Performance Asc idparceirolocal
idxb352de0f Performance Asc idsafra
idxcba79140 Performance Asc idusuariocriador
idxea4ef255 Performance Asc idprofissional
idxwsversao_bfaef756 Performance Desc wsversao
uc9048926 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation