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. .gif "Note") Note:
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. Note:
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. |