10 Data Dictionary

This chapter describes the database objects for each component of WebLogic Portal. The information in this section is collectively known as the data dictionary.

For each component of WebLogic Portal, the following information is provided:

An entity-relationship diagram
A detailed description of each database table, including:
- Table Name – The predefined name for the Table.
- Table Description – A detailed description of the contents and purpose for the table in WebLogic Portal database schema.
- Column Name – The predefined name for the column.
- Data Type – The predefined characteristics for the column.
  
  Data types vary slightly by DBMS. For instance, columns defined as BLOB data types in Oracle, DB2, and Derby would be defined as TEXT columns in Microsoft SQL Server and Sybase.
- Null Value – Indicates whether or not null values can be stored for the column.
- Column Description – A detailed description of the contents and purpose for the column including Primary Key (PK-) and Foreign Key (FK-) designations.
  
  Note:
  
  The term hint in the descriptions refers to available capabilities that are not supported in the default skeletons provided with WebLogic Portal.

The New or Changed Version column indicates the version of WebLogic Portal in which a table or column was added or altered. If the New or Changed Version column does not exist, the table or column was created prior to the 9.2 or 10.0release of WebLogic Portal.

This chapter contains the following sections:

Section 10.1, "Personalization Database Objects"
Section 10.2, "Portal Services Database Objects"
Section 10.3, "Portal Framework Database Objects"
Section 10.4, "WSRP Portal Framework Database Objects"
Section 10.5, "Communities Framework Database Objects"
Section 10.6, "Content Management Database Objects"
Section 10.7, "Content Management Virtual Content Repository Database Objects"

Section 10.8, "RDBMS Security Store Tables"

Note:

The appendix Appendix A, "Scripts and Properties Files" identifies the filenames and location of DDL (database definition language) files for each set of WebLogic Portal database objects.

10.1 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.

For an entity relation diagram of the Personalization database tables, see Figure B-1, "Personalization Database Tables".

10.1.1 Base Personalization Database Tables

The following tables support basic personalization functionality:

Section 10.1.1.1, "USER_PROFILE Database Table"
Section 10.1.1.2, "ENTITY Database Table"
Section 10.1.1.3, "PROPERTY_KEY Database Table"
Section 10.1.1.4, "PROPERTY_VALUE Database Table"
Section 10.1.1.5, "SEQUENCER Database Table"
Section 10.1.1.6, "USERS Database Table"
Section 10.1.1.7, "GROUPS Database Table"
Section 10.1.1.8, "GROUPMEMBERS Database Table"
Section 10.1.1.9, "P13N_QUIESCENT_STATE Database Table"
Section 10.1.1.10, "P13N_LEASE Database Table"
Section 10.1.2.1, "P13N_ANONYMOUS_PROPERTY Database Table"
Section 10.1.2.2, "P13N_ANONYMOUS_USER Database Table"
Section 10.1.1.11, "Credential Service Dictionary Tables"
Section 10.1.1.16, "Job Scheduler Dictionary Tables"
Section 10.1.1.22, "Entitlement Reference Dictionary Tables"
Section 10.1.3, "Behavior Tracking Database Tables"
Section 10.1.4, "Data Synchronization Database Tables"

10.1.1.1 USER_PROFILE Database Table

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.

10.1.1.2 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.

10.1.1.3 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.

10.1.1.4 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.

10.1.1.5 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.

10.1.1.6 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

10.1.1.7 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

10.1.1.8 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

10.1.1.9 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

10.1.1.10 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

10.1.1.11 Credential Service Dictionary Tables

For an entity relation diagram of the Personalization Credential Service tables, see Figure B-2, "Personalization Credential Service Database Tables".

The Credential tables include the following:

Section 10.1.1.12, "P13N_CREDENTIAL Database Table"
Section 10.1.1.13, "P13N_CREDENTIAL_APPLICATION Database Table"
Section 10.1.1.14, "P13N_CREDENTIAL_MASTER Database Table"
Section 10.1.1.15, "P13N_CREDENTIAL_METADATA Database Table"

10.1.1.12 P13N_CREDENTIAL Database Table

This table was added in WebLogic Portal 10.2. The table stores credential user name and password information for accessing external system resources.

Table 10-11 P13N_CREDENTIAL Table Metadata

Column Name	Data Type	Null Value	Description	New or Changed Version
CREDENTIAL_ID	INTEGER	Not Null	A unique system-generated number to use as the record identifier.	10.2
CREDENTIAL_MASTER_ID	INTEGER	Not Null	FK – A Foreign Key to P13N_CREDENTIAL_MASTER	10.2
USER_NAME	VARCHAR(200)	Not Null	The name of the user.	10.2
CREATION_DATE	DATETIME	Not Null	Date and time the row was created.	10.2
MODIFIED_DATE	DATETIME	Not Null	Date and time the row was last modified.	10.2
CREDENTIAL_PRINCIPAL	BLOB(5M)	Null	Encrypted login information for the external credentialed system.	10.2
CREDENTIAL_PASSWORD	BLOB(5M)	Null	Encrypted password for the external credentialed system.	10.2

10.1.1.13 P13N_CREDENTIAL_APPLICATION Database Table

This table was added in WebLogic Portal 10.2. The table is used to identify the enterprise and web application associated with a credentialed system.

Table 10-12 P13N_CREDENTIAL_APPLICATION Table Metadata

Column Name	Data Type	Null Value	Description	New or Changed Version
CREDENTIAL_APPLICATION_ID	INTEGER	Not Null	A unique system-generated number to use as the record identifier.	10.2
ENTAPP_NAME	VARCHAR(255)	Null	The name of a credentialed enterprise application.	10.2
WEBAPP_NAME	VARCHAR(255)	Null	The name of a credentialed web application.	10.2

10.1.1.14 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

10.1.1.15 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.

Table 10-14 P13N_CREDENTIAL_METADATA Table Metadata

Column Name	Data Type	Null Value	Description	New or Changed Version
CREDENTIAL_ID	INTEGER	Not Null	A unique system-generated number to use as the record identifier. PK/FK – A Foreign Key to P13N_ CREDENTIAL	10.2
METADATA_NAME	VARCHAR(512)	Not Null	PK - A name identifying the meta data value. For example: SAP URL.	10.2
CREATION_DATE	DATETIME	Not Null	Date and time the row was created.	10.2
MODIFIED_DATE	DATETIME	Not Null	Date and time the row was last modified.	10.2
TEXT_VALUE	VARCHAR(512)	Not Null	The actual value of the metadata.	10.2

10.1.1.16 Job Scheduler Dictionary Tables

For an entity relation diagram of the Personalization Job Scheduler tables, see Figure B-3, "Personalization Job Scheduler Database Tables".

The Job Scheduler tables include the following:

Section 10.1.1.17, "P13N_JOB_DEFINITION Database Table"
Section 10.1.1.18, "P13N_JOB_LISTENER Database Table"
Section 10.1.1.19, "P13N_JOB_PARAMETER Database Table"
Section 10.1.1.20, "P13N_JOB_RUN_HEADER Database Table"
Section 10.1.1.21, "P13N_JOB_RUN_DATA Database Table"

10.1.1.17 P13N_JOB_DEFINITION 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. 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

10.1.1.18 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

10.1.1.19 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

10.1.1.20 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

10.1.1.21 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

10.1.1.22 Entitlement Reference Dictionary Tables

For an entity relation diagram of the Entitlement database tables, see Figure B-4, "Entitlement Database Tables".

The following tables are used by the Administration Console to maintain security policy reference data as policies are created, edited, and deleted. These tables allow efficient searching for policies given a role name, resource ID web application name, and so on.

The Entitlement tables include the following:

Section 10.1.1.23, "P13N_ENTITLEMENT_APPLICATION Database Table"
Section 10.1.1.24, "P13N_ENTITLEMENT_POLICY Database Table"
Section 10.1.1.25, "P13N_ENTITLEMENT_RESOURCE Database Table"
Section 10.1.1.26, "P13N_ENTITLEMENT_ROLE Database Table"
Section 10.1.1.27, "P13N_DELEGATED_HIERARCHY Database Table"

10.1.1.23 P13N_ENTITLEMENT_APPLICATION Database Table

This table uniquely identifies an application for which entitlements can be applied.

Table 10-20 P13N_ENTITLEMENT_APPLICATION Table Metadata

Column Name	Data Type	Null Value	Description
ENTITLEMENT_APP_ID	NUMBER(15)	Not Null	PK – A unique, system-generated number to use as the record ID.
ENTAPP_NAME	VARCHAR(255)	Not Null	The name of the enterprise application.
WEBAPP_NAME	VARCHAR(255)	Null	The name of the web application.
ENTITLEMENT_APP_ DESCRIPTION	VARCHAR(255)	Null	The description of the enterprise application.
CREATION_DATE	DATE	Not Null	The date and time the record was created; the default is the current time stamp.
MODIFIED_DATE	DATE	Not Null	The date and time the record was last modified; the default is the current time stamp.

10.1.1.24 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.

Table 10-21 P13N_ENTITLEMENT_POLICY Table Metadata

Column Name	Data Type	Null Value	Description	New or Changed Version
RESOURCE_ENT_APP_ID	NUMBER(15)	Not Null	PK and FK to `P13N_ENTITLEMENT_APPLICATION`.
RESOURCE_ID	NUMBER(15)	Not Null	PK and FK to `P13N_ENTITLEMENT_RESOURCE`.
ROLE_ENT_APP_ID	NUMBER(15)	Not Null	PK and FK to `P13N_ENTITLEMENT_APPLICATION`.
ROLE_ID	NUMBER(15)	Not Null	PK and FK to `P13N_ENTITLEMENT_ROLE`.
POLICY_RESOURCE_ CAPABILITY	VARCHAR(80)	Not Null	PK – Identifies the unique capability of this policy instance.
CREATION_DATE	DATE	Not Null	The date and time the record was created; the default is the current time stamp.
MODIFIED_DATE	DATE	Not Null	The date and time the record was last modified; default value is the current time stamp.
ROLE_PROVIDER_NAME	VARCHAR(80)	Not Null	The name given the deployed Role Mapping provider holding the role definition.
ATZ_PROVIDER_NAME	VARCHAR(80)	Not Null	The name of the authorization provider.	9.2

10.1.1.25 P13N_ENTITLEMENT_RESOURCE Database Table

This table uniquely identifies an application resource that can have an entitlement associated with it.

Table 10-22 P13N_ENTITLEMENT_RESOURCE Table Metadata

Column Name	Data Type	Null Value	Description	New or Changed Version
ENTITLEMENT_APP_ID	NUMBER(15)	Not Null	PK and FK to `P13N_ENTITLEMENT_APPLICATION`.
RESOURCE_ID	NUMBER(15)	Not Null	PK – A unique, system-generated number to use as the record ID.
RESOURCE_NAME	VARCHAR(882)	Not Null	The name of the resource having a policy applied on it.	9.2
RESOURCE_DESCRIPTION	VARCHAR(255)	Null	Optional description of resource.
RESOURCE_METADATA	VARCHAR(255)	Null	Optional application-defined metadata.
CREATION_DATE	DATE	Not Null	The date and time the record was last modified; the default is the current time stamp.
MODIFIED_DATE	DATE	Not Null	The date and time the record was last modified; the default is the current time stamp.

10.1.1.26 P13N_ENTITLEMENT_ROLE Database Table

This table uniquely identifies entitlement and delegated administration roles for a given application.

Table 10-23 P13N_ENTITLEMENT_ROLE Table Metadata

Column Name	Data Type	Null Value	Description	New or Changed Version
ENTITLEMENT_APP_ID	NUMBER(15)	Not Null	PK and FK to `P13N_ENTITLEMENT_APPLICATION`.
ROLE_ID	NUMBER(15)	Not Null	PK – A unique, system-generated number to use as the record ID.
ROLE_NAME	VARCHAR(255)	Not Null	The name of the security role.
ROLE_DESCRIPTION	VARCHAR(255)	Null	Optional description of the role.
ROLE_SEGMENT	VARCHAR(255)	Null	Optional role expression name.
CREATION_DATE	DATE	Not Null	The date and time the record was last modified; the default is the current time stamp.
MODIFIED_DATE	DATE	Not Null	The date and time the record was last modified; the default is the current time stamp.
ROLE_PROVIDER_NAME	VARCHAR(80)	Not Null	Identifies the policy role mapper provider; default value = DefaultRoleMapper	9.2

10.1.1.27 P13N_DELEGATED_HIERARCHY Database Table

This table uniquely identifies an entitlement hierarchy. An entitlement hierarchy is associated with P13N_ENTITLEMENT_APPLICATION.

Table 10-24 P13N_DELEGATED_HIERARCHY Table Metadata

