SDISCGRADE

279 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
LPUBLICSDISCGRADE.CODCOLIGADACLASSIS FKLPUBLICSDISCGRADE_SDISCGRADER
SDISCFILHA.CODCOLIGADA FKSDISCFILHA_SDISCGRADEFILHAR
SDISCGRADECOMPL.CODCOLIGADA FKSDISCGRADECOMPL_SDISCGRADER
SDISCGRADECOMPLDISC.CODCOLIGADA FKSDISCGRCOMPLDISC_SDISCGRADER
SDISCGRADEHABILIDADE.CODCOLIGADA FKSDISCGRADEHABILIDADE_SDISCGR
SEQUIVALENCIADISCGRADE.CODCOLIGADA FKEQUIVDISCGRADE_SDISCGRADER
SREQUISITO.CODCOLIGADA FKSREQUISITO_SDISCGRADER
SGRUPODISC.CODCOLIGADA FKSDISCGRADE_SGRUPODISCR
SGRUPOCOMPLEMENTODISC.CODCOLIGADA FKSDISCGRADE_SGRUPOCOMPLDISCR
SAREACONHECIMENTO.CODCOLIGADA FKSDISCGRADE_SAREACONHECIMENTOR
SPERIODO.CODCOLIGADA FKSDISCGRADE_SPERIODOR
GFORMULA.CODCOLIGADA FKSDISCGRAD_GFORMULA2R
SDISCIPLINA.CODCOLIGADA FKSDISCGRADE_SDISCIPLINAR
CODCURSO varchar 10 null
LPUBLICSDISCGRADE.CODCURSO FKLPUBLICSDISCGRADE_SDISCGRADER
SDISCFILHA.CODCURSO FKSDISCFILHA_SDISCGRADER
SDISCGRADECOMPL.CODCURSO FKSDISCGRADECOMPL_SDISCGRADER
SDISCGRADECOMPLDISC.CODCURSO FKSDISCGRCOMPLDISC_SDISCGRADER
SDISCGRADEHABILIDADE.CODCURSO FKSDISCGRADEHABILIDADE_SDISCGR
SEQUIVALENCIADISCGRADE.CODCURSO FKEQUIVDISCGRADE_SDISCGRADER
SREQUISITO.CODCURSO FKSREQUISITO_SDISCGRADER
SPERIODO.CODCURSO FKSDISCGRADE_SPERIODOR
CODHABILITACAO varchar 10 null
LPUBLICSDISCGRADE.CODHABILITACAO FKLPUBLICSDISCGRADE_SDISCGRADER
SDISCFILHA.CODHABILITACAO FKSDISCFILHA_SDISCGRADEFILHAR
SDISCGRADECOMPL.CODHABILITACAO FKSDISCGRADECOMPL_SDISCGRADER
SDISCGRADECOMPLDISC.CODHABILITACAO FKSDISCGRCOMPLDISC_SDISCGRADER
SDISCGRADEHABILIDADE.CODHABILITACAO FKSDISCGRADEHABILIDADE_SDISCGR
SEQUIVALENCIADISCGRADE.CODHABILITACAO FKEQUIVDISCGRADE_SDISCGRADER
SREQUISITO.CODHABILITACAO FKSREQUISITO_SDISCGRADER
SPERIODO.CODHABILITACAO FKSDISCGRADE_SPERIODOR
CODGRADE varchar 10 null
LPUBLICSDISCGRADE.CODGRADE FKLPUBLICSDISCGRADE_SDISCGRADER
SDISCFILHA.CODGRADE FKSDISCFILHA_SDISCGRADER
SDISCGRADECOMPL.CODGRADE FKSDISCGRADECOMPL_SDISCGRADER
SDISCGRADECOMPLDISC.CODGRADE FKSDISCGRCOMPLDISC_SDISCGRADER
SDISCGRADEHABILIDADE.CODGRADE FKSDISCGRADEHABILIDADE_SDISCGR
SEQUIVALENCIADISCGRADE.CODGRADE FKEQUIVDISCGRADE_SDISCGRADER
SREQUISITO.CODGRADE FKSREQUISITO_SDISCGRADER
SPERIODO.CODGRADE FKSDISCGRADE_SPERIODOR
CODPERIODO smallint 2 null
LPUBLICSDISCGRADE.CODPERIODO FKLPUBLICSDISCGRADE_SDISCGRADER
SDISCFILHA.CODPERIODO FKSDISCFILHA_SDISCGRADEFILHAR
SDISCGRADECOMPL.CODPERIODO FKSDISCGRADECOMPL_SDISCGRADER
SDISCGRADECOMPLDISC.CODPERIODO FKSDISCGRCOMPLDISC_SDISCGRADER
SDISCGRADEHABILIDADE.CODPERIODO FKSDISCGRADEHABILIDADE_SDISCGR
SEQUIVALENCIADISCGRADE.CODPERIODO FKEQUIVDISCGRADE_SDISCGRADER
SREQUISITO.CODPERIODO FKSREQUISITO_SDISCGRADER
SPERIODO.CODPERIODO FKSDISCGRADE_SPERIODOR
CODDISC varchar 20 null
LPUBLICSDISCGRADE.CODDISC FKLPUBLICSDISCGRADE_SDISCGRADER
SDISCFILHA.CODDISC FKSDISCFILHA_SDISCGRADER
SDISCFILHA.CODDISCFILHA FKSDISCFILHA_SDISCGRADEFILHAR
SDISCGRADECOMPL.CODDISC FKSDISCGRADECOMPL_SDISCGRADER
SDISCGRADECOMPLDISC.CODDISC FKSDISCGRCOMPLDISC_SDISCGRADER
SDISCGRADEHABILIDADE.CODDISC FKSDISCGRADEHABILIDADE_SDISCGR
SEQUIVALENCIADISCGRADE.CODDISC FKEQUIVDISCGRADE_SDISCGRADER
SREQUISITO.CODDISC FKSREQUISITO_SDISCGRADER
SDISCIPLINA.CODDISC FKSDISCGRADE_SDISCIPLINAR
CODGRPDISC varchar 6 √ null
SGRUPODISC.CODGRPDISC FKSDISCGRADE_SGRUPODISCR
PREREQCRED numeric 17,4 √ null
POSHIST int 4 √ null
NUMCREDITOSCOB RMDVALOR4 17,4 √ null
DESCRICAO varchar 60 √ null
VALORCREDITO RMDVALOR4 17,4 √ null
TIPODISC varchar 2 √ null
CH RMDVALOR4 17,4 √ null
OBJETIVO varchar 2000 √ null
DECIMAIS int 4 √ null
PERCAULASNAOPRES RMDVALOR4 17,4 √ null
PRIORIDADEMATRICULA int 4 √ null
ATIVIDADE varchar 1 √ ('1')
CALCMEDIAGLOBAL varchar 1 √ ('S')
DESEMPENHOALUNO varchar 1 √ ('S')
IMPBOLETIM varchar 1 √ ('S')
TIPONOTA varchar 1 √ ('N')
NUMMINDISC int 4 √ null
CHDISC RMDVALOR4 17,4 √ null
APLICACAO varchar 1 √ null
GFORMULA.APLICACAO FKSDISCGRADE_GFORMULAR
CODFORMULAPRE varchar 8 √ null
GFORMULA.CODIGO FKSDISCGRADE_GFORMULAR
CODFORMULACO varchar 8 √ null
GFORMULA.CODIGO FKSDISCGRAD_GFORMULA2R
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDGRUPOCOMPLEMENTO int 4 √ null
SGRUPOCOMPLEMENTODISC.IDGRUPOCOMPLEMENTO FKSDISCGRADE_SGRUPOCOMPLDISCR
DISCIPLINATCC varchar 1 √ null
TCCEMGRUPO varchar 1 √ null
CODAREACONHECIMENTO int 4 √ null
SAREACONHECIMENTO.CODAREACONHECIMENTO FKSDISCGRADE_SAREACONHECIMENTOR

Indexes

Constraint Name Type Sort Column(s)
PKSDISCGRADE Primary key Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODCURSO + CODHABILITACAO + CODGRADE + CODPERIODO + CODDISC
SXDISCGRADE Must be unique Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODCURSO + CODHABILITACAO + CODGRADE + CODDISC

Relationships

Close relationships within degrees of separation