operacaocadresposta


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idoperacaocadresposta int8 19 null
operacaocadresposta_aud.idoperacaocadresposta Implied Constraint R
idoperacaocadopcoes int8 19 √ null
operacaocadopcoes.idoperacaocadopcoes fk_sv7sr55qxkond5775djjqdctb R
idoperacaocadastro int8 19 null
operacaocadastro.idoperacaocadastro fk_hfu28jy99nhumpbx25mda2kqu R
idusuario int8 19 null
usuario.idusuario fk_5qwd3fw9j1a90frr3rhbx12iy R
idparceiro int8 19 √ null
parceiro.idparceiro fk_6kltjpax4smjtc3mbquor6rby R
idlocal int8 19 √ null
local.idlocal fk_fyp2j5b5l7d51uscgfe1b8yik R
idcontatopessoa int8 19 √ null
contatopessoa.idcontatopessoa fk_3xtojexdy6ry7br3xx1jhikj6 R
dataresposta date 13 null
sglambienteresposta varchar 45 null
descricao varchar 4000 √ null
idnexportadoerp int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 1 rows

Indexes

Constraint Name Type Sort Column(s)
pk39f06ee9 Primary key Asc idoperacaocadresposta
idx32c99f83 Performance Asc idparceiro
idx371f02cc Performance Asc idcontatopessoa
idx65a1ccf4 Performance Asc idoperacaocadopcoes
idx94dad9fd Performance Asc idlocal
idxe434d263 Performance Asc idusuario
idxfba43722 Performance Asc idoperacaocadastro
idxwsversao_39f06ee9 Performance Desc wsversao
uc324bcaf3 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.