product_external_ids

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

5 rows where product_id = "PRD_2ARYN8WBWZT0"

✎ 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_3CR656X8RT1G Volume 3 PRD_2ARYN8WBWZT0 content 1 e691e253-3613-4c12-be0c-5380211c2de7  
PID_0K3H2C7C42Y0 Volume 3 PRD_2ARYN8WBWZT0 product 2 bwg_migration.362113  
PID_1763SXSSZZ50 Volume 3 PRD_2ARYN8WBWZT0 product 4 61262593B23983000000  
PID_391TC5CP30VG Volume 3 PRD_2ARYN8WBWZT0 product 3 9781612629490  
PID_3X45BP53TXEG Volume 3 PRD_2ARYN8WBWZT0 product 7 9781612629490  

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