DSH_PORTLET_PREFERENCES

This table stores the portlet preferences definitions for portlets and drill-down portlets.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
DSH_DRILL_TO_PORTLETS	DRILL_TO_PORTLET_ID	DRILL_TO_PORTLET_ID
DSH_PORTLETS	PORTLET_ID	PORTLET_ID

Column Descriptions

Column Name	Null?	Data Type	Description
PORTLET_PREFERENCE_ID	NOT NULLABLE	NUMBER	System identifier for the portlet preference
VERSION	NOT NULLABLE	NUMBER	Row version information
NAME	NOT NULLABLE	VARCHAR2(200)	Preference name identifier
ADVANCED_DEF_PROPERTY	NULLABLE	VARCHAR2(200)	Advanced property info of the preference (for example, ENTITY_INFO)
PORTLET_ID	NOT NULLABLE IF DRILL_TO_PORTLET_ID IS NULL	NUMBER	FK to the portlet to which this preference refers
DRILL_TO_PORTLET_ID (Added in PPM 9.66)	NOT NULLABLE IF PORTLET_ID IS NULL	NUMBER	FK to the drill-down portlet which this preference refers

Indexes

Index Name	Index Type	Sequence	Column Name
DSH_PREF_PK	UNIQUE		PORTLET_PREFERENCE_ID
DSH_POR_PRE_IX1	NONUNIQUE		PORTLET_ID
DSH_POR_PRE_IX2	NONUNIQUE		DRILL_TO_PORTLET_ID

Sequences

This table uses no sequences.