Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AddressID | int | 4 | √ | null |
|
|
||
| AddressCreatedDate | datetime | 16,3 | √ | null |
|
|
||
| AddressCreatedBy | varchar | 50 | √ | null |
|
|
||
| AddressModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| AddressModifiedBy | varchar | 50 | √ | 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 |
|
|
||
| PhoneActual | varchar | 15 | √ | null |
|
|
||
| PhoneAlt | varchar | 15 | √ | null |
|
|
||
| Fax | varchar | 15 | √ | null |
|
|
||
| HomeAddressSameFlag | bit | 1 | √ | 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 |
|
|
||
| ValidAddressFlag | bit | 1 | √ | null |
|
|
||
| SilentPhoneFlag | bit | 1 | √ | null |
|
|
||
| MailFlag | bit | 1 | √ | null |
|
|
||
| MagazineFlag | bit | 1 | √ | null |
|
|
||
| SolicitationFlag | bit | 1 | √ | null |
|
|
||
| RaffleFlag | bit | 1 | √ | null |
|
|
||
| ReasonFlagChange | varchar | 50 | √ | null |
|
|
||
| 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 | √ | null |
|
|
||
| AddressRegionOverrideFlag | tinyint | 1 | √ | null |
|
|
||
| AddressComment | varchar | 250 | √ | null |
|
|
||
| AddressDPID | varchar | 8 | √ | null |
|
|
||
| AddressSortPlanNumber | varchar | 3 | √ | null |
|
|
||
| HomeAddressDPID | varchar | 8 | √ | null |
|
|
||
| HomeAddressSortPlanNumber | varchar | 3 | √ | null |
|
|
||
| AddressPAFVersion | varchar | 10 | √ | null |
|
|
||
| HomeAddressPAFVersion | varchar | 10 | √ | null |
|
|
||
| AddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| HomeAddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| SilentHomeAddressFlag | bit | 1 | √ | null |
|
|
||
| MailFlagChangeReason | varchar | 255 | null |
|
|
|||
| MagazineFlagChangeReason | varchar | 255 | null |
|
|
|||
| SolicitationFlagChangeReason | varchar | 255 | null |
|
|
|||
| RaffleFlagChangeReason | varchar | 255 | null |
|
|
|||
| UserFlag1 | bit | 1 | null |
|
|
|||
| UserFlag2 | bit | 1 | null |
|
|
|||
| UserFlag3 | bit | 1 | null |
|
|
|||
| UserFlag4 | bit | 1 | null |
|
|
|||
| UserFlag5 | bit | 1 | null |
|
|
|||
| HomeAddressLatitude | decimal | 11,6 | √ | null |
|
|
||
| HomeAddressLongitude | decimal | 11,6 | √ | null |
|
|
Table contained 0 rows