Database Table: EMLUSRRECV

This table stores user preference of whether to receive e-mail or not.

Column Name Column Type Column Description
RECEIVEEML INTEGER
NOT NULL, DEFAULT 0
The flag indicating if a user chooses to receive e-mail or not. (1 - receive, 0 - does not receive)
STOREENT_ID INTEGER
NOT NULL
A store from which the user no longer wishes to receive e-mail. If a row contains 0 in this column, the user is considered opted out of receiving mail from all stores.
USERS_ID BIGINT
NOT NULL
The foreign key representing the user.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034925990 USERS_ID, STOREENT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_966 USERS_ID USERS USERS_ID Cascade
F_967 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable