Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CIITEMLIST
Each row in this table represents the relationship between an IItemlist and a member to which it is the current list.
Column Name Column Type Description IITEMLIST_ID BIGINT NOT NULL The interest item list which is a current list for one or more members. MEMBER_ID BIGINT NOT NULL The member to which the IItemlist is the current. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030314820 IITEMLIST_ID+MEMBER_ID Primary Key I0000535 MEMBER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_239 IITEMLIST_ID IITEMLIST IITEMLIST_ID Cascade F_240 MEMBER_ID MEMBER MEMBER_ID Cascade
Related reference
_vcc_freeselect_bottom_