Schema index
Synced from
docs/generated/erd/— do not hand-edit.
Regenerate withbun 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
Generated with the ERD run. Full per-table Markdown is produced by tbls, then bulk pages are pruned for git (GitHub PR file-count limits).
Labeled tables keep their page. Everything else: use this index + viewpoints, or runERD_KEEP_ALL_TABLES=1 bun run docs:erdfor a local full tree.
| Table | Label (if curated) | Page |
|---|---|---|
_test_locks |
— | _test_locks |
ab_test_variants |
— | ab_test_variants |
access_requests |
— | access_requests |
accounting_sync_log |
— | accounting_sync_log |
activity_heatmap |
— | activity_heatmap |
admin_config |
— | admin_config |
admin_override_log |
— | admin_override_log |
ai_admin_audit_log |
— | ai_admin_audit_log |
ai_call_log |
— | ai_call_log |
ai_content_suggestions |
— | ai_content_suggestions |
ai_insight_feedback |
— | ai_insight_feedback |
api_audit_logs |
— | api_audit_logs |
api_keys |
— | api_keys |
assessments |
— | assessments |
association_users |
— | association_users |
associations |
— | associations |
author_accounts |
— | author_accounts |
authors |
— | authors |
automation_templates |
— | automation_templates |
autonomy_executions |
— | autonomy_executions |
autonomy_lane_catalog |
— | autonomy_lane_catalog |
autonomy_promotions |
— | autonomy_promotions |
badge_print_log |
— | badge_print_log |
benefit_definitions |
Catalog of chamber benefits that member_entitlements allocate | benefit_definitions |
benefit_reservations |
Holds placed against entitlements before fulfilment (expiring reservations) | benefit_reservations |
benefit_showcase_items |
— | benefit_showcase_items |
benefit_usage |
Draw-down ledger against entitlements (legacy / sponsorship fulfilment) | benefit_usage |
billable_offers |
— | billable_offers |
billing_agreements |
— | billing_agreements |
billing_customers |
— | billing_customers |
billing_discounts |
— | billing_discounts |
billing_dunning_state |
— | billing_dunning_state |
billing_subscriptions |
— | billing_subscriptions |
billing_transactions |
— | billing_transactions |
blog_posts |
— | blog_posts |
board_positions |
— | board_positions |
board_reports |
— | board_reports |
bullseye_growth_taxonomy |
— | bullseye_growth_taxonomy |
bullseye_intelligence_catalog |
— | bullseye_intelligence_catalog |
bullseye_member_intelligence |
— | bullseye_member_intelligence |
bullseye_member_intelligence_admin |
— | bullseye_member_intelligence_admin |
bullseye_org_intelligence |
— | bullseye_org_intelligence |
bullseye_progress |
— | bullseye_progress |
campaigns |
— | campaigns |
canonical_identities |
— | canonical_identities |
certifications |
— | certifications |
chamber_event_check_ins |
— | chamber_event_check_ins |
chamber_event_invitations |
— | chamber_event_invitations |
chamber_event_registrations |
— | chamber_event_registrations |
chamber_event_series |
— | chamber_event_series |
chamber_event_ticket_types |
— | chamber_event_ticket_types |
chamber_event_waitlist |
— | chamber_event_waitlist |
chamber_events |
THE event row — everything on the calendar, public or member-only | chamber_events |
channel_variants |
— | channel_variants |
checkout_flows |
— | checkout_flows |
cohort_members |
— | cohort_members |
cohort_referrals |
— | cohort_referrals |
cohort_sessions |
— | cohort_sessions |
cohorts |
— | cohorts |
commerce_entitlements |
Plan / agreement commercial limits (seats, quota, access windows) | commerce_entitlements |
commerce_products |
Sellable SKU catalog (platform / association / org-owned products) | commerce_products |
commercial_overrides |
— | commercial_overrides |
comms_pending_approvals |
— | comms_pending_approvals |
comms_sender_approval_policy |
— | comms_sender_approval_policy |
communication_templates |
— | communication_templates |
companies |
— | companies |
config_versions |
— | config_versions |
connection_directives |
— | connection_directives |
connection_outcomes |
— | connection_outcomes |
connection_types |
— | connection_types |
connector_roles |
— | connector_roles |
connector_routing_rules |
— | connector_routing_rules |
contact_auth |
— | contact_auth |
contact_invitations |
— | contact_invitations |
contact_relationships |
— | contact_relationships |
contact_submissions |
— | contact_submissions |
contacts |
Person identity (auth-linked via contact_auth); used across CRM and membership | contacts |
content_campaign_targets |
— | content_campaign_targets |
content_delivery_keys |
— | content_delivery_keys |
content_formats |
— | content_formats |
content_growth_mappings |
— | content_growth_mappings |
content_library |
— | content_library |
content_pieces |
— | content_pieces |
content_plan_themes |
— | content_plan_themes |
content_plans |
— | content_plans |
course_enrollments |
— | course_enrollments |
course_modules |
— | course_modules |
courses |
— | courses |
credit_balance_summary |
— | credit_balance_summary |
credit_ledger |
— | credit_ledger |
crm_activity_timeline |
— | crm_activity_timeline |
crm_phase2_migration_review |
— | crm_phase2_migration_review |
cron_config |
— | cron_config |
cross_product_event_ledger |
— | cross_product_event_ledger |
custom_field_definitions |
— | custom_field_definitions |
custom_field_values |
— | custom_field_values |
demo_email_batch_items |
— | demo_email_batch_items |
demo_email_routing |
— | demo_email_routing |
demo_requests |
— | demo_requests |
deployment_log |
— | deployment_log |
digest_referrals |
— | digest_referrals |
digest_tokens |
— | digest_tokens |
directives |
— | directives |
economic_impact |
— | economic_impact |
email_admin_audit_log |
— | email_admin_audit_log |
email_campaigns |
— | email_campaigns |
email_domain_checks |
— | email_domain_checks |
email_events |
First-party campaign engagement events (campaign_id, member_id) | email_events |
email_hygiene_rate_limits |
— | email_hygiene_rate_limits |
email_inbound |
— | email_inbound |
email_mode_history |
— | email_mode_history |
email_segments |
— | email_segments |
email_send_log |
Per-recipient send ledger (status, block_reason, template) — the real send log | email_send_log |
email_send_state |
SINGLETON dispatcher tuning/throttle state (batch size, delay, TTLs) | email_send_state |
email_signature_templates |
— | email_signature_templates |
email_templates |
— | email_templates |
email_unsubscribe_tokens |
— | email_unsubscribe_tokens |
email_unsubscribes |
— | email_unsubscribes |
email_webhook_events |
Raw inbound Resend webhook payloads (svix_id, resend_email_id) | email_webhook_events |
emn_audit_logs |
— | emn_audit_logs |
emn_policies |
— | emn_policies |
engagement_events |
— | engagement_events |
entitlements |
Legacy / sponsorship-fulfilment entitlement rows (not the platform commerce ledger) | entitlements |
erasure_receipts |
— | erasure_receipts |
erasure_requests |
— | erasure_requests |
event_approval_tokens |
— | event_approval_tokens |
event_connection_intents |
— | event_connection_intents |
event_connection_suggestions |
— | event_connection_suggestions |
event_content |
— | event_content |
event_email_sequences |
— | event_email_sequences |
event_feedback |
— | event_feedback |
event_photos |
— | event_photos |
event_poll_dates |
— | event_poll_dates |
event_promo_codes |
— | event_promo_codes |
event_registration_cancel_tokens |
— | event_registration_cancel_tokens |
event_sequence_emails |
— | event_sequence_emails |
event_sequence_template_steps |
— | event_sequence_template_steps |
event_sequence_templates |
— | event_sequence_templates |
event_sessions |
— | event_sessions |
event_slug_history |
— | event_slug_history |
event_speakers |
— | event_speakers |
event_sponsor_slots |
— | event_sponsor_slots |
event_staff_assignments |
— | event_staff_assignments |
event_templates |
Reusable event blueprint used to seed a new chamber_events row | event_templates |
event_testimonial_consents |
— | event_testimonial_consents |
event_volunteer_response_tokens |
— | event_volunteer_response_tokens |
exchange_distribution_targets |
— | exchange_distribution_targets |
exchange_engagement |
— | exchange_engagement |
exchange_items |
— | exchange_items |
exchange_propagation_rules |
— | exchange_propagation_rules |
exchange_publications |
— | exchange_publications |
exchange_submissions |
— | exchange_submissions |
exchange_visibility |
— | exchange_visibility |
external_integrations |
— | external_integrations |
feature_adoption |
— | feature_adoption |
feature_definitions |
— | feature_definitions |
feature_set_items |
— | feature_set_items |
feature_sets |
— | feature_sets |
feedback |
— | feedback |
field_interactions |
— | field_interactions |
fix_proposals |
— | fix_proposals |
form_analytics |
— | form_analytics |
form_starts |
— | form_starts |
form_views |
— | form_views |
forum_ask_interventions |
— | forum_ask_interventions |
forum_categories |
— | forum_categories |
forum_follows |
— | forum_follows |
forum_reactions |
— | forum_reactions |
forum_replies |
— | forum_replies |
forum_reports |
— | forum_reports |
forum_saved_posts |
— | forum_saved_posts |
forum_space_audience |
— | forum_space_audience |
forum_threads |
— | forum_threads |
funnel_assets |
— | funnel_assets |
funnel_conversions |
— | funnel_conversions |
funnel_form_submissions |
— | funnel_form_submissions |
funnel_page_variants |
— | funnel_page_variants |
funnel_pages |
— | funnel_pages |
funnel_templates |
— | funnel_templates |
funnels |
— | funnels |
group_meetings |
— | group_meetings |
group_members |
— | group_members |
groups |
— | groups |
growth_group_members |
— | growth_group_members |
growth_groups |
— | growth_groups |
growth_tracks |
— | growth_tracks |
hot_deals |
— | hot_deals |
import_logs |
— | import_logs |
inbound_email_routes |
— | inbound_email_routes |
inbound_webhook_events |
— | inbound_webhook_events |
industry_segments |
— | industry_segments |
integration_contracts |
— | integration_contracts |
internal_config |
— | internal_config |
interventions |
— | interventions |
intro_requests |
— | intro_requests |
invoices |
— | invoices |
issue_signals |
— | issue_signals |
job_postings |
— | job_postings |
journey_edges |
— | journey_edges |
journey_nodes |
— | journey_nodes |
journey_pack_templates |
— | journey_pack_templates |
journey_run_events |
— | journey_run_events |
journey_runs |
— | journey_runs |
journey_send_dispatches |
— | journey_send_dispatches |
journey_versions |
— | journey_versions |
journeys |
— | journeys |
kb_articles |
— | kb_articles |
kb_categories |
— | kb_categories |
learning_engagement_events |
— | learning_engagement_events |
legal_document_versions |
— | legal_document_versions |
legal_documents |
— | legal_documents |
location_bookings |
— | location_bookings |
location_clusters |
— | location_clusters |
location_fixtures |
— | location_fixtures |
location_rooms |
— | location_rooms |
location_wayfinding_section_images |
— | location_wayfinding_section_images |
location_wayfinding_sections |
— | location_wayfinding_sections |
locations |
— | locations |
marketing_placement_bookings |
— | marketing_placement_bookings |
media_asset_usages |
— | media_asset_usages |
media_assets |
— | media_assets |
member_activation_milestones |
— | member_activation_milestones |
member_activity_feed |
— | member_activity_feed |
member_benefit_usage |
Draw-down ledger against member_entitlements (chamber member benefits) | member_benefit_usage |
member_billing |
Member billing satellite | member_billing |
member_comm_preferences |
— | member_comm_preferences |
member_contributions |
— | member_contributions |
member_entitlements |
Chamber member benefit allocations (quantity + usage per benefit) | member_entitlements |
member_external_access |
— | member_external_access |
member_growth_group_interest |
— | member_growth_group_interest |
member_interest_tags |
— | member_interest_tags |
member_metrics |
Member metrics / engagement satellite | member_metrics |
member_milestones |
— | member_milestones |
member_preferences |
— | member_preferences |
member_product_accounts |
— | member_product_accounts |
member_product_entitlements |
External product provisioning (e.g. Bullseye access by product_key) | member_product_entitlements |
member_profiles |
Member profile satellite (name, contact fields, etc.) | member_profiles |
member_progress |
— | member_progress |
member_referrals |
— | member_referrals |
member_role_assignments |
Assigns a role_definitions service role to a member (term dates, scope) | member_role_assignments |
member_social_handles |
— | member_social_handles |
member_success_goals |
— | member_success_goals |
member_success_plans |
— | member_success_plans |
members |
Member identity hub row (org-scoped); satellites hold profile/billing/metrics | members |
membership_applications |
— | membership_applications |
membership_benefit_definitions |
— | membership_benefit_definitions |
membership_tiers_config |
— | membership_tiers_config |
membership_types |
— | membership_types |
membership_unit_members |
— | membership_unit_members |
membership_units |
— | membership_units |
metric_snapshots |
— | metric_snapshots |
network_metrics |
— | network_metrics |
notification_reads |
— | notification_reads |
notifications |
— | notifications |
offer_bundle_items |
— | offer_bundle_items |
offer_cross_sell_rules |
— | offer_cross_sell_rules |
offer_redemptions |
— | offer_redemptions |
onboarding_state |
— | onboarding_state |
onboarding_task_completions |
— | onboarding_task_completions |
opportunity_clusters |
— | opportunity_clusters |
opportunity_recommendations |
— | opportunity_recommendations |
org_ai_config |
— | org_ai_config |
org_autonomy_lanes |
— | org_autonomy_lanes |
org_config_overrides |
— | org_config_overrides |
org_email_config |
— | org_email_config |
org_enabled_capabilities |
Per-org capability enablement, overriding the platform default | org_enabled_capabilities |
org_enabled_modules |
Per-org module enablement, overriding the platform default | org_enabled_modules |
org_event_roles |
— | org_event_roles |
org_hierarchy_history |
— | org_hierarchy_history |
org_integrations |
— | org_integrations |
org_integrations_safe |
— | org_integrations_safe |
org_partnerships |
Peer org<->org partnership — invite/accept/pause/revoke lifecycle; one LIVE row per pair (pending/active/paused), revoked is terminal, expired can still be revoked | org_partnerships |
org_taxonomy_availability |
— | org_taxonomy_availability |
org_type_template_applications |
— | org_type_template_applications |
org_type_templates |
— | org_type_templates |
organization_users |
The org seat — presence in an org plus display/email overrides | organization_users |
organizations |
— | organizations |
outbound_webhook_events |
— | outbound_webhook_events |
package_benefits |
— | package_benefits |
partnership_grants |
One direction’s scope of an org_partnerships row (channels, object types, caps) — asymmetric, at most one row per (partnership, granting org) | partnership_grants |
payments |
— | payments |
performance_metrics |
— | performance_metrics |
permission_catalog_entries |
— | permission_catalog_entries |
permission_catalog_groups |
— | permission_catalog_groups |
pie_runs |
— | pie_runs |
plan_price_variants |
— | plan_price_variants |
plan_proposals |
— | plan_proposals |
platform_email_domain_status |
— | platform_email_domain_status |
platform_email_reputation_status |
— | platform_email_reputation_status |
platform_email_settings |
— | platform_email_settings |
platform_enabled_capabilities |
Platform-wide capability enablement (default inherited by every org) | platform_enabled_capabilities |
platform_enabled_modules |
Platform-wide module enablement (the default every org inherits) | platform_enabled_modules |
platform_reputation_config |
— | platform_reputation_config |
playbook_launches |
— | playbook_launches |
playbooks |
— | playbooks |
predictive_signals |
— | predictive_signals |
product_bundle_rules |
— | product_bundle_rules |
product_invite_queue |
— | product_invite_queue |
product_sync_event_log |
— | product_sync_event_log |
program_recommendations |
— | program_recommendations |
programming_items |
— | programming_items |
prospects |
— | prospects |
public_hot_deals |
— | public_hot_deals |
public_job_postings |
— | public_job_postings |
public_membership_tiers |
— | public_membership_tiers |
public_org_branding |
— | public_org_branding |
publish_webhook_config |
— | publish_webhook_config |
publish_webhook_deliveries |
— | publish_webhook_deliveries |
rate_limit_hits |
— | rate_limit_hits |
rbac_audience_class_definitions |
— | rbac_audience_class_definitions |
rbac_org_user_permission_sets |
Assigns permission sets to a contact within an org (composes on top of their role) | rbac_org_user_permission_sets |
rbac_org_user_roles |
Org privilege grant — (contact_id x org_id) to an RBAC role; what is_org_admin() / is_org_staff() read | rbac_org_user_roles |
rbac_permission_set_definitions |
Catalog of composable permission sets — the sanctioned way to add a job-function capability | rbac_permission_set_definitions |
rbac_role_definitions |
Catalog of PRIVILEGE-bearing RBAC roles (role_key, default permission + module keys) | rbac_role_definitions |
rbac_shadow_divergence_expected |
— | rbac_shadow_divergence_expected |
rbac_shadow_divergence_log |
— | rbac_shadow_divergence_log |
recommendation_feedback |
— | recommendation_feedback |
recommended_interventions |
— | recommended_interventions |
referral_matches |
— | referral_matches |
registration_form_fields |
— | registration_form_fields |
registration_form_submissions |
— | registration_form_submissions |
registration_forms |
— | registration_forms |
renewal_risks |
— | renewal_risks |
reports |
— | reports |
risk_scoring_runs |
— | risk_scoring_runs |
role_definitions |
Catalog of member SERVICE roles (board seat, group post) — descriptive only | role_definitions |
scoring_weights |
— | scoring_weights |
seat_allocations |
— | seat_allocations |
seating_tables |
— | seating_tables |
segments |
— | segments |
short_link_visits |
— | short_link_visits |
short_links |
— | short_links |
signature_event_budget_items |
— | signature_event_budget_items |
signature_event_linked_events |
— | signature_event_linked_events |
signature_event_logistics |
— | signature_event_logistics |
signature_event_milestones |
— | signature_event_milestones |
signature_event_run_of_show |
— | signature_event_run_of_show |
signature_event_tasks |
— | signature_event_tasks |
signature_event_vendors |
— | signature_event_vendors |
signature_events |
Flagship-event PLANNING workspace (budget, stage, owner); links to chamber_events | signature_events |
simpletexting_delivery_log |
— | simpletexting_delivery_log |
simpletexting_outbox |
— | simpletexting_outbox |
sponsor_impressions |
— | sponsor_impressions |
sponsor_placements |
— | sponsor_placements |
sponsorship_credit_balances |
— | sponsorship_credit_balances |
sponsorship_credit_ledger |
— | sponsorship_credit_ledger |
sponsorship_inventory |
— | sponsorship_inventory |
sponsorship_newsletter_issues |
— | sponsorship_newsletter_issues |
sponsorship_offerings |
— | sponsorship_offerings |
sponsorship_website_months |
— | sponsorship_website_months |
sponsorships |
— | sponsorships |
spotlight_bars |
— | spotlight_bars |
staff_mailbox_connections |
— | staff_mailbox_connections |
stripe_processed_events |
— | stripe_processed_events |
success_plan_items |
— | success_plan_items |
support_ticket_messages |
— | support_ticket_messages |
support_tickets |
— | support_tickets |
suppressed_emails |
— | suppressed_emails |
sync_config |
— | sync_config |
sync_webhook_logs |
— | sync_webhook_logs |
system_health |
— | system_health |
tab_definitions |
— | tab_definitions |
tasks |
— | tasks |
tier_benefits |
— | tier_benefits |
tier_comparison_features |
— | tier_comparison_features |
tier_feature_definitions |
— | tier_feature_definitions |
tier_feature_sets |
— | tier_feature_sets |
tier_features |
— | tier_features |
tracked_links |
— | tracked_links |
trial_accounts |
— | trial_accounts |
tribespring_insights |
— | tribespring_insights |
tribespring_signals |
— | tribespring_signals |
user_module_overlays |
Per-user module grant/deny overlay on top of the org’s enabled set | user_module_overlays |
user_onboarding_completions |
— | user_onboarding_completions |
user_preferences |
— | user_preferences |
user_roles |
PLATFORM-wide role grants (master_admin) — what is_master_admin() reads | user_roles |
value_events |
— | value_events |
video_access_rules |
— | video_access_rules |
video_assets |
— | video_assets |
video_progress |
— | video_progress |
voice_profiles |
— | voice_profiles |
vw_active_members |
— | vw_active_members |
webhook_deliveries |
— | webhook_deliveries |
webhook_subscriptions |
— | webhook_subscriptions |
website_config |
— | website_config |
website_pages |
— | website_pages |
workspace_capabilities |
— | workspace_capabilities |
workspace_modules |
— | workspace_modules |
Total: 388 public tables documented by tbls this run.