export type Json = | string | number | boolean | null | { [key: string]: Json | undefined } | Json[] export type Database = { public: { Tables: { atp_poll_records: { Row: { cid: string created_at: string record: Json uri: string } Insert: { cid: string created_at?: string record: Json uri: string } Update: { cid?: string created_at?: string record?: Json uri?: string } Relationships: [] } atp_poll_votes: { Row: { indexed_at: string poll_cid: string poll_uri: string record: Json uri: string voter_did: string } Insert: { indexed_at?: string poll_cid: string poll_uri: string record: Json uri: string voter_did: string } Update: { indexed_at?: string poll_cid?: string poll_uri?: string record?: Json uri?: string voter_did?: string } Relationships: [ { foreignKeyName: "atp_poll_votes_poll_uri_fkey" columns: ["poll_uri"] isOneToOne: false referencedRelation: "atp_poll_records" referencedColumns: ["uri"] }, ] } blob_cleanup_queue: { Row: { path: string queued_at: string } Insert: { path: string queued_at?: string } Update: { path?: string queued_at?: string } Relationships: [] } bsky_follows: { Row: { follows: string identity: string } Insert: { follows: string identity?: string } Update: { follows?: string identity?: string } Relationships: [ { foreignKeyName: "bsky_follows_follows_fkey" columns: ["follows"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["atp_did"] }, { foreignKeyName: "bsky_follows_identity_fkey" columns: ["identity"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["atp_did"] }, ] } bsky_posts: { Row: { cid: string indexed_at: string post_view: Json uri: string } Insert: { cid: string indexed_at?: string post_view: Json uri: string } Update: { cid?: string indexed_at?: string post_view?: Json uri?: string } Relationships: [] } bsky_profiles: { Row: { did: string handle: string | null indexed_at: string record: Json } Insert: { did: string handle?: string | null indexed_at?: string record: Json } Update: { did?: string handle?: string | null indexed_at?: string record?: Json } Relationships: [ { foreignKeyName: "bsky_profiles_did_fkey" columns: ["did"] isOneToOne: true referencedRelation: "identities" referencedColumns: ["atp_did"] }, ] } comment_tombstones: { Row: { deleted_at: string document: string | null record: Json uri: string } Insert: { deleted_at?: string document?: string | null record: Json uri: string } Update: { deleted_at?: string document?: string | null record?: Json uri?: string } Relationships: [ { foreignKeyName: "comment_tombstones_document_fkey" columns: ["document"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, ] } comments_on_documents: { Row: { document: string | null indexed_at: string past_versions: Json profile: string | null record: Json uri: string } Insert: { document?: string | null indexed_at?: string past_versions?: Json profile?: string | null record: Json uri: string } Update: { document?: string | null indexed_at?: string past_versions?: Json profile?: string | null record?: Json uri?: string } Relationships: [ { foreignKeyName: "comments_on_documents_document_fkey" columns: ["document"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, ] } custom_domain_routes: { Row: { created_at: string domain: string edit_permission_token: string id: string route: string view_permission_token: string } Insert: { created_at?: string domain: string edit_permission_token: string id?: string route: string view_permission_token: string } Update: { created_at?: string domain?: string edit_permission_token?: string id?: string route?: string view_permission_token?: string } Relationships: [ { foreignKeyName: "custom_domain_routes_domain_fkey" columns: ["domain"] isOneToOne: false referencedRelation: "custom_domains" referencedColumns: ["domain"] }, { foreignKeyName: "custom_domain_routes_edit_permission_token_fkey" columns: ["edit_permission_token"] isOneToOne: false referencedRelation: "permission_tokens" referencedColumns: ["id"] }, { foreignKeyName: "custom_domain_routes_view_permission_token_fkey" columns: ["view_permission_token"] isOneToOne: false referencedRelation: "permission_tokens" referencedColumns: ["id"] }, ] } custom_domains: { Row: { confirmed: boolean created_at: string domain: string identity: string | null identity_id: string | null } Insert: { confirmed: boolean created_at?: string domain: string identity?: string | null identity_id?: string | null } Update: { confirmed?: boolean created_at?: string domain?: string identity?: string | null identity_id?: string | null } Relationships: [ { foreignKeyName: "custom_domains_identity_fkey" columns: ["identity"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["email"] }, { foreignKeyName: "custom_domains_identity_id_fkey" columns: ["identity_id"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["id"] }, ] } document_mentions_in_bsky: { Row: { document: string indexed_at: string link: string uri: string } Insert: { document: string indexed_at?: string link: string uri: string } Update: { document?: string indexed_at?: string link?: string uri?: string } Relationships: [ { foreignKeyName: "document_mentions_in_bsky_document_fkey" columns: ["document"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, { foreignKeyName: "document_mentions_in_bsky_uri_fkey" columns: ["uri"] isOneToOne: false referencedRelation: "bsky_posts" referencedColumns: ["uri"] }, ] } document_question_answers: { Row: { indexed_at: string question: string record: Json subject: string uri: string } Insert: { indexed_at?: string question: string record: Json subject: string uri: string } Update: { indexed_at?: string question?: string record?: Json subject?: string uri?: string } Relationships: [ { foreignKeyName: "document_question_answers_question_fkey" columns: ["question"] isOneToOne: true referencedRelation: "document_questions" referencedColumns: ["uri"] }, { foreignKeyName: "document_question_answers_subject_fkey" columns: ["subject"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, ] } document_question_visibility: { Row: { indexed_at: string question: string state: string subject: string uri: string } Insert: { indexed_at?: string question: string state: string subject: string uri: string } Update: { indexed_at?: string question?: string state?: string subject?: string uri?: string } Relationships: [ { foreignKeyName: "document_question_visibility_subject_fkey" columns: ["subject"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, ] } document_questions: { Row: { asker_did: string cid: string indexed_at: string record: Json subject: string uri: string } Insert: { asker_did: string cid: string indexed_at?: string record: Json subject: string uri: string } Update: { asker_did?: string cid?: string indexed_at?: string record?: Json subject?: string uri?: string } Relationships: [ { foreignKeyName: "document_questions_subject_fkey" columns: ["subject"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, ] } document_replies: { Row: { document: string indexed_at: string record: Json replier_did: string subject: string uri: string } Insert: { document: string indexed_at?: string record: Json replier_did: string subject: string uri: string } Update: { document?: string indexed_at?: string record?: Json replier_did?: string subject?: string uri?: string } Relationships: [ { foreignKeyName: "document_replies_document_fkey" columns: ["document"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, { foreignKeyName: "document_replies_subject_fkey" columns: ["subject"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, ] } document_reply_rejections: { Row: { rejected_at: string reply: string subject: string } Insert: { rejected_at?: string reply: string subject: string } Update: { rejected_at?: string reply?: string subject?: string } Relationships: [ { foreignKeyName: "document_reply_rejections_reply_fkey" columns: ["reply"] isOneToOne: true referencedRelation: "document_replies" referencedColumns: ["uri"] }, { foreignKeyName: "document_reply_rejections_subject_fkey" columns: ["subject"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, ] } document_reply_visibility: { Row: { indexed_at: string reply: string subject: string uri: string } Insert: { indexed_at?: string reply: string subject: string uri: string } Update: { indexed_at?: string reply?: string subject?: string uri?: string } Relationships: [ { foreignKeyName: "document_reply_visibility_subject_fkey" columns: ["subject"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, ] } document_tags: { Row: { tag: string uri: string } Insert: { tag: string uri: string } Update: { tag?: string uri?: string } Relationships: [ { foreignKeyName: "document_tags_uri_fkey" columns: ["uri"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, ] } document_version_blob_refs: { Row: { path: string version: string } Insert: { path: string version: string } Update: { path?: string version?: string } Relationships: [ { foreignKeyName: "document_version_blob_refs_version_fkey" columns: ["version"] isOneToOne: false referencedRelation: "document_versions" referencedColumns: ["id"] }, ] } document_versions: { Row: { author_did: string | null author_identity: string | null byte_size: number closure_hash: string created_at: string fact_count: number id: string kind: string name: string | null snapshot: Json | null snapshot_path: string | null token: string } Insert: { author_did?: string | null author_identity?: string | null byte_size: number closure_hash: string created_at?: string fact_count: number id: string kind?: string name?: string | null snapshot?: Json | null snapshot_path?: string | null token: string } Update: { author_did?: string | null author_identity?: string | null byte_size?: number closure_hash?: string created_at?: string fact_count?: number id?: string kind?: string name?: string | null snapshot?: Json | null snapshot_path?: string | null token?: string } Relationships: [ { foreignKeyName: "document_versions_author_identity_fkey" columns: ["author_identity"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["id"] }, { foreignKeyName: "document_versions_token_fkey" columns: ["token"] isOneToOne: false referencedRelation: "permission_tokens" referencedColumns: ["id"] }, ] } documents: { Row: { bsky_like_count: number data: Json identity_did: string | null indexed: boolean indexed_at: string recommend_count: number sort_date: string | null uri: string } Insert: { bsky_like_count?: number data: Json identity_did?: never indexed?: boolean indexed_at?: string recommend_count?: number sort_date?: never uri: string } Update: { bsky_like_count?: number data?: Json identity_did?: never indexed?: boolean indexed_at?: string recommend_count?: number sort_date?: never uri?: string } Relationships: [] } documents_in_publications: { Row: { document: string indexed_at: string members_only: boolean publication: string } Insert: { document: string indexed_at?: string members_only?: boolean publication: string } Update: { document?: string indexed_at?: string members_only?: boolean publication?: string } Relationships: [ { foreignKeyName: "documents_in_publications_document_fkey" columns: ["document"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, { foreignKeyName: "documents_in_publications_publication_fkey" columns: ["publication"] isOneToOne: false referencedRelation: "publications" referencedColumns: ["uri"] }, ] } email_auth_tokens: { Row: { confirmation_code: string confirmed: boolean created_at: string email: string | null id: string identity: string | null } Insert: { confirmation_code: string confirmed?: boolean created_at?: string email?: string | null id?: string identity?: string | null } Update: { confirmation_code?: string confirmed?: boolean created_at?: string email?: string | null id?: string identity?: string | null } Relationships: [ { foreignKeyName: "email_auth_tokens_identity_fkey" columns: ["identity"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["id"] }, ] } email_render_images: { Row: { created_at: string key: string spec: Json } Insert: { created_at?: string key: string spec: Json } Update: { created_at?: string key?: string spec?: Json } Relationships: [] } email_subscriptions_to_entity: { Row: { confirmation_code: string confirmed: boolean created_at: string email: string entity: string id: string token: string } Insert: { confirmation_code: string confirmed?: boolean created_at?: string email: string entity: string id?: string token: string } Update: { confirmation_code?: string confirmed?: boolean created_at?: string email?: string entity?: string id?: string token?: string } Relationships: [ { foreignKeyName: "email_subscriptions_to_entity_entity_fkey" columns: ["entity"] isOneToOne: false referencedRelation: "entities" referencedColumns: ["id"] }, { foreignKeyName: "email_subscriptions_to_entity_token_fkey" columns: ["token"] isOneToOne: false referencedRelation: "permission_tokens" referencedColumns: ["id"] }, ] } entities: { Row: { created_at: string id: string set: string } Insert: { created_at?: string id: string set: string } Update: { created_at?: string id?: string set?: string } Relationships: [ { foreignKeyName: "entities_set_fkey" columns: ["set"] isOneToOne: false referencedRelation: "entity_sets" referencedColumns: ["id"] }, ] } entity_sets: { Row: { created_at: string id: string } Insert: { created_at?: string id?: string } Update: { created_at?: string id?: string } Relationships: [] } facts: { Row: { attribute: string author_did: string | null created_at: string data: Json entity: string id: string updated_at: string | null version: number } Insert: { attribute: string author_did?: string | null created_at?: string data: Json entity: string id: string updated_at?: string | null version?: number } Update: { attribute?: string author_did?: string | null created_at?: string data?: Json entity?: string id?: string updated_at?: string | null version?: number } Relationships: [ { foreignKeyName: "facts_entity_fkey" columns: ["entity"] isOneToOne: false referencedRelation: "entities" referencedColumns: ["id"] }, ] } identities: { Row: { atp_did: string | null created_at: string email: string | null home_page: string id: string interface_state: Json | null metadata: Json | null tutorial: boolean } Insert: { atp_did?: string | null created_at?: string email?: string | null home_page?: string id?: string interface_state?: Json | null metadata?: Json | null tutorial?: boolean } Update: { atp_did?: string | null created_at?: string email?: string | null home_page?: string id?: string interface_state?: Json | null metadata?: Json | null tutorial?: boolean } Relationships: [ { foreignKeyName: "identities_home_page_fkey" columns: ["home_page"] isOneToOne: false referencedRelation: "permission_tokens" referencedColumns: ["id"] }, ] } leaflet_contributors: { Row: { contributor_did: string created_at: string leaflet: string } Insert: { contributor_did: string created_at?: string leaflet: string } Update: { contributor_did?: string created_at?: string leaflet?: string } Relationships: [ { foreignKeyName: "leaflet_contributors_contributor_did_fkey" columns: ["contributor_did"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["atp_did"] }, { foreignKeyName: "leaflet_contributors_leaflet_fkey" columns: ["leaflet"] isOneToOne: false referencedRelation: "permission_tokens" referencedColumns: ["id"] }, ] } leaflets_in_publications: { Row: { archived: boolean | null cover_image: string | null description: string doc: string | null email_only: boolean leaflet: string preferences: Json | null publication: string reply_to: string | null reply_to_block: string | null scheduled_publish_at: string | null scheduled_publish_data: Json | null tags: string[] | null title: string } Insert: { archived?: boolean | null cover_image?: string | null description?: string doc?: string | null email_only?: boolean leaflet: string preferences?: Json | null publication: string reply_to?: string | null reply_to_block?: string | null scheduled_publish_at?: string | null scheduled_publish_data?: Json | null tags?: string[] | null title?: string } Update: { archived?: boolean | null cover_image?: string | null description?: string doc?: string | null email_only?: boolean leaflet?: string preferences?: Json | null publication?: string reply_to?: string | null reply_to_block?: string | null scheduled_publish_at?: string | null scheduled_publish_data?: Json | null tags?: string[] | null title?: string } Relationships: [ { foreignKeyName: "leaflets_in_publications_doc_fkey" columns: ["doc"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, { foreignKeyName: "leaflets_in_publications_leaflet_fkey" columns: ["leaflet"] isOneToOne: false referencedRelation: "permission_tokens" referencedColumns: ["id"] }, { foreignKeyName: "leaflets_in_publications_publication_fkey" columns: ["publication"] isOneToOne: false referencedRelation: "publications" referencedColumns: ["uri"] }, ] } leaflets_to_documents: { Row: { cover_image: string | null created_at: string description: string document: string leaflet: string preferences: Json | null scheduled_publish_at: string | null scheduled_publish_data: Json | null tags: string[] | null title: string } Insert: { cover_image?: string | null created_at?: string description?: string document: string leaflet: string preferences?: Json | null scheduled_publish_at?: string | null scheduled_publish_data?: Json | null tags?: string[] | null title?: string } Update: { cover_image?: string | null created_at?: string description?: string document?: string leaflet?: string preferences?: Json | null scheduled_publish_at?: string | null scheduled_publish_data?: Json | null tags?: string[] | null title?: string } Relationships: [ { foreignKeyName: "leaflets_to_documents_document_fkey" columns: ["document"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, { foreignKeyName: "leaflets_to_documents_leaflet_fkey" columns: ["leaflet"] isOneToOne: false referencedRelation: "permission_tokens" referencedColumns: ["id"] }, ] } mention_service_configs: { Row: { identity_did: string record: Json uri: string } Insert: { identity_did: string record: Json uri: string } Update: { identity_did?: string record?: Json uri?: string } Relationships: [] } mention_services: { Row: { identity_did: string record: Json uri: string } Insert: { identity_did: string record: Json uri: string } Update: { identity_did?: string record?: Json uri?: string } Relationships: [] } notifications: { Row: { created_at: string data: Json id: string read: boolean recipient: string } Insert: { created_at?: string data: Json id: string read?: boolean recipient: string } Update: { created_at?: string data?: Json id?: string read?: boolean recipient?: string } Relationships: [ { foreignKeyName: "notifications_recipient_fkey" columns: ["recipient"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["atp_did"] }, ] } oauth_session_store: { Row: { key: string session: Json } Insert: { key: string session: Json } Update: { key?: string session?: Json } Relationships: [] } oauth_state_store: { Row: { key: string state: Json } Insert: { key: string state: Json } Update: { key?: string state?: Json } Relationships: [] } permission_token_on_homepage: { Row: { archived: boolean | null created_at: string identity: string token: string } Insert: { archived?: boolean | null created_at?: string identity: string token: string } Update: { archived?: boolean | null created_at?: string identity?: string token?: string } Relationships: [ { foreignKeyName: "permission_token_creator_identity_fkey" columns: ["identity"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["id"] }, { foreignKeyName: "permission_token_on_homepage_token_fkey" columns: ["token"] isOneToOne: false referencedRelation: "permission_tokens" referencedColumns: ["id"] }, ] } permission_token_rights: { Row: { change_entity_set: boolean create_token: boolean created_at: string entity_set: string read: boolean token: string write: boolean } Insert: { change_entity_set?: boolean create_token?: boolean created_at?: string entity_set: string read?: boolean token: string write?: boolean } Update: { change_entity_set?: boolean create_token?: boolean created_at?: string entity_set?: string read?: boolean token?: string write?: boolean } Relationships: [ { foreignKeyName: "permission_token_rights_entity_set_fkey" columns: ["entity_set"] isOneToOne: false referencedRelation: "entity_sets" referencedColumns: ["id"] }, { foreignKeyName: "permission_token_rights_token_fkey" columns: ["token"] isOneToOne: false referencedRelation: "permission_tokens" referencedColumns: ["id"] }, ] } permission_tokens: { Row: { blocked_by_admin: boolean | null description: string | null id: string root_entity: string title: string | null } Insert: { blocked_by_admin?: boolean | null description?: string | null id?: string root_entity: string title?: string | null } Update: { blocked_by_admin?: boolean | null description?: string | null id?: string root_entity?: string title?: string | null } Relationships: [ { foreignKeyName: "permission_tokens_root_entity_fkey" columns: ["root_entity"] isOneToOne: false referencedRelation: "entities" referencedColumns: ["id"] }, ] } phone_number_auth_tokens: { Row: { confirmation_code: string confirmed: boolean country_code: string created_at: string id: string phone_number: string } Insert: { confirmation_code: string confirmed?: boolean country_code: string created_at?: string id?: string phone_number: string } Update: { confirmation_code?: string confirmed?: boolean country_code?: string created_at?: string id?: string phone_number?: string } Relationships: [] } phone_rsvps_to_entity: { Row: { country_code: string created_at: string entity: string id: string name: string phone_number: string plus_ones: number status: Database["public"]["Enums"]["rsvp_status"] } Insert: { country_code: string created_at?: string entity: string id?: string name?: string phone_number: string plus_ones?: number status: Database["public"]["Enums"]["rsvp_status"] } Update: { country_code?: string created_at?: string entity?: string id?: string name?: string phone_number?: string plus_ones?: number status?: Database["public"]["Enums"]["rsvp_status"] } Relationships: [ { foreignKeyName: "phone_rsvps_to_entity_entity_fkey" columns: ["entity"] isOneToOne: false referencedRelation: "entities" referencedColumns: ["id"] }, ] } poll_votes_on_entity: { Row: { created_at: string id: string option_entity: string poll_entity: string voter_token: string } Insert: { created_at?: string id?: string option_entity: string poll_entity: string voter_token: string } Update: { created_at?: string id?: string option_entity?: string poll_entity?: string voter_token?: string } Relationships: [ { foreignKeyName: "poll_votes_on_entity_option_entity_fkey" columns: ["option_entity"] isOneToOne: false referencedRelation: "entities" referencedColumns: ["id"] }, { foreignKeyName: "poll_votes_on_entity_poll_entity_fkey" columns: ["poll_entity"] isOneToOne: false referencedRelation: "entities" referencedColumns: ["id"] }, ] } publication_contributors: { Row: { confirmed: boolean contributor_did: string created_at: string publication_uri: string } Insert: { confirmed?: boolean contributor_did: string created_at?: string publication_uri: string } Update: { confirmed?: boolean contributor_did?: string created_at?: string publication_uri?: string } Relationships: [ { foreignKeyName: "publication_contributors_contributor_did_fkey" columns: ["contributor_did"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["atp_did"] }, { foreignKeyName: "publication_contributors_publication_uri_fkey" columns: ["publication_uri"] isOneToOne: false referencedRelation: "publications" referencedColumns: ["uri"] }, ] } publication_domains: { Row: { created_at: string domain: string identity: string publication: string } Insert: { created_at?: string domain: string identity: string publication: string } Update: { created_at?: string domain?: string identity?: string publication?: string } Relationships: [ { foreignKeyName: "publication_domains_domain_fkey" columns: ["domain"] isOneToOne: false referencedRelation: "custom_domains" referencedColumns: ["domain"] }, { foreignKeyName: "publication_domains_identity_fkey" columns: ["identity"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["atp_did"] }, { foreignKeyName: "publication_domains_publication_fkey" columns: ["publication"] isOneToOne: false referencedRelation: "publications" referencedColumns: ["uri"] }, ] } publication_email_posts: { Row: { audience: string byline_dids: string[] created_at: string created_by: string description: string error: string | null id: string image_paths: string[] leaflet: string pages: Json publication: string revision: number send_at: string | null send_mode: string sent_at: string | null status: string subscriber_count: number | null title: string updated_at: string } Insert: { audience?: string byline_dids?: string[] created_at?: string created_by: string description?: string error?: string | null id?: string image_paths?: string[] leaflet: string pages: Json publication: string revision?: number send_at?: string | null send_mode: string sent_at?: string | null status: string subscriber_count?: number | null title?: string updated_at?: string } Update: { audience?: string byline_dids?: string[] created_at?: string created_by?: string description?: string error?: string | null id?: string image_paths?: string[] leaflet?: string pages?: Json publication?: string revision?: number send_at?: string | null send_mode?: string sent_at?: string | null status?: string subscriber_count?: number | null title?: string updated_at?: string } Relationships: [ { foreignKeyName: "publication_email_posts_leaflet_fkey" columns: ["leaflet"] isOneToOne: false referencedRelation: "permission_tokens" referencedColumns: ["id"] }, { foreignKeyName: "publication_email_posts_publication_fkey" columns: ["publication"] isOneToOne: false referencedRelation: "publications" referencedColumns: ["uri"] }, ] } publication_email_subscriber_events: { Row: { event_type: string id: string metadata: Json | null occurred_at: string publication: string subscriber: string } Insert: { event_type: string id?: string metadata?: Json | null occurred_at?: string publication: string subscriber: string } Update: { event_type?: string id?: string metadata?: Json | null occurred_at?: string publication?: string subscriber?: string } Relationships: [ { foreignKeyName: "publication_email_subscriber_events_publication_fkey" columns: ["publication"] isOneToOne: false referencedRelation: "publications" referencedColumns: ["uri"] }, { foreignKeyName: "publication_email_subscriber_events_subscriber_fkey" columns: ["subscriber"] isOneToOne: false referencedRelation: "publication_email_subscribers" referencedColumns: ["id"] }, ] } publication_email_subscribers: { Row: { confirmation_code: string | null confirmed_at: string | null created_at: string email: string id: string identity_id: string | null metadata: Json | null publication: string state: string unsubscribe_token: string unsubscribed_at: string | null } Insert: { confirmation_code?: string | null confirmed_at?: string | null created_at?: string email: string id?: string identity_id?: string | null metadata?: Json | null publication: string state?: string unsubscribe_token?: string unsubscribed_at?: string | null } Update: { confirmation_code?: string | null confirmed_at?: string | null created_at?: string email?: string id?: string identity_id?: string | null metadata?: Json | null publication?: string state?: string unsubscribe_token?: string unsubscribed_at?: string | null } Relationships: [ { foreignKeyName: "publication_email_subscribers_identity_id_fkey" columns: ["identity_id"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["id"] }, { foreignKeyName: "publication_email_subscribers_publication_fkey" columns: ["publication"] isOneToOne: false referencedRelation: "publications" referencedColumns: ["uri"] }, ] } publication_membership_settings: { Row: { created_at: string enabled: boolean publication: string subscriber_tier_description: string | null subscriber_tier_name: string updated_at: string } Insert: { created_at?: string enabled?: boolean publication: string subscriber_tier_description?: string | null subscriber_tier_name?: string updated_at?: string } Update: { created_at?: string enabled?: boolean publication?: string subscriber_tier_description?: string | null subscriber_tier_name?: string updated_at?: string } Relationships: [ { foreignKeyName: "publication_membership_settings_publication_fkey" columns: ["publication"] isOneToOne: true referencedRelation: "publications" referencedColumns: ["uri"] }, ] } publication_membership_tiers: { Row: { active: boolean annual_price_cents: number | null created_at: string currency: string description: string | null id: string monthly_price_cents: number name: string publication: string sort_order: number stripe_price_annual_id: string | null stripe_price_monthly_id: string | null stripe_product_id: string | null updated_at: string } Insert: { active?: boolean annual_price_cents?: number | null created_at?: string currency?: string description?: string | null id?: string monthly_price_cents: number name: string publication: string sort_order?: number stripe_price_annual_id?: string | null stripe_price_monthly_id?: string | null stripe_product_id?: string | null updated_at?: string } Update: { active?: boolean annual_price_cents?: number | null created_at?: string currency?: string description?: string | null id?: string monthly_price_cents?: number name?: string publication?: string sort_order?: number stripe_price_annual_id?: string | null stripe_price_monthly_id?: string | null stripe_product_id?: string | null updated_at?: string } Relationships: [ { foreignKeyName: "publication_membership_tiers_publication_fkey" columns: ["publication"] isOneToOne: false referencedRelation: "publications" referencedColumns: ["uri"] }, ] } publication_memberships: { Row: { cadence: string | null cancel_at_period_end: boolean created_at: string current_period_end: string | null id: string identity_id: string pending_cadence: string | null pending_tier: string | null publication: string status: string | null stripe_account_id: string | null stripe_customer_id: string | null stripe_price_id: string | null stripe_subscription_id: string | null tier: string updated_at: string } Insert: { cadence?: string | null cancel_at_period_end?: boolean created_at?: string current_period_end?: string | null id?: string identity_id: string pending_cadence?: string | null pending_tier?: string | null publication: string status?: string | null stripe_account_id?: string | null stripe_customer_id?: string | null stripe_price_id?: string | null stripe_subscription_id?: string | null tier: string updated_at?: string } Update: { cadence?: string | null cancel_at_period_end?: boolean created_at?: string current_period_end?: string | null id?: string identity_id?: string pending_cadence?: string | null pending_tier?: string | null publication?: string status?: string | null stripe_account_id?: string | null stripe_customer_id?: string | null stripe_price_id?: string | null stripe_subscription_id?: string | null tier?: string updated_at?: string } Relationships: [ { foreignKeyName: "publication_memberships_identity_id_fkey" columns: ["identity_id"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["id"] }, { foreignKeyName: "publication_memberships_pending_tier_fkey" columns: ["pending_tier"] isOneToOne: false referencedRelation: "publication_membership_tiers" referencedColumns: ["id"] }, { foreignKeyName: "publication_memberships_publication_fkey" columns: ["publication"] isOneToOne: false referencedRelation: "publications" referencedColumns: ["uri"] }, { foreignKeyName: "publication_memberships_tier_publication_fkey" columns: ["tier", "publication"] isOneToOne: false referencedRelation: "publication_membership_tiers" referencedColumns: ["id", "publication"] }, ] } publication_newsletter_settings: { Row: { confirmation_code: string | null created_at: string embed_redirect_url: string | null enabled: boolean publication: string reply_to_email: string | null reply_to_verified_at: string | null updated_at: string } Insert: { confirmation_code?: string | null created_at?: string embed_redirect_url?: string | null enabled?: boolean publication: string reply_to_email?: string | null reply_to_verified_at?: string | null updated_at?: string } Update: { confirmation_code?: string | null created_at?: string embed_redirect_url?: string | null enabled?: boolean publication?: string reply_to_email?: string | null reply_to_verified_at?: string | null updated_at?: string } Relationships: [ { foreignKeyName: "publication_newsletter_settings_publication_fkey" columns: ["publication"] isOneToOne: true referencedRelation: "publications" referencedColumns: ["uri"] }, ] } publication_pages: { Row: { created_at: string document: string | null id: number leaflet_src: string | null metadata: Json page_entity: string | null path: string | null publication: string published_metadata: Json | null record: Json | null record_uri: string | null sort_order: string title: string } Insert: { created_at?: string document?: string | null id?: number leaflet_src?: string | null metadata?: Json page_entity?: string | null path?: string | null publication: string published_metadata?: Json | null record?: Json | null record_uri?: string | null sort_order: string title?: string } Update: { created_at?: string document?: string | null id?: number leaflet_src?: string | null metadata?: Json page_entity?: string | null path?: string | null publication?: string published_metadata?: Json | null record?: Json | null record_uri?: string | null sort_order?: string title?: string } Relationships: [ { foreignKeyName: "publication_pages_document_fkey" columns: ["document"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, { foreignKeyName: "publication_pages_leaflet_src_fkey" columns: ["leaflet_src"] isOneToOne: false referencedRelation: "permission_tokens" referencedColumns: ["id"] }, { foreignKeyName: "publication_pages_publication_fkey" columns: ["publication"] isOneToOne: false referencedRelation: "publications" referencedColumns: ["uri"] }, ] } publication_post_sends: { Row: { completed_at: string | null document: string error: string | null publication: string started_at: string status: string subscriber_count: number | null } Insert: { completed_at?: string | null document: string error?: string | null publication: string started_at?: string status?: string subscriber_count?: number | null } Update: { completed_at?: string | null document?: string error?: string | null publication?: string started_at?: string status?: string subscriber_count?: number | null } Relationships: [ { foreignKeyName: "publication_post_sends_document_fkey" columns: ["document"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, { foreignKeyName: "publication_post_sends_publication_fkey" columns: ["publication"] isOneToOne: false referencedRelation: "publications" referencedColumns: ["uri"] }, ] } publication_recommendations: { Row: { indexed_at: string publication: string recommendation: string sort_order: number uri: string } Insert: { indexed_at?: string publication: string recommendation: string sort_order: number uri: string } Update: { indexed_at?: string publication?: string recommendation?: string sort_order?: number uri?: string } Relationships: [ { foreignKeyName: "publication_recommendations_publication_fkey" columns: ["publication"] isOneToOne: false referencedRelation: "publications" referencedColumns: ["uri"] }, ] } publication_scheduled_posts: { Row: { bsky_post: Json | null created_at: string created_by: string error: string | null id: string leaflet: string publication: string publish_at: string revision: number send_email: boolean show_in_discover: boolean status: string updated_at: string } Insert: { bsky_post?: Json | null created_at?: string created_by: string error?: string | null id?: string leaflet: string publication: string publish_at: string revision?: number send_email?: boolean show_in_discover?: boolean status?: string updated_at?: string } Update: { bsky_post?: Json | null created_at?: string created_by?: string error?: string | null id?: string leaflet?: string publication?: string publish_at?: string revision?: number send_email?: boolean show_in_discover?: boolean status?: string updated_at?: string } Relationships: [ { foreignKeyName: "publication_scheduled_posts_leaflet_fkey" columns: ["leaflet"] isOneToOne: true referencedRelation: "permission_tokens" referencedColumns: ["id"] }, { foreignKeyName: "publication_scheduled_posts_publication_fkey" columns: ["publication"] isOneToOne: false referencedRelation: "publications" referencedColumns: ["uri"] }, ] } publication_subscriptions: { Row: { created_at: string identity: string publication: string record: Json uri: string } Insert: { created_at?: string identity: string publication: string record: Json uri: string } Update: { created_at?: string identity?: string publication?: string record?: Json uri?: string } Relationships: [ { foreignKeyName: "publication_subscriptions_identity_fkey" columns: ["identity"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["atp_did"] }, { foreignKeyName: "publication_subscriptions_publication_fkey" columns: ["publication"] isOneToOne: false referencedRelation: "publications" referencedColumns: ["uri"] }, ] } publications: { Row: { draft_leaflet: string | null identity_did: string indexed_at: string name: string record: Json | null uri: string } Insert: { draft_leaflet?: string | null identity_did: string indexed_at?: string name: string record?: Json | null uri: string } Update: { draft_leaflet?: string | null identity_did?: string indexed_at?: string name?: string record?: Json | null uri?: string } Relationships: [ { foreignKeyName: "publications_draft_leaflet_fkey" columns: ["draft_leaflet"] isOneToOne: false referencedRelation: "permission_tokens" referencedColumns: ["id"] }, { foreignKeyName: "publications_identity_did_fkey" columns: ["identity_did"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["atp_did"] }, ] } recommends_on_documents: { Row: { document: string indexed_at: string recommender_did: string record: Json uri: string } Insert: { document: string indexed_at?: string recommender_did: string record: Json uri: string } Update: { document?: string indexed_at?: string recommender_did?: string record?: Json uri?: string } Relationships: [ { foreignKeyName: "recommends_on_documents_document_fkey" columns: ["document"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, { foreignKeyName: "recommends_on_documents_recommender_did_fkey" columns: ["recommender_did"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["atp_did"] }, ] } replicache_clients: { Row: { client_group: string client_id: string last_mutation: number } Insert: { client_group: string client_id: string last_mutation: number } Update: { client_group?: string client_id?: string last_mutation?: number } Relationships: [] } reply_drafts: { Row: { block: string | null created_at: string identity_did: string leaflet: string subject: string } Insert: { block?: string | null created_at?: string identity_did: string leaflet: string subject: string } Update: { block?: string | null created_at?: string identity_did?: string leaflet?: string subject?: string } Relationships: [ { foreignKeyName: "reply_drafts_identity_did_fkey" columns: ["identity_did"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["atp_did"] }, { foreignKeyName: "reply_drafts_leaflet_fkey" columns: ["leaflet"] isOneToOne: true referencedRelation: "permission_tokens" referencedColumns: ["id"] }, { foreignKeyName: "reply_drafts_subject_fkey" columns: ["subject"] isOneToOne: false referencedRelation: "documents" referencedColumns: ["uri"] }, ] } site_standard_documents: { Row: { data: Json identity_did: string indexed_at: string uri: string } Insert: { data: Json identity_did: string indexed_at?: string uri: string } Update: { data?: Json identity_did?: string indexed_at?: string uri?: string } Relationships: [ { foreignKeyName: "site_standard_documents_identity_did_fkey" columns: ["identity_did"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["atp_did"] }, ] } site_standard_documents_in_publications: { Row: { document: string indexed_at: string publication: string } Insert: { document: string indexed_at?: string publication: string } Update: { document?: string indexed_at?: string publication?: string } Relationships: [ { foreignKeyName: "site_standard_documents_in_publications_document_fkey" columns: ["document"] isOneToOne: false referencedRelation: "site_standard_documents" referencedColumns: ["uri"] }, { foreignKeyName: "site_standard_documents_in_publications_publication_fkey" columns: ["publication"] isOneToOne: false referencedRelation: "site_standard_publications" referencedColumns: ["uri"] }, ] } site_standard_publications: { Row: { data: Json identity_did: string indexed_at: string uri: string } Insert: { data: Json identity_did: string indexed_at?: string uri: string } Update: { data?: Json identity_did?: string indexed_at?: string uri?: string } Relationships: [ { foreignKeyName: "site_standard_publications_identity_did_fkey" columns: ["identity_did"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["atp_did"] }, ] } site_standard_subscriptions: { Row: { created_at: string identity: string publication: string record: Json uri: string } Insert: { created_at?: string identity: string publication: string record: Json uri: string } Update: { created_at?: string identity?: string publication?: string record?: Json uri?: string } Relationships: [ { foreignKeyName: "site_standard_subscriptions_identity_fkey" columns: ["identity"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["atp_did"] }, { foreignKeyName: "site_standard_subscriptions_publication_fkey" columns: ["publication"] isOneToOne: false referencedRelation: "site_standard_publications" referencedColumns: ["uri"] }, ] } stripe_connected_accounts: { Row: { charges_enabled: boolean created_at: string details_submitted: boolean identity_id: string payouts_enabled: boolean requirements: Json | null stripe_account_id: string updated_at: string } Insert: { charges_enabled?: boolean created_at?: string details_submitted?: boolean identity_id: string payouts_enabled?: boolean requirements?: Json | null stripe_account_id: string updated_at?: string } Update: { charges_enabled?: boolean created_at?: string details_submitted?: boolean identity_id?: string payouts_enabled?: boolean requirements?: Json | null stripe_account_id?: string updated_at?: string } Relationships: [ { foreignKeyName: "stripe_connected_accounts_identity_id_fkey" columns: ["identity_id"] isOneToOne: true referencedRelation: "identities" referencedColumns: ["id"] }, ] } stripe_connected_customers: { Row: { created_at: string identity_id: string stripe_account_id: string stripe_customer_id: string updated_at: string } Insert: { created_at?: string identity_id: string stripe_account_id: string stripe_customer_id: string updated_at?: string } Update: { created_at?: string identity_id?: string stripe_account_id?: string stripe_customer_id?: string updated_at?: string } Relationships: [ { foreignKeyName: "stripe_connected_customers_identity_id_fkey" columns: ["identity_id"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["id"] }, ] } stripe_wallets: { Row: { card_brand: string | null card_exp_month: number | null card_exp_year: number | null card_last4: string | null created_at: string default_payment_method_id: string | null identity_id: string stripe_customer_id: string updated_at: string } Insert: { card_brand?: string | null card_exp_month?: number | null card_exp_year?: number | null card_last4?: string | null created_at?: string default_payment_method_id?: string | null identity_id: string stripe_customer_id: string updated_at?: string } Update: { card_brand?: string | null card_exp_month?: number | null card_exp_year?: number | null card_last4?: string | null created_at?: string default_payment_method_id?: string | null identity_id?: string stripe_customer_id?: string updated_at?: string } Relationships: [ { foreignKeyName: "stripe_wallets_identity_id_fkey" columns: ["identity_id"] isOneToOne: true referencedRelation: "identities" referencedColumns: ["id"] }, ] } tag_counts: { Row: { document_count: number tag: string } Insert: { document_count?: number tag: string } Update: { document_count?: number tag?: string } Relationships: [] } user_entitlements: { Row: { entitlement_key: string expires_at: string | null granted_at: string identity_id: string metadata: Json | null source: string | null } Insert: { entitlement_key: string expires_at?: string | null granted_at?: string identity_id: string metadata?: Json | null source?: string | null } Update: { entitlement_key?: string expires_at?: string | null granted_at?: string identity_id?: string metadata?: Json | null source?: string | null } Relationships: [ { foreignKeyName: "user_entitlements_identity_id_fkey" columns: ["identity_id"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["id"] }, ] } user_subscriptions: { Row: { created_at: string current_period_end: string | null identity_id: string plan: string | null status: string | null stripe_customer_id: string stripe_subscription_id: string | null updated_at: string } Insert: { created_at?: string current_period_end?: string | null identity_id: string plan?: string | null status?: string | null stripe_customer_id: string stripe_subscription_id?: string | null updated_at?: string } Update: { created_at?: string current_period_end?: string | null identity_id?: string plan?: string | null status?: string | null stripe_customer_id?: string stripe_subscription_id?: string | null updated_at?: string } Relationships: [ { foreignKeyName: "user_subscriptions_identity_id_fkey" columns: ["identity_id"] isOneToOne: true referencedRelation: "identities" referencedColumns: ["id"] }, ] } } Views: { [_ in never]: never } Functions: { create_identity_homepage: { Args: Record Returns: string } document_feed_publication: { Args: { doc_uri: string doc_data: Json } Returns: string } get_facts: { Args: { root: string } Returns: { attribute: string author_did: string | null created_at: string data: Json entity: string id: string updated_at: string | null version: number }[] } get_facts_for_roots: { Args: { roots: string[] max_depth: number } Returns: { root_id: string id: string entity: string attribute: string data: Json created_at: string updated_at: string version: number author_did: string | null }[] } get_facts_with_depth: { Args: { root: string max_depth: number } Returns: { id: string entity: string attribute: string data: Json created_at: string updated_at: string version: number author_did: string | null }[] } get_follows_feed_skeleton: { Args: { p_identity: string p_cursor_timestamp?: string p_cursor_uri?: string p_limit?: number } Returns: { uri: string sort_date: string post_ref: Json bsky_post_ref: Json published_at: string }[] } get_leaflet_page_data: { Args: { p_token_id: string } Returns: { permission_token: Json permission_token_rights: Json leaflets_in_publications: Json leaflets_to_documents: Json custom_domain_routes: Json facts: Json }[] } get_profile_posts: { Args: { p_did: string p_cursor_sort_date?: string p_cursor_uri?: string p_limit?: number } Returns: { uri: string data: Json sort_date: string comments_count: number mentions_count: number recommends_count: number publication_uri: string publication_record: Json publication_name: string }[] } get_publication_feed_docs: { Args: { p_publication: string p_limit?: number } Returns: { uri: string data: Json sort_date: string }[] } get_reader_feed: { Args: { p_identity: string p_cursor_timestamp?: string p_cursor_uri?: string p_limit?: number } Returns: { uri: string data: Json sort_date: string comments_count: number mentions_count: number recommends_count: number publication_uri: string publication_record: Json publication_name: string }[] } get_subscription_feed_skeleton: { Args: { p_identity: string p_cursor_timestamp?: string p_cursor_uri?: string p_limit?: number } Returns: { uri: string sort_date: string post_ref: Json bsky_post_ref: Json published_at: string }[] } get_tag_page_document_uris: { Args: { tag_query: string max_count?: number } Returns: { uri: string }[] } log_subscriber_events: { Args: { p_events: Json } Returns: undefined } parse_iso_timestamp: { Args: { "": string } Returns: string } pull_data: { Args: { token_id: string client_group_id: string } Returns: Database["public"]["CompositeTypes"]["pull_result"] } pull_data_cvr: { Args: { token_id: string client_group_id: string base_cvr: Json } Returns: Json } search_tags: { Args: { search_query: string } Returns: { name: string document_count: number }[] } } Enums: { rsvp_status: "GOING" | "NOT_GOING" | "MAYBE" } CompositeTypes: { leaflet_page_result: { permission_token: Json | null permission_token_rights: Json | null leaflets_in_publications: Json | null leaflets_to_documents: Json | null custom_domain_routes: Json | null facts: Json | null } pull_result: { client_groups: Json | null facts: Json | null publications: Json | null draft_contributors: Json | null } } } } type PublicSchema = Database[Extract] export type Tables< PublicTableNameOrOptions extends | keyof (PublicSchema["Tables"] & PublicSchema["Views"]) | { schema: keyof Database }, TableName extends PublicTableNameOrOptions extends { schema: keyof Database } ? keyof (Database[PublicTableNameOrOptions["schema"]]["Tables"] & Database[PublicTableNameOrOptions["schema"]]["Views"]) : never = never, > = PublicTableNameOrOptions extends { schema: keyof Database } ? (Database[PublicTableNameOrOptions["schema"]]["Tables"] & Database[PublicTableNameOrOptions["schema"]]["Views"])[TableName] extends { Row: infer R } ? R : never : PublicTableNameOrOptions extends keyof (PublicSchema["Tables"] & PublicSchema["Views"]) ? (PublicSchema["Tables"] & PublicSchema["Views"])[PublicTableNameOrOptions] extends { Row: infer R } ? R : never : never export type TablesInsert< PublicTableNameOrOptions extends | keyof PublicSchema["Tables"] | { schema: keyof Database }, TableName extends PublicTableNameOrOptions extends { schema: keyof Database } ? keyof Database[PublicTableNameOrOptions["schema"]]["Tables"] : never = never, > = PublicTableNameOrOptions extends { schema: keyof Database } ? Database[PublicTableNameOrOptions["schema"]]["Tables"][TableName] extends { Insert: infer I } ? I : never : PublicTableNameOrOptions extends keyof PublicSchema["Tables"] ? PublicSchema["Tables"][PublicTableNameOrOptions] extends { Insert: infer I } ? I : never : never export type TablesUpdate< PublicTableNameOrOptions extends | keyof PublicSchema["Tables"] | { schema: keyof Database }, TableName extends PublicTableNameOrOptions extends { schema: keyof Database } ? keyof Database[PublicTableNameOrOptions["schema"]]["Tables"] : never = never, > = PublicTableNameOrOptions extends { schema: keyof Database } ? Database[PublicTableNameOrOptions["schema"]]["Tables"][TableName] extends { Update: infer U } ? U : never : PublicTableNameOrOptions extends keyof PublicSchema["Tables"] ? PublicSchema["Tables"][PublicTableNameOrOptions] extends { Update: infer U } ? U : never : never export type Enums< PublicEnumNameOrOptions extends | keyof PublicSchema["Enums"] | { schema: keyof Database }, EnumName extends PublicEnumNameOrOptions extends { schema: keyof Database } ? keyof Database[PublicEnumNameOrOptions["schema"]]["Enums"] : never = never, > = PublicEnumNameOrOptions extends { schema: keyof Database } ? Database[PublicEnumNameOrOptions["schema"]]["Enums"][EnumName] : PublicEnumNameOrOptions extends keyof PublicSchema["Enums"] ? PublicSchema["Enums"][PublicEnumNameOrOptions] : never