Website Builder Schema

ext_builder - Website Builder

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

---

projects

Website builder projects.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	—
name	text	NO	—
slug	text	NO	—
uuid	uuid	NO	gen_random_uuid()
status	text	NO	'draft'
template_slug	text	YES	—
thumbnail_url	text	YES	—
settings	jsonb	NO	'{}'
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

pages

Individual pages within a builder project.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
project_id	uuid	NO	—
name	text	NO	—
slug	text	NO	—
html_content	text	NO	''
css_content	text	NO	''
js_content	text	NO	''
sort_order	integer	NO	0
meta_title	text	YES	—
meta_description	text	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

published_sites

Published/deployed sites from builder projects.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
project_id	uuid	NO	—
user_id	uuid	NO	—
subdomain	text	YES	—
domain_id	uuid	YES	—
forms_email	text	YES	—
is_live	boolean	NO	false
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

templates

Pre-built website templates.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	YES	—
name	text	NO	—
slug	text	NO	—
category	text	NO	'Landing Page'
description	text	YES	—
thumbnail_url	text	YES	—
config	jsonb	NO	'{}'
is_system	boolean	NO	true
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

template_pages

Pages within a template.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
template_id	uuid	NO	—
name	text	NO	—
html_content	text	NO	''
sort_order	integer	NO	0

form_submissions

Form data submitted on published sites.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
site_id	uuid	NO	—
form_data	jsonb	NO	'{}'
ip_address	text	YES	—
submitted_at	timestamptz	NO	now()

ftp_profiles

FTP deployment targets for site export.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	—
label	text	NO	—
host	text	NO	—
port	integer	NO	21
username	text	NO	—
encrypted_password	text	NO	—
directory	text	NO	'/'
use_ssl	boolean	NO	false
passive_mode	boolean	NO	true
created_at	timestamptz	NO	now()

ai_generations

AI-generated content for the builder.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	—
type	text	NO	—
prompt	text	NO	—
response	text	NO	—
tokens_used	integer	NO	0
model	text	NO	—
created_at	timestamptz	NO	now()