Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| FileYear | smallint | 2 | √ | null |
|
|
||
| FileSemester | smallint | 2 | √ | null |
|
|
||
| StudentID | int | 4 | null |
|
|
|||
| StudentTitle | varchar | 30 | √ | null |
|
|
||
| StudentInitials | varchar | 15 | √ | null |
|
|
||
| StudentSurname | varchar | 30 | √ | null |
|
|
||
| StudentGiven1 | varchar | 20 | √ | null |
|
|
||
| StudentGiven2 | varchar | 50 | √ | null |
|
|
||
| StudentPreferred | varchar | 20 | √ | null |
|
|
||
| StudentPreferredFormal | varchar | 20 | √ | null |
|
|
||
| StudentNameInternal | varchar | 100 | √ | null |
|
|
||
| StudentNameExternal | varchar | 100 | √ | null |
|
|
||
| StudentLegalFullName | varchar | 150 | √ | null |
|
|
||
| StudentFamilyPosition | smallint | 2 | null |
|
|
|||
| StudentGender | varchar | 15 | √ | null |
|
|
||
| StudentBirthDate | datetime | 16,3 | √ | null |
|
|
||
| StudentNationalityDescription | varchar | 30 | √ | null |
|
|
||
| StudentCountryOfBirthDescription | varchar | 40 | √ | null |
|
|
||
| StudentHomeLanguageDescription | varchar | 100 | √ | null |
|
|
||
| StudentParishDescription | varchar | 50 | √ | null |
|
|
||
| StudentReligionDescription | varchar | 40 | √ | null |
|
|
||
| StudentMobilePhone | varchar | 15 | √ | null |
|
|
||
| StudentEmail | varchar | 100 | √ | null |
|
|
||
| StudentPhoneSilentFlag | bit | 1 | √ | null |
|
|
||
| StudentPhone | varchar | 15 | √ | null |
|
|
||
| StudentPhoneActual | varchar | 15 | √ | null |
|
|
||
| StudentPhoneAlt | varchar | 15 | √ | null |
|
|
||
| StudentHomeEmail | varchar | 100 | √ | null |
|
|
||
| StudentAddressComma | varchar | 200 | √ | null |
|
|
||
| StudentAddressFull | varchar | 200 | √ | null |
|
|
||
| StudentHomeAddressSameFlag | bit | 1 | √ | null |
|
|
||
| StudentHomeAddressComma | varchar | 200 | √ | null |
|
|
||
| StudentHomeAddressFull | varchar | 200 | √ | null |
|
|
||
| ShowCourtOrderFlag | varchar | 2147483647 | null |
|
|
|||
| ParentsSeparatedFlag | bit | 1 | √ | null |
|
|
||
| ParentsSeparatedReason | varchar | 200 | √ | null |
|
|
||
| CourtOrderType | varchar | 15 | √ | null |
|
|
||
| CourtOrderTypeDescription | varchar | 50 | √ | null |
|
|
||
| CourtOrderDetails | varchar | 2147483647 | √ | null |
|
|
||
| CourtOrderDate | datetime | 16,3 | √ | null |
|
|
||
| PrivacyPolicyAgreedFlag | bit | 1 | √ | null |
|
|
||
| StudentContactType | varchar | 3 | √ | null |
|
|
||
| StudentContactDescription | varchar | 30 | √ | null |
|
|
||
| StudentContactParentFlag | bit | 1 | √ | null |
|
|
||
| StudentContactLivesWithFlag | bit | 1 | √ | null |
|
|
||
| StudentContactPrimaryOnlyFlag | bit | 1 | √ | null |
|
|
||
| StudentContactID | int | 4 | √ | null |
|
|
||
| StudentContactRelationship | varchar | 30 | null |
|
|
|||
| StudentContactGender | varchar | 15 | null |
|
|
|||
| StudentContactBirthDate | datetime | 16,3 | √ | null |
|
|
||
| StudentContactTitle | varchar | 30 | null |
|
|
|||
| StudentContactInitials | varchar | 15 | √ | null |
|
|
||
| StudentContactSurname | varchar | 30 | √ | null |
|
|
||
| StudentContactGiven1 | varchar | 20 | √ | null |
|
|
||
| StudentContactGiven2 | varchar | 50 | null |
|
|
|||
| StudentContactPreferred | varchar | 20 | √ | null |
|
|
||
| StudentContactHomeAddressComma | varchar | 200 | √ | null |
|
|
||
| StudentContactHomeAddressFull | varchar | 200 | √ | null |
|
|
||
| StudentContactHomeAddressSameFlag | bit | 1 | √ | null |
|
|
||
| StudentContactMailName | varchar | 100 | √ | null |
|
|
||
| StudentContactMailSalutation | varchar | 100 | √ | null |
|
|
||
| StudentContactAddressComma | varchar | 200 | √ | null |
|
|
||
| StudentContactAddressFull | varchar | 200 | √ | null |
|
|
||
| StudentContactPreferredFormal | varchar | 20 | √ | null |
|
|
||
| StudentContactNameInternal | varchar | 100 | √ | null |
|
|
||
| StudentContactNameExternal | varchar | 100 | √ | null |
|
|
||
| StudentContactLegalFullName | varchar | 150 | √ | null |
|
|
||
| StudentContactDefaultMobilePhone | varchar | 15 | √ | null |
|
|
||
| StudentContactMobilePhone | varchar | 15 | √ | null |
|
|
||
| StudentContactPhoneActual | varchar | 15 | √ | null |
|
|
||
| StudentContactHomePhone | varchar | 15 | √ | null |
|
|
||
| StudentContactHomePhoneAlt | varchar | 15 | √ | null |
|
|
||
| StudentContactOccupMobilePhone | varchar | 15 | √ | null |
|
|
||
| StudentContactOccupPhone | varchar | 15 | √ | null |
|
|
||
| StudentContactDefaultEmail | varchar | 201 | √ | null |
|
|
||
| StudentContactEmail | varchar | 100 | √ | null |
|
|
||
| StudentContactOccupCompany | varchar | 50 | null |
|
|
|||
| StudentContactOccupType | varchar | 50 | null |
|
|
|||
| StudentContactOccupCode | varchar | 15 | null |
|
|
|||
| StudentContactOccupDescription | varchar | 120 | null |
|
|
|||
| StudentContactOccupFax | varchar | 15 | null |
|
|
|||
| StudentContactOccupEmail | varchar | 100 | null |
|
|
|||
| StudentContactSpouseID | int | 4 | √ | null |
|
|
||
| StudentContactSpouseRelationship | varchar | 30 | null |
|
|
|||
| StudentContactSpouseGender | varchar | 15 | null |
|
|
|||
| StudentContactSpouseBirthDate | datetime | 16,3 | √ | null |
|
|
||
| StudentContactSpouseTitle | varchar | 30 | null |
|
|
|||
| StudentContactSpouseInitials | varchar | 15 | null |
|
|
|||
| StudentContactSpouseSurname | varchar | 30 | null |
|
|
|||
| StudentContactSpouseGiven1 | varchar | 20 | null |
|
|
|||
| StudentContactSpouseGiven2 | varchar | 50 | null |
|
|
|||
| StudentContactSpousePreferred | varchar | 20 | null |
|
|
|||
| StudentContactSpousePreferredFormal | varchar | 20 | null |
|
|
|||
| StudentContactSpouseNameInternal | varchar | 100 | null |
|
|
|||
| StudentContactSpouseNameExternal | varchar | 100 | null |
|
|
|||
| StudentContactSpouseLegalFullName | varchar | 150 | null |
|
|
|||
| StudentContactSpouseDefaultMobilePhone | varchar | 15 | null |
|
|
|||
| StudentContactSpouseMobilePhone | varchar | 15 | null |
|
|
|||
| StudentContactSpouseOccupMobilePhone | varchar | 15 | null |
|
|
|||
| StudentContactSpouseOccupPhone | varchar | 15 | null |
|
|
|||
| StudentContactSpouseDefaultEmail | varchar | 201 | null |
|
|
|||
| StudentContactSpouseEmail | varchar | 100 | null |
|
|
|||
| StudentContactSpouseOccupCompany | varchar | 50 | null |
|
|
|||
| StudentContactSpouseOccupType | varchar | 50 | null |
|
|
|||
| StudentContactSpouseOccupCode | varchar | 15 | null |
|
|
|||
| StudentContactSpouseOccupDescription | varchar | 120 | null |
|
|
|||
| StudentContactSpouseOccupFax | varchar | 15 | null |
|
|
|||
| StudentContactSpouseOccupEmail | varchar | 100 | null |
|
|
Table contained 0 rows