AddressesArchive


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 ('')
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

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
AK_AddressesArchive_AddressIDDate Performance Asc/Asc AddressID + AddressModifiedDate