UGRADE

344 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
LPUBLICUGRADE.CODCOLIGADACLASSIS FKLPUBLICUGRADE_UGRADER
UCONTEUDOPROG.CODCOLIGADA FKUCONTEUDOPROG_UGRADER
UEQUIVDISC.CODCOLIGADA FKUEQUIVDISC_UGRADER
UEQUIVDISC.CODCOLIGADAEQ FKUEQUIVDISC_UGRADEEQR
UEQUIVINT.CODCOLIGADA FKUEQUIVINT_UGRADER
UGRADEPRE.CODCOLIGADA FKUGRADEPRE_UGRADEPR
UGRPEQUIV.CODCOLIGADA FKUGRPEQUIV_UGRADER
UGRPEQUIVDISC.CODCOLIGADA FKUGRPEQUIVDISC_UGRADER
UMATTURMA.CODCOLIGADA FKUMATTURMA_UGRADER
UPLANOENSINO.CODCOLIGADA FKUPLANOENSINO_UGRADER
UPROFRESPONSAVEL.CODCOLIGADA FKUPROFRESPONSAVEL_UGRADER
UDEFGRADE.CODCOLIGADA FKUGRADE_UDEFGRADER
UMATERIAS.CODCOLIGADA FKUGRADE_UMATERIASR
CODCUR int 4 null
LPUBLICUGRADE.CODCUR FKLPUBLICUGRADE_UGRADER
UCONTEUDOPROG.CODCUR FKUCONTEUDOPROG_UGRADER
UEQUIVDISC.CODCUR FKUEQUIVDISC_UGRADER
UEQUIVDISC.CODCUREQ FKUEQUIVDISC_UGRADEEQR
UEQUIVINT.CODCURG FKUEQUIVINT_UGRADER
UGRADEPRE.CODCUR FKUGRADEPRE_UGRADER
UGRPEQUIV.CODCUR FKUGRPEQUIV_UGRADER
UGRPEQUIVDISC.CODCUR FKUGRPEQUIVDISC_UGRADER
UMATTURMA.CODCUR FKUMATTURMA_UGRADER
UPLANOENSINO.CODCUR FKUPLANOENSINO_UGRADER
UPROFRESPONSAVEL.CODCUR FKUPROFRESPONSAVEL_UGRADER
UDEFGRADE.CODCUR FKUGRADE_UDEFGRADER
CODPER int 4 null
LPUBLICUGRADE.CODPER FKLPUBLICUGRADE_UGRADER
UCONTEUDOPROG.CODPER FKUCONTEUDOPROG_UGRADER
UEQUIVDISC.CODPER FKUEQUIVDISC_UGRADER
UEQUIVDISC.CODPEREQ FKUEQUIVDISC_UGRADEEQR
UEQUIVINT.CODPERG FKUEQUIVINT_UGRADER
UGRADEPRE.CODPER FKUGRADEPRE_UGRADEPR
UGRPEQUIV.CODPER FKUGRPEQUIV_UGRADER
UGRPEQUIVDISC.CODPER FKUGRPEQUIVDISC_UGRADER
UMATTURMA.CODPER FKUMATTURMA_UGRADER
UPLANOENSINO.CODPER FKUPLANOENSINO_UGRADER
UPROFRESPONSAVEL.CODPER FKUPROFRESPONSAVEL_UGRADER
UDEFGRADE.CODPER FKUGRADE_UDEFGRADER
GRADE int 4 null
LPUBLICUGRADE.GRADE FKLPUBLICUGRADE_UGRADER
UCONTEUDOPROG.GRADE FKUCONTEUDOPROG_UGRADER
UEQUIVDISC.GRADE FKUEQUIVDISC_UGRADER
UEQUIVDISC.GRADEEQ FKUEQUIVDISC_UGRADEEQR
UEQUIVINT.GRADEG FKUEQUIVINT_UGRADER
UGRADEPRE.GRADE FKUGRADEPRE_UGRADER
UGRPEQUIV.GRADE FKUGRPEQUIV_UGRADER
UGRPEQUIVDISC.GRADE FKUGRPEQUIVDISC_UGRADER
UMATTURMA.GRADE FKUMATTURMA_UGRADER
UPLANOENSINO.GRADE FKUPLANOENSINO_UGRADER
UPROFRESPONSAVEL.GRADE FKUPROFRESPONSAVEL_UGRADER
UDEFGRADE.GRADE FKUGRADE_UDEFGRADER
PERIODO int 4 null
CODMAT varchar 16 null
LPUBLICUGRADE.CODMAT FKLPUBLICUGRADE_UGRADER
UCONTEUDOPROG.CODMAT FKUCONTEUDOPROG_UGRADER
UEQUIVDISC.CODMAT FKUEQUIVDISC_UGRADER
UEQUIVDISC.CODMATEQ FKUEQUIVDISC_UGRADEEQR
UEQUIVINT.CODMATG FKUEQUIVINT_UGRADER
UGRADEPRE.CODMAT FKUGRADEPRE_UGRADER
UGRADEPRE.CODMATPRE FKUGRADEPRE_UGRADEPR
UGRPEQUIV.CODMAT FKUGRPEQUIV_UGRADER
UGRPEQUIVDISC.CODMAT FKUGRPEQUIVDISC_UGRADER
UMATTURMA.CODMAT FKUMATTURMA_UGRADER
UPLANOENSINO.CODMAT FKUPLANOENSINO_UGRADER
UPROFRESPONSAVEL.CODMAT FKUPROFRESPONSAVEL_UGRADER
UMATERIAS.CODMAT FKUGRADE_UMATERIASR
CODMATG varchar 16 √ null
TIPO int 4 √ null
TIPODISC varchar 15 √ null
NAULASSEM int 4 √ null
CARGAHORARIA RMDVALOR4 17,4 √ null
NUMCREDITOS int 4 √ null
CONTEUDO MEMO 2147483647 √ null
CREDTES RMDVALOR4 17,4 √ null
GRUPOMATERIA varchar 6 √ null
UGRUPOMAT.CODGRUPMAT FKUGRADE_UGRUPOMATR
VALORCREDITO int 4 √ null
CALCMEDIAGLOBAL varchar 1 √ null
CHESTAGIO RMDVALOR4 17,4 √ null
ORDEMHIST int 4 √ null
NUMMINDISC int 4 √ null
CRDISC int 4 √ null
CHDISC 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
CARGAHORARIAPRATICA numeric 17,4 √ null
CARGAHORARIATEORICA numeric 17,4 √ null
NAULASSEMPRATICA int 4 √ null
NAULASSEMTEORICA int 4 √ 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)
PKUGRADE Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODCUR + CODPER + GRADE + CODMAT
UXCODMATGRADE Performance Asc/Asc CODCUR + CODMAT
UXCODMM Performance Asc/Asc/Asc/Asc/Asc CODCUR + CODPER + GRADE + CODMATG + CODMAT

Relationships

Close relationships within degrees of separation