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 recieve 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 | 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 |