product_external_ids

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

5 rows where product_id = "PRD_1E71J6MVJNFG"

✎ 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_2ZD4MV47NEE0 Volume 1 PRD_1E71J6MVJNFG content 1 71fb1274-04d8-4efd-9ca5-8e02c0fd7380  
PID_0WD5JWAA9WW0 Volume 1 PRD_1E71J6MVJNFG product 3 9798855423617  
PID_10HGED363S30 Volume 1 PRD_1E71J6MVJNFG product 7 9798855423617  
PID_26CW13X0JYJG Volume 1 PRD_1E71J6MVJNFG product 2 bwg_migration.3095975  
PID_3AKEWMQW4TSG Volume 1 PRD_1E71J6MVJNFG product 4 85542361C00003066514  

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