PFHSTHOR

137 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKPFHSTHOR_PFUNCR
AHORARIO.CODCOLIGADA FKPFHSTHOR_AHORARIOR
CHAPA DCHAPA 16 null
PFUNC.CHAPA FKPFHSTHOR_PFUNCR
DTMUDANCA datetime 16,3 null
CODHORARIO varchar 10 √ null
AHORARIO.CODIGO FKPFHSTHOR_AHORARIOR
INDINICIOHOR smallint 2 √ null
DATAALTERACAO datetime 16,3 √ null
MOTIVO varchar 2 √ null
COMPORTAMENTOHORARIOANTERIOR int 4 (0)
COMPORTAMENTOHORARIOATUAL int 4 (0)
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)
PKPFHSTHOR Primary key Asc/Asc/Asc CODCOLIGADA + CHAPA + DTMUDANCA

Relationships

Close relationships within degrees of separation