WebSphere Commerce database table: GREMLLIST

Reference > Database > WebSphere Commerce database tables > G

WebSphere Commerce database table: GREMLLIST

This table stores e-mail information about the recipients of an annoucement made for gift registries and wish lists.

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
SQL100520030339020 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
_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

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.