Schema

products

The product catalog.

student_ro:No access

Not accessible via student_ro

This table is documented for completeness. With a direct connection you cannot query it; use the REST endpoint instead.

Columns#

Column	Type	Nullable	Notes
`id`	bigint	No	Primary key.
`cost`	numeric(12,2)	No	Unit cost to StyleHub.
`category`	text	No	Product category, e.g. Jeans.
`name`	text	No	Display name.
`brand`	text	Yes	Brand name.
`retail_price`	numeric(12,2)	No	List price in USD.
`department`	text	No	e.g. Men, Women.
`sku`	text	No	Stock keeping unit.
`created_at`	timestamptz	No	When the row was created. Indexed.
`updated_at`	timestamptz	No	When the row was last modified. Equals created_at until the row changes. May not be indexed.

Filter on updated_at for incremental loads — see Incremental loading.