|
|
WebLogic Personalization Server Schema
This chapter documents the database schema for the WebLogic Personalization Server and includes the following sections:
The Entity-Relationship Diagram
The following figures comprise the Entity-Relationship Diagram (ERD) for the WebLogic Personalization Server database.
The Tables Comprising the WebLogic Personalization Server
The WebLogic Personalization Server is comprised of the following tables. In this list, the tables are sorted by functionality:
Documentation Management tables:
Portal Management tables:
Rule Editor table:
User Management tables:
Tables used in the Sample Portal Application:
Common tables used by both WLPS and WLCS:
The Schema Tables
In this section, the WebLogic Personalization Server schema tables are arranged alphabetically as a data dictionary.
Note: Even though the following documentation references "foreign keys" to various tables, these constraints do not currently exist in this release of WebLogic Personalization Server. However, they will be (available in future releases) in place in future versions of WebLogic Personalization Server and we want you to be aware of these relationships now.
Table 9-1 describes the WLCS_BOOKMARKS table. This table is used by the Example portal and is not used except for demonstration purposes. It contains information used in the Bookmark portlet.
The Primary Key is comprised of NAME and OWNER.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
URL |
VARCHAR2(50) |
The URL of the bookmark. |
NAME |
VARCHAR2(150) |
The name of the bookmark. |
OWNER |
VARCHAR2(150) |
The owner of the bookmark. |
Table 9-2 describes the WLCS_CATEGORIES table. This table is used to store category information for the portal portion of the WebLogic Personalization Server application.
Note: The CATEGORY feature has not been implemented at this time and, therefore, this table is not being used/populated.
The Primary Key is NID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
NID |
NUMBER(15) |
Category identifier. |
PORTAL_NID |
NUMBER(15) |
The Portal identifier. This column is a foreign key to the NID column of the WLCS_PORTAL_DEFINITION table. |
NAME |
VARCHAR2(100) |
The name for the category. |
ICON_URL |
VARCHAR2(100) |
The URL pointing to the icon associated with the category. This may be null. |
CATEGORY_ORDER |
NUMBER(5) |
The sequence number identifying the order of display. |
Table 9-3 describes the WLCS_COLUMN_INFORMATION table. This table is used to store column definition information for each portal and category.
The Primary Key is comprised of PORTAL_NID, CATEGORY_NID and COLUMN_ORDER.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PORTAL_NID |
NUMBER(15) |
The Portal identifier. This column is a foreign key to the NID column of the WLCS_PORTAL_DEFINITION table. |
CATEGORY_NID |
NUMBER(15) |
The Category identifier. |
COLUMN_WIDTH |
NUMBER(5) |
The value entered here is a percentage of the screen width. An example would be 30. This represents how wide this particular portal column is to be (30% of the screen). |
COLUMN_ORDER |
NUMBER(5) |
A sequence number identifying the display sequence for this column. Starting at the left-most part of the screen the COLUMN_ORDER would be 1. |
Table 9-4 describes the WLCS_DOCUMENT table. This table is used to store information pertinent to each document used within the WebLogic Personalization Server.
The Primary Key is ID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
ID |
VARCHAR2(500) |
The identifier of the document. This specifies the relative path (case sensitive using forward slashes) to the actual file. |
DOCUMENT_SIZE |
NUMBER(15) |
The size of the document in bytes. |
VERSION |
NUMBER(15) |
The version of the document. |
AUTHOR |
VARCHAR2(50) |
The author's name of this document. |
CREATION_DATE |
DATE |
The date this document was created in the system. |
LOCKED_BY |
VARCHAR2(50) |
This column identifies who has this document locked for edits or updates. |
MODIFIED_DATE |
DATE |
This tells you when this document record was last modified. |
MODIFIED_BY |
VARCHAR2(50) |
This column stores the name of the individual who last modified the document record. |
DESCRIPTION |
VARCHAR2(50) |
A description of the document. |
COMMENTS |
VARCHAR2(50) |
An area to store miscellaneous notes about the document. |
MIME_TYPE |
VARCHAR2(100) |
This column identifies which MIME type (or file type) is associated with this document. This is supposed to be MIME 1.0. |
Table 9-5 describes the WLCS_DOCUMENT_METADATA table. This table is used to store user-defined properties associated with each document.
The Primary Key is ID and NAME.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
ID |
VARCHAR2(500) |
The document identifier. This is a foreign key to the ID column of the WLCS_DOCUMENT table. |
NAME |
VARCHAR2(240) |
The metadata name. |
VALUE |
VARCHAR2(2000) |
The value to be associated with the metadata name (NAME). |
STATE |
VARCHAR2(50) |
The current state of this metadata property. This is used by Interwoven and can be set to null. |
Table 9-6 describes the WLCS_ENTITY_ID table. Any ConfigurableEntity within the system will have an entry in this table.
The Primary Key is comprised of JNDI_HOME_NAME and PK_STRING.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
JNDI_HOME_NAME |
VARCHAR2(100) |
Defines what type of ConfigurableEntity this is. |
PK_STRING |
VARCHAR2(200) |
Unique identifier within the ConfigurableEntity. |
ENTITY_ID |
NUMBER(15) |
A sequence-generated number providing a unique identifier used throughout the system (in the Property tables and so on). |
Table 9-7 describes the WLCS_GROUPS table. This table is used to maintain each of the various Group identifiers.
The Primary Key is comprised of IDENTIFIER.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
IDENTIFIER |
VARCHAR2(50) |
The group name. This column is a foreign key to the PK_STRING column in the WLCS_ENTITY_ID table. |
Table 9-8 describes the WLCS_GROUP_HIERARCHY table. This table stores relationship information between groups.
The Primary Key is comprised of PARENT_ID and CHILD_ID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PARENT_ID |
NUMBER(15) |
The parent group identifier. This column is a foreign key to the ENTITY_ID column in the WLCS_ENTITY_ID table. |
CHILD_ID |
NUMBER(15) |
The child group identifier. This column is a foreign key to the ENTITY_ID column in the WLCS_ENTITY_ID table. |
Table 9-9 describes the WLCS_GROUP_PERSONALIZATION table. Portals can be associated to groups and this table helps establish those relationships and maintain specific information for the group.
The Primary Key is comprised of PORTAL_NID, CATEGORY_NID, PORTLET_NID and GROUP_NID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PORTAL_NID |
NUMBER(15) |
The portal identifier. This column is a foreign key to the NID column of the WLCS_PORTAL_DEFINITION table. |
CATEGORY_NID |
NUMBER(15) |
The category identifier. This column is a foreign key to the NID column of the WLCS_CATEGORIES table. |
PORTLET_NID |
NUMBER(15) |
The portlet identifier. This column is a foreign key to the NID column of the WLCS_PORTLET_DEFINITION table. |
GROUP_NID |
NUMBER(15) |
The group identifier. This column is a foreign key to the ENTITY_ID column of the WLCS_ENTITY_ID table. |
AVAILABLE |
NUMBER(5) |
A switch to identify whether or not this portlet is available. |
MANDATORY |
NUMBER(5) |
This flag, when set, overrides the VISIBLE flag and requires the portlet be displayed. |
EDITABLE |
NUMBER(5) |
This flag determines whether a user is allowed to edit any content. |
MOVEABLE |
NUMBER(5) |
This column is not being used. |
MINIMIZEABLE |
NUMBER(5) |
This flag determines whether or not the user will be allowed to minimize the portlet. |
MAXIMIZEABLE |
NUMBER(5) |
This flag determines whether or not the user will be allowed to maximize the portlet. |
FLOATABLE |
NUMBER(5) |
This flag determines whether the portlet can open up in its own browser window. |
VISIBLE |
NUMBER(5) |
This flag determines whether or not the portlet is visible. |
X |
NUMBER(5) |
The X coordinate determines the placement of the portlet on the screen. This is zero based and refers to the column placement (0=column 1, 1=column 2 and so on). |
Y |
NUMBER(5) |
The Y coordinate determines placement of the portlet on the screen. Like the X coordinate, it is zero based. The Y coordinate refers to the row placement (0=row 1, 1=row 2 and so on). |
MINIMIZED |
NUMBER(5) |
This flag determines whether or not the portlet should be displayed in a minimized format when initially displayed. |
Table 9-10 describes the WLCS_IS_ALIVE table. This table is used by the JDBC connection pools to insure the connection to the database is still alive.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
NAME |
VARCHAR2(100) |
Used by the JDBC connection pools to insure the connection to the database is still alive. |
Table 9-11 describes the WLCS_LDAP_CONFIG table. This table holds configuration information for LDAP functionality within the User Management module.
The Primary Key is LDAP_PROPERTY.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
LDAP_PROPERTY |
VARCHAR2(100) |
The property name. |
LDAP_VALUE |
VARCHAR2(255) |
The property value. |
Table 9-12 describes the WLCS_PORTAL_DEFINITION table.
The Primary Key is NID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
NID |
NUMBER(15) |
The identifier for the portal definition. |
NAME |
VARCHAR2(500) |
The name of the portal definition. Any combination of numbers and letters will be accepted in this field. |
HEADER_URL |
VARCHAR2(500) |
Enter a URL to display as the portal header. It can be a JSP or HTML fragment. |
CONTENT_URL |
VARCHAR2(500) |
Enter a URL relative to your portal working directory. |
FOOTER_URL |
VARCHAR2(500) |
Enter a URL to display as the portal footer. It can be a JSP or HTML fragment. |
CONTENT_COLUMN_COUNT |
NUMBER(5) |
Specifies the number of content columns. Valid values at this time would be 1, 2, or 3. |
SUSPENDED |
NUMBER(5) |
Set this flag to suspend the portal application and replace the portal home page with an "under maintenance" screen until service resumes. |
SUSPENDED_URL |
VARCHAR2(500) |
When the SUSPENDED flag is set this URL will point to the JSP page to be displayed while the application is in suspend mode. |
Table 9-13 describes the WLCS_PORTAL_GROUP_HIERARCHY table. This table maintains records showing which groups are associated with each portal.
The Primary Key is comprised of PORTAL_NID and GROUP_NID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PORTAL_NID |
NUMBER(15) |
The portal identifier. This column is a foreign key to the NID column of the WLCS_PORTAL_DEFINITION table. |
GROUP_NID |
NUMBER(15) |
The group identifier. This column is a foreign key to the ENTITY_ID column of the WLCS_ENTITY_ID table. |
Table 9-14 describes the WLCS_PORTAL_HIERARCHY table. This table contains records showing which portlets are associated with each portal.
The Primary Key is comprised of PORTAL_NID and PORTLET_NID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PORTAL_NID |
NUMBER(15) |
The portal identifier. This column is a foreign key to the NID column of the WLCS_PORTAL_DEFINITION table. |
PORTLET_NID |
NUMBER(15) |
The portlet identifier. This column is a foreign key to the NID column of the WLCS_PORTLET_DEFINITION table. |
Table 9-15 describes the WLCS_PORTAL_PERSONALIZATION table. This table maintains information pertinent to each personalized portal definition.
The Primary Key is comprised of PORTAL_NID, CATEGORY_NID and PORTLET_NID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PORTAL_NID |
NUMBER(15) |
The portal identifier. This column is a foreign key to the NID column of the WLCS_PORTAL_DEFINITION table. |
CATEGORY_NID |
NUMBER(15) |
The category identifier. This column is a foreign key to the NID column of the WLCS_CATEGORIES table. |
PORTLET_NID |
NUMBER(15) |
The portlet identifier. This column is a foreign key to the NID column of the WLCS_PORTLET_DEFINITION table. |
AVAILABLE |
NUMBER(5) |
This flag, when set, overrides the VISIBLE flag and requires the portlet be displayed. 0 equates to FALSE and 1 equates to TRUE. |
EDITABLE |
NUMBER(5) |
This flag determines whether a user is allowed to edit the content of the portal. 0 equates to FALSE and 1 equates to TRUE. |
MOVEABLE |
NUMBER(5) |
This column is not being used. 0 equates to FALSE and 1 equates to TRUE. |
MINIMIZEABLE |
NUMBER(5) |
This flag determines whether or not the user will be allowed to minimize the portlet. 0 equates to FALSE and 1 equates to TRUE. |
MAXIMIZEABLE |
NUMBER(5) |
This flag determines whether or not the user will be allowed to maximize the portlet. 0 equates to FALSE and 1 equates to TRUE. |
FLOATABLE |
NUMBER(5) |
This flag determines whether the portlet can open up in its own browser window. 0 equates to FALSE and 1 equates to TRUE. |
VISIBLE |
NUMBER(5) |
This flag determines whether or not the portlet is visible. 0 equates to FALSE and 1 equates to TRUE. |
X |
NUMBER(5) |
The X coordinate determines the placement of the portlet on the screen. This is zero based and refers to the column placement (0=column 1, 1=column 2 and so on). |
Y |
NUMBER(5) |
The Y coordinate determines placement of the portlet on the screen. Like the X coordinate, it is zero based. The Y coordinate refers to the row placement (0=row 1, 1=row 2 and so on). |
MINIMIZED |
NUMBER(5) |
This flag determines whether or not the portlet should be displayed in a minimized format when displayed initially. 0 equates to FALSE and 1 equates to TRUE. |
Table 9-16 describes the WLCS_PORTLET_DEFINITION table. This table maintains information pertinent to each portlet definition.
The Primary Key is comprised of NID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
NID |
NUMBER(15) |
The portlet identifier. |
NAME |
VARCHAR2(500) |
The name of your portlet. Any combination of numbers and letters will be accepted in this field. |
HEADER_URL |
VARCHAR2(500) |
Enter a URL to display as the portlet header. It can be a JSP or HTML fragment. |
FOOTER_URL |
VARCHAR2(500) |
Enter a URL to display as the portlet footer. It can be a JSP or HTML fragment. |
CONTENT_URL |
VARCHAR2(500) |
Enter a URL relative to your portal working directory. |
BANNER_URL |
VARCHAR2(500) |
Enter a URL to display as the portlet banner under the portlet titlebar. It can be a JSP or HTML fragment. |
ALTERNATE_HEADER_URL |
VARCHAR2(500) |
Enter a URL to display as a Web page header when the portlet is floated or maximized. If this is null, the portal framework uses a default called alternateheader.jsp. |
ALTERNATE_FOOTER_URL |
VARCHAR2(500) |
Enter a URL to display as a Web page footer when the portlet is floated or maximized. If this is null, the portal framework uses a default called alternatefooter.jsp. |
TITLEBAR_URL |
VARCHAR2(500) |
Enter a URL to display as the portlet titlebar. It can be a JSP or HTML fragment. |
EDIT_URL |
VARCHAR2(500) |
If the EDITABLE flag has been set then a URL will be stored here that enables the user to edit the portlet content. |
HELP_URL |
VARCHAR2(500) |
If the HELP flag has been set then a URL must be specified that opens a help topic related to the portlet. |
ICON_URL |
VARCHAR2(500) |
A URL to display an icon (GIF) on the left side of the portlet title bar. This image should be 27 pixels wide by 20 pixels high with 2 pixels of transparency on the right. |
HELP |
NUMBER(5) |
This flag determines whether users can access a help screen in the portlet. If set, a Help icon displays in the portlet titlebar. |
MAXIMIZED_URL |
VARCHAR2(500) |
A URL for the content area of the maximized page. The default URL is your portlet content area URL. |
MANDATORY |
NUMBER(5) |
This flag, when set, overrides the VISIBLE flag and requires the portlet be displayed. 0 equates to FALSE and 1 equates to TRUE. |
EDITABLE |
NUMBER(5) |
This flag determines whether a user is allowed to edit the content of a portlet. 0 equates to FALSE and 1 equates to TRUE. |
MOVEABLE |
NUMBER(5) |
This column is not being used. 0 equates to FALSE and 1 equates to TRUE. |
LOGIN_REQUIRED |
NUMBER(5) |
This flag determines whether or not security is required for access to the portlet. 0 equates to FALSE and 1 equates to TRUE. |
MINIMIZEABLE |
NUMBER(5) |
This flag determines whether or not the user will be allowed to minimize the portlet. 0 equates to FALSE and 1 equates to TRUE. |
MAXIMIZEABLE |
NUMBER(5) |
This flag determines whether or not the user will be allowed to maximize the portlet. 0 equates to FALSE and 1 equates to TRUE. |
FLOATABLE |
NUMBER(5) |
This flag determines whether the portlet can open up in its own browser window. 0 equates to FALSE and 1 equates to TRUE. |
VISIBLE |
NUMBER(5) |
This flag determines whether or not the portlet is visible. 0 equates to FALSE and 1 equates to TRUE. |
X |
NUMBER(5) |
The X coordinate determines the placement of the portlet on the screen. This is zero based and refers to the column placement (0=column 1, 1=column 2 and so on). |
Y |
NUMBER(5) |
The Y coordinate determines placement of the portlet on the screen. Like the X coordinate, it is zero based. The Y coordinate refers to the row placement (0=row 1, 1=row 2 and so on). |
MINIMIZED |
NUMBER(5) |
This flag determines whether or not the portlet should be displayed in a minimized format when displayed initially. 0 equates to FALSE and 1 equates to TRUE. |
Table 9-17 describes the WLCS_PROP_BOOLEAN table. This table stores property values for boolean properties.
The Primary Key is PROPERTY_ID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PROPERTY_ID |
NUMBER(15) |
The identifier for each boolean property. |
VALUE |
NUMBER(3) |
The value for each boolean property identifier. |
Table 9-18 describes the WLCS_PROP_DATETIME table. This table stores property values for date and time properties.
The Primary Key is PROPERTY_ID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PROPERTY_ID |
NUMBER(15) |
The identifier for each date and time property. |
VALUE |
DATE |
The value for each data and time property identifier. |
Table 9-19 describes the WLCS_PROP_FLOAT table. This table stores property values for float properties.
The Primary Key is PROPERTY_ID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PROPERTY_ID |
NUMBER(15) |
The identifier for each float property. |
VALUE |
NUMBER |
The value associated with each float property identifier. |
Table 9-20 describes the WLCS_PROP_ID table. Any property assigned to a ConfigurableEntity has a unique PROPERTY_ID. This identifier and associated information is stored here.
The Primary Key is ENTITY_ID, PROPERTY_NAME and SCOPE_NAME.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
ENTITY_ID |
NUMBER(15) |
A system generated value and foreign key to the WLCS_ENTITY_ID column. |
SCOPE_NAME |
VARCHAR2(100) |
This column may be null. If this property is defined in a property set, then the SCOPE_NAME will match the SCHEMA_NAME for that property set in the WLCS_SCHEMA table. |
PROPERTY_NAME |
VARCHAR2(100) |
The name of the property. |
PROPERTY_TYPE |
NUMBER(3) |
This column identifies the type of property we are dealing with (for example, boolean, integer, float, text, and so on). |
PROPERTY_META_DATA_ID |
NUMBER(15) |
The identifier for the Property metadata information. Again, we use the PROPERTY_TYPE column to identify which type of Property metadata we are looking at (for example, boolean, integer, and so on). |
SCHEMA_HAS_CHANGED |
NUMBER(3) |
A flag informing to identify whether anything in the WLCS_SCHEMA or WLCS_PROP_MD_xxx tables has changed. If so, then certain cleanup activities must be performed prior to using this property next time. |
PROPERTY_ID |
NUMBER(15) |
The property identifier is a unique system generated number. |
Table 9-21 describes the WLCS_PROP_INTEGER table. This table stores property values for integer properties.
The Primary Key is PROPERTY_ID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PROPERTY_ID |
NUMBER(15) |
The identifier of the integer property. |
VALUE |
NUMBER(20) |
The value associated with the integer property. |
Table 9-22 describes the WLCS_PROP_MD table. This table stores information about defined properties in a property set.
The Primary Key is SCHEMA_ID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
SCHEMA_ID |
NUMBER(15) |
A foreign key to the WLCS_SCHEMA table. |
PROPERTY_NAME |
VARCHAR2(100) |
The name of a property. |
DESCRIPTION |
VARCHAR2(255) |
A description of the property. |
IS_RESTRICTED |
NUMBER(3) |
If set TRUE, the value of the property is constrained to a set of values. 0 equates to FALSE and 1 equates to TRUE. |
IS_EXPLICIT |
NUMBER(3) |
If set TRUE, the property value may be coming from an external source. 0 equates to FALSE and 1 equates to TRUE. |
IS_MULTIVALUED |
NUMBER(3) |
Some properties may have more than one value. 0 equates to FALSE and 1 equates to TRUE. |
PROPERTY_TYPE |
NUMBER(3) |
Defines the property type (boolean, text and so on). |
PROPERTY_META_DATA_ID |
NUMBER(15) |
The primary key is a unique, system-generated value. |
Table 9-23 describes the WLCS_PROP_MD_BOOLEAN table. This table stores property set definitions for the boolean property type.
The Primary Key is PROPERTY_META_DATA_ID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PROPERTY_META_DATA_ID |
NUMBER(15) |
A unique identifier for this Property metadata and foreign key to the WLCS_PROP_MD table. |
VALUE |
NUMBER(3) |
The value associated with the Property metadata. |
IS_DEFAULT |
NUMBER(3) |
This flag tells us whether or not the VALUE column is the default value for this piece of Property metadata. 0 equates to FALSE and 1 equates to TRUE. |
Table 9-24 describes the WLCS_PROP_MD_DATETIME table. This table stores property set definitions for the date and time property type.
The Primary Key is PROPERTY_META_DATA_ID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PROPERTY_META_DATA_ID |
NUMBER(20) |
A unique identifier for this Property metadata. |
VALUE |
DATE |
The value associated with the Property metadata. |
IS_DEFAULT |
NUMBER(3) |
This flag tells us whether or not the VALUE column is the default value for this piece of Property metadata. 0 equates to FALSE and 1 equates to TRUE. |
Table 9-25 describes the WLCS_PROP_MD_FLOAT table. This table stores property set definitions for the float property type.
The Primary Key is PROPERTY_META_DATA_ID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PROPERTY_META_DATA_ID |
NUMBER(15) |
A unique identifier for this Property metadata. |
VALUE |
NUMBER |
The value associated with the Property metadata. |
IS_DEFAULT |
NUMBER(3) |
This flag tells us whether or not the VALUE column is the default value for this piece of Property metadata. 0 equates to FALSE and 1 equates to TRUE. |
Table 9-26 describes the WLCS_PROP_MD_INTEGER table. This table stores property set definitions for the Integer property type.
The Primary Key is PROPERTY_META_DATA_ID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PROPERTY_META_DATA_ID |
NUMBER(15) |
A unique identifier for this Property metadata. |
VALUE |
NUMBER(20) |
The value associated with the Property metadata. |
IS_DEFAULT |
NUMBER(3) |
This flag tells us whether or not the VALUE column is the default value for this piece of Property metadata. 0 equates to FALSE and 1 equates to TRUE. |
Table 9-27 describes the WLCS_PROP_MD_TEXT table. This table stores property set definitions for the text property type.
The Primary Key is PROPERTY_META_DATA_ID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PROPERTY_META_DATA_ID |
NUMBER(15) |
A unique identifier for this Property metadata. |
VALUE |
VARCHAR2(255) |
The value associated with the Property metadata. |
IS_DEFAULT |
NUMBER(3) |
This flag tells us whether or not the VALUE column is the default value for this piece of Property metadata. 0 equates to FALSE and 1 equates to TRUE. |
Table 9-28 describes the WLCS_PROP_MD_USER_DEFINED table. This table stores property set definitions for any user defined property type.
The Primary Key is PROPERTY_META_DATA_ID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PROPERTY_META_DATA_ID |
NUMBER(15) |
A unique identifier for this Property metadata. |
VALUE |
BLOB |
The value associated with the Property metadata. |
IS_DEFAULT |
NUMBER(3) |
This flag tells us whether or not the VALUE column is the default value for this piece of Property metadata. 0 equates to FALSE and 1 equates to TRUE. |
Table 9-29 describes the WLCS_PROP_TEXT table. This table stores property values for the text for the text property type.
The Primary Key is PROPERTY_ID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PROPERTY_ID |
NUMBER(15) |
The identifier of the text property. |
VALUE |
VARCHAR2(255) |
The value associated with the text property. |
Table 9-30 describes the WLCS_PROP_USER_DEFINED table. This table stores property values for any user-defined property type.
The Primary Key is PROPERTY_ID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PROPERTY_ID |
NUMBER(15) |
The identifier of the user-defined property. |
VALUE |
BLOB |
The value associated with the user-defined property. |
Table 9-31 describes the WLCS_RULESET_DEFINITION table. This table contains all rule sets.
The Primary Key is NAME.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
NAME |
VARCHAR2(50) |
The identifier, or name, of the rule set. |
DOCUMENT |
BLOB |
The XML document containing the rule set definition. |
Table 9-32 describes the WLCS_SCHEMA table. This table stores property set definitions.
The Primary Key is comprised of SCHEMA_GROUP_NAME and SCOPE_NAME.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
SCHEMA_GROUP_NAME |
VARCHAR2(100) |
The type of object this schema is used for. |
SCOPE_NAME |
VARCHAR2(100) |
The application name since it is defining names for the application. |
DESCRIPTION |
VARCHAR2(255) |
A description of the schema. |
SCHEMA_ID |
NUMBER(15) |
A system generated number used throughout the application. |
Table 9-33 describes the WLCS_SEQUENCER table. The WLCS_SEQUENCER table is used to maintain all of the sequence identifiers (for example, property_meta_data_id_sequence, and so on) used in the application.
The Primary Key is SEQUENCE_NAME.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
SEQUENCE_NAME |
VARCHAR2(50) |
A unique name used to identify the sequence. |
CURRENT_VALUE |
NUMBER(15) |
The current value of the sequence. |
Table 9-34 describes the WLCS_TODO table. This table is used by the Example portal and is not used except for demonstration purposes. It contains information used in the To Do portlet.
The Primary Key is ITEM and OWNER.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
ITEM |
VARCHAR2(50) |
The activity to be accomplished. |
DONE |
NUMBER(5) |
The status identifying whether this item has been completed. |
PRIORITY |
NUMBER(5) |
The priority of the activity. |
OWNER |
VARCHAR2(150) |
The individual who owns, or is responsible, for this activity. |
Table 9-35 describes the WLCS_UIDS table. This table stores sequence information in a generic database independent format.
The Primary Key is SID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
SID |
VARCHAR2(100) |
The name of the sequence. |
NEXT_SEQUENCE |
NUMBER(15) |
The next value available for use with the sequence. |
Table 9-36 describes the WLCS_UNIFIED_PROFILE_TYPE table. This table allows registration of classes which extend the ProvidedUser class.
The Primary Key is TYPE_NAME.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
TYPE_NAME |
VARCHAR2(100) |
Any unique name used for easy lookup. |
CLASS_NAME |
VARCHAR2(100) |
The name of the remote interface class. |
HOME |
VARCHAR2(100) |
The name of the home class. |
PK |
VARCHAR2(100) |
The name of the primary key class. |
JNDI_NAME |
VARCHAR2(100) |
The name to look up in the JNDI tree. |
SUCCESSOR |
VARCHAR2(100) |
This column allows you to define another class should the TYPE_NAME not exist. This column is a foreign key to TYPE_NAME of the WLCS_UNIFIED_PROFILE_TYPE table. |
Table 9-37 describes the WLCS_USER table. This table stores all user login/password combinations.
The Primary Key is IDENTIFIER.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
IDENTIFIER |
VARCHAR2(50) |
The user login. This column is a foreign key to the PK_STRING column of the WLCS_ENTITY_ID table. |
PASSWORD |
VARCHAR2(50) |
The encrypted password. |
IS_EXTERNAL |
NUMBER(3) |
This flag determines whether a user came from an external realm as opposed to the internal database realm. |
PROFILE_TYPE |
VARCHAR2(100) |
A foreign key to the TYPE_NAME in the WLCS_UNIFIED_PROFILE_TYPE table. |
Table 9-38 describes the WLCS_USER_GROUP_HIERARCHY table. This table allows you to store associated users and groups.
The Primary Key is comprised of USER_ID and GROUP_ID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
USER_ID |
NUMBER(15) |
The ENTITY_ID of a user. This column is a foreign key to the USER_ID column of the WLCS_ENTITY_ID table. |
GROUP_ID |
NUMBER(15) |
The ENTITY_ID of a group. This column is a foreign key to the USER_ID column of the WLCS_ENTITY_ID table. |
Table 9-39 describes the WLCS_USER_PERSONALIZATION table.This table contains personalized portal information for the user.
The Primary Key is comprised of PORTAL_NID, CATEGORY_NID, GROUP_NID, USER_NID and PORTLET_NID.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
PORTAL_NID |
NUMBER(15) |
The portal identifier. This column is a foreign key to the NID column of the WLCS_PORTAL_DEFINITION table. |
CATEGORY_NID |
NUMBER(15) |
The category identifier. This column is a foreign key to the NID column of the WLCS_CATEGORIES table. |
GROUP_NID |
NUMBER(15) |
The group identifier. This column is a foreign key to the ENTITY_ID column of the WLCS_ENTITY_ID table. |
USER_NID |
NUMBER(15) |
The user identifier. This column is a foreign key to the ENTITY_ID column of the WLCS_ENTITY_ID table. |
PORTLET_NID |
NUMBER(15) |
The portlet identifier. This column is a foreign key to the NID column of the WLCS_PORTLET table. |
VISIBLE |
NUMBER(5) |
This flag determines whether or not the portlet is visible. 0 equates to FALSE and 1 equates to TRUE. |
X |
NUMBER(5) |
The X coordinate determines the placement of the portlet on the screen. This is zero based and refers to the column placement (0=column 1, 1=column 2 and so on). |
Y |
NUMBER(5) |
The Y coordinate determines placement of the portlet on the screen. Like the X coordinate, it is zero based. The Y coordinate refers to the row placement (0=row 1, 1=row 2 and so on). |
MINIMIZED |
NUMBER(5) |
This flag determines whether or not the portlet should be displayed in a minimized format when displayed initially. 0 equates to FALSE and 1 equates to TRUE. |
Table 9-40 describes the WLCS_UUP_EXAMPLE table. This is an example of how to use the Unified Profile Types.
The Primary Key is NAME.
Column Name |
Data Type |
Description and Recommendations |
---|---|---|
NAME |
VARCHAR2(100) |
A username. |
POINTS |
NUMBER(15) |
A point accumulator based on various actions taken by the user. |
The SQL Scripts Used to Create the Database
WebLogic Personalization Server is installed as part of the WebLogic Commerce Server installation. If you install WebLogic Commerce Server into an NT environment and accept the defaults, you will have a directory path that looks like this:
C:\WebLogicCommerce\
Under this main directory you will find a database directory:
C:\WebLogicCommerce\db\
Under the database directory you will find several directories for each database currently supported:
At this particular level, you will find scripts which are common to both WebLogic Commerce Server and WebLogic Personalization Server.
Create-all-oracle.sql |
This script executes all of the Oracle scripts. It will create tables, indexes, constraints and populate tables as well. |
Create-common-oracle.sql |
This script creates tables, indexes, and constraints common to both servers (WebLogic Commerce Server andWebLogic Personalization Server). |
Create-wlcs-oracle.sql |
This script calls all of the appropriate scripts used to build and populate theWebLogic Commerce Server database. |
Create-wlps-oracle.sql |
This script calls all of the appropriate scripts used to build and populate the WebLogic Personalization Server database. |
Insert-common-oracle.sql |
This script populates the common tables used by both servers (WebLogic Commerce Server and WebLogic Personalization Server). |
Finally, under each database directory you will also find a WLCS and a WLPS directory:
For example, under the Oracle database directory you would find:
C:\WebLogicCommerce\db\oracle\wlcs
C:\WebLogicCommerce\db\oracle\wlps
These directories contain scripts which are specific to the individual server (WebLogic Commerce Server and WebLogic Personalization Server).
Under C:\WebLogicCommerce\db\oracle\wlcs you will find the scripts listed in Table 9-42.
Create-catalog-oracle.sql |
Creates tables, indexes and constraints related to the Catalog portion of the WebLogic Commerce Server. |
Create-order-oracle.sql |
Creates tables, indexes and constraints related to the Order Management portion of the WebLogic Commerce Server. |
Insert-catalog-data-oracle.sql |
Populates the Catalog portion of the WebLogic Commerce Server database with preliminary data. |
Insert-order-data-oracle.sql |
Populates the Order Management portion of the WebLogic Commerce Server database with preliminary data. |
Insert-wlcs-common-oracle.sql |
Populates the database with preliminary data in the tables shared by both the Catalog and Order Management pieces of the WebLogic Commerce Server. |
Under C:\WebLogicCommerce\db\oracle\wlps you will find the scripts listed in Table 9-43:
Create-app-oracle.sql |
Creates tables associated with the example application. |
Create-document-oracle.sql |
Creates tables, indexes and constraints associated with the Document Management portion of the WebLogic Personalization Server. |
Create-portal-oracle.sql |
Creates tables, indexes and constraints associated with the Portal Management portion of the WebLogic Personalization Server. |
Create-ruleeditor-oracle.sql |
Creates the tables associated with the Rule Set Engine portion of the WebLogic Personalization Server. |
Insert-pzsamples-oracle.sql |
Populates the WebLogic Personalization Server database with preliminary data. |
|
Copyright © 2000 BEA Systems, Inc. All rights reserved.
|