This table stores e-mail information about the recipients of an annoucement 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.
OPTCOUNTERSMALLINTThe 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