Versions_software
Table for storing software version information with release details and stability flags
| Column Name | Data Type | Constraints |
|---|---|---|
| id | bigint | NOT NULL |
| created_at | timestamp with time zone | DEFAULT now() NOT NULL |
| version | text | NOT NULL |
| hyperlink | text | |
| description | text | NOT NULL |
| title | text | |
| system | text | NOT NULL |
| updated_at | timestamp with time zone | DEFAULT now() |
| commit_hash | text | |
| stable | boolean | DEFAULT false NOT NULL |
| pre | boolean | DEFAULT true NOT NULL |
| min | boolean | DEFAULT false NOT NULL |
| broken | boolean | DEFAULT false NOT NULL |
| path_build_artifact | text |
Security Policies (RLS)
RLS enabled. Herd scope: Not per-herd row; table-wide.
| Operation | has_herd_ability ability key | Other paths |
|---|---|---|
| SELECT | — | All authenticated users |
| INSERT | — | Platform superadmin only |
| UPDATE | — | Platform superadmin only |
| DELETE | — | Platform superadmin only |
Herd roles never grant write access; releases are published by platform superadmins (or the service role).