SPSCONTROLEPRESENCAPROF

28 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SPSPROFISSIONALPS.CODCOLIGADA FKSPSCPRESENCAPROF_SPSPROFPSR
IDPS int 4 null
SPSPROFISSIONALPS.IDPS FKSPSCPRESENCAPROF_SPSPROFPSR
IDPROF int 4 null
SPSPROFISSIONALPS.IDPROF FKSPSCPRESENCAPROF_SPSPROFPSR
IDLOCALPS int 4 null
SPSPROFISSIONALPS.IDLOCALPS FKSPSCPRESENCAPROF_SPSPROFPSR
IDTIPOPROFISSIONAL smallint 2 null
SPSPROFISSIONALPS.IDTIPOPROFISSIONAL FKSPSCPRESENCAPROF_SPSPROFPSR
DATA datetime 16,3 null
PRESENTE BOOLEAN 1 ('F')
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)
PKSPSCONTPRESENCAPROF Primary key Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDPS + IDPROF + IDLOCALPS + IDTIPOPROFISSIONAL + DATA

Relationships

Close relationships within degrees of separation