Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| FileType | varchar | 5 | null |
|
|
|||||
| FileYear | smallint | 2 | null |
|
|
|||||
| FileSemester | smallint | 2 | null |
|
|
|||||
| ClassCampus | varchar | 3 | ('') |
|
|
|||||
| AssessmentCode | varchar | 15 | ('') |
|
|
|||||
| AreaSeq | smallint | 2 | ((0)) |
|
|
|||||
| UnderlayFollowingAreaFlag | bit | 1 | ((0)) |
|
|
|||||
| OverallFlag | bit | 1 | ((0)) |
|
|
|||||
| OverallSeq | smallint | 2 | ((0)) |
|
|
|||||
| ResultEntryFlag | bit | 1 | ((1)) |
|
|
|||||
| ResultPrintFlag | bit | 1 | ((1)) |
|
|
|||||
| CalculatedFieldFlag | bit | 1 | ((0)) |
|
|
|||||
| MarkOutOf | int | 4 | ((0)) |
|
|
|||||
| ResultType | varchar | 15 | ('') |
|
|
|||||
| SummariseToSeq | smallint | 2 | √ | null |
|
|
||||
| AreaBlockEndFlag | bit | 1 | ((0)) |
|
|
|||||
| AutoPickFlag | bit | 1 | ((1)) |
|
|
|||||
| HdgAbbrev1 | varchar | 10 | ('') |
|
|
|||||
| HdgAbbrev2 | varchar | 10 | ('') |
|
|
|||||
| Heading | varchar | 255 | ('') |
|
|
|||||
| Overview | varchar | 2147483647 | √ | null |
|
|
||||
| SubjectAssessmentAreaGUID | int identity | 4 | √ | null |
|
|
||||
| ResultGroup | varchar | 15 | ('') |
|
|
|||||
| ExternalLinkSeq | int | 4 | ((0)) |
|
|
|||||
| DefaultResultClassification | varchar | 15 | ('') |
|
|
|||||
| WeightingFactor | numeric | 10,4 | ((1)) |
|
|
|||||
| ProviderCode | varchar | 15 | ('') |
|
|
|||||
| ContextCode | varchar | 15 | ('') |
|
|
|||||
| ResultMin | decimal | 10,2 | √ | null |
|
|
||||
| ResultMax | decimal | 10,2 | √ | null |
|
|
||||
| ResultAverage | decimal | 10,2 | √ | null |
|
|
||||
| ResultVariance | decimal | 10,2 | √ | null |
|
|
||||
| ResultStandardDeviation | decimal | 10,2 | √ | null |
|
|
||||
| ResultCalculationFormula | varchar | 2000 | ('') |
|
|
|||||
| SubjectAssessmentsSeq | int | 4 | √ | null |
|
|
||||
| ResultCalculationDecimalPlaces | tinyint | 1 | √ | null |
|
|
||||
| ResultCalculationDecimalPlacesFixedFlag | bit | 1 | ((0)) |
|
|
|||||
| ResultCalculationDecimalPlacesTruncateFlag | bit | 1 | ((0)) |
|
|
|||||
| ExpectedResultFlag | bit | 1 | ((0)) |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_SubjectAssessmentAreas | Primary key | Asc/Asc/Asc/Asc/Asc/Asc | FileType + FileYear + FileSemester + ClassCampus + AssessmentCode + AreaSeq |
| AK_SubjectAssessmentAreas_ContectCode | Performance | Asc | ContextCode |
| AK_SubjectAssessmentAreas_ExternalLinkSeq | Performance | Asc | ExternalLinkSeq |
| AK_SubjectAssessmentAreas_ResultGroup | Performance | Asc | ResultGroup |
| AK_SubjectAssessmentAreas_ResultType | Performance | Asc | ResultType |
| AK_SubjectAssessmentAreas_SubjectAssessmentAreaGUID | Must be unique | Asc | SubjectAssessmentAreaGUID |
| AK_SubjectAssessmentAreas_SubjectAssessmentsSeq | Performance | Asc | SubjectAssessmentsSeq |
Relationships
Close relationships within degrees of separation
