charter_toggle_definitions

Overview

The charter_toggle_definitions table contains the system-defined set of community norm toggles available for circle charters. Each toggle represents a behavioral expectation (e.g., "Be respectful", "Stay on topic"). These are seeded by the migration and are not user-editable.

Schema

-- From 20260131_circle_charters_schema.sql
CREATE TABLE charter_toggle_definitions (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  key TEXT UNIQUE NOT NULL,
  label TEXT NOT NULL,
  description TEXT,
  category TEXT DEFAULT 'general',
  default_enabled BOOLEAN DEFAULT TRUE,
  sort_order INTEGER DEFAULT 0,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

Columns

Column	Type	Nullable	Default	Description
id	uuid	No	gen_random_uuid()	Primary key
key	text	No	--	Unique toggle key (e.g., 'respect')
label	text	No	--	Display label for the toggle
description	text	Yes	--	Explanation of what this norm means
category	text	No	'general'	Toggle category grouping
default_enabled	boolean	No	TRUE	Whether enabled by default in new charters
sort_order	integer	No	0	Display order
created_at	timestamptz	No	NOW()	Seed timestamp

RLS Policies

-- SELECT: All authenticated users can read toggle definitions
CREATE POLICY "Anyone can read charter toggles"
  ON charter_toggle_definitions FOR SELECT
  USING (true);

Related

• circle_charters -- Per-circle toggle state

---

Last updated: 2026-02-07