Addresses Table
The Addresses table in the profiles database contains information about the addresses that are associated with registered users.
The following table describes the columns in the Addresses table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
u_address_id |
nvarchar(50) |
no |
The ID of the address. This is the primary key. |
i_address_type |
int |
yes |
Not used. You can use this column for your extensions to Commerce Server Core Systems. |
u_address_name |
nvarchar(50) |
no |
The name of the address, for example "home" or "work". |
u_first_name |
nvarchar(64) |
yes |
The first name of the person who is associated with the address. |
u_last_name |
nvarchar(64) |
yes |
The last name of the person who is associated with the address. |
u_description |
nvarchar(50) |
yes |
A description of the address. |
u_address_line1 |
nvarchar(80) |
yes |
The first line of the address. |
u_address_line2 |
nvarchar(80) |
yes |
The second line of the address. |
u_city |
nvarchar(64) |
yes |
The city of the address. |
u_region_code |
nvarchar(50) |
yes |
The region code of the address. |
u_region_name |
nvarchar(64) |
yes |
The name of the region. |
u_postal_code |
nvarchar(20) |
yes |
The postal code of the address. |
u_country_code |
nvarchar(50) |
yes |
The country code of the address. |
u_country_name |
nvarchar(50) |
yes |
The name of the country. |
u_tel_number |
nvarchar(32) |
yes |
The telephone number of the person who is associated with the address. |
u_tel_extension |
nvarchar(50) |
yes |
The telephone extension of the person who is associated with the address. |
i_locale |
int |
yes |
Not used. You can use this column for your extensions to Commerce Server Core Systems. |
u_user_id_changed_by |
nvarchar(50) |
yes |
The Microsoft Windows user ID of the person who last modified the address. |
dt_date_last_changed |
datetime |
yes |
The date that changes were last made to the address. |
dt_csadapter_date_last_changed |
datetime |
yes |
The date the address was last updated by BizTalk Server. |
dt_date_created |
datetime |
yes |
The date that the address was created. |