WebSphere Commerce database table: GREVNTTYPE

This tables stores event information for a gift registry.

Column Descriptions

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
SQL060903235202260	EVENTTYPE_ID	Primary Key

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