SPSINSCRICAOAREAOFERTADA

191 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SMATRICPL.CODCOLIGADA FKSMATRICPL_SPSINSCRICAOAREAOFR
SPSACEITETERMO.CODCOLIGADA FKSPSACEITETERMO_SPSINSCRICAOAR
SPSALTDATAVENCLANC.CODCOLIGADA FKSPSALTDATAVENCLANC_SPSINSCRIR
SPSARQUIVOSCANDIDATO.CODCOLIGADA FKSPSARQUIVOSCANDIDATO_SPSINSCR
SPSCLASSIFICACAOGERAL.CODCOLIGADA FKSPSCLASSIFICACAOGERAL_SPSINSR
SPSCONTROLEDISTRIBUICAOPROVA.CODCOLIGADA FKSPSCONTDISTPRV_SPSINSCAREAOFR
SPSDISTRIBUICAOPROVAFACIL.CODCOLIGADA FKSPSDISTPROVAFACIL_SPSINSCRICR
SPSDOCUMENTOENTREGUE.CODCOLIGADA FKSPSDOCUMENTOENTREGUE_SPSINSCR
SPSHISTLANINSCRICAO.CODCOLIGADA FKSPSHISTLANINSCRICAO_SPSINSCRR
SPSIDIOMAINSCRITO.CODCOLIGADA FKSPSIDIOMAINSCRITO_SPSINSCRICR
SPSINSCAREAOFERTACOMPL.CODCOLIGADA FKSPSINSCAREAOFERTACOMPL_SPSINR
SPSINSCRICAOANONIMA.CODCOLIGADA FKSPSINSCRICAOANONIMA_SPSINSCRR
SPSINSCRICAOAREAOFERTADASUBDEF.CODCOLIGADA FKSPSINSCAREAOFESUBDEF_SPSINSCR
SPSINSCRICAOITINERARIO.CODCOLIGADA FKSPSINSCRICAOITINERARIO_SPSIR
SPSLOCALETAPAINSCRITO.CODCOLIGADA FKSPSLOCALETAPAINSCRITO_SPSINSR
SPSLOGALTERACAOSTATUS.CODCOLIGADA FKSPSLOGALTERACAOSTATUS_SPSINSR
SPSOPCAOINSCRITO.CODCOLIGADA FKSPSOPCAOINSCRITO_SPSINSCRICAR
SPSFORMAINSCRICAOPS.CODCOLIGADA FKSPSINSCAREAOF_SPSFORMAINSCPSR
IDPS int 4 null
SMATRICPL.IDPS FKSMATRICPL_SPSINSCRICAOAREAOFR
SPSACEITETERMO.IDPS FKSPSACEITETERMO_SPSINSCRICAOAR
SPSALTDATAVENCLANC.IDPS FKSPSALTDATAVENCLANC_SPSINSCRIR
SPSARQUIVOSCANDIDATO.IDPS FKSPSARQUIVOSCANDIDATO_SPSINSCR
SPSCLASSIFICACAOGERAL.IDPS FKSPSCLASSIFICACAOGERAL_SPSINSR
SPSCONTROLEDISTRIBUICAOPROVA.IDPS FKSPSCONTDISTPRV_SPSINSCAREAOFR
SPSDISTRIBUICAOPROVAFACIL.IDPS FKSPSDISTPROVAFACIL_SPSINSCRICR
SPSDOCUMENTOENTREGUE.IDPS FKSPSDOCUMENTOENTREGUE_SPSINSCR
SPSHISTLANINSCRICAO.IDPS FKSPSHISTLANINSCRICAO_SPSINSCRR
SPSIDIOMAINSCRITO.IDPS FKSPSIDIOMAINSCRITO_SPSINSCRICR
SPSINSCAREAOFERTACOMPL.IDPS FKSPSINSCAREAOFERTACOMPL_SPSINR
SPSINSCRICAOANONIMA.IDPS FKSPSINSCRICAOANONIMA_SPSINSCRR
SPSINSCRICAOAREAOFERTADASUBDEF.IDPS FKSPSINSCAREAOFESUBDEF_SPSINSCR
SPSINSCRICAOITINERARIO.IDPS FKSPSINSCRICAOITINERARIO_SPSIR
SPSLOCALETAPAINSCRITO.IDPS FKSPSLOCALETAPAINSCRITO_SPSINSR
SPSLOGALTERACAOSTATUS.IDPS FKSPSLOGALTERACAOSTATUS_SPSINSR
SPSOPCAOINSCRITO.IDPS FKSPSOPCAOINSCRITO_SPSINSCRICAR
SPSFORMAINSCRICAOPS.IDPS FKSPSINSCAREAOF_SPSFORMAINSCPSR
CODPESSOA int 4 √ null
SPESSOA.CODIGO FKINSCRICAOAREAOFER_SPESSOAR
NUMEROINSCRICAO int 4 null
SMATRICPL.NUMEROINSCRICAO FKSMATRICPL_SPSINSCRICAOAREAOFR
SPSACEITETERMO.NUMEROINSCRICAO FKSPSACEITETERMO_SPSINSCRICAOAR
SPSALTDATAVENCLANC.NUMEROINSCRICAO FKSPSALTDATAVENCLANC_SPSINSCRIR
SPSARQUIVOSCANDIDATO.NUMEROINSCRICAO FKSPSARQUIVOSCANDIDATO_SPSINSCR
SPSCLASSIFICACAOGERAL.NUMEROINSCRICAO FKSPSCLASSIFICACAOGERAL_SPSINSR
SPSCONTROLEDISTRIBUICAOPROVA.NUMEROINSCRICAO FKSPSCONTDISTPRV_SPSINSCAREAOFR
SPSDISTRIBUICAOPROVAFACIL.NUMEROINSCRICAO FKSPSDISTPROVAFACIL_SPSINSCRICR
SPSDOCUMENTOENTREGUE.NUMEROINSCRICAO FKSPSDOCUMENTOENTREGUE_SPSINSCR
SPSHISTLANINSCRICAO.NUMEROINSCRICAO FKSPSHISTLANINSCRICAO_SPSINSCRR
SPSIDIOMAINSCRITO.NUMEROINSCRICAO FKSPSIDIOMAINSCRITO_SPSINSCRICR
SPSINSCAREAOFERTACOMPL.NUMEROINSCRICAO FKSPSINSCAREAOFERTACOMPL_SPSINR
SPSINSCRICAOANONIMA.NUMEROINSCRICAO FKSPSINSCRICAOANONIMA_SPSINSCRR
SPSINSCRICAOAREAOFERTADASUBDEF.NUMEROINSCRICAO FKSPSINSCAREAOFESUBDEF_SPSINSCR
SPSINSCRICAOITINERARIO.NUMEROINSCRICAO FKSPSINSCRICAOITINERARIO_SPSIR
SPSLOCALETAPAINSCRITO.NUMEROINSCRICAO FKSPSLOCALETAPAINSCRITO_SPSINSR
SPSLOGALTERACAOSTATUS.NUMEROINSCRICAO FKSPSLOGALTERACAOSTATUS_SPSINSR
SPSOPCAOINSCRITO.NUMEROINSCRICAO FKSPSOPCAOINSCRITO_SPSINSCRICAR
IDFORMAINSCRICAO smallint 2 √ null
SPSFORMAINSCRICAOPS.IDFORMAINSCRICAO FKSPSINSCAREAOF_SPSFORMAINSCPSR
DATAINSCRICAO datetime 16,3 null
VALORINSCRICAO RMDVALOR4 17,4 √ null
VALORDESCONTO RMDVALOR4 17,4 √ null
UTILIZANOTAENEM BOOLEAN 1 ('F')
CODCOLIGADALAN DCODCOLIGADANULL 2 √ null
FLAN.CODCOLIGADA FKINSCRICAOAREAOFER_FLANR
IDLAN int 4 √ null
FLAN.IDLAN FKINSCRICAOAREAOFER_FLANR
NUMEROCARTAORESPOSTA int 4 √ null
CODPESSOARESPONSAVEL int 4 √ null
PPESSOA.CODIGO FKINSCRICAOAREAOFER_PPESSOAR
CODCOLIGADAALUNO DCODCOLIGADANULL 2 √ null
SALUNO.CODCOLIGADA FKINSCRICAOAREAOFER_SALUNOR
RA varchar 20 √ null
SALUNO.RA FKINSCRICAOAREAOFER_SALUNOR
CODCOLIGADAALUNOESB DCODCOLIGADANULL 2 √ null
EALUNOS.CODCOLIGADA FKINSCRICAOAREAOFER_EALUNOSR
MATRICULA varchar 10 √ null
EALUNOS.MATRICULA FKINSCRICAOAREAOFER_EALUNOSR
CODCOLIGADAFUNC DCODCOLIGADANULL 2 √ null
PFUNC.CODCOLIGADA FKSPSINSCAREAOFER_PFUNCR
CHAPA DCHAPANULL 16 √ null
PFUNC.CHAPA FKSPSINSCAREAOFER_PFUNCR
CODCOLIGADACFO DCODCOLIGADANULL 2 √ null
FCFO.CODCOLIGADA FKSPSINSCAREAOFER_FCFOR
CODCFO varchar 25 √ null
FCFO.CODCFO FKSPSINSCAREAOFER_FCFOR
CODMUNICIPIO varchar 20 √ null
GMUNICIPIO.CODMUNICIPIO FKSPSINSCAREAOFER_GMUNICIPIOR
CODETDMUNICIPIO varchar 2 √ null
GMUNICIPIO.CODETDMUNICIPIO FKSPSINSCAREAOFER_GMUNICIPIOR
ENEMNUMINSCRICAO varchar 15 √ null
ENEMANOREFERENCIA smallint 2 √ null
ENEMNOTAREDACAO RMDVALOR4 17,4 √ null
ENEMNOTAOBJETIVA RMDVALOR4 17,4 √ null
STATUS smallint 2 √ null
TREINEIRO BOOLEAN 1 ('F')
DEFAUDITIVA BOOLEAN 1 ('F')
DEFVISUAL BOOLEAN 1 ('F')
DEFFISICA BOOLEAN 1 ('F')
DEFMULTIPLA BOOLEAN 1 ('F')
DEFOUTRAS BOOLEAN 1 ('F')
DEFMOTIVOOUTRAS MEMO 2147483647 √ null
CODCOLIGADAQS DCODCOLIGADANULL 2 √ null
CODPROVAQS varchar 16 √ null
IDQS int 4 √ null
CODCOLIGADAMAT DCODCOLIGADANULL 2 √ null
SMATRICPL.CODCOLIGADA FKSPSINSCAREAOFER_SMATRICPLR
IDPERLET int 4 √ null
SMATRICPL.IDPERLET FKSPSINSCAREAOFER_SMATRICPLR
IDHABFILIALMAT int 4 √ null
SMATRICPL.IDHABILITACAOFILIAL FKSPSINSCAREAOFER_SMATRICPLR
RAMAT varchar 20 √ null
SMATRICPL.RA FKSPSINSCAREAOFER_SMATRICPLR
IDCAMPUS int 4 √ null
SPSCAMPUS.IDCAMPUS FKSPSINSCRAREAOFERT_SPSCAMPUSR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
COTAFEDERAL BOOLEAN 1 √ ('F')
COTAFEDERALENSINOPUBLICO BOOLEAN 1 √ ('F')
COTAFEDERALRENDA BOOLEAN 1 √ ('F')
COTAFEDERALCORACA BOOLEAN 1 √ ('F')
CODPESSOAACEITEPORTAL int 4 √ null
DATAHORAACEITEPORTAL DDATETIME 16,3 √ null
ENEMNOTANATUREZA RMDVALOR4 17,4 √ null
ENEMNOTAHUMANAS RMDVALOR4 17,4 √ null
ENEMNOTALINGUAGEM RMDVALOR4 17,4 √ null
ENEMNOTAMATEMATICA RMDVALOR4 17,4 √ null
CODUSUARIOPS int 4 √ null
SPSUSUARIO.CODUSUARIOPS FKSPSINSCRICAOAREAOFER_SPSUSUAR
COTAFEDERALPCD BOOLEAN 1 √ null
DEFFALA BOOLEAN 1 ('F')
DEFMENTAL BOOLEAN 1 ('F')
DEFINTELECTUAL BOOLEAN 1 ('F')
BRPDH BOOLEAN 1 ('F')
CODPLANOPGTO varchar 10 √ null
PROVAFACILKEY varchar 64 √ null
PROVAFACILEXAMURL varchar 250 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSPSINSCRICAOAREAOFERTADA Primary key Asc/Asc/Asc CODCOLIGADA + IDPS + NUMEROINSCRICAO
S$SPSINSCRAREAOFERTADA_FLAN Performance Asc/Asc IDLAN + CODCOLIGADALAN

Relationships

Close relationships within degrees of separation