Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| FileYear | smallint | 2 | null |
|
|
|||
| FileSemester | smallint | 2 | null |
|
|
|||
| StudentID | int | 4 | null |
|
|
|||
| StudentCampus | varchar | 3 | null |
|
|
|||
| StudentCampusDescription | varchar | 30 | √ | null |
|
|
||
| YearLevel | smallint | 2 | √ | null |
|
|
||
| YearLevelSort | smallint | 2 | null |
|
|
|||
| StudentForm | varchar | 15 | null |
|
|
|||
| StudentFormDescription | varchar | 30 | √ | null |
|
|
||
| StudentHouse | varchar | 5 | null |
|
|
|||
| StudentHouseDescription | varchar | 30 | √ | null |
|
|
||
| NameInternal | varchar | 100 | √ | null |
|
|
||
| NameExternal | varchar | 100 | √ | null |
|
|
||
| LegalFullName | varchar | 150 | √ | null |
|
|
||
| Surname | varchar | 30 | √ | null |
|
|
||
| PreferredName | varchar | 20 | √ | null |
|
|
||
| PreferredFormalName | varchar | 20 | √ | null |
|
|
||
| TimetableCycleDays | tinyint | 1 | √ | null |
|
|
||
| DefinitionPeriodNumber | tinyint | 1 | √ | null |
|
|
||
| DefinitionTimeFrom | datetime | 16,3 | √ | null |
|
|
||
| DefinitionDescription | varchar | 50 | √ | null |
|
|
||
| StudentSubSchool | varchar | 15 | √ | null |
|
|
Table contained 0 rows