Portal Management Database Schema

 

This topic documents the database schema for the WebLogic Portal package. This topic includes the following sections:

• The Entity-Relation Diagram

• List of Tables Comprising the Portal Management Package

• The Portal Management Data Dictionary

• The SQL Scripts Used to Create the Database

• Defined Constraints

 

---

The Entity-Relation Diagram

Figure 7-1 shows the logical Entity-Relation diagram for the WebLogic Commerce Server Portal and Portlet tables in the Commerce database. See the subsequent sections in this chapter for information about the data type syntax.

Figure 7-1 Entity-Relation Diagram for the Portal and Portlet Tables

 
 

Figure 7-2 lists the tables used for the example portal.

Figure 7-2 Tables Used for the Sample Portal

 

 

---

List of Tables Comprising the Portal Management Package

Portal Management tables:

The LAYOUT Database Table

The PORTAL Database Table

The PORTAL_P13N Database Table

The PORTAL_P13N_LAYOUT Database Table

The PORTAL_P13N_SKIN_POOL Database Table

The PORTAL_PAGE Database Table

The PORTAL_PAGE_P13N Database Table

The PORTAL_PAGE_P13N_LAYOUT_POOL Database Table

The PORTLET Database Table

The PORTLET_P13N Database Table

The PORTLET_PLACEHOLDER Database Table

The RESOURCE_GROUP_ADMIN Database Table

The SKIN Database Table

 

---

The Portal Management Data Dictionary

In this section, the Portal, Portlet, and Sample Portal schema tables are arranged alphabetically as a data dictionary.

The LAYOUT Database Table

Table 7-1 describes the LAYOUT table. This table stores all of the defined layouts.

For information on defined constraints in this table, see Defined Constraints.

The Primary Key is LAYOUT_ID.

 

Table 7-1 LAYOUT Table Metadata

Column Name	Data Type	Null Value	Description and Recommendations
LAYOUT_ID	NUMBER(15)	NOT NULL	PK— a unique, system-generated number used as the record identifier.
PORTAL_ID	NUMBER(15)	NOT NULL	The record identifier for the portal associated with the layout. FK to the PORTAL table.
LAYOUT_XML_REF	VARCHAR(254)	NOT NULL	The identifier for this layout as specified in the portal definition XML file.
CREATION_DATE	DATE	NOT NULL	The date and time the record was created.
MODIFIED_DATE	DATE	NOT NULL	The last date and time the record was modified.

 

The PORTAL Database Table

Table 7-2 describes the PORTAL table. This table stores all of the defined portals.

The Primary Key is PORTAL_ID.

Table 7-2 PORTAL Table Metadata

Column Name	Data Type	Null Value	Description and Recommendations
PORTAL_ID	NUMBER(15)	NOT NULL	PK—a unique, system-generated number used as the record identifier.
PORTAL_XML_REF	VARCHAR(254)	NOT NULL	The identifier for this portal as specified in the portal definition XML file.
CREATION_DATE	DATE	NOT NULL	The date and time the record was created.
MODIFIED_DATE	DATE	NOT NULL	The last date and time the record was modified.
DEFAULT_PORTAL_P13N_ID	NUMBER(15)	NULL	The record identifier for the personalized portal associated with the particular portal.

 

The PORTAL_P13N Database Table

Table 7-3 describes the PORTAL_P13N table. This table stores all of the personalized portal records.

The Primary Key is PORTAL_P13N_ID.

Table 7-3 PORTAL_P13N Table Metadata

Column Name	Data Type	Null Value	Description and Recommendations
PORTAL_P13N_ID	NUMBER(15)	NOT NULL	PK—a unique, system-generated number used as the record identifier.
PORTAL_ID	NUMBER(15)	NOT NULL	The record identifier for the portal associated with the personalized portal. FK to the PORTAL table.
CREATION_DATE	DATE	NOT NULL	The date and time the record was created.
MODIFIED_DATE	DATE	NOT NULL	The last date and time the record was modified.
NAVBAR_ORIENTATION	NUMBER(1)	NOT NULL	This flag determines the orientation of the navigation bar. 0 equates to horizontal and 1 equates to vertical.
HOME_PORTAL_PAGE_ID	NUMBER(15)	NOT NULL	The record identifier for the home portal page associated with the personalized portal. FK to the PORTAL_PAGE table.
SKIN_ID	NUMBER(15)	NOT NULL	The record identifier for the skin associated with the personalized portal. FK to the SKIN table.
GROUP_NAME	VARCHAR(200)	NOT NULL	The group name associated with the personalized portal.
USER_NAME	VARCHAR(200)	NOT NULL	The user name associated with the personalized portal.
DISPLAY_NAME	VARCHAR(254)	NOT NULL	The personalized portal display name.

 

The PORTAL_P13N_LAYOUT Database Table

Table 7-4 describes the PORTAL_P13N_LAYOUT table. This table stores all available layouts for each of the personalized portals.

For information on defined constraints in this table, see Defined Constraints.

The Primary Key is comprised of both LAYOUT_ID and PORTAL_P13N_ID.

Table 7-4 PORTAL_P13N_LAYOUT Table Metadata

Column Name	Data Type	Null Value	Description and Recommendations
LAYOUT_ID	NUMBER(15)	NOT NULL	PK—combined with PORTAL_P13N_ID to form a unique record identifier. FK to the LAYOUT table.
PORTAL_P13N_ID	NUMBER(15)	NOT NULL	PK—combined with PORTAL_P13N_ID to form a unique record identifier. FK to the PORTAL_P13N table.
CREATION_DATE	DATE	NOT NULL	The date and time the record was created.
MODIFIED_DATE	DATE	NOT NULL	The last date and time the record was modified.
DISPLAY_NAME	VARCHAR(254)	NULL	The display name for the layout associated with the personalized portal.

 

The PORTAL_P13N_SKIN_POOL Database Table

Table 7-5 describes the PORTAL_P13N_SKIN_POOL table. This table stores all available skins for a personalized portal.

For information on defined constraints in this table, see Defined Constraints.

The Primary Key is comprised of both PORTAL_P13N_ID and SKIN_ID.

Table 7-5 PORTAL_P13N_SKIN_POOL Table Metadata

Column Name	Data Type	Null Value	Description and Recommendations
PORTAL_P13N_ID	NUMBER(15)	NOT NULL	PK—combined with SKIN_ID to form a unique record identifier. FK to the PORTAL_P13N table.
SKIN_ID	NUMBER(15)	NOT NULL	PK—combined with PORTAL_P13N_ID to form a unique record identifier. FK to the SKIN table.
CREATION_DATE	DATE	NOT NULL	The date and time the record was created.
MODIFIED_DATE	DATE	NOT NULL	The last date and time the record was modified.
DISPLAY_NAME	VARCHAR(254)	NULL	The display name for the skin associated with the personalized portal.

 

The PORTAL_PAGE Database Table

Table 7-6 describes the PORTAL_PAGE table. This table stores all of the defined pages for each portal.

For information on defined constraints in this table, see Defined Constraints.

The Primary Key is PORTAL_PAGE_ID.

Table 7-6 PORTAL_PAGE Table Metadata

Column Name	Data Type	Null Value	Description and Recommendations
PORTAL_PAGE_ID	NUMBER(15)	NOT NULL	PK—a unique, system-generated number used as the record identifier.
PORTAL_ID	NUMBER(15)	NOT NULL	The record identifier for the portal associated with the portal page. FK to the PORTAL table.
PORTAL_PAGE_XML_REF	VARCHAR(254)	NOT NULL	The identifier for this portal page as specified in the portal definition XML file.
CREATION_DATE	DATE	NOT NULL	The date and time the record was created.
MODIFIED_DATE	DATE	NOT NULL	The last date and time the record was modified.

 

The PORTAL_PAGE_P13N Database Table

Table 7-7 describes the PORTAL_PAGE_P13N table. This table stores information for each personalized portal page.

For information on defined constraints in this table, see Defined Constraints.

The Primary Key is PORTAL_PAGE_P13N_ID.

Table 7-7 PORTAL_PAGE_P13N Table Metadata

