WebSphere Commerce database table: USERDEMO

USERDEMO

This table stores demographics information for users.

Column Descriptions:

Name Type Description
USERS_ID BIGINT NOT NULL Foreign key to the USER table for the member (user) who is associated with this demographic 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 group the user is in. The default value is 0 (age group 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.
DATEOFBIRTH DATE The date of birth of the user stored as an absolute point in time. The year 1896 is internally designated as the year if the user does not provide a year of birth, as it includes all valid dates in the Gregorian calendar.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> USERS_ID Primary Key

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_888 USERS_ID USERS USERS_ID Cascade

Related reference
Member data model

Name	Type	Description
USERS_ID	BIGINT NOT NULL	Foreign key to the USER table for the member (user) who is associated with this demographic 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 group the user is in. The default value is 0 (age group 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.
DATEOFBIRTH	DATE	The date of birth of the user stored as an absolute point in time. The year 1896 is internally designated as the year if the user does not provide a year of birth, as it includes all valid dates in the Gregorian calendar.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.