CIITEMLIST

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

Column Descriptions:

NameTypeDescription
IITEMLIST_IDBIGINT NOT NULLThe interest item list which is a current list for one or more members.
MEMBER_IDBIGINT NOT NULLThe member to which the IItemlist is the current.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>IITEMLIST_ID+MEMBER_IDPrimary Key
I0000535MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_239IITEMLIST_IDIITEMLISTIITEMLIST_IDCascade
F_240MEMBER_IDMEMBERMEMBER_IDCascade