product_external_ids

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

5 rows where product_id = "PRD_1Z2B17GRYMSG"

✎ 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_0XS67068JMM0 Volume 18 PRD_1Z2B17GRYMSG content 1 c2b88a34-16a6-4c67-bde0-4ad4af52c14e  
PID_0BGSCD9DTQVG Volume 18 PRD_1Z2B17GRYMSG product 7 9781646593712  
PID_19E573BE5XB0 Volume 18 PRD_1Z2B17GRYMSG product 2 bwg_migration.908112  
PID_1XJG2MXVZSY0 Volume 18 PRD_1Z2B17GRYMSG product 4 04000000C00001152120  
PID_37CEGVGG0VMG Volume 18 PRD_1Z2B17GRYMSG product 3 9781646593712  

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