DSH_PORTLETS

This table stores information of all the portlets.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

DSH_PORTLET_DEFS

PORTLET_DEF_ID

PORTLET_DEF_ID

DSH_PAGES

PAGE_ID

PAGE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PORTLET_ID

NOT NULL

NUMBER

System-generated identifier

VERSION

NOT NULL

NUMBER

Version for the portlet

PORTLET_DEF_ID

NOT NULL

NUMBER

Portlet definition ID

PAGE_ID

NOT NULL

NUMBER

Page ID. A portlet can only be associated with, and therefore, displayed on one page.

LAYOUT_WIDTH

NOT NULL

NUMBER

The width (for columns) of the portlet when it appears on its page with other portlets in a layout. For now, only the values 1 and 2 are supported with 1=short and 2=wide.

LAYOUT_COLUMN

NOT NULL

NUMBER

The zero-based column of the portlet when it appears on its page with other portlets in a layout. For now, only the values 0 and 1 are supported, with 0= the first column and 1= the second column.

LAYOUT_ROW

NOT NULL

NUMBER

The zero-based row of the portlet when it appears on its page with other portlets in a layout.

TITLE

NOT NULL

VARCHAR2 (200)

The string name of the portlet.

IS_MINIMIZED

NOT NULL

CHAR (1)

Flag to indicate whether the portlet is minimized into a bar, rather than displaying its content.

HAS_CHANGED_SINCE_VIEW

NOT NULL

CHAR (1)

Flg to indicate whether the portlet was created or modified by the module distribution process. Once the owner views the portlet for the first time, the flat is set back to false. This flag is deprecated.

LAST_UPDATE_DATE

NULLABLE

DATE

Date when the record was last updated

TOUCH

NULLABLE

VARCHAR2 (1)

A meaningless scratch column. Its value is never used for any functional purpose. We just change it to force the page object's version to increment.

IS_PORTLET_COMM

NOT NULL

CHAR (1)

Flag to indicate whether the portlet communication is enabled for this portlet.

UUID

NOT NULL

VARCHAR2 (255)

Universally unique identifier

IS_PAGE_FILTERS_ENABLED

NOT NULL

CHAR (1)

Flag to indicate whether page filters are enabled for this portlet.

BORDERLESS

NOT NULL

CHAR (1)

True if this portlet is presented without a border.

DEFINITION_LANGUAGE

NOT NULL

VARCHAR2 (40)

The language definition for MLU

SHOW_TOTAL_ROW_COUNT

NOT NULL

CHAR (1)

Flag to indicate whether this portlet shows total row count.

EXPORT_TO_HTML_EXCEL NOT NULL CHAR (1) Flag to indicate whether this portlet is exported to HTML format Excel.
LAYOUT NULL VARCHAR(4000) Stores portlet layout information to support more layouts of portlets.

Indexes

Index Name

Index Type

Sequence

Column Name

DSH_PORTLETS_PK

UNIQUE

1

PORTLET_ID

DSH_PORT_IX1

NON-UNIQUE

1

PORTLET_DEF_ID

DSH_PORT_IX2

NON-UNIQUE

1

PAGE_ID

DSH_PORT_IX3

NON-UNIQUE

1

UUID

Sequences

This table does not have any sequences.