SPSTIPOPROFISSIONALLOCAL

23 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SPSPROFISSIONALPS.CODCOLIGADA FKSPSPROFPS_SPSTIPOPROFLOCALR
SPSLOCALPS.CODCOLIGADA FKSPSTIPOPROFPS_SPSLOCALPSR
IDPS int 4 null
SPSPROFISSIONALPS.IDPS FKSPSPROFPS_SPSTIPOPROFLOCALR
SPSLOCALPS.IDPS FKSPSTIPOPROFPS_SPSLOCALPSR
IDLOCALPS int 4 null
SPSPROFISSIONALPS.IDLOCALPS FKSPSPROFPS_SPSTIPOPROFLOCALR
SPSLOCALPS.IDLOCALPS FKSPSTIPOPROFPS_SPSLOCALPSR
IDTIPOPROFISSIONAL smallint 2 null
SPSPROFISSIONALPS.IDTIPOPROFISSIONAL FKSPSPROFPS_SPSTIPOPROFLOCALR
SPSTIPOPROFISSIONAL.IDTIPOPROFISSIONAL FKSPSTIPOPROFPS_SPSTIPOPROFR
NUMEROPROFISSIONAIS smallint 2 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
SEXOEXIGIDO varchar 1 ('A')

Indexes

Constraint Name Type Sort Column(s)
PKSPSTIPOPROFISSIONALPS Primary key Asc/Asc/Asc/Asc CODCOLIGADA + IDPS + IDLOCALPS + IDTIPOPROFISSIONAL

Relationships

Close relationships within degrees of separation