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 |