Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int | 4 | null |
|
|
|||
| IDType | varchar | 1 | null |
|
|
|||
| SpouseFlag | bit | 1 | null |
|
|
|||
| NameInternal | varchar | 100 | null |
|
|
|||
| NameExternal | varchar | 100 | null |
|
|
|||
| LegalFullName | varchar | 150 | null |
|
|
|||
| Surname | varchar | 30 | null |
|
|
|||
| SurnamePrevious | varchar | 30 | null |
|
|
|||
| Title | varchar | 30 | null |
|
|
|||
| Initials | varchar | 15 | null |
|
|
|||
| Suffix | varchar | 20 | null |
|
|
|||
| Preferred | varchar | 20 | null |
|
|
|||
| PreferredFormal | varchar | 20 | null |
|
|
|||
| Given1 | varchar | 20 | null |
|
|
|||
| Given2 | varchar | 50 | null |
|
|
|||
| BirthDate | datetime | 16,3 | √ | null |
|
|
||
| DeceasedDate | datetime | 16,3 | √ | null |
|
|
||
| DeceasedFlag | bit | 1 | null |
|
|
|||
| Gender | varchar | 15 | null |
|
|
|||
| MobilePhone | varchar | 15 | null |
|
|
|||
| DefaultMobilePhone | varchar | 15 | null |
|
|
|||
| SilentMobilePhoneFlag | bit | 1 | null |
|
|
|||
| varchar | 100 | null |
|
|
||||
| ReligionCode | varchar | 5 | null |
|
|
|||
| CountryOfBirthCode | varchar | 5 | null |
|
|
|||
| HomeLanguageCode | varchar | 5 | null |
|
|
|||
| NationalityCode | varchar | 5 | null |
|
|
|||
| Nationality2Code | varchar | 5 | null |
|
|
|||
| Education | varchar | 255 | null |
|
|
|||
| Qualifications | varchar | 255 | null |
|
|
|||
| HighestSecondaryYearLevel | tinyint | 1 | null |
|
|
|||
| HighestQualificationLevel | varchar | 15 | null |
|
|
|||
| LastYearOfStudy | int | 4 | null |
|
|
|||
| MaritalStatus | varchar | 1 | null |
|
|
|||
| MailNamePrimary | varchar | 100 | null |
|
|
|||
| MailNameJoint | varchar | 100 | null |
|
|
|||
| MailSalutationPrimary | varchar | 100 | null |
|
|
|||
| MailSalutationJoint | varchar | 100 | null |
|
|
|||
| Comment | varchar | 2147483647 | √ | null |
|
|
||
| Biography | varchar | 2147483647 | √ | null |
|
|
||
| ParishCode | varchar | 5 | null |
|
|
|||
| OccupCode | varchar | 15 | √ | null |
|
|
||
| OccupCodeDesc | varchar | 120 | √ | null |
|
|
||
| OccupDesc | varchar | 50 | null |
|
|
|||
| OccupDescIncludeInAddressFlag | bit | 1 | null |
|
|
|||
| OccupCompany | varchar | 50 | null |
|
|
|||
| OccupCompanyAttn | varchar | 40 | null |
|
|
|||
| OccupIndustryCode | varchar | 8 | null |
|
|
|||
| OccupPositionCode | varchar | 8 | null |
|
|
|||
| OccupPhone | varchar | 15 | null |
|
|
|||
| OccupFax | varchar | 15 | null |
|
|
|||
| OccupEmail | varchar | 100 | null |
|
|
|||
| OccupAddressFull | varchar | 200 | null |
|
|
|||
| OccupAddressComma | varchar | 200 | null |
|
|
|||
| OccupSuburb | varchar | 40 | null |
|
|
|||
| OccupState | varchar | 5 | √ | null |
|
|
||
| OccupCountryCode | varchar | 5 | null |
|
|
|||
| OccupPostCode | varchar | 5 | null |
|
|
|||
| OccupMobilePhone | varchar | 15 | null |
|
|
|||
| SilentOccupMobilePhoneFlag | bit | 1 | null |
|
|
|||
| OccupAddressDPID | varchar | 8 | null |
|
|
|||
| OccupAddressDPIDBarcode | varchar | 60 | null |
|
|
|||
| OccupAddressSortPlanNumber | varchar | 3 | null |
|
|
|||
| OccupAddressPAFVersion | varchar | 10 | null |
|
|
|||
| DirectoryIncludeFlag | bit | 1 | null |
|
|
|||
| DirectoryProvideFlag | bit | 1 | null |
|
|
|||
| PublishToAssociatedFlag | bit | 1 | null |
|
|
|||
| DefaultEmail | varchar | 201 | null |
|
|
|||
| SpouseID | int | 4 | null |
|
|
|||
| WebSite | varchar | 100 | null |
|
|
|||
| SpouseNameInternal | varchar | 100 | √ | null |
|
|
||
| SpouseNameExternal | varchar | 100 | √ | null |
|
|
||
| SpouseLegalFullName | varchar | 150 | √ | null |
|
|
||
| SpouseSurname | varchar | 30 | √ | null |
|
|
||
| SpouseSurnamePrevious | varchar | 30 | √ | null |
|
|
||
| SpouseTitle | varchar | 30 | √ | null |
|
|
||
| SpouseInitials | varchar | 15 | √ | null |
|
|
||
| SpouseSuffix | varchar | 20 | √ | null |
|
|
||
| SpousePreferred | varchar | 20 | √ | null |
|
|
||
| SpousePreferredFormal | varchar | 20 | √ | null |
|
|
||
| SpouseGiven1 | varchar | 20 | √ | null |
|
|
||
| SpouseGiven2 | varchar | 50 | √ | null |
|
|
||
| SpouseBirthDate | datetime | 16,3 | √ | null |
|
|
||
| SpouseDeceasedDate | datetime | 16,3 | √ | null |
|
|
||
| SpouseDeceasedFlag | bit | 1 | √ | null |
|
|
||
| SpouseGender | varchar | 15 | √ | null |
|
|
||
| SpouseMobilePhone | varchar | 15 | √ | null |
|
|
||
| SpouseDefaultMobilePhone | varchar | 15 | √ | null |
|
|
||
| SpouseEmail | varchar | 100 | √ | null |
|
|
||
| SpouseReligionCode | varchar | 5 | √ | null |
|
|
||
| SpouseCountryOfBirthCode | varchar | 5 | √ | null |
|
|
||
| SpouseHomeLanguageCode | varchar | 5 | √ | null |
|
|
||
| SpouseNationalityCode | varchar | 5 | √ | null |
|
|
||
| SpouseNationality2Code | varchar | 5 | √ | null |
|
|
||
| SpouseEducation | varchar | 255 | √ | null |
|
|
||
| SpouseQualifications | varchar | 255 | √ | null |
|
|
||
| SpouseHighestSecondaryYearLevel | tinyint | 1 | √ | null |
|
|
||
| SpouseHighestQualificationLevel | varchar | 15 | √ | null |
|
|
||
| SpouseLastYearOfStudy | int | 4 | √ | null |
|
|
||
| SpouseMaritalStatus | varchar | 1 | √ | null |
|
|
||
| SpouseComment | varchar | 2147483647 | √ | null |
|
|
||
| SpouseBiography | varchar | 2147483647 | √ | null |
|
|
||
| SpouseParishCode | varchar | 5 | √ | null |
|
|
||
| SpouseMailNamePrimary | varchar | 100 | √ | null |
|
|
||
| SpouseMailSalutationPrimary | varchar | 100 | √ | null |
|
|
||
| SpouseOccupAddressFull | varchar | 200 | √ | null |
|
|
||
| SpouseOccupAddressComma | varchar | 200 | √ | null |
|
|
||
| SpouseOccupCode | varchar | 15 | √ | null |
|
|
||
| OccupSpouseCodeDesc | varchar | 120 | √ | null |
|
|
||
| SpouseOccupDesc | varchar | 50 | √ | null |
|
|
||
| SpouseOccupCompany | varchar | 50 | √ | null |
|
|
||
| SpouseOccupCompanyAttn | varchar | 40 | √ | null |
|
|
||
| SpouseOccupIndustryCode | varchar | 8 | √ | null |
|
|
||
| SpouseOccupPositionCode | varchar | 8 | √ | null |
|
|
||
| SpouseOccupPhone | varchar | 15 | √ | null |
|
|
||
| SpouseOccupFax | varchar | 15 | √ | null |
|
|
||
| SpouseOccupEmail | varchar | 100 | √ | null |
|
|
||
| SpouseOccupState | varchar | 5 | √ | null |
|
|
||
| SpouseOccupCountryCode | varchar | 5 | √ | null |
|
|
||
| SpouseOccupPostCode | varchar | 5 | √ | null |
|
|
||
| SpouseOccupMobilePhone | varchar | 15 | √ | null |
|
|
||
| SpouseOccupSuburb | varchar | 40 | √ | null |
|
|
||
| SpouseOccupAddressDPID | varchar | 8 | √ | null |
|
|
||
| SpouseOccupAddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| SpouseOccupAddressSortPlanNumber | varchar | 3 | √ | null |
|
|
||
| SpouseOccupAddressPAFVersion | varchar | 10 | √ | null |
|
|
||
| SpousePublishToAssociatedFlag | bit | 1 | √ | null |
|
|
||
| SpouseDirectoryIncludeFlag | bit | 1 | √ | null |
|
|
||
| SpouseDirectoryProvideFlag | bit | 1 | √ | null |
|
|
||
| SpouseDefaultEmail | varchar | 201 | √ | null |
|
|
||
| SpouseWebSite | varchar | 100 | √ | null |
|
|
||
| AddressID | int | 4 | null |
|
|
|||
| Address1 | varchar | 40 | null |
|
|
|||
| Address2 | varchar | 40 | null |
|
|
|||
| Address3 | varchar | 40 | null |
|
|
|||
| Suburb | varchar | 40 | null |
|
|
|||
| State | varchar | 5 | null |
|
|
|||
| CountryCode | varchar | 5 | null |
|
|
|||
| PostCode | varchar | 5 | null |
|
|
|||
| AddressComma | varchar | 200 | √ | null |
|
|
||
| AddressFull | varchar | 200 | √ | null |
|
|
||
| AddressDPID | varchar | 8 | null |
|
|
|||
| AddressDPIDBarcode | varchar | 60 | null |
|
|
|||
| AddressSortPlanNumber | varchar | 3 | null |
|
|
|||
| AddressPAFVersion | varchar | 10 | null |
|
|
|||
| HomeAddress1 | varchar | 40 | null |
|
|
|||
| HomeAddress2 | varchar | 40 | null |
|
|
|||
| HomeAddress3 | varchar | 40 | null |
|
|
|||
| HomeSuburb | varchar | 40 | null |
|
|
|||
| HomeState | varchar | 5 | null |
|
|
|||
| HomeCountryCode | varchar | 5 | null |
|
|
|||
| HomePostCode | varchar | 5 | null |
|
|
|||
| HomeAddressComma | varchar | 200 | √ | null |
|
|
||
| HomeAddressFull | varchar | 200 | √ | null |
|
|
||
| HomeAddressDPID | varchar | 8 | null |
|
|
|||
| HomeAddressDPIDBarcode | varchar | 60 | null |
|
|
|||
| HomeAddressSortPlanNumber | varchar | 3 | null |
|
|
|||
| HomeAddressPAFVersion | varchar | 10 | null |
|
|
|||
| HomePhone | varchar | 15 | √ | null |
|
|
||
| HomePhoneAlt | varchar | 15 | null |
|
|
|||
| HomeFax | varchar | 15 | null |
|
|
|||
| SilentPhoneFlag | bit | 1 | null |
|
|
|||
| AddressComment | varchar | 250 | null |
|
|
|||
| MailFlag | bit | 1 | null |
|
|
|||
| MagazineFlag | bit | 1 | null |
|
|
|||
| SolicitationFlag | bit | 1 | null |
|
|
|||
| RaffleFlag | bit | 1 | null |
|
|
|||
| ValidAddressFlag | bit | 1 | null |
|
|
|||
| SilentHomeAddressFlag | bit | 1 | null |
|
|
|||
| PhoneActual | varchar | 15 | null |
|
|
|||
| ConstitCodes | varchar | 200 | √ | null |
|
|
||
| WorkWithChildrenCheckStatus | varchar | 15 | null |
|
|
|||
| WorkWithChildrenCheckRegistrationNumber | varchar | 30 | null |
|
|
|||
| WorkWithChildrenCheckExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| SpouseWorkWithChildrenCheckStatus | varchar | 15 | √ | null |
|
|
||
| SpouseWorkWithChildrenCheckRegistrationNumber | varchar | 30 | √ | null |
|
|
||
| SpouseWorkWithChildrenCheckExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| CountryDescription | varchar | 40 | √ | null |
|
|
||
| HomeCountryDescription | varchar | 40 | √ | null |
|
|
||
| OccupCountryDescription | varchar | 40 | √ | null |
|
|
||
| HomeAddressSameFlag | bit | 1 | null |
|
|
|||
| IdamGuid | uniqueidentifier | 16 | √ | null |
|
|
||
| IdamLogin | varchar | 50 | null |
|
|
|||
| Barcode | varchar | 20 | null |
|
|
|||
| CommunityCreatedBy | varchar | 50 | √ | null |
|
|
||
| CommunityCreatedDate | datetime | 16,3 | √ | null |
|
|
||
| CommunityModifiedBy | varchar | 50 | √ | null |
|
|
||
| CommunityModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| CountryCitizenshipCode | varchar | 5 | null |
|
|
|||
| DefaultEmailCode | varchar | 1 | null |
|
|
|||
| DefaultMobilePhoneCode | varchar | 1 | null |
|
|
|||
| EthnicGroup1Code | varchar | 15 | null |
|
|
|||
| EthnicGroup2Code | varchar | 15 | null |
|
|
|||
| EthnicGroup3Code | varchar | 15 | null |
|
|
|||
| Fax | varchar | 15 | null |
|
|
|||
| IndigenousGroup1Code | varchar | 15 | null |
|
|
|||
| IndigenousGroup2Code | varchar | 15 | null |
|
|
|||
| IndigenousGroup3Code | varchar | 15 | null |
|
|
|||
| InitialsOverrideFlag | bit | 1 | null |
|
|
|||
| MailFormat | varchar | 1 | null |
|
|
|||
| MobilePhoneActual | varchar | 15 | null |
|
|
|||
| NetworkLogin | varchar | 100 | null |
|
|
|||
| OccupAddress1 | varchar | 40 | null |
|
|
|||
| OccupAddress2 | varchar | 40 | null |
|
|
|||
| OccupAddress3 | varchar | 40 | null |
|
|
|||
| OccupMobilePhoneActual | varchar | 15 | null |
|
|
|||
| ParkingSpace | varchar | 15 | null |
|
|
|||
| Phone | varchar | 15 | √ | null |
|
|
||
| PhoneAlt | varchar | 15 | null |
|
|
|||
| ReasonFlagChange | varchar | 50 | null |
|
|
|||
| ReasonFlagChangeDate | datetime | 16,3 | √ | null |
|
|
||
| SalutFormat | varchar | 1 | null |
|
|
Table contained 0 rows