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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035002300 | MEMBER_ID, VIEWNAME | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|