Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| StudentSurname | varchar | 30 | √ | null |
|
|
||
| StudentPreferred | varchar | 20 | √ | null |
|
|
||
| StudentGiven1 | varchar | 20 | √ | null |
|
|
||
| StudentGiven2 | varchar | 50 | √ | null |
|
|
||
| StudentGender | varchar | 15 | √ | null |
|
|
||
| StudentDOB | datetime | 16,3 | √ | null |
|
|
||
| StudentCountryOfBirth | varchar | 5 | √ | null |
|
|
||
| StudentTitle | varchar | 30 | √ | null |
|
|
||
| StudentAppliedResidencyFlag | bit | 1 | √ | null |
|
|
||
| StudentCitizenship | varchar | 5 | √ | null |
|
|
||
| OnlineImportApplicationsSeq | int | 4 | null |
|
|
|||
| StudentEnrolDate | datetime | 16,3 | √ | null |
|
|
||
| StudentCampus | varchar | 3 | √ | null |
|
|
||
| StudentYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentEnquirySource | varchar | 10 | √ | null |
|
|
||
| StudentEnquirySourceComment | varchar | 2147483647 | √ | null |
|
|
||
| StudentPreviousSchool | varchar | 15 | √ | null |
|
|
||
| StudentVisaNumber | varchar | 20 | √ | null |
|
|
||
| StudentPassportCountryCode | varchar | 5 | √ | null |
|
|
||
| StudentPassportExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| StudentCountryOfApplicationCode | varchar | 5 | √ | null |
|
|
||
| StudentReligion | varchar | 5 | √ | null |
|
|
||
| StudentParish | varchar | 5 | √ | null |
|
|
||
| StudentMobile | varchar | 20 | √ | null |
|
|
||
| StudentEmail | varchar | 50 | √ | null |
|
|
||
| StudentYearOfEntry | int | 4 | √ | null |
|
|
||
| StudentVSNNumber | varchar | 20 | √ | null |
|
|
||
| StudentCatholicNotification | bit | 1 | √ | null |
|
|
||
| StudentAddress1 | varchar | 30 | √ | null |
|
|
||
| StudentAddress2 | varchar | 30 | √ | null |
|
|
||
| StudentAddress3 | varchar | 30 | √ | null |
|
|
||
| StudentVisaCode | varchar | 30 | √ | null |
|
|
||
| ContactSurname | varchar | 30 | √ | null |
|
|
||
| ContactTitle | varchar | 30 | √ | null |
|
|
||
| ContactPreferred | varchar | 20 | √ | null |
|
|
||
| ContactGiven1 | varchar | 20 | √ | null |
|
|
||
| ContactGiven2 | varchar | 50 | √ | null |
|
|
||
| ContactGender | varchar | 15 | √ | null |
|
|
||
| ContactCountryOfBirthCode | varchar | 5 | √ | null |
|
|
||
| ContactMobilePhone | varchar | 15 | √ | null |
|
|
||
| ContactEmail | varchar | 100 | √ | null |
|
|
||
| ContactOccupPhone | varchar | 15 | √ | null |
|
|
||
| ContactOccupCompany | varchar | 50 | √ | null |
|
|
||
| ContactSpouseSurname | varchar | 30 | √ | null |
|
|
||
| ContactSpouseTitle | varchar | 30 | √ | null |
|
|
||
| ContactSpousePreferred | varchar | 20 | √ | null |
|
|
||
| ContactSpouseGiven1 | varchar | 20 | √ | null |
|
|
||
| ContactSpouseGiven2 | varchar | 50 | √ | null |
|
|
||
| ContactSpouseGender | varchar | 15 | √ | null |
|
|
||
| ContactSpouseCountryOfBirthCode | varchar | 5 | √ | null |
|
|
||
| ContactSpouseMobilePhone | varchar | 15 | √ | null |
|
|
||
| ContactSpouseEmail | varchar | 100 | √ | null |
|
|
||
| ContactSpouseOccupPhone | varchar | 15 | √ | null |
|
|
||
| ContactSpouseOccupCompany | varchar | 50 | √ | null |
|
|
||
| HomeAddress1 | varchar | 40 | √ | null |
|
|
||
| HomeAddress2 | varchar | 40 | √ | null |
|
|
||
| HomeAddress3 | varchar | 40 | √ | null |
|
|
||
| HomeSuburb | varchar | 40 | √ | null |
|
|
||
| HomeState | varchar | 5 | √ | null |
|
|
||
| HomeCountryCode | varchar | 5 | √ | null |
|
|
||
| HomePostCode | varchar | 5 | √ | null |
|
|
||
| ContactPhone | varchar | 15 | √ | null |
|
|
||
| ContactPhoneAlt | varchar | 15 | √ | null |
|
|
||
| ContactFax | varchar | 15 | √ | null |
|
|
||
| ContactReligion | varchar | 5 | √ | null |
|
|
||
| ContactSpouseReligion | varchar | 5 | √ | null |
|
|
||
| ContactRelationship | varchar | 5 | √ | null |
|
|
||
| ContactSpouseRelationship | varchar | 5 | √ | null |
|
|
||
| Comment | varchar | 2147483647 | √ | null |
|
|
||
| Boarder | varchar | 3 | √ | null |
|
|
||
| UniqueId | varchar | 40 | null |
|
|
Table contained 0 rows