All Content Management Features

The following tables are used by all features. Related language records are also available.

The following tables pertain to folders:

Table

Description

Notes

EPPCM_CATEGORY

Folders.

Not applicable.

EPPCM_CATG_TYPE

Folder types.

Different folder types allow for different rules regarding how the components render and are used.

Valid folder types are:

  • B: Categorized Content.

  • C: Related information.

  • D: Discussion forum.

  • E: Collaborative workspace.

  • N: News publications.

  • R: Managed content.

  • S: Menu items.

  • T: Manage navigation.

  • W: Pagelet wizard.

  • A: Action items.

  • L: Calendar events.

EPPCM_CATG_CONT

Folder content relationship.

Not applicable.

EPPCM_CATG_SITE

Folder type by site.

Overrides a select set of values by site for the feature.

EPPCM_CONT_SITE

Content type by site.

Overrides by site the available content types to add.

EPPCM_COMP_TYPE

Folder type components.

Associates the feature or component type to the menu, component, and page. It also sets the page display values for that feature or component type.

EPPCM_CONT_TYPE

Content type available by feature and component type.

Lists available content types that can be added to the given feature on the given component type.

EPPCM_DFLT_URL

Default URL used to locate file storage location.

Not applicable.

EPPCM_CATG_MEM

Folder member assignment.

Related: PSOPRDEFN and PSROLEDEFN.

Implements row-level security for folder content.

EPPCM_CATG_VWR

Folder viewer assignment.

Viewer roles for published content within the folder.

EPPCM_CONT_VWR

Content viewer assignment.

Viewer roles for published content.

EPPCM_CATG_ATTR

Folder attributes.

Not applicable.

EPPCM_TPCATGADM

Top administrator assignments by feature.

Not applicable.

EPPCM_PRIVILEGE

Privilege set definition for the feature.

Determines actions available to the user. The defined privilege set is stored in the EPPCM_CATG_MEM table, which implements row-level security for folder content.

EO_PE_OPTIONS

Holds the next available category or content ID.

Warning! These IDs are system-assigned and consequently make moving Content Management-related categories and content from one database to another ill advised.

The following tables pertain to content:

Table Name

Description

Comments

EPPCM_CONTENT

Parent content record, general metadata.

Contains content type indicator.

EPPCM_DOC

Content version details with the content and version ID.

Not applicable.

EPPCM_CONT_ATTR

Content attributes.

Not applicable.

EPPCM_SUBSCRIBR

Subscribe to content privilege is set.

Users with the subscribe privilege can add or delete Managed Content members as interested parties.

EPPCM_IMAGE

Content version details with the content and version ID.

Used only by the Managed Content feature.

EPPCM_IMAGEUPL

Content image upload.

Not applicable.

EPPCM_HTMLTEXT

Content version details with the content and version ID.

Not applicable.

EPPCM_URL

Content version details with the content and version ID.

Not applicable.

EPPCM_CREF

Content version details with the content and version ID.

Used for the Menu Item content type.

EPPCM_DOCINDB

BLOB record.

Repository for documents that are stored in the database instead of on an FTP file server.