Reference > Database > WebSphere Commerce database tables > G
WebSphere Commerce database table: GREVTRMDLG
This table stores information about gift registry reminders.
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 SQL100520030339450 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 _vcc_freeselect_bottom_