PFHSTPROVFORMULA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFHSTPROVFORMULAMESCC.CODCOLIGADA FKPFHSTPROVFORMULAMESCC_PFHSTPR
PFUNC.CODCOLIGADA FKPFHSTPROVFORMULA_PFUNCR
GFORMULA.CODCOLIGADA FKPFHSTPROVFORMULA_GFORMULAR
CHAPA DCHAPA 16 null
PFHSTPROVFORMULAMESCC.CHAPA FKPFHSTPROVFORMULAMESCC_PFHSTPR
PFUNC.CHAPA FKPFHSTPROVFORMULA_PFUNCR
ANO smallint 2 null
PFHSTPROVFORMULAMESCC.ANO FKPFHSTPROVFORMULAMESCC_PFHSTPR
MES smallint 2 null
PFHSTPROVFORMULAMESCC.MES FKPFHSTPROVFORMULAMESCC_PFHSTPR
CODAPLICACAO varchar 1 null
GFORMULA.APLICACAO FKPFHSTPROVFORMULA_GFORMULAR
CODFORMULA varchar 8 null
PFHSTPROVFORMULAMESCC.CODFORMULA FKPFHSTPROVFORMULAMESCC_PFHSTPR
GFORMULA.CODIGO FKPFHSTPROVFORMULA_GFORMULAR
NROAVOSFOR int 4 null
VALFORMULA RMDVALOR2 17,2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPFHSTPROVFORMULA Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + ANO + MES + CODFORMULA

Relationships

Close relationships within degrees of separation