product_external_ids

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

5 rows where product_id = "PRD_381VA6F8Q1ZG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source

id ▼ product_id source type external_id external_id_original
CID_1SGMP2Q9ABJG Volume 3 PRD_381VA6F8Q1ZG content 1 860defe9-8520-4000-a135-f341d481a5f2  
PID_1BQS2MVYZTMG Volume 3 PRD_381VA6F8Q1ZG product 3 9798888776650  
PID_1ZTBY6CAHPVG Volume 3 PRD_381VA6F8Q1ZG product 7 9798894788807  
PID_2XHQGWEQ0WB0 Volume 3 PRD_381VA6F8Q1ZG product 2 bwg_migration.3158920  
PID_31M2CD70TRY0 Volume 3 PRD_381VA6F8Q1ZG product 4 88877665C00003118432  

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