product_categories

Many-to-many link between products and categories

8 rows where product_id = "0bwqcf8ooa"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id category_id
0bwqcf8ooa,23 Lime Pink Decor 0bwqcf8ooa Mothers Day 23
0bwqcf8ooa,24 Lime Pink Decor 0bwqcf8ooa Morsdag 24
0bwqcf8ooa,30 Lime Pink Decor 0bwqcf8ooa Floral Arrangements 30
0bwqcf8ooa,35 Lime Pink Decor 0bwqcf8ooa Bestselger 35
0bwqcf8ooa,74 Lime Pink Decor 0bwqcf8ooa Best Sellers 74
0bwqcf8ooa,82 Lime Pink Decor 0bwqcf8ooa Decoration 82
0bwqcf8ooa,94 Lime Pink Decor 0bwqcf8ooa Rosa 94
0bwqcf8ooa,99 Lime Pink Decor 0bwqcf8ooa Pink 99

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