Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int | 4 | null |
|
|
|||
| StudentNameInternal | varchar | 100 | null |
|
|
|||
| StudentNameExternal | varchar | 100 | null |
|
|
|||
| StudentLegalFullName | varchar | 150 | null |
|
|
|||
| StudentSurname | varchar | 30 | null |
|
|
|||
| StudentPreferred | varchar | 20 | null |
|
|
|||
| StudentPreferredFormal | varchar | 20 | null |
|
|
|||
| StudentTitle | varchar | 30 | null |
|
|
|||
| StudentMailNamePrimary | varchar | 100 | null |
|
|
|||
| StudentMailNameJoint | varchar | 100 | null |
|
|
|||
| StudentDisplayName | varchar | 221 | √ | null |
|
|
||
| StudentMailSalutationPrimary | varchar | 100 | null |
|
|
|||
| StudentMailSalutationJoint | varchar | 100 | null |
|
|
|||
| StudentAddressComma | varchar | 200 | √ | null |
|
|
||
| StudentAddressFull | varchar | 200 | √ | null |
|
|
||
| StudentAddressSuburb | varchar | 40 | √ | null |
|
|
||
| StudentAddressPostcode | varchar | 5 | √ | null |
|
|
||
| StudentPhone | varchar | 15 | √ | null |
|
|
||
| StudentMobilePhone | varchar | 15 | null |
|
|
|||
| StudentDefaultMobilePhone | varchar | 15 | null |
|
|
|||
| StudentFax | varchar | 15 | √ | null |
|
|
||
| StudentID | int | 4 | null |
|
|
|||
| StudentForm | varchar | 30 | √ | null |
|
|
||
| StudentHouse | varchar | 30 | √ | null |
|
|
||
| StudentTutorGroup | varchar | 30 | √ | null |
|
|
||
| StudentStaffName | varchar | 100 | √ | null |
|
|
||
| StudentHomeroomTutor | varchar | 100 | √ | null |
|
|
||
| StudentYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentContactNameInternal | varchar | 100 | null |
|
|
|||
| StudentContactNameExternal | varchar | 100 | null |
|
|
|||
| StudentContactLegalFullName | varchar | 150 | null |
|
|
|||
| StudentContactSurname | varchar | 30 | null |
|
|
|||
| StudentContactPreferred | varchar | 20 | null |
|
|
|||
| StudentContactPreferredFormal | varchar | 20 | null |
|
|
|||
| StudentContactTitle | varchar | 30 | null |
|
|
|||
| StudentContactMailNamePrimary | varchar | 100 | null |
|
|
|||
| StudentContactMailNameJoint | varchar | 100 | null |
|
|
|||
| StudentContactDisplayName | varchar | 221 | √ | null |
|
|
||
| StudentContactMailSalutationPrimary | varchar | 100 | null |
|
|
|||
| StudentContactMailSalutationJoint | varchar | 100 | null |
|
|
|||
| StudentContactAddressComma | varchar | 200 | √ | null |
|
|
||
| StudentContactAddressFull | varchar | 200 | √ | null |
|
|
||
| StudentContactAddressSuburb | varchar | 40 | √ | null |
|
|
||
| StudentContactAddressPostcode | varchar | 5 | √ | null |
|
|
||
| StudentContactPhone | varchar | 15 | √ | null |
|
|
||
| StudentContactMobilePhone | varchar | 15 | null |
|
|
|||
| StudentContactDefaultEmail | varchar | 201 | null |
|
|
|||
| StudentContactFax | varchar | 15 | √ | null |
|
|
||
| StudentContactOccupDesc | varchar | 50 | null |
|
|
|||
| StudentContactOccupCompany | varchar | 50 | null |
|
|
|||
| StudentContactOccupAddressFull | varchar | 200 | null |
|
|
|||
| StudentContactOccupAddressComma | varchar | 200 | null |
|
|
|||
| StudentContactOccupPhone | varchar | 15 | null |
|
|
|||
| StudentContactOccupMobilePhone | varchar | 15 | null |
|
|
|||
| StudentContactOccupFax | varchar | 15 | null |
|
|
|||
| StudentContactOccupSuburb | varchar | 40 | null |
|
|
|||
| StudentContactOccupState | varchar | 5 | √ | null |
|
|
||
| StudentContactOccupPostCode | varchar | 5 | null |
|
|
|||
| StudentContactID | int | 4 | null |
|
|
|||
| StudentContactDefaultMobilePhone | varchar | 15 | √ | null |
|
|
Table contained 0 rows