Public Schema

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

---

Table of Contents

• Enum Types
• Tables
  • Users & Profiles
  • Social & Follows
  • Posts & Content
  • Chat & Messaging
  • Stories
  • Marketplace (Products, Stores, Jobs)
  • Ads & Payments
  • Settings & Preferences
  • Admin & Moderation
  • System & Config
• Foreign Key Relationships

---

Enum Types

Enum Name	Values
ad_status	draft, active, paused
approval_status	pending, approved, rejected
bookmarkable_type	post, product, job
chat_type	direct, group
follow_status	following, requested
gender_type	male, female, other, prefer_not_to_say
group_privacy	open, closed
group_visibility	public, private
invite_status	pending, accepted, declined
job_status	active, closed
job_type	full_time, part_time, contract, freelance
media_status	processing, processed, failed
media_type	image, video, audio, document
oauth_provider	google, apple, twitter, facebook, discord, linkedin, tiktok, vk, telegram, microsoft, github
payment_type	deposit, withdrawal
post_status	draft, published, archived
product_condition	new, like_new, used
product_status	draft, active, inactive
product_type	physical, digital
report_status	pending, resolved, dismissed
story_frame_status	draft, active
story_frame_type	image, video
story_privacy	all, followers, friends
transaction_direction	incoming, outgoing
transaction_status	pending, completed, failed
transaction_type	deposit, withdrawal, transfer
user_role	user, admin, moderator
user_status	active, suspended, banned
user_type	personal, business

---

Tables

Users & Profiles

profiles

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

Column	Type	Nullable	Default
id	uuid	NO	— (from auth)
username	text	NO	—
first_name	text	YES	—
last_name	text	YES	—
email	text	YES	—
phone	text	YES	—
bio	text	YES	—
caption	text	YES	—
avatar_url	text	YES	—
cover_url	text	YES	—
website	text	YES	—
category	text	YES	—
country	text	YES	—
city	text	YES	—
birth_day	smallint	YES	—
birth_month	smallint	YES	—
birth_year	smallint	YES	—
gender	gender_type	YES	—
role	user_role	NO	'user'
type	user_type	NO	'personal'
status	user_status	NO	'active'
verified	boolean	NO	false
verified_at	timestamptz	YES	—
theme	text	YES	'system'
language	text	YES	'en'
tips	boolean	NO	false
is_ai_generated	boolean	NO	false
followers_count	integer	NO	0
following_count	integer	NO	0
publications_count	integer	NO	0
last_active	timestamptz	YES	—
ip_address	inet	YES	—
stripe_customer_id	text	YES	—
subscription_status	text	YES	'free'
subscription_plan	text	YES	—
subscription_expires_at	timestamptz	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

business_accounts

Extended profile for business users with Stripe Connect integration.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	FK -> profiles.id
name	text	NO	—
logo	text	YES	—
description	text	YES	—
industry_id	uuid	YES	—
business_email	text	YES	—
business_phone	text	YES	—
address_line1	text	YES	—
address_line2	text	YES	—
city	text	YES	—
state	text	YES	—
postal_code	text	YES	—
country	text	YES	—
tax_number	text	YES	—
billing_address	jsonb	YES	'{}'
website	text	YES	—
verified	boolean	NO	false
is_reviewed	boolean	NO	false
stripe_account_id	text	YES	—
stripe_onboarding_complete	boolean	NO	false
stripe_charges_enabled	boolean	NO	false
stripe_payouts_enabled	boolean	NO	false
platform_fee_percent	numeric	NO	5.00
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

social_accounts

OAuth provider accounts linked to a user.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	FK -> profiles.id
provider	oauth_provider	NO	—
provider_id	text	NO	—
provider_data	jsonb	YES	'{}'
created_at	timestamptz	NO	now()

social_links

Social media links (polymorphic via linkable_type).

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
linkable_id	uuid	NO	—
linkable_type	text	NO	—
platform	text	NO	—
url	text	NO	—
created_at	timestamptz	NO	now()

devices

User device tracking.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	FK -> profiles.id
device_name	text	YES	—
device_type	text	YES	—
user_agent	text	YES	—
ip_address	inet	YES	—
last_active	timestamptz	YES	now()
created_at	timestamptz	NO	now()

onboards

User onboarding progress.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	FK -> profiles.id
completed	boolean	NO	false
step	smallint	NO	0
metadata	jsonb	YES	'{}'
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

account_deletion_feedback

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	YES	FK -> profiles.id
reason	text	YES	—
feedback	text	YES	—
created_at	timestamptz	NO	now()

---

Social & Follows

follows

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
follower_id	uuid	NO	FK -> profiles.id
following_id	uuid	NO	FK -> profiles.id
status	follow_status	NO	'following'
created_at	timestamptz	NO	now()

bookmarks

Polymorphic bookmarks (post, product, job).

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	FK -> profiles.id
bookmarkable_id	uuid	NO	—
bookmarkable_type	bookmarkable_type	NO	—
created_at	timestamptz	NO	now()

reactions

Polymorphic emoji reactions (via reactable_type).

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
reactable_id	uuid	NO	—
reactable_type	text	NO	—
unified_id	text	NO	—
native_symbol	text	NO	—
reactions_count	integer	NO	1
users	jsonb	NO	'[]'
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

---

Posts & Content

posts

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	FK -> profiles.id
title	text	YES	—
content	text	YES	—
status	post_status	NO	'draft'
type	text	YES	—
text_language	text	YES	'en'
edited	boolean	NO	false
profile_pinned	boolean	NO	false
global_pinned	boolean	NO	false
is_sensitive	boolean	NO	false
is_ai_generated	boolean	NO	false
views_count	integer	NO	0
comments_count	integer	NO	0
shares_count	integer	NO	0
bookmarks_count	integer	NO	0
quotes_count	integer	NO	0
quote_post_id	uuid	YES	FK -> posts.id
preview_lqip_base64	text	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

comments

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

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
post_id	uuid	NO	FK -> posts.id
user_id	uuid	NO	FK -> profiles.id
parent_id	uuid	YES	FK -> comments.id
content	text	NO	—
text_language	text	YES	'en'
reactions_count	integer	NO	0
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

post_polls

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
post_id	uuid	NO	FK -> posts.id
choices	jsonb	NO	'[]'
votes	jsonb	NO	'{}'
is_anonymous	boolean	NO	false
is_cancellable	boolean	NO	true
expires_at	timestamptz	YES	—
metadata	jsonb	YES	'{}'
created_at	timestamptz	NO	now()

post_views

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
post_id	uuid	NO	FK -> posts.id
user_id	uuid	NO	FK -> profiles.id
viewed_at	timestamptz	NO	now()

media

Polymorphic media attachments (via mediaable_type).

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
mediaable_id	uuid	NO	—
mediaable_type	text	NO	—
source_path	text	NO	—
thumbnail_path	text	YES	—
lqip_base64	text	YES	—
type	media_type	NO	—
status	media_status	NO	'processed'
disk	text	YES	'supabase'
extension	text	YES	—
size	bigint	YES	—
mime	text	YES	—
visibility	text	YES	'public'
order	smallint	YES	0
metadata	jsonb	YES	'{}'
created_at	timestamptz	NO	now()

link_snapshots

Open Graph / URL preview cache.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
url	text	NO	—
title	text	YES	—
description	text	YES	—
image	text	YES	—
site_name	text	YES	—
metadata	jsonb	YES	'{}'
created_at	timestamptz	NO	now()

---

Chat & Messaging

chats

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
chat_id	uuid	NO	gen_random_uuid()
type	chat_type	NO	'direct'
last_activity	timestamptz	YES	now()
created_at	timestamptz	NO	now()

chat_participants

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
chat_id	uuid	NO	FK -> chats.id
user_id	uuid	NO	FK -> profiles.id
last_read_message_id	uuid	YES	—
metadata	jsonb	YES	'{}'
last_read_at	timestamptz	YES	—
joined_at	timestamptz	NO	now()

messages

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

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
chat_id	uuid	NO	FK -> chats.id
user_id	uuid	NO	FK -> profiles.id
participant_id	uuid	YES	FK -> chat_participants.id
parent_id	uuid	YES	FK -> messages.id
content	text	YES	—
is_deleted	boolean	NO	false
text_language	text	YES	'en'
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

chat_invites

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
chat_id	uuid	NO	FK -> chats.id
inviter_id	uuid	NO	FK -> profiles.id
invitee_id	uuid	NO	FK -> profiles.id
status	invite_status	NO	'pending'
created_at	timestamptz	NO	now()

groups

Group metadata extending a chat.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
chat_id	uuid	NO	FK -> chats.id
user_id	uuid	NO	FK -> profiles.id (owner)
avatar	text	YES	—
name	text	NO	—
description	text	YES	—
visibility	group_visibility	NO	'private'
privacy	group_privacy	NO	'closed'
verified	boolean	NO	false
status	text	YES	'active'
verified_at	timestamptz	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

archived_chats

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
chat_id	uuid	NO	FK -> chats.id
user_id	uuid	NO	FK -> profiles.id
created_at	timestamptz	NO	now()

hidden_chats

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
chat_id	uuid	NO	FK -> chats.id
user_id	uuid	NO	FK -> profiles.id
created_at	timestamptz	NO	now()

hidden_messages

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
message_id	uuid	NO	FK -> messages.id
user_id	uuid	NO	FK -> profiles.id
created_at	timestamptz	NO	now()

---

Stories

stories

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
story_uuid	uuid	NO	gen_random_uuid()
user_id	uuid	NO	FK -> profiles.id
created_at	timestamptz	NO	now()

story_frames

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
story_id	uuid	NO	FK -> stories.id
content	text	YES	—
status	story_frame_status	NO	'active'
type	story_frame_type	NO	'image'
privacy	story_privacy	NO	'all'
views_count	integer	NO	0
is_highlight	boolean	NO	false
duration_seconds	smallint	YES	5
meta	jsonb	YES	'{}'
expires_at	timestamptz	NO	now() + 24h
created_at	timestamptz	NO	now()

story_views

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
story_frame_id	uuid	NO	FK -> story_frames.id
user_id	uuid	NO	FK -> profiles.id
viewed_at	timestamptz	NO	now()

---

Marketplace

stores

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	FK -> profiles.id
name	text	NO	—
caption	text	YES	—
description	text	YES	—
logo	text	YES	—
address	text	YES	—
phone	text	YES	—
email	text	YES	—
website	text	YES	—
status	text	NO	'active'
rating	numeric	YES	0
products_count	integer	NO	0
reviews_count	integer	NO	0
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

products

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
category_id	uuid	YES	FK -> categories.id
store_id	uuid	YES	FK -> stores.id
user_id	uuid	NO	FK -> profiles.id
title	text	NO	—
description	text	YES	—
approval	approval_status	NO	'pending'
status	product_status	NO	'draft'
condition	product_condition	NO	'new'
currency	text	YES	'USD'
stock_quantity	integer	YES	0
price	numeric	NO	0
rating	numeric	YES	0
discount	numeric	YES	0
address	text	YES	—
type	product_type	NO	'physical'
views_count	integer	NO	0
contacts_count	integer	NO	0
reviews_count	integer	NO	0
bookmarks_count	integer	NO	0
last_contacted_at	timestamptz	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

job_listings

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
category_id	uuid	YES	FK -> categories.id
user_id	uuid	NO	FK -> profiles.id
title	text	NO	—
overview	text	YES	—
description	text	YES	—
approval	approval_status	NO	'pending'
status	job_status	NO	'active'
type	job_type	NO	'full_time'
currency	text	YES	'USD'
budget	numeric	YES	—
is_urgent	boolean	NO	false
is_remote	boolean	NO	false
is_start_income	boolean	NO	false
views_count	integer	NO	0
contacts_count	integer	NO	0
reviews_count	integer	NO	0
bookmarks_count	integer	NO	0
last_contacted_at	timestamptz	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

reviews

Polymorphic reviews (via reviewable_type).

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
reviewer_id	uuid	NO	FK -> profiles.id
reviewee_id	uuid	NO	FK -> profiles.id
reviewable_id	uuid	NO	—
reviewable_type	text	NO	—
rating	smallint	NO	—
content	text	YES	—
created_at	timestamptz	NO	now()

---

Ads & Payments

ads

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	FK -> profiles.id
title	text	NO	—
content	text	YES	—
cta_text	text	YES	—
status	ad_status	NO	'draft'
type	text	YES	—
total_budget	numeric	NO	0
spent_budget	numeric	NO	0
price_per_view	numeric	NO	0.01
target_url	text	YES	—
approval	approval_status	NO	'pending'
views_count	integer	NO	0
last_show_at	timestamptz	YES	—
last_charge_at	timestamptz	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

wallets

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	FK -> profiles.id
balance	numeric	NO	0
currency	text	NO	'USD'
wallet_number	text	NO	substr(gen_random_uuid(), 1, 12)
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

wallet_transactions

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
wallet_id	uuid	NO	FK -> wallets.id
amount	numeric	NO	—
commission	numeric	YES	0
currency	text	NO	'USD'
transaction_type	transaction_type	NO	—
is_internal	boolean	NO	false
direction	transaction_direction	NO	—
status	transaction_status	NO	'pending'
metadata	jsonb	YES	'{}'
created_at	timestamptz	NO	now()

payments

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	FK -> profiles.id
payment_uuid	uuid	NO	gen_random_uuid()
reference_id	text	YES	—
payment_type	payment_type	NO	—
payment_method	text	YES	—
status	transaction_status	NO	'pending'
amount	numeric	NO	—
currency	text	NO	'USD'
description	text	YES	—
metadata	jsonb	YES	'{}'
created_at	timestamptz	NO	now()

---

Settings & Preferences

user_notification_settings

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	FK -> profiles.id
push_enabled	boolean	NO	true
email_enabled	boolean	NO	true
preferences	jsonb	NO	{comment, mention, message, payment, reaction, new_follower, follow_request: all true}
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

user_privacy_settings

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	FK -> profiles.id
profile_visibility	text	NO	'public'
message_permissions	text	NO	'everyone'
comment_permissions	text	NO	'everyone'
follower_approval	boolean	NO	false
show_activity_status	boolean	NO	true
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

user_security_settings

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	FK -> profiles.id
two_factor_enabled	boolean	NO	false
two_factor_secret	text	YES	—
settings	jsonb	NO	'{}'
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

---

Admin & Moderation

blacklist

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
admin_id	uuid	NO	FK -> profiles.id
type	text	NO	—
blacklistable	text	NO	—
reason	text	YES	—
added_at	timestamptz	NO	now()
expires_at	timestamptz	YES	—

censors

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
admin_id	uuid	NO	FK -> profiles.id
type	text	NO	—
level	text	NO	'moderate'
pattern	text	NO	—
replacement	text	YES	'***'
created_at	timestamptz	NO	now()

reports

Polymorphic content reports (via reportable_type).

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
reporter_id	uuid	NO	FK -> profiles.id
reportable_id	uuid	NO	—
reportable_type	text	NO	—
status	report_status	NO	'pending'
reason_index	smallint	YES	—
type	text	YES	—
reporter_comment	text	YES	—
created_at	timestamptz	NO	now()

authorship_requests

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	FK -> profiles.id
status	approval_status	NO	'pending'
metadata	jsonb	YES	'{}'
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

---

System & Config

notifications

Polymorphic notifications (via notifiable_type).

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
type	text	NO	—
notifiable_id	uuid	NO	FK -> profiles.id
notifiable_type	text	NO	'user'
data	jsonb	NO	'{}'
read_at	timestamptz	YES	—
created_at	timestamptz	NO	now()

apps

Platform mini-apps / modules.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
slug	text	NO	—
name	text	NO	—
description	text	YES	—
icon	text	YES	—
schema_name	text	NO	—
manifest	jsonb	YES	'{}'
is_active	boolean	NO	true
is_first_party	boolean	NO	true
requires_stripe	boolean	NO	false
created_at	timestamptz	NO	now()

user_apps

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	FK -> profiles.id
app_id	uuid	NO	FK -> apps.id
is_active	boolean	NO	true
config	jsonb	YES	'{}'
installed_at	timestamptz	NO	now()

categories

Self-referencing hierarchical categories.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
localization	jsonb	NO	'{}'
parent_id	uuid	YES	FK -> categories.id
categorizable_type	text	NO	—
depth	smallint	NO	0
created_at	timestamptz	NO	now()

currencies

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
code	text	NO	—
name	text	NO	—
symbol	text	NO	—
is_active	boolean	NO	true
created_at	timestamptz	NO	now()

locales

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
code	text	NO	—
name	text	NO	—
native_name	text	YES	—
is_active	boolean	NO	true
created_at	timestamptz	NO	now()

api_keys

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
name	text	NO	—
key_hash	text	NO	—
created_at	timestamptz	NO	now()

data_stats

Aggregate media storage stats.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
media_type	text	NO	—
disk	text	NO	'supabase'
content_size	bigint	NO	0
content_items	integer	NO	0
updated_at	timestamptz	NO	now()

---

Foreign Key Relationships

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