product_categories

Many-to-many link between products and categories

10 rows where product_id = "47megzw6ty"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id category_id
47megzw6ty,9 Lover`s heart 47megzw6ty Homepage Specials 9
47megzw6ty,19 Lover`s heart 47megzw6ty Buketter 19
47megzw6ty,23 Lover`s heart 47megzw6ty Mothers Day 23
47megzw6ty,24 Lover`s heart 47megzw6ty Morsdag 24
47megzw6ty,37 Lover`s heart 47megzw6ty Valentines 37
47megzw6ty,51 Lover`s heart 47megzw6ty Bouquets 51
47megzw6ty,67 Lover`s heart 47megzw6ty Valentines Day 67
47megzw6ty,77 Lover`s heart 47megzw6ty Homepage No 77
47megzw6ty,92 Lover`s heart 47megzw6ty Flerfarget 92
47megzw6ty,95 Lover`s heart 47megzw6ty Multicolor 95

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