Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| wkStudentResultsNZQAStudentsSeq | int identity | 4 | √ | null |
|
|
||
| NZQAID | varchar | 10 | √ | null |
|
|
||
| ID | int | 4 | √ | null |
|
|
||
| NSN | int | 4 | √ | null |
|
|
||
| NSNStr | varchar | 10 | √ | null |
|
|
||
| Surname | varchar | 50 | √ | null |
|
|
||
| Given1 | varchar | 30 | √ | null |
|
|
||
| Given2 | varchar | 50 | √ | null |
|
|
||
| Gender | varchar | 15 | null |
|
|
|||
| BirthDate | datetime | 16,3 | √ | null |
|
|
||
| Ethnicity1 | int | 4 | √ | null |
|
|
||
| Ethnicity2 | int | 4 | √ | null |
|
|
||
| Ethnicity3 | int | 4 | √ | null |
|
|
||
| HighestAttainment | int | 4 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_wkStudentResultsNZQAStudents | Primary key | Asc | wkStudentResultsNZQAStudentsSeq |
| AK_wkStudentResultsNZQAStudents_ID | Performance | Asc/Asc | ID + NSNStr |
| AK_wkStudentResultsNZQAStudents_NSN | Performance | Asc | NSN |