Reference > Database > WebSphere Commerce database tables > G
WebSphere Commerce database table: GREVNTTYPE
This tables stores event information for a gift registry and wish list. The default event type id for a wish list is 0 and it applies to all stores. A new wish list event can be defined specific to a store.
Column Name Column Type Description EVENTTYPE_ID INTEGER NOT NULL Primary key for the event type. SORTORDER BIGINT NOT NULL The sequence number used for sorting the display order of available event types. Default sorting is in ascending order. STATUS INTEGER NOT NULL DEFAULT 1 Status of the event type. Two options are available:
- 0: The event type is not available to the public.
- 1: The event type is available to the public.
STOREID INTEGER NOT NULL The store identifier that identifies the store for this event type. OPTCOUNTER SMALLINT Reserved for IBM internal use. FIELD1 VARCHAR(64) Customizable. FIELD2 VARCHAR(64) Customizable. FIELD3 VARCHAR(64) Customizable. EVENTTYPENAME VARCHAR(32) NOT NULL The name of an event type.
Indexes Index Name Indexed Column Names Index Type GRE_INDEX1 EVENTTYPENAME+STOREID Unique Index SQL100520030339300 EVENTTYPE_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type GRA_CONSTRAINT2 EVENTTYPE_ID GRANNTMPLT EVENTTYPE_ID No Action ETD_FK_1 EVENTTYPE_ID GRETDESC EVENTTYPE_ID No Action GR_FK_2 EVENTTYPE_ID GRGFTREG EVENTTYPE_ID No Action _vcc_freeselect_bottom_