product_translations

0 rows where no_product_id = "56ktg2xz1k"

✎ View and edit SQL

This data as json

0 records

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);