product_external_ids

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

5 rows where product_id = "PRD_2NCX04SX1F60"

✎ 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_10RECNK3JB5G Tug of Love PRD_2NCX04SX1F60 content 1 2d378ee8-f11c-4359-bd84-037dac394428  
PID_09AVCY0JNWYG Tug of Love PRD_2NCX04SX1F60 product 4 59668247B24026700000  
PID_1K4J35V8YYN0 Tug of Love PRD_2NCX04SX1F60 product 3 9784596682475  
PID_278WYQC4GTR0 Tug of Love PRD_2NCX04SX1F60 product 7 9784596682475  
PID_3568HDE120BG Tug of Love PRD_2NCX04SX1F60 product 2 bwg_migration.363090  

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