Skip to content
MemberOSMemberOSMemberOS Help

Events & Registration

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

Section titled “Description”

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

Tables

Section titled “Tables”

Chamber event core

Section titled “Chamber event core”

Event, tickets, registrations, check-ins

Name Columns Comment Type
chamber_event_check_ins 7 BASE TABLE
chamber_event_invitations 6 BASE TABLE
chamber_event_registrations 27 BASE TABLE
chamber_event_ticket_types 9 BASE TABLE
chamber_event_waitlist 16 BASE TABLE
chamber_events 67 BASE TABLE

Event content & staff

Section titled “Event content & staff”

Sessions, speakers, sponsors, staff

Name Columns Comment Type
event_content 10 BASE TABLE
event_feedback 22 BASE TABLE
event_photos 9 BASE TABLE
event_sessions 12 BASE TABLE
event_speakers 13 BASE TABLE
event_sponsor_slots 9 BASE TABLE
event_staff_assignments 11 BASE TABLE

Registration forms

Section titled “Registration forms”

Configurable registration forms

Name Columns Comment Type
event_promo_codes 12 BASE TABLE
registration_form_fields 13 BASE TABLE
registration_form_submissions 12 BASE TABLE
registration_forms 9 BASE TABLE

Templates & sequences

Section titled “Templates & sequences”

Reusable event templates and email sequences

