WebSphere Commerce database table: IITEMLIST

Each row in this table represents an InterestItemList.

Column Descriptions

Column Name	Column Type	Description
IITEMLIST_ID	BIGINT NOT NULL	Generated unique key for this interest item list.
MEMBER_ID	BIGINT NOT NULL	The owner of the IItemList.
DESCRIPTION	VARCHAR(254) NOT NULL DEFAULT ''	A mnemonic description of the IItemList, entered by the customer and suitable for display to the customer.
SEQUENCE	DOUBLE NOT NULL DEFAULT 0	May be used by a user interface to control the sequence of IItemLists in a list.
LASTUPDATE	TIMESTAMP	The last time this IItemList was updated.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
I0000132	IITEMLIST_ID+SEQUENCE+MEMBER_ID	Unique Index
I0000133	IITEMLIST_ID+MEMBER_ID	Unique Index
SQL060903235207110	IITEMLIST_ID	Primary Key
I0000587	MEMBER_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_383	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_239	IITEMLIST_ID	CIITEMLIST	IITEMLIST_ID	Cascade
F_379	IITEMLIST_ID	IITEM	IITEMLIST_ID	Cascade

Related reference

• Interest item data model