Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| StudentID | int | 4 | null |
|
|
|||
| StudentIndigenousFlag | bit | 1 | null |
|
|
|||
| StudentTSIFlag | bit | 1 | null |
|
|
|||
| StudentEntryDate | datetime | 16,3 | √ | null |
|
|
||
| FileYear | smallint | 2 | null |
|
|
|||
| Tutor | varchar | 15 | null |
|
|
|||
| StudentCampus | varchar | 3 | null |
|
|
|||
| StudentForm | varchar | 15 | null |
|
|
|||
| StudentYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentYearLevelSort | smallint | 2 | null |
|
|
|||
| StudentLeavingDate | datetime | 16,3 | √ | null |
|
|
||
| StudentReturningDate | datetime | 16,3 | √ | null |
|
|
||
| StudentNameInternal | varchar | 100 | null |
|
|
|||
| StudentSurname | varchar | 30 | null |
|
|
|||
| StudentGiven1 | varchar | 20 | null |
|
|
|||
| StudentGiven2 | varchar | 50 | null |
|
|
|||
| StudentTitle | varchar | 30 | null |
|
|
|||
| StudentBirthDate | datetime | 16,3 | √ | null |
|
|
||
| StudentGender | varchar | 15 | null |
|
|
|||
| StudentHomeLanguageCode | varchar | 5 | null |
|
|
|||
| StudentPreferred | varchar | 20 | null |
|
|
|||
| StudentCountryOfBirthCode | varchar | 5 | null |
|
|
|||
| StudentAddress1 | varchar | 40 | √ | null |
|
|
||
| StudentAddress2 | varchar | 40 | √ | null |
|
|
||
| StudentAddress3 | varchar | 40 | √ | null |
|
|
||
| StudentSuburb | varchar | 40 | √ | null |
|
|
||
| StudentCountryCode | varchar | 5 | √ | null |
|
|
||
| StudentState | varchar | 5 | √ | null |
|
|
||
| StudentPostCode | varchar | 5 | √ | null |
|
|
||
| StudentPhone | varchar | 15 | √ | null |
|
|
||
| StudentAddressComma | varchar | 200 | √ | null |
|
|
||
| StudentAddressFull | varchar | 200 | √ | null |
|
|
||
| StudentCountryOfBirthExternalSystemCode | varchar | 20 | √ | null |
|
|
||
| StudentCountryOfBirthDescription | varchar | 40 | √ | null |
|
|
||
| StudentCampusExternalSystemCode | varchar | 20 | √ | null |
|
|
||
| FormFieldName | varchar | 50 | √ | null |
|
|
||
| StudentHomeLanguageDescription | varchar | 100 | √ | null |
|
|
||
| Parent1HighestSecondaryYearLevel | tinyint | 1 | √ | null |
|
|
||
| Parent1HighestQualificationLevel | varchar | 15 | √ | null |
|
|
||
| Parent1OccupPositionCode | varchar | 8 | √ | null |
|
|
||
| Parent1HomeLanguageCode | varchar | 5 | √ | null |
|
|
||
| Parent1ID | int | 4 | √ | null |
|
|
||
| Parent1NameInternal | varchar | 100 | √ | null |
|
|
||
| Parent1Given1 | varchar | 20 | √ | null |
|
|
||
| Parent1PreferredName | varchar | 20 | √ | null |
|
|
||
| Parent1Surname | varchar | 30 | √ | null |
|
|
||
| Parent1MailNameJoint | varchar | 100 | √ | null |
|
|
||
| Parent1AddressComma | varchar | 200 | √ | null |
|
|
||
| Parent1AddressFull | varchar | 200 | √ | null |
|
|
||
| Parent2HighestSecondaryYearLevel | tinyint | 1 | √ | null |
|
|
||
| Parent2HighestQualificationLevel | varchar | 15 | √ | null |
|
|
||
| Parent2OccupPositionCode | varchar | 8 | √ | null |
|
|
||
| Parent2HomeLanguageCode | varchar | 5 | √ | null |
|
|
||
| Parent2ID | int | 4 | √ | null |
|
|
||
| Parent2NameInternal | varchar | 100 | √ | null |
|
|
||
| Parent2Given1 | varchar | 20 | √ | null |
|
|
||
| Parent2PreferredName | varchar | 20 | √ | null |
|
|
||
| Parent2Surname | varchar | 30 | √ | null |
|
|
||
| Parent2AddressComma | varchar | 200 | √ | null |
|
|
||
| Parent2AddressFull | varchar | 200 | √ | null |
|
|
||
| MotherHighestSecondaryYearLevel | tinyint | 1 | √ | null |
|
|
||
| MotherHighestQualificationLevel | varchar | 15 | √ | null |
|
|
||
| MotherOccupPositionCode | varchar | 8 | √ | null |
|
|
||
| MotherOccupPositionGroup | varchar | 8 | √ | null |
|
|
||
| MotherHomeLanguageCode | varchar | 5 | √ | null |
|
|
||
| MotherID | int | 4 | √ | null |
|
|
||
| MotherNameInternal | varchar | 100 | √ | null |
|
|
||
| MotherNameGiven1 | varchar | 20 | √ | null |
|
|
||
| MotherNamePreferred | varchar | 20 | √ | null |
|
|
||
| MotherSurname | varchar | 30 | √ | null |
|
|
||
| MotherMailNameJoint | varchar | 100 | √ | null |
|
|
||
| MotherAddressComma | varchar | 200 | √ | null |
|
|
||
| MotherOccupCompany | varchar | 50 | √ | null |
|
|
||
| MotherOccupDesc | varchar | 50 | √ | null |
|
|
||
| FatherHighestSecondaryYearLevel | tinyint | 1 | √ | null |
|
|
||
| FatherHighestQualificationLevel | varchar | 15 | √ | null |
|
|
||
| FatherOccupPositionCode | varchar | 8 | √ | null |
|
|
||
| FatherOccupPositionGroup | varchar | 8 | √ | null |
|
|
||
| FatherHomeLanguageCode | varchar | 5 | √ | null |
|
|
||
| FatherID | int | 4 | √ | null |
|
|
||
| FatherNameInternal | varchar | 100 | √ | null |
|
|
||
| FatherNameGiven1 | varchar | 20 | √ | null |
|
|
||
| FatherNamePreferred | varchar | 20 | √ | null |
|
|
||
| FatherSurname | varchar | 30 | √ | null |
|
|
||
| FatherMailNameJoint | varchar | 100 | √ | null |
|
|
||
| FatherAddressComma | varchar | 200 | √ | null |
|
|
||
| FatherOccupCompany | varchar | 50 | √ | null |
|
|
||
| FatherOccupDesc | varchar | 50 | √ | null |
|
|
||
| StudentFormFieldName | varchar | 50 | √ | null |
|
|
||
| StudentHomeLanguageExternalSystemCode | varchar | 20 | √ | null |
|
|
||
| Parent1HomeLanguageExternalSystemCode | varchar | 20 | √ | null |
|
|
||
| Parent2HomeLanguageExternalSystemCode | varchar | 20 | √ | null |
|
|
||
| MotherHomeLanguageExternalSystemCode | varchar | 20 | √ | null |
|
|
||
| FatherHomeLanguageExternalSystemCode | varchar | 20 | √ | null |
|
|
||
| MotherHomeLanguageDescription | varchar | 100 | √ | null |
|
|
||
| FatherHomeLanguageDescription | varchar | 100 | √ | null |
|
|
||
| Parent1HighestQualificationLevelExternalSystemCode | varchar | 20 | √ | null |
|
|
||
| Parent2HighestQualificationLevelExternalSystemCode | varchar | 20 | √ | null |
|
|
||
| MotherHighestQualificationLevelExternalSystemCode | varchar | 20 | √ | null |
|
|
||
| FatherHighestQualificationLevelExternalSystemCode | varchar | 20 | √ | null |
|
|
||
| Parent1OccupationPositionExternalSystemCode | varchar | 20 | √ | null |
|
|
||
| Parent2OccupationPositionExternalSystemCode | varchar | 20 | √ | null |
|
|
||
| MotherOccupationPositionExternalSystemCode | varchar | 20 | √ | null |
|
|
||
| FatherOccupationPositionExternalSystemCode | varchar | 20 | √ | null |
|
|
Table contained 0 rows