IITEMLIST

Each row in this table represents an InterestItemList.

Column Descriptions:

NameTypeDescription
IITEMLIST_IDBIGINT NOT NULLGenerated unique key for this interest item list.
MEMBER_IDBIGINT NOT NULLThe owner of the IItemList.
DESCRIPTIONVARCHAR (254) NOT NULL DEFAULT ''A mnemonic description of the IItemList, entered by the customer and suitable for display to the customer.
SEQUENCEDOUBLE NOT NULL DEFAULT 0May be used by a user interface to control the sequence of IItemLists in a list.
LASTUPDATETIMESTAMPThe last time this IItemList was updated.
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_IDPrimary Key
I0000132IITEMLIST_ID+SEQUENCE+MEMBER_IDUnique Index
I0000133IITEMLIST_ID+MEMBER_IDUnique Index
I0000587MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_383MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_239IITEMLIST_IDCIITEMLISTIITEMLIST_IDCascade
F_379IITEMLIST_IDIITEMIITEMLIST_IDCascade