product_translations

Norwegian to English product mappings

1 row where no_product_id = "hbhfz09a70"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date)

id ▼ no_product_id en_product_id verified notes created_at
20 Preserved Mystique hbhfz09a70 Preserved Mystique ov16q0g9gg 1   2026-02-03 21:08:43

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE product_translations (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    no_product_id TEXT NOT NULL,
    en_product_id TEXT NOT NULL,
    verified INTEGER DEFAULT 0,  -- 1 if manually verified
    notes TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (no_product_id) REFERENCES products(id),
    FOREIGN KEY (en_product_id) REFERENCES products(id),
    UNIQUE(no_product_id, en_product_id)
);
CREATE INDEX idx_product_translations_no ON product_translations(no_product_id);
CREATE INDEX idx_product_translations_en ON product_translations(en_product_id);