localemail


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocalemail int8 19 null
localemail_aud.idlocalemail Implied Constraint R
pesquisausuarioemail.idlocalemail fk_9w1xqhojg8b32yf0912p7wkfn R
pesquisausuarioemail_aud.idlocalemail Implied Constraint R
email varchar 80 √ null
observacao varchar 4000 √ null
idnpadrao int2 5 null
idlocal int8 19 √ null
local.idlocal fk_firx286vigtakld7m75ak9281 R
idparceiro int8 19 √ null
parceiro.idparceiro fk_2uwyuoioesi81xo67cnv67fxq R
idtipoemail int8 19 √ null
tipoemail.idtipoemail fk_qhdn88pv0k6op822kcs6hu8wq R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idnexportadoerp int2 5 null
observacaointegracao varchar 4000 √ null

Indexes

Constraint Name Type Sort Column(s)
pkc3154311 Primary key Asc idlocalemail
idx41a457cd Performance Asc idtipoemail
idx5d02b0ff Performance Asc idlocal
idx7d61f0e0 Performance Asc idparceiro
idxwsversao_c3154311 Performance Desc wsversao
uca2c3c989 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation