Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| StaffID | int | 4 | null |
|
|
|||
| StaffTitle | varchar | 30 | √ | null |
|
|
||
| StaffInitials | varchar | 15 | √ | null |
|
|
||
| StaffSurname | varchar | 30 | √ | null |
|
|
||
| StaffGiven1 | varchar | 20 | √ | null |
|
|
||
| StaffGiven2 | varchar | 50 | √ | null |
|
|
||
| StaffPreferred | varchar | 20 | √ | null |
|
|
||
| StaffPreferredFormal | varchar | 20 | √ | null |
|
|
||
| StaffNameInternal | varchar | 100 | √ | null |
|
|
||
| StaffNameExternal | varchar | 100 | √ | null |
|
|
||
| StaffLegalFullName | varchar | 150 | √ | null |
|
|
||
| StaffGender | varchar | 15 | √ | null |
|
|
||
| StaffBirthDate | datetime | 16,3 | √ | null |
|
|
||
| SpouseID | int | 4 | √ | null |
|
|
||
| SpouseRelationsship | varchar | 30 | √ | null |
|
|
||
| StaffSpouseTitle | varchar | 30 | null |
|
|
|||
| StaffSpouseInitials | varchar | 15 | null |
|
|
|||
| StaffSpuseSurname | varchar | 30 | null |
|
|
|||
| StaffSpouseGiven1 | varchar | 20 | null |
|
|
|||
| StaffSpouseGiven2 | varchar | 50 | null |
|
|
|||
| StaffSpousePreferred | varchar | 20 | null |
|
|
|||
| StaffSpousePreferredFormal | varchar | 20 | null |
|
|
|||
| StaffSpouseNameInternal | varchar | 100 | null |
|
|
|||
| StaffSpouseNameExternal | varchar | 100 | null |
|
|
|||
| StaffSpouseLegalFullName | varchar | 150 | null |
|
|
|||
| StaffSpouseGender | varchar | 15 | null |
|
|
|||
| StaffSpouseBirthDate | datetime | 16,3 | null |
|
|
|||
| StaffEmail | varchar | 100 | √ | null |
|
|
||
| StaffOccupEmail | varchar | 100 | √ | null |
|
|
||
| StaffDefaultMobilePhone | varchar | 15 | √ | null |
|
|
||
| StaffOccupMobilePhone | varchar | 15 | √ | null |
|
|
||
| StaffSpouseEmail | varchar | 100 | null |
|
|
|||
| StaffSpouseOccupEmail | varchar | 100 | null |
|
|
|||
| StaffSpouseMobilePhone | varchar | 15 | null |
|
|
|||
| StaffSpouseOccupMobilePhone | varchar | 15 | null |
|
|
|||
| StaffPhoneSilentFlag | bit | 1 | √ | null |
|
|
||
| StaffHomePhone | varchar | 15 | √ | null |
|
|
||
| StaffPhoneActual | varchar | 15 | √ | null |
|
|
||
| StaffPhoneAlt | varchar | 15 | √ | null |
|
|
||
| StaffAddressComma | varchar | 200 | √ | null |
|
|
||
| StaffAddressFull | varchar | 200 | √ | null |
|
|
||
| StaffHomeAddressSameFlag | bit | 1 | √ | null |
|
|
||
| StaffHomeAddressComma | varchar | 200 | √ | null |
|
|
||
| StaffHomeAddressFull | varchar | 200 | √ | null |
|
|
||
| ShowCourtOrderFlag | varchar | 2147483647 | null |
|
|
|||
| StaffCourtOrderType | varchar | 15 | √ | null |
|
|
||
| StaffCourtOrderTypeDescription | varchar | 50 | √ | null |
|
|
||
| StaffCourtOrderDetails | varchar | 2147483647 | √ | null |
|
|
||
| StaffCourtOrderDate | datetime | 16,3 | √ | null |
|
|
||
| StaffPrivacyPolicyAgreedFlag | bit | 1 | √ | null |
|
|
||
| StaffSpouseCourtOrderType | varchar | 15 | √ | null |
|
|
||
| StaffSpouseCourtOrderTypeDescription | varchar | 50 | √ | null |
|
|
||
| StaffSpouseCourtOrderDetails | varchar | 2147483647 | √ | null |
|
|
||
| StaffSpouseCourtOrderDate | datetime | 16,3 | √ | null |
|
|
||
| StaffSpousePrivacyPolicyAgreedFlag | bit | 1 | √ | null |
|
|
Table contained 0 rows