HFLUXOTAREFA

191 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VMAPEAMENTOFLUXOAGILIS.CODCOLIGADA FKVMAPFLUXOAGILIS_HFLUXOTAREFAR
VREQMAPEAMENTOFLUXO.CODCOLIGADA FKVREQMAPFLUXO_HFLUXOTAREFAR
HTAREFA.CODCOLIGADA FKHFLUXOTAREFA_HTAREFAR
GFORMULA.CODCOLIGADA FKHFLUXOTAREFA_GFORMULAR
ID int 4 null
VMAPEAMENTOFLUXOAGILIS.IDFLUXOTAREFA FKVMAPFLUXOAGILIS_HFLUXOTAREFAR
VREQMAPEAMENTOFLUXO.IDFLUXOTAREFA FKVREQMAPFLUXO_HFLUXOTAREFAR
CODTIPOATENDIMENTO int 4 null
HTAREFA.CODTIPOATENDIMENTO FKHFLUXOTAREFA_HTAREFA2R
CODTAREFA int 4 null
HTAREFA.CODTAREFA FKHFLUXOTAREFA_HTAREFA2R
CODPROXTAREFA int 4 null
HTAREFA.CODTAREFA FKHFLUXOTAREFA_HTAREFAR
CODMOTIVOREP int 4 null
HMOTIVOREPASSE.CODMOTIVOREP FKHFLUXOTA_HMOTIVOREPASSER
MAILTO varchar 255 √ null
DESCRICAO varchar 100 √ null
FRMAVANCATAREFA varchar 8 √ null
ACOESTAREFA MEMO 2147483647 √ null
MAILCODFORMULA varchar 8 √ null
GFORMULA.CODIGO FKHFLUXOTAREFA_GFORMULAR
APLICACAO varchar 1 √ null
GFORMULA.APLICACAO FKHFLUXOTAREFA_GFORMULAR
MAILBODY varchar 255 √ null
ATIVARFLUXOTAREFA DLOGICO 2 ('1')
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKHFLUXOTAREFA Primary key Asc/Asc CODCOLIGADA + ID

Relationships

Close relationships within degrees of separation