SPSPROFISSIONALPS

46 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SPSCONTROLEPAGAMENTOPROF.CODCOLIGADA FKSPSCTRLPAGPROF_SPSPROFPSR
SPSCONTROLEPRESENCAPROF.CODCOLIGADA FKSPSCPRESENCAPROF_SPSPROFPSR
SPSLANCAMENTO.CODCOLIGADA FKSPSLANCAMENTO_SPSPROFR
SPSTIPOPROFISSIONALLOCAL.CODCOLIGADA FKSPSPROFPS_SPSTIPOPROFLOCALR
IDPS int 4 null
SPSCONTROLEPAGAMENTOPROF.IDPS FKSPSCTRLPAGPROF_SPSPROFPSR
SPSCONTROLEPRESENCAPROF.IDPS FKSPSCPRESENCAPROF_SPSPROFPSR
SPSLANCAMENTO.IDPS FKSPSLANCAMENTO_SPSPROFR
SPSTIPOPROFISSIONALLOCAL.IDPS FKSPSPROFPS_SPSTIPOPROFLOCALR
IDLOCALPS int 4 null
SPSCONTROLEPAGAMENTOPROF.IDLOCALPS FKSPSCTRLPAGPROF_SPSPROFPSR
SPSCONTROLEPRESENCAPROF.IDLOCALPS FKSPSCPRESENCAPROF_SPSPROFPSR
SPSLANCAMENTO.IDLOCALPS FKSPSLANCAMENTO_SPSPROFR
SPSTIPOPROFISSIONALLOCAL.IDLOCALPS FKSPSPROFPS_SPSTIPOPROFLOCALR
IDTIPOPROFISSIONAL smallint 2 null
SPSCONTROLEPAGAMENTOPROF.IDTIPOPROFISSIONAL FKSPSCTRLPAGPROF_SPSPROFPSR
SPSCONTROLEPRESENCAPROF.IDTIPOPROFISSIONAL FKSPSCPRESENCAPROF_SPSPROFPSR
SPSLANCAMENTO.IDTIPOPROFISSIONAL FKSPSLANCAMENTO_SPSPROFR
SPSPERFILPROFISSIONAL.IDTIPOPROFISSIONAL FKSPSPROFPS_SPSPERFILPROFR
SPSTIPOPROFISSIONALLOCAL.IDTIPOPROFISSIONAL FKSPSPROFPS_SPSTIPOPROFLOCALR
IDPROF int 4 null
SPSCONTROLEPAGAMENTOPROF.IDPROF FKSPSCTRLPAGPROF_SPSPROFPSR
SPSCONTROLEPRESENCAPROF.IDPROF FKSPSCPRESENCAPROF_SPSPROFPSR
SPSLANCAMENTO.IDPROF FKSPSLANCAMENTO_SPSPROFR
SPSPERFILPROFISSIONAL.IDPROF FKSPSPROFPS_SPSPERFILPROFR
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)
PKSPSPROFISSIONALPS Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDPS + IDLOCALPS + IDTIPOPROFISSIONAL + IDPROF

Relationships

Close relationships within degrees of separation