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 Descriptions:

Name	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	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
FIELD1	VARCHAR (64)	Customizable.
FIELD2	VARCHAR (64)	Customizable.
FIELD3	VARCHAR (64)	Customizable.
EVENTTYPENAME	VARCHAR (32) NOT NULL	The name of an event type.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	EVENTTYPE_ID	Primary Key
GRE_INDEX1	EVENTTYPENAME+STOREID	Unique Index

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
ETD_FK_1	EVENTTYPE_ID	GRETDESC	EVENTTYPE_ID	No Action
GRA_CONSTRAINT2	EVENTTYPE_ID	GRANNTMPLT	EVENTTYPE_ID	No Action
GR_FK_2	EVENTTYPE_ID	GRGFTREG	EVENTTYPE_ID	No Action