product_categories

Many-to-many link between products and categories

6 rows where product_id = "s9361aug2n"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id category_id
s9361aug2n,19 Royal Red bukett s9361aug2n Buketter 19
s9361aug2n,24 Royal Red bukett s9361aug2n Morsdag 24
s9361aug2n,35 Royal Red bukett s9361aug2n Bestselger 35
s9361aug2n,37 Royal Red bukett s9361aug2n Valentines 37
s9361aug2n,40 Royal Red bukett s9361aug2n Romanse 40
s9361aug2n,48 Royal Red bukett s9361aug2n Rod 48

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