PFCOMPL

56 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKPFCOMPL_PFUNCR
CHAPA DCHAPA 16 null
PFUNC.CHAPA FKPFCOMPL_PFUNCR
SANGUE varchar 7 √ null
CESTABASICA varchar 6 √ null
CONFBB varchar 20 √ null
MANEQUIM smallint 2 √ null
NUMEROSAPATO smallint 2 √ null
MESNASCIMENTO smallint 2 √ null
TAMBOTA int 4 √ null
DTCASAMENTO datetime 16,3 √ null
TIPOSANGUE varchar 1 √ null
SANGUE1 varchar 3 √ null
CTA varchar 10 √ null
NUMCARTAO varchar 20 √ null
NUMNOVOCARTAO varchar 20 √ null
FORMACAO varchar 20 √ null
TIPOCONTRATO varchar 20 √ null
TOTALTICKETS varchar 20 √ null
BLOCAGEM varchar 20 √ null
VALOR varchar 20 √ null
MESESHE varchar 10 √ null
MDISSCOLETIVO varchar 10 √ null
MGRATIFIC varchar 10 √ null
CNPJCONTASSIST varchar 20 √ null
CODMUNICIPIO varchar 15 √ 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)
PKPFCOMPL Primary key Asc/Asc CODCOLIGADA + CHAPA

Relationships

Close relationships within degrees of separation