Biolinks Schema

ext_biolinks - Bio Links

Schema: ext_biolinks | Auto-generated on 2026-03-30

---

pages

Bio link landing pages.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	—
title	text	NO	—
slug	text	NO	—
description	text	YES	—
avatar_url	text	YES	—
status	text	NO	'active'
seo_title	text	YES	—
seo_description	text	YES	—
og_image_url	text	YES	—
custom_css	text	YES	—
is_default	boolean	NO	false
metadata	jsonb	YES	'{}'
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

blocks

Content blocks within a bio link page (links, text, embeds, etc.).

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
page_id	uuid	NO	—
type	text	NO	—
title	text	YES	—
content	text	YES	—
icon	text	YES	—
thumbnail_url	text	YES	—
settings	jsonb	NO	'{}'
sort_order	smallint	NO	0
is_active	boolean	NO	true
starts_at	timestamptz	YES	—
ends_at	timestamptz	YES	—
metadata	jsonb	YES	'{}'
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

page_themes

Theme/style configuration for bio link pages.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
page_id	uuid	NO	—
theme	text	NO	'default'
background_type	text	NO	'color'
background_value	text	NO	'#ffffff'
font_family	text	YES	—
font_color	text	YES	—
button_style	text	NO	'rounded'
button_color	text	NO	'#000000'
button_text_color	text	NO	'#ffffff'
animation	text	YES	—
metadata	jsonb	YES	'{}'
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()