Skip to content

Products Schema

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


Digital product catalog.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
seller_iduuidNO—
titletextNO—
slugtextNO—
descriptiontextYES—
short_descriptiontextYES—
pricenumericNO—
compare_pricenumericYES—
typetextNO'digital'
statustextNO'draft'
thumbnail_urltextYES—
sales_countintegerNO0
rating_avgnumericNO0
rating_countintegerNO0
metadatajsonbNO'{}'
published_attimestamptzYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Downloadable files for products.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
product_iduuidNO—
titletextNO—
file_pathtextNO—
file_sizeintegerYES—
file_typetextYES—
sort_orderintegerNO0
created_attimestamptzNOnow()

Product images/videos.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
product_iduuidNO—
urltextNO—
typetextNO'image'
sort_orderintegerNO0
created_attimestamptzNOnow()

Product spec key-value pairs.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
product_iduuidNO—
keytextNO—
valuetextNO—
sort_orderintegerNO0

Product purchase records.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
product_iduuidNO—
buyer_iduuidNO—
seller_iduuidNO—
payment_iduuidYES—
amountnumericNO—
statustextNO'pending'
created_attimestamptzNOnow()
updated_attimestamptzNOnow()