HHISTORICOETAPASATENDIMENTO

25 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDHISTORICOETAPAS int 4 null
CODCOLIGADA DCODCOLIGADA 2 null
HATENDIMENTOBASE.CODCOLIGADA FKHHISTETAPASATEND_HATENDBASER
CODLOCAL int 4 null
HATENDIMENTOBASE.CODLOCAL FKHHISTETAPASATEND_HATENDBASER
CODATENDIMENTO int 4 √ null
HATENDIMENTOBASE.CODATENDIMENTO FKHHISTETAPASATEND_HATENDBASER
COLIGADAETAPAANTERIOR DCODCOLIGADANULL 2 √ null
HTAREFA.CODCOLIGADA FKHHISTETAPASATEND_HTAREFAANTR
CODTIPOATENDETAPAANTERIOR int 4 √ null
HTAREFA.CODTIPOATENDIMENTO FKHHISTETAPASATEND_HTAREFAANTR
CODETAPAANTERIOR int 4 √ null
HTAREFA.CODTAREFA FKHHISTETAPASATEND_HTAREFAANTR
COLIGADAATENDENTEANTERIOR DCODCOLIGADANULL 2 √ null
CODATENDENTEANTERIOR int 4 √ null
COLIGADAETAPAATUAL DCODCOLIGADANULL 2 √ null
HTAREFA.CODCOLIGADA FKHHISTETAPASATEND_HTAREFAATUR
CODTIPOATENDIMENTOETAPAATUAL int 4 √ null
HTAREFA.CODTIPOATENDIMENTO FKHHISTETAPASATEND_HTAREFAATUR
CODETAPAATUAL int 4 √ null
HTAREFA.CODTAREFA FKHHISTETAPASATEND_HTAREFAATUR
COLIGADAATENDENTEATUAL DCODCOLIGADANULL 2 √ null
CODATENDENTEATUAL int 4 √ null
INICIO DDATETIME 16,3 √ null
MUDANCADEETAPA DDATETIME 16,3 √ null
HORASUTEIS 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)
PKHHISTORICOETAPASATENDIMENTO Primary key Asc IDHISTORICOETAPAS

Relationships

Close relationships within degrees of separation