HHISTORICOATEND

13 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
HATENDENTE.CODCOLIGADA FKHHISTORICOATEND_HATENDR
HTAREFA.CODCOLIGADA FKHHISTORICOATEND_HTAREFAR
CODATENDENTE int 4 null
HATENDENTE.CODATENDENTE FKHHISTORICOATEND_HATENDR
INICIO datetime 16,3 null
TERMINO datetime 16,3 √ null
CODMOTINATATEND varchar 5 √ null
CODAPONTAMENTO int 4 null
CODLOCAL int 4 √ null
HATENDIMENTOBASE.CODLOCAL FKHHISTORICOATEND_HATENDIMEXTR
CODCOLIGADAAT DCODCOLIGADANULL 2 √ null
HATENDIMENTOBASE.CODCOLIGADA FKHHISTORICOATEND_HATENDIMEXTR
CODATENDIMENTO int 4 √ null
HATENDIMENTOBASE.CODATENDIMENTO FKHHISTORICOATEND_HATENDIMEXTR
CODGRUPOATENDIMENTO int 4 √ null
CODTIPOATENDIMENTO int 4 √ null
HTAREFA.CODTIPOATENDIMENTO FKHHISTORICOATEND_HTAREFAR
CODTAREFA int 4 √ null
HTAREFA.CODTAREFA FKHHISTORICOATEND_HTAREFAR
QTHORA DVALOR2 17,2 √ null
OBSERVACAO varchar 255 √ null
APROVADO DLOGICO 2 (0)
PERCENTUALCOMPLETUDE int 4 √ null
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)
PKHHISTORICOATEND Primary key Asc CODAPONTAMENTO
HXHISTORICOATENDENTE Performance Asc CODATENDENTE
HXHISTORICOATENDLOCAL Performance Asc/Asc/Asc CODCOLIGADA + CODLOCAL + CODATENDIMENTO
HXHISTORICOMOTINATATEND Performance Asc CODMOTINATATEND
HXHISTORICOTIPOATEND Performance Asc/Asc/Asc CODCOLIGADA + CODTIPOATENDIMENTO + CODTAREFA

Check Constraints

Constraint Name Constraint
CK__HHISTORIC__PERCE__6561EF8B ([PERCENTUALCOMPLETUDE] >= 0)

Relationships

Close relationships within degrees of separation