DSH_DRILL_TO_PORTLETS

This table stores the information of drill-down portlets.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
DSH_HYPERLINKS	BUILDER_PORTLET_DEF_LINK_ID	BUILDER_PORTLET_DEF_LINK_ID
DSH_PORTLET_DEFS	PORTLET_DEF_ID	DRILL_TO_PORTLET_DEFINITION_ID

Column Descriptions

Column Name	Null?	Data Type	Description
DRILL_TO_PORTLET_ID	NOT NULLABLE	NUMBER	System identifier for the drill-down portlet
VERSION	NOT NULLABLE	NUMBER	Row version information
DRILL_TO_PORTLET_DEFINITION_ID	NULLABLE	NUMBER	Reference to the portlet definition the drill-down portlet points to.
BUILDER_PORTLET_DEF_LINK_ID	NOT NULLABLE	NUMBER	Portlet definition the drill-down portlet is defined in as a hyperlink.
TITLE	NULLABLE	VARCHAR2(200)	Title of the drill-down portlet
DEFINITION_LANGUAGE	NOT NULLABLE	VARCHAR2(40)	Definition language for the drill-down portlet title. Titles of additional languages can be stored in the DSH_DRILL_TO_PORTLETS_LOC table.
LAYOUT_COLUMN	NOT NULLABLE	NUMBER	Column index (0 based) for the layout of the drill-down portlet.
LAYOUT_ROW	NOT NULLABLE	NUMBER	Row index (0 based) for the layout of the drill-down portlet.
LAYOUT_WIDTH	NOT NULLABLE	NUMBER	Width of the drill-down portlet (0 = default width, 1 or 2)
UUID	NOT NULLABLE	VARCHAR2(255)	System-generated unique identifier of the drill-down portlet.
SEQUENCE	NOT NULLABLE	NUMBER	Sequence of the drill-down portlet when multiple portlets are defined in a drill-down portlet.

Indexes

Index Name	Index Type	Sequence	Column Name
DSH_DRILL_PK	UNIQUE		DRILL_TO_PORTLET_ID
DSH_DR_POR_IX1	NONUNIQUE		BUILDER_PORTLET_DEF_LINK_ID
DSH_DR_POR_IX2	NONUNIQUE		DRILL_TO_PORTLET_DEFINITION_ID
DSH_DRILL_PORT_UUID_IX1	NONUNIQUE		UUID

Sequences

This table uses no sequences.