WebSphere Commerce database table: CIITEMLIST

Each row in this table represents the relationship between an IItemlist and a member to which it is the current list.

Column Descriptions
Column Name Column Type Description
IITEMLIST_ID BIGINT NOT NULL The interest item list which is a current list for one or more members.
MEMBER_ID BIGINT NOT NULL The member to which the IItemlist is the current.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235141200 IITEMLIST_ID+MEMBER_ID Primary Key
I0000535 MEMBER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_239 IITEMLIST_ID IITEMLIST IITEMLIST_ID Cascade
F_240 MEMBER_ID MEMBER MEMBER_ID Cascade
Related reference