Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int | 4 | null |
|
|
|||
| NameInternal | varchar | 100 | null |
|
|
|||
| NameExternal | varchar | 100 | null |
|
|
|||
| LegalFullName | varchar | 150 | null |
|
|
|||
| Surname | varchar | 30 | null |
|
|
|||
| Title | varchar | 30 | null |
|
|
|||
| Initials | varchar | 15 | null |
|
|
|||
| Preferred | varchar | 20 | null |
|
|
|||
| PreferredFormal | varchar | 20 | null |
|
|
|||
| Given1 | varchar | 20 | null |
|
|
|||
| Given2 | varchar | 50 | null |
|
|
|||
| BirthDate | datetime | 16,3 | √ | null |
|
|
||
| Gender | varchar | 15 | null |
|
|
|||
| MobilePhone | varchar | 15 | null |
|
|
|||
| DefaultMobilePhone | varchar | 15 | null |
|
|
|||
| OccupMobilePhone | varchar | 15 | null |
|
|
|||
| varchar | 100 | null |
|
|
||||
| Education | varchar | 255 | null |
|
|
|||
| HighestSecondaryYearLevel | tinyint | 1 | null |
|
|
|||
| LastYearOfStudy | int | 4 | null |
|
|
|||
| MailNamePrimary | varchar | 100 | null |
|
|
|||
| QualificationExistsFlag | int | 4 | null |
|
|
|||
| QualificationSeq | int | 4 | √ | null |
|
|
||
| QualificationCode | varchar | 15 | √ | null |
|
|
||
| QualificationCodeDescription | varchar | 80 | √ | null |
|
|
||
| QualificationQualificationLevel | varchar | 15 | √ | null |
|
|
||
| QualificationLevelDescription | varchar | 80 | √ | null |
|
|
||
| QualificationRegistrationCode | varchar | 20 | √ | null |
|
|
||
| QualificationDescription | varchar | 80 | √ | null |
|
|
||
| QualificationComment | varchar | 2147483647 | √ | null |
|
|
||
| QualificationAttainedDate | datetime | 16,3 | √ | null |
|
|
||
| QualificationMajor1 | varchar | 100 | √ | null |
|
|
||
| QualificationMajor2 | varchar | 100 | √ | null |
|
|
||
| QualificationMinor1 | varchar | 100 | √ | null |
|
|
||
| QualificationMinor2 | varchar | 100 | √ | null |
|
|
||
| QualificationExpectedAttainmentYear | smallint | 2 | √ | null |
|
|
||
| QualificationTrainingProviderCode | varchar | 15 | √ | null |
|
|
||
| AddressFull | varchar | 200 | √ | null |
|
|
||
| AddressComma | varchar | 200 | √ | null |
|
|
||
| ValidAddressFlag | bit | 1 | null |
|
|
|||
| StaffFlag | int | 4 | null |
|
|
|||
| StaffSchoolStaffCode | varchar | 30 | √ | null |
|
|
||
| StaffRegSchoolsBoardCode | varchar | 15 | √ | null |
|
|
||
| StaffRegistrationNumber | varchar | 15 | √ | null |
|
|
||
| StaffRegistrationType | varchar | 15 | √ | null |
|
|
||
| StaffRegistrationExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| StaffStartDate | datetime | 16,3 | √ | null |
|
|
||
| StaffCampus | varchar | 3 | √ | null |
|
|
||
| StaffForm | varchar | 15 | √ | null |
|
|
||
| StaffBuilding | varchar | 15 | √ | null |
|
|
||
| StaffRoom | varchar | 15 | √ | null |
|
|
||
| StaffCategory | varchar | 15 | √ | null |
|
|
||
| StaffExtension | varchar | 15 | √ | null |
|
|
||
| StaffDepartmentCode | varchar | 15 | √ | null |
|
|
||
| StaffLeavingDate | datetime | 16,3 | √ | null |
|
|
||
| StaffDepartmentCampus | varchar | 3 | √ | null |
|
|
||
| StaffDepartmentDescription | varchar | 80 | √ | null |
|
|
||
| StaffDepartmentLocation | varchar | 100 | √ | null |
|
|
||
| StaffDepartmentHeadOfDepartment | varchar | 50 | √ | null |
|
|
Table contained 0 rows