SubjectClassResultGroups


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SubjectClassResultGroupsNumber int identity 4 √ null
FileType varchar 5 null
FileYear smallint 2 null
FileSemester smallint 2 null
ClassCampus varchar 3 ('')
ClassCode varchar 15 ('')
ResultGroup varchar 15 ('')
GroupClass varchar 25 ('')
OverrideFlag bit 1 ((0))
OverrideMean decimal 7,2 ((0))
OverrideStandardDeviation decimal 7,2 ((0))
OverrideType varchar 1 ('N')
OverrideMax decimal 7,2 ((0))
OverrideMin decimal 7,2 ((0))
StudentCount int 4 ((0))
CalibreMean decimal 7,2 ((0))
CalibreStandardDeviation decimal 7,2 ((0))
ScaledMean decimal 7,2 ((0))
ScaledStandardDeviation decimal 7,2 ((0))
ScaledMax decimal 7,2 ((0))
ScaledMin decimal 7,2 ((0))
GroupStudentCount int 4 ((0))
GroupCalibreMean decimal 7,2 ((0))
GroupCalibreStandardDeviation decimal 7,2 ((0))
GroupScaledMean decimal 7,2 ((0))
GroupScaledStandardDeviation decimal 7,2 ((0))
GroupScaledMax decimal 7,2 ((0))
GroupScaledMin decimal 7,2 ((0))
DiffMean decimal 7,2 ((0))
DiffStandardDeviation decimal 7,2 ((0))
GroupDiffMean decimal 7,2 ((0))
GroupDiffStandardDeviation decimal 7,2 ((0))

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_SubjectClassResultGroups Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc FileType + FileYear + FileSemester + ClassCampus + ClassCode + ResultGroup + GroupClass
AK_SubjectClassResultGroups_SubjectClassResultGroupsNumber Must be unique Asc SubjectClassResultGroupsNumber