Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ActivitySeq | int | 4 | null |
|
|
|||
| ID | int | 4 | √ | null |
|
|
||
| Activity | varchar | 15 | null |
|
|
|||
| ActivityDescription | varchar | 50 | √ | null |
|
|
||
| ActivityDate | datetime | 16,3 | √ | null |
|
|
||
| ActivityStatus | varchar | 15 | null |
|
|
|||
| ActivityStatusDescription | varchar | 50 | √ | null |
|
|
||
| ActivityByID | int | 4 | null |
|
|
|||
| ActivityByPreferred | varchar | 20 | √ | null |
|
|
||
| ActivityBySurname | varchar | 30 | √ | null |
|
|
||
| ActivityByName | varchar | 52 | √ | null |
|
|
||
| FollowUpFlag | bit | 1 | null |
|
|
|||
| FollowUpDate | datetime | 16,3 | √ | null |
|
|
||
| FollowUpID | int | 4 | null |
|
|
|||
| FollowUpPreferred | varchar | 20 | √ | null |
|
|
||
| FollowUpSurname | varchar | 30 | √ | null |
|
|
||
| FollowUpName | varchar | 52 | √ | null |
|
|
||
| Comment | varchar | 8000 | √ | null |
|
|
||
| MailRequestFlag | bit | 1 | null |
|
|
|||
| MailedDate | datetime | 16,3 | √ | null |
|
|
||
| MailedBy | varchar | 50 | null |
|
|
|||
| ActivityCreatedBy | varchar | 50 | null |
|
|
|||
| StudentType | varchar | 7 | null |
|
|
|||
| StudentPreferred | varchar | 20 | √ | null |
|
|
||
| StudentGiven1 | varchar | 20 | √ | null |
|
|
||
| StudentGiven2 | varchar | 50 | √ | null |
|
|
||
| StudentSurname | varchar | 30 | √ | null |
|
|
||
| ContactID | int | 4 | null |
|
|
|||
| ContactPreferred | varchar | 20 | null |
|
|
|||
| ContactSurname | varchar | 30 | null |
|
|
|||
| ContactMobile | varchar | 15 | null |
|
|
|||
| ContactPhone | varchar | 15 | null |
|
|
|||
| ContactAddress | varchar | 200 | null |
|
|
|||
| ContactSpousePreferred | varchar | 20 | null |
|
|
|||
| ContactSpouseSurname | varchar | 30 | null |
|
|
|||
| MailedFlag | int | 4 | null |
|
|
|||
| FutureStudentCampus | varchar | 3 | √ | null |
|
|
||
| FutureStudentGender | varchar | 15 | √ | null |
|
|
||
| FutureStudentYearLevel | smallint | 2 | √ | null |
|
|
||
| FutureStudentHouse | varchar | 5 | √ | null |
|
|
||
| FutureStudentForm | varchar | 15 | √ | null |
|
|
||
| FutureStudentTutor | varchar | 15 | √ | null |
|
|
||
| FutureStudentFullFeeFlag | bit | 1 | √ | null |
|
|
||
| FutureStudentStatus | varchar | 3 | √ | null |
|
|
||
| FutureStudentPriority | varchar | 3 | √ | null |
|
|
||
| FutureStudentEnrolDate | datetime | 16,3 | √ | null |
|
|
||
| FutureStudentBoarder | varchar | 3 | √ | null |
|
|
||
| FutureStudentBoarderType | varchar | 30 | √ | null |
|
|
||
| FutureStudentBoardingHouse | varchar | 15 | √ | null |
|
|
||
| ActivityRequiredForEnrolment | bit | 1 | √ | null |
|
|
||
| ActivitySynergyMeaning | varchar | 15 | √ | null |
|
|
Table contained 0 rows