CIITEMLIST

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

Column Descriptions:

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	IITEMLIST_ID+MEMBER_ID	Primary Key
I0000535	MEMBER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_239	IITEMLIST_ID	IITEMLIST	IITEMLIST_ID	Cascade
F_240	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Related reference
Interest item data model