lead


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlead int8 19 null
camporesposta.idlead fk_3tqjvvabfog6l29tlxk1i28h R
camporesposta_aud.idlead Implied Constraint R
lead_aud.idlead Implied Constraint R
leadanexo.idlead fk_fydrshq4ucddbfftu1gw6q4bs R
leadanexo_aud.idlead Implied Constraint R
leadetapahistorico.idlead fk_eeyv6nd2l6mujt1a5ivp7vj8u R
leadetapahistorico_aud.idlead Implied Constraint R
leadhistorico.idlead fk_n0rny1h1a8ljdxt2nsx3ak9qk R
leadhistorico_aud.idlead Implied Constraint R
oportunidade.idlead fk_cwe65bdui2glbitgan1ekkb5l R
oportunidade_aud.idlead Implied Constraint R
parceiro.idlead fk_29rin0mv7ofhto1otkmq1yqyl R
parceiro_aud.idlead Implied Constraint R
nome varchar 80 √ null
descricao varchar 4000 √ null
nomefantasia varchar 80 √ null
razaosocial varchar 80 √ null
contato varchar 80 √ null
telefone varchar 80 √ null
site varchar 80 √ null
email varchar 80 √ null
logradouro varchar 80 √ null
idpais int8 19 √ null
pais.idpais fk_nqwch2ny1vl7k5f82so0xncde R
idunidadefederativa int8 19 √ null
unidadefederativa.idunidadefederativa fk_d85ccm6j8ixhat0grwebj3drt R
idcidade int8 19 √ null
cidade.idcidade fk_m9ae9ayl49hxpj8p3s2n03owb R
numero varchar 45 √ null
responsavelcomercial varchar 80 √ null
nomelogotipo varchar 80 √ null
arquivologotipo bytea 2147483647 √ null
datacadastro date 13 null
horacadastro varchar 8 null
idleadetapa int8 19 √ null
leadetapa.idleadetapa fk_nwqu95nhk0beknd19us68ohbm R
idusuario int8 19 null
usuario.idusuario fk_9e79jdphjr7gmpu8s08hf8cq9 R
idusuarioresponsavel int8 19 √ null
usuario.idusuario fk_rk0k0nfm4rsaqxspx43ii1hvu R
idnpessoafisica int2 5 null
idnativo int2 5 null
idnexportadoerp int2 5 null
idparceiro int8 19 √ null
parceiro.idparceiro Implied Constraint R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
cnpj varchar 14 √ null
dataanonimizacao date 13 √ null
documentoidentificacao varchar 80 √ null
horaanonimizacao varchar 8 √ null
idtipoidentificacao int8 19 √ null
tipoidentificacao.idtipoidentificacao fk_qgjdxfk3xlym28ligva44lnue R
idusuarioanonimizacao int8 19 √ null
usuario.idusuario fk_5t8isf7wnjnol55vaofifr4nv R

Indexes

Constraint Name Type Sort Column(s)
pk24137c Primary key Asc idlead
idx10f3c63b Performance Asc idusuarioanonimizacao
idx506f4fc2 Performance Asc idpais
idx69fd9614 Performance Asc idusuario
idx7be5624a Performance Asc idusuarioresponsavel
idx7c735259 Performance Asc idtipoidentificacao
idx8c6cb148 Performance Asc idleadetapa
idxb5cd33f6 Performance Asc idunidadefederativa
idxdccbd5cf Performance Asc idcidade
idxfcc66ca6 Performance Asc idparceiro
idxwsversao_24137c Performance Desc wsversao
uc3ea8ee5e Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation