visita


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idvisita int8 19 null
visita_aud.idvisita Implied Constraint R
visitacampo.idvisita fk_7cfwxcdvp8g4v3a7u6qb73k7p R
visitacampo_aud.idvisita Implied Constraint R
visitacmpd.idvisita fk_quskbb7ms8t61kf25tr3jiiia R
visitacmpd_aud.idvisita Implied Constraint R
visitaimagem.idvisita fk_j2schw0wixhmog8spc43dbo9 R
visitaimagem_aud.idvisita Implied Constraint R
visitaprod.idvisita fk_lppkumvvon71vmynb63b51ob5 R
visitaprod_aud.idvisita Implied Constraint R
visitaprodconcorr.idvisita fk_fcklrcokpbdxta9xh1advg506 R
visitaprodconcorr_aud.idvisita Implied Constraint R
visitaresposta.idvisita fk_r5n6ylh648xr0yiowh91o50qf R
visitaresposta_aud.idvisita Implied Constraint R
dataprevista date 13 null
datarealizada date 13 √ null
datacadastro date 13 null
dataalteracao date 13 null
idnobrigatorio int2 5 null
idnadicional int2 5 null
dias numeric 18 √ null
nomeparceiro varchar 500 √ null
localparceiro varchar 500 √ null
idparceirolocal int8 19 √ null
parceirolocal.idparceirolocal fk_3baep6gwvtn4awpbt5tw9otlt R
idvisitasituacao int8 19 null
visitasituacao.idvisitasituacao fk_7rjbdfr4qph2har5ryi6rbme8 R
idvisitatipo int8 19 null
visitatipo.idvisitatipo fk_b0760rdqpv7qudkybg2lxli34 R
identidade int8 19 √ null
entidade.identidade fk_srpdh7oxeg7exklmxcfqhp2dq R
iddemanda int8 19 √ null
demanda.iddemanda fk_kgka5bruy55hil32525x6y48m R
idparceiro int8 19 √ null
parceiro.idparceiro fk_ft1oxhxhp4x91bigt8j78i7lb R
idlocal int8 19 √ null
local.idlocal fk_16jbilcptgyg3sguqr4tbojft R
idagenda int8 19 √ null
agenda.idagenda fk_57ixb4u0yg9bjb9hkymjgu0u2 R
idusuariocriador int8 19 null
usuario.idusuario fk_r0ak5x8459baaqq63k92uewhj R
idprofissional int8 19 null
usuario.idusuario fk_pyw3cu9an6m1pa2883axk22gg R
idvisitaconfig int8 19 null
visitaconfig.idvisitaconfig fk_bf1egauupyb6s38gvjt7jdyp9 R
idsafra int8 19 null
safra.idsafra fk_3njsg9xhutvbijbmfuc6siflk R
idcultura int8 19 null
cultura.idcultura fk_t4l7obm11ilk31l5er9vxr1q3 R
latitude numeric 18,6 √ null
longitude numeric 18,6 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idnavulso int2 5 √ null
idnexibir int2 5 √ null
idnmultiplosprodutos int2 5 null
idnexibirrelatorio int2 5 null

Indexes

Constraint Name Type Sort Column(s)
pk98be4896 Primary key Asc idvisita
idx1444811d Performance Asc idprofissional
idx5b3d425c Performance Asc idvisitaconfig
idx60ef0e76 Performance Asc idsafra
idx7b2afe79 Performance Asc idvisitaconfig
idx8176eef8 Performance Asc identidade
idxa513039 Performance Asc iddemanda
idxa5e57cb1 Performance Asc idparceiro
idxb2ded686 Performance Asc idvisitasituacao
idxb8ecf904 Performance Asc idvisitatipo
idxc4397773 Performance Asc idparceirolocal
idxd324121e Performance Asc idagenda
idxd9760c94 Performance Asc idlocal
idxe79d06bf Performance Asc idusuariocriador
idxf042a615 Performance Asc idcultura
idxwsversao_98be4896 Performance Desc wsversao
uc612267c4 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation