Database
The Supabase baseline groups tables by identity, settings, content, notifications, analytics, leads, billing, security, and team pages.
| Group | Tables | Purpose |
|---|---|---|
| Identity and access | profiles, profile_activity_days, custom_roles, rbac_cache_state, staff_invites | Profiles, activity, custom access roles, permission cache state, and invitations. |
| Settings and branding | app_settings, branding_settings | Application behavior, localization, SEO defaults, and public brand identity. |
| Content | authors, posts, posts_revisions, faq_items, changelog_releases, team_page_settings, team_public_members | Authored content, revisions, FAQ, changelog, and public team pages. |
| Notifications | notification_event_registry, notification_user_event_registry, notification_user_preferences, notification_user_event_preferences, notification_settings, notification_templates, notification_outbox, notification_audits, notification_send_log, notification_log, notification_audit_log | Event definitions, preferences, templates, queued work, delivery logs, and audit records. |
| Leads and analytics | analytics_events, waitlist_signups, contact_messages, contact_message_replies | Product events, launch leads, contact or support messages, and their replies. |
| Provider events | billing_webhook_events, resend_webhook_events | Idempotency and processing state for billing and email provider callbacks. |
| Billing records | billing_customers, billing_subscriptions, billing_subscription_items, billing_orders, billing_invoices, billing_invoice_line_items, billing_charges, billing_refunds, billing_disputes, billing_usage_events, billing_credit_grants, billing_credit_transactions, billing_entitlements, billing_notification_states, billing_activity_events | Provider-neutral customer, purchase, subscription, invoice, usage, credit, entitlement, and customer-safe activity projections. |
| Security | request_rate_limits, audit_log | Shared request throttling state and sensitive action history. |