CREATE TABLE [dbo].[ttAddressResponse](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[RecordID] [int] NOT NULL,
	[TransmissionReference] [nvarchar](100) NULL,
	[Results] [nvarchar](50) NULL,
	[FormattedAddress] [nvarchar](1000) NULL,
	[Organization] [nvarchar](100) NULL,
	[AddressLine1] [nvarchar](100) NULL,
	[AddressLine2] [nvarchar](100) NULL,
	[AddressLine3] [nvarchar](100) NULL,
	[AddressLine4] [nvarchar](100) NULL,
	[AddressLine5] [nvarchar](100) NULL,
	[AddressLine6] [nvarchar](100) NULL,
	[AddressLine7] [nvarchar](100) NULL,
	[AddressLine8] [nvarchar](100) NULL,
	[SubPremises] [nvarchar](100) NULL,
	[DoubleDependentLocality] [nvarchar](100) NULL,
	[DependentLocality] [nvarchar](100) NULL,
	[Locality] [nvarchar](100) NULL,
	[SubAdministrativeArea] [nvarchar](100) NULL,
	[AdministrativeArea] [nvarchar](100) NULL,
	[PostalCode] [nvarchar](100) NULL,
	[PostalCodeType] [nvarchar](10) NULL,
	[AddressType] [nvarchar](10) NULL,
	[AddressKey] [nvarchar](100) NULL,
	[SubNationalArea] [nvarchar](100) NULL,
	[CountryName] [nvarchar](100) NULL,
	[CountryISO3166_1_Alpha2] [nvarchar](10) NULL,
	[CountryISO3166_1_Alpha3] [nvarchar](10) NULL,
	[CountryISO3166_1_Numeric] [nvarchar](10) NULL,
	[CountrySubdivisionCode] [nvarchar](10) NULL,
	[Thoroughfare] [nvarchar](100) NULL,
	[ThoroughfarePreDirection] [nvarchar](100) NULL,
	[ThoroughfareLeadingType] [nvarchar](100) NULL,
	[ThoroughfareName] [nvarchar](100) NULL,
	[ThoroughfareTrailingType] [nvarchar](100) NULL,
	[ThoroughfarePostDirection] [nvarchar](100) NULL,
	[DependentThoroughfare] [nvarchar](100) NULL,
	[DependentThoroughfarePreDirection] [nvarchar](100) NULL,
	[DependentThoroughfareLeadingType] [nvarchar](100) NULL,
	[DependentThoroughfareName] [nvarchar](100) NULL,
	[DependentThoroughfareTrailingType] [nvarchar](100) NULL,
	[DependentThoroughfarePostDirection] [nvarchar](100) NULL,
	[Building] [nvarchar](100) NULL,
	[PremisesType] [nvarchar](100) NULL,
	[PremisesNumber] [nvarchar](100) NULL,
	[SubPremisesType] [nvarchar](100) NULL,
	[SubPremisesNumber] [nvarchar](100) NULL,
	[PostBox] [nvarchar](100) NULL,
	[Latitude] [nvarchar](100) NULL,
	[Longitude] [nvarchar](100) NULL,
	[DeliveryIndicator] [nvarchar](10) NULL,
	[MelissaAddressKey] [nvarchar](100) NULL,
	[MelissaAddressKeyBase] [nvarchar](100) NULL,
	[PostOfficeLocation] [nvarchar](100) NULL,
	[SubPremiseLevel] [nvarchar](100) NULL,
	[SubPremiseLevelNumber] [nvarchar](10) NULL,
	[SubBuilding] [nvarchar](100) NULL,
	[SubBuildingType] [nvarchar](100) NULL,
	[SubBuildingNumber] [nvarchar](10) NULL,
	[UTC] [nvarchar](20) NULL,
	[DST] [nvarchar](10) NULL,
	[DeliveryPointSuffix] [nvarchar](10) NULL,
	[CensusKey] [nvarchar](100) NULL,
 CONSTRAINT [PK_AddressResponse] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO