pesquisa


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idpesquisa int8 19 null
email.idpesquisa fk_ftcbb2rx0cw2pyg1oqt13g7hf R
email_aud.idpesquisa Implied Constraint R
pesquisa_aud.idpesquisa Implied Constraint R
pesquisaparametro.idpesquisa fk_1uhvx6aev7jvxyonnti5vff6 R
pesquisaparametro_aud.idpesquisa Implied Constraint R
pesquisapergunta.idpesquisa fk_93q2o58l8j5qymiqj6gglrefi R
pesquisapergunta_aud.idpesquisa Implied Constraint R
pesquisaresultado.idpesquisa fk_575ym0fykqna096rauqq60xaw R
pesquisaresultado_aud.idpesquisa Implied Constraint R
usuariopesquisa.idpesquisa fk_fv9dsdexxqpkuugygvnajg6gs R
usuariopesquisa_aud.idpesquisa Implied Constraint R
titulo varchar 80 null
descricao varchar 80 √ null
dispararautomatico varchar 80 √ null
sglmodelopesquisa varchar 10 √ null
idnpermitevariasresp int2 5 null
idnformularioanonimo int2 5 null
idnenumerarpergunta int2 5 null
idnordenaraleatorio int2 5 null
idncertificargps int2 5 null
observacao varchar 4000 √ null
datainiciovigencia date 13 √ null
datacadastro date 13 null
horacadastro varchar 8 null
datafimvigencia date 13 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idusuario int8 19 null
usuario.idusuario fk_c25uv5pi7iw3xyet7ksmkhh0r R
idpesqtemplate int8 19 √ null
pesqtemplate.idpesqtemplate fk_evnrm2r83ng3pksewdjc6xyc R
idpesquisaemail int8 19 √ null
pesquisaemail.idpesquisaemail fk_l5d3ctx6s9ig9it311omr5v2o R
idusuarioaprovacao int8 19 √ null
usuario.idusuario fk_ja4b85l8aftyyatrw463rrhjj R
dataaprovacao date 13 √ null
observacaoaprovacao varchar 4000 √ null
idtipoaprovacao int8 19 √ null
tipoaprovacao.idtipoaprovacao fk_3r0iqc1fa1ix8j9hd2n9e6okb R
idtiposituacaoaprovacao int8 19 √ null
tiposituacaoaprovacao.idtiposituacaoaprovacao fk_incow9h41p0jkhc6n852lwcgm R
idncadastrofinalizado int2 5 null
idndispgravacliente int2 5 √ null
idnativo int2 5 null
idnenviaemail int2 5 √ null
idnhabilitaobsaprovacao int2 5 √ null
sgltipocampoobsaprovacao varchar 10 √ null
sgltipocampoobsaprovacao2 varchar 10 √ null
sglacaoexibeobs varchar 10 √ null
idnpermiteedicao int2 5 √ null
labelobsaprovacao varchar 80 √ null
labelobsaprovacao2 varchar 80 √ null

Table contained 3 rows

Indexes

Constraint Name Type Sort Column(s)
pk1fdfdd95 Primary key Asc idpesquisa
idx2606e200 Performance Asc idusuario
idx491b30fe Performance Asc idpesquisaemail
idx5aa4bb83 Performance Asc idtipoaprovacao
idxbb22c200 Performance Asc idpesqtemplate
idxec2ae175 Performance Asc idtiposituacaoaprovacao
idxf31a73b6 Performance Asc idusuarioaprovacao
idxwsversao_1fdfdd95 Performance Desc wsversao
ucda382d65 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.