Blog Schema
ext_blog - Blog
Section titled “ext_blog - Blog”Schema: ext_blog | Auto-generated on 2026-03-30
articles
Section titled “articles”Blog articles with publishing, SEO, and engagement tracking.
| Column | Type | Nullable | Default |
|---|---|---|---|
id | uuid | NO | gen_random_uuid() |
author_id | uuid | NO | — |
category_id | uuid | YES | — |
title | text | NO | — |
slug | text | NO | — |
content | text | NO | — |
excerpt | text | YES | — |
featured_image | text | YES | — |
cover_image_url | text | YES | — |
status | text | NO | 'draft' |
is_featured | boolean | NO | false |
allow_comments | boolean | NO | true |
tags | text[] | NO | '{}' |
reading_time_minutes | integer | NO | 0 |
view_count | integer | NO | 0 |
metadata | jsonb | NO | '{}' |
published_at | timestamptz | YES | — |
created_at | timestamptz | NO | now() |
updated_at | timestamptz | NO | now() |
blog_categories
Section titled “blog_categories”Hierarchical blog categories.
| Column | Type | Nullable | Default |
|---|---|---|---|
id | uuid | NO | gen_random_uuid() |
owner_id | uuid | NO | — |
name | text | NO | — |
slug | text | NO | — |
description | text | YES | — |
parent_id | uuid | YES | — |
sort_order | integer | NO | 0 |
created_at | timestamptz | NO | now() |
updated_at | timestamptz | NO | now() |