Reference > Database > WebSphere Commerce database tables > G
WebSphere Commerce database table: GRANNHIST
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 Name Column 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 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 SQL100520030338730 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
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type GRE_CONSTRAINT4 ANNHISTORY_ID GREMLLIST ANNHISTORY_ID Cascade _vcc_freeselect_bottom_