This chapter describes the database objects for each component of WebLogic Portal. The information in this section is collectively known as the data dictionary.
For each component of WebLogic Portal, the following information is provided:
An entity-relationship diagram
A detailed description of each database table, including:
Table Name - The predefined name for the Table.
Table Description - A detailed description of the contents and purpose for the table in WebLogic Portal database schema.
Column Name - The predefined name for the column.
Data Type - The predefined characteristics for the column.
Data types vary slightly by DBMS. For instance, columns defined as BLOB data types in Oracle, DB2, and PointBase would be defined as TEXT columns in Microsoft SQL Server and Sybase.
Null Value - Indicates whether or not null values can be stored for the column.
Column Description - A detailed description of the contents and purpose for the column including Primary Key (PK-) and Foreign Key (FK-) designations.
Note:
The term hint in the descriptions refers to available capabilities that are not supported in the default skeletons provided with WebLogic Portal.
Change bars in the left column indicate tables or table rows that are new or changed in WebLogic Portal version 9.2.
The appendix Scripts and Properties Files identifies the filenames and location of DDL (database definition language) files for each set of WebLogic Portal database objects.
Personalization Database Objects
Personalization enables you to develop, manage, and measure personalized portal applications. These functions help you target content to a desired audience. This includes the tracking of anonymous users and behavior tracking.
Click to view, and use the magnifying tool to inspect, individual tables in the entity-relation diagram for the Personalization database objects.
Base Personalization Database Tables
The following tables support basic personalization functionality:
This table associates users with profiles (such as the WLCS_CUSTOMER user profile). User profiles use property sets to organize the properties that they contain.
Table 9-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 (such as WLCS_Customer).
CREATION_DATE
DATE
Not Null
The date and time this record was created.
ENTITY Database Table
Some objects in WebLogic Portal implement a Java interface called ConfigurableEntity. Any ConfigurableEntity within the system has an entry in this table.
Table 9-2 ENTITY Table Metadata
Column Name
Data Type
Null Value
Description
ENTITY_ID
NUMBER(15)
Not Null
PK - A unique, sequence-generated number used as the record identifier.
ENTITY_NAME
VARCHAR(200)
Not Null
The name of the ConfigurableEntity.
ENTITY_TYPE
VARCHAR(100)
Not Null
Defines the type of ConfigurableEntity.
CREATION_DATE
DATE
Not Null
The date and time this record was created.
MODIFIED_DATE
DATE
Not Null
The date and time this record was last modified.
PROPERTY_KEY Database Table
Any property assigned to a ConfigurableEntity has a unique PROPERTY_ID. The identifier and associated information is stored in the following table.
Table 9-3 PROPERTY_KEY Table Metadata
Column Name
Data Type
Null Value
Description and Recommendations
PROPERTY_KEY_ID
NUMBER(15)
Not Null
PK - A unique, system-generated number used as the record identifier.
PROPERTY_NAME
VARCHAR(100)
Not Null
The property name.
CREATION_DATE
DATE
Not Null
The date and time this record was created.
MODIFIED_DATE
DATE
Not Null
The date and time this record was last modified.
PROPERTY_SET_NAME
VARCHAR(100)
Null
The name of the property set.
PROPERTY_SET_TYPE
VARCHAR(100)
Null
The type the property set.
PROPERTY_VALUE Database Table
This table stores property values for boolean, datetime, float, integer, text, and user-defined properties.
Table 9-4 PROPERTY_VALUE Table Metadata
Column Name
Data Type
Null Value
Description
PROPERTY_VALUE_ID
NUMBER(15)
Not Null
PK - A unique, system-generated number used as the record identifier.
PROPERTY_KEY_ID
NUMBER(15)
Not Null
FK to PROPERTY_KEY.PROPERTY_KEY_ID
ENTITY_ID
NUMBER(15)
Not Null
FK to ENTITY.ENTITY_ID
PROPERTY_TYPE
NUMBER(1)
Not Null
Valid entries are:
0=Boolean, 1=Integer, 2=Float, 3=Text, 4=Date and Time, 5=User-Defined (BLOB).
CREATION_DATE
DATE
Not Null
The date and time this record was created.
MODIFIED_DATE
DATE
Not Null
The date and time this record was last modified.
BOOLEAN_VALUE
NUMBER(1)
Null
The value for each boolean property identifier.
DATETIME_VALUE
DATE
Null
The value for each date and time property identifier.
DOUBLE_VALUE
NUMBER
Null
The value associated with each float property identifier.
LONG_VALUE
NUMBER(20)
Null
The value associated with the integer property.
TEXT_VALUE
VARCHAR(254)
Null
The value associated with the text property.
BLOB_VALUE
BLOB
Null
The value associated with the user-defined property.
SEQUENCER Database Table
The SEQUENCER table maintains all of the sequence identifiers (for example, property_meta_data_id_sequence, and so on) used in the application.
Table 9-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.
WEBLOGIC_IS_ALIVE Database Table
This table is used by the JDBC connection pools to ensure that the connection to the database is still alive.
Table 9-6 WEBLOGIC_IS_ALIVE Table Metadata
Column Name
Data Type
Null Value
Description
NAME
VARCHAR(100)
Not Null
Used by the JDBC connection pools to ensure that the connection to the database is still alive.
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 9-7 P13N_QUIESCENT_STATE Table Metadata
Column Name
Data Type
Null Value
Description
New or Changed Version
ENTAPP_NAME
VARCHAR(255)
Not Null
PK - Name of the enterprise application.
9.2
WEBAPP_NAME
VARCHAR(255)
Not Null
PK - Name of the web application.
9.2
RESOURCE_NAME
VARCHAR(255)
Not Null
PK - The name of an entitled or delegated resource; for example, CONTENT, PORTAL.
9.2
CAPABILITY_NAME
VARCHAR(80)
Not Null
PK - The name of allowed operations/capabilities; anything that allows you to the manipulate the system.
9.2
MODE_NAME
VARCHAR(80)
Not Null
The name of the quiescence mode; for example, BLOCKED.
9.2
MODE_ENABLED_USER_ NAME
VARCHAR(200)
Not Null
The name of the person who turned on quiescence for DT, or who set the BLOCKED mode for the resource.
9.2
P13N_LEASE Database Table
This table was added in WebLogic Portal version 9.2. It is used internally to maintain an exclusive lease request across any application connecting to the same database, in order to prevent multiple conflicting processes. The values in the table are transient and rows in the table should exist only as long as the lease is of value. If for some reason the row is not deleted automatically, WebLogic Portal will update any row as needed when another request with the same name occurs.
The following examples show how this lease data is used:
A WebLogic Portal lease manager locks a resource for startup/update for a specified period of time, and a propagation is running on one node in the cluster. If another node attempts to start a propagation, the lease prevents the second process from beginning at that time.
A WebLogic Portal lease manager uses this table to synchronize distribution of portal framework data within a cluster.
This table is used for internal processing only and is not accessible using the WebLogic Portal Administration Console.
Table 9-8 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
Tracked Anonymous User Dictionary Tables
This section documents the database objects for the WebLogic Portal package. For more information about anonymous users, refer to the User Management Guide.
The following tables support tracking of anonymous users:
This table stores the properties associated with the tracked anonymous user.
Table 9-9 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.
P13N_ANONYMOUS_USER Database Table
This table stores the tracked anonymous user data.
Table 9-10 P13N_ANONYMOUS_USER Table Metadata
Column Name
Data Type
Null Value
Description
ANONYMOUS_USER_ID
VARCHAR(128)
Not Null
FK - maps to the primary key of the anonymous user.
CREATION_DATE
DATE
Not Null
The date and time the row was created.
MODIFIED_DATE
DATE
Not Null
The date and time the row was last modified. This column's data is maintained using a database trigger.
LAST_VISIT_DATE
DATE
Null
Date when the tracked anonymous user last updated the data.
Behavior Tracking Database Tables
Each DBMS-specific chapter of this guide describes how to set up a separate behavior tracking database. Three tables are provided for behavior tracking data. The BT_EVENT table stores all event data. The BT_EVENT_ACTION table logs actions used by third-party vendors against the recorded event data, and the BT_EVENT_TYPE table references event types and categories in the EVENT table.
This table references event types and categories in the BT_EVENT table. This table is static.
Table 9-11 BT_EVENT_TYPE Database Table
Column Name
Data Type
Null Value
Description
EVENT_TYPE
VARCHAR(30)
Not Null
PK - A unique, system-generated number used as the record ID.
EVENT_GROUP
VARCHAR(10)
Not Null
The event category group associated with the event type.
DESCRIPTION
VARCHAR(50)
Null
A description of the EVENT_TYPE.
To record custom events, you must create an entry in this table. If a custom event does not have a record in this table, you cannot persist it to the BT_EVENT table.
BT_EVENT Database Table
This table stores all behavior tracking event data.
Table 9-12 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 9-13.
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 9-12, 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 9-13.
This table holds the various applications available for the data synchronization process.
Table 9-15 DATA_SYNC_APPLICATION Table Metadata
Column Name
Data Type
Null Value
Description
APPLICATION_ID
NUMBER(15)
Not Null
PK - A unique, system-generated number used as the record identifier.
APPLICATION_NAME
VARCHAR(100)
Not Null
The deployed J2EE application name. This should match the name in the WebLogic Server console.
CREATION_DATE
DATE
Not Null
The date and time this record was created.
MODIFIED_DATE
DATE
Not Null
The date and time this record was last modified.
DATA_SYNC_ITEM Database Table
This table stores all the data items to be synchronized.
Table 9-16 DATA_SYNC_ITEM Table Metadata
Column Name
Data Type
Null Value
Description
DATA_SYNC_ITEM_ID
NUMBER(15)
Not Null
PK - A unique, system-generated number used as the record identifier.
APPLICATION_ID
NUMBER(15)
Not Null
FK to DATA_SYNC_ APPLICATON.APPLICATION_ID
SCHEMA_URI_ID
NUMBER(15)
Not Null
FK to DATA_SYNC_ SCHEMA_URI.SCHEMA_URI_ID
VERSION_MAJOR
NUMBER(15)
Not Null
FK to DATA_SYNC_ VERSION.VERSION_MAJOR
VERSION_MINOR
NUMBER(15)
Not Null
FK to DATA_SYNC_ VERSION.VERSION_MINOR
ITEM_CHECKSUM
NUMBER(15)
Not Null
A generated number representing the contents of the XML_DEFINITION column.
CREATION_DATE
DATE
Not Null
The date and time this record was created.
MODIFIED_DATE
DATE
Not Null
The date and time this record was last modified.
XML_MODIFIED_DATE
DATE
Not Null
The date and time the XML file was last modified.
XML_CREATION_DATE
DATE
Not Null
The date and time the XML file was created.
XML_DEFINITION
CLOB
Not Null
The XML representation of the data item to be synchronized.
ITEM_URI
VARCHAR(254)
Not Null
The path on the file system of the data item to be synchronized.
ITEM_AUTHOR
VARCHAR(200)
Null
Metadata information - the OS login.
ITEM_NAME
VARCHAR(100)
Null
Metadata information - the full path to the item.
ITEM_DESCRIPTION
VARCHAR(254)
Null
Metadata information - a general description of the item to be synchronized.
DATA_SYNC_SCHEMA_URI Database Table
This table holds information pertaining to each of the governing schemas used by various documents.
Table 9-17 DATA_SYNC_SCHEMA_URI Table Metadata
Column Name
Data Type
Null Value
Description
SCHEMA_URI_ID
NUMBER(15)
Not Null
PK - A unique, system-generated number used as the record identifier.
SCHEMA_URI
VARCHAR(254)
Not Null
The governing schema of the document.
CREATION_DATE
DATE
Not Null
The date and time this record was created.
MODIFIED_DATE
DATE
Not Null
The date and time this record was last modified.
DATA_SYNC_VERSION Database Table
This table is not being used currently. It is reserved for future use and is expected to accommodate data synchronization versioning. As a result, this table holds only one record.
Table 9-18 DATA_SYNC_VERSION Table Metadata
Column Name
Data Type
Null Value
Description
VERSION_MAJOR
NUMBER(15)
Not Null
PK - The current record has a value of zero.
VERSION_MINOR
NUMBER(15)
Not Null
PK - The current record has a value of zero.
CREATION_DATE
DATE
Not Null
The date and time that the record was created.
MODIFIED_DATE
DATE
Not Null
The date and time that the record was last modified.
BUILD_NUMBER
NUMBER(15)
Null
The build number associated with the version.
VERSION_DESCRIPTION
VARCHAR(30)
Null
A description of the particular sync version.
Portal Services Database Objects
Portal Services database objects are used for placeholders, ads, and ad bucket services.
Click to view, and use the magnifying tool to inspect individual tables in the entity-relation diagram for Portal Services database objects.
The following tables compose the Portal Services database:
PK - A unique, system-generated number used as the record identifier.
USER_NAME
VARCHAR (200)
Not Null
The user's name associated with the ad.
PLACEHOLDER_XML_REF
VARCHAR(254)
Not Null
The location identifier of the XML-based placeholder definition file.
APPLICATION_NAME
VARCHAR(100)
Not Null
The name of the application for which the ad has been scoped.
CONTEXT_REF
VARCHAR(254)
Null
The scenario-unique identifier.
CONTAINER_REF
VARCHAR(254)
Null
The campaign-unique identifier.
CONTAINER_TYPE
VARCHAR(50)
Null
Identifies the service associated with the CONTAINER_REF.
WEIGHT
NUMBER(15)
Null
A weighted scheme used in prioritizing one placeholder over another.
VIEW_COUNT
NUMBER(15)
Null
Disabled. Reserved for future use.
EXPIRATION_DATE
DATE
Null
The date and time the ad expires or becomes invalid.
CREATION_DATE
DATE
Not Null
The date and time this record was created.
MODIFIED_DATE
DATE
Not Null
The date and time this record was last modified.
AD_QUERY
CLOB
Null
The actual content query.
AD_COUNT Database Table
This table tracks the number of times the ads are displayed and clicked though.
Table 9-20 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
NUMBER(15)
Not Null
The number of times the ad has been displayed.
CLICK_THROUGH_COUNT
NUMBER(15)
Not Null
The number of times the ad has been clicked.
PLACEHOLDER_PREVIEW Database Table
This table is used as a mechanism to hold the placeholder for previewing purposes only.
Table 9-21 PLACEHOLDER_PREVIEW Table Metadata
Column Name
Data Type
Null Value
Description
PREVIEW_ID
NUMBER
Not Null
PK - A unique, system-generated number used as the record identifier.
XML_DEFINITION
CLOB
Null
The representation of the expression to be previewed.
MAIL_ADDRESS Database Table
This table stores all of the address information for e-mail purposes.
Table 9-22 MAIL_ADDRESS Table Metadata
Column Name
Data Type
Null Value
Description
MAIL_ADDRESS_ID
NUMBER(15)
Not Null
PK - A unique, system-generated number to use as the record ID.
MESSAGE_ID
NUMBER(15)
Not Null
FK - Foreign key to the MAIL_MESSAGE table.
ADDRESS
VARCHAR(254)
Not Null
Stores the various e-mail addresses on the distribution list.
SEND_TYPE
VARCHAR(4)
Not Null
Determines how the ADDRESS should be included on the distribution. Possible values are TO, CC, or BCC.
MAIL_BATCH Database Table
This table establishes a batch for each mailing.
Table 9-23 MAIL_BATCH Table Metadata
Column Name
Data Type
Null Value
Description
BATCH_ID
NUMBER(15)
Not Null
PK - A unique, system-generated number to use as the record ID.
BATCH_NAME
VARCHAR(254)
Not Null
The name of the mail message batch.
MAIL_BATCH_ENTRY Database Table
This table correlates the mail batch with the specific mail message.
Table 9-24 MAIL_BATCH_ENTRY Table Metadata
Column Name
Data Type
Null Value
Description
BATCH_ID
NUMBER(15)
Not Null
PK and FK - A unique, system-generated number to use as the record ID.
MESSAGE_ID
NUMBER(15)
Not Null
PK and FK - Foreign key to the MAIL_MESSAGE table.
MAIL_HEADER Database Table
This table contains all of the header information specific to the e-mail message.
Table 9-25 MAIL_HEADER Table Metadata
Column Name
Data Type
Null Value
Description
HEADER_ID
NUMBER(15)
Not Null
PK - A unique, system-generated number to use as the record ID.
MESSAGE_ID
NUMBER(15)
Not Null
FK - Foreign key to the MAIL_MESSAGE table.
HEADER_NAME
VARCHAR(50)
Null
The name of the mail message header.
HEADER_VALUE
VARCHAR(254)
Null
The value of the mail message header.
MAIL_MESSAGE Database Table
This table contains the specifics of the mail message (for example, the subject line, text, and so on).
Table 9-26 MAIL_MESSAGE Table Metadata
Column Name
Data Type
Null Value
Description
MESSAGE_ID
NUMBER(15)
Not Null
PK - A unique, system-generated number to use as the record ID.
FROM_ADDRESS
VARCHAR(254)
Null
Identifies who is sending the message.
SUBJECT
VARCHAR(128)
Null
Stores the mail message subject.
MESSAGE_TEXT
CLOB
Null
Holds the content of the mail message.
SCENARIO_END_STATE Database Table
This table identifies when a user is no longer eligible to participate in a particular scenario.
Table 9-27 SCENARIO_END_STATE Table Metadata
Column Name
Data Type
Null Value
Description
SCENARIO_XML_REF
VARCHAR(20)
Not Null
PK - The identifier for the XML-based scenario definition file.
USER_NAME
VARCHAR(200)
Not Null
PK—the user ID. FK to WLCS_USER.IDENTIFIER.
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.
Entitlement Reference Dictionary 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 Policy system has the following tables:
PK - A unique, system-generated number to use as the record ID.
ENTAPP_NAME
VARCHAR(255)
Not Null
The name of the enterprise application.
WEBAPP_NAME
VARCHAR(255)
Null
The name of the web application.
ENTITLEMENT_APP_ DESCRIPTION
VARCHAR(255)
Null
The description of the enterprise application.
CREATION_DATE
DATE
Not Null
The date and time the record was created; the default is the current time stamp.
MODIFIED_DATE
DATE
Not Null
The date and time the record was last modified; the default is the current time stamp.
P13N_ENTITLEMENT_POLICY Database Table
This table uniquely identifies an entitlement policy. An entitlement policy is created when an entitlement role is associated with an entitlement resource and capability.
Table 9-29 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
P13N_ENTITLEMENT_RESOURCE Database Table
This table uniquely identifies an application resource that can have an entitlement associated with it.
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.
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 9-33 USERS Table Metadata
Column Name
Data Type
Null Value
Description
New or Changed Version
U_NAME
VARCHAR(200)
Not Null
PK - Unique name of the user.
9.2
U_PASSWORD
VARCHAR(50)
Not Null
Password of the user.
9.2
U_DESCRIPTION
VARCHAR(1000)
Null
Optional description.
9.2
GROUPS Database Table
This table was added in WebLogic Portal version 9.2. It maintains information on groups and their descriptions.
Table 9-34 GROUPS Table Metadata
Column Name
Data Type
Null Value
Description
New or Changed Version
G_NAME
VARCHAR(200)
Not Null
PK - Unique name of the group.
9.2
G_DESCRIPTION
VARCHAR(1000)
Null
Optional description.
9.2
GROUPMEMBERS Database Table
This table was added in WebLogic Portal version 9.2. It maintains group hierarchy information.
Table 9-35 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
Portal Framework Database Objects
The Portal Framework is the portion of WebLogic Portal that is responsible for the rendering and customization of the portal.
Click to view, and use the magnifying tool to inspect individual tables in the logical entity-relation diagram for the Portal Framework tables. This includes tables that support WSRP and localization.
Portal Framework Database Tables
In this section, tables are arranged alphabetically as a data dictionary. The following tables compose the generic Portal Framework database:
This table defines a BOOK portal library resource. Books are used to aggregate PAGES and other BOOKS.
Table 9-36 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 WebLogic Workshop.
If a label is not supplied at creation time, the BOOK_DEFINITION_ID prefixed with a B is used. This label can be supplied to APIs to activate books or pages.
PF_BOOK_GROUP Database Table
This table represents a child page or book placement on the parent book. A single record in the table represents one placement on a book. This table also identifies a customized grouping of books and pages. Customized groupings are represented and aggregated around the DESKTOP_INSTANCE_ID.
Table 9-37 PF_BOOK_GROUP Table Metadata
Column Name
Data Type
Null Value
Description
BOOK_GROUP_ID
NUMBER
Not Null
PK - A unique, system-generated number to use as the record ID.
PARENT_BOOK_ID
NUMBER
Not Null
FK to PF_BOOK_INSTANCE that identifies the parent BOOK_INSTANCE_ID.
ALIGNMENT
NUMBER
Not Null
The alignment is a hint to the menu skeleton JSP to indicate whether the tab should be aligned on the left or right of the tab bar. A skeleton can either implement this feature or ignore it.
MENU_POSITION
NUMBER
Not Null
The order, in the tab menu, in which this page or book will appear on the parent book.The order does not need to be contiguous.
CREATION_DATE
DATE
Not Null
The date and time the row was created.
MODIFIED_DATE
DATE
Not Null
The date and time the row was last modified. This column's data is maintained using a database trigger.
IS_DEFAULT
NUMBER
Not Null
A boolean flag indicating that this is the default page or book on the parent book.
CHILD_BOOK_ID
NUMBER
Null
FK to PF_BOOK_INSTANCE that identifies the child BOOK_INSTANCE_ID.
PAGE_INSTANCE_ID
NUMBER
Null
FK to PF_BOOK_INSTANCE.
DESKTOP_INSTANCE_ID
NUMBER
Null
FK to PF_DESKTOP_INSTANCE. If this book grouping is an administrator or end user customization, this value is non null and points to the administrator's or user's desktop. If this field is null, it represents the library's view.
PF_BOOK_INSTANCE Database Table
This table identifies an instance of the BOOK_DEFINITION. There is always at least one book instance, namely the primary instance. All other instances represent customization by administrators or end users.
Table 9-38 PF_BOOK_INSTANCE Table Metadata
Column Name
Data Type
Null Value
Description
BOOK_INSTANCE_ID
NUMBER
Not Null
PK - A unique, system-generated number to use as the record ID.
MENU_ORIENTATION
NUMBER
Not Null
The orientation is a hint to the book skeleton JSP and the menu skeleton JSP to display the tabs on the top, left, right, or bottom of the main book. The skeletons can choose to ignore this field.
INSTANCE_TYPE
NUMBER
Not Null
The type of book instance: 1=Primary, 3=Admin, 4=User.
CREATION_DATE
DATE
Not Null
The date and time the row was created.
MODIFIED_DATE
DATE
Not Null
The date and time the row was last modified. This column's data is maintained using a database trigger.
INSTANCE_TITLE
VARCHAR(255)
Null
An end-user-customized title for this BOOK.
This title is not internationalized as it is used only by the end user. If the end user does not customize the book title, then the value is null and the L10N_RESOURCE title is used.
BOOK_DEFINITION_ID
NUMBER
Not Null
FK to PF_BOOK_DEFINITION.
MENU_DEFINITION_ID
NUMBER
Null
FK to PF_MENU_DEFINITION. Can be null as not every book must have a menu.
THEME_DEFINITION_ID
NUMBER
Null
FK to PF_THEME_DEFINITION.
PF_DESKTOP_DEFINITION Database Table
This table defines a desktop definition. You can create Desktops from template (.portal) files or from existing resources.
Table 9-39 PF_DESKTOP_DEFINITION Table Metadata
Column Name
Data Type
Null Value
Description
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).
PF_DESKTOP_INSTANCE Database Table
This table identifies a customized or localized instance of a desktop.
Table 9-40 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.
IS_COMMUNITY
NUMBER
Not Null
Indicates whether the desktop is a community; possible values are: 0 (the default, not a community), or 1 (community).
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 9-41 PF_LAYOUT_DEFINITION Table Metadata
Column Name
Data Type
Null Value
Description
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.
PF_LOOK_AND_FEEL_DEFINITION Database Table
This table defines a LOOK and FEEL portal library resource or template for assignment to DESKTOPs that control how a portal renders.
PK - A unique, system-generated number to use as the record ID.
LOOK_FEEL_LABEL
VARCHAR(80)
Not Null
A moniker used to reference this portal resource for development purposes.
CREATION_DATE
DATE
Not Null
The date and time the row was created.
MODIFIED_DATE
DATE
Not Null
The date and time the row was last modified. This column's data is maintained using a database trigger.
INTERSECTION_ID
NUMBER
Not Null
FK to L10N_INTERSECTION.
MARKUP_DEFINITION_ID
NUMBER
Not Null
FK to PF_MARKUP_DEFINITION.
WEBAPP_NAME
VARCHAR(80)
Not Null
Name of the J2EE web application to which the portal resource is scoped.
IS_LOOK_FEEL_FILE_ DELETED
NUMBER
Not Null
A boolean indicating that the file associated with this look and feel was removed from the file system. If the look and feel is not being used, then the record is deleted outright.
This flag is set to true only when the .laf file is deleted and the look and feel is still in use. You can either return the .laf file and this flag is automatically reset, or remove the look and feel with a replacement look and feel in the Administration Console.
LOOK_FEEL_FILE
VARCHAR(255)
Not Null
The fully qualified file path (from the web app) to the location of the .laf file associated with this look and feel definition.
PF_MARKUP_DEFINITION Database Table
This table defines the MARKUP (blueprint, design, model) for a portal library resource.
Table 9-43 PF_MARKUP_DEFINITION Table Metadata
Column Name
Data Type
Null Value
Description
MARKUP_DEFINITION_ID
NUMBER
Not Null
PK - A unique, system-generated number to use as the record ID.
CREATION_DATE
DATE
Not Null
The date and time the row was created.
MODIFIED_DATE
DATE
Not Null
The date and time the row was last modified. This column's data is maintained using a database trigger.
MARKUP_NAME
VARCHAR(255)
Not Null
The filename and location that contains the definition of this portal object.
MARKUP_TYPE
VARCHAR(20)
Not Null
The type of portal resource that this markup defines.
BEGIN_XML
VARCHAR(2000)
Not Null
The first 2000 characters of XML definition of this portal object.
END_XML
VARCHAR(2000)
Null
The last 2000 characters of the XML definition of this portal object.
MARKUP_FILE
VARCHAR(255)
Null
Location of the file containing the markup definition.
WEBAPP_NAME
VARCHAR(80)
Null
Name of the J2EE web application to which the portal resource is scoped.
PF_MARKUP_XML Database Table
This table was added in WebLogic Portal version 9.2. It defines additional XML markup information for portal resources.
Table 9-44 PF_MARKUP_XML Table Metadata
Column Name
Data Type
Null Value
Description
New or Changed Version
MARKUP_DEFINITION_ID
INTEGER
Not Null
PK - A unique, system-generated number to use as the record ID.
9.2
XML_TYPE
CHAR(1)
Not Null
Identifies if this block is a begin or end block. Values are "B" for begin or "E" for end.
9.2
BLOCK_NUMBER
INTEGER
Not Null
Determines the order of the markup.
9.2
MARKUP_XML
VARCHAR(2000)
Not Null
The markup value.
9.2
PF_MENU_DEFINITION Database Table
This table defines a MENU portal library resource or template that can be assigned to a BOOK INSTANCE.
Table 9-45 PF_MENU_DEFINITION Table Metadata
Column Name
Data Type
Null Value
Description
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.
PF_PAGE_DEFINITION Database Table
This table defines a PAGE portal library resource or template that can be assigned to a PAGE INSTANCE.
Table 9-46 PF_PAGE_DEFINITION Table Metadata
Column Name
Data Type
Null Value
Description
PAGE_DEFINITION_ID
NUMBER
Not Null
PK - A unique, system-generated number to use as the record ID.
MARKUP_DEFINITION_ID
NUMBER
Not Null
FK to PF_MARKUP_DEFINITION.
IS_PUBLIC
NUMBER
Not Null
A boolean indicating this page definition is public. Only public page definitions are ever exposed to site visitors.
IS_HIDDEN
NUMBER
Not Null
A boolean indicating this page is hidden. The hidden flag is a hint to the menu not to render a tab for this page. The page can still be displayed by other methods (links, events).
CREATION_DATE
DATE
Not Null
The date and time the row was created.
MODIFIED_DATE
DATE
Not Null
The date and time the row was last modified. This column's data is maintained using a database trigger.
INTERSECTION_ID
NUMBER
Not Null
FK to L10N_INTERSECTION.
WEBAPP_NAME
VARCHAR(80)
Not Null
Name of the J2EE web application to which the portal resource is scoped.
PAGE_LABEL
VARCHAR(80)
Null
A moniker used to reference this portal resource for development purposes.
PF_PAGE_INSTANCE Database Table
This table identifies an instance of the page definition; at least one instance per definition always exists.
Table 9-47 PF_PAGE_INSTANCE Table Metadata
Column Name
Data Type
Null Value
Description
PAGE_INSTANCE_ID
NUMBER
Not Null
PK - A unique, system-generated number to use as the record ID.
CREATION_DATE
DATE
Not Null
The date and time the row was created.
MODIFIED_DATE
DATE
Not Null
The date and time the row was last modified. This column's data is maintained using a database trigger.
INSTANCE_TYPE
NUMBER
Not Null
The type of page instance: 1=Primary, 3=Admin, 4=User.
LAYOUT_DEFINITION_ID
NUMBER
Not Null
FK to PF_LAYOUT_DEFINITION.
PAGE_DEFINITION_ID
NUMBER
Not Null
FK to PF_PAGE_DEFINITION.
THEME_DEFINITION_ID
NUMBER
Null
FK to PF_THEME_DEFINITION.
INSTANCE_TITLE
VARCHAR(255)
Null
A desktop- or user-customized title for this page. This instance title is valid only to end users as it cannot and need not be localized.
PF_PLACEHOLDER_DEFINITION Database Table
This table defines a PLACEHOLDER portal library resource or template that has a LAYOUT definition and can be assigned to a PLACEMENT.
PK - A unique, system-generated number to use as the record ID.
MARKUP_DEFINITION_ID
NUMBER
Not Null
FK to PF_MARKUP_DEFINITION.
LAYOUT_LOCATION
NUMBER
Not Null
The location of this placeholder in the layout. This is used when swapping layouts, as portlets in one layout's location are moved to the other layout's location with the same ID. If the other layout does not have the same number of placeholders, the modulus of the location by number of locations are used.
CREATION_DATE
DATE
Not Null
The date and time the row was created.
MODIFIED_DATE
DATE
Not Null
The date and time the row was last modified. This column's data is maintained using a database trigger.
INTERSECTION_ID
NUMBER
Not Null
FK to L10N_INTERSECTION.
LAYOUT_DEFINITION_ID
NUMBER
Not Null
FK to PF_LAYOUT_DEFINITION.
PF_PLACEMENT Database Table
Each record in this table represents a single placement of a book or portlet on a page.
Table 9-49 PF_PLACEMENT Table Metadata
Column Name
Data Type
Null Value
Description
PLACEMENT_ID
NUMBER
Not Null
PK - A unique, system-generated number to use as the record ID.
PAGE_INSTANCE_ID
NUMBER
Not Null
FK to PF_PAGE_INSTANCE.
POSITION
NUMBER
Not Null
The position within the placeholder where this placement lies. Placeholders can contain more than one placement.
CREATION_DATE
DATE
Not Null
The date and time the row was created.
MODIFIED_DATE
DATE
Not Null
The date and time the row was last modified. This column's data is maintained using a database trigger.
PLACEHOLDER_
DEFINITION_ID
NUMBER
Not Null
FK to PF_PLACEHOLDER_DEFINITION.
PORTLET_INSTANCE_ID
NUMBER
Null
FK to PF_PORTLET_INSTANCE.
BOOK_INSTANCE_ID
NUMBER
Null
FK to PF_BOOK_INSTANCE.
DESKTOP_INSTANCE_ID
NUMBER
Null
FK to PF_DESKTOP_INSTANCE. If this placement grouping is an administrator- or end-user-customization, the value is non null and points to the administrator's or user's desktop. If this field is null, it represents the library's view.
PF_PORTAL Database Table
This table identifies a PORTAL application library resource or template that can be associated with a DESKTOP definition.
Table 9-50 PF_PORTAL Table Metadata
Column Name
Data Type
Null Value
Description
PORTAL_PATH
VARCHAR(40)
Not Null
PK - Partial primary key and partial URL to this portal.
WEBAPP_NAME
VARCHAR(80)
Not Null
PK - Name of the J2EE web application to which the portal resource is scoped.
CREATION_DATE
DATE
Not Null
The date and time the row was created.
MODIFIED_DATE
DATE
Not Null
The date and time the row was last modified. This column's data is maintained using a database trigger.
INTERSECTION_ID
NUMBER
Not Null
FK to L10N_INTERSECTION.
CONTENT_URI
VARCHAR(255)
Null
Defines an optional URI to be forwarded to when only the portal portion of the URL is supplied. You can use this URL (JSP or .portal) to forward to a default desktop or to display a list of desktops available under this portal.
PF_PORTLET_CATEGORY Database Table
This table associates a PORTLETCATEGORY resource with a PORTLETDEFINITION.
Table 9-51 PF_PORTLET_CATEGORY Table Metadata
Column Name
Data Type
Null Value
Description
PORTLET_DEFINITION_ID
NUMBER
Not Null
PK - A unique, system-generated number to use as the record ID.
PORTLET_CATEGORY_ DEFINITION_ID
NUMBER
Not Null
FK to PF_PORTLET_CATEGORY_ DEFINITION.
CREATION_DATE
DATE
Not Null
The date and time the row was created.
MODIFIED_DATE
DATE
Not Null
The date and time the row was last modified. This column's data is maintained using a database trigger.
PF_PORTLET_CATEGORY_DEFINITION Database Table
This table identifies a PORTLET CATEGORY and PORTLET CATEGORY hierarchy resource or template for association with a PORTLET resource.
PK - A unique, system-generated number to use as the record ID.
CREATION_DATE
DATE
Not Null
The date and time the row was created.
MODIFIED_DATE
DATE
Not Null
The date and time the row was last modified. This column's data is maintained using a database trigger.
INTERSECTION_ID
NUMBER
Not Null
FK to L10N_INTERSECTION.
WEBAPP_NAME
VARCHAR(80)
Not Null
Name of the J2EE web application to which the portal resource is scoped.
PARENT_CATEGORY_ DEFINITION_ID
NUMBER
Null
FK to PF_PORTLET_CATEGORY_ DEFINITION that identifies the parent portlet category. NULL if this is a top level category.
PF_PORTLET_DEFINITION Database Table
This table identifies the characteristics of a PORTLET library resource or template that can used as the user interfaces for a web application.
Table 9-53 PF_PORTLET_DEFINITION Table Metadata
Column Name
Data Type
Null Value
Description
PORTLET_DEFINITION_ID
NUMBER
Not Null
PK - A unique, system-generated number to use as the record ID.
MARKUP_DEFINITION_ID
NUMBER
Not Null
FK to PF_MARKUP_DEFINITION.
IS_PUBLIC
NUMBER
Not Null
A boolean indicating that the portlet definition is public. Only public portlet definitions are ever exposed to site visitors.
IS_FORKABLE
NUMBER
Not Null
A boolean indicating that the portlet supports multi-threading.
FORK_RENDER
NUMBER
Not Null
A boolean indicating whether multi-threading is being used for this portlet; this value can be true only if IS_FORKABLE is true.
IS_CACHEABLE
NUMBER
Not Null
A boolean indicating whether this portlet can use render caching.
CACHE_EXPIRES
NUMBER
Not Null
Indicates whether this portlet is using caching and if so, gives the ttl: -1 indicates off; 0..n indicates a ttl for the cache.
Can have a value other than -1 only if IS_CACHEABLE is true.
WSRP_PROPERTIES_MODE
NUMBER
Not Null
Indicates required user properties.
for WSRP user profile propagation. Possible values are: 0 = None 1 = All 2 = Specified properties 3 = User properties are defaulted to the web application's default. This is the default value.
IS_PORTLET_FILE_DELETED
NUMBER
Not Null
A boolean that indicates whether the PORTLET_FILE associated with this object has been removed from the file system.
This flag is set to true only when the .portlet file is deleted and the portlet is still in use. You can either return the .portlet file and this flag is automatically reset, or remove the portlet in the Administration Console.
CREATION_DATE
DATE
Not Null
The date and time the row was created.
MODIFIED_DATE
DATE
Not Null
The date and time the row was last modified. This column's data is maintained using a database trigger.
PORTLET_LABEL
VARCHAR(80)
Not Null
A moniker used to reference this portal resource for development purposes.
WEBAPP_NAME
VARCHAR(80)
Not Null
Name of the J2EE web application to which the portal resource is scoped.
CONTENT_URI
VARCHAR(255)
Not Null
The content URI for this portlet (JSP, HTML).
This value can be null for Java (JSR168) portlets.
EDIT_URI
VARCHAR(255)
Null
The Edit mode URI (JSP) for this portlet (if the portlet supports edit mode).
HELP_URI
VARCHAR(255)
Null
The Help mode URI (JSP) for this portlet (if the portlet supports help mode).
BACKING_FILE
VARCHAR(255)
Null
The optional backing file (Java class name) for this portlet. Backing classes must implement JspBacking or extend AbstractJspBacking.
PORTLET_FILE
VARCHAR(255)
Null
The (*.portlet) file describing the controls that make up the portlet. The field is null if no portlet file exists.
PF_PORTLET_INSTANCE Database Table
This table identifies a customized or localized instance of a portlet
This table identifies preference values for the portlet instance.
Table 9-55 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(40)
Not Null
An optional name associated with the preference values.
CREATION_DATE
DATE
Not Null
The date and time the row was created.
MODIFIED_DATE
DATE
Not Null
The date and time the row was last modified. This column's data is maintained using a database trigger.
IS_MODIFIABLE
NUMBER
Not Null
A boolean, indicating whether the name/value of this preference can be modified by portlets.
IS_MULTIVALUED
NUMBER
Not Null
A boolean, indicating whether a preference can have more than one value.
PREFERENCE_DESCRIPTION
VARCHAR(255)
Null
An optional description of the portlet preferences.
PF_PORTLET_PREFERENCE_VALUE Database Table
This table maintains values of portlet preferences. There is a one-to-many correspondence between the records in the PF_PORTLET_PREFERENCE table and this table.
PK - A unique, system-generated number to use as the property ID.
PORTLET_DEFINITION_ID
NUMBER
Not Null
PK - A unique, system-generated number to use as the portlet definition ID.
PROPERTY_STRING
VARCHAR(255)
Not Null
String value.
PF_SHELL_DEFINITION Database Table
This table represents a shell definition. There is a one-to-one correspondence between records in this table and .shell files.
Table 9-58 PF_SHELL_DEFINITION Table Metadata
Column Name
Data Type
Null Value
Description
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.
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 9-59 PF_THEME_DEFINITION Table Metadata
Column Name
Data Type
Null Value
Description
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.
PF_URL_COMPRESSION Database Table
This table was added in WebLogic Portal version 9.2. It maintains URL compression values.
Table 9-60 PF_URL_COMPRESSION Table Metadata
Column Name
Data Type
Null Value
Description
New or Changed Version
URL_COMPRESSION_ID
INTEGER
Not Null
PK - A unique, system-generated number to use as the URL Compression ID.
9.2
EXPANDED_URL_HASH
INTEGER
Not Null
Hashed URL used to look up the compressed URL; hashes are not guaranteed to be unique, so a secondary search is performed on EXPANDED_URL.
9.2
EXPANDED_URL
VARCHAR(1000)
Not Null
The full uncompressed URL value.
9.2
PAGE_LABEL
VARCHAR(80)
Null
A name used to reference this portal resource for development purposes.
9.2
Localization Dictionary Tables
This section documents the database objects for the WebLogic Portal framework. The following tables support localization:
The PF_CONSUMER_PORTLETS table associates consumer IDs and portlet instance IDs so that when a consumer unregisters from a producer, the producer can clean up any portlets that it created for the consumer.
Table 9-65 PF_CONSUMER_PORTLETS Database Table
Column Name
Data Type
Null Value
Description
CONSUMER_ID
NUMBER
Not Null
PK/FK to PF_PRODUCER_REGISTRY.
PORTLET_ID
NUMBER
Not Null
PK/FK to PF_PORTLET_INSTANCE.
PF_CONSUMER_PROPERTIES Database Table
This table contains optional registration properties. You can set up the consumer to ask for these during registration.
Table 9-66 PF_CONSUMER_PROPERTIES Database Table
Column Name
Data Type
Null Value
Description
PRODUCER_ID
INTEGER
Not Null
PK/FK to PF_PRODUCER_REGISTRY.
PROPERTY_NAME
VARCHAR(80)
Not Null
PK - The name of the property.
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.
PROPERTY_VALUE
VARCHAR (80)
Null
The value associated with the property name.
PF_CONSUMER_REGISTRY Database Table
This table contains registration handles that are assigned by the producer during registration by a consumer.
Table 9-67 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.
PF_PRODUCER_PROPERTIES Database Table
This table contains optional registration properties. The producer might be asked for these during registration.
Table 9-68 PF_PRODUCER_PROPERTIES Database Table
Column Name
Data Type
Null Value
Description
CONSUMER_ID
INTEGER
Not Null
PK/FK to PF_CONSUMER_REGISTRY.
PROPERTY_NAME
VARCHAR(80)
Not Null
PK - The name of the property.
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.
PROPERTY_VALUE
VARCHAR(80)
Null
The value associated with the PROPERTY_NAME.
PF_PRODUCER_REGISTRY Database Table
This table contains producer-generated registration handles stored for each consumer during registration.
Table 9-69 PF_PRODUCER_REGISTRY Database Table
Column Name
Data Type
Null Value
Description
CONSUMER_ID
INTEGER
Not Null
PK - A unique system-generated number to use as the record ID.
WEBAPP_NAME
VARCHAR(80)
Not Null
Name of the J2EE web application to which the portal application is scoped.
CREATION_DATE
DATE
Not Null
The date and time the row was created.
MODIFIED_DATE
DATE
Not Null
The date and time the row was modified. This column's data is maintained using a database trigger.
CONSUMER_NAME
VARCHAR(80)
Null
A unique name that identifies the consumer. For the producer to assert user identity, the consumer name must correspond to the alias of the consumer's public key deployed in the producer's key store.
CONSUMER_AGENT
VARCHAR(80)
Null
Name and version of the consumer's vendor. The value must start with productName.majorVersion.minorVersion where productName identifies the product that the consumer installed for its deployment, and majorVersion and minorVersion are vendor-defined indications of the version of its product.
PF_PORTLET_INSTANCE Database Table
The consumer manages remote portlet-specific data from here. The framework inserts data into this table whenever a proxy portlet instance is created (including successors). When portlet instances are deleted, the IS_SET_FOR_DESTROY flag is set for subsequent cleanup.
PK - A unique system-generated number to use as the record ID.
PRODUCER_ID
INTEGER
Not Null
FK to PF_CONSUMER_REGISTRY.
CREATED_DATE
DATE
Not Null
The date and time the row was created.
MODIFIED_DATE
DATE
Not Null
The date and time the row was modified. This column's data is maintained using a database trigger.
REQUIRES_URL_TEMPLATES
NUMBER
Not Null
A boolean indicating that URL templates are required by the producer.
TEMPLATES_STORED_ IN_ SESSION
NUMBER
Not Null
A boolean indicating whether the consumer should send templates with every request. The default is 1 = True.
PORTLET_STATE_CHANGE
NUMBER
Not Null
A flag that indicates how the consumer handles customizations of remote portlets. Based on the value of this flag, the consumer may clone remote portlets. Possible values include: 0 = Readonly (default) 1 = CBW(CloneBeforeWrite) 2 = Read/Write.
IS_PRODUCER_OFFERED
NUMBER
Not Null
Identifies the portlet as producer-offered. The defaults is 1 = True.
If IS_PRODUCER_OFFERED is True, and the PORTLET_INSTANCE_ID is null, this PF_PROXY_PORTLET_INSTANCE is removed from the database during data cleanup processing.
PORTLET_INSTANCE_ID
INTEGER
Null
FK to PF_PORTLET_INSTANCE for the proxy portlet. If the associated PF_PORTLET_INSTANCE row is deleted, the value of this column is set to null.
PORTLET_HANDLE
VARCHAR(255)
Null
The handle to the remote portlet as it is specified by the producer. The consumer uses portlet handles throughout the communication to address and interact with portlets using the producer.
DELETE_ERROR_CAUSE
VARCHAR(255)
Null
A description of the cause of the error, if an error is encountered while trying to delete the counter part of this proxy portlet on the producer.
PORTLET_STATE
BLOB
Null
Portlet state as returned by the producer after implicit/explicit cloning.
IS_PRIMARY
NUMBER
Not Null
A boolean indicating whether the proxy portlet is primary or not. When multiple versions of the same proxy portlet are being used on a consumer, operations that involve either using or removing the proxy portlet will be done on the primary version (unless specified that the operation affects all versions). The defaults is 0 (False).
PF_PROXY_BOOK Database Table
This table maintains information on proxy books for the WebLogic Portal Administration Console. If a user is adding new remote resources to the portal, this data can be used to let the user know if a particular proxy book is already in the library.
This table was added in WebLogic Portal 9.2.
Table 9-71 PF_PROXY_BOOK Table Metadata
Column Name
Data Type
Null Value
Description
New or Changed Version
PROXY_BOOK_ID
INTEGER
Not Null
PK - A unique, system-generated number to use as the property ID.
9.2
PRODUCER_HANDLE
VARCHAR(40)
Not Null
Uniquely identifies the producer to the consumer.
9.2
ORIGINAL_NAME
VARCHAR(80)
Not Null
Original name of the book on the producer; this name is tracked in order to find duplicates.
9.2
BOOK_DEFINITION_ID
INTEGER
Not Null
FK to PF_BOOK_DEFINITION
9.2
CREATION_DATE
DATE
Not Null
The date and time the row was created.
9.2
MODIFIED_DATE
DATE
Not Null
The date and time the row was last modified. This column's data is maintained using a database trigger.
9.2
IS_PRIMARY
NUMBER
Not Null
A boolean indicating whether the proxy book is primary or not. When multiple versions of the same proxy book are being used on a consumer, operations that involve either using or removing the proxy book will be done on the primary version (unless specified that the operation affects all versions). The defaults is 0 (False).
9.2
PF_PROXY_PAGE Database Table
This table maintains information on proxy pages for the WebLogic Portal Administration Console. If a user is adding new remote resources to the portal, this data can be used to let the user know if a particular proxy page is already in the library.
This table was added in WebLogic Portal 9.2.
Table 9-72 PF_PROXY_PAGE Table Metadata
Column Name
Data Type
Null Value
Description
New or Changed Version
PROXY_PAGE_ID
INTEGER
Not Null
PK - A unique, system-generated number to use as the property ID.
9.2
PRODUCER_HANDLE
VARCHAR(40)
Not Null
Uniquely identifies the producer to the consumer.
9.2
ORIGINAL_NAME
VARCHAR(80)
Not Null
Original name of the book on the producer; this name is tracked in order to find duplicates.
9.2
PAGE_DEFINITION_ID
INTEGER
Not Null
FK to PF_PAGE_DEFINITION
9.2
CREATION_DATE
DATE
Not Null
The date and time the row was created.
9.2
MODIFIED_DATE
DATE
Not Null
The date and time the row was last modified. This column's data is maintained using a database trigger.
9.2
IS_PRIMARY
NUMBER
Not Null
A boolean indicating whether a proxy page is primary or not. When multiple versions of the same proxy page are being used on a consumer, operations that involve either using or removing the proxy page will be done on the primary version (unless specified that the operation affects all versions). The defaults is 0 (False).
9.2
Communities Framework Database Objects
Communities are a new feature in WebLogic Portal version 9.2. Communities are WebLogic Portal desktops that let users with common goals and interests work together in—and administer—a web-based environment. Whether for specific events, work groups, partners, or for any other groups that need to share information, communities provide a dedicated, secure, self-managed place to collaborate.
Click to view, and use the magnifying tool to inspect individual tables in the logical entity-relation diagram for the Communities Portal Framework tables.
Communities Portal Framework Data Dictionary Tables
The Communities Portal Framework system has the following tables:
The PF_COMMUNITY_DEFINITION table contains community definition data.
Table 9-73 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
PF_COMMUNITY_MEMBER Database Table
The PF_COMMUNITY_MEMBER table contains user information for community members.
Table 9-74 PF_COMMUNITY_MEMBER Database Table
Column Name
Data Type
Null Value
Description
New or Changed Version
COMMUNITY_MEMBER_ID
NUMBER
Not Null
PK - A unique, system-generated number to use as the community member ID.
9.2
USER_NAME
VARCHAR(200)
Not Null
The WebLogic Server user name for the community member.
9.2
MEMBER_TYPE
NUMBER
Not Null
Identifies the community member as internal (1) or external (0).
9.2
MEMBER_STATUS
NUMBER
Not Null
Setting for member's community status. Values are: 0 = Disabled, 1 = Active.
9.2
CREATION_DATE
TIMESTAMP
Not Null
The date and time the row was created.
9.29.2
MODIFIED_DATE
TIMESTAMP
Not Null
The date and time the row was modified. This column's data is maintained using a database trigger.
9.2
PF_COMMUNITY_MEMBERSHIP Database Table
The PF_COMMUNITY_MEMBERSHIP table contains information regarding the membership status of community members.
Table 9-75 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.
The date and time the row was modified. This column's data is maintained using a database trigger.
9.2
LAST_ACCESS_DATE
TIMESTAMP
Null
If access tracking is enabled, this field contains a timestamp that is updated at each login event by the user associated with this CommunityMembership to the linked Community desktop.
9.2
PF_MEMBERSHIP_CAPABILITY Database Table
The PF_MEMBERSHIP_CAPABILITY table contains information about the capabilities of a member within the community.
Table 9-76 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
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 9-77 PF_COMMUNITY_PROPERTY Database Table
Column Name
Data Type
Null Value
Description
New or Changed Version
COMMUNITY_DEFINITION_ID
INTEGER
Not Null
PK/FK - A foreign key to PF_COMMUNITY_DEFINITION.
9.2
PROPERTY_NAME
VARCHAR(100)
Not Null
PK - The property name.
9.2
CREATION_DATE
TIMESTAMP
Not Null
The date and time the row was created.
9.2
MODIFIED_DATE
TIMESTAMP
Not Null
The date and time the row was modified. This column's data is maintained using a database trigger.
9.2
IS_MULTI_VALUED
NUMBER
Not Null
Boolean value.
9.2
DESCRIPTION
VARCHAR(255)
Null
Descriptive text to for this property.
9.2
PF_COMMUNITY_PROPERTY_VALUE Database Table
The PF_COMMUNITY_PROPERTY_VALUE table contains information regarding the actual value of the custom community property.
PK - A system-generated unique number to use as the community property value ID.
9.2
COMMUNITY_DEFINITION_ID
INTEGER
Not Null
A foreign key to PF_COMMUNITY_PROPERTY.
9.2
PROPERTY_NAME
VARCHAR(100)
Not Null
A foreign key to PF_COMMUNITY_PROPERTY.
9.2
CREATION_DATE
TIMESTAMP
Not Null
The date and time the row was created.
9.2
MODIFIED_DATE
TIMESTAMP
Not Null
The date and time the row was modified. This column's data is maintained using a database trigger.
9.2
PROPERTY_VALUE
VARCHAR(400)
Null
The value associated with the property name.
9.2
PF_FILE_TEMPLATE Database Table
The PF_FILE_TEMPLATE table records the location of a file type template. This includes the web application and the URI within the web application to the file, as well as an intersection ID that can be used to retrieve a localized name for the file template.
Table 9-79 PF_FILE_TEMPLATE Database Table
Column Name
Data Type
Null Value
Description
New or Changed Version
TEMPLATE_ID
INTEGER
Not Null
PK - A system-generated unique identifier for the file template.
9.2
INTERSECTION_ID
INTEGER
Not Null
A foreign key to L10N_RESOURCE for the Localization Resource.
9.2
TEMPLATE_URI
VARCHAR(255)
Not Null
URI pointing to the .portal file that this FileTemplate is based on.
9.2
WEBAPP_NAME
VARCHAR(80)
Not Null
Name of the web application that contains the .portal file that this FileTemplate is based.
9.2
PF_INVITATION Database Table
The PF_INVITATION table stores data related to community invitations.
Table 9-80 PF_INVITATION Database Table
Column Name
Data Type
Null Value
Description
New or Changed Version
INVITATION_ID
INTEGER
Not Null
PK - A system-generated unique identifier for the invitation ID.
9.2
COMMUNITY_DEFINITION_ID
INTEGER
Not Null
A foreign key to PF_COMMUNITY_DEFINITION.
9.2
EXPIRATION_DATE
TIMESTAMP
Null
The expiration date for the Invitation, after which the Invitation is no longer active and cannot be consumed.
9.2
IS_SELF_DESTRUCT_ENABLED
NUMBER
Not Null
Indicates whether the framework should automatically clean up database information about the invitation after it has been consumed or timed out, or stored for possible later use in queries. Default = 0 (not enabled/false).
9.2
CREATION_DATE
DATE
Not Null
The date and time the row was created.
INVITATION_PAYLOAD
VARCHAR(200)
Null
Application-specific text data that can be attached to an invitation, for use by a communities application during member registration based on this Invitation.
9.2
FROM_WLS_USER_NAME
VARCHAR(200)
Null
The WebLogic Server user name from which the invitation originated
9.2
PF_INVITEE Database Table
The PF_INVITEE table contains information regarding the target of the invitation.
Table 9-81 PF_INVITEE Database Table
Column Name
Data Type
Null Value
Description
New or Changed Version
INVITEE_ID
INTEGER
Not Null
PK - A system-generated unique identifier for the invitee ID.
9.2
INVITATION_ID
INTEGER
Not Null
A foreign key to PF_INVITATION.
9.2
INVITEE_ADDRESS
VARCHAR(255)
Null
The messaging address (usually an e-mail address) used to send invitations to external users.
The WebLogic Server user name if the invitation is for an existing user, but can be null when inviting external invitees who do not yet have a WebLogic Server user name.
9.2
INVITATION_VALIDATION_ TEXT
VARCHAR(400)
Null
Validation text that is sent as part of the notification, which must then be provided by the invitee when accepting or declining an invitation. The format of this text is developer- definable.
9.2
PF_INVITEE_PROPERTY Database Table
The PF_INVITEE_PROPERTY table contains information regarding persistent invitee properties such as invitee attributes and capabilities
Table 9-82 PF_INVITEE_PROPERTY Database Table
Column Name
Data Type
Null Value
Description
New or Changed Version
INVITEE_ID
INTEGER
Not Null
PK/FK - A foreign key to PF_INVITEE.
9.2
PROPERTY_TYPE
NUMBER
Not Null
PK - Property type. Possible values are:
10 - Persisted Attribute
20 - Persisted Capability
9.2
PROPERTY_NAME
VARCHAR(100)
Not Null
PK - Property name.
9.2
PROPERTY_VALUE
VARCHAR(400)
Not Null
Value of the persisted attribute or capability.
9.2
PF_MESSAGING_ADDR Database Table
The PF_MESSAGING_ADDR table is reserved for future use.
PF_NOTIFICATION Database Table
The PF_NOTIFICATION table stores information about event notifications. Notifications for the Portal Framework are a mechanism for publishing availability, and subscribing to and delivering notification events within a portal. A notification event is a sibling to other types of portlet events as defined in the current inter-portlet eventing design, in that portlets can be authored in a declarative manner to listen for notifications using an event subscription tag within the portlet or portlet instance tag. The primary difference between notification events and normal portlet events is that the source of the notification comes from outside the user's portal desktop. Instead, notifications can come from other users, web applications, or even the framework itself.
Table 9-83 PF_NOTIFICATION Database Table
Column Name
Data Type
Null Value
Description
New or Changed Version
NOTIFICATION_ID
INTEGER
Not Null
PK - A system-generated unique identifier for the notification ID.
9.2
USER_NAME
VARCHAR(200)
Not Null
User name of the notification recipient.
9.2
PAYLOAD_ID
INTEGER
Not Null
A foreign key to PF_NOTIFICATION_PAYLOAD.
9.2
IS_CONSUMED
NUMBER
Not Null
Indicates whether the notification has been consumed; the notification remains active until it is explicitly consumed or until the expiration time occurs. Default = 0 (not consumed).
9.2
PF_NOTIFICATION_PAYLOAD Database Table
The PF_NOTIFICATION_PAYLOAD table stores information about notifications for individual users. Because a notification can be sent to groups of users and each user must individually acknowledge (remove) the notification, the notification table contains an entry for each user for each notification. Because the payload and other characteristics of a single notification batch are identical for each user, this information is separated and stored only once per notification to minimize redundancy in the database.
For portal desktops that are enabled for notification delivery, WebLogic Portal performs a query against the active notifications for a user prior to executing the portal lifecycle for each request.
Table 9-84 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
Content Management Database Objects
WebLogic Portal's content management system allows you to store content, track its progress, and incorporate content in your portal applications. It provides an easy integration between creating content and delivering that content to your users. Content creators can use WebLogic Portal's repositories to create content and portal developers use the content API and JSP tools to deliver content to portal visitors.
Click to view, and use the magnifying tool to inspect individual tables in the logical entity-relation diagram for the content management tables.
Content Management Data Dictionary Tables
The Content Management system has the following tables:
In the CM_NODE table, a node represents an element in a hierarchy that can either be a "Hierarchy Node" or a "Content Node." A hierarchy node can contain both other hierarchy and content nodes while a content node can contain only other content nodes. Nodes can contain properties based on the ObjectClass (schema) defined for it.
Both Content Nodes and Hierarchy Nodes can contain an ObjectClass and properties. Each node has a path that uniquely identifies it within the repository.
Table 9-85 CM_NODE Table Metadata
Column Name
Data Type
Null Value
Description
New or Changed Version
NODE_ID
NUMBER
Not Null
PK - A unique, system-generated number to use as the record ID.
PARENT_NODE_ID
NUMBER
Null
FK - The node's parent record ID (NODE_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.
OBJECT_CLASS_ID
NUMBER
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
NUMBER
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
TIMESTAMP
Not Null
The date and time the row was created. Maintained by the application.
CM_MODIFIED_DATE
TIMESTAMP
Not Null
The date and time the row was last modified. Maintained by the application.
FULL_PATH
VARCHAR(882)
Null
AK - Each node has a path that uniquely identifies it within the repository.
The path is defined in a UNIX-like format such as /a/b/c where "/" is the root and "a" ("a" is the Nodes NODE_NAME) is the root's child.
The path must always begin with "/" and never end with it. So neither of the following are valid: a/b/c/d or /a/b/d/d/.
9.2
LIFECYCLE_STATUS
INTEGER
Null
The specific workflow status that the node version has been assigned:
WORKFLOW_ID
INTEGER
Null
FK - The Workflow ID associated with the node.
TITLE
VARCHAR(254)
Not Null
Applies only to a GroupSpace repository. Title for GroupSpace content, used for all GroupSpace content types.
DESCRIPTION
VARCHAR(254)
Null
Applies only to a GroupSpace repository. Description for GroupSpace content; can be used by all GroupSpace content types.
VISIBILITY
VARCHAR(254)
Not Null
Applies only to a GroupSpace repository. Scopes viewing of GroupSpace data; used for GroupSpace content types. Valid visibility values are:
Personal - only viewable by a specific user but viewable in all GroupSpace Communities
Private - only viewable by a specific user and only viewable in the GroupSpace Community in which it was created
Community - viewable by all users within a GroupSpace Community
OWNER
VARCHAR(254)
Not Null
Applies only to a GroupSpace repository. User who owns the GroupSpace content.
FEED_ENTRY_ PUBLICATION_DATE
TIMESTAMP
Not Null
Applies only to a GroupSpace repository. Date that a Feed Entry was published. This is used only by content of type Feed_Entry.
CM_COLLABORATION_API_METADATA Database Table
This table is used to store information about WebLogic Portal's collaboration portlets.
PK - A unique, system-generated number to use as the record ID.
9.2
ICONTAINER_SUBCONTAINER_ COUNT
INTEGER
Not Null
The number of shallow child containers for the current node.
9.2
IGWARE_CONTR_TOTAL_ITEM_ COUNT
INTEGER
Not Null
The number of shallow child items for the current node.
9.2
IGWARE_CONTR_UNREAD_ITEM_COUNT
INTEGER
Not Null
The number of shallow child items that are marked as UNREAD for the current node.
9.2
IFORUM_CATEGORY_FORUM_ COUNT
INTEGER
Not Null
The number of shallow forums beneath this category.
9.2
ITOPIC_SUPPRT_DEEP_TOPIC_ COUNT
INTEGER
Not Null
The number of topics, infinitely deep, below this node.
9.2
ITOPIC_SUPPRT_TOPIC_COUNT
INTEGER
Not Null
The number of shallow topics below this node.
9.2
CM_OBJECT_CLASS Database Table
The ObjectClass is the schema for a Node (a content type). It has both an ID and a name that uniquely identifies it within a content repository. An ObjectClass can have PropertyDefinitions associated with it that define the shape of Properties required for a Node. This does not mean that the Property must contain a value, but simply that the Property must exist for the Node.
The ObjectClass may have a primary PropertyDefinition that defines the primary content Property for a Node. This allows for the definition of content in the schema since the schema does not distinguish between content and meta-content. A Node is considered valid in the repository only if its Properties conform to its ObjectClass PropertyDefinitions.
Table 9-87 CM_OBJECT_CLASS Table Metadata
Column Name
Data Type
Null Value
Description
New or Changed Version
OBJECT_CLASS_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.
OBJECT_CLASS_NAME
VARCHAR(100)
Not Null
AK - A unique name for the object class.
PRIMARY_PROPERTY_ DEFINITION_ID
NUMBER
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
NUMBER
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
NUMBER
Not Null
A flag indicating if this property is searchable.
9.2
PARENT_OBJECT_CLASS_ID
INTEGER
Null
FK - The OBJECT_CLASS_ID of the parent type if this type is inheriting from a parent type.
9.2
PATH
VARCHAR(882)
Not Null
The string path of the object class. This will take the form of /object_class_name for most object classes. Those that use inheritance will take the form /parent/child or /grandparent/parent/child, and so on.
9.2
OBJECT_CLASS_DESCRIPTION
VARCHAR(254)
Null
Optional description for the content type.
9.2
WORKFLOW_ID
INTEGER
Null
The workflow ID associated with the type.
9.2
CM_PROPERTY Database Table
The CM_PROPERTY table identifies a property. The property consists of a name value pair; the name is unique relative to the CM_NODE, and the value is either a Date, BLOB, Boolean, Number, Float, or Varchar.
Only one value should be set on a given row; if the value is a BLOB, then all of the BLOB_ columns can be set. If the IS_MULTIVALUED column is set to 1, then there will be multiple rows with the same property name and same NODE_ID. A property can represent both the content and meta-content for a Node.
Table 9-88 CM_PROPERTY Table Metadata
Column Name
Data Type
Null Value
Description
New or Changed Version
PROPERTY_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.
NODE_ID
NUMBER
Not Null
FK - The ID of the node that contains the property.
PROPERTY_NAME
VARCHAR(894)
Not Null
The name of the property. It must be unique relative to its node.
FK - The ID of the property definition to which this property must conform.
BOOLEAN_VALUE
NUMBER
Null
True (1) for the Property if the PROPERTY_TYPE is Boolean (PROPERTY_TYPE=0).
DATETIME_VALUE
TIMESTAMP
Null
The datetime value for the property if the PROPERTY_TYPE is DATE (PROPERTY_TYPE=4).
LONG_VALUE
NUMBER
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
NUMBER
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
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 9-89 CM_PROPERTY_CHOICE Table Metadata
Column Name
Data Type
Null Value
Description
New or Changed Version
PROPERTY_CHOICE_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.
PROPERTY_DEFINITION_ID
NUMBER
Not Null
FK - The ID of the property definition that contains the property choice.
DEFAULT_PROPERTY
NUMBER
Not Null
Set to 1 if the property choice is a default, or 0 if it is not.
BOOLEAN_VALUE
NUMBER
Null
True (1) for the Property if the PROPERTY_TYPE is BOOLEAN (PROPERTY_TYPE=0).
DATETIME_VALUE
TIMESTAMP
Null
The date/time value for the Property if the PROPERTY_TYPE is DATE (PROPERTY_TYPE=4).
LONG_VALUE
NUMBER
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
NUMBER
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"
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 9-90 CM_PROPERTY_DEFINITION Table Metadata
Column Name
Data Type
Null Value
Description
New or Changed Version
PROPERTY_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.
OBJECT_CLASS_ID
NUMBER
Not Null
FK - The OBJECT_CLASS_ID of the property definitions CM_OBJECT_CLASS.
PROPERTY_NAME
VARCHAR(100)
Not Null
The name associated with the property definition. The combination of PROPERTY_NAME and OBJECT_ CLASS_ID for an Alternate Key for the CM_PROPERTY_DEFINITION table.
PROPERTY_TYPE
NUMBER
Not Null
The type of the property:
0 = Boolean 1 = Number 2 = Float 3 = Varchar 4 = Date 5 = BLOB
IS_MANDATORY
NUMBER
Not Null
True if the value of a property must be set.
IS_READ_ONLY
NUMBER
Not Null
True if the value of a property should not be set by an end user.
IS_RESTRICTED
NUMBER
Not Null
True if the value of a property should come from the property choice values.
IS_MULTI_VALUED
NUMBER
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
NUMBER
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
NUMBER
Not Null
The type of the property definition. Native definitions are defined on the containing object class. Inherited definitions are populated through type inheritance, and overridden definitions are also populated through type inheritance, but changed by the inheriting (child) type. Possible values are:
FK - The OBJECT_CLASS_ID of the nested type. An object class can "nest" the set of definitions as defined by another object class.
9.2
CM_WORKFLOW Table
This table was added in WebLogic Portal version 9.2. It stores information for the Content Management workflow.
Table 9-91 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
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
WORKFLOW_COMMENT
VARCHAR(254)
Null
Optional comment for the workflow.
9.2
Content Management Virtual Database Objects
The BEA repository provides automatic versioning.
Click to view, and use the magnifying tool to inspect individual tables in the logical entity-relation diagram for Virtual Content Repository (versioning) object tables.
Content Management Virtual Object Data Dictionary Tables
The Content Management system has the following tables for virtual objects:
This table uniquely identifies a content-managed node from a BEA repository (that is, CM_NODE table) that has been versioned and is being edited within the Content Management Virtual Repository.
Table 9-92 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
NUMBER
Not Null
Flag to determine if the record is locked.
OBJECT_CLASS_ID
VARCHAR (254)
Null
The object class ID that is associated with the node.
ASSIGNED_TO_USER_NAME
VARCHAR(200)
Null
Username to which the node is assigned.
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 9-93 CMV_NODE_ASSIGNED_ROLE Table
Column Name
Data Type
Null Value
Description
NODE_ID
VARCHAR(254)
Not Null
PK/FK - The ID of the node that roles are associated with. Foreign key relationship to CMV_NODE table.
ROLE_NAME
VARCHAR(254)
Not Null
PK - The name of the role.
CMV_NODE_VERSION Table
This table uniquely identifies all the versions of a mode within the Virtual Content Repository.
Table 9-94 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
TIMESTAMP
Not Null
Time the node version was last edited.
MODIFIED_BY
VARCHAR(100)
Not Null
Username of the person who last edited the node version.
VERSION_COMMENT
VARCHAR(254)
Not Null
Comment added to a node version when saving.
LIFECYCLE_STATUS
INTEGER
Null
Specific life cycle status that the node version has been assigned (for example, In Progress, Published, and so on).
CMV_PROPERTY Table
This table uniquely identifies a property that can be associated with a node version. For example, some properties of a book might be author, title, and subject.
Table 9-95 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
TIMESTAMP
Not Null
The date and time the row was created; the default is the current timestamp.
MODIFIED_DATE
TIMESTAMP
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
NUMBER
Not Null
The type of the property:
0 = Boolean 1 = Number 2 = Float 3 = Varchar 4 = Date 5 = BLOB
CMV_VALUE Table
This table uniquely identifies a value for a given property. For example, a property SUBJECT for a BOOK might have a value of FINANCE.
Only one value is set on a given record. If the value is BLOB, then all the BLOB_ columns can be set.
Table 9-96 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
TIMESTAMP
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
TIMESTAMP
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
NUMBER
Not Null
Flag to determine if property is a Boolean value: 1= True, 0 = False.
DATETIME_VALUE
TIMESTAMP
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
CMV_NODE_VERSION_PROPERTY Table
This table uniquely identifies a relationship between a CMV_NODE_VERSION and CMV_PROPERTY.
Table 9-97 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.
