Share this page
DSH_BUILDER_DEF_PREFS
This table stores all the preferences of the portlet.
Foreign Keys
| Primary Key Table | Primary Key Column | Foreign Key Column |
|---|---|---|
| DSH_PORTLET_DEFS | PORTLET_DEF_ID | PORTLET_DEF_ID |
Column Descriptions
| Column Name | Null? | Data Type | Description |
|---|---|---|---|
| BUILDER_PORTLET_DEF_PREF_ID | NOT NULL | NUMBER(19,0) | ID of the table |
| VERSION | NOT NULL | NUMBER(10,0) | Version |
| NAME | NOT NULL | VARCHAR2(200 BYTE) | Name of the preference |
| TYPE | NOT NULL | VARCHAR2(30 BYTE) | Type of the preference |
| PROMPT | NOT NULL | VARCHAR2(200 BYTE) | Prompt of the preference |
| DEFAULT_VALUE | NULL | VARCHAR2(4000 BYTE) | Default value |
| DISPLAY_OPTION | NOT NULL | VARCHAR2(32 BYTE) | Display option of the preference, can be one of the followings: requiredEditablePref, editablePref, nonEditablePref, and hiddenPref |
| PORTLET_DEF_ID | NOT NULL | NUMBER(19,0) | The ID of table DSH_PORTLET_DEFS |
| LAYOUT_ROW | NOT NULL | NUMBER(10,0) | Row position in layout |
| LAYOUT_COLUMN | NOT NULL | NUMBER(10,0) | Column position in layout |
| LAYOUT_WIDTH | NOT NULL | NUMBER(10,0) | Width of the layout |
| DEFINITION_LANGUAGE | NOT NULL | VARCHAR2(40 BYTE) | Definition language |
| UUID | NOT NULL | VARCHAR2(255 BYTE) | System-generated identifier (UUID) |
| ADVANCED_DEF_PROPERTY | NULL | VARCHAR2(20 CHAR) | Advanced default property, can be one of the followings: NONE, USER_INFO and ENTITY_INFO |
Indexes
| Index Name | Index Type | Sequence | Column Name |
|---|---|---|---|
| DSH_BLD_DEF_IX1 | NONUNIQUE | 1 | PORTLET_DEF_ID |
| DSH_BLD_DEF_IX2 | NONUNIQUE | 1 | UUID |
| DSH_BUILD_PR_PK | UNIQUE | 1 | BUILDER_PORTLET_DEF_PREF_ID |
Sequences
This table does not have any sequences.
