Something went wrong. Try again.
a tool for shared writing and social publishing
Something went wrong. Try again.
TypeScript
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494export type Json = | string | number | boolean | null | { [key: string]: Json | undefined } | Json[]
export type Database = { graphql_public: { Tables: { [_ in never]: never } Views: { [_ in never]: never } Functions: { graphql: { Args: { operationName?: string query?: string variables?: Json extensions?: Json } Returns: Json } } Enums: { [_ in never]: never } CompositeTypes: { [_ in never]: never } } 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"] }, ] } 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"] }, ] } comments_on_documents: { Row: { document: string | null indexed_at: string profile: string | null record: Json uri: string } Insert: { document?: string | null indexed_at?: string profile?: string | null record: Json uri: string } Update: { document?: string | null indexed_at?: string 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_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"] }, ] } documents: { Row: { bsky_like_count: number data: Json indexed: boolean indexed_at: string recommend_count: number sort_date: string | null uri: string } Insert: { bsky_like_count?: number data: Json indexed?: boolean indexed_at?: string recommend_count?: number sort_date?: string | null uri: string } Update: { bsky_like_count?: number data?: Json indexed?: boolean indexed_at?: string recommend_count?: number sort_date?: string | null 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_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 } Insert: { atp_did?: string | null created_at?: string email?: string | null home_page?: string id?: string interface_state?: Json | null metadata?: Json | null } Update: { atp_did?: string | null created_at?: string email?: string | null home_page?: string id?: string interface_state?: Json | null metadata?: Json | null } 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 leaflet: string preferences: Json | null publication: string 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 leaflet: string preferences?: Json | null publication: string 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 leaflet?: string preferences?: Json | null publication?: string 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_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 updated_at: string } Insert: { created_at?: string enabled?: boolean publication: string updated_at?: string } Update: { created_at?: string enabled?: boolean publication?: 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: { cancel_at_period_end: boolean created_at: string current_period_end: string | null id: string identity_id: string publication: string status: string | null stripe_customer_id: string | null stripe_subscription_id: string | null tier: string | null updated_at: string } Insert: { cancel_at_period_end?: boolean created_at?: string current_period_end?: string | null id?: string identity_id: string publication: string status?: string | null stripe_customer_id?: string | null stripe_subscription_id?: string | null tier?: string | null updated_at?: string } Update: { cancel_at_period_end?: boolean created_at?: string current_period_end?: string | null id?: string identity_id?: string publication?: string status?: string | null stripe_customer_id?: string | null stripe_subscription_id?: string | null tier?: string | null updated_at?: string } Relationships: [ { foreignKeyName: "publication_memberships_identity_id_fkey" columns: ["identity_id"] isOneToOne: false referencedRelation: "identities" referencedColumns: ["id"] }, { foreignKeyName: "publication_memberships_publication_fkey" columns: ["publication"] isOneToOne: false referencedRelation: "publications" referencedColumns: ["uri"] }, { foreignKeyName: "publication_memberships_tier_fkey" columns: ["tier"] isOneToOne: false referencedRelation: "publication_membership_tiers" referencedColumns: ["id"] }, ] } publication_newsletter_settings: { Row: { confirmation_code: string | null created_at: string 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 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 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 page_entity: string | null path: string | null publication: string record: Json | null record_uri: string | null sort_order: string title: string } Insert: { created_at?: string document?: string | null id?: number page_entity?: string | null path?: string | null publication: string record?: Json | null record_uri?: string | null sort_order: string title?: string } Update: { created_at?: string document?: string | null id?: number page_entity?: string | null path?: string | null publication?: string 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_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_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: [] } 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"] }, ] } 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"] }, ] } 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"] }, ] } } Views: { [_ in never]: never } Functions: { create_identity_homepage: { Args: Record<PropertyKey, never> Returns: string } get_facts: { Args: { root: string } Returns: { attribute: string 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_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_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_tag_page_document_uris: { Args: { tag_query: string max_count?: number } Returns: { uri: string }[] } parse_iso_timestamp: { Args: { "": string } Returns: string } pull_data: { Args: { token_id: string client_group_id: string } Returns: Database["public"]["CompositeTypes"]["pull_result"] } search_tags: { Args: { search_query: string } Returns: { name: string document_count: number }[] } } Enums: { rsvp_status: "GOING" | "NOT_GOING" | "MAYBE" } CompositeTypes: { pull_result: { client_groups: Json | null facts: Json | null publications: Json | null draft_contributors: Json | null } } } storage: { Tables: { buckets: { Row: { allowed_mime_types: string[] | null avif_autodetection: boolean | null created_at: string | null file_size_limit: number | null id: string name: string owner: string | null owner_id: string | null public: boolean | null updated_at: string | null } Insert: { allowed_mime_types?: string[] | null avif_autodetection?: boolean | null created_at?: string | null file_size_limit?: number | null id: string name: string owner?: string | null owner_id?: string | null public?: boolean | null updated_at?: string | null } Update: { allowed_mime_types?: string[] | null avif_autodetection?: boolean | null created_at?: string | null file_size_limit?: number | null id?: string name?: string owner?: string | null owner_id?: string | null public?: boolean | null updated_at?: string | null } Relationships: [] } migrations: { Row: { executed_at: string | null hash: string id: number name: string } Insert: { executed_at?: string | null hash: string id: number name: string } Update: { executed_at?: string | null hash?: string id?: number name?: string } Relationships: [] } objects: { Row: { bucket_id: string | null created_at: string | null id: string last_accessed_at: string | null metadata: Json | null name: string | null owner: string | null owner_id: string | null path_tokens: string[] | null updated_at: string | null version: string | null } Insert: { bucket_id?: string | null created_at?: string | null id?: string last_accessed_at?: string | null metadata?: Json | null name?: string | null owner?: string | null owner_id?: string | null path_tokens?: string[] | null updated_at?: string | null version?: string | null } Update: { bucket_id?: string | null created_at?: string | null id?: string last_accessed_at?: string | null metadata?: Json | null name?: string | null owner?: string | null owner_id?: string | null path_tokens?: string[] | null updated_at?: string | null version?: string | null } Relationships: [ { foreignKeyName: "objects_bucketId_fkey" columns: ["bucket_id"] isOneToOne: false referencedRelation: "buckets" referencedColumns: ["id"] }, ] } s3_multipart_uploads: { Row: { bucket_id: string created_at: string id: string in_progress_size: number key: string owner_id: string | null upload_signature: string version: string } Insert: { bucket_id: string created_at?: string id: string in_progress_size?: number key: string owner_id?: string | null upload_signature: string version: string } Update: { bucket_id?: string created_at?: string id?: string in_progress_size?: number key?: string owner_id?: string | null upload_signature?: string version?: string } Relationships: [ { foreignKeyName: "s3_multipart_uploads_bucket_id_fkey" columns: ["bucket_id"] isOneToOne: false referencedRelation: "buckets" referencedColumns: ["id"] }, ] } s3_multipart_uploads_parts: { Row: { bucket_id: string created_at: string etag: string id: string key: string owner_id: string | null part_number: number size: number upload_id: string version: string } Insert: { bucket_id: string created_at?: string etag: string id?: string key: string owner_id?: string | null part_number: number size?: number upload_id: string version: string } Update: { bucket_id?: string created_at?: string etag?: string id?: string key?: string owner_id?: string | null part_number?: number size?: number upload_id?: string version?: string } Relationships: [ { foreignKeyName: "s3_multipart_uploads_parts_bucket_id_fkey" columns: ["bucket_id"] isOneToOne: false referencedRelation: "buckets" referencedColumns: ["id"] }, { foreignKeyName: "s3_multipart_uploads_parts_upload_id_fkey" columns: ["upload_id"] isOneToOne: false referencedRelation: "s3_multipart_uploads" referencedColumns: ["id"] }, ] } } Views: { [_ in never]: never } Functions: { can_insert_object: { Args: { bucketid: string name: string owner: string metadata: Json } Returns: undefined } extension: { Args: { name: string } Returns: string } filename: { Args: { name: string } Returns: string } foldername: { Args: { name: string } Returns: string[] } get_size_by_bucket: { Args: Record<PropertyKey, never> Returns: { size: number bucket_id: string }[] } list_multipart_uploads_with_delimiter: { Args: { bucket_id: string prefix_param: string delimiter_param: string max_keys?: number next_key_token?: string next_upload_token?: string } Returns: { key: string id: string created_at: string }[] } list_objects_with_delimiter: { Args: { bucket_id: string prefix_param: string delimiter_param: string max_keys?: number start_after?: string next_token?: string } Returns: { name: string id: string metadata: Json updated_at: string }[] } search: { Args: { prefix: string bucketname: string limits?: number levels?: number offsets?: number search?: string sortcolumn?: string sortorder?: string } Returns: { name: string id: string updated_at: string created_at: string last_accessed_at: string metadata: Json }[] } } Enums: { [_ in never]: never } CompositeTypes: { [_ in never]: never } }}
type PublicSchema = Database[Extract<keyof Database, "public">]
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