This table stores demographics information for users.
Column Description(s):
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 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 Name | Indexed Column Names | Index Type |
SQL050212031324740 |
USERS_ID |
Primary Key |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_888 |
USERS_ID |
USERS |
USERS_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.