WebSphere Commerce database table: GREMLLIST

WebSphere Commerce database table: GREMLLIST

This table stores e-mail information used for gift registries, such as gift registry announcements

Column Descriptions
Column Name Column Type Description

EMAILLIST_ID BIGINT NOT NULL Primary key of the table.

ANNHISTORY_ID BIGINT NOT NULL Refers to the announcement associated with this e-mail list.

OPTCOUNTER SMALLINT Reserved for IBM internal use.

EMLTYPE INTEGER NOT NULL The type of the e-mail. The types are supported:
0: The recipient was addressed
1: The recipient was copied (that is CC'd)
2: The recipient was blind copied (that is, BCC'd)

NAME VARCHAR(32) The name of the receiver.

EMAIL VARCHAR(254) NOT NULL The e-mail address.

Indexes
Index Name Indexed Column Names Index Type

SQL060903235201950 EMAILLIST_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type

GRE_CONSTRAINT4 ANNHISTORY_ID GRANNHIST ANNHISTORY_ID Cascade

Column Name	Column Type	Description
EMAILLIST_ID	BIGINT NOT NULL	Primary key of the table.
ANNHISTORY_ID	BIGINT NOT NULL	Refers to the announcement associated with this e-mail list.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.
EMLTYPE	INTEGER NOT NULL	The type of the e-mail. The types are supported: 0: The recipient was addressed 1: The recipient was copied (that is CC'd) 2: The recipient was blind copied (that is, BCC'd)
NAME	VARCHAR(32)	The name of the receiver.
EMAIL	VARCHAR(254) NOT NULL	The e-mail address.