home / shop

product_categories

Many-to-many link between products and categories

15 rows where product_id = "ee2py0lb3a"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id category_id
ee2py0lb3a,6 Rosy Beauty ee2py0lb3a Blomster i en boks 6
ee2py0lb3a,9 Rosy Beauty ee2py0lb3a Homepage Specials 9
ee2py0lb3a,11 Rosy Beauty ee2py0lb3a Romance 11
ee2py0lb3a,13 Rosy Beauty ee2py0lb3a Seasonal Product 13
ee2py0lb3a,23 Rosy Beauty ee2py0lb3a Mothers Day 23
ee2py0lb3a,24 Rosy Beauty ee2py0lb3a Morsdag 24
ee2py0lb3a,37 Rosy Beauty ee2py0lb3a Valentines 37
ee2py0lb3a,40 Rosy Beauty ee2py0lb3a Romanse 40
ee2py0lb3a,42 Rosy Beauty ee2py0lb3a Orange 42
ee2py0lb3a,67 Rosy Beauty ee2py0lb3a Valentines Day 67
ee2py0lb3a,77 Rosy Beauty ee2py0lb3a Homepage No 77
ee2py0lb3a,79 Rosy Beauty ee2py0lb3a Oransj 79
ee2py0lb3a,94 Rosy Beauty ee2py0lb3a Rosa 94
ee2py0lb3a,99 Rosy Beauty ee2py0lb3a Pink 99
ee2py0lb3a,100 Rosy Beauty ee2py0lb3a Flowers in a box 100

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)
);
Powered by Datasette · Queries took 6.278ms