product_external_ids

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

5 rows where product_id = "PRD_0TGMHVK5ZXH0"

✎ 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_223XW5AM2FS0 The Royal Baby Revelation PRD_0TGMHVK5ZXH0 content 1 8854fe42-f5ab-41d2-a828-eb25412d97c1  
PID_07VXHGRQ2X4G The Royal Baby Revelation PRD_0TGMHVK5ZXH0 product 4 59669058C00002941919  
PID_29NM47KD7YV0 The Royal Baby Revelation PRD_0TGMHVK5ZXH0 product 3 9784596690586  
PID_2XR7395YSVE0 The Royal Baby Revelation PRD_0TGMHVK5ZXH0 product 7 9784596690586  
PID_3KQJTF7VB0HG The Royal Baby Revelation PRD_0TGMHVK5ZXH0 product 2 bwg_migration.2962271  

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