Name Columns Comment Type
event_email_sequences 7 BASE TABLE
event_sequence_emails 23 BASE TABLE
event_sequence_template_steps 12 BASE TABLE
event_sequence_templates 9 BASE TABLE
event_templates 10 EF-5 (#2833 / #473): org-scoped reusable event templates. template jsonb snapshots the reusable event fields (mirrors EventTemplate.defaults). Members read the org’s templates; org admins manage. Authored by SaveAsTemplateDialog, consumed by Create Event’s template picker. BASE TABLE

Signature events

Section titled “Signature events”

Large-format / multi-day event shell

Name Columns Comment Type
signature_event_linked_events 6 BASE TABLE
signature_events 19 BASE TABLE

-

Section titled “-”
Name Columns Comment Type
event_approval_tokens 8 BASE TABLE
event_connection_intents 14 BASE TABLE
event_connection_suggestions 10 BASE TABLE
event_poll_dates 10 BASE TABLE
event_slug_history 5 BASE TABLE
location_bookings 14 BASE TABLE
public.members 17 Member identity hub row (org-scoped); satellites hold profile/billing/metrics — Not: Full member payload — write profiles/billing/metrics to their tables — See: docs/PLATFORM.md BASE TABLE
organizations 35 BASE TABLE
seating_tables 9 BASE TABLE

Relations

Section titled “Relations”
erDiagram

"public.chamber_event_check_ins" }o--|| "public.chamber_event_registrations" : "FOREIGN KEY (registration_id) REFERENCES chamber_event_registrations(id) ON DELETE CASCADE"
"public.chamber_event_check_ins" }o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.chamber_event_invitations" }o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.chamber_event_registrations" }o--o| "public.chamber_event_ticket_types" : "FOREIGN KEY (ticket_type_id) REFERENCES chamber_event_ticket_types(id) ON DELETE SET NULL"
"public.chamber_event_registrations" }o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.chamber_event_registrations" }o--o| "public.members" : "FOREIGN KEY (member_id) REFERENCES members(id) ON DELETE SET NULL"
"public.chamber_event_ticket_types" }o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.chamber_event_waitlist" }o--o| "public.chamber_event_registrations" : "FOREIGN KEY (registration_id) REFERENCES chamber_event_registrations(id) ON DELETE SET NULL"
"public.chamber_event_waitlist" }o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.chamber_event_waitlist" }o--o| "public.members" : "FOREIGN KEY (member_id) REFERENCES members(id) ON DELETE SET NULL"
"public.chamber_event_waitlist" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.chamber_events" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.chamber_events" }o--o| "public.registration_forms" : "FOREIGN KEY (registration_form_id) REFERENCES registration_forms(id)"
"public.event_approval_tokens" }o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.event_connection_intents" }o--o| "public.chamber_event_registrations" : "FOREIGN KEY (registration_id) REFERENCES chamber_event_registrations(id) ON DELETE SET NULL"
"public.event_connection_intents" }o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.event_connection_intents" }o--o| "public.members" : "FOREIGN KEY (member_id) REFERENCES members(id) ON DELETE SET NULL"
"public.event_connection_intents" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.event_connection_suggestions" }o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.event_connection_suggestions" }o--|| "public.members" : "FOREIGN KEY (member_a_id) REFERENCES members(id) ON DELETE CASCADE"
"public.event_connection_suggestions" }o--|| "public.members" : "FOREIGN KEY (member_b_id) REFERENCES members(id) ON DELETE CASCADE"
"public.event_connection_suggestions" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.event_content" }o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.event_email_sequences" |o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.event_feedback" }o--o| "public.chamber_event_registrations" : "FOREIGN KEY (registration_id) REFERENCES chamber_event_registrations(id) ON DELETE SET NULL"
"public.event_feedback" }o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.event_feedback" }o--o| "public.members" : "FOREIGN KEY (member_id) REFERENCES members(id) ON DELETE SET NULL"
"public.event_feedback" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.event_photos" }o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.event_photos" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.event_poll_dates" }o--o| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.event_poll_dates" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.event_promo_codes" }o--o| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.event_sequence_emails" }o--|| "public.event_email_sequences" : "FOREIGN KEY (sequence_id) REFERENCES event_email_sequences(id) ON DELETE CASCADE"
"public.event_sequence_template_steps" }o--|| "public.event_sequence_templates" : "FOREIGN KEY (template_id) REFERENCES event_sequence_templates(id) ON DELETE CASCADE"
"public.event_sessions" }o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.event_slug_history" }o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.event_speakers" }o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.event_speakers" }o--o| "public.members" : "FOREIGN KEY (member_id) REFERENCES members(id) ON DELETE SET NULL"
"public.event_speakers" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.event_sponsor_slots" }o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.event_sponsor_slots" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.event_staff_assignments" }o--|| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.location_bookings" }o--o| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE SET NULL"
"public.location_bookings" }o--o| "public.members" : "FOREIGN KEY (booked_for_member_id) REFERENCES members(id) ON DELETE SET NULL"
"public.members" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.registration_form_fields" }o--|| "public.registration_forms" : "FOREIGN KEY (form_id) REFERENCES registration_forms(id) ON DELETE CASCADE"
"public.registration_form_submissions" }o--o| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id)"
"public.registration_form_submissions" }o--o| "public.members" : "FOREIGN KEY (member_id) REFERENCES members(id)"
"public.registration_form_submissions" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.registration_form_submissions" }o--|| "public.registration_forms" : "FOREIGN KEY (form_id) REFERENCES registration_forms(id)"
"public.registration_forms" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.seating_tables" }o--o| "public.chamber_events" : "FOREIGN KEY (event_id) REFERENCES chamber_events(id) ON DELETE CASCADE"
"public.seating_tables" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.signature_event_linked_events" }o--|| "public.chamber_events" : "FOREIGN KEY (chamber_event_id) REFERENCES chamber_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.chamber_event_check_ins" {
  uuid event_id ""
  uuid registration_id ""
}
"public.chamber_event_invitations" {
  uuid event_id ""
}
"public.chamber_event_registrations" {
  uuid event_id ""
  uuid id ""
  uuid member_id ""
  uuid ticket_type_id ""
}
"public.chamber_event_ticket_types" {
  uuid event_id ""
  uuid id ""
}
"public.chamber_event_waitlist" {
  uuid event_id ""
  uuid member_id ""
  text org_id ""
  uuid registration_id ""
}
"public.chamber_events" {
  uuid id ""
  text org_id ""
  uuid registration_form_id ""
}
"public.event_approval_tokens" {
  uuid event_id ""
}
"public.event_connection_intents" {
  uuid event_id ""
  uuid member_id ""
  text org_id ""
  uuid registration_id ""
}
"public.event_connection_suggestions" {
  uuid event_id ""
  uuid member_a_id ""
  uuid member_b_id ""
  text org_id ""
}
"public.event_content" {
  uuid event_id ""
}
"public.event_email_sequences" {
  uuid event_id ""
  uuid id ""
}
"public.event_feedback" {
  uuid event_id ""
  uuid member_id ""
  text org_id ""
  uuid registration_id ""
}
"public.event_photos" {
  uuid event_id ""
  text org_id ""
}
"public.event_poll_dates" {
  uuid event_id ""
  text org_id ""
}
"public.event_promo_codes" {
  uuid event_id ""
}
"public.event_sequence_emails" {
  uuid sequence_id ""
}
"public.event_sequence_template_steps" {
  uuid template_id ""
}
"public.event_sequence_templates" {
  uuid id ""
}
"public.event_sessions" {
  uuid event_id ""
}
"public.event_slug_history" {
  uuid event_id ""
}
"public.event_speakers" {
  uuid event_id ""
  uuid member_id ""
  text org_id ""
}
"public.event_sponsor_slots" {
  uuid event_id ""
  text org_id ""
}
"public.event_staff_assignments" {
  uuid event_id ""
}
"public.event_templates" {
}
"public.location_bookings" {
  uuid booked_for_member_id ""
  uuid event_id ""
}
"public.members" {
  uuid id ""
  text org_id ""
}
"public.organizations" {
  text id ""
}
"public.registration_form_fields" {
  uuid form_id ""
}
"public.registration_form_submissions" {
  uuid event_id ""
  uuid form_id ""
  uuid member_id ""
  text org_id ""
}
"public.registration_forms" {
  uuid id ""
  text org_id ""
}
"public.seating_tables" {
  uuid event_id ""
  text org_id ""
}
"public.signature_event_linked_events" {
  uuid chamber_event_id ""
  uuid signature_event_id ""
}
"public.signature_events" {
  uuid id ""
}

Generated by tbls