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 |
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.