Products Schema

ext_products - Digital Products

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

---

products

Digital product catalog.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
seller_id	uuid	NO	—
title	text	NO	—
slug	text	NO	—
description	text	YES	—
short_description	text	YES	—
price	numeric	NO	—
compare_price	numeric	YES	—
type	text	NO	'digital'
status	text	NO	'draft'
thumbnail_url	text	YES	—
sales_count	integer	NO	0
rating_avg	numeric	NO	0
rating_count	integer	NO	0
metadata	jsonb	NO	'{}'
published_at	timestamptz	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

product_files

Downloadable files for products.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
product_id	uuid	NO	—
title	text	NO	—
file_path	text	NO	—
file_size	integer	YES	—
file_type	text	YES	—
sort_order	integer	NO	0
created_at	timestamptz	NO	now()

product_media

Product images/videos.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
product_id	uuid	NO	—
url	text	NO	—
type	text	NO	'image'
sort_order	integer	NO	0
created_at	timestamptz	NO	now()

product_specifications

Product spec key-value pairs.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
product_id	uuid	NO	—
key	text	NO	—
value	text	NO	—
sort_order	integer	NO	0

product_orders

Product purchase records.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
product_id	uuid	NO	—
buyer_id	uuid	NO	—
seller_id	uuid	NO	—
payment_id	uuid	YES	—
amount	numeric	NO	—
status	text	NO	'pending'
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()