Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| StudentID | int | 4 | null |
|
|
|||
| RecipientID | int | 4 | null |
|
|
|||
| StudentContactType | varchar | 3 | √ | null |
|
|
||
| Relationship | varchar | 100 | √ | null |
|
|
||
| UseEmailCode | varchar | 10 | √ | null |
|
|
||
| UseEmailEmail | varchar | 1000 | null |
|
|
|||
| UseEmailRecipientCount | int | 4 | √ | null |
|
|
||
| UseEmailEmailFlag | bit | 1 | √ | null |
|
|
||
| UseEmailCodeFlag | bit | 1 | √ | null |
|
|
||
| UseSMSCode | varchar | 10 | √ | null |
|
|
||
| UseSMSMobilePhone | varchar | 1000 | null |
|
|
|||
| UseSMSRecipientCount | int | 4 | √ | null |
|
|
||
| UseSMSMobilePhoneFlag | bit | 1 | √ | null |
|
|
||
| UseSMSCodeFlag | bit | 1 | √ | null |
|
|
||
| StudentSurname | varchar | 30 | null |
|
|
|||
| StudentPreferred | varchar | 20 | null |
|
|
|||
| StudentGiven1 | varchar | 20 | null |
|
|
|||
| StudentNameInternal | varchar | 100 | null |
|
|
|||
| StudentGender | varchar | 15 | null |
|
|
|||
| StudentFullFeeFlag | bit | 1 | null |
|
|
|||
| StudentDisabilityFlag | bit | 1 | null |
|
|
|||
| StudentEnglishSecondFlag | bit | 1 | null |
|
|
|||
| StudentEntryDate | datetime | 16,3 | √ | null |
|
|
||
| StudentIndigenousFlag | bit | 1 | null |
|
|
|||
| StudentMedicalAlertFlag | bit | 1 | null |
|
|
|||
| StudentNonResidentFlag | bit | 1 | null |
|
|
|||
| StudentSpecialNeedsFlag | bit | 1 | null |
|
|
|||
| StudentEMAFlag | bit | 1 | null |
|
|
|||
| StudentIntegrationFlag | bit | 1 | null |
|
|
|||
| FileYear | smallint | 2 | null |
|
|
|||
| StudentBoarder | varchar | 3 | null |
|
|
|||
| StudentBoarderDescription | varchar | 30 | √ | null |
|
|
||
| StudentBoarderSynergyMeaning | varchar | 30 | √ | null |
|
|
||
| StudentBoardingHouse | varchar | 15 | null |
|
|
|||
| StudentBoardingHouseDescription | varchar | 30 | √ | null |
|
|
||
| StudentForm | varchar | 15 | null |
|
|
|||
| StudentFormDescription | varchar | 30 | √ | null |
|
|
||
| StudentFormStaffName | varchar | 100 | √ | null |
|
|
||
| StudentHouse | varchar | 5 | null |
|
|
|||
| StudentHouseDescription | varchar | 30 | √ | null |
|
|
||
| StudentIBFlag | bit | 1 | null |
|
|
|||
| StudentLeavingDate | datetime | 16,3 | √ | null |
|
|
||
| StudentStatus | varchar | 3 | null |
|
|
|||
| StudentStatusDescription | varchar | 30 | √ | null |
|
|
||
| StudentStatusSynergyMeaning | varchar | 30 | √ | null |
|
|
||
| StudentCampus | varchar | 3 | null |
|
|
|||
| StudentCampusDescription | varchar | 30 | √ | null |
|
|
||
| StudentTutor | varchar | 15 | null |
|
|
|||
| StudentTutorDescription | varchar | 30 | √ | null |
|
|
||
| StudentTutorName | varchar | 100 | √ | null |
|
|
||
| StudentYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentYearLevelDescription | varchar | 30 | √ | null |
|
|
||
| StudentYearLevelCoordinator | varchar | 30 | √ | null |
|
|
||
| StudentFamilyPosition | smallint | 2 | null |
|
|
|||
| StudentContactLivesWithFlag | bit | 1 | √ | null |
|
|
||
| StudentContactNormalMailFlag | bit | 1 | √ | null |
|
|
||
| StudentContactParentFlag | bit | 1 | √ | null |
|
|
||
| StudentContactReportsFlag | bit | 1 | √ | null |
|
|
||
| StudentContactSpouseFlag | bit | 1 | √ | null |
|
|
||
| RecipientSurname | varchar | 30 | √ | null |
|
|
||
| RecipientPreferred | varchar | 20 | √ | null |
|
|
||
| RecipientGiven1 | varchar | 20 | √ | null |
|
|
||
| RecipientMailNamePrimary | varchar | 100 | √ | null |
|
|
||
| RecipientMailSalutationPrimary | varchar | 100 | √ | null |
|
|
||
| RecipientTitle | varchar | 30 | √ | null |
|
|
||
| RecipientNameExternal | varchar | 100 | √ | null |
|
|
||
| RecipientGender | varchar | 15 | √ | null |
|
|
||
| RecipientDefaultEmailCode | varchar | 1 | √ | null |
|
|
||
| RecipientDefaultEmail | varchar | 201 | √ | null |
|
|
||
| RecipientEmail | varchar | 100 | √ | null |
|
|
||
| RecipientOccupEmail | varchar | 100 | √ | null |
|
|
||
| RecipientDefaultMobilePhoneCode | varchar | 1 | √ | null |
|
|
||
| RecipientDefaultMobilePhone | varchar | 15 | √ | null |
|
|
||
| RecipientMobilePhone | varchar | 15 | √ | null |
|
|
||
| RecipientOccupMobilePhone | varchar | 15 | √ | null |
|
|
||
| LearningPathway | varchar | 30 | null |
|
|
Table contained 0 rows