product_translations

92 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at, created_at (date)

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