TrioCMS Developers
← Docs

Data modelInternals

Postgres database triocms. Core tables:

  • sites — slug, title, url, custom_domain, description, is_published + gtag, og_image, favicon, twitter_card, jquery_version, jqueryui_version, blueimp_version
  • pages — site_id, slug, title, body (Quill HTML), menu, menu_url, in_menu, sort_order, parent_id, is_published, meta_description, deleted
  • articles — like pages + excerpt, published_at
  • sections — reusable blocks; standard ones seeded per site: header, footer, stylesheet
  • api_keys — per-account REST keys
  • knowledge_base — these docs (full-text searchable)

Every content row is scoped by site_id; sites are scoped by user_id.