Skip to content

Website Builder Schema

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


Website builder projects.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNO—
nametextNO—
slugtextNO—
uuiduuidNOgen_random_uuid()
statustextNO'draft'
template_slugtextYES—
thumbnail_urltextYES—
settingsjsonbNO'{}'
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Individual pages within a builder project.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
project_iduuidNO—
nametextNO—
slugtextNO—
html_contenttextNO''
css_contenttextNO''
js_contenttextNO''
sort_orderintegerNO0
meta_titletextYES—
meta_descriptiontextYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Published/deployed sites from builder projects.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
project_iduuidNO—
user_iduuidNO—
subdomaintextYES—
domain_iduuidYES—
forms_emailtextYES—
is_livebooleanNOfalse
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Pre-built website templates.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidYES—
nametextNO—
slugtextNO—
categorytextNO'Landing Page'
descriptiontextYES—
thumbnail_urltextYES—
configjsonbNO'{}'
is_systembooleanNOtrue
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Pages within a template.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
template_iduuidNO—
nametextNO—
html_contenttextNO''
sort_orderintegerNO0

Form data submitted on published sites.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
site_iduuidNO—
form_datajsonbNO'{}'
ip_addresstextYES—
submitted_attimestamptzNOnow()

FTP deployment targets for site export.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNO—
labeltextNO—
hosttextNO—
portintegerNO21
usernametextNO—
encrypted_passwordtextNO—
directorytextNO'/'
use_sslbooleanNOfalse
passive_modebooleanNOtrue
created_attimestamptzNOnow()

AI-generated content for the builder.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNO—
typetextNO—
prompttextNO—
responsetextNO—
tokens_usedintegerNO0
modeltextNO—
created_attimestamptzNOnow()