product_categories

Many-to-many link between products and categories

7 rows where product_id = "xi1iwix2km"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id category_id
xi1iwix2km,19 Lily Delight xi1iwix2km Buketter 19
xi1iwix2km,42 Lily Delight xi1iwix2km Orange 42
xi1iwix2km,51 Lily Delight xi1iwix2km Bouquets 51
xi1iwix2km,54 Lily Delight xi1iwix2km Snittblomster 54
xi1iwix2km,63 Lily Delight xi1iwix2km Fresh Cut Flowers 63
xi1iwix2km,79 Lily Delight xi1iwix2km Oransj 79
xi1iwix2km,719 Lily Delight xi1iwix2km OutOfSeason 719

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