WebSphere Commerce database table: GRANNHIST

WebSphere Commerce database table: GRANNHIST

This table stores a history of e-mail announcements sent regarding a gift registry. A registrant can send one or more announcements about their gift registry, and a history is stores in the database.
Column Descriptions
Column Name Column Type Description
ANNHISTORY_ID BIGINT NOT NULL Primary key of the table.
GIFTREGISTRY_ID BIGINT NOT NULL The gift registry for which this announcement is created.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
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
Index Name Indexed Column Names Index Type
SQL060903235201610 ANNHISTORY_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
ANN_CONST2 GIFTREGISTRY_ID GRGFTREG GIFTREGISTRY_ID No Action

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
GRE_CONSTRAINT4 ANNHISTORY_ID GREMLLIST ANNHISTORY_ID Cascade

Column Name	Column Type	Description
ANNHISTORY_ID	BIGINT NOT NULL	Primary key of the table.
GIFTREGISTRY_ID	BIGINT NOT NULL	The gift registry for which this announcement is created.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.
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.