Docs 1
Home GitHub
menu_book Navigation menu
Documentation Content Modeling Status & Revisions

Status & Revisions

Status

The visibility of an entry is strictly controlled at the database level via the entries table.

  • Draft: (status = 0). Only visible to administrators.
  • Published: (status = 1). Visible to the public.
  • Scheduled: (status = 1 with a published_at date in the future). The routing engine will automatically hide this content from the public until the exact timestamp is reached.

Revisions

Pragma CMS utilizes a "Raw Data Snapshot" approach for revisions.

Instead of saving bloated, hydrated PHP objects, the system saves the exact, raw SQL state of the entry into a JSON string within the entry_revisions table. This guarantees mathematical data integrity: if you roll back to a version from a year ago, the system restores the exact IDs and strings that were present in the database at that precise millisecond, immune to any code logic changes that happened since.