Database

Supabase project: honeycomb (qjpfvwipdvepqborfxof) | Region: us-west-2 | Postgres 17.6

Complete schema documentation for the Honeycomb platform database.

Schemas

Public Schema

The foundational schema shared by all apps. Contains users, posts, chat, stories, marketplace, payments, settings, and admin/moderation tables.

50 tables | 30 custom enums
Central hub: profiles (linked to auth.users)
Polymorphic patterns: media, bookmarks, reactions, reports, reviews, notifications, social_links

View public schema

Extensions

Each installable app gets its own isolated Postgres schema (ext_{'{app_name}'}). This keeps app-specific data separate from the core platform and from each other.

29 schemas | ~144 tables total
Largest: ext_honeycomb (37 tables)
LMS stack: courses, quizzes, assignments, certificates, bundles
Business tools: invoicing, time tracking, subscriptions

View extension index

Extension Schemas

Schema	App	Tables	Docs
`ext_honeycomb`	Honeycomb Core (rooms, calls, games)	37	View
`ext_courses`	Courses / LMS	12	View
`ext_invoicing`	Invoicing & Quotations	12	View
`ext_documents`	Document Management	9	View
`ext_builder`	Website Builder	8	View
`ext_workflows`	Workflow Engine	6	View
`ext_forums`	Discussion Forums	5	View
`ext_quizzes`	Quiz Engine	5	View
`ext_products`	Digital Products	5	View
`ext_events`	Events & Ticketing	4	View
`ext_affiliates`	Affiliate Program	4	View
`ext_assignments`	Course Assignments	4	View
`ext_live_sessions`	Live Sessions & Meetings	4	View
`ext_timetracking`	Time Tracking	4	View
`ext_biolinks`	Bio Link Pages	3	View
`ext_bundles`	Course Bundles	3	View
`ext_ai_docs`	AI Document Generation	3	View
`ext_reminders`	Scheduled Reminders	3	View
`ext_esignatures`	E-Signatures	3	View
`ext_subscriptions`	Subscription Plans	3	View
`ext_support`	Support Tickets	3	View
`ext_analytics`	Click Analytics	2	View
`ext_blog`	Blog	2	View
`ext_filerequests`	File Requests	2	View
`ext_pixels`	Tracking Pixels	2	View
`ext_shortlinks`	Short URLs	2	View
`ext_certificates`	Certificates	2	View
`ext_domains`	Custom Domains	1	View
`ext_qr`	QR Codes	1	View

Conventions

All schemas follow these patterns:

Primary keys: id uuid DEFAULT gen_random_uuid() on every table
Timestamps: created_at / updated_at with DEFAULT now()
Soft references to users: user_id uuid referencing public.profiles.id
Status fields: text columns with text defaults (e.g. 'draft', 'active', 'pending')
Counters: denormalized integer counts (e.g. views_count, member_count) defaulting to 0
Metadata: jsonb columns defaulting to '{}' for flexible extension data
Polymorphic references: *able_id + *able_type pattern (bookmarks, reactions, media, reports, etc.)