UserObject Table
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 Core Systems. |
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 Core Systems. |
u_Pref2 |
nvarchar(50) |
yes |
Not used. You can use this column for your extensions to Commerce Server Core Systems. |
u_Pref3 |
nvarchar(50) |
yes |
Not used. You can use this column for your extensions to Commerce Server Core Systems. |
u_Pref4 |
nvarchar(50) |
yes |
Not used. You can use this column for your extensions to Commerce Server Core Systems. |
u_Pref5 |
nvarchar(50) |
yes |
Not used. You can use this column for your extensions to Commerce Server Core Systems. |
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 Core Systems. |
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 Core Systems. |
dt_last_activity_date |
datetime |
yes |
The last date the user interacted with the Commerce Server Core Systems 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. |