This table stores whether the user prefers to receive e-mail activities or not.
Column Descriptions
| 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.
|