This table stores whether the user prefers to
receive marketing e-mail and SMS messages or not.
Column Descriptions:
| Name | 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 receive marketing e-mail and
SMS messages. 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. |
| RECEIVESMS | INTEGER NOT NULL DEFAULT 0 | This column contains a flag which indicates
whether a user chooses to receive marketing SMS messages or not.
Possible values include:
1 - Chooses to receive marketing SMS messages.
0 - Chooses not to receive marketing SMS messages. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | USERS_ID+STOREENT_ID | Primary Key |
| I0000567 | STOREENT_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_966 | USERS_ID | USERS | USERS_ID | Cascade |
| F_967 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |