IITEM

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

Column Descriptions:

NameTypeDescription
CATENTRY_IDBIGINT NOT NULLThe CatalogEntry ID of the product in the InterestItemList.
IITEMLIST_IDBIGINT NOT NULLThe InterestItemList to which this IItem is belongs.
MEMBER_IDBIGINT NOT NULLThe owner of the IItem (which is the same as the owner of the IItemList).
STOREENT_IDINTEGER NOT NULLThe StoreEntity to which this InterestItem belongs.
LASTUPDATETIMESTAMPThe last time this IItem was updated.
SEQUENCEDOUBLE NOT NULL DEFAULT 0May be used by a user interface to control the sequence of IItem in a IItemlist.
FIELD1INTEGERCustomizable.
FIELD2DECIMAL (20,5)Customizable.
QUANTITYDOUBLEThe 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.
FIELD3VARCHAR (254)Customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>IITEMLIST_ID+CATENTRY_IDPrimary Key
I0000584CATENTRY_IDNon-Unique Index
I0000585STOREENT_IDNon-Unique Index
I0000586MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_379IITEMLIST_IDIITEMLISTIITEMLIST_IDCascade
F_380MEMBER_IDMEMBERMEMBER_IDCascade
F_381STOREENT_IDSTOREENTSTOREENT_IDCascade
F_382CATENTRY_IDCATENTRYCATENTRY_IDCascade