WebSphere Commerce database table: MBRVIEWPRF

This table stores view preferences for members.


Column Description(s):
Column NameColumn TypeDescription
MEMBER_ID BIGINT NOT NULL ID for the member, foreign key to the MEMBER table.
VIEWNAME VARCHAR(254) NOT NULL Corresponds to VIEWNAME column of VIEWREG table.
PREFERENCE BIGINT Foreign key to USERPVCDEV_ID in USERPVCDEV table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031239470 MEMBER_ID+VIEWNAME Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_456 MEMBER_ID MEMBER MEMBER_ID Cascade
F_455 PREFERENCE USERPVCDEV USERPVCDEV_ID Cascade

Feedback