Users

Table for storing user profile data linked to Supabase Auth users

Column Name	Data Type	Constraints
id	uuid	NOT NULL
username	text

Security Policies (RLS)

This table has Row Level Security (RLS) enabled with the following policies:

Read Access: Anyone can view user profiles (public visibility)
Create/Update/Delete: No specific policies defined (handled by Supabase Auth)

Users_roles_per_herd

Table for storing user role assignments per herd with role-based access control

Versions_software

Table for storing software version information with release details and stability flags