Oracle® Fusion Middleware Database Administration Guide for Oracle WebLogic Portal 10g Release 3 (10.3.5) Part Number E14233-03 |
|
|
View PDF |
This chapter describes the database objects for each component of WebLogic Portal. The information in this section is collectively known as the data dictionary.
For each component of WebLogic Portal, the following information is provided:
An entity-relationship diagram
A detailed description of each database table, including:
Table Name – The predefined name for the Table.
Table Description – A detailed description of the contents and purpose for the table in WebLogic Portal database schema.
Column Name – The predefined name for the column.
Data Type – The predefined characteristics for the column.
Data types vary slightly by DBMS. For instance, columns defined as BLOB data types in Oracle, DB2, and Derby would be defined as TEXT columns in Microsoft SQL Server and Sybase.
Null Value – Indicates whether or not null values can be stored for the column.
Column Description – A detailed description of the contents and purpose for the column including Primary Key (PK-) and Foreign Key (FK-) designations.
Note:
The term hint in the descriptions refers to available capabilities that are not supported in the default skeletons provided with WebLogic Portal.
The New or Changed Version column indicates the version of WebLogic Portal in which a table or column was added or altered. If the New or Changed Version column does not exist, the table or column was created prior to the 9.2 or 10.0release of WebLogic Portal.
This chapter contains the following sections:
Section 10.7, "Content Management Virtual Content Repository Database Objects"
Section 10.8, "RDBMS Security Store Tables"
Note:
The appendix Appendix A, "Scripts and Properties Files" identifies the filenames and location of DDL (database definition language) files for each set of WebLogic Portal database objects.
Personalization enables you to develop, manage, and measure personalized portal applications. These functions help you target content to a desired audience. This includes the tracking of anonymous users and behavior tracking.
For an entity relation diagram of the Personalization database tables, see Figure B-1, "Personalization Database Tables".
The following tables support basic personalization functionality:
Section 10.1.1.22, "Entitlement Reference Dictionary Tables"
This table associates users with profiles. User profiles use property sets to organize the properties that they contain.
Some objects in WebLogic Portal implement a Java interface called ConfigurableEntity. Any ConfigurableEntity within the system has an entry in this table.
Table 10-2 ENTITY Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
ENTITY_ID |
NUMBER(15) |
Not Null |
PK – A unique, sequence-generated number used as the record identifier. |
ENTITY_NAME |
VARCHAR(200) |
Not Null |
The name of the ConfigurableEntity. |
ENTITY_TYPE |
VARCHAR(100) |
Not Null |
Defines the type of ConfigurableEntity. |
CREATION_DATE |
DATE |
Not Null |
The date and time this record was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time this record was last modified. |
Any property assigned to a ConfigurableEntity has a unique PROPERTY_ID
. The identifier and associated information is stored in the following table.
Table 10-3 PROPERTY_KEY Table Metadata
Column Name | Data Type | Null Value | Description and Recommendations |
---|---|---|---|
PROPERTY_KEY_ID |
NUMBER(15) |
Not Null |
PK – A unique, system-generated number used as the record identifier. |
PROPERTY_NAME |
VARCHAR(100) |
Not Null |
The property name. |
CREATION_DATE |
DATE |
Not Null |
The date and time this record was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time this record was last modified. |
PROPERTY_SET_NAME |
VARCHAR(100) |
Null |
The name of the property set. |
PROPERTY_SET_TYPE |
VARCHAR(100) |
Null |
The type the property set. |
This table stores property values for boolean, datetime, float, integer, text, and user-defined properties.
Table 10-4 PROPERTY_VALUE Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
PROPERTY_VALUE_ID |
NUMBER(15) |
Not Null |
PK – A unique, system-generated number used as the record identifier. |
PROPERTY_KEY_ID |
NUMBER(15) |
Not Null |
FK to |
ENTITY_ID |
NUMBER(15) |
Not Null |
FK to |
PROPERTY_TYPE |
NUMBER(1) |
Not Null |
Valid entries are: 0=Boolean, 1=Integer, 2=Float, 3=Text, 4=Date and Time, 5=User-Defined (BLOB). |
CREATION_DATE |
DATE |
Not Null |
The date and time this record was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time this record was last modified. |
BOOLEAN_VALUE |
NUMBER(1) |
Null |
The value for each boolean property identifier. |
DATETIME_VALUE |
DATE |
Null |
The value for each date and time property identifier. |
DOUBLE_VALUE |
NUMBER |
Null |
The value associated with each float property identifier. |
LONG_VALUE |
NUMBER(20) |
Null |
The value associated with the integer property. |
TEXT_VALUE |
VARCHAR(254) |
Null |
The value associated with the text property. |
BLOB_VALUE |
BLOB |
Null |
The value associated with the user-defined property. |
The SEQUENCER
table maintains all of the sequence identifiers (for example, property_meta_data_id_sequence, and so on) used in the application.
Table 10-5 SEQUENCER Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
SEQUENCE_NAME |
VARCHAR(50) |
Not Null |
PK – A unique name used to identify the sequence. |
CURRENT_VALUE |
NUMBER(15) |
Not Null |
The current value of the sequence. |
IS_LOCKED |
NUMBER(1) |
Not Null |
This flag identifies whether or not the particular SEQUENCE_ID has been locked for update, and has a value of 0 or 1. This column is used as a generic locking mechanism that can be used for multiple database environments. |
This table was added in WebLogic Portal version 9.2. It maintains user, group, and password information for the WebLogic Server SQLAuthenticator.
This table was added in WebLogic Portal version 9.2. It maintains information on groups and their descriptions.
This table was added in WebLogic Portal version 9.2. It maintains group hierarchy information.
This table was added in WebLogic Portal version 9.2. It allows an Administration Console user or visitor tools user to disable modifications to portal resources, and allows you to send multicast messages to a member of a cluster.
Table 10-9 P13N_QUIESCENT_STATE Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
ENTAPP_NAME |
VARCHAR(255) |
Not Null |
PK – Name of the enterprise application. |
9.2 |
WEBAPP_NAME |
VARCHAR(255) |
Not Null |
PK – Name of the web application. |
9.2 |
RESOURCE_NAME |
VARCHAR(255) |
Not Null |
PK – The name of an entitled or delegated resource; for example, CONTENT, PORTAL. |
9.2 |
CAPABILITY_NAME |
VARCHAR(80) |
Not Null |
PK – The name of allowed operations/capabilities; anything that allows you to the manipulate the system. |
9.2 |
MODE_NAME |
VARCHAR(80) |
Not Null |
The name of the quiescence mode; for example, BLOCKED. |
9.2 |
MODE_ENABLED_USER_ NAME |
VARCHAR(200) |
Not Null |
The name of the person who turned on quiescence for DT, or who set the BLOCKED mode for the resource. |
9.2 |
This table was added in WebLogic Portal version 9.2. It is used internally to maintain an exclusive lease request across any application connecting to the same database, in order to prevent multiple conflicting processes. The values in the table are transient and rows in the table should exist only as long as the lease is of value. If for some reason the row is not deleted automatically, WebLogic Portal will update any row as needed when another request with the same name occurs.
The following examples show how this lease data is used:
A WebLogic Portal lease manager locks a resource for startup/update for a specified period of time, and a propagation is running on one node in the cluster. If another node attempts to start a propagation, the lease prevents the second process from beginning at that time.
A WebLogic Portal lease manager uses this table to synchronize distribution of portal framework data within a cluster.
This table is used for internal processing only and is not accessible using the WebLogic Portal Administration Console.
Table 10-10 P13N_LEASE Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
LEASE_NAME |
VARCHAR(80) |
Not Null |
PK – Unique name of the lease requested. |
9.2 |
CREATION_DATE |
TIMESTAMP |
Not Null |
Date and time the lease was requested. The default value is the current timestamp. |
9.2 |
EXPIRATION_DATE |
TIMESTAMP |
Not Null |
Date and time the lease will expire |
9.2 |
SERVER_NAME |
VARCHAR(80) |
Not Null |
Name of the server requesting the lease. |
9.2 |
For an entity relation diagram of the Personalization Credential Service tables, see Figure B-2, "Personalization Credential Service Database Tables".
The Credential tables include the following:
This table was added in WebLogic Portal 10.2. The table stores credential user name and password information for accessing external system resources.
Table 10-11 P13N_CREDENTIAL Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
CREDENTIAL_ID |
INTEGER |
Not Null |
A unique system-generated number to use as the record identifier. |
10.2 |
CREDENTIAL_MASTER_ID |
INTEGER |
Not Null |
FK – A Foreign Key to P13N_CREDENTIAL_MASTER |
10.2 |
USER_NAME |
VARCHAR(200) |
Not Null |
The name of the user. |
10.2 |
CREATION_DATE |
DATETIME |
Not Null |
Date and time the row was created. |
10.2 |
MODIFIED_DATE |
DATETIME |
Not Null |
Date and time the row was last modified. |
10.2 |
CREDENTIAL_PRINCIPAL |
BLOB(5M) |
Null |
Encrypted login information for the external credentialed system. |
10.2 |
CREDENTIAL_PASSWORD |
BLOB(5M) |
Null |
Encrypted password for the external credentialed system. |
10.2 |
This table was added in WebLogic Portal 10.2. The table is used to identify the enterprise and web application associated with a credentialed system.
Table 10-12 P13N_CREDENTIAL_APPLICATION Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
CREDENTIAL_APPLICATION_ID |
INTEGER |
Not Null |
A unique system-generated number to use as the record identifier. |
10.2 |
ENTAPP_NAME |
VARCHAR(255) |
Null |
The name of a credentialed enterprise application. |
10.2 |
WEBAPP_NAME |
VARCHAR(255) |
Null |
The name of a credentialed web application. |
10.2 |
This table was added in WebLogic Portal 10.2. The table is used to reference the credentialed system. For example, a SAP system or SAP portlets, or a Documentum or SharePoint Content Repository.
Table 10-13 P13N_CREDENTIAL_MASTER Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
CREDENTIAL_MASTER_ID |
INTEGER |
Not Null |
FK – A Foreign Key to P13N_CREDENTIAL_MASTER |
10.2 |
CREDENTIAL_APPLICATION_ID |
INTEGER |
Not Null |
A unique system-generated number to use as the record identifier. FK – A Foreign Key to P13N_CREDENTIAL_APPLICATION |
10.2 |
RESOURCE_NAME |
VARCHAR(255) |
Not Null |
The name of the resource having a credential. |
10.2 |
CREDENTIAL_NAME |
VARCHAR(255) |
Not Null |
The name identifying the credential or external credential system. |
10.2 |
CREDENTIAL_SCOPE |
SMALLINT |
Not Null |
The type of the credential. Valid values include: 0=Resource; 1=User; 2=System. |
10.2 |
DESCRIPTION |
VARCHAR(512) |
Null |
Optional. Description of the credential or external credential system. |
10.2 |
This table was added in WebLogic Portal 10.2. The table is used to identify the attributes of the credential.
Table 10-14 P13N_CREDENTIAL_METADATA Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
CREDENTIAL_ID |
INTEGER |
Not Null |
A unique system-generated number to use as the record identifier. PK/FK – A Foreign Key to P13N_ CREDENTIAL |
10.2 |
METADATA_NAME |
VARCHAR(512) |
Not Null |
PK - A name identifying the meta data value. For example: SAP URL. |
10.2 |
CREATION_DATE |
DATETIME |
Not Null |
Date and time the row was created. |
10.2 |
MODIFIED_DATE |
DATETIME |
Not Null |
Date and time the row was last modified. |
10.2 |
TEXT_VALUE |
VARCHAR(512) |
Not Null |
The actual value of the metadata. |
10.2 |
For an entity relation diagram of the Personalization Job Scheduler tables, see Figure B-3, "Personalization Job Scheduler Database Tables".
The Job Scheduler tables include the following:
This table was added in WebLogic Portal 10.2. The table is currently for internal use only and is reserved for future customer use. This table defines job run types and schedule information.
Table 10-15 P13N_JOB_DEFINITION Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
JOB_NAME |
VARCHAR(255) |
Not Null |
PK - A unique name for the job within a web application. |
10.2 |
APPLICATION_NAME |
VARCHAR(100) |
Not Null |
PK - The enterprise application name. |
10.3 |
WEBAPP_NAME |
VARCHAR(255) |
Null |
PK - The name of a web application. |
10.2 |
JOB_GROUP_NAME |
VARCHAR(80) |
Null |
Optional. A user-defined group name associated with the job or group of jobs. For content publishing, for example, App init job group. |
10.2 |
SERVER_NAME |
VARCHAR(80) |
Null |
Optional. The name of the server where the job should run. |
10.2 |
JOB_TYPE |
VARCHAR(10) |
Not Null |
The type of job. |
10.2 |
IS_ENABLED |
SMALLINT |
Not Null |
A Boolean indicating that the job is enabled for execution. Default=1 (true). |
10.2 |
IS_REMOVE_AFTER_RUN |
SMALLINT |
Not Null |
A Boolean that indicates to the job manager that the job definition should be deleted after the job runs. |
10.2 |
CLASS_NAME |
VARCHAR(255) |
Not Null |
Class name that the job represents. |
10.2 |
RUN_INTERVAL |
INTEGER |
Null |
Time in minutes that the job should run or Null. |
10.2 |
RUN_YEAR |
SMALLINT |
Null |
Year YYYY that the job should run or Null. |
10.2 |
RUN_MONTH |
SMALLINT |
Null |
Month MM that the job should run or Null. |
10.2 |
RUN_DAY |
SMALLINT |
Null |
Day DD that the job should run or Null. |
10.2 |
RUN_HOUR |
SMALLINT |
Null |
Hour that the job should run or Null. Based on a 24-hour clock. |
10.2 |
RUN_MINUTE |
SMALLINT |
Null |
Minute of the hour that the job should run. Defaults to 0. |
10.2 |
DESCRIPTION |
VARCHAR(255) |
Null |
Optional. User-defined description of the job. |
10.2 |
This table was added in WebLogic Portal 10.2. The table is currently for internal use only and is reserved for future customer use. The table defines listener classes for a given job.
Table 10-16 P13N_JOB_LISTENER Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
JOB_NAME |
VARCHAR(255) |
Not Null |
PK – A unique name for the job. FK - references P13N_JOB_DEFINITION. JOB_NAME |
10.2 |
LISTENER_NAME |
VARCHAR(255) |
Not Null |
PK – A unique name for the job listener. |
10.2 |
CLASS_NAME |
VARCHAR(255) |
Not Null |
Job listener class name. |
10.2 |
APPLICATION_NAME |
VARCHAR(100 |
Not Null |
PK - The enterprise application name. FK - references P13N_JOB_DEFINITION.APPLICATION_NAME |
10.3 |
WEBAPP_NAME |
VARCHAR(255) |
Not Null |
PK - The web application name. FK - References P13N_JOB_DEFINITION.WEBAPP_NAME |
10.3 |
This table was added in WebLogic Portal 10.2. The table is currently for internal use only and is reserved for future customer use. The table defines job run parameter name value pairs.
Table 10-17 P13N_JOB_PARAMETER Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
JOB_NAME |
VARCHAR(255) |
Not Null |
PK – A unique name for the job. FK – References P13N_JOB_DEFINITION. JOB_NAME |
10.2 |
APPLICATION_NAME |
VARCHAR(100) |
Not Null |
PK - The enterprise application name. FK - references P13N_JOB_DEFINITION.APPLICATION_NAME |
10.3 |
WEBAPP_NAME |
VARCHAR(255) |
Not Null |
PK - The web application name FK - References P13N_JOB_DEFINITION.WEBAPP_NAME |
10.3 |
PARAMETER_NAME |
VARCHAR(255) |
Not Null |
PK – A unique job parameter name supplied at job run time. For example, App default e-mail. |
10.2 |
PARAMETER_VALUE |
VARCHAR(255) |
Not Null |
A job parameter value supplied at run time. For example, feedback@customer.com. |
10.2 |
This table was added in WebLogic Portal 10.2. The table is currently for internal use only and is reserved for future customer use. The table groups run information about job executions.
Table 10-18 P13N_JOB_RUN_HEADER Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
JOB_RUN_HEADER_ID |
INTEGER |
Not Null |
PK – A unique system-generated header ID for the job run. |
10.2 |
JOB_NAME |
VARCHAR(255) |
Not Null |
A unique name for the job. |
10.2 |
SERVER_NAME |
VARCHAR(80) |
Not Null |
Optional. The name of the server where the job should run. |
10.2 |
APPLICATION_NAME |
VARCHAR(100) |
Not Null |
The application name. |
10.3 |
WEBAPP_NAME |
VARCHAR(255) |
Null |
The name of the web application in which the job should run. |
10.2 |
This table was added in WebLogic Portal 10.2. The table is currently for internal use only and is reserved for future customer use. The table stores job run data associated with execution of the job.
Table 10-19 P13N_JOB_RUN_DATA Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
JOB_RUN_GUID |
VARCHAR(255) |
Not Null |
PK – A system-generated, global, unique identifier for the job's execution. |
10.2 |
JOB__RUN_HEADER_ID |
INTEGER |
Not Null |
FK – A Foreign Key to P13N_JOB_RUN_ HEADER. |
10.2 |
RUN_STATUS |
VARCHAR(20) |
Not Null |
Status of the job run. Valid values include RUNNING, COMPLETED, INCOMPLETE, FAILED, and SUCCESS. |
10.2 |
START_DATETIME |
NUMERIC(15,0) |
Null |
The date and time the job run started. |
10.2 |
END_DATETIME |
NUMERIC(15,0) |
Null |
The date and time the job run finished. |
10.2 |
LEASE_NAME |
VARCHAR(160) |
Null |
The name of the lease associated with the job run. |
10.2 |
RUN_DATA |
CLOB(30M) |
Null |
Data retained about the job run. |
10.2 |
ERROR_DATA |
CLOB(30M) |
Null |
Error information for a failed job. |
10.2 |
For an entity relation diagram of the Entitlement database tables, see Figure B-4, "Entitlement Database Tables".
The following tables are used by the Administration Console to maintain security policy reference data as policies are created, edited, and deleted. These tables allow efficient searching for policies given a role name, resource ID web application name, and so on.
The Entitlement tables include the following:
This table uniquely identifies an application for which entitlements can be applied.
Table 10-20 P13N_ENTITLEMENT_APPLICATION Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
ENTITLEMENT_APP_ID |
NUMBER(15) |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
ENTAPP_NAME |
VARCHAR(255) |
Not Null |
The name of the enterprise application. |
WEBAPP_NAME |
VARCHAR(255) |
Null |
The name of the web application. |
ENTITLEMENT_APP_ DESCRIPTION |
VARCHAR(255) |
Null |
The description of the enterprise application. |
CREATION_DATE |
DATE |
Not Null |
The date and time the record was created; the default is the current time stamp. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the record was last modified; the default is the current time stamp. |
This table uniquely identifies an entitlement policy. An entitlement policy is created when an entitlement role is associated with an entitlement resource and capability.
Table 10-21 P13N_ENTITLEMENT_POLICY Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
RESOURCE_ENT_APP_ID |
NUMBER(15) |
Not Null |
PK and FK to |
|
RESOURCE_ID |
NUMBER(15) |
Not Null |
PK and FK to |
|
ROLE_ENT_APP_ID |
NUMBER(15) |
Not Null |
PK and FK to |
|
ROLE_ID |
NUMBER(15) |
Not Null |
PK and FK to |
|
POLICY_RESOURCE_ CAPABILITY |
VARCHAR(80) |
Not Null |
PK – Identifies the unique capability of this policy instance. |
|
CREATION_DATE |
DATE |
Not Null |
The date and time the record was created; the default is the current time stamp. |
|
MODIFIED_DATE |
DATE |
Not Null |
The date and time the record was last modified; default value is the current time stamp. |
|
ROLE_PROVIDER_NAME |
VARCHAR(80) |
Not Null |
The name given the deployed Role Mapping provider holding the role definition. |
|
ATZ_PROVIDER_NAME |
VARCHAR(80) |
Not Null |
The name of the authorization provider. |
9.2 |
This table uniquely identifies an application resource that can have an entitlement associated with it.
Table 10-22 P13N_ENTITLEMENT_RESOURCE Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
ENTITLEMENT_APP_ID |
NUMBER(15) |
Not Null |
PK and FK to |
|
RESOURCE_ID |
NUMBER(15) |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
|
RESOURCE_NAME |
VARCHAR(882) |
Not Null |
The name of the resource having a policy applied on it. |
9.2 |
RESOURCE_DESCRIPTION |
VARCHAR(255) |
Null |
Optional description of resource. |
|
RESOURCE_METADATA |
VARCHAR(255) |
Null |
Optional application-defined metadata. |
|
CREATION_DATE |
DATE |
Not Null |
The date and time the record was last modified; the default is the current time stamp. |
|
MODIFIED_DATE |
DATE |
Not Null |
The date and time the record was last modified; the default is the current time stamp. |
This table uniquely identifies entitlement and delegated administration roles for a given application.
Table 10-23 P13N_ENTITLEMENT_ROLE Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
ENTITLEMENT_APP_ID |
NUMBER(15) |
Not Null |
PK and FK to |
|
ROLE_ID |
NUMBER(15) |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
|
ROLE_NAME |
VARCHAR(255) |
Not Null |
The name of the security role. |
|
ROLE_DESCRIPTION |
VARCHAR(255) |
Null |
Optional description of the role. |
|
ROLE_SEGMENT |
VARCHAR(255) |
Null |
Optional role expression name. |
|
CREATION_DATE |
DATE |
Not Null |
The date and time the record was last modified; the default is the current time stamp. |
|
MODIFIED_DATE |
DATE |
Not Null |
The date and time the record was last modified; the default is the current time stamp. |
|
ROLE_PROVIDER_NAME |
VARCHAR(80) |
Not Null |
Identifies the policy role mapper provider; default value = DefaultRoleMapper |
9.2 |
This table uniquely identifies an entitlement hierarchy. An entitlement hierarchy is associated with P13N_ENTITLEMENT_APPLICATION.
Table 10-24 P13N_DELEGATED_HIERARCHY Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
ENTITLEMENT_APP_ID |
NUMBER(15) |
Not Null |
PK and FK to |
ENTITLEMENT_DOCUMENT |
CLOB |
Not Null |
An XML document containing the Delegated Administration role hierarchy. |
CREATION_DATE |
DATE |
Not Null |
The date and time the record was last modified; the default is the current time stamp. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the record was last modified; the default is the current time stamp. |
This section documents the database objects for the WebLogic Portal package. For more information about anonymous users, refer to the Oracle Fusion Middleware User Management Guide for Oracle WebLogic Portal.
The following tables support tracking of anonymous users:
This table stores the properties associated with the tracked anonymous user.
Table 10-25 P13N_ANONYMOUS_PROPERTY Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
ANONYMOUS_PROPERTY_ID |
VARCHAR(128) |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
PROPERTY_SET_NAME |
VARCHAR(100) |
Not Null |
The name of the property set for which the tracked anonymous user data is set. |
PROPERTY_NAME |
VARCHAR(100) |
Not Null |
The name of the property being tracked for the anonymous user. |
ANONYMOUS_USER_ID |
VARCHAR(128) |
Not Null |
FK - A foreign key to P13N_ANONYMOUS_USER. |
PROPERTY_VALUE |
BLOB |
Not Null |
The value of the property that must implement |
This table stores the tracked anonymous user data.
Table 10-26 P13N_ANONYMOUS_USER Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
ANONYMOUS_USER_ID |
VARCHAR(128) |
Not Null |
FK – Maps to the primary key of the anonymous user. |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
LAST_VISIT_DATE |
DATE |
Null |
Date when the tracked anonymous user last updated the data. |
For an entity relation diagram of the Behavior Tracking tables, see Figure B-5, "Behavior Tracking Database Tables".
Each DBMS-specific chapter of this guide describes how to set up a separate behavior tracking database. Three tables are provided for behavior tracking data. The BT_EVENT
table stores all event data. The BT_EVENT_ACTION
table logs actions used by third-party vendors against the recorded event data, and the BT_EVENT_TYPE
table references event types and categories in the EVENT
table.
For more information about behavior tracking, refer to the Oracle Fusion Middleware Interaction Management Guide for Oracle WebLogic Portal.
This table references event types and categories in the BT_EVENT
table. This table is static.
Table 10-27 BT_EVENT_TYPE Database Table
Column Name | Data Type | Null Value | Description |
---|---|---|---|
EVENT_TYPE |
VARCHAR(30) |
Not Null |
PK - A unique, system-generated number used as the record ID. |
EVENT_GROUP |
VARCHAR(10) |
Not Null |
The event category group associated with the event type. |
DESCRIPTION |
VARCHAR(50) |
Null |
A description of the |
To record custom events, you must create an entry in this table. If a custom event does not have a record in this table, you cannot persist it to the BT_EVENT
table.
This table stores all behavior tracking event data.
Table 10-28 BT_EVENT Database Table
Column Name | Data Type | Null Value | Description |
---|---|---|---|
EVENT_ID |
NUMBER |
Not Null |
PK - A unique, system-generated number used as the record ID. |
APPLICATION |
VARCHAR (30) |
Not Null |
The application that created the event. |
EVENT_TYPE |
VARCHAR(30) |
Not Null |
FK - Set to BT_EVENT_TYPE. A string identifier showing which event was fired. |
EVENT_DATE |
DATE |
Not Null |
The date and time of the event. |
WLS_SESSION_ID |
VARCHAR(254) |
Not Null |
A unique, WebLogic Server-generated number assigned to the session. |
XML_DEFINITION |
CLOB |
Null |
An XML document that contains the specific event information for each event type. It is stored as a |
USER_ID |
VARCHAR(50) |
Null |
The user ID associated with the session and event. If the user has not logged in this column is null. |
ANONYMOUS_USER_ ID |
VARCHAR(128) |
Null |
The user ID of the anonymous user associated with the session and event, if applicable. |
As shown in Table 10-42, the BT_EVENT
table has eight columns; each column corresponds to a specific event element. Seven of the BT_EVENT
table's columns contain data common to every event type. The XML_DEFINITION
column contains information about the application, event-date, event-type, session-id, and user-id, plus event data that is unique to each event type. An XML
document is created specifically for each event type. The data elements corresponding to each event type are captured in the XML_DEFINITION
column of the EVENT
table. These elements are listed in Table 10-42.
Table 10-29 XML_DEFINITION Data Elements
Event | Data Element |
---|---|
AddToCartEvent |
application event-date event-type session-id user-id sku quantity unit-list-price currency application-name |
BuyEvent |
application event-date event-type session-id user-id sku quantity unit-price currency application-name order-line-id |
CampaignUserActivityEvent |
application event-date event-type session-id user-id campaign-id scenario-id |
ClickCampaignEvent |
application event-date event-type session-id user-id document-type document-id campaign-id scenario-id application-name placeholder-id |
ClickContentEvent |
application event-date event-type session-id user-id document-type document-id |
ClickProductEvent |
application event-date event-type session-id user-id document-type document-id sku category-id application-name |
DisplayCampaignEvent |
application event-date event-type session-id user-id document-type document-id campaign-id scenario-id application-name placeholder-id |
DisplayContentEvent |
application event-date event-type session-id user-id document-type document-id |
DisplayProductEvent |
application event-date event-type session-id user-id document-type document-id sku category-id application-name |
PurchaseCartEvent |
application event-date event-type session-id user-id total-price order-id currency application-name |
RemoveFromCartEvent |
application event-date event-type session-id user-id sku quantity unit-price currency application-name |
RuleEvent |
application event-date event-type session-id user-id ruleset-name rule-name |
SessionBeginEvent |
application event-date event-type session-id user-id |
SessionEndEvent |
application event-date event-type session-id user-id |
SessionLoginEvent |
application event-date event-type session-id user-id |
UserRegistrationEvent |
application event-date event-type session-id user-id |
This table logs actions used by third-party vendors against the recorded event data.
Table 10-30 BT_EVENT_ACTION Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
EVENT_ACTION |
VARCHAR(30) |
Not Null |
The event action taken such as |
ACTION_DATE |
DATE |
Not Null |
The date and time of the event. This field is one of the table's primary keys. |
EVENT_ID |
NUMBER |
Null |
The |
For an entity relation diagram of the Data Synchronization tables, see Figure B-6, "Data Synchronization Database Tables".
In this section, WebLogic Portal data synchronization objects tables are arranged alphabetically as a data dictionary.
The following tables compose the data synchronization database:
This table holds the various applications available for the data synchronization process.
Table 10-31 DATA_SYNC_APPLICATION Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
APPLICATION_ID |
NUMBER(15) |
Not Null |
PK – A unique, system-generated number used as the record identifier. |
APPLICATION_NAME |
VARCHAR(100) |
Not Null |
The deployed J2EE application name. This should match the name in the WebLogic Server console. |
CREATION_DATE |
DATE |
Not Null |
The date and time this record was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time this record was last modified. |
This table stores all the data items to be synchronized.
Table 10-32 DATA_SYNC_ITEM Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
DATA_SYNC_ITEM_ID |
NUMBER(15) |
Not Null |
PK – A unique, system-generated number used as the record identifier. |
APPLICATION_ID |
NUMBER(15) |
Not Null |
FK to |
SCHEMA_URI_ID |
NUMBER(15) |
Not Null |
FK to |
VERSION_MAJOR |
NUMBER(15) |
Not Null |
FK to |
VERSION_MINOR |
NUMBER(15) |
Not Null |
FK to |
ITEM_CHECKSUM |
NUMBER(15) |
Not Null |
A generated number representing the contents of the |
CREATION_DATE |
DATE |
Not Null |
The date and time this record was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time this record was last modified. |
XML_MODIFIED_DATE |
DATE |
Not Null |
The date and time the XML file was last modified. |
XML_CREATION_DATE |
DATE |
Not Null |
The date and time the XML file was created. |
XML_DEFINITION |
CLOB |
Not Null |
The XML representation of the data item to be synchronized. |
ITEM_URI |
VARCHAR(254) |
Not Null |
The path on the file system of the data item to be synchronized. |
ITEM_AUTHOR |
VARCHAR(200) |
Null |
Metadata information – the OS login. |
ITEM_NAME |
VARCHAR(100) |
Null |
Metadata information – the full path to the item. |
ITEM_DESCRIPTION |
VARCHAR(254) |
Null |
Metadata information – a general description of the item to be synchronized. |
This table holds information pertaining to each of the governing schemas used by various documents.
Table 10-33 DATA_SYNC_SCHEMA_URI Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
SCHEMA_URI_ID |
NUMBER(15) |
Not Null |
PK – A unique, system-generated number used as the record identifier. |
SCHEMA_URI |
VARCHAR(254) |
Not Null |
The governing schema of the document. |
CREATION_DATE |
DATE |
Not Null |
The date and time this record was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time this record was last modified. |
This table is not being used currently. It is reserved for future use and is expected to accommodate data synchronization versioning. As a result, this table holds only one record.
Table 10-34 DATA_SYNC_VERSION Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
VERSION_MAJOR |
NUMBER(15) |
Not Null |
PK – The current record has a value of zero. |
VERSION_MINOR |
NUMBER(15) |
Not Null |
PK – The current record has a value of zero. |
CREATION_DATE |
DATE |
Not Null |
The date and time that the record was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time that the record was last modified. |
BUILD_NUMBER |
NUMBER(15) |
Null |
The build number associated with the version. |
VERSION_DESCRIPTION |
VARCHAR(30) |
Null |
A description of the particular sync version. |
Portal Services database objects are used for placeholders, ads, and ad bucket services.
For an entity relation diagram of the Portal Services database tables, see Figure B-7, "Portal Services Database Tables".
The following tables compose the Portal Services database:
This table maintains content queries for ads.
Table 10-35 AD_BUCKET Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
AD_BUCKET_ID |
NUMERIC(15) |
Not Null |
PK – A unique, system-generated number used as the record identifier. |
USER_NAME |
VARCHAR (200) |
Not Null |
The user's name associated with the ad. |
PLACEHOLDER_XML_REF |
VARCHAR(254) |
Not Null |
The location identifier of the XML-based placeholder definition file. |
APPLICATION_NAME |
VARCHAR(100) |
Not Null |
The name of the application for which the ad has been scoped. |
CONTEXT_REF |
VARCHAR(254) |
Null |
The scenario-unique identifier. |
CONTAINER_REF |
VARCHAR(254) |
Null |
The campaign-unique identifier. |
CONTAINER_TYPE |
VARCHAR(50) |
Null |
Identifies the service associated with the |
WEIGHT |
NUMERIC(15) |
Null |
A weighted scheme used in prioritizing one placeholder over another. |
VIEW_COUNT |
NUMERIC(15) |
Null |
Disabled. Reserved for future use. |
EXPIRATION_DATE |
DATE |
Null |
The date and time the ad expires or becomes invalid. |
CREATION_DATE |
DATE |
Not Null |
The date and time this record was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time this record was last modified. |
AD_QUERY |
CLOB |
Null |
The actual content query. |
This table tracks the number of times the ads are displayed and clicked though.
Table 10-36 AD_COUNT Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
AD_ID |
VARCHAR(254) |
Not Null |
PK – A unique, system-generated number used as the record identifier. |
CONTAINER_REF |
VARCHAR(254) |
Not Null |
PK – The campaign-unique identifier. |
APPLICATION_NAME |
VARCHAR(100) |
Not Null |
PK – The name of the application for which the ad clicks or views were scoped. |
DISPLAY_COUNT |
NUMERIC(15) |
Not Null |
The number of times the ad has been displayed. |
CLICK_THROUGH_COUNT |
NUMERIC(15) |
Not Null |
The number of times the ad has been clicked. |
This table is used as a mechanism to hold the placeholder for previewing purposes only.
This table stores all of the address information for e-mail purposes.
Table 10-38 MAIL_ADDRESS Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
MAIL_ADDRESS_ID |
NUMERIC(15) |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
MESSAGE_ID |
NUMERIC(15) |
Not Null |
FK – Foreign key to the |
ADDRESS |
VARCHAR(254) |
Not Null |
Stores the various e-mail addresses on the distribution list. |
SEND_TYPE |
VARCHAR(4) |
Not Null |
Determines how the |
This table establishes a batch for each mailing.
This table correlates the mail batch with the specific mail message.
This table contains all of the header information specific to the e-mail message.
Table 10-41 MAIL_HEADER Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
HEADER_ID |
NUMERIC(15) |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
MESSAGE_ID |
NUMERIC(15) |
Not Null |
FK – Foreign key to the |
HEADER_NAME |
VARCHAR(50) |
Null |
The name of the mail message header. |
HEADER_VALUE |
VARCHAR(254) |
Null |
The value of the mail message header. |
This table contains the specifics of the mail message (for example, the subject line, text, and so on).
Table 10-42 MAIL_MESSAGE Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
MESSAGE_ID |
NUMERIC(15) |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
FROM_ADDRESS |
VARCHAR(254) |
Null |
Identifies who is sending the message. |
SUBJECT |
VARCHAR(128) |
Null |
Stores the mail message subject. |
MESSAGE_TEXT |
CLOB |
Null |
Holds the content of the mail message. |
This table identifies when a user is no longer eligible to participate in a particular scenario.
Table 10-43 SCENARIO_END_STATE Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
SCENARIO_XML_REF |
VARCHAR(254) |
Not Null |
PK – The identifier for the XML-based scenario definition file. |
USER_NAME |
VARCHAR(200) |
Not Null |
PK—the user |
CONTAINER_REF |
VARCHAR(254) |
Not Null |
PK—the campaign unique identifier. FK to |
CONTAINER_TYPE |
VARCHAR(50) |
Not Null |
PK—At this time this column always holds the string |
APPLICATION_NAME |
VARCHAR(100) |
Not Null |
PK – The deployed J2EE application name. This should match the name in the WebLogic Server console. |
The Portal Framework is the portion of WebLogic Portal that is responsible for the rendering and customization of the portal.
For an entity relation diagram of the Portal Framework database tables, see Figure B-8, "Portal Framework Database Tables". This includes tables that support WSRP and localization.
In this section, tables are arranged alphabetically as a data dictionary. The following tables compose the generic Portal Framework database:
Section 10.3.1.7, "PF_LOOK_AND_FEEL_DEFINITION Database Table"
Section 10.3.1.13, "PF_PLACEHOLDER_DEFINITION Database Table"
Section 10.3.1.17, "PF_PORTLET_CATEGORY_DEFINITION Database Table"
Section 10.3.1.21, "PF_PORTLET_PREFERENCE_VALUE Database Table"
Section 10.3.1.22, "PF_PORTLET_USER_PROPERTIES Database Table"
To view the communities-related portal framework tables, see Section 10.5, "Communities Framework Database Objects." To view the tables related to localization, refer to Section 10.3.2, "Localization Dictionary Tables."
This table defines a BOOK
portal library resource. Books are used to aggregate PAGES
and other BOOKS
.
Table 10-44 PF_BOOK_DEFINITION Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
BOOK_DEFINITION_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
MARKUP_DEFINITION_ID |
NUMBER |
Not Null |
FK to |
IS_PUBLIC |
NUMBER |
Not Null |
A boolean flag indicating whether this book definition displays to the public. When end users create books they are not marked as public. |
IS_HIDDEN |
NUMBER |
Not Null |
A boolean flag indicating whether this book definition is hidden from the menu. Marking a page or book as hidden does not prevent it from being displayed; this indicator is only a hint to the menu control not to display a tab for the given book or page. The page or book can be activated using a link or a backing file. |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
INTERSECTION_ID |
NUMBER |
Not Null |
FK to |
WEBAPP_NAME |
VARCHAR(80) |
Not Null |
Name of the J2EE web application (as defined in the |
BOOK_LABEL |
VARCHAR(80) |
Null |
A moniker used to reference this portal resource for development purposes. This is the same as the bookDefinitionLabel in Oracle Enterprise Pack for Eclipse. If a label is not supplied at creation time, the |
This table represents a child page or book placement on the parent book. A single record in the table represents one placement on a book. This table also identifies a customized grouping of books and pages. Customized groupings are represented and aggregated around the DESKTOP_INSTANCE_ID.
Table 10-45 PF_BOOK_GROUP Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
BOOK_GROUP_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
PARENT_BOOK_ID |
NUMBER |
Not Null |
FK to |
ALIGNMENT |
NUMBER |
Not Null |
The alignment is a hint to the menu skeleton JSP to indicate whether the tab should be aligned on the left or right of the tab bar. A skeleton can either implement this feature or ignore it. |
MENU_POSITION |
NUMBER |
Not Null |
The order, in the tab menu, in which this page or book will appear on the parent book.The order does not need to be contiguous. |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
IS_DEFAULT |
NUMBER |
Not Null |
A boolean flag indicating that this is the default page or book on the parent book. |
CHILD_BOOK_ID |
NUMBER |
Null |
FK to |
PAGE_INSTANCE_ID |
NUMBER |
Null |
FK to |
DESKTOP_INSTANCE_ID |
NUMBER |
Null |
FK to |
This table identifies an instance of the BOOK_DEFINITION
. There is always at least one book instance, namely the primary instance. All other instances represent customization by administrators or end users.
Table 10-46 PF_BOOK_INSTANCE Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
BOOK_INSTANCE_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
MENU_ORIENTATION |
NUMBER |
Not Null |
The orientation is a hint to the book skeleton JSP and the menu skeleton JSP to display the tabs on the top, left, right, or bottom of the main book. The skeletons can choose to ignore this field. |
INSTANCE_TYPE |
NUMBER |
Not Null |
The type of book instance: 1=Primary, 3=Admin, 4=User. |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
INSTANCE_TITLE |
VARCHAR(255) |
Null |
An end-user-customized title for this This title is not internationalized as it is used only by the end user. If the end user does not customize the book title, then the value is null and the |
BOOK_DEFINITION_ID |
NUMBER |
Not Null |
FK to |
MENU_DEFINITION_ID |
NUMBER |
Null |
FK to |
THEME_DEFINITION_ID |
NUMBER |
Null |
FK to |
This table defines a desktop definition. You can create Desktops from template (.portal
) files or from existing resources.
Table 10-47 PF_DESKTOP_DEFINITION Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
DESKTOP_PATH |
VARCHAR(40) |
Not Null |
Part of the PK – identifies the partial URL path to the desktop. |
|
PORTAL_PATH |
VARCHAR(40) |
Not Null |
Part of the PK and FK to |
|
WEBAPP_NAME |
VARCHAR(80) |
Not Null |
Part of the PK and FK to |
|
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
|
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
|
INTERSECTION_ID |
NUMBER |
Not Null |
FK to |
|
MARKUP_DEFINITION_ID |
NUMBER |
Not Null |
FK to |
|
IS_TREE_OPTIMIZED |
NUMBER |
Not Null |
Indicates whether tree optimization is active for a desktop. Acceptable values are 0 (off; the default) or 1 (on). |
|
DESKTOP_TYPE |
NUMBER |
Not Null |
Indicates whether the desktop is a community; the default is 0 (not a community). |
|
IS_TEMPLATE |
NUMBER |
Not Null |
Indicates whether the desktop is a template; the default is 0 (not a template). |
|
IS_GLOBAL |
NUMBER |
Not Null |
Indicates whether the desktop is a global desktop; the default is 0 (not global). |
|
ASYNC_MODE_TYPE |
VARCHAR(10) |
Not Null |
Adds the ability to turn running a desktop in AJAX on or off at the desktop level. The default is |
10.0 |
IS_SCROLL_TO_WINDOW_ ENABLED |
SMALLINT |
Not Null |
A Boolean flag that enables scrolling of the browser window to the last window where the user interacted.The default is |
10.0 |
IS_DVT_ENABLED |
SMALLINT |
Not Null |
A flag that indicates if the desktop has client-side dynamic visitor tooling enabled. Default is 0 (false). |
10.2 |
IS_DISC_ENABLED |
SMALLINT |
Not Null |
A flag that indicates if the desktop has dynamic interface scripting context enabled for client-side and server-wide framework integration. Default is 0 (false). |
10.2 |
This table identifies a customized or localized instance of a desktop.
Table 10-48 PF_DESKTOP_INSTANCE Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
DESKTOP_INSTANCE_ID |
NUMBER |
Not Null |
PK – identifies the partial URL path to the desktop. |
DESKTOP_PATH |
VARCHAR(40 |
Not Null |
FK to |
PORTAL_PATH |
VARCHAR(40) |
Not Null |
FK to |
WEBAPP_NAME |
VARCHAR(80) |
Not Null |
FK to |
MAIN_BOOK_ID |
NUMBER |
Not Null |
FK to |
USER_NAME |
VARCHAR(200) |
Null |
The name of the user if the user has customized his/her desktop. This value is null if the desktop instance is not for a particular user or administrator. |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
LOOK_FEEL_DEFINITION_ID |
NUMBER |
Null |
FK to |
INSTANCE_TITLE |
VARCHAR(20) |
Null |
An end-user-customized title for this If the end user does not customize the desktop title, then the value is null and the |
SHELL_DEFINITION_ID |
NUMBER |
Not Null |
FK to |
This table defines a LAYOUT
portal library resource that is used as a specification for determining the location of items on a page. For every layout definition there is a corresponding .layout
file. By updating the .layout
file, you are updating this record.
Table 10-49 PF_LAYOUT_DEFINITION Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
LAYOUT_DEFINITION_ ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
|
MARKUP_DEFINITION_ ID |
NUMBER |
Not Null |
FK to |
|
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
|
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
|
INTERSECTION_ID |
NUMBER |
Not Null |
FK to |
|
WEBAPP_NAME |
VARCHAR(80) |
Not Null |
Name of the J2EE web application to which the portal resource is scoped. |
|
IS_LAYOUT_FILE_ DELETED |
NUMBER |
Not Null |
A boolean indicating that the file associated with this layout was removed from the file system. If the layout is not being used, then the record is deleted outright. This flag is set to true only when the |
|
LAYOUT_FILE |
VARCHAR(255) |
Null |
The name and location of the file associated with this layout definition. |
|
ICON_URI |
VARCHAR(255) |
Null |
The URI that identifies the |
|
HTML_LAYOUT_URI |
VARCHAR(255) |
Null |
The URI for the HTML for this layout definition. The htlp file is used by the admin and visitor tools to provide a visual display that emulates the real layout. |
|
THUMBNAIL_URI |
VARCHAR(255) |
Null |
Associates a thumbnail image with the layout for display in the Administration Console or Visitor Tools. |
10.0 |
This table defines a LOOK and FEEL
portal library resource or template for assignment to DESKTOPs
that control how a portal renders.
Table 10-50 PF_LOOK_AND_FEEL_DEFINITION Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
LOOK_FEEL_ DEFINITION_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
|
LOOK_FEEL_LABEL |
VARCHAR(80) |
Not Null |
A moniker used to reference this portal resource for development purposes. |
|
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
|
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
|
INTERSECTION_ID |
NUMBER |
Not Null |
FK to L10N_INTERSECTION. |
|
MARKUP_DEFINITION_ID |
NUMBER |
Not Null |
FK to PF_MARKUP_DEFINITION. |
|
WEBAPP_NAME |
VARCHAR(80) |
Not Null |
Name of the J2EE web application to which the portal resource is scoped. |
|
IS_LOOK_FEEL_FILE_ DELETED |
NUMBER |
Not Null |
A boolean indicating that the file associated with this look and feel was removed from the file system. If the look and feel is not being used, then the record is deleted outright. This flag is set to true only when the |
|
LOOK_FEEL_FILE |
VARCHAR(255) |
Not Null |
The fully qualified file path (from the web app) to the location of the |
|
THUMBNAIL_URI |
VARCHAR(255) |
Null |
Associates a thumbnail image with the look and feel for display in the Administration Console or Visitor Tools. |
10.0 |
This table defines the MARKUP
(blueprint, design, model) for a portal library resource.
Table 10-51 PF_MARKUP_DEFINITION Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
MARKUP_DEFINITION_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
MARKUP_NAME |
VARCHAR(255) |
Not Null |
The filename and location that contains the definition of this portal object. |
MARKUP_TYPE |
VARCHAR(20) |
Not Null |
The type of portal resource that this markup defines. |
BEGIN_XML |
VARCHAR(2000) |
Not Null |
The first 2000 characters of XML definition of this portal object. |
END_XML |
VARCHAR(2000) |
Null |
The last 2000 characters of the XML definition of this portal object. |
MARKUP_FILE |
VARCHAR(255) |
Null |
Location of the file containing the markup definition. |
WEBAPP_NAME |
VARCHAR(80) |
Null |
Name of the J2EE web application to which the portal resource is scoped. |
This table was added in WebLogic Portal version 9.2. It defines additional XML markup information for portal resources.
Table 10-52 PF_MARKUP_XML Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
MARKUP_DEFINITION_ID |
INTEGER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
9.2 |
XML_TYPE |
CHAR(1) |
Not Null |
Identifies if this block is a begin or end block. Values are "B" for begin or "E" for end. |
9.2 |
BLOCK_NUMBER |
INTEGER |
Not Null |
Determines the order of the markup. |
9.2 |
MARKUP_XML |
VARCHAR(2000) |
Not Null |
The markup value. |
9.2 |
This table defines a MENU
portal library resource or template that can be assigned to a BOOK INSTANCE
.
Table 10-53 PF_MENU_DEFINITION Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
MENU_DEFINITION_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
|
MARKUP_ DEFINITION_ID |
NUMBER |
Not Null |
FK to |
|
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
|
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
|
INTERSECTION_ID |
NUMBER |
Not Null |
FK to |
|
WEBAPP_NAME |
VARCHAR(80) |
Not Null |
Name of the J2EE web application to which the portal resource is scoped. |
|
IS_MENU_FILE_ DELETED |
NUMBER |
Not Null |
A boolean indicating that the file associated with this menu was removed from the file system. If the menu is not being used then the record is deleted outright. This flag is set to true only when the |
|
MENU_FILE |
VARCHAR(255) |
Not Null |
The fully qualified path (from the web application) to the location of the .menu file associated with this menu definition. |
|
THUMBNAIL_URI |
VARCHAR(255) |
Null |
Associates a thumbnail image with the menu for display in the Administration Console or Visitor Tools. |
10.0 |
This table defines a PAGE
portal library resource or template that can be assigned to a PAGE INSTANCE
.
Table 10-54 PF_PAGE_DEFINITION Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
PAGE_DEFINITION_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
MARKUP_DEFINITION_ID |
NUMBER |
Not Null |
FK to |
IS_PUBLIC |
NUMBER |
Not Null |
A boolean indicating this page definition is public. Only public page definitions are ever exposed to site visitors. |
IS_HIDDEN |
NUMBER |
Not Null |
A boolean indicating this page is hidden. The hidden flag is a hint to the menu not to render a tab for this page. The page can still be displayed by other methods (links, events). |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
INTERSECTION_ID |
NUMBER |
Not Null |
FK to |
WEBAPP_NAME |
VARCHAR(80) |
Not Null |
Name of the J2EE web application to which the portal resource is scoped. |
PAGE_LABEL |
VARCHAR(80) |
Null |
A moniker used to reference this portal resource for development purposes. |
This table identifies an instance of the page definition; at least one instance per definition always exists.
Table 10-55 PF_PAGE_INSTANCE Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
PAGE_INSTANCE_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
INSTANCE_TYPE |
NUMBER |
Not Null |
The type of page instance: 1=Primary, 3=Admin, 4=User. |
LAYOUT_DEFINITION_ID |
NUMBER |
Not Null |
FK to |
PAGE_DEFINITION_ID |
NUMBER |
Not Null |
FK to |
THEME_DEFINITION_ID |
NUMBER |
Null |
FK to |
INSTANCE_TITLE |
VARCHAR(255) |
Null |
A desktop- or user-customized title for this page. This instance title is valid only to end users as it cannot and need not be localized. |
This table defines a PLACEHOLDER
portal library resource or template that has a LAYOUT
definition and can be assigned to a PLACEMENT
.
Table 10-56 PF_PLACEHOLDER_DEFINITION Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
PLACEHOLDER_DEFINITION_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
MARKUP_DEFINITION_ID |
NUMBER |
Not Null |
FK to |
LAYOUT_LOCATION |
NUMBER |
Not Null |
The location of this placeholder in the layout. This is used when swapping layouts, as portlets in one layout's location are moved to the other layout's location with the same ID. If the other layout does not have the same number of placeholders, the modulus of the location by number of locations are used. |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
INTERSECTION_ID |
NUMBER |
Not Null |
FK to |
LAYOUT_DEFINITION_ID |
NUMBER |
Not Null |
FK to |
Each record in this table represents a single placement of a book or portlet on a page.
Table 10-57 PF_PLACEMENT Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
PLACEMENT_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
PAGE_INSTANCE_ID |
NUMBER |
Not Null |
FK to |
POSITION |
NUMBER |
Not Null |
The position within the placeholder where this placement lies. Placeholders can contain more than one placement. |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
PLACEHOLDER_ DEFINITION_ID |
NUMBER |
Not Null |
FK to |
PORTLET_INSTANCE_ID |
NUMBER |
Null |
FK to |
BOOK_INSTANCE_ID |
NUMBER |
Null |
FK to |
DESKTOP_INSTANCE_ID |
NUMBER |
Null |
FK to |
This table identifies a PORTAL
application library resource or template that can be associated with a DESKTOP
definition.
Table 10-58 PF_PORTAL Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
PORTAL_PATH |
VARCHAR(40) |
Not Null |
PK – Partial primary key and partial URL to this portal. |
WEBAPP_NAME |
VARCHAR(80) |
Not Null |
PK – Name of the J2EE web application to which the portal resource is scoped. |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
INTERSECTION_ID |
NUMBER |
Not Null |
FK to |
CONTENT_URI |
VARCHAR(255) |
Null |
Defines an optional URI to be forwarded to when only the portal portion of the URL is supplied. You can use this URL (JSP or |
This table associates a PORTLET
CATEGORY
resource with a PORTLET
DEFINITION
.
Table 10-59 PF_PORTLET_CATEGORY Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
PORTLET_DEFINITION_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
PORTLET_CATEGORY_ DEFINITION_ID |
NUMBER |
Not Null |
FK to
|
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
This table identifies a PORTLET CATEGORY
and PORTLET CATEGORY
hierarchy resource or template for association with a PORTLET
resource.
Table 10-60 PF_PORTLET_CATEGORY_DEFINITION Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
PORTLET_CATEGORY_ DEFINITION_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
INTERSECTION_ID |
NUMBER |
Not Null |
FK to |
WEBAPP_NAME |
VARCHAR(80) |
Not Null |
Name of the J2EE web application to which the portal resource is scoped. |
PARENT_CATEGORY_ DEFINITION_ID |
NUMBER |
Null |
FK to
|
This table identifies the characteristics of a PORTLET
library resource or template that can used as the user interfaces for a web application.
Table 10-61 PF_PORTLET_DEFINITION Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
PORTLET_DEFINITION_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
MARKUP_DEFINITION_ID |
NUMBER |
Not Null |
FK to |
IS_PUBLIC |
NUMBER |
Not Null |
A |
IS_FORKABLE |
NUMBER |
Not Null |
A boolean indicating that the portlet supports multi-threading. |
FORK_RENDER |
NUMBER |
Not Null |
A boolean indicating whether multi-threading is being used for this portlet; this value can be true only if |
IS_CACHEABLE |
NUMBER |
Not Null |
A boolean indicating whether this portlet can use render caching. |
CACHE_EXPIRES |
NUMBER |
Not Null |
Indicates whether this portlet is using caching and if so, gives the ttl: -1 indicates off; 0..n indicates a ttl for the cache. Can have a value other than -1 only if |
WSRP_PROPERTIES_MODE |
NUMBER |
Not Null |
Indicates required user properties. for WSRP user profile propagation. Possible values are: 0 = None 1 = All 2 = Specified properties 3 = User properties are defaulted to the web application's default. This is the default value. |
IS_PORTLET_FILE_DELETED |
NUMBER |
Not Null |
A boolean that indicates whether the This flag is set to true only when the |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
PORTLET_LABEL |
VARCHAR(80) |
Not Null |
A moniker used to reference this portal resource for development purposes. |
WEBAPP_NAME |
VARCHAR(80) |
Not Null |
Name of the J2EE web application to which the portal resource is scoped. |
CONTENT_URI |
VARCHAR(255) |
Not Null |
The content URI for this portlet (JSP, HTML). This value can be null for Java (JSR168) portlets. |
EDIT_URI |
VARCHAR(255) |
Null |
The Edit mode URI (JSP) for this portlet (if the portlet supports edit mode). |
HELP_URI |
VARCHAR(255) |
Null |
The Help mode URI (JSP) for this portlet (if the portlet supports help mode). |
BACKING_FILE |
VARCHAR(255) |
Null |
The optional backing file (Java class name) for this portlet. Backing classes must implement JspBacking or extend AbstractJspBacking. |
PORTLET_FILE |
VARCHAR(255) |
Null |
The ( |
This table identifies a customized or localized instance of a portlet.
Note:
To view the WSRP tables that are a subset of the PF_PORTLET_INSTANCE table, see Section 10.4, "WSRP Portal Framework Database Objects."
Table 10-62 PF_PORTLET_INSTANCE Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
PORTLET_INSTANCE_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
|
PORTLET_DEFINITION_ID |
NUMBER |
Not Null |
FK to |
|
DEFAULT_MINIMIZED |
NUMBER |
Not Null |
A boolean that indicates whether the portlet is to be displayed in the minimized state by default. |
|
INSTANCE_TYPE |
NUMBER |
Not Null |
Type codes for the portlet instance. Valid values: 1=Primary, 2=Library, 3=Admin, 4=User. |
|
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
|
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
|
TITLE_BAR_ORIENTATION |
NUMBER |
Null |
A hint to the skeleton file to display this portlet's title bar in either the top, left, right, or bottom location. Not all skeletons may implement this and therefore may not have any effect. |
|
INTERSECTION_ID |
NUMBER |
Not Null |
FK to |
|
PORTLET_LABEL |
VARCHAR(80) |
Not Null |
A moniker used to reference this portal resource for development purposes. |
|
THEME_DEFINITION_ID |
NUMBER |
Null |
FK to |
|
PARENT_PORTLET_ INSTANCE_ID |
NUMBER |
Null |
FK to |
|
TITLE_KEY |
VARCHAR(80) |
Null |
The bundle key for the localized title of the portlet for the bundle contained in the .portlet file. |
10.0 |
This table identifies preference values for the portlet instance.
Table 10-63 PF_PORTLET_PREFERENCE Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
PORTLET_INSTANCE_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
PREFERENCE_NAME |
VARCHAR(80) |
Not Null |
An optional name associated with the preference values. |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
IS_MODIFIABLE |
NUMBER |
Not Null |
A boolean, indicating whether the name/value of this preference can be modified by portlets. |
IS_MULTIVALUED |
NUMBER |
Not Null |
A boolean, indicating whether a preference can have more than one value. |
PREFERENCE_DESCRIPTION |
VARCHAR(255) |
Null |
An optional description of the portlet preferences. |
This table maintains values of portlet preferences. There is a one-to-many correspondence between the records in the PF_PORTLET_PREFERENCE table and this table.
Table 10-64 PF_PORTLET_PREFERENCE_VALUE Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
PORTLET_PREFERENCE_ VALUE_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
PORTLET_INSTANCE_ID |
NUMBER |
Not Null |
FK to |
PREFERENCE_NAME |
VARCHAR(80) |
Not Null |
FK to |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
PREFERENCE_VALUE |
VARCHAR(255) |
Null |
The actual value for this preference. |
This table maintains values of portlet user properties for WSRP user profile propagation.
This table was added in WebLogic Portal 9.2.
Table 10-65 PF_PORTLET_USER_PROPERTIES Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
USER_PROPERTY_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the property ID. |
PORTLET_DEFINITION_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the portlet definition ID. |
PROPERTY_STRING |
VARCHAR(255) |
Not Null |
String value. |
This table represents a shell definition. There is a one-to-one correspondence between records in this table and .shell files.
Table 10-66 PF_SHELL_DEFINITION Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
SHELL_DEFINITION_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
|
MARKUP_DEFINITION_ID |
NUMBER |
Not Null |
FK to |
|
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
|
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
|
INTERSECTION_ID |
NUMBER |
Not Null |
FK to |
|
WEBAPP_NAME |
VARCHAR (80) |
Not Null |
Name of the J2EE web application to which the portal resource is scoped. |
|
IS_SHELL_FILE_DELETED |
NUMBER |
Not Null |
A boolean indicating that the file associated with this shell was removed from the file system. If the shell is not being used, then the record is deleted outright. This flag is set to true only when the . |
|
SHELL_FILE |
VARCHAR (255) |
Not Null |
The name of the |
|
THUMBNAIL_URI |
VARCHAR (255) |
Null |
Associate a thumbnail image with the shell for display in the Administration Console or Visitor Tools. |
10.0 |
HEADER_LAYOUT _DEFINITION_ID |
INTEGER |
Null |
FK to PF_LAYOUT_ DEFINITION. |
10.0 |
FOOTER_LAYOUT _DEFINITION_ID |
INTEGER |
Null |
FK to PF_LAYOUT_ DEFINITION. |
10.0 |
This table supports disassembling layouts in the .shell
files. Each record represents the item (either book or portlet) placement in the layout for a header or footer in the .shell
file.
Table 10-67 PF_SHELL_PLACEMENT Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
PLACEMENT_ID |
INTEGER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
10.0 |
SHELL_DEFINITION_ID |
INTEGER |
Not Null |
FK to PF_SHELL_ DEFINITION on DELETE CASCADE. |
10.0 |
IS_IN_HEADER |
SMALLINT |
Not Null |
A Boolean indicating that the shell placement is defined for the header of the book or portlet. |
10.0 |
POSITION |
SMALLINT |
Not Null |
The position within the placeholder where this placement lies. Placeholders can contain more than one placement. |
10.0 |
CREATION_DATE |
TIMESTAMP DEFAULT CURRENT_TIMESTAMP |
Not Null |
The date and time the row was created. |
10.0 |
MODIFIED_DATE |
TIMESTAMP DEFAULT CURRENT_TIMESTAMP |
Not Null |
The date and time that the record was last modified. |
10.0 |
PLACEHOLDER_ DEFINITION_ID |
INTEGER |
Not Null |
FK to PF_PLACEHOLDER_ DEFINITION. |
10.0 |
PORTLET_INSTANCE_ID |
INTEGER |
Null |
FK to PF_PORTLET_ INSTANCE. |
10.0 |
BOOK_INSTANCE_ID |
INTEGER |
Null |
FK to PF_BOOK_ INSTANCE. |
10.0 |
This table represents a theme definition. There is a one-to-one correspondence between records in this table and .theme
files.
Table 10-68 PF_THEME_DEFINITION Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
THEME_DEFINITION_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
|
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
|
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
|
INTERSECTION_ID |
NUMBER |
Not Null |
FK to |
|
MARKUP_DEFINITION_ID |
NUMBER |
Not Null |
|
|
WEBAPP_NAME |
VARCHAR(80) |
Not Null |
Name of the J2EE web application to which the portal resource is scoped. |
|
IS_THEME_FILE_DELETED |
NUMBER |
Not Null |
A boolean indicating that the file associated with this theme was removed from the file system. If the theme is not being used, then the record is deleted outright. This flag is set to true only when the |
|
THEME_FILE |
VARCHAR(255) |
Not Null |
The name of the |
|
THUMBNAIL_URI |
VARCHAR(255) |
Null |
Associates a thumbnail image with the theme for display in the Administration Console or Visitor Tools. |
10.0 |
This table was added in WebLogic Portal version 9.2. It maintains URL compression values.
Table 10-69 PF_URL_COMPRESSION Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
URL_COMPRESSION_ID |
INTEGER |
Not Null |
PK – A unique, system-generated number to use as the URL Compression ID. |
9.2 |
EXPANDED_URL_HASH |
INTEGER |
Not Null |
Hashed URL used to look up the compressed URL; hashes are not guaranteed to be unique, so a secondary search is performed on EXPANDED_URL. |
9.2 |
EXPANDED_URL |
VARCHAR(1000) |
Not Null |
The full uncompressed URL value. |
9.2 |
PAGE_LABEL |
VARCHAR(80) |
Null |
A name used to reference this portal resource for development purposes. |
9.2 |
This section documents the database objects for the WebLogic Portal framework. The following tables support localization:
This table ties an application resource (menu, portlet, and so on) to a localized title and description.
Table 10-70 L10N_INTERSECTION Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
INTERSECTION_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
RESOURCE_TYPE |
VARCHAR(80) |
Not Null |
FK to |
This table defines the characteristics of a locale that are needed to localize an application.
Table 10-71 L10N_LOCALE Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
LOCALE_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
ENCODING |
VARCHAR(20) |
Not Null |
The encoding that is used by the locale. The default encoding is UTF-8. |
LANGUAGE |
CHAR(2) |
Not Null |
Lowercase two-letter ISO-639 language code that is used by the locale; for example, en, au. |
COUNTRY |
CHAR(2) |
Null |
Uppercase two-letter ISO-3166 country code that is used by the locale; for example, US, UK. |
VARIANT |
VARCHAR(40) |
Null |
Vendor- and browser-specific code variant code that is used by the locale; for example, WIN, MAC, UNIX. |
This table defines the localized title and description of a localized resource.
Table 10-72 L10N_RESOURCE Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
LOCALE_ID |
NUMBER |
Not Null |
PK and FK to |
|
INTERSECTION_ID |
NUMBER |
Not Null |
PK and FK to |
|
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
|
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
|
TITLE |
VARCHAR(80) |
Not Null |
A localized title for the object, typically used for display purposes; for example, the name of the portal or portlet. |
|
DESCRIPTION |
VARCHAR(500) |
Null |
A localized description of the object. |
|
TITLE_CK |
VARCHAR(160) |
Null |
Collation key column for the title; an ASCII-sortable string that will sort correctly in the given language. |
9.2 |
DESCRIPTION_CK |
VARCHAR(1000) |
Null |
Collation key column for the description; an ASCII-sortable string that will sort correctly in the given language. |
9.2 |
This table defines portal resource types for localization.
Table 10-73 L10N_RESOURCE _TYPE Table Metadata
Column Name | Data Type | Null Value | Description |
---|---|---|---|
RESOURCE_TYPE |
VARCHAR(80) |
Not Null |
PK – Type of resource to be localized; for example, |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
APPLICATION_NAME |
VARCHAR(100) |
Not Null |
The name of the application to which the resource belongs.
|
For an entity relation diagram of the WSRP Portal Framework tables, see Figure B-9, "WSRP Portal Framework Tables".
The following WSRP-related tables are a subset of the PF_PORTLET_INSTANCE database table:
The PF_CONSUMER_PORTLETS table associates consumer IDs and portlet instance IDs so that when a consumer unregisters from a producer, the producer can clean up any portlets that it created for the consumer.
This table contains optional registration properties. You can set up the consumer to ask for these during registration.
Table 10-75 PF_CONSUMER_PROPERTIES Database Table
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
PRODUCER_ID |
INTEGER |
Not Null |
PK/FK to |
|
PROPERTY_NAME |
VARCHAR (255) |
Not Null |
PK – The name of the property. |
10.2 |
CREATION_DATE |
DATETIME |
Not Null |
The date and time the row was created. |
|
MODIFIED_DATE |
DATETIME |
Not Null |
The date and time the row was modified. The column's data is maintained using a database trigger. |
|
PROPERTY_VALUE |
VARCHAR (255) |
Null |
The value associated with the property name. |
10.2 |
PROPERTY_TYPE |
NUMERIC(1) |
Not Null |
The type of property being stored (string, long, double, Boolean, or datetime). |
10.2 |
This table contains registration handles that are assigned by the producer during registration by a consumer.
Table 10-76 PF_CONSUMER_REGISTRY Database Table
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
PRODUCER_ID |
INTEGER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
|
WEBAPP_NAME |
VARCHAR(80) |
Not Null |
Name of the J2EE web application (as defined in |
|
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
|
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was modified. The column's data is maintained using a database trigger. |
|
PRODUCER_HANDLE |
VARCHAR(40) |
Not Null |
Uniquely identifies the producer to the consumer. |
|
SERVICE_DESCRIPTION_ PORT_URL |
VARCHAR(255) |
Null |
Optional. URL to the description service port offered by the producer. |
9.2 |
MARKUP_PORT_URL |
VARCHAR(255) |
Null |
Optional. URL to the markup service port offered by the producer. |
9.2 |
COOKIE_PROTOCOL |
NUMBER |
Not Null |
The cookie protocol. Values: 0 = None, 1 = Per User, 2 = Per Group. |
|
WSDL_URL |
VARCHAR(255) |
Not Null |
URL to the WSDL offered by the producer. |
|
REQUIRES_REGISTRATION |
NUMBER |
Not Null |
A boolean indicating that registration is required. |
|
REGISTRATION_PORT_URL |
VARCHAR(255) |
Null |
URL to the registration service port offered by the producer (if offered). |
|
PORTLET_MANAGEMENT_ PORT_URL |
VARCHAR(255) |
Null |
URL to the portlet management service port offered by the producer (if offered). |
|
REGISTRATION_HANDLE |
VARCHAR(255) |
Null |
Registration handle returned by the producer after registration. |
|
VENDOR_NAME |
VARCHAR(255) |
Null |
Name of the vendor of the producer implementation. |
|
DESCRIPTION |
VARCHAR(255) |
Null |
A description of the portlet. |
|
REGISTRATION_STATE |
BLOB |
Null |
Registration state returned by the producer after registration. |
|
IS_DISABLED |
SMALLINT |
Not Null |
A Boolean that indicates if the corresponding Producer is enabled or disabled for the Consumer. The default is enabled, or 0. |
10.0 |
IS_STORE_REGISTRATION_ PROPERTIES |
SMALLINT |
Not Null |
A Boolean that indicates if registration properties should be stored. Used by the propagation framework. Default is (1), true. |
10.2 |
This table contains producer-generated registration handles stored for each consumer during registration.
Table 10-77 PF_PRODUCER_REGISTRY Database Table
Column Name | Data Type | Null Value | Description |
---|---|---|---|
CONSUMER_ID |
INTEGER |
Not Null |
PK – A unique system-generated number to use as the record ID. |
WEBAPP_NAME |
VARCHAR(80) |
Not Null |
Name of the J2EE web application to which the portal application is scoped. |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was modified. This column's data is maintained using a database trigger. |
CONSUMER_NAME |
VARCHAR(80) |
Null |
A unique name that identifies the consumer. For the producer to assert user identity, the consumer name must correspond to the alias of the consumer's public key deployed in the producer's key store. |
CONSUMER_AGENT |
VARCHAR(80) |
Null |
Name and version of the consumer's vendor. The value must start with |
The consumer manages remote portlet-specific data from here. The framework inserts data into this table whenever a proxy portlet instance is created (including successors). When portlet instances are deleted, the IS_SET_FOR_DESTROY
flag is set for subsequent cleanup.
Table 10-78 PF_PROXY_PORTLET_INSTANCE Database Table
Column Name | Data Type | Null Value | Description |
---|---|---|---|
PROXY_PORTLET_ INSTANCE_ID |
INTEGER |
Not Null |
PK – A unique system-generated number to use as the record ID. |
PRODUCER_ID |
INTEGER |
Not Null |
FK to |
CREATED_DATE |
DATE |
Not Null |
The date and time the row was created. |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was modified. This column's data is maintained using a database trigger. |
REQUIRES_URL_TEMPLATES |
NUMBER |
Not Null |
A boolean indicating that URL templates are required by the producer. |
TEMPLATES_STORED_ IN_ SESSION |
NUMBER |
Not Null |
A boolean indicating whether the consumer should send templates with every request. The default is 1 = True. |
PORTLET_STATE_CHANGE |
NUMBER |
Not Null |
A flag that indicates how the consumer handles customizations of remote portlets. Based on the value of this flag, the consumer may clone remote portlets. Possible values include: 0 = Readonly (default) 1 = CBW(CloneBeforeWrite) 2 = Read/Write. |
IS_PRODUCER_OFFERED |
NUMBER |
Not Null |
Identifies the portlet as producer-offered. The defaults is 1 = True. If |
PORTLET_INSTANCE_ID |
INTEGER |
Null |
FK to |
PORTLET_HANDLE |
VARCHAR(255) |
Null |
The handle to the remote portlet as it is specified by the producer. The consumer uses portlet handles throughout the communication to address and interact with portlets using the producer. |
DELETE_ERROR_CAUSE |
VARCHAR(255) |
Null |
A description of the cause of the error, if an error is encountered while trying to delete the counter part of this proxy portlet on the producer. |
PORTLET_STATE |
BLOB |
Null |
Portlet state as returned by the producer after implicit/explicit cloning. |
IS_PRIMARY |
NUMBER |
Not Null |
A boolean indicating whether the proxy portlet is primary or not. When multiple versions of the same proxy portlet are being used on a consumer, operations that involve either using or removing the proxy portlet will be done on the primary version (unless specified that the operation affects all versions). The defaults is 0 (False). |
This table maintains information on proxy books for the WebLogic Portal Administration Console. If a user is adding new remote resources to the portal, this data can be used to let the user know if a particular proxy book is already in the library.
This table was added in WebLogic Portal 9.2.
Table 10-79 PF_PROXY_BOOK Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
PROXY_BOOK_ID |
INTEGER |
Not Null |
PK – A unique, system-generated number to use as the property ID. |
9.2 |
PRODUCER_HANDLE |
VARCHAR(40) |
Not Null |
Uniquely identifies the producer to the consumer. |
9.2 |
ORIGINAL_NAME |
VARCHAR(80) |
Not Null |
Original name of the book on the producer; this name is tracked in order to find duplicates. |
9.2 |
BOOK_DEFINITION_ID |
INTEGER |
Not Null |
FK to PF_BOOK_DEFINITION |
9.2 |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
9.2 |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
9.2 |
IS_PRIMARY |
NUMBER |
Not Null |
A boolean indicating whether the proxy book is primary or not. When multiple versions of the same proxy book are being used on a consumer, operations that involve either using or removing the proxy book will be done on the primary version (unless specified that the operation affects all versions). The defaults is 0 (False). |
9.2 |
This table maintains information on proxy pages for the WebLogic Portal Administration Console. If a user is adding new remote resources to the portal, this data can be used to let the user know if a particular proxy page is already in the library.
This table was added in WebLogic Portal 9.2.
Table 10-80 PF_PROXY_PAGE Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
PROXY_PAGE_ID |
INTEGER |
Not Null |
PK – A unique, system-generated number to use as the property ID. |
9.2 |
PRODUCER_HANDLE |
VARCHAR(40) |
Not Null |
Uniquely identifies the producer to the consumer. |
9.2 |
ORIGINAL_NAME |
VARCHAR(80) |
Not Null |
Original name of the book on the producer; this name is tracked in order to find duplicates. |
9.2 |
PAGE_DEFINITION_ID |
INTEGER |
Not Null |
FK to PF_PAGE_DEFINITION |
9.2 |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
9.2 |
MODIFIED_DATE |
DATE |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
9.2 |
IS_PRIMARY |
NUMBER |
Not Null |
A boolean indicating whether a proxy page is primary or not. When multiple versions of the same proxy page are being used on a consumer, operations that involve either using or removing the proxy page will be done on the primary version (unless specified that the operation affects all versions). The defaults is 0 (False). |
9.2 |
Communities are a new feature in WebLogic Portal version 9.2. Communities are WebLogic Portal desktops that let users with common goals and interests work together in—and administer—a web-based environment. Whether for specific events, work groups, partners, or for any other groups that need to share information, communities provide a dedicated, secure, self-managed place to collaborate.
For an entity relation diagram of the Communities Portal Framework database tables, see Figure B-10, "Communities Portal Framework Database Tables".
The Communities Portal Framework system has the following tables:
The PF_COMMUNITY_DEFINITION table contains community definition data.
Table 10-81 PF_COMMUNITY_DEFINITION Database Table
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
COMMUNITY_DEFINITION_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the community definition ID. |
9.2 |
INTERSECTION_ID |
NUMBER |
Not Null |
FK to L10N_RESOURCE for the localization resource. |
9.2 |
DESKTOP_PATH |
VARCHAR(40) |
Not Null |
FK to PF_DESKTOP_ DEFINITION. |
9.2 |
PORTAL_PATH |
VARCHAR(40) |
Not Null |
FK to PF_DESKTOP_ DEFINITION. |
9.2 |
WEBAPP_NAME |
VARCHAR(80) |
Not Null |
FK to PF_DESKTOP_ DEFINITION. Name of the web application that hosts the desktop. |
9.2 |
TIMEZONE |
VARCHAR(80) |
Not Null |
Display TimeZone identifier. This can be used by Communities applications to format dates and times in a time zone specific to a community instance. |
9.2 |
IS_ACTIVE |
NUMBER |
Not Null |
Indicates whether the community is active; default = 0 (inactive). |
9.2 |
IS_PUBLIC |
NUMBER |
Not Null |
Indicates whether the community is public; default = 0 (not public). |
9.2 |
IS_TEMPLATE |
NUMBER |
Not Null |
Indicates whether the community is a template; default = 0 (not a template). |
9.2 |
IS_ACCESS_TRACKING_ ENABLED |
NUMBER |
Not Null |
Indicates whether the community has access tracking enabled; default = 0 (not enabled). |
9.2 |
IS_PERSONAL_PAGES_ ENABLED |
NUMBER |
Not Null |
Indicates whether the community has personal pages enabled; default = 0 (not enabled). |
9.2 |
IS_SELF_REG_ENABLED |
NUMBER |
Not Null |
Indicates whether self-registration is enabled; default = 0 (not enabled). |
9.2 |
IS_GLOBAL |
NUMBER |
Not Null |
Indicates whether the community is global; default = 0 (not global). |
9.2 |
CREATION_DATE |
TIMESTAMP |
Not Null |
The date and time the row was created. |
9.2 |
MODIFIED_DATE |
TIMESTAMP |
Not Null |
The date and time the row was modified. This column's data is maintained using a database trigger. |
9.2 |
EXPIRATION_DATE |
TIMESTAMP |
Not Null |
The date and time this community will expire. |
9.2 |
PARENT_COMMUNITY_ DEFINITION_ID |
NUMBER |
Null |
FK - References parent community. |
9.2 |
CALLBACK_CLASS_NAME |
VARCHAR(255) |
Null |
The class name for the CommunityCallback implementation that is configured for this community, if one exists. |
9.2 |
PRIMARY_MESSAGING_ADDR |
VARCHAR(80) |
Null |
The MessagingAddress name that identifies the default MessagingAddressType that is configured for use with this community. If this is null, the default MessagingAddressType for all community operations will be the type configured in |
9.2 |
SELF_REG_URI |
VARCHAR(255) |
Null |
URI pointing to the registration page for this community instance. |
9.2 |
DEACTIVATED_URI |
VARCHAR(255) |
Null |
URI to page when community is either deactivated or the membership of the user has been deactivated. |
9.2 |
The PF_COMMUNITY_MEMBER table contains user information for community members.
Table 10-82 PF_COMMUNITY_MEMBER Database Table
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
COMMUNITY_MEMBER_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the community member ID. |
9.2 |
USER_NAME |
VARCHAR(200) |
Not Null |
The WebLogic Server user name for the community member. |
9.2 |
MEMBER_TYPE |
NUMBER |
Not Null |
Identifies the community member as internal (1) or external (0). |
9.2 |
MEMBER_STATUS |
NUMBER |
Not Null |
Setting for member's community status. Values are: 0 = Disabled, 1 = Active. |
9.2 |
CREATION_DATE |
TIMESTAMP |
Not Null |
The date and time the row was created. |
9.29.2 |
MODIFIED_DATE |
TIMESTAMP |
Not Null |
The date and time the row was modified. This column's data is maintained using a database trigger. |
9.2 |
The PF_COMMUNITY_MEMBERSHIP table contains information regarding the membership status of community members.
Table 10-83 PF_COMMUNITY_MEMBERSHIP Database Table
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
COMMUNITY_MEMBERSHIP_ID |
NUMBER |
Not Null |
PK – A unique, system-generated number to use as the community membership ID. |
9.2 |
COMMUNITY_DEFINITION_ID |
INTEGER |
Not Null |
FK - A foreign key to PF_COMMUNITY_DEFINITION. |
9.2 |
COMMUNITY_MEMBER_ID |
INTEGER |
Not Null |
FK - A foreign key to PF_COMMUNITY_MEMBER. |
9.2 |
MEMBERSHIP_STATUS |
NUMBER |
Not Null |
Setting to determine membership status. Values are: 1 = active, 0 = Disabled |
9.2 |
CREATION_DATE |
TIMESTAMP |
Not Null |
The date and time the row was created. |
9.2 |
MODIFIED_DATE |
TIMESTAMP |
Not Null |
The date and time the row was modified. This column's data is maintained using a database trigger. |
9.2 |
LAST_ACCESS_DATE |
TIMESTAMP |
Null |
If access tracking is enabled, this field contains a timestamp that is updated at each login event by the user associated with this CommunityMembership to the linked Community desktop. |
9.2 |
The PF_MEMBERSHIP_CAPABILITY table contains information about the capabilities of a member within the community.
Table 10-84 PF_COMMUNITY_MEMBERSHIP Database Table
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
COMMUNITY_MEMBERSHIP_ID |
INTEGER |
Not Null |
PK/FK to COMMUNITY_MEMBERSHIP. |
9.2 |
CAPABILITY |
VARCHAR(80) |
Not Null |
PK - Text label applied to the community member. The only default security functionality with capabilities is that a community "creator" can delete a community and a community "owner" can manage a community. |
9.2 |
The PF_COMMUNITY_PROPERTY table contains information regarding custom community properties, used to uniquely identify the community and its characteristics.
Table 10-85 PF_COMMUNITY_PROPERTY Database Table
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
COMMUNITY_DEFINITION_ID |
INTEGER |
Not Null |
PK/FK – A foreign key to PF_COMMUNITY_DEFINITION. |
9.2 |
PROPERTY_NAME |
VARCHAR(100) |
Not Null |
PK – The property name. |
9.2 |
CREATION_DATE |
TIMESTAMP |
Not Null |
The date and time the row was created. |
9.2 |
MODIFIED_DATE |
TIMESTAMP |
Not Null |
The date and time the row was modified. This column's data is maintained using a database trigger. |
9.2 |
IS_MULTI_VALUED |
NUMBER |
Not Null |
Boolean value. |
9.2 |
DESCRIPTION |
VARCHAR(255) |
Null |
Descriptive text to for this property. |
9.2 |
The PF_COMMUNITY_PROPERTY_VALUE table contains information regarding the actual value of the custom community property.
Table 10-86 PF_COMMUNITY_PROPERTY_VALUE Database Table
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
COMMUNITY_PROPERTY_ VALUE_ID |
INTEGER |
Not Null |
PK – A system-generated unique number to use as the community property value ID. |
9.2 |
COMMUNITY_DEFINITION_ID |
INTEGER |
Not Null |
A foreign key to PF_COMMUNITY_PROPERTY. |
9.2 |
PROPERTY_NAME |
VARCHAR(100) |
Not Null |
A foreign key to PF_COMMUNITY_PROPERTY. |
9.2 |
CREATION_DATE |
TIMESTAMP |
Not Null |
The date and time the row was created. |
9.2 |
MODIFIED_DATE |
TIMESTAMP |
Not Null |
The date and time the row was modified. This column's data is maintained using a database trigger. |
9.2 |
PROPERTY_VALUE |
VARCHAR(400) |
Null |
The value associated with the property name. |
9.2 |
The PF_FILE_TEMPLATE table records the location of a file type template. This includes the web application and the URI within the web application to the file, as well as an intersection ID that can be used to retrieve a localized name for the file template.
Table 10-87 PF_FILE_TEMPLATE Database Table
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
TEMPLATE_ID |
INTEGER |
Not Null |
PK – A system-generated unique identifier for the file template. |
9.2 |
INTERSECTION_ID |
INTEGER |
Not Null |
A foreign key to L10N_RESOURCE for the Localization Resource. |
9.2 |
TEMPLATE_URI |
VARCHAR(255) |
Not Null |
URI pointing to the |
9.2 |
WEBAPP_NAME |
VARCHAR(80) |
Not Null |
Name of the web application that contains the |
9.2 |
The PF_INVITATION table stores data related to community invitations.
Table 10-88 PF_INVITATION Database Table
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
INVITATION_ID |
INTEGER |
Not Null |
PK – A system-generated unique identifier for the invitation ID. |
9.2 |
COMMUNITY_DEFINITION_ID |
INTEGER |
Not Null |
A foreign key to PF_COMMUNITY_DEFINITION. |
9.2 |
EXPIRATION_DATE |
TIMESTAMP |
Null |
The expiration date for the Invitation, after which the Invitation is no longer active and cannot be consumed. |
9.2 |
IS_SELF_DESTRUCT_ENABLED |
NUMBER |
Not Null |
Indicates whether the framework should automatically clean up database information about the invitation after it has been consumed or timed out, or stored for possible later use in queries. Default = 0 (not enabled/false). |
9.2 |
CREATION_DATE |
DATE |
Not Null |
The date and time the row was created. |
|
INVITATION_PAYLOAD |
VARCHAR(200) |
Null |
Application-specific text data that can be attached to an invitation, for use by a communities application during member registration based on this Invitation. |
9.2 |
FROM_WLS_USER_NAME |
VARCHAR(200) |
Null |
The WebLogic Server user name from which the invitation originated |
9.2 |
The PF_INVITEE table contains information regarding the target of the invitation.
Table 10-89 PF_INVITEE Database Table
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
INVITEE_ID |
INTEGER |
Not Null |
PK – A system-generated unique identifier for the invitee ID. |
9.2 |
INVITATION_ID |
INTEGER |
Not Null |
A foreign key to PF_INVITATION. |
9.2 |
INVITEE_ADDRESS |
VARCHAR(255) |
Null |
The messaging address (usually an e-mail address) used to send invitations to external users. |
9.2 |
INVITATION_STATUS |
NUMBER |
Not Null |
The status of the invitation. Values are: 10 - Sent (default) 20 -Accepted 30 - Rejected 40 - Revoked 50 - Expired |
9.2 |
MODIFIED_DATE |
TIMESTAMP |
Not Null |
Date the status was updated. |
9.2 |
USER_NAME |
VARCHAR(200) |
Null |
The WebLogic Server user name if the invitation is for an existing user, but can be null when inviting external invitees who do not yet have a WebLogic Server user name. |
9.2 |
INVITATION_VALIDATION_ TEXT |
VARCHAR(400) |
Null |
Validation text that is sent as part of the notification, which must then be provided by the invitee when accepting or declining an invitation. The format of this text is developer- definable. |
9.2 |
The PF_INVITEE_PROPERTY table contains information regarding persistent invitee properties such as invitee attributes and capabilities
Table 10-90 PF_INVITEE_PROPERTY Database Table
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
INVITEE_ID |
INTEGER |
Not Null |
PK/FK - A foreign key to PF_INVITEE. |
9.2 |
PROPERTY_TYPE |
NUMBER |
Not Null |
PK - Property type. Possible values are: 10 - Persisted Attribute 20 - Persisted Capability |
9.2 |
PROPERTY_NAME |
VARCHAR(100) |
Not Null |
PK - Property name. |
9.2 |
PROPERTY_VALUE |
VARCHAR(400) |
Not Null |
Value of the persisted attribute or capability. |
9.2 |
The PF_MESSAGING_ADDR table is reserved for future use.
The PF_NOTIFICATION table stores information about event notifications. Notifications for the Portal Framework are a mechanism for publishing availability, and subscribing to and delivering notification events within a portal. A notification event is a sibling to other types of portlet events as defined in the current inter-portlet eventing design, in that portlets can be authored in a declarative manner to listen for notifications using an event subscription tag within the portlet or portlet instance tag. The primary difference between notification events and normal portlet events is that the source of the notification comes from outside the user's portal desktop. Instead, notifications can come from other users, web applications, or even the framework itself.
Table 10-91 PF_NOTIFICATION Database Table
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
NOTIFICATION_ID |
INTEGER |
Not Null |
PK – A system-generated unique identifier for the notification ID. |
9.2 |
USER_NAME |
VARCHAR(200) |
Not Null |
User name of the notification recipient. |
9.2 |
PAYLOAD_ID |
INTEGER |
Not Null |
A foreign key to PF_NOTIFICATION_PAYLOAD. |
9.2 |
IS_CONSUMED |
NUMBER |
Not Null |
Indicates whether the notification has been consumed; the notification remains active until it is explicitly consumed or until the expiration time occurs. Default = 0 (not consumed). |
9.2 |
The PF_NOTIFICATION_PAYLOAD table stores information about notifications for individual users. Because a notification can be sent to groups of users and each user must individually acknowledge (remove) the notification, the notification table contains an entry for each user for each notification. Because the payload and other characteristics of a single notification batch are identical for each user, this information is separated and stored only once per notification to minimize redundancy in the database.
For portal desktops that are enabled for notification delivery, WebLogic Portal performs a query against the active notifications for a user prior to executing the portal lifecycle for each request.
Table 10-92 PF_NOTIFICATION_PAYLOAD Database Table
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
PAYLOAD_ID |
INTEGER |
Not Null |
PK – A system-generated unique identifier for the payload ID. |
9.2 |
NOTIFICATION_NAMESPACE |
VARCHAR(80) |
Not Null |
Denotes the namespace for this Notification, which is should be generated as a unique identifier by the application that constructed the Notification. This is meant to help in avoiding collisions due to duplicate NOTIFICATION_ NAMEs used by applications. For example, this could be the company name of the application developer that makes use of the Notifications framework. |
9.2 |
NOTIFICATION_NAME |
VARCHAR(40) |
Not Null |
Name of the notification. |
9.2 |
IS_SELF_DESTRUCT_ENABLED |
NUMBER |
Not Null |
Indicates whether the notification framework should automatically clean up database information about the notification after it has been consumed or timed out, or stored for possible later use in queries. Default = 0 (not enabled/false). |
9.2 |
IS_ACTIVE |
NUMBER |
Not Null |
Indicates whether the notification is active. When a notification is first sent, its status is set to active for each user. Default = 1 (active). |
9.2 |
EXPIRATION_DATE |
TIMESTAMP |
Not Null |
Expiration time for the notification; the notification remains active until it is explicitly consumed or until the expiration time occurs. |
9.2 |
SOURCE_WEBAPP_NAME |
VARCHAR(80) |
Not Null |
Name of the source web application. |
9.2 |
PORTAL_PATH |
VARCHAR(40) |
Null |
Path for the portal. |
9.2 |
DESKTOP_PATH |
VARCHAR(40) |
Null |
Path for the desktop. |
9.2 |
DESKTOP_INSTANCE_TITLE |
VARCHAR(20) |
Null |
Title of the desktop instance. |
9.2 |
PORTLET_DEFINITION_LABEL |
VARCHAR(80) |
Null |
Definition label of the portlet. |
9.2 |
PORTLET_INSTANCE_LABEL |
VARCHAR(80) |
Null |
Instance label of the portlet. |
9.2 |
TARGET_WEBAPP_NAME |
VARCHAR(80) |
Null |
Name of the target web application. |
9.2 |
PAYLOAD |
VARCHAR(4000) |
Null |
The content of the notification. |
9.2 |
WebLogic Portal's content management system allows you to store content, track its progress, and incorporate content in your portal applications. It provides an easy integration between creating content and delivering that content to your users. Content creators can use WebLogic Portal's repositories to create content and portal developers use the content API and JSP tools to deliver content to portal visitors.
For an entity relation diagram of the Content Management database tables, see Figure B-11, "Content Management Database Tables".
The Content Management system has the following tables:
In the CM_NODE
table, a node represents an element in a hierarchy that can either be a "Hierarchy Node" or a "Content Node." A hierarchy node can contain both other hierarchy and content nodes while a content node can contain only other content nodes. Nodes can contain properties based on the ObjectClass
(schema) defined for it.
Both Content Nodes and Hierarchy Nodes can contain an ObjectClass and properties. Each node has a path that uniquely identifies it within the repository.
Table 10-93 CM_NODE Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
NODE_ID |
INTEGER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
|
PARENT_NODE_ID |
INTEGER |
Null |
FK – The node's parent record ID ( |
|
CREATION_DATE |
DATETIME |
Not Null |
The date and time the row was created. |
|
MODIFIED_DATE |
DATETIME |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
|
OBJECT_CLASS_ID |
INTEGER |
Null |
FK – The object class ID associated to the node. |
|
NODE_NAME |
VARCHAR(50) |
Not Null |
The name of the node. The name is unique relative to its siblings. The name must not contain forward or backward slashes. |
|
NODE_TYPE |
SMALLINT |
Not Null |
The node type. Possible values are: 0 = Unpopulated value 1 = Hierarchy Node 2 = Content Node |
|
NODE_STATUS |
VARCHAR(40) |
Null |
The status of the node. The available values are defined by the application as property definition choices. |
|
CREATED_BY |
VARCHAR(100) |
Not Null |
ID of the user who created the node. |
|
MODIFIED_BY |
VARCHAR(100) |
Null |
ID of the user who last modified the node. |
|
CM_CREATION_DATE |
DATETIME |
Not Null |
The date and time the row was created. Maintained by the application. |
|
CM_MODIFIED_DATE |
DATETIME |
Not Null |
The date and time the row was last modified. Maintained by the application. |
|
FULL_PATH |
VARCHAR(882) |
Null |
AK – Each node has a path that uniquely identifies it within the repository. The path is defined in a UNIX-like format such as /a/b/c where "/" is the root and "a" ("a" is the Nodes The path must always begin with "/" and never end with it. So neither of the following are valid: a/b/c/d or /a/b/d/d/. |
9.2 |
LIFECYCLE_STATUS |
INTEGER |
Null |
The specific workflow status that the node version has been assigned: |
|
WORKFLOW_ID |
INTEGER |
Null |
FK – The Workflow ID associated with the node. |
|
CHILD_NODE_POSITION |
NUMERIC(13) |
Not Null |
The position of the child node with respect to other child nodes in the hierarchy. New children are added at the end of the grouping. Nodes with no current position are assigned a default value of -1. |
10.0 |
This table is used to store information about WebLogic Portal's collaboration portlets.
Table 10-94 CM_COLLABORATION_API_METADATA Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
NODE_ID |
INTEGER |
Not Null |
PK - A unique, system-generated number to use as the record ID. |
9.2 |
ICONTAINER_SUBCONTAINER_ COUNT |
INTEGER |
Not Null |
The number of shallow child containers for the current node. |
9.2 |
IGWARE_CONTR_TOTAL_ITEM_ COUNT |
INTEGER |
Not Null |
The number of shallow child items for the current node. |
9.2 |
IGWARE_CONTR_UNREAD_ITEM_COUNT |
INTEGER |
Not Null |
The number of shallow child items that are marked as UNREAD for the current node. |
9.2 |
IFORUM_CATEGORY_FORUM_ COUNT |
INTEGER |
Not Null |
The number of shallow forums beneath this category. |
9.2 |
ITOPIC_SUPPRT_DEEP_TOPIC_ COUNT |
INTEGER |
Not Null |
The number of topics, infinitely deep, below this node. |
9.2 |
ITOPIC_SUPPRT_TOPIC_COUNT |
INTEGER |
Not Null |
The number of shallow topics below this node. |
9.2 |
The ObjectClass is the schema for a Node (a content type). It has both an ID and a name that uniquely identifies it within a content repository. An ObjectClass can have PropertyDefinitions associated with it that define the shape of Properties required for a Node. This does not mean that the Property must contain a value, but simply that the Property must exist for the Node.
The ObjectClass may have a primary PropertyDefinition that defines the primary content Property for a Node. This allows for the definition of content in the schema since the schema does not distinguish between content and meta-content. A Node is considered valid in the repository only if its Properties conform to its ObjectClass PropertyDefinitions.
Table 10-95 CM_OBJECT_CLASS Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
OBJECT_CLASS_ID |
INTEGER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
|
CREATION_DATE |
DATETIME |
Not Null |
The date and time the row was created. |
|
MODIFIED_DATE |
DATETIME |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
|
OBJECT_CLASS_NAME |
VARCHAR (100) |
Not Null |
AK – A unique name for the object class. |
|
PRIMARY_PROPERTY_ DEFINITION_ID |
INTEGER |
Null |
FK – The
|
|
IS_ABSTRACT |
SMALLINT |
Not Null |
A flag indicating if this type (object class) is abstract. An abstract type cannot be used as the object class of a node, but can be used as a base type for others using type inheritance or as a nested type. Possible values are: 0 = false 1 = true |
9.2 |
IS_SEARCHABLE |
SMALLINT |
Not Null |
A flag indicating if this property is searchable. |
9.2 |
PARENT_OBJECT_ CLASS_ID |
INTEGER |
Null |
FK – The OBJECT_CLASS_ID of the parent type if this type is inheriting from a parent type. |
9.2 |
PATH |
VARCHAR (882) |
Not Null |
The string path of the object class. This will take the form of |
9.2 |
OBJECT_CLASS_ DESCRIPTION |
VARCHAR (254) |
Null |
Optional description for the content type. |
9.2 |
WORKFLOW_ID |
INTEGER |
Null |
The workflow ID associated with the type. |
9.2 |
The CM_PROPERTY
table identifies a property. The property consists of a name value pair; the name is unique relative to the CM_NODE,
and the value is either a Date, BLOB, Boolean, Number, Float, or Varchar.
Only one value should be set on a given row; if the value is a BLOB
, then all of the BLOB_
columns can be set. If the IS_MULTIVALUED
column is set to 1, then there will be multiple rows with the same property name and same NODE_ID
. A property can represent both the content and meta-content for a Node.
Table 10-96 CM_PROPERTY Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
PROPERTY_ID |
INTEGER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
|
CREATION_DATE |
DATETIME |
Not Null |
The date and time the row was created. |
|
MODIFIED_DATE |
DATETIME |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
|
NODE_ID |
INTEGER |
Not Null |
FK – The ID of the node that contains the property. |
|
PROPERTY_NAME |
VARCHAR(894) |
Not Null |
The name of the property. It must be unique relative to its node. |
9.2 |
PROPERTY_TYPE |
SMALLINT |
Not Null |
The type of the property: 0 = Boolean 1 = Number 2 = Float 3 = Varchar 4 = Date 5 = BLOB 6 = Nested 7 = Linked |
|
PROPERTY_DEFINITION_ID |
INTEGER |
Null |
FK – The ID of the property definition to which this property must conform. |
|
BOOLEAN_VALUE |
SMALLINT |
Null |
True (1) for the Property if the |
|
DATETIME_VALUE |
DATETIME |
Null |
The datetime value for the property if the |
|
LONG_VALUE |
NUMERIC |
Null |
The long number or integer value for the Property if the |
|
DOUBLE_VALUE |
FLOAT |
Null |
The floating point decimal number value for the Property if the |
|
TEXT_VALUE |
VARCHAR(254) |
Null |
The textual property value for the Property if the |
|
BLOB_VALUE |
BLOB |
Null |
The binary large object for the Property if the |
|
BLOB_VALUE_CHECKSUM_HEX |
VARCHAR(32) |
Null |
The HEX representation of the MD5 checksum for each binary value in the table. |
9.2 |
BLOB_FILE_NAME |
VARCHAR(50) |
Null |
Name of the file associated with the |
|
BLOB_FILE_SIZE |
INTEGER |
Null |
The size of the file in bytes associated with the |
|
BLOB_CONTENT_TYPE |
VARCHAR(100) |
Null |
The content type (mime type and character set) for the |
|
LINKED_NODE_ REPOSITORY_NAME |
VARCHAR(254) |
Null |
For a property of type link, the name of the repository to which the link property refers. |
9.2 |
LINKED_NODE_UID |
VARCHAR(254) |
Null |
For a property of type link, the repository-specific node UID to which the link property refers. |
9.2 |
NESTED_GROUP_ID |
VARCHAR(254) |
Null |
An ID that acts as a grouping mechanism to relate a set of multi-valued nested properties together. |
9.2 |
ORDERED_POSITION |
SMALLINT |
Not Null |
A number associated with multi-valued properties for deterministic ordering in the presentation of the property values. For example, if the property values Snow, Sleet, Wind and Rain are added when constructing a multi-valued property those values will always appear in the order in which they were added. Property value Snow would have an ordered position of 1, Sleet would be 2 and so on. The property values ordered position can be updated (or re-ordered) with the Content Management API. |
10.0 |
A number associated with multi-valued properties for deterministic ordering in the presentation of the property values. For example, if the property values Snow, Sleet, Wind and Rain are added when constructing a multi-valued property those values will always appear in the order in which they were added. Property value Snow would have an ordered position of 1, Sleet would be 2 and so on. The property values ordered position can be updated (or re-ordered) via the Content Management API.
This table identifies the valid values or choices for a PropertyDefinition (row in the CM_PROPERTY_DEFINITION
table). A property choice can identify a default choice (DEFAULT_PROERTY=1)
; if the creator of a Property does not choose different values, it is set as a Property value.
If the PropertyChoice
value is defined as NULL
(no value is supplied for the PROPERTY_TYPE
), it allows for an empty choice. For example, a Property that has a String type (or TEXT_VALUE
) could have three PropertyChoices - "blue," "red," "*," and null.
Table 10-97 CM_PROPERTY_CHOICE Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
PROPERTY_CHOICE_ID |
INTEGER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
|
CREATION_DATE |
DATETIME |
Not Null |
The date and time the row was created. |
|
MODIFIED_DATE |
DATETIME |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
|
PROPERTY_DEFINITION_ID |
INTEGER |
Not Null |
FK – The ID of the property definition that contains the property choice. |
|
DEFAULT_PROPERTY |
SMALLINT |
Not Null |
Set to |
|
BOOLEAN_VALUE |
SMALLINT |
Null |
True (1) for the Property if the |
|
DATETIME_VALUE |
DATETIME |
Null |
The date/time value for the Property if the |
|
LONG_VALUE |
NUMERIC |
Null |
The long number or integer value for the Property if the |
|
DOUBLE_VALUE |
FLOAT |
Null |
The floating point decimal number value for the Property if the |
|
TEXT_VALUE |
VARCHAR(254) |
Null |
The textual property value for the Property if the |
|
BLOB_VALUE |
BLOB |
Null |
The binary large object for the Property if the |
|
BLOB_VALUE_CHECKSUM_HEX |
VARCHAR (32) |
Null |
The HEX representation of the MD5 checksum for each binary value in the table. |
9.2 |
BLOB_FILE_NAME |
VARCHAR(50) |
Null |
The name of the file associated with the |
|
BLOB_FILE_SIZE |
INTEGER |
Null |
The size of the file in bytes associated with the |
|
BLOB_CONTENT_TYPE |
VARCHAR(100) |
Null |
The content type (mime type and characterset) for the |
|
ORDERED_POSITION |
SMALLINT |
Not Null |
A number associated with property choices for deterministic ordering in the presentation of the property choices. The default is 0. For example, if the property choices Snow, Sleet, Wind, and Rain are added when constructing the property choices for a given property, those choices will always appear in the order in which they were added. Property choice Snow would have an ordered position of 1, Sleet would be 2 and so on. The property choices ordered positions can be updated or re-ordered with the Content Management API. |
10.2 |
The PropertyDefinition
table defines the shape of a property. It describes the property type (BLOB, Boolean, Varchar, Float, Date, Number), whether it is required, whether it is editable, the default value, and restricted values, if applicable. A PropertyDefinition
can have 0..n PropertyChoices.
This is a list of values that you can select for a Property's values. Rules for a PropertyDefinition
are as follows:
If the PropertyDefinition
contains a reference, it cannot be multi-valued or binary.
If the PropertyDefinition
is binary, it cannot be multi-valued or restricted and can have only one PropertyChoice.
If the PropertyDefinition
is boolean, it cannot be multi-valued. If the PropertyDefinition
is restricted, then the Property's value(s) must be contained in the PropertyChoice
list, or be null.
For example: consider a PropertyDefinition named color. It has PropertyChoices blue, green, and red. If the PropertyDefinition is restricted, then the value of a property defined by this PropertyDefinition cannot have a value other than green, red, blue, or null.
Table 10-98 CM_PROPERTY_DEFINITION Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
PROPERTY_DEFINITION_ID |
INTEGER |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
|
CREATION_DATE |
DATETIME |
Not Null |
The date and time the row was created. |
|
MODIFIED_DATE |
DATETIME |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
|
OBJECT_CLASS_ID |
INTEGER |
Not Null |
|
|
PROPERTY_NAME |
VARCHAR(100) |
Not Null |
The name associated with the property definition. The combination of
|
|
PROPERTY_TYPE |
SMALLINT |
Not Null |
The type of the property: 0 = Boolean 1 = Number 2 = Float 3 = Varchar 4 = Date 5 = BLOB |
|
IS_MANDATORY |
SMALLINT |
Not Null |
True if the value of a property must be set. |
|
IS_READ_ONLY |
SMALLINT |
Not Null |
True if the value of a property should not be set by an end user. |
|
IS_RESTRICTED |
SMALLINT |
Not Null |
True if the value of a property should come from the property choice values. |
|
IS_MULTI_VALUED |
SMALLINT |
Not Null |
True if there can be multiple rows with the same property name, |
|
COLUMN_NAME |
VARCHAR(30) |
Null |
The name of a column added to the |
|
DESCRIPTION |
VARCHAR(254) |
Null |
A description of the property definition. |
|
IS_SEARCHABLE |
SMALLINT |
Not Null |
Defines whether values of this property definition should be indexed by the full text search engine. Possible values are: 0 = Not searchable (the default) 1 = Searchable |
9.2 |
PROPERTY_DEFINITION_ TYPE |
SMALLINT |
Not Null |
The type of the property definition. Native definitions are defined on the containing object class. Inherited definitions are populated through type inheritance, and overridden definitions are also populated through type inheritance, but changed by the inheriting (child) type. Possible values are: 1 = Native (the default) 2 = Inherited 3 = Overridden |
9.2 |
NESTED_OBJECT_CLASS_ID |
INTEGER |
Not Null |
FK – The OBJECT_CLASS_ID of the nested type. An object class can "nest" the set of definitions as defined by another object class. |
9.2 |
This table provides for large textual property value strings. The View CM_PROPERTY_V (new in 10.0) joins the CM_PROPERTY_TEXT table with the CM_PROPERTY table to expand the size of text value strings to VARCHAR(4254).
This table was added in WebLogic Portal version 9.2. It stores information for the Content Management workflow.
Table 10-100 CM_WORKFLOW Table
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
WORKFLOW_ID |
INTEGER |
Not Null |
PK – A unique, system-generated number to use as the workflow ID. |
9.2 |
WORKFLOW_NAME |
VARCHAR (50) |
Not Null |
The name of the workflow. |
9.2 |
WORKFLOW_DOCUMENT |
BLOB |
Not Null |
The binary representation of the workflow document. |
9.2 |
CREATION_DATE |
DATETIME |
Not Null |
The date and time the row was created. |
9.2 |
MODIFIED_DATE |
DATETIME |
Not Null |
The date and time the row was last modified. This column's data is maintained using a database trigger. |
9.2 |
WORKFLOW_COMMENT |
VARCHAR(254) |
Null |
Optional comment for the workflow. |
9.2 |
The WLP repository provides automatic versioning.
For an entity relation diagram of the Virtual Content Repository (versioning) database tables see Figure B-12, "Content Management Virtual Content Repository Database Tables".
The Content Management system has the following tables for virtual objects:
This table uniquely identifies a content-managed node from a WLP repository (that is, CM_NODE table) that has been versioned and is being edited within the Content Management Virtual Repository.
Table 10-101 CMV_NODE Table
Column Name | Data Type | Null Value | Description |
---|---|---|---|
NODE_ID |
VARCHAR (254) |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
NODE_NAME |
VARCHAR (50) |
Not Null |
The name of the node. |
REPOSITORY_NAME |
VARCHAR (254) |
Not Null |
The name of the repository where the node was created and published. |
IS_LOCKED |
SMALLINT |
Not Null |
Flag to determine if the record is locked. |
OBJECT_CLASS_ID |
VARCHAR (254) |
Null |
The object class ID that is associated with the node. |
ASSIGNED_TO_USER_NAME |
VARCHAR(200) |
Null |
User name to which the node is assigned. |
LAST_ASSIGNED_TO_USER_NAME |
VARCHAR(200) |
Null |
User name to which the node is assigned; to be used in a revert scenario. |
This table uniquely identifies all roles for a given node that have authorization to view or alter the node.
This table uniquely identifies all the versions of a mode within the Virtual Content Repository.
Table 10-103 CMV_NODE_VERSION Table
Column Name | Data Type | Null Value | Description |
---|---|---|---|
NODE_ID |
VARCHAR(254) |
Not Null |
PK/FK – The ID of the node for which versions have been created. Foreign key relationship to CMV_NODE table. |
NODE_VERSION_ID |
VARCHAR(254) |
Not Null |
PK – The unique version ID for the node. |
CM_MODIFIED_DATE |
DATETIME |
Not Null |
Time the node version was last edited. |
MODIFIED_BY |
VARCHAR(100) |
Not Null |
User name of the person who last edited the node version. |
VERSION_COMMENT |
VARCHAR(254) |
Not Null |
Comment added to a node version when saving. |
LIFECYCLE_STATUS |
INTEGER |
Null |
Specific life cycle status that the node version has been assigned (for example, In Progress, Published, and so on). |
This table uniquely identifies a property that can be associated with a node version. For example, some properties of a book might be author, title, and subject.
Table 10-104 CMV_PROPERTY Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
PROPERTY_ID |
VARCHAR(254) |
Not Null |
PK – A unique, system-generated number to use as the record ID. |
|
CREATION_DATE |
DATETIME |
Not Null |
The date and time the row was created; the default is the current timestamp. |
|
MODIFIED_DATE |
DATETIME |
Not Null |
Date and time the row was last modified; the default is the current timestamp. This column's data is maintained using a database trigger. |
|
PROPERTY_NAME |
VARCHAR(894) |
Not Null |
The name of the property. It must be unique relative to its node. |
9.2 |
PROPERTY_TYPE |
SMALLINT |
Not Null |
The type of the property: 0 = Boolean 1 = Number 2 = Float 3 = Varchar 4 = Date 5 = BLOB |
This table uniquely identifies a value for a given property. For example, a property SUBJECT
for a BOOK
might have a value of FINANCE
.
Only one value is set on a given record. If the value is BLOB
, then all the BLOB_
columns can be set.
Table 10-105 CMV_VALUE Table
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
PROPERTY_ID |
VARCHAR(254) |
Not Null |
PK/FK – ID of the property with which the values are associated. Foreign key relationship to CMV_PROPERTY. |
|
VALUE_ID |
VARCHAR(254) |
Not Null |
PK – A unique, system-generated number to use as the value ID. |
|
CREATION_DATE |
DATETIME |
Not Null |
The date and time the row was created; the default is the current timestamp. This column's data is maintained using a database trigger. |
|
MODIFIED_DATE |
DATETIME |
Not Null |
Date and time the row was last modified; the default is the current timestamp. This column's data is maintained using a database trigger. |
|
BOOLEAN_VALUE |
SMALLINT |
Not Null |
Flag to determine if property is a Boolean value: 1= True, 0 = False. |
|
DATETIME_VALUE |
DATETIME |
Null |
The datetime value for the property if the PROPERTY_TYPE is DATE. |
|
LONG_VALUE |
NUMERIC (20) |
Null |
The long number or integer value for the property if the PROPERTY_TYPE is NUMBER. |
|
DOUBLE_VALUE |
FLOAT |
Null |
The floating point decimal number value for the property value if the PROPERTY_TYPE is FLOAT. |
|
TEXT_VALUE |
VARCHAR(254) |
Null |
The textual property value if the PROPERTY_TYPE is VARCHAR. |
|
BLOB_VALUE |
BLOB |
Null |
The binary large object for the property value if the PROPERTY_TYPE is BLOB. |
|
BLOB_VALUE_CHECKSUM_HEX |
VARCHAR(32) |
Null |
The HEX representation of the MD5 checksum for each binary value in the table. |
9.2 |
BLOB_FILE_NAME |
VARCHAR (50) |
Null |
The name of the file associated with BLOB_VALUE. |
|
BLOB_FILE_SIZE |
INTEGER |
Null |
The size of the file (in bytes) associated with BLOB_VALUE. |
|
BLOB_CONTENT_TYPE |
VARCHAR (100) |
Null |
The content type (MIME and character set) for the BLOB_VALUE. For example: "text/html;charset=iso8859-1" |
|
LINKED_NODE_ REPOSITORY_NAME |
VARCHAR(254) |
Null |
For a property of type link, the name of the repository to which the link property refers. |
9.2 |
LINKED_NODE_UID |
VARCHAR(254) |
Null |
For a property of type link, the repository-specific node UID to which the link property refers. |
9.2 |
NESTED_GROUP_ID |
VARCHAR(254) |
Null |
An ID that acts as a grouping mechanism to relate a set of multi-valued nested properties together. |
9.2 |
ORDERED_POSITION |
SMALLINT |
Not Null |
A number associated with multi-valued properties for deterministic ordering in the presentation of the property values. For example, if the property values Snow, Sleet, Wind and Rain are added when constructing a multi-valued property those values will always appear in the order in which they were added. Property value Snow would have an ordered position of 1, Sleet would be 2 and so on. The property values ordered position can be updated (or re-ordered) with the Content Management API. |
10.0 |
This table provides for large textual property value strings. The View CMV_VALUE_V (new in 10.0) joins the CMV_VALUE_TEXT table with the CMV_VALUE table to expand the size of text value strings to VARCHAR(4254).
Table 10-106 CMV_VALUE_TEXT Table Metadata
Column Name | Data Type | Null Value | Description | New or Changed Version |
---|---|---|---|---|
PROPERTY_ID |
VARCHAR (254) |
Not Null |
PK and FK – The PROPERTY_ID from the CMV_VALUE table. |
10.0 |
VALUE_ID |
VARCHAR (254) |
Not Null |
PK and FK – The value ID from the CMV_VALUE table. |
10.0 |
TEXT_VALUE_EXT |
VARCHAR (3746) |
Null |
Extends textual value strings. |
10.0 |
This table uniquely identifies a relationship between a CMV_NODE_VERSION and CMV_PROPERTY.
Table 10-107 CMV_NODE_VERSION_PROPERTY Table
Column Name | Data Type | Null Value | Description |
---|---|---|---|
NODE_ID |
VARCHAR(254) |
Not Null |
PK/FK – ID of the node with which the properties are associated. Foreign key relationship to CMV_NODE_VERSION. |
NODE_VERSION_ID |
VARCHAR(10) |
Not Null |
PK/FK – ID of the node version with which the properties are associated. Foreign key relationship to CMV_NODE_VERSION. |
PROPERTY_ID |
VARCHAR(254) |
Not Null |
PK/FK – ID of the property with which the node versions are associated. Foreign key relationship to CMV_PROPERTY. |
WebLogic Server provides the option of using an external RDBMS as a datastore that is used by authorization, role mapping, credential mapping, and certificate registry providers. WebLogic Portal uses this datastore as part of its default domain configuration. When you configure a WLP domain, the RDBMS security store tables are automatically created.
For detailed information on the RDBMS security store, see the WebLogic Server document, "Managing the RDBMS Security Store," in Oracle Fusion Middleware Securing Oracle WebLogic Server.
Table 10-108 highlights the collection of columns from the RDBMS security store tables for which WLP has modified the column sizes.
Table 10-108 RDBMS Security Store Database Table Defaults
Column Name | WLS Default Size (bytes) | WLP Default Size (bytes) | DB2 | MySQL |
---|---|---|---|---|
DOMN |
128 |
128 |
50 |
50 |
REALMN |
128 |
128 |
50 |
50 |
CREDN |
400 |
768 |
WLP default |
600 |
CN |
400 |
768 |
WLP default |
600 |
PM_CN |
400 |
768 |
WLP default |
600 |
ENTRY_KEY |
400 |
768 |
WLP default |
600 |
WCRIDN |
400 |
768 |
WLP default |
600 |
WCRSN |
400 |
768 |
WLP default |
600 |
WCRSDN |
400 |
768 |
WLP default |
600 |
WCRSKI |
400 |
768 |
WLP default |
600 |
XRS |
400 |
768 |
WLP default |
600 |
TYPEN |
400 |
768 |
WLP default |
600 |
XR |
400 |
768 |
WLP default |
600 |