product_categories

Many-to-many link between products and categories

7 rows where product_id = "1hkfu96x1o"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id category_id
1hkfu96x1o,10 Precious Spring Bliss 1hkfu96x1o Baby 10
1hkfu96x1o,18 Precious Spring Bliss 1hkfu96x1o White 18
1hkfu96x1o,53 Precious Spring Bliss 1hkfu96x1o Spring 53
1hkfu96x1o,54 Precious Spring Bliss 1hkfu96x1o Snittblomster 54
1hkfu96x1o,63 Precious Spring Bliss 1hkfu96x1o Fresh Cut Flowers 63
1hkfu96x1o,83 Precious Spring Bliss 1hkfu96x1o Var 83
1hkfu96x1o,93 Precious Spring Bliss 1hkfu96x1o Hvit 93

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