EGRADE

880 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
ECONTEUDOPROG.CODCOLIGADA FKECONTEUDOPROG_EGRADER
EGRADECOMPL.CODCOLIGADA FKEGRADECOMPL_EGRADER
EMATTURMA.CODCOLIGADA FKEMATTURMA_EGRADER
EPLANOENSINO.CODCOLIGADA FKEPLANOENSINO_EGRADER
EPROFRESPONSAVEL.CODCOLIGADA FKEPROFRESPONSAVEL_EGRADER
LPUBLICEGRADE.CODCOLIGADACLASSIS FKLPUBLICEGRADE_EGRADER
GCOLIGADA.CODCOLIGADA FKEGRADE_GCOLIGADAR
CODPERLET varchar 6 null
ECONTEUDOPROG.CODPERLET FKECONTEUDOPROG_EGRADER
EGRADECOMPL.CODPERLET FKEGRADECOMPL_EGRADER
EMATTURMA.CODPERLET FKEMATTURMA_EGRADER
EPLANOENSINO.CODPERLET FKEPLANOENSINO_EGRADER
EPROFRESPONSAVEL.CODPERLET FKEPROFRESPONSAVEL_EGRADER
LPUBLICEGRADE.CODPERLET FKLPUBLICEGRADE_EGRADER
EPERLET.CODPERLET FKEGRADE_EPERLETR
CODCUR int 4 null
ECONTEUDOPROG.CODCUR FKECONTEUDOPROG_EGRADER
EGRADECOMPL.CODCUR FKEGRADECOMPL_EGRADER
EMATTURMA.CODCUR FKEMATTURMA_EGRADER
EPLANOENSINO.CODCUR FKEPLANOENSINO_EGRADER
EPROFRESPONSAVEL.CODCUR FKEPROFRESPONSAVEL_EGRADER
LPUBLICEGRADE.CODCUR FKLPUBLICEGRADE_EGRADER
EPERIODOS.CODCUR FKEGRADE_EPERIODOSR
CODPER int 4 null
ECONTEUDOPROG.CODPER FKECONTEUDOPROG_EGRADER
EGRADECOMPL.CODPER FKEGRADECOMPL_EGRADER
EMATTURMA.CODPER FKEMATTURMA_EGRADER
EPLANOENSINO.CODPER FKEPLANOENSINO_EGRADER
EPROFRESPONSAVEL.CODPER FKEPROFRESPONSAVEL_EGRADER
LPUBLICEGRADE.CODPER FKLPUBLICEGRADE_EGRADER
EPERIODOS.CODPER FKEGRADE_EPERIODOSR
CODMAT varchar 16 null
ECONTEUDOPROG.CODMAT FKECONTEUDOPROG_EGRADER
EGRADECOMPL.CODMAT FKEGRADECOMPL_EGRADER
EMATTURMA.CODMAT FKEMATTURMA_EGRADER
EPLANOENSINO.CODMAT FKEPLANOENSINO_EGRADER
EPROFRESPONSAVEL.CODMAT FKEPROFRESPONSAVEL_EGRADER
LPUBLICEGRADE.CODMAT FKLPUBLICEGRADE_EGRADER
EDISCIPLINAS.CODMAT FKEGRADE_EDISCIPLINASR
NAULASSEM int 4 √ null
VALORAULA int 4 √ null
TIPO int 4 √ null
POSHIST int 4 √ null
TIPONOTA varchar 1 √ null
DECIMAIS int 4 √ null
CARGAHORARIA RMDVALOR2 17,2 √ null
CONTEUDO MEMO 2147483647 √ null
IMPB varchar 1 √ null
USARMELHORESALUNOS varchar 1 √ null
DURACAOAULA int 4 √ null
MATERIAPAI varchar 16 √ null
EDISCIPLINAS.CODMAT FKGRADE_DISCIPLINASR
DECIMAISPROVA int 4 √ null
PERCDISCPAI RMDVALOR4 17,4 √ null
EMENTA MEMO 2147483647 √ null
OBJETIVO MEMO 2147483647 √ null
METODOLOGIAENSINO MEMO 2147483647 √ null
AVALFREQ MEMO 2147483647 √ null
RECURSOS MEMO 2147483647 √ null
BIBLIOGRAFIA MEMO 2147483647 √ null
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)
PKEGRADE Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODPERLET + CODCUR + CODPER + CODMAT
EXGRADEDISC Performance Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODPERLET + CODMAT + CODCUR + CODPER
EXGRADEMATERIAPAI Performance Asc MATERIAPAI

Relationships

Close relationships within degrees of separation