Addresses Table

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

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.

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.

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.

See Also

Other Resources

Profiles System Database Tables