Column Name	Data Type	Null Value	Description and Recommendations
PORTAL_PAGE_P13N_ID	NUMBER(15)	NOT NULL	PK—a unique, system-generated number used as the record identifier.
PORTAL_P13N_ID	NUMBER(15)	NOT NULL	The record identifier for the personalized portal associated with this personalized portal page. FK to the PORTAL_P13N table.
PORTAL_PAGE_ID	NUMBER(15)	NOT NULL	The record identifier for the portal page associated with this personalized portal page. FK to the PORTAL_PAGE table.
CREATION_DATE	DATE	NOT NULL	The date and time the record was created.
MODIFIED_DATE	DATE	NOT NULL	The last date and time the record was modified.
INDEX_NUMBER	NUMBER(4)	NOT NULL	The index number associated with this piece of the personalized portal page.
IS_AVAILABLE	NUMBER(1)	NOT NULL	This flag determines whether or not the portal page is available. 0 equates to false, 1 equates to true, and -1 equates to unspecified.
IS_ENTITLED	NUMBER(1)	NOT NULL	This flag determines whether or not entitlement rulesets have been defined for the portal page. 0 equates to false, 1 equates to true, and -1 equates to unspecified.
IS_MANDATORY	NUMBER(1)	NOT NULL	This flag determines whether or not the portal page is mandatory. 0 equates to false, 1 equates to true, and -1 equates to unspecified.
IS_VISIBLE	NUMBER(1)	NOT NULL	This flag determines whether or not the portal page is visible. 0 equates to false, 1 equates to true, and -1 equates to unspecified.
LAYOUT_ID	NUMBER(15)	NOT NULL	The record identifier for the layout associated with this personalized portal page. FK to the LAYOUT table.
DISPLAY_NAME	VARCHAR(254)	NOT NULL	The display name associated with the personalized portal page.

 

The PORTAL_PAGE_P13N_LAYOUT_POOL Database Table

Table 7-8 describes the PORTAL_PAGE_P13N_LAYOUT_POOL table. This table stores all available layouts for each of the personalized portal pages.

For information on defined constraints in this table, see Defined Constraints.

The Primary Key is comprised of both PORTAL_PAGE_P13N_ID and LAYOUT_ID.

Table 7-8 PORTAL_PAGE_P13N_LAYOUT_POOL Table Metadata

Column Name	Data Type	Null Value	Description and Recommendations
PORTAL_PAGE_P13N_ID	NUMBER(15)	NOT NULL	PK—combined with LAYOUT_ID this is a unique record identifier. FK to the PORTAL_PAGE_P13N table.
LAYOUT_ID	NUMBER(15)	NOT NULL	PK—combined with PORTAL_PAGE_P13N_ID this is a unique record identifier. FK to the LAYOUT table.
CREATION_DATE	DATE	NOT NULL	The date and time the record was created.
MODIFIED_DATE	DATE	NOT NULL	The last date and time the record was modified.

 

The PORTLET Database Table

Table 7-9 describes the PORTLET table. This table stores all of the defined portlets.

For information on defined constraints in this table, see Defined Constraints.

The Primary Key is PORTLET_ID.

Table 7-9 PORTLET Table Metadata

Column Name	Data Type	Null Value	Description and Recommendations
PORTLET_ID	NUMBER(15)	NOT NULL	PK—a unique, system-generated number used as the record identifier.
PORTAL_ID	NUMBER(15)	NOT NULL	The record identifier for the portal associated with this particular portlet. FK to the PORTAL table.
PORTLET_XML_REF	VARCHAR(254)	NOT NULL	The identifier for this portlet as specified in the portal definition XML file.
CREATION_DATE	DATE	NOT NULL	The date and time the record was created.
MODIFIED_DATE	DATE	NOT NULL	The last date and time the record was modified.

 

The PORTLET_P13N Database Table

Table 7-10 describes the PORTLET_P13N table. This table holds all personalized portlet records.

For information on defined constraints in this table, see Defined Constraints.

The Primary Key is PORTLET_P13N_ID.

Table 7-10 PORTLET_P13N Table Metadata

