WebSphere Commerce database table: MBRVIEWPRF

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

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

Member data model

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.

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