">

OOTHUB Blog Detail

  • Database Tables_984.png

    Content Server Key Tables

    In OpenText Content Server, various tables manage different types of data, with DTreeCore being the central entity table. It holds a record for every item, such as folders and documents. While DTreeCore is the main table, a view called DTree is often used for convenience, backward compatibility, and alignment with system parameters.

    Here is a breakdown of other key tables:

    • DVersData: This table stores a record for each version of a versioned item, like a document that has been revised.

    • ProviderData: This table tracks the location of the actual data for each versioned object, such as the content of a document. The data itself is stored either internally within the BLOBData table or externally in a separate directory.

    • DTreeACL (Access Control List): This table controls access to items. It holds a record for each user or group with permissions for a specific item.

    • DauditNew: This table logs every action performed on an item, but only if auditing is enabled to track those events.

    • KUAF: This table stores a record for every user and group, and it is directly linked to DTree, DTreeACL, and DauditNew.