SPSPROFISSIONAL

20 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDPROF int 4 null
SPSPERFILPROFISSIONAL.IDPROF FKSPSPERFILPROF_SPSPROFR
DATACADASTRO datetime 16,3 √ null
CODCOLIGADAFUNC DCODCOLIGADANULL 2 √ null
PFUNC.CODCOLIGADA FKSPSPROFISSIONAL_PFUNCR
CHAPA DCHAPANULL 16 √ null
PFUNC.CHAPA FKSPSPROFISSIONAL_PFUNCR
CODCOLIGADACFO DCODCOLIGADANULL 2 √ null
FCFO.CODCOLIGADA FKSPSPROFISSIONAL_FCFOR
CODCFO varchar 25 √ null
FCFO.CODCFO FKSPSPROFISSIONAL_FCFOR
ATIVO BOOLEAN 1 ('T')
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
SEXOCFO varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSPSPROFISSIONAL Primary key Asc IDPROF

Relationships

Close relationships within degrees of separation