EMLUSRRECV
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