product_external_ids

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

6 rows where product_id = "PRD_1M6ZXD9582RG"

✎ 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_3FDE8BHYBMTG Chapter 5 PRD_1M6ZXD9582RG content 1 dd7cee95-e93f-4019-98ec-9f18c6667733  
PID_1BM340GSF3MG Chapter 5 PRD_1M6ZXD9582RG product 4 04000000C00003167457  
PID_1MHXKDEP7600 Chapter 5 PRD_1M6ZXD9582RG product 8 6810000018949  
PID_2XQST8BQG5B0 Chapter 5 PRD_1M6ZXD9582RG product 2 bwg_migration.3215336  
PID_31T4HSW3A1Y0 Chapter 5 PRD_1M6ZXD9582RG product 7 6810000018949  
PID_3YKM1M1C886G Chapter 5 PRD_1M6ZXD9582RG product 9 6810000018949  

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