maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
The operational product catalog — one row per SKU with category, list price, and an active flag. The source of truth for product names referenced everywhere downstream. `name` is renamed to `product_name` in staging to avoid the SQL keyword.
8 of 8
Column
Description
Tests · PII
product_id
Primary key — BIGSERIAL on the source.
2 tests
sku
Stock-keeping unit code. Unique business identifier surfaced in BI.
2 tests
name
Human-readable product name (renamed to `product_name` in staging to avoid the SQL keyword).
category
Product category (e.g. `electronics`, `apparel`). Loose taxonomy, may be null.
unit_price
Catalog list price in the product's reporting currency. NUMERIC(10,2).
is_active
True if the product is currently sellable; false for archived/deleted catalog entries.
created_at
Row insert timestamp in the source DB.
updated_at
Row update timestamp in the source DB.