DSH_PREFERENCE_VALS

This table stores the portlet preferences values for the portlet preferences defined in the DSH_PORTLET_PREFERENCES table. There is no limit on the size of the text value that can be stored, but values larger than 4000 chars are saved in multiple rows.

Foreign Keys

Primary Key Table Primary Key Column Foreign Key Column
DSH_PORTLET_PREFERENCES PORTLET_PREFERENCE_ID PORTLET_PREFERENCE_ID

Column Descriptions

Column Name Null? Data Type Description
PORTLET_PREFERENCE_VALUE_ID NOT NULLABLE NUMBER System identifier for the portlet preference value
VERSION NOT NULLABLE NUMBER Row version information
PORTLET_PREFERENCE_ID NOT NULLABLE NUMBER FK to the portlet preference for which this value is defined
VALUE NULLABLE VARCHAR2(4000) Value of the portlet preference. When code meaning is saved, it is saved here as [code][meaning].
PREF_SEQUENCE NOT NULLABLE NUMBER If a preference value for a given PORTLET_PREFERENCE_ID is too large to fit into a single row (with sequence = 0), extra rows will be created to record the value, each with an increasing PREF_SEQUENCE value.

Indexes

Index Name Index Type Sequence Column Name
DSH_PREF_VALS_PK UNIQUE   PORTLET_PREFERENCE_VALUE_ID
DSH_PRE_VAL_IX1 NONUNIQUE   PORTLET_PREFERENCE_ID

Sequences

This table uses no sequences.