WebSphere Commerce database table: USERDEMO

This table stores demographics information for users.


Column Description(s):
Column NameColumn TypeDescription
USERS_ID BIGINT NOT NULL Foreign key to the USER table for the member (user) who is associated with this demographical information.
GENDER CHAR(1) The gender of the user. Valid values are as follows:
  • F = female
  • M = male
  • N = not provided
If not provided, N is used as the default.
AGE INTEGER The age of the user. The default value is 0 (age not provided). Other values are configurable.
INCOME INTEGER The annual income for the user. Valid values are configurable.
MARITALSTATUS CHAR(1) The marital status of the user. Valid values are configurable.
INCOMECURRENCY CHAR(3) Currency for the income of the user.
CHILDREN INTEGER The number of children that the user has. If not provided, the default is 0.
HOUSEHOLD INTEGER Number of people in the household.
COMPANYNAME VARCHAR(128) The company for which the user works.
HOBBIES VARCHAR(254) The main interests and hobbies of the user.
ORDERBEFORE CHAR(1) Indicates whether or not the user has previously placed an order. This value is supplied by the user.
FIELD1 CHAR(1) Customizable.
TIMEZONE CHAR(5) The time zone in which the user resides.
FIELD2 CHAR(1) Customizable.
FIELD7 VARCHAR(64) Customizable.
FIELD3 CHAR(1) Customizable.
FIELD4 CHAR(1) Customizable.
FIELD5 VARCHAR(254) Customizable.
FIELD6 INTEGER Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031324740 USERS_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_888 USERS_ID USERS USERS_ID Cascade

Feedback