Database Table: IITEM

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

Column Name Column Type Column Description
CATENTRY_ID BIGINT
NOT NULL
The CatalogEntry ID of the product in the InterestItemList.
FIELD1 INTEGER
NULL
Customizable.
FIELD2 DECIMAL (20,5)
NULL
Customizable.
FIELD3 VARCHAR (254)
NULL
Customizable.
IITEMLIST_ID BIGINT
NOT NULL
The InterestItemList that this IItem is part of.
LASTUPDATE TIMESTAMP
NULL
The last time this IItem was updated.
MEMBER_ID BIGINT
NOT NULL
The owner of the IItem (which is the same as the owner of the IItemList).
QUANTITY DOUBLE
NULL
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.
SEQUENCE DOUBLE
NOT NULL, DEFAULT 0
May be used by a user interface to control the sequence of IItem in a IItemlist.
STOREENT_ID INTEGER
NOT NULL
The StoreEntity that this InterestItem belongs to.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034944380 IITEMLIST_ID, CATENTRY_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable