UALUCURSO

162 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
UATVCOMPALUNO.CODCOLIGADA FKUATVCOMPALUNO_UALUCURSOR
UHISTMATALUN.CODCOLIGADA FKUHISTMATALUN_UALUCURSOR
UMATRICPL.CODCOLIGADA FKUMATRICPL_UALUCURSOR
UPROFALUNO.CODCOLIGADA FKUPROFALUNO_UALUCURSOR
UPROTOCOLOS.CODCOLIGADA FKUPROTOCOLOS_UALUCURSOR
EALUNOS.CODCOLIGADA FKUALUCURSO_EALUNOSR
UDEFGRADE.CODCOLIGADA FKUALUCURSO_UDEFGRADER
MATALUNO varchar 10 null
UATVCOMPALUNO.MATALUNO FKUATVCOMPALUNO_UALUCURSOR
UHISTMATALUN.MATALUNO FKUHISTMATALUN_UALUCURSOR
UMATRICPL.MATALUNO FKUMATRICPL_UALUCURSOR
UPROFALUNO.MATALUNO FKUPROFALUNO_UALUCURSOR
UPROTOCOLOS.MATALUNO FKUPROTOCOLOS_UALUCURSOR
EALUNOS.MATRICULA FKUALUCURSO_EALUNOSR
CODCUR int 4 null
UATVCOMPALUNO.CODCUR FKUATVCOMPALUNO_UALUCURSOR
UHISTMATALUN.CODCUR FKUHISTMATALUN_UALUCURSOR
UMATRICPL.CODCUR FKUMATRICPL_UALUCURSOR
UPROFALUNO.CODCUR FKUPROFALUNO_UALUCURSOR
UPROTOCOLOS.CODCUR FKUPROTOCOLOS_UALUCURSOR
UDEFGRADE.CODCUR FKUALUCURSO_UDEFGRADER
CODPER int 4 null
UATVCOMPALUNO.CODPER FKUATVCOMPALUNO_UALUCURSOR
UHISTMATALUN.CODPER FKUHISTMATALUN_UALUCURSOR
UMATRICPL.CODPER FKUMATRICPL_UALUCURSOR
UPROFALUNO.CODPER FKUPROFALUNO_UALUCURSOR
UPROTOCOLOS.CODPER FKUPROTOCOLOS_UALUCURSOR
UDEFGRADE.CODPER FKUALUCURSO_UDEFGRADER
GRADE int 4 null
UATVCOMPALUNO.GRADE FKUATVCOMPALUNO_UALUCURSOR
UHISTMATALUN.GRADE FKUHISTMATALUN_UALUCURSOR
UMATRICPL.GRADE FKUMATRICPL_UALUCURSOR
UPROFALUNO.GRADE FKUPROFALUNO_UALUCURSOR
UPROTOCOLOS.GRADE FKUPROTOCOLOS_UALUCURSOR
UDEFGRADE.GRADE FKUALUCURSO_UDEFGRADER
CODTUN int 4 √ null
ETURNOS.CODTURNO FKUALUCURSO_ETURNOSR
ANOCONC2GRAU varchar 8 √ null
COLEGIO2GRAU int 4 √ null
ECOLEGIOS.CODINST FKUALUCURSO_ECOLEGIOSR
TIPO2GRAU varchar 2 √ null
UTIP2GRAU.CODTIPO2GRAU FKUALUCURSO_UTIP2GRAUR
TIPOINGRESSO int 4 √ null
UTABINGRS.CODTIPING FKUALUCURSO_UTABINGRSR
DATAINGRESSO varchar 8 √ null
ENTVESTIBULAR varchar 60 √ null
PONTOSVESTIBULAR varchar 10 √ null
STATUS varchar 2 √ null
USITMAT.CODSITMAT FKUALUCURSO_USITMATR
STATUSANT varchar 2 √ null
USITMAT.CODSITMAT FKUALUCURSO_USITMAT1R
MOTALTSTATUS int 4 √ null
PERLETCOLGRAU varchar 6 √ null
DATAALTSTATUS datetime 16,3 √ null
DATACOLACAOGRAU datetime 16,3 √ null
DATAEMISDIPLOMA datetime 16,3 √ null
COLEGIOTEMP varchar 50 √ null
CIDADECOLTEMP varchar 30 √ null
UFCOLTEMP varchar 2 √ null
CLASSIFICACAOVESTIB int 4 √ null
MEDIAPONTOSVESTIB RMDVALOR4 17,4 √ null
NUMREGISTROCONCL varchar 30 √ null
NUMFOLHAREG varchar 10 √ null
NUMLIVROREG varchar 10 √ null
DATACONCLUSAOCURSO datetime 16,3 √ null
CR RMDVALOR4 17,4 √ null
MEDIAGLOBAL RMDVALOR4 17,4 √ null
MEDIAGLOBALAPROVADAS RMDVALOR4 17,4 √ null
MATERIASFALT int 4 √ null
PERCMATFALT RMDVALOR2 17,2 √ null
PERIODOSFALT int 4 √ null
CODFACTRANSFER int 4 √ null
ECOLEGIOS.CODINST FKUALUCURSO_ECOLEGIOSFR
DTPROVAO datetime 16,3 √ null
CONFPROVAO varchar 1 √ null
MATELETIVAFALT RMDVALOR4 17,4 √ null
PERCELETIVAFALT RMDVALOR2 17,2 √ null
MATOPTATIVAFALT RMDVALOR4 17,4 √ null
PERCOPTATIVAFALT RMDVALOR2 17,2 √ null
DATASOLICITACAOALT datetime 16,3 √ null
MATATVCOMPFALT RMDVALOR4 17,4 √ null
PERCATVCOMPFALT RMDVALOR2 17,2 √ null
INSTREGDIPLOMA int 4 √ null
ECOLEGIOS.CODINST FKUALUCURSO_ECOLEGIOSDIPR
PROCESSOREGISTRO varchar 50 √ null
OBSERVACAO MEMO 2147483647 √ null
DATAREGISTRODIPLOMA datetime 16,3 √ 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)
PKUALUCURSO Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + MATALUNO + CODCUR + CODPER + GRADE

Relationships

Close relationships within degrees of separation