This table stores a history of e-mail announcements sent regarding a gift registry or wish list. A registrant can send one or more announcements about their gift registry or wish list, and a history is stored in the database.

Column Descriptions:

ANNHISTORY_IDBIGINT NOT NULLPrimary key of the table.
GIFTREGISTRY_IDBIGINT NOT NULLThe gift registry or wish list for which this announcement is created.
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.
SENTDATEDATE NOT NULLThe date when this announcement was sent.
SENDEREMAILVARCHAR (254) NOT NULLThe e-mail address of the sender.
MESSAGEVARCHAR (254) NOT NULLThe content of the announcement.
SENDERNAMEVARCHAR (32) NOT NULLThe name of the announcement sender.
FIELD1VARCHAR (64)Customizable.
FIELD2VARCHAR (64)Customizable.


NameColumn NamesType

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType