WebSphere Commerce database table: IITEM

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

Column Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235206950 IITEMLIST_ID+CATENTRY_ID Primary Key
I0000584 CATENTRY_ID Non-Unique Index
I0000585 STOREENT_ID Non-Unique Index
I0000586 MEMBER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names 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
Related reference