product_categories

Many-to-many link between products and categories

11 rows where product_id = "pn6jqqrwrr"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id category_id
pn6jqqrwrr,6 Amethyst Love Box pn6jqqrwrr Blomster i en boks 6
pn6jqqrwrr,11 Amethyst Love Box pn6jqqrwrr Romance 11
pn6jqqrwrr,13 Amethyst Love Box pn6jqqrwrr Seasonal Product 13
pn6jqqrwrr,23 Amethyst Love Box pn6jqqrwrr Mothers Day 23
pn6jqqrwrr,24 Amethyst Love Box pn6jqqrwrr Morsdag 24
pn6jqqrwrr,37 Amethyst Love Box pn6jqqrwrr Valentines 37
pn6jqqrwrr,40 Amethyst Love Box pn6jqqrwrr Romanse 40
pn6jqqrwrr,56 Amethyst Love Box pn6jqqrwrr Purple 56
pn6jqqrwrr,67 Amethyst Love Box pn6jqqrwrr Valentines Day 67
pn6jqqrwrr,100 Amethyst Love Box pn6jqqrwrr Flowers in a box 100
pn6jqqrwrr,101 Amethyst Love Box pn6jqqrwrr Lilla 101

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