SPSLOCALETAPAINSCRITO

117 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SPSCONTROLEDISTRIBUICAOPROVA.CODCOLIGADA FKSPSCONTDISTPRV_SPSLOCETAINSCR
SPSDISTRIBUICAOPROVAFACIL.CODCOLIGADA FKSPSDISTPROVAFACIL_SPSETAPAR
SPSINSCRICAOAREAOFERTADA.CODCOLIGADA FKSPSLOCALETAPAINSCRITO_SPSINSR
IDPS int 4 null
SPSCONTROLEDISTRIBUICAOPROVA.IDPS FKSPSCONTDISTPRV_SPSLOCETAINSCR
SPSDISTRIBUICAOPROVAFACIL.IDPS FKSPSDISTPROVAFACIL_SPSETAPAR
SPSINSCRICAOAREAOFERTADA.IDPS FKSPSLOCALETAPAINSCRITO_SPSINSR
CODPESSOA int 4 √ null
PPESSOA.CODIGO FKSPSLOCALETAPAINSCRITO_PPESSOR
NUMEROINSCRICAO int 4 null
SPSCONTROLEDISTRIBUICAOPROVA.NUMEROINSCRICAO FKSPSCONTDISTPRV_SPSLOCETAINSCR
SPSDISTRIBUICAOPROVAFACIL.NUMEROINSCRICAO FKSPSDISTPROVAFACIL_SPSETAPAR
SPSINSCRICAOAREAOFERTADA.NUMEROINSCRICAO FKSPSLOCALETAPAINSCRITO_SPSINSR
IDAREAINTERESSE int 4 null
SPSCONTROLEDISTRIBUICAOPROVA.IDAREAINTERESSE FKSPSCONTDISTPRV_SPSLOCETAINSCR
SPSDISTRIBUICAOPROVAFACIL.IDAREAINTERESSE FKSPSDISTPROVAFACIL_SPSETAPAR
IDETAPA int 4 null
SPSCONTROLEDISTRIBUICAOPROVA.IDETAPA FKSPSCONTDISTPRV_SPSLOCETAINSCR
SPSDISTRIBUICAOPROVAFACIL.IDETAPA FKSPSDISTPROVAFACIL_SPSETAPAR
IDLOCALPS int 4 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODUSUARIOPS int 4 √ null
SPSUSUARIO.CODUSUARIOPS FKSPSLOCALETAPAINSCRITO_SPSUSUR

Indexes

Constraint Name Type Sort Column(s)
PKSPSLOCALETAPAINSCRITO Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDPS + NUMEROINSCRICAO + IDAREAINTERESSE + IDETAPA

Relationships

Close relationships within degrees of separation