UDEFGRADE

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
UALUCURSO.CODCOLIGADA FKUALUCURSO_UDEFGRADER
UATVCOMPGRADE.CODCOLIGADA FKUITEMCURRICULAR_UDEFGRADER
UATVCOMPOFERTAGRADE.CODCOLIGADA FKUATVCOMPOFGRADE_UDEFGRADER
UCURSOPROCSEL.CODCOLIGADA FKUCURSOPROCSEL_UDEFGRADER
UGRADE.CODCOLIGADA FKUGRADE_UDEFGRADER
UGRADECUR.CODCOLIGADA FKUGRADECUR_UDEFGRADER
BOBJETOAVALIADO.CODCOLIGADA FKUDEFGRADE_BOBJETOAVALIADOR
UPERIODOS.CODCOLIGADA FKUDEFGRADE_UPERIODOSR
CODCUR int 4 null
UALUCURSO.CODCUR FKUALUCURSO_UDEFGRADER
UATVCOMPGRADE.CODCUR FKUITEMCURRICULAR_UDEFGRADER
UATVCOMPOFERTAGRADE.CODCUR FKUATVCOMPOFGRADE_UDEFGRADER
UCURSOPROCSEL.CODCUR FKUCURSOPROCSEL_UDEFGRADER
UGRADE.CODCUR FKUGRADE_UDEFGRADER
UGRADECUR.CODCUR FKUGRADECUR_UDEFGRADER
UPERIODOS.CODCUR FKUDEFGRADE_UPERIODOSR
CODPER int 4 null
UALUCURSO.CODPER FKUALUCURSO_UDEFGRADER
UATVCOMPGRADE.CODPER FKUITEMCURRICULAR_UDEFGRADER
UATVCOMPOFERTAGRADE.CODPER FKUATVCOMPOFGRADE_UDEFGRADER
UCURSOPROCSEL.CODPER FKUCURSOPROCSEL_UDEFGRADER
UGRADE.CODPER FKUGRADE_UDEFGRADER
UGRADECUR.CODPER FKUGRADECUR_UDEFGRADER
UPERIODOS.CODPER FKUDEFGRADE_UPERIODOSR
GRADE int 4 null
UALUCURSO.GRADE FKUALUCURSO_UDEFGRADER
UATVCOMPGRADE.GRADE FKUITEMCURRICULAR_UDEFGRADER
UATVCOMPOFERTAGRADE.GRADE FKUATVCOMPOFGRADE_UDEFGRADER
UCURSOPROCSEL.GRADE FKUCURSOPROCSEL_UDEFGRADER
UGRADE.GRADE FKUGRADE_UDEFGRADER
UGRADECUR.GRADE FKUGRADECUR_UDEFGRADER
DESCRICAO varchar 50 null
FORMULA varchar 10 √ null
SEMESTRAL varchar 1 √ null
NUMERODEPERIODOS int 4 √ null
DATAINICIO datetime 16,3 √ null
PFHSTGRADEREMUN.DATAINICIO Implied ConstraintR
DATAFIM datetime 16,3 √ null
CARGAHOR int 4 √ null
NUNDISELETIVA int 4 √ null
NUMDISOPTATIVA int 4 √ null
CHELETIVA RMDVALOR4 17,4 √ null
CHOPTATIVA RMDVALOR4 17,4 √ null
CRELETIVA int 4 √ null
CROPTATIVA int 4 √ null
SEQOBJETOAVALIADO int 4 √ null
BOBJETOAVALIADO.SEQOBJETOAVALIADO FKUDEFGRADE_BOBJETOAVALIADOR
MINGRPATVCOMPS smallint 2 √ null
NUMATVCOMP int 4 √ null
CHATVCOMP RMDVALOR4 17,4 √ null
CRATVCOMP 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)
PKUDEFGRADE Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODCUR + CODPER + GRADE

Relationships

Close relationships within degrees of separation