Database declaration reference · Brand Studio docs

Every checked-in Brand Studio Supabase SQL declaration, its declared objects and exact source.

This reference is regenerated from every docs/supabase-brand-studio-*.sql file and preserves each declaration verbatim. It proves what the repository declares, not what is deployed. Repeated migrations may amend the same object, and live acceptance still requires a read-only schema/version observation against the intended Supabase project.

Declaration file	Declared objects	Source
supabase-brand-studio-alpha-admission	function:brand_studio_guard_alpha_admission_v1, function:brand_studio_reserve_alpha_pull_v1, index:brand_studio_pulls_alpha_created_idx, trigger:brand_studio_guard_alpha_admission_v1	`docs/supabase-brand-studio-alpha-admission.sql`
supabase-brand-studio-api-keys	index:brand_studio_api_keys_user_idx, table:brand_studio_api_keys	`docs/supabase-brand-studio-api-keys.sql`
supabase-brand-studio-auth	function:set_brand_studio_runs_updated_at, index:brand_studio_runs_user_brand_updated_idx, index:brand_studio_runs_user_status_idx, index:brand_studio_runs_user_updated_idx, policy:brand_studio_runs_delete_own, policy:brand_studio_runs_insert_own, policy:brand_studio_runs_select_own, policy:brand_studio_runs_update_own, table:brand_studio_runs, trigger:set_brand_studio_runs_updated_at	`docs/supabase-brand-studio-auth.sql`
supabase-brand-studio-basic-reads	index:brand_studio_basic_reads_brand_created_idx, index:brand_studio_basic_reads_user_created_idx, policy:brand_studio_basic_reads_select_own, table:brand_studio_basic_reads	`docs/supabase-brand-studio-basic-reads.sql`
supabase-brand-studio-basic-watches	index:brand_studio_basic_watch_runs_user_started_idx, index:brand_studio_basic_watches_due_idx, policy:brand_studio_basic_watch_runs_select_own, policy:brand_studio_basic_watches_select_own, table:brand_studio_basic_watch_runs, table:brand_studio_basic_watches	`docs/supabase-brand-studio-basic-watches.sql`
supabase-brand-studio-billing	index:brand_studio_credit_ledger_user_created_idx, policy:brand_studio_credit_ledger_select_own, policy:brand_studio_plans_select_authenticated, policy:brand_studio_subscriptions_select_own, table:brand_studio_credit_ledger, table:brand_studio_plans, table:brand_studio_subscriptions	`docs/supabase-brand-studio-billing.sql`
supabase-brand-studio-byo-keys	function:brand_studio_byo_keys_touch, index:brand_studio_byo_keys_user_idx, table:brand_studio_byo_keys, trigger:brand_studio_byo_keys_touch	`docs/supabase-brand-studio-byo-keys.sql`
supabase-brand-studio-checkout-attempts	function:brand_studio_reserve_checkout_attempt, index:brand_studio_checkout_attempts_owner_created_idx, table:brand_studio_checkout_attempts	`docs/supabase-brand-studio-checkout-attempts.sql`
supabase-brand-studio-client-review	index:brand_studio_client_reviews_requests_idx, index:brand_studio_client_reviews_shares_idx, table:brand_studio_client_reviews	`docs/supabase-brand-studio-client-review.sql`
supabase-brand-studio-crawl-task-rollout	function:brand_studio_adopt_crawl_task	`docs/supabase-brand-studio-crawl-task-rollout.sql`
supabase-brand-studio-evidence-chunks	function:brand_studio_evidence_chunks_no_update, function:brand_studio_evidence_storage_version_v1, function:brand_studio_renew_evidence_lease_v1, function:brand_studio_store_evidence_chunk_v1, policy:evidence_chunks_no_client_delete, policy:evidence_chunks_no_client_insert, policy:evidence_chunks_no_client_update, policy:evidence_chunks_owner_bound, policy:evidence_chunks_owner_read, table:brand_studio_evidence_chunks, trigger:brand_studio_evidence_chunks_immutable	`docs/supabase-brand-studio-evidence-chunks.sql`
supabase-brand-studio-mcp-oauth	function:brand_studio_mcp_oauth_authorize, function:brand_studio_mcp_oauth_consume_code, function:brand_studio_mcp_oauth_issue_tokens, function:brand_studio_mcp_oauth_revoke_token, index:brand_studio_mcp_oauth_grants_owner_idx, index:brand_studio_mcp_oauth_tokens_grant_idx, table:brand_studio_mcp_oauth_codes, table:brand_studio_mcp_oauth_grants, table:brand_studio_mcp_oauth_tokens	`docs/supabase-brand-studio-mcp-oauth.sql`
supabase-brand-studio-monitoring-20261023	function:brand_studio_create_review_watch, function:brand_studio_ledger_snapshot, function:brand_studio_monitoring_sweep_claim, function:brand_studio_monitoring_sweep_finish, function:brand_studio_notification_claim, function:brand_studio_notification_enqueue, function:brand_studio_notification_finish, function:brand_studio_notification_preference, function:brand_studio_notification_queue_claim, function:brand_studio_notification_queue_finish, function:brand_studio_notification_unsubscribe, index:brand_studio_notification_due_idx, index:brand_studio_notification_queue_due_idx, index:brand_studio_review_watch_runs_user_started_idx, index:brand_studio_review_watches_due_idx, policy:brand_studio_review_watch_runs_select_own, policy:brand_studio_review_watches_select_own, table:brand_studio_monitoring_sweeps, table:brand_studio_notification_outbox, table:brand_studio_notification_preferences, table:brand_studio_notification_suppressions, table:brand_studio_review_watch_runs, table:brand_studio_review_watches	`docs/supabase-brand-studio-monitoring-20261023.sql`
supabase-brand-studio-monitoring-credit-view	function:brand_studio_ledger_snapshot	`docs/supabase-brand-studio-monitoring-credit-view.sql`
supabase-brand-studio-notifications	function:brand_studio_notification_claim, function:brand_studio_notification_enqueue, function:brand_studio_notification_finish, function:brand_studio_notification_preference, function:brand_studio_notification_queue_claim, function:brand_studio_notification_queue_finish, function:brand_studio_notification_unsubscribe, index:brand_studio_notification_due_idx, index:brand_studio_notification_queue_due_idx, table:brand_studio_notification_outbox, table:brand_studio_notification_preferences, table:brand_studio_notification_suppressions	`docs/supabase-brand-studio-notifications.sql`
supabase-brand-studio-open-beta	index:brand_studio_credit_ledger_created_idx	`docs/supabase-brand-studio-open-beta.sql`
supabase-brand-studio-plan-decisions	table:brand_studio_plan_decisions	`docs/supabase-brand-studio-plan-decisions.sql`
supabase-brand-studio-pull-tasks	function:brand_studio_claim_crawl_task, function:brand_studio_seed_crawl_task, function:brand_studio_transition_crawl_task, index:brand_studio_pull_tasks_due_idx, policy:pull_task_evidence_owner_read, policy:pull_tasks_owner_read, table:brand_studio_pull_task_evidence, table:brand_studio_pull_task_transitions, table:brand_studio_pull_tasks	`docs/supabase-brand-studio-pull-tasks.sql`
supabase-brand-studio-pulls-service-writes	policy:release_deny_client_delete, policy:release_deny_client_insert, policy:release_deny_client_update	`docs/supabase-brand-studio-pulls-service-writes.sql`
supabase-brand-studio-pulls	index:brand_studio_brands_user_updated_idx, index:brand_studio_pull_diffs_brand_created_idx, index:brand_studio_pull_diffs_to_pull_idx, index:brand_studio_pulls_brand_created_idx, index:brand_studio_pulls_user_brand_created_idx, index:brand_studio_pulls_user_status_idx, table:brand_studio_brands, table:brand_studio_pull_diffs, table:brand_studio_pulls	`docs/supabase-brand-studio-pulls.sql`
supabase-brand-studio-release-2026-09-08	function:brand_studio_ledger_snapshot, policy:release_deny_client_delete, policy:release_deny_client_insert, policy:release_deny_client_update	`docs/supabase-brand-studio-release-2026-09-08.sql`
supabase-brand-studio-retention	function:set_brand_studio_retention_settings_updated_at, policy:brand_studio_retention_settings_delete_own, policy:brand_studio_retention_settings_insert_own, policy:brand_studio_retention_settings_select_own, policy:brand_studio_retention_settings_update_own, table:brand_studio_retention_settings, trigger:set_brand_studio_retention_settings_updated_at	`docs/supabase-brand-studio-retention.sql`
supabase-brand-studio-review-release-check	function:brand_studio_review_release_check	`docs/supabase-brand-studio-review-release-check.sql`
supabase-brand-studio-review-watches	function:brand_studio_create_review_watch, index:brand_studio_review_watch_runs_user_started_idx, index:brand_studio_review_watches_due_idx, policy:brand_studio_review_watch_runs_select_own, policy:brand_studio_review_watches_select_own, table:brand_studio_review_watch_runs, table:brand_studio_review_watches	`docs/supabase-brand-studio-review-watches.sql`
supabase-brand-studio-review	index:brand_studio_score_overrides_pull_idx, policy:brand_studio_score_overrides_delete_own, policy:brand_studio_score_overrides_insert_own, policy:brand_studio_score_overrides_select_own, policy:brand_studio_score_overrides_update_own, table:brand_studio_score_overrides	`docs/supabase-brand-studio-review.sql`
supabase-brand-studio-search-watches	index:brand_studio_search_watch_runs_user_started_idx, index:brand_studio_search_watches_due_idx, policy:brand_studio_search_watch_runs_select_own, policy:brand_studio_search_watches_select_own, table:brand_studio_search_watch_runs, table:brand_studio_search_watches	`docs/supabase-brand-studio-search-watches.sql`
supabase-brand-studio-section-review-recovery	table:brand_studio_section_review_recoveries	`docs/supabase-brand-studio-section-review-recovery.sql`
supabase-brand-studio-site-page-reads	index:brand_studio_site_page_reads_page_idx, index:brand_studio_site_page_reads_site_read_idx, policy:brand_studio_site_page_reads_select_own, table:brand_studio_site_page_reads	`docs/supabase-brand-studio-site-page-reads.sql`
supabase-brand-studio-site-pages	index:brand_studio_site_pages_brand_observed_idx, index:brand_studio_site_pages_user_created_idx, policy:brand_studio_site_pages_select_own, table:brand_studio_site_pages	`docs/supabase-brand-studio-site-pages.sql`
supabase-brand-studio-social-watches	index:brand_studio_social_watch_runs_user_started_idx, index:brand_studio_social_watches_due_idx, policy:brand_studio_social_watch_runs_select_own, policy:brand_studio_social_watches_select_own, table:brand_studio_social_watch_runs, table:brand_studio_social_watches	`docs/supabase-brand-studio-social-watches.sql`
supabase-brand-studio-sweep-health	function:brand_studio_monitoring_sweep_claim, function:brand_studio_monitoring_sweep_finish, table:brand_studio_monitoring_sweeps	`docs/supabase-brand-studio-sweep-health.sql`