Database Table: USERDEMO

This table stores demographics information for users.

Column Name Column Type Column Description
AGE INTEGER
NULL
The age of the user. The default value is 0 (age not provided). Other values are configurable.
CHILDREN INTEGER
NULL
The number of children that the user has. If not provided, the default is 0.
COMPANYNAME VARCHAR (128)
NULL
The company for which the user works.
FIELD1 CHARACTER (1)
NULL
Customizable.
FIELD2 CHARACTER (1)
NULL
Customizable.
FIELD3 CHARACTER (1)
NULL
Customizable.
FIELD4 CHARACTER (1)
NULL
Customizable.
FIELD5 VARCHAR (254)
NULL
Customizable.
FIELD6 INTEGER
NULL
Customizable.
FIELD7 VARCHAR (64)
NULL
Customizable.
GENDER CHARACTER (1)
NULL
The gender of the user. Valid values are F (female), M (male), or N (not provided). If not provided, N is used as the default.
HOBBIES VARCHAR (254)
NULL
The main interests and hobbies of the user.
HOUSEHOLD INTEGER
NULL
Number of people in the household.
INCOME INTEGER
NULL
The annual income for the user. Valid values are configurable.
INCOMECURRENCY CHARACTER (3)
NULL
Currency for the income of the user.
MARITALSTATUS CHARACTER (1)
NULL
The marital status of the user. Valid values are configurable.
ORDERBEFORE CHARACTER (1)
NULL
Indicates whether or not the user has previously placed an order. This value is supplied by the user.
TIMEZONE CHARACTER (5)
NULL
The time zone in which the user resides.
USERS_ID BIGINT
NOT NULL
Foreign key to the USER table for the member (user) who is associated with this demographical information.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035140720 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable