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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034925990 | USERS_ID, STOREENT_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|