product_external_ids

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

5 rows where product_id = "PRD_3KM7HRHDWQDG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source

id ▼ product_id source type external_id external_id_original
CID_2KXVPVTVQX6G Volume 06 PRD_3KM7HRHDWQDG content 1 4dc8c4a0-0ba4-4ceb-9153-d75717600b92  
PID_057QCN2VJ7WG Volume 06 PRD_3KM7HRHDWQDG product 4 64609812C00002810711  
PID_2F1E2WNHQ9K0 Volume 06 PRD_3KM7HRHDWQDG product 3 9781646093441  
PID_2K5RYEED9260 Volume 06 PRD_3KM7HRHDWQDG product 7 9781646098125  
PID_3H34H48FRB9G Volume 06 PRD_3KM7HRHDWQDG product 2 bwg_migration.2808833  

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