product_external_ids

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

5 rows where product_id = "PRD_1P8HZ3GFGQB0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source

id ▼ product_id source type external_id external_id_original
CID_29T143HDX23G Chapter 2 PRD_1P8HZ3GFGQB0 content 1 cfa83b20-b941-4b53-bfe7-cd245d85f267  
PID_0E66DW6K3JEG Chapter 2 PRD_1P8HZ3GFGQB0 product 2 bwg_migration.1073231  
PID_0JAH9DZCNENG Chapter 2 PRD_1P8HZ3GFGQB0 product 7 TID01029_EN_C1_002  
PID_244FZMKTYG80 Chapter 2 PRD_1P8HZ3GFGQB0 product 4 04000000C00001300476  
PID_388TV64PGCZ0 Chapter 2 PRD_1P8HZ3GFGQB0 product 6 TID01029  

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