Column Name	Data Type	Null Value	Description and Recommendations
PORTLET_P13N_ID	NUMBER(15)	NOT NULL	PK—a unique, system-generated number used as the record identifier.
PORTLET_ID	NUMBER(15)	NOT NULL	The record identifier for the portal associated with this particular personalized portlet. FK to the PORTLET table.
PORTAL_PAGE_P13N_ID	NUMBER(15)	NOT NULL	The record identifier for the portal associated with this particular personalized portlet. FK to the PORTAL_PAGE_P13N table.
CREATION_DATE	DATE	NOT NULL	The date and time the record was created.
MODIFIED_DATE	DATE	NOT NULL	The last date and time the record was modified.
PORTLET_PLACEHOLDER_ID	NUMBER(15)	NOT NULL	The record identifier for the placeholder selected for this particular personalized portlet. FK to the PORTLET_PLACEHOLDER table.
PLACEHOLDER_INDEX_NUMBER	NUMBER(4)	NOT NULL	An index specifying the order that this particular personalized portlet appears within the specified placeholder.
IS_MANDATORY	NUMBER(1)	NOT NULL	This flag determines whether or not the personalized portlet is mandatory. 0 equates to false, 1 equates to true, and -1 equates to unspecified.
IS_AVAILABLE	NUMBER(1)	NOT NULL	This flag determines whether or not the personalized portlet is available. 0 equates to false, 1 equates to true, and -1 equates to unspecified.
IS_MOVEABLE	NUMBER(1)	NOT NULL	This column is not being used and is reserved for future use.
IS_MINIMIZEABLE	NUMBER(1)	NOT NULL	This flag determines whether or not the personalized portlet can be minimized. 0 equates to false, 1 equates to true, and -1 equates to unspecified.
IS_MAXIMIZEABLE	NUMBER(1)	NOT NULL	This flag determines whether or not the personalized portlet can be maximized. 0 equates to false, 1 equates to true, and -1 equates to unspecified.
IS_FLOATABLE	NUMBER(1)	NOT NULL	This flag determines whether or not the personalized portlet can float. 0 equates to false, 1 equates to true, and -1 equates to unspecified.
IS_VISIBLE	NUMBER(1)	NOT NULL	This flag determines whether or not the personalized portlet is visible. 0 equates to false, 1 equates to true, and -1 equates to unspecified.
IS_MINIMIZED	NUMBER(1)	NOT NULL	This flag determines whether or not the personalized portlet is minimized at startup. 0 equates to false, 1 equates to true, and -1 equates to unspecified.
IS_ENTITLED	NUMBER(1)	NOT NULL	This flag determines whether or not entitlement rulesets have been defined for the portlet. 0 equates to false, 1 equates to true, and -1 equates to unspecified.
DISPLAY_NAME	VARCHAR(254)	NOT NULL	The display name of the personalized portlet.

 

The PORTLET_PLACEHOLDER Database Table

Table 7-11 describes the PORTLET_PLACEHOLDER table.

For information on defined constraints in this table, see Defined Constraints.

The Primary Key is PORTLET_PLACEHOLDER_ID.

Table 7-11 PORTLET_PLACEHOLDER_ID Table Metadata

Column Name	Data Type	Null Value	Description and Recommendations
PORTLET_PLACEHOLDER_ID	NUMBER(15)	NOT NULL	PK—stores all of the defined placeholder records for each portlet.
PORTAL_PAGE_ID	NUMBER(15)	NOT NULL	The record identifier for the portal page associated with this particular portlet placeholder. FK to the PORTAL_PAGE table.
PORTLET_PLACEHOLDER_XML_REF	VARCHAR(254)	NOT NULL	The identifier for this placeholder as specified in the portal definition XML file.
CREATION_DATE	DATE	NOT NULL	The date and time the record was created.
MODIFIED_DATE	DATE	NOT NULL	The last date and time the record was modified.

 

The RESOURCE_GROUP_ADMIN Database Table

Table 7-12 describes the RESOURCE_GROUP_ADMIN table. This table is used to store administrative privileges for various users.

The Primary Key is comprised of both RESOURCE_GROUP_TAXONOMY and DELEGATED_TO_USER_NAME.

Table 7-12 RESOURCE_GROUP_ADMIN Table Metadata

Column Name	Data Type	Null Value	Description and Recommendations
RESOURCE_GROUP_TAXONOMY	VARCHAR(254)	NOT NULL	PK—combined with DELEGATED_TO_USER_NAME this is used as a unique record identifier.
DELEGATED_TO_USER_NAME	VARCHAR(200)	NOT NULL	PK—combined with RESOURCE_GROUP_TAXONOMY this is a unique record identifier.
CREATION_DATE	DATE	NOT NULL	The date and time the record was created.
MODIFIED_DATE	DATE	NOT NULL	The last date and time the record was modified.
DELEGATED_BY_USER_NAME	VARCHAR(200)	NULL	The user who administered priviliges to the DELEGATED_TO_USER_NAME.

 

The SKIN Database Table

