Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ContactEnquiryID | int identity | 4 | √ | null |
|
|
||
| GuessID | int | 4 | ((0)) |
|
|
|||
| ID | int | 4 | ((0)) |
|
|
|||
| Surname | varchar | 30 | ('') |
|
|
|||
| Title | varchar | 30 | ('') |
|
|
|||
| Initials | varchar | 10 | ('') |
|
|
|||
| Suffix | varchar | 20 | ('') |
|
|
|||
| Preferred | varchar | 20 | ('') |
|
|
|||
| Given1 | varchar | 20 | ('') |
|
|
|||
| Given2 | varchar | 50 | ('') |
|
|
|||
| Gender | varchar | 15 | ('') |
|
|
|||
| MobilePhone | varchar | 15 | ('') |
|
|
|||
| OccupPhone | varchar | 15 | ('') |
|
|
|||
| varchar | 100 | √ | ('') |
|
|
|||
| SpouseGuessID | int | 4 | ((0)) |
|
|
|||
| SpouseID | int | 4 | ((0)) |
|
|
|||
| SpouseSurname | varchar | 30 | ('') |
|
|
|||
| SpouseTitle | varchar | 30 | ('') |
|
|
|||
| SpouseInitials | varchar | 10 | ('') |
|
|
|||
| SpouseSuffix | varchar | 20 | ('') |
|
|
|||
| SpousePreferred | varchar | 20 | ('') |
|
|
|||
| SpouseGiven1 | varchar | 20 | ('') |
|
|
|||
| SpouseGiven2 | varchar | 50 | ('') |
|
|
|||
| SpouseGender | varchar | 15 | ('') |
|
|
|||
| SpouseMobilePhone | varchar | 15 | ('') |
|
|
|||
| SpouseOccupPhone | varchar | 15 | ('') |
|
|
|||
| SpouseEmail | varchar | 100 | √ | ('') |
|
|
||
| AddressID | int | 4 | ((0)) |
|
|
|||
| Address1 | varchar | 40 | ('') |
|
|
|||
| Address2 | varchar | 40 | ('') |
|
|
|||
| Address3 | varchar | 40 | ('') |
|
|
|||
| Suburb | varchar | 40 | ('') |
|
|
|||
| State | varchar | 5 | ('') |
|
|
|||
| CountryCode | varchar | 5 | ('') |
|
|
|||
| PostCode | varchar | 5 | ('') |
|
|
|||
| Phone | varchar | 15 | ('') |
|
|
|||
| PhoneAlt | varchar | 15 | ('') |
|
|
|||
| Fax | varchar | 15 | ('') |
|
|
|||
| MailNamePrimary | varchar | 100 | ('') |
|
|
|||
| MailNameJoint | varchar | 100 | ('') |
|
|
|||
| MailSalutationPrimary | varchar | 100 | ('') |
|
|
|||
| MailSalutationJoint | varchar | 100 | ('') |
|
|
|||
| AddressComma | varchar | 200 | ('') |
|
|
|||
| MailAddressType | varchar | 1 | √ | null |
|
|
||
| MailAddressFull | varchar | 200 | √ | null |
|
|
||
| OccupDesc | varchar | 50 | √ | null |
|
|
||
| OccupCompany | varchar | 50 | √ | null |
|
|
||
| AddressDPID | varchar | 8 | ('') |
|
|
|||
| AddressSortPlanNumber | varchar | 3 | ('') |
|
|
|||
| AddressPAFVersion | varchar | 10 | ('') |
|
|
|||
| AddressDPIDBarcode | varchar | 60 | ('') |
|
|
|||
| ContactXML | varchar | 2147483647 | ('') |
|
|
|||
| Religion | varchar | 5 | ('') |
|
|
|||
| ContactContactSpouseRelationship | varchar | 5 | ('') |
|
|
|||
| SpouseReligion | varchar | 5 | ('') |
|
|
|||
| ExternalValidationFlag | bit | 1 | ((0)) |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__EnquiryStudentCo__5729AA24 | Primary key | Asc | ContactEnquiryID |
| AK_EnquiryContacts_AddressID | Performance | Asc | AddressID |
| AK_EnquiryContacts_ID | Performance | Asc | ID |
| AK_EnquiryContacts_Preferred | Performance | Asc | Preferred |
| AK_EnquiryContacts_spGiven1 | Performance | Asc | SpouseGiven1 |
| AK_EnquiryContacts_SpouseID | Performance | Asc | SpouseID |
| AK_EnquiryContacts_spSurname | Performance | Asc | SpouseSurname |
| AK_EnquiryContacts_Surname | Performance | Asc | Surname |