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	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