SHISTHABILITACAOALUNO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SHISTATVIDADEALUNO.CODCOLIGADA FKSHISTATVALUNO_SHISTHABALUNOR
SHISTDISCAPROVESTUDOSORIGEM.CODCOLIGADA FKSHISTDISCAPVEST_SHISTHABALUR
SHISTDISCCONCLUIDAS.CODCOLIGADA FKSHISTDISCCONC_SHISTHABALUNOR
SHISTDISCEQUIVCONCLUIDAS.CODCOLIGADA FKSHISTDISCEQCONC_SHISTHABALUR
SHISTDISCEQUIVEMCURSO.CODCOLIGADA FKSHISTDISCEQUIVEMCURSO_SHISTHR
SHISTDISCOPTELETIVAS.CODCOLIGADA FKSHISTDISCOPTELE_SHISTHABALUR
SHISTDISCPENDENTES.CODCOLIGADA FKSHISTDISCPEND_SHISTHABALUNOR
SHISTDISCTCC.CODCOLIGADA FKSHISTDISCTCC_SHISTHABILITALUR
IDHABILITACAOFILIAL int 4 null
SHISTATVIDADEALUNO.IDHABILITACAOFILIAL FKSHISTATVALUNO_SHISTHABALUNOR
SHISTDISCAPROVESTUDOSORIGEM.IDHABILITACAOFILIAL FKSHISTDISCAPVEST_SHISTHABALUR
SHISTDISCCONCLUIDAS.IDHABILITACAOFILIAL FKSHISTDISCCONC_SHISTHABALUNOR
SHISTDISCEQUIVCONCLUIDAS.IDHABILITACAOFILIAL FKSHISTDISCEQCONC_SHISTHABALUR
SHISTDISCEQUIVEMCURSO.IDHABILITACAOFILIAL FKSHISTDISCEQUIVEMCURSO_SHISTHR
SHISTDISCOPTELETIVAS.IDHABILITACAOFILIAL FKSHISTDISCOPTELE_SHISTHABALUR
SHISTDISCPENDENTES.IDHABILITACAOFILIAL FKSHISTDISCPEND_SHISTHABALUNOR
SHISTDISCTCC.IDHABILITACAOFILIAL FKSHISTDISCTCC_SHISTHABILITALUR
RA varchar 20 null
SHISTATVIDADEALUNO.RA FKSHISTATVALUNO_SHISTHABALUNOR
SHISTDISCAPROVESTUDOSORIGEM.RA FKSHISTDISCAPVEST_SHISTHABALUR
SHISTDISCCONCLUIDAS.RA FKSHISTDISCCONC_SHISTHABALUNOR
SHISTDISCEQUIVCONCLUIDAS.RA FKSHISTDISCEQCONC_SHISTHABALUR
SHISTDISCEQUIVEMCURSO.RA FKSHISTDISCEQUIVEMCURSO_SHISTHR
SHISTDISCOPTELETIVAS.RA FKSHISTDISCOPTELE_SHISTHABALUR
SHISTDISCPENDENTES.RA FKSHISTDISCPEND_SHISTHABALUNOR
SHISTDISCTCC.RA FKSHISTDISCTCC_SHISTHABILITALUR
CODTIPOINGRESSO smallint 2 √ null
CODINST int 4 √ null
CODSTATUS int 4 √ null
DTINGRESSO datetime 16,3 √ null
PONTOSVESTIBULAR varchar 10 √ null
CLASSIFICACAOVESTIBULAR varchar 20 √ null
MEDIAVESTIBULAR RMDVALOR4 17,4 √ null
DTCOLACAOGRAU datetime 16,3 √ null
DTEMISDIPLOMA datetime 16,3 √ null
REGISTROCONCLUSAO varchar 10 √ null
LIVROREGISTRO varchar 20 √ null
PAGINAREGISTRO varchar 10 √ null
DTCONCLUSAOCURSO datetime 16,3 √ null
CR RMDVALOR4 17,4 √ null
MEDIAGLOBAL RMDVALOR4 17,4 √ null
DTPROVAO datetime 16,3 √ null
PROCESSOREGISTRO varchar 30 √ null
CODINSTDIPLOMA smallint 2 √ null
OBSERVACAO MEMO 2147483647 √ null
REALIZOUPROVAO varchar 1 √ null
IDHABILITACAOFILIALORIGEM int 4 √ null
CODMOTIVOTRANSFERENCIA smallint 2 √ null
MOTIVOTRANSFERENCIA MEMO 2147483647 √ null
NOMETIPOINGRESSO varchar 60 √ null
NOMEINSTITUICAO varchar 255 √ null
NOMESTATUS varchar 30 √ null
NOMEGRADE varchar 255 √ null
NOMECURSO varchar 500 √ null
NOMEHABILITACAO varchar 150 √ null
NOMETURNO varchar 15 √ null
NOMEALUNO varchar 120 √ null
CODCURSO varchar 10 √ null
QTDTOTALDISCOBR int 4 √ null
QTDCONCDISCOBR int 4 √ null
QTDPENDDISCOBR int 4 √ null
TIPOCONTDISCOPT varchar 45 √ null
QTDTOTALDISCOPT RMDVALOR4 17,4 √ null
QTDCONCDISCOPT RMDVALOR4 17,4 √ null
QTDPENDDISCOPT RMDVALOR4 17,4 √ null
TIPOCONTDISCELE varchar 45 √ null
QTDTOTALDISCELE RMDVALOR4 17,4 √ null
QTDCONCDISCELE RMDVALOR4 17,4 √ null
QTDPENDDISCELE RMDVALOR4 17,4 √ null
TIPOCONTATVCUR varchar 45 √ null
QTDTOTALATVCUR RMDVALOR4 17,4 √ null
QTDCONCATVCUR RMDVALOR4 17,4 √ null
QTDPENDATVCUR RMDVALOR4 17,4 √ null
DATAPROCESSAMENTO datetime 16,3 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
QTDTOTALEXTENSAO RMDVALOR4 17,4 √ null
QTDCONCEXTENSAO RMDVALOR4 17,4 √ null
QTDPENDEXTENSAO RMDVALOR4 17,4 √ null
POSSUIEXTENSAO varchar 1 ('N')
TOTCHINTEGRALIZADA RMDVALOR4 17,4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSHISTHABILITACAOALUNO Primary key Asc/Asc/Asc CODCOLIGADA + IDHABILITACAOFILIAL + RA

Relationships

Close relationships within degrees of separation