product_categories

Many-to-many link between products and categories

7 rows where product_id = "ygww7yq8dh"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id category_id
ygww7yq8dh,11 Violet regalia ygww7yq8dh Romance 11
ygww7yq8dh,16 Violet regalia ygww7yq8dh Summer 16
ygww7yq8dh,19 Violet regalia ygww7yq8dh Buketter 19
ygww7yq8dh,29 Violet regalia ygww7yq8dh Sommer 29
ygww7yq8dh,51 Violet regalia ygww7yq8dh Bouquets 51
ygww7yq8dh,56 Violet regalia ygww7yq8dh Purple 56
ygww7yq8dh,101 Violet regalia ygww7yq8dh 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)
);