Table 7-13 describes the SKIN table. This table holds all of the defined skins.

For information on defined constraints in this table, see Defined Constraints.

The Primary Key is comprised of SKIN_ID.

Table 7-13 SKIN Table Metadata

Column Name	Data Type	Null Value	Description and Recommendations
SKIN_ID	NUMBER(15)	NOT NULL	PK—a unique, system-generated number used as the record identifier.
PORTAL_ID	NUMBER(15)	NOT NULL	The record identifier for the portal associated with this particular skin. FK to the PORTAL table.
SKIN_XML_REF	VARCHAR(254)	NOT NULL	The identifier for this skin as specified in the portal definition XML file.
CREATION_DATE	DATE	NOT NULL	The date and time the record was created.
MODIFIED_DATE	DATE	NOT NULL	The last date and time the record was modified.

 

 

---

The SQL Scripts Used to Create the Database

The database schemas for WebLogic Portal and WebLogic Personalization Server are all created by executing the create_all script for the target database environment.

Scripts

Regardless of your database, execute one of the following to generate the necessary database objects for the modules desired ( WebLogic Portal, WebLogic Personalization Server, Commerce services, Campaign services and Sample Portal):

• PORTAL_HOME\db\create_all.bat (Windows)

• PORTAL_HOME/db/create_all.sh (UNIX)

  The following are the various directories underneath WL_COMMERCE_HOME/db
  (as seen in a UNIX environment):

  PORTAL_HOME/db/cloudscape/351

  PORTAL_HOME/db/oracle/817

Note: In this documentation,PORTAL_HOME is used to designate the directory where the product is installed.

Each of the databases supported have the same number of scripts in each of their subdirectories. The scripts are listed and described in Table 7-14 below.

Table 7-14 The Scripts Supporting the Databases

Script Name	Description
create_all.bat	Windows script used to connect to the database and create the necessary database objects for the modules desired (e.g., WebLogic Portal, WebLogic Personalization Server, Commerce services, Campaign services and Sample Portal)
create_all.sh	Unix script used to connect to the database and create the necessary database objects for the modules desired (e.g., WebLogic Portal, WebLogic Personalization Server, Commerce services, Campaign services and Sample Portal)
campaign_create_fkeys.sql	SQL script used to create all foreign keys associated with the Campaign services.
campaign_create_indexes.sql	SQL script used to create all indexes associated with the Campaign services.
campaign_create_tables.sql	SQL script used to create all tables associated with the Campaign services.
campaign_create_triggers.sql	SQL script used to create all database triggers associated with the Campaign services.
campaign_create_views.sql	SQL script used to create all views associated with the Campaign services.
campaign_drop_constraints.sql	SQL script used to drop all constraints (other than foreign keys) associated with the Campaign services.
campaign_drop_fkeys.sql	SQL script used to drop all foreign key constraints associated with the Campaign services.
campaign_drop_indexes.sql	SQL script used to drop all indexes associated with the Campaign services.
campaign_drop_tables.sql	SQL script used to drop all tables associated with the Campaign services.
campaign_drop_views.sql	SQL script used to drop all views associated with the Campaign services.
p13n_create_fkeys.sql	SQL script used to create all foreign keys associated with the WebLogic Personalization Server.
p13n_create_indexes.sql	SQL script used to create all indexes associated with the WebLogic Personalization Server.
p13n_create_tables.sql	SQL script used to create all tables associated with the WebLogic Personalization Server.
p13n_create_triggers.sql	SQL script used to create all database triggers associated with the WebLogic Personalization Server.
p13n_create_views.sql	SQL script used to create all views associated with the WebLogic Personalization Server.
p13n_drop_constraints.sql	SQL script used to drop all constraints (other than foreign keys) associated with the WebLogic Personalization Server.
p13n_drop_fkeys.sql	SQL script used to drop all foreign key constraints associated with the WebLogic Personalization Server.
p13n_drop_indexes.sql	SQL script used to drop all indexes associated with the WebLogic Personalization Server.
p13n_drop_tables.sql	SQL script used to drop all tables associated with the WebLogic Personalization Server.
p13n_drop_views.sql	SQL script used to drop all views associated with the WebLogic Personalization Server.
portal_create_fkeys.sql	SQL script used to create all foreign keys associated with the WebLogic Portal.
portal_create_indexes.sql	SQL script used to create all indexes associated with the WebLogic Portal.
portal_create_tables.sql	SQL script used to create all tables associated with the WebLogic Portal.
portal_create_triggers.sql	SQL script used to create all database triggers associated with the WebLogic Portal.
portal_create_views.sql	SQL script used to create all views associated with the WebLogic Portal.
portal_drop_constraints.sql	SQL script used to drop all constraints (other than foreign keys) associated with the WebLogic Portal.
portal_drop_fkeys.sql	SQL script used to drop all foreign key constraints associated with the WebLogic Portal.
portal_drop_indexes.sql	SQL script used to drop all indexes associated with the WebLogic Portal.
portal_drop_tables.sql	SQL script used to drop all tables associated with the WebLogic Portal.
portal_drop_views.sql	SQL script used to drop all views associated with the WebLogic Portal.
sample_portal_create_fkeys.sql	SQL script used to create all foreign keys associated with the Sample Portal.
sample_portal_create_indexes.sql	SQL script used to create all indexes associated with the Sample Portal.
sample_portal_create_tables.sql	SQL script used to create all tables associated with the Sample Portal.
sample_portal_create_triggers.sql	SQL script used to create all database triggers associated with the Sample Portal.
sample_portal_create_views.sql	SQL script used to create all views associated with the Sample Portal.
sample_portal_drop_constraints.sql	SQL script used to drop all constraints (other than foreign keys) associated with the Sample Portal.
sample_portal_drop_fkeys.sql	SQL script used to drop all foreign key constraints associated with the Sample Portal.
sample_portal_drop_indexes.sql	SQL script used to drop all indexes associated with the Sample Portal.
sample_portal_drop_tables.sql	SQL script used to drop all tables associated with the Sample Portal.
sample_portal_drop_views.sql	SQL script used to drop all views associated with the Sample Portal.
wlcs_create_fkeys.sql	SQL script used to create all foreign keys associated with the Commerce services.
wlcs_create_indexes.sql	SQL script used to create all indexes associated with the Commerce services.
wlcs_create_tables.sql	SQL script used to create all tables associated with the Commerce services.
wlcs_create_triggers.sql	SQL script used to create all database triggers associated with the Commerce services.
wlcs_create_views.sql	SQL script used to create all views associated with the Commerce services.
wlcs_drop_constraints.sql	SQL script used to drop all constraints (other than foreign keys) associated with the Commerce services.
wlcs_drop_fkeys.sql	SQL script used to drop all foreign key constraints associated with the Commerce services.
wlcs_drop_indexes.sql	SQL script used to drop all indexes associated with the Commerce services.
wlcs_drop_tables.sql	SQL script used to drop all tables associated with the Commerce services.
wlcs_drop_views.sql	SQL script used to drop all views associated with the Commerce services.

 

 

---

Defined Constraints

Various constraints are defined and used in the Portal database schema. These constraints can be found in the following scripts:

portal_create_fkeys.sql—contains the Foreign Keys

portal_create_tables.sql—contains the Check Constraints

Table 7-15 Constraints Defined on Portal Database Tables

Table Name	Constraints
LAYOUT	Column—PORTAL_ID Constraint—FK1_LAYOUT Constraint Type—FOREIGN KEY Ensures that each LAYOUT references an existing PORTAL via the PORTAL_ID column.
PORTAL_P13N_SKIN_POOL	Column—PORTAL_P13N_ID Constraint—FK1_SKIN_POOL Constraint Type—FOREIGN KEY Ensures that each PORTAL_P13N_SKIN_POOL references an existing PORTAL_P13N via the PORTAL_P13N_ID column.
PORTAL_PAGE	Column—PORTAL_ID Constraint—FK1_PORTAL_PAGE Constraint Type—FOREIGN KEY Ensures that each PORTAL_PAGE references an existing PORTAL via the PORTAL_ID column
PORTAL_PAGE_P13N	Column— PORTAL_P13N_ID Constraint—FK3_PL_PAGE_P13N Constraint Type—FOREIGN KEY Ensures that each PORTAL_PAGE_P13N references an existing PORTAL_P13N via the PORTAL_P13N_ID column.
PORTAL_PAGE_P13N_LAYOUT_POOL	Column—PORTAL_PAGE_P13N_ID Constraint— FK2_LAYOUT_POOL Constraint Type—FOREIGN KEY Ensures that each PORTAL_PAGE_P13N_LAYOUT_POOL references an existing PORTAL_PAGE_P13N via the PORTAL_PAGE_P13N_ID column.
PORTLET	Column—PORTAL_ID Constraint—FK1_PORTLET Constraint Type—FOREIGN KEY Ensures that each PORTLET references an existing PORTAL via the PORTAL_ID column.
PORTLET_P13N	Column—PORTAL_PAGE_P13N_ID Constraint—FK3_PORTLET_P13N Constraint Type—FOREIGN KEY Ensures that each PORTAL_P13N references an existing PORTAL_PAGE_P13N via the PORTAL_PAGE_P13N_ID column.
PORTLET_PLACEHOLDER	Column— PORTAL_PAGE_ID Constraint—FK1_PORTLET_PHD Constraint Type—FOREIGN KEY Ensures that each PORTLET_PLACEHOLDER references an existing PORTAL_PAGE via the PORTAL_PAGE_ID column.
SKIN	Column—PORTAL_ID Constraint— FK1_SKIN Constraint Type—FOREIGN KEY Ensures that each SKIN references an existing PORTAL via the PORTAL_ID column.
PORTAL_P13N_LAYOUT	Column—PORTAL_P13N_ID Constraint—FK1_PL_LAYOUT Constraint Type—FOREIGN KEY Ensures that each PORTAL_P13N_LAYOUT references an existing PORTAL_P13N via the PORTAL_P13N_ID column.
PORTAL_PAGE_P13N	Column—IS_AVAILABLE Constraint—CC1_PL_PAGE_P13N Constraint Type—CHECK Ensures the value of the IS_AVAILABLE column is either -1 (undefined), 0 (false) or 1 (true). Column—IS_MANDATORY Constraint—CC2_PL_PAGE_P13N Constraint Type—CHECK Ensures the value of the IS_MANDATORY column is either -1 (undefined), 0 (false) or 1 (true). Column—IS_VISIBLE Constraint—CC3_PL_PAGE_P13N Constraint Type—CHECK Ensures the value of the IS_VISIBLE column is either -1 (undefined), 0 (false) or (true). Column—IS_ENTITLED Constraint—CC4_PL_PAGE_P13N Constraint Type—CHECK Ensures the value of the IS_ENTITLED column is either -1 (undefined), 0 (false) or 1 (true).
PORTLET_P13N	Column—IS_MINIMIZED Constraint—CC1_PORTLET_P13N Constraint Type—CHECK Ensures the value of the IS_MINIMIZED column is either -1 (undefined), 0 (false) or 1 (true). Column—IS_MANDATORY Constraint—CC2_PORTLET_P13N Constraint Type—CHECK Ensures the value of the IS_MANDATORY column is either -1 (undefined), 0 (false) or 1 (true). Column—IS_AVAILABLE Constraint—CC3_PORTLET_P13N Constraint Type—CHECK Ensures the value of the IS_AVAILABLE column is either -1 (undefined), 0 (false) or 1 (true). Column—IS_MOVEABLE Constraint—CC4_PORTLET_P13N Constraint Type—CHECK Ensures the value of the IS_MOVEABLE column is either -1 (undefined), 0 (false) or 1 (true). Column—IS_MINIMIZEABLE Constraint—CC5_PORTLET_P13N Constraint Type—CHECK Ensures the value of the IS_MINIMIZEABLE column is either -1 (undefined), 0 (false) or 1 (true). Column—IS_MAXIMIZEABLE Constraint—CC6_PORTLET_P13N Constraint Type—CHECK Ensures the value of the IS_MAXIMIZEABLE column is either -1 (undefined), 0 (false) or 1 (true). Column—IS_FLOATABLE Constraint—CC7_PORTLET_P13N Constraint Type—CHECK Ensures the value of the IS_FLOATABLE column is either -1 (undefined), 0 (false) or 1 (true).
PORTLET_P13N (continued)	Column—IS_VISIBLE Constraint—CC8_PORTLET_P13N Constraint Type—CHECK Ensures the value of the IS_VISIBLE column is either -1 (undefined), 0 (false) or 1 (true). Column—IS_ENTITLED Constraint—CC9_PORTLET_P13N Constraint Type—CHECK Ensures the value of the IS_ENTITLED column is either -1 (undefined), 0 (false) or 1 (true).