SFREQUENCIA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SJUSTIFICATIVAFALTA.CODCOLIGADA FKSFREQUENCIA_SJUSTIFICATIVAFAR
SMATRICULA.CODCOLIGADA FKSFREQUENCIA_SMATRICULAR
SHORARIOTURMA.CODCOLIGADA FKSFREQUENCIA_SHORARIOTURMAR
IDHORARIOTURMA int 4 null
SHORARIOTURMA.IDHORARIOTURMA FKSFREQUENCIA_SHORARIOTURMAR
IDTURMADISC int 4 null
SMATRICULA.IDTURMADISC FKSFREQUENCIA_SMATRICULAR
RA varchar 20 null
SMATRICULA.RA FKSFREQUENCIA_SMATRICULAR
DATA datetime 16,3 null
PRESENCA char 1 null
JUSTIFICADA varchar 1 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDJUSTIFICATIVAFALTA int 4 √ null
SJUSTIFICATIVAFALTA.IDJUSTIFICATIVAFALTA FKSFREQUENCIA_SJUSTIFICATIVAFAR

Indexes

Constraint Name Type Sort Column(s)
PKSFREQUENCIA Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDHORARIOTURMA + IDTURMADISC + RA + DATA
IX_SFREQ_PKMATRICULA Performance Asc/Asc/Asc CODCOLIGADA + IDTURMADISC + RA

Relationships

Close relationships within degrees of separation