Column Name	Data Type	Null Value	Description
ENTITLEMENT_APP_ID	NUMBER(15)	Not Null	PK and FK to `P13N_ENTITLEMENT_APPLICATION`.
ENTITLEMENT_DOCUMENT	CLOB	Not Null	An XML document containing the Delegated Administration role hierarchy.
CREATION_DATE	DATE	Not Null	The date and time the record was last modified; the default is the current time stamp.
MODIFIED_DATE	DATE	Not Null	The date and time the record was last modified; the default is the current time stamp.

10.1.2 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 Oracle Fusion Middleware User Management Guide for Oracle WebLogic Portal.

The following tables support tracking of anonymous users:

Section 10.1.2.1, "P13N_ANONYMOUS_PROPERTY Database Table"
Section 10.1.2.2, "P13N_ANONYMOUS_USER Database Table"

10.1.2.1 P13N_ANONYMOUS_PROPERTY Database Table

This table stores the properties associated with the tracked anonymous user.

Table 10-25 P13N_ANONYMOUS_PROPERTY Table Metadata

Column Name	Data Type	Null Value	Description
ANONYMOUS_PROPERTY_ID	VARCHAR(128)	Not Null	PK – A unique, system-generated number to use as the record ID.
CREATION_DATE	DATE	Not Null	The date and time the row was created.
MODIFIED_DATE	DATE	Not Null	The date and time the row was last modified. This column's data is maintained using a database trigger.
PROPERTY_SET_NAME	VARCHAR(100)	Not Null	The name of the property set for which the tracked anonymous user data is set.
PROPERTY_NAME	VARCHAR(100)	Not Null	The name of the property being tracked for the anonymous user.
ANONYMOUS_USER_ID	VARCHAR(128)	Not Null	FK - A foreign key to P13N_ANONYMOUS_USER.
PROPERTY_VALUE	BLOB	Not Null	The value of the property that must implement `java.io.Serializable`.

10.1.2.2 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.

10.1.3 Behavior Tracking Database Tables

For an entity relation diagram of the Behavior Tracking tables, see Figure B-5, "Behavior Tracking Database Tables".

Each DBMS-specific chapter of this guide describes how to set up a separate behavior tracking database. Three tables are provided for behavior tracking data. The BT_EVENT table stores all event data. The BT_EVENT_ACTION table logs actions used by third-party vendors against the recorded event data, and the BT_EVENT_TYPE table references event types and categories in the EVENT table.

For more information about behavior tracking, refer to the Oracle Fusion Middleware Interaction Management Guide for Oracle WebLogic Portal.

Section 10.1.3.1, "BT_EVENT_TYPE Database Table"
Section 10.1.3.2, "BT_EVENT Database Table"
Section 10.1.3.3, "BT_EVENT_ACTION Database Table"

10.1.3.1 BT_EVENT_TYPE Database 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.

10.1.3.2 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-42.
USER_ID	VARCHAR(50)	Null	The user ID associated with the session and event. If the user has not logged in this column is null.
ANONYMOUS_USER_ ID	VARCHAR(128)	Null	The user ID of the anonymous user associated with the session and event, if applicable.

As shown in Table 10-42, the BT_EVENT table has eight columns; each column corresponds to a specific event element. Seven of the BT_EVENT table's columns contain data common to every event type. The XML_DEFINITION column contains information about the application, event-date, event-type, session-id, and user-id, plus event data that is unique to each event type. An XML document is created specifically for each event type. The data elements corresponding to each event type are captured in the XML_DEFINITION column of the EVENT table. These elements are listed in Table 10-42.

Table 10-29 XML_DEFINITION Data Elements

Event	Data Element
AddToCartEvent	application event-date event-type session-id user-id sku quantity unit-list-price currency application-name
BuyEvent	application event-date event-type session-id user-id sku quantity unit-price currency application-name order-line-id
CampaignUserActivityEvent	application event-date event-type session-id user-id campaign-id scenario-id
ClickCampaignEvent	application event-date event-type session-id user-id document-type document-id campaign-id scenario-id application-name placeholder-id
ClickContentEvent	application event-date event-type session-id user-id document-type document-id
ClickProductEvent	application event-date event-type session-id user-id document-type document-id sku category-id application-name
DisplayCampaignEvent	application event-date event-type session-id user-id document-type document-id campaign-id scenario-id application-name placeholder-id
DisplayContentEvent	application event-date event-type session-id user-id document-type document-id
DisplayProductEvent	application event-date event-type session-id user-id document-type document-id sku category-id application-name
PurchaseCartEvent	application event-date event-type session-id user-id total-price order-id currency application-name
RemoveFromCartEvent	application event-date event-type session-id user-id sku quantity unit-price currency application-name
RuleEvent	application event-date event-type session-id user-id ruleset-name rule-name
SessionBeginEvent	application event-date event-type session-id user-id
SessionEndEvent	application event-date event-type session-id user-id
SessionLoginEvent	application event-date event-type session-id user-id
UserRegistrationEvent	application event-date event-type session-id user-id

10.1.3.3 BT_EVENT_ACTION Database Table

This table logs actions used by third-party vendors against the recorded event data.

Table 10-30 BT_EVENT_ACTION Table Metadata

Column Name	Data Type	Null Value	Description
EVENT_ACTION	VARCHAR(30)	Not Null	The event action taken such as `BEGIN EXPORT` or `END EXPORT`. This field is one of the table's primary keys.
ACTION_DATE	DATE	Not Null	The date and time of the event. This field is one of the table's primary keys.
EVENT_ID	NUMBER	Null	The `ID` of the event that corresponds with the event action taken.

10.1.4 Data Synchronization Database Tables

For an entity relation diagram of the Data Synchronization tables, see Figure B-6, "Data Synchronization Database Tables".

In this section, WebLogic Portal data synchronization objects tables are arranged alphabetically as a data dictionary.

The following tables compose the data synchronization database:

Section 10.1.4.1, "DATA_SYNC_APPLICATION Database Table"
Section 10.1.4.2, "DATA_SYNC_ITEM Database Table"
Section 10.1.4.3, "DATA_SYNC_SCHEMA_URI Database Table"
Section 10.1.4.4, "DATA_SYNC_VERSION Database Table"

10.1.4.1 DATA_SYNC_APPLICATION Database Table

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.

10.1.4.2 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.

10.1.4.3 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.

10.1.4.4 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.

10.2 Portal Services Database Objects

Portal Services database objects are used for placeholders, ads, and ad bucket services.

