Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CMFTSKMBREL
Holds the task member-specific information.
Column Name Column Type Description CMFTASK_ID BIGINT NOT NULL Forms the primary key along with MEMBER_ID. Foreign key to the CMFTASK table. MEMBER_ID BIGINT NOT NULL Forms the primary key together with CMFTASK_ID. Foreign key to the MEMBER table. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030317110 CMFTASK_ID+MEMBER_ID Primary Key I0000888 MEMBER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1133 CMFTASK_ID CMFTASK CMFTASK_ID Cascade F_1134 MEMBER_ID MEMBER MEMBER_ID Cascade _vcc_freeselect_bottom_