Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pk_ID | int | 4 | null |
|
|
|||
| SpouseID | int | 4 | null |
|
|
|||
| ConstitCode | varchar | 15 | null |
|
|
|||
| Title | varchar | 30 | null |
|
|
|||
| Given1 | varchar | 20 | null |
|
|
|||
| Given2 | varchar | 50 | null |
|
|
|||
| NameInternal | varchar | 100 | null |
|
|
|||
| NameExternal | varchar | 100 | null |
|
|
|||
| LegalFullName | varchar | 150 | null |
|
|
|||
| Preferred | varchar | 20 | null |
|
|
|||
| PreferredFormal | varchar | 20 | null |
|
|
|||
| Surname | varchar | 30 | null |
|
|
|||
| Suffix | varchar | 20 | null |
|
|
|||
| Initials | varchar | 15 | null |
|
|
|||
| BirthDate | datetime | 16,3 | √ | null |
|
|
||
| Gender | varchar | 15 | null |
|
|
|||
| MailNamePrimary | varchar | 100 | null |
|
|
|||
| MailSalutationPrimary | varchar | 100 | null |
|
|
|||
| Address1 | varchar | 40 | null |
|
|
|||
| Address2 | varchar | 40 | null |
|
|
|||
| Address3 | varchar | 40 | null |
|
|
|||
| Suburb | varchar | 40 | null |
|
|
|||
| State | varchar | 5 | null |
|
|
|||
| PostCode | varchar | 5 | null |
|
|
|||
| CountryCode | varchar | 5 | null |
|
|
|||
| CountryDescription | varchar | 40 | √ | null |
|
|
||
| Phone | varchar | 15 | √ | null |
|
|
||
| OccupPhone | varchar | 15 | null |
|
|
|||
| MobilePhone | varchar | 15 | null |
|
|
|||
| DefaultMobilePhone | varchar | 15 | null |
|
|
|||
| OccupMobilePhone | varchar | 15 | null |
|
|
|||
| DefaultEmail | varchar | 100 | null |
|
|
|||
| NetworkLogin | varchar | 100 | null |
|
|
|||
| StudentStatus | varchar | 3 | √ | null |
|
|
||
| StudentLeavingDate | datetime | 16,3 | √ | null |
|
|
||
| StudentAltCode | varchar | 15 | √ | null |
|
|
||
| StudentEntryCampus | varchar | 3 | √ | null |
|
|
||
| StudentEntryYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentEntryDate | datetime | 16,3 | √ | null |
|
|
||
| StudentYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentFamilyPosition | smallint | 2 | √ | null |
|
|
||
| StudentBoarder | varchar | 3 | √ | null |
|
|
||
| StudentHouse | varchar | 5 | √ | null |
|
|
||
| StudentHouseDescription | varchar | 30 | √ | null |
|
|
||
| StaffActiveFlag | bit | 1 | √ | null |
|
|
||
| StaffStartDate | datetime | 16,3 | √ | null |
|
|
||
| StaffExtension | varchar | 15 | √ | null |
|
|
||
| StaffHouse | varchar | 5 | √ | null |
|
|
||
| StaffHouseDescription | varchar | 30 | √ | null |
|
|
||
| StaffDepartment | varchar | 15 | √ | null |
|
|
||
| StaffDepartmentDescription | varchar | 80 | √ | null |
|
|
||
| StaffBuilding | varchar | 15 | √ | null |
|
|
||
| StaffBuildingDescription | varchar | 50 | √ | null |
|
|
||
| StaffRoom | varchar | 15 | √ | null |
|
|
||
| StaffRoomDescription | varchar | 50 | √ | null |
|
|
||
| StaffCategory | varchar | 15 | √ | null |
|
|
||
| StaffCategoryDescription | varchar | 50 | √ | null |
|
|
||
| SchoolStaffCode | varchar | 30 | √ | null |
|
|
||
| StaffCampus | varchar | 3 | √ | null |
|
|
||
| CurrentParentContactType | varchar | 3 | √ | null |
|
|
||
| CurrentParentNormalMailFlag | int | 4 | √ | null |
|
|
||
| CurrentParentReportsFlag | int | 4 | √ | null |
|
|
||
| CurrentParentLivesWithFlag | int | 4 | √ | null |
|
|
||
| StudentBoarderDescription | varchar | 30 | √ | null |
|
|
||
| StudentBoardingHouse | varchar | 15 | √ | null |
|
|
||
| StudentBoardingHouseDescription | varchar | 50 | √ | null |
|
|
||
| StudentBoarderParentFlag | int | 4 | null |
|
|
|||
| ParentList | varchar | 8000 | √ | null |
|
|
||
| StudentList | varchar | 8000 | √ | null |
|
|
||
| JobPositionDescription | varchar | 80 | √ | null |
|
|
||
| OccupFax | varchar | 15 | null |
|
|
|||
| OccupEmail | varchar | 100 | null |
|
|
Table contained 0 rows