For an entity relation diagram of the Portal Services database tables, see Figure B-7, "Portal Services Database Tables".

The following tables compose the Portal Services database:

Section 10.2.1, "AD_BUCKET Database Table"
Section 10.2.2, "AD_COUNT Database Table"
Section 10.2.3, "PLACEHOLDER_PREVIEW Database Table"
Section 10.2.4, "MAIL_ADDRESS Database Table"
Section 10.2.5, "MAIL_BATCH Database Table"
Section 10.2.6, "MAIL_BATCH_ENTRY Database Table"
Section 10.2.7, "MAIL_HEADER Database Table"
Section 10.2.8, "MAIL_MESSAGE Database Table"
Section 10.2.9, "SCENARIO_END_STATE Database Table"

10.2.1 AD_BUCKET Database Table

This table maintains content queries for ads.

Table 10-35 AD_BUCKET Table Metadata

Column Name	Data Type	Null Value	Description
AD_BUCKET_ID	NUMERIC(15)	Not Null	PK – A unique, system-generated number used as the record identifier.
USER_NAME	VARCHAR (200)	Not Null	The user's name associated with the ad.
PLACEHOLDER_XML_REF	VARCHAR(254)	Not Null	The location identifier of the XML-based placeholder definition file.
APPLICATION_NAME	VARCHAR(100)	Not Null	The name of the application for which the ad has been scoped.
CONTEXT_REF	VARCHAR(254)	Null	The scenario-unique identifier.
CONTAINER_REF	VARCHAR(254)	Null	The campaign-unique identifier.
CONTAINER_TYPE	VARCHAR(50)	Null	Identifies the service associated with the `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.

10.2.2 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.

10.2.3 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.

10.2.4 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`.

10.2.5 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.

10.2.6 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.

10.2.7 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.

10.2.8 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.

10.2.9 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.

10.3 Portal Framework Database Objects

The Portal Framework is the portion of WebLogic Portal that is responsible for the rendering and customization of the portal.

For an entity relation diagram of the Portal Framework database tables, see Figure B-8, "Portal Framework Database Tables". This includes tables that support WSRP and localization.

10.3.1 Portal Framework Database Tables

In this section, tables are arranged alphabetically as a data dictionary. The following tables compose the generic Portal Framework database:

Section 10.3.1.1, "PF_BOOK_DEFINITION Database Table"
Section 10.3.1.2, "PF_BOOK_GROUP Database Table"
Section 10.3.1.3, "PF_BOOK_INSTANCE Database Table"
Section 10.3.1.4, "PF_DESKTOP_DEFINITION Database Table"
Section 10.3.1.5, "PF_DESKTOP_INSTANCE Database Table"
Section 10.3.1.6, "PF_LAYOUT_DEFINITION Database Table"
Section 10.3.1.7, "PF_LOOK_AND_FEEL_DEFINITION Database Table"
Section 10.3.1.8, "PF_MARKUP_DEFINITION Database Table"
Section 10.3.1.9, "PF_MARKUP_XML Database Table"
Section 10.3.1.11, "PF_PAGE_DEFINITION Database Table"
Section 10.3.1.12, "PF_PAGE_INSTANCE Database Table"
Section 10.3.1.13, "PF_PLACEHOLDER_DEFINITION Database Table"
Section 10.3.1.14, "PF_PLACEMENT Database Table"
Section 10.3.1.15, "PF_PORTAL Database Table"
Section 10.3.1.16, "PF_PORTLET_CATEGORY Database Table"
Section 10.3.1.17, "PF_PORTLET_CATEGORY_DEFINITION Database Table"
Section 10.3.1.18, "PF_PORTLET_DEFINITION Database Table"
Section 10.3.1.19, "PF_PORTLET_INSTANCE Database Table"
Section 10.3.1.20, "PF_PORTLET_PREFERENCE Database Table"
Section 10.3.1.21, "PF_PORTLET_PREFERENCE_VALUE Database Table"
Section 10.3.1.22, "PF_PORTLET_USER_PROPERTIES Database Table"
Section 10.3.1.23, "PF_SHELL_DEFINITION Database Table"
Section 10.3.1.24, "PF_SHELL_PLACEMENT Database Table"
Section 10.3.1.25, "PF_THEME_DEFINITION Database Table"
Section 10.3.1.26, "PF_URL_COMPRESSION Database Table"

To view the communities-related portal framework tables, see Section 10.5, "Communities Framework Database Objects." To view the tables related to localization, refer to Section 10.3.2, "Localization Dictionary Tables."

10.3.1.1 PF_BOOK_DEFINITION Database Table

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 Oracle Enterprise Pack for Eclipse. 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.

10.3.1.2 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.

10.3.1.3 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`.

10.3.1.4 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

10.3.1.5 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.`

10.3.1.6 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 display in the Administration Console or Visitor Tools.	10.0

10.3.1.7 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.

Table 10-50 PF_LOOK_AND_FEEL_DEFINITION Table Metadata

Column Name	Data Type	Null Value	Description	New or Changed Version
LOOK_FEEL_ DEFINITION_ID	NUMBER	Not Null	PK – A unique, system-generated number to use as the record ID.
LOOK_FEEL_LABEL	VARCHAR(80)	Not Null	A moniker used to reference this portal resource for development purposes.
CREATION_DATE	DATE	Not Null	The date and time the row was created.
MODIFIED_DATE	DATE	Not Null	The date and time the row was last modified. This column's data is maintained using a database trigger.
INTERSECTION_ID	NUMBER	Not Null	FK to L10N_INTERSECTION.
MARKUP_DEFINITION_ID	NUMBER	Not Null	FK to PF_MARKUP_DEFINITION.
WEBAPP_NAME	VARCHAR(80)	Not Null	Name of the J2EE web application to which the portal resource is scoped.
IS_LOOK_FEEL_FILE_ DELETED	NUMBER	Not Null	A boolean indicating that the file associated with this look and feel was removed from the file system. If the look and feel is not being used, then the record is deleted outright. This flag is set to true only when the `.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

10.3.1.8 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.

10.3.1.9 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

10.3.1.10 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

10.3.1.11 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.

10.3.1.12 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.

10.3.1.13 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.

Table 10-56 PF_PLACEHOLDER_DEFINITION Table Metadata

Column Name	Data Type	Null Value	Description
PLACEHOLDER_DEFINITION_ID	NUMBER	Not Null	PK – A unique, system-generated number to use as the record ID.
MARKUP_DEFINITION_ID	NUMBER	Not Null	FK to `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`.

10.3.1.14 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.

10.3.1.15 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.

10.3.1.16 PF_PORTLET_CATEGORY Database Table

This table associates a PORTLET CATEGORY resource with a PORTLET DEFINITION.

Table 10-59 PF_PORTLET_CATEGORY Table Metadata

Column Name	Data Type	Null Value	Description
PORTLET_DEFINITION_ID	NUMBER	Not Null	PK – A unique, system-generated number to use as the record ID.
PORTLET_CATEGORY_ DEFINITION_ID	NUMBER	Not Null	FK to `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.

