PSINDICATOPT

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNCPT.CODCOLIGADA FKPFUNCPT_PSINDICATOPTR
GFORMULA.CODCOLIGADA FKPSINDICATOPT_GFORMULAFOLHAR
CODSINDICATO varchar 10 null
PFUNCPT.CODSINDICATO FKPFUNCPT_PSINDICATOPTR
NOME varchar 120 √ null
RUA varchar 100 √ null
NUMERO varchar 8 √ null
COMPLEMENTO DCOMPLEMENTO 60 √ null
CODFREGUESIA varchar 10 √ null
GFREGUESIAPT.CODIGO FKPSINDICATOPT_GFREGUESIAPTR
CODPOSTAL varchar 8 √ null
GCODIGOPOSTALPT.CODIGO FKPSINDICATOPT_GCODIGOPOSTALPTR
LOCALIDADE varchar 40 √ null
CONCELHO varchar 20 √ null
GMUNICIPIO.CODMUNICIPIO FKPSINDICATOPT_GMUNICIPIOR
DISTRITO varchar 2 √ null
GMUNICIPIO.CODETDMUNICIPIO FKPSINDICATOPT_GMUNICIPIOR
GETD.CODETD FKPSINDICATOPT_GETDR
NIB varchar 21 √ null
FORMFOLHA varchar 8 √ null
GFORMULA.CODIGO FKPSINDICATOPT_GFORMULAFOLHAR
FORMFERIAS varchar 8 √ null
GFORMULA.CODIGO FKPSINDICATOPT_GFORMULAFERIASR
FORMSUBS varchar 8 √ null
GFORMULA.CODIGO FKPSINDICATOPT_GFORMULASUBSR
APLICFORMUL varchar 1 √ null
GFORMULA.APLICACAO FKPSINDICATOPT_GFORMULAFERIASR
CODCONTRIBUINTE varchar 9 √ 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)
PKPSINDICATOPT Primary key Asc/Asc CODCOLIGADA + CODSINDICATO

Relationships

Close relationships within degrees of separation