Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| StudentID | int | 4 | null |
|
|
|||
| StudentSurname | varchar | 30 | null |
|
|
|||
| StudentName | varchar | 51 | null |
|
|
|||
| StudentGender | varchar | 15 | null |
|
|
|||
| StudentGiven1 | varchar | 20 | null |
|
|
|||
| StudentGiven2 | varchar | 50 | null |
|
|
|||
| StudentPreferred | varchar | 20 | null |
|
|
|||
| StudentLegalFullName | varchar | 150 | null |
|
|
|||
| StudentStatus | varchar | 3 | null |
|
|
|||
| StudentStatusSynergyMeaning | varchar | 30 | null |
|
|
|||
| StudentBirthDate | datetime | 16,3 | √ | null |
|
|
||
| StudentApplicationDate | datetime | 16,3 | √ | null |
|
|
||
| StudentEntryDate | datetime | 16,3 | √ | null |
|
|
||
| StudentLeftDate | datetime | 16,3 | √ | null |
|
|
||
| StudentLeavingReason | varchar | 3 | null |
|
|
|||
| StudentLeavingDestination | varchar | 15 | null |
|
|
|||
| StudentLeavingDestinationDescription | varchar | 100 | √ | null |
|
|
||
| StudentReturningDate | datetime | 16,3 | √ | null |
|
|
||
| FileYear | int | 4 | √ | null |
|
|
||
| StudentCampus | varchar | 3 | null |
|
|
|||
| StudentYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentYearLevelDescription | varchar | 30 | √ | null |
|
|
||
| StudentYearLevelSort | smallint | 2 | √ | null |
|
|
||
| StudentType | varchar | 7 | null |
|
|
|||
| StudentEnquirySource | varchar | 10 | null |
|
|
|||
| StudentFullFeeFlag | bit | 1 | null |
|
|
|||
| StudentFamilyPosition | int | 4 | null |
|
|
|||
| PreviousSchool | varchar | 15 | null |
|
|
|||
| PreviousSchoolDescription | varchar | 100 | √ | null |
|
|
||
| StudentEmail | varchar | 100 | null |
|
|
|||
| StudentOccupEmail | varchar | 100 | null |
|
|
|||
| StudentSubSchool | varchar | 15 | √ | null |
|
|
||
| ContactID | int | 4 | null |
|
|
|||
| ContactType | varchar | 3 | null |
|
|
|||
| ContactPrimaryOnlyFlag | bit | 1 | null |
|
|
|||
| ContactNormalMailFlag | bit | 1 | null |
|
|
|||
| ContactReportsFlag | bit | 1 | null |
|
|
|||
| ContactParentFlag | bit | 1 | null |
|
|
|||
| ContactLivesWithFlag | bit | 1 | null |
|
|
|||
| ContactMailName | varchar | 100 | null |
|
|
|||
| ContactAddressComma | varchar | 200 | √ | null |
|
|
||
| ContactAddressFull | varchar | 200 | √ | null |
|
|
||
| ContactSurname | varchar | 30 | null |
|
|
|||
| StudentContactSpouseID | int | 4 | null |
|
|
|||
| SudentContactHomeAddressComma | varchar | 200 | √ | null |
|
|
||
| StudentContactHomeAddressFull | varchar | 200 | √ | null |
|
|
||
| StudentContactHomeAddressSameFlag | bit | 1 | null |
|
|
|||
| StudentContactDefaultMobilePhone | varchar | 15 | null |
|
|
|||
| StudentContactDefaultEmail | varchar | 201 | null |
|
|
|||
| StudentContactOccupCompany | varchar | 50 | null |
|
|
|||
| StudentContactOccupDescription | varchar | 50 | null |
|
|
|||
| StudentContactOccupCode | varchar | 15 | √ | null |
|
|
||
| StudentContactOccupPhone | varchar | 15 | null |
|
|
Table contained 0 rows