10.3.1.17 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.

Table 10-60 PF_PORTLET_CATEGORY_DEFINITION Table Metadata

Column Name	Data Type	Null Value	Description
PORTLET_CATEGORY_ DEFINITION_ID	NUMBER	Not Null	PK – A unique, system-generated number to use as the record ID.
CREATION_DATE	DATE	Not Null	The date and time the row was created.
MODIFIED_DATE	DATE	Not Null	The date and time the row was last modified. This column's data is maintained using a database trigger.
INTERSECTION_ID	NUMBER	Not Null	FK to `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.

10.3.1.18 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.

10.3.1.19 PF_PORTLET_INSTANCE Database Table

This table identifies a customized or localized instance of a portlet.

Note:

To view the WSRP tables that are a subset of the PF_PORTLET_INSTANCE table, see Section 10.4, "WSRP Portal Framework Database Objects."

Table 10-62 PF_PORTLET_INSTANCE Table Metadata

Column Name	Data Type	Null Value	Description	New or Changed Version
PORTLET_INSTANCE_ID	NUMBER	Not Null	PK – A unique, system-generated number to use as the record ID.
PORTLET_DEFINITION_ID	NUMBER	Not Null	FK to `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

10.3.1.20 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.

10.3.1.21 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.

Table 10-64 PF_PORTLET_PREFERENCE_VALUE Table Metadata

Column Name	Data Type	Null Value	Description
PORTLET_PREFERENCE_ VALUE_ID	NUMBER	Not Null	PK – A unique, system-generated number to use as the record ID.
PORTLET_INSTANCE_ID	NUMBER	Not Null	FK to `PF_PORTLET_PREFERENCE`.
PREFERENCE_NAME	VARCHAR(80)	Not Null	FK to `PF_PORTLET_PREFERENCE`.
CREATION_DATE	DATE	Not Null	The date and time the row was created.
MODIFIED_DATE	DATE	Not Null	The date and time the row was last modified. This column's data is maintained using a database trigger.
PREFERENCE_VALUE	VARCHAR(255)	Null	The actual value for this preference.

10.3.1.22 PF_PORTLET_USER_PROPERTIES Database Table

This table maintains values of portlet user properties for WSRP user profile propagation.

This table was added in WebLogic Portal 9.2.

Table 10-65 PF_PORTLET_USER_PROPERTIES Table Metadata

Column Name	Data Type	Null Value	Description
USER_PROPERTY_ID	NUMBER	Not Null	PK – A unique, system-generated number to use as the property ID.
PORTLET_DEFINITION_ID	NUMBER	Not Null	PK – A unique, system-generated number to use as the portlet definition ID.
PROPERTY_STRING	VARCHAR(255)	Not Null	String value.

10.3.1.23 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

10.3.1.24 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

10.3.1.25 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

10.3.1.26 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

10.3.2 Localization Dictionary Tables

This section documents the database objects for the WebLogic Portal framework. The following tables support localization:

Section 10.3.2.1, "L10N_INTERSECTION Database Table"
Section 10.3.2.2, "L10N_LOCALE Database Table"
Section 10.3.2.3, "L10N_RESOURCE Database Table"
Section 10.3.2.4, "L10N_RESOURCE_TYPE Database Table"

10.3.2.1 L10N_INTERSECTION Database Table

This table ties an application resource (menu, portlet, and so on) to a localized title and description.

Table 10-70 L10N_INTERSECTION Table Metadata

Column Name	Data Type	Null Value	Description
INTERSECTION_ID	NUMBER	Not Null	PK – A unique, system-generated number to use as the record ID.
CREATION_DATE	DATE	Not Null	The date and time the row was created.
MODIFIED_DATE	DATE	Not Null	The date and time the row was last modified. This column's data is maintained using a database trigger.
RESOURCE_TYPE	VARCHAR(80)	Not Null	FK to `L10N_RESOURCE_TYPE.`

10.3.2.2 L10N_LOCALE Database Table

This table defines the characteristics of a locale that are needed to localize an application.

Table 10-71 L10N_LOCALE Table Metadata

Column Name	Data Type	Null Value	Description
LOCALE_ID	NUMBER	Not Null	PK – A unique, system-generated number to use as the record ID.
CREATION_DATE	DATE	Not Null	The date and time the row was created.
MODIFIED_DATE	DATE	Not Null	The date and time the row was last modified. This column's data is maintained using a database trigger.
ENCODING	VARCHAR(20)	Not Null	The encoding that is used by the locale. The default encoding is UTF-8.
LANGUAGE	CHAR(2)	Not Null	Lowercase two-letter ISO-639 language code that is used by the locale; for example, en, au.
COUNTRY	CHAR(2)	Null	Uppercase two-letter ISO-3166 country code that is used by the locale; for example, US, UK.
VARIANT	VARCHAR(40)	Null	Vendor- and browser-specific code variant code that is used by the locale; for example, WIN, MAC, UNIX.

10.3.2.3 L10N_RESOURCE Database Table

This table defines the localized title and description of a localized resource.

Table 10-72 L10N_RESOURCE Table Metadata

Column Name	Data Type	Null Value	Description	New or Changed Version
LOCALE_ID	NUMBER	Not Null	PK and FK to `L10N_LOCALE.`
INTERSECTION_ID	NUMBER	Not Null	PK and FK to `L10N_INTERSECTION.`
CREATION_DATE	DATE	Not Null	The date and time the row was created.
MODIFIED_DATE	DATE	Not Null	The date and time the row was last modified. This column's data is maintained using a database trigger.
TITLE	VARCHAR(80)	Not Null	A localized title for the object, typically used for display purposes; for example, the name of the portal or portlet.
DESCRIPTION	VARCHAR(500)	Null	A localized description of the object.
TITLE_CK	VARCHAR(160)	Null	Collation key column for the title; an ASCII-sortable string that will sort correctly in the given language.	9.2
DESCRIPTION_CK	VARCHAR(1000)	Null	Collation key column for the description; an ASCII-sortable string that will sort correctly in the given language.	9.2

