SPSLOCALPS

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SPSTIPOPROFISSIONALLOCAL.CODCOLIGADA FKSPSTIPOPROFPS_SPSLOCALPSR
SPSPROCESSOSELETIVO.CODCOLIGADA FKSPSLOCALPS_SPSPROCSELR
IDPS int 4 null
SPSTIPOPROFISSIONALLOCAL.IDPS FKSPSTIPOPROFPS_SPSLOCALPSR
SPSPROCESSOSELETIVO.IDPS FKSPSLOCALPS_SPSPROCSELR
IDLOCALPS int 4 null
SPSTIPOPROFISSIONALLOCAL.IDLOCALPS FKSPSTIPOPROFPS_SPSLOCALPSR
IDPREDIO int 4 √ null
SPSLOCAL.IDPREDIO FKSPSLOCALPS_SPSLOCALR
IDLOCAL smallint 2 √ null
SPSLOCAL.IDLOCAL FKSPSLOCALPS_SPSLOCALR
PRIORIDADEENSALAMENTO smallint 2 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)
PKSPSLOCALPS Primary key Asc/Asc/Asc CODCOLIGADA + IDPS + IDLOCALPS
SXSPSLOCALPS Must be unique Asc/Asc/Asc/Asc CODCOLIGADA + IDPS + IDPREDIO + IDLOCAL

Relationships

Close relationships within degrees of separation