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 Descriptions 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 SQL060903235213940 MEMBER_ID+VIEWNAME Primary Key Related reference
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