Skip to content

Blog Schema

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


Blog articles with publishing, SEO, and engagement tracking.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
author_iduuidNO—
category_iduuidYES—
titletextNO—
slugtextNO—
contenttextNO—
excerpttextYES—
featured_imagetextYES—
cover_image_urltextYES—
statustextNO'draft'
is_featuredbooleanNOfalse
allow_commentsbooleanNOtrue
tagstext[]NO'{}'
reading_time_minutesintegerNO0
view_countintegerNO0
metadatajsonbNO'{}'
published_attimestamptzYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Hierarchical blog categories.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
owner_iduuidNO—
nametextNO—
slugtextNO—
descriptiontextYES—
parent_iduuidYES—
sort_orderintegerNO0
created_attimestamptzNOnow()
updated_attimestamptzNOnow()