10.3.2.4 L10N_RESOURCE_TYPE Database Table

This table defines portal resource types for localization.

Table 10-73 L10N_RESOURCE _TYPE Table Metadata

Column Name	Data Type	Null Value	Description
RESOURCE_TYPE	VARCHAR(80)	Not Null	PK – Type of resource to be localized; for example, `BOOK,` `DESKTOP,` `DESKTOP CATEGORY`.
CREATION_DATE	DATE	Not Null	The date and time the row was created.
MODIFIED_DATE	DATE	Not Null	The date and time the row was last modified. This column's data is maintained using a database trigger.
APPLICATION_NAME	VARCHAR(100)	Not Null	The name of the application to which the resource belongs. `APPLICATION_` `NAME` is currently set to `PORTAL` for all types of resources to be localized.

10.4 WSRP Portal Framework Database Objects

For an entity relation diagram of the WSRP Portal Framework tables, see Figure B-9, "WSRP Portal Framework Tables".

The following WSRP-related tables are a subset of the PF_PORTLET_INSTANCE database table:

Section 10.4.1, "PF_CONSUMER_PORTLETS Database Table"
Section 10.4.2, "PF_CONSUMER_PROPERTIES Database Table"
Section 10.4.3, "PF_CONSUMER_REGISTRY Database Table"
Section 10.4.4, "PF_PRODUCER_REGISTRY Database Table"
Section 10.3.1.19, "PF_PORTLET_INSTANCE Database Table"
Section 10.4.6, "PF_PROXY_BOOK Database Table"
Section 10.4.7, "PF_PROXY_PAGE Database Table"

10.4.1 PF_CONSUMER_PORTLETS Database Table

The PF_CONSUMER_PORTLETS table associates consumer IDs and portlet instance IDs so that when a consumer unregisters from a producer, the producer can clean up any portlets that it created for the consumer.

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`.

10.4.2 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

10.4.3 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

10.4.4 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.

10.4.5 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.

Table 10-78 PF_PROXY_PORTLET_INSTANCE Database Table

Column Name	Data Type	Null Value	Description
PROXY_PORTLET_ INSTANCE_ID	INTEGER	Not Null	PK – A unique system-generated number to use as the record ID.
PRODUCER_ID	INTEGER	Not Null	FK to `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).

10.4.6 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

10.4.7 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

10.5 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.

For an entity relation diagram of the Communities Portal Framework database tables, see Figure B-10, "Communities Portal Framework Database Tables".

10.5.1 Communities Portal Framework Data Dictionary Tables

The Communities Portal Framework system has the following tables:

Section 10.5.1.1, "PF_COMMUNITY_DEFINITION Database Table"
Section 10.5.1.2, "PF_COMMUNITY_MEMBER Database Table"
Section 10.5.1.3, "PF_COMMUNITY_MEMBERSHIP Database Table"
Section 10.5.1.5, "PF_COMMUNITY_PROPERTY Database Table"
Section 10.5.1.6, "PF_COMMUNITY_PROPERTY_VALUE Database Table"
Section 10.5.1.7, "PF_FILE_TEMPLATE Database Table"
Section 10.5.1.8, "PF_INVITATION Database Table"
Section 10.5.1.9, "PF_INVITEE Database Table"
Section 10.5.1.10, "PF_INVITEE_PROPERTY Database Table"
Section 10.5.1.11, "PF_MESSAGING_ADDR Database Table"
Section 10.5.1.12, "PF_NOTIFICATION Database Table"
Section 10.5.1.13, "PF_NOTIFICATION_PAYLOAD Database Table"

10.5.1.1 PF_COMMUNITY_DEFINITION Database Table

The PF_COMMUNITY_DEFINITION table contains community definition data.

Table 10-81 PF_COMMUNITY_DEFINITION Database Table

