PFUNCPT

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PHSTCATEGPROFPT.CODCOLIGADA FKPHSTCATEGPROFPT_PFUNCPTR
PFUNC.CODCOLIGADA FKPFUNCPT_PFUNCR
PCATEGPROFPT.CODCOLIGADA FKPFUNCPT_PCATEGPROFPTR
PSINDICATOPT.CODCOLIGADA FKPFUNCPT_PSINDICATOPTR
CHAPA DCHAPA 16 null
PHSTCATEGPROFPT.CHAPA FKPHSTCATEGPROFPT_PFUNCPTR
PFUNC.CHAPA FKPFUNCPT_PFUNCR
CODCONTRIBSS varchar 3 √ null
PCONTRSSPT.CODCLIENTE FKPFUNCPT_PCONTRSSPTR
PERSSEMPREGADO RMDVALOR2 17,2 √ null
PERSSEMPREGADOR RMDVALOR2 17,2 √ null
TAXAFIXAIRS RMDVALOR2 17,2 √ null
ESTADOCIVILFISCAL char 2 √ ('1S')
PCODESTCIVILPT.CODCLIENTE PKPFUNCPT_PCODESTCIVILPTR
DEFICIENTEFISICO char 1 √ ('N')
TIPOCONTRATO char 1 √ null
PCONTRATPT.CODCLIENTE FKPFUNCPT_PCONTRATPTR
RENOVAR smallint 2 √ null
EXPERIMENTAL smallint 2 √ (0)
DATAFIMEXPERIMENTAL datetime 16,3 √ null
NUMDIASEXPERIMENTAL int 4 √ (0)
JORNADASEMANAL smallint 2 √ null
NIB varchar 21 √ null
CONTRIBUINTESS smallint 2 √ null
NISS varchar 11 √ null
CODSIND varchar 10 √ null
PCATEGPROFPT.CODIGO FKPFUNCPT_PCATEGPROFPTR
CODCATPROF varchar 5 √ null
PCATEGPROFPT.CODCATPROF FKPFUNCPT_PCATEGPROFPTR
SITPROFISSIONAL char 1 √ null
PSITPROFISSPT.CODCLIENTE FKPFUNCPT_PSITPROFISSPTR
REGDURTRAB char 1 √ null
PREGDURTRABPT.CODCLIENTE FKPFUNCPT_PREGDURTRABPTR
CODPROFISSAO varchar 6 √ null
HORANORMAL smallint 2 √ (0)
HORASUPLEMENTAR smallint 2 √ (0)
TETOSSOCIAL smallint 2 √ (0)
CODSINDICATO varchar 10 √ null
PSINDICATOPT.CODSINDICATO FKPFUNCPT_PSINDICATOPTR
CODFREGUESIANASCIMENTO varchar 10 √ null
GFREGUESIAPT.CODIGO FKPFUNCPT_GFREGUESIAPTR
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)
PKPFUNCPT Primary key Asc/Asc CODCOLIGADA + CHAPA

Relationships

Close relationships within degrees of separation