Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OnlineImportContactsSeq | int identity | 4 | √ | null |
|
|
||||||
| Surname | varchar | 30 | ('') |
|
|
|||||||
| Title | varchar | 30 | ('') |
|
|
|||||||
| Suffix | varchar | 20 | ('') |
|
|
|||||||
| Preferred | varchar | 20 | ('') |
|
|
|||||||
| Given1 | varchar | 20 | ('') |
|
|
|||||||
| Given2 | varchar | 50 | ('') |
|
|
|||||||
| Gender | varchar | 15 | ('') |
|
|
|||||||
| MobilePhone | varchar | 15 | ('') |
|
|
|||||||
| OccupPhone | varchar | 15 | ('') |
|
|
|||||||
| varchar | 100 | ('') |
|
|
||||||||
| SpouseID | int | 4 | ((0)) |
|
|
|||||||
| SpouseSurname | varchar | 30 | ('') |
|
|
|||||||
| SpouseTitle | varchar | 30 | ('') |
|
|
|||||||
| 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 | ('') |
|
|
|||||||
| 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 | ('') |
|
|
|||||||
| OccupDesc | varchar | 50 | ('') |
|
|
|||||||
| OccupCompany | varchar | 50 | ('') |
|
|
|||||||
| ContactXML | varchar | 2147483647 | ('') |
|
|
|||||||
| RelationshipToSpouse | varchar | 5 | ('') |
|
|
|||||||
| RelationshipToStudent | varchar | 5 | ('') |
|
|
|||||||
| SpouseRelationshipToSpouse | varchar | 5 | ('') |
|
|
|||||||
| SpouseRelationshipToStudent | varchar | 5 | ('') |
|
|
|||||||
| HomeAddressSameFlag | bit | 1 | ((0)) |
|
|
|||||||
| HomeAddress1 | varchar | 40 | ('') |
|
|
|||||||
| HomeAddress2 | varchar | 40 | ('') |
|
|
|||||||
| HomeAddress3 | varchar | 40 | ('') |
|
|
|||||||
| HomeSuburb | varchar | 40 | ('') |
|
|
|||||||
| HomeState | varchar | 5 | ('') |
|
|
|||||||
| HomeCountryCode | varchar | 5 | ('') |
|
|
|||||||
| HomePostCode | varchar | 5 | ('') |
|
|
|||||||
| HomePhoneActual | varchar | 15 | ('') |
|
|
|||||||
| HomePhoneAlt | varchar | 15 | ('') |
|
|
|||||||
| HomeFax | varchar | 15 | ('') |
|
|
|||||||
| SpouseAddressID | int | 4 | ('') |
|
|
|||||||
| SpouseAddress1 | varchar | 40 | ('') |
|
|
|||||||
| SpouseAddress2 | varchar | 40 | ('') |
|
|
|||||||
| SpouseAddress3 | varchar | 40 | ('') |
|
|
|||||||
| SpouseSuburb | varchar | 40 | ('') |
|
|
|||||||
| SpouseState | varchar | 5 | ('') |
|
|
|||||||
| SpouseCountryCode | varchar | 5 | ('') |
|
|
|||||||
| SpousePostCode | varchar | 5 | ('') |
|
|
|||||||
| SpousePhoneActual | varchar | 15 | ('') |
|
|
|||||||
| SpousePhoneAlt | varchar | 15 | ('') |
|
|
|||||||
| SpouseFax | varchar | 15 | ('') |
|
|
|||||||
| SpouseHomeAddressSameFlag | bit | 1 | ((0)) |
|
|
|||||||
| SpouseHomeAddress1 | varchar | 40 | ('') |
|
|
|||||||
| SpouseHomeAddress2 | varchar | 40 | ('') |
|
|
|||||||
| SpouseHomeAddress3 | varchar | 40 | ('') |
|
|
|||||||
| SpouseHomeSuburb | varchar | 40 | ('') |
|
|
|||||||
| SpouseHomeState | varchar | 5 | ('') |
|
|
|||||||
| SpouseHomeCountryCode | varchar | 5 | ('') |
|
|
|||||||
| SpouseHomePostCode | varchar | 5 | ('') |
|
|
|||||||
| SpouseHomePhoneActual | varchar | 15 | ('') |
|
|
|||||||
| SpouseHomePhoneAlt | varchar | 15 | ('') |
|
|
|||||||
| SpouseHomeFax | varchar | 15 | ('') |
|
|
|||||||
| OccupCode | varchar | 15 | ('') |
|
|
|||||||
| OccupPositionCode | varchar | 8 | ('') |
|
|
|||||||
| OccupIndustryCode | varchar | 8 | ('') |
|
|
|||||||
| SpouseOccupDesc | varchar | 50 | ('') |
|
|
|||||||
| SpouseOccupCompany | varchar | 50 | ('') |
|
|
|||||||
| SpouseOccupCode | varchar | 15 | ('') |
|
|
|||||||
| SpouseOccupPositionCode | varchar | 8 | ('') |
|
|
|||||||
| SpouseOccupIndustryCode | varchar | 8 | ('') |
|
|
|||||||
| OnlineImportApplicationsSeq | int | 4 | ((0)) |
|
|
|||||||
| CommunityID | int | 4 | √ | null |
|
|
||||||
| BirthDate | datetime | 16,3 | √ | null |
|
|
||||||
| CountryOfBirthCode | varchar | 5 | ('') |
|
|
|||||||
| SpouseCountryOfBirthCode | varchar | 5 | ('') |
|
|
|||||||
| ContactTypeCode | varchar | 3 | ('') |
|
|
|||||||
| PrimaryOnlyFlag | bit | 1 | √ | null |
|
|
||||||
| NormalMailFlag | bit | 1 | √ | null |
|
|
||||||
| ReportsFlag | bit | 1 | √ | null |
|
|
||||||
| ParentFlag | bit | 1 | √ | null |
|
|
||||||
| LivesWithFlag | bit | 1 | √ | null |
|
|
||||||
| OccupFax | varchar | 15 | ('') |
|
|
|||||||
| OccupEmail | varchar | 100 | ('') |
|
|
|||||||
| OccupAddress1 | varchar | 40 | ('') |
|
|
|||||||
| OccupAddress2 | varchar | 40 | ('') |
|
|
|||||||
| OccupAddress3 | varchar | 40 | ('') |
|
|
|||||||
| OccupSuburb | varchar | 40 | ('') |
|
|
|||||||
| OccupState | varchar | 5 | ('') |
|
|
|||||||
| OccupCountryCode | varchar | 5 | ('') |
|
|
|||||||
| OccupPostCode | varchar | 5 | ('') |
|
|
|||||||
| OccupAddressDPID | varchar | 8 | ('') |
|
|
|||||||
| OccupOccupMobilePhoneActual | varchar | 15 | ('') |
|
|
|||||||
| SilentOccupMobilePhoneFlag | bit | 1 | ((0)) |
|
|
|||||||
| SpouseOccupFax | varchar | 15 | ('') |
|
|
|||||||
| SpouseOccupEmail | varchar | 100 | ('') |
|
|
|||||||
| SpouseOccupAddress1 | varchar | 40 | ('') |
|
|
|||||||
| SpouseOccupAddress2 | varchar | 40 | ('') |
|
|
|||||||
| SpouseOccupAddress3 | varchar | 40 | ('') |
|
|
|||||||
| SpouseOccupSuburb | varchar | 40 | ('') |
|
|
|||||||
| SpouseOccupState | varchar | 5 | ('') |
|
|
|||||||
| SpouseOccupCountryCode | varchar | 5 | ('') |
|
|
|||||||
| SpouseOccupPostCode | varchar | 5 | ('') |
|
|
|||||||
| SpouseOccupAddressDPID | varchar | 8 | ('') |
|
|
|||||||
| SpouseOccupOccupMobilePhoneActual | varchar | 15 | ('') |
|
|
|||||||
| SpouseSilentOccupMobilePhoneFlag | bit | 1 | ((0)) |
|
|
|||||||
| IsDebtorFlag | bit | 1 | ((0)) |
|
|
|||||||
| Religion | varchar | 5 | ('') |
|
|
|||||||
| SpouseReligion | varchar | 5 | ('') |
|
|
|||||||
| ParishCode | varchar | 5 | ('') |
|
|
|||||||
| PostalAddress1 | varchar | 40 | ('') |
|
|
|||||||
| PostalAddress2 | varchar | 40 | ('') |
|
|
|||||||
| PostalAddress3 | varchar | 40 | ('') |
|
|
|||||||
| PostalSuburb | varchar | 40 | ('') |
|
|
|||||||
| PostalPostCode | varchar | 5 | ('') |
|
|
|||||||
| PostalState | varchar | 5 | ('') |
|
|
|||||||
| PostalCountry | varchar | 5 | ('') |
|
|
|||||||
| PostalHomePhoneActual | varchar | 15 | ('') |
|
|
|||||||
| SpouseDOB | datetime | 16,3 | √ | null |
|
|
||||||
| SpouseParish | varchar | 5 | ('') |
|
|
|||||||
| EnquiryContactID | int | 4 | √ | null |
|
|
||||||
| HomeAddressValidated | bit | 1 | ((0)) |
|
|
|||||||
| AddressValidated | bit | 1 | ((0)) |
|
|
|||||||
| OccupAddressValidated | bit | 1 | ((0)) |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_OnlineImportContacts | Primary key | Asc | OnlineImportContactsSeq |
Relationships
Close relationships within degrees of separation
