This table stores e-mail information about the
recipients of an annoucement made for gift registries and wish
lists.
Column Descriptions:
| Name | Type | Description |
| EMAILLIST_ID | BIGINT NOT NULL | Primary key of the table. |
| ANNHISTORY_ID | BIGINT NOT NULL | Refers to the announcement associated with this
e-mail list. |
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
| EMLTYPE | INTEGER NOT NULL | The type of the e-mail. The types are supported:
- 0: The recipient was addressed
- 1: The recipient was copied (that is CC'd)
- 2: The recipient was blind copied (that is, BCC'd)
|
| NAME | VARCHAR (32) | The name of the receiver. |
| EMAIL | VARCHAR (254) NOT NULL | The e-mail address. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | EMAILLIST_ID | Primary Key |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| GRE_CONSTRAINT4 | ANNHISTORY_ID | GRANNHIST | ANNHISTORY_ID | Cascade |