Page database structure
The Kentico database stores pages (nodes in the content tree of websites) in several interconnected tables:
Contains only one record for each page, regardless of the number of language versions. The table doesn't store any versioned data.
May contain multiple records per page, one for each language version. Some of the page columns are versioned.
Coupled data tables
Stores the fields of individual page types.
For example, the News page type has the CONTENT_News coupled table with the columns defined for news pages, such as NewsTitle, NewsSummary, NewsText.
Page attachments and versions
Stores files uploaded to the database as page attachments.
Includes all types of page attachments:
Stores page versions, including older versions and versions that are being edited. When a version is published, the system updates the corresponding records in the CMS_Tree and CMS_Document tables using the data of the version record.
Stores attachments of page versions. The main purpose of this table is to avoid redundancy for page versions that use the same attachments.
When a page version is published, the system updates the records in the CMS_Attachment table using the data of the version record.
|CMS_VersionAttachment||Stores relationships between page versions and their page attachments.|
Stores records representing relationships between two pages. Used for both:
Stores the relationship names (types) defined in the system.
Binding table that connects relationship names to websites. Each entry indicates that a relationship can be used on a given site.