This table stores e-mail information about the recipients of an announcement made for gift registries and wish lists.

Column Descriptions:

EMAILLIST_IDBIGINT NOT NULLPrimary key of the table.
ANNHISTORY_IDBIGINT NOT NULLRefers to the announcement associated with this e-mail list.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
EMLTYPEINTEGER NOT NULLThe 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)
NAMEVARCHAR (32)The name of the receiver.
EMAILVARCHAR (254) NOT NULLThe e-mail address.


NameColumn NamesType

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType