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 PointBase 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.0 release of WebLogic Portal.
The appendix Scripts and Properties Files identifies the filenames and location of DDL (database definition language) files for each set of WebLogic Portal database objects.
Personalization 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.
Click to view and use the magnifying tool to inspect individual tables in the entity-relation diagram for the Personalization database objects.
Base Personalization Database Tables
The following tables support basic personalization functionality:
This table associates users with profiles. User profiles use property sets to organize the properties that they contain.
Table 10-1 USER_PROFILE Table Metadata
Column Name
Data Type
Null Value
Description
USER_NAME
VARCHAR(200)
Not Null
PK – The user name.
PROFILE_TYPE
VARCHAR(100)
Not Null
A type of profile associated with the user.
CREATION_DATE
DATE
Not Null
The date and time this record was created.
ENTITY Database Table
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.
PROPERTY_KEY Database Table
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.
PROPERTY_VALUE Database Table
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 PROPERTY_KEY.PROPERTY_KEY_ID
ENTITY_ID
NUMBER(15)
Not Null
FK to ENTITY.ENTITY_ID
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.
SEQUENCER Database Table
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.
USERS Database Table
This table was added in WebLogic Portal version 9.2. It maintains user, group, and password information for the WebLogic Server SQLAuthenticator.
Table 10-6 USERS Table Metadata
Column Name
Data Type
Null Value
Description
New or Changed Version
U_NAME
VARCHAR(200)
Not Null
PK – Unique name of the user.
9.2
U_PASSWORD
VARCHAR(50)
Not Null
Password of the user.
9.2
U_DESCRIPTION
VARCHAR(1000)
Null
Optional description.
9.2
GROUPS Database Table
This table was added in WebLogic Portal version 9.2. It maintains information on groups and their descriptions.
Table 10-7 GROUPS Table Metadata
Column Name
Data Type
Null Value
Description
New or Changed Version
G_NAME
VARCHAR(200)
Not Null
PK – Unique name of the group.
9.2
G_DESCRIPTION
VARCHAR(1000)
Null
Optional description.
9.2
GROUPMEMBERS Database Table
This table was added in WebLogic Portal version 9.2. It maintains group hierarchy information.
Table 10-8 GROUPMEMBERS Table Metadata
Column Name
Data Type
Null Value
Description
New or Changed Version
G_NAME
VARCHAR(200)
Not Null
PK and FK to the GROUPS table. Unique name of the group.
9.2
G_MEMBER
VARCHAR(200)
Not Null
PK – Member of the group.
9.2
P13N_QUIESCENT_STATE Database Table
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
P13N_LEASE Database Table
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
Credential Service Dictionary Tables
Click here for Personalization Credential Service tables and use the magnifying tool to inspect individual tables in the entity-relation diagram.
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
P13N_CREDENTIAL_MASTER Database Table
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
P13N_CREDENTIAL_METADATA Database Table
This table was added in WebLogic Portal 10.2. The table is used to identify the attributes of the credential.
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
P13N_JOB_LISTENER Database Table
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
P13N_JOB_PARAMETER Database Table
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
P13N_JOB_RUN_HEADER Database Table
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
P13N_JOB_RUN_DATA Database Table
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
Entitlement Reference Dictionary Tables
Click here for Entitlement tables and use the magnifying tool to inspect individual tables in the entity-relation diagram.
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.
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.
P13N_ENTITLEMENT_POLICY Database Table
This table uniquely identifies an entitlement policy. An entitlement policy is created when an entitlement role is associated with an entitlement resource and capability.
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.
Tracked Anonymous User Dictionary Tables
This section documents the database objects for the WebLogic Portal package. For more information about anonymous users, refer to the User Management Guide.
The following tables support tracking of anonymous users:
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 java.io.Serializable.
P13N_ANONYMOUS_USER Database Table
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.
Behavior Tracking Database Tables
Click here for Behavior Tracking tables and use the magnifying tool to inspect individual tables in the entity-relation diagram.
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.
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 EVENT_TYPE.
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.
BT_EVENT Database 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 CLOB (Character Large Object). See Table 10-29.
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-28, 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-29.
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.
DATA_SYNC_ITEM Database Table
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 DATA_SYNC_ APPLICATON.APPLICATION_ID
SCHEMA_URI_ID
NUMBER(15)
Not Null
FK to DATA_SYNC_ SCHEMA_URI.SCHEMA_URI_ID
VERSION_MAJOR
NUMBER(15)
Not Null
FK to DATA_SYNC_ VERSION.VERSION_MAJOR
VERSION_MINOR
NUMBER(15)
Not Null
FK to DATA_SYNC_ VERSION.VERSION_MINOR
ITEM_CHECKSUM
NUMBER(15)
Not Null
A generated number representing the contents of the XML_DEFINITION column.
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.
DATA_SYNC_SCHEMA_URI Database Table
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.
DATA_SYNC_VERSION Database Table
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
Portal Services database objects are used for placeholders, ads, and ad bucket services.
Click to view, and use the magnifying tool to inspect individual tables in the entity-relation diagram for Portal Services database objects.
The following tables compose the Portal Services database:
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 CONTAINER_REF.
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.
AD_COUNT Database Table
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.
PLACEHOLDER_PREVIEW Database Table
This table is used as a mechanism to hold the placeholder for previewing purposes only.
Table 10-37 PLACEHOLDER_PREVIEW Table Metadata
Column Name
Data Type
Null Value
Description
PREVIEW_ID
NUMERIC(15)
Not Null
PK – A unique, system-generated number used as the record identifier.
XML_DEFINITION
CLOB
Null
The representation of the expression to be previewed.
MAIL_ADDRESS Database Table
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 MAIL_MESSAGE table.
ADDRESS
VARCHAR(254)
Not Null
Stores the various e-mail addresses on the distribution list.
SEND_TYPE
VARCHAR(4)
Not Null
Determines how the ADDRESS should be included on the distribution. Possible values are TO, CC, or BCC.
MAIL_BATCH Database Table
This table establishes a batch for each mailing.
Table 10-39 MAIL_BATCH Table Metadata
Column Name
Data Type
Null Value
Description
BATCH_ID
NUMERIC(15)
Not Null
PK – A unique, system-generated number to use as the record ID.
BATCH_NAME
VARCHAR(254)
Not Null
The name of the mail message batch.
MAIL_BATCH_ENTRY Database Table
This table correlates the mail batch with the specific mail message.
Table 10-40 MAIL_BATCH_ENTRY Table Metadata
Column Name
Data Type
Null Value
Description
BATCH_ID
NUMERIC(15)
Not Null
PK and FK – A unique, system-generated number to use as the record ID.
MESSAGE_ID
NUMERIC(15)
Not Null
PK and FK – Foreign key to the MAIL_MESSAGE table.
MAIL_HEADER Database Table
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 MAIL_MESSAGE table.
HEADER_NAME
VARCHAR(50)
Null
The name of the mail message header.
HEADER_VALUE
VARCHAR(254)
Null
The value of the mail message header.
MAIL_MESSAGE Database Table
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.
SCENARIO_END_STATE Database Table
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 ID.
CONTAINER_REF
VARCHAR(254)
Not Null
PK—the campaign unique identifier. FK to CAMPAIGN.CAMPAIGN_UID.
CONTAINER_TYPE
VARCHAR(50)
Not Null
PK—At this time this column always holds the string Campaign.
APPLICATION_NAME
VARCHAR(100)
Not Null
PK – The deployed J2EE application name. This should match the name in the WebLogic Server console.
Portal Framework Database Objects
The Portal Framework is the portion of WebLogic Portal that is responsible for the rendering and customization of the portal.
Click to view, and use the magnifying tool to inspect individual tables in the logical entity-relation diagram for the Portal Framework tables. This includes tables that support WSRP and localization.
Portal Framework Database Tables
In this section, tables are arranged alphabetically as a data dictionary. The following tables compose the generic Portal Framework database:
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 PF_MARKUP_DEFINITION.
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 L10N_INTERSECTION.
WEBAPP_NAME
VARCHAR(80)
Not Null
Name of the J2EE web application (as defined in the config.xml) to which the portal resource is scoped.
BOOK_LABEL
VARCHAR(80)
Null
A moniker used to reference this portal resource for development purposes. This is the same as the bookDefinitionLabel in Workshop for WebLogic.
If a label is not supplied at creation time, the BOOK_DEFINITION_ID prefixed with a B is used. This label can be supplied to APIs to activate books or pages.
PF_BOOK_GROUP Database Table
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 PF_BOOK_INSTANCE that identifies the parent BOOK_INSTANCE_ID.
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 PF_BOOK_INSTANCE that identifies the child BOOK_INSTANCE_ID.
PAGE_INSTANCE_ID
NUMBER
Null
FK to PF_BOOK_INSTANCE.
DESKTOP_INSTANCE_ID
NUMBER
Null
FK to PF_DESKTOP_INSTANCE. If this book grouping is an administrator or end user customization, this value is non null and points to the administrator’s or user’s desktop. If this field is null, it represents the library's view.
PF_BOOK_INSTANCE Database Table
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 BOOK.
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 L10N_RESOURCE title is used.
BOOK_DEFINITION_ID
NUMBER
Not Null
FK to PF_BOOK_DEFINITION.
MENU_DEFINITION_ID
NUMBER
Null
FK to PF_MENU_DEFINITION. Can be null as not every book must have a menu.
THEME_DEFINITION_ID
NUMBER
Null
FK to PF_THEME_DEFINITION.
PF_DESKTOP_DEFINITION Database Table
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 PF_PORTAL – identifies the partial URL path to this desktop and parent portal.
WEBAPP_NAME
VARCHAR(80)
Not Null
Part of the PK and FK to PF_PORTAL. This is the name of the web application (as defined in the config.xml file) to which this desktop 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 L10N_INTERSECTION. The BOOK_INSTANCE_ID of the main or default PF_BOOK_INSTANCE for the desktop.
MARKUP_DEFINITION_ID
NUMBER
Not Null
FK to PF_MARKUP_DEFINITION.
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 compat_9_2, or off.
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 0 (true).
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
PF_DESKTOP_INSTANCE Database Table
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 PF_DESKTOP_DEFINITION.
PORTAL_PATH
VARCHAR(40)
Not Null
FK to PF_DESKTOP_DEFINITION.
WEBAPP_NAME
VARCHAR(80)
Not Null
FK to PF_DESKTOP_DEFINITION.
MAIN_BOOK_ID
NUMBER
Not Null
FK to BOOK_INSTANCE_ID of the main or default PF_BOOK_INSTANCE for the desktop.
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 PF_LOOK_AND_FEEL_DEFINITION.
INSTANCE_TITLE
VARCHAR(20)
Null
An end-user-customized title for this DESKTOP. This title is not internationalized as it is used only by the end user.
If the end user does not customize the desktop title, then the value is null and the L10N_RESOURCE title is used.
SHELL_DEFINITION_ID
NUMBER
Not Null
FK to PF_SHELL_DEFINITION.
PF_LAYOUT_DEFINITION Database Table
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 PF_MARKUP_ DEFINITION.
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.
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 is deleted and the layout is still in use. You can either return the .layout file and this flag is automatically reset, or remove the layout with a replacement layout in the admin tools.
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 ICON for this layout definition.
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 for display in the Administration Console or Visitor Tools.
10.0
PF_LOOK_AND_FEEL_DEFINITION Database Table
This table defines a LOOK and FEEL portal library resource or template for assignment to DESKTOPs that control how a portal renders.
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 .laf file is deleted and the look and feel is still in use. You can either return the .laf file and this flag is automatically reset, or remove the look and feel with a replacement look and feel in the Administration Console.
LOOK_FEEL_FILE
VARCHAR(255)
Not Null
The fully qualified file path (from the web app) to the location of the .laf file associated with this look and feel definition.
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
PF_MARKUP_DEFINITION Database Table
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.
PF_MARKUP_XML Database Table
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
PF_MENU_DEFINITION Database Table
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 PF_MARKUP_DEFINITION.
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.
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 is deleted and the menu is still in use. You can either return the .menu file and this flag is automatically reset, or remove the menu with a replacement menu in the Administration Console.
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
PF_PAGE_DEFINITION Database Table
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 PF_MARKUP_DEFINITION.
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 L10N_INTERSECTION.
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.
PF_PAGE_INSTANCE Database Table
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 PF_LAYOUT_DEFINITION.
PAGE_DEFINITION_ID
NUMBER
Not Null
FK to PF_PAGE_DEFINITION.
THEME_DEFINITION_ID
NUMBER
Null
FK to PF_THEME_DEFINITION.
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.
PF_PLACEHOLDER_DEFINITION Database Table
This table defines a PLACEHOLDER portal library resource or template that has a LAYOUT definition and can be assigned to a PLACEMENT.
PK – A unique, system-generated number to use as the record ID.
MARKUP_DEFINITION_ID
NUMBER
Not Null
FK to PF_MARKUP_DEFINITION.
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 L10N_INTERSECTION.
LAYOUT_DEFINITION_ID
NUMBER
Not Null
FK to PF_LAYOUT_DEFINITION.
PF_PLACEMENT Database Table
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 PF_PAGE_INSTANCE.
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 PF_PLACEHOLDER_DEFINITION.
PORTLET_INSTANCE_ID
NUMBER
Null
FK to PF_PORTLET_INSTANCE.
BOOK_INSTANCE_ID
NUMBER
Null
FK to PF_BOOK_INSTANCE.
DESKTOP_INSTANCE_ID
NUMBER
Null
FK to PF_DESKTOP_INSTANCE. If this placement grouping is an administrator- or end-user-customization, the value is non null and points to the administrator’s or user’s desktop. If this field is null, it represents the library's view.
PF_PORTAL Database Table
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 L10N_INTERSECTION.
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 .portal) to forward to a default desktop or to display a list of desktops available under this portal.
PF_PORTLET_CATEGORY Database Table
This table associates a PORTLETCATEGORY resource with a PORTLETDEFINITION.
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 PF_PORTLET_CATEGORY_ DEFINITION.
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.
PF_PORTLET_CATEGORY_DEFINITION Database Table
This table identifies a PORTLET CATEGORY and PORTLET CATEGORY hierarchy resource or template for association with a PORTLET resource.
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 L10N_INTERSECTION.
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 PF_PORTLET_CATEGORY_ DEFINITION that identifies the parent portlet category. NULL if this is a top level category.
PF_PORTLET_DEFINITION Database Table
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 PF_MARKUP_DEFINITION.
IS_PUBLIC
NUMBER
Not Null
A boolean indicating that the portlet definition is public. Only public portlet definitions are ever exposed to site visitors.
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_FORKABLE is true.
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 IS_CACHEABLE is true.
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 PORTLET_FILE associated with this object has been removed from the file system.
This flag is set to true only when the .portlet file is deleted and the portlet is still in use. You can either return the .portlet file and this flag is automatically reset, or remove the portlet in the Administration Console.
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 (*.portlet) file describing the controls that make up the portlet. The field is null if no portlet file exists.
PF_PORTLET_INSTANCE Database Table
This table identifies a customized or localized instance of a portlet.
PK – A unique, system-generated number to use as the record ID.
PORTLET_DEFINITION_ID
NUMBER
Not Null
FK to PF_PORTLET_DEFINITION.
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 L10N_INTERSECTION.
PORTLET_LABEL
VARCHAR(80)
Not Null
A moniker used to reference this portal resource for development purposes.
THEME_DEFINITION_ID
NUMBER
Null
FK to PF_THEME_DEFINITION.
PARENT_PORTLET_ INSTANCE_ID
NUMBER
Null
FK to PF_PORTLET_INSTANCE that identifies the parent portlet instance. the value is null if this is a top-level portlet instance.
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
PF_PORTLET_PREFERENCE Database Table
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.
PF_PORTLET_PREFERENCE_VALUE Database Table
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.
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.
PF_SHELL_DEFINITION Database Table
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 PF_MARKUP_DEFINITION.
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
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 is deleted and the shell is still in use. You can either return the .shell file and this flag is automatically reset, or remove the shell with a replacement in the Administration Console.
SHELL_FILE
VARCHAR (255)
Not Null
The name of the .shell file contained in the application’s framework/markup/shell directory backing this shell definition.
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
PF_SHELL_PLACEMENT Database Table
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
PF_THEME_DEFINITION Database Table
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 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_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 is deleted and the theme is still in use. You can either return the .theme file and this flag is automatically reset, or remove the theme using the Administration Console.
THEME_FILE
VARCHAR(255)
Not Null
The name of the .theme file contained in the application’s framework/markup/theme directory backing this theme definition.
THUMBNAIL_URI
VARCHAR(255)
Null
Associates a thumbnail image with the theme for display in the Administration Console or Visitor Tools.
10.0
PF_URL_COMPRESSION Database Table
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
Localization Dictionary Tables
This section documents the database objects for the WebLogic Portal framework. The following tables support localization:
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.
Table 10-74 PF_CONSUMER_PORTLETS Database Table
Column Name
Data Type
Null Value
Description
CONSUMER_ID
NUMBER
Not Null
PK/FK to PF_PRODUCER_REGISTRY.
PORTLET_ID
NUMBER
Not Null
PK/FK to PF_PORTLET_INSTANCE.
PF_CONSUMER_PROPERTIES Database Table
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 PF_CONSUMER_REGISTRY
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
PF_CONSUMER_REGISTRY Database Table
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 config.xml) 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. 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
PF_PRODUCER_REGISTRY Database Table
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 productName.majorVersion.minorVersion where productName identifies the product that the consumer installed for its deployment, and majorVersion and minorVersion are vendor-defined indications of the version of its product.
PF_PROXY_PORTLET_INSTANCE Database Table
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.
PK – A unique system-generated number to use as the record ID.
PRODUCER_ID
INTEGER
Not Null
FK to PF_CONSUMER_REGISTRY.
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 IS_PRODUCER_OFFERED is True, and the PORTLET_INSTANCE_ID is null, this PF_PROXY_PORTLET_INSTANCE is removed from the database during data cleanup processing.
PORTLET_INSTANCE_ID
INTEGER
Null
FK to PF_PORTLET_INSTANCE for the proxy portlet. If the associated PF_PORTLET_INSTANCE row is deleted, the value of this column is set to null.
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).
PF_PROXY_BOOK Database Table
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
PF_PROXY_PAGE Database Table
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 Framework Database Objects
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.
Click to view, and use the magnifying tool to inspect individual tables in the logical entity-relation diagram for the Communities Portal Framework tables.
Communities Portal Framework Data Dictionary Tables
The Communities Portal Framework system has the following tables:
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 communities-config.xml.
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
PF_COMMUNITY_MEMBER Database Table
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
PF_COMMUNITY_MEMBERSHIP Database Table
The PF_COMMUNITY_MEMBERSHIP table contains information regarding the membership status of community members.
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
PF_MEMBERSHIP_CAPABILITY Database Table
The PF_MEMBERSHIP_CAPABILITY table contains information about the capabilities of a member within the community.
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
PF_COMMUNITY_PROPERTY Database Table
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
PF_COMMUNITY_PROPERTY_VALUE Database Table
The PF_COMMUNITY_PROPERTY_VALUE table contains information regarding the actual value of the custom community property.
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
PF_FILE_TEMPLATE Database Table
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 .portal file that this FileTemplate is based on.
9.2
WEBAPP_NAME
VARCHAR(80)
Not Null
Name of the web application that contains the .portal file that this FileTemplate is based.
9.2
PF_INVITATION Database Table
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
PF_INVITEE Database Table
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.
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
PF_INVITEE_PROPERTY Database Table
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
PF_MESSAGING_ADDR Database Table
The PF_MESSAGING_ADDR table is reserved for future use.
PF_NOTIFICATION Database Table
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
PF_NOTIFICATION_PAYLOAD Database Table
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.
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
Content Management Database Objects
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.
Click to view, and use the magnifying tool to inspect individual tables in the logical entity-relation diagram for the content management tables.
Content Management Data Dictionary 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 (NODE_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 NODE_NAME) is the root's child.
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.
TITLE
VARCHAR(254)
Not Null
Applies only to a GroupSpace repository. Title for GroupSpace content, used for all GroupSpace content types.
DESCRIPTION
VARCHAR(254)
Null
Applies only to a GroupSpace repository. Description for GroupSpace content; can be used by all GroupSpace content types.
VISIBILITY
VARCHAR(254)
Not Null
Applies only to a GroupSpace repository. Scopes viewing of GroupSpace data; used for GroupSpace content types. Valid visibility values are:
Personal – only viewable by a specific user but viewable in all GroupSpace Communities
Private – only viewable by a specific user and only viewable in the GroupSpace Community in which it was created
Community – viewable by all users within a GroupSpace Community
OWNER
VARCHAR(254)
Not Null
Applies only to a GroupSpace repository. User who owns the GroupSpace content.
FEED_ENTRY_ PUBLICATION_DATE
TIMESTAMP
Not Null
Applies only to a GroupSpace repository. Date that a Feed Entry was published. This is used only by content of type Feed_Entry.
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
CM_COLLABORATION_API_METADATA Database Table
This table is used to store information about WebLogic Portal’s collaboration portlets.
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
CM_OBJECT_CLASS Database Table
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 PROPERTY_DEFINITION_ID for the primary CM_PROPERTY_ DEFINITION table row that defines the content for a node associated to the object class.
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 /object_class_name for most object classes. Those that use inheritance will take the form /parent/child or /grandparent/parent/child, and so on.
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
CM_PROPERTY Database Table
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.
FK – The ID of the property definition to which this property must conform.
BOOLEAN_VALUE
SMALLINT
Null
True (1) for the Property if the PROPERTY_TYPE is Boolean (PROPERTY_TYPE=0).
DATETIME_VALUE
DATETIME
Null
The datetime value for the property if the PROPERTY_TYPE is DATE (PROPERTY_TYPE=4).
LONG_VALUE
NUMERIC
Null
The long number or integer value for the Property if the PROPERTY_TYPE is NUMBER(PROPERTY_TYPE=1).
DOUBLE_VALUE
FLOAT
Null
The floating point decimal number value for the Property if the PROPERTY_TYPE is FLOAT(PROPERTY_TYPE=2).
TEXT_VALUE
VARCHAR(254)
Null
The textual property value for the Property if the PROPERTY_TYPE is VARCHAR(PROPERTY_TYPE=3).
BLOB_VALUE
BLOB
Null
The binary large object for the Property if the PROPERTY_TYPE is BLOB(PROPERTY_TYPE=5).
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_VALUE.
BLOB_FILE_SIZE
INTEGER
Null
The size of the file in bytes associated with the BLOB_VALUE.
BLOB_CONTENT_TYPE
VARCHAR(100)
Null
The content type (mime type 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
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.
CM_PROPERTY_CHOICE Database Table
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 1 if the property choice is a default, or 0 if it is not.
BOOLEAN_VALUE
SMALLINT
Null
True (1) for the Property if the PROPERTY_TYPE is BOOLEAN (PROPERTY_TYPE=0).
DATETIME_VALUE
DATETIME
Null
The date/time value for the Property if the PROPERTY_TYPE is DATE (PROPERTY_TYPE=4).
LONG_VALUE
NUMERIC
Null
The long number or integer value for the Property if the PROPERTY_TYPE is NUMBER(PROPERTY_TYPE=1).
DOUBLE_VALUE
FLOAT
Null
The floating point decimal number value for the Property if the PROPERTY_TYPE is FLOAT(PROPERTY_TYPE=2).
TEXT_VALUE
VARCHAR(254)
Null
The textual property value for the Property if the PROPERTY_TYPE is VARCHAR(PROPERTY_TYPE=3).
BLOB_VALUE
BLOB
Null
The binary large object for the Property if the PROPERTY_TYPE is BLOB(PROPERTY_TYPE=5).
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_VALUE.
BLOB_FILE_SIZE
INTEGER
Null
The size of the file in bytes associated with the BLOB_VALUE.
BLOB_CONTENT_TYPE
VARCHAR(100)
Null
The content type (mime type and characterset) for the BLOB_VALUE. For example: “text/html;charset=iso8859-1”
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
CM_PROPERTY_DEFINITION Database Table
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
FK – The OBJECT_CLASS_ID of the property definitions CM_OBJECT_CLASS.
PROPERTY_NAME
VARCHAR(100)
Not Null
The name associated with the property definition. The combination of PROPERTY_NAME and OBJECT_ CLASS_ID for an Alternate Key for the CM_PROPERTY_DEFINITION table.
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, node_id, but different property IDs.
COLUMN_NAME
VARCHAR(30)
Null
The name of a column added to the CM_NODE table that defines an explicit property.
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:
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
CM_PROPERTY_TEXT Database Table
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).
Table 10-99 CM_PROPERTY_TEXT Table Metadata
Column Name
Data Type
Null Value
Description
New or Changed Version
PROPERTY_ID
INTEGER
Not Null
PK and FK – The property ID from the CM_PROPERTY table.
10.0
TEXT_VALUE_EXT
VARCHAR (4000)
Null
Extends textual property value strings.
10.0
CM_WORKFLOW Database Table
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
Content Management Virtual Database Objects
The WLP repository provides automatic versioning.
Click to view, and use the magnifying tool to inspect individual tables in the logical entity-relation diagram for Virtual Content Repository (versioning) object tables.
Content Management Virtual Object Data Dictionary 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
Username to which the node is assigned.
LAST_ASSIGNED_TO_USER_NAME
VARCHAR(200)
Null
Username to which the node is assigned; to be used in a revert scenario.
CMV_NODE_ASSIGNED_ROLE Table
This table uniquely identifies all roles for a given node that have authorization to view or alter the node.
Table 10-102 CMV_NODE_ASSIGNED_ROLE Table
Column Name
Data Type
Null Value
Description
NODE_ID
VARCHAR(254)
Not Null
PK/FK – The ID of the node that roles are associated with. Foreign key relationship to CMV_NODE table.
ROLE_NAME
VARCHAR(254)
Not Null
PK – The name of the role.
CMV_NODE_VERSION Table
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
Username 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).
CMV_PROPERTY Table
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
CMV_VALUE Table
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
CMV_VALUE_TEXT Table
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
CMV_NODE_VERSION_PROPERTY Table
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.