Column Name	Data Type	Null Value	Description	New or Changed Version
COMMUNITY_DEFINITION_ID	NUMBER	Not Null	PK – A unique, system-generated number to use as the community definition ID.	9.2
INTERSECTION_ID	NUMBER	Not Null	FK to L10N_RESOURCE for the localization resource.	9.2
DESKTOP_PATH	VARCHAR(40)	Not Null	FK to PF_DESKTOP_ DEFINITION.	9.2
PORTAL_PATH	VARCHAR(40)	Not Null	FK to PF_DESKTOP_ DEFINITION.	9.2
WEBAPP_NAME	VARCHAR(80)	Not Null	FK to PF_DESKTOP_ DEFINITION. Name of the web application that hosts the desktop.	9.2
TIMEZONE	VARCHAR(80)	Not Null	Display TimeZone identifier. This can be used by Communities applications to format dates and times in a time zone specific to a community instance.	9.2
IS_ACTIVE	NUMBER	Not Null	Indicates whether the community is active; default = 0 (inactive).	9.2
IS_PUBLIC	NUMBER	Not Null	Indicates whether the community is public; default = 0 (not public).	9.2
IS_TEMPLATE	NUMBER	Not Null	Indicates whether the community is a template; default = 0 (not a template).	9.2
IS_ACCESS_TRACKING_ ENABLED	NUMBER	Not Null	Indicates whether the community has access tracking enabled; default = 0 (not enabled).	9.2
IS_PERSONAL_PAGES_ ENABLED	NUMBER	Not Null	Indicates whether the community has personal pages enabled; default = 0 (not enabled).	9.2
IS_SELF_REG_ENABLED	NUMBER	Not Null	Indicates whether self-registration is enabled; default = 0 (not enabled).	9.2
IS_GLOBAL	NUMBER	Not Null	Indicates whether the community is global; default = 0 (not global).	9.2
CREATION_DATE	TIMESTAMP	Not Null	The date and time the row was created.	9.2
MODIFIED_DATE	TIMESTAMP	Not Null	The date and time the row was modified. This column's data is maintained using a database trigger.	9.2
EXPIRATION_DATE	TIMESTAMP	Not Null	The date and time this community will expire.	9.2
PARENT_COMMUNITY_ DEFINITION_ID	NUMBER	Null	FK - References parent community.	9.2
CALLBACK_CLASS_NAME	VARCHAR(255)	Null	The class name for the CommunityCallback implementation that is configured for this community, if one exists.	9.2
PRIMARY_MESSAGING_ADDR	VARCHAR(80)	Null	The MessagingAddress name that identifies the default MessagingAddressType that is configured for use with this community. If this is null, the default MessagingAddressType for all community operations will be the type configured in `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

10.5.1.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

10.5.1.3 PF_COMMUNITY_MEMBERSHIP Database Table

The PF_COMMUNITY_MEMBERSHIP table contains information regarding the membership status of community members.

Table 10-83 PF_COMMUNITY_MEMBERSHIP Database Table

Column Name	Data Type	Null Value	Description	New or Changed Version
COMMUNITY_MEMBERSHIP_ID	NUMBER	Not Null	PK – A unique, system-generated number to use as the community membership ID.	9.2
COMMUNITY_DEFINITION_ID	INTEGER	Not Null	FK - A foreign key to PF_COMMUNITY_DEFINITION.	9.2
COMMUNITY_MEMBER_ID	INTEGER	Not Null	FK - A foreign key to PF_COMMUNITY_MEMBER.	9.2
MEMBERSHIP_STATUS	NUMBER	Not Null	Setting to determine membership status. Values are: 1 = active, 0 = Disabled	9.2
CREATION_DATE	TIMESTAMP	Not Null	The date and time the row was created.	9.2
MODIFIED_DATE	TIMESTAMP	Not Null	The date and time the row was modified. This column's data is maintained using a database trigger.	9.2
LAST_ACCESS_DATE	TIMESTAMP	Null	If access tracking is enabled, this field contains a timestamp that is updated at each login event by the user associated with this CommunityMembership to the linked Community desktop.	9.2

10.5.1.4 PF_MEMBERSHIP_CAPABILITY Database Table

The PF_MEMBERSHIP_CAPABILITY table contains information about the capabilities of a member within the community.

Table 10-84 PF_COMMUNITY_MEMBERSHIP Database Table

Column Name	Data Type	Null Value	Description	New or Changed Version
COMMUNITY_MEMBERSHIP_ID	INTEGER	Not Null	PK/FK to COMMUNITY_MEMBERSHIP.	9.2
CAPABILITY	VARCHAR(80)	Not Null	PK - Text label applied to the community member. The only default security functionality with capabilities is that a community "creator" can delete a community and a community "owner" can manage a community.	9.2

10.5.1.5 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

10.5.1.6 PF_COMMUNITY_PROPERTY_VALUE Database Table

The PF_COMMUNITY_PROPERTY_VALUE table contains information regarding the actual value of the custom community property.

Table 10-86 PF_COMMUNITY_PROPERTY_VALUE Database Table

Column Name	Data Type	Null Value	Description	New or Changed Version
COMMUNITY_PROPERTY_ VALUE_ID	INTEGER	Not Null	PK – A system-generated unique number to use as the community property value ID.	9.2
COMMUNITY_DEFINITION_ID	INTEGER	Not Null	A foreign key to PF_COMMUNITY_PROPERTY.	9.2
PROPERTY_NAME	VARCHAR(100)	Not Null	A foreign key to PF_COMMUNITY_PROPERTY.	9.2
CREATION_DATE	TIMESTAMP	Not Null	The date and time the row was created.	9.2
MODIFIED_DATE	TIMESTAMP	Not Null	The date and time the row was modified. This column's data is maintained using a database trigger.	9.2
PROPERTY_VALUE	VARCHAR(400)	Null	The value associated with the property name.	9.2

10.5.1.7 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

10.5.1.8 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

10.5.1.9 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.	9.2
INVITATION_STATUS	NUMBER	Not Null	The status of the invitation. Values are: 10 - Sent (default) 20 -Accepted 30 - Rejected 40 - Revoked 50 - Expired	9.2
MODIFIED_DATE	TIMESTAMP	Not Null	Date the status was updated.	9.2
USER_NAME	VARCHAR(200)	Null	The WebLogic Server user name if the invitation is for an existing user, but can be null when inviting external invitees who do not yet have a WebLogic Server user name.	9.2
INVITATION_VALIDATION_ TEXT	VARCHAR(400)	Null	Validation text that is sent as part of the notification, which must then be provided by the invitee when accepting or declining an invitation. The format of this text is developer- definable.	9.2

10.5.1.10 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

10.5.1.11 PF_MESSAGING_ADDR Database Table

The PF_MESSAGING_ADDR table is reserved for future use.

10.5.1.12 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

10.5.1.13 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.

Table 10-92 PF_NOTIFICATION_PAYLOAD Database Table

Column Name	Data Type	Null Value	Description	New or Changed Version
PAYLOAD_ID	INTEGER	Not Null	PK – A system-generated unique identifier for the payload ID.	9.2
NOTIFICATION_NAMESPACE	VARCHAR(80)	Not Null	Denotes the namespace for this Notification, which is should be generated as a unique identifier by the application that constructed the Notification. This is meant to help in avoiding collisions due to duplicate NOTIFICATION_ NAMEs used by applications. For example, this could be the company name of the application developer that makes use of the Notifications framework.	9.2
NOTIFICATION_NAME	VARCHAR(40)	Not Null	Name of the notification.	9.2
IS_SELF_DESTRUCT_ENABLED	NUMBER	Not Null	Indicates whether the notification framework should automatically clean up database information about the notification after it has been consumed or timed out, or stored for possible later use in queries. Default = 0 (not enabled/false).	9.2
IS_ACTIVE	NUMBER	Not Null	Indicates whether the notification is active. When a notification is first sent, its status is set to active for each user. Default = 1 (active).	9.2
EXPIRATION_DATE	TIMESTAMP	Not Null	Expiration time for the notification; the notification remains active until it is explicitly consumed or until the expiration time occurs.	9.2
SOURCE_WEBAPP_NAME	VARCHAR(80)	Not Null	Name of the source web application.	9.2
PORTAL_PATH	VARCHAR(40)	Null	Path for the portal.	9.2
DESKTOP_PATH	VARCHAR(40)	Null	Path for the desktop.	9.2
DESKTOP_INSTANCE_TITLE	VARCHAR(20)	Null	Title of the desktop instance.	9.2
PORTLET_DEFINITION_LABEL	VARCHAR(80)	Null	Definition label of the portlet.	9.2
PORTLET_INSTANCE_LABEL	VARCHAR(80)	Null	Instance label of the portlet.	9.2
TARGET_WEBAPP_NAME	VARCHAR(80)	Null	Name of the target web application.	9.2
PAYLOAD	VARCHAR(4000)	Null	The content of the notification.	9.2

10.6 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.

For an entity relation diagram of the Content Management database tables, see Figure B-11, "Content Management Database Tables".

10.6.1 Content Management Data Dictionary Tables

The Content Management system has the following tables:

Section 10.6.1.1, "CM_NODE Database Table"
Section 10.6.1.2, "CM_COLLABORATION_API_METADATA Database Table"
Section 10.6.1.4, "CM_PROPERTY Database Table"
Section 10.6.1.5, "CM_PROPERTY_CHOICE Database Table"
Section 10.6.1.6, "CM_PROPERTY_DEFINITION Database Table"
Section 10.6.1.7, "CM_PROPERTY_TEXT Database Table"
Section 10.6.1.8, "CM_WORKFLOW Database Table"

10.6.1.1 CM_NODE Database Table

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.
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

10.6.1.2 CM_COLLABORATION_API_METADATA Database Table

This table is used to store information about WebLogic Portal's collaboration portlets.

Table 10-94 CM_COLLABORATION_API_METADATA Table Metadata

Column Name	Data Type	Null Value	Description	New or Changed Version
NODE_ID	INTEGER	Not Null	PK - A unique, system-generated number to use as the record ID.	9.2
ICONTAINER_SUBCONTAINER_ COUNT	INTEGER	Not Null	The number of shallow child containers for the current node.	9.2
IGWARE_CONTR_TOTAL_ITEM_ COUNT	INTEGER	Not Null	The number of shallow child items for the current node.	9.2
IGWARE_CONTR_UNREAD_ITEM_COUNT	INTEGER	Not Null	The number of shallow child items that are marked as UNREAD for the current node.	9.2
IFORUM_CATEGORY_FORUM_ COUNT	INTEGER	Not Null	The number of shallow forums beneath this category.	9.2
ITOPIC_SUPPRT_DEEP_TOPIC_ COUNT	INTEGER	Not Null	The number of topics, infinitely deep, below this node.	9.2
ITOPIC_SUPPRT_TOPIC_COUNT	INTEGER	Not Null	The number of shallow topics below this node.	9.2

10.6.1.3 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

10.6.1.4 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.	9.2
PROPERTY_TYPE	SMALLINT	Not Null	The type of the property: 0 = Boolean 1 = Number 2 = Float 3 = Varchar 4 = Date 5 = BLOB 6 = Nested 7 = Linked
PROPERTY_DEFINITION_ID	INTEGER	Null	FK – The ID of the property definition to which this property must conform.
BOOLEAN_VALUE	SMALLINT	Null	True (1) for the Property if the `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.

