Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| FutureID | int | 4 | null |
|
|
|||
| RecipientID | int | 4 | null |
|
|
|||
| FutureContactType | 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 |
|
|
||
| FutureSurname | varchar | 30 | null |
|
|
|||
| FuturePreferred | varchar | 20 | null |
|
|
|||
| FutureGiven1 | varchar | 20 | null |
|
|
|||
| FutureNameInternal | varchar | 100 | null |
|
|
|||
| FutureGender | varchar | 15 | null |
|
|
|||
| CurrentStudentFlag | bit | 1 | √ | null |
|
|
||
| FutureBoarder | varchar | 3 | null |
|
|
|||
| FutureBoarderDescription | varchar | 30 | √ | null |
|
|
||
| FutureBoarderSynergyMeaning | varchar | 30 | √ | null |
|
|
||
| FutureBoardingHouse | varchar | 15 | null |
|
|
|||
| FutureBoardingHouseDescription | varchar | 30 | √ | null |
|
|
||
| FutureCampus | varchar | 3 | null |
|
|
|||
| FutureCampusDescription | varchar | 30 | √ | null |
|
|
||
| FutureDisabilityFlag | bit | 1 | null |
|
|
|||
| FutureEnglishSecondFlag | bit | 1 | null |
|
|
|||
| FutureEnquiryDate | datetime | 16,3 | √ | null |
|
|
||
| FutureEnquirySource | varchar | 10 | null |
|
|
|||
| FutureEnrolDate | datetime | 16,3 | √ | null |
|
|
||
| FutureEnrolYear | int | 4 | √ | null |
|
|
||
| FutureForm | varchar | 15 | null |
|
|
|||
| FutureFormDescription | varchar | 30 | √ | null |
|
|
||
| FutureFormStaffName | varchar | 100 | √ | null |
|
|
||
| FutureFullFeeFlag | bit | 1 | null |
|
|
|||
| FutureHouse | varchar | 5 | null |
|
|
|||
| FutureHouseDescription | varchar | 30 | √ | null |
|
|
||
| FutureIBFlag | bit | 1 | null |
|
|
|||
| FutureIndigenousFlag | bit | 1 | null |
|
|
|||
| FutureMedicalAlertFlag | bit | 1 | null |
|
|
|||
| FutureNonResidentFlag | bit | 1 | null |
|
|
|||
| FuturePreviousSchool | varchar | 15 | null |
|
|
|||
| FuturePriority | varchar | 3 | null |
|
|
|||
| FuturePriorityDescription | varchar | 30 | null |
|
|
|||
| FuturePrioritySynergyMeaning | varchar | 15 | null |
|
|
|||
| FutureSpecialNeedsFlag | bit | 1 | null |
|
|
|||
| FutureStatus | varchar | 3 | null |
|
|
|||
| FutureStatusDescription | varchar | 30 | √ | null |
|
|
||
| FutureStatusSynergyMeaning | varchar | 30 | √ | null |
|
|
||
| FutureTutor | varchar | 15 | null |
|
|
|||
| FutureTutorDescription | varchar | 30 | √ | null |
|
|
||
| FutureTutorName | varchar | 100 | √ | null |
|
|
||
| FutureYearLevel | smallint | 2 | √ | null |
|
|
||
| FutureYearLevelDescription | varchar | 30 | √ | null |
|
|
||
| FutureYearLevelCoordinator | varchar | 30 | √ | null |
|
|
||
| FutureEMAFlag | bit | 1 | null |
|
|
|||
| FutureIntegrationFlag | bit | 1 | null |
|
|
|||
| FutureContactLivesWithFlag | bit | 1 | √ | null |
|
|
||
| FutureContactNormalMailFlag | bit | 1 | √ | null |
|
|
||
| FutureContactParentFlag | bit | 1 | √ | null |
|
|
||
| FutureContactReportsFlag | bit | 1 | √ | null |
|
|
||
| FutureContactSpouseFlag | 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