Note

    schema

    Source Summary CREATE TABLE IF NOT EXISTS shops ( id TEXT PRIMARY KEY, shopifydomain TEXT NOT NULL UNIQUE, accesstoken TEXT NOT NULL, createdat TEXT NOT NULL...

    Source Summary

    CREATE TABLE IF NOT EXISTS shops ( id TEXT PRIMARY KEY, shopify_domain TEXT NOT NULL UNIQUE, access_token TEXT NOT NULL, created_at TEXT NOT NULL ); CREATE TABLE IF NOT EXISTS products ( id TEXT PRIMARY KEY, shop_id TEXT NOT NULL, shopify_product_id TEXT, current_release_id TEXT, prompt_id TEXT, created_at TEXT NOT NUL

    Imported Context

    CREATE TABLE IF NOT EXISTS shops ( id TEXT PRIMARY KEY, shopify_domain TEXT NOT NULL UNIQUE, access_token TEXT NOT NULL, created_at TEXT NOT NULL );

    CREATE TABLE IF NOT EXISTS products ( id TEXT PRIMARY KEY, shop_id TEXT NOT NULL, shopify_product_id TEXT, current_release_id TEXT, prompt_id TEXT, created_at TEXT NOT NULL, FOREIGN KEY (shop_id) REFERENCES shops(id) );

    CREATE TABLE IF NOT EXISTS releases ( id TEXT PRIMARY KEY, product_id TEXT NOT NULL, version TEXT NOT NULL, status TEXT NOT NULL, created_at TEXT NOT NULL, FOREIGN KEY (product_id) REFERENCES products(id) );

    CREATE TABLE IF NOT EXISTS assets ( id TEXT PRIMARY KEY, release_id TEXT NOT NULL, key TEXT NOT NULL, checksum TEXT NOT NULL, mime TEXT NOT NULL, width INTEGER, height INTEGER, size INTEGER NOT NULL, variant_label TEXT NOT NULL, created_at TEXT NOT NULL, FOREIGN KEY (release_id) REFERENCES releases(id) );

    CREATE TABLE IF NOT EXISTS prompts ( id TEXT PRIMARY KEY, shop_id TEXT NOT NULL, raw_prompt TEXT NOT NULL, provider TEXT NOT NULL, model TEXT NOT NULL, output_summary TEXT, created_at TEXT NOT NULL, FOREIGN KEY (shop_id) REFERENCES shops(id) );

    CREATE TABLE IF NOT EXISTS jobs ( id TEXT PRIMARY KEY, shop_id TEXT NOT NULL, type TEXT NOT NULL, status TEXT NOT NULL, input_payload TEXT NOT NULL, output_payload TEXT, error TEXT, group_id TEXT, item_index INTEGER, created_at TEXT NOT NULL, updated_at TEXT NOT NULL, FOREIGN KEY (shop_id) REFERENCES shops(id) );

    CREATE TABLE IF NOT EXISTS entitlements ( id TEXT PRIMARY KEY, shop_id TEXT NOT NULL, order_id TEXT NOT NULL, customer_id TEXT, release_id TEXT NOT NULL, token TEXT NOT NULL, expires_at TEXT NOT NULL, created_at TEXT NOT NULL, FOREIGN KEY (shop_id) REFERENCES shops(id) );

    CREATE INDEX IF NOT EXISTS idx_jobs_status ON jobs(status); CREATE INDEX IF NOT EXISTS idx_jobs_group ON jobs(group_id); CREATE INDEX IF NOT EXISTS idx_assets_release ON assets(release_id); CREATE INDEX IF NOT EXISTS idx_entitlements_token ON entitlements(token);

    Provenance