product_external_ids

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

5 rows where product_id = "PRD_3YDB8G8V900G"

✎ 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_0W4YTWF7ESSG For The Sake Of His Child PRD_3YDB8G8V900G content 1 da8054df-61de-47be-9d80-75a8fbf1d24e  
PID_08FV6F5TTMAG For The Sake Of His Child PRD_3YDB8G8V900G product 4 59606883C00002944409  
PID_1J9HMPRGZP10 For The Sake Of His Child PRD_3YDB8G8V900G product 3 9784596068835  
PID_26DWG7HCHJM0 For The Sake Of His Child PRD_3YDB8G8V900G product 7 9784596068835  
PID_34B8AXK90R7G For The Sake Of His Child PRD_3YDB8G8V900G product 2 bwg_migration.2960816  

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