Reference > Database > WebSphere Commerce database tables > M
WebSphere Commerce database table: MBRVIEWPRF
This table is deprecated and is provided for backward compatibility only. This table stores messaging view preferences for members.
Column Name Column Type Description MEMBER_ID BIGINT NOT NULL ID for the member, foreign key to the MEMBER table. VIEWNAME VARCHAR(254) NOT NULL Corresponds to name of view. PREFERENCE BIGINT Foreign key to USERPVCDEV_ID in USERPVCDEV table. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030354900 MEMBER_ID+VIEWNAME Primary Key I0001261 PREFERENCE Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_456 MEMBER_ID MEMBER MEMBER_ID Cascade F_455 PREFERENCE USERPVCDEV USERPVCDEV_ID Cascade
Related reference
_vcc_freeselect_bottom_