camporesposta


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcamporesposta int8 19 null
camporesposta_aud.idcamporesposta Implied Constraint R
idcampo int8 19 null
campo.idcampo fk_8oselbk52lkv2cmkpkfpvst85 R
idcampoopcaofixo int8 19 √ null
campoopcaofixo.idcampoopcaofixo fk_pkkb75yqt329rw92uaga0dckl R
resposta varchar 4000 √ null
idproduto int8 19 √ null
produto.idproduto fk_p8jmpx2y9g3syqrw5f9dxu9up R
idparceiro int8 19 √ null
parceiro.idparceiro fk_kju75714jnelv22hd1mk7kdi7 R
idlocal int8 19 √ null
local.idlocal fk_rftg5h4w7m2qt7q5cs5duvp7l R
idcontatopessoa int8 19 √ null
contatopessoa.idcontatopessoa fk_70a6qrry0lgnmf60dd8ksyhmv R
idlead int8 19 √ null
lead.idlead fk_3tqjvvabfog6l29tlxk1i28h R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
iddemanda int8 19 √ null
demanda.iddemanda fk_re7thkyjcp2wgimg4bu1j75au R
idpkorigem int8 19 √ null

Table contained 15 rows

Indexes

Constraint Name Type Sort Column(s)
pkd559a32f Primary key Asc idcamporesposta
idx144cf3dc Performance Asc idproduto
idx46e11a36 Performance Asc idparceiro
idx565dcd38 Performance Asc idcampo
idx7f6d2192 Performance Asc idlocal
idxae7c6066 Performance Asc iddemanda
idxae96f044 Performance Asc idcampoopcaofixo
idxcc607e32 Performance Asc idcontatopessoa
idxe2d65879 Performance Asc idlead
idxwsversao_d559a32f Performance Desc wsversao
ucfffd114d Must be unique Asc codigoerp

Graphviz Needed!

SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz graphvizVersion 2.26 or versions greater than 2.31 from www.graphviz.org.