Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| StudentID | int | 4 | null |
|
|
|||
| 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 |
|
|
|||
| StudentGiven1 | varchar | 20 | null |
|
|
|||
| StudentGiven2 | varchar | 50 | null |
|
|
|||
| StudentBirthDate | datetime | 16,3 | √ | null |
|
|
||
| StudentGender | varchar | 15 | null |
|
|
|||
| StudentName | varchar | 52 | √ | null |
|
|
||
| CurrentScholarship | int | 4 | null |
|
|
|||
| ScholarshipCampus | varchar | 3 | null |
|
|
|||
| Scholarship | varchar | 10 | null |
|
|
|||
| ScholarshipStatus | varchar | 3 | null |
|
|
|||
| ScholarshipYear | smallint | 2 | null |
|
|
|||
| ScholarshipEnquiryDate | datetime | 16,3 | √ | null |
|
|
||
| ScholarshipTestingMark | tinyint | 1 | √ | null |
|
|
||
| ScholarshipTesingDate | datetime | 16,3 | √ | null |
|
|
||
| ScholarshipFinalisedDate | datetime | 16,3 | √ | null |
|
|
||
| ScholarshipComment | varchar | 2147483647 | null |
|
|
|||
| ScholarshipDescription | varchar | 100 | √ | null |
|
|
||
| ScholarchipStatusDescription | varchar | 30 | √ | null |
|
|
||
| StudentEntryDate | datetime | 16,3 | √ | null |
|
|
||
| StudentEntryCampus | varchar | 3 | null |
|
|
|||
| StudentEntryYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentIntendsTertiaryFlag | int | 4 | null |
|
|
|||
| StudentContactType | varchar | 3 | √ | null |
|
|
||
| StudentContactID | int | 4 | √ | null |
|
|
||
| StudentContactLivesWithFlag | bit | 1 | √ | null |
|
|
||
| StudentContactAddressID | int | 4 | √ | null |
|
|
||
| StudentContactDeceasedFlag | bit | 1 | √ | null |
|
|
||
| StudentContactMailName | varchar | 100 | √ | null |
|
|
||
| StudentContactPhone | varchar | 15 | √ | null |
|
|
||
| StudentContactPhoneActual | varchar | 15 | √ | null |
|
|
||
| StudentContactPhoneAlt | varchar | 15 | √ | null |
|
|
||
| StudentContactValidAddressFlag | bit | 1 | √ | null |
|
|
||
| StudentContactAddressComma | varchar | 200 | √ | null |
|
|
||
| StudentContactAddressFull | varchar | 200 | √ | null |
|
|
||
| StudentContactHomeAddressComma | varchar | 200 | √ | null |
|
|
||
| StudentContactHomeAddressFull | varchar | 200 | √ | null |
|
|
||
| FileYear | smallint | 2 | √ | null |
|
|
||
| FileSemester | smallint | 2 | √ | null |
|
|
||
| Status | varchar | 3 | √ | null |
|
|
||
| StatusDescription | varchar | 30 | √ | null |
|
|
||
| StudentCampus | varchar | 3 | √ | null |
|
|
||
| YearLevel | smallint | 2 | √ | null |
|
|
||
| YearLevelSort | smallint | 2 | √ | null |
|
|
||
| House | varchar | 5 | √ | null |
|
|
||
| Form | varchar | 15 | √ | null |
|
|
||
| Tutor | varchar | 15 | √ | null |
|
|
||
| Boarder | varchar | 3 | √ | null |
|
|
||
| BoardingHouse | varchar | 15 | null |
|
|
|||
| FamilyPosition | int | 4 | null |
|
|
|||
| CurrentSemesterOnlyFlag | int | 4 | null |
|
|
|||
| StudentStudiesCode | varchar | 15 | √ | null |
|
|
||
| StudentGovernmentStudentNumber | varchar | 15 | √ | null |
|
|
||
| StudentSubSchool | varchar | 15 | √ | null |
|
|
||
| StudentEntrySubSchool | varchar | 15 | √ | null |
|
|
Table contained 0 rows