public.signature_events

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

Flagship-event PLANNING workspace (budget, stage, owner); links to chamber_events — Not: An event on the calendar — the real event row is chamber_events

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
budget_actual_revenue	numeric	0	false
budget_target_revenue	numeric	0	false
budget_total_expenses	numeric	0	false
created_at	timestamp with time zone	now()	false
description	text		true
end_date	timestamp with time zone		true
event_type	text	‘custom’::text	false
id	uuid	gen_random_uuid()	false	signature_event_budget_items signature_event_linked_events signature_event_logistics signature_event_milestones signature_event_run_of_show signature_event_tasks signature_event_vendors sponsorships
location_id	uuid		true		locations	FK to the Location library (#3994) – the place-attach source of truth for #3999. venue_name/venue_address (free text) stay as a fallback/audit trail and are never cleared when a Location is attached. Only parking_instructions/floorplan_url from signature_event_logistics are wayfinding data (per #3999 scope) – absorbed into location_wayfinding_sections at attach-time by the frontend, not by this migration.
name	text		false
notes	text		true
org_id	text	‘’::text	false
owner_email	text		true
owner_name	text		true
planning_stage	text	‘concept’::text	false
start_date	timestamp with time zone	now()	false
status	text	‘planning’::text	false
updated_at	timestamp with time zone	now()	false
venue_address	text		true
venue_name	text		true

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
signature_events_location_id_fkey	FOREIGN KEY	FOREIGN KEY (location_id) REFERENCES locations(id) ON DELETE RESTRICT
signature_events_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
idx_sig_events_org	CREATE INDEX idx_sig_events_org ON public.signature_events USING btree (org_id)
idx_signature_events_location_id	CREATE INDEX idx_signature_events_location_id ON public.signature_events USING btree (location_id) WHERE (location_id IS NOT NULL)
signature_events_pkey	CREATE UNIQUE INDEX signature_events_pkey ON public.signature_events USING btree (id)

Triggers

Name	Definition
trg_purge_media_usages	CREATE TRIGGER trg_purge_media_usages AFTER DELETE ON public.signature_events FOR EACH ROW EXECUTE FUNCTION media_usages_purge_for_record(‘signature_event’)
update_signature_events_updated_at	CREATE TRIGGER update_signature_events_updated_at BEFORE UPDATE ON public.signature_events FOR EACH ROW EXECUTE FUNCTION update_updated_at_column()

Relations

erDiagram

"public.signature_event_budget_items" }o--|| "public.signature_events" : "FOREIGN KEY (signature_event_id) REFERENCES signature_events(id) ON DELETE CASCADE"
"public.signature_event_linked_events" }o--|| "public.signature_events" : "FOREIGN KEY (signature_event_id) REFERENCES signature_events(id) ON DELETE CASCADE"
"public.signature_event_logistics" }o--|| "public.signature_events" : "FOREIGN KEY (signature_event_id) REFERENCES signature_events(id) ON DELETE CASCADE"
"public.signature_event_milestones" }o--|| "public.signature_events" : "FOREIGN KEY (signature_event_id) REFERENCES signature_events(id) ON DELETE CASCADE"
"public.signature_event_run_of_show" }o--|| "public.signature_events" : "FOREIGN KEY (signature_event_id) REFERENCES signature_events(id) ON DELETE CASCADE"
"public.signature_event_tasks" }o--|| "public.signature_events" : "FOREIGN KEY (signature_event_id) REFERENCES signature_events(id) ON DELETE CASCADE"
"public.signature_event_vendors" }o--|| "public.signature_events" : "FOREIGN KEY (signature_event_id) REFERENCES signature_events(id) ON DELETE CASCADE"
"public.sponsorships" }o--o| "public.signature_events" : "FOREIGN KEY (signature_event_id) REFERENCES signature_events(id) ON DELETE SET NULL"
"public.signature_events" }o--o| "public.locations" : "FOREIGN KEY (location_id) REFERENCES locations(id) ON DELETE RESTRICT"

"public.signature_events" {
  uuid id ""
  uuid location_id FK "FK to the Location library (#3994) -- the place-attach source of truth for\n   #3999. venue_name/venue_address (free text) stay as a fallback/audit trail\n   and are never cleared when a Location is attached. Only\n   parking_instructions/floorplan_url from signature_event_logistics are\n   wayfinding data (per #3999 scope) -- absorbed into\n   location_wayfinding_sections at attach-time by the frontend, not by this\n   migration."
}
"public.signature_event_budget_items" {
  uuid signature_event_id FK ""
}
"public.signature_event_linked_events" {
  uuid chamber_event_id FK ""
  uuid signature_event_id FK ""
}
"public.signature_event_logistics" {
  uuid signature_event_id FK ""
}
"public.signature_event_milestones" {
  uuid signature_event_id FK ""
}
"public.signature_event_run_of_show" {
  uuid signature_event_id FK ""
}
"public.signature_event_tasks" {
  uuid signature_event_id FK ""
}
"public.signature_event_vendors" {
  uuid signature_event_id FK ""
}
"public.sponsorships" {
  uuid company_id FK ""
  uuid event_id FK "#3542: set for an event-scoped sponsorship; NULL for an org-level one."
  uuid id ""
  uuid member_id FK ""
  uuid membership_unit_id FK ""
  uuid offering_id FK "#3542: FK to sponsorship_offerings (renamed from tier_id)."
  text org_id FK ""
  uuid signature_event_id FK ""
  uuid subscription_id FK ""
}
"public.locations" {
  uuid id ""
  uuid offered_by_member_id FK ""
  text org_id FK ""
}

---

Generated by tbls