product_categories

Many-to-many link between products and categories

12 rows where product_id = "j9qkdfxdgl"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id category_id
j9qkdfxdgl,10 White Phalaenopsis j9qkdfxdgl Baby 10
j9qkdfxdgl,18 White Phalaenopsis j9qkdfxdgl White 18
j9qkdfxdgl,23 White Phalaenopsis j9qkdfxdgl Mothers Day 23
j9qkdfxdgl,27 White Phalaenopsis j9qkdfxdgl Planter 27
j9qkdfxdgl,35 White Phalaenopsis j9qkdfxdgl Bestselger 35
j9qkdfxdgl,36 White Phalaenopsis j9qkdfxdgl Plants 36
j9qkdfxdgl,53 White Phalaenopsis j9qkdfxdgl Spring 53
j9qkdfxdgl,69 White Phalaenopsis j9qkdfxdgl Orkideer 69
j9qkdfxdgl,74 White Phalaenopsis j9qkdfxdgl Best Sellers 74
j9qkdfxdgl,81 White Phalaenopsis j9qkdfxdgl Orchids 81
j9qkdfxdgl,93 White Phalaenopsis j9qkdfxdgl Hvit 93
j9qkdfxdgl,96 White Phalaenopsis j9qkdfxdgl Corporate Solutions 96

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