WebSphere Commerce database table: GREVTRMDLG

This table stores information about gift registry reminders.

Column Descriptions

Column Name	Column Type	Description
EVTRMDLG_ID	BIGINT NOT NULL	Primary key of the table.
GIFTREGISTRY_ID	BIGINT NOT NULL	The gift registry for which this reminder is logged.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.
SENTDATE	DATE NOT NULL	The date when the reminder is sent.
REMINDERTYPE	VARCHAR(32) NOT NULL	The type of reminder.

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235202440	EVTRMDLG_ID	Primary Key

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
GRE_CONSTRAINT2	GIFTREGISTRY_ID	GRGFTREG	GIFTREGISTRY_ID	No Action