UATVCOMPALUNO

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDATVCOMPALUNO int 4 null
UATVCOMPALUNOCOMPL.IDATVCOMPALUNO FKUATVCOMPALCOMPL_UATVCOMPALUNR
CODCOLIGADA DCODCOLIGADA 2 null
UATVCOMPALUNOCOMPL.CODCOLIGADA FKUATVCOMPALCOMPL_UATVCOMPALUNR
UATVCOMPOFERTA.CODCOLIGADA FKUATVCOMPALUNO_UATVCOMPOFERTAR
UATVCOMP.CODCOLIGADA FKUATVCOMPALUNO_UATVCOMPR
UALUCURSO.CODCOLIGADA FKUATVCOMPALUNO_UALUCURSOR
CODGRPATVCOMP int 4 √ null
UATVCOMP.CODGRPATVCOMP FKUATVCOMPALUNO_UATVCOMPR
CODATVCOMP int 4 √ null
UATVCOMP.CODATVCOMP FKUATVCOMPALUNO_UATVCOMPR
IDATVCOMPOFERTA int 4 √ null
UATVCOMPOFERTA.IDATVCOMPOFERTA FKUATVCOMPALUNO_UATVCOMPOFERTAR
MATALUNO varchar 10 null
UALUCURSO.MATALUNO FKUATVCOMPALUNO_UALUCURSOR
CODCUR int 4 null
UALUCURSO.CODCUR FKUATVCOMPALUNO_UALUCURSOR
CODPER int 4 null
UALUCURSO.CODPER FKUATVCOMPALUNO_UALUCURSOR
GRADE int 4 null
UALUCURSO.GRADE FKUATVCOMPALUNO_UALUCURSOR
CODPERLET varchar 6 √ null
EPERLET.CODPERLET FKUATVCOMPALUNO_EPERLETR
CREDITOS int 4 √ null
CARGAHORARIA RMDVALOR4 17,4 √ null
CUMPRIUATIVIDADE varchar 1 √ null
DOCUMENTACAOENTREGUE varchar 1 √ null
DESCRICAO varchar 60 √ null
DATAINSCRICAO datetime 16,3 √ null
OBSERVACOES 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)
PKUATVCOMPALUNO Primary key Asc/Asc CODCOLIGADA + IDATVCOMPALUNO
UXUATVCOMPALUNO Performance Asc/Asc/Asc/Asc/Asc CODCOLIGADA + MATALUNO + CODCUR + CODPER + GRADE

Relationships

Close relationships within degrees of separation