product_external_ids

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

5 rows where product_id = "PRD_21X9R46EWBBG"

✎ 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_1NPS1XVBBMH0 The Theater of Haruhi Suzumiya PRD_21X9R46EWBBG content 1 bf5cd9d2-0a65-4b0b-9a59-7d780ac4cbfe  
PID_0EHXTJTVM860 The Theater of Haruhi Suzumiya PRD_21X9R46EWBBG product 7 9798855416886  
PID_1CF9D8V47H9G The Theater of Haruhi Suzumiya PRD_21X9R46EWBBG product 2 bwg_migration.2366975  
PID_1GKM8TDHSDWG The Theater of Haruhi Suzumiya PRD_21X9R46EWBBG product 4 85541688C00002419632  
PID_3TDJZ10E2FK0 The Theater of Haruhi Suzumiya PRD_21X9R46EWBBG product 3 9798855416886  

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