Reference > Database > WebSphere Commerce database tables > M
WebSphere Commerce database table: MGPCONDELENVP
This table stores member group condition element values.
Column Name Column Type Description MGPCONDELENVP_ID BIGINT NOT NULL The member group condition element name-value pair ID. MGPCONDELE_ID BIGINT NOT NULL The member group condition element ID. NAME VARCHAR(254) NOT NULL The name-value pair name. VALUE VARCHAR(254) NOT NULL The name-value pair value. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030356330 MGPCONDELENVP_ID Primary Key I0001232 MGPCONDELE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3591 MGPCONDELE_ID MGPCONDELE MGPCONDELE_ID Cascade _vcc_freeselect_bottom_