Data model
Sealed products
Sealed product catalogue: boxes, bundles and decks, priced only where a user owns one.
12 columns. Every value below is generated from the provenance registry.
| Field | Type | Source | Updated | Written by |
|---|---|---|---|---|
| id | string | calculated | never | database |
| Internal UUID primary key. | ||||
| mtgjson_uuid | string | mtgjson | on set release | scripts/seed-sealed-products.ts |
| MTGJSON SealedProduct uuid — the product's stable identity. | ||||
| name | string | mtgjson | on set release | scripts/seed-sealed-products.ts |
| Product display name (booster box, bundle, precon product, …). | ||||
| set_code | string | mtgjson | on set release | scripts/seed-sealed-products.ts |
| Owning set code. | ||||
| set_name | string | mtgjson | on set release | scripts/seed-sealed-products.ts |
| Owning set display name. | ||||
| category | string | mtgjson | on set release | scripts/seed-sealed-products.ts |
| Normalized product category (booster_box, bundle, deck, …), derived from MTGJSON category/subtype. | ||||
| subtype | string | null | mtgjson | on set release | scripts/seed-sealed-products.ts |
| MTGJSON product subtype; NULL when absent. | ||||
| image_url | string | null | mtgjson | on set release | scripts/seed-sealed-products.ts |
| Product image URL; currently unpopulated (null) — no sealed image source wired yet. | ||||
| price_usd | number | null | unmaintained | not refreshed | none |
| Last known sealed retail USD price. No job refreshes it; read prices_updated_at before using it. | ||||
| prices_updated_at | string | null | unmaintained | not refreshed | none |
| When price_usd was last written. Nothing has written it since the sealed price vendor was decommissioned. | ||||
| released_at | string | null | mtgjson | on set release | scripts/seed-sealed-products.ts |
| Product release date; falls back to the set release date. | ||||
| tcgplayer_product_id | string | null | mtgjson | on set release | scripts/seed-sealed-products.ts |
| TCGplayer product id, used as the buy-link target. | ||||
TypeScript model
interface sealed_products {
id: string
mtgjson_uuid: string
name: string
set_code: string
set_name: string
category: string
subtype: string | null
image_url: string | null
price_usd: number | null
prices_updated_at: string | null
released_at: string | null
tcgplayer_product_id: string | null
}