PESOCIALCLIFOR

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FCFO.CODCOLIGADA FKPESOCIALCLIFOR_FCFOR
CODCFO varchar 25 null
FCFO.CODCFO FKPESOCIALCLIFOR_FCFOR
TOMADORFOLHA smallint 2 √ null
OBRAPROPRIA smallint 2 √ null
CONSIDERAFILIALOBRA smallint 2 √ ((0))
CODCOLIGADAFILIALOBRA DCODCOLIGADANULL 2 √ null
CODFILIALOBRA smallint 2 √ null
CNAEPREP varchar 7 √ null
PERCENTACIDTRAB RMDVALOR2 17,2 √ null
FAP RMDVALOR4 17,4 √ null
TIPOCONTROLEPONTO smallint 2 √ null
CODCATEGORIAESOCIAL int 4 √ null
CPF varchar 20 √ null
INDOPCCP smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null
INDMV smallint 2 √ null
PREFIXOPERIODOESOCIAL varchar 30 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPESOCIALCLIFOR Primary key Asc/Asc CODCOLIGADA + CODCFO

Relationships

Close relationships within degrees of separation