Autonomous Retail Market Intelligence for High-Volatility Hardware E-Commerce

-- Production Staging Table
CREATE SCHEMA IF NOT EXISTS staging;

CREATE TABLE staging.stg_scraped_products (
    staging_id          BIGSERIAL PRIMARY KEY,
    batch_id            UUID NOT NULL,
    source_name         VARCHAR(50) NOT NULL,
    raw_product_name    TEXT NOT NULL,
    raw_category        VARCHAR(100),
    raw_price           VARCHAR(100),
    raw_rating          VARCHAR(50),
    raw_availability    VARCHAR(100),
    product_url         TEXT NOT NULL,
    extracted_at        TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    checksum            CHAR(64) NOT NULL,
    is_processed        BOOLEAN NOT NULL DEFAULT FALSE,
    error_message       TEXT
);