10.6.1.5 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

10.6.1.6 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` – T`he 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: 1 = Native (the default) 2 = Inherited 3 = Overridden	9.2
NESTED_OBJECT_CLASS_ID	INTEGER	Not Null	FK – The OBJECT_CLASS_ID of the nested type. An object class can "nest" the set of definitions as defined by another object class.	9.2

10.6.1.7 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

10.6.1.8 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

10.7 Content Management Virtual Content Repository Database Objects

The WLP repository provides automatic versioning.

For an entity relation diagram of the Virtual Content Repository (versioning) database tables see Figure B-12, "Content Management Virtual Content Repository Database Tables".

10.7.1 Content Management Virtual Object Data Dictionary Tables

The Content Management system has the following tables for virtual objects:

Section 10.7.1.1, "CMV_NODE Table"
Section 10.7.1.2, "CMV_NODE_ASSIGNED_ROLE Table"
Section 10.7.1.3, "CMV_NODE_VERSION Table"
Section 10.7.1.4, "CMV_PROPERTY Table"
Section 10.7.1.5, "CMV_VALUE Table"
Section 10.7.1.6, "CMV_VALUE_TEXT Table"
Section 10.7.1.7, "CMV_NODE_VERSION_PROPERTY Table"

10.7.1.1 CMV_NODE Table

This table uniquely identifies a content-managed node from a WLP repository (that is, CM_NODE table) that has been versioned and is being edited within the Content Management Virtual Repository.

Table 10-101 CMV_NODE Table

Column Name	Data Type	Null Value	Description
NODE_ID	VARCHAR (254)	Not Null	PK – A unique, system-generated number to use as the record ID.
NODE_NAME	VARCHAR (50)	Not Null	The name of the node.
REPOSITORY_NAME	VARCHAR (254)	Not Null	The name of the repository where the node was created and published.
IS_LOCKED	SMALLINT	Not Null	Flag to determine if the record is locked.
OBJECT_CLASS_ID	VARCHAR (254)	Null	The object class ID that is associated with the node.
ASSIGNED_TO_USER_NAME	VARCHAR(200)	Null	User name to which the node is assigned.
LAST_ASSIGNED_TO_USER_NAME	VARCHAR(200)	Null	User name to which the node is assigned; to be used in a revert scenario.

10.7.1.2 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.

10.7.1.3 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	User name of the person who last edited the node version.
VERSION_COMMENT	VARCHAR(254)	Not Null	Comment added to a node version when saving.
LIFECYCLE_STATUS	INTEGER	Null	Specific life cycle status that the node version has been assigned (for example, In Progress, Published, and so on).

10.7.1.4 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

10.7.1.5 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

10.7.1.6 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

10.7.1.7 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.

10.8 RDBMS Security Store Tables

WebLogic Server provides the option of using an external RDBMS as a datastore that is used by authorization, role mapping, credential mapping, and certificate registry providers. WebLogic Portal uses this datastore as part of its default domain configuration. When you configure a WLP domain, the RDBMS security store tables are automatically created.

For detailed information on the RDBMS security store, see the WebLogic Server document, "Managing the RDBMS Security Store," in Oracle Fusion Middleware Securing Oracle WebLogic Server.

Table 10-108 highlights the collection of columns from the RDBMS security store tables for which WLP has modified the column sizes.

Table 10-108 RDBMS Security Store Database Table Defaults

Column Name	WLS Default Size (bytes)	WLP Default Size (bytes)	DB2	MySQL
DOMN	128	128	50	50
REALMN	128	128	50	50
CREDN	400	768	WLP default	600
CN	400	768	WLP default	600
PM_CN	400	768	WLP default	600
ENTRY_KEY	400	768	WLP default	600
WCRIDN	400	768	WLP default	600
WCRSN	400	768	WLP default	600
WCRSDN	400	768	WLP default	600
WCRSKI	400	768	WLP default	600
XRS	400	768	WLP default	600
TYPEN	400	768	WLP default	600
XR	400	768	WLP default	600