product_categories

Many-to-many link between products and categories

10 rows where product_id = "lgqpp0lvui"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id category_id
lgqpp0lvui,9 Ida Amore lgqpp0lvui Homepage Specials 9
lgqpp0lvui,16 Ida Amore lgqpp0lvui Summer 16
lgqpp0lvui,29 Ida Amore lgqpp0lvui Sommer 29
lgqpp0lvui,42 Ida Amore lgqpp0lvui Orange 42
lgqpp0lvui,53 Ida Amore lgqpp0lvui Spring 53
lgqpp0lvui,77 Ida Amore lgqpp0lvui Homepage No 77
lgqpp0lvui,79 Ida Amore lgqpp0lvui Oransj 79
lgqpp0lvui,83 Ida Amore lgqpp0lvui Var 83
lgqpp0lvui,94 Ida Amore lgqpp0lvui Rosa 94
lgqpp0lvui,99 Ida Amore lgqpp0lvui Pink 99

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