Committee user management and site activity.
Members with login access to gated pages. Change roles here — the profiles table updates immediately.
| Name / ID | Role | Change Role |
|---|
SOMA/standards/soma-auth-profiles-admin-write.sqlBug reports and feature suggestions submitted by committee members, with Bill's analysis and Greg's approval queue.
View Recommendations Admin →All communications and requests made for this website — by Mike or Greg — with their completion status. Greg can add refinement notes or submit new requests here.
View Site Change Log →Members submit these directly through Bill (the AI widget). They route here for Greg's review before any action is taken.
| Date | Type | Description | Member | Page | Status | Actions |
|---|
CREATE TABLE IF NOT EXISTS public.bill_feedback (
id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
type text NOT NULL CHECK (type IN ('bug', 'feature')),
description text NOT NULL,
member_name text,
member_email text,
page_context text,
assistant_id text DEFAULT 'legends-bill',
source text DEFAULT 'bill-widget',
ip text,
user_agent text,
status text DEFAULT 'new',
created_at timestamptz NOT NULL DEFAULT now()
);
ALTER TABLE public.bill_feedback ENABLE ROW LEVEL SECURITY;
Responses from the Member Needs Assessment form, stored in Supabase.
| Submitted | Name | Membership | Source |
|---|
SOMA/standards/soma-assessment-submissions.sqlControl whether each resource is open to everyone or restricted to committee members. Changes are saved to the server immediately.
This page is restricted to site administrators. If you believe you should have access, contact Greg Foster at gfos44@gmail.com.