EMLUSRRECV

This table stores whether the user prefers to receive marketing e-mail and SMS messages or not.

Column Descriptions:

NameTypeDescription
USERS_IDBIGINT NOT NULLForeign key to the USERS table.
STOREENT_IDINTEGER NOT NULLA 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.
RECEIVEEMLINTEGER NOT NULL DEFAULT 0This 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.
RECEIVESMSINTEGER NOT NULL DEFAULT 0This 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.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>USERS_ID+STOREENT_IDPrimary Key
I0000567STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_966USERS_IDUSERSUSERS_IDCascade
F_967STOREENT_IDSTOREENTSTOREENT_IDCascade