product_external_ids

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

6 rows where product_id = "PRD_3ZM3HK9Z8WEG"

✎ 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_0V3YG9GNX720 Chapter 2 PRD_3ZM3HK9Z8WEG content 1 d2b0f561-2f74-49de-8b6c-3c06f8c60fcb  
PID_19S94G8FFYTG Chapter 2 PRD_3ZM3HK9Z8WEG product 8 6810000014807  
PID_1T6840VB3V8G Chapter 2 PRD_3ZM3HK9Z8WEG product 4 04000000C00002955508  
PID_2KV7V735K0H0 Chapter 2 PRD_3ZM3HK9Z8WEG product 9 6810000014807  
PID_3C06T8E14XF0 Chapter 2 PRD_3ZM3HK9Z8WEG product 2 bwg_migration.2972257  
PID_3G4HHS0JYSJ0 Chapter 2 PRD_3ZM3HK9Z8WEG product 7 6810000014807  

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