This table stores whether the user prefers to receive e-mail activities or not.
Column Name | Column Type | Description |
---|---|---|
USERS_ID | BIGINT NOT NULL | Foreign key to the USERS table. |
STOREENT_ID | INTEGER NOT NULL | A store for which the user has indicated a preference about whether they want to recieve e-mail. If a row contains a 0 in this column, it is considered applicable to all stores. |
RECEIVEEML | INTEGER NOT NULL DEFAULT 0 | This column contains a flag which indicates whether a user chooses to receive e-mail or not. Possible values include: 1 - Chooses to receive e-mail activities. 0 - Chooses not to receive e-mail activities. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031226030 | USERS_ID+STOREENT_ID | Primary Key |
I0000567 | STOREENT_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_967 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
F_966 | USERS_ID | USERS | USERS_ID | Cascade |