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.