CMS & Content Database Structure

Key Relationships

CMS Tables Relationships

Note: This is a simplified diagram showing the main relationships.

CMS Page Tables

cms_page

Stores CMS pages.

ColumnTypeDescription
page_idsmallintPrimary key
titlevarcharPage title

Widget Tables

widget_instance

Stores widget instances.

ColumnTypeDescription
instance_idintPrimary key
instance_typevarcharWidget type (PHP class)

Data Analysis Tips

  • Use cms_page joined with cms_page_store for per-store data
  • Use url_rewrite to map friendly URLs to CMS pages