ADDRESS
Description: An address expressed using postal conventions

Primary Key
Column Name Ordinal Position

Foreign Key
Column Name Ordinal Position Referenced Table
LKADDRESSUSEID 2 LKADDRESSUSE
LKADDRESSTYPEID 3 LKADDRESSTYPE
LKCOUNTYID 8 LKCOUNTY
LKSTATEID 9 LKSTATE
LKCOUNTRYID 11 LKCOUNTRY

Column Information
Name Type
1 ADDRESSID INT
Description: The unique Id for the Address table
Name Type
2 LKADDRESSUSEID INT
Description: LkAddressUseId is a foreign key to the LkAddressUse table
Name Type
3 LKADDRESSTYPEID INT
Description: LkAddressTypeId is a foreign key to the LkAddressType table
Name Type
4 ADDRESSLINE1 NVARCHAR
Description: Line one of the address
Name Type
5 ADDRESSLINE2 NVARCHAR
Description: Line two of the address
Name Type
6 ADDRESSLINE3 NVARCHAR
Description: Line three of the address
Name Type
7 CITY NVARCHAR
Description: The city of the address
Name Type
8 LKCOUNTYID INT
Description: LkCountyId is a foreign key to the LkCounty table
Name Type
9 LKSTATEID INT
Description: LkStateId is a foreign key to the LkState table
Name Type
10 ZIPCODE NVARCHAR
Description: The zip code of the address
Name Type
11 LKCOUNTRYID INT
Description: LkCountryId is a foreign key to the LkCountry table
Name Type
13 CREATED DATETIMEOFFSET
Description: Record created time
Name Type
15 LASTMODIFIED DATETIMEOFFSET
Description: Record Last Modified time