UserObject Table

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

The UserObject table in the profiles database contains information about registered users.

The following table describes the columns in the UserObject table.

Column name

Type

Allow null

Description

u_user_id

nvarchar(50)

no

The ID of the user.

This is the primary key.

u_org_id

nvarchar(50)

yes

The ID of the organization that is associated with the user.

u_user_type

nvarchar(50)

yes

The type of user.

u_first_name

nvarchar(50)

yes

The user's first name.

u_last_name

nvarchar(50)

yes

The user's last name.

u_email_address

nvarchar(64)

no

The user's e-mail address.

u_preferred_address

nvarchar(50)

yes

The ID of the user's preferred address.

u_addresses

nvarchar(255)

yes

The IDs of all the addresses that are associated with the user.

u_preferred_credit_card

nvarchar(50)

yes

The ID of the user's preferred credit card.

u_credit_cards

nvarchar(255)

yes

The IDs of all credit cards that are associated with the user.

u_tel_number

nvarchar(32)

yes

The user's telephone number.

u_tel_extension

nvarchar(50)

yes

The extension of the user's telephone number.

u_fax_number

nvarchar(32)

yes

The user's fax number.

u_fax_extension

nvarchar(50)

yes

The extension of the user's fax number.

u_user_security_password

nvarchar(100)

yes

The user's logon password.

Bb520800.alert_note(en-US,CS.70).gifNote:
By default, the value is encrypted.

u_user_id_changed_by

nvarchar(50)

yes

The Windows user ID of the person who last modified the profile.

u_account_status

nvarchar(50)

yes

The status of the user's account.

u_user_catalog_set

nvarchar(50)

yes

The ID of the catalog set that is associated with the user.

dt_date_registered

datetime

yes

The date that the user registered.

u_campaign_history

nvarchar(50)

yes

Not used. You can use this column for your extensions to Commerce Server.

dt_date_last_changed

datetime

yes

The date that changes were last made to the user profile.

dt_csadapter_date_last_changed

datetime

yes

The date the user profile was last updated by BizTalk Server.

dt_date_created

datetime

yes

The date the user profile was created.

u_language

nvarchar(128)

yes

The user's preferred language.

u_Pref1

nvarchar(50)

yes

Not used. You can use this column for your extensions to Commerce Server.

u_Pref2

nvarchar(50)

yes

Not used. You can use this column for your extensions to Commerce Server.

u_Pref3

nvarchar(50)

yes

Not used. You can use this column for your extensions to Commerce Server.

u_Pref4

nvarchar(50)

yes

Not used. You can use this column for your extensions to Commerce Server.

u_Pref5

nvarchar(50)

yes

Not used. You can use this column for your extensions to Commerce Server.

u_password_question

nvarchar(255)

yes

The question to ask the user when the user forgets the password.

u_password_answer

nvarchar(255)

yes

The answer to the question to ask the user when the user forgets the password.

Bb520800.alert_note(en-US,CS.70).gifNote:
By default, the value is encrypted.

u_logon_error_dates

nvarchar(255)

yes

The dates the user unsuccessfully tried to log on.

u_password_answer_error_dates

nvarchar(255)

yes

The dates the user entered an incorrect password.

i_keyindex

int

yes

The index of the encryption key.

i_access_level_id

int

yes

Not used. You can use this column for your extensions to Commerce Server.

b_change_password

bit

yes

Whether periodic password changes are required.

dt_date_last_password_changed

datetime

yes

The date the user's password was last changed.

dt_last_logon

datetime

yes

The last date the user logged on.

dt_last_lockedout_date

datetime

yes

The last date the user was locked out of the account.

u_application_name

nvarchar(256)

yes

Not used. You can use this column for your extensions to Commerce Server.

dt_last_activity_date

datetime

yes

The last date the user interacted with the Commerce Server application.

b_direct_mail_opt_out

bit

yes

Whether the user has opted out of receiving direct mail.

b_express_checkout

bit

yes

Whether the user can use the express checkout functionality.

dt_date_address_list_last_changed

datetime

yes

The date that any address associated with the user was last changed.

dt_date_credit_card_list_last_changed

datetime

yes

The date that any credit card associated with the user was last changed.

See Also

Other Resources

Profiles System Database Tables