SPSOPCAOINSCRITO

261 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SPSHISTORICOCLASSIFICACAO.CODCOLIGADA FKSPSHISTCLASSIFICACAO_SPSOPCAR
SPSINSCRICAOAREAOFERTADA.CODCOLIGADA FKSPSOPCAOINSCRITO_SPSINSCRICAR
SPSAREAOFERTADA.CODCOLIGADA FKSPSOPCAOINSC_SPSAREAOFERTADAR
IDPS int 4 null
SPSHISTORICOCLASSIFICACAO.IDPS FKSPSHISTCLASSIFICACAO_SPSOPCAR
SPSINSCRICAOAREAOFERTADA.IDPS FKSPSOPCAOINSCRITO_SPSINSCRICAR
SPSAREAOFERTADA.IDPS FKSPSOPCAOINSC_SPSAREAOFERTADAR
CODPESSOA int 4 √ null
PPESSOA.CODIGO FKSPSOPCAOINSCRITO_PPESSOAR
NUMEROINSCRICAO int 4 null
SPSHISTORICOCLASSIFICACAO.NUMEROINSCRICAO FKSPSHISTCLASSIFICACAO_SPSOPCAR
SPSINSCRICAOAREAOFERTADA.NUMEROINSCRICAO FKSPSOPCAOINSCRITO_SPSINSCRICAR
IDAREAINTERESSE int 4 null
SPSHISTORICOCLASSIFICACAO.IDAREAINTERESSE FKSPSHISTCLASSIFICACAO_SPSOPCAR
SPSAREAOFERTADA.IDAREAINTERESSE FKSPSOPCAOINSC_SPSAREAOFERTADAR
NUMEROOPCAO smallint 2 null
CLASSIFICACAO int 4 √ null
PONTUACAO RMDVALOR4 17,4 √ null
NUMCHAMADA int 4 √ null
STATUS smallint 2 √ null
ULTIMAETAPA int 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
TIPOCOTAFEDERAL smallint 2 √ null
CLASSIFICACAOCOTA int 4 √ null
TIPOCOTACHAMADO smallint 2 √ null
CODUSUARIOPS int 4 √ null
SPSUSUARIO.CODUSUARIOPS FKSPSOPCAOINSCRITO_SPSUSUARIOR
CODCAMPUSMATRICULA varchar 10 √ null
SCAMPUS.CODCAMPUS FKSPSOPCAOINSCRITO_SCAMPUSR

Indexes

Constraint Name Type Sort Column(s)
PKSPSOPCAOINSCRITO Primary key Asc/Asc/Asc/Asc CODCOLIGADA + IDPS + NUMEROINSCRICAO + IDAREAINTERESSE
SXSPSOPCAOINSCRITO Must be unique Asc/Asc/Asc/Asc CODCOLIGADA + IDPS + NUMEROINSCRICAO + NUMEROOPCAO

Relationships

Close relationships within degrees of separation