This appendix discusses the tables that support:
All content management features.
Categorized content.
Note. The tables in this appendix identify all basic tables that are used in the Content Management system, as well as important cautionary notes. This list is not intended to be exhaustive, as it does not identify views or work records.
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:
|
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. |
The following table lists the additional tables required by:
Table |
Description |
Notes |
EPPCM_CATG_ATTR |
Folder attributes, such as manual or automatically created. |
Not applicable. |
EPPCM_CONT_ATTR |
Content attributes, such as manual versus auto-created. |
Not applicable. |
PS_EPPCM_SPIDR_AET |
Run control state for the Content Categorization Spider application engine. |
Not applicable. |
PS_EPPCM_SPIDR_IDS |
Content categorization spider application engine program content ID work table. |
Not applicable. |
PS_EPPCM_SPIDR_LGS |
Content categorization spider application engine program search index languages. |
Not applicable. |
PS_EPPCM_SPIDR_RUN |
Content categorization spider run control table. |
Not applicable. |
PS_EPPCM_SPIDR_DTL |
Folder spider properties, such as folder mappings. |
Not applicable. |