Each row of this table represents an IItem in an IItemList.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index 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 Name | Column Name(s) | Foreign Table Name | Foreign 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 |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.