product_categories

Many-to-many link between products and categories

5 rows where product_id = "wqt2evp14c"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id category_id
wqt2evp14c,24 Blissfull Love wqt2evp14c Morsdag 24
wqt2evp14c,37 Blissfull Love wqt2evp14c Valentines 37
wqt2evp14c,40 Blissfull Love wqt2evp14c Romanse 40
wqt2evp14c,47 Blissfull Love wqt2evp14c Hjerter 47
wqt2evp14c,94 Blissfull Love wqt2evp14c Rosa 94

Advanced export

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

CSV options: 

CREATE TABLE product_categories (
    product_id TEXT NOT NULL,
    category_id INTEGER NOT NULL,
    PRIMARY KEY (product_id, category_id),
    FOREIGN KEY (product_id) REFERENCES products(id),
    FOREIGN KEY (category_id) REFERENCES categories(id)
);