Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ContactEnquiryID | int | 4 | null |
|
|
|||
| GuessID | int | 4 | null |
|
|
|||
| ID | int | 4 | null |
|
|
|||
| Surname | varchar | 30 | √ | null |
|
|
||
| Title | varchar | 30 | √ | null |
|
|
||
| Initials | varchar | 15 | √ | null |
|
|
||
| Suffix | varchar | 20 | √ | null |
|
|
||
| Preferred | varchar | 20 | √ | null |
|
|
||
| Given1 | varchar | 20 | √ | null |
|
|
||
| Given2 | varchar | 50 | √ | null |
|
|
||
| Gender | varchar | 15 | √ | null |
|
|
||
| Name | varchar | 75 | √ | null |
|
|
||
| MobilePhone | varchar | 15 | √ | null |
|
|
||
| OccupPhone | varchar | 15 | √ | null |
|
|
||
| varchar | 100 | √ | null |
|
|
|||
| SpouseGuessID | int | 4 | null |
|
|
|||
| SpouseID | int | 4 | √ | null |
|
|
||
| SpouseSurname | varchar | 30 | √ | null |
|
|
||
| SpouseTitle | varchar | 30 | √ | null |
|
|
||
| SpouseInitials | varchar | 15 | √ | null |
|
|
||
| SpouseSuffix | varchar | 20 | √ | null |
|
|
||
| SpousePreferred | varchar | 20 | √ | null |
|
|
||
| SpouseGiven1 | varchar | 20 | √ | null |
|
|
||
| SpouseGiven2 | varchar | 50 | √ | null |
|
|
||
| SpouseGender | varchar | 15 | √ | null |
|
|
||
| SpouseName | varchar | 75 | √ | null |
|
|
||
| SpouseMobilePhone | varchar | 15 | √ | null |
|
|
||
| SpouseOccupPhone | varchar | 15 | √ | null |
|
|
||
| SpouseEmail | 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 |
|
|
||
| Phone | varchar | 15 | √ | null |
|
|
||
| PhoneAlt | varchar | 15 | √ | null |
|
|
||
| Fax | varchar | 15 | √ | null |
|
|
||
| MailNamePrimary | varchar | 100 | √ | null |
|
|
||
| MailNameJoint | varchar | 100 | √ | null |
|
|
||
| MailSalutationPrimary | varchar | 100 | √ | null |
|
|
||
| MailSalutationJoint | varchar | 100 | √ | null |
|
|
||
| AddressComma | varchar | 200 | √ | null |
|
|
||
| MailAddressFull | varchar | 200 | √ | null |
|
|
||
| OccupDesc | varchar | 50 | √ | null |
|
|
||
| OccupCompany | varchar | 50 | √ | null |
|
|
||
| AddressDPID | varchar | 8 | √ | null |
|
|
||
| AddressSortPlanNumber | varchar | 3 | √ | null |
|
|
||
| AddressPAFVersion | varchar | 10 | √ | null |
|
|
||
| AddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| Religion | varchar | 5 | √ | null |
|
|
||
| SpouseReligion | varchar | 5 | √ | null |
|
|
||
| ReligionDescription | varchar | 40 | √ | null |
|
|
||
| SpouseReligionDescription | varchar | 40 | √ | null |
|
|
||
| ContactXML | varchar | 2147483647 | null |
|
|
|||
| ContactContactSpouseRelationship | varchar | 5 | null |
|
|
|||
| ContactContactSpouseRelationshipDescription | varchar | 30 | √ | null |
|
|
||
| DefaultEmail | varchar | 201 | √ | null |
|
|
||
| SpouseDefaultEmail | varchar | 201 | √ | null |
|
|
||
| OccupEmail | varchar | 100 | √ | null |
|
|
||
| SpouseOccupEmail | varchar | 100 | √ | null |
|
|
||
| ValidAddressFlag | int | 4 | √ | null |
|
|
||
| DeceasedFlag | bit | 1 | null |
|
|
|||
| MailAddressType | varchar | 1 | √ | null |
|
|
Table contained 0 rows