PFHSTSEC

62 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKPFHSTSEC_PFUNCR
PMOTMUDSECAO.CODCOLIGADA FKPFHSTSEC_PMOTMUDSECAOR
PSECAO.CODCOLIGADA FKPFHSTSEC_PSECAOR
CHAPA DCHAPA 16 null
PFUNC.CHAPA FKPFHSTSEC_PFUNCR
DTMUDANCA datetime 16,3 null
MOTIVO varchar 2 null
PMOTMUDSECAO.CODCLIENTE FKPFHSTSEC_PMOTMUDSECAOR
CODSECAO varchar 35 √ null
PSECAO.CODIGO FKPFHSTSEC_PSECAOR
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)
PKPFHSTSEC Primary key Asc/Asc/Asc CODCOLIGADA + CHAPA + DTMUDANCA

Relationships

Close relationships within degrees of separation