PFENCARGO

51333 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFENCCC.CODCOLIGADA FKPFENCCC_PFENCARGOR
PFUNC.CODCOLIGADA FKPFENCARGO_PFUNCR
PENCARGO.CODCOLIGADA FKPFENCARGO_PENCARGOR
CHAPA DCHAPA 16 null
PFENCCC.CHAPA FKPFENCCC_PFENCARGOR
PFUNC.CHAPA FKPFENCARGO_PFUNCR
ANOCOMP smallint 2 null
PFENCCC.ANOCOMP FKPFENCCC_PFENCARGOR
MESCOMP smallint 2 null
PFENCCC.MESCOMP FKPFENCCC_PFENCARGOR
CODENCARGO varchar 4 null
PFENCCC.CODENCARGO FKPFENCCC_PFENCARGOR
PENCARGO.CODIGO FKPFENCARGO_PENCARGOR
VALOR RMDVALOR4 17,4 √ null
APLICACAO varchar 1 √ null
BASEENCARGO RMDVALOR4 17,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)
PKPFENCARGO Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + ANOCOMP + MESCOMP + CODENCARGO

Relationships

Close relationships within degrees of separation