Description: An address expressed using postal conventions
Column Name |
Ordinal Position |
|
|
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
|