product_external_ids

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

5 rows where product_id = "PRD_138Z1AY1EWWG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, external_id

id ▼ product_id source type external_id external_id_original
CID_3DQQT78DKPM0 Volume 10 PRD_138Z1AY1EWWG content 1 2d0bc30c-c687-41d3-b448-6f8fb42b7890  
PID_0KQGF8K0Q0B0 Volume 10 PRD_138Z1AY1EWWG product 2 bwg_migration.3004665  
PID_17T3AT5WEWY0 Volume 10 PRD_138Z1AY1EWWG product 4 89863319C00002985118  
PID_39NSS1RAKYMG Volume 10 PRD_138Z1AY1EWWG product 3 9798898633196  
PID_3XR4MJH65TVG Volume 10 PRD_138Z1AY1EWWG product 7 9798898633196  

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