Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: IITEM
Each row of this table represents an IItem in an IItemList.
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 SQL100520030344360 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
_vcc_freeselect_bottom_