product_external_ids

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

5 rows where product_id = "PRD_0FN215GYDBE0"

✎ 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_04NQA9FQQGXG Volume 4 PRD_0FN215GYDBE0 content 1 7e601e12-bc59-45b7-9f5b-d1f790a003c7  
PID_0W2JZW4X214G Volume 4 PRD_0FN215GYDBE0 product 2 bwg_migration.362073  
PID_106XVDXENXBG Volume 4 PRD_0FN215GYDBE0 product 4 34550131B23979000000  
PID_3A0M9MG4YZE0 Volume 4 PRD_0FN215GYDBE0 product 3 9781612627113  
PID_3Y7756AGGVN0 Volume 4 PRD_0FN215GYDBE0 product 7 9781612627113  

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