product_external_ids

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

5 rows where product_id = "PRD_0XSDK3G9VGGG"

✎ 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_052ZKWM489P0 Volume 1 PRD_0XSDK3G9VGGG content 1 890af431-0cba-437d-8803-6a41f2b2d749  
PID_0VT7X6J6C4X0 Volume 1 PRD_0XSDK3G9VGGG product 2 bwg_migration.1814184  
PID_1FYJR84J6100 Volume 1 PRD_0XSDK3G9VGGG product 4 97539153C00001937725  
PID_2HR9EZZ8B36G Volume 1 PRD_0XSDK3G9VGGG product 3 9781975391539  
PID_35WMA0G42ZDG Volume 1 PRD_0XSDK3G9VGGG product 7 9781975391539  

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