product_categories

Many-to-many link between products and categories

6 rows where product_id = "nl5i2hg1tx"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id category_id
nl5i2hg1tx,23 Amorcito decoration nl5i2hg1tx Mothers Day 23
nl5i2hg1tx,30 Amorcito decoration nl5i2hg1tx Floral Arrangements 30
nl5i2hg1tx,74 Amorcito decoration nl5i2hg1tx Best Sellers 74
nl5i2hg1tx,82 Amorcito decoration nl5i2hg1tx Decoration 82
nl5i2hg1tx,99 Amorcito decoration nl5i2hg1tx Pink 99
nl5i2hg1tx,100 Amorcito decoration nl5i2hg1tx 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)
);