product_external_ids

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

5 rows where product_id = "PRD_1NBDWZT7P280"

✎ 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_07G0K45G4B30 Volume 6 PRD_1NBDWZT7P280 content 1 9c30d3b6-0f50-4aae-a73a-b3717c2f2faa  
PID_1VBRPNFVFCZ0 Volume 6 PRD_1NBDWZT7P280 product 3 9781718340619  
PID_2FEBJ60Q1920 Volume 6 PRD_1NBDWZT7P280 product 7 9781718340619  
PID_3D5Q4W2HGENG Volume 6 PRD_1NBDWZT7P280 product 2 bwg_migration.3154447  
PID_3H820DVDAARG Volume 6 PRD_1NBDWZT7P280 product 4 71834061C00003115245  

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