product_categories

Many-to-many link between products and categories

13 rows where product_id = "jgw9qhsc3x"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id category_id
jgw9qhsc3x,2 Juicy and Joy jgw9qhsc3x Christmas 2
jgw9qhsc3x,9 Juicy and Joy jgw9qhsc3x Homepage Specials 9
jgw9qhsc3x,16 Juicy and Joy jgw9qhsc3x Summer 16
jgw9qhsc3x,37 Juicy and Joy jgw9qhsc3x Valentines 37
jgw9qhsc3x,39 Juicy and Joy jgw9qhsc3x Red 39
jgw9qhsc3x,42 Juicy and Joy jgw9qhsc3x Orange 42
jgw9qhsc3x,51 Juicy and Joy jgw9qhsc3x Bouquets 51
jgw9qhsc3x,67 Juicy and Joy jgw9qhsc3x Valentines Day 67
jgw9qhsc3x,74 Juicy and Joy jgw9qhsc3x Best Sellers 74
jgw9qhsc3x,77 Juicy and Joy jgw9qhsc3x Homepage No 77
jgw9qhsc3x,95 Juicy and Joy jgw9qhsc3x Multicolor 95
jgw9qhsc3x,97 Juicy and Joy jgw9qhsc3x Anniversary 97
jgw9qhsc3x,98 Juicy and Joy jgw9qhsc3x Autumn 98

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