Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| FileYear | int | 4 | null |
|
|
|||
| StandardNumber | int | 4 | null |
|
|
|||
| StandardVersion | int | 4 | null |
|
|
|||
| StandardLanguage | varchar | 1 | null |
|
|
|||
| StandardType | varchar | 1 | ('') |
|
|
|||
| StandardTitle | varchar | 255 | √ | ('') |
|
|
||
| Level | int | 4 | ((0)) |
|
|
|||
| Credits | int | 4 | ((0)) |
|
|
|||
| FieldCode | int | 4 | ((0)) |
|
|
|||
| FieldName | varchar | 60 | ('') |
|
|
|||
| SubfieldCode | int | 4 | ((0)) |
|
|
|||
| SubfieldName | varchar | 60 | ('') |
|
|
|||
| DomainCode | int | 4 | ((0)) |
|
|
|||
| DomainName | varchar | 60 | ('') |
|
|
|||
| L1Numeracy | varchar | 1 | ('') |
|
|
|||
| L1Literacy | varchar | 1 | ('') |
|
|
|||
| AssessmentOption | varchar | 1 | ('') |
|
|
|||
| MeritPermissible | varchar | 1 | ('') |
|
|
|||
| TranslatedPaperAvailable | varchar | 1 | ('') |
|
|
|||
| TeReoAnswerPermissable | varchar | 1 | ('') |
|
|
|||
| Context | varchar | 1 | ('') |
|
|
|||
| LastAssessmentDate | datetime | 16,3 | √ | null |
|
|
||
| UELiteracyRead | varchar | 1 | ('') |
|
|
|||
| UELiteracyWrite | varchar | 1 | ('') |
|
|
|||
| LatestVersionFlag | bit | 1 | ((0)) |
|
|
|||
| UENumeracy | varchar | 1 | ('') |
|
|
|||
| UEMaoriLiteracyRead | varchar | 1 | ('') |
|
|
|||
| UEMaoriLiteracyWrite | varchar | 1 | ('') |
|
|
|||
| AssessmentRequestIndicator | varchar | 2 | ('') |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_SubjectAssessmentNCEAStandards | Primary key | Asc/Asc/Asc/Asc | FileYear + StandardNumber + StandardVersion + StandardLanguage |