IITEM

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

Column Descriptions:

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	IITEMLIST_ID+CATENTRY_ID	Primary Key
I0000584	CATENTRY_ID	Non-Unique Index
I0000585	STOREENT_ID	Non-Unique Index
I0000586	MEMBER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_379	IITEMLIST_ID	IITEMLIST	IITEMLIST_ID	Cascade
F_380	MEMBER_ID	MEMBER	MEMBER_ID	Cascade
F_381	STOREENT_ID	STOREENT	STOREENT_ID	Cascade
F_382	CATENTRY_ID	CATENTRY	CATENTRY_ID	Cascade

Related reference
Interest item data model