Skip to content

Public Schema

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



Enum NameValues
ad_statusdraft, active, paused
approval_statuspending, approved, rejected
bookmarkable_typepost, product, job
chat_typedirect, group
follow_statusfollowing, requested
gender_typemale, female, other, prefer_not_to_say
group_privacyopen, closed
group_visibilitypublic, private
invite_statuspending, accepted, declined
job_statusactive, closed
job_typefull_time, part_time, contract, freelance
media_statusprocessing, processed, failed
media_typeimage, video, audio, document
oauth_providergoogle, apple, twitter, facebook, discord, linkedin, tiktok, vk, telegram, microsoft, github
payment_typedeposit, withdrawal
post_statusdraft, published, archived
product_conditionnew, like_new, used
product_statusdraft, active, inactive
product_typephysical, digital
report_statuspending, resolved, dismissed
story_frame_statusdraft, active
story_frame_typeimage, video
story_privacyall, followers, friends
transaction_directionincoming, outgoing
transaction_statuspending, completed, failed
transaction_typedeposit, withdrawal, transfer
user_roleuser, admin, moderator
user_statusactive, suspended, banned
user_typepersonal, business

Central user table linked to Supabase Auth (id = auth.users.id).

ColumnTypeNullableDefault
iduuidNO— (from auth)
usernametextNO—
first_nametextYES—
last_nametextYES—
emailtextYES—
phonetextYES—
biotextYES—
captiontextYES—
avatar_urltextYES—
cover_urltextYES—
websitetextYES—
categorytextYES—
countrytextYES—
citytextYES—
birth_daysmallintYES—
birth_monthsmallintYES—
birth_yearsmallintYES—
gendergender_typeYES—
roleuser_roleNO'user'
typeuser_typeNO'personal'
statususer_statusNO'active'
verifiedbooleanNOfalse
verified_attimestamptzYES—
themetextYES'system'
languagetextYES'en'
tipsbooleanNOfalse
is_ai_generatedbooleanNOfalse
followers_countintegerNO0
following_countintegerNO0
publications_countintegerNO0
last_activetimestamptzYES—
ip_addressinetYES—
stripe_customer_idtextYES—
subscription_statustextYES'free'
subscription_plantextYES—
subscription_expires_attimestamptzYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Extended profile for business users with Stripe Connect integration.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNOFK -> profiles.id
nametextNO—
logotextYES—
descriptiontextYES—
industry_iduuidYES—
business_emailtextYES—
business_phonetextYES—
address_line1textYES—
address_line2textYES—
citytextYES—
statetextYES—
postal_codetextYES—
countrytextYES—
tax_numbertextYES—
billing_addressjsonbYES'{}'
websitetextYES—
verifiedbooleanNOfalse
is_reviewedbooleanNOfalse
stripe_account_idtextYES—
stripe_onboarding_completebooleanNOfalse
stripe_charges_enabledbooleanNOfalse
stripe_payouts_enabledbooleanNOfalse
platform_fee_percentnumericNO5.00
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

OAuth provider accounts linked to a user.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNOFK -> profiles.id
provideroauth_providerNO—
provider_idtextNO—
provider_datajsonbYES'{}'
created_attimestamptzNOnow()

Social media links (polymorphic via linkable_type).

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
linkable_iduuidNO—
linkable_typetextNO—
platformtextNO—
urltextNO—
created_attimestamptzNOnow()

User device tracking.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNOFK -> profiles.id
device_nametextYES—
device_typetextYES—
user_agenttextYES—
ip_addressinetYES—
last_activetimestamptzYESnow()
created_attimestamptzNOnow()

User onboarding progress.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNOFK -> profiles.id
completedbooleanNOfalse
stepsmallintNO0
metadatajsonbYES'{}'
created_attimestamptzNOnow()
updated_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidYESFK -> profiles.id
reasontextYES—
feedbacktextYES—
created_attimestamptzNOnow()

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
follower_iduuidNOFK -> profiles.id
following_iduuidNOFK -> profiles.id
statusfollow_statusNO'following'
created_attimestamptzNOnow()

Polymorphic bookmarks (post, product, job).

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNOFK -> profiles.id
bookmarkable_iduuidNO—
bookmarkable_typebookmarkable_typeNO—
created_attimestamptzNOnow()

Polymorphic emoji reactions (via reactable_type).

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
reactable_iduuidNO—
reactable_typetextNO—
unified_idtextNO—
native_symboltextNO—
reactions_countintegerNO1
usersjsonbNO'[]'
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNOFK -> profiles.id
titletextYES—
contenttextYES—
statuspost_statusNO'draft'
typetextYES—
text_languagetextYES'en'
editedbooleanNOfalse
profile_pinnedbooleanNOfalse
global_pinnedbooleanNOfalse
is_sensitivebooleanNOfalse
is_ai_generatedbooleanNOfalse
views_countintegerNO0
comments_countintegerNO0
shares_countintegerNO0
bookmarks_countintegerNO0
quotes_countintegerNO0
quote_post_iduuidYESFK -> posts.id
preview_lqip_base64textYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Nested comments on posts (self-referencing via parent_id).

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
post_iduuidNOFK -> posts.id
user_iduuidNOFK -> profiles.id
parent_iduuidYESFK -> comments.id
contenttextNO—
text_languagetextYES'en'
reactions_countintegerNO0
created_attimestamptzNOnow()
updated_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
post_iduuidNOFK -> posts.id
choicesjsonbNO'[]'
votesjsonbNO'{}'
is_anonymousbooleanNOfalse
is_cancellablebooleanNOtrue
expires_attimestamptzYES—
metadatajsonbYES'{}'
created_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
post_iduuidNOFK -> posts.id
user_iduuidNOFK -> profiles.id
viewed_attimestamptzNOnow()

Polymorphic media attachments (via mediaable_type).

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
mediaable_iduuidNO—
mediaable_typetextNO—
source_pathtextNO—
thumbnail_pathtextYES—
lqip_base64textYES—
typemedia_typeNO—
statusmedia_statusNO'processed'
disktextYES'supabase'
extensiontextYES—
sizebigintYES—
mimetextYES—
visibilitytextYES'public'
ordersmallintYES0
metadatajsonbYES'{}'
created_attimestamptzNOnow()

Open Graph / URL preview cache.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
urltextNO—
titletextYES—
descriptiontextYES—
imagetextYES—
site_nametextYES—
metadatajsonbYES'{}'
created_attimestamptzNOnow()

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
chat_iduuidNOgen_random_uuid()
typechat_typeNO'direct'
last_activitytimestamptzYESnow()
created_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
chat_iduuidNOFK -> chats.id
user_iduuidNOFK -> profiles.id
last_read_message_iduuidYES—
metadatajsonbYES'{}'
last_read_attimestamptzYES—
joined_attimestamptzNOnow()

Supports replies (parent_id) and soft delete (is_deleted).

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
chat_iduuidNOFK -> chats.id
user_iduuidNOFK -> profiles.id
participant_iduuidYESFK -> chat_participants.id
parent_iduuidYESFK -> messages.id
contenttextYES—
is_deletedbooleanNOfalse
text_languagetextYES'en'
created_attimestamptzNOnow()
updated_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
chat_iduuidNOFK -> chats.id
inviter_iduuidNOFK -> profiles.id
invitee_iduuidNOFK -> profiles.id
statusinvite_statusNO'pending'
created_attimestamptzNOnow()

Group metadata extending a chat.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
chat_iduuidNOFK -> chats.id
user_iduuidNOFK -> profiles.id (owner)
avatartextYES—
nametextNO—
descriptiontextYES—
visibilitygroup_visibilityNO'private'
privacygroup_privacyNO'closed'
verifiedbooleanNOfalse
statustextYES'active'
verified_attimestamptzYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
chat_iduuidNOFK -> chats.id
user_iduuidNOFK -> profiles.id
created_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
chat_iduuidNOFK -> chats.id
user_iduuidNOFK -> profiles.id
created_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
message_iduuidNOFK -> messages.id
user_iduuidNOFK -> profiles.id
created_attimestamptzNOnow()

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
story_uuiduuidNOgen_random_uuid()
user_iduuidNOFK -> profiles.id
created_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
story_iduuidNOFK -> stories.id
contenttextYES—
statusstory_frame_statusNO'active'
typestory_frame_typeNO'image'
privacystory_privacyNO'all'
views_countintegerNO0
is_highlightbooleanNOfalse
duration_secondssmallintYES5
metajsonbYES'{}'
expires_attimestamptzNOnow() + 24h
created_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
story_frame_iduuidNOFK -> story_frames.id
user_iduuidNOFK -> profiles.id
viewed_attimestamptzNOnow()

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNOFK -> profiles.id
nametextNO—
captiontextYES—
descriptiontextYES—
logotextYES—
addresstextYES—
phonetextYES—
emailtextYES—
websitetextYES—
statustextNO'active'
ratingnumericYES0
products_countintegerNO0
reviews_countintegerNO0
created_attimestamptzNOnow()
updated_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
category_iduuidYESFK -> categories.id
store_iduuidYESFK -> stores.id
user_iduuidNOFK -> profiles.id
titletextNO—
descriptiontextYES—
approvalapproval_statusNO'pending'
statusproduct_statusNO'draft'
conditionproduct_conditionNO'new'
currencytextYES'USD'
stock_quantityintegerYES0
pricenumericNO0
ratingnumericYES0
discountnumericYES0
addresstextYES—
typeproduct_typeNO'physical'
views_countintegerNO0
contacts_countintegerNO0
reviews_countintegerNO0
bookmarks_countintegerNO0
last_contacted_attimestamptzYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
category_iduuidYESFK -> categories.id
user_iduuidNOFK -> profiles.id
titletextNO—
overviewtextYES—
descriptiontextYES—
approvalapproval_statusNO'pending'
statusjob_statusNO'active'
typejob_typeNO'full_time'
currencytextYES'USD'
budgetnumericYES—
is_urgentbooleanNOfalse
is_remotebooleanNOfalse
is_start_incomebooleanNOfalse
views_countintegerNO0
contacts_countintegerNO0
reviews_countintegerNO0
bookmarks_countintegerNO0
last_contacted_attimestamptzYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Polymorphic reviews (via reviewable_type).

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
reviewer_iduuidNOFK -> profiles.id
reviewee_iduuidNOFK -> profiles.id
reviewable_iduuidNO—
reviewable_typetextNO—
ratingsmallintNO—
contenttextYES—
created_attimestamptzNOnow()

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNOFK -> profiles.id
titletextNO—
contenttextYES—
cta_texttextYES—
statusad_statusNO'draft'
typetextYES—
total_budgetnumericNO0
spent_budgetnumericNO0
price_per_viewnumericNO0.01
target_urltextYES—
approvalapproval_statusNO'pending'
views_countintegerNO0
last_show_attimestamptzYES—
last_charge_attimestamptzYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNOFK -> profiles.id
balancenumericNO0
currencytextNO'USD'
wallet_numbertextNOsubstr(gen_random_uuid(), 1, 12)
created_attimestamptzNOnow()
updated_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
wallet_iduuidNOFK -> wallets.id
amountnumericNO—
commissionnumericYES0
currencytextNO'USD'
transaction_typetransaction_typeNO—
is_internalbooleanNOfalse
directiontransaction_directionNO—
statustransaction_statusNO'pending'
metadatajsonbYES'{}'
created_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNOFK -> profiles.id
payment_uuiduuidNOgen_random_uuid()
reference_idtextYES—
payment_typepayment_typeNO—
payment_methodtextYES—
statustransaction_statusNO'pending'
amountnumericNO—
currencytextNO'USD'
descriptiontextYES—
metadatajsonbYES'{}'
created_attimestamptzNOnow()

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNOFK -> profiles.id
push_enabledbooleanNOtrue
email_enabledbooleanNOtrue
preferencesjsonbNO{comment, mention, message, payment, reaction, new_follower, follow_request: all true}
created_attimestamptzNOnow()
updated_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNOFK -> profiles.id
profile_visibilitytextNO'public'
message_permissionstextNO'everyone'
comment_permissionstextNO'everyone'
follower_approvalbooleanNOfalse
show_activity_statusbooleanNOtrue
created_attimestamptzNOnow()
updated_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNOFK -> profiles.id
two_factor_enabledbooleanNOfalse
two_factor_secrettextYES—
settingsjsonbNO'{}'
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
admin_iduuidNOFK -> profiles.id
typetextNO—
blacklistabletextNO—
reasontextYES—
added_attimestamptzNOnow()
expires_attimestamptzYES—
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
admin_iduuidNOFK -> profiles.id
typetextNO—
leveltextNO'moderate'
patterntextNO—
replacementtextYES'***'
created_attimestamptzNOnow()

Polymorphic content reports (via reportable_type).

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
reporter_iduuidNOFK -> profiles.id
reportable_iduuidNO—
reportable_typetextNO—
statusreport_statusNO'pending'
reason_indexsmallintYES—
typetextYES—
reporter_commenttextYES—
created_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNOFK -> profiles.id
statusapproval_statusNO'pending'
metadatajsonbYES'{}'
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Polymorphic notifications (via notifiable_type).

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
typetextNO—
notifiable_iduuidNOFK -> profiles.id
notifiable_typetextNO'user'
datajsonbNO'{}'
read_attimestamptzYES—
created_attimestamptzNOnow()

Platform mini-apps / modules.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
slugtextNO—
nametextNO—
descriptiontextYES—
icontextYES—
schema_nametextNO—
manifestjsonbYES'{}'
is_activebooleanNOtrue
is_first_partybooleanNOtrue
requires_stripebooleanNOfalse
created_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNOFK -> profiles.id
app_iduuidNOFK -> apps.id
is_activebooleanNOtrue
configjsonbYES'{}'
installed_attimestamptzNOnow()

Self-referencing hierarchical categories.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
localizationjsonbNO'{}'
parent_iduuidYESFK -> categories.id
categorizable_typetextNO—
depthsmallintNO0
created_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
codetextNO—
nametextNO—
symboltextNO—
is_activebooleanNOtrue
created_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
codetextNO—
nametextNO—
native_nametextYES—
is_activebooleanNOtrue
created_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
nametextNO—
key_hashtextNO—
created_attimestamptzNOnow()

Aggregate media storage stats.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
media_typetextNO—
disktextNO'supabase'
content_sizebigintNO0
content_itemsintegerNO0
updated_attimestamptzNOnow()

profiles.id ──< account_deletion_feedback.user_id
profiles.id ──< ads.user_id
profiles.id ──< archived_chats.user_id
profiles.id ──< authorship_requests.user_id
profiles.id ──< blacklist.admin_id
profiles.id ──< bookmarks.user_id
profiles.id ──< business_accounts.user_id
profiles.id ──< censors.admin_id
profiles.id ──< chat_invites.inviter_id
profiles.id ──< chat_invites.invitee_id
profiles.id ──< chat_participants.user_id
profiles.id ──< comments.user_id
profiles.id ──< devices.user_id
profiles.id ──< follows.follower_id
profiles.id ──< follows.following_id
profiles.id ──< groups.user_id
profiles.id ──< hidden_chats.user_id
profiles.id ──< hidden_messages.user_id
profiles.id ──< job_listings.user_id
profiles.id ──< messages.user_id
profiles.id ──< notifications.notifiable_id
profiles.id ──< onboards.user_id
profiles.id ──< payments.user_id
profiles.id ──< post_views.user_id
profiles.id ──< posts.user_id
profiles.id ──< products.user_id
profiles.id ──< reports.reporter_id
profiles.id ──< reviews.reviewer_id
profiles.id ──< reviews.reviewee_id
profiles.id ──< social_accounts.user_id
profiles.id ──< stores.user_id
profiles.id ──< stories.user_id
profiles.id ──< story_views.user_id
profiles.id ──< user_apps.user_id
profiles.id ──< user_notification_settings.user_id
profiles.id ──< user_privacy_settings.user_id
profiles.id ──< user_security_settings.user_id
profiles.id ──< wallets.user_id
chats.id ──< archived_chats.chat_id
chats.id ──< chat_invites.chat_id
chats.id ──< chat_participants.chat_id
chats.id ──< groups.chat_id
chats.id ──< hidden_chats.chat_id
chats.id ──< messages.chat_id
posts.id ──< comments.post_id
posts.id ──< post_polls.post_id
posts.id ──< post_views.post_id
posts.id ──< posts.quote_post_id (self-ref)
comments.id ──< comments.parent_id (self-ref)
messages.id ──< messages.parent_id (self-ref)
messages.id ──< hidden_messages.message_id
categories.id ──< categories.parent_id (self-ref)
categories.id ──< job_listings.category_id
categories.id ──< products.category_id
stores.id ──< products.store_id
stories.id ──< story_frames.story_id
story_frames.id ──< story_views.story_frame_id
wallets.id ──< wallet_transactions.wallet_id
apps.id ──< user_apps.app_id
chat_participants.id ──< messages.participant_id