DATA_SOURCE: duckdb - Ecommerce platform — customers, orders, products, inventory, and marketing. DuckDB backend. Run `python seed.py` to initialise.
CONTEXT: inventory - Stock levels, reorder thresholds, and product catalogue. Use this context to monitor warehouse quantities and flag products that need restocking. (v1.0)
DATASET: main - Primary ecommerce schema
TABLES:
main.inventory|Current stock quantities by product and warehouse. reorder_point is the minimum quantity that triggers a purchase order. When quantity <= reorder_point, the product needs restocking. FK: product_id → products.id.|id:I[PK]|product_id:I[FK:products.id]|warehouse:S|quantity:I|reorder_point:I|updated_at:TS
main.products|Full product catalogue including cost and active status. active=FALSE means the product is discontinued (may still have inventory). FK: category_id → categories.id.|id:I[PK]|sku:S|name:S|description:S|price:N|cost:N|category_id:I[FK:categories.id]|active:B|created_at:D
main.categories|Product categories: Electronics, Clothing, Books, Home. Use for category-level inventory summaries.|id:I[PK]|name:S|slug:S|description:S
