product_categories

Many-to-many link between products and categories

8 rows where product_id = "6g0dtjzbqf"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id category_id
6g0dtjzbqf,16 Pastel Pure 6g0dtjzbqf Summer 16
6g0dtjzbqf,18 Pastel Pure 6g0dtjzbqf White 18
6g0dtjzbqf,29 Pastel Pure 6g0dtjzbqf Sommer 29
6g0dtjzbqf,30 Pastel Pure 6g0dtjzbqf Floral Arrangements 30
6g0dtjzbqf,53 Pastel Pure 6g0dtjzbqf Spring 53
6g0dtjzbqf,82 Pastel Pure 6g0dtjzbqf Decoration 82
6g0dtjzbqf,83 Pastel Pure 6g0dtjzbqf Var 83
6g0dtjzbqf,93 Pastel Pure 6g0dtjzbqf 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)
);