product_external_ids

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

5 rows where product_id = "PRD_06GJMDXP7BV0"

✎ 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_145D836Q6YWG Volume 2 PRD_06GJMDXP7BV0 content 1 2d8df010-d72b-4191-8207-cc5f9e302b5e  
PID_0Q6M5PVRMRR0 Volume 2 PRD_06GJMDXP7BV0 product 3 9780316363921  
PID_1V570RCMENF0 Volume 2 PRD_06GJMDXP7BV0 product 7 9780316363921  
PID_2S0JVYEPSTYG Volume 2 PRD_06GJMDXP7BV0 product 2 bwg_migration.354089  
PID_3D4XQF72KQ5G Volume 2 PRD_06GJMDXP7BV0 product 4 31636392B23761800000  

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