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 |
Security Policies (RLS)
This table has Row Level Security (RLS) enabled with the following policies:
- Read Access: Public read access (software versions are generally accessible)
- Create/Update/Delete: Users with admin role only