Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: IITEMLIST
Each row in this table represents an InterestItemList.
Column Name Column Type Description IITEMLIST_ID BIGINT NOT NULL Generated unique key for this interest item list. MEMBER_ID BIGINT NOT NULL The owner of the IItemList. DESCRIPTION VARCHAR(254) NOT NULL DEFAULT '' A mnemonic description of the IItemList, entered by the customer and suitable for display to the customer. SEQUENCE DOUBLE NOT NULL DEFAULT 0 May be used by a user interface to control the sequence of IItemLists in a list. LASTUPDATE TIMESTAMP The last time this IItemList was updated. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000132 IITEMLIST_ID+SEQUENCE+MEMBER_ID Unique Index I0000133 IITEMLIST_ID+MEMBER_ID Unique Index SQL100520030344540 IITEMLIST_ID Primary Key I0000587 MEMBER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_383 MEMBER_ID MEMBER MEMBER_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_239 IITEMLIST_ID CIITEMLIST IITEMLIST_ID Cascade F_379 IITEMLIST_ID IITEM IITEMLIST_ID Cascade
Related reference
_vcc_freeselect_bottom_