Custom query table definition and its versions

The Lifecycle

Definition availability and version publication are separate dimensions. A definition can be active, deprecated or disabled while retaining its draft and released history.

Transitions Explained

Publishing promotes the analyzed draft, supersedes the former release and creates another draft. Lifecycle setters record the requested status even when that status is unchanged.

What Cannot Happen

Version immutability is database-enforced; publication also checks validation configuration and acknowledged breaking dependencies.

Concurrency and Timing

Version checks serialize staff changes. Production lacks the configured validation workspace required for publication and nightly revalidation.