product_external_ids

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

5 rows where product_id = "PRD_01A0Z49BECVG"

✎ 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_3ZWPZD9KGAEG I Want to Eat Your Pancreas PRD_01A0Z49BECVG content 1 56e41f04-5c6c-4ea7-b86b-f264e809fe7b  
PID_1RY01VMQWRXG I Want to Eat Your Pancreas PRD_01A0Z49BECVG product 3 9798893731095  
PID_2D2JXDD3PN0G I Want to Eat Your Pancreas PRD_01A0Z49BECVG product 7 9798893731095  
PID_32SYM3FC1TG0 I Want to Eat Your Pancreas PRD_01A0Z49BECVG product 2 bwg_migration.2142982  
PID_3PW9KM1SVQ70 I Want to Eat Your Pancreas PRD_01A0Z49BECVG product 4 89373109C00002223296  

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