SDISCGRADEALUNO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SDISCFILHAALUNO.CODCOLIGADA FKSDISCFILHAALFIL_SDISCGRADEALR
SDISCGRADEALUNOCOMPL.CODCOLIGADA FKSDISCGRADALUCOMPL_SDISCGRADER
SREQUISITOALUNO.CODCOLIGADA FKSREQUISITOALUNO_SDISCGRADEALR
SGRUPODISC.CODCOLIGADA FKSDISCGRADEALUNO_SGRUPODISCR
SPERIODOALUNO.CODCOLIGADA FKSDISCGRADEALUNO_SPERIODOALUNR
GFORMULA.CODCOLIGADA FKSDISCGRADEALUNO_GFORMULAR
SDISCIPLINA.CODCOLIGADA FKSDISCGRADEALUNO_SDISCIPLINAR
IDHABILITACAOFILIAL int 4 null
SDISCFILHAALUNO.IDHABILITACAOFILIAL FKSDISCFILHAALUNO_SDISCGRADEALR
SDISCGRADEALUNOCOMPL.IDHABILITACAOFILIAL FKSDISCGRADALUCOMPL_SDISCGRADER
SREQUISITOALUNO.IDHABILITACAOFILIAL FKSREQUISITOALUNO_SDISCGRADEALR
SPERIODOALUNO.IDHABILITACAOFILIAL FKSDISCGRADEALUNO_SPERIODOALUNR
RA varchar 20 null
SDISCFILHAALUNO.RA FKSDISCFILHAALFIL_SDISCGRADEALR
SDISCGRADEALUNOCOMPL.RA FKSDISCGRADALUCOMPL_SDISCGRADER
SREQUISITOALUNO.RA FKSREQUISITOALUNO_SDISCGRADEALR
SPERIODOALUNO.RA FKSDISCGRADEALUNO_SPERIODOALUNR
CODPERIODO smallint 2 null
SDISCFILHAALUNO.CODPERIODO FKSDISCFILHAALUNO_SDISCGRADEALR
SDISCGRADEALUNOCOMPL.CODPERIODO FKSDISCGRADALUCOMPL_SDISCGRADER
SREQUISITOALUNO.CODPERIODO FKSREQUISITOALUNO_SDISCGRADEALR
SPERIODOALUNO.CODPERIODO FKSDISCGRADEALUNO_SPERIODOALUNR
CODDISC varchar 20 null
SDISCFILHAALUNO.CODDISC FKSDISCFILHAALUNO_SDISCGRADEALR
SDISCFILHAALUNO.CODDISCFILHA FKSDISCFILHAALFIL_SDISCGRADEALR
SDISCGRADEALUNOCOMPL.CODDISC FKSDISCGRADALUCOMPL_SDISCGRADER
SREQUISITOALUNO.CODDISC FKSREQUISITOALUNO_SDISCGRADEALR
SDISCIPLINA.CODDISC FKSDISCGRADEALUNO_SDISCIPLINAR
DESCRICAO varchar 60 √ null
TIPODISC varchar 2 √ null
CODGRPDISC varchar 6 √ null
SGRUPODISC.CODGRPDISC FKSDISCGRADEALUNO_SGRUPODISCR
NUMCREDITOSCOB RMDVALOR4 17,4 √ null
PERCAULASNAOPRES RMDVALOR4 17,4 √ null
CALCMEDIAGLOBAL varchar 1 √ null
VALORCREDITO RMDVALOR4 17,4 √ null
NUMCREDITOS RMDVALOR4 17,4 √ null
CHDISCIPLINA RMDVALOR4 17,4 √ null
PRIORIDADEMATRICULA int 4 √ null
POSHIST int 4 √ null
PREREQCRED RMDVALOR4 17,4 √ null
NUMMINDISC int 4 √ null
NUMMINCH RMDVALOR4 17,4 √ null
CODFORMULACO varchar 8 √ null
GFORMULA.CODIGO FKSDISCGRADEALUNO_GFORMULAR
CODFORMULAPRE varchar 8 √ null
GFORMULA.CODIGO FKSDISCGRADEALUNOPRE_GFORMULAR
APLICACAO varchar 1 √ null
GFORMULA.APLICACAO FKSDISCGRADEALUNOPRE_GFORMULAR
OBJETIVO varchar 2000 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DISCIPLINATCC varchar 1 √ null
TCCEMGRUPO varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSDISCGRADEALUNO Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDHABILITACAOFILIAL + RA + CODPERIODO + CODDISC
SXSDISCGRADEALUNO Must be unique Asc/Asc/Asc/Asc CODCOLIGADA + IDHABILITACAOFILIAL + RA + CODDISC

Relationships

Close relationships within degrees of separation