PFCONVOCACAOPFPERFF

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFCONVOCACAO.CODCOLIGADA FKPFCONVOCACAOPFPERFF_PFCONVOCR
PFPERFF.CODCOLIGADA FKPFCONVOCACAOPFPERFF_PFPERFFR
CHAPA DCHAPA 16 null
PFPERFF.CHAPA FKPFCONVOCACAOPFPERFF_PFPERFFR
PFCONVOCACAO.CHAPA FKPFCONVOCACAOPFPERFF_PFCONVOCR
CODCONVOCACAO nvarchar 60 null
PFCONVOCACAO.CODCONVOCACAO FKPFCONVOCACAOPFPERFF_PFCONVOCR
ANOCOMP smallint 2 null
PFPERFF.ANOCOMP FKPFCONVOCACAOPFPERFF_PFPERFFR
MESCOMP smallint 2 null
PFPERFF.MESCOMP FKPFCONVOCACAOPFPERFF_PFPERFFR
NROPERIODO smallint 2 null
PFPERFF.NROPERIODO FKPFCONVOCACAOPFPERFF_PFPERFFR
QUANTIDADEDIAS smallint 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)
PKPFCONVOCACAOPFPERFF Primary key Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + CODCONVOCACAO + ANOCOMP + MESCOMP + NROPERIODO

Relationships

Close relationships within degrees of separation