Audit Tables

Table Name Description
ADMIN_ACTIVITY Tracks administrative auditing activities by the admin users. Activities like adding and deleting users from User Manager
USER_ACTIVITY Tracks user activity. Tracks User activities like logging on and off, changing password, updating user profile

Configuration

            #-------------------------------------------------------------------------
            # jetspeed.properties
            #-------------------------------------------------------------------------
            portal.audit.enable=true
            

Statistics Tables

Table Name Description
PAGE_STATISTICS Counts page accesses and min, max and average page render times system wide
USER_STATISTICS Counts user total sessions and session max, min and average session times
PORTLET_STATISTICS Counts portlet accesses and min, max and average portlet render times system wide

Configuration

            #-------------------------------------------------------------------------
            # jetspeed.properties
            #-------------------------------------------------------------------------
            portal.statistics.logToLogger=false
            portal.statistics.logToDatabase=true
            # Number of records
            portal.statistics.MaxPortalRecordToFlush=300
            portal.statistics.MaxUserUserRecordToFlush=50
            portal.statistics.MaxPagePageRecordToFlush=100
            # Flush time in in Millisecond
            portal.statistics.MaxTimePortalToFlush=300000
            portal.statistics.MaxTimeUserToFlush=5000
            portal.statistics.MaxTimePageToFlush=60000
            

Profiler Tables

Table Name Description
PROFILING_RULE Defines a profiling rule name and class
RULE_CRITERION Defines a Profiling Rule Criterion and associates it with a Profiling Rule(RULE_ID) with a RULE CRITERIA(CRITERIA_ID)
PRINCIPAL_RULE_ASSOC Associates a user (PRINCIPAL_NAME) to a profiling rule (RULE_ID). Determines which profiling rule is used per user.
PROFILE_PAGE_ASSOC Deprecated

Configuration

            #-------------------------------------------------------------------------
            # jetspeed.properties
            #-------------------------------------------------------------------------
            # default profiling rule names assigned to a new user
            profiler.rule.names.default = page
            # default profiling rule values assigned to a new user
            profiler.rule.values.default = j2
            # Registration default profiling rules assigned during registration or new user creation
            # comma separated list
            registration.rules.default = j2
            

Security Tables

Table Name Description
SECURITY_DOMAIN Multi-tenant domain identifier. Currently modeled in database, but not used by Jetspeed
SECURITY_PRINCIPAL Defines a Security Principal of type User, Role, Group. Users are stored in this table. Usernames stored in PRINCIPAL_NAME column, unique by DTYPE + PRINCIPAL_NAME
SECURITY_PRINCIPAL_ASSOC Associates a principal to another principal by FROM_PRINCIPAL to TO_PRINCIPAL. This is how we represent user's group and role membership. Valid association types are: isMemberOf, isChildOf, isA, isPartOf, belongsTo
SECURITY_PERMISSION Java Security Policy permission definitions. Supported permissions: Folder, Page, Portlet, Fragment.
SECURITY_CREDENTIAL Defines a credential associated with a Security Principal. Also defines credential/password rules and expirations
SECURITY_ATTRIBUTE An attribute name value pair associated (one-to-many attributes) with a Security Principal. Typically used for dynamic user attributes per user
PRINCIPAL_PERMISSION Association(join) table joining a Security Principal(SECURITY_PRINCIPAL) to a Permission(SECURITY_PERMISSION)

Configuration

            #-------------------------------------------------------------------------
            # jetspeed.properties
            #-------------------------------------------------------------------------
            #1 = Permissions = use Jetspeed Java Security Policy
            #2 = Constraints = use Jetspeed (PageManager) Constraint-based Security
            portal.core.security.type=2

            # jetspeed security persistence manager cache size:
            org.apache.jetspeed.ehcache.jspm.maxelements=128
            # jetspeed security persistence manager cache element expiration in seconds, (infinite = 0):
            org.apache.jetspeed.ehcache.jspm.element.ttl=150

            # if no user has been setup, default.user.principal will be
            # automatically added via HttpRequestContext.setUserPrincpal()
            default.user.principal=guest
            default.admin.user=admin
            default.admin.role=admin
            default.manager.role=manager
            default.user.role=user
            default.guest.role=guest

            

PSML Tables

Table Name Description
FOLDER PSML Folder
FOLDER_CONSTRAINT PSML Folder Security
FOLDER_CONSTRAINTS_REF PSML Folder Security
FOLDER_MENU PSML Folder Menu
FOLDER_MENU_METADATA PSML Folder Menu
FOLDER_METADATA PSML Folder Menu
FOLDER_ORDER PSML Folder Menu
FRAGMENT PSML Fragment (Portlet Instance)
FRAGMENT_CONSTRAINT PSML Fragment (Portlet Instance) Security
FRAGMENT_CONSTRAINTS_REF PSML Fragment (Portlet Instance) Security
FRAGMENT_PREF Entity (Page Fragment) level preferences
FRAGMENT_PREF_VALUE Entity (Page Fragment) level preferences
FRAGMENT_PROP Fragment properties like number of columns, row/column positioning
LINK PSML Links
LINK_CONSTRAINT PSML Link security
LINK_CONSTRAINT_REF PSML Link Security
LINK_METADATA PSML Links
PAGE PSML Pages
PAGE_CONSTRAINT PSML Page Security
PAGE_CONSTRAINT_REF PSML Page Security
PAGE_MENU PSML Page Menu
PAGE_MENU_METADATA PSML Page Menu
PAGE_METADATA PSML Page Metadata
PAGE_SECURITY PSML Page Security definitions and references
PAGE_SEC_CONSTRAINTS_DEF PSML Global Security Constraints collection definitions
PAGE_SEC_CONSTRAINTS_REF PSML Global Security Constraints references
PAGE_SEC_CONSTRAINT_DEF PSML Global Security Constraints definition

Configuration

            #-------------------------------------------------------------------------
            # jetspeed.properties
            #-------------------------------------------------------------------------
            # defaults for page manager security
            page.manager.permissions.security = false
            page.manager.constraints.security = true
            db.page.manager.cache.size=128
            #- folder/page/link cache expires seconds, default=-1 (default then is 150 seconds), infinite=0, min=30
            db.page.manager.cache.expire=-1
            

Preferences Tables

Table Name Description
PORTLET_PREFERENCE Primary Portlet and User Preferences definitions
PORTLET_PREFERENCE_VALUE Primary Portlet and User Preferences values associated to PORTLET_PREFERENCE by PREF_ID
            #-------------------------------------------------------------------------
            # jetspeed.properties
            #-------------------------------------------------------------------------
            preferences.session.cache.enabled = true
            

Registry Tables

Table Name Description
CUSTOM_PORTLET_MODE portlet.xml
CUSTOM_WINDOW_STATE portlet.xml
EVENT_ALIAS portlet.xml
EVENT_DEFINITION portlet.xml
FILTERED_PORTLET portlet.xml
FILTER_LIFECYCLE portlet.xml
FILTER_MAPPING portlet.xml
JETSPEED_SERVICE jetspeed-portlet.xml
LANGUAGE portlet.xml
LOCALE_ENCODING_MAPPING portlet.xml
LOCALIZED_DESCRIPTION portlet.xml
LOCALIZED_DISPLAY_NAME portlet.xml
NAMED_PARAMETER portlet.xml
PARAMETER portlet.xml
PARAMETER_ALIAS portlet.xml
PA_METADATA_FIELDS jetspeed-portlet.xml
PA_SECURITY_CONSTRAINT jetspeed-portlet.xml
PD_METADATA_FIELDS jetspeed-portlet.xml
PORTLET_APPLICATION Primary Portlet Application definition from portlet.xml
PORTLET_DEFINITION Primary Portlet Definition definition from portlet.xml
PORTLET_FILTER portlet.xml
PORTLET_LISTENER portlet.xml
PORTLET_SUPPORTS portlet.xml
PROCESSING_EVENT portlet.xml
PUBLIC_PARAMETER portlet.xml
PUBLISHING_EVENT portlet.xml
RUNTIME_OPTION portlet.xml
RUNTIME_VALUE portlet.xml
SECURED_PORTLET portlet.xml
SECURITY_ROLE portlet.xml
SECURITY_ROLE_REFERENCE portlet.xml
USER_ATTRIBUTE portlet.xml
USER_ATTRIBUTE_REF portlet.xml

Capability Tables

Table Name Description
CAPABILITY A device capability
CLIENT Defines a device
CLIENT_TO_CAPABILITY Association table: a device(client) can have many capabilities
CLIENT_TO_MIMETYPE Association table: a device(client) can have many mimetypes
MEDIATYPE_TO_CAPABILITY Association table: a mediatype can have many capabilities
MEDIATYPE_TO_MIMETYPE Assocation table: media type to mime type
MEDIA_TYPE A generalized media type such as HTML or XML
MIMETYPE A Internet Standard Mime Type such as text/html

ObjectRelational Mapping Tables

Table Name Description
OJB_HL_SEQ High Low Sequence tables for all primary keys (Native database sequences are not used)
OJB_* Not used

Jetspeed SSO Tables

Table Name Description
SSO_SITE Secure Signon Site definition with credentials and Form-based security parameters