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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035140720 | USERS_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_888 | USERS_ID | USERS | USERS_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|