DSH_BUILDER_PORTLET_DEFS

This table stores the definitions of all builder portlets.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KDSH_DATA_SOURCES

DATA_SOURCE_ID

DATA_SOURCE

Column Descriptions

Column Name

Null?

Data Type

Description

PORTLET_DEF_ID

NOT NULL

NUMBER (19)

System-generated identifier

DATA_SOURCE

NOT NULL

VARCHAR2 (200 Char)

Identifier for the data source

REQUIRE_EDIT_BEFORE_FIRST_VIEW

NOT NULL

CHAR (1 Char)

Flag to indicate whether edit is required before the first view

SHOW_PREFERENCE_SUMMARY

 

NOT NULL

CHAR (1 Char)

Flag to indicate whether preference summary is shown

SHOW_TOTAL

NULLABLE

CHAR (1 Char)

Flag to indicate whether total for a certain portlet is shown

Indexes

Index Name

Index Type

Sequence

Column Name

  DSH_BUILD_PORT_PK

UNIQUE

1

PORTLET_DEF_ID

Sequences

This table does not have any sequences.