public.event_templates

Synced from docs/generated/erd/ — do not hand-edit.
Regenerate with bun run docs:erd (needs staging reader), then this script runs automatically.
Labels: docs/db/erd-table-labels.yml · Runbook: docs/runbooks/erd-schema-docs.md

Description

Reusable event blueprint used to seed a new chamber_events row — Not: event_sequence_templates (email sequences); not an event itself

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
category	text	‘general’::text	false
created_at	timestamp with time zone	now()	false
created_by	uuid		true
description	text	‘’::text	false
icon	text	‘📋’::text	false
id	uuid	gen_random_uuid()	false
name	text		false
org_id	text		false
template	jsonb	‘{}’::jsonb	false
updated_at	timestamp with time zone	now()	false

Viewpoints

Name	Definition
Events & Registration	Chamber events, ticket types, registrations, check-ins, sessions/speakers, promo codes, registration forms, signature events (core). Catalog §3.1.

Constraints

Name	Type	Definition
event_templates_created_by_fkey	FOREIGN KEY	FOREIGN KEY (created_by) REFERENCES auth.users(id) ON DELETE SET NULL
event_templates_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
event_templates_pkey	CREATE UNIQUE INDEX event_templates_pkey ON public.event_templates USING btree (id)
idx_event_templates_org	CREATE INDEX idx_event_templates_org ON public.event_templates USING btree (org_id, created_at DESC)

Triggers

Name	Definition
set_updated_at_event_templates	CREATE TRIGGER set_updated_at_event_templates BEFORE UPDATE ON public.event_templates FOR EACH ROW EXECUTE FUNCTION update_updated_at_column()

Relations

erDiagram


"public.event_templates" {
}

---

Generated by tbls