UDATAAVAL

99 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
UMATTURMA.CODCOLIGADA FKUDATAAVAL_UMATTURMAR
CODFILIAL DCODCOLIGADA 2 null
UMATTURMA.CODFILIAL FKUDATAAVAL_UMATTURMAR
CODPERLET varchar 6 null
UETAPAS.CODPERLET FKUDATAAVAL_UETAPASR
UMATTURMA.CODPERLET FKUDATAAVAL_UMATTURMAR
CODMAT varchar 16 null
UMATTURMA.CODMAT FKUDATAAVAL_UMATTURMAR
CODTUR varchar 16 null
UMATTURMA.CODTUR FKUDATAAVAL_UMATTURMAR
NUMPROVA varchar 10 null
PONTCONC varchar 6 √ null
PONTNUM RMDVALOR4 17,4 √ null
AULASPREVISTAS int 4 √ null
AULASDADAS int 4 √ null
TOTALTURMA RMDVALOR4 17,4 √ null
USUARDIGNOTAS varchar 10 √ null
TOTALFALTAS int 4 √ null
USUARDIGFALTAS varchar 10 √ null
USUARDIGPROVAS varchar 10 √ null
DATAPROVA datetime 16,3 √ null
DATADIGNOTAS datetime 16,3 √ null
DATADIGFALTAS datetime 16,3 √ null
HORAPROVA datetime 16,3 √ null
NOTAFALTA varchar 1 null
UETAPAS.NOTAFALTA FKUDATAAVAL_UETAPASR
CODETAPA int 4 null
UETAPAS.CODETAPA FKUDATAAVAL_UETAPASR
MEDIAPROVA RMDVALOR4 17,4 √ null
DESCRICAO varchar 100 √ null
OBSERVACAO MEMO 2147483647 √ null
DTLIMITENOTASWEB datetime 16,3 √ null
DTINICIOCONSNOTAWEB datetime 16,3 √ null
DISPONIVELWEB varchar 1 √ 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)
PKUDATAAVAL Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODFILIAL + CODPERLET + CODMAT + CODTUR + CODETAPA + NOTAFALTA + NUMPROVA
UXUDATAAVAL Performance Asc/Asc/Asc/Asc CODPERLET + CODMAT + CODTUR + NUMPROVA

Relationships

Close relationships within degrees of separation