SPSCONTROLEPAGAMENTOPROF

27 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FLAN.CODCOLIGADA FKSPSCTRLPAGPROF_FLANR
SPSPROFISSIONALPS.CODCOLIGADA FKSPSCTRLPAGPROF_SPSPROFPSR
IDPS int 4 null
SPSPROFISSIONALPS.IDPS FKSPSCTRLPAGPROF_SPSPROFPSR
IDLOCALPS int 4 null
SPSPROFISSIONALPS.IDLOCALPS FKSPSCTRLPAGPROF_SPSPROFPSR
IDPROF int 4 null
SPSPROFISSIONALPS.IDPROF FKSPSCTRLPAGPROF_SPSPROFPSR
IDTIPOPROFISSIONAL smallint 2 null
SPSPROFISSIONALPS.IDTIPOPROFISSIONAL FKSPSCTRLPAGPROF_SPSPROFPSR
VALORRECEBIDO RMDVALOR4 17,4 null
IDLAN int 4 √ null
FLAN.IDLAN FKSPSCTRLPAGPROF_FLANR
USUARIO varchar 20 null
DIAEXECUCAO datetime 16,3 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)
PKSPSCONTROLEPAGAMENTOPROF Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDPS + IDLOCALPS + IDPROF + IDTIPOPROFISSIONAL
S$SPSCONTROLEPAGTOPROF_FLAN Performance Asc/Asc IDLAN + CODCOLIGADA

Relationships

Close relationships within degrees of separation