Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int | 4 | null |
|
|
|||
| Surname | varchar | 30 | null |
|
|
|||
| Title | varchar | 30 | null |
|
|
|||
| Preferred | varchar | 20 | null |
|
|
|||
| Given1 | varchar | 20 | null |
|
|
|||
| OccupPositionCode | varchar | 8 | null |
|
|
|||
| BirthDate | nvarchar | 200 | √ | null |
|
|
||
| DeceasedDate | nvarchar | 200 | √ | null |
|
|
||
| Gender | varchar | 15 | null |
|
|
|||
| MobilePhone | varchar | 15 | null |
|
|
|||
| varchar | 100 | null |
|
|
||||
| ReligionCode | varchar | 5 | null |
|
|
|||
| CountryOfBirthCode | varchar | 5 | null |
|
|
|||
| HomeLanguageCode | varchar | 5 | null |
|
|
|||
| HighestSecondaryYearlevel | tinyint | 1 | null |
|
|
|||
| MailNameJoint | varchar | 100 | null |
|
|
|||
| NetworkLogin | varchar | 100 | null |
|
|
|||
| CountryCitizenshipCode | varchar | 5 | null |
|
|
|||
| HighestQualificationLevel | varchar | 15 | null |
|
|
|||
| OverideLegalSurname | varchar | 30 | null |
|
|
|||
| OccupEmail | varchar | 100 | null |
|
|
|||
| CommunityGUID | varchar | 32 | null |
|
|
|||
| IsStaff | int | 4 | null |
|
|
|||
| StartDate | nvarchar | 200 | √ | null |
|
|
||
| RegistrationNumber | varchar | 15 | √ | null |
|
|
||
| IdamGUID | uniqueidentifier | 16 | √ | null |
|
|
||
| IdamLogin | varchar | 50 | null |
|
|
|||
| AddressID | int | 4 | √ | null |
|
|
||
| SpouseID | int | 4 | null |
|
|
|||
| SpouseFlag | bit | 1 | null |
|
|
Table contained 0 rows