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_


+

Search Tips   |   Advanced Search