Reference > Database > WebSphere Commerce database tables > U
WebSphere Commerce database table: USERDEMO
This table stores demographics information for users.
Column Name Column 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...
- 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. 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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030444330 USERS_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_888 USERS_ID USERS USERS_ID Cascade
Related reference
_vcc_freeselect_bottom_