Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AddressID | int | 4 | null |
|
|
|||
| AddressCreatedDate | datetime | 16,3 | √ | (getdate()) |
|
|
||
| AddressCreatedBy | varchar | 50 | √ | ('') |
|
|
||
| AddressModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| AddressModifiedBy | varchar | 50 | √ | ('') |
|
|
||
| Address1 | varchar | 40 | ('') |
|
|
|||
| Address2 | varchar | 40 | ('') |
|
|
|||
| Address3 | varchar | 40 | ('') |
|
|
|||
| Suburb | varchar | 40 | ('') |
|
|
|||
| State | varchar | 5 | ('') |
|
|
|||
| CountryCode | varchar | 5 | ('') |
|
|
|||
| PostCode | varchar | 5 | ('') |
|
|
|||
| PhoneActual | varchar | 15 | ('') |
|
|
|||
| PhoneAlt | varchar | 15 | ('') |
|
|
|||
| Fax | varchar | 15 | ('') |
|
|
|||
| HomeAddressSameFlag | bit | 1 | ((1)) |
|
|
|||
| HomeAddress1 | varchar | 40 | ('') |
|
|
|||
| HomeAddress2 | varchar | 40 | ('') |
|
|
|||
| HomeAddress3 | varchar | 40 | ('') |
|
|
|||
| HomeSuburb | varchar | 40 | ('') |
|
|
|||
| HomeState | varchar | 5 | ('') |
|
|
|||
| HomeCountryCode | varchar | 5 | ('') |
|
|
|||
| HomePostCode | varchar | 5 | ('') |
|
|
|||
| ValidAddressFlag | bit | 1 | ((1)) |
|
|
|||
| SilentPhoneFlag | bit | 1 | ((0)) |
|
|
|||
| MailFlag | bit | 1 | ((1)) |
|
|
|||
| MagazineFlag | bit | 1 | ((1)) |
|
|
|||
| SolicitationFlag | bit | 1 | ((1)) |
|
|
|||
| RaffleFlag | bit | 1 | ((1)) |
|
|
|||
| ReasonFlagChange | varchar | 50 | ('') |
|
|
|||
| ReasonFlagChangeDate | datetime | 16,3 | √ | null |
|
|
||
| AddressComma | varchar | 200 | √ | null |
|
|
||
| AddressFull | varchar | 200 | √ | null |
|
|
||
| HomeAddressComma | varchar | 200 | √ | null |
|
|
||
| HomeAddressFull | varchar | 200 | √ | null |
|
|
||
| Phone | varchar | 15 | √ | null |
|
|
||
| AddressRegion | varchar | 10 | √ | ('') |
|
|
||
| AddressRegionOverrideFlag | tinyint | 1 | √ | ((0)) |
|
|
||
| AddressComment | varchar | 250 | ('') |
|
|
|||
| AddressDPID | varchar | 8 | ('') |
|
|
|||
| AddressSortPlanNumber | varchar | 3 | ('') |
|
|
|||
| HomeAddressDPID | varchar | 8 | ('') |
|
|
|||
| HomeAddressSortPlanNumber | varchar | 3 | ('') |
|
|
|||
| AddressPAFVersion | varchar | 10 | ('') |
|
|
|||
| HomeAddressPAFVersion | varchar | 10 | ('') |
|
|
|||
| AddressDPIDBarcode | varchar | 60 | ('') |
|
|
|||
| HomeAddressDPIDBarcode | varchar | 60 | ('') |
|
|
|||
| SilentHomeAddressFlag | bit | 1 | ((0)) |
|
|
|||
| MailFlagChangeReason | varchar | 255 | ('') |
|
|
|||
| MagazineFlagChangeReason | varchar | 255 | ('') |
|
|
|||
| SolicitationFlagChangeReason | varchar | 255 | ('') |
|
|
|||
| RaffleFlagChangeReason | varchar | 255 | ('') |
|
|
|||
| UserFlag1 | bit | 1 | ((0)) |
|
|
|||
| UserFlag2 | bit | 1 | ((0)) |
|
|
|||
| UserFlag3 | bit | 1 | ((0)) |
|
|
|||
| UserFlag4 | bit | 1 | ((0)) |
|
|
|||
| UserFlag5 | bit | 1 | ((0)) |
|
|
|||
| HomeAddressLatitude | decimal | 11,6 | √ | null |
|
|
||
| HomeAddressLongitude | decimal | 11,6 | √ | null |
|
|
||
| ExternalValidationFlag | bit | 1 | ((0)) |
|
|
|||
| HomeExternalValidationFlag | bit | 1 | ((0)) |
|
|
|||
| HomeAddressValidationSeq | int | 4 | √ | null |
|
|
||
| AddressValidationSeq | int | 4 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Addresses_2__14 | Primary key | Asc | AddressID |
| AK_Addresses_Postcode | Performance | Asc | PostCode |
| AK_Addresses_Suburb | Performance | Asc | Suburb |