WebSphere Commerce database table: IITEMLIST

Each row in this table represents an InterestItemList.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000132 IITEMLIST_ID+SEQUENCE+MEMBER_ID Unique Index
I0000133 IITEMLIST_ID+MEMBER_ID Unique Index
SQL050212031233030 IITEMLIST_ID Primary Key
I0000587 MEMBER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_383 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_239 IITEMLIST_ID CIITEMLIST IITEMLIST_ID Cascade
F_379 IITEMLIST_ID IITEM IITEMLIST_ID Cascade

Feedback