WebSphere Commerce database table: IITEM

Each row of this table represents an IItem in an IItemList.


Column Description(s):
Column NameColumn TypeDescription
CATENTRY_ID BIGINT NOT NULL The CatalogEntry ID of the product in the InterestItemList.
IITEMLIST_ID BIGINT NOT NULL The InterestItemList to which this IItem is belongs.
MEMBER_ID BIGINT NOT NULL The owner of the IItem (which is the same as the owner of the IItemList).
STOREENT_ID INTEGER NOT NULL The StoreEntity to which this InterestItem belongs.
LASTUPDATE TIMESTAMP The last time this IItem was updated.
SEQUENCE DOUBLE NOT NULL DEFAULT 0 May be used by a user interface to control the sequence of IItem in a IItemlist.
FIELD1 INTEGER Customizable.
FIELD2 DECIMAL (20,5) Customizable.
QUANTITY DOUBLE The result of multiplying QUANTITY by CATENTSHIP.NOMINALQUANTITY must be a multiple of CATENTSHIP.QUANTITYMULTIPLE, and represents the actual quantity being purchased, in the unit of measurement specified by CATENTSHIP.QUANTITYMEASURE.
FIELD3 VARCHAR(254) Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031232880 IITEMLIST_ID+CATENTRY_ID Primary Key
I0000584 CATENTRY_ID Non-Unique Index
I0000585 STOREENT_ID Non-Unique Index
I0000586 MEMBER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_382 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_379 IITEMLIST_ID IITEMLIST IITEMLIST_ID Cascade
F_380 MEMBER_ID MEMBER MEMBER_ID Cascade
F_381 STOREENT_ID STOREENT STOREENT_ID Cascade

Feedback