product_external_ids

Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)

5 rows where product_id = "PRD_29RY7N67SQAG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source

id ▼ product_id source type external_id external_id_original
CID_2Q09R65VJZC0 Volume 7 PRD_29RY7N67SQAG content 1 c5ba3ee5-5691-4d77-b5f6-72feadc67f91  
PID_0W5EC3B1D02G Volume 7 PRD_29RY7N67SQAG product 2 bwg_migration.194447  
PID_109SBMXX4W9G Volume 7 PRD_29RY7N67SQAG product 7 9781613131466  
PID_3ABQSVGB9YC0 Volume 7 PRD_29RY7N67SQAG product 4 04000000B15499700000  
PID_3YE2ND973TK0 Volume 7 PRD_29RY7N67SQAG product 6 Mag Garden  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE product_external_ids (
      id TEXT PRIMARY KEY,
      product_id TEXT NOT NULL,
      source TEXT NOT NULL,
      type INTEGER NOT NULL,
      external_id TEXT NOT NULL,
      external_id_original TEXT NOT NULL,
      FOREIGN KEY (product_id) REFERENCES products(id)
    );
CREATE INDEX idx_product_external_ids_product ON product_external_ids(product_id);