SGRADEALUNO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SGRADECOMPLALUNO.CODCOLIGADA FKSGRADECOMPLALUNO_SGRADEALUNOR
SGRUPOOPTELETALUNO.CODCOLIGADA FKSGRUPOOPTELETALUNO_SGRADEALUR
SPERIODOALUNO.CODCOLIGADA FKSPERIODOALUNO_SGRADEALUNOR
SHABILITACAOALUNO.CODCOLIGADA FKSGRADEALUNO_SHABILITACAOALUNR
GFORMULA.CODCOLIGADA FKSGRADEALUNOCR_GFORMULAR
IDHABILITACAOFILIAL int 4 null
SGRADECOMPLALUNO.IDHABILITACAOFILIAL FKSGRADECOMPLALUNO_SGRADEALUNOR
SGRUPOOPTELETALUNO.IDHABILITACAOFILIAL FKSGRUPOOPTELETALUNO_SGRADEALUR
SPERIODOALUNO.IDHABILITACAOFILIAL FKSPERIODOALUNO_SGRADEALUNOR
SHABILITACAOALUNO.IDHABILITACAOFILIAL FKSGRADEALUNO_SHABILITACAOALUNR
RA varchar 20 null
SGRADECOMPLALUNO.RA FKSGRADECOMPLALUNO_SGRADEALUNOR
SGRUPOOPTELETALUNO.RA FKSGRUPOOPTELETALUNO_SGRADEALUR
SPERIODOALUNO.RA FKSPERIODOALUNO_SGRADEALUNOR
SHABILITACAOALUNO.RA FKSGRADEALUNO_SHABILITACAOALUNR
TOTALCH RMDVALOR4 17,4 √ null
TOTALCREDITOS RMDVALOR4 17,4 √ null
MINCREDPERIODO RMDVALOR4 17,4 √ null
MAXCREDPERIODO RMDVALOR4 17,4 √ null
TIPOOPTATIVA varchar 1 √ null
TIPOELETIVA varchar 1 √ null
TIPOATIVIDADECURRICULAR varchar 1 √ null
CODFORMULA varchar 8 √ null
GFORMULA.CODIGO FKSGRADEALUNO_GFORMULAR
CODFORMULACR varchar 8 √ null
GFORMULA.CODIGO FKSGRADEALUNOCR_GFORMULAR
DESCRICAO varchar 255 √ null
APLICACAO varchar 1 √ null
GFORMULA.APLICACAO FKSGRADEALUNO_GFORMULAR
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)
PKSGRADEALUNO Primary key Asc/Asc/Asc CODCOLIGADA + IDHABILITACAOFILIAL + RA

Relationships

Close relationships within degrees of separation