Timetable


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TimetableSeq int identity 4 √ null
FileType varchar 5 ('A')
FileYear smallint 2 ((0))
FileSemester smallint 2 ((0))
DayNumber tinyint 1 ((0))
PeriodNumber tinyint 1 ((0))
TimetableDate datetime 16,3 √ null
ClassCampus varchar 3 ('')
ClassCode varchar 15 ('')
StudentID int 4 ((0))
StaffID int 4 ((0))
Room varchar 15 ('')
TimetableGroup varchar 5 ('')
SIF3RefID uniqueidentifier 16 (newid())

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_SubjectClassTimetable Primary key Asc TimetableSeq
AK_Timetable_FileType_FileYear_FileSemester_ClassCode_TimetableGroup_includes Performance Asc/Asc/Asc/Asc/Asc FileType + FileYear + FileSemester + ClassCode + TimetableGroup
AK_Timetable_FileYear_FileSemester_includes Performance Asc/Asc FileYear + FileSemester
AK_Timetable_FileYear_FileSemester_PeriodNumber_includes Performance Asc/Asc/Asc FileYear + FileSemester + PeriodNumber
AK_Timetable_FileYear_FileSemester_TimetableGroup_includes Performance Asc/Asc/Asc FileYear + FileSemester + TimetableGroup
AK_TimetableClass Performance Asc/Asc/Asc/Asc DayNumber + PeriodNumber + ClassCampus + ClassCode
AK_TimetableKey Performance Asc/Asc/Asc/Asc/Asc/Asc FileType + FileYear + FileSemester + TimetableGroup + DayNumber + PeriodNumber
AK_TimetableRoom Performance Asc/Asc/Asc Room + DayNumber + PeriodNumber
AK_TimetableStaff Performance Asc/Asc/Asc StaffID + DayNumber + PeriodNumber
AK_TimetableStudent Performance Asc/Asc/Asc StudentID + DayNumber + PeriodNumber