Database Table: MBRVIEWPRF

This table stores view preferences for members.

Column Name Column Type Column Description
MEMBER_ID BIGINT
NOT NULL
ID for the member, foreign key to the MEMBER table.
PREFERENCE BIGINT
NULL
Foreign key to USERPVCDEV_ID in USERPVCDEV table.
VIEWNAME VARCHAR (254)
NOT NULL
Corresponds to VIEWNAME column of VIEWREG table.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035002300 MEMBER_ID, VIEWNAME Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_455 PREFERENCE USERPVCDEV USERPVCDEV_ID Cascade
F_456 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable