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.