KNTA_PAGES
This table stores a row for each PPM Center web page with regular portlets. The maximized page of a regular portlet does not need a row in this table. This table has been deprecated in favor of the new DSH tables for the dashboard but is here to preserve data on an upgrade.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
CREATED_BY |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
PAGE_ID |
NOT NULL |
NUMBER |
System-generated identifier |
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
PAGE_NAME |
NOT NULL |
VARCHAR2(80) |
|
DESCRIPTION |
NULLABLE |
VARCHAR2(240) |
|
TITLE |
NOT NULL |
VARCHAR2(80) |
|
DEFINITION_LANGUAGE |
NOT NULL |
VARCHAR2(40) |
|
REFERENCE_CODE |
NOT NULL |
VARCHAR2(200) |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KNTA_PAGES_N1 |
NONUNIQUE |
1 |
PAGE_NAME |
KNTA_PAGES_U1 |
UNIQUE |
1 |
PAGE_ID |
SYS_C00109352576 |
UNIQUE |
1 |
REFERENCE_CODE |
Sequences
This table uses no sequences.