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:
| Name | Type | Description |
| ANNHISTORY_ID | BIGINT NOT NULL | Primary key of the table. |
| GIFTREGISTRY_ID | BIGINT NOT NULL | The gift registry or wish list for which this
announcement is created. |
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
| SENTDATE | DATE NOT NULL | The date when this announcement was sent. |
| SENDEREMAIL | VARCHAR (254) NOT NULL | The e-mail address of the sender. |
| MESSAGE | VARCHAR (254) NOT NULL | The content of the announcement. |
| SENDERNAME | VARCHAR (32) NOT NULL | The name of the announcement sender. |
| FIELD1 | VARCHAR (64) | Customizable. |
| FIELD2 | VARCHAR (64) | Customizable. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | ANNHISTORY_ID | Primary Key |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| ANN_CONST2 | GIFTREGISTRY_ID | GRGFTREG | GIFTREGISTRY_ID | No Action |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| GRE_CONSTRAINT4 | ANNHISTORY_ID | GREMLLIST | ANNHISTORY